Allan Smith

Summary:
 16+ years of IT experience in Software Design, Development, Analysis, Testing and Implementa-
tion of business applications for Manufacturing, Financial and Utilities verticals.
Experienced in:
 Installation and Configuration of Informatica MDM Hub 9.7.x/10.x, Cleanse and Match Server,
Informatica Power Center.
 Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the
Hub.
 Developing the Mappings to move the data loaded from Landing to Stage by using various
cleanse functions.
 Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
 Defining Static and Dynamic Lookups for Displaying the Data on the Hierarchies.
 Creating IDD application as per the business needs by creating the subject area and subject area
groups.
 Developing Put and Display packages for both Hierarchy Manager and IDD Application.
 Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns
and rules.
 Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automa-
tion Process.
 Data Processing experience in designing and implementing Data Mart applications using ETL tool
Informatica Power Center 9.1/8.6.1 and Informatica Power Exchange 9.x.
 Adept at understanding business processes / requirements and implementing them through
mappings and transformations.
 Involved in Database design, entity relationship modeling and dimensional modeling using Star
and Snowflake schemas.
 Extensively worked with mappings using different transformations like Filter, Joiner, Router,
Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggre-
gator and SCD Type-1,2&3.
 Experience in tuning Mappings and Sessions for better Performance.
 Experience in loading various data sources like Oracle, SQL Server, ERP’s, DB2 and Flat Files into
Data marts.
 Skilled professional experience in developing test plans, test cases, test procedures and execu-
tion of application using both Manual, Automated-testing tools.
 Dimensional modeling.
 Experience in writing Stored Procedures, Functions, and Packages etc using PL/SQL.
 Support and Maintenance of existing data warehouse and Informatica Servers through Infor-
matica Administration console.
 Worked on Informatica Administration Tool to maintain Informatica Servers, repositories, inte-
gration services.
 Upgrading Informatica Power Center applications and applying hotfixes.
 Developing Functional and Technical Specifications and provide User Training.

TECHNICAL SKILLS
EIM Tools : Informatica MDM 9.x, 10.x, IDD
ETL : Informatica Power Center 9.5/9.1/8.6.1, Informatica Data Quality/Analyst
9.5/9.1, Informatica Power Exchange 9.1
Operating Systems : UNIX (Solaris 8, Linux 9), Windows XP/2000/NT/98.
App Servers : JBoss EAP 6.1/6.2
Languages : C, C++, SQL, PL/SQL.
Databases : Oracle 11g/10g, MS SQL Server 2000/2005/2008/2012, Teradata

PROFESSIONAL EXPERIENCE

Selective Insurance, NJ Dec’2021 to Till Date

Role: MDM Developer

Environment: Informatica MDM Multi-domain 10.2, JBoss EAP 6.4, Oracle, Rundeck Scheduler

Schlumberger Limited is the world's largest oilfield services company. Schlumberger employs
approximately 100,000 people representing more than 140 nationalities working in more than 85
countries.
SLB MDM solution focused on management of Asset, Customer, Vendor, Product, Entity, Financial
Entity, Facility domains Data and also to effectively maintain the hierarchies and relationships between
Wells, Fields, Borehole, Rig, Customers, Suppliers, Vendors, Entities, Financial entities and Product
Entities.

Responsibilities:

 Created Low Level Technical Design document for MDM/IDD configuration during the design
phase
 Worked on staging and loading process using the batch viewer for initial and adhoc loads
 Configured Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match/Merge
and cascading unmerge Process
 Extensively worked on very complex process of Assets Match-Merge process
 Developed 3 different IDD applications for different business teams with different requirements
 Worked on Adhoc Unmerge/batch delete requests by business users
 Configured hierarchies and relationships for Assets, Customers, Entities, Financial Entities and
product domains
 Created roles and assigned users for different IDD applications and business units.
 Customized the IDD application UI as per business requirements
 Worked on Informatica MDM Administration issues, environmental issues and migration activi-
