Customer Service Project

Mrinal Bhushan

***-*******, ******* ********,

Crossing Republik- NH-24,

Ghaziabad 201016, INDIA

Phone (M): +91-981*******

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

[pic]

CAREER VISION: Seeking a career in the software industry with a growth-

oriented organization, where my skills would be utilized to the optimum for

the growth of the organization and so me.

CAREER SUMMARY

< Qualitative exposure of more than 7.1 years

in software development lifecycle.

< Possess hands on experience of 7.1 years in

Informatica (ETL Tool), Oracle / Teradata.

< Informatica Certified Developer.

< Handled projects independently and

efficiently delivered the required

applications while meeting and exceeding

client expectations.

< Worked with Commercial Finance, Banking,

Communication, Electronic and High Tech

clients on end-to-end projects.

< Hands on work on ETL end working on the full

breadth of the project starting from scratch

design and modeling.

< Excellent Communicator with the ability to

deal with issues with precision & accuracy,

individually or in a team as required.

< An accomplished IT professional with

excellent analytical & logical approach.

ACADEMIC PURSUITS

* Master of Computer Application from BBD National Institute of

Technology and Management, Lucknow, during 2004-2007.

* Bachelor of Computer Application from I.T.S, Ghaziabad during 2001-

2004.

SKILL SET

Technical

ETL Tools : Informatica Power Center (7, 8.1, 8.6.1,

9.1)

Scheduling Tool : Control M.

Operating System : MS Windows, UNIX.

RDBMS : Oracle 11g/9i/8i, MS SQL Server 2000, Teradata, DB2.

Languages : SQL, PL/SQL

GIS Tools : ERDAS IMAGINE 8.4, ArcView GIS 3.2, ArcInfo

Methodologies : Accenture Delivery Methods, Data

Warehousing Concepts.

Certifications : Informatica Certified Developer

(8.X).

Accenture internal Informatica - Beginner level

certification.

C&HT Certification- Beginner level

certification.

Accenture internal Data Warehouse Concepts

- Beginner level certification.

- Intermediate level certification.

Functional

< Implementing project plans within deadlines.

< Involved in design, development, testing, tuning and implementation of

enhancements, new requirements and change requests using Informatica,

PL/SQL and UNIX scripts.

< Creating Detailed Technical Designs based on the business requirements.

< Effort estimation of simple to complex Informatica developments and

enhancements for Project Management.

< Adhering to best practices for project support and documentation.(as per

CMMI Level 5 standards)

< Designing, developing, and troubleshooting of the application.

< Efficiently run tests to ensure the application is working properly.

< Responsible for client communications and POC for offshore team for the

client.

ORGANISATIONAL DETAILS

IBM Inida Ltd Aug 2011 to

Till Date

Birlasoft India Ltd, Noida Nov 2010 to

Aug 2011

TCS, Gurgaon June2010 to

Nov 2010

Accenture Services Pvt. Ltd, Mumbai April

2008 to June2010

Eoa NDMI Pvt. Ltd, Noida April

2007 to April 2008

PROJECT EXPERIENCE

Project 6 : Designing and developing Datamarts as part

of DW team of a Electricity distribution company of US

(Energy and Utilities vertical client).

Duration : April, 2013 - Till Now.

Environment : Informatica Power Center 9.1, Oracle 9i, Teradata,

Unix scripting, Salesforce.

Team Size : Dev Team - 15

Description : The client in this project is the electricity

distribution company of US. Basically we are fetching data

from different source systems like Oracle, SQL Server,

Salesforce or Flat files and dumping the data in staging

areas (Teradata) and then we analyze the data and apply

business logic and create dimensions and facts as part of

data marts (on Teradata) as per client's requirement .

These data marts are used by the reporting teams to

generate Bills/ Reports for the client. We are also

involved in Bug Fixing of the present code and Fine Tunning

the current applications. We are generally working in Star

Schema in this project.

Role :1) Working as BA for specific Data Marts for specific business

areas (Bill Print).

2) Analyze, Design and Code for the

requirements from the client as a BA.

3) Working closely with the Client and

Architects to get the requirements to closure.

4) Debugging issues and Design Gaps as per the clients requirement.

5) Create Technical design, LLD and then implement it through

Informatica / PL SQL / Unix scripting/Teradata / Oracle .

