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

Project Manager

• Team building, task allocation.
• Client interaction.
• Keeping a close watch on systems performance, getting it resolved in case of urgencies or escalations.
• Monitoring progress of each and every project under development closely.
• Motivating team members to perform well under pressure.
• Monitoring pre production and post-production application performance, getting the bugs if any resolved within SLA.
• Keeping close interactions with vendors and third party solution providers like PWC, Oracle for optimum systems performance.
• Getting the critical problems solved on high priority with the team.
• Prioritizing the work as per the business demand.
• Monitoring Optimum Resource Utilization percentage criteria.
• Participating in Effort Estimation for sizing a project.
• On demand meeting with CEO, presenting the entire progress flow, MIS Report, etc.
• On demand technical presentation to business to grab any new projects if any
• Participating in freezing of User Stories with clients.

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

Project Manager

• Working in close coordination with EDW Priority Releases Team to implement Defect Tracking/Fixing Strategies.
• Successfully handling implementation of enhancements and new product launches.
• Working as in interface between Stakeholders' and the Technical Team to implement the products ranging from various modules like:
• Creating project plan.
• Coordinating with team.
• Doing status meeting.
• Following up and making actions plans.
• Ensuring successful completion of projects on time and with cost.

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

Confidential

Project Manager/Business Analyst

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