Consultant - ETL Developer
Resume:
Neelesh Kaja
*******.****@*****.***
Professional Summary
●Emergent software developer with 3.5 years of IT experience in software design, development and deployment of large and complex software applications.
●Involved in Data Requirement Analysis, Design, and Development of ETL process using IBM Data Stage 8.5 (InfoSphere Information Server) Data Stage Designer, Data Stage Director and Teradata.
●Experience in Data Warehousing applications, responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
●Experience in using various sources like Fixed Width files, Field Delimited Files and Oracle.
●Knowledge in Data Warehousing concepts like Snowflake Schema, Star Schema and ETL.
●Good knowledge on best ETL practices to follow for loading the data into Data warehouse/Staging based on business requirements.
●Excellent analytical, interpersonal and communication skills with aptitude to assimilate new technologies.
Technical Skills
ETL Tools
Data Stage
Databases
Oracle 10g,Teradata
Operating Systems
Windows 7, UNIX
Tools
SQL Developer, SSH Tectia Client, MS Office,Open Office
Qualifications
Degree and Date
Institute
Percentage
B.Tech – 2012
V.R.Siddhartha Engineering College, Vijayawada, Andhra Pradesh
75
Intermediate - 2008
Sri Chaitanya Junior College,Vijayawada,Andhra Pradesh
92.5
Matriculation - 2006
STBEM English Medium School,Vijayawada,Andhra Pradesh
82
Career Profile
Dates
Organization
Role
Nov 2015 - Till Date
CITI Bank through Emerio GlobeSoft Pte Ltd, Singapore
Consultant
June 2012 - Nov 2015
Tata Consultancy Services, Chennai
Software Engineer
Awards and Appreciations:
●Got TCS “On Spot Award” for completion of the Project with in Short period of time
●Received Appreciation Certificate from Client, for implementing CEMEA NextGen Project successfully.
PROJECT EXPERIENCE
Client
Project Name
: CITI Bank
: AML Athena G2
Period
Role
: Nov 2015 – Till Date
: Infrastructure Support
Tools/Technology Used
: Data stage V9.1,Oracle 11g, Unix
Description: This project is developed to generate Resumes and Insights for the data that is available in Mantas application, where it consists of alerts generated for all the fraud transaction. Data is loaded from Mantas and other applications is loaded into multiple layers and finally loaded to insight database after applying business logics to generate resumes for all the cases generated, which in turn will be available in the front end system.
Role and responsibilities:
Co-ordinated with several teams to create the environment setup.
Executed end to end SIT and UAT batches.
Fine tuning of the jobs has been performed, which helped to increase the performance of the batches.
Automated Data stage Jobs Using Autosys.
Client
Project Name
: CITI Bank
: NextGen
Period
Role
: Aug 2014 – Nov 2015
: Developer
Tools/Technology Used
: Data stage V8.5,Teradata 13.0, Oracle 11g, Unix
Description: The project is developed UK, Czech, Russia, UAE, Hungary and Poland. We have enhanced all the legacy systems to the NextGen DWH with initiative of Rainbow program, to have common platform across all the countries. Along with enhancement of all the systems we have also improvised the code to meet new business requirements.
Role and responsibilities:
Involved in Analysis and Effort estimation for project architecture.
Analysis, design and review of the Data Stage Jobs.
Exporting and Loading data through Teradata utilities.
Preparation of Unit Test Cases for giving out a quality deliverable.
Exporting and Importing of the jobs into UAT and preparation of the Implementation Plan for deployment into Production.
Coordinating with business and fixing the issues of UAT to get sign off and promoting to Jobs to Production
Handling Ad hoc queries and Change Requests.
Automated Jobs Using IBM Tivoli Workload Scheduler.
Client
Project Name
: CITI Bank
: SCV (Single Customer View)
Period
Role
: Oct 2013 – July 2014
: Developer
Tools/Technology Used
: Data stage V8.1,Oracle 11g, Unix
Description: This project is developed for UK business. This is a downstream application, where two files will be generated and sent to business, which consists of all the customer and account level information which is useful for bank during time of crisis.
Role and responsibilities:
Requirement gathering and Estimation, information delivery, design and infrastructure service
Involved in the Analysis and Effort estimation for project architecture.
Analysis, design and review of the Data Stage Jobs.
Generate output file as per the client requirement
Preparation of Unit Test Cases for giving out a quality deliverable.
Client
Project Name
: CITI Bank
: CEMEA Poland Tactical
Period
Role
: Jun 2012 – Sep 2013
: Developer
Tools/Technology Used
: Data stage V7.5, Oracle 10g, Unix
Description: The project is developed for Poland. DWH will be receiving files from different product processors on a daily basis and these files are processed based on the business requirements and loaded into different Tables as per the data model.
Roles and Responsibilities:
Involved in the migration of Data Stage jobs from Development stage to Production environment.
Requirement Analysis, Estimation, information delivery, design and infrastructure services.
Developed Parallel jobs using stages like Join, Lookup, Aggregator, Transformer, Oracle Enterprise Stage, Dataset, Funnel and Change Data Capture.
Participated effectively in execution of projects to support development and integration.
Having regular calls with the business in understanding the changes required.
Loading source data that is received in the fixed-width file format with client’s specification.
Personal Details
Date of Birth
19-07-1990
Nationality
Indian
Marital Status
Single
Passport No
J4291749
Language Known
Telugu, English, Hindi
Contact this candidate