SUMMARY

• 14 years of IT experience in analysis, design, development, testing and implementation of Data Modelling, Data Governance, Data warehouses, Data Migration, Data Integration, Master Data Management, Data Quality and Cloud Computing as Sr. Developer/Consultant and Architect.
• Extensive experience in Informatica MDM, IDQ, ActiveVOS, IDD, Provisioning, Power Center, AXON,TDM, ILM, Java, Mulesoft and AWS.
• Worked in various business domains like Insurance, Pharmaceuticals, Auto Finance, Supply Chain and Health Care.
• Experience in Leading a team of 10 - 15 people with excellent Customer Service Experience or Delivery Team Leadership experience.
• Working around constraining factors such as Key Challenges, environmental impact and project budget.
• Playing a part in project and team management.
• Working closely with a team of other professionals and architectural technologists.
• In-depth understanding of the domain and pertinent technologies.
• Identify and address architectural challenges. Create models and assess alternative approaches.
• Understand what technical issues are key to success and prototype/experiment/simulate towards the optimul solutions.
• Prepare architectural documents and presentations.
• Influence business strategy and Translate business strategy into technical vision and strategy.
• Understand customer and market trends and Capture customer, organizational and business requirements on the architecture.
• Work with developers with defined architecture and implement the solutions with quality within defined period of time.

TECHNICAL SKILLS

Infrastructure: AWS

Data Modelling Tool: Erwin, ER/Studio, MS-Visio, Toad Data Modeller.

Informatica Products: Informatica PowerCenter, Power Exchange, Metadata Manager, IDQ,Analyst, IDD, MDM, ILM,TDM,AXON,ActiveVOS, Provisioning Tool.

Other ETL Tools: SSIS, Oracle Warehouse Builder, Mainframe with COBOL, PL1, AS400.

Reporting Tools: Tableau, Cognos, OBIEE,SSRS.

Databases: MarkLogic,Oracle,VSAM, DB2, PS Files and MS Access, Netezza, SQL Server.

Tools: and Utilities: TOAD, SQL Developer, SQL Navigator, SQL Server Management Studio, SQL* plus, SQL* Loader, Autosys, CA, UC4, Changeman, SCLM, FileAid, Fault Analyzer,TIDAL.

ChangeManagement Tool: JIRA,SCLM,ServiceNOW.

Languages and Web Technologies: HTML, XML, XSD, JavaScript, SQL, PL/SQL, C, UNIX Shell Script, Perl Script,COBOL, PL1.

Operating Systems: Windows,UNIX,OZ/OS

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. MDM Consultant/Architect

Responsibilities:

• Build Master Data Management Architecture for Patient Domain.
• Designing Realtime Data injestion from internal and external Laboratory, Hospitals, Clinic etc.
• Current business process maps, data flow and overall system design.
• Data source profiling and format validations.
• Mastering requirements.
• Integration and real-time needs.
• Current validation process.
• Current and future data throughput and volume.
• Reporting and analysis needs.
• Critical institutional roadmap items
• ‘Quick win’ opportunities.
• Conceptual and physical system architecture.
• Design all data flow and process maps.
• Volume needs and related system sizing.
• Component selection (inclusion/exclusion of Informatica system components)
• Match / merge business rules and process.
• Real time integration between different sources and MDM and between MDM and Outbound application.
• Hierarchy designing for Partners’ Lab, External Patient, MML Patients.

Confidential, CA

MDM Architect

Responsibilities:

