Debiprasad Das

Email - acfrns@r.postjobfree.com

Cell- +1-908-***-****

SUMMARY

. I bring with me around 8 Years of strong IT experience and Technical

proficiency in the Data Warehousing, Databases and Business Intelligence.

. Strong experience in entire SDLC process which includes Business

Requirements Gathering, System Analysis, Design, Data Modeling,

Development, Testing and Implementation of Data Warehouse.

. 7 yrs of Technical hands-on experience in the development and

Implementation of Data warehousing solutions using Informatica Power

Center 9.5/9.1/8.6/8.1, Teradata 13.1,14.1,14.10

. Strong experience in developing Informatica Mappings / Mapplets using

various Transformations for Extraction, Transformation and Loading of

data from Multiple Sources to Data Warehouse using complex

transformations like Expressions, Routers, Lookups, Source Qualifiers,

Aggregators, Filters, Joiners and Creating Workflows with Worklets &

Tasks and Scheduling using Workflow Manager (WLM),Tidal Scheduler

. Have good hands on experience in Installing, Configuring Informatica

server, Client and Repository.

. Extensive experience in error handling and problem fixing in Informatica

. Good working knowledge of SQL and BTEQ in Teradata.

. Extensively worked on BTEQ, MULTILOAD, FASTLOAD, TPUMP and FAST EXPORT

utilities in Teradata.

. Extensively worked on BTEQ scripts in Teradata using UNIX to override the

Informatica code which causing performance issues.

. Involved in the performance tuning of Informatica mappings by using

Informatica Push Down optimization (PDO), which provides the same

performance impact as a BTEQ script but also provide a good data lineage.

. Extensive knowledge in handling Slowly Changing Dimensions.

. Experience in integration of various data sources from Databases like

Oracle, SQL Server, Teradata, DB2,

. SAP R3 and formats like flat-files and CSV files.

. Have good hands-on experience in tuning Teradata scripts by using explain

plans.

. Good experience in interacting with the Business Users, SME's and staff

to gather requirements, Design Tables for new applications.

. Good working knowledge in Data Modeling using Dimensional Data modeling,

Star Schema/Snow flake schema, FACT & Dimensions tables, Physical &

logical data modeling.

. Have good hands on Clear Case as a Configuration management tools, for

maintaining the project related documents and their versioning system.

. Strong Hands-on experience in scheduling UNIX scripts, Teradata BTEQ

scripts and Informatica workflows.

. Extensively worked on the documentation related to the work plans,

Detailed Design Doc, High Level Design Doc, ETL Mapping documents, Unit

Test cases and Approach documents.

. Extensive Experience in Production support to schedule the jobs,

Workflows to load the data in the data warehouse and resolving critical

production issues.

. Strong communication skills (both verbal and written) and Interpersonal

skills with the ability to interact with individuals and a strong team

player.

. Excellent Analytical skills to understand the business requirements and

also to resolve the Complex Production issues.

. Have extensive hands on experience integrating SAP Source System ( File &

Stream Mode ) with Informatica,Teradata,Unix

Technical Skills

Data Informatica Power Center 9.x/8.x/7.x (Source Analyzer,

Warehousing/ ETL Transformation Developer, Mapplet Designer, Mapping Designer,

Tools Repository Manager, Workflow Manager, Workflow Monitor and

Informatica Server) ETL, Repository, Metadata, Data Mart, FACT

& Dimensions tables, Physical & Logical Data Modeling

Databases Teradata 13.1/14.1,14.10, Oracle 9i/10G, Mainframe DB2, SQL

Server,Ms Access

Utilities Bteq, Fast Export,Fload,Mload,Tpump, Teradata Viewpoint

Programming SQL,PL/SQL,Teradata SQL,Unix Shell Scripting

Tools Clear Case, TOAD, Service Center,CITRIX,Quality Center,IRIS

Environment Windows 7/8/XP, UNIX

Scheduling tools WLM,Tidal Scheduler, Autosys,Informatica Scheduler

IDEs WinSCP, Putty

Education

Bachelor of Technology, Biju Patnaik University Of Technology,Orissa, India

Certifications

Informatica 8 Certified

PROFESSIONAL EXPERIENCE:

Johnson & Johnson,

Dec 2012 - Till

date

