Sreenath Prakaash

Address: Email: acx2a5@r.postjobfree.com

*/**, ******* *****, *** street, Mobile: +91 - 994*******

Annai Violet college road, Menambedu, Nationality: Indian

Ambattur, Chennai-600053

Professional Synopsis

9.2 years IT experience in managing DW & BI projects like ETL migration, ETL upgrade, performance optimization, disaster recovery solution, EDW development projects, support & enhancements for different clients & gained good subject matter knowledge of ETL factories.

I am a Data Integration expert being an IBM Certified Datastage professional. Played various roles like Service Delivery Manager, ETL Architect, Project Manager, Technical Lead.

Won awards such as ‘Innovator of the year’, ‘Runner up in National HCL Good Practices Conference 7 2014’, ‘Best project of the year’, ‘Livewire’. Contributed / provided many value adds so far in HCL of total value 0.5 million $.

Worked on building development standards, best practices and process development for all SDLC phases in BI Projects. Played an important role in HCLs journey of getting CMMI Services Level 3 certification and ISO certification.

Total Experience:

9 Years 2 months

Experience Summary:

Organization

Designation

From

To

Cognizant Technology Solutions India Pvt Ltd

Programmer Analyst

24 Sep 2007

18 May 2010

HCL Technologies Ltd

Associate Project Manager

20 May 2010

Till Date

Skill Summary:

Skill Area

Skill

Functional Expectation

Sub Components / Product Version

Self Rating

Primary Skills

DW & BI

IBM Infosphere Datastage

Standard Configuration / Implementation

11.5

Subject Matter Expert

Primary

DW & BI

IBM Infosphere Suite 11.5

Standard Configuration / Implementation

Fast track, Information Analyser, Metadata Workbench, Quality Stage, Operations Console

Hands on Experience

Secondary

Databases

Teradata

Programming / Customization / Maintenance

13.0

Hands-on Experience

Secondary

Databases

Oracle

Programming / Customization / Maintenance

11g

Hands-on Experience

Secondary

Databases

DB2

Programming / Customization / Maintenance

NA

Hands-on Experience

Secondary

Databases

Netezza

Programming / Customization / Maintenance

NA

Hands-on Experience

Secondary

DW & BI

Informatica

Standard Configuration / Implementation

Informatica Power Centre 9.1

Basic Understanding (Theoretical knowledge)

Secondary

Big Data

NoSQL

Programming / Customization / Maintenance

NA

Basic Understanding (Theoretical knowledge)

Secondary

Open Source

Hadoop

Programming / Customization / Maintenance

NA

Basic Understanding(Theoretical knowldg)

Secondary

Open Source

Unix

Programming / Customization / Maintenance

7

Extensive Experience

Secondary

Package Solution

MS Sharepoint

Standard Configuration / Implementation

NA

Extensive Experience

Secondary

Engineering Standards

Agile Standards

Capacity – Monitor / User

Scrum

Basic Understanding (Theoretical knowledge)

Secondary

Quality Control

Defect Prevention Analyst

Capacity – Monitor / User

NA

Extensive Experience

Secondary

Quality Control

Project Quality Analyst

Capacity – Monitor / User

NA

Extensive Experience

Secondary

Quality Control

Configuration Controller

Capacity – Monitor / User

NA

Extensive Experience

Secondary

Support

Tivoli Work Scheduler

Capacity – Monitor / User

NA

Extensive Experience

Secondary

Education:

Degree / Certificate

Discipline

Institute / University

Year of Passing

Post Graduation - PGD

HR

Symbiosis

2011

Graduation – BE

ECE

Anna University

2007

Professional Certificate

Communication Studies

Brainbench

2010

Professional Certificate

Interpersonal Communications

Brainbench

2010

Certifications:

Certificate

Discipline

From

To

IBM

Websphere IIS Datastage Enterprise edition

18 Apr 2009

18 Apr 2019

Brainbench

SQL Ansi Fundamentals

01 Dec 2009

01 Dec 2019

Calydon Tech

Datastage Developer 3

11 Nov 2009

11 Nov 2019

Project Details:

Project

Leaseplan Smart Extracts

Duration

Jan 2016 – Dec 2016

Team Size

10

Role / Position

Senior Technical Lead

Project Description

Reverse engineering project to replace legacy application extracts which are 35+ years old, with Infosphere Datastage ETL jobs. Objective of this project is to develop a centralised ODS layer to integrate data from 23 different countries core leasing systems (NOLS). The ODS data is then to be populated into EDW. Source systems are in iseries DB2 / RPG programs & Teradata databases and target ODS is built in Netezza.

Technical Environment

Infosphere Information Analyser 11.5, IBM Netezza, Aginity workbench, DB2, Teradata, Unix, Control M

Responsibilities

Acquired knowledge from customer SMEs in short span of time and delivered as per customer expectations

Mentored the team and helped onboarding team members who had no prior BI projects working experience to deliver as per project need

Owned the delivery of ODS & EDW for entire Portugal country

Prepared development standards, updated coding framework, test strategy, accelerators, value adds

Achievements

Acquired knowledge from customer SMEs in a short span of time and shared the knowledge to rest of the team. Worked as a Sr. technical lead and owned the delivery of ODS for entire Portugal country. Mentored the team and helped onboarding team members who had no prior BI projects working experience to deliver as per project need. Provided ideas like automated view generation, automated analysis of source data keys through information analyzer and changed coding approach from near real time to full refresh.

Project

LBG Commercial Banking Risk Support

Duration

July 2013 –Feb 2016

Team Size

21

Role / Position

Service Delivery Manager – BIS

Project Description

Support and enhancement of RDW (Risk Data Warehouse), Business objects end user reporting. RDW is a business intelligence system used by LBG Commercial Banking Risk Systems team for risk profiling and risk analysis of customers. The RDW system consists of 40+ datamarts held together using conformed dimensions into a datawarehouse. It has been built on Oracle 11g, Datastage 9.1 and unix.

Technical Environment

IBM Infosphere 9.1, Unix, Oracle, Maestro, Support & Maintenance, Business Objects XI3

Responsibilities

As a Service manager, involved in the following activities: • Understood scope of the project and contributed to preparing, updating of project overview and understanding documents •Mentored junior resources for developing the entire team and improving service delivery. •Worked closely with customer at onsite and developed good rapport and support for the team with all stakeholders •Groomed the team to handle all high severity issues to develop SMEs within the team •Managed and constantly monitored the SM7 queue and assigned incidents to resources based on their availability • Handled any ageing problem records / escalated incidents and acted as a solution provider / problem solver •Provided root cause fixes for long term recurring issues and reduced inflow of incidents

Achievements

Interacted closely with customer stakeholders like Project Managers, Service Managers, SMEs, platform lead etc during my tenure at onshore and developed a good working relationship for the team. This avoided many escalations and improved customer satisfaction. Implemented / facilitated implementation of value adds worth 15000 GBP. Managed to handle increase of 35% support scope without increasing team headcount and maintaining same service levels for customer. Sustained 25% incident reduction year on year exceeding customer expectations.

Project

LBG Wholesale BI Application Support - PSA

Duration

22 Nov 2010-30 Jun 2013

Team Size

13

Role / Position

Project Lead

Project Description

Support and enhancement of BIR (Business Intelligence Repository) and Business objects end user reporting. BIR is a business intelligence system used by LBG Wholesale Data Risk Systems team for risk profiling and risk analysis of customers. The BIR system consists of 40+ datamarts held together using conformed dimensions into a datawarehouse. It has been built on Oracle 10g, Datastage 7.5.2 and unix.

Technical Environment

Datastage, Unix, Oracle, Maestro, Support and maintenance

Responsibilities

As a Project Lead, involved in the following activities: • Understood the scope of the project and contributed to preparing, updating of project overview and understanding documents • Mentored junior resources for developing the entire team and improving service delivery. •Took the responsibility of being an active Configuration Controller, DPA and PQA for my project cyclically • Handled all high severity issues in different datamarts of BIR and grew into an SME •Managed and constantly monitored the SM7 queue and assigned incidents to resources based on their availability • Handled any ageing problem records / escalated incidents and acted as a solution provider / problem solver •Monitored the BIR batch and handled batch failures • Provided root cause fixes for long term recurring issues and reduced inflow of incidents

Achievements

• Developed standard questionnaire to facilitate handover to support from project team

• Developed housekeeping process to identify orphaned obsolete files to reclaim space periodically, improving system performance and reducing storage costs.

• Formulated periodic application services restart mechanism to flush out idle / zombie processes improving system performance

• Pioneered application Portfolio optimization by decommissioning old feeds / datamarts not used by business

• Prepared a validation framework to check monthly Basel II risk reporting data sent by customer to regulator. This created an assurance to business that their data is being validated by IT before being sent to Finance and then onto regulators

• Lead the business objects support colleagues to document knowledge gaps, highlighted the same to customer and enabled a business objects support resource to travel onshore and receive refresher KT to close down knowledge gaps.

• Provided many value adds worth more than 300000$ like BIR Batch improvements, Sev3 incident reduction initiative, Automated Queue Monitoring tool - Hawkeye

Project

LBG Wholesale - BI Enhancements

Duration

27 Aug 2010-21 Nov 2010

Team Size

3

Role / Position

Design Lead

Project Description

This project involves performance tuning and performance improvement of BIR (Business Intelligence Repository). The BIR batch was running for about 16 hrs daily and the execution time of the batch had to be brought down to about 14 hrs to facilitate data availability for users on time. This project has resulted in saving about 1.5 hours of batch run time daily, making data available to hundreds of users in LBG 1 hours earlier

Technical Environment

Datastage, Unix, Oracle, Maestro, Design, Performance Tuning, Development

Responsibilities

As a designer lead, involved in the following activities: • Understood the scope of the project & contributed to preparing, updating of project overview & understanding documents • Handled a team of 3 members in the analysis of mapping(spec), design, development, review, unit testing and documentation of deliverables. • Participated actively in design activities, preparation of MLPD, validation of design approaches, preparation & validation of DPAD.

Achievements

This project is saving about $10100 per annum of direct support resource cost for LBG and much more in terms of indirect savings by making data available earlier for users. Published a white paper on Datastage best practices in Arkemedes

Project

LBG Mortgage Integration

Duration

24 May 2010-26 Aug 2010

Team Size

30

Role / Position

Module Lead

Project Description

Integration of Mortgage BI Sales & Servicing systems of HBOS, Lloyds bank, Scottish widows & other banks which have merged to form “Lloyds banking group” LBG. Using Datastage ETL, Oracle 10g Mortgage Data Warehouse, Teradata transactional source system, Financial Services Logical Data Model (FSLDM) & unix/linux environment the sales & servicing systems are being integrated

Technical Environment

Datastage, Unix, SQL, Oracle, Teradata, Maestro

Responsibilities

As a module lead, involved in the following activities: • Understood the scope of the project & contributed to preparing, updating of project overview & understanding documents • Handled a team of 3 members in the analysis of mapping(spec), design, development, review, unit testing and documentation of deliverables related to a subject area(module) called ‘Product’. • Prepared Data stage V8.1 coding standards, naming standards and best practices documents for the project • Participated actively in design activities, preparation of MLPD, validation of design approaches, preparation & validation of DPAD. • Participated proactively in target stream mapping of different subject areas. • Participated actively in data mapping review and query logging • Mentoring freshers to understand BI concepts, Data stage concepts and work on various requirements in the project

Achievements

Presented sessions on various topics like Datawarehousing basics & BI, data stage basics, parallelism concepts, configuration options in Data stage, differences between data stage V7.5 and V8.1, Handbook preparation, Project KT for new incumbents, XML in Datastage, Stress management, etc

Project

Analytical Disaster Recovery

Duration

July 2009 – May 2010

Team Size

6

Role / Position

Module Lead

Project Description

ADR is an EDW upgrade project which provides a customized disaster recovery solution to backup DB2 prod and DR databases using shell scripts.

Technical Environment

Datastage, Unix, SQL, Control M, SVN

Responsibilities

Scoping, Design and development of disaster recovery system.

Designed and developed disaster recovery project for the client using shell scripts for recovering the Business intelligence system and data in case of any disaster. This has helped the client from many crisis situations even during earning preparation.

The project ADR (Analytical Disaster recovery) which is a disaster recovery & database synchronization project involves synchronization of production & disaster recovery(DR) Databases by creating various business rules encompassing a wide range of data created by numerous processes running in the current production environment.

Since this project has to synchronize the data in production & DR DB, it has to consider the entire set of business rules by which data was loaded in production DB for the past 10+ years.

Coordinating and participating in various Quality Assurance activities like Metrics Collection and Analysis, Quality Audits, Preparation of Quality Documents for the Project

Issue tracking, preparing and publishing weekly status reports and project monthly reports to client

Achievements

Took the responsibility of designing a complete Disaster recovery Application for my client. Lead the project EDW upgrade (Analytical Disaster Recovery) which is a complex Disaster Recovery application completely developed using shell, perl scripts and DB2.

Project

Datawarehousing BIS Development

Duration

Jan 2009 – June 2009

Team Size

15

Role / Position

ETL Developer

Project Description

Development of new BI requirements and enhancement of existing BI feeds in customer’s enterprise banking DW.

Technical Environment

DataStage, AB Initio, BO, DB2, PL/SQL, Shell Scripting, Perl

Responsibilities

Design and development of Various Datastage ETL development projects.

Interaction with Source Data bases like Oracle, DB2, and Sybase used to extract, transform and load the data finally in to Data ware house.

Co ordination of development of the projects undertaken at offshore.

Developed 12 processes providing bank, brokerage and credit card based solutions to clients

Test Environment set-up & System Test plan and test procedure.

Handling Production support/maintenance activities for batch optimization, check-in and deployment of the code in production.

Involving various Change management activities for successful roll of code in to production.

Coordinating and participating in various Quality Assurance activities like Metrics Collection and Analysis, Quality Audits, Preparation of Quality Documents for the Project

Achievements

Learnt the landscape and existing feeds, interfaces, etc in a short timescale and performed exceedingly well in the project. Delivered 12 different modules within 6 months and was appreciated by customer for my contributions.

Project

BIS ETL Migration

Duration

Nov 2007 – Jan 2009

Team Size

30

Role / Position

ETL Developer

Project Description

Migration of all the BIS processes to Datastage environment from the present Batch Framework which works primarily in AB Initio and UNIX and bring all the BIS processes handbooks to Wiki Format to support the Batch Framework standards..

Technical Environment

DataStage, AB Initio, BO, DB2, PL/SQL, Shell Scripting, Perl

Responsibilities

Understanding and analyzing the existing Ab Initio graphs for their ETL logic

Designed the ETL migration utility for metadata conversion

Developing Datastage jobs for the corresponding Ab Initio graphs and testing them

Fine Tuning of Datastage jobs to aid parallelism

Development of wrapper scripts to run the DS jobs using an external scheduler like Control-M

Testing, Reviewing and Quality process

Conducting internal training to share the project experience to the team

Analyzing data issues and fix bugs

Preparing test cases and test logs

Achievements

Developed many tools using VB macros to accelerate migration of Ab-Initio ETL code to Datastage by reverse engineering the ETL logic into export / excel template conversion / import.

Training:

Training

From

To

Netezza Basics

15 Feb 2016

17 Feb 2016

Big Data and Hadoop Basics

15 Jun 2015

19 Jun 2015

Agile Scrum Basic certification

09 Nov 2015

13 Nov 2015

ASM Intermediate

05 Sep 2013

06 Sep 2013

CMMI SVC Model

16 Aug 2011

16 Aug 2011

Teradata foundation

27 May 2010

28 May 2010

IBM Infosphere suite (Datastage, Quality Stage, Information Analyser, Fast track, DQ Console)

04 Jan 2010

08 Jan 2010

Other Details:

Domain Expertise: Banking, Data warehousing

Location Preference: Europe, USA, Canada, ANZ.

Contact this candidate