Senior Data Analyst - Data Analytics & BI

VISHAL SHARMA Email: **********@*****.***

Senior Data Analyst Mobile: +91-900*******

Professional Summary

Overall, 11 Yrs experience & 7.5 Years experience in Result oriented and Passionate Data Analytics & Project management Professional, Excellent problem solver with a plethora of required skill sets and highly believes in customer satisfaction.

Skillful in eliciting Business requirements, project management & implementation, performing data analysis and data preparation, communicating results to the stakeholders. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Technical Skills

Data Analytics & BI Advance Excel, Power BI, Power Query, DAX, Google Looker Studio, Tableau, Microsoft Fabric Programming Python (Numpy, Pandas, Matplotlib & Seaborn), SQL Databases MySQL, Snowflake, MS Access

Data warehouse Big Query

Other Tools &

Methods A/B Testing, Sentiment Analysis, Agile, Asana, Slack, Scrum, GitHub, Google Analytics Professional Experience

Senior Data Analyst

ARMMAN, December 2023 – Present, Delhi

● Analyze complex datasets to identify trends, correlations, and actionable insights to guide business decisions.

● Collaborate with key stakeholders to understand strategic objectives and develop data-driven solutions.

● Design and develop advanced dashboards and reports using tools like Power BI, Tableau or Looker to effectively communicate findings.

● Present insights and recommendations to executive teams and cross-functional stakeholders.

● Plan for data migration from previous systems, focusing on data accuracy and consistency.

● Develop predictive and statistical data models using Python to forecast business performance.

● Write complex queries in SQL to fetch data from the database.

● Utilize machine learning algorithms to optimize processes and predict customer behavior.

● Lead data analysis projects, ensuring on-time delivery and alignment with business goals.

● Mentor junior analysts by providing technical guidance, code reviews, and training on best practices.

● Ensure the accuracy and reliability of datasets by implementing data validation checks and cleaning procedures.

● Maintain data governance policies to ensure compliance with regulatory requirements and company standards.

● Identify inefficiencies in workflows and propose data-driven improvements to enhance operational efficiency.

● Reviewing the PRD (Product Requirement Document) and BRD (Business Requirement Document) for verifying the features, workflows and business goals clearly defined.

● Work closely with directors, program, research and content teams to align analytical initiatives with company objectives.

● Translate technical findings into clear, actionable business recommendation. Senior Data Analyst

iDreamCareer, Aug 2022 – Nov 2023, Delhi

● Design and implement database schemas, including tables, join, view, relationships, and indexes.

● Collect and process data from various digital channels and tools, such as Google Analytics, and custom tracking solutions.

● Develop and maintain complex SQL queries for data extraction and transformation.

● Creating and executing queries utilizing various data sources to provide business information.

● Identify relevant trends, do follow-up analysis, prepare visualizations in the form of charts, graphs, and tables.

● Analyze customer behavior patterns, including purchasing habits, engagement with marketing materials, and customer journey mapping.

● Built out the data and reporting infrastructure from the ground up using Google data studio, Power BI and SQL provide real-time insights into the product, marketing funnels, and business KPIs.

● Align customer analytics and marketing analysis efforts with the overall business objectives and marketing goal.

● Managing Customer Complaint management tools and analyzing the data using Power BI & Tableau to give better support to the customers.

● Recommend personalized content or marketing strategies to improve user engagement and conversion.

● Build predictive models to forecast customer behavior and campaign outcomes.

● Segment website or app users based on various criteria (demographics, behavior, geography, etc.) to better understand different user groups and their needs.

● Retrieve data from various databases and analyze large datasets to extract meaningful insights and trends Use insights to develop strategies for improving customer retention and loyalty. Data Consultant

IPE Global, Aug 2021 – Aug 2022, Delhi

Project: Generate customized Statistical Reports using BI/Data Mining and Analytics tools for WHO to control hypertension in India for IHCI Project.

● Hands on experience in SQL, R & python to analyze the data for insights.

● Monitored the IHCI portal to ensure data quality of patients’ health and drug-related data.

● Implement data validation checks to ensure data accuracy and consistency.

● Experience in Data Exploration, Visualization and Cleaning using several techniques.

