S Das

aces85@r.postjobfree.com

Ph: 239-***-****

Profile:

Mr. Das has over 20 years of computing experience in implementing

enterprise computing solutions and business reengineering efforts. He is

experienced in software development, data warehousing/business

intelligence, and project management across various industries, including

insurance, medical devices, entertainment, consumer electronics, and

technology. He brings a considerable amount of project lifecycle experience

in large-scale projects that encompass planning, analysis, design,

construction, implementation and support phases.

Career History:

CSC - Jan 2014 - Feb 2014

Sr. Data Conversion Developer

. Worked at Kaiser Permanente as a Sr. Data Conversion Developer which

was from old IBM mainframe software to modern client server software.

. This was from CICS/DB2 to Oracle using Informatica.

. This involved converting the data of all the North and Southern

California as well as the ROCS - Georgia, Colorado and Massachusetts.

This involved changing all the Store data as well as Doctor and

Patient data.

. Not all store data is complete but will be complete in one or two

months.

IBM - From Nov 2010 - July 2013

Managing Consultant/Architect

Worked in a number of clients/projects which are:

US Cellular - Chicago

. US Cellular is undergoing a major migration from its existing billing

system to a brand new billing system. Among the migration was the

interfaces for data from and to external sources/companies numbering

around 30. In the old system, there were 6 databases while in the new

system there was only one consolidated database. IBM was responsible

for these interfaces.

. The migration was being done database by database, each database

representing a different market segment.

. Mr. Das role was to ensure that all the bridging between the different

migrations was programmed (Informatica Power Center, Erwin, Shell

Scripts, SQL Scripts), set up MDM and set up properly.

Pacific Life - Orange County, CA

. Pacific Life has a PeopleSoft Implementation currently in progress. As

part of the implementation, a reporting framework is being delivered.

. The reporting framework required a Aggregated Data engine to be built.

This engine was dependent on a set of report metadata to be fed to it

based on requirements given by users.

. Mr. Das had to Architect and design the Data Aggregation Engine,

define the data model, develop MDM and test the various components of

the engine with the ETL tool Informatica Power Center Ver 9.x, Erwin

and SQL Scripts and transfer knowledge to the client.

GE FLEET - Minneapolis, MN

. GE Fleet is a subsidiary of GE Capital.GE Capital is in the process of

consolidating various divisions data warehouses into its own data

warehouse. IBM was contracted to consolidate GE Fleet's data warehouse

into the GE Capital's master warehouse. Mr. Das had to design the

pieces for Big Data along with the Data Warehouse.

. Mr. Das's responsibilities were to design, develop and test the ETL

components in Big Data, SQL Scripts, Erwin and Informatica Power

Center Ver 9.x for the Event-Maintenance module, develop the MDM and

assist and mentor junior ETL resources. This included managing 3

people onsite and 12 people off-site.

J P Morgan Chase - Columbus, OH

. JPMorgan Chase Bank NA is one of the world's largest financial

institutions, serving individual consumers, small- and middle-market

businesses and large corporations with a full range of banking,

investing, asset management and other financial and risk management

products and services. The JPMC Retail ICDW Program was an 18-Month

effort to achieve an industry best in class Integrated Customer Data

Warehouse environment.

. Mr. Das was a member of a small team that built mapping xml generators

to generate mapping xml for the common components.

. After that, Mr. Das worked on the Credit Risk portion of the project

where he did the micro design, worked with the data modellers on the

data model, involved with the data mapping, developed MDM, built

mappings/sessions/workflows in Informatica Power Center Ver 8.x, Erwin

and SQL Scripts, successfully mentored junior team member in data

integration and singlehandedly managed an off-shore development team.

. This included 6 people on-site and 10 people off-site.

Markel Insurance Company - Virginia

. IBM built a Insurance Data Warehouse for a leading Insurance company.

As part of the exercise, a separate process is being built which will

extract data from the data warehouse and feed into the financial

system. This process is for the IBNR ( incurred but not reported )

transactions which are reported by the source systems and are fed into

the Data Warehouse.

. As a member of the ETL team Mr. Das was responsible for the analysis,

design and development of the 'Allocation' part of the IBNR process in

Informatica Power Center Ver 8.x, Transact SQL, SSIS, Erwin and SQL

Scripts. This included 4 people onsite and 6 people off-site.

Accenture : May 2007 - Nov 2010

Consultant/Architect

His experience in Accenture has included the following:

Highmark BCBS - Pittsburgh, PA

. Mr. Das was responsible for the ETL architecture/design for the

Consumer Profile Initiative at Highmark. This would create a

consistent definition of a Consumer across Highmark with access to

reliable Consumer contact information (name, email, mailing address).

. His role was of an ETL Architect/Lead and his responsibilities

included producing the ETL architectural approach and design, ETL

standards, developed MDM, check-lists, processes, and procedures, to

support the business and technical requirements for Highmark, creating

