SUMMARY:

• Highly accomplished and motivated IT professional with over 18 years of contribution in individual and leadership roles involving Enterprise Software and Consulting Services, catering to a variety of different areas across many industry verticals, including Data Integration, Data Governance, ETL and Master Data Management (MDM) and Business Intelligence/Data Warehousing,
• 15+ years of experience in end - to-end Life Cycle Design and Development of Data Warehousing (Dimensional Modelling, Database Design, Data Governance, ETL/ELT and Business Intelligence (Report, KPI, Scorecards, Dashboards)
• Certified Master Data Management and Big Data Management
• SME on building Enterprise Data Warehouse or Data Warehouse appliances from Scratch using both Kimball and Inmon Approach. Having knowledge in Big Data, Data Lakes Architecture and Design experience.
• Data Architecture (Conceptual, Logical, Physical) experience involves building Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, Use cases and KPI} using Erwin, TOAD and Visio.
• Expertise in Data Quality Matrix and Master Data Management in Patient/Product/Provider/Location/ Customer domains and in working with CXO levels, Business Heads, Data Stewards and Data Custodians.
• ETL Architecture experience involves defining different layers (landing/staging, recovery point layers,) Complete ETL schedule and flow to fit SLA, IDQ, Power Center, mapping design, Error handling and Workflow Design on Informatica. Knowledge in Data Integration, Data Virtualization, ELT Processing. Hands on mainly on Informatica, guided team on SSIS and DataStage. Worked on Databases like Oracle, SQL Server and DB2
• Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment
• Proven track record in Project Management in Traditional Methodologies and Agile Methodologies
• Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand (or get the customer to articulate) the business needs in terms of business value
• Managed and mentored 10+ team technically to deliver solutions from both Company and Vendors team

TECHNICAL SKILLS:

Data warehousing: Dimensional Modelling - Star, Snowflake, Fact Table, Dimension Table, Slowly Changing Dimension, Metrics, KPIs, OLAP (Worked on Both Kimball and Inmon Approach)

Domain Expertise: Healthcare/Insurance (Benefits Administration, Health, Dental, Vision, Life, AD&D, Short & Long Term Disability, Eligibility & Enrolment, Claims Processing, EHR, EMR, HIT, Patient/ Provider/ Location Master Data Management, Pharmacy Data and Hospital Management)

Bank: Customer/Branch/Product Master Data, Credit Card Utilization/ Disputes Tracking Analysis, Credit Management, Multiple Loans Processing, Cross Product Sales CRM (Customer Enrolment, Sales Enquiry, Sales Order Booking, Order Processing, Billing, Order Delivery, Logistics Monitoring, Service Monitoring, Customer Survey) Supply Chain Management Demand Analysis, Distribution Analysis, Financial Analysis, Fulfilment Analysis, Inventory Analysis, Procurement Analysis, Allocation Analysis, and Resource Analysis, Transportation Analytics, Retail Analytics Master Data in Product/ Vendor/Location domain

Telecommunication: Revenue & Usage Analysis, Customer Acquisition and Behaviour Analysis, Product Profitability. Custom churn Analysis, Customer Segmentation.

Languages: SQL, T-SQL, PL/SQL, XML, VB.Net and PB

ETL Tools: Informatica, Data Stage, TIBCO, IDQ, Power Center and MSBI

Data Modelling Tool: Erwin, E/R Studio, TOAD and Visio

Databases: Oracle, SQL Server, NoSQL and DB2. Epic, NextGen and Meditech products

Project Management: MS Office Suite, ITIL, MS Project, MS Visio and Agile Methodologies

BI/Reporting and Analytical Tool: Cognos, SQL Server (SSRS & SSAS) and Tableau

PROFESIONAL EXPERIENCE:

Confidential

MDM Informatica Architect

Environment: Informatica, MDM, Erwin, Oracle, SFDC, SAP, IDD, BES, SIF, DNB, IDQ, SoapUI, JBoss and UNIX

Responsibilities:

• As the MDM Architect involved in defining the MDM architecture, design and development of data management standards, policies and master data management as part of Data Governance program.
• Documented MDM standards, procedures, Party Model, Data Publishing process design,
• Migrated and consolidated the SAP & Siebel CRM data to SFDC. Implemented Customer and Account Master Data Management Domains by interacting with business heads and data stewards in Multi Domain environment. Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly
• Timely communication to the Project participants and management team about the progress
• Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization

