Data Architect Modeler

Amirul Choudhury

Naperville, Illinois 630-***-**** ****************@*****.***;

DATA ARCHITECT & DATA MODELER

** ***** ** **** ********* & data modeling experience. Worked as a Lead OLTP & ODS DATA Architect & Data Modeler to develop Conceptual, Logical and Physical Entity Relational Model and tuned the data model up to 3rd Normal Form. Experience also includes Lead Data Warehouse & Data Modeler to develop Conceptual, Logical and Physical Star Schema Data Model using Ralph Kimball’s Methodology. Additionally, worked as a Lead Data Lake Architect & Data Modeler to develop HYBRID (Semi Normalized & Denormalized) model for Conformed Layer and Views or Star Schema Model for Published layer. Experienced in building flattened structures for Hadoop databases.

Data Warehouse Developer: 15 years of data warehousing experience. Worked on multiple full Lifecycle data warehouse implementations. Worked on gathering report requirements, KPI matrix development, Dimensional Star and Snowflake data modeling, Data Source Analysis, Data Mapping & Data Cleansing using Transact-SQL, PL/SQL & INFORMATICA tool. Worked on MICROSOFT ANALYSIS SERVICES, COGNOS, BUSINESS OBJECTS and SAP BW OLAP tools.

MDM: 15 years of Master Data Management experience in OLTP, ODS environment.

DBA: 2 years of work experience as a DBA (ORACLE & MS SQL server)

SQL Development: 10 years development experienced in Transact/SQL and PL/SQL.

TECHNICAL EXPERTISE

Operating Systems: Windows XP, 2000; AS400, UNIX, and VAX

Databases: Snowflake 9.2.8, 8.15.0, Databricks (Run time Version 13.3), DBeaver, Hadoop, ORACLE

10g, 9I, 8I, 7, Microsoft SQL Server 2008, 2005, 2000, 7.0, 6.5, Gitlab, TeraData, DB2,

ACCESS & SYBASE.

OLAP: MS ANALYSIS SERVICES & PROCLARITY, BUSINESS OBJECTS 6.1, 5.1,

COGNOS TRANSFORMER, POWER PLAY & IMPROMPTU, CRYSTAL REPORTS & SAP

BW.

ETL: SSIS 2014, INFORMATICA 5, 6; BO Data Integrator, Transact-SQL and PL/SQL

Languages: MDX, C++, JAVA, XML, ASP, Visual Basic, COBOL, HTML, Visual Café

Softwares: ERWIN 12.1, 8.2, 8.1, 7.3.1, ER/Studio 9.01/8.5/7.5/7.1, ERWIN Data Profiler, Power

Designer 16.5.4.3, 15.2,12.5, IBM InfoSphere Data Architect 9.1.2.0. 9.1.1, Rochade 7.6, SAP

MDM, Console 7.1, SAP MDM Data Manager 7.1, SAP MDM Import Manager 7.1, SAP MDM

Syndicator 7.1, SAP PI (Net Weaver), Web Method, SAP R3, SAP MDG, Siebel 8.11,

REMEDY, ATRIUM, VANTIVE, Evoke AXIO,TOAD,SAPHIR, Test Director, MS Project,

PVCS Tracker, Microsoft Visual Studio 6.0, Microsoft Visual Source Safe, Install Shield,

