Facilities Engineer Integration Manager

Rogelio Ivan Espinosa Flores

**/**/****

Mexican

Address: Hacienda el Arbolillo # 21

Telephone:

Mobile: +52-722-***-****

E-mail: ***********.********@*****.***

CURP: EIFR821024HMCSLG07

IMSS: 940********

Professional summary:

- Infrastructure Project management in the automotive industry at (GM, FCA-Chrysler and Magna International) deploying assembly & production lines and stations with Lean & Kanban with base on ERP Manufacturing and MES (Manufacturing Execution System) and Integration with AB & Siemens.

- Five years as Leader / Manager of business intelligence systems Banking, retail and Process Integration BPMN-TIBCO, DataStage, SQL SSIS, AB Initio suite & Info Outbound CRM Analytics international projects and three projects for the American Embassy in Mexico for the Merida initiative (Security Projects and Telco ).

Professional history:

Tata Consultancy Services (Jan 2021 - ) – SCE/ Southern California Edison (Power Energy USA)

Current position: DevOps & Cloud Operations Manager Architect

Reporting directly to: GDL Global Operations

Responsibilities:

Planning, Desing & Release Azure Infra over ARM Templates & Terraform with DevOps Pipelines

Respository & Versioning coding

Desing & Deploy Pipelines to integrate automate testing and CI/Delivery~Deployment

SRE Operations on Azure,

Migrate VMachines to Azure & Storage solutions

Planning & Migrate OnPremise Databases to Azure (SQL & CosmosDB)

Desing & Deploy continuous Monitoring & DSC Desired State Configuration.

Freelance – VW Outsourcing (Nov 2020 – Jan 2021) – Ministerio de Hacienda El Salvador

Current position: Solution Architect

Reporting directly to: Jaime Rubio

Responsibilities:

I was invited to planning, sizing, desing & deploy a complete PaaS platform to manage a large project to El Salvador Country in Ministerio de Hacienda (Simil IRS USA) whose objective is manages offer a Web Solution to create & manages all tax documentation for every person in their country, this solution is based on Docker Containers wrote with Phython, NodeJS and Angular as front & Data Store Aurora for MySQL on Replica & MongoDB Atlas on EC2 as main data base, including a large security stack for example CloudHSM, Hub, CloudTrail, Shield & Cognito everything over AWS offering SLAs 99.999, load balancing and eslasticity (vertical/horizontal) for this last I decide help me configuring AWS ELB (Elastic load balancer in Application balancing mode) to balance AWS ECS/ECS Registry Docker Cluster and AWS AutoScale to manage Elasticity on infrastructure required finally deploy Data Replica to ensuring data and availability, it is very important to mention that I don’t coding the solution these application was build last year over physical server and never release on Production environment until now, I offer to configure and deploy a pipeline DevOps with AWS CodeCommit/AWS CodeBuild & integrate with Jenkins because Jenkis is and has been their main technology basis.

Optimissa – VW Outsourcing (July 2019 – Nov2020) – Automotive & Finance

Current position: Solution Architecture Cloud

Reporting directly to: Ralf Shönekerl Manager for Digital Transformation

Responsibilities:

I was hired to collaborate in a AS-IT o To-BE analysis & Desing, sizing and Deploy of AWS Data Lake for Volkswagen about digital strategy as part of TO-BE delivery I have delivered Data Lake base architecture solution base on AWS & Azure considering next services of AWS:

S3 – Data Store to RAW Data, Data Transform & other S3 bucket for Exposition

S3 Glacier – Persistant Data

Data Lake Formation: Basis Data Lake

Glue & Informatica BDS for ELT & Data Streaming Legacy sources, NoSQL & Data Streams

Athena: To works and SQL Client to 3rd client

EMR: Big Data/Hadoop/Casandra as a service & Consume

RedShift: as a modern DWH

DynamoDB: As a ODS & Data Storge

Storage Gateway: NFS & SMB

EFS:

EBS:

Direct Connect: As a ODS & Data Storge

EC2 Instances: Linux RedHat & AWS Linux for Webservers

CI/CD CodeCommit, Pipeline, CodeBuild

CloudWatch

NAT Gateway

CloudFormation & Terraform

My team & me collaborate to migrate a redesign IPC ELT to new ELT platform Informatica data engineering integration or Informatica DEI over AWS Marketplace, including, ingestions, transformation, Data Quality and deploying data pillars and their dashboard for Data Governance with Informatica Axon, for landing zone to structured data and I decide configure AWS Storage Gateway using NFS & SMB Files & objects (objects as Json documents, XMLs and other structured information) protocols because many data sources resided on physical servers over Unix (NFS) and WindowsServer (SMB) outside of AWS VPC, so to integrate this servers we planning and deploy AWS Direct Connect to ensure a secure channel over the VPN. Later to store semi-structured & non structured data was configure and deploy AWS EBS (Elastic Block Store) to assing volumes to EC2 instances on AWS Linux to process similar to staging area including real time transactions & transactions, finally to Transform information was used Informatica DEI and store information in AWS S3 buckets for different purposes and exposes this information to other target with AWS Storage Gateway to satisfy different targets as virtual machines instances on ESXi (NFS & CIFS), Hadoop Cluster (S3 buckets) and Databases on AWS DynamoDB & Redshift.

