PROFESSIONAL SUMMARY:

• Highly creative, goal - oriented data warehousing professional with 8 plus years of IT experience in the Business Requirements Analysis, System Design, Data Modeling, Development, Testing, Implementation and Maintenance.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using DataStage.
• Worked extensively with Dimensional modeling, ETL Processes.
• Worked extensively on Ab Initio GDE 1.15/1.14x/1.13x/1.11x/1.10, Ab Initio Co-Operating System 2.15/2.14/2.13 x/2.10x
• Expertise in Ab Initio GDE, CO>operating System. Created complex Ab Initio graphs for data processing, data migration and data analyzing purposes.
• Involved in Unit testing of Ab Initio code, Integration Testing, and System testing in pre-production environment.
• Expertise in creating and integrating BO reports and objects with the data warehouse.
• 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 CA Erwin and profiled the data for setting mapping rules.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Ensure appropriate processes and controls across major process areas, including but not limited to data quality, ETL and Meta data management.
• Highly proficient in UNIX shell scripting (Korn Shell) and administering Job Scheduler using Cron, Autosys on UNIX machines.
• Involved in Unit Testing of Datastage Jobs, integration testing and system testing in pre-production environment
• Good experience of ETL tools working with multiple data sources.
• Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.

TECHNICAL SKILLS:

ETL Tools: Ab Initio GDE 1.15/1.14x/1.13x/1.11x/1.10, Ab Initio Co-Operating System 2.15/2.14/2.13 x/2.10x,Informatica 7.1/6.1Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata V2R5/V2R6, MS Access 2003

OLAP Tools: MicroStrategy OLAP Suite (8 & 7i), Cognos 8.0/7.0/6.0, Business Objects XI R2/6.x/5.x

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML

Tools: TOAD, Win SQL, SQL* Loader, Teradata SQL Assistant

Operating Systems: Windows 2003/2000/NT/XP, AIX, Sun Solaris, Linux,Unix

Testing Tools: QTP 8.2, Quality Center 9.2, Test Director

Rational Tools: RUP, Rational Rose, Rational Clear Case, Clear Quest, Test Manager, Robot, Rational Requisite Pro

Methodologies: Star Schema, Snow Flake, Ralph Kimball

Application Servers: Web sphere, Web Logic

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr. ETL/SQL/Data Analysis

Responsibilities:

• Analyzed business and functional requirements to derive test plans, test cases, procedures, and expected results for testing UNIX/Teradata based data warehouse applications.
• Developed Teradata and Oracle Structured Query Language (SQL) test scripts from test procedures and executed them with Oracle's SQLplus and Teradata's SQL Assistant or BTEQ.
• Preventing occurrences of multiple runs by flagging processed date
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory joins and rollups to speed up various Ab Initio graphs.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
• Created test plans and performed unit testing for the Ab Initio graph
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Improved the performance of viewing the Baseline and Actual data from 20 minutes to less than 2 minutes by moving some functionality from Ab Initio to Teradata.
• Validated Extract/Transform/Load (ETL) processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Utilized ClearCase to maintain test documents and record test results, and ClearQuest to log testing errors.
• Tested several UNIX Shell Scripts for job scheduling.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Coordinated integration testing activities with other data warehouse teams and upstream/downstream application test teams.
• Tested several SSIS packages which were migrated from PL/SQL procedures.
• Written Complex SQL queries to validate the data conditions for ETL and BI group.

Environment: Ab Initio GDE 1.15. Co>Operating System 2.15,SQL SERVER 2008, Oracle 10g, Teradata V2R6, Flat Files, XML Files, HP Quality Center (HPQC) 9.2, Erwin 4.0, NEO view DB, SSIS, YOTTA, Caliber RM, Windows XP, Tidal, DB Visualize, XML, ProClarity, WinSQL, TOAD, XSLT, XML Spy 2008, SQL, PL/SQL, T-SQL, Rational Clear Case/Clear Quest

Confidential, Jersey City, New Jersey

