Data Analyst Power Bi

Rupesh Akula

Dallas, Texas, United States ******.*******@*****.*** +1-469-***-**** in/rupesh-krishna-akula-264259355 github.com/RupeshAkula98 SUMMARY

Impact-focused Senior Data Analyst with 5+ years of experience delivering high-value insights across fintech, healthcare, and e-commerce sectors. Spearheaded real-time KPI dashboards (cut reporting effort by 65%), optimized ETL pipelines (reduced processing time by 55% for 12TB+ datasets), and improved fraud analytics accuracy by 22%, enabling faster compliance response. Skilled in SQL, Python, Tableau, and cloud-native tools like Airflow, Spark, and Snowflake, driving data strategies that influenced $50M+ quarterly revenue decisions and enhanced executive-level reporting. SKILLS

Languages & Tools: SQL, Python (Pandas, NumPy), R, VBA, DAX, JQuery, HTML, CSS, SAS, MATLAB Visualization: Tableau, Power BI, Looker, QuickSight, Qlik Sense, Power BI Fabric, Power BI Reports, Data Modelling, Data Repository, Metabase, Superset, Google Sheets

ETL & Pipelines: Airflow, Glue, Azure Data Factory, SSIS, Alteryx, Databricks, Fivetran, dbt Data Warehousing: Snowflake, Redshift, BigQuery, Azure Synapse Cloud & DevOps: AWS (S3, IAM, Lambda), Azure (ADLS), GCP (BigQuery), Git, GitHub Actions, DevOps Integration Statistical Analysis: Regression, A/B Testing, Forecasting, Time Series, Scikit-learn, Data Analytics, Hypothesis Testing, Causal Inference, Predictive Modeling, Modeling Decile Analyses

Compliance & Governance: HIPAA, GDPR, PCI DSS, SOX, RLS, Collibra, Data Profiling, Data Validation, Data Quality Tools (e.g., Informatica DQ, Talend), Root Cause Analysis, Data Governance Frameworks, Master Data Management (MDM) Business: KPI Reporting, Stakeholder Management, Requirements Gathering, Data Storytelling, Documentation, Collaboration, Business Intelligence, Marketing Analytics, Process Improvement

Other Skills: Excel, T-SQL, Data Migration, Data Modeling, Data Cleaning, SQL Queries, Microsoft Office Suite EXPERIENCE

Data Analytics Engineer

American Express July 2024 - June 2025, Texas, USA Led cloud migration efforts for reporting pipelines from on-premise relational databases and Hadoop clusters to Google Cloud Platform using Cloud Storage and Cloud Data Management best practices, ensuring scalable architecture and enhanced data security.

•

Demonstrated an analytical mindset, detail-oriented execution, and effective communication while managing cross-functional deliverables with strong project management, adaptability, and a willingness to learn in fast-paced environments.

•

Spearheaded design and execution of 3 Strategic Programs integrating Snowflake, Python, and Tableau over 12 months, enabling 25% faster analytics delivery and aligning KPIs across 4 departments through unified data pipelines.

•

Collaborated cross-functionally to ensure successful data transfer and delivery of high-quality data during cloud migration projects, demonstrating strong teamwork and implementing optimizations that reduced migration time by 30%.

•

Evaluated large datasets in Snowflake and Python across 12-month initiatives, applying analytical skills to optimize pipeline performance and achieve a 40% reduction in processing time for monthly regulatory reporting projects.

•

Collaborated with engineering and product teams to lead estimating work, navigate the delivery lifecycle, and proactively mitigate risk through early stakeholder engagement, backlog prioritization, and sprint planning.

•

Applied strong attention to detail and the ability to connect dots between technical solutions and business goals, effectively using tech-to-business speak and strategic questioning to uncover gaps and accelerate delivery.

•

Senior Data Analyst

PayPal May 2020 – July 2023, Hyderabad, India

• Designed Tableau dashboards for payment flow insights, enabling faster decisions across global risk and product teams. Defined and executed data migration strategies across cloud environments (Snowflake, BigQuery), resolving data issues escalation paths and ensuring integrity within relational databases.

•

Collaborated with scrum teams and engineering leads to manage full delivery lifecycles, from effort estimation and scope refinement to post-launch risk mitigation and stakeholder feedback loops.

•

Led application development and database management efforts across cross-functional initiatives, providing strategic guidance, supervision, and resource management to ensure timely, high-quality delivery.

•

Drove proof of concept development to test innovative solutions, applying strong analytical thinking, problem solving, and innovative thinking to derisk product decisions and accelerate rollout.

•

Bridged technical and business teams through clear tech-to-business communication, presentation skills, and the ability to “connect the dots,” ask the right questions, and maintain an E2E view of project goals and delivery risks.

•

Delivered insights and dashboards using Superset and Google Sheets to support analytics initiatives in regulated industries, ensuring full adherence to data compliance and governance standards.

•

Applied critical thinking and cross-functional collaboration to strengthen data stewardship, enhance data integrity, and implement automated QA checks that improved data accuracy across reporting pipelines.

•

Presented monthly Insights Presentation to executive leadership over a 24-month period using Tableau and PowerPoint, translating complex analytics into actionable recommendations that drove a 28% increase in data-informed project execution across four business units.

•

Spearheaded deployment of advanced query tools, such as DBeaver and SQL Workbench, to streamline data discovery and ad hoc analysis across 8 stakeholder workstreams over 12 months, resulting in a 37% reduction in turnaround time for complex SQL-based reporting requests.

•

Collaborated with onboarding and compliance teams to support client data integration and KYC alignment, using PL/SQL and Oracle Exadata to validate and migrate onboarding data while driving delivery across the agile project lifecycle.

•

Data Analyst

