SUMMARY:

• Total 10+ Years of experience in which 1+ Year as DWBI Data Analyst, Data Mapping and 5.6 Years of Experience on DWBI - ETL Testing, OBIEE- Report Testing and 3.5 Years of Experience on Mainframe Development. Having strong knowledge in SDLC and STLC. Having Domain knowledge in Banking & Financial services, Healthcare, Retail and Communications.
• Experience in Data Analysis, Data Mapping and Data Validation
• Adept in end-to-end development of various applications from requirement analysis to system study, data mapping testing and documentation
• Extensive experience in Informatica Power Center Tools (Designer, Workflow manager and Workflow Monitor) and ETL Concepts
• Well-versed with all stages of software Development life cycle(SDLC), Software testing life cycle(STLC) and Defect Life Cycle (DLC).
• Strong knowledge in OLAP Systems, OLTP Systems Dimensional modeling using Star schema and Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Strong understanding of Data warehouse and BI Analytics concepts.
• Having good experience in Data Mapping, Data Analysis, Data Validations.
• Experience in understanding Business Process from the requirements and converting them to Data Mapping.
• Experience in validating the data from file to data base, data base to data base validations
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in using HP ALM for test management, Bug Tracking and Defect Reporting
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL for data integrity.
• Expertise in working with various operational sources like Oracle, Flat files into a staging area.
• Experience in Reports testing using OBIEE. Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Experience in Test Management tools and writing complex SQL Queries
• Experience in understanding Business Process from the requirements and converting them to test scenarios.
• Strong knowledge on JCL,cobol,DB2,VSAM and CICS
• Extensive experience on various mainframe tools like changeman,File Manager, SPUFI and Debugger
• Extensively worked on developing OLTP application using mainframes
• Strong knowledge on JCL, COBOL, DB2, VSAM and CICS
• Extensive experience on various mainframe tools like changeman, File Manager, SPUFI and Debugger
• Good Team Player committed to customer satisfaction and quality.

TECHNICAL SKILLS:

ETL Tools: Informatica 9X

Healthcare Product: Facets

Testing Methodologies: ETL Testing Methodologies

Reporting Tools: OBIEE

Programming Language: SQL, COBOL and JCL

Operating Systems: Win. 9X, Win. XP and z/OS

RDBMS: Oracle 12c, DB2

DB Tools: VSAM,SQL,QMF, Debuger, FileManager, Changeman, SDSF, Fault Analyzer, SDF II and SPUFI

Test management Tool: HP Quality center & HP ALM

OLTP: CICS

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Attending the project kick-off meeting with stake holders
• Analyzed business requirements, system requirements and responsible for documenting data Mapping specifications
• Attend meeting to discuss about the Business Requirements and Pre-requisites.
• Estimating the Data Analysis effort for completing project, to meet the time line
• Present mapping and analysis details to client and development team to get the approval
• Knowledge transfer and walkthrough with offshore team
• Map the Requirements to data mapping Requirement traceability Matrix
• Attend the daily status call with offshore and development teams and clarifying any issues Raised by offshore team
• Attend the weekly status calls and defect status calls with client and discuss on any roadblocks
• Create Daily, Weekly status Reports to state the analysis progress, Issues and Risks on the Project
• Create SQL queries for data validation to meet the business requirements and also performance Tuning the complex SQL Queries
• Providing the KT and walkthrough with offshore Team and Participated in Test Case Walkthroughs, Review meetings.
• Identify the elements the needs to be mapped for the business requirements and analyze the data and ensure the data was mapped correctly
• Acquire data from primary or secondary data sources and map the data elements
• Written SQL queries for data validation to meet the business requirements and Worked on SQL, Views and worked with Performance tuning of complex SQL queries.
• Work with management to prioritize business and information needs
• Locate and define new process improvement opportunities
• Assign tasks, monitor and review status and progress with offshore team.

Confidential

Environment: Informatica, Facets, Oracle, SQL Server, OBIEE, Flat files, HP ALM

Test Lead

Responsibilities:

