Senior BI -Consultant -Sumit Kumar Thakur
Download as doc, pdf1 like285 views
Sumit Kumar Thakur has over 4 years of experience as a BI Consultant working with QlikView. He has extensive experience in requirements gathering, data modeling, ETL, dashboard development, testing, deployment, and training. Some of his clients include Abbvie TSA, National Institute of Education, Marine Port Authority, and Deloitte USA India. He is proficient in QlikView, SQL Server, Oracle, and N Printing and has expertise in all phases of the SDLC for BI projects.
Senior BI -Consultant -Sumit Kumar Thakur
- 1. RESUME SUMIT KUMAR THAKUR Contact Number--+65 99195204 Career Objective To work in a challenging environment in an organization that provides excellent work culture and paves the way for early assumption of responsibilities. I also want to be an asset for the company I work for. Profile Completed Bachelor of Technology (Computer Science and Engineering) from B.B.S COLLEGE OF ENGINEERING AND TECHNOLOGY PHAPHAMAU,ALLAHABAD,211003 (UPTU) and updated with the latest trends and techniques of the field, having a strong aptitude, determined to carve a successful and satisfying professional career. Focused and hardworking, self motivated and team oriented; with capability to meet high-pressure deadlines. Confident and resourceful with a willingness to learn new concepts and apply them to yield successful results. Over 4 Years and 9 Months of experience in system analysis, design, development, testing and maintenance of application system in various projects (Complete SDLC) executed in QlikView 10,11 and 12 capable of handling responsibilities independently as well as a proactive team member. Have knowledge in building user defined report by using N Printing 15 and 16. Expert in QlikView solution Provider All Technical Support, Project Delivery, Training Etc. Business requirement Gathering/analysis, Defining and documenting business, technical & functional specifications, Business and technical team coordination, Design and E2E implementation and delivery. Expertise in system feasibility study, system redesign/engineering and implementation with significant experience in Data Modeling/Data Quality Analysis/Data Validation Proficient in Installing QlikView and configuration of their tools (Server, Publisher, Connectors (SAP,), etc). Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning. Expert level experience with Business Intelligence Tools.(QlikView) Expert in Data Extraction, Transforming and Loading (ETL) using Script editor in Qlikview. Good Hand on Resolving complex issues and Error Handling in QlikView.
- 2. Good understanding in database and data warehousing concepts. A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills. Excellent communication skills, both oral and written and pleasing interpersonal skills. Technical Skills Programming Languages: Qlikview 10 , Qlikview 11 and Qlikview 12 Operating Systems: MS- Windows XP, Linux. Operating Tools: MS-Office, QlikView10, 11,12, N Printing 15,16 Area of Interest : Data Base Management System. Database: MS Sql Server. Training Skills QlikView10/11 Understand overall architecture of the QlikView, Data Modelling, and Set Analysis. Integration of QlikView with data source mainly SAP, JD Edward, Oracle, Sybase, Tally, SQL Server, MS Access, Excel etc. Writing scripts and configuration of fetching data from various sources. Performance Tuning of the Dashboard. Best practices. QlikView Access Point. QV server and Publisher settings Jayaswal Neco Ltd, Nagpur Wanbury Ltd, Mumbai Suzlon Energy Ltd., Pune Deloitte US India Pvt. Ltd , Mumbai Danik Bhaskar Corp Ltd, Bhopal Abbvie TSA ,Singapore National Institute of Technology ,Singapore Logwin ,Singapore Marine Port Authority ,Singapore Work Experience Company Name 1.Quosphere Info Solution Pvt Ltd., Navi Mumbai (Jan-2012-Sep 2014) Project Name:- 1. Client Jayaswal Neco Ltd, Nagpur Technologies Qlikview v10 Database Sybase, tally, SAP
- 3. Scope Cover all the Qlikview Dashboards/Reporting regarding Sales. Role and Responsibility Role - Junior BI Consultant Responsibility -- 1. Requirement gathering 2. Designing of Front end. 3. Defining and documenting business, technical & functional specifications. 4. Server Installation and Deployment of application. Project Description Client is a Jayaswal Neco Ltd products company. The application developed is being used to track the sales trend of the products, identifying the key action areas, market, products and Partner performance. Also, application helps users to extract their operational reporting as well as analytics to present to higher management for business decisions. Duration 3 Months (Jan 2012- Apr 2012) 2. Client Wanbury Ltd, Mumbai Technologies QlikView v11 Database SQL Server, SAP Scope Cover Sales and Distribution Dashboard/Reporting and HR application. Role and Responsibility Role - BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SQL server, doing data modelling and Developing front end application related to Sales and HR 3. Defining and documenting business, technical & functional specifications. 4. Server Installation and Deployment of application. Project Description Client is a Wanbury Ltd pharmaceutical company. The application developed is being used to track the sales trend of the medical products, identifying on time and late time shipment, products contribution, top sales performance and Yearly and Monthly performance. Also, application helps users to extract their analytics related to better performance by using What if Analysis that helps higher management for business decision. Duration 2 Months(May 2012-Jun 2012) 3. Client Suzlon One Earth, Pune Technologies QlikView v10 Database SQL Server, SAP BI, Excel Scope Cover OMS (Operation Management System)/Inventory/OTC (Order to Cash) Dashboard/Reporting Role and Responsibility Role - BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SAP BI (Cubes and DSO), doing data
- 4. modelling. Developing front end application related to Sales ,Operational Management and Inventory 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard. Project Description Client is a Suzlon One Earth manufacturing company. OTC Application:- The application developed is being used to track the sales trend of the products (Wind mills), identifying on time and late time shipment of windmills and payments from customer, account manager contribution, top sales performance and indentifying root cause of late payments based on payments method. Inventory Application:- The application developed is being used to track the ageing of the raw materials which are used in manufacturing Wind mills ,Stock balancer of raw material, identifying shortage of raw material for manufacturing and as well as funds requirement by using What if analysis. OMS Application:- The application developed is being used to track number of windmills installed ,their power generation(in MW) by region and month and identify reason for low power generation of windmills. Duration 1 Year 5 Months(July 2012- Jan 2014) 4. Client Deloitte USA India Pvt. Ltd Technologies QlikView v11 Database SQL Server, Excel Scope Cover Audit, PIOO Reports for Converge Healthcare Product. Role and Responsibility Role - Senior BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SQL Server , doing data modelling. Developing front end application related to Audit and PIOO application 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard.
- 5. Project Description Client is a Deloitte USA India Pvt. Ltd health care company. Audit Application:- The application developed is being used to track the difference between master file and Transaction file. PIOO Application:- The application developed is being used to track the Total Expenses and Labour Expenses by Year ,Facility name, Functional Area and Department. We also track different department performance based on their surgery metrics Duration 5 Months (Feb 2014 to June 2014) 5. Client Dainik Bhaskar Corp Ltd. Technologies Qlikview v11 Database SAP RW, Excel Scope Material Management and Production Planning Module Role and Responsibility Role - Senior BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SAP RW , doing data modelling. Developing front end application related to Material Management and Production Planning 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard. Project Description Client is a Dainik Bhaskar Corp Ltd. news paper company. Production Planning Application:- The application developed is being used to track the count of print order and average print pages on daily basis. This application also show the consumption analysis of raw materials , mainly concentrate on percentage of different type of waste material (Wrapper, Scrap, Layer, Reel End and Print waste) on daily basis which comes while printing newspaper. Material Management Application:- The application developed is being used to track the Inventory, Consumption and Purchase Values for printing newspaper. In this application we also track the material wise Loan given and Loan taken between different plants and also providing user with Stock on Date analysis and Material ageing to track the usage of materials. Duration 3 Months (Jul 2014 to Sep 2014)
- 6. 2.ICON Resources & Technology PTE LTD ,Singapore (Oct-2014-Present) Project Name:- 1. Client Abbvie TSA ,Singapore Technologies Qlikview v11 Database Oracle 11G , Excel and CSV Scope Cover all the Sales and Distribution Qlikview Dashboards/Reporting. Role and Responsibility Role - BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SAP RW , doing data modelling. Developing front end application related to Sales and Distribution. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard. Project Description Client is a Abbvie , pharmaceutical company. Distributor Sales information allowing you to analyse Sales Invoices, Sales rep & Product Target, Plan, ADS and Sales Returns by Product, division, customer, sales organisation plus many others. Business questions answered include: Who is my best customer from a sales perspective and which product do they buy? How Sales Rep are performing low or high / on time? Which Materials and divisions generate the highest margin? How is the sales compared to last year and how does it trend over time? Plus the ability to drill down to individual sales invoice and invoice document line item detail. Duration 3 Months (Oct 2014- Jan 2015) 2. Client NIE- National Institute of Education ,Singapore Technologies Qlikview v11 Database Oracle 11G Scope Cover Statistical Reporting in Qlikview Dashboard Role and Role - BI Consultant
- 7. Responsibility Responsibility -- 1. Requirement gathering 2. Extracting data from SAP RW , doing data modelling. Developing front end application related to Sales and Distribution. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard. Project Description Client is a National Institute of Education , Educational domain. Statistical reporting allowing you to analyse (ITP reports and Higher Degree reports) Count of Enrolled /Count of Intake / Count of Graduate Student based on Program Category Level , Mode of Study , Year of Study etc . Business questions answered include: Count of Enrolled student by Program Category , Scholarship ,Age, Citizenship , Nationality and Race. Count of Intake student by Program Category , Scholarship ,Age , Citizenship , Nationality and Race. Count of Graduate student by Program Category , Scholarship , Age, Citizenship , Nationality and Race. Duration 3 Months (Jan 2015- Mar 2015) 3. Client Marine Port Authority ,Singapore Technologies Qlikview v11 Database SAP RW and Excel Scope Account Payable Module Role and Responsibility Role - BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from SAP RW , doing data modelling. Developing front end application related to Sales and Distribution. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. 5. Server Installation and Deployment of application. 6. User training related to Qlikview functionality and walkthrough of dashboard.
- 8. Project Description Client is a Marine Port Authority, Marine industry. The application developed is being used to track the top vendor analysis , Expenditure analysis and Amount payable ageing analysis. Duration 3 Months (Jan 2015- Mar 2015) 4. Client Renewable Energy Cooperation ,Singapore Technologies Qlikview v9 Database CSV and Excel Scope VIPS and Inventory Role and Responsibility Role Senior BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from CSV , doing data Modelling. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. Project Description Client is a Renewable Energy Cooperation, Solar Energy industry. The purpose of this project is to replicate the old application (using IFS data i.e. Oracle data ) into new application (using CSV file) Replicate the Raw extractor in the manner so that there is no need to change data model and application. Implemented the incremental load. Duration 3 Months (Mar 2015- May 2015) 5. Client Ministry of Home Affairs ,Singapore Technologies Qlikview v11 Database Oracle 11G and Excel Scope Corporate Office Analytics Dashboard Role and Responsibility Role Senior BI Consultant Responsibility -- 1. Requirement gathering 2. Extracting data from Oracle , doing data Modelling. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Security for accessing dashboard. Project Description Client is a Ministry of Home Affairs, Procurement industry. To reduce the data preparation time needed to combine multiple sources of data for analysis, and improve visibility by allowing MHA users to analyse massive amounts of data from various dimensions and scenarios. To facilitate audit, enhance procurement planning and practices, and
- 9. strengthen finance governance and processes. To facilitate the sharing of best practices within the audit, finance, administration and procurement community in MHA through a common platform for analytical applications. Duration 7 Months (Jun 2015- Jan 2016) 6. Client Adidas, Singapore Technologies Qlikview v11 and N Printing 16 Database Oracle 11G and Excel Scope Corporate N Printing Project Role and Responsibility Role Senior BI Consultant Responsibility -- 1. Requirement gathering 2. Understanding the application and Data model to Incorporate the N Printing requirement. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Project Description Client is a Adidas, Inventory industry. To build the user specific report using N Printing tool. Distribute the reports to users. .Applying security and scheduling NSQ file so that email can be send the user automatically. Duration 1 Months (Jan 2016- Feb 2016) 7. Client HCL, Singapore Technologies Qlikview v11 and N Printing 16 Database Oracle 11G and Excel Scope Corporate Service Performance Report Role and Responsibility Role Senior BI Consultant Responsibility -- 1. Requirement gathering. Extracting data from Oracle 11G 2. Building the application and Data model to incorporate the N Printing requirement. 3. Defining and documenting business, technical & functional specifications. 4. Performed Testing ,Data validation and implemented Project Description Client is a HCL, Telecom industry. To build the user specific report using N Printing tool by developing the report in QlikView. Distribute the reports to users.
- 10. .Applying security and scheduling NSQ file so that email can be send the user automatically. Duration 4 Months (Mar 2016- Jul 2016) Support Activities Handled issue in following companies(Clients) : 1. NSL (Singapore) - Development 2. Logwin Logistic (Singapore) - Development and Qlikview server upgrade to Qlikview 11 SR9 3. DB Schenkar (Singapore) - Development and Qlikview server upgrade to Qlikview 11 SR9 4. MPA (Singapore ) - Qlikview server upgrade to Qlikview 11 SR9 5. PIL (Singapore) - N Printing Client and Server Installation 6. PUB (Singapore) - Qlikview Server 11 SR9 Installation 7. Marshal Cavendish Qlikview Consultancy i.e. Section Access and Qlikview Best practice 8. PAN ASIA - QlikView 11 SR13 installation , Qlikview Best practice ,Section Access and N Printing demo Qlikview Training in following companies(Clients) : 1. Toshiba Singapore - Conducted training of 2 days to 5 IT Persons on how to use Qlikview tool and also Qlikview developer. 2. NSL Singapore - Conducted training of 1 days to 2 IT Persons on Qlikview Security implementation. Achievements Best Athlete in school sports. Member of MANAGING COMMITEE in Tech fest of the College. Member of the CORE COMMITTEE of the College. Got the appreciation letter from the client Suzlon One earth, Pune for Inventory and OTC Dashboard. Got the appreciation letter from the client Deloitte USA India for PIWB/PIOO HealthCare product.
- 11. Personal Details Gender Male Date of Birth 7 Jan 1988 Fathers Name Mr. Surendra Thakur Mothers Name Smt. Nirmala Thakur Permanent Address Thakur Colony, Kali Mandir Road BekarBandh, Dhanbad - 826003 Passport Number J9671826