SUMMARY

• Over 7+ years of IT experience in Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst.
• Extensive experience in Analyzing Functional Specifications and developing Test plans, Test cases, Test estimation, execution of Test scenarios, analyzing the Test results and Defect Management.
• Experience in System, Functional, Integration, Regression and Performance testing
• Extensive experience in Data warehouse testing using Informatica products such as Informatica PowerCenter 8.x/7.x, PowerConnect, PowerAnalyzer, Power Exchange tools, SSIS, Data Stage and Data Integrator
• Extensive experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB 2 9.1/8.0/7.0/6.0, Teradata V2R6/V2R5/V2R4/V2R3, MS SQL Server 2008/2005/2000, Excel and MYSQL, SQL Developer, TOAD, Quest Central for DB2.
• Four plus years of experience in Business intelligence reporting tools using Cognos Series 8.x/7.0, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server, and Business Objects XI R3/R2/6.5/6.0, BO Developer Suite 6.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module), SSRS.
• Worked with PERL for file manipulations
• Converted SQL queries results into PERL variable
• Good understanding in the concepts of Data modeling, slowly changing dimensions, Star schema & snow flake schema and Business process testing, Data analysis and experience in testing the reports.
• Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures, Triggers, Appworx and Autosys.
• Experience in testing the web services using SOAP UI and Experience working in agile development environments.
• Experience in testing the XML schema using XML Editor and ISTQB - CTFL Certified Tester.
• Extensively used the Load runner to develop the performance test scripts to meet the performance testing requirements.
• Experience in designing scenarios in load runner to specify ramp up, ramp down and duration to depict varying amounts of user load on the server at any given moment.
• Performed load and stress testing using rendezvous points and recording transactions in Load Runner, to pinpoint potential problem areas and bottlenecks.
• Recorded and parameterized Vuser scripts using Virtual User Generator.
• Utilized Load Runner Analysis tool to analyze the response times of the business transactions under load.
• Maintain functioning test environments by verifying integration points and working proactively with DBA’s/Developers as necessary.
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux, UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).
• Involved in all phases of the QA Life Cycle, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, Etc.
• Performed risk analysis, monitored testing progress and ensured the timely completion of testing consistent with corporation requirements and update management about the status of all assigned tasks.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 8.x/7.x (Repository Manager, Designer, Workflow Manager,Workflow Monitor)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager. Repository manager administration)/5.1/4.7(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), PowerMart 6.2/5.1/4.7/1.7, Data Integrator, Data Mining, OLAP, OLTP, SSIS, Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI & Reporting: Business Objects XIR3/R 2/6.5/6.0/5.0, BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module), Cognos Impromptu 8.0/7.0/6.6, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise, SSRS.

Testing Tools: Load Runner 8.1, QTP 8.2, RFT 6.1, Test Director, Quality Center 9.2.

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2008/2005/2000 /7.0/6.5, IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: Appworx, Autosys, BMC Control M, Maestro

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux,MS-DOS

Web Service Tools: SOAP UI

Languages/Utilities: SQL, PL/SQL, SQL Developer, TOAD, Quest Central for DB2,UNIX shell scripts (Cron, C),Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL QA Tester

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Created complex SQL queries for querying data against different data bases for data verification process.
• 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.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Conducted backend testing by querying databases to synchronize testing databases and checked for data integrity and proper routing based on workflow rules at each step.
• Involved in rigorous meetings with Design, development and QA team to plan and implement the testing efforts.
• Generated the detailed Bug reports and Defects were tracked, reviewed and analyzed.
• Involved in meetings to discuss the findings in the executed tests and decide the next steps.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
• Developed separate test cases for Inbound and Outbound Processes.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Worked with PERL scripts for data parsing, text processing and connecting to database.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center Work Flow monitor 8.1
• Used HP Quality Center 9.2 to state requirements, test plan, test cases, update test run status for each iteration and to report the defects.
• Involved in recording change requests on the Change Requests.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Extracted certain column of data from a number to files using PERL.
• Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
• Generated the Test data for the application using Mainframe File-Aid.
• Worked with Business Object’s Team to test reports
• Responsible for loading historic data into UAT.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Involved in various testing phases like Integration Testing, System Testing.
• Developed complex queries to test the reports developed.
• Tested whether the reports developed in Business Objects are as per company standards.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging table
• Tested the data and data integrity among various sources and targets.

Environment: ETL (Informatica 8.6.1), PERL, Business Objects XI R3, Oracle 9i/10g, SQL, PL/SQL, UNIX, HP Quality Center 9.2, TOAD, SQL Navigator, Windows XP Professional, filezilla, SSH Pro, SmartFTP, MS Excel 2007, XML, XSD, XSLT, XML Spy 2008, Unix Shell Scripting, DB2, VSAM Files, JCL.