the detailed designs for the common/re-usable components and the

complex applications, conducting code-reviews, promoted code,

performance tuning the ETL extract and load system configuration and

design and supporting the ETL development team.

. Technology used was Teradata, Erwin, SQL Scripts and Informatica Power

Center Ver 8.x. This included 4 people onsite and 4 people off-site.

Dean Foods - Dallas, TX

. Mr. Das was responsible for the design and construction of the

Supply Chain Data Warehouse at Dean Foods. This resulted in

receiving automated data feeds from direct store delivery ("DSD")

plant source systems. His role was that of a Solutions/Technical

Architect and his responsibilities included hardware sizing,

Infrastructure design, data modelling, designing MDM and data

quality strategy and worked with the stakeholders to obtain

signoffs for the design and architecture.

. This was done using Informatica Power Center/IDQ Ver 7.x/8.x,

Teradata and Erwin. This included 3 people onsite and 6 people off-

site.

VM Ware - Palo Alto, CA

. Mr. Das conducted a shortened Master Plan assessment for the

Consumer and Marketing Solutions group at VM Ware. His role was

that of a Solution architect and his responsibilities included:

assessing the current architecture, generating the technical

landscape, designing the MDM strategy, Assessing VM Ware's data

model conformance with an future SOA strategy and presenting his

findings to the IT management team of VM Ware.

United States Postal Service - Washington D.C.

. Mr. Das conducted a review of the architecture and design of the

Integration components of Seamless Acceptance to automate the

Business Mail Entry (BME) mail verification processes. This project

was to enable USPS to streamline their business mail acceptance

processes.

. His role was that of a ETL Architect/Designer. Mr. Das assessed the

Architecture and design, reviewed the technical plans met technical

standards of the client and effectively coach junior ETL

developers. The technology used was T-SQL, SQL Scripts and

Informatica Power Center Ver 8.x.

Chubb Insurance - New Jersey

. Mr. Das conducted a shortened Master Plan assessment for the Claims

EDW group at Chubb Insurance. Mr. Das assessed the current

architecture, analyzed ETL performance and made recommendations to

the Informatica Power Center code and environment to meet

performance requirements

Kraft Foods - Glenview, IL

. Mr. Das was responsible for the Data Integration of a Siebel

Incentive Compensation Management system. The Incentive

Compensation System was for consolidating different compensation

plans/systems for the sales and delivery workforce of different

divisions of Kraft Foods. His role was that of a Data Integration

Architect / Lead and his responsibilities included Architecture,

Technical Design, Data Modelling, Reviewing Team's Work and

providing timely and accurate status.

. This included 6 people onsite, 2 persons in Italy and 4 people in

India. Technology used were SQL Scripts, Erwin, Transact SQL and

Informatica Power Center.

04/2006 - 04/2007 Spherion, Los Angeles, CA, US

ETL Analyst / Designer

. Mr. Das provided Analysis, design & development expertise in proposing

enterprise definition(s) for a Multi Line Customer Data Mart at Farmer

Insurance. Mr. Das designed and implemented several complex Data

Warehouse loads & routines utilizing Informatica that met the business

objectives.

. For an Auto Pricing Data Mart, Mr. Das was involved in delivering an

enterprise data management design solution consisting of ETL Analysis

and leading a team of designers / developers in implementing several

complex Data Warehouse loads & routines utilizing Informatica ETL tool

suite that meets the business objectives.

. As part of ETL Analysis, he was responsible for mapping data from

Source systems to a consolidated Data Repository as well as the Data

Mart. This involves setting data transformation as well data

rationalization rules.

. He was involved in architecting the sophisticated Informatica audit,

balance, and controls (ABC) and data quality process for the project.

The technology used were Informatica, Erwin and DB2/UDB SQL Scripts.

06/2004 - 03/2006 Universal Music Group, Universal City, CA, US

Data Warehouse Developer

. Mr. Das provided analysis, design & development expertise in proposing

enterprise definition(s) for Point of Sale, Digital Music Sales &

Digital Financial Sales Reporting systems.

. Mr. Das conducted over a dozen interviews with key stake holders

obtaining requirements for reporting and analysis.

. Mr. Das delivered an enterprise data management design solution

consisting of a logical and physical data models, architectural

infrastructure, and designed and implemented several complex Data

Warehouse loads & routines utilizing Informatica ETL tool suite and

Unix Shell scripts that met the business objectives. Mr. Das

maintained those systems and further enhanced the Data Warehouse

integrating a comprehensive Digital Assets Delivery as well as Digital

Content Sales.

. Technology used were Informatica Power Center, Erwin, DB2/UDB and Unix

Shell scripts.

.

08/2001 - 06/2004 Medtronic Inc, Santa Rosa, CA, US

Data Architect

. Mr. Das was responsible for the strategy, principles, vision, and

standards for data within the organization. In that capacity, he was

responsible for the design, structure, organization, and maintenance

of that data, and for evaluating the use of data and relating data

