Datastage Developerr

KRISHNAPRASATH R

Data Specialist ETL-Datastage

Infosys limited, Chennai, India

Emp No:- 680729

Email: ***************@*****.***

Mobile: +91-950*******

Objective

To use every opportunity available to prove my proficiency and to take every challenge as a learning process to update my technical and soft skills in a diversified environment.

Professional Experience

S.No

Company

Role

From

To

1

Infosys Limited

Senior Systems Engineer

Nov-14

Present

2

Bahwan CyberTek

Trainee

Oct-13

Feb-14

Joined as a Systems Engineer Trainee in Infosys and Currently serving as Senior Systems engineer role after successful progression.

Have been playing the role of a ETL developer and as a lead in few projects.

Key Skills and competencies

Key Skills and competencies:

Over 3 years of experience as ETL developer and application specialist

Experience in Data stage tools like Data stage –Administrator, Designer, Director

Excellent experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts

Worked extensively with Data migration, Packaging, ETL Processes for data warehouses

Experienced in scheduling Sequence and parallel jobs using UNIX scripts and Scheduling tool (Autosys)

Extensive experience in Unit Testing, Functional Testing, Integration Testing, Regression Testing and Tech Testing.

Worked with various databases like IBM DB2 10.1.0, Oracle 10g and Oracle 11g

Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism

Played significant role in various phases of project life cycle, such as Initiation, Planning, Execution and Closure

Good communication skill and experience in customer interaction with respect to project discussion, weekly status meeting and execution discussion

Worked in Project proposals and estimations

Accomplishments:

Done a Process automation using Unix and Java on self-interest, which resulted in 40K+ USD for client and awarded as ‘Best Zero Distance’ for last year

Received ‘Most Valuable player award’ in unit level in 2015-2016 for leading the team in efficient way

Received ‘Bug free developer award’ for deploying zero defect code in production for 2 consecutive years

Received ‘Insta Award’ within the organization consecutively in three quarters, calendar year 2016-17 for superior performance

Duties & Responsibilities

Used to handle onshore activities, during onshore resource absence

Production components creation and validation

Preparing Design documents, Traceability matrix, Test Scenarios and Test Cases

Design and code review for rest of the team members

Communication with Technical Team and Management

Sharing estimates to Management for upcoming projects

Leading the team and managing efficiently

Technical Skills

ETL Tools used : Data stage 9.1

Computer Language : SQL, MDM, Basics of Unix, Mainframes, HTML and Java

Cloud : Azure

Project Details

Project 1: Leading US Bank – MDM Bridge LLE Automation

Description: Project Deals with scaling up an environment similar to Production environment, to ensure all process of Batch cycle runs in scheduled way eradicating manual error and intervention and to ensure that files are delivered are within deadline along mailer notification in automated way. A new process is built integrating Jar and Data stage to compare the data of the tables across upstream and our application.

Domain: Banking

Duration: 4 Months

Team Size: 2 members

Role: ETL Data Stage Developer

Roles & Responsibilities:

Problem identification and analysis

Design document and test script preparation

Build, Coding, Testing, Bug Fixing

Creating Unix scripts

User Acceptance Testing

Our implementation eradicated the dependency of a support team

Communication with distributed teams and customer to maintain integrity of the code

Project 2: Leading US Bank – Reference Data Management

Description: Project deals with storing country code formats of different standards such as ISO, IRS, etc and create a mapping between the standards.

One of the largest Bank in US which provides services to customers across the globe. Internal applications of bank were using different standards instead of generic standard and faced challenges while communicating to other applications. We have created a master database in DB2 tables which contains all standards and ETL jobs were coded to load the data, to extract the data and to create mapping files across standards.

Domain: Banking

Duration: 5 Months

Team Size: 2 members

Role: ETL Data Stage Developer

Roles & Responsibilities:

Requirement analysis and Design documents preparation

Creating Table Structure, SQL queries and executing them

Creating excel load sheets and Coding/Testing ETL jobs

Test case preparation and execution

Traceability matrix maintenance

Coordinating with Business Governance team regarding load data

Build, Coding, Testing, Bug Fixing

Communication with distributed teams and customer to maintain integrity of the code

Project 3: Leading US Bank – Consent extract

Description: Project Deals with extract of different category customers with the consents they have signed off for the day.

As per terms, consent handed over to our application since existing application is receiving huge traffic. We have created separate table to store the same through API calls, which will be extracted on Daily/Monthly basis and functional logic will be applied on the extracted data and delivered to consuming application.

Domain: Banking

Duration: 4 Months

Team Size: 6 members

Role: ETL Data Stage Developer

Roles & Responsibilities:

Requirement analysis, design document and test script preparation

Build, Coding, Testing, Bug Fixing

Creating DS/Non-DS Components

User Acceptance Testing

Coordination with Business team regarding manager customer confidential information

Building, Coding, Testing and Bug Fixing

Communication with distributed teams and customer to maintain integrity of the code

Other product/usage experience

Good exposure in Report Generation Tool for Data Science i.e. Tableau 9

Worked on Autosys Scheduling Tool

Educational Qualification

Course/ Exam

Institution

Year of Completion

Aggregate

(%/ CGPA)

Remarks

Bachelor of Engineering (Electronics and Communication Engineering)

SriGuru Institute of Technology, Coimbatore

2013

7.8

Department topper in Mathematics & Computer Science & Subject topper in Engineering graphics

Higher Secondary (XII)

Erode Hindu Kalvi Nilayam, Erode

2009

87%

99% in Mathematics & 97.5% in Computer Science

Matriculation(X)

Reliance Matriculation School, Namakkal

2007

88%

99.5% in Mathematics

Personal Details

Father’s name : Mr. S.Ravichandran

Date of Birth : 30th September, 1991

Sex : Male

Marital Status : Single

Current Location : Chennai

Hobbies : Outreach to schools, Gardening and Drawing

Contact this candidate