Other project on VW with AWS Services was eCommerce Platform with B2C/B2B capabilities deploying a front end with AWS Cloudfront/CDN for static webpages, AWS Lambda functions & AWS Step Functions over nodeJS, AWS DyanomoDB/DAX to principal data store and RDS PostgreSQL to metadata and marketing proposal, AWS API Gateway to integration or orchestration functions, AWS WAF, CM, Shield to security and AWS SQS to integrate commercial associates and their systems finally SNS & CloudWath to monitoring.

Also I collaborate to release a DevOps & DataOps Governance (process & Tools) to stablish in VW Mexico new processes & policies to Data Governance & continuity release deploying tool box.

Projects with Actinver Banking: over Azure & GPC I considered to use next services:

PowerBI Pro – Licensing & publish over Azure to create dashboard, KPI/Metrics & simple reports

Oficce 365 – all community

QlikSense – Enable Developer & Reader licensing on Azure Market place for complex reports & MSI

Actinver Casa de Bolsa is a brokerage vertical and was migrated an OnPrem mobile solution to investment capital & risk values to final clients, this solution was created over Oracle/Jboss APP/Tibco and I participated to redesign the architecture to attend and API integration over RESTFull to communicate any transaction to other legacy and deploy a cache with GPC memorystore/redis to increase the performance, Apigee as the root of strategy & GPC Anthos to hybrid solution integration to communicate physical infra & legacy applications as corebanking. I participate deploying the new integration architecture for legacy application deploying new microservice engine over Apigee and reduce overload to TIBCO BW Data Flows.

Projects with Sabadell: Finally over Azure I considered to use next services:

Azure Data Factory & Azure DWH – To migration planning DWH OnPremise over Microsoft Technology to Azure including T-SQL scripting, SSIS ETL to Data Factory ELT, Data Stores, Data Models and Define and deploy Data Quality & Meta Data Store-

EISEI-OUTSOURCING BANORTE (April 2018 – July 2019) – Banking & Finance / Business Intelligence & Profibility

Current position: BI & Data integration Manager

Reporting directly to: Maria de la Luz Inclán / Profibility CTO

Responsibilities:

I was hired to collaborate in the deployment of architecture for self-service initiatives: this includes self-service data integration and ETL with the AB Initio tool such as AB Initio GDE, ExpressIT and BRE. I was participate actively to measure capacity planning, infrastructure planning, proof of concepts (POC) and finally deploying the final environment. I have an ETL Team composed of 3 people, a business analyst and two ETL developers who are running some projects, I also have another team consisting of only six developers in BI tools (Qlikview / Qliksense, WebFocus and Microsoft SSRS). I am in charge of open, execute and close each initiative and our projects are related to risk, collection, profitability and private banking.

Main achievements:

Deployment of self-service display and reporting platform (Qlikview / QlikSense, PowerBI and Pentaho)

Start-up of self-service platform for, exploitation, data integration, ETL, Metadata-HUB Database virtualization & ExpressIT/rule engine, continuous flow & co>Operating systems operations, users, licensing etc.

Other projects involved was related to migrate VMWare OnPrem platform to Cloud on Azure and redesigning load & capacity to each vm and deploying a VPC divided by specialized tasks, environments (Dev/QA/pre-prod/Prod), departments and type of users.

With Microsoft Azure was planned, designed & deployed an Analytic platform to traditional dashboards and reports over Power Platform and notebooks/workspaces with Azure Databricks to define an Hadoop Yarn cluster to BigData with block storage and blob providing a way to process couple of data files and data formats.

PRAXIS-FCA/CHRYSLER (January 2015 – March 2018) – Press Shop, Assembly & OEM Manufacturing

Last position: MES & ERP Infrastructure Leader (Manufacturing, Supply Chain & Warehouse)

Reporting directly to: CTO NAFTA Manufacturing systems

Responsibilities:

As Project Leader of Infrastructure and Implementation of Manufacturing ERP for the FCA Mexico and USA stamping plants I have been responsible for the control and administration of the SIEMENS MES SIMATIC project, initially I participated in the unification and standardization of the requirements of the users of the Stamping plants, requirements management and designation of tasks to the team of analysts of the TCoE (Team Center of Excellence) for their analysis and design, around the integration of additional legacy systems, I was responsible for giving monitoring control, approvals and release of said requirements; actively participating in the creation of corresponding test matrices and releases for manufacturing data marts.