• Worked on MDM into Cloud(AWS).
• Worked on Micro Services and Integration with MuleSoft.
• Created Conceptual, Logical and Physical Data Model for Mastering Data of Providers like Hospital, Physician, Mid Level, PPG (Contracting Partner), non Physician and Ancillary.
• Creating Hierarchy and Relationship understanding the Busineed needs and how they can be setup in User Interface screen(IDD).
• Design end to end integration with different sourecs both Realtime and batch. Design Realtime and batch publishing layer from MDM.
• Requirement gathering, Requirement analysis and analysing of different source data, Data Profiling, generation of score card and Trend chart.
• Configured Base object,staging and landing tables.
• Configured Delta detection, RAW table, History tables.
• Defined System Trust and Validation rules for base object columns for Golden Records.
• Providing solutions to Realtime and Batch Integration with Inbound and Outbound sources.
• Working on SIF for Realtime and Batch Inbound Integration.
• Developed User Exists for Data Customization during the Post Stage and Post Load processes using Java.
• Configured User Interface from IDD application.
• Configured Entity 360 from Provisioing tool.
• Developed BES (Business Entity Services) for Outbound application for Data Pool from MDM.
• Created custom services from provisioning tool to serve approval process generated from external applications.

Environment: ER/Studio, MarkLogic, Informatica MDM 10.2, IDQ 10.1, Power Center 10.1, Mulesoft, ActiveVOS, IDD, Provisioning Tool 10.2, AXON, Oracle, Unix.

Confidential, Orange County, CA

Sr. MDM Consultant

Responsibilities:

• Working as a Senior Informatica consultant and MDM Architect in Data Governance and Supply Chain projects.
• Requirement gathering, Requirement analysis and analysing of different source data, Data Profiling, Score card generation and Creating MDM Data Model.
• MDM Installation on application Server JBOSS. MDM version upgrade.
• Hands on Informatica IDQ experience in Data profiling, Name Standadization, Address Validation, Name Parsing, Date fields validations, Phone number Standization.
• Creating DQ Error Report with the help of Informatica IDQ and integrate IDQ with MDM and ETL.
• Create conceptual, Logical and Physical data Model for MDM Base object tables.
• Provide solution of the ETL process to load Source data from various source applications to MDM Landing tables.
• Create DQ maplets for Name Standadization, Name Parsing, Error Report generation and Address validation using Address doctor in IDQ.
• Configured Staging tables, foreign key relationships, lookup tables, queries, query groups, packages and custom cleanse functions in MDM.
• Defined System Trust and Validation rules for base object columns for Golden Records.
• Configuration of SIF and run them using webService call from Power Center.
• Working with User Exits, message queue and configured Batch viewer and Batch groups.
• Unmerge, Batch unmerge, Soft Delete and Hard Delete in MDM.
• IDD configuration for Hierarchy, Smart Search, REST APIs, Composite Services, ActiveVOS.
• Configuration of IDD for Data Steward for manual merge and unmerge.
• Create different views from Golden records for downstream application, EDW.

Environment: Erwin, Informatica MDM 10.1/9.7, IDQ 9.6, Power Center 9.6, TIBCO, ActiveVOS, IDD, Provisioning Tool 10, AXON, SQL Server, Oracle,SSIS,SSRS.

Confidential, Los Angeles, CA

Senior Informatica Consultant(MDM Specialist)

Responsibilities:

• Working as a Senior Informatica consultant in Master Data Management and Data Migration projects.
• Requirement analysis and analysing of different source data, data Profiling.
• As a part of Migration project, generated reports from different source systems, datamart and loaded them into ODS. The new Supply chain tool was fed with the ODS data for gap analysis between the existing system and the new system.
• Developed complex Informatica mappings to load the data from various sources using different transformations.
• Discovered the data anomalies in Source data by data Profiling and standardized them with the IDQ mapplets and integrate them with MDM and ETL.
• MDM version upgrade.
• Involved in developing the mappings for moving data from sources ( Flat Files, AS400 data) to Staging (STG) and then to DWH and datamart.
• Created MDM Hub Console, Configured Base Objects and developed customed MDM mapping with clease functions for Supply Chain project.
• Configuration of user exits and IDD.
• Developed Slowly Changing Dimensions mappings (Type1, Type 2) as per the business requirements.
• Writing various Unix Scriptings including workflow triggering based on various criteria, FTP of files, control files etc.
• Used Debugger to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Performance tuning and Error handling both in ETL and MDM sides.
• Involved in unit testing and integration testing.
• Experienced with FTP process, scheduling tools like CA, UC4 to setup jobs and their dependencies.