We provide IT Staff Augmentation Services!

Mdm Architect Resume

SUMMARY:

  • Extensive experience in Master Data Management, Data warehouse, Business Intelligence, application development for front end, back end and middle tier technologies.
  • Extensive experience in Data Warehousing and hands on with ETL tools like Ab Initio & Informatica.
  • Strong experience in PL/SQL, Shell Scripting and other programming languages.
  • Excellent Master Data Management, Data Warehousing and Data Modeling knowledge.
  • Excellent MDM experience as MDM/ETL Analyst with IBM Initiate MDS (Master Data Service); Work Bench, Hub, Inbound Broker, Outbound Broker, Enterprise Viewer, Initiate Inspector, Search Harness, Bulksearch, Clover ETL, Initiate BXM and IXM utilities.
  • Lots of experience dealing with the business end users. Excellent ability to understand and implement projects from the management perspective.
  • Excellent team building skills. Led and managed teams responsible for delivering/maintaining critical projects.
  • Experience in working as a Developer, Designer and Team Lead and Manager.
  • Good team player, hard working, self - motivated and self-learner with admirable interpersonal and communication skills.
  • Demonstrate ability in grasping both technical and non-technical concepts.
  • Excellent communication and interpersonal skills, with the ability to work independently and/or adapt to any team environment.

SKILLS SUMMARY:

Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4, HP-Unix).

Master Data Management: IBM Initiate 9.7, IBM Infosphere 10.1

ETL Tools: Ab Initio (GDE1.15, Co>OperatingSystem2.15), Informatica, Power Mart 4.7, Power Center 7.1.x and 5.1.

Languages: SQL, PL/SQL, Unix Korn Shell, C, C++, JavaScript, VBScript, HTML, XML, ASP and .NET Framework

RDBMS: Teradata V2R5, Oracle 11g, SQL Server 7.0/2000, MS Access 97/2000

Scheduling Tools: Autosys, Control M

Database Utilities: Teradata SQL Assistance 6.1, Toad 7.5, SQL Loader, BTEQ Win

DSS Tools: Crystal Reports 8.0/8.5, Business Objects XI R3

CM Tools: Ab Initio EME Environment, PVCS, Visual SourceSafe 6.0, Harvest, Subversion

Testing Tools: Test Director 7.6, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential

MDM Architect

Responsibilities:

  • As Technical Architect, work with prime vendor Accenture to review existing data model for Federal Facilitated Marketplace.
  • Design scalable Java EE SOA architecture for MDM Cloud Services.
  • Implement MDM governance process and whiteboard solutions for Y2015 Small Business Healthcare Enrollment.
  • Plan multiple work streams and delineate tasks for building MDM Identity Hub.
  • Consult Department of Health and Human Services for COTS product selections, Data Center requirements and strategic road map.
  • For the business interfaces, present to Government the ‘Initial Operating Capability’ to the CMS Technical Review Board and ultimately present the ‘Final Operating Capability’ for the U.S. Senate.
  • Installed Initiate MDS v10.1 Red Hat Linux in Data Center VMs.
  • Design bucketing algorithm and configure PME to populate weights table.
  • Define Data Extract elements and configure Workbench MPXDATA jobs for bulk cross match (BXM Process).
  • Configured Inbound Brokers for the ingestion of daily delta changes
  • Created Composite View of the entity EMCA, MMCA and golden record in Enterprise Viewer
  • Installed Workbench, Enterprise Viewer and Inspector utilities.
  • Run analytics profiling tool prior to re-distributing buckets.
  • Use FPF filter to adjust auto-link threshold.
  • Configure LDAP security and Data Steward grouping hierarchies.
  • Manage technical resources on a daily JAD format.
  • Review test plans and ETL architectures. Prepare Data Model (in Erwin) and Virtual Data Dictionary.

Environment: Informatica Power Center 9.5, IBM Initiate 10.1, REHL, Oracle 11g

Confidential

