SUMMARY:

• A senior Informatica Architect with very strong professional background in Data warehouse domain and over 15 years of industry experience in the software engineering, processes and methodologies, and management specializing in Informatica components.

TECHNICAL SKILLS:

Software: Informatica Data Quality, Power Exchange, Informatica 9.6, 8.6, 8.5, 8.0, 7.4, 6.4, 5.1(PowerCenter - Meta Data Manager, Pushdown Optimizer, Velocity Documentation), Informatica Services Integration Framework, Business Objects, Toad, Oracle 10g (table creation, schema creation, dimensional modeling), RHEL 6, HADOOP, Sybase(power center), Cognos, Master Data Management, Informatica B2B Data Exchange, Teradata Healthcare Logical Data Model, SFDC API, UNIX/LINUX Shell Scripting

Program languages: PL/SQL, JAVA, SQL, XML, C++

Reporting Tools: Remedy, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential,Phoenix, AZ

Informatica MDM Delivery Manager

• Gather requirements for the implementation of Informatica and data services solution.
• Act as a liaison between business analysts, project management, solution architects and development teams, and shepherd projects through the design, build, and test phases.
• Translate business requirements and business intelligence reporting requirements into functional/technical specification or source system analysis documents.
• Provide input from high-level to detailed estimates for intake, projects, and change requests in areas of responsibility.
• Create technical impact assessments utilizing input and direction from business analyst, architects, development and supporting documentation such as functional specifications and use cases.
• Perform proactive Data Profiling to ensure source system data requirements in the project deliverables.
• Assist project to find alternative solutions for the source data where appropriate.
• Provide analysis support to development and test teams for assigned projects. This can include responding to ad hoc analysis requests and collaborating with test resources to validate test cases, defect triage and resolution.
• Generally demonstrate knowledge of application systems in area of responsibility to identify, evaluate and define impacts of changes.
• Provide alternatives both to the application changing and all upstream and downstream systems, or identify if a change is a manual process taking into account the entire picture as well as the details

Tools: Informatica PowerCenter, Informatica Meta Data Manager, Informatica PIM, HADOOP, XML, HTTP, TOAD, SQL, Linux, SAP.

Confidential,Minneapolis, MN

Technical Solution MDM Delivery Manager

• Gather requirements for the implementation of Informatica and data services solution.
• Extract legacy data and process thru either web service, batch process, or direct ETL with Informatica.
• Develop ETL mappings based off Data Models from SAP source to support project.
• Create a DHA (Data Health Assessment) of data warehouse prior to extraction and data migration.
• Design preliminary column level data quality assessment with Informatica Data Quality.
• Implement data handling, cleansing, and standardization procedures and business transformation rules and logic (ETL) using Informatica 9.5 and Oracle 11g
• Develop, and implement functions, stored procedures, and ETL jobs using PL/SQL
• Actively participate in agile scrum review and planning sessions
• Actively participate in regular code reviews and maintenance of code and process documentation

Tools: Informatica PowerCenter, Informatica Meta Data Manager, Informatica PIM, HADOOP, XML, HTTP, TOAD, SQL, Linux, SAP.

Confidential,Allen, TX

Informatica MDM Specialist

• Gather requirements for the implementation of Informatica and data services solution.
• Extract legacy data and process thru either web service, batch process, or direct etl with Informatica.
• Develop ETL mappings based off Data Models from SAP source to support project.
• Create ETL data models from architecture models.
• Design application support protocols for 1st and 2nd tier support.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Power Exchange), HADOOP, XML, HTTP, TOAD, SQL, Linux, SAP.

Confidential,Houston, TX

Informatica MDM Specialist

• Design ETL architecture for initial solution and ensure scalability provide Informatica Administration duties using Informatica Services Integration Framework.
• Develop ETL mappings based off Data Models to support project.
• Informatica Power Center installation in multiple environments (AIX, Linux, and Windows 2008) with DB2 and SQL Server databases.
• Perform Informatica Admin duties as needed including but not limited to installing (Power Exchange on client, server, and source machine).
• Gather requirements for the implementation of Informatica and data services solution.
• Extract legacy data and process thru either web service, batch process, or direct etl with Informatica.
• Perform IDQ design activities and responsible for maintaining the cleanse functions.
• Assist with IDQ installation, product code migration, testing defect resolution, and initial data loads.
• Load SAP data sources migrating them into the data warehouse.

Tools: Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Power Exchange), Teradata, SQL, Linux, Sap.

Confidential,Jefferson City,Mo

Informatica MDM Specialist

