SUMMARY

• 7+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Taxation, Banking, Insurance, Financial, Hospitality, and Retail Industries.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• 5+ years with SQL/PLSQL and expertise in writing SQL Queries.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Proficient in developing procedures, packages in PL/SQL with good knowledge in Oracle Developer 2000 and SQL*Loader
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Extensive experience with databases like Oracle, Teradata, SQL Server, DB2, and MS Access.
• Work extensively with slowly changing Dimensions.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Well versed with Manual and Automated Testing methodologies and principles.
• Strong Experience in data Maintenance and Support which uses Oracle 11g/10g/9i databases, SQL, PL/SQL, SQL* Loader in windows NT and Unix environment.
• Experience in Performance Tuning of SQL and Stored Procedures.

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica Power center, Power mart.

OS: Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x.

Databases: Oracle 10g/9i/8.x,IBM DB2, MS SQL Server.

Languages: C, C++, Java, XML, Visual Basic 6.0/5.0, SQL, PL/SQL, Transact-SQL and Perl.

OLAP/Tools: Cognos (Impromptu, Power Play), Business objects, Micro Strategy, Oracle Reports.

Packages: SQL* PLUS, Toad 7.x, SQL Loader, Erwin 4.0, MS Visio 2002.

Scripting: UNIX Shell (Ksh/Csh).

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Sr. Data Warehouse ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Defined data requirements and elements used in XML transactions.
• Reviewed and approved database modifications
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Created and scheduled sessions and workflows using Workflow Manager to load the data into the Target Database.
• Extracted data from Oracle database, transformed it and loaded into Oracle database validating according to the design specifications.
• Validation of mappings and verification of transformations using Source Qualifier, Update Strategy, Stored Procedure and Expressions according to the business rules and technical specifications.
• Developed Korn shell scripts to automate file manipulation and data loading.
• Testing of mapping parameters and variables.
• Responsible for testing and validating target data, fixing invalid mappings.
• Worked with various Sessions in a single workflow.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Prepared test plans/test schedules with inputs from Project manager and development team .

Environment: Informatica Power Center 8.6, IBM AIX 6.1, HP Quality Center, Teradata V2R6, Rational Clear Case, IBM Mainframes, UNIX, Korn Shell Scripts Oracle11g, SQL Developer, XML, Tivoli Work scheduler.

Confidential, Bardstown, Oklahoma

Sr. DWH/SQL/ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Used technical transformation document to design and build the Extraction, Transformation, and Loading (ETL) modules.
• Developed Unix Wrapper scripts to run multiple Ab initio graphs together in a sequence based on requirements.
• Worked Ab Initio Multi File System (MFS) and Multifiles to make use of Data parallelism and to achieve better performance.
• Used Ab Initio EME for Check-In/Check-Outs and Version control.
• Developed Data Validation Controls and Exceptions processes per business requirements to validate transformations in Ab Initio Graphs and report exceptions.
• Documenting of complete Ab Initio Graphs.
• Involved in unit testing of the Ab Initio graphs.
• Performed source data assessment and identified the quality and consistency of the source data.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• 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.
• Validated cube and query data from the reporting system back to the source system.
• Prepared test plans/test schedules with inputs from Project manager and development team

Environment: Ab Initio (Co.Op 2.15, GDE 1.15.9.2), UNIX, Korn Shell Scripts IBM DB2, COBOL, Flat Files, Copy Books, VSS, Cognos 8.3, Oracle9i, UNIX Korn Shell Scripting. SQL Server 2000/2005.

Confidential, WI

Sr. Backend/ETL Tester

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used Test Director to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Involved in the testing of the Designed and developed DataStage.
• Testing of all the PL/SQL procedure to improve the performance of ETL process.
• Backend testing of the and existing DataStage jobs for all the updated changes requested by users.
• Testing of various Autosys JIL Scripts to activate the UNIX scripts in production .
• Written UNIX AWK Scripts to manipulate test data and input files.
• Responsible to find out different DDL Issues and Report to DBA’s using Test Director.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using Test Director.

Environment: Ascential DataStage 7.5.2 (Designer, Manager, Director), Quality Stage, Sagent 5.0 (Designer Studio, Sagent Automation), Oracle 10g, MSSQL Server 2005, DB2, Crontab, Solaris UNIX, Windows NT, LINUX

Confidential, Boston, MA

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle.
• Used Informatica designer to create source definitions, target definitions, transformations and mappings.
• Worked with various transformations like aggregator, expression, filter, source qualifier, joiner, lookup and stored procedure etc to in corporate the business rules into the mappings.
• Scheduled and ran extraction and load process and monitored sessions using Informatica Workflow Monitor Tested the entire data reconciliation process for multiple source and target systems.
• Used Informatica designer to create source definitions, target definitions, transformations and mappings.
• Worked with various transformations like aggregator, expression, filter, source qualifier, joiner, lookup and stored procedure etc to in corporate the business rules into the mappings.
• Scheduled and ran extraction and load process and monitored sessions using Informatica Workflow Monitor
• Tested the entire data reconciliation process for multiple source and target systems.Designed forms and reports using Developer 2000 according to the client requirements. Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, se-quences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.

Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Shell Scripting, QTP, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts.

Confidential

Data Warehouse Analyst / Junior Tester

Responsibilities:

• Writing test plans and test scripts and complex SQL queries
• Performed testing in mainframe environment
• Recorded Testable and Non Testable requirements in spreadsheet.
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in functional, system, integration and performance testing.
• Assigned defects to developers through Test Director.
• Updated the defects status in Test Director.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Involved in interacting with UNIX Shell scripts.

Environment: Oracle 8i, Load Runner, PL/SQL, UNIX, Test Director 8.0, QTP.