Mahendhar Reddy M
Alpharetta,GA
Summary
Experienced Data Analyst with 7 years in analyzing large datasets and resolving data quality challenges. Skilled in SQL, Python, Tableau, and Power BI, with a focus on finance and e-commerce sectors. Developed BI dashboards that enhance decision-making and operational efficiency while driving data-driven strategies in Agile environments.
Overview
9
9
years of professional experience
Work History
Data Analyst
Capital One
Atlanta, USA
12.2023 - Current
- Led data analysis for consumer banking and credit card portfolios, utilizing millions of customer records to inform risk and growth strategies.
- Optimized complex SQL queries (CTEs, window functions) to extract actionable insights from large-scale relational and cloud data warehouses.
- Developed Python-based analytics workflows (Pandas, NumPy) to automate data cleaning and reporting processes.
- Designed executive dashboards in Tableau/Power BI to visualize KPIs like credit performance and customer retention for strategic decision-making.
- Collaborated with product managers and risk teams to translate business inquiries into actionable, data-driven insights.
- Conducted credit risk analysis to identify trends in spending and payment patterns, supporting enhanced policy optimization.
- Conducted A/B tests to evaluate product features and marketing campaigns, yielding statistically valid recommendations.
- Mentored junior analysts by reviewing code and standardizing reporting practices.
Graduate Research Assistant
Auburn University at Montgomery
Montgomery, USA
07.2022 - 11.2022
- Analyzed research and operational datasets to identify patterns, trends, and insights supporting data-driven conclusions.
- Collected, cleaned, and prepared large datasets to ensure accuracy and reliability for analysis.
- Analyzed clickstream and customer behavior data using SQL, Spark.
- Used Excel, SQL, and Python.
- Worked with cross-functional stakeholders on data needs, clarity, and feasibility across business and engineering teams.
Data Analyst
Amazon
Hyderabad, India
06.2020 - 03.2022
- Analyzed clickstream and customer behavior data using SQL, Spark, and Scala, informing product improvement strategies.
- Executed A/B experiment analysis and statistical evaluation, guiding product feature decisions based on data-driven insights.
- Built KPI dashboards and real-time monitoring views in Tableau / Power BI, enabling business teams to track performance.
- Built data marts and ETL pipelines using AWS S3, Redshift, Glue, Ni Fi, and Snowflake to support analytics and reporting teams.
- Collaborated with cross-functional stakeholders to clarify data needs and assess feasibility, enhancing alignment between business and engineering teams.
Data Analyst
Google
Bangalore, India
01.2019 - 06.2020
- Built executive dashboards using Looker and Google Data Studio, enabling data-driven decision-making across global teams.
- Analyzed and aggregated data using Big Query, SQL, and Python to support product analytics, campaign performance, and operational reporting.
- Performed data profiling and query optimization to enhance data quality and accuracy.
- Conducted A/B testing and statistical analysis to inform product feature development and understand user behavior.
- Automated data workflows with Google Apps Script and Python, streamlining reporting processes for teams.
Data Analyst
Apple
Hyderabad, India
12.2017 - 12.2018
- Conducted advanced SQL analysis on operational datasets, delivering actionable insights to finance, engineering, and product teams.
- Designed dashboards and visualizations for leadership teams to track KPIs and operational performance.
- Built automated Python routines to extract and transform data for reporting and quality tracking.
- Ensured high-quality data warehousing through ETL validation, data profiling, and quality checks, enhancing data reliability for analysis.
Business Analyst
Capgemini
Mumbai, India
05.2017 - 11.2017
- Facilitated product and operational initiatives through data analysis, stakeholder communication, and Agile project execution to enhance decision-making.
- Bridged business requirements with technical teams, translating use cases into clear process flows and documentation.
- Developed dashboards and reports to enable business performance review and identify operational improvements.
Education
Master of Science -
Auburn University
Montgomery, USASkills
- Python and R
- SQL and NoSQL databases
- Data visualization tools
- Machine learning techniques
- Statistical analysis methods
- Data integration and migration
- Cloud computing platforms
- Version control systems
- Analytical and problem-solving skills
Timeline
Data Analyst
Capital One
12.2023 - Current
Graduate Research Assistant
Auburn University at Montgomery
07.2022 - 11.2022
Data Analyst
Amazon
06.2020 - 03.2022
Data Analyst
Google
01.2019 - 06.2020
Data Analyst
Apple
12.2017 - 12.2018
Business Analyst
Capgemini
05.2017 - 11.2017
Master of Science -
Auburn University