SUMMARY

• Over 6+ years of IT experience in Data warehousing testing with extensive usage of SQL, PL/SQL, UNIX, Shell Scripting & HP QC.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations using Datastage, Informatica, and Ab Initio and Autosys tools were.
• Experienced working with multiple databases like SQL Server, Netezza, Oracle, Teradata, Sybase & DB2.
• Experienced in setting test environment and preparing mock data to test ETL and BI applications.
• Experienced in testing Business Report developed in OBIEE, Business Objects XIR2 & Cognos 8 series.
• Experienced in manually testing the job scheduling that were designed using Autosys and Control - M.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Worked with different Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader, Export/Import in UNIX environment.
• Good working knowledge with QA Methodology and QA Validations to ensure the Quality.
• Extensive experience in all phases of SDLC methodologies Agile, Waterfall etc.
• Expertise in analyzing business requirements, developing Test plans, Test cases, Test Scripts
• Experience in Manual, Functional and Automated Software Testing tools QTP, Selenium, and SoapUI.
• Solid Back-end testing experience in writing and executing SQL Queries.
• Performed Data Migration testing where SQL was used heavily for validating data between source and target databases.
• Involved in testing the reports dashboards, prompts, and drill down, drill ups, filters and various pivot reports.
• Exceptional time management skills and able to handle multiple competing priorities in a fast-paced environment.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica (PowerMart & PowerCenter), Abinitio, Datastage

BI Tools: Business Objects XIR4, Cognos, Crystal Reports, Hyperion, OBIEE

Testing Tools: HP Quality Center 10.0/AlM, Rational Clear Quest, Bugzilla, Rally

Databases: SQL Server008, Oracle 11i/10g/9i, Teradata V2R6, DB2, Sybase 12.5, Netezza

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting and JavaScript

Operating System: MS - Windows 9x/NT/2000/XP, UNIX (Sun Solaris 5.8)

Other Tools: TOAD 8.x and SQL plus, Autosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Sr. ETL Test Analyst

Responsibilities:

• Worked on testing various process that generates Balance sheets,profit and loss statements, financial statements, cash flow, breakeven analysis, ratio analysis.
• Verified processed customer transactions using computerized methods, accurately recorded financial transactions, and generated receipts.
• Prepared test plans, test cases and various QA artifacts and reviewed with the project team before test execution.
• Prepared RTM which shows a complete coverage of test cases against the requirements.
• Discussed the test cases for regression testing and scope for automation with the quality engineers for each build.
• Validated and executed ETL jobs scheduled in Autosys.
• Validated the mappings and their workflows generated in Informatica, the ETL tool used.
• Wrote SQL queries to validate the ETL logic of the application.
• Updated and modified UNIX files consumed by various process of the ETL process.
• Interacted with the development team to report bugs and discuss the status of bugs with open status or hold status.
• Involved in various documentation tasks such as daily status reports, weekly progress reports, Requirements traceability Metrics (RTM) and defect logs.
• Validated Microstrategy reports for cosmetic, function and data.
• Extensively usedQuality Centerfortest planning, test execution and bug tracking and reporting.
• Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
• Actively participated in enhancement meetings, project review meetings, Weekly status meetings and various other meetings which were focused on making the application more effective.
• Automated test cases, for data driven tests and linked test scripts using QTP to perform Regression testing of different application versions.
• Creating Test sets using Mercury Quality Center and HP Quality Center.

Environment:HP Quality Center ALM, Microstrategy,Informatica 9.0, Rational Clear Quest 8.0.1,Windows, Unix, MS Excel, MS Word, Oracle 10g,Putty,Autosys,TOAD,Office Communicator, SharePoint.

Confidential, Charlotte, NC

BI/ETL/SQL Test Analyst

Responsibilities:

• Prepared and executed Test Cases manually according to the BRD, Technical Specification, Functional Design and Use Case documents, identifying applications functionality, test requirements and coverage.
• Performed regression testing against the various builds of the application.
• Wrote SQL queries and tested front end developed data in the databases.
• Executed automated test scripts using QTP 9.2 to perform through testing.
• Develop and automate Web Services API testing using SoapUI frameworks.
• Defects were tracked, reviewed, analyzed and reported using Quality Centre.
• Prepared test cases for the ETL application according to technical specification document and extensively tested data extraction, transformations and loading processes.
• ValidatedETLprocess and reports usingSQLqueries.
• Validated the ETL mappings and Sessions developed in Informatica.
• Performed Configuration and compatibility testing, verified the application on different operating systems.
• Interfaced with developers to resolve technical issues and investigated software faults.
• Prepared RTM Document to ensure that all the requirements had sufficient coverage for through testing.
• Analyzed the functional specifications and helped team members to achieve test goal.
• Defects were tracked, reviewed, analyzed and reported using Quality Center.
• Tested the reports developed in the system as per company standards and requirements
• Prepared documentation of the Prescription fulfilment and management module for management review and project presentations.
• Responsible for giving demonstrations and presentation to the management and mentoring other junior team members.
• Involved in auditing documentation for CMMI certification.

Environment:SQL, HP Quality Center 10, Informatica 9.0, Windows XP, Quick Test Professional, JSP, Java, MS Excel, MS word, SOAP UI, Oracle 10g,TOAD,Putty.

Confidential, Chicago, IL

DW Tester - Retail Data Mart

Responsibilities:

• Tested all phases of ETL testing including Extraction, Transformation and Loading.
• Tested various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested test scenarios that were used to validate the ETL movement
• Written complex SQL queries for validating the transformation rules for ETL mappings.
• Developed test scripts using QTP for Functionality and Regression Testing
• Involved in conversion of WinRunner scripts to QTP (Quick Test Pro)
• Tested Korn Shell scripts and cron jobs to refresh the load on weekly basis.
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Tested Desktop Intelligence and Web Intelligence reports.

Environment: Oracle 9i/10g, SQL, PL/SQL, Informatica, OBIEE, Stored Procedures, XML, XSD, Unix Shell Scripting, Teradata V2R5, SQL Assistant 6.0, QTP9.2, Business Objects 6.5.

Confidential, Durham,NC

SQL/ETL Tester - Data Mart

Responsibilities:

• Used SQL Loader to load data from delimited files into Oracle tables.
• Extensively developed UNIX Shell scripts to transfer and archive account files.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Integrated data from Flat files and other Databases to load into Oracle tables using Informatica
• Defined Best Practices for the ETL.
• Prepared and Executed the Test Cases during Unit Testing.
• Supported Testing team, UAT Team & Productions support team.
• Developed Oracle Stored Procedures to update the data in control tables and account tables.
• Maintained versions of code and supporting documents in Clear Case (UNIX)
• Prepared and deployed build from DEV to other environments.
• Created Autosys JIL scripts, Control files, Parameter files and UNIX Environmental files.
• Tested Business Objects reports and Web Intelligence reports.
• Tested Cross-Tab reports
• Resolved major issues affecting the reporting environment.
• Provided solutions for the most complex scenarios of “linking” objects while testing.
• Performed data validation by creating ad hoc reports.
• Created derived tables at the universe level to reduce the complexity of universe building.
• Extensively used Informatica power center for ETL process.
• Preparation of ETL mapping specifications.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed mappings for dimensions and facts.

Environment: Oracle 8/9i, Informatica 7.1, UNIX Shell Scripting, SQL, PL/SQL, Business Objects 6.1b, Windows XP, IBM AIX 5.3, PERL 5.8, XML Files, XSD