Summary

• 10 years career reflecting experience and high performance in System Analysis, Design, Development and Implementation in Relational Database and Data Warehousing Systems using IBM InfoSphere Information Server 8.1, IBM Ascential DataStage Enterprise and DataStage 7.5/7/6.x/5.x, Informatica 8.6.1, SSIS and Ab Initio
• Involved in all the stages of Software Development Life Cycle SDLC .
• Experienced in Data Warehousing, Application Development and Production Support.
• Worked with business users to identify the data sources, key facts and dimensions that support the requirement.a
• Excellent experience in working with Server jobs, Parallel jobs, debugging, troubleshooting and performance tuning.
• Excellent understanding of the DBA functions including creating tables, table spaces, databases, indices and clusters. Also worked with Cubes and Metadata.
• Experienced in Data analysis, Data modeling concepts, Database design and Data migration.
• Strong understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling.
• Application Data warehousing experience including Financial, Retail, Pharmaceutical and Insurance. Proven ability to implement technology based solutions for business problems.
• Excellent skills in Informatica, AB Initio, Teradata, DB2, SQL Server and Oracle 9i/8i RDBMS.
• Extensive experience in Perl and UNIX shell scripting.
• Excellent experience in scheduling and monitoring the production jobs using Tidal and Autosys.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon SCD , surrogate key assignment and CDC Change Data Capture .
• Excellent knowledge of different RDBMS like Oracle 8i/9i/10g, MS SQL Server, DB2 and Teradata.
• Expert in unit testing, system integration testing, implementation and maintenance.
• Good aptitude for problem solving and logical analysis.

Professional Experience

Confidential

Project Manager

• Provide staff and users with assistance solving computer related problems, such as malfunctions and program problems
• Test, maintain, and monitor computer programs and systems, including coordinating the installation of computer programs and systems
• Perform User Acceptance Testing and assure that the application developed is responsive to different platforms on the handheld devices.
• Assess the usefulness of pre-developed application packages and adapt them to a user environment
• Define the goals of the system and devise flow charts and diagrams describing logical operational steps of programs
• Develop, document and revise system design procedures, test procedures, and quality standards review and analyze computer printouts and performance indicators to locate code problems, and correct errors by correcting codes
• Read manuals, periodicals, and technical reports to learn how to develop programs that meet staff and user requirements
• Supervise computer programmers or other systems analysts or serve as project leaders for particular systems projects
• Utilize the computer in the analysis and solution of business problems such as development of integrated production and inventory control and cost analysis systems
• Prepare cost-benefit and return-on-investment analyses to aid in decisions on system implementation and
• Specify inputs accessed by the system and plan the distribution and use of the results

Confidential

Lead Software Tester

Project name: LADWP portal Development /Database Management

• Participated in Technical Reviews and Inspections to make sure the standards are maintained throughout the project.
• Interacted with clients to determine User requirements and goals.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed UAT along with Clients and generate reports for the Test Team. Update the Bug tracking status sheet on a daily basis to update the progress report for the clients.
• Create a Traceability matrix and perform System Integration Testing. Prioritize the defects and submit the report to the Development team.
• Perform Acceptance Testing alongwith the end clients and Business Users. Keep track of the change requests and the enhancements suggested and match them with the Scope.
• Perform UAT on Mobile and Handheld devices for iOS, Androids and Blackberry OS.
• Performed Positive and Negative Testing for this application.
• Performed basic testing of security features using manual testing.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Testing the source and target databases for conformance to specifications.
• Performed functional testing using QTP for end to end application testing.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
• Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Designed and developed UNIX shell scripts as part of the ETL process, automated the process of loading, pulling the data.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Reported bugs and tracked defects using Quality Center 9.2
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Developed 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.
• Written several UNIX scripts for invoking data reconciliation.
• Tested the Oracle Applications and Portals like Executive Dashboard, Credit Card Online Portal built on Oracle. Used TOAD Software for Querying ORACLE.

Environment: Java, ADF, WebCenter 11g, Oracle SOA, , Oracle Database11g, Oracle Web Center 11g ps4 SAS, SSIS, Informatica Power Center 8.1/7.1, HP Quality Center 9.2, XML, MS SQL Server 2005/2008, TOAD, iOS, Android OS.

Confidential

Sr.Data Warehouse Testing Analyst/Data Analyst

• Gather Requirements from the Clients specific to projects.
• Performed Data validity testing for reports and feeds based on requirements.
• Validated format of the reports and feeds.
• Performed manual testing of the application to check the data validity of the reports.
• Updated weekly status on the testing progress and other concerned issues.
• Conduct Formal Reviews and walkthrough for preparing test plans and test cases with team mates.
• Participated in daily QA meetings to improve efficiency of queries that take a long time to execute.
• Communicated with developers and Business Analysts to discuss issues and priorities.

