Debojyoti Das

: +1-832-***-****

: ac6olq@r.postjobfree.com

Highlights:

Software Professional with overall 9 years of experience in Software Development and Project Management whereas 6 years of experience in Data Analytics and Business Intelligence.

Currently working with Capgemini America Inc as Lead Data Analyst.

Adept in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.

An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.

Worked on Data Modeling, Data Warehouse Solutions, worked with tools like Informatica Power Center, Informatica Data Analyst, Informatica Metadata Manager, Informatica Data Quality, Talend Studio, Tableau, Uipath and familiar UNIX env.

Databases that I had been working with are Oracle, Teradata, DB2, SQL Server, GreenPlum

Achievements and Certification:

Awarded in the Gold Medal Category for the presentation of Yearly (2017- 2018) Innovation Contest in Capgemini.

Completed the Foundation Level Certification on Automation Tool UiPath.

Recognized by PAT ON THE BACK award at IT vertical in the organization for the successful execution of the LS BI Migration project in the days of initial phases and mentoring the team with the processes, technologies.

Recognized by PAT ON THE BACK award at IT vertical in the organization for the successful deployment of the LS project into production within tight time line, without any issues.

Bagged the award for the Key Player in the Account (Macys System and Technology) 2011. (Individual award).

Achieved Best Project Presentation award (in Q4 2009) and Best Performed Team award of the Account (Macys System and Technology) in Q4 2010.

Functional:

Conducting case / system / process study for project planning, scoping, estimation and tracking.

Understanding the technical & functional specifications.

Leading the execution team involve in Analysis / coding / testing/ documenting developed objects.

Developing, testing, troubleshooting and debugging of the applications.

Interacting with team and clients/users on daily basis and discuss about advancements and needs in the module.

Providing post-implementation, enhancement and maintenance support to client for application.

SKILL SET

SKILL AREA

EXPERIENCE

(IN YEARS)

PROFICIENCY

Teradata

6.5 Years

Proficient

Informatica Power Center

3.9 Years

Proficient

SQl

6 Years

Proficient

Cronacle

3.9 Years

Proficient

Informatica Metadata Manager

1.2 Years

Proficient

Informatica Data Quality

1 Years

Knowledgeable

Informatica Analyst

1.2 Years

Knowledgeable

Unix

2 Years

Knowledgeable

Informatica Identity Resolution

1 Year

Knowledgeable

Informatica Data Validation Option

.8 Years

Beginner

Java

3 years

Proficient

Oracle and Exa Data and PL/SQL

2 Years

Knowledgeable

Data Structure,Data Warehouse and Business Intelligence, Data Modeling and Data Warehouse Solution.

6 Years

Proficient

GreenPlum

2 Years

Proficient

Tableau

2 Years

Knowledgeable

Talend Studio

2 Years

Proficient

PROFESSIONAL EXPERIENCE

Since June 2017 with Capgemini America INC, Houston, Texas as Lead Data Analyst

Current Project ==>

Project Title

Sales and Operation for Surface Inventory

Project Type

Data Warehouse Solution and Development

Client

GE Power

Platform

Windows, Unix.

Technologies/

Tools

GreenPlum, Talend, Tableau, Uipath

Role (Billable)

Lead Data Analyst

Responsibilities

Worked as an independent consultant and providing end to warehouse solution

1.Gather User Requirement and Design

2.Development

3.Testing and Debugging

4.Support for Already developed code

5.Interact directly with client and business users for new requirements

6.Support for migration to one env to other env

7.Technical and Functional Documents for reference

8.Leading Team of 10 Members

Team Size

10

Duration

July’17 till Date.

Description

This project intends to develop a data warehouse solution for business which gives global visibility of inventory management, Safety Stock, Dual Deplete and other metrics for supply chain management as well. It was started from source data profiling, Data Modeling, ETL flows and strategy and reporting solution. Also we implemented the automation workflows for the tasks where manual intervention were more using UiPath.

From July 2016 to June 2017 with Capgemini America INC, Houston, Texas as Lead Data Analyst

Project Title

Sales and Operation for Surface Inventory

Project Type

Data Warehouse Solution and Development

Client

GE Oil and Gas

Platform

Windows, Unix.

Technologies/

Tools

Oracle, PL/SQL, Oracle EXA Data, Informatica Power Center, Talend Studio

Role (Billable)

Lead Data Analyst

Responsibilities

Worked as an independent consultant and providing end to warehouse solution

9.Gather User Requirement and Design

10.Development

11.Testing and Debugging

12.Support for Already developed code

13.Interact directly with client for new requirements

14.Support for migration to one env to other env

15.Technical and Functional Documents for reference

Team Size

1

Duration

July’16 to June 2017.

Description

This project intends to provide support and development activities on ETL for surface business of GE Oil and Gas. Different ETL components are being developed and get support for different module of material demand planning, OBSO, Excess Material and other ongoing requirements