6) Created some Reusable Unix Scripts which is being used across

projects.

7) Developing maps and workflows for

Type II and Type I slowly changing dimension.

8) Bug Fixing and assisting testing team

to complete their testing for all the code developed.

Project 5 : Market Risk DWH for a Banking Domain Client.

Duration : August, 2011 - March 2013.

Environment : Informatica Power Center 8.6, Oracle 9i, DB2.

Team Size : Total- 200; Dev Team - 14

Description : This is the second largest bank in Turkey. It is

upgrading its legacy system with latest technology to cater

its growing customer needs in efficient manner. IBM was

involved in the project aimed at developing dynamic system

for banking pricing system. There was a central fees &

commission system which was running on Z/Os. But the

abilities of this central system were not enough to cover

new coming business requirements. So the new system was

developed to replace fees & commission system by central

pricing hub system.

Role : 1) Technical lead for 6 member Dev team from offshore.

2) Developing Data Marts for specific business areas (Market Risk).

3) Preparing Designs for Converting DB2 Programs into Informatica

codes.

4) Analyze, Design and Code the requirements from the client.

5) Working closely with BA team to get the

requirements to closure.

6) Debugging issues and Design Gaps as per the clients requirement.

7) Create Informatica Code, Unix Scripts and Oracle Procs

according to Technical Design.

8) Assisting testing team to complete their testing for all the

code developed.

9) RCA on production issues.

10) Developing maps and workflows for

Type II and Type I slowly changing dimension.

11) Writing Unit Test Case/Script and

their execution.

Project 4 : Scorecard creation from EDW for a Commercial

Finance giant of US

Duration : November, 2010 - August 2011.

Environment : Informatica Power Center 8.6, UNIX, Oracle 9i/11g,

Teradata.

Team Size : Total- 30; Dev Team - 6

Description : Birlasoft was involved in all aspects of remodeling of

the EDW and fetching data from Oracle DB and creating

Dimensions and Facts into an efficient and high performance

Tearadata Enterprise Data Warehouse (EDW). We have

successfully remodeled and tuned the present codes and

created new ones on Teradata to manage huge amount of data

up to the satisfaction of the client. We have also been

engaged in delivering BTEQ scripts as per the client's

requirement. The core functionality of the batches is to

process the Commercial Finance data of the client through

Informatica and load the processed data in the concerned

tables of the concerned dimensions, from where this data

would be used for some scorecard generation.

Role :1) Understanding Business Specification and developing

Technical Design.

2) Regular interaction with the client to

get the clear understanding of the requirements.

4) Create Informatica Code according to Technical Design and Tune

the existing code. This also includes Teradata PL/SQL

scripts .

5) Assisting junior members to complete the design and deliver

on time.

6) Following version control in Informatica.

7) Developing maps and workflows for

Type II and Type I slowly changing dimensions.

8) Writing Unit Test Case/Script and

execution.

9) Help the testing team to test the

scenarios as required by the client BA team.

10) Adhere & implement standards and

process adopted, Client standards as well as Birlasoft

standards.

Project 3 : Rx Connect development of DW for US Pharmacy

retail chain.

Duration : June, 2010 - Nov, 2010

Environment : Informatica, UNIX, Oracle 9i/11g.

Team Size : Total- 150; Dev Team - 8

Description : TCS was involved in all aspects of creating and

migrating client's Data Warehouse from an existing

independent for each stores to a new centralized DW

system. We have successfully migrated over 6000 stores to

the new centralized system and the rest 1000+ are in

progress. We have also been engaged in delivering scripts

and batches of jobs to be run daily. The core functionality

of the batches is to process the patient and prescriber

data as required by the client through Informatica and send

them the processed data in flat files or through updates in

the concerned tables.

Role :1) Understanding Business Specification and developing

Technical Design.

2) Defining use cases from the BRD. Assist team mates for the same.

3) Create Informatica Code according to Technical Design. This

also includes PL/SQL scripts or Procedures, UNIX scripts

etc.

4) Developing UNIX script to run all the batches which is

initiated through Control M.

5) Following version control in Informatica.

6) Developing maps and workflows for Type II and Type I slowly

changing dimensions.

7) Writing Unit Test Case/Script and execution.

8) Adhere & implement standards and process adopted, Client

standards as well as TCS standards.

