SUMMARY

• Having Nine years of experience in IT industry in all phases of software development life cycle developing various Client/Server, Database, Data Warehouse and Business Intelligence applications.
• Strong noledge of Software Development Life Cycle (SDLC) and QA Methodologies.
• Strong experience in developing Test Plans and Test Cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Ability to write Test plans, Test cases, Test Procedures and Test Scripts from requirements and Use Cases.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.
• Experience in using Mercury Suite (Win Runner, Test Director and Quality center).
• Expertise in performing different types of Testing: Black box, Integration, System, GUI, Stress, Performance, Regression, User Acceptance Testing.
• Strong Knowledge on Informatica Transformations, Workflows, Mapplet and sessions.
• Strong noledge on Data warehouse concepts like Star and Snow - flake schemas, Top-Down(Inmon’s) and bottom-up(Ralph-Kimball) approaches, Data Acquisition process(ETL), DWH Hierarchies(Drill-Up, Drill-Down, Drill Across),Dimensions, Facts, slowly changing dimensions(SCD), transformations, Sessions, Mappings and Mapplets.
• Strong noledge on OLAP tools like Cognos 8.2 suite(Cognos connection, Framework Manager, Report Studio, Query studio, Analysis studio, Cognos Report net and Cubes) and Business Objects .
• Testing ETL sessions, mappings and PL/SQL scripts in data warehouse applications and BI application development, Cognos cubes and reports.
• Good noledge in Erwin Modeling Tool and TOAD.
• Extensive working noledge in UNIX and Windows platforms.

TECHNICAL SKILLS

Languages: SQL,PL/SQL,C,C++,COBOL,JCL

OLTP TOOLS: Informatica, Data stage, Data Manager

OLAP TOOLS: Cognos, Business Objects

Other Tools: Erwin, TOAD

RDBMS: Oracle 10g, 9i, 8i and 7.X, DB2, MS SQL Server

Testing TOOLS: Win Runner, Quality Center

OS: MS-DOS, UNIX, MVS, Sun Solaris, Windows 9X, NT/2000/XP

Version Control: Visual Source safe, PVCS, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, IL

ETL Test Analyst

Responsibilities:

• Created Test Cases using the SDLC procedures and reviewed them with the Test lead and Development team.
• Validating the data thru various stages of data movement from staging to Data Warehouse tables.
• Involved in white box testing by using Informatica.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Developed test cases, prepared test data sets, performed system integration testing defined by business rules and executed through ETL.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Experience in Test Informatica ETL processes by confirming data integrity between data sources utilizing Informatica Power Center
• Testing included unit, system, regression and User Acceptance and Business Objects reports testing.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the data files from source to make sure correct data TEMPhas been captured to be loaded to target tables.
• Extensive experience using SQL to develop queries.
• Validate mappings, sessions and workflows in Informatica tool.
• Test Case Management Creating, executing, and managing test cases with or without business requirements/design docs

Environment: Informatica 8.6.0, SQL Server 2008, Team Foundation Server, Business Objects XI/R2 MS Office10 and UNIX.

Confidential, IL

ETL /Reports Tester

Responsibilities:

• Involved in test plans and test scripts for testing the entire application.
• Prepared test data and test procedures to test the business logic.
• Performed boundary checking manually for every user input level.
• Analyzed system requirements and functional requirement documents to prepare test cases and test data.
• Involved in Functional, Backend Testing.
• Performed different types of tests such as Integration Tests, Regression Tests and User Interface Tests.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead and Development team.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Developed test cases, prepared test data sets, performed system integration testing defined by business rules and executed through ETL.
• Validating the data thru various stages of data movement from staging to Data Warehouse tables.
• Developed Traceability matrix from Requirements document, detailed design.
• Reported the bugs through email notifications to developers using Quality Center.
• Analyzed production data to prepare test data.
• Performed white box and user acceptance testing.
• Created SQL queries for back end testing.

Environment: Informatica 8.1, Cognos 8.2,Oracle 10g, Oracle 9i, TOAD, Animate, Ultra Editor, SOAP UI, Quality Center and UNIX.

