PROFILE:

• Over 12 years of experience in Data ware housing area.
• Over 10 years of experience on Data Stage, Teradata&Oracle in Confidential area.
• Good experience in leading a data ware housing team of 5.
• Good experience in financial, Investment and education industry. Have worked for major Banking, Healthcare and Securities
• Experience in Designing an enterprise level data warehousing solution involving heterogeneous source and target systems ranging from SQL Server,DB2,Oracle, Teradata, ESB Services, Dot Net Services, XML and MQ Real - Time.
• Extensively involved in designing infrastructure for ETL and DB for 4-5 TB EDW setup.
• Experience in creating ETL and DB architecture for handling massive loads of data ranging from 500 million to 1 billion on SOA Architecture
• Have Experience in working on Linux/Unix environment.
• Involved in ETL Server upgrades from DataStage 7.5 to 8.1, 8.1 to 8.5 and8.1 to 11.3 across Dev, SIT, PreProd and Prod environments.
• Experienced in working on Slowly Changing Dimension Type I, II and III.
• Have knowledge on sales force cloud environment.
• Architect, Design, Integrate, Develop and implemented enterprise level data ware house solutions using Datastage 8.5 and Oracle 11g on SOA (Real -time) architecture.
• Have hands on experience in implementing large data ware house projects on DataStage.
• Extensive experience in using highly scalable parallel processing infrastructure using DataStage.
• Hands on experience on tuning Oracle and Teradata queries.
• Worked on all Teradata Utilities
• Have expert level of understanding on tuning Datastage jobs, Teradata and oracle SQL queries.
• Expertise in data Confidential projects with heterogeneous system like from Oracle to Teradata database

TECHNICAL SKILLS:

Data warehousing Tools: Data Stage 11.3, 8.7 & 7.5

Database: Teradata, Oracle 11g,DB2

Real-Time: ESB MQ, XML,SOA, Real-Time, Web Services

Programming Languages: Oracle PL-SQL, C & C++

Operating Systems: Sun Solaris, UNIX, Linux and Windows 2000/NT/XP.

Development/Productivity Tool : Control - M, AutoSys

EXPERIENCE:

Confidential

ETL Designer / Analyst Programmer

Responsibilities:

• Client interaction to capture and understand business requirements, and defining project scope.
• Architect, Design, Integrate, Develop and implemented enterprise level data warehouse solutions using Datastage 8.5 and Oracle 11g on SOA (Real -time ) architecturefor Enterprise level data warehouse solution.
• Converting business requirements to project documentation and technical specifications.
• Project Estimations for New DataStage projects and deployment of complex Datastage project.
• Have experience in leading the team.
• Designing an enterprise level data warehousing solution involving heterogeneous source systems ranging from SQL Server, DB2, Oracle, ESB Services, Dot Net Services and MQ Real-Time.
• Fine tuning Data Stage jobs and tuning Teradata Queries to optimize performance. Experience in tuning Teradata tables in production environment to achieve optimized performance benefits.
• Involved in all the phases of project from Requirement gathering, development, Unit testing SIT, UAT, Pre Prod &Prod phases.
• Has good experience & knowledge on Data stage advanced concepts. Worked on Both DataStage Parallel & Server editions.

Confidential

Associate Software Architect

Responsibilities:

• Design and develop DataStage jobs. Maintaning the Datastage Jobs.
• Worked on UNIX scripting for handling enormous reject/error files for different scenarios.
• System Integration Testing & Individually handled DataStage Project deployment into Production.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.

Technologies Involved: DataStage 11.3, 8.1 Oracle and Unix Scripting

Confidential

Technical Architect

Responsibilities:

• Design and develop DataStage jobs. Migrating the Oraclce PL/SQL scripts to Datastage Jobs.
• Worked on UNIX scripting for handling enormous reject/error files for different scenarios.
• System Integration Testing & Individually handled DataStage Project deployment into Production.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.

Technologies Involved: DataStage 11.3, 8.1 Oracle and Unix Scripting

Confidential

Analyst Programmer

Responsibilities:

• Working on implementation of ADS (Authorized Data Source) for Deposits product.
• Has working knowledge on products like Deposits and Loans.
• Involved in ETL Server upgrades from DataStage 8.1 to 11.3 across Dev, SIT & Prod environment.
• Design and develop DataStage jobs for Deposits product to leverage the calculation of Confidential for the bank.
• Worked on UNIX scripting for handling enormous reject/error files for different scenarios.
• System Integration Testing & Individually handled DataStage Project deployment into Production.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.