Environment: Informatica 8.1.1, Oracle 9i, Oracle Database10g, PL/SQL, Business Objects 6.5, XML, Flat Files, IBM Rational Clear Case v7.1.2 , XML/DHTML, Shell Scripting, TOAD v8.0

Project Name: Stepwise

Lead Data Warehouse Testing Analyst/Data Analyst

• Extensively used Informatica PowerCenter 8.1.1 to load data sourcing from Source to Target databases
• Executing ETL Informatica Workflows for updating test Databases from the Production servers.
• Tested various jobs and performed data loads and transformations using different stages of informatica 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 manual testing of the application to check the data validity on a weekly basis.

Environment: Informatica 8.1.1, Oracle 9i, Oracle Database10g, PL/SQL, Business Objects 6.5, Flat Files, IBM Rational Clear Case v7.0.1.0 , IBM ClearQuest v7.1.2 TOAD v8.0

Confidential

Data Warehouse Testing Analyst

• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Identifying duplicate records in the staging area before data gets processed
• Test data creation in various required formats upto millions of records as per banking requirements.
• Testing the source and target databases for conformance to specifications
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Conducted regression testing on the application under test

Environment: Informatica 8.6.1, Business Objects Xi R3,WindowsXP,Oracle10G,Sybase,IBM DB2,TOAD for Oracle, UNIX, Reflections, Mercury Quality Center 10, PVCS Dimensions , MS Project, FACETS 4.3, FACETS 4.5,

Confidential

Sr. ETL/QA Test Analyst

Responsibilities:

• 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.
• Extensively worked in testing of the programs, ETL Procedures and processes.
• Resolving issues with business users and taking care of the reporting requirements
• Tested Complex ETL flow based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for creating the automated tests using QTP for applications for the high level functionality of the applications.
• Tested Ab Initio graphs for data loading.
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs
• 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.

Environment: Ab Initio GDE 1.14, Co>Op 2.14 , HP Quality Centre 9.0, QTP 9.2, Teradata V2R6, Teradata SQL Assistant 6.0, Unix, Oracle 10g, MS SQL Server 2008, MS Access, SQL Data Access, Flat files, Tivoli 8.2, Erwin 7.1, MVS, ISPF, VSAM Files, Copy Books, SQL, PL/SQL, Toad, XML, XSD, XML Spy 2008

Confidential

ETL/BI/SQL Test Analyst

Responsibilities:

• Performed Regression Testing using Quick Test Professional QTP and generated scripts for testing functional, acceptance and limit validations.
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Performed manual testing of the application to check the data validity of the reports.
• Written SQL queries to access the data in SQL Server database to execute back-end testing.
• Provided assistance and consultation to development and project support teams on project activities.
• Updated weekly status on the testing progress and other concerned issues.
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Compared query result sets from different database systems using UNIX diff command.
• 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.
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup and summarize data
• Validated the OLAP cubes generated in SQL Server Environment.
• Well versed with Unix Shell Scripting.
• Tested jobs and used Ab Initio as an ETL tool to load the final loads. Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Responded to user request on queries on the enterprise data warehouse and creation of reports using Cognos 8.

Environment: Ab Initio GDE 1.12, Co>Op 2.12 , Oracle 10g/8i, QTP 8.0, Quality Center, Unix, IBM AIX, MS SQL Server 2005, Flat files, DB2 UDB, Erwin4.0/7.0, Autosys, Shell Scripting, PERL, XML, XSLT, XSD, XML Spy 2008, Teradata V2R6, Cognos Series 7.3

Confidential

Data Warehouse Tester

Responsibilities:

• Created job sequences to control the flow of jobs.
• Analyzed and defined testable requirements created and implemented test plans.
• Developed Test Cases/Scripts based on Use Cases, SRS Documents.
• Developed the Check Sum graph in GDE by using Input File, Input Table, Reformat, Replicate and Check Sum components etc.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center
• Developed the Field Validation graph in GDE by using different components like Reformat, Sort key and Join Components, Input File and Input Table Components etc.
• Performed Check In and Check Out the various graphs Code into EME.
• Verified the data records by using check sum graph comparing Flat Files and Target Database TPR .
• Performed Field by Field Validation on each Record by using Field Validation graph comparing, Joining Flat Files and Target Data base TPR .

Environment: Unix, Teradata, Ab Initio, Quality Center, Windows NT 4.0, SQL, PL/SQL, Oracle 9i, MS SQL Server, IBM DB2, Sequential files, MS Access, CSV files, Shell Scripting, PERL

Confidential

ETL Tester/Developer

Confidential

ETL/QA Analyst Claims Data Processing Data Mart