Data Analyst Analysis

DWARAKAMAI JANGITI

+1-571-***-**** **********@*****.*** linkedin dwaraka.com

PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience delivering actionable insights across finance and healthcare. Successfully automated data pipelines and developed dashboards that reduced reporting times by up to 40%, leveraging strong PL/SQL and Oracle expertise to enhance data integration. Proven track record in design solutions, story refinement, and risk mitigation through targeted proof of concepts. Adept at translating business requirements into robust, testable interfaces and guiding teams through agile delivery cycles. TECHNICAL SKILLS

• Data Analysis & Reporting: SQL, Python (Pandas/NumPy), Tableau, Power BI, Looker, Excel, Microsoft Office

• ETL & Data Warehousing: SSIS, Informatica, ADF, Snowflake, Teradata, Oracle, Oracle Exadata

• Cloud & Automation: AWS, Azure, GCP, Docker, Jenkins, Azure Functions

• Data Quality & Governance: Data Mapping, STTM, Data Dictionaries, DQ Checks

• Business Domains: Healthcare, Financial Services, Insurance, Pharma

• Visualization & Storytelling: KPI dashboards, drill-down reports, R visualizations

• Professional Competencies: Agile/Scrum, Analytical Thinking, Innovative Thinking WORK EXPERIENCE

McKesson Jul 2024 - Present

Senior Data Analyst Richmond, VA

• Orchestrated the integration of Salesforce and SAP into a centralized data warehouse and implemented robust test scenarios to ensure seamless interface integration, accelerating analytics processing by 35% and enhancing reporting for 100+ users.

• Automated multilingual text translation using Python NLP to address global reporting delays, enabling actionable insights across 5 regions.

• Led the creation of interactive supply chain KPI dashboards in Power BI with drill-through functionality, reducing manual tracking by 90% and achieving annual savings of $2M.

• Consolidated plant performance data using DAX measures in Power BI to enhance leadership visibility and support analytical story refinement for P&L analysis across 10+ regions.

• Designed COPQ and DPPM analysis dashboards in Power BI to uncover hidden quality issues, cutting defects by 15%. Markel Corporation Nov 2023 - Jun 2024

Senior Data Analyst Richmond, VA

• Migrated legacy reporting systems to Informatica ETL by designing solution integration approaches that eliminated inefficiencies and improved data processing speed by 25%.

• Authored Source-to-Target Mapping documents that clarified data lineage, ensuring 100% governance compliance and audit readiness.

• Created geo-coded Tableau dashboards with scorecards to provide underwriters with risk insights and assist in wholesale credit products assessment, reducing exposure by 18%.

• Resolved inconsistencies in 100M+ rows of financial data by writing SQL/PLSQL queries and conducting root-cause analysis, enhancing accuracy by 20%.

• Standardized data dictionaries and validation plans to strengthen enterprise-wide reporting reliability. Novartis Dec 2022 - Jul 2023

Data Analyst Hyderabad, India

• Designed prescriptive data models in Azure Boards & MS Dynamics by integrating design solutions that addressed operational inefficiencies, boosting decision-making speed by 30%.

• Automated Tableau dashboard refreshes to replace manual updates, ensuring consistent test scenarios for on-time report delivery.

• Built KPI scorecards in Tableau to track global program performance and support story refinement across 8 business units.

• Developed interactive dashboards to streamline executive reporting, reducing manual effort by 40 hours/month while supporting agile delivery cycles.

• Conducted stakeholder workshops to address low analytics adoption, driving widespread dashboard usage and facilitating work estimation discussions.

State Street Corporation Jun 2020 - Nov 2022

Data Analyst Hyderabad, India

• Created data marts and warehouses from scratch to meet previously unmet reporting needs, enabling faster risk analysis on $500M AUM portfolios and supporting an end-to-end view.

• Automated data workflows using Azure Data Factory and Logic Apps to replace manual jobs, cutting processing time by 50% and incorporating detailed test scenarios.

• Developed predictive risk models in SQL and Python, including PL/SQL scripts, to address exposure blind spots and reduce high-risk asset allocation by 12%.

• Delivered 15+ Power BI and Tableau dashboards to improve client reporting turnaround by 40% and contribute to story refinement sessions.

• Built SSIS packages and PL/SQL scripts to enforce business rules during ETL, achieving 99% data accuracy and facilitating agile work and effort estimation.

EDUCATION

Lindsey Wilson University Aug 2023 - May 2025

Master's, information technology

CERTIFICATION

• Microsoft Certified:Power BI Data Analyst Associate

• SQL and Relational Databases & Introduction toCloud courses:powered by IBM Developer Skills Network

Contact this candidate