SRUTHI RAVI

• Tracking all the assigned projects and coordinating with team members to complete assigned tasks.
• Analysis of business requirements and mapping document to determine the functionality of the ETL processes.
• Responsible for generating test reports.
• Responsible for analyzing the Test Objectives and Test Plan and Test Data for the projects.
• Responsible for preparing the Test Plan and the Test Data, and working with the data team to get the required data.
• Responsible for updating the project team on the progress and letting the team know if there are any setbacks to meet the timeline for the project.
• Wrote several test cases for analyzing and validating data between source and target databases.
• Involved in reviewing the test results with product owners.
• Involved in validating the replication while testing the ETL loads.
• Performed requirements engineering and involved in requirements traceability within software development and systems engineering.
• Prepared several documentation on the everyday jobs and loads that are helpful for knowledge transfer and cross training within the teams.
• Extensively supported Production Monthly close in terms of reconciliation, involved in supporting Auditors in terms of reconciliation, and providing walkthroughs.
• Worked on Autosys, Oozie for batch processing ETL, PL/SQL subprograms, and performed backend testing.
• Worked on Stonebranch Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries with required Transformation logic for data validation and data verification on the database.
• Identified requirement and code gaps to reduce business risk ahead.
• Documented all errors/defects identified and implemented their resolutions as defined by management.
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Tested the ETL process for both before data validation and after data validation process.
• Wrote the Insert, Update, Delete, and Error Processing test cases in all the stages.
• Imported/exported large amounts of data from files to Oracle, and vice versa.
• Interacted with the business to discuss various data validations and data conversion rules.
• Led the complete testing activity for moving the Membership-Group Eligibility, Wellness, Care Management.
• Lab, Provider, and Clinical data from legacy into different Databases such as Postgres, Redshift, Dataricks, and successfully completed Production Migration and transition.
• Validated and fixed mapping errors, ensuring successful data transformation.
• Implemented advanced SQL query scripting to validate the complex transformation logic and produce the data for each LOB for analytical purposes.
• Ensuring data availability to end-users/Stakeholders as per the expectations and to downstream reports.
• Debugging and understanding of UNIX commands ,basic scala code,JSON and XML files

• Responsible for coordinating with team for analyzing the requirements, creating test documents, test execution, defect reporting and assisting UAT team.
• Analysis of business requirements and mapping document to determine the functionality of the ETL processes.
• Responsible for analyzing the Test Objectives and Test Plan and Test Data for the projects.
• Responsible for preparing Test Plan and the Test Data and work with the data team to get the required data.
• Responsible for updating the project team on the progress and letting the team know if there are any setbacks to meet the timeline for the project.
• Experience in writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL) as well as AWS Redshift data warehouse.
• Involved in loading csv,parquet,text file,fixed width files to Hadoop system to validate the source data.
• Extensively involved in business operation testing, User Acceptance testing (UAT), end-to-end Integration and Regression testing.
• Verified and validated ETL logs and reject/discard files for errors and reported them to development team.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.
• Tested ETL mappings that transfer data from legacy systems to Hadoop Environment
• Involved in meetings with onshore counterparts, testing team, and DWH Lead to plan and implement the testing efforts.
• Worked on Data Verifications and Validations to evaluate whether the data generated according to the requirements is appropriate and consistent.
• End to end Validation for data in target system against the source system to check for data consistency and accuracy and merged data from multiple sources.
• Worked closely with stakeholders to understand the business requirements, data and data sources.
• Worked on ETL Tools like Teradata,Netezza,sql server and job scheduling tool Autosys.
• Documented all errors/defects identified and implemented their resolutions as defined by management.
• Perform the Sqoop operation to import the data from upstream servers Like sql server, Oracle, Netezza and Teradata

Data Validation on Oracle Fusion Application for Various services provided to ensure the data is consistent from source till Reporting

• Performing batch processing to import the front end to reflect the same in DB (SQL server).
• Validations based on various scenarios based on the required given.
• Written SQL's based on scenarios to be tested and executing the test case successfully
• Worked on Oracle Reporting tool (OBIEE) to ensure the data flow from Fusion UI to Database to Reporting is in sync.
• Involved in the phase of requirement analysis and worked on Requirement Traceability Matrix.
• Worked on Defect Management, Test planning, and Release Management activities.