We provide IT Staff Augmentation Services!

Senior Conversion/integration/mdm Architect Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • US Citizen with 22+ years of progressive experience in providing IT consulting to Fortune companies in Oil & Gas, Energy, Telecommunications, Transportation, Manufacturing as well as to Government sector entities
  • Extensive expertise with Data Integration and Conversion architecture and methodology of high - profile corporate mergers, de-mergers, acquisitions such as AT&T/Cingular, Exxon/Mobil, GE, Energy Transfer/Southern Union, NOV, Confidential IL etc.
  • 22+ years extensive experience architecting Data Integration and Data Conversion solutions including expertise in Oracle, SQL Server, Snowflake and other Databases along with related tools such as PL/SQL, Toad, SQL Developer, SSIS, SnowSQL etc.
  • 13+ years of expert experience providing Informatica Power Center solutions (5X to 9X) and Informatica Intelligent Cloud Suite (IICS) including core Development, Administration, Architecture and Upgrades
  • Expert in MDM Architecture including Informatica MDM, Data Governance and Data Integration Architecture across large enterprises especially those with special data organizational requirements
  • 3+ years with Master Data Management (MDM) strategies and processes
  • 7+ years as an Architect and a Data Scientist (Data Integration, Conversions and MDM)
  • 5+ years of SSIS experience
  • 1+ year with Informatica Data Quality (IDQ)
  • Expert in creating, tracking and providing readiness status to PMO and OCM
  • Managed, Lead and Developed projects related to Data Integration, Data Conversions, Data Warehouses and Business Applications Implementations
  • Expert in Data Conversions, Interfaces, and Implementations of EBS-Oracle Financial Management (GL, AP, AR, FA), Oracle Manufacturing (PO, SCM) and Oracle HR, iasWorld-Property Tax Assessment, CRM-Siebel, Oracle and Clarify, and EIM-Callidus TrueComp
  • Expert in working with offshore teams, multiple vendors, composite team build-ups and in delivering solutions successfully against aggressive time.
  • Machine Learning and AI-Python, Fundamentals of ML and AI, Supervised Learning, Unsupervised Learning, Ensemble Techniques, Featurization, Model Selection & Tuning, Neural Networks, Computer vision and NLP.

PROFESSIONAL EXPERIENCE

Confidential

Senior Conversion/Integration/MDM Architect

Responsibilities:

  • Design, Architect and Develop the data extraction, conversion and mapping from Legacy (Mainframe/AS400) to Oracle based proprietary application called Integrated Property Applications System.
  • Design and Architect the Taxpayer and Address master data using Informatica MDM.
  • Establish Best Practices and Enforce standards during the entire lifecycle of Data Conversion and MDM governance.
  • Engage, Ensure and Confirm with different stakeholders during the entire progression path of the project leading to a successful implementation.
  • Lead the Design, Development and Scripting efforts of Informatica cloud, PL/SQL and SQL Loader for conversion of all historical data of “Property Taxpayers” in the county.
  • Define, Plan and Execute different phases and rollout strategies.
  • Architect different interfaces and reports based on client’s legacy requirements.
  • Define, update and escalate Data readiness metrics as per the project progression path.
  • Define, Develop and Ensure Data Quality and Integrity from Legacy to New Applications
  • Develop, Troubleshoot and Resolve errors while transforming huge amounts of data while successfully maintaining the linage of every data element.

Confidential

Senior Architect-MDM

Responsibilities:

  • Architect “Bid Process” solutions for the company including MDM, database and data transformations (Informatica 9x)
  • Architect and develop Informatica solutions against aggressive timelines to implement the new bid process that 1. Captures data from different sources into a single standard source, 2. Validates data against master data, and 3. Transforms data into the database for accurate reporting across the organization.

Confidential

Data Integration Architect/ Lead Specialist

Responsibilities:

  • Redesigning the database and ETL solutions to merge Transwestern and SUG pipelines.
  • Evaluated the gap and Adapted, Architected and re developed the existing ETL (Informatica) Solutions using SQL Server Integration Services (SSIS) toolset.
  • Designed, developed and successfully implemented the ETL solutions in Production against aggressive timelines and in co ordination with other teams to affect successful systems cut off from Panhandle Energy’s systems thus avoiding expensive systems and data support fees.
  • Supported business and reporting teams with data and related issues for the new redesigned BI solutions.
  • Implemented Adhoc databases and ETL solutions for new and special reports and providing support to the deployed ETL solutions.

We'd love your feedback!