Highly analytical and process-oriented data analyst and BI analyst with two years of experience. In-depth knowledge of database types, research methodologies, and big data capture, curation, manipulation and visualization. Knowledgeable in finding ways to create useful, communicative insights from business data. Furnish insights, analytics and business intelligence used to advance opportunity identification, process re-engineering and corporate growth.
-
Experience
Capgemini, Chicago, USA Mar 2020 – Apr 2020 Application Consultant 2 (Data Visualization, Power BI, DAX)
• Developed Power BI model for HR reporting of Capgemini Data & Insights team. • Designed Headcount Analysis reports and Attrition Analysis reports for HR team.
• Built a Power BI solution to identify mitigation options for raw materials shortages.
• Gathered business requirements, definition and design of the Power bi reports, working in conjunction with the data warehouse architect on the development of logical data models. • Integrated SAP transactional (ODS) procurement systems for BI reporting.
--------------------------------------------------------------------------------------------------------------
Allianz Global Corporate and Specialty, Chicago, USA Aug 2019 – Dec 2019
Data Analyst Intern (Alteryx, Tableau, R, SQL, SSRS)
• Designed ETL pipelines using Alteryx that delivered financial data in real-time from various databases reducing company workload by 40%. • Performed Data Wrangling and extracted statistical values from the data to perform classification analysis. • Identified and measured business KPIs to influence, support, and execute result-oriented business decisions for the Underwriting team, which helped in reducing Average Annual Loss by 4%. • Designed, developed and maintained daily and monthly summary, trending and benchmark reports in Tableau Desktop to help track North America Property Financial data at granular level.
--------------------------------------------------------------------------------------------------------------
Anything but Beer, New York, USA May 2019 – July 2019 Data Analyst Intern (Tableau, Python ,WEKA , SQL) • Extracted transaction data from Salesforce using SQL queries and pre-processed it to analyze customer behavior. • Performed association rule mining using WEKA, discovered interesting purchasing trends and assisted the marketing team in developing target marketing strategies. • Used advanced statistical techniques like clustering, linear regression between revenue and marketing spend to gain valuable insights that enabled the clients to optimize pricing and improved ROI by 20%.
--------------------------------------------------------------------------------------------------------------
Tata Consultancy Service, Hyderabad, India December 2016 – December 2017
Data Analyst (SQL, ETL, RapidMiner , MS Excel ,Power BI)
• Designed and developed various SQL scripts as part of automation of manual monthly reporting to third-party consumer. • Redesigned ETL pipelines using RapidMiner to parallelize execution of data stream reducing SLA escalations by 30% and improving executing time by 70%. • Identified discrepancy in data and analyzed the customer's policy claim transactional data using SQL and advanced Excel functions like V - Lookups, macros and pivot tables and created Power BI dashboards for reporting.
-
Projects
Data Analytics August 2018 – December 2018
Crime Analysis of Chicago (Python(NumPy, pandas, scikit-learn), SQL, Tableau)
• Quantified data of 100,000+ crimes to make it suitable for analysis. • Implemented Decision Trees, Random Forests, Naïve Bayes, KNN and Logistic regression to predict the arrests made against the crimes with an accuracy of 76%. • Cluster Analysis of the crimes based on the Location of the Crimes to gain insight over the streets with the highest crime rate. • Time Series Analysis of the Chicago Crime to understand the trend of crime in the city between the years 2012 to 2017. • Visually recognized the highest crime areas by generating a heat map for the city along with several other Crime Statistics reports.
--------------------------------------------------------------------------------------------------------------
Data Warehousing January 2019 – May 2019 Fudge Mart – Retail Company (SQL, ETL, Alteryx, Power BI)
• Analyzed and documented business requirements and defined the scope of realization.
• Designed fact and dimension tables; developed dimensional model by identifying business processes.
• Developed Star Schema model diagrams, performed data mapping, processed ETL to load over 110,000 records from source system to respective target tables by Alteryx.
• Generated business intelligence reports in pivot tables linked to Alteryx and visualized analytical results in Power BI.