• Design ETL architecture for initial solution and ensure scalability provide Informatica Administration duties using Informatica Services Integration Framework.
• Develop ETL mappings based off Data Models to support project.
• Informatica Power Center installation in multiple environments (AIX, Linux, and Windows 2008) with DB2, SQL Server and Hadoop databases.
• Perform Informatica Admin duties as needed including but not limited to installing (Power Exchange on client, server, and source machine).
• Subject matter expert “Patient Protection and Affordable Care Act” (Obama care) from the state of Missouri.
• Gather requirements for the implementation of Informatica as a Web Service driver and data services solution.
• Extract legacy data and process thru either web service, batch process, or direct etl with Informatica.
• Design application support protocols for 1st and 2nd tier support.
• Assist with IDQ installation, product code migration, testing defect resolution, and initial data loads.
• Design of the Cleanse functions & Match rules for various business entities

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Power Exchange), HADOOP, XML, HTTP, HADOOP, TOAD, SQL, Linux.

Confidential,Irving, TX

Informatica MDM Solution Architect

• Evaluate current data warehouse/ETL environment for usage in spend analytics solution deployment and provide gap assessment.
• Evaluate technical complexity of data sources from business units for initial implementation.
• Design ETL architecture for initial solution and ensure scalability provide Informatica Administration duties using Informatica Services Integration Framework.
• Develop ETL mappings based off Teradata Healthcare Logical Data Model to support healthcare analytics.
• Data validation and cleansing with Informatica Data Quality and Informatica Data Explorer
• Lead Discovery, data profiling & Requirements Analysis from SAP data sources to Hadoop database.
• Design of the Cleanse functions & Match rules for various business entities
• Assist with IDQ installation, product code migration, testing defect resolution, and initial data loads.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture, SIF), Java, XML, HTTP, TOAD, SQL, ORACLE, Linux, HADOOP, SAP, Teradata.

Confidential, Plano, TX

MDM Architect/Informatica Lead

• Design, Code, Test, schedule, and Implement project using Informatica/Oracle ETL and Informatica toolset administration (including server representation for the DWH EDW team).
• Interact with users to identify their requirements and deliver results appropriately. Debug and troubleshoot production environment application issues.
• Perform analysis and resolution of Help Desk Tickets and maintenance for assigned applications. Mentor Junior Staff and explore new technology.
• Perform IDQ design activities and responsible for maintaining the cleanse functions.
• Assist with IDQ installation, product code migration, testing defect resolution, and initial data loads.
• Lead Discovery, data profiling & Requirements Analysis to Hadoop database.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture, SIF), XML, HADOOP, TOAD, SQL, ORACLE, Netezza, Teradata, UNIX.

Confidential, Arlington, TX

Informatica IDQ Lead

• Creating financial requirement analysis, system analysis and design, development, implementation, and test plans.
• Data cleanup procedures, transformations, scripts, stored procedures and execution of test plans for loading the financial data successfully into the targets.
• Responsible for the successful operation of the development process.
• Lead daily developer meetings, decompose project into tasks monitor development and design progress.
• Coordinate development team's interaction with financial advisors, project managers, designers, analysts, and Q.A. and data consumers.
• Work with System Administrators and Database Administrators to monitor and tune performance
• Support administrative tasks within Informatica platform such as stopping/starting Informatica Repository and Server processes, performing code migration, backup and restore of Informatica Repository, upgrades and security administration.
• Documentation of legacy sources into Informatica mappings, develop financial star schemas fact/dimension tables for new mappings. Pull data from the Teradata source repository to move the data a staging area.
• Develop financial mapping documents using power center mapping analyst for excel. Design and develop the ETL process by studying the business requirements from the users and the mapping documents. Build repositories for IDE, IDQ and Power Center for data profiling.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture, SIF), TOAD, SQL, ORACLE, SAP, Teradata, HADOOP.

Confidential,North Chicago,IL

Informatica MDM Architect Lead

• Creating test strategies and test plans, Mentoring Junior developers.
• Data cleanup procedures, transformations, scripts, stored procedures and execution of test plans for loading the data successfully into the targets.
• Responsible for the successful operation of the development process.
• Lead daily developer meetings, decompose project into tasks monitor development and design progress.
• Lead Discovery, data profiling & Requirements Analysis
• Coordinate development team's interaction with project managers, designers, analysts, Q.A. and data consumers. Load data from Salesforce managing the technical delivery of integrations and custom extensions.
• Work with System Administrators and Database Administrators to monitor and tune performance
• Support administrative tasks within Informatica platform such as stopping/starting Informatica Repository and Server processes, performing code migration, backup and restore of Informatica Repository, upgrades and security administration.
• Documentation of legacy Informatica mappings, develop star schemas fact/dimension tables for new mappings. Pull data from the Teradata source repository to move the data a staging area.
• Develop mapping documents consisting of sources, targets, transformation logic from the information gathered from the business users. Design and develop the ETL process by studying the business requirements from the users and the mapping documents.
• Build repositories for IDE, IDQ and PowerCenter for data profiling.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture), XML, HADOOP, TOAD, SQL, ORACLE, Teradata.

