Information Management and Analytics Solution Architectwith BI/ETL Performance Infrastructure background at one of the largest mortgage agencies in USA: The Federal National Mortgage Association (FNMA) it’s a US Government-sponsored enterprises founded since 1938. FNMA publicly traded since 1968. ETL Architect Performance Architect onsite role for new strategic business partnership and technical implementation at FNME. Propose a strategy developing and implementing and new innovative automated tool to capture performance metrics that meet required business non-functional and high availability infrastructure requirements needs. Preparation with planning and LOE estimations. Identify value drivers fitting with client and opportunity situation, develop a proposition plan mapping value drivers/targeted units/ phasing/resources  Identify the right profiles for the strategic team (Web-services Performance Engineers, ETL Testers) and demonstrate leadership. Address complex issues involving interactions up to executive level. Develop proposition both written and presented at orals Provide hands-on problem-solving assistance with multi-functional project teams and clients.

BI and Analytics Solution Architect. Information Management and Analytics.Big Data Market Basket and Price Elasticity analysis for hybrid On-Prem-Cloud platform for business analytics projects and implementations, and business solutions for the Commercial Fast Food and Supply Chain functional and services areas. Data Engineering Services and Data Mining for data driven implementation.ETL Performance Architect responsible for implementing process and mechanisms to automate the highly complex Enterprise Data Integration platform performance metrics gathering, and corresponding performance analysis.Data Analysis and Data Cleaning on IOT sensor data.Data Quality on data points required on data mining and modeling for data science and analytics modeling algorithms.ETL Code and Data migration and implementation DWH hybrid (on premises and cloud services).♦ Freeport McMoRan Inc, Phoenix, AZ. Oct 2019 – Current. Data Engineering Services / Copper & Gold Mining. Data Mining♦ Advance America, Spartanburg, SC . June 2019 – Sept 2019. BI&BA Solutions Architect / Micro-Lending Banking and Financial System♦ Freddie Mac, McLean, VA. Mar 2018 – May 2019. BI&BA Solutions Architect / Mortgage Market, Loans and Securitization, Financial system. Services Delivery Management ♦ Oxxo FEMSA, Mexico. Mar 2016 – January 2018 . BI&BA Solutions Architect on Retail Store Industry. BI Big Data Solutions Architect ♦ Fannie Mae, Reston, VA. Jul 2014 – Oct 2015. BI&BA Solutions Architect for Federal National Mortgage Market. Project Delivery Manager.♦ Banamex – Citi Group, Mexico, USA. Oct 2013 – Jul 2014. Service Project Delivery Manager Banking and Financial System. Client Onsite Project Coordinator♦ Gov. Health System , Mexico. June 2013 – Sept 2013. BI and Big Data Analyst Consultant for Healthcare system. Business Information Management.

Description:Responsible for the proposal of bids to existing and prospective clients in Financial Services, Banking and Insurance areas. Bid for a project within the correct time estimations, resourcing and proper financial parameters. Proven leadership skills to manage bids successfully.. Achievements:  Business Information Management overall assessment for the LatAm region for the 3rd global financial institution worldwide. Data warehousing and dynamic information integration contribution for LatAm region for the 3rd global financial institution worldwide. Application Management Outsourcing Service Framework Implementation collaboration for a large Global Insurance Company. Architecture analysis and technical proposal for cross-business banking and accounting reconciliation automation process for 3rd largest bank in Mexico.Roles and Responsibilities: Analyze, recommend and implement Business Information Management solutions (KPIs, metrics, processes and methodologies) that meet financial services business needs, functional and high-level technical requirements as subject matter expert. Propose the strategy and document preparation with planning and budgeting (project cost estimating & tracking) for customer new BI and analytics implementations. Provide hands-on problem-solving assistance with BI solutions, data integration and data quality tools to internal and external team leads, project managers and developers. Determine best approach, tools, and techniques to best meet business requirements. Coordinate both offshore and nearshore efforts along with onshore initiatives and teamsPart of the BI EDW/CRM core team I was leading the Solution Architecture team getting over the responsibilities to manage an ALM of Legacy BI Systems project.

