Vamshi Reddy

Business Data Analyst @Cigna Healthcare

US

Working to create efficiencies in data reporting and analytics with automation where appropriate. Primary department tools to utilize are R or Python.• Preparing analysis plans and writing detailed specifications based on executive or stakeholder requirements.• Validating and troubleshoot discrepancies in data by creating and executing SQL queries in Teradata SQL and GCP.• Primary department platforms are Microsoft Excel, PowerPoint, Tableau, and PowerBI.• Interpret and analyze data from multiple sources including claims, provider, member, and encounters data. Identify and assess the business impact of trends. Extracted and cleaned data from EHR systems, including demographic, clinical, and medication data, to train the model.• Utilized SQL and Python to extract, clean, and analyze data from Electronic Health Records (EHR) systems, ensuring data integrity and compliance with HIPAA regulations.• Contributing to the planning and execution of large-scale projects with limited direction from leadership• Assisting in the design, testing, and implementation of process enhancements and identifying opportunities for automation.• Identifying and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers.• Reduced the time spent on generating reports by 60%, allowing the sales team to focus on strategy rather than data preparation.• Identify a previously overlooked customer segment that contributed to a 15% increase in sales within three months of implementing targeted marketing campaigns.• Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.• Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.

East Texas A&M University

Master's degree

Loyola Degree and PG College

Bachelor's degree