Confidential,Overland Park,KS

Informatica MDM Architect Lead

• Load data to a Salesforce target database
• Work with System Administrators and Database Administrators to monitor and tune performance
• Support administrative tasks within Informatica platform such as stopping/starting Informatica Repository and Server processes, performing code migration, backup and restore of Informatica Repository, upgrades and security administration.
• Documentation of legacy Informatica mappings, develop star schemas fact/dimension tables for new mappings. Pull data from the Teradata source repository to move the data a staging area.
• Develop mapping documents consisting of sources, targets, transformation logic from the information gathered from the business users. Design and develop the ETL process by studying the business requirements from the users and the mapping documents.
• Build repositories for IDE, IDQ and PowerCenter for data profiling.
• Respond quickly and effectively to production issues and taking responsibility for seeing those issues thru resolution.
• Ensure system compliance with accepted industry standards and practices (such as corporate information factory data flow architecture, star schema modeling, and various ETL techniques).
• Develop strategies and ensure optimization of data acquisitions, archived data recovery, and publication and integration of data into Informatica data targets.

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture, SIF), Java, XML, HTTP, TOAD, SQL, ORACLE, SAP Teradata.

Confidential,Tucson,AZ

Informatica MDM Architect

• ETL batch development converting legacy systems and create mappings with Informatica.
• Installed and upgraded Informatica suite version 8.6 from 8.5, Informatica CDC.
• Wrote UNIX Scripts for ETL development for implementation in Informatica, report daily run daily with Cognos.
• Responsible for utilizing Extract, Transform & Load tools to map and establish the required movement of data.
• Designed and modeled Informatica data architecture and provided relational database design and Business intelligence reporting using Business Objects.
• Supported programming changes during quality assurance, user acceptance testing and post implementation to ensure integrity of application. Developed star schemas (fact/dimension tables) for development of new maps.
• 10 Terabits of data, 95 millions rows of transactions weekly, daily application support.
• Pull data from the Teradata source repository to move the data a staging area.
• Build repositories for IDE, IDQ and PowerCenter for data profiling.
• Followed System Development Life Cycle (SDLC).

Tools: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Pushdown Optimizer, Change Data Capture), Java, XML, HTTP, TOAD, SQL, ORACLE, SAP Teradata.

Confidential,Creve Coeur,MO

Informatica Data Warehouse Architect

• Designed, identified, analyzed, defined, modeled and mapped the data relevant to the information needs and requirements of existing and proposed systems using Oracle designer, including data modeling (schemas, fact tables, dimension tables) and provided application support.
• Converted existing VMS ETL batch into Informatica mappings.
• Worked as an ETL designer, VMS and Informatica administrator and data warehouse architect to achieve best practices IDQ (Informatica Data Quality).
• Provided performance tuning in Oracle 10g using database partitioning concepts.
• Planned, implemented data models and database designs; resolved database capacity issues, replication, and other distributed data issues. Developed star schemas (fact/dimension tables) for development of new maps.
• Wrote Informatica velocity documents and provided code review for all ETL development.
• Wrote UNIX Scripts for ETL development for implementation in Informatica.
• Utilized Informatica Extract, Transform & Load tools to map and established the required movement of data.
• Provided documentation to support program changes, Business intelligence reporting.
• Supported programming changes during quality assurance, user acceptance testing and post implementation to ensure integrity of application.
• 2 Terabits of data, 25 million rows of transactions daily, daily application support.
• Followed System Development Life Cycle (SDLC).

Tools: Informatica PowerCenter (Repository Manager, Scheduler, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager, Change Data Capture), Oracle, TOAD, XML

Confidential,Arden Hills,MN

MDM Engineer

• Financial data extracted from RDBMS and UNIX Operating Systems command-line development.
• Informatica ETL tool set for supporting, maintaining, and enhancing financial Metadata interfaces for a Demand Chain Management application (UNIX and SQL).
• Financial data warehousing architecture design including data modeling (schemas, fact tables, and dimension tables), designed mappings and provided application support.
• Provided Analysis, design, and development using Systems Development Life Cycle Methodology.
• Wrote financial ETL design document and provided code review for all ETL development.
• Provided technical consulting support on projects or system issues. Collected and analyzed financial business requirements for large, multifunctional projects.
• Wrote Unix Scripts for ETL financial development, Informatica IDQ. Developed financial star schemas (fact/dimension tables) for development of new maps.
• 8 Terabits of data, 75 million rows of transactions daily, daily application support.

