Summary
A results-driven, customer-focused, Database ETL developer with strong 5.5 years of experience in design and integration problem solving skills. Expert in Oracle 10g PL/SQL, Data Stage, Teradata queries, database analysis and design.
Experience
5.5 years of experience in PL/SQL and Data stage/Teradata.
OCA Certified Oracle Programmer.
Worked with Teradata as a Senior Data stage & Teradata Developer for Mccain International Client.
Worked with TATA Consultancy Services (TCS) as a Senior Data stage & PL SQL Developer for Merrill Lynch - Bank of America client.
Worked with 3i-infotech as a Software Developer (PL/SQL) for BPP and Exim Bank of Malaysia.
Successfully executed role of being Onsite Coordinator at Malaysia (KL) for project implementation.
Strong experience in PL/SQL programming - writing packages, triggers, functions and procedures.
Experience in Data Stage tool - Data Extraction, Data Transformation, Data Loading and Data Analysis and in writing queries in Teradata.
Experience in interacting with the client from requirements gathering till user acceptance test (UAT) sign off.
Proven track record of multiple project implementations as a developer and Onsite Coordinator.
A go-getter with positive attitude, who works well in a team or as an individual.
Technical Skills
Technology / Language Details SQL , PL/SQL
ETL Tool Data Stage 8 and 7.5
Databases Oracle 9i/10g , Teradata , SQLServer
Operating Systems Windows XP, Unix
Tools / Packages VSS, SVN, PL/SQL Developer, Toad, PVCS, Data stage 8 and 7.5.
Domain / Functional Area Banking and Financial Services and Retail
Employers History
Employer Name Designation From - To
Teradata (India) Technical Analyst Nov 2011 – April 2013
Tata Consultancy Services(India ) IT Analyst Sep 2010 – Nov 2011
3i - Infotech (India) Sr. Software Engineer Sep 2007 – May 2010
Professional Experience
Employer 1
TeraData, Mumbai, India (Nov 2011 – March 2013)
Projects
McCain SAM Companies (Client: McCain International)
This is basically a data warehousing project where we get the source data from source system and we got it store in into EDW (Enterprise data warehouse). There are 4 steps to load the data in EDW which are staging, CDC, Load, Target and then it gets loaded in PL layer which is queried by the users to generate the reports for different companies.
Role: Data Stage (8.1) and Teradata Developer
Responsibilities
Regular interaction with the client.
Develop processes for cleansing, transforming, extracting, integrating and loading data.
Writing complex queries to facilitate the supply of data.
Worked on parallel Processes.
Worked on almost all kinds of stages and Develop/Enhance Mappings in Data stage Designer and debug issues by viewing data stage director.
Taking part in complex module coding.
Preparing Test Cases, Unit testing, Integrated testing.
Version control.
Technical Environment:
Oracle 10g, Unix, SVN, PL/SQL Developer, Toad, Data stage (8.1 , 7.5 ), Teradata.
Employer 2
Tata Consultancy Services (TCS), Mumbai, India (Sep 2010 – Nov 2011)
Projects
Siperain HUB (Path Xref)/ Siperain HUB (Lead FA) Client: Bank of America – USA
This Siperain HUB was basically to send the file to Path system (stores information of Profiles), which communicates with Hub system for maintaining Client Centric Database.
Lead FA was the project where we had to load the file data into Oracle tables after doing some transformations, related to company cost center no and company Nos.
Role: Data Stage (8.1) and PL SQL Developer
Responsibilities:
Regular interaction with the client.
Develop processes for cleansing, transforming, extracting, integrating and loading data.
Writing complex queries to facilitate the supply of data.
Responsible for using different types of Stages such as Sequential File, Sort, Dataset, Aggregator, Transformer and join, look up, filter, oracle and Funnel etc. develop different jobs.
Understanding Bank of America Standards and policies for any ETL application and working with Merrill Lynch Client for the transition.
Worked on almost all kinds of stages and Develop/Enhance Mappings in Data stage Designer and debug issues by viewing data stage director.
Taking part in complex module coding.
Preparing Test Cases, Unit testing, Integrated testing.
Version control.
Technical Environment:
Oracle 10g, Unix, SVN, PL/SQL Developer, Toad, Data stage (8.1 , 7.5 )
Siperain HUB (Affiliate Sharing) Client: Bank of America – USA
Affiliate Sharing is a module which was based on the visibility of accounts to the clients of Merrill Lynch (Trading Account) /Bank of America (Bank and other Accounts). Like if a client has both the Accounts Trading and Bank Account then it depends on this wish whether he wants to share his visibility with financial Advisor or not or with joint account holder. For temporary visibility we had temporary and durable consent flags. Depending upon the consent flags updated by the clients, we had rules to set the visibility flags as YES or No. For Advisory (High Profile Clients), for California (Location based), for Non Advisory Clients, for Joint Account owners we had different matrix to set the flags.
Role: Data Stage (8.1) and PL SQL Developer
Responsibilities:
Regular interaction with the client.
Develop processes for cleansing, transforming, extracting, integrating and loading data.
Writing complex queries to facilitate the supply of data.
Responsible for using different types of Stages such as Sequential File, Sort, Dataset, Aggregator, Transformer and join, look up, filter, oracle and Funnel etc. develop different jobs.
Understanding Bank of America Standards and policies for any ETL application and working with Merrill Lynch Client for the transition.
Worked on almost all kinds of stages and Develop/Enhance Mappings in Data stage Designer and debug issues by viewing data stage director.
Taking part in complex module coding.
Preparing Test Cases, Unit testing, Integrated testing.
Version control.
Technical Environment:
Oracle 10g, Unix, SVN, PL/SQL Developer, Toad, Data stage (8.1 , 7.5 )
Siperain HUB (Migration from Data stage 7.5 to 8.1) ...
Login or Register to view the full resume.
