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.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• 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.
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Involved in Installing Business Objects, Creating Repository, Creating Users and User Groups using Business Objects Supervisor
• 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 cron - 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
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Good working experience inOracle, Unix ShellScripting.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000 / 7.0.
• 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
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP,NT/95/2000, OS/2, Sun Solaris 2.6/2.7,Linux 6.X/7.X/8.X

LANGUAGES KNOWN: C, C++, PL/SQL, T- SQL, Unix, HTML, XML

RDBMS: Oracle 7.X/8/9i/10g, Teradata V2R6, MS SQL Server 6.5/7.0/2000 , MS Access 7.0/’97/2000, SQL Server 11.x/12.0

REPORTING TOOLS: Crystal Reports 6.5, Business Objects 5.1, Cognos 6.5/7.0

SCRIPTING LANGUAGES: VB Script, Java Script, Unix Shell Scripting

DATABASES: IBM DB2 8.x, Oracle 9i/10g, Teradata V2R6, Sybase 12.3, SQL Server 2000/2005, Netezza NPS 8050

TECHNOLOGIES: Active X, OLEDB, and ODBC

WEB SERVERS: Java WebServer2.0, Netscape Enterprise Server, Web Logic 6.0.

DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000

DATAWAREHOUSING: Ab Initio, (GDE 1.14, Co>Op 2.14), Informatica 8.1, Data Stage 8.x, ETL, Data Mining, DataMart, OLAP, OLTP, SQL*Loader, TOAD 7.5.2, DataFlux, WinSQL

PROFESSIONAL EXPERIENCE

Confidential, Minnesota, MN

Sr. ETL/QA SQL DWH BI Test Specialist (Data Warehouse)

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Prepared the guides for UAT.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Tested Datastage jobs to allow portability and flexibility during runtime.
• Analyzed the Data Dictionary developed by the Systems Analyst for developing test scripts to test the Policy and Claims systems.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts.
• Tested various jobs and performed data loads and transformations using different stages of Datastage and pre-built routines, functions and macros.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Performed Regression testing for every modification in the application & new builds using QTP.
• Tested various jobs and performed data loads and transformations using different stages of Datastage and pre-built routines, functions and macros.
• Developed automated Test Scripts using QTP
• Responsible to design, develop and test the software (Data Stage, PL/SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Extensively test the reports for data accuracy and universe related errors
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.
• 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 training sessions and assisting in UAT (User Acceptance Testing).
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Promoted Unix/Datastage application releases from development to QA and to UAT environments as required
• Experience testing ETL data conversions and migration using Data Stage.
• Implemented SDLC, QA methodologies and concepts in the Project
• Responsible for testing Business Reports developed by Business Objects XIR2
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• 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: IBM Data Stage 8.7, XML, XSLT, WinSQL, Windows NT 4.0, SQL Server 2010, HP ALM Quality Center 11.0, HP QTP 11.0, DTS, T-SQL,SQL, Teradata 14.0, TOAD, Teradata SQL Assistant 7.0, Oracle 11g, PL/SQL, IBM DB2, Business Objects XIR3, UNIX, Shell Perl Script, Microsoft Visio 2003, Kalido 8, MS Access, Flat Files.

Confidential, Alpharetta, GA

Sr. ETL/QA BI DWH Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
• External interactions with NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• 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 the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required
• Worked with thin client and thick client (Business Objects XI R2)
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc..
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• 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.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Business Objects are as per company standards.
• 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 tables.

Environment: Informatica 9.0/8.6.1/7.1 , Informix, DB2, Java, Business Objects XIR2, SQL, SQL Server 2005/2008, Oracle 10g, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 7.0, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, HP QTP 10.0,WINSQL, Ultra edit, Rumba UNIX Display, HP ALM Quality Center 10.0

Sr. ETL SQL QA DWH 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.
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• 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.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• 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 6.5
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: UNIX Shell Scripting, Oracle Clinical, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Cognos 7.0,Oracle9i, SQL Server 2005, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, Bloomington, IL

ETL SQL QA Test Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Responsible for complete manual testing of application under test (UAT)
• Tested several Datastage ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written complex SQL queries for data validation and data verification.
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director.

Environment: Datastage 6.5, Windows NT, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script.

Confidential

Data Warehousing Test Engineer

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Did test on multiple Ab Initio graphs for ETL loading and Data manipulation.
• Did Data Completeness, Data Transformation, Data Quality, Data Loading, Data Profiling and Integration, UAT and Regression testing for multiple source data coming from different systems.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Designed the screens and layout using Visual Basic 5.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), EME, Oracle 7.0, SQL*Plus, SQL, Test Director, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, Java and UNIX, Korn shell scripting