Confidential, AR

ETL /Reports Tester

Responsibilities:

• Responsible for developing test plans and test scripts for testing the entire application.
• Prepared test data and test procedures to test the business logic.
• Performed boundary checking manually for every user input level.
• Analyzed system requirements and functional requirement documents to prepare test cases and test data.
• Involved in Functional, Backend Testing, Data Driven Testing By using QTP as well as Manual Testing.
• Automation of Manual Test Cases using QuickTest Professional (QTP)
• Created Estimates for estimating the time for automating the application.
• Performed different types of tests such as Integration Tests, Regression Tests and User Interface Tests.
• Analyzed production data to prepare test data.
• Performed white box and user acceptance testing.
• Created SQL queries for back end testing
• Interacted with control buyers to understand and test the business specifications.
• Involved in all phases of SDLC to ensure proper quality of the system.

Environment: Data Stage (ETL), MVS, COBOL, JCL, Oracle 9i/8i, ERWIN 4.0, SQL, PL/SQL, SQL*Loader, Business Objects, Teradata, QTP, SQL Server 2000, Windows NT/2000, HP-Unix.

Confidential, Bethesda, MD

ETL /Reports Tester

Responsibilities:

• Created a Business view according to Business Requirements in Framework Manager.
• Customized Cognos Connection with appropriate reports and security measures
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Tested List, Cross tab, Chart drill through, master-detail and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Validated custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created Traceability Metrics for requirements coverage.
• Interacted with business users to analyze the requirements.
• Created test scenarios and test cases.
• Performed testing for various Application Interfaces and validated the reports from third party vendors.
• Used Framework Manger to create model query subjects, filters, calculated items in business view and when designing the model, analyzed the joins and cardinalities between query subjects.
• Created and Published package to Cognos Portal and this packaged is used in developing reports in Report Studio.
• Created SQL queries for back end testing.
• Deployed Report Studio reports from developing environment to production Environment.

Environment: Informatica 7.1,Cognos ReportNet 1.0, Internet Information Services (IIS) 5.1, MS SQL Server 2005,Oracle9i, Windows 2000, Impromptu 7.1 Transformer 7.1, Power play and windows.

Confidential, NY

ETL Tester

Responsibilities:

• Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports, OLAP and CUBE.
• Conducted Test plan reviews, Test case reviews.
• Worked on traceability matrix to map Test cases against Requirements using Quality Center.
• Worked on multiple sources and Data warehouse built in Oracle.
• Executed SQL queries to verify the flow of data between back end and front end.
• Involved in conducting the Regression tests for reported bugs to test whether the fix TEMPhas been applied or not and to test whether the caused another problem or not.
• Monitoring the defect tracking process, trouble shooting and generating customized graphs and reports. Reported Bugs to the development team using Test Director.
• Participated in Business Requirement, Software Requirement, Data Modeling meetings along with Business Analyst and team members.
• Developed test cases and Documented Defects.

Environment: Informatica 7.0, Cognos 7.0 BI Suite (Framework Manager, Report Studio, Query Studio, Cognos Connection) Oracle 9i and QC.

Confidential

PL/SQL Developer

Responsibilities:

• Generating reports as per client specifications
• Involved in UTP & UTR.
• Loading Data from Flat Files through Toad tool
• Coded Packages, functions, cursors, views and triggers as per requirements.

Environment: Oracle 8, SQL, PL/SQL and Windows 98.

Confidential

PL/SQL Developer

Responsibilities:

• Writing stored procedures and analysis change requests
• Updating views according to client requirements
• Generating reports as per client specifications
• Involved in UTP & UTR.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in checkbook related programs like check book Issuance’s, Generating Flat files for sending the checkbook requests and uploading the incoming checkbook request flat files.
• Writing stored procedures and analysis change requests
• Updating views according to client requirements
• Created Packages, Views, Triggers, Cursors and Exceptions
• Loading Data from Flat Files through Toad tool.