Microsoft Certified Data Analyst

ROHITH N
C: (628) 261-4914 | E: rohithnagarjuna001@[Link]

Professional Summary
Experienced Data Analyst with 9+ years in designing, developing, and supporting enterprise data
warehouse and BI solutions. Skilled in Power BI, Tableau, SQL, Splunk and Kafka for scalable data
streaming and real-time analytics. Proven track record in end-to-end process optimization, cloud-native
data warehousing, and delivering actionable insights using Amazon RDS, AWS Glue, and modern ETL
pipelines. Excellent communicator with a track record of collaborating with stakeholders to translate
business requirements into scalable data solutions.
Awarded "Best Innovation" at the Kansas Data Science Consortium 2024 for presentation of
capstone project that optimized nonprofit membership models of “Lawrence Arts Centre, Kansas City”
using advanced analytics

Professional Summary:
 Data professional with 9+ years of experience in data analysis, database design using SQL, and Python
programming, with hands-on work in BI tools like Power BI and cloud services like Azure data factory
and AWS.
 Developed and enforced enterprise-wide data governance policies, ensuring consistent standards for
data ownership, classification, and usage.
 Collaborated with business and IT stakeholders to establish a data stewardship framework, assigning
clear ownership and accountability for critical data domains.
 Led roll-out of BCBS 239 compliance controls, documenting data flows and controls to meet regulatory
reporting standards.
 Collaborated with business analysts, data engineers, and stakeholders to gather and understand data
requirements for reporting and analysis.
 Ability to work both independently and in cross-functional teams with strong communication and
leadership skills.
 Skilled at turning complex data into clear, actionable insights through compelling dashboards and
visualizations using Power BI, Tableau, and Python.
 Extensive experience developing interactive reports and dashboards in Power BI, Tableau, and SSRS for
business and compliance reporting.
 Good understanding of ETL processes and cloud storage, with hands-on experience building data
pipelines using AWS Glue enabling seamless data ingestion, transformation, and processing to support
analytics and decision-making across industries and managing data in S3.
 Skilled in Power BI for building advanced dashboards and performing data analysis, with a solid
understanding of DAX for custom measures, calculated columns and business logic.
 Experience using M language in Power Query for data transformation and cleaning tasks within Power
BI.
 Experienced in connecting Power BI and Tableau to various data sources, including AWS services like
Redshift, Athena, and S3, as well as SQL-based databases.
 Managed and analyzed large datasets using SQL to support business strategies and data-driven
decision-making.
 Skilled in writing and optimizing SQL queries for performance across SQL Server (T-SQL), MySQL, and
PostgreSQL.
 Strong T-SQL development skills, including writing complex queries and designing relational schemas
with primary and foreign key constraints.
 Conducted exploratory data analysis (EDA) in Python to uncover trends and insights that supported
strategic decision-making and improved product development and investment planning.
 Performed statistical analysis and financial modeling using Python to calculate key metrics for risk
evaluation, policy efficiency, and asset management.

Technical Skills:
Languages: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, R, DAX, M-Query
Analytics & Reporting: Tableau, PowerBI, SSRS
Databases & ETL: MySQL, MS SQL Server, AWS (S3, Glue, Athena), Amazon RDS, Azure Synapse
Analytics, Kafka, SSIS
Microsoft Certified Data Analyst
Tools: Advanced MS Excel (Pivot tables, Power Query, Macros, Lookups), MS PowerPoint, PowerShell, SAP
(PP, MM, QM)
Version Control: Git, GitHub

Professional Experience:
American Express, AZ
Sr. Data Analyst
Aug 2024 – Till Date
Responsibilities:
 Designed and developed end-to-end ETL solutions using Microsoft SSIS, extracting and transforming
data from SQL Server, flat files, and APIs into staging and data warehouse environments, increasing
data pipeline efficiency by 30%.
 Built robust SSIS packages to transfer and transform data across source systems, staging areas, and
operational data stores (ODS), supporting critical FP&A reporting workflows.
 Created complex SQL Server stored procedures, functions, and views to support ETL processes and
business logic implementation, enabling cleaner and faster data transformations.
 Imported and integrated structured and semi-structured data using SSIS, automating recurring data
loads from external sources (CSV, Excel, FTP) into SQL Server, improving reporting timeliness.
 Debugged and optimized SSIS workflows to minimize run-time latency and improve accuracy, resulting
in a 40% reduction in data processing time.
 Developed SSIS templates and reusable control flow components, accelerating onboarding of new data
sources and standardizing ETL best practices across projects.
 Tested and validated ETL processes for both production and non-production environments, including
unit testing, UAT, and load testing to ensure accuracy and performance under scale.
 Authored comprehensive documentation for SSIS packages, covering design logic, deployment steps,
and troubleshooting guides to support operational handover and audits.
 Created dynamic SQL views and joins across financial, customer, and operational datasets, supporting
compliance monitoring and executive reporting with a 20% improvement in data reliability.
 Performed exploratory data analysis (EDA) using Python and R to uncover trends influencing pricing,
risk, and customer behavior, enriching financial models and planning forecasts.
 Led Power BI dashboard standardization initiatives, replacing legacy reporting tools to unify financial
and operational reporting, enhancing decision-making across departments.
 Implemented Row-Level Security (RLS) and role-based access in Power BI to maintain data
confidentiality and support audit readiness.
 Facilitated end-user training and documentation for FP&A teams, improving adoption of self-service BI
and reducing reliance on ad hoc reporting by 35%.
 Managed GitHub repositories for ETL and reporting code, enabling version control, code reviews, and
