Developer Engineer

Poulosty Das

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

Cell: +91-990*******

Objective

To contribute professionally towards the fulfillment of the objective of the company. Work in the most challenging position with an organisation that provides ample opportunities to learn and to contribute. I am flexible and willing to work on any technology.

Professional Summary

• Experienced ETL/Report Developer in AB-INITIO, PLSQL and UNIX with the ability to scope and execute projects efficiently and provide targeted analytical insights.

• Having good communication skills, inter-personal skills, dedication and professionalism, seeks to enhance self-growth and contribute to the growth and development of the organization.

• Good knowledge on Data Warehousing.

Experience Summary

I am having total experience of 6.2 years as an software engineer. I am currently working as senior software engineer in HCL tech from the past 1.3 years. Previously I was associated with Tata Consultancy Services for 4.3 years .I have primarily worked in a Data Warehousing Project of a Telecom firm (British Telecomm) and in banking and financial services (JP Morgan chase, CITI security and fund services). I am currently working in the grade of Senior software Engineer with a role of ETL Developer. My technological fortes are Ab-initio, PL/SQL, UNIX.

Experience Summary

Duration(Years)

Abinitio v3,Abinitio BRE

4.2

Oracle Pl/sql,Unix

1.8

Technology

Below is a list of important hardware, software products, tools and methods that I have worked with.

Hardware

Software Products

Tools

Methods

Intel Pentium 4 with 3GHz Processor

OS :

UNIX

WINDOWS XP

Programming Languages:

ORACLE(PL/SQL)

PL/SQL Developer 7.1.5

Putty

Defect Management system(DMS)

ETL Tool :

Ab-initio V3,Abinitio BRE

PL/SQL Developer 7.1.5

Unix

Version Control Tool:

Sub-Version(SVN)

Agile Methodology

Qualifications

Degree and Date

Institute

Aggregate

B.Tech in Computer science and Engineering,2008

Silicon Institute of Technology.Bhubaneswar.

70.07%

12th,2003

J.K.B.K junior college.cuttack

64.44%

10th, 2001

Kendriya Vidyalaya,Cuttack

80.66%

Project Details

CITI SECURITY AND FUND SERVICES ETL development:

CITI is an American multinational financial services corporation headquartered in Manhattan, Newyork city, United states. The other division of citigroups are citi institutional client group, citi global consumer banking, Citi international personal bank, global wealth management services.

As a team member, I am currently a part of offshore team in a role of Abinitio ETL developer responsible for design, development, testing, deployment of graphs, packages and support for UAT and SIT environment.

As a part of development, We receive the business requirement document from the functional team. After that we need to analyse the functional document, the requirements and identify the technical changes that need to be implemented and we proceed with our development and testing. After implementation of the changes and unit testing, we promote the graph to SIT and then after sign off from SIT team we promote to UAT and then to production. The preproduction document is released and sign off from the user before it is implemented in production.

Project

CITI SECURITY AND FUND SERVICES

Application

MFIC DW extraction and Infocentre reporting

Description

In MFIC extraction, our process fetches the data from the source, validate it and then process it and generate files which need to be sent to downstream system like FSR, confluence unity. We have EOD extraction which runs once daily and intraday extraction which runs frequently based on the time limit provided by downstream system.

Duration

July 2013 to Till Date

Location

Bangalore

Role

ETL Developer

Solution Environment

Ab-initio v3.1,UNIX, Database-Oracle 10g, Autosys

Tools

PL/SQL Developer 7.1.5, Putty, Ab-initio - V3

Responsibilities

Analysis of the functional document provided by functional team.

Identifying the changes need to be done in the graph, packages and scripts.

Adding the technical design in the design doc and proceeding with the development..

Development of the Abinitio graph,packages, scripts.

Preparation of Unit test case document and running the unit test cases and logging it in design doc in the test case section..

After Passing of Unit test cases moving the code to SIT testing.

After SIT testing, moved to UAT environment for E2E testing by user..

After UAT signoff, pre production document is prepared, KT is given to production team and thenb code promoted to production..

SAUDI TELCOMM ETL MIGRATION AND DEVELOPMENT

The Saudi Telecommunication Group provides integrated mobile, fixed and broadband communications services to over 160 million customers globally. Headquartered in Riyadh, Saudi Arabia, Saudi Telecom Company (STC) is the largest telecommunications company by market capitalization, total revenue and number of employees in the Arab State region.

As a Team member I was a part of ODS team responsible for the maintenance and migration of the data stage ETL jobs to Abinitio ETL graphs. As a part of 1st phase of development we initially get the updated data stage jobs from the current production environment After getting the required information we proceed for the high level design document including the functionality of the current datastage jobs. Once the High level design documents is finalised we proceed for the low level design document and along with that started the development of Abinitio graphs. After the low level design and coding is completed, the same is being reviewed by the client. Once the low level design and the code get approved we started the unit testing of the code and move the code to SIT environment and then to UAT and production environment

Project

STC ETL MIGRATION AND DEVELOPMENT ODS