About the infrastructure, I had participated in designing the hardware architecture solution including floor devices (Servers / Operating Systems, Controls, PLC, controls & others) networking (Switching, Routing, Security) and software (Application Servers and Data Base Servers) with The integration of the different layers of the MES Siemens, the project is Global and involves plants in Mexico (Toluca / Saltillo) and USA (Michigan and Texas).

I was responsible to NetApp storage to the MES Clusters Application, databases and fileshare offering alternatives to backup, redundancy & trunk or vault using services and protocols as: iSCSI, CIFS, NSF, NAS services, sfpt, SnapMirror raid to mirroring volumes to servers machines or NetApp SnapVault to planning, configure and data feeding associated to historical production,

Main achievements:

PRESS SHOP / STAMPING COMPLEX

• Infrastructure implementation for SIEMENS SIMATIC IT - MES solution per complex (Toluca, Saltillo, Warren, Sterling and Windsor)

• Integration of the MES with floor devices via AB RSLinx gateway

• Integration of robots and 3D vision systems kyence for Quality Assurance

• Construction of Data Mart Manufacturing based on ISA-95 pillars measuring at the end of each cycle or shift the KPIs: OEE, downtime, scrap, rework and maintenance.

MANUFACTURING & ASSEMBLY

Start-up of the Solidat (a German MES-Manufacturing Execution System), with points of Quality Assurance, traceability, messages and backflush to SAP for warehouse block at the end of the cycle, production planning, monitoring of critical stations, Andon display and productive dashboards (reports for online production ).

UST GLOBAL (August 2012 – August 2013) – Sr Consultor Banking, Retail & BI

Last position: Sr System Integrator

Reporting directly to: Guru Natarash

Responsibilities:

I was responsible for receiving the commercial requirements on development of systems and integrations in web platforms, supply chain and data storage, regarding commercial requirements. I was encharged of analyze each one, develop the use cases and document, model, plan the capacity, design capacities, help in the business process and provide the users with the project plan with the necessary human or material resources.

Main achievements:

Contract closure with the Panama Tourism Authority for the Paper-less program (automation of procurement bidding processes and recruitment process) under IBM BPM platforms and integration with legacy systems.

Acquisition of the contract with Walmart Mexico for maintenance of the supply chain system (RedPrairie) for Region LATAM

Alutiiq LLC (June 2011 – August 2012) – System Security Integrators / DOS-NAS US Mex Embassy

Last Position: Infrastructure leader

Reporting directly to: Otis Harty

Responsibilities:

Deploy RENADIC physical architecture project (videoconference, data, audio and national network 332 CITIES), defining the business case, creating the project plan, implementing the necessary site inspections, coordinating with the network providers, server providers and the facilities engineer. This project involved the design of a central network infrastructure for Telepresence, meeting place, VOiP telephone and central switch and MPLS network contract services covering the entire country of Mexico. The software side includes implementing high availability on Jboss and Postgree SQL application servers.

Main achievements:

Deployment of a national WAN network with the 4NEtworks and CISCO provider

Integration of INAMI systems to the Mexico and Interpol platform

Start-up of biometric system for recognition and exchange of information

Nasoft CitiLatam(March 2009 a may 2011) – Falcon Fraud Manager

Last Position: Technical Business & Integrator Analyst

Reporting directly to: Marcela Ruiz Barron – Citi Employee

Responsibilities:

Leading user meeting to define fraud prevention strategy and Business Logic to qualify credit & Debit cards.

Define business strategy to scoring transaction & collaborate with Brazilian Team FICO to define this strategies into Fraud Manager

Identify all legacy and source systems to create Data Flow with Tibco with Adapters as Java / JMS, Tuxedo, Mainframe OS, Oracle Adapter & Data file transfer over ConnectDirect (Intelar Citi)

Define Data mapping to source and targets Tibco flow and define squemas (XSD) and Contracts

Carry out testing phase with data preparation, data masking, define test scenarios and collaborate with final user in End-to-test testing.

Register, Open, follow and close test defect over development and FICO Falcon.

Tools:

Tibco BW 4.5, spotfire, adapters, Tibco EBX for master data management & File Transfer

Integration of INAMI systems to the Mexico and Interpol platform

Start-up of biometric system for recognition and exchange of information

Academic history

Bachelors Degree

-Universidad Interamerciana (System Engineer)

Courses:

Course or Certification

Institution

Period

CISCO CCNA

Universidad Interamericana

2002

Oracle tunning

Ked Educacion

2011

Infor CRM Analytic Manager

Infor

2010

AB Initio suite

CitiBanamex

2018

QlikSense

Banorte

2019

Languages:

Spanish: Native

English: Fluent

Contact this candidate