SUMMARY

• Highly analytical and process - oriented data analyst with around 7 years of experience and in-depth knowledge of database types; research methodologies; and data curation, manipulation and visualization.
• Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.

TECHNICAL SKILLS

Databases: MySQL, MS SQL Server, Teradata, Oracle

Data Science Tools: Python (NumPy, Pandas, Seaborn, Scikit-learn), R

Data Visualization: Tableau, Power BI

Office Tools: MS Word, MS Project, MS Outlook, MS Power point, MS Excel (VBA, Pivot Tables)

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Developed new controls(reports) and enhance existing ones, based on business requirements, functional and technical specifications, and development standards for ‘Absolute Control’ team
• Transformed the business process logic into Python scripts using Databricks platform, utilizing libraries like Pandas, Numpy, snowflake-connector and others.
• Imported data from external and internal data sources, and then included, validated and recorded the data in internal tables using complex SQL queries in Snowflake.
• Optimizing the current database by adding tables, relationships, creating views and performance tuning of SQL queries and stored procedures.
• Integrated multiple datas in multiple file formats and retrieved them onto DB stage using PySpark modules.
• Worked in close collaboration with Intent owners to understand the Card processes as well as the reporting requirements, which facilitated them to identify the outliers in data so that the Triage team can take necessary action.

Confidential, San Francisco, CA

Sr. Data Analyst

Responsibilities:

• Created an interactive cohort analysis report in Tableau Server for the product with global filters and parameters that helped improve monthly retention by 17% for a specific target.
• Automated processing of billions of rows of data from Redshift and Postgres SQL to improve real-time reporting of product metrics, saving the company $215K yearly in reduced downtime.
• Ran SQL queries for data validation and performed quality analysis on data extracts across various database systems.
• Wrote Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
• Conducted quantitative and qualitative analyses on a broad array of issues across disciplines, projects, and functional areas. Structured and executed analysis independently.
• Perform Pandas profiling to generate an analysis report on the data frame, and better understand the correlation between data variables.
• Conducted gap analysis and root cause analysis and recommended alternatives to streamline and optimize data flows.

Confidential, Woonsocket, RI

Business Intelligence Analyst

Responsibilities:

• Recommended analytic solutions for Extracare Card program, that enable a comprehensive understanding of customer behaviour within or across segments, markets, or other defined logical groupings.
• Developed Power BI dashboard with KPIs (Key Performance Indicators) by using complex DAX queries resulting in well informed and smarter decisions.
• Performed A/B testing using Google Analytics and Python resulting in the increase of foot traffic on the clients’ website by 8%.
• Performed ETL on large healthcare datasets, applied data hygiene, reconciled matched tables, performed data auditing and validation using Teradata.
• As a part of Customer Research & Marketing Analytics team, evaluated business needs, derived actionable insights from customer POS & E-commerce data to help business teams take informed decisions.
• Worked collaboratively with multiple internal teams to identify KPIs for critical business requirements for reporting and conducted regular ad-hoc data analysis.

Confidential

Data Analyst

Responsibilities:

• Recommended improvements to clients on the ongoing Customer Loyalty program by deriving insights from customer data helping in expanding its member-base and increasing customer engagement by 24%.
• Extracted relevant datasets from marketing databases and derived useful insights using complex SQL queries and Tableau.
• Automated analysis of key performance metrics to prepare marketing reports for clients, using MS Excel (Macros).
• Wrote and executed SQL queries using Query Analyzer to provide custom reports to the Marketing and Strategy team.
• Drove requirements gathering for integration of sales systems at dealerships with substantial ROI.

Confidential

Business Data Analyst

Responsibilities:

• Provided oversight to the daily operations, including data pulls, research assignments, file transfers, data processing and data quality management to streamline operations.
• Prepared a holistic database of prospects for the Business Development team by extracting, cleaning, and merging from different tables using SQL.
• Fetched multiple new opportunities in the form of new channel partners, for the Business team by churning data from prospective companies’ databases.
• Conducted market analysis using Python (Pandas, Scikit-learn) and prepared regular reports, which gave insights to senior management in their Sales strategy.