 Technical and Functional Requirements Review: Conducted detailed reviews and meetings to clarify and explain technical specifications for customized software solutions to team members and customers. Business Requirements Evaluation: Assessed functional and business requirements while supporting functional and acceptance testing to ensure alignment with project goals. ETL Processes: Cleaned, aggregated, and enriched data using ETL tools, implementing business rules and data validation logic, and loading processed data into data warehouses and data lakes. Cross-Functional Collaboration: Worked closely with cross-functional teams to understand data needs, ensuring consistency and accuracy across platforms. Agile Methodologies: Participated in User Story Refinement, Sprint Planning, Retrospectives, and Reviews, collaborating with Product Owners, Scrum Masters, and stakeholders to develop user stories and maintain a backlog. ETL Solutions Analysis: Conducted analyses to recommend optimal ETL technologies, collaborating with experts to troubleshoot configurations and identify issues. Business Intelligence Design: Carried out complex functional requirements analysis and system design using business intelligence methodologies. Architectural Design: Designed high-performance, secure cloud-based solutions using modeling, iterative prototyping, and quantitative assessment methods. Governance and Development: Utilized knowledge of operations and governance frameworks to gather technical data for ETL application customizations. Documentation and Feedback: Oversaw the analysis, estimation, design, development, and review processes, ensuring thorough documentation (including technical design documents and user manuals) and scheduling feedback sessions with stakeholders. Tool and Technology Identification: Identified appropriate tools and technologies for application development, focusing on reusable components tailored for client applications

• Developed complex mappings using Informatica PC and IDQ. Reviewed the TBA requirements to understand how the system will operate ongoing. also created reports using multiple parameters and rule sets for the relational table. • Throughout the process, I continuously deployed and documented different releases. • The Data Conversion Service Data Analyst Advance (DCS DAA) ensures data quality and integrity throughout the data conversion process for the Total Benefits Administration (TBA) database, covering analysis, testing, reconciliation, and documentation. Owned the creation of custom Informatica edits and defined reconciliation strategies. Analyzed client raw data, reviewed profiling reports, identified root causes, and suggested fixes. Coordinated with teams to track load errors and performed GUI-based data verification. Assisted with root cause analysis, post-live data cleanup, and data cleansing efforts.

Extracted, transformed, and loaded data from legacy systems using ETL tools like Informatica and SSIS. Applied business rules and ensured data quality through validation and reconciliation. Optimized ETL performance, handled batch processing, and performed root cause analysis for discrepancies. Collaborated with cross-functional teams to ensure data integrity and successful migration. Provided post-migration support for data cleanup and ensured compliance with security protocols

My Roles and Responsibilities:• Performing ETL testing and Database Testing.• Preparing traceability matrix• Understanding requirement and then identifying scenarios• Analyzing the critical production issues.• Track build and Release details.• Identified, Reported and Tracked Defects using JIRA/Redmine test management tool.• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the Oracle supporting tables.• Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.• Performed End-to-End testing of database to check data integrity using SQL queries.