ties in production and non-production environments
 Performed Unit Testing, worked with Quality team on System Testing
 Created MDM query’s and packages for IDD application.
 Worked on MDM/IDD tasks in Agile sprint cycles
 Created Assets Entity 360 application using Informatica’s advanced Entity 360 framework
 Worked on Custom user exits for Hub and IDD
Boston Scientific Corp, MA Aug’2018 to Dec’2021
Role: Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, Informatica MDM Multi-domain 10.1, WebSphere,
Oracle

The Boston Scientific Corporation (abbreviated BSC) is a worldwide developer, manufacturer and
marketer of medical devices whose products are used in a range of interventional medical specialties,
including interventional radiology, interventional cardiology, peripheral interventions, neuromodulation,
neurovascular intervention, electrophysiology, cardiac surgery, vascular surgery, endoscopy, oncology,
urology and gynecology.
Boston Scientific EU Party MDM solution focused on management of Party Data
(customer/seller/vendor etc) and also to effectively maintain the hierarchies and relationships between
Customer, Seller, Vendor, Geographical Area and Product Entities.

Responsibilities:

 Worked with business analysts and customer on requirements for MDM data model, trust/vali-
dation, match merge rules and IDD configuration
 Worked on MDM Logical, Conceptual and physical data models using EA Sparx data modeler
tool
 Created Low level Technical Design document for MDM/IDD configuration during the design
phase
 Worked on End-to-End MDM Hub configuration for data loading from Landing to Base tables
and match-Merge for all parent and child tables
 Worked on Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and
Merge Process
 Worked on Security Access Manager (SAM) for creating roles and assigning users.
 Configured Hierarchies and relationships as per the business requirements
 Configured the whole BSC IDD application with all Subject Area Groups, Subject Areas and Sub-
ject Area childs and grand childs
 Customized the IDD application UI as per business requirements
 Configured business process workflows to manage data for Data stewards and Data Managers
for managing MDM Data in IDD using ActiveVOS
 Worked on most of Informatica MDM Administration issues, environmental issues andmigration
activities in production and non-production environments
 Performed Unit Testing, worked with Quality team on System Testing
 Created MDM query’s and stored procedures for IDD application.
 Worked on all major Informatica MDM environmental issues in Production and Non-Production
environments.

Schlumberger, TX Jul’2016 to Aug’2018

Role: Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, Informatica MDM Multi-domain 10.1, JBoss EAP
6.1, JBoss EAP 6.2, SQL Server, ASG-Zena Scheduler
Selective Insurance Group, Inc. is a regional insurance holding company based in Branchville, New
Jersey, and provides property and casualty insurance products and insurance services to customers in
the United States through its subsidiaries. Selective provides insurance, alternative risk management
products and related services to businesses and individuals, and administers flood insurance policies for
the National Flood Insurance Program. The Insurance Operations segment writes commercial lines and
personal lines property and casualty insurance through independent insurance agents in 22 states in the
Eastern and Midwestern regions of the United States.
Selective Insurance is using MDM for mastering EMAIL, CLAS and PLUS source systems. Email source
systems all the email data from all agents, customer survey email data. CLAS is a commercial customer’s
source system which has all customer data from commercial insurance line of business. Plus is a
personal customer’s source system which has all customer data from personal insurance line of
business. Once MDM masters all these source systems, agents will use web services to check for the
customer data for new policies through web services. These web services will be built for inbound data
and outbound data.

Responsibilities:
 Installed Informatica MDM 10.1 in SQL Server in Lab environment.
 Installed Informatica ActiveVOS as part of MDM 10.1 installation in Lab environment
 Worked on all MDM Admin activities like creating data sources, creating users, creating roles,
promoting the code to all non-Production environments, applying hot fixes/patches to the envi-
ronment in all non-Production environments
 Working with business on requirements for MDM data model and match merge rules.
 Working with business on requirements for IDD
 Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
 Configured JMS Queues for MDM and JBoss Messaging
 Configured Hermes JMS for Queue management for Queues in JBoss JMS
 Configured ORS specific and regular SIF services
 Automated MDM deployments through Metadata commands
 Automated daily backups of MDM metadata
 Working on Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and
Merge Process
 Worked on Security Access Manager (SAM) for creating roles and assigning users.
 Working on IDD application to search Devices by creating subject area groups, subject areas,