• Attending the project kick-off meeting with stake holders
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in ALM
• Attend meeting to discuss about the Business Requirements and Pre-requisites.
• Create Test Strategy and Test Plan Documents
• Estimating the testing effort for the complete project, to meet the timeline
• Presenting the Test strategy, Test Plan to client and development team to get the approval
• Providing the KT and walkthrough with offshore Team and Participated in Test Case walkthroughs, Review meetings.
• Presenting a walkthrough on the designed test cases to client and development team to get approval
• Mapped Requirements to Test Cases Requirement Traceability Matrix .
• Attending the daily status call with offshore and development teams and clarifying any issues raised by offshore team
• Attending the weekly status calls and defect status calls with clients and discuss on any roadblocks
• Created Daily, Weekly Status Reports to state the testing progress, Issues and Risks on the project
• Written SQL queries for data validation to meet the business requirements and Worked on SQL, views and worked with Performance tuning of complex SQL queries.
• Created and executed the Test Scenario’s and Test Cases Designed.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Executed test cases on Source database tables, staging tables and Data warehouse tables to validate the data loaded in from source systems to Datawarehouse.
• Assign tasks, monitor and review status and progress with offshore team.
• Validate the data flow from source to target and validate various canned and adhoc OBIEE reports
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL Informatica mappings and ETL Processes for both before and after validations.
• Validating the data passed to downstream systems.
• Worked on Smoke Testing, System testing, Functional Testing, Performance Testing and Regression Testing.
• Logged defects in the defect-tracking tool HP ALM tested and maintained trailing history of the defects found in the software.
• Involved in the error checking in the Informatica session and workflow logs.
• Tracked the defects using Quality Center tool and generated defect summary reports.
• Creating Test closure reports once after completion of projects

Confidential

Environment: Informatica, Oracle, SQL Server, OBIEE, Flat files and HP ALM

Test Lead

Responsibilities:

• Getting inputs from onsite coordinator and Handling the Onsite calls.
• Analyzed business requirements, system requirements and data mapping requirements
• Involved in developing test cases and test scripts and loading to Quality Center for Functional and Regression Testing.
• Performed Smoke Testing, System Testing, Functional Testing, Scenarios, Regression and end- end testing
• Tested the reports using Business Objects functionalities
• Responsible for testing OBIEE Business Reports.
• The reports that were created in Business Objects were testing by running the SQL statements.
• Used Platinum tool to write the automated test scripts by using various actions and reusable actions.
• In HP Quality Centre, Maintained the project information.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases
• Involved in Data mapping specifications to create and execute detailed system test plans.
• The data Mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Worked on SQL, views and worked with Performance tuning of complex SQL queries.
• Involved in the error checking and testing of the ETL procedures and Informatica session log.
• Experienced in writing test cases, test scripts and execution of test cases reporting and
• Documenting the test results using Quality Center.
• Extensively used Complex SQL statement for retrieving data using TOAD
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extraction of test data from tables and loading of data into SQL tables.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process.
• Validating the data passed to downstream systems.
• Worked with Testing Data Extraction, Transformation and Loading (ETL)
• Involved in testing data mapping and conversion in a server based data warehouse.
• Used Informatica Designer to test mappings, transformations and source and target tables
• Tested various Drill through reports from report to report.
• Reported operations sum and average, intersection, etc.
• Used Quality Center to track and report system defects

Confidential

Environment: Informatica, Oracle, SQL Server, OBIEE, Flat files and HP ALM

Mainframe Developer

Responsibilities:

• Business Analysis and Requirements Gathering.
• Interact with SME’s.
• Developed an OLTP system in mainframes.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and developing the programs in Cobol, unit test and providing 1 month warranty support.
• Creating job in JCL to invoke the programs.
• Troubleshooting the issues using Debugger.
• Creating the technical design documents and migration documents
• Extensively used Cobol for creating batch programs and used CICS for online transaction processing programs
• Involved in Unit and Integrating testing of mainframe programs.
• Formulate SQL queries on assigned modules.
• Prepare the Release Document and Implementation Plan for the change request.

Confidential

Environment: COBOL, JCL, DB2 and CICS

Mainframe Developer

Responsibilities:

• Business Analysis and Requirements Gathering and Interact with SME’s.
• Developed an OLTP system in mainframes.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and developing the programs in Cobol, unit test and providing 1-month warranty support.
• Creating job in JCL to invoke the programs and troubleshooting the issues using Debugger.
• Creating the technical design documents and migration documents
• Extensively used Cobol for creating batch programs and used CICS for online transaction processing programs
• Involved in Unit and Integrating testing of mainframe programs and