Manager in EDS. Delivery Lead, Tech Lead, and ETL Designer/Architect

Responsibilities:

  • Successfully managed a team of 15-20 resources (On-Site and Off-Shore) in CDI/MDM and ETL
  • Successfully integrated ~150 M customer account records across 32 sources.
  • Successfully implemented High Availability with 99.999% availability
  • Successfully used BXM(Bulk Cross Match) solution to identify the common customers between Confidential and partnership customer data
  • Developed Ab Initio Solution to load the data from different sources into CDI Master Files and create deltas to be loaded into HUB.
  • Successfully implemented ACE framework creating reusable templates on existing enterprise pattern Ab Initio graphs
  • Successfully used IXM (Incremental Cross Match) to integrate the 8.9M customer account records within 10 hours into CDI.
  • Successfully designed and implemented Initiate Algorithms for Person, Business and Household
  • Successfully implemented in-house built Match Quality Operational Manual Review process
  • Responsible for the management and implementation of the EDW and CDI/MDM solution
  • Worked with Initiate Support, DBA’s, UNIX, Storage teams to tune and improve performance
  • Successfully designed and deployed Inbound, Entity Management, Outbound broker processes
  • Successfully lead several system conversions and delivered complex new business capabilities
  • Strong Vendor Management skills: IBM/Initiate and On-Site/Off-Shore Resourcing partners

Environment: IBM Infosphere, Initiate MDS CDI/MDM Versions 7.5/8.5/ 9.7, Ab Initio GDE 3.1, Co-op 3.1, Ab Initio ACE, UNIX/Linux, Oracle, Teradata

Confidential, Washington, DC

Senior Ab Initio Developer

Responsibilities:

  • Involved in design and architecture of the whole application.
  • Designed various IR2 modules for Loan Setup and Payment processing modules for various programs like 1MP, 2MP, HAFA, FHA and RDHAMP.
  • Involved in various High level design and detail level design review meetings.
  • Involved in designing the workflow for the whole project
  • Involved in various handshake meeting between Confidential and external partners.
  • Supported testing efforts in both system test and acceptance environments
  • Supported various releases in Production as well as acceptance environments.
  • Designed the file transfer B2B protocols with different recipients using Flex File Exchange
  • Involved and supported Adhoc Database Modification and File Modification processes.
  • Developed process for Cleaning up the ETL UNIX file system and BOXI Wintel file system.
  • Developed Data Quality mappings using Informatica Data Quality tool.
  • Scheduled the calendar jobs using the Autosys Scheduler
  • Involved in process design as per Risk and Compliance Standards

Environment: ETL, Ab Initio (GDE 1.15, Co>Op 2.15), Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX, Business Objects XI R3, Informatica

Confidential, Washington, DC

Architect / Analyst / Senior ETL Specialist/ Team Leader

Responsibilities:

  • Technical team lead and also responsible for leading the team, providing the technical solutions and also designing, developing, testing, and implementing the Mortgage backed Securities ETL processes and architecture.
  • Responsible for understanding business and functional requirements and converting them into technical requirements and mapping documents.
  • Involved as Designer and Developer for Guaranty Business System (GBS).
  • Developed Ab Initio graphs and high level design and detail design document for data movement.
  • Developed parameterized Ab Initio Graphs to load the data in to Oracle Staging Tables.
  • Create cfd, pset, data, and ctrl files.
  • Performed transformations of source data with transform components like Write Multiple Files, Run Program, Join, Dedup Sorted, Reformat, Filter-by-Expression and Rollup, etc.
  • Unit testing of new and existing Graphs.
  • Used Automated Test Framework to test the Ab Initio graphs.
  • Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
  • Writing Korn Shell Scripts in Aix UNIX to automate the ETL process.
  • Scheduling the Graphs using Autosys Scheduler.

Environment: ETL, Ab Initio (GDE 1.13.3.2, Co>Op 2.13.1), Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX

SENIOR AB INITIO DESIGNER/TEAM LEAD