New Brunswick, NJ, USA

ETL Specialist

Client Description

Johnson & Johnson is an American multinational medical devices,

pharmaceutical and consumer packaged goods manufacturer founded in 1886.

Its common stock is a component of the Dow Jones Industrial Average and the

company is listed among the Fortune 500. Johnson & Johnson is headquartered

in New Brunswick, New Jersey with the consumer division being located in

Skillman, New Jersey

Project Description

Global Procurement's strategic initiatives include supplier management, de-

risking the business, category and spend management. A key procurement

fundamental enabler is providing smooth, efficient solutions, which enable

comprehensive and accurate access to global spend information. This project

will deliver an efficient system to collect and report global direct &

indirect spend with data feeds from multiple systems, including Ariba,

Accounts Payable and Jansen Supply Chain (JSC) systems.

Roles & Responsibilities

. Design and develop large Enterprise Data Warehouse projects and data

marts.

. Data Analysis, Profiling & Requirement Analysis.

. Designed ETL architecture to Process volume of data and created High-

level design, low-level design documents keeping data lineage as the

first priority and performance the next. Participate in user meetings;

gather Business requirements & specifications for the Data warehouse

design.

. Developed Informatica mappings to extract data from Oracle, Flat files,

SAP R3 Sources to load in to Stage area using TPT (Teradata Parallel

Transporter) utility. Worked data mapping, data cleansing, program

development for loads, and data verification of converted data to legacy

data.

. Design, Develop, Test and Implement the jobs that extract, transform and

load data into the Enterprise data warehouse

. Developed Informatica mappings with Pushdown Optimization (PDO) to load

data from Staging to the EDW layer.

. Generate Windows scripts to handle, transform and transfer files and also

to execute commands. Apply Informatica & Teradata best practices during

development with a strong focus on reusability and better performance.

. Produce clearly articulated functionality documentation in data

integration.

. Experience in Integration of various data sources like Teradata, Oracle,

DB2, SQL Server, Flat Files and XML files.

. Highly motivated with the ability to work effectively in teams as well as

independently.

. Provided required support in Multiple (SIT, UAT, PROD) environments of

the project.

Environment: Informatica Power Center 9.1/9.5, Teradata 14.10, SAP R3,

Oracle 10G, Linux Batch Scripting, TIDAL Scheduling Tool, Teradata

Viewpoint

Prescription Solutions (UHG)

Jun 2011- Nov 2012

Santa Ana, CA

ETL Developer

CLIENT DESCRIPTION:

UnitedHealth Group Inc. is a diversified managed health care company

headquarters in Minnesota,U.S. It is No. 14 on Fortune magazines top 500

companies in the United States.[5] UnitedHealth Group offers a spectrum of

products and services through two operating businesses: United HealthCare

and Optum.

PROJECT DESCRIPTION:

Prescriptions Solutions is a pharmacy benefit management (PBM) industry

serving more than 10 million people through online, mail service pharmacies

and a national network of more than 64,000 community pharmacies and manages

prescription drug benefits of commercial, Medicare, and government health

plans, and those of employers and unions.

The overall idea of this project (Transition Benefit Letter) is to prepare

aggregated data for the end users to utilize them for reporting purpose.

Here we extracted data from RxCLAIM batch processing system and transformed

according to the business requirement and finally loaded to target table.

The aggregated data later used for reporting purpose.

When a claim has been paid as a transition benefit, a letter is sent to the

member indicating the reason for the transition supply and instructions on

what must be done before the transition benefit period ends.

The letter is printed and mailed (referred to as fulfilled) by an outside

vendor who receives a daily extract file generated from Prescription

Solutions' RxCLAIM system.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Participated in user meetings, gathered Business requirements &

specifications for the Data-warehouse design. Translated the user inputs

into ETL design docs.

. Involved in the creation of Informatica mappings to extracting data from

Flat Files to load in to Stage area.

. Designed and Created validation and External loading scripts like MLOAD

and FLOAD for Teradata warehouse using Informatica ETL tool.

. Involved in error handling, performance tuning of mappings, Testing of

Informatica Sessions, and the Target Data.

. Experienced in loading data into Data Warehouse/Data Marts using

Informatica, Teradata Multiload, Fast load and BTEQ utilities.

. Extensively worked on indexes in Teradata and Creation of proper Primary