Since April 2015 to June 2016 with Capgemini India, Bangalore as Lead Data Analyst

Project Title

APAC Services

Project Type

Data Warehouse Solution and Development

Client

GE HealthCare

Platform

Windows, Unix.

Technologies/

Tools

Teradata, lnformatica Power Center, SpotFire

Role (Billable)

Lead Data Analyst

Responsibilities

1.Requirement Gathering

2.Prepare High Level Estimation and project plan

3.Worked on Data Modeling and Architecture

4.Develop code.

5.Educate the team members and closely work with them to resolve any issues.

6.Assign different tasks the team members

7.Perform code review, unit testing, system testing, integration testing, Peer testing.

8.Support UAT and Release activities.

9.Prepare different technical and SOP document for reuse and review the release documents as well.

Team Size

10

Duration

Apr’15 to June’16.

Description

The objective of this project is to develop the enterprise data warehouse for APAC Region. The developed warehouse will enable users to prepare different metrics and ad-hoc reports on different aspects on service business. The reports are being used by the super users from

different regions of APAC (ANZ, KOREA, ASEAN).

To build the warehouse we used Teradata as the backend database and lnformatica as ETL tool. For reporting layer SpotFire have been used

Since August 2014 to March 2015 with IGATE Global Solution, Bangalore as System Analyst

Project Title

Bl Acceleration

Project Type

Data Warehouse Initiative and Development

Client

GE HealthCare

Platform

Windows, Unix.

Technologies/

Tools

lnformatica Metadata Manager, lnformatica Data Vatidation Option, Pushdown Optimization, lnformatica Anatyst, Teradata

Role (Billable)

System Analyst / Project Lead

Responsibilities

1.Identified the areas for improvement as part of this initiative

2.Involved in design and architechture

3.Prepared plan and probable road map for execution.

4.Supported additional release activities for IMM.

5.Implemented PDO and made a successful go live.

6.Develop scheduler for DVO release.

7.Successful implementation of DQA for a pilot project.

Team Size

6

Duration

Aug’14 to Mar 2015.

Description

The objective of this project is to implement new tool and concepts to improve DWBI operation smoother. We have implemented lnofrmatjca Metadata Manager (lMM), Pushdown optimization (PDO), lnformatica Data Vatidatjon Option (DVO) and lnformatica Analyst (DQA) for GE HeatthCare Bl operations successfully in various projects which were live already.

To implement lnformatica Metadata Manager IGATE devetoped an in-house JAVA program to prepare a metadata file from a BTQ file.

Since December 2013 to July 2014 with IGATE Global Solution, Bangalore as System Analyst

Project Title

UCM Data on Boarding

Project Type

Data Warehouse Initiative and Development

Client

GE HealthCare

Platform

Windows, Unix.

Technologies/

Tools

Informatica Data Quality, Informatica Identity Resolution

Informatica Power Center, Informatica Analyst

Role (Billable)

System Analyst / Project Lead

Responsibilities

1. Developed rules in IDQ to implement data quality rules on the transactional data.

2. Developed rule file in IIR to identity resolution.

3. Developed mapping to automate the standardization process and proper process for the same

4. Analyzed the data in DQA to define quality rules.

5. Supported the go live activities in UCM

Team Size

5

Duration

Dec’13 to July 2014.

Description

The objective of this project is to implement new tool and concepts to improve DWBI operation smoother. We have implemented lnofrmatjca Metadata Manager (lMM), Pushdown optimization (PDO), lnformatica Data Vatidatjon Option (DVO) and lnformatica Analyst (DQA) for GE HeatthCare Bl operations successfully in various projects which were live already.

To implement lnformatica Metadata Manager IGATE devetoped an in-house JAVA program to prepare a metadata file from a BTQ file.

Since August 2013 to November 2013 with IGATE Global Solution, Bangalore as System Analyst

Project Title

Health BI Informatica Metadata Pilot

Project Type

Data Warehouse Initiative and Development

Client

GE HealthCare

Platform

Windows, Unix.

Technologies/

Tools

Teradata, Cronacle, Informatica Metadata Manager.

Role (Billable)

Technical Lead

Responsibilities

1. To understand the functionality of IMM for preparing lineage of different data loading stages.

2. Explore and Development of MMCMD command to operate IMM from unix box.

3. Development of scheduling scripts for data loading and running MMCMD command through Cronacle Scheduler.

4. Participate in making POC for this initiative.

5. Communicate with different stakeholders for their additional requirements and upcoming challenges and risks

Team Size

5

Duration

Aug’13 to Nov 2013.

Description

This project is a BI initiatives to get the clear picture of different stages of data loading happening in ODS which eventually will help to understand the impact when a new set of code or modification to the existing code will occur. We are building lineage for source and target table as well columns to make a complete data flow understanding from Transactional system to final report.

