Objective:
Intend to build a career with leading corporate of hi-tech environment that will help me to expose my potential. Willing to work as a key player in challenging and creative environment.
Experience Summary:
Having 7 years of experience in IT industry with strong emphasis in all phases of software development in DataStage and in real time project migration activities.
TCS Experience
7 Year(s)
Designation
IT Analyst
Education:
Qualification Category
Qualification
Subject
Master of Science
M.Sc. IT
Information Technology
Bachelor Of Computer Application
BCA
Computer Application
Standard Xii / H.S.C.
XII
General
SSLC
X
General
.
Technical Skills:
SKILLS
TOOLS
Languages
PL/SQL, Shell Script, DataStage
OS
Windows XP,NT
Tools Used
Toad, SQL+, Business Objects XI R3
Platform
Unix, Windows 95 /NT/XP
Project Details:
Title of Project: SS3X
Client : Banking Client
Environment: Oracle, DataStage 11.3, Shell script
Project Description: The project is to migrate the Sub-servicing project from legacy systems
to ETL tool.
Roles and Responsibilities:
Worked as a Technical lead.
Involved in
1.Requirements Gathering
2.Mapping Document preparation
3.Preparing Technical Design Documents
4.Developing the datastage jobs and involved in unit testing for the same.
Training the new team members
Title of Project: Single Customer View
Client : Banking Client
Environment: Oracle, DataStage 8.5, Shell script
Project Description: The project is to provide single customer view(SCV) flow of eligible claimants aggregated protected deposits in an electronic format.
Roles and Responsibilities:
Worked as a Technical lead.
Involved in requirements gathering.
Developed datastagde jobs to create single customer view for clients.
Used various datastagde components like sort, merge, join as part of the development work.
Extracted data from Oracle database and flat file using datastage, performed manipulations to it and provided the results in the form of files.
Involved in unit testing. Integration testing and system testing.
Title of Project: Issue 45 and Issue 83
Client : Insurance Client
Environment: Oracle, DataStage 8, Shell script
Project Description: The project is to correct the assured claim amount to be paid to the clients which were being already generated by the existing system
Roles and Responsibilities:
Worked as a module lead.
Communicate with the customer for requirements gathering.
Developed datastagde jobs to create fresh claims for clients.
Used various datastagde components like sort, merge, join as part of the development work.
Extracted data from Oracle database and flat file using datastage, performed manipulations to it and provided the results in the form of files.
Involved in unit testing. Integration testing and system testing.
Managing the timesheet compliance of the project associates.
Title of Project: PBSS (Passenger Based Service System)
Client : Airlines Client
Environment: DB2 9.7.3, DataStage 8.5, Business Objects XI R3, Shell script
Project Description: Data migration project. Impact due to source system change
Roles and Responsibilities:
Worked as a module lead.
Performed Impact Analysis for Data Migration projects
Designed and developed data validation, load processes (ETL) using Data stage.
Involved in unit testing. Integration testing and system testing.
Title of Project: MLVS (Message Logging and Viewing System)
Client : Airlines Client
Environment: Oracle Database9i, PL/SQL, Business Objects XI R3, Shell script
Project Description: Reporting system for front-end users using BOXI-R3.
Roles and Responsibilities:
Developed procedures, functions and database triggers using PL/SQL for business rules.
Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression and lookups
Extracted data from Oracle database and flat file, perform mappings and load it into target Oracle tables using External tables.
Set up dimensions, measures and hierarchies for providing drill down options in the reporting environment.
Generate ad-hoc reports using Business Objects XI R3.
Involved in unit testing. Integration testing and system testing.
Personal Details:
Name: Indu Narayanan
Marital Status: Married
Address: No.10, 7th Street,
Karthikayapuram,
Madipakkam,
Chennai – 600091
Passport Details:
Passport Number: G7159234
Valid up to: 30-jan-2018