Data Analyst: SQL, Python, Power BI, Cloud Analytics

Sai Sathwika Guntupalli

+1-812-***-**** ***********************@*****.***

PROFESSIONAL SUMMARY

• Data Analyst with around 4 years of experience in data analysis, data engineering, business intelligence and cloud analytics.

• Expertise in SQL, Python, and Excel for data extraction, transformation and performance optimization to drive data driven decisions.

• Experienced in managing AWS and Azure analytics workflows including data ingestion, ETL orchestration, monitoring and alerting using services like S3, Athena, Redshift, RDS, CloudWatch, Azure Synapse, Data factory, Databricks.

• Adept at integrating on-premise and cloud data sources with Power BI to build scalable, automated dashboards for operational, financial, and KPI reporting.

• Expertise in using SQL Server Integration Services (SSIS) Packages for data migration and transformation aligned with complex business logic.

• Expert in building Power BI solutions including data modeling, DAX calculations, Power Query transformations, and visual storytelling to deliver impactful, decision-ready dashboards.

• Advanced proficiency in Excel analytics including Power Query, PivotTables, VBA Macros, and forecasting models for dynamic business reporting.

• Skilled in tracing data lineage and identifying the source of truth across complex pipelines to ensure accuracy and reliability in enterprise reporting.

• Applied Python based libraries for exploratory data analysis, trend detection, and predictive insights.

• Conducted data analysis using statistical methods, hypothesis testing, and data visualization to uncover actionable insights.

• Hands-on in Python (Numpy, Pandas, Matplotlib, Seaborn) for exploratory data analysis, predictive trend modeling, Automation and validation tasks.

• Worked on streamlining data processes, improving operational efficiency, and delivering actionable insights to stakeholders.

• Authored optimized SQL queries including dynamic queries, complex joins, and indexing strategies to improve data retrieval and reporting efficiency.

• Collaborated in Agile teams to deliver iterative BI enhancements, maintain documentation, and align solutions with stakeholder requirements.

• Recognized for strong analytical thinking, communication, and adaptability in fast-paced, cross functional project environments.

• Supported production releases and post-implementation validation of enterprise analytics platforms to ensure data integrity and performance stability.

CORE EXPERTISE

Data Analysis & Visualization Dashboarding & Reporting KPI Analysis Data Extraction Data Collection Data Cleansing & Transformation Data Modeling Data Governance & Quality Assurance Data Loading Data Migration Data Integration Story Telling Statistical Analysis SQL & Database Management Business Intelligence & KPI Reporting Root Cause Analysis (RCA) Project & Agile Collaboration ServiceNow Incident Management Problem and Change Management Trend & SLA analysis SOP Documentation SKILLS & TOOLS

Databases MySQL, PostgreSQL, Microsoft SQL Server Management Studio, Snowflake Languages Python (NumPy, Pandas, Matplotlib), SQL

Visualization & Flow

Diagrams

Power BI, Excel (Power Query, PivotTables, VLOOKUPs, XLOOKUPs, VBA, Macros), SSRS, MS Visio, Lucid Chart

Cloud Platform and Services AWS (S3, Lambda, Glue, DynamoDB, CloudTrail, CloudWatch, IAM, CloudFormation), Azure (Synapse, Data Factory, Power BI Service) ETL & Data Integration SSIS, Alteryx, AWS Glue, Azure Data Factory Methodologies SDLC, Agile, Scrum and Safe

Other tools Jira, Confluence, Smartsheet, ServiceNow, SharePoint, Git, Putty, Datadog, IRIS, Splunk

CERTIFICATIONS

Alteryx Foundational Micro- Credential

Python for Data Science – Issued by IBM

Data Science Foundations – Level 1 – Issued by IBM JIRA Fundamental Badge

Joining data in SQL – Issued by Data Camp

PROFESSIONAL EXPERIENCE

Data Analyst Percipient,LLC Indiana Jan 2025 – Present

• Translated complex datasets into actionable insights through dashboards and reports to drive strategic decisions.

• Leveraged SQL to connect databases with Power BI; implemented Power Query transformations to reduce data processing time by 60%.

• Led secure data migration initiatives, including data cleansing and transformation for accurate data transfer across on-prem and AWS cloud environments.

• Created complex SQL queries to analyze clinical and administrative data and generate insightful, actionable reports.

