Data Analyst Power Bi

Maheswari Pulagam

+1-316-***-**** *******************@*****.***

PROFESSIONAL SUMMARY

Data Analyst/Business Analyst with 4+ years of hands-on experience building and operating end-to-end analytics solutions and translating data into actionable business decisions. Optimized T-SQL workloads and designed automated ETL pipelines (SSIS, Python) that reduced report runtimes by up to 70% and eliminated over 20 hours of manual effort per month. Developed and maintained Power BI and Tableau dashboards that surfaced key performance indicators, anomalies, and trends—enabling clinical, operational, and marketing stakeholders to make faster, more informed decisions. Experienced in capturing and documenting business requirements, defining KPIs, conducting root-cause analysis, and driving process improvements in Agile environments using JIRA and Confluence. Hands-on with cloud data platforms (Azure, AWS) to support scalable, compliant reporting workflows in regulated industries such as healthcare and high-volume e-commerce. Passionate about data storytelling, data quality, and ensuring analytics are trusted and operationalized.

TECHNICAL SKILLS

Data Analysis & Programming: T-SQL (SQL Server), SQL, Python (pandas, NumPy), R Visualization & Reporting: Power BI, Tableau, SSRS, Excel (Power Pivot, PivotTables, advanced formulas, VBA Macros) Data Warehousing & Modeling: Data modeling (fact & dimension tables, star/snowflake schemas), data warehousing concepts, Azure Synapse, AWS Redshift

ETL & Data Engineering: SSIS, Python scripting for ETL automation, incremental loads/change data capture, data cleansing and reconciliation

Cloud Platforms: Azure (Data Factory, Synapse, SQL Database), AWS (Redshift, Glue, S3) Data Quality & Governance: Data validation, lineage, documentation, compliance awareness (healthcare/claims data) Collaboration & Tools: Git, JIRA, Confluence, SSMS Databases: Microsoft SQL Server, Oracle

Domain Expertise: Healthcare analytics (claims, provider, membership), operational & performance reporting, e- commerce metrics

WORK EXPERIENCE

Data Analyst CVS Health Nov 2024 – Present

• Built and deployed Power BI dashboards using DAX, Power Query, and SQL to deliver insights across supply chain and marketing functions; defined KPIs and data visualizations that informed strategic decisions.

• Led requirements gathering sessions with business and clinical stakeholders, documented functional specifications in Confluence, and translated business needs into technical data solutions.

• Improved legacy Excel reporting by 40% by migrating to optimized Power BI dashboards with automated refreshes through Power BI Gateway, reducing manual intervention and increasing timeliness.

• Created dynamic calculated columns and measures in DAX, cutting manual reporting effort by 30% while improving accuracy and consistency.

• Designed, scheduled, and maintained SSIS jobs to extract, clean, and transform large datasets; enabled daily/weekly refreshes of warehouse tables supporting decision-making.

• Integrated data from diverse sources (SQL Server, SAP BW, Azure SQL, Oracle) into centralized reporting and published dashboards to Power BI Service.

• Conducted Python-based analyses (pandas, seaborn) to uncover web traffic and customer trends, supported insights that contributed to a 25% increase in traffic and 20% uplift in online conversions

• Collaborated within Agile teams using JIRA for sprint tracking, issue resolution, and release coordination; performed root-cause analysis on pipeline failures to improve reliability.

• Developed SSRS reports (tabular, matrix, drilldown) using stored procedures and sub-reports for regular business distribution.

ETL/SQL Developer JPMorgan Chase & Co. Dec 2023 - Nov 2024

• Developed end-to-end ETL workflows using Informatica PowerCenter and SSIS, consolidating data from flat files, Oracle, and SQL Server into a centralized Sales Data Warehouse.

• Translated complex business logic into efficient mappings with reusable components (lookups, joins, aggregators), reducing mapping errors by 15–20%.

• Automated data loads with SQL Server Agent Jobs, cutting manual execution time by 30–35% and ensuring timely availability of analytics-ready data.

• Built scalable data models and supported both batch and near real-time ingestion from 5+ source systems into Teradata and Netezza; implemented FastLoad/MultiLoad and BTEQ scripts to increase throughput by 25–30%.

• Designed and published SSRS drill-down and ad-hoc reports, accelerating report delivery by 40%.

• Optimized T-SQL queries and stored procedures to enhance performance by 20–25%; maintained metadata and mapping standards to improve audit compliance and reduce rework.

• Tuned ETL performance using SQL Profiler, improving daily job success rates by 10–12%; collaborated with QA and dev teams to streamline releases and improve stability. SQL Server Developer Wipro Aug 2020 – Dec 2022

• Developed complex T-SQL stored procedures and views supporting enterprise reporting; reduced manual data preparation by 30%.

• Built and maintained SSIS packages for data ingestion, transformation, and migration from multiple sources; implemented automated FTP-based transfers, improving staging reliability by 25%.

• Designed and maintained data warehouse models (star and snowflake schemas) to ensure optimized query performance.

• Created interactive, subscription-enabled SSRS reports in multiple formats (Excel, PDF, web) for regular distribution.

• Implemented OLAP cubes and data mining models for analytical insight generation; used Erwin for dimensional consistency across datasets.

• Tuned SQL queries using joins, CTEs, and temp tables to improve performance by 20–25%; managed cross- version data integration between SQL Server environments to support seamless reporting.

• Partnered with business users to deliver ad-hoc insights, shortening report request turnaround by 40%. CERTIFICATIONS

• Career Essentials in Data Analysis by Microsoft and LinkedIn

• Data Analytics Essentials by Cisco

EDUCATION

• Master's in computer science, University of Central Missouri.

Contact this candidate