Data Analyst Project
Resume:
Debojyoti Das
: ***.*********@*****.***
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