Kumar Surendra Email & Phone Number

Project Description Modules: NYPAL (New York PAL) & LACA (Life Agency of Canada)The scope of the project is to migration the existing NYPAL & LACA data from Studio System to CI and PD Systems. My Responsibilities:• Established the business analysis methodology using Iterative model of SDLC.• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.• Responsible for Data Mapping testing by writing SQL Queries.• Involved in Delta load testing and compare source and target data.• Involved in GAP Analysis as per requirements and communicate with our BA on finding GAP Issues.• Arranged meetings with business customers in better understanding the reports by using business naming conventions.• Work closely with team members to follow up on defects validation to get closed within the timelines and the same to be informed to the customer.• Coordinate with offshore team members to finish assigned work with in the time line.• We will have weekly status meeting offshore &onshore team members. • Performed various types of testing, such as Functional, SIT and Regression testing.• Extensively used ETL Informatica to load from source system to target system.• After loading the data into Data warehouse then compare and validate source and target systems. • Data testing in NY PAL Studio application (Source) data to migrate properly in Target NY PAL CI System.• Involved RPT Database testing for EDW data with Reporting data.• Environment: Informatica, SAP Business Objects XI R3, XML,SQL Server 2008 and Oracle 10g

Module: 3R's (Prototype & Production)The scope of the project is to ENHANCE the existing reports. Presently I am handling Income, Claims and Recovery reports which is developed in Cognos.My Responsibilities:• Established the business analysis methodology using Iterative model of SDLC.• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.• Responsible for Data Mapping testing by writing SQL Queries.• Arranged meetings with business customers in better understanding the reports by using business naming conventions.• Utilized Clear Quest tool to create defects and assign to respective Developer.• Performed various types of testing, such as Functional, SIT and Regression testing• Determined testing scope and prioritized deliverables in different phases.• Tested data warehouse components, data marts, testing of Dimension and Fact tables.• Tested Claims data in Facets.• Extensively used ETL Data Stage to load from different source systems and load into the target data warehouse.• After loading the data into Data warehouse then compare and validate source and target systems. • Work closely with DW Developer to follow up on defects to get closed within the timelines and the same to be informed to stake holder. • Ensured the process oriented steps to get the job done within the timelines to avoid un-interrupted business service/requirements. Environment: Team Room, Clear Quest, Data Stage, Cognos, XML, DB2 and Teradata

Project Description Module: Alineo 3.2 The scope of the project is to Migration from Other System Alineo3.2 to existing applications BCBS COMMON, which are used by the entire organization. My Responsibilities:• Established the business analysis methodology using Iterative model of SDLC.• Agile methodology used in the project.• Design and Develop Test Plans for different application releases.• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.• Involved in Mapping Design analysis and finding the Gaps in the document.• Validate Claims data which is coming from Facets System to Source Systems(Alineo, PCMH and MPI)• Data Validation from Difference Sources(Alineo, PCMH & MPI) to Stage(IDS)/data validation from Stage (IDS) to Target(EDW) Environment: SharePoint, Daptive, Data Stage, Facets, Business Object XI R2 , XML, XSD, Oracle 10G ,Sybase ,T-SQL and DB2.