Data Analyst Power Bi

Sudheer Kumar Reddy Yeruva

Data Analyst

https://www.linkedin.com/in/sudheer-kumar-reddy-yeruva/

+1-901-***-**** ************************@*****.*** USA Summary

• Strategic and analytical Data Analyst with 5 years of cross-functional expertise in Insurance, Property & Casualty, and Reinsurance domains. Architected advanced data solutions, automated ETL pipelines, and deployed cutting-edge reporting frameworks to enable actionable insights, operational excellence, and compliance with global data governance standards.

• Enhanced enterprise reporting ecosystems by integrating cloud data platforms (AWS Redshift, Azure Synapse, GCP BigQuery), driving faster analytics and scalability.

• Data analysis, data management, and business intelligence software. Skilled in relational database concepts, SQL, ETL, and VBA.

• Standardized ETL workflows and implemented automation frameworks, reducing manual intervention and improving data pipeline reliability by 35%

• Pioneered advanced statistical models and forecasting techniques using Python/R, enabling proactive risk assessment and trend analysis. Skill in data reconciliation, financial reporting, data transformation, and advanced Microsoft Excel.

• Strengthened compliance posture by embedding audit-ready controls and lineage tracking into enterprise data processes.

• Consolidated multi-source data streams into unified data marts, improving accessibility and accelerating decision-making cycles

• Directed large-scale data migrations from SAP ECC & Legacy systems into SAP BW, accelerating BI adoption and operational efficiency.

Skills

• Reporting & Visualization : Power BI, Tableau, QlikView, Crystal Reports, SQL Server Reporting Services (SSRS), Cognos

• ETL & Data Integration : Informatica, SQL Server Management Studio (SSMS), SAP BODS, Composite Studio, AWS Glue

• Data Analysis & ML Libraries : SQL, Python (Pandas, NumPy), R, Apache Spark, Financial Analytics, RapidMiner, Java

• Databases & Data Management : SQL, Python (Pandas, NumPy, Matplotlib), VBA Macros

• Cloud Platforms: AWS (S3, Glue, Redshift), Microsoft Azure, Google Cloud Platform (GCP)

• Programming & Scripting: SQL, JavaScript, UML, Gherkin, Python, R, Spring Boot, PostgreSQL, JPA, Hibernate, React.js.

• Testing & Monitoring Tools: HP ALM/Quality Center, Splunk, Power BI, Tableau, QlikView

• Project Management & Agile Tools: JIRA, MS Project, Scrum, Kanban

• Operating Systems: Windows (NT/2000/XP/7/10), UNIX, Linux

• Productivity & Other Tools: Advanced Excel, Jupyter Notebook, Power Query, Power Pivot, Power Maps

• Cloud & Data Platforms: AWS (S3, Glue, Redshift), MS Azure, GCP, Snowflake, Databricks, Azure Synapse, Google Big Query

• Business Analytics: Tableau, Power BI, SQL Server Reporting Services (SSRS), Excel (Pivot Tables, Power Query, VBA) Experience

CLIENT:- USAA, San Antonio, TX Jan 2023 – Present

Data Analyst

• Upgraded the existing insurance portal into a modern E-Service platform, enhancing self-service capabilities for policyholders and new customers.

• Spearheaded large-scale data migration from on-premise databases to AWS Redshift, RDS, and S3, ensuring scalability, high availability, and reduced infrastructure costs..

• Architected and automated ETL pipelines using Informatica, SSIS, and Python to extract, transform, and load Guidewire (Policy, Billing, Claims) data into the enterprise data warehouse.

• Developed and deployed real-time and ad-hoc reports in Power BI and SSRS, with advanced drill-through, matrix, and KPI dashboards for business stakeholders.

• Engineered predictive analytics models in Python and automated reporting workflows, reducing manual effort by 40% and accelerating delivery cycles.

• Integrated data from multi-source systems (Guidewire, Oracle, Google Analytics) for 360-degree customer analysis, A/B testing, and campaign performance tracking.