● Work with Power bi, Google Data Studio & Tableau to create dashboards and other visual displays to provide clear and insights.

● Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from 10 disparate data sources with the help of SQL.

● Segment app users based on various criteria (demographics, behavior, geography, etc.) to better understand different user groups and their queries.

● Prepare data for analysis by reshaping, aggregating, or merging datasets as needed and analyze time- dependent data for forecasting and trend identification with the help of python libraries.

● Interpreted data and analyzed results using statistical techniques to provide ongoing reports for health, SCM, and training data.

Senior Quality Data Analyst

Bharti Foundation, Aug 2014 – Jul 2021, Gurgaon

● Performed quality process internal audits for programs and departments like HR, Procurement, and MIS.

● Developed and implemented databases, data collection systems, data analytics, and other strategies to optimize statistical efficiency and quality.

● Developed root cause reports in Power BI, to address problems with customer conversions, successfully revealing insights that boosted conversions.

● Acquired data from primary or secondary sources and maintained databases/data systems.

● Conducted data cleaning, identified, analyzed, and interpreted trends or patterns in complex data sets.

● Interpreted data and analyzed results using statistical techniques to provide ongoing reports.

● Created dashboards to display real-time results.

● Performed ETL processes in Power Query for better results.

● Controlled the QC process and made changes in processes as per organizational needs.

● Located and defined new process improvement opportunities.

● Performed valid and reliable SWOT analysis.

Area of Expertise

Areas of Expertise: Project Management & Implementation, Database administration, Data management, Data cleaning, Data Analysis, Descriptive statistical analysis, Inferential statistical analysis, Hypothesis testing, Relational databases Management, Data Visualization, Data warehousing systems, Database Normalization, Data Transformation, Data Mining, Data Collection, Data Modelling. Projects

1. Teacher Attrition Analysis

Description: The objective of this project was to prepare a dashboard based on the teacher attrition & KPI for below given analytics-

• Performance of teacher on the basis of the annual exam.

• Root cause analysis of the attrition by the questionnaire.

• Planning for training program of new teachers.

Methodology: Identified key performance indicators, performed data cleaning, and detected missing values and outliers and applied correlation analysis with different variables. Once we pull all the data from SQL then we start analyzing the data by joining the different tables and using windows function and show all KPI’s through Advance excel, python, Power BI, SQL, Tableau

& ETL.

2. Customer Analysis & Segmentation

Description: The objective of this project was to prepare a dashboard based on the customer segmentation & KPI for below given analytics-

• Performance of repeat & new customers, customer retention and loyalty, marketing strategies.

• Root cause analysis of Growth & De-growth.

• Plan & Tagging Acquisition of new customers.

Methodology: On the basis of uploading data, we are calculating sales value, customer visits, delivering orders, counselor optimization.

Once we pull all the data from SQL then we start analyzing the data by joining the different tables and using windows function and show all KPI’s through Advance excel, python, Power BI, SQL & ETL. 3. Vendor Performance Analysis

Description: The objective of this project was to analyzed the vendor performance based on different KPIs

Methodology: On the basis of uploading data, I am calculating the Sell through, Vendor Compliance rate, Capacity, On Time Delivery brand wise, Department wise and Article wise etc. Once we pull all the data from SQL then we start analyzing the data by joining the different tables and using windows function and show all KPI’s through Advance excel, python, Power BI, SQL & ETL. Academics

Examination Stream University/Institute Year %

PGDBA Operations Symbiosis Centre for Distance Learning, Pune 2018 61.6 Master of Science Statistics Aligarh Muslim University, Aligarh 2012 68.7 Bachelor of Science Computer Science Dr. Bhim Rao Ambedkar University, Agra 2009 67.9 Certifications and Trainings

● Advance excel – Udemy

● SQL certification – Hackerrank and Udemy

● Data Visualization – Great Learning and LinkedIn Learning

● Python for Data Science – One Fourth Labs and Udemy

● Six Sigma Green Belt – Six sigma academy, Udemy

● Data Analysis Workshop in SPSS & R Software - Aligarh Muslim University, Aligarh

● Training on “7 QC Tools” Implementation - TQM International Pvt. Ltd.

● Training on “5S” Implementation - TQM International Pvt. Ltd.

Contact this candidate