PROFESSIONAL SUMMARY:

• 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Solid Back End Testing experience by writing and executing SQL Queries
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Expertise in designing the test scenarios and scripting the test cases in order to test the application and Test Data Management Plan.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Worked with technologies like WSDL, SOAP,SOAP UI, XML, XPath and Web Services
• Expert in PERL, UNIX Shell Scripting &SQL writing for several technology needs
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in UNIX shell scripting and configuring corn - jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
• Good working experience in Oracle, Unix Shell Scripting
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C JavaScript, Shell Scripting

Databases: Oracle, MS SQL Server, MS Access, Teradata, DB2

Reporting Tools: Business Objects, Cognos, Crystal Reports, Microstrategy, SSRS

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008, MS-Office suite (Word, Excel, Project and Outlook)

Operating Systems: Windows, UNIX

Testing Tools: Quality Center, Quick Test Professional, Performance Center

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS

WORK EXPERIENCE:

Confidential - Franklin lakes, NJ

ETL/QA/DWH Tester

Responsibilities:

• Prepared test data based on data mapping document.
• Have experience in validating the business transformations by writing complex SQL queries.
• Executing Autosys jobs and validating the source and the target files.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins using Rapid SQL.
• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Involved in testing all the reports that were generated through MicroStrategy.
• Review each PBI with the Product Owner as part of Definition of Done.
• Hands on experience in using Autosys scheduling.
• Onsite/offshore coordination on daily bases.
• Involved in generating Test Scripts using QTP/UFT for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
• Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.
• Extracted certain column of data from a number to files using PERL
• Used PERL for automating all the types of modules at a time
• Tested data migration to ensure that integrity of data was not compromised.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Coordinating data movement and validation with third party vendors.
• Implementing ATDD Test concepts for defined User Stories.
• Responsible for coordinating Integration testing, UAT and Regression testing with Business Consultants and Offshore team members, as applicable.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Managed and executed the test process, using Agile Methodology.
• Involved in web services testing using SOAP UI, validated request and response XML.
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
• As an ETL/BI Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project.
• Performed Pre Migration Assessment, Migration and Post Migration.
• Developed test scripts using QTP/UFT for Functionality and Regression Testing.
• Validated various MicroStrategy reports such as ad hoc, grids, graphs.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Created UNIX scripts for file transfer and file manipulation
• Actively participate in production deployment check-out activities and communication.
• Work on Test Strategy for each sprint and help refine the Acceptance Criteria for all PBI’s.
• Draft and review test plans every sprint.
• Performed Web Service testing using HPService Test and SOAP UI.
• Identify business rules for data migration and Perform data validations.
• Involved in various testing phases like Integration Testing, System Testing, Regression testing and Inactive prod testing.
• Ensure defect management activities for all bugs identified, reported and worked upon.

Environment: Informatica, Unix, Teradata, ALM/HP Quality Center, Perl, Web Services, SOAP, SOAP UI, QTP/UFT, Agile.

Confidential, Louisville,KY

ETL/QA Tester

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Performance Tuning in Netezza and writing ADOC Queries (NPS Netezza Performance Server)
• Migrating the IDQ mappings to the Informatica PowerCenter platform and doing the testing
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Worked in AGILE - SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• 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.
• Tested the extracted data from flat files and oracle database, and tested the applied business logic on the transformations.
• Extract daily reports from HP ALM/Quality Center about the testing status.
• Maintain, improve and support current ETL and data integration processes.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
• Data profiling, address doctor validation, monitoring and cleansing across the enterprise through Informatica Data Quality (IDQ)
• Prepare the Oracle to Netezza migration approach document
• Extraction of test data from tables and loading of data into SQL tables.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Tested the ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging of jobs.

Confidential - San Antonio, Texas

ETL/QA Tester

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, 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.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested new Data migration tool used in the mapping of data to new system.
• Data migration of raw data to excel documents for clients
• Participated in defining and executing test strategies using agile methodology.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• 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.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Performed database testing with SQL queries to verify data integrity using QTP/UFT.
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving& job scheduling
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• 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.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Prepared reusable function in QTP/UFT to use across the automation scripts.
• 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.
• 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 for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
• Used Toad for query Oracle, SQL Assistant for Teradata and SQL Management studio for SQL Server
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Tested the functionality and performance of web services using SOAP UI.
• Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
• Worked on issues with migration from development to testing
• 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.
• Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
• Developed complex queries to test the reports developed.
• 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: Informatica, Oracle, SQL, PL/SQL, SOAP, SOAP UI, UNIX, Teradata, ALM/HP Quality Center 11, TOAD, MS Excel, Agile, XML, Perl, XSD, XSLT, XML Spy

Confidential - Hopkins, MN

ETL/QA Tester

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared the guides for UAT& Production readiness for entire ETL testing efforts.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Ensured that the mappings are correct and Conducted data validation testing
• Worked with PERL control structures & Regular Expressions for substitutions based on matches
• Worked with business analyst and developers in setting up test data
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Extensively test the reports for data accuracy and universe related errors
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in user sessions and assisting in UAT (User Acceptance Testing)
• Extracted certain column of data from a number to files using PERL
• Monitored the workflow transformations in Informatica work flow monitor
• Preparing manual test cases and test data for Scenarios
• Written several complex SQL queries for validating Cognos Reports
• Worked with business team to test the reports developed in Cognos
• Developed test plans, test cases and test scripts for data validation testing.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Performed end-to-end testing of applications and coordinated with other teams.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Did database backup and recovery mechanism using PERL
• Created ETL execution scripts for automating jobs
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Tested Operation Data Store process of ODS/DWL product
• Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Informatica, XML, XSLT, XPath, SQL Server, ALM/ HP Quality Center, SQL, TOAD, Teradata SQL Assistant, Oracle, PL/SQL

Confidential

ETL/QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Used HP ALM - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing and Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Performed Web Services testing and Validated XML request/response data using SOAPUI
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Packages
• Performed the data validation once the Batch Job execution is completed
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Executed Informatica Workflows from UNIX using the shell scripts.
• Tested the created Informatica packages to transfer data from various sources like Oracle, Db2, MS Access, Excel, Flat files
• Extensively executed T-SQL queries in order to view successful transactions of data. Conducted Load testing using SOAPUI tool.
• Generated reports using SOAPUI. Validated several UNIX scripts for invoking data reconciliation
• To verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Extensively used AUTOSYS to schedule the jobs and run the scheduled jobs at specific time.
• Involved in testing the UI applications.
• Extensively involved with backend testing by writing complex SQL queries. Testing of records with logical delete using flags.

Environment: Informatica, Oracle 11g, Autosys, HP ALM, QTP, T-SQL, SQL, TOAD, Agile, Flat Files, UNIX Shell Scripting

Confidential

QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Performed UAT testing
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Extensively used Informatica power center for extraction, transformation and loading process
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Reported bugs and tracked defects using Test Director
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: UNIX Shell Scripting, Oracle, Informatica Power Center, QTP, SQL *Loader, SQL Server, Windows, TOAD, PL/SQL