Tools: Informatica 8.0 PowerCenter (Repository Manager, Scheduler, Designer, Workflow Manager, Workflow Monitor, Meta Data Manager), Oracle PL/SQL, Oracle designer, AutoSys, TOAD, UNIX

Confidential,Minneapolis, MN

MDM Assistant

• Provided version control setup, database conversion, application server deployment, completed setup and maintenance tasks for Learning Services. This involved setting up new products, patching applications when available.
• Provided support to users and developers on UNIX and Informatica.
• Developed and designed market database analysis programs to meet the needs of product management in identifying potential markets, targeting customers using customer information and demographics.
• Created, maintained and analyzed marketing database resources used in the development of marketing programs. PL/SQL code, Oracle forms and reporting, UNIX scripts, Oracle database and Informatica mappings. Developed star schemas (fact/dimension tables) for development of new maps.
• Created Informatica mappings using Data Warehouse best practices, SQL coding from scratch, debugging of code. AutoSys development in test and production.
• Developed an Informatica ETL solution as per the mapping document adhering to enterprise development standards.
• Developed Informatica velocity document from source system data elements to target system (data warehouse) elements with proper transformation rules. Worked with business users and source system experts to define the transformation rules.
• Daily application support.
• Used System Development Life Cycle (SDLC).

Tools: Informatica 6.4, Oracle PL/SQL

Confidential, Bloomington, MN

Systems Analyst

• Set up and maintained development and testing in JRE environments with UNIX scripting and Informatica source to target mappings and IDQ (Informatica Data Quality).
• Provided version control setup, database conversion to Oracle 10g, and application server deployment.
• Completed setup or maintenance tasks for Learning Services. This involved setting up new products and patching applications when available. rovided technical support to customers and internal employees.
• Implemented Informatica applications and workflow enhancements from business requirements, in accordance with corporate procedures and standards.
• Worked on Informatica modules: Admin, User, Import, Source, and Target. Integrating into Oracle Databases using SQL and XML and developing on both UNIX and Windows NT Operating Systems.
• Provided solutions using Oracle Tools such as Forms, Reports, Developer, and Designer.
• Translated complex business requirements and business rules into technical specifications and detailed design documents. Developed star schemas (fact/dimension tables) for development of new maps.
• Developed detailed test plans for all programming assignments. Analyzed, Designed, Tested and Debugged Coded; translated business requirements into logical and physical data models that support customer analytical and reporting demands.
• Created Packages, Functions and Procedures using PL/SQL and all necessary database objects for enterprise solutions.
• Provided performance tuning of all SQL code/queries IDQ (Informatica Data Quality).
• Worked cooperatively with users and other team members in problem resolution.
• Followed System Development Life Cycle (SDLC).
• Daily application support.

Tools: Informatica 6.4, Oracle 10g

Confidential, Bloomington, MN

Informatica Architect

• Provided analysis, design, code review, and testing of JavaScript and ETL functions.
• Accurately recorded all ETL designs and requirements. Developed star schemas (fact/dimension tables) for development of new maps.
• Installed, configured and troubleshoot software packages, including operating systems, desktop software and custom applications and ETL mappings with Informatica.
• Provided third level support for database and application issues; escalate complex problems to the appropriate groups or staff. Participate in IT projects such as system implementations, upgrades, product evaluations, disaster backup and recovery, and provide status reports at the end of each week.
• Daily application support.

Tools: Informatica 6.4, TOAD, UNIX, Oracle, AutoSys

Confidential, Bloomington, IL

Systems Analyst

• Resolved system issues and provided ETL support.
• Responsible for diagnosing, testing, repairing and maintenance of ETL designs and mappings, following Informatica ETL and first and second echelon procedures.
• ETL Integration and Interfacing of LDAP with Informatica Internet/Extranets, vendor systems and/or databases. SQL programming, Informatica mapping and troubleshooting errors.
• Performed "quick fixes", software upgrades and programming of subscriber equipment.
• Provided application support to customers and internal employees. Entered customer repair data into local market database to ensure proper tracking of all repairs. Develop an ETL solution as per the mapping document adhering to enterprise development standards.
• Troubleshot calls for cellular network using cellular support software.

Tools: Informatica 6.1, TOAD, UNIX, Oracle, AutoSys