directly to the goals and practices of the enterprise in a way that

provides clear results. Mr. Das focused on developing standards for

naming, describing, governing, managing, modelling, storing,

cleansing, and transforming all data within the division Mr. Das

provided a design and development framework for the Data Warehouse

environment. Technology used were T-SQL,

. SQL Scripts,PL/SQL, Informatica and Business Objects.

12/1999 - 05/2001 Kiracom, San Francisco, CA, US

Database Architect

. Mr. Das designed and implemented a data warehouse for a women's web

site using Oracle8 on Sun Solaris. Single-handedly designed the data

model and developed specific actions for all the processes for a

decision support system of a permission based marketing model.

. This model enabled the company, their partners and advertisers to

target consumers based on their demographics/preferences. It also

enabled the ability to conduct surveys and analyze member responses.

This enabled the company to approach businesses with analyzed data for

their product planning, design and management.

10/1998 - 11/1999 iOwn, San Francisco, CA, US

Senior Database Analyst

. Mr. Das designed and implemented Electronic Commerce applications for

the World Wide Web using MS SQL Server on Windows NT and Oracle 7.3 on

Sun Solaris. Mr. Das single-handedly designed, implemented and

administered the backend database for a Loan Management System and

Loan Processing System accessible to the iOwn Web site.

. Mr. Das prepared Entity Relationship Diagrams using S-Designer,

designing both the logical and physical database; wrote API

specifications; programmed extensive stored procedures using Transact

SQL and PL/SQL; monitored and tuned ORACLE performance; administered

security; and worked with front end web developers to coordinate

successful product delivery.

06/1997 - 09/1998 Alexis (CNA Financial Corp Subsidiary), Livonia, MI,

US

Database Analyst

. Mr. Das, analyzed requirements and existing data processing, and

prepared logical and physical database designs for a Claims Warehouse

using Oracle Designer 2000. Mr. Das prepared specifications for

information retrieval processes; developed stored procedures and

packages using PL/SQL, tuned ORACLE performance, carried out ORACLE

replication using snapshots.

. The application provided instant retrieval of critical insurance

claims information and generated data on tapes for the company's

clients.

12/1996 - 05/1997 CNA Financial Corp (Client), Chicago, IL, US

Data Acquisition Specialist

. Mr. Das provided consultation for three teams in a risk management

data warehouse project that included customizations, reporting and

maintenance, and initial data load.

. He designed conversion paths from legacy systems to a new data

warehouse for large account / risk management services clients. This

encompassed both business and systems knowledge of the insurance

industry, claims processing, and CNA's legacy systems.

12/1991 - 11/1996 AIG (Client), New York, NY, US

Consultant

. Mr. Das was involved with the design and development of Client-Server

applications on consulting assignments using a variety of Visual

Basic, MS SQL Server, SYBASE, DB2, CICS, COBOL and VSAM on Windows NT,

Windows 95, Unix and MVS platforms. Led projects throughout all phases

of the system development life cycle. Interacted with users to gather

requirements; wrote business specifications; prepared project plans

and monitored progress to ensure the deliverables were met; prepared

technical design specifications for the team; designed database

schema; programmed stored procedures and triggers; tuned database

performance; prepared test plans; and managed testing and

implementation.

. For American International Group, Mr. Das led a 16-member team in an

eleven-month project to design and develop a business reservation

system using Visual Basic, MS SQL Server, SYBASE System 11, Windows 95

and Windows NT. This system would replace a legacy system the group

had to maintain.

. For American International Underwriters, Mr. Das led a team of seven

in the design and development of the database portion of a

comprehensive insurance underwriting system using Sybase System 10 and

MS SQL Server.

. For American International Group, Mr. Das involved in the migration of

a Loss Management and an Underwriters processing system from VSAM to

DB2 using COBOL and CICS.

05/1984 - 11/1991 Various Companies/Clients, Mumbai, India

Lead Developer

. Progressed through increasing levels of responsibility from Programmer

Analyst to Lead Developer in the design and development of business

applications using COBOL on OS/2, MVS and RSX.

Key Skills:

Architectures:

Data Warehousing, ETL, IT Infrastructure

Business Systems

Sales Reporting, Underwriting, Claims, Marketing, Manufacturing, Supply

Chain, Pricing, Incentive Compensation

Databases

Sybase, Oracle, SQL Server, DB2 UDB

GUIs/Reporting Tools/CASE Tools

Business Objects, Data Workbench, Erwin, Power Designer, Cognos

Languages

ANSI SQL, T-SQL, PL/SQL, UNIX shell scripting

Methodologies

Software Lifecycle, Kimball Data Warehouse Toolkit,Star Schema Design

Operating Systems

UNIX, Windows, Linux

Warehousing Tools

Informatica 7/8.x/9.x, Business Objects, Cognos

Education:

. Bachelor's degree in Commerce in Accounting

. University of Calcutta, India

Contact this candidate