Application

Migration of datastage code to Abinitio v3.1

Description

STC migration and ETL development an ETL Migration project where the datastage code is implemented in Abinitio .In datastage there are many jobs in ODS where the ETL processing takes place and the output files are generated or loaded to different tables.. The same datastage code need to be analysed, designed and then implemented in Abinitio code.

Duration

Mar 2013 to May 2013

Location

Bhubaneswar

Role

Developer

Solution Environment

Ab-initio v3.1,UNIX, Database-Oracle 10g

Tools

PL/SQL Developer 7.1.5, Putty, Ab-initio - V3

Responsibilities

Analysis of the data stage jobs in the current production environment.

Preparing high level design document based on the data stage jobs functionality to be implemented in Abinitio.

Preparing low level design document which include the design approach for implementing the datastage jobs in Abinitio.

Development of Abinitio graphs, unix scripts as per requirement.

Preparation of Unit test case document and running the unit test cases logging the defect.

After Passing of Unit test cases moving the code to SIT testing.

E2E testing of the graphs using the sample file provided by the client.

After SIT testing the code is moved to UAT environment and after testing in UAT code is moved to production.

BNP PARIBAS ETL DEVELOPMENT

As a team member, I have done ETL development for the migration of VB code to Abinitio for different application of BNP Paribas project. We follow the agile methodology for the development and deployment of code in production. Based on the Functional and technical document given by the Client for a particular application VB team analyse the code and prepares a high level design document based on the VB code. Abinitio team based on that high level design doc prepares a low level design doc of migrating the VB code to Abinitio graph. After the design phase is over the graph build starts and after the unit testing of code is over, the code is deployed in SIT environment and then to UAT and production environment. During development we generally follow OTD (on time delivery) and RFT (right first time).

Project

BNP Paribas ETL Development

Application

Migration of VB code to Abinitio v3.0

Description

BNP Paribas is an ETL Migration project where the VB code is implemented in Abinitio .In VB there are many application where the ETL processing takes place and the output files are generated or loaded to different tables.. The same VB code need to be analysed, designed and then implemented in Abinitio code.

Duration

Dec 2012 to Mar 2013

Location

Bhubaneswar

Role

Developer

Solution Environment

Ab-initio v3.0,UNIX, Database-Oracle 10g

Tools

PL/SQL Developer 7.1.5, Putty, Ab-initio - V3

Responsibilities

Analysis of the high level VB document provided by the VB team for different applications.

Preparing low level design document of the VB code to be implemented in Abinitio(Elementm v3.0).

Development of Abinitio graphs, unix scripts as pr requirement.

Preparation of Unit test case document and running the unit test cases logging the defect.

After Passing of Unit test cases moving the code to SIT testing.

E2E testing of the graphs using the sample file provided by the client.

After SIT testing the code is moved to UAT environment and after testing in UAT code is moved to production.

J.P MORGAN CHASE ETL DEVELOPMENT

As a team member, I have done ETL development for the application LRR– India and LRR - Indonesia. We follow the agile methodology for the development and deployment of code in production. We started our development based on the design mapping document provided by client which generally have the mapping of different target columns with the source column and their population logic. We generally build the graph and write business rule xfrs based on the transformation logic. After the development is over, the code is deployed in SIT (system integration testing) environment for testing. After SIT, code is deployed in UAT environment after all the fixes finally prepared to be deployed in production environment. We then prepare the deployment plan to deploy the code in production environment on the date agreed with clients. During development we generally follow OTD (on time delivery) and RFT (right first time).

Project

APAC- LRR India, APAC- LRR Indonesia

Application

J.P Morgan Chase

Description

APAC LRR India and LRR Indonesia is a data warehousing project. Data from various sources is kept in the landing path from where ab-initio graph pick up the data validate, process them and then load these data to different staging table. After which according to business requirement the reports are generated and sent to customer via mail.

Duration

Aug 2011 to Nov 2012

Location

Bhubaneswar

Role

Developer

Solution Environment

Ab-initio - V3,Abinitio BRE, UNIX, Database-Oracle 10g

Tools

PL/SQL Developer 7.1.5, Putty, Ab-initio - V3

Responsibilities

Analysis of the requirement.

Analysis of the design mapping document, ETL mapping Documents shared by Client.

Analysis of the existing generic graph for reusability if applicable for a specific business scenario.

Development of graphs, scripts, business rules xfrs for the validation and processing of data.

Preparing the unit test cases for the business requirement.

E2E testing of the graphs using the sample file shared by clients.

Migrating the code to SIT environment.

After SIT testing the code is moved to UAT environment and after testing in UAT code is moved to production.

Project Details

BT Group plc is a global telecommunication Services Company headquartered in London, United Kingdom. It is the largest telecommunications services company in the world. BT Wholesale is a member of the BT Group plc: the holding company for an integrated group of businesses that provide voice and data services in the UK, elsewhere in Europe and around the world.

BT WHOLESALE DEVELOPMENT