Confidential

MDM Lead / Sr Data Architect

Environment: Informatica Erwin, MDM, IDD, SIF, BES, Active VOS, Informatica Cloud, SFDC, HBase, SQL Server, AWS, RedShift, DB2, JBoss and Tableau

Responsibilities:

• Prepare GAP Analysis, Data Management strategies, analyzing the GAP Analysis to improve the existing process of Data
• Coordination with the ETL & Reporting Development team with Design/Development approach to create a DataMart and Data Integration from source systems into Operational Data Store-ODS
• Implemented data architecture, Customer and Account Master Data Management Domains by interacting with business heads and data stewards. Worked extensively with Data Quality, MDM Hub, IDD, and as part of Data Governance Process implementation
• Worked with DBA's to get the Database design approved and implemented
• Define and Improve tasks to ensure Data Quality and standardize the process at enterprise level
• Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly
• Timely communication to the Project participants and management team about the progress

Confidential

Lead MDM Architect/ Data Architect

Environment: Erwin, Oracle, Informatica, IDQ, MDM, Active VOS, Hadoop, HBase, Big Data, MS Office, PL/SQL and Tableau

Responsibilities:

• Created Strategy Roadmap, Data Management, Dimensional Data Modeling, Database Design, Architecture of Enterprise Data Warehouse and Data Lakes
• Participated in Requirements Gathering, Business Analysis, User meetings, Business Consensus for Data Governance implementation by interacting with business heads and data stewards
• Lead the Data Architecture and BI Team in evaluating Vendor and Products Evaluations and Selection. Build the teams from internal and external sources for successful implementation of EDW and Data Governance.
• Extensively involved in ETL/ELT process to load data from different sources (structured/ unstructured) to data warehouse.
• Extensively used Informatica MDM and IDQ process in implementing Patient (Master Patient Index), Provider (National Provider Index), Pharmacy (Medicines) and Location domains.
• User inputs into technical design and to BI reports Using Tableau.
• Database application development and support using Oracle Optimized long-running queries.
• Trained business teams how to interact with the cubes.
• Identify numerous data issues and report other defects to outside vendors.
• Identify security holes, train co-workers, and offer alternative solutions.

Confidential

Lead Data Architect and MDM Expert

Environment: SAP, Informatica, Erwin, Informatica MDM, SQL Server, DB2, UNIX and Tableau

Responsibilities:

• Gathering the Project Requirement Analyze changes and Design Database Changes
• Providing alternate solutions or approach to improve the existing process
• Implemented customer/ Branch, Product Master Data Management Domains by interacting with business heads and data stewards.
• Coordination with the ETL & Reporting Development team with Design/Development approach to create a DataMart and Data Integration from source systems into Operational Data Store-ODS
• Worked with DBA's to get the Database design approved and implemented
• Define and Improve tasks to ensure Data Quality
• Find performance bottle necks and provide industry standard solution
• Standardize the process to the enterprise level
• Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly
• Timely communication to the Project participants and management team about the progress
• Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization

Confidential

Data Architect/MDM Specialist

Environment: SAP, VB, Erwin, MDM, Data Stage, Epic, SQL Server, SSIS, SSRS and DB/2

Responsibilities:

• Requirements analysis, User interaction for Business and Report requirements
• Designed new database structures. Created data modelsusing STAR Schema
• Documented Database Design standards along with data dictionary
• Involved in Informatica MDM and Data Quality process. Implemented Member, Payor, and Party Accounts to establish golden record
• Reverse engineered the data structures, provided data maps
• User inputs into technical design and to BI reports Using Tableau.
• Database application development and support using Oracle Optimized long-running queries.
• Trained business teams how to interact with the cubes.

Confidential

Data Modeler/ETL Specialist

Environment: Erwin, Oracle, Informatica, SAP, IDQ, MDM, Java, Arbor, PL/SQL, and Tableau

Responsibilities:

• Participated in Requirements Gathering, Business Analysis, User meetings, Business Consensus
• Architecture of Enterprise Data Warehouse Data Modeling and Database Design.
• Participated in Vendor and Products Evaluations and Selection.
• Extraction, Transformation and Data Loading and Data Quality from different sources to data warehouse
• User inputs into technical design and to BI reports Using Tableau.
• Database application development and support using Oracle Optimized long-running queries.
• Improved report performance using advanced modeling and report techniques.
• Implemented data and user-based security.