subject area child
 Working on manual merge tasks for Data stewards and managers for managing manual merge
tasks
 Created MDM query’s and stored procedures for IDD application.
 Work on all administration issues in Production and Non-Production environments.
 Work on Repository manager to migrate the code between Dev to QA or QA to Prod environ-
ments.

Zimmer UDI(ZUDI), IN May’2013 to Jul’2016

Role: Informatica MDM Lead Consultant
Environment: Informatica MDM Multi-domain 9.7.1, JBoss EAP 6.1, Informatica Power center 9.1, SQL
Server, Redwood Scheduler

Zimmer designs, develops, manufactures and markets orthopedics products, including knee, hip,

shoulder, elbow, foot and ankle artificial joints and dental prostheses. Zimmer has operations in more
than 25 countries around the world and sells products in more than 100 countries. The FDA issued a
‘final rule’ to establish a system to adequately identify medical devices through distribution and use.
This rule requires the label of medical devices to include a unique device identifier (UDI), except where
the rule provides for an exception or alternative placement.
Under the UDI system, the health care community and the public will be able to identify a device
through a UDI that will appear on the label and package of a device. The UDI system will make it possible
to rapidly and definitively identify a device and key attributes that affect its safe and effective use, and
will subsequently facilitate a reduction in medical errors that result from misidentification of a device or
confusion concerning its appropriate use.
Additionally, the UDI system will also facilitate healthcare product data synchronization and accurate
reporting of adverse events by making it easier to identify the device prior to submitting a report.
Synchronizing healthcare product data globally allows the healthcare industry to know when and where
products are produced and to manage recall and adverse event reporting to a global standard.

Responsibilities:
 Installed Informatica MDM 9.7.1 in SQL Server in Sand Box environment.
 Applied hotfix 2,3 for Informatica MDM 9.7.1 in SQL environment
 Worked with business team for new requirements and enhancements to existing requirements.
 Worked on all MDM Admin activities like creating data sources, creating users, creating roles,
promoting the code to all non-Production environments, applying hot fixes/patches to the envi-
ronment in all non-Production environments
 Defined and developed the ETL process to load the data into the landing tables during the land
process using Informatica Power Center
 Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
 Completed manual landing, staging and loading process using the batch viewer
 Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match
and Merge Process
 Worked on Security Access Manager (SAM) for creating roles and assigning users.
 Created and Implemented IDD application to search Devices by creating subject area groups,
subject areas, subject area child
 Created manual merge tasks for Data stewards and managers for managing manual merge tasks
 Created MDM query’s and stored procedures for IDD application.
 Worked on all production issues in MDM and IDD.
 Worked on all administration issues in Production and Non-Production environments.
 Worked on Repository manager to migrate the code between Dev to QA or QA to Prod environ-
ments.

LPL Financial, NC Mar’2010 to May’2013

Role: Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, 10.x, JBoss EAP 6.2, Informatica Power center
9.1,Informatica Data Quality/Analyst 9.1, Oracle 11g, SQL Server, Erwin, DIS Scheduler
LPL Financial is the largest organization of independent financial advisors in the United States. LPL
Financial advisors help clients meet investment goals with a number of financial services, including
equities, bonds, mutual funds, annuities, insurance, and fee-based programs. Unlike many other
brokerage firms, LPL Financial does not develop its own investment products, enabling the firm’s
investment professionals to offer financial advice free from broker/dealer-inspired conflicts of interest.
LPL financial is using MDM for mastering almost 12 million customers/Accounts and 20 million securities
information in a single location which is in various source systems like BETA, CUSIP, Direct Business etc.
The main goal of the project was to identify Single customer, Single Account, Single Security and relation
between Customer & Account, Customer & Advisor master across the enterprise. This customer
information is useful for faster decision making of approval process of lead and various decision makings
across the organization.

Responsibilities:
 Involved in the business requirements sessions with business for all project requirements.
 Involved in data modeling sessions for creating the model along with data modelers to align the
model with project requirements
 Configured Address Doctor in Informatica Data quality tool and standardized the address data