Since August 2013 to November 2013 with IGATE Global Solution, Bangalore as System Analyst

Project Title

Health BI Migrations

Project Type

Support

Client

GE Health Care

Platform

Windows, Unix.

Technologies/

Tools

TERADATA (v.13.0), Informatica, Cronacle

Role (Billable)

BI Release Specialist

Responsibilities

1. Review Code of different technologies used in GEHC

2. Migration of codes to STG env for different Technologies

3. Troubleshooting of problems occurred in STG env

4. Communicate with different stakeholders for their requirements and deadline for migrating codes

5. Responsible for configuration management and other maintenance activity for STG env.

Team Size

10

Duration

Aug’12 to July’ 13.

Description

This project is targeted to provide best services for migration, execution and testing of codes as part of development, enhancement and bug fix for GEHC. This team is responsible for making a successful integration of codes between testing env and production env. Performs several maintenance activities to smooth code migration and execution.

Since Feb 2011 to July 2012 with IGATE Global Solutions, Bangalore as Systems Analyst

Project Title

Life Science JDE Data Acquisition

Project Type

Support and Enhancement

Client

GE Health Care

Platform

Windows, Unix env for execution of some code.

Technologies/

Tools

TERADATA (v.13.0), Informatica

Role (Billable)

Developer/System Analyst

Responsibilities

1. Analyzing the requirements provided by the client.

2. Understanding the standard ODS architecture and designing the ODS components for the JDE data.

3. Developing, testing & implementing backend components (BTQs, tables, views) in Teradata

4. Daily requirement/performance call with user to understand the support and enhancement for further.

Team Size

5

Duration

Feb’11 to July’12.

Description

This project is targeted to provide analytical reporting solution for the Orders and Items. For the daily transaction for orders and items the updated or new data should be reflect to the EDW by daily Jobs and those records are being used for reporting on Qlick View.

Worldwide four region in included for this daily load. Those are North America, Japan, Hong Kong and Europe.

From March’11 to June 2012 with IGATE Global Solutions, Bangalore as Systems Analyst

Project Title

Life Science Siebel Integration

Project Type

Development

Client

GE Health Care

Platform

Windows, Unix env for execution of some code.

Technologies/

Tools

TERADATA (v.13.0), Informatica

Role (Billable)

Developer/System Analyst

Responsibilities

1. Analyzing the requirements provided by the client.

2. Understanding the standard ODS architecture and designing the ODS components for the Siebel provided solution.

3. Developing, testing & implementing backend components (procedures, tables, views) in Teradata

4. Creating different Informatica mappings and workflows for moving data from Source database (Oracle) to target database (Teradata).

Team Size

12

Duration

March’11 to June 2012.

Description

This project is targeted to provide analytical reporting solution for the Marketing and Sales modules for Life Sciences Business.

Project was done so as to decommission the Siebel Analytics provided solution and integrate its functionality into ODS Teradata warehouse.

In the 3rd phase for this project we successfully developed the Quote, Lead and campaign modules for the reporting purpose. This effort also includes the ETL development for the security implementation for the reporting users.

EDUCATIONAL QUALIFICATION

ACADEMIC QUALIFICATIONS: -

EXAMINATION

BOARD\UNIVERSITY

YEAR

RESULT MADHYAMIK EXAMINATION

WEST BENGAL BOARD OF SECONDARY EDUCATION

2001

79.75%

H.S. EXAMINATION

WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION

2003

64.9%

University Result: -

B.TECH. (IT), 2007

WEST BENGAL UNIVERSITY OF TECHNOLOGY 76.1%

PERSONAL INFORMATION

Personal Strengths:

Enthusiastic, proactive and self-starting, hard working. Seizes opportunities, acts upon them and Displays sustained energy and determination in the face of obstacles to set and meet challenging targets, in compliance with quality, time and diversity standards.

Personal Description:

Name

Debojyoti Das

Current Location

Houston, Texas, United States of America

Work Permit

H1B

Local Address

Apt# 814, 10000 Kemp wood Drive, Houston, Texas,77080

United States

Permanent Address

South Nibedita Park, P.O – Hridaypur, P.S – Barasat

District – North 24 Parganas, West Bengal, 700127, India

Date of Birth

8th October, 1984

Educational Qualification

B-Tech in Information Technology from West Bengal University of Bachelor of Technology

Languages Known

English, Hindi, Bengali,

PERSONAL DETAILS

Date of Birth: 8th October 1984

Nationality: Indian

SEX: Male

Marital Status: Single

Special Interests: Playing Football, Traveling in holidays, Social Activity, Cooking.

Languages: English, Hindi & Bengali

I hereby declare that the information furnished above is true to the best of my knowledge.

DEBOJYOTI DAS

Contact this candidate