seamless collaboration with cross-functional teams.

CVS Health, Hartford, Connecticut

Role: Sr. Data Analyst Dec
2023 – Aug 2024
Responsibilities:
 Built and optimized ETL workflows in Azure Data Factory to ingest and process high-volume healthcare
data, ensuring compliance with data governance and security standards.
 Utilized Python libraries like Pandas and NumPy for advanced data manipulation of complex data and
used Seaborn/Matplotlib to visualize trends for internal reporting on patient engagement and cost
patterns.
 Supported secure API integration in Python to access real-time provider, formulary, and drug pricing
data, ensuring enriched and up-to-date analytical datasets for care management teams.
 Wrote advanced SQL queries and Python scripts to handle ad hoc requests across benefits,
reimbursements, and enrollment systems, reducing manual reporting tasks and increasing data
accuracy.
 Designed and deployed dynamic Power BI dashboards to monitor real-time metrics related to claims
volume, operational performance, and prescription adherence, empowering pharmacy operations and
Microsoft Certified Data Analyst
strategy teams.
 Leveraged Splunk dashboards to monitor ETL failures, API latency, and system anomalies, enabling
proactive resolution and improved SLA compliance.
 Optimized end-to-end claims ingestion and processing workflows, resulting in a 25% reduction in data
delivery time and improved stakeholder visibility.
 Integrated Kafka-based streaming pipeline to support ingestion of real-time healthcare and claim event
data, improving timeliness of analytics.
 Applied advanced DAX expressions in Power BI to support forecasting, patient segmentation, and plan
performance tracking for Medicare and commercial health plans.
 Configured Power Query and Dataflows to consolidate data from cloud-based EMRs and on-premises
claim processing systems into a unified analytics layer.
 Built scalable ETL workflows in AWS Glue to ingest and process high-volume data from S3 and Redshift,
transforming pharmacy and care coordination datasets into analytics-ready formats.
 Scheduled and monitored Glue job runs to ensure timely updates of dashboards for executive
reporting, compliance tracking, and audit readiness.
 Led Power BI adoption by conducting in-house training sessions, empowering teams to explore data
independently and responsibly.
 Maintained well-documented Python code repositories in GitHub to support collaborative development
and reproducibility across teams.
 Managed version control for ETL workflows and reporting assets, ensuring traceability and consistent
delivery across environments.
 Used GitHub issues and pull requests to coordinate enhancements and troubleshoot bugs, improving
development cycles and code quality.

Dun & Bradstreet, NJ

Data Analyst
May 2023 – Nov 2023
Responsibilities:
 Developed Tableau dashboards for senior leadership to track real-time operational KPIs across client
accounts, using live connections to Amazon RDS.
 Built Kafka pipelines to stream customer interaction data into Amazon RDS, enabling near real-time
reporting in Tableau and Power BI.
 Standardized Tableau reporting templates across B2B teams to drive consistency in client health
monitoring and resolution workflows.
 Built interactive visualizations including bar charts, heat maps, line graphs, KPIs, and geo-maps,
enabling self-service analytics with intuitive filters and slicers.
 Implemented Row-Level Security (RLS) to protect sensitive client and financial information, ensuring
controlled access by user roles and business units.
 Conducted internal enablement sessions to train analysts and stakeholders on dashboard features,
significantly increasing usage and reducing dependency on manual reports.
 Maintained detailed documentation for semantic models, DAX logic, data lineage, and report access
protocols to support audit readiness and long-term scalability.
 Resulted in a 30% reduction in customer issue resolution time and improved satisfaction scores
through faster, data-informed responses and operational visibility.

TechnipFMC
Data Analyst
Jun 2017 – Jul 2022
Responsibilities:
 Developed and maintained Power BI dashboards tracking global supplier metrics (FPY, OTD, TAT),
leading to a 15% improvement in supplier performance and a 30% increase in first-pass yield.
 Developed and automated reporting pipelines integrating SharePoint and Power BI, reducing manual
reporting time by 40% and ensuring consistent accuracy across global supplier KPIs.
 Performed statistical root cause analysis on FPY data across four global regions; implemented
corrective actions that reduced non-conformance rates by 25%.
 Built reusable, performance-optimized SQL queries for extracting monthly compliance reports from
large SAP datasets, reducing report generation time by 35%.
 Created parameterized SQL views and custom joins to support ad hoc reporting needs across regions,
Microsoft Certified Data Analyst
improving agility of analytics responses by 40%.
 Partnered with supplier quality engineers and product owners to deliver trend-based Power BI reports,
leading to a 10% improvement in approval turnaround time.
 Delivered monthly presentations and quarterly review decks using PowerPoint and Power BI, providing
leadership with actionable insights that influenced compliance initiatives.

Monarch Ergo
Data Analyst
Jun 2016 – Jun 2017
 Designed a dynamic Excel-based costing template to streamline repetitive pricing calculations,
reducing manual entry errors by 25% and speeding up quotation workflows by 30%.
 Consolidated project data from multiple Excel sources into standardized dashboards using pivot tables,
conditional formatting, macros and lookup formulas, enabling faster weekly status reporting.
 Collaborated with production, finance, and QA teams to translate project tracking needs into executive-
friendly Excel presentations, delivering insights that influenced resource planning and reduced
turnaround times by 15%.

Education
Wichita State University, Wichita
Master of Science in Data Science
Relevant Coursework: Statistics, Machine Learning, Data Mining, Object Oriented Programming,
Business Intelligence.

Osmania University, Hyderabad, India

Bachelor of Engineering in Mechanical Engineering