PROFESSIONAL SUMMARY:

• 7 years of IT experience in the Analysis, design, development and Implementation QA process For Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) wif good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience wif integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• Experienced in testing Web applications and client/server applications
• Experience wif Agile Methodology.
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in data migration which included identifying various databases where the information/data lay scattered, understanding the complex business rules dat need to be implemented and planning the data transformation methodology.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in using Automated Tools like WinRunner, Test Director, Load Runner and JTest in Client /Server, Web, Database, API and GUI Testing.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000 / 7.0.
• Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
• Strong experience in testing tools like TestDirector7.6, Quality Center, Quick Test Pro.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently wifin timeframe.
• 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, PL/SQL 8.x/2.x, SQL*Plus, SAS 9.1/8.1

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: Shell Scripting, PERL, Java Script, XSLT

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: Informatica PowerCenter / PowerMart 8.6.1/7.1/6.1/5.1, Ab Initio GDE> 2.15, OP>. EME, DataStage 7.x, ETL, Data Mining, DataMart, OLAP, OLTP, SQL*Loader, TOAD 7.5.2, WinSQL

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification and Mocking up the data and created Test Cases according to the Business Requirements
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Exclusively developed the Test Strategies, development and execution of Test Plans, Test Scenarios and Test Cases and maintaining them using Quality Center
• Created test cases in Excel and uploaded them in Quality center
• Worked wif historical market data and Time Series Data for multiple applications to validate the data conditions
• Worked in an Agile technology
• Worked on Informatica Power Center 8.6.1 tool - source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and Reusable Transformations in the process of Datawarehouse Testing
• Did integration testing of various data sources wif Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Created test plans and performed unit testing for the Informatica mappings.
• Responsible for different Data mapping activities from Source systems to Targeted
• Written Test Cases for ETL to compare Source and Target database systems.
• Created Batch processes using Fastload, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup and summarize data.
• Executing the Test Cases using Putty, Animate, and PL/SQL developer.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools. Developed test cases to accomplish ETL data migration.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Worked wif Compatability Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Strong knowledge in loading the flat files, xml feeds, data from IMS mainframes into databases such as Oracle 10G, SQL server 2005
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure dat transformation was successful.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Used SQL for Querying the DB2 database in UNIX environment and used T-SQL for Querying the SQL Server database for data validation.
• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Verified the applied security features of Business Objects like report level & object level security in the universe so as to make the sensitive data secure
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3.1
• Implemented Agile/scrum methodology through out the project to emphasize working software as the primary measure of progress. Combined wif the preference for face-to-face communication.
• Tested the Business Objects Web me Reports are created and deployed through Info View.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Tested whether the Business Objects reports developed in OLAP are as per company standards.
• Did database backup and recovery mechanism using PERL
• Coordinated wif the developers to resolve defects.
• Involved in the design of web application using HTML, DHTML, Cascading style Sheets Java script and ASP.
• Using filezilla to open the dropped files in the Putty.
• Using Ultra edit to perform testing on the files as per the audit rules.
• Exported Manual Test Cases from MS Excel template directly to Mercury Quality Center and executed 100% of the Test Cases in Quality Center wif Pass/Fail/Blocked status.

Environment: Oracle 10g,Informatica 8.6.1 power center, SQL Developer, Business Objects XIR 3.1, SQL, PL/SQL, PERL, T-SQL, SQL Server 2000, Agile, Teradata 12.0, SQL Assistant 12.0, MVS, IBM DB2, COBOL: II, JCL, VSAM, XML, XSLT, XML Spy, SQL *Loader, Windows 2000, TOAD 7, Autosys, MS Excel, Flat files, Animate, UNIX- Putty, Shell Scripting, J2EE, Java, PERL, AutoSys, Quality Center 10.0

Confidential, San Leandro, CA

QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Worked wif multiple data feeds to handle different portfolios including equity swaps and options
• 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.
• Worked in an Agile technology wif Scrum
• Extensively worked on the Console application and to bring the output of the console application to in corporate in to the web application.
• Tested the outgoing links from all the web pages from specific domain.
• Extensively used Ab Initio for extraction, transformation and loading process.
• Worked wif ETL group for understating Ab Initio graphs for dimensions and facts.
• Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• 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 wif 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.
• 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
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Tested all the internal links and tested links jumping on the same Web page
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Used PERL for automating all the types of modules at a time
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files and Oracle to load into the Teradata data warehouse
• Worked wif PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
• Used Quick Test Pro generated various scripts for performing functional testing.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Assisted System Test and UAT testing.
• Monitored production runs and resolved both technical and financial accounting problems. Implement software upgrades. Coordinate hardware and software upgrades.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and Management (risk analysis) at every stage of the project Cycle wif transparency in planning and module development
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Quality Center, Data Profiler, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, NET, ASP.NET, VB.NET, Cognos 7.0, Oracle 9i, SQL Server 2000, Agile, Erwin 3.5, Shell Scripting, PERL, Windows 2000, TOAD 7.

Confidential, Herndon, VA

ETL/QA 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
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans.
• Created the test environment for Staging area, loading the Staging area wif data from multiple sources.
• The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• 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.
• Developed ETL/data migration scripts using Oracle as back-end database.
• Testing of records wif logical delete using flags
• Good knowledge of SDLC and closely followed Agile, Iterative and RUP Methodologies
• Written PERL scripts for text processing, database connectivity & data parsing
• 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)
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Worked wif thin client and thick client (Business Objects XI R2)
• 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 wif Data Extraction, Transformation and Loading (ETL).
• Involved in testing the UI applications
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Involved in Security testing for different LDAP roles.
• Tested whether the reports developed in Business Objects are as per company standards.
• Used Quality Center to track and report system defects

Environment: Informatica 7.1, Informix, DB2, Java, Business Objects, SQL, SQL Server 2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 7.0, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Agile, Rumba UNIX Display, PERL, Quality Center 8.2

Confidential, Minneapolis, Minnesota

Data Warehouse Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Written Test Plans and Test Cases on Rational ClearQuest
• Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Did ETL Data Warehousing, database testing using Informatica for Workflow process.
• Worked wif ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Provided overall support to the reverse mortgage systems, Consumer Home Equity Enhancement & Reporting System and the Shared Accounting and Reporting System.
• Extensively worked wif 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.
• Worked wif business team to test the reports developed in Cognos
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Rational ClearQuest.
• Reported bugs and tracked defects using Rational ClearQuest
• Worked on issues wif migration from development to testing.

Environment: UNIX Shell Scripting, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Rational ClearQuest 6.0, SQL *Loader, Quality Center, Cognos 7.0,Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, Columbus, OH

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.
• Designed the data flow diagrams using VISIO.
• Created stored procedures, triggers using PL/SQL.
• Performed Unit, Integration, functional, Load, performance, Regression testing.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Review the test cases and bug reports.
• Performed report generation for Tournaments module.
• Actively involved in preparing test plans and test cases.
• Wrote SQL queries to perform database Validations
• Performed Unit Testing, Integration and Regression testing of the application.
• Reported bugs in Test Director.
• 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

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, UNIX, Korn shell scripting