Manager Data
Resume:
Eduardo Hiram Godinez Aguirre
Summary
Informatica MDM HUB Developer Certified with 6+ years of experience in IT with certifications/training and deep understanding of EIM (Informatica MDM), datawarehousing (Teradata), ETL tools (Informatica) and database. Knowledge and training in virtualization (Citrix, vmware) and server infrastructure (HP). Experience in the healthcare vertical projects.
Expertise in installing, managing and configuring Informatica MDM Hub Server, Informatica MDM Cleanse Server, Hub Resource Kit.
Experience using SSRS (SQL Server Reporting Services) to represent the Master data to the customer.
Experience using Informatica cloud to make connections between MDM and source systems.
Strong background in creating Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions in Informatica MDM.
Expertise in Informatica MDM Hub Match and Merge process, Batch Jobs, Batch Groups, Validation Rules, Trust settings for source systems.
Creation of user exits (Post Merge) for specific business requirements.
Developed MDM mappings to data domains for performing data extraction, data validation, data cleansing, data match, data load, and exception handling.
Extension of External match functionality by including it on an in house software solution.
Designed update strategy on merged records after initial deployment.
Developed the test scripts for UAT and the created the documents.
Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
Provided several presentations to the business on the MDM functionalities.
Support of the MDM and SSIS jobs and stablished the bases to migrate to Control M.
Automated the MDM execution using batch commands, PowerShell scripts and Windows Scheduler.
Provided several reports to the business explaining why the records were merged, when and make changes if needed.
Solve MDM Priority 1 production issues as well as Priority 2.
Expert in developing Informatica Power Center mappings to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Flat files and MS Access with Informatica.
Extensive experience in Informatica Power complex transformations like Expressions, Routers, Unconnected/Connected Lookup, Source Qualifiers, Aggregators, Filters, Joiners, Aggregator and SCD Type-1,2&3.
Improve performance in Teradata data warehouse through the extensive experience in primary/secondary index and Teradata Architecture (AMP).
Experience in Teradata DML, DDL, DCL.
Expertise in Teradata BTEQ, Fast Export, Fast Load, MultiLoad, TPUMP, PL/SQL Stored Procedures and Triggers.
Experience in writing the test scripts and document it as per the business logic
Performed System Integration and Unit testing for bug free code
Expertise in testing the code in all phases of the project and support the needs
Developed Citrix sizing (Licenses, Servers, Windows configurations) in several companies using vmware and HP servers.
Extensive expertise configuring and tuning Citrix XenApp and XenDesktop. Involved in vmware implementation.
Comprehensive understanding on HP Enterprise technologies.
Certifications, training
Informatica MDM HUB 9.x Developer specialist
Informatica MDM HUB Boot camp training
Teradata 14 training by Mentor Global
Informatica 9 (power center designer, workflow manager, workflow monitor) training by Mentor Global
Unix fundamentals training by Mentor Global
Microsoft Technology Associate Database Administration Fundamentals (E429-2521)
Microsoft Technology Specialist Windows Server 2008 R2, Server Virtualization (E132-8410)
Microsoft Certified Professional Developer in SharePoint server 2010 (Microsoft Certification ID 9023677)
Citrix Certified Administrator in XenApp 6.5 (CTX491353)
Citrix Certified Administrator in XenDesktop 5 (CTX491353)
Citrix Certified Sales Professional (CTX491353)
Citrix in Amazon EC2 Training by Compusoluciones
SDLC (Software Development Life Cycle) training by Mentor Global
HP Expert One Implementing Rack and tower server solutions training
HP Expert One Technical Certified II Enterprise solutions (PL71785782)
Professional experience
Direct Energy, headquartered in Texas, is the leading energy company. Direct energy is using MDM for aggregating almost 2 million customers based on the address and names. The main goal of the project was to identify golden customer master across the enterprise. The customer information is useful for faster decision making of approval process of lead and various decision makings across the organization. The difference with other MDM projects is that all the source systems are billing systems.
Responsibilities:
Highly experienced with installation and setup.
Creation of SSRS (SQL Server Reporting Services) to represent the Master data to the customer.
Creation of part of the Base objects, Staging tables and relationships.
Involved in the queries and package development.
Worked with Informatica in a proof of concept using Informatica cloud.
Manage and deliver report to the data stewards and data steward manager.
Development of the MDM mapping and cleanse functions.
Work closely with the ETL data architect to populate landing tables in MDM.
Defined Mapping data from Loading Tables to Staging Tables.
Conducted brain storming sessions with business users to understand matching requirements
Creation of user exits (Post Merge) for specific business requirements.
Set up match/merge and run match rules to check the effectiveness of MDM process on data.
Standardized the data using cleanse functions.
Creation of data profile of each source system.
Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
Extension of External match functionality by including it on an in house software solution.
Designed update strategy on merged records after initial deployment.
Developed the test scripts for UAT and the created the documents.
Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
Provided several presentations to the business on the MDM functionalities.
Support of the MDM and SSIS jobs and stablished the bases to migrate to Control M.
Automated the MDM execution using batch commands, PowerShell scripts and Windows Scheduler.
Provided several reports to the business explaining why the records were merged, when and make changes if needed.
Solve Priority 1 production issues as well as Priority 2.
Fix source data ETL and update MDM data.
Environment: Informatica MDM Multi-domain9.5, JBoss 5.1, Informatica Power center/Analyst 9.1, Oracle 11g, SQL Server, Linux, Address Doctor, Microsoft Project.
Zurich Financial Services, headquartered in Schaumburg, IL is the leading Insurance company. Zurich financial services using MDM for aggregating almost 8 million customers based on the claims. The main goal of the project was to identify Single customer master across the enterprise. The customer information is useful for faster decision making of approval process of lead and various decision makings across the organization.
Responsibilities:
Conducted meetings with business users to understand matching requirements
Analyzed and understood the Data to give more details to the technical team.
Build the business rules for supporting the Data Governance.
Creation of part of the Base objects, Staging tables and relationships.
Involved in the queries and package development.
Development of the MDM mapping and cleanse functions according to the data governance principles.
Work closely with the ETL data architect to populate landing tables in MDM.
Set up match/merge and run match rules to check the effectiveness of MDM process on data.
Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
Developed the test scripts for UAT and the created the documents.
Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to different environments.
Environment: Informatica MDM Multi-domain9.5, JBoss 5.1, Informatica Power center/Analyst 9.1, Oracle 11g, SQL Server, Linux, Address Doctor, Microsoft Project.
Hyatt Hotels Corporations, Chicago, IL June 2012 - July 2013
Data Analyst / Hub Developer
Responsibilities:
Gathered the requirements and translated it to the Technical team to build the data model.
Defined business rules for Match and Merge and Trust frame work.
Conducted scrum meetings to keep the business and technical team in sync to address the issues.
Suggested Data Model changes as per the data movement and business logic.
Configured and installed Informatica MDM Hub server, Cleanse Adaptor, Resource Kit, and AddressDoctor.
Define an ORS data source in the application server (Web Logic) environment for Informatica MDM Hub.
Performed Data profiling for the data from multiple source systems by using Data Quality Audit.
Defined the source systems in Systems and Trust model workbench.
Configured Base Objects, Staging Tables, Landing Tables and columns in the tables.
Defined the Foreign Key Relationship between Base Objects.
Defined Mapping data from Loading Tables to Staging Tables.
Designed and developed validation rules and match/merge rules and data cleansing using Informatica MDM Hub.
Standardized the data using cleanse functions.
Created Queries and Query Groups to be used by Packages, Data Manager and Merge Manager Tools.
Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, and Profiles using Hierarchies tool.
Defined Put / Update and Display Packages to be used in Hierarchy Manager.
Experienced in Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase.
Environment: Informatica Multi Domain MDM 9.5, Oracle 11g, SQL Developer, Jboss 5.1, Address Doctor 5.
UST Global, México, Guanajuato January 2011 - June 2012
Teradata/Informatica ETL Developer
As a member of the WellPoint project, my role was to develop Teradata scripts (BTEQ and MLOAD mostly) and Informatica mappings (Power center, workflow manager, workflow monitor) necessary for ETL - Extract, Transform and Load. I was in charge of the claims data which needed to be moved and cleaned (expressions, normalizer, filter, SCD Type 1, 2 and 3, etc.) from several source systems to the Teradata Enterprise Data Warehousing. Our team was involved in the Analysis phase where we design the data fllow according to datawarehouse tables which were developed by other team previously.
Responsibilities:
Work with another team in India for the complete Analysis phase on data flow.
Design the ETL process from the source systems (Oracle, SQL Server, flat files) to the Teradata data warehousing with several layers of Informatica Power center and Teradata.
Unit testing and stress testing of mappings and scripts.
Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter, Router etc.
Customize existing mappings as per end user requirements.
Used Informatica workflow Manager with Unix scripts to create, schedule, monitor and send the messages in case of process failures.
Designed and developed SQL, PL/SQL and UNIX shell scripts.
Improve the performance on the Teradata scripts “playing” with the AMP’s and using the EXPLAIN statement. In Informatica Power center we used reusable objects like the store procedure transformation and mapplets for saving development time.
Environment: Informatica Power center, Teradata, SQL Developer, Unix.
The role that I had was to be professinal services engineer of Citrix, HP and VMware. I had to architect and implement those technologies, providing knowledge transfer and support of the sales complete the sale of such technologies and techniques to solve customer queries. As a specialist, my job is to implement the latest technologies in conjunction with a team. Take several trainings and pass tests in order to become certified in the latest technologies. In addition to my work as an IT professional, I coordinated the activities of the professional services department, I manage shared calendars and manage both internal and external projects based on metrics obtained weekly.
Responsibilities:
Take several trainings and certifications in Citrix, Microsoft, HP and vmware to maintain the partner status of the company.
Implement these technologies on site.
Size the project (number of servers, licences).
Setup and initial configuration and license administration tool of XenApp and XenDesktop.
Install and configure Web Interface, create and customize Web Interface sites, and configure client delivery.
Publish applications, content, and desktops for users.
Add and configure worker groups, administrative accounts, and permissions, and log administrative changes.
Create and configure Citrix policies, applying filters and using policy modeling tools.
Configure printing for XenApp and XenDesktop.
Configure monitoring tools and technologies for XenApp and XenDesktop, as track license usage.
Basic setup and configuration of the Microsoft Active directory.
Initialization and configuration of the HP hardware (servers, storage).
Participate in the pre-sales process, provide to the customer high impact presentations of the different products. Analyze the enterprise customer requirements.
Use the appropriate tools to make recommendations for the optimal HP product or solution to solve customers' business needs.
Configure Proliant rack and tower server hardware components.
Setup and configure iLO components.
Create and customize storage arrays.
Manage shared calendars for the different activities of the professional services department.
My role was to provide technical support for Hewlett Packard computers through email; I provided support to laptops, desktops, printers, multifunctional, accessories, etc. I possess extensive experience in customer service. Through teamwork strategies, we managed to increase the ratings of quality and customer experience. In this company, I learned to be empathetic, to meet all customer needs by showing the advantages of our product compared to the competition, but mostly, providing the "plus" in each one of the interactions that I had not only in the company, but in personal life too.
Responsibilities:
Provide quality customer support in English and Spanish.
Update and document the solutions that were not found in the HP site.
Train and certify every six months in the tech support skills and the internal tools.
Provide the physical repair or exchange according to the situation and problem.
Solve and respond to a minimum number of interactions.
Skills
Systems Analyst – Ability to analyze a problem and break it down into parts. Knowledge of the traditional SDLC (Software Development Life Cycle) model. Functional Modeling (flowchart, diagram UML), data modeling (entity relationship diagrams, relational model).
Languages: Visual Basic, Mat lab, PHP, ASP.net, Java.
Databases: Teradata, MS SQL Server, Access.
Programmer - Application Development with small participation in projects using Visual Studio 2010, Visual Studio 6.0, Dreamweaver, JCreator.
High impact presentations - Through different techniques, presentations and demonstrations in IT, I awake the desire to learn and know more about the presented topic.
Education
Institute technologic de León, Computers Systems Engineering
Contact this candidate