UnitedHealth Group June 2019 - March 2020, Bangalore, India Consolidated disparate data sources using Alteryx and SQL, standardizing over 5TB of healthcare information for integration into a centralized platform, which improved data accessibility and slashed manual reporting efforts by 60% across cross-functional teams.

•

Built interactive dashboards in Metabase and performed advanced predictive analysis, integrating machine learning and statistics to improve forecasting models for product engagement and spend behavior.

•

Participated in code reviews and collaborative development cycles to ensure best practices in data science pipelines and reproducibility of insights across teams.

•

Delivered impactful visualizations and translated complex analyses into executive-level narratives, communicating insights clearly in a fast-paced environment while staying highly results-oriented.

•

Engineered comprehensive test scenarios using Python and dbt over a 6-month cycle, validating end-to-end data pipelines for 12+ business-critical workflows to achieve 99% data accuracy prior to dashboard deployment.

•

Integrated software engineering principles into the development of automated ETL pipelines using Python and Snowflake over 12 months, improving test coverage by 35% and increasing deployment frequency to weekly cycles for enterprise analytics initiatives.

•

Leveraged connecting dots across business objectives and technical requirements to architect and deliver automated ETL solutions in Snowflake and Python over 18 months, increasing alignment on analytics KPIs for 6 key projects and reducing requirements-to-delivery cycle time by 22%.

•

Presented complex analytics insights in tech business speak to executive stakeholders bi-weekly over 18 months, utilizing Tableau and Python to translate technical KPIs into actionable business decisions, improving cross-department understanding and expediting project alignment for 6 initiatives.

•

Facilitated biweekly stakeholder workshops over a 12-month period using Miro and Zoom, systematically asking questions to clarify business needs and elicit data requirements, leading to a 25% reduction in scope creep across six analytics projects.

•

Data Reporting Analyst

Wayfair August 2018 - February 2019, Chennai, India

• Wrote SQL queries and stored procedures to generate weekly and monthly performance reports, increasing visibility of key operational KPIs. Engineered automated ETL pipelines using Python and SQL, enabling daily integration of data from five sources and reducing manual processing time by 30% while increasing reporting accuracy for cross-departmental stakeholders.

•

Leveraged Tableau and Power BI to integrate and display operational data from multiple systems, facilitating transparent reporting that supported rapid executive alignment and data-driven discussions.

•

• Managed agile sprint cycles for BI requests, prioritizing and delivering new KPIs and dashboard features within 2-week iterations. Led initiatives to migrate legacy reports and modernize dashboards for better usability, aligning outputs with stakeholder needs and promoting platform adoption across departments.

•

Coordinated with cross-functional technical and business units using SQL and Python to address urgent BI requests, ensuring prompt and accurate completion in deadline-driven settings.

•

Analyzed profit margins across 7 business units by developing advanced SQL queries and Power BI dashboards, driving a 12% improvement in decision- making speed over 9 months through actionable reporting on revenue and cost trends.

•

Spearheaded quarterly analysis of operational outcomes across 7 business units by designing SQL-driven Tableau dashboards, resulting in a 15% increase in KPI tracking accuracy and enabling leadership to implement targeted process enhancements within two reporting cycles.

•

Developed data extraction workflows utilizing T-SQL and SQL Server for ad hoc and scheduled reporting across 7 business units, improving executive access to actionable insights and achieving a 20% reduction in data retrieval time over 12 months.

•

Implemented PL/SQL skills to design and deploy complex stored procedures supporting monthly financial reporting for 7 business units, resulting in a 25% reduction in data processing errors and increased stakeholder trust over a 6-month rollout using Oracle Database.

•

Optimized data warehousing processes on Oracle Exadata by configuring advanced partitioning and parallel query execution, resulting in a 35% increase in ETL throughput and supporting the accurate generation of monthly financial reports for 7 business units over a 12-month period.

•

PROJECT

Feast-IT

UTD • github.com/RupeshAkula98/myvendorfood-app • January 2024 - March 2024 Designed RESTful APIs using Flask, SQLAlchemy, and MySQL to handle vendor onboarding, document uploads, and order tracking, ensuring consistent CRUD operations with schema validation.

•

Implemented secure document ingestion workflows with Werkzeug in Flask, capturing file metadata in MySQL to support admin-side verification and centralized access.

•

Real-Time Ticker Flow

UTD • github.com/RupeshAkula98/Real_Time_Ticker_Flow • August 2023 - October 2023 Engineered a modular ETL workflow utilizing Apache Airflow to automate the ingestion of daily sales CSVs into PostgreSQL databases, ensuring continuous and timely data updates for real-time ticker displays.

•

Transformed sales data with pandas in Python for data ingestion and transformation by handling nulls, formatting timestamps, and resolving schema mismatches, boosts data consistency by 88%.

•

Tweet-Sense-AI

Personal Project • github.com/RupeshAkula98/tweet-sense-ai • April 2020 - June 2020 Built a real-time sentiment analysis pipeline using Python, Tweepy, and HuggingFace Transformers to classify tweets by emotional tone on a big data scale with 85%+ model confidence, storing results in SQLite.

•

Engineered automated data ingestion and preprocessing modules tailored for large-scale Twitter datasets, seamlessly integrating advanced NLP models to deliver high-frequency sentiment insights to end-users.

•

CERTIFICATIONS

Microsoft Certified: Power BI Data Analyst Associate AWS Certified Data Engineer – Associate

Microsoft Certified: Azure AI Fundamentals (AI-900) EDUCATION

M.S. in Information Technology & Management

Minor in Data Science • The University of Texas at Dallas • USA • 2025 • 3.4

• JSOM Dean Excellence Scholar

B. Tech in Computer Science

Lovely Professional University • India • 2020 • 3.5

Contact this candidate