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:

Confidential

Sr. Data Conversion Developer

• Worked at Confidential 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.

Confidential

Managing Consultant/Architect

• Confidential 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.

Confidential

• Confidential 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.

Confidential

• Confidential 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.

Confidential

• Confidential 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.

Confidential

• 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.

Confidential

Consultant/Architect

• Confidential 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.

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