Sagar Pithadia

 Sagar Pithadia’s Profile Objectives Sagar Pithadia -: - Personal Information Nationality: Indian Linguistics: English, Hindi, Marathi, Gujarati Aspiring for a challenging position in your esteemed organization, where my skills and abilities will greatly enhance the company & my own personal growth. Work Summary Mazars India LLP: Nov 2019 to Dec 2020 Accenture India: Nov 2018 to Nov 2019 L&T Financial Services: Feb 2017 to July 2018 Starcom MediaVest Group: June 2015 to Feb 2017 SBI Life Insurance: June 2014 to June 2015 Personal Profile Date of Birth: 04th June,1991 Gender: Male Tools: QlikView, Qlik Sense, Qlik Sense Mashup, Tableau, Power BI, Jupyter Notebook Programming Language: JavaScript, Python(learning), HTML, CSS Address: B4, Jalaram Jyot CHS, Vallabh baug lane, opp. Bank of Baroda, Ghatkopar East, Mumbai 400077 Result-oriented individual with 6.5 Plus years of Experience in Business Intelligence and Data Analytics field. A resourceful, solution-focused professional with excellent interpersonal and rapport-building skills. Self-motivated professional who achieves results and has superior ability to coordinate and perform several assignments simultaneously. I Have 6.5+ years of experience in EDA, Designing Report and Dashboard designing using Data Discovery Platforms like QlikView, QlikSense, Tableau and Power BI. Key Skills & Experience – Areas of Specialization Understanding Business Problem and providing meaningful insight using QlikView, Qlik Sense, Tableau and Python concepts to solve business Problems and successful implementations of solutions. Possess expertise in Exploratory Data Analysis, Data Visualization using any leading BI Tools. I have successfully implemented Sentiment Analysis project using NLP methods in Python. Knowledge in visualizing the data using QlikView, Qlik Sense, Tableau and Power BI. Knowledge of end to end implementation of BI Reporting Projects. Possess expertise in Database as well as Data warehousing concepts, skilled at progressing from problem statement to well documented design. Strong ETL Knowledge of Data Integration, Master Data Management, Data Profiling and Data quality processes. Excellent knowledge and experience in Data Warehouse Development life cycle, Dimensional Modelling, Repository Management and Administration, Implementation of STAR, Snowflake Schemas and Slowly Changing Dimensions.  Sagar Pithadia’s Profile Experience in Client Facing environment, understanding business requirements, and implementing the critical reports for business users. Educational Qualifications Qualification Year of Passing MCA B.Sc.(C.S.) H.S.C. S.S.C. 2014 2011 2008 2006 NMIMS Mumbai Maharashtra Maharashtra University University Board Board S.V.I.S. Lala International Smt. College MPSTME Lajpat Rai school and J.B.Khot College junior high school college Marks/Grades 74.5% 62.75% 59% 66.53% University Organizational Experience Mazars India LLP: Nov 2019 – Dec 2020 as Senior Consultant ➢ Sentiment Analysis is being done on internal data using Python. I have pulled data from External sources like Glassdoor using web scrapping method in Python. To Perform Sentiment Analysis, we have used hybrid model approach, we are using StanFord Core NLP and Text Blob for finding polarity of statement. Once classification is done through model, using Power BI tool visualizing the insights. o Doing Customer interaction and understanding the requirement. o Getting the requirements from client and distributing the task among the team members. o Made exploratory data analysis and cleansed the data. o Part of Advance analytics team for implementation of the Sentiment Analysis model using Python. ➢ Sales Analysis Dashboard (Retail) in Qlik Sense for retail company to generate insight. Initially company was using Excel tool to perform EDA and generating insights. With the help of Power BI tool and dashboard which is created houses comprehensive information regarding Business and Key KPI’s. Dashboard saves lot of time in preparation of data and generating insights. o Doing Customer interaction and understanding the requirement. o Getting the requirements from client and distributing the task among the team members. o Done exploratory analysis and took inferences by visualization the data. o Improvised the quality of data by removing inconsistent data, missing values and label the data using feature scaling. o Explored the data using different visualization techniques.  Sagar Pithadia’s Profile o Presented Business Insights to Client using dashboard developed in Qlik Sense. ➢ Data Analyst for a Banking Client: Working with client on Categorization of transaction. Transactions can be done for food or emi or it can be for investment. As a data analyst my role is to increase the accuracy of correct categorization of transaction. Working with vendor team to improve the categorization and making necessary changes in the detectors. ➢ Recruitment Fit Dashboard in Power BI: Client desires to leverage Artificial Intelligence to make hiring process more efficient & simpler. Recruitment Fit matches right candidates for the right job, gives insight into the hiring process & improves quality of hire. I was part of Advanced Analytics team helping them in creating data model for applying advanced analytics method to achieve the goal. I have Used Python to churn data for advanced analytics. Presented Insights in Power BI dashboard. ➢ Worked as a QlikView Consultant, helping client in optimizing the existing structure of dashboard. Things considered while optimization are: 1. Structure of existing data model. 2. Structure of Qlik dashboards. 3. Purpose of the dashboard and key stake holders. Worked on QlikSense Mashup to create custom dashboard for end user with details analysis and outcome / interpretation of the numbers. QlikSense mashup’s were catered to Finance team and sales team to understand their business figures. Delivered the training on QlikSense Mashup. How to create a mashup and how it can be integrated with other sources. Accenture India: Nov 2018 to Nov 2019 Stericycle is a compliance company that specializes in collecting and disposing regulated substances, such as medical waste and sharps, pharmaceuticals, hazardous waste, and providing services for recalled and expired goods. It also provides related education and training services, and patient communication services. o o o Supporting offshore development of QlikView Dashboard and optimizing the existing process or dashboard design. Preparing SQL statement for quality check. Created Complex Mapping and tuned them for better performance. L&T Financial Services: Feb 2017 to Jul 2018 ➢ Business MIS for HF, MFI, developed automated reports for Business Team in QlikView. That has helped team in saving time in generating report. I have done intital level of requirement Gathering. Analysing the data, performing ETL. Data modelling to develop report. report help understand the daily business growth against target set by business heads. ➢ Sales MIS for FARM and Two-Wheeler Product. Report helps understand the daily business of FARM and Two-Wheeler Products. It helps in tracking daily progress of business with respect to target. Requirement Gathering. Analyzing the data, performing ETL. Data modelling to develop report. report  Sagar Pithadia’s Profile help understand the daily business growth against target set by business heads. • Tool used: QlikView, MSSQL. ➢ Insurance Penetration Report for HF, FARM, TW. Requirement Gathering. Analysing the data, performing ETL. Data modelling to develop report. report helps understand the sale of insurance provided against the loan disbursed. ➢ Supporting offshore development team and helping them conceptualize the business processes. ➢ Created Complex Mapping and tuned them for better performance. ➢ Extensive Data modelling experience using Dimensional Data modelling, Star Schema modelling, Snowflake modelling, and FACT and Dimensions tables. ➢ Defect Management and Bug Fixing. Starcom MediaVest Group: Jun 2015 to Feb 2017 ➢ KPI Monitoring Dashboard for Retail Client: Developed a dashboard in Tableau for a client to monitor KPI which were part of contract between client and Starcom MediaVest Group. In Tableau dashboard we were monitoring what is the GRP delivered on TV or other media platforms for Media Campaign. Client wanted to track the performance of Starcom MediaVest Group’s in terms of Media Buying and creating ad campaigns for a client. o Source data directly from Operational Sources. o Apply Transformation rules consistently across sources. o Load data with a latency of T-1 Day from source. o Act as one source for Enterprise reporting and analysis purpose. ➢ Competitive Dashboard for Retail Client: Developed a dashboard in Tableau for a client to Competitions spend in Media platform as compare to Clients. We were showing TV, Print and Radio Media’s spend across different product category and hierarchy. ➢ Actively involved in Advanced Analytics project: Creating first level of hypothesis for marketing media mix model using R Programming. Responsible for cleaning and getting the required data to the level of where we can perform logistic regression on given data. Also have delivered Global Competitive report for a electronic manufacturing client, finding insight and presenting it to the client. SBI Life Insurance: Jun 2014 to Jun 2015 ➢ Responsible for maintenance of QlikView Dashboard. ➢ Developed ETL and designed dashboards in QlikView for various stake holder. ➢ Actively involved in Requirement gathering phase, was part of feasibility study of the requirement. ➢ Implemented dashboard reports end to end. Place: Mumbai Date: 08 Jun, 2020  Sagar Pithadia’s Profile