coming from source systems
 Installed Informatica MDM 9.7.0 in Oracle environment in all Non-Production environments.
 Applied hotfix 1 for Informatica MDM 9.7.1 in Oracle environment
 Upgraded Informatica MDM 10 in Oracle environment in all Non-Production environments.
 Worked on all MDM Admin activities like creating data sources, creating users, creating roles,
promoting the code to all non-Production environments, applying hot fixes/patches to the envi-
ronment in all non-Production environments
 Created the landing tables, base tables and staging tables as per the enterprise data model.
 Defined and developed the ETL process to load the data into the landing tables during the land
process using Informatica Power Center and Informatica Data Quality tools
 Configured the Foreign Key Relationships among the Base Objects and define the lookups for
the staging tables
 Created MDM landing to stage mappings as per the project requirements
 Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
 Completed manual landing, staging and loading process using the batch viewer
 Used Metadata manager to Import and Export of Metadata and Promote Incremental changes
between environments from development to QA/LDQA.
 Worked closely with the Business in gathering the Match rules and created the Match rule docu-
ment
 Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match
and Merge Process
 Worked Security Access Manager (SAM) for creating roles and assigning users.
 Created and Implemented IDD application to search Customer and Security by creating subject
area groups, subject areas, subject area child
 Created manual merge tasks for Data stewards and managers for managing manual merge tasks
 Created MDM query’s and stored procedures for IDD application.
Florida Power and Light, USA
Role: Informatica Power Center Developer Aug’2008 to Mar’2010

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX Shell Scripting, SQL Navigator

The purpose of AMI Data Warehouse is to store the data from UIQ and CIS systems. AMIDW acts as
Meter Data Management system for FPL with master data information about meter as well as
information about Meter Reads and Billing History.

The objectives of the project are:

1) Define controls and balances, data integrity, data quality and data consistency standards and best
practices for AMI DW data; 2) Assess each subject area of the AMI DW for compliance with defined
standards and best practices; 3) Provide a report outlining gaps between AMI DW and defined standards
and best practices; and 4) Recommend next steps.

Control and Balancing project has been divided into three steps

1) Control & Balance Audit Report 2) AMI DW Missing Data Analysis 3) AMI DW Governance Policies and
Procedures. The Control & Balance Audit Reporting will be implemented through various phases of SDLC
while Missing Data Analysis and Governance Policies and Procedures will be recommendation oriented.

Responsibilities:

 Analyzing the Source System.

 Designing approach.
 Development of the Informatica Mappings.
 Development of the Informatica Sessions/Workflows.
 Development of the SQL queries to pull the data from Source.
 Development of the small shell scripts required for Informatica Objects.
 Development of the Database objects like Tables/views.etc.
 Scheduling the Informatica Workflows.
 Monitoring and Supporting the Informatica workflows

DELL International Services

Role: Informatica Power Center Developer Jun’2006 to Aug’2008

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX Shell Scripting, Toad 8.6, Remedy Action
Request System, Control M, Data Allegro, Teradata.

As part of the DATAllegro retirement as the base and package layer, the business has decided to migrate
MPG Program to the Teradata 13.

Responsibilities:
 Analyzed business requirements, and worked closely with the DA's involved to domain and
sources to target data mapping document.
 Worked with DA's on logical and physical model designs of both Base and Package layers.
 Re-designed the mappings existed for MPG DATA-Marketing Programs Global program in such a
way that they can be used for this program for the daily loads in Teradata.
 Package layer is being implemented using Teradata macros and Informatica. As the volumes for
the daily loads being 20-30 mil records approximately tuned the queries in such a way that the
performance will be good.
 Worked with DBA to set up development, test, stage and production environments in Teradata.
 Performed unit testing and documented the results.
 Worked closely with QA team during the testing phase and fixed bugs that were reported
 Developed and Scheduled Control M jobs for the daily load invoked Informatica workflows &
sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and
target tables, Unix Script to create / update the parameter file, check source / target database
connectivity, delete tag files etc.
 Prepared code migration document and worked with release team in migrating the code from
Development to UAT, Production Servers.