Technologies Involved: DataStage 11.3, 8.1 Oracle, Teradata,DB2, SAP and Unix Scripting

Confidential

Analyst Programmer

Responsibilities:

• Development and Unit Testing of Data Stage components development, Unit testing SIT, UAT, Pre Prod &Prod.
• Designed and Developed ETL solutions using DataStage and Netezza.
• System Integration Testing & DataStage Project deployment into Production.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.

Technologies Involved: DataStage 8.5, Netezza and Unix Scripting

Confidential, NY

ETL Designer / ETL Team Lead

Responsibilities:

• Contributed in all the phases of project development, Unit testing SIT, UAT&Prod phases.
• Project Estimations for New DataStage projects.
• Worked on UNIX scripting for handling enormous reject/error files for different scenarios.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.
• Successfully implemented two Data Stage projects to production with zero defects.

Technologies Involved: DataStage 8.5, Oracle 11g, SQL Server and Unix Scripting

Confidential, NY

ETL Designer / ETL Team Lead

Responsibilities:

• Involved in designing Enterprise level data warehouse solution using Data stage 8.5 and Oracle 11g on SOA (Real -time ) architecture.
• Contributed in all the phases of project development, Unit testing SIT, UAT, Pre Prod &Prod phases.
• Project Estimations for New DataStage projects.
• Lead the team of 5 Data Stage Developers.
• Designed an integrated meta data framework for capturing row level data flow across source system.
• Designed and Developed real time solutions using DataStage and Oracle 11g.
• Involved in Designing an enterprise level data warehousing solution involving heterogeneous source systems ranging from SQL Server,DB2,Oracle, ESB Services, Dot Net Services and MQ Real-Time
• Worked on UNIX scripting for handling enormous reject/error files for different scenarios.
• System Integration Testing & Individually handled DataStage Project deployment into Production.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.
• Successfully implemented two Data Stage projects to production with zero defects.

Technologies Involved: DataStage 8.5, Oracle 11g, SQL Server,ESB MQ Services and Unix Scripting

Confidential, Boston

ETL Designer / ETL Developer

Responsibilities:

• Handling the role of ETL Designer, involved in designing of data stage components.
• Contributed in all the phases of project development, Unit testing SIT, UAT, Pre Prod &Prod phases.
• Project Estimations for New Datastage projects.
• Development and Unit Testing of Data Stage components.
• Worked on most of the Datastage stages.
• Worked in error handling, reject reprocessing cycles.
• Worked on PL - SQL procedures for handling different scenarios.
• System Integration Testing & support for DataStage deployment environment.
• Fine tuning Data Stage jobs, Queries to achieve optimized performance benefits.
• Creating autosys jobs for scheduling the datastage components.

Technologies Involved DataStage, Oracle 10g, Unix, Autosys

Confidential

ETL Developer

Responsibilities:

• Extract data from the source systems through Datastage jobs.
• Load the extracted file through SuposisSunopsis Packages using Teradata Mload utility.
• Fine tuning Teradata Queries to optimize performance.
• Creating Control - M Drafts to schedule Datastage jobs &Sunopsis Packages.
• Validation the results in the target FSLDM Tables.

Technologies Involved: DataStage, Sunopsis (Oracle Proprietary ETL/ELT tool know as ODI), NCR Teradata

Confidential

ETL Developer

Responsibilities:

• Development and Unit Testing of GDW Data Stage components.
• Fine tuning Data Stage jobs to achieve optimized performance benefits.
• Customizing queries from Oracle to Teradata.
• Fine tuning Teradata Queries to optimize performance. (Hands on experience on tuning teradata queries)
• Hands on experience on all Teradata Utilities (MLOAD, Fast Load, TPump) etc

Technology Involved: Data Stage 7.5, Teradata, Oracle 9i

Confidential

ETL Support

Responsibilities:

• Process the production ETL jobs which include Scheduling
• Auditing, and monitoring Production jobs.
• Audit the output file for threshold limitations, after validation send the processed output file to the client.

Technology Involved: An ETL tool orbiter which runs on Data Stage. A scheduler called Nexus to schedule and run the jobs.