Confidential, Charlotte, NC

Responsibilities:

  • Responsible for gathering business and functional requirements.
  • Involved as Designer and Developer for Securities Collateral Tracking (SCT).
  • Development of source data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
  • System extract processes - CDMG will develop the data requirements for each system of record extract, and will work with business and IT support staff to create and/or modify extract processes.
  • Testing and data validation - each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management.
  • Involved in various EME data store operations like creating sandbox, code check-in, code check-out according to the environment settings for the Securities Collateral Tracking (SCT) application.
  • Developed Ab Initio graphs and high level design and detail design document for data movement.
  • Developed Ab Initio Graphs to load the data in to Loan, Loan-Coll and Acct-Address MVS data files for RDW Group.
  • Involved in Universal cleansing process for COBOL copybooks and mvs data files.
  • Create cfd, pset, data, and ctrl files.
  • Writing functions for Date/Time list formats.
  • Running Development Scripts to convert the COBOL copybooks to create clean EBCDIC and ASCII dml’s.
  • Creating several Complex Graphs in Ab Initio for different system of records.
  • Unit testing of new and existing Graphs.
  • Responsible for creating Test Autosys jobs in development and test environments.
  • Promotion of Code from development to test environments using Harvest Source Control System.
  • Responsible for the code to be unit tested in the Dev Source tree before migrating it into the test environment.
  • Responsible for checking the validity of the control files for business dates and record counts and also validated the ETL output files with the record counts in the input files.
  • Responsible for of team members on Autosys, Harvest and also guided them to understand the development and test cycles.
  • Responsible for sending timely status updates to the team, enabling downstream users to load the tables into Informix.
  • Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
  • Writing Korn Shell Scripts in Aix UNIX to automate the ETL process.
  • Scheduling the Graphs using Autosys Scheduler.

Environment: ETL, Ab Initio (GDE 1.13.3.2, Co>Op 2.13.1), Ab Initio Enterprise Meta Environment, Mainframe, COBOL Copybooks, MVS, Harvest, Autosys, UNIX

SENIOR AB INITIO DEVELOPER

Confidential, Richmond, VA

Responsibilities:

  • Responsible for gathering business and functional requirements.
  • Worked with business users to come up with the format of scrub books used to massage the data to hide the customer sensitive data from the offshore developers.
  • Responsible for developing Ab Initio graphs for the data scrubbing process that enabled users to create customized test data based on parameters and environment variables.
  • Initial setup for Ab Initio like writing Unix Scripts. Ex: setup scripts, deployed scripts etc.
  • Build various Sandboxes in order to create Adhoc & Regular applications in Ab Initio.
  • Build several Ab Initio graphs for the test data generator. These enabled the generator to scrub and unload data from production and load it into DMZ.
  • Developed the process to parse the Scrub books to get parent-child relationship between the database tables to be unloaded.
  • Developed the process to generate the DML for the tables to be unloaded.
  • Developed the process to unload the data from the tables and scrubbed the data as per the rules specified in the scrub books
  • Published the data into files in the following naming convention ...txt.
  • Created the various parametric graphs to download and scrub the data from different databases like Teradata, Oracle and also from Flat files.
  • Used Ab Initio Shop for data for running the Data Scrubbing of tables on demand by business users.
  • Performed transformations of source data with transform components like Write Multiple Files, Run Program, Join, Dedup Sorted, Reformat, Filter-by-Expression and Rollup, etc.
  • Wide usage of Lookup Files to scrub the data.
  • Writing Korn Shell Scripts in Aix UNIX to automate the ETL Process.

Environment: ETL, Ab Initio, Ab Initio Enterprise Meta Environment, Ab Initio Shop for Data, Teradata, UNIX

Confidential