Confidential, Wilmington, DE

DWH Tester

Responsibilities:

• Created test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• PL/SQL queries were written to perform operations like joins in the source database.
• Vigorously worked on Manual Testing. Written Test plans, Test Cases and Test Scripts.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Developed test reports, which compare the sources and the desired targets.
• Involved in all testing phases: System Testing, Acceptance Testing, Regression Testing, and Integration Testing.
• Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
• Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for Mini specifications document that describe the functionality of each subject area.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are used in this project to write Shell Scripts and SQL queries
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Creating and executing SQL queries to perform Data Integrity testing on Oracle Database to validate and test data using TOAD.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment.
• Scheduled the ETL jobs using Maestro and loaded the data into target tables from staging area using dynamic load process.
• Extensively worked in the Unix Environment using Shell Scripts.
• Created test plans and performed unit testing for the Informatica mappings.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.

Environment: Informatica Power Center 7.1/6.2, Informatica Power Connect, MS Visio 2002, Oracle 8i/9i, MS SQL Server7/2000, IBM DB2/400,IBM AS/400, Teradata V2R5, MS Excel 97, Flat files, PL/SQL, SQL, Toad 7.0, Transact-SQL, SQL*Loader, Windows 2000, HP-UX 11.x Unix (ksh) Shell and Cognos (Impromptu, Power Play) 7.1, Shell Scripting, PERL, XML Files, Cognos reportnet.

Confidential, Alpharetta, GA

ETL Tester

Responsibilities:

• Worked on Informatica Power Center 6.1 tool (Workflow Monitor, Workflow Manger, Mapping & Mapplet Designer and Transformation Developer) to transform data mainly from DB2 and Flat Files and load that data to Oracle.
• Prepared PL/SQL queries to perform operations like joins in the source database.
• Involved in Functional, Regression and System testing.
• Designed and created various Test Plans, Test Cases and Test Scripts based on the application requirements.
• Analyzed the business requirements (e.g., business logic, Process specs, process flows). Developed test plans and test cases based on the business requirements.
• Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Reported the Defects found during test execution using the Test Director tool and followed up the development personnel for bug resolution.
• Conducted Bug Review meetings for update on defects from development team & retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Interact with analyst, system staff, business user and developers. Provide input and documentation to System Level Test Plan and facilitated project deliverables
• Development of Unit Test Plans, Integrated and System test plans
• Stored data in the Data Warehouse about Customers, Accounts. The loads were scheduled (Daily and weekly) depending on the frequency of source data.
• Participated in walkthrough and defect report meetings periodically.

Environment: Informatica Power Mart 6.1, Toad 7.0, Oracle 8, MS SQL Server, IBM Mainframes, DB2, COBOL, XML, PL/SQL, SQL Plus, SQL, Transact-SQL, SQL*Loader, Business objects 5, UNIX, Windows NT

Confidential, Hopewell, New Jersy

SQL Tester

Responsibilities:

• Involved in testing effort estimation of the task allocation.
• Developed Test Plan, Test Cases, Test Scripts based on the Functional Requirements specification and prepared the Validation Progress Reports.
• Written complex SQL queries for validating the data.
• Reviewed the test cases, test scripts and prepared test data bed for test scripts.
• Analyzed the results and reported the issues using Mantis.
• Performed web service testing using SOAP UI.
• Performed XML schema validation using XML editor.
• Verified the back end processing of batch jobs & data using SQL Server.
• Reporting bugs and Follow up with the development team for bug resolution using Mantis.
• Preparation of Load testing Scripts using VUGen.
• Execution of scripts for different scenarios Controller.
• Analysis of load test results using LR analysis & Preparation of Load test report.
• Lead the team of 4 members.
• Trained the team members on the functional aspects of the project.
• Provided Testing Status to management and conduct follow up calls with concerned departments to resolve any outstanding bug resolution related issues.

Environment: TOAD, SQL, Java, Struts, Linux, Load Runner, SOAP UI, XML Editor, SQL Server, T-SQL, Mantis.

Confidential, Foster City CA

QA Tester

Responsibilities:

• Analyzed existing business requirements and the business process flow and derived comprehensive and detailed test conditions.
• Written several shell scripts using UNIX for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked with Rational Functional Tester for both manual and automation for setting up verification points and regular expression.
• Wrote complex SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Designing of test cases based on the Functional Requirements specification.
• Performed System Testing and Analyzed Test Results and Creating Bug Report.
• Reporting bugs and Follow up with the development team for bug resolution.
• Analyzing Test Results and Creating Bug Report.
• Preparation of Load testing Scripts and execution of scripts for different scenarios.
• Analysis of load test results and preparation of Load test report.

Environment: TOAD, ETL, Informatica, PL/SQL, UNIX Shell Scripting, J2EE, Oracle, Atlas, Load Runner.