Dharmil Shah
Atlanta,GA
Summary
Results-driven professional with 4+ years of experience in quantitative analysis, data mining and statistical modeling, successfully driving business strategies to positively impact a company's performance, specializing in financial analysis and marketing insights within the finance sector. Passionate about translating complex data into compelling stories that drive strategic business decisions. Proficient in utilizing a wide range of programming languages, including SQL, R, SAS, Python and visualization tools such as Tableau and Power BI. Skilled at developing and optimizing selection strategies, driving substantial improvements in campaign performance and ROI.
Overview
4
4
years of professional experience
Work History
Quantitative Analyst III
BHG Financial
Atlanta, GA
01.2022 - Current
- Managing end-to-end financial analysis of marketing campaigns, contributing to a 20% lift in campaign efficiency through strategic insights.
- Executing a structured targeted Direct Mail campaign monthly resulted in a 27% increase in a response rate and a 16% conversion rate.
- Implementing a efficient designed Email campaign biweekly resulted in a 32% increase in open rates and 19% increase in click-through rates.
- Led the development of optimized selection strategies for Direct Mail to maximize 12M$ loan origination monthly and minimizing CAC.
- Analyzing customer journey data across all platforms, revealing bottlenecks and recommended improvements that increased eligible universe by 10%.
- Create and optimize complex SQL queries to extract insights and analyze large datasets to drive strategies.
- Development and maintenance of Tableau dashboards to track performance metrics and provide insights that directed strategic planning and increased marketing efficiencies.
- Performing detailed statistical data analysis on Databricks using Python, SQL and Excel for optimizing the CPP while constantly improving the return on investment for our campaigns.
- Presenting data analysis at stakeholder meetings which influences the decision-making process and strategies adopted.
- Conducting A/B testing on different channels, yielding a 12% lift in customer engagement.
- Worked with Finance Team to provide guidance on long-term revenue impact of A/B tests.
- Crafted a new framework cutting down the development process by 13%.
- Improved lead generation process using predictive analytics, leading to a 15% growth in qualified better credit quality leads for the sales team and generating additional $4.5M in loan origination.
- Automated the reporting tasks using Python on Databricks, saving the team 2 hours per day in manual pivot report processing.
Data Analytics Engineer
Fitzco
Atlanta, GA
07.2021 - 10.2021
- Carried out data extraction and transformation tasks to manage databases for clients.
- Increased the efficiency of data fetching using query optimization and indexing.
- Automated ETL processes, making it easier to wrangle data and reducing time by 20%.
- Utilized SAS, SQL and Python for data cleaning, management and analysis assignments.
- Built Power BI dashboards and weekly Excel reports to meet the needs of the business, gathering all appropriate requirements from clients.
- Audited client's data files on a weekly basis to understand customer's retention rate and analysis effectiveness.
Data Analyst Intern
American Society of Engineering Education
Washington, DC
07.2021 - 09.2021
- Implemented a long term multi metric dashboard that improved the weekly manual tasks for the team by 4hrs.
- Collaborated with team members in developing the dashboards for Engineering and Information Technology Departments of universities using R shiny.
- Employed the use of Midfield R package that yields better determining persistence metrics.
Data Analyst Intern
American College of Nurse-Midwives
Silver Spring, MD
05.2020 - 10.2020
- Coordinated with the Senior Analyst to understand requirements, analyzed and build custom business reports.
- Developed interactive dashboards in Tableau based on the requirements of the department.
- Collaborated closely with the supervisor and ETL member to understand business needs and wrote SQL scripts to maintain and manage data in the data mart.
- Automated database jobs for monthly midwives enrollments, upcoming event assignment feeding the daily CRM data, resulted in reducing assignments human efforts.
Education
Master of Science - Information Systems
University of Maryland, Baltimore County
Baltimore, MD05-2021
Skills
- Programming Languages: SQL, R, SAS, Python, R
- Databases: Oracle 11g, SQL Server, MySQL, Teradata, PostgreSQL
- Cloud Computing: Databricks, Microsoft Azure, Snowflake
- Visualization Tools: Tableau, Power BI, Google Analytics
- Competencies: Statistical Data Analysis, Quantitative Analysis, Big Data Analytics, Finance, Machine Learning, KPI Reporting, Problem Solving, Data-Driven Decision Making
- ETL Tools: SQL Server Integration Services
- Framework and Tools: SAS Enterprise Guide, Jupyter Notebook, RStudio, Git, Visual Studio, Advanced Excel, Macros
- Project Management: Jira, Trello
Timeline
Quantitative Analyst III
BHG Financial
01.2022 - Current
Data Analytics Engineer
Fitzco
07.2021 - 10.2021
Data Analyst Intern
American Society of Engineering Education
07.2021 - 09.2021
Data Analyst Intern
American College of Nurse-Midwives
05.2020 - 10.2020
Master of Science - Information Systems
University of Maryland, Baltimore County