DataFlux, PVCS, TFS (Team Foundation 2013 (TFS), Guide Wire, Query Builder & Rapid

SQL 8.5.0.

PROFESSIONAL EXPERIENCE

Northwestern Mutual, Milwaukee, Wisconsin 01/2025-Current

APEX Systems, Inc

Enterprise Data Warehouse (AWS, Snowflake & DBT) Projects

NM’s Finance & Risk Function (FRF) team developed a reporting solution for Finance & Risk business area for optimal & scalable delivery of financial insights for a growing organization responsiveness to its environment.

Solution Architecture: Participated in the discussion in developing the overall solution architecture for the project using AWS environment. Solution architecture components used are AWS DMS, AWS Lambda, AWS Transfer (SFTP), S3 Database, AWS Glue (Convert files to Iceberg), Snowflake databases (Raw, Type, Stage, Curated Layer, Consumption Layer), DBT, Power BI, AWS Athena, AWS Eventbridge & AWS Batch.

Data Mesh Architecture: The project used ‘Data Mesh’ architecture to develop ‘Data Products’. Worked on the below data products.

PFI, CALYPSO, PLM & JDE DATA PRODUCT: Developed multiple data products for Management Investment team: Developed STAR schema data models with journal transactions for PFI, CALYPSO, PLM & JDE applications.

ABOR_TRANSACTION Data Product (Accounting Book of Record): Developed an integrated harmonized journal transactions for 4-sub-leger systems i.e PFI, CALYPSO, PLM & JDE. Developed Star Schema data model with Credit & Debit Amount, General Ledger Account, Asset, Party & Date Dimension.

GL Data Product: Developed Star Schema Data Model with General Ledger Fact, Budget Ledger Fact, Business Unit Dim, Account Dim etc for GL data product which were sourced from PeopleSoft application.

Big 3 Report Development: Developed a Star Schema Data Model for the YTD balances and monthly results for Invested Assets, Net Investment Income, and Realized/Unrealized Capital Gains/Losses. In addition, Actual vs. Plan amounts for Net Investment Income and Realized/Unrealized Capital Gains/Losses are shown to illustrate how actual balances of our investments are doing relative to what Plan expected. Worked with complex Asset hierarchy with Fixed Investment (Corporate Bond, Structured Bond), Equity Investment (Real Estate Joint Venture, Common-Preferred Stock), Derivative (Future, Forward, Swaption) to develop the data model.

Worked as a Lead Data Warehouse Data Modeler to develop Logical and Physical Star Schema Data Model with facts and dimensions in ERWIN 12.1 in Snowflake 9.2.8 from KPI Dimension matrix. Used ‘Ralph Kimball’s Methodology to develop the Star Schema with ‘Conformed’ Dimensions and Facts. The overall architecture (Medallion) was developed with a RAW, TYPE, STG, CLS, PRE/PTP (VIEWS) layers to capture initial load and delta data. Developed Type 1 and Type 2 Slowly Changing Dimensions, ‘Error Processing Mechanism’ for CLS (Cleansed) tables. Developed ‘Data Mapping & Transformation document’ and Data Dictionary for CLS tables.

Data Analysis: Performed data analysis using SQL for Assets, Portfolio, General Ledger, Sub Ledger transaction models in Snowflake 9.2.8. Analyzed DBT codes to make sure correct data were moved from layers to layers.

Vertex Pharmaceutical (A life science firm) 11/2024 – 01/2025

Enterprise OLTP Project (8-Weeks project) Xendat Data & Analytics

Vertex developed an Ontology that provides a consistent set of metadata properties for programs & activities that can be mapped to disease areas and built into the Dotmatics platform to enable compliance.

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual & Logical ‘Entity Relational Data Model’ with Master & Transactional entities and normalized them upto 3rd Normal Form in MySQL Workbench 8.0.

Evernorth Health Services, A CIGNA Group Company 10/2023 – 10/2024

Enterprise Data Lakehouse (Databricks & Hadoop) Projects RandStad Digital Cigna's Evernorth division includes pharmacy benefit manager Express Scripts, specialty pharmacy Accredo and the rest of Cigna's health service product lines. Its focuses include benefit management, behavioral and clinical care, pharmacy, and intelligence.

Data Lakehouse Project (Databricks)

Project: Accredo Specialty Pharmacy Integrated Reporting Environment (ASPIRE): Evernorth developed a reporting solution for the existing Specialty Pharmacy RXHome operational system for Accredo Specialty Pharmacy application. The purpose is to deliver the data in real time fashion via Databricks (DBx) in AWS 10 environment. The data model consisted of a combination of hybrid normalized & denormalized entities which were implemented in ‘Conformed’ zone. VIEWS are built in ‘Published’ zone which accessed data from the conformed layer. Entities developed were Patient, Pharmacy, Claim Center (Payer), Compound & Non Compound Drug, Invoice, Prescription, Payment, Prior Authorization, Sales Order etc.

Project: MSK: MSK Chat is basically an async chat - where a message sent by agent (Care Advocate - CA) will wait for the user to be read and user may not be active on the conversation when CA sends the message. The effort is to identify how many users have not read messages from CA and once the user is identified, a notification will be sent to the user saying there is a message waiting for him to be read.

The overall architecture was built with Raw Zone (JSON structure using KAFKA load (MSK) or source aligned tables (ASPIRE), Conformed and Published layers in Databricks version 13.3. Worked as a ‘Lead OLTP Data Modeler’ to gather requirements from the JSON structure to develop the Conceptual, Logical & Physical ‘Entity Relational Data Model’ with Master & Transactional entities and normalized them upto 3rd Normal Form in ERWIN 12.1. Used Sub Type Super Type, Parent Child, Associative, ‘Key Value Pair’ and Union concept etc to develop the data model. Additionally, developed Verb Phrases for the relationships, Class Words for the attributes and defined definitions for the entities and attributes for developing the logical model. Used Naming Standard File for the attributes for abbreviation purpose and applied Primary, Foreign, Unique Key, Column constraints, Audit Attributes, Audit Entities, Views etc. to develop the physical data model. Developed Type 2 slowly changing entities (INSERT ONLY) to capture history data. Identify financial fields for security tagging (data masking).

Performed data analysis writing SQL in the source system i.e Teradata database 17.10.03.11 in developing the data model with tables & fields and also developed data mapping documents for source to target mappings with transformations information from the Raw Zone (Staging area) to the Conformed Layer and Conformed Layer to Published Layer.

CVS Pharmacy & AETNA Health Insurance, Hartford, Connecticut

01/2017- 10/2023 Fulltime Employee (Apr 2021 to Oct 2023) & Consultant Thru Timewell Inc (Jan 2017 to Apr 2021)

Transactional System (OLTP), Enterprise Data Warehouse - Data Lake (Hadoop) Projects

Worked as a Lead Data Warehouse, OLTP & Hadoop Data Modeler to implement 80 projects in a span of 7 years in the area of Claims, Member, Membership, Provider etc.

Transactional System Development (OLTP)

Project: Hedis Digital

HL7® (Health Level Seven®3) developed FHIR® (Fast Healthcare Interoperability Resources) standard which defines how healthcare information can be exchanged between different computer systems regardless of how it is stored in those systems. It allows healthcare information, including clinical and administrative data, to be available securely to those who have the right to do so for the benefit of a patient receiving care. Developed Logical & Physical Interface Data Model for FHIR for CLINICAL data with the entities Encounter, Observation, Diagnostic Report, Procedure, Condition, Patient, Practitioner, Immunization, Allergy Intolerance, Location & Organization. The purpose of the project to populate FHIR structures with Clinical data (CDR) and later link them with claims data via the patient data.

Project: MCOE SSIBroker Web

SSI (Senior Supplement Insurance) Agent Portal is a Web-based application Aetna built for their own agent & TPA’s (Third Party Administrator) to manage their end-to-end business functionalities. The application consist of features like Agent On-boarding, Commissions reporting, Agent reporting etc. Developed an AGENT data model with Party, Person, Organization, Party Role, Party Relationship, Party Alternate Identifier, Party Contact etc. concept.

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual & Logical, Physical ‘Entity Relational Data Model’ with Master & Transactional entities and normalized them upto 3rd Normal Form in IBM InfoSphere Data Architect 9.1.1.0 for DB2 10.1.database.

Data Warehouse - Operational Data Store Development – (ODS)

Project: Financial Reporting Data Mart

AETNA bought COVENTRY Healthcare whose Federal Business (Federal Employee Health Benefit Plans (FEHBP) claims needs to be available for Claim Financial reporting. Those claims include the following for Mail Handlers (MHMP), Rural Career (RCBP), and Foreign Service (FSBP): Medical (including Minute Clinic Claims from CVS for RCBP only), Dental, & Pharmacy (CVS and ESI).

Worked as a Lead Data Warehouse Data Modeler to develop a PAYOR Logical & Physical hybrid normalized & denormalized ‘Entity Relational Data Model’ for CLAIM system (Claim, Adjustment & Reversal). Worked with CLAIM, FUNDING, PAYMENT, OVERRIDE, MEMBERSHIP & PROVIDER etc business areas. The overall architecture was developed with a ‘Staging’ and a ‘Datamart’ area to capture the source data. Implemented Type 1 and Type 2 Slowly Changing Dimensions and designed the ‘Error Processing’ handling for the Data Mart tables for null, Primary Key and Foreign Key constraints.

Data Lakehouse Project (Hadoop Project)

Project: Warehosue2020 Project (Hadoop Modeling—Big Data)

Aetna replaced their existing enterprise data warehouse with a Hadoop database. The project integrated multi sources for Membership, Provider, Policy, Product, Claims data in a centralized location.

Worked as a Lead Data Warehouse Data Modeler to develop a Logical & Physical hybrid normalized & denormalied ‘Entity Relational Data Model’ with entities & attributes in IBM InfoSphere Data Architect 9.1.1 in HortonWorks 2.6’s Hadoop HIVE database for the ‘Conformed layer’. The data model was developed with Party, Person, Organization, Membership, Product & Policy data.

The reporting architecture was built on ‘Data Lake’ concept which consisted of ‘Raw Data Archive’, ‘Raw Viewable’, ‘Conformed Layer’, ‘Integration Layer’ & ‘Analytical Layer’. A denormalized flattened fact table structure was developed in the ‘Analytical layer’ for the reporting purpose.

Data Warehouse Project (Hadoop Projects)

Project: HEDIS (Healthcare Effectiveness Data & Information Set)

NCQA established HEDIS measures specifically for SNPs. HEDIS is a comprehensive set of standardized performance measures designed to provide purchasers & consumers with the information they need for reliable comparison of health plan performance. SNPs can use HEDIS performance data to identify opportunities for improvement, monitor the success of quality improvement initiatives, and provide a set of measurement standards that allow comparison with other plans.

Project: QMDM (Quality Measure Data Mart) (Hadoop Modeling—Big Data)

Ability to do organization specific HEDIS (Healthcare Effectiveness Data & Information Set) reporting and Plan Sponsor reporting for employer specific contractual agreements and performance.

Project: QMART (Quality Measure Analytic Research Tool)— Hadoop & Netezza

Quality Measures Analytic Research Tool (QMART) will provide users with access to HEDIS and other Quality Measures Engine data in an easy-to-access format. This tool will be used internally by HEDIS staff to research questions related to HEDIS data and perform in-depth analysis.

Worked as a Lead Data Warehouse Data Modeler to develop a Logical & Physical

‘Denormalized Flattened Structure’ with entities & attributes in IBM InfoSphere Data Architect 9.1.1.0 for HortonWorks 2.6’s Hadoop HIVE database. The overall architecture was developed using source, staging and target database (CIF,COF etc) and reporting areas such a QMDM & QMART for Commercial, Medicare & Medicaid data.

Other Hadoop Projects

Project: FEHBP SIU (Special Investigation Unit) Reporting Project (Hadoop Modeling—Big Data)

The Aetna SIU needs to provide claims data to the Office of Policy Management (OPM) for employees of three Federal Employee Health Benefit Plans (FEHBP). SIU reports dealt with identifying & investigating potential insurance fraud cases for Medical and Pharmaceutical claims.

Data Warehouse Development (DB2)

Project: MCAID NextGen Train 6 Finance Hedis:

The primary goal of this project to migrate Medicaid members to NextGen environment. The focus of this project was to bring Medicaid Hedis reporting into the Enterprise Asset (Quality Measure Engine) and Commercial/Medicare HEDIS reporting team.

Project: Medicare Next Gen Project

Market Prominence (MP) provides enrollment, billing and premium services for the Medicare Joint Venture (MCR JV) members under the Innovation Health (PPO & HMO plans) in the Virginia market. Developed a reporting solution for ‘Enrollment’ data from the MP system.

Worked as a Lead Data Warehouse Data Modeler to develop a Logical & Physical hybrid normalized & denormalied ‘Entity Relational Data Model’ with entities & attributes in IBM InfoSphere Data Architect 9.1.1.0 for DB2 10.1.

Northwestern Mutual, Milwaukee, Wisconsin 04/2015-09/2016

APEX Systems, Inc (04/2015 -09/2015); USTech Solutions (10/2015 -09/2016)

Transactional System Development (OLTP)

NM is an insurance firm who developed a transactional system for NGIS (Next Generation Illustration System) which is used for planning & sales for insurance (Life, Disability, Annuity) products.

Worked as a ‘Lead OLTP Data Architect & Data Modeler’ to develop the Conceptual & Physical ‘Entity Relational Data Model’ with Master & Transactional entities and normalized them upto 3rd Normal Form in Power Designer 16.5.4.3 in a Microsoft’s Azure’s Cloud Based environment for MS SQL Server 2012 database in a Continuous Availability environment. Used Legal Entity, Person, Organization, Legal Entity Role Type, Legal Entity Role Relationship etc concepts in developing the data model. Performed gap analysis between Cassandra (NOSQL – Query based data model) & MS SQL Server databases capabilities. Worked in Rochade 7.6 to analyze & standardized enterprise metadata for the transactional system and for the integration layer (Orchestrator) between different components of the application.

MS SQL Server DBA Role: Worked as a MS SQL Server 2012 DBA role to generate DDL from the physical model & maintained tables, VIEWS, INDEXES etc in the database using Rapid SQL 8.5.0.

Arkansas Blue Cross Blue Shield (ABCBS), Little Rock, Arkansas 05/2014-01/2015

Enterprise Data Warehouse-ODS(Operational Data Store) Amitech Solutions ABCBS who provides health care coverage to its customers built a data warehouse solution for CLAIM business area for pharmaceutical, medical, dental business lines etc. Worked on multiple number of 3rd party pharmaceutical claims i.e extract from MEDCO system (Walmart’s employee’s non risk drug Claims), CAREMARK system (TYSON’s employees non risk drug claims & Commercials i.e BCBS Member’s risk Drug Claims) to build a reporting system. Responsibilities as a data architect.

Operational Data Store Development (ODS)

Worked as a Lead OLTP & MDM Data Modeler to develop the Logical and Physical ‘Entity Relational Data Model’ for Claim system (CLAIM & ADJUSTMENTS) with entities & attributes and normalized them upto 3rd Normal Form in IBM InfoSphere Data Architect 9.1.0 & ERWIN 8.2 for DB2 10.1. The PAYOR data model was developed with PARTY, ADDRESS, PROVIDER, DRUG, CLAIM & MEMBERSHIP entities. Worked on a table driven approach to develop a unique record for the PARTY and ADDRESS table. Used ‘MATCH & MERGE’ rule tables to develop the MDM (Master Data Management) master records for PARTY and ADDRESS.

Savvis, A CenturyLink Company, St Louis, Missouri 08/2013-04/2014

Customer & Product Master Data Management project Stockell Consulting

Savvis replaced their current Configuration Management Database (CMDB) in VANTIVE (8.2.2) with REMEDY and ATRIUM systems. Worked as a Lead OLTP & MDM Data Modeler & Data Analyst to develop an Enterprise MDM solution with Customer & Product Master data.

Worked in the capacity of Enterprise Lead OLTP & MDM Data Modeler & Data Analyst to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Customer, Product Master entities and normalized them upto 3rd Normal Form in ERStudio Studio 9.01. Applied Party concepts such as Party, Company, Company Hierarchy, Person, Party Role, Party Relationship, Product etc to develop the data model. Worked on ‘Key Cross Reference’ table and developed a mapping document which maps unique keys from source system to MDM and MDM to downstream systems for master data. Worked as an MS SQL Server 2008 Application DBA to generate tables from DDL and also maintained tables and VIEWS in the database.

Data Analyst & Data Profiler: Wrote Transact-SQL to perform data analysis for database tables and developed VIEWs for the development team. Performed Data Profiling (Column profiling) on tables and attributes in INFORMATICA Power Center Designer 9 for VANTIVE, REMEDY and ATRIUM tables.

Data Governance: Formed data governance teams for the CMDB and Customer data and identified the owners for the data and the process to improve the quality of data.

Analyze BMC Atrium CMDB Data Model 7.6.04 for classes and attributes and mapped them with VANTIVE’s Configuration Management Database’s tables and columns.

Cardinal Health, Columbus, OHIO 03/2013-05/2013

Product & Customer Master Data Management project Information Control Corporation

Cardinal Health is a healthcare distribution firm who redesigned their existing ‘Pharmaceutical Distribution’ Product and Supplier Master data to better support their Pharma application modernization. Product master also included 3rd party data such as First Data Bank, GS1, Medispan, CMS (Medical & Medicaid Claim data), UPC, GTIN (Global Trade Item Number) and Taxonomy Hierarchy.

Worked as a ‘Lead OLTP & MDM Data Modeler’ to develop the Conceptual, & Physical ‘Entity Relational Data Model’ with Product Master, Supplier and 3rd party entities and normalized them upto 3rd Normal Form in Power Designer 15.2.0. Participated SAP MDG and IBM InfoSphere MDM workshops to perform gap analysis for the MDM tool selection process.

SRDS, Des Plaines, Illinois 08/2012-11/2012

Transactional System, MDM Development & Enterprise Data Warehouse Project AEQUOR

SRDS is a Media firm who needed to reengineer and integrate all of their current disparate transactional systems i.e Media, Circulation, Online Display Advertising, Ownership, Finance, CRM (Sales Force) & 3rd Party Data (Nielsen, Scarborough, SQAD) to one integrated transactional system.

Worked as a ‘Lead OLTP & MDM Data Architect & Data Modeler’ to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Master and Transactional entities and normalized them upto 3rd Normal Form in ERWIN 7.2 for Oracle Database. Developed DDL for the Oracle database and passed them to the DBAs. Applied Party concepts such as Party, Organization, Person, Party Role, Party Relationship etc in developing the data model.

Dearborn National, Oak Brook, Illinois 01/2012-06/2012

Wholly owned subsidiary of Health Care Service Corporation (HCSC) W3R Consulting

Enterprise Data Warehouse/Business Intelligence Project

Dearborn National is a Life, Disability and Dental Insurance company who developed a reporting solution for PAS (Prospect Automation System) system which generates Quotes for Life, Disability and Dental Insurance. PAS reporting solution is centered around i.e Product Management, Sales and Underwriting.

Worked as a Lead Data Warehouse Data Modeler to develop the Logical and Physical Data Model from the report requirements in ERWIN 7.3.11 in MS SQL Server 2008. The Logical model was built using ‘Entity Relational Data Model’ with Entities, Attributes and their relationships and tuned the model upto 3rd Normal Form. The physical model was built with entities denormalized to develop physical tables for reporting purpose. The overall architecture was developed with a ‘Stage’ and a ‘Datamart’ area to capture initial load data and delta data. Developed Type 1 and Type 2 Slowly Changing Dimensions, ‘Error Processing Mechanism’ for Data Mart tables, ‘Data Mapping & Transformation document’ and Data Dictionary.

Grant Thornton, Oak Brook, Illinois 08/2011-12/2011

Transactional System Development(OLTP) APEX Systems, Inc

Grant Thornton (GT) is a Tax, Audit and Advisory firm who developed a Global Application (One Application Globally) on Relationship Check. Relationship Check application deals with checking conflicts of interest between GT executives against a prospective clients.

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Entities, Attributes and their Relationships and normalized them upto 3rd Normal Form in ERWIN 8.1 for MS SQL Server 2008. Worked with complex Organizational hierarchy (Client, Subsidiaries, Branches & Person) and stored them in an XML file in the database.

Developed a comprehensive Enterprise ‘ERWIN Data Modeling Standard and Procedure’ for the logical and physical data modeling for the Data Management Group. Additionally, developed a data modeling process to be followed by all projects as per the data modeling group’s guidelines.

American Family Insurance, Madison, Wisconsin 12/2010-07/2011

Transactional System Development (OLTP) AE Business Solutions

AFFAM is a Property & Casualty Insurance firm who developed an integrated applications in the area of Quote, Policy, Claims Processing, Claims Financials, Claims Group Payment, Billing, Vehicle Characteristics for Policy Rating, Security, Premium Calculations, Medical Billing etc. Worked as a Lead OLTP Data Modeler in 15 different projects simultaneously to develop different applications. Applications developed were ICS Claims, Claims Financials, Claims Group Payment, Life Point of Sales Migration, Policy Processing, Vehicle Information Service, Commercial Lines PSP/UPM, ISO, Consumer Reports Services, Commercial Farm Ranch Pricing Sophistications, SiteMinder Security, Minnesota EDI (835), Agency Sales Manager, HIPAA 4010A1 Conversion to 5010 Electronic Mapping.

Conceptual, Logical & Physical Data Model for AFFAM Projects

Worked as a ‘Lead OLTP Data Modeler’ i.e Relation Data Modeler to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Entities, Attributes and their Relationships and normalized them upto 3rd Normal Form in ER Studio 8.5.3 for ORACLE & DB2 database.

MillerCoors, Milwaukee, Wisconsin 08/2009-12/2010

SAP MDM Implementation TekSystems

Miller and Coors merged together and developed a ‘Master Data Solution’ in SAP MDM software. Worked as an OLTP & MDM Lead Data Modeler to develop a consolidated master data such as Product, Customer, Security, Calendar etc for SAP MDM application.

Conceptual, Logical & Physical Data Model for SAP MDM (Master Data Management)

Worked as a Lead OLTP Data Modeler to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Entities, Attributes and their Relationships and normalized them upto 3rd Normal Form in ERWIN 7.3.1. Used Naming Standard File for the attributes for abbreviation purpose and applied Primary, Foreign, Unique Key constraints, Audit Attributes, Audit entities, Views etc for the entities to develop the physical data model.

Developed Physical Model for the staging tables in ERWIN 7.3 for TeraData 12.0 database for SAP MDM tables in EIW environment (Data Warehouse Environment). Developed Canonical Structures i.e normalized hierarchical structures staging tables for syndication purpose.

Worked on Normalized vs Denormalized syndication from MDM to the subscribers. Used Real time, Normalized and Delta mechanism for transferring data from MDM to the subscribers.

Distributor Interface (DRIVE)---Subscriber System for SAP MDM

Transactional System Development (OLTP) TekSystems

Worked as a Lead OLTP Data Modeler to develop an Ordering Entry tool for MillerCoors’s Distributors replacing the legacy ordering tools.

Conceptual, Logical & Physical Data Model for Distributor Ordering System

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Entities, Attributes and their Relationships and normalized them upto 3rd Normal Form in ERWIN 7.3.1. Developed DDL for MS SQL Server 2008 and executed them in the database. Developed staging tables for Master data in MS SQL Server 2008 which were populated by the Web Method (XML) from the SAP MDM.

John Deere, Moline, IL 03/2009-06/2009

Transactional System Development (OLTP) Yash Technology

John Deere developed an Inventory Management System (IMS) for it’s Dealers (Retail Business) to track Deere and Non Deere product at the dealership. Responsibilities as Lead Data Modeler were

Data Architect Role: Participated in the discussion of Real time data integration architecture i.e Web Service Architecture for the IMS. Inventory Management data (transaction Data) is linked real time with multiple number of existing master data databases via Web Service messages (XML). The architecture was built on Service Oriented Architecture (SOA).

Conceptual, Logical & Physical Data Model for IMS Transactional System

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual, Logical and Physical ‘Entity Relational Data Model’ with Entities & Attributes and normalized them upto 3rd Normal Form in Power Designer 12.5.0.2198 for DB2 database. Developed the Inventory Management System (IMS) with Serialized and Non Serialized Product Master Data. Used ‘Arts Data Model’ (Retail Industrial Model) as the basis for developing the IMS.

British Petroleum Warrenville, IL; London, England; 10/2007-09/2008 Transactional System (OLTP) Development Harvest Consulting

British Petroleum implemented their Global Financial Template (GFT) i.e Finance Master & Transaction Data for General Ledger, Controlling, Accounts Payable, Accounts Receivables and Asset Management etc. in SAP R3 system. Worked as a Lead OLTP & MDM Data Modeler to develop Conceptual & Logical Data Model for GFT business processes.Led and facilitated multiple workshops in London to sell the data modeling concepts to the business stakeholders.

Finance Data Road Map: Conceptual and Logical Data Model for GFT Transactional System

Worked as a ‘Lead OLTP Data Modeler’ to develop the Conceptual & Logical ‘Entity Relational Data Model’ with Entities, Attributes and their Relationships and normalized them upto 3rd Normal Form in ER/Studio 7.5/7.1. Used SAPHIR (SAPHIR reads SAP data dictionary) to analyze the existing SAP tables and compare them with the business processes to develop the logical model. Used ER/Studio Macros to generate data dictionary

Contact this candidate