• Built interactive Power BI dashboards to track policy lifecycle KPIs such as creation, revision, approvals, assessments, and expirations.

• Monitored system performance and user feedback to identify improvement areas and optimize platform functionality.

• Applied SQL performance tuning to optimize query execution times and improve reporting efficiency.

• Collaborated with Product and QA teams during Agile sprints to prioritize data needs aligned with healthcare compliance milestones.

• Applied Power BI best practices with Power Query and DAX to build scalable reports and dashboards.

• Performed ad-hoc analysis to address business questions and deliver insights that improved operational efficiency and reduced costs.

• Managed AWS S3 and Glue datasets with automated triggers via EventBridge and Lambda, real-time monitoring and alerts through CloudWatch and SNS.

• Built dynamic Excel models for performance tracking, forecasting, and scenario analysis.

• Created stakeholder-facing PowerPoint presentations to communicate key insights, trends, and data-driven recommendations.

• Documented business requirements, data workflows, and dashboard logic to support cross-functional collaboration and knowledge transfer.

• Designed Excel templates with power query and pivot tables to streamline repetitive reporting tasks.

• Maintained detailed project documentation including SOPs and change logs to support audit and Knowledge sharing.

Payments Analyst BSol Consultants (Henry Ford Health) India Apr2023 – Jul 2024

• Utilized Python and SQL for data cleaning, transformation in high-volume payment datasets.

• Extracted and transformed multi-source payment data using SQL for KPI tracking, trend analysis, and RCA.

• Designed, developed, and maintained Power BI dashboards, reports, and data stories for enhanced decision-making.

• Analyzed card transactions from multiple processors to identify trends in approvals, declines, chargebacks, and settlements.

• Built interactive Power BI dashboards visualizing payment lifecycle stages including authorization, clearing, settlement, and reconciliation.

• Performed trend and cohort analysis on chargebacks, returns, and disputes to deliver actionable insights for the risk team.

• Performed exploratory data analysis to identify trends, summarize business problems, and present compelling data stories to executives.

• Executed data lineage mapping and audit trails for financial compliance validation.

• Exported processed data and reports in CSV for audits, analysis, and cross-functional sharing.

• Participated in Agile ceremonies across the SDLC lifecycle, including sprint planning, standups, and retrospectives.

• Collaborated with data engineers to validate pipelines, ensure schema accuracy, and track data lineage.

• Documented analytics workflows, RCA findings, and project deliverables in Confluence and SharePoint.

• Translated client specifications into clear documentation for reporting and analytics requirements.

• Logged and tracked data issues in ServiceNow, ensuring timely resolution and SLA adherence. Systems Engineer Seaone Software Pvt.ltd India Jan 2022 – Mar 2023

• Investigated policy and claims-related batch job failures using SQL, retrieving and analyzing data to identify data issues and system errors.

• Performed data cleaning and validation on extracted records to support accurate root cause analysis and prevent recurring batch job failures.

• Monitored and validated daily batch jobs related to policy issuance, renewals, and claims processing; escalated failures and coordinated with technical teams for resolution.

• Built and maintained Datadog dashboards to monitor batch job health using metrics.

• Defined key performance indicators (KPIs) aligned with organizational goals and built monitoring frameworks to track progress against those metrics.

• Configured IRIS alerts to notify stakeholders in real-time about failures or performance deviations in production batch processes.

• Participated in ECC (Enterprise Command Center)/Bridge calls to document incident details, RCA

(Root Cause Analysis), impact, and resolution steps; maintained records in Confluence and ECC tracker.

• Created dynamic reports and dashboards in Excel and Google Sheets, incorporating advanced functions such as Pivot Tables, VLOOKUPs, Macros, and VBA to support key business decisions.

• Assigned tickets within the team upon ECC issue allocation; ensured timely acknowledgment, resolution, and communication with stakeholders.

• Utilized Git for version control and Jira for project management, ensuring efficient collaboration, task tracking, and timely project completion.

• Authored and maintained SOPs, knowledge base articles, and process guides in SharePoint and Confluence to ensure seamless knowledge transfer.

• Used ServiceNow to log, assign, and track incidents and enhancement requests, ensured end-to-end issue management and closure.

• Liaised with business stakeholders and QA teams to validate requirements and support user acceptance testing (UAT) cycles.

EDUCATION

University of North Texas Denton, TX, USA

Masters in Computer Science

Contact this candidate