Data Analyst Power Bi

SUMMARY

ASHISH KETHAVARAPU

DATA ANALYST

Atlanta, Georgia +1-334-***-**** ********************@*****.*** Experienced Data Analyst with 4+ years of expertise in data processing, analysis, and visualization using Python, SAS, SQL, R, and AWS well versed in designing and automating large-scale ETL pipelines with Apache Airflow and constructing NoSQL-based workflows to process over 2TB of data monthly. Proficient in Power BI and Tableau for creating interactive dashboards that deliver actionable insights. TECHNICAL SKILLS

Programming Languages: Python (Fast API, SQL Alchemy, Pandas, NumPy), R, SQL, Bash Libraries: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn Databases: MySQL, PostgreSQL, Oracle, MongoDB, NoSQL, Snowflake Cloud Platforms: AWS (EC2, S3, Redshift, Athena, Glue, EMR, Lambda), Azure (Data Factory, Data Lake, Databricks) Data Visualization: Tableau, Power BI, Seaborn, MS Excel Version Control: Git, GitHub, SVN, Bitbucket

Project Management Tools: JIRA, IBM UDeploy, Confluence, MS Project, SharePoint, Google Suite, JupyterNotebook, Hadoop, Hive and Spark Methodologies: Agile (Scrum), Waterfall

WORK EXPERIENCE

Data Analyst

Uber Atlanta, GA Dec 2024 – Present

• Engineered scalable ETL pipelines with Python and AWS Glue, processing over 5,000 financial records monthly.

• Created real-time Power BI dashboards that cut reporting time by 2-3 hours, improving visibility of key financial metrics.

• Automated reporting workflows using AWS Lambda and S3, improving data delivery speed by 35%.

• Enhanced data quality and compliance through Alteryx, cleansing and validating over 1,000 records to ensure consistent reporting.

• Partnered with business stakeholders to define reporting metrics and deliver real-time insights into financial performance, supporting data-driven decision- making.

Data Analyst

BNY Mellon GA USA Apr 2024 – Dec 2024

• Engineered robust data processing frameworks by leveraging Python libraries such as Pandas and NumPy, achieving high-quality standardization of diverse datasets that enhanced the integrity of over 200 monthly business intelligence reports.

• Conducted trend analysis and predictive modeling using SQL and R, delivering insights that informed client strategies; findings identified top three operational inefficiencies leading to systematized decision-making processes across four key industries.

• Smoothed database architecture and improved query efficiency, achieving a 40% decrease in data retrieval times; facilitated faster insights gathering that directly supported strategic decisions within critical business units

• Increased data accuracy and consistency by 30% by implementing standardized data cleaning processes, leading to higher quality analytics.

• Arranged AWS Glue pipelines which refined data workflows by 40%, resulting in expedited retrieval processes; quicker access to vital datasets, streamlining decision-making for cross-functional teams.

• Achieved a 25% reduction in cloud infrastructure expenses by optimizing SQL queries and refining data pipeline architecture within AWS, resulting in notable Long-term savings for the organization’s operational budget. Data Analyst

Adani Group India Oct 2020 – Jul 2022

• Built scalable data solutions using AWS S3, Redshift, and SQL, processing over 5 million records monthly while reducing manual query efforts by 25%.

• Developed interactive Tableau dashboards that enhanced business insights and provided visibility into over 50 KPIs, enabling quicker decision-making for executives.

• Deployed machine learning models on AWS using Scikit-learn to predict customer churn, resulting in a 15% improvement in customer retention and saving

• $200,000 annually through targeted prevention strategies.

• Managed 12 projects and delivered them 20% ahead of deadlines by using Agile methodologies, boosting client satisfaction and trust.

• Conducted statistical analysis using R on over 100 datasets and presented actionable insights during client presentations, improving decision-making speed by 25%. Data Analyst

Trigent Software India Feb 2020 – Sep 2020

• Improved ETL processes by streamlining Python code and optimizing SQL queries, reducing report generation time by 30%.

• Enhanced Excel reporting by creating advanced formulas, pivot tables, and charts to provide insightful data analysis.

• Conducted A/B testing on marketing campaigns, resulting in a 10% increase in user engagement.

• Delivered 12+ projects 20% ahead of schedule using Agile practices, contributing to increased client satisfaction and repeat business. EDUCATION

Master of Science in Information Technology

Auburn university at Montgomery, USA Aug 2022 – Dec 2023 Bachelor of Engineering in Mechanical Engineering

Chaitanya Bharathi Institute of Technology, Hyderabad, India Sep 2013 – May 2017 CERTIFICATION

• Microsoft Certified: Data Analyst Associate

• Microsoft Azure Fundamentals (AZ-900)

• Power BI for Data Analysis – Coursera

Contact this candidate