Sr. Data/ETL/QA Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• Tracking and analyzing the defects and recording the variation between the expected and actual results
• Experience in Testing data conversions and transformations
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Extensively worked in the UNIX environment using Shell Scripts. Created test cases and performed unit testing for the Ab Initio graphs and documented Unit testing. Logged and resolved defects in the roll out phase.
• Involved in Ab Initio upgrade from GDE 1.13 to GDE 1.14.35.
• Involved in Client Interaction and knowledge Transfer sessions
• Extensively worked in the UNIX environment using Shell Scripts. Created test cases and performed unit testing for the Ab Initio graphs. Documented Unit testing. Logged and resolved defects in the roll out phase
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Different Ab Initio components especially are used effectively to develop and maintain the database
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Prepared extensive set of validation test cases to verify the data
• 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.
• 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
• Collected requirements and tested several business reports.
• Involved in installation of Business Objects XI R2 and assisted in creating users and assigning them appropriate access rights.
• Extensively test the reports for data accuracy and universe related errors
• Created and Tested event based schedules of the reports and built an emailing mechanism to indicate success/failure of the schedule.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• The Rational Clear Quest and Clear Case are also used as test management tool and the repository of the new and existing test cases.
• Perform functional, integration, regression, volume and performance testing and preparing the test reports using rational clear quest and rational clear case is using as repository to maintain new and modified test cases.
• Involved in full cycle of code management and reported defects and initiated Change requests using Clear Quest.
• Consumed existing web services for the retrieval of business logic data from web sphere.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents.
• Written test cases to test the entire application manually.
• Collected requirements and tested several business reports.
• Analyzing the requirements, data sources to be moved to the warehouse.
• 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).
• 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
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Involved in Unit Testing of the system and defining test plans for functional and quality assurance testing of ETL and system integration work flows.

Environment: SQL, PL/SQL, XML, XSLT, XML Spy 4.3, IBM AIX 5.3, KORN SHELL SCRIPTINGAb Initio (GDE 1.14, Co>Operating System 2.14), Rational (RUP, Clear Case, Clear Quest), Terdata V2R6 (SQL Assistant, Fast Load, Multi Load, TPUMP), Oracle 10g, web sphere, Business Objects 6.5.1/XIR2, WebI XIR2, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

Confidential, Well View, TX

Sr. QA Tester

Responsibilities:

• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Was involved in executing the Regression testing on new Builds
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Managed test environments and schedules
• Created, updated and ran the QTP scripts
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders
• Trained the users for the User Acceptance Testing(UAT) and explained about each link, tab and search functionalities to the users
• Created scenario to check the response time using Load Runner
• Performed testing on web services using SOAP UI 2.0 & 2.5
• Tracked bugs using Test Director and generated the defect reports for review by the client and the management teams.
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Tested the Material Management, and Sales and Distribution Modules of SAP

Environment: MS SQL Server, Oracle 11g (SQL, PL/SQL), TOAD, MS Access, Citrix Server, QTP 9.2, Informatica Power Center, Informatica Workflow Monitor, Informatica Repository Manager, Business Objects, XML, Test Director, J2EE, SAP

Confidential

Database Tester

Responsibilities:

• Developed components to retrieve, display and administer the records that are stored onto Oracle database.
• Extensively worked on XML, XSLT for getting the configuration settings depending on locale code, getting user role code, implementing customized show hide matrix, which is used by ASP to display the required operation depending on User Rights, implementing customized property XML file which has all the user details, RMI port details and number of Library Session Connections to be opened during the startup.
• Tested ETL feeds and written complex SQL queries to validate the data based on ETL mapping rules.
• 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.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and Provide Onsite product and network support to clients in administration, maintenance.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.
• Integrated and deployed components belonging to various modules in system test, integration test and production environments.
• Creating Database objects including Tables, Indexes, Clusters, sequences, roles, and privileges.
• Created and coded Functional and Business constraints, packages and triggers.
• Created database tables using various Normalization techniques & Database design rules.
• Developed the ER diagrams showing the flow of data and the relations between tables.
• Used DBCC to check physical and logical consistency of the database and solved page allocation errors and Table corruption.
• Data Upload from MS Access, Excel to Oracle.
• Received for becoming an Oracle DBA.

Environment: SQL, UNIX, XML, PL/SQL, ORACLE, UNIX Scripting, Informatica 7.1, XSLT, XSD