PROFESSIONAL SUMMARY:

• Over 9 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking, Insurance, Financial, Healthcare, 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). In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Experienced in defining Testing methodologies, Designing Test Plans and Test Cases, Verifying and Validating Data for several ETL and BI applications and documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle
• Adept at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
• Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Well versed with Manual and Automated Testing methodologies and principles.
• Expert in managing/leading ETL and Business Intelligence Testing.
• Configured test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Experienced and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Adept at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Designed data models using Erwin.
• 5+ years with SQL/PLSQL and expertise in writing SQL complex Queries for data testing.
• 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
• Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, SQL Navigator, Perl, UNIX, Korn Shell Scripting.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Ab Initio & Informatica jobs using UNIX Shell Scripting.
• Application Data warehousing experience in Financial, Banking, Healthcare and Insurance.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Databases: Oracle 8.1/9i/10g,PL/SQL,SQL Server 2000/2005, Siebel, Sybase

ETL Tools: Informatica 6.1, 7.1, 8.1 and Data Stage 6.x/7.x/8.x, Ab Initio (GDE 1.15, Co>Op 2.15)

Reporting Tools: Cognos, Business Objects 5.0/6.5/XI R3/R2/R1

Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Scripting Languages: XML, HTML, XHTML, Shell Scripting

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

Application Development: Visual Basic 6.0, Oracle9i/10g

Packages: MS-Office, Visual Studio. 2005

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Scheduler Tools: Autosys, Appworx, Tidal

Others: Visual Source Safe,TFS, File Zilla, MKS Tool kit, XML Spy 2008 (UNIX scripts)

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

ETL/ SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Lead team of 6 people onsite and 4 people offshore.
• Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
• Executed the Test cases for Crystal Reports and Cognos.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• 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.
• Generated test data (on UNIX box using Perl scripts) to support development.
• Experience in Data Inspection/analysis of tables as well as outbound files (data files in EBCIDIC & ASCII format).
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• 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.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on UNIX Shell wrapper scripts
• 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.
• Tested analytical reports using Analysis Studio

Environment: SQL, PL/SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, SAS/BASE 9.1.2, SAS/Access, SAS/Connect, IBM DB2, COBOL, Flat Files, Copy Books, MVS, TSO, JCL, IMS DB/DC, ISPF, Informatica Power Center 7.2 (Power Center Designer, workflow manager, workflow monitor), SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000/2005, Erwin 3.5/4.0

Confidential, Sioux Falls, SD

Sr. Data Warehouse Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Lead team of 5~6 people and co-ordinate offshore team of 12 people in Confidential .
• Managed multiple projects from different Line of Businesses.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed and approved database modifications
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• 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.
• Reviewed Informatica mappings and test cases before delivering to Client.
• 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
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• 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 Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Worked with all Teradata load utilities
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with business analysts, developers, and content department to resolve issues.
• Was involved in design part for Extracting data from different source systems into the target database using IBM Data stage Server 8.1.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Informatica Power Center 8.1, Data Profiler, SQL, PL/SQL, Quick Test Pro 8.0, Business Objects XIR2, UNIX, Shell Scripts, Mercury Quality Center, Teradata V2R6, SQL Assitant 6.0, MLOAD, FLOAD, TPUMP, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, CICS, Sybase, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SQL, TSO/ISPF

Confidential, Atlanta, GA

Data Warehouse Tester

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used TestDirector 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.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases
• Prepared the Customer Templates to Upload the Data to the Application.
• Assist with the user testing of systems (User Acceptance testing) developing and maintaining quality procedures, and ensuring the appropriate document is in place.
• Developed SQL procedures to ensure compliance with standards and lack of redundancy, business rules and functionality requirement into ETL procedures.
• Designed and executed Functionality and User Acceptance test cases.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands.
• 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 TestDirector.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Perform data driven testing and validated the test results.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Written Complicated SQL queries in DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Written various UNIX Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Ab Initio (Co>Op 2.13, GDE 1.13), Data Profiler, Oracle 9i, Autosys, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy

Confidential, Woodland Hills, CA

Sr. Backend/ ETL Tester

Responsibilities:

• Designed and created various Test Plans, Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Used TOAD Software for Querying Database.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Tested mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Participated in walkthrough and defect report meetings periodically.
• Involved in Unit, Functional, Regression and System testing.
• Worked on profiling the data for understanding the data and ETL mapping document.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Created test plans and performed unit testing for the Ab Initio graphs and its components.
• 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.
• Documented and reported various bugs during Manual Testing.
• Retesting the resolved defects/issues after the developers fix the defects
• Performed Installation testing and Performance testing manually.

Environment: Ab Initio (Co>Op 2.12, GDE 1.12), Oracle 9i, Autosys, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy

Confidential, Manhattan, New York

Software Engineer

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.
• Created new Oracle Stored Procedures and modified the existing ones. Designed, Developed and tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Did functional testing using Quick Test Pro.
• 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, sequences 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.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Wrote and ran UNIX Scripts for batch jobs.
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.

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