Data Analyst with over 3+ years of experience in digital marketing analytics, ETL workflows, and automation, optimizing data-driven decision-making. Proficient in SQL, Python, Azure Data Factory, Snowflake, and PySpark, managing 5+ TB of unstructured and structured data and automating data pipelines. Developed interactive dashboards in Tableau, Power BI, and Salesforce, providing real-time insights into ad performance, audience engagement, and campaign optimization. Collaborated with cross-functional teams, implementing data governance strategies and driving a 10% increase in campaign success rates through data-backed insights for media planning and ad spend efficiency.
Hi, I’m
KEERTHI BACHAWALA
Montgomery,AL
Summary
Overview
5
years of professional experience
1
Certification
Work History
McKesson
Data Analyst
03.2025 - Current
Job overview
- Conducted comprehensive data analysis on healthcare and pharmaceutical datasets using SQL and Python (Pandas, NumPy) to support patient outcomes, operational efficiency, and inventory optimization.
- Created interactive dashboards and real-time visualizations in Power BI to monitor key performance indicators including prescription fill rates, patient adherence, and supply chain efficiency.
- Applied statistical methods such as descriptive analytics, regression analysis, and hypothesis testing to uncover trends in medication usage, improve risk assessment, and support compliance initiatives.
- Automated data aggregation and reporting tasks through Python scripting and advanced Excel (VLOOKUP, PivotTables, Macros), reducing manual effort and improving data delivery turnaround by 40%.
- Collaborated with cross-functional teams—including business, clinical, and compliance units—to define data requirements and deliver actionable insights through stakeholder-ready presentations and reports.
- Maintained high standards of data accuracy and consistency, supporting internal audit processes and ensuring alignment with HIPAA and GxP regulations.
- Supported development of data dictionaries, performed data validation, and contributed to data governance efforts to improve trust and usability of enterprise-wide data assets.
MediaMint
Data Analyst
01.2021 - 12.2022
Job overview
- Built and maintained interactive dashboards in Tableau and Salesforce, delivering actionable insights into digital campaign performance, ad spend efficiency, and audience engagement, achieving a 98% client satisfaction rating by aligning insights with marketing objectives.
- Conducted data-driven analysis to optimize ad delivery, audience targeting, and media buying efficiency using SQL databases with over 5 TB of storage, identifying trends that contributed to $6M in revenue generation for clients through enhanced campaign ROI.
- Collaborated with cross-functional teams (creative, sales, and operations) to provide data-backed insights from Azure Databricks processing 10 TB of structured and unstructured campaign data, supporting media planning, and achieving a 15% increase in performance success rates.
- Managed SQL databases enabling rapid retrieval of ad performance metrics and client reporting, ensuring seamless functionality and data quality across all reporting systems for real-time campaign optimization.
- Engineered data pipelines using Azure Data Factory to automate the integration of ad platform data (Google Ads, Facebook Ads), maintaining reliable data flow and supporting collaboration with clients for timely decision-making.
- Developed data governance standards for over 100 datasets, ensuring accuracy and compliance in campaign analytics, which led to a 90% improvement in team proficiency through data-driven training sessions on analytics tools for ad operations staff.
- Executed data cleaning processes to eliminate inaccuracies in datasets processed via Azure Synapse Analytics, enhancing reporting systems and facilitating accurate, comprehensive analysis for campaign forecasting and client deliverables.
MediaMint
Data Analyst Intern
09.2020 - 01.2021
Job overview
- Designed and maintained complex SQL queries for data extraction, transformation, and reporting, ensuring efficient data retrieval and analysis.
- Configured and fine-tuned Snowflake Virtual Warehouses to enhance query performance while maintaining cost efficiency and scalability.
- Partnered with cross-functional teams, including data analysts, engineers, and business stakeholders, to develop data-driven solutions supporting strategic decision-making.
- Coordinated in managing and optimizing 3+ ETL pipelines, automating workflows to improve data processing speed and reliability.
- Conducted data quality monitoring on 50,000+ records, identifying inconsistencies and implementing data cleansing strategies to ensure accuracy and completeness.
- Facilitated 5+ partner data imports and integrations, validating data integrity and resolving discrepancies to maintain consistency across systems.
- Deployed Power BI dashboards at MediaMint displaying key media metrics, ROI trends, and audience insights, enabling clients to make data-driven decisions and improving the adoption of analytics tools across internal and external teams.
Trigent Software
Data Analyst Intern
01.2020 - 09.2020
Job overview
- Systematized transformation, data extraction, and loading (ETL) processes with Python scripts, improving pipeline efficiency and reducing manual effort with automation.
- Pruned complex SQL queries to retrieve and manipulate data from relational databases, enhancing the speed and accuracy of report generation for timely business insights.
- Streamlined data analysis and reporting tasks with Excel models, incorporating advanced functions like Pivot Tables, VLOOKUP, and Macros, automating repetitive tasks and improving weekly workflows.
- Monitored Oracle databases to ensure high availability and reliability, implementing regular backups and disaster recovery procedures to minimize downtime and data loss.
- Secured sensitive data within PostgreSQL databases by applying access controls, encryption, and validation measures, maintaining data integrity, and protecting over 100 GB of data from unauthorized access.
- Leveraged Pandas for data aggregation and filtering, manipulating large datasets to uncover actionable insights and support business functions.
- Conducted A/B testing to assess the impact of changes on key metrics, providing data-backed recommendations that upgraded conversion rates and user engagement.
Education
Auburn University at MontgomeryMontgomery, Alabama
Master of Science from Computer Science
12.2024
University Overview
CMR Technical Campus
Bachelor of Technology from Computer Science
04.2020
University Overview
Skills
- Programming & Scripting: Python (Pandas, NumPy), SQL
- Data Analytics & Visualization: Tableau, Salesforce Analytics, Power BI
- Database Management: SQL (MySQL, PostgreSQL, Azure SQL Database), Snowflake
- ETL & Data Processing: Azure Data Factory, Azure Synapse Analytics, ETL Pipelines
- Big Data & Cloud Technologies: Azure Databricks, Azure Data Lake Storage, PySpark, AWS (S3, EC2, Lambda)
- Data Governance & Quality: Data Cleaning, Data Validation, Data Governance Standards
- Digital Marketing Analytics: Google Ads, Facebook Ads, Media Buying Optimization
- Business Intelligence & Reporting: KPI Tracking, Campaign Performance Analysis
- SQL
- Data visualization and presentations
- Data analysis
- Python programming
- Excel functions
- Data cleaning
- SQL databases
- Analytical problem solving
- Statistical analysis
- Tableau
- Attention to detail
- Tableau software
- Data validation
- Database programming and SQL
- Database management
- Data modeling
- ETL processes
- Database maintenance
- Project management
- Report preparation
- Data storytelling
- Data mining
- Reporting tools
- Google analytics
- Software development life cycle (SDLC)
- A/B testing
- MS Excel
- Data collection
- Microsoft power BI
- Report writing
- Data quality assurance processes
- Data integrity validation
Accomplishments
Accomplishments
Achieved Employee of the Quarter Award at Mediamint
Certification
- Azure Data Engineer – 203
- Programming basics and Data Analytics with Python
- Google Data Analytics
Languages
English
Full Professional
Interests
- I enjoy helping others and giving back to the community
- Reading
Timeline
Data Analyst
McKesson
03.2025 - Current
Data Analyst
MediaMint
01.2021 - 12.2022
Data Analyst Intern
MediaMint
09.2020 - 01.2021
Data Analyst Intern
Trigent Software
01.2020 - 09.2020
CMR Technical Campus
Bachelor of Technology from Computer Science
Auburn University at Montgomery
Master of Science from Computer Science
Similar Profiles
Andre HenleyAndre Henley
Operations Supervisor/Receiving Supervisor at McKessonOperations Supervisor/Receiving Supervisor at McKesson
Annetta JonesAnnetta Jones
Material Handler at McKessonMaterial Handler at McKesson
ERNEST FIANKOERNEST FIANKO
Senior Warehouse Associate at MckessonSenior Warehouse Associate at Mckesson
Raymond ParraRaymond Parra
Delivery Driver at McKessonDelivery Driver at McKesson
Jasmine ColeJasmine Cole
Restaurant Hostess at BB King'sRestaurant Hostess at BB King's