♦ ETL Architect SME providing Data Warehousing overall direction and guidance, driving the BI Data Governance and metadata management content, enforcing data quality for integrity and quality standards through process and governance to the different Data Warehouse Project teams♦ Data Flow Design - Develop Data Flow diagrams and Source-to-Target mapping. Enforce the correct techniques for data mapping and data model design.♦ Serve as a primary thought leader on the data integration tool (Informatica) and its capabilities.♦ Hands-on problem-solving supervisor with data integration and data profiling tools to team leads, project managers and developers.♦ Analyze and recommending solutions to meet business, functional and high-level technical requirements as subject matter expert.♦ Determine programming approach, tools, and techniques to best meet business requirements.♦ Benchmarking technologies, conducting POCs for BI solutions ♦ Technical and architecture reviews and guidanceEnvironment: Energy Services, Information Management, Data Architecture and Data Warehousing, IBM DataStage Server 9.1.2, Informatica PowerCenter 8.x, 9.x, CDC PowerExchange, Metadata Manager, Cognos, MS Visio, MS Project, UNIX Solaris, Linux, HP QC, TOGAF Framework, Enterprise Architect (EA), Control-M, Autosys, Unix OS, Linux RHEL, PostgreSQL, Oracle, SQL Server, MS Visio, UNIX shell-scripting, Visio, BMC Remedy, MS Project, Software Development Lifecycle Cycle (SDLC), Six Sigma(6s), Lean Software and Teams, SDLC, TSLC, ITIL, RU

♦ Banking and Financial Services, Informatica PowerCenter 8.6.1, Informatica Metadata, HP Quality Center 10, BMC Remedy, Citrix, Teradata, Oracle ♦ Nearshore Data Movement ETL Operations Manager supporting production 120+ ETL different applications from one of the 500 Fortune Bank Organization. ♦ ETL Architect SME providing direction and guidance to the different Data Warehouse Project teams ♦ Supervisor: CMMi, ISO 9001:2008 and ISO 27001 Certifications in just 1 year for Infosys LATAM organization.♦ ETL Midrange Platform CAB member.♦ Technical and architecture reviews for BofA Change Management / Advisory Board ♦ POC Support Engineer of 3-Tier Business Class clustered Unix Platform.♦ Nearshore Data Movement ETL Operations Manager ♦ Migration Support Manager ♦ Coordinator for Migration Support Staff and Operations teams for around 1000+ end-users between developers and businesspeople. ♦ Merged +20 ETL Applications from a second largest Financial Consulting Services US Corporation; coordinating activities for Migration Support and Operations Staff teams for around 1000+ people between developers and business end-users. Migration Support Manager and Support Engineer SME of 20+ Clustered UNIX servers used for PowerCenter Platform.Environment: Informatica PowerCenter 8.x, 9.x, CDC PowerExchange, Metadata Manager, Cognos, MS Visio, MS Project, UNIX Solaris, Linux, HP QC

♦ Senior Support Engineering SME♦ Design, development, construction, Maintenance, Integration and administration of the different systems that the IT area requires for internal company operation♦ Senior consultant for Global Service Center (CEMEX GSC), supporting to the third largest cement company worldwide.♦ Technical support engineer and UNIX system administrator supporting e-Procurement High Availability UNIX application servers and ETL platforms, for continuous infrastructure improvements.♦ UNIX System Administrator and Platform Support Engineer.♦ ETL mapping integration design and support and migration for new PeopleSoft Oracle database versions♦ Outsourcing & Management Jobs and Scheduling Apps, stored procedures and triggers coordinator♦ ETL mapping integration design and support coordinator, JDEdwards to SAP and Legacy systems to SAP for 2rd largest Cement company world wide♦ UNIX shell advanced programming and PowerCenter training to various development teams.♦ Define functional specifications, etl integration development coordinator ♦ Support Engineer for Spend Analysis, Logistics, Productive Table, Inventory and E-Procurement Business Intelligence ♦ Development, and continuous improvement infrastructure for e-Procurement application servers on Solaris Platforms and Arrays 1-0. UNIX System Ariba Buyer Applications Specialist Administrator♦ SME and Support Engineer for Ariba Buyer y JDE World Software 7.3 in Procurement ♦ Ariba Buyer catalog manager ♦ Application management and tuning system responsible♦ Support engineer e-Procurement area World Wide♦ ITIL Move to Operation (M2O) process responsible for release management, processes and document management, and production implementation.Environment: e-Procurement and Business processes for Cement & Transformation Industries, Support and Maintenance, ARIBA BUYER 7.5, REQUISITE/CMMC 3.8.7.3 INFORMATICA, Unix AIX, Quality Center, PeopleSoft, and SAP