Sahithi Nagireddy
Piscataway,NJ
Summary
Experienced Data Analyst and SQL Developer with 6+ years of expertise in data analysis, Data Warehouse design, and Business Intelligence applications. Proficient in the full Software Development Life Cycle (SDLC), adept at understanding business processes, gathering requirements, and conducting impactful risk assessments. Skilled in collaborating with stakeholders across diverse industries including health insurance, real estate, oil and gas, and retail. Proven ability in generating insightful reports and conducting rigorous data analysis, validation, and cleansing. Specialized in domain-specific GAP analysis, User Acceptance Testing (UAT), and system analysis. Possessing exceptional analytical, logical, and communication skills, with a proactive attitude towards learning and adapting to new challenges in varied industry domains.
Overview
8
8
years of professional experience
Work History
Data Analyst
Wellmark Inc
Des Moines, IA
03.2020 - Current
- Analyze structured and unstructured data sources, including enrollment and billing data, provider data, claims data, and HEDIS (Healthcare Effectiveness Data and Information Set) data.
- Review data for anomalies and gaps, ensuring accuracy and completeness.
- Transform data into actionable insights to support business decisions.
- Worked with technical and business peers on development efforts, including designing, analyzing, assessing, and reporting for Medicare Advantage Health Plan Project and Product Quoting Flexibility Project.
- Implement databases, data collection systems, and analytics strategies using SQL, Teradata, and other relevant technologies for reporting and analysis.
- Create and maintain source to target mapping documents(S2T), ensuring alignment with Wellmark dialect standards and data governance requirements.
- Execute functional test plans and validate test results.
Data Quality Analyst/SQL Developer
Beam Living
New York City, NY
02.2019 - Current
- Developed predictive models using historical property data and market indicators to forecast property values, rental yields, and market demand, enabling stakeholders to make informed decisions on property acquisitions, dispositions, and leasing strategies.
- Working with data investigation, discovery and mapping tools to scan every single data record from many sources on Lease, Person, Unit Data.
- Responsible for tasks regarding Data Governance and Data Quality Committee.
- Collaborated with cross-functional teams to document analytical workflows, data sources, and project deliverables using Confluence, ensuring transparency, knowledge sharing, and alignment on project objectives and milestones.
- Involves in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
- Facilitates in developing testing procedures, test cases and User Acceptance Testing (UAT).
Data Analyst
Chevron Oil and Gas Industry
Houston, TX
08.2018 - 01.2019
- Involved in understanding of Law IT management business processes and coordinated with business analysts to get specific user requirements and translated them to technical requirements.
- Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors
- Implemented end user requirements by creating stage variables and coding the business rule logic for transformations and rejections with a Business Rule stage.
- Extensive usage SQL developer for executing queries.
- Defined Simple and complex Data Quality rules based on the business requirements by using IBM Information Analyzer, Quality Stage.
- Experience with Information Analyzer column analysis, primary key & foreign key analysis, Publish Analysis result, define data rules definitions & Rule set to raise exceptions, understand and resolve logs.
Data Analyst
Abhinna Foundations
India
01.2016 - 11.2016
- Participated in requirement gathering session with team and sponsors to understand and document the requirements
- Worked on profiling source data to determine the key consistency, data type, size, etc
- Worked closely with ETL team in loading and mapping the data
- Created Source-to-target (S2T) mapping document as part of Data Analysis
- Designed tables for staging and integration layers
- Implemented the standard naming conventions
- Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers etc.)
- Dealt with different data sources ranging from flat files, Excel, and SQL Server
- Communicating with the project team throughout all stages of design, managing time effectively, and work on project timelines simultaneously in demanding deadline driven environment.
Education
Skills
- Data Modeling Tools: Erwin, Sparx Systems Enterprise
- ETL Tools: Microsoft SSIS, Data Stage and Quality Stage, Informatica
- Programming Languages: SQL, PL/SQL, HTML, XML, Basic Java,Python
- Database Tools: Microsoft SQL Server, MS Access, DBeaver, Teradata SQL Assistant
- Reporting Tools: SSRS, Excel Reporting, Tableau, Power BI and IBM Infosphere tools
- Workflow Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access, Jira, Confluence
Websites
Timeline
Data Analyst
Wellmark Inc
03.2020 - Current
Data Quality Analyst/SQL Developer
Beam Living
02.2019 - Current
Data Analyst
Chevron Oil and Gas Industry
08.2018 - 01.2019
Data Analyst
Abhinna Foundations
01.2016 - 11.2016
Similar Profiles
Cindy SappingfieldCindy Sappingfield
Senior Account Service Representative at Wellmark Blue Cross Blue Shield of South DakotaSenior Account Service Representative at Wellmark Blue Cross Blue Shield of South Dakota
Theodore CromwellTheodore Cromwell
Systems Architect at Wellmark Blue Cross and Blue Shield of IowaSystems Architect at Wellmark Blue Cross and Blue Shield of Iowa
Theresa KocerTheresa Kocer
Senior Account Manager at Wellmark Blue Cross And Blue Shield Of South DakotSenior Account Manager at Wellmark Blue Cross And Blue Shield Of South Dakot
Himani PatelHimani Patel
Clinical Physiotherapist at Holistica World Multispecialty HospitalClinical Physiotherapist at Holistica World Multispecialty Hospital
Heather CarboyHeather Carboy
Director, Client Development at InnovateMRDirector, Client Development at InnovateMR