Project 2 : Global Data Warehouse Development and

maintenance for an Electronics and Hi-Tech vertical

client from US.

Duration : April, 2008 - June 2010.

Environment : Informatica Power Center 8.1/9.1, OBIEE, Hyperion,

Kalido, Oracle 9i/11g.

Team Size : Total- 250; Dev Team - 10

Description : Accenture participated in all aspects of creating

client's Enterprise Data Warehouse (EDW) for Customer

Service of EMC. Accenture shared responsibility for

managing the project, analyzing the business requirements,

creating the design, building/testing technical solution,

performing the initial cutover and stabilization. The EDW

is a fully customized data warehouse and data model that

was designed to support EMC's Customer Service business.

The core functionality of the warehouse supports reporting

and business intelligence on the following topic areas:

Service Requests, Install Base, Contracts, Accounts

Receivable, Products, Customers, Employees and hierarchy

information. The technical solution was made up of custom

Staging areas for data aggregation followed by the core

Data Warehouse. The system is now being completely

supported by Accenture as part of an Application

outsourcing deal.

Role :1) Understanding Business Specification and developing

Technical Design.

2) Provide detailed effort estimates to project management for self

and team to build, test and reviews. Assist team mates for

the same.

3) Create Informatica Code according to Technical Design. This

may/ may not include PL/SQL scripts or Procedures, UNIX

scripts etc.

4) Developing maps and workflows for Type II and Type I slowly

changing dimensions.

5) Writing Unit Test Case/Script and execution.

6) Point of contact from offshore team for Client,

responsible for day to day team management activities like

client communications, status consolidation and

communication, to meet all client expectations from IDC

perspective.

7) Adhere & implement standards and process adopted, Client

standards as well as Accenture standards.

8) Creation of reusable assets for DW/BI capability within

Accenture.

9) Knowledge transition to Client's own offshore team as and when

required.

Project 1 : GIS Data Warehouse development for an Indian

client.

Duration : April, 2007 to April, 2008.

Client : Meteorological Department of India, Government of

India

Environment : Informatica Power Center 8.1, ArcView GIS 3.2,

Oracle 8i.

Team Size : 10.

Description : Meteorological Department of India has engaged

NDMI to maintain and enhance its geographic database

(GIS). The scope of this work includes maintenance of

its Geographic data, implementing changes as and when

required, and generating graphical reports through

ArcView GIS for the Geographic data of an area. The scope

also included the study of historic Geographic data and

analysis of its effect on the geographies in coming

future. The analysis of data may be to determine

different Geographic behaviors as and when required.

Role : 1) Work on development of

Informatica code and unit test.

2) Reviewer and Peer reviewer of the developed code/

code developed by team.

3) Scientific data extraction from text files to

relational tables.

4) Work with Client team/ Business users to ensure

quality of end deliverable.

5) Responsible for single handedly handling end client

communication, status meets. 6) Presenting

demos to state level secretaries at Vigyan Bhavan, New

Delhi.

7) Ensure issues raised are resolved to ensure progress

on the deliverables.

Achievements / Accomplishments

. IBM (GBS-GD) Eminence & Excellence Recognition Award for the year

2012.

. Birlasoft Employee of the month award for the first quarter of

2011.

. Build special fix maps for handling more than 1000 ids through

the parameter file because SQL has a limit of 1000 elements in

its IN condition and previously we needed to make separate

parameter files for each 1000 ids. Now we can handle in one file

only.

. Developing fix maps for processing of selected data based on some

unique columns.

. Performance tunning of the mappings by tunning on the database or

the map level which has sometimes reduced the time taken by the

map to 60 times.

. Helped client in debugging issues like special characters issue

(2 or 3 byte characters) which are not handled by Informatica 7

even by changing the page code settings.

. Ranked 2nd in B.C.A Ist year among the 230 students batch in 2004-

05 at I.T.S, Ghaziabad during my graduation.

Personal Profile

Father's Name : Mr. Umesh Prasad.

Nationality : Indian.

Languages known : Hindi, English.

Hobbies : Travelling, Reading and Listening to Music.

Mobile Number : 098********

Declaration

I hereby declare that all the aforesaid information is true and correct to

the best of my knowledge and belief.

Date: 16th July 2014

(Mrinal Bhushan)

Contact this candidate