Responsibilities:

  • Initial setup for Ab Initio like writing UNIX scripts. Ex: setup scripts, deployed scripts etc.
  • Build various Sandboxes in order to create Adhoc & Regular applications in Ab Initio.
  • Check out existing applications in UNIX in order to perform the necessary modifications.
  • Designed and developed several credit card applications like Account Transfer, Customer, and Snapshot for both US Card and Canada Credit Card Data.
  • Participated in design and code reviews, designed the production support documents.
  • Supported the offshore developers with their activities in, coding and rollout code to the QA environment.
  • Provided fourth level production support to the applications developed by the Confidential team.
  • Developed the Credit Card Application in compliance with Sarbanes Oxley standards by taking care of Data Lineage.
  • FTP the new and existing Ab Initio applications to the local host.
  • Creating several Complex Graphs in Ab Initio to Automate the Banking Process.
  • Unit testing of new and existing Graphs.
  • Responsible for developing the reusable components and Graphs.
  • Worked extensively in development of Job Tracking and (N) Monitoring System (JTNM) which tracks the ETL Loads.
  • Responsible for writing stored procedures and Macros needed for JTNM System.
  • Extensive usage of Multi files system where data is partitioned into eight partitions in two nodes for parallel processing.
  • Working with Partition components like Partition-by-Key, Partition-by-expression, partition-by-Round robin to Partition the data from Serial File.
  • Working with De-partition Components like Gather, Interleave in order to De-partition and Repartition the data from Multi File accordingly.
  • Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Reformat, Filter-by-Expression, Rollup, etc.
  • Create summary tables using Rollup, Scan as well as Aggregate.
  • Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
  • Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
  • Writing Korn Shell Scripts in Aix UNIX to automate the ETL Process.
  • Scheduling the scripts using Control M Scheduler.

Environment: Ab Initio GDE 1.10.4, Co>Operating System 2.10.11, AIX UNIX, Control M, Teradata, Oracle, Test Director, Clear Quest

ETL DEVELOPER

Confidential

Responsibilities:

  • Maintenance and enhancement of the project.
  • Prepare production support schedules.
  • Planned and mitigated risks.
  • Defined and implemented the development processes.
  • Approved and consolidated weekly status reports.
  • Verified authenticity of issues raised and followed it up until closure.
  • Conducted project review meetings.
  • Coordinated with onsite team lead.
  • Scheduling the scripts using Autosys Scheduler.
  • Using Data Warehouse Management Systems (DWMS) Cycles to load data from ETL Server to Reporting Servers.
  • Responsible for optimizing the stored procedures, which transform the data.
  • Played a major part in analysis and improving the Confidential Performance (Mini Project).

Environment: Windows 2000, SQL Server 2000, Informatica, Sybase, Visual Source safe 6.0, MS SQL Analysis Services

ETL DEVELOPER

Confidential

Responsibilities:

  • Maintenance and enhancement for the project.
  • Prepare production support schedules.
  • Planned and mitigated risks.
  • Defined and implemented the development processes.
  • Approved and consolidated weekly status reports.
  • Verified authenticity of issues raised and followed it up until closure.
  • Conducted project review meetings.
  • Coordinated with onsite team lead.
  • Providing technical guidance to the team.
  • Responsible for coding the stored procedures that check the data quality from source to destination.
  • Responsible for optimizing the stored procedures, which transform the data.
  • Played a major part in migration of the project from SQL Server 7.0 to SQL Server 2000. (Mini Project)

Environment: Windows 2000, SQL Server 7.0 & SQL Server 2000, Informatica, Visual Source Safe 6.0

MODULE LEADER

Confidential

Responsibilities:

  • Actively involved in managing the team, requirement analysis, design, database design, coding, testing and documentation.
  • Analysis of the specifications provided by the clients.
  • Design and development.
  • Assisting team members and delegation of work.
  • Created database tables, stored procedures and triggers.
  • Database tuning - tuning SQL statements, tuning data storage, performance tuning and optimization.
  • Optimize the SQL statement using optimizer hints and restructuring of the SQL statement.

Environment: ASP, HTML, JavaScript, VBScript, SQL Server 2000, Windows 2000, IIS5.0

Hire Now