Index (PI) talking into consideration of both planned access of data and

even distribution of data across all the available AMPS.

. Designed ETL to collect stats on regular basis ( when the volume

increases by 3 % more )

. Loading data by using the Teradata loader connection, writing Teradata

utilities scripts (Fast load, Multiload) and working with loader logs.

Scheduled workflows, BTEQ Scripts, UNIX shell scripts using WLM

Scheduling tool.

. Dropped the Join Indexes before ETL load and re-built after the ETL load

to enhance Performance more.

Environment: Informatica Power Center 9.1, Teradata 13.10, IBM DB2, WLM

Scheduling Tool and Windows 7

Wellpoint Inc.

Apr 2010- May

2011

Richmond, VA

ETL Developer

CLIENT DESCRIPTION:

WellPoint, Inc. is the largest managed health care, for-profit company in

the Blue Cross and Blue Shield Association. It was formed when WellPoint

Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem

adopting the name, WellPoint, Inc. and began trading its common stock under

the WLP symbol on December 1, 2004.

PROJECT DESCRIPTION:

As a part of larger objective of business, Group Health Co-operative (GHC)

will be integrated with Wellpoint as a back office third party

Administrator (TPA) for WellPoint state sponsored business (WLP SSB) across

6 countries in southeast Wisconsin. To achieve this objective WI Medicaid

data is sourced from GHC into EDWard, the single source of truth and data

from Edward is transferred to IHUB datawarehouse, thereby ensuring complete

data integration within wellpoint.

The Objective of this project is to extract the Claims and Medical related

data from the GHC and load into Edward Datawarehouse.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Involved with the Business analysts in requirements gathering,

business analysis, discussed issues to be resolved and translated user

input into Business specifications documents.

. Analyzed the change requests and did the impact analysis and effort

estimation.

. Documented business requirements, Coordinated with offshore team to

prepare flawless ETL specifications, Technical design documents.

. Data profiling to estimate the quality of the data.

. Designed the data model and worked with Data Architect to Publish the

Data Model.

. Developed and modified Teradata BTEQ, FLOAD, UNIX shell scripts.

. Identifying indexes for Teradata Tables to improve the performance.

. Provided required support in Multiple (SIT, UAT,PROD) stages of the

project.

. Set up the FTP to transfer files from DX server to Vendor server.

. Provided support for system integration testing, release testing and

production

Environment: Informatica Power Center 8.6, Teradata 13.10,WLM, Clear Case,

Quality Center

Wellpoint Enterprise

Aug 2007- Mar 2010

Bangalore,KA,IND

ETL Developer

CLIENT DESCRIPTION:

WellPoint, Inc. is the largest managed health care, for-profit company in

the Blue Cross and Blue Shield Association. It was formed when WellPoint

Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem

adopting the name, WellPoint, Inc. and began trading its common stock under

the WLP symbol on December 1, 2004.

PROJECT DESCRIPTION:

WellPoint is implementing Callidus suite of tools as strategic enterprise

solution to Generate and manage sales and bonus commission payments to

internal agents and external brokers for all lines of business. WellPoint

Inc has asked to provide Integration consultants and report developers to

work with Callidus team for Enterprise commission project to load data from

various inbound interfaces to Truecomp staging area and to develop custom

reports.

The objective of the project is to develop a detailed approach to source

the data from different sources (FACETS, ASCS) directly to the EDW

(Enterprise Data Warehouse) base model.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Data Analysis & Detailed Requirements Gathering

. Preparing High Level Design, ETL processing document and Low level

design.

. Developed ETL around the business logic and testing the same against

the specific business rules.

. Analyzing the source data and deciding on appropriate extraction,

transformation and loading strategy.

. Handling Defects raised by End Users, Analyzing the Informatica bugs

and fixing them in the Informatica mappings

. Daily Data load Monitoring: These Workflows were then scheduled to run

at specific time intervals on the Client Production Repository and

monitored regularly in Workflow Monitor.

. Coordinating with the onsite team for reviews, feedback and issue

resolutions & Mentoring new team members.

. Creating project deployment process document for the release

management team to release the code to production

Environment: Informatica Power Center 8.1, Oracle 9i,SQL Server,Ms

Access,Autosys, Quality Center

Contact this candidate