• Instituted data quality frameworks and implemented data governance practices, improving accuracy, consistency, and compliance with SOX/GDPR. Enhanced Guidewire data marts for Policy Center, Billing Center, and Claim Center, customizing them for businessspecific reporting requirements.

• Optimized SQL and Spark queries to improve performance in large-scale data profiling, cleansing, and anomaly detection.

• Collaborated with cross-functional teams (QA, business users, marketing, IT) to perform integration, regression, and UAT testing, achieving timely sign-off.

• Automated data visualization workflows using Power BI, Python, and Matplotlib, accelerating KPI delivery and operational insights.

• Designed KPI frameworks to monitor policy processing, claims management, and reinsurance performance, directly supporting executive decision-making.

• Strengthened customer engagement analytics by integrating Google Analytics with business data sources, providing actionable insights on user journeys and conversions.

• Provided SME guidance on Data Governance and Data Quality management, driving continuous process improvement initiatives. CLIENT:- Infosys, India May 2020 – Jul 2022

Data Analyst

• Developed a Salesforce CRM-driven Decision Support System enabling Risk Management teams, Actuaries, and Analysts to perform geo-spatial risk analysis across multiple lines of business (Life Insurance, P&C Insurance, Reinsurance). The solution enhanced policy pricing, underwriting, risk exposure management, catastrophe planning, and reinsurance strategies, providing a competitive advantage in financial resilience and operational efficiency.

• Collaborated with project managers to design and maintain project schedules, milestones, and deliverables using MS Project and facilitated requirement workshops. Architected business process workflows with MS Visio, bridging communication gaps between business and technical teams.

• Authored and maintained Business Requirement Documents (BRD), Functional Specifications (FRS), and Requirement Traceability Matrix (RTM), ensuring alignment of user stories with system functionality.

• Engineered advanced Tableau dashboards and SSRS reports, integrating data blending, parameters, quick filters, and KPI scorecards to drive actionable insights. Optimized existing Tableau reports and integrated new business data points to streamline workflows, enhance decision-making, and improve reporting accuracy.

• Preprocessed and cleansed large datasets using Python and R, reducing data processing time by 30% and ensuring high-quality inputs for predictive models.

• Developed machine learning models (Decision Trees, Clustering) and visualized outcomes via Tableau for business strategy alignment. Automated ETL pipelines using SSIS and Autosys, including scheduling, archiving, and transaction logging, to enable seamless batch processing.

• Designed and deployed OLAP Cubes (SSAS) and Star Schema models, enabling multidimensional reporting and performancedriven analysis

• Integrated Google Analytics data with Tableau and Excel, providing comprehensive visibility into customer behavior, conversion trends, and engagement metrics.

• Enhanced data governance practices by documenting Data Dictionaries, Metadata, and Data Mapping artifacts, improving system reliability. Directed infrastructure coordination with legacy systems to ensure smooth data extraction and transformation for ETL processes.

• Championed KPI frameworks and corporate scorecards to monitor profitability, underwriting performance, and financial resilience. Utilized Excel (Power Query, Pivot Tables, VBA Macros) to automate reconciliation and ad-hoc financial reporting, reducing manual effort

• Partnered with QA teams to design and execute test plans, test cases, and scenarios, ensuring system validation and defect-free deployments.

Education

Master's in Information Systems

Christian Brothers University, TN -2024

projects

Part Pro Management System:

• Developed a website for managing and selling auto parts online using Java, Spring Boot, MySQL, JPA, Hibernate, Tomcat, React, Redux, JavaScript, JUnit, Azure, Docker.

• Created a responsive and user-friendly frontend interface with React JS, HTML, and Bootstrap, ensuring a smooth user experience across different devices

Home Insurance Management System (HIMS):

• Spearheaded the UI design and development for the policyholder module in the Home Insurance Management System using Java 8, Spring Boot, PostgreSQL, JPA, Hibernate, React.js. Certification

Power BI Certified ETL in Python & SQL Fundamentals of Azure AI Document Intelligence.

Contact this candidate