As a team member, I have done development for the application wholesale calls, 20CN broadband orders and faults. In BT we follow the agile methodology for the development and deployment of code in production. After the design phase is over, we started our development based on the solution design document provided by designer. After the development is over, the code is handed over to SIT(system integration testing) team for testing and in parallel it is handed over to performance team with the performance spreadsheet that records the time taken,volumetrics for each new query and changed query for performance suggestion(if any). After SIT, code is handed over to E2E testing team to test the code in an environment that is similar to production environment. Code that is tested in E2E environment with all the fixes finally prepared to be deployed in live environment. We then prepare the deployment plan and automated scripts to deploy the code in production environment on the date agreed with clients. During development we generally follow OTD (on time delivery) and RFT (right first time).Post deployment we provide production support for 3 months until the transition has been given to Support team.

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Project

BIP 20CN broadband Reporting

Application

Broadband customer Reporting for Faults (BBCR),20CN asset list reporting,Market3 Billing, Broadband customer Reporting for Orders (BBCR) 20CN,Wholesale calls

Description

BBCR Fault reports generally show the status and various attributes of the faults for client analysis. The reports are build using actuate. Reporting is done from MART.

Broadband Asset Reporting reports all the active and inactive service id’s that belongs to a customer so that can get all the related information for all service id’s that belong to that particular customer. Generally 6 csv reports are sent to customer as a part of this reporting.

Broadband Inventory Feed are send to the downstream source for all the active and inactive service id’s that are present in the integration layer in BIP database .So that downstream source can get all the related information to generate the report for client analysis.

Broadband Orders reports generally show the status and attributes of the orders that are being raised until the orders are completed. These reports are build in actuate.

Duration

Aug 2010 to Aug 2011

Work Location

Bhubaneswar

Role

Developer

Solution Environment

Database-Oracle 10g, WINDOWS XP,Actuate

Tools

Abinitio V3.0,PL/SQL Developer 7.1.5, Putty, Sub-Version(SVN)

Responsibilities

Analysis of the existing application.

Analysis the design documents and requirement for the change.

Preparing the unit test specification listing the test case as per requirements.

Developing and modifying various procedures, packages and Graphs as per requirement.

Developing automation unit testing scripts.

Performance testing for the changes.

Presenting the changes to BT and TCS TA team for approval.

Preparing deployment plan so as support team, DBA team are aware of the new changes before deployment.

Post production support for 1 month for the changes made in production environment.

Project

BIP 20CN Broadband Reporting

Application

20CN Broadband Orders and Faults CIT Dashboard

Description

CIT dashboard in BIP for 20CN shows all the jobs that are running for 20CN broadband in BIP. It shows all the automation scripts that are running successfully for 20CN broadband faults and orders application.

Duration

Mar 2009 to Aug 2010

Location

Bhubaneswar

Role

Developer

Solution Environment

UNIX, Database-Oracle 10g,WINDOWS XP

Tools

PL/SQL Developer 7.1.5, Putty, Sub-Version(SVN)

Responsibilities

Analysis of the requirement

Analysis of different application inside BIP for 20CN broadband orders and faults.

Listing the functionality and test case for various applications.

Configuring all the procedures, packages and scripts in the database and Unix system according to source layer, integration layer and extraction layer.

Preparing automation scripts using pl/sql and Unix that will be triggered automatically to show the status in the CIT dashboard if existing functionality are hampered due to any change inside the application

Accolades

As a developer got appreciation for the support to production team during warranty period of the deliveries.

As a developer got appreciation from manager and client for my hard work and successful deliveries.

Got appreciation for the support to TCS – Maitree initiatives programme (Compu-kid and share n care programme)

Career Profile

Dates

Organization

Grade

08/07/2013 to till date

HCL technologies Ltd

Senior system Engineer

08/05/13 to 28/05/13

Polaris Financial Technology ltd

Consultant T130

01/04/10 to 03/05/13

TATA Consultancy Services

SE(C1 Y)

14/02/09 to 31/03/10

TATA Consultancy Services

ASE(C1 Y)

08/12/08 to 14/02/09

TATA Consultancy Services

ASE-Trainee(Y)

Training / Continuing Education Summary

Program or Course

Coverage

Dates

Project Training

PL/SQL, UNIX, Data Warehousing Concepts, basic concepts on Oracle business intelligence, Ab-initio E0

Apr 2009

Initial Learning Program(ILP)

Pl/sql,Unix

Dec 2008 to Mar 2009

Personal Details

Date of Birth

11/02/1986

Nationality

Indian

Languages Known

Fluent in English, Hindi,Oriya

PAN Card No.

ALSPD3698L

Permanent Address

Sector-7,Plot-D/170,CDA,Cuttack-753014,Orissa

Present Address

Door No -6, 2nd floor, House No – 97/2 Block A, Ramajeneya layout, Marathahalli bridge, Bangalore-560037

Passport Details

Name as on passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

Poulosty Das

G9522464

19/08/2008

18/08/2018

Bhubaneswar

Contact this candidate