7
Work Completed
3+
Years of Experience
30
Total Projects
Professional Summary
Motivated, highly analytical, Teamwork-oriented, and responsible Data analyst with significant experience in increasing comprehension of reports and visualizations.
Experience in Data visualization and presentation using Tableau, Matplotlib, and Excel.
Expertise in writing SQL queries, Dynamic queries, and complex joins for generating Stored Procedures, Views, and Triggers.
Strong knowledge of Google Analytics, Salesforce reporting, and Proficiency in predictive modeling, data mining methods, factors analysis, and A/B testing.
Experienced in Python to manipulate data for data loading and extraction and worked with Python libraries like Matplotlib, NumPy, and Pandas for data analysis and machine learning.
Skilled in advanced Regression modeling, correlation, Multivariate analysis, and developing predictive models.
Experience in creating quick calculations, static, and dynamic sets, parameters, and levels of details using advanced logical and statistical functions in Tableau Desktop.
Automated recurring reports using SQL and Python and visualized them on BI platforms like Tableau, and Power BI.
Education & Certifications
M.S. in Data Science: New Jersey Institute of Technology, Newark, NJ, Sept 2018 - May 2020
B.E. in Computer Engineering: Savitribai Phule Pune University, Pune, India, Aug 2013 - May 2017
Google Data Analytics Certification
ThoughtSpot Business User Certification
Technical Knowledge
Programming Languages: Python, R, SQL, SAS, HTML, CSS
Big Data and Machine Learning: Spark, NumPy, Pandas, Scikit-learn, Matplotlib.
Databases: MS SQL Server, Oracle, PostgreSQL, MySQL.
Data Science | Data Analysis: A/B testing, Regression, Random Forest, SVM, Clustering, ETL, Data Science Pipeline, Time Series, Experimental design, Hypothesis testing, Statistics, Spreadsheets, Tableau, Excel, ThoughtSpot, Power BI.
Miscellaneous: Django, Rest API, PyCharm, Jupyter Notebook, Spyder, Git, JIRA, Confluence, AWS (e.g., EC2, S3, RDS, Redshift, Athena), Tableau CRM, AWS SageMaker, GCP, Google Analytics, Adobe Analytics, Knime, Presto, Hue, Tableau Prep.
Professional Experience
Data Analyst/BI Developer
2022 - Present
The Vanguard Group, Malvern PA
Developing Tableau visualizations, dashboards, and workbooks using Tableau Desktop from multiple sources to perform YTD, QTD, and MTD types of analysis and share them with business users.
Working on a daily production support task by gathering and updating the ITS daily trade revenue data used in daily trading revenue reports, dashboards, and metadata layers sourced from Excel, SQL Server, Hue, Redshift, and Athena.
Assisting with digital reporting tasks on Intelledox activity by providing required data using Tableau and SQL queries.
Responsible for gathering, analyzing, documenting business and functional requirements, and data specifications to generate the Reports. Actively involved in weekly A/B testing experiments and Other ongoing projects.
Assisting with the IOR Project with business requirements and replicating the report from Tableau to ThoughtSpot.
Involvement in creating dashboards and reports focusing on Primary KPIs in Tableau and maintaining server activities like maintaining and refreshing data sources on the Tableau server.
Responsible to work with AWS hive by developing SQL queries to generate the reports and make changes accordingly to meet the data requirements.
Work extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps, Aggregations, calculated Fields, table calculations, Totals, and percentages using Key Performance Indicators (KPI) and Measures.
Data Analyst
2021 - 2022
Horizon Media, New York, NY
Writing complex SQL queries to fetch the data from Oracle, MS SQL Server and created stored procedures, triggers, used joins, and views.
Effectively using data blending feature in Tableau to connect different databases like Oracle, and MS SQL Server.
Involved in creating dashboards and reports on Executive summary, Media performance, Brand Health, and Creatives using Tableau.
Involved in Tableau dashboard designing based on different kinds of visuals Ex. charts, tables, color combinations, etc. Created Customized and interactive dashboards using multiple data sources.
Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps, and URLs.
Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs, etc. in Tableau Desktop/Server.
Collaborating with senior management teams to prioritize business requirements and locate and define opportunities for process improvements.