SUMMARY:

• 25 years IT experience with successful hands - on, technical leadership, infrastructure administration and project management for most important organizations in Mexico, USA and Latin America mainly on banking, financial, insurance, retailers, government and TELCO sectors.
• Highly talented Technical Leader, Data Architect and Technical Support Levels 2-3 on Master Data Management, Data Warehouse and Data Base Administration with robust and proven knowledge on Infrastructure, Storage Management, Security, Automation, Monitoring, Troubleshooting, Capacity Planning, Performance Tuning, High Availability and Replication on diverse technologies.
• Expert on large database platforms for Legacy, CRM, ERP, BPM, Content Management and BI Systems, proven project management capabilities in enterprise companies, strong requirements and business analysis skills, initiative, leadership, excellent verbal and written communications, cool under pressure, ability to interact with a wide range of different corporate personnel. Perception from the highest business objectives down to fine technical details, the ability to lead complex projects through to completion, confidence on drive to go all out to implement the correct solutions.
• Thorough knowledge o Toof all aspects of Data Management getting through: Assessment, Arquitecture, Capacity Planning, Advisory, Data Modeling, Development, Testing, Quality Assurance, Implementation and delivery of services on critical production environments.
• Excellent balance of technical and management skills, with proven ability to lead complex, globally distributed teams and deliver projects on time and on budget always oriented toward rapid results
• Has been a key player in projects of Systems Platform Conversion, Re-Hosting and Downzisings, Data Center re-location, coordinating the activities inside project team and involved areas of the organization.
• Development of proposed solutions and projects to Senior IT management, getting approval and delivery; leading/interacting with multiple managers, service providers and technical staff.
• Management of projects for various departments in the company, IT and Data Center; since Assessment up to Delivery in Data Management over Oracle, DB2, SAP, Java & Mainframe Z/OS.
• Responsible of assessment, advisory, planning and implementation of topmost IT solutions.
• Provide guidance to client and contractor personnel in support of a project.
• Provide overall leadership and direction to Contractor Project Teams for solution delivery of Business Intelligence and Data Warehousing over Oracle, SAP, Java and DB2.
• Development, delivery, maintenance, monitoring and troubleshooting for every component and platform related with systems and service on EDW; hands on, leading and skill transfer to teams.
• Interact and manage multiple project managers, each responsible for an element of the project and their own project team.
• Define and document the objectives for the project, business requirements analysis and determining of project scope; determine budgetary requirements; the composition, roles and responsibilities, and terms of reference for the project team.
• Develop and maintain project plans, including Work Breakdown Structures, timelines, resource plans, training plans and any other project related plans.
• Provide and/or oversee deliverable quality assurance, prior to delivery to the client.
• Ensure project close-out and wrap-up activities are performed and documented according to generally acceptable project Standards.
• Implementation of latest standards and (Kimball) methodologies in the area of BI. Building of models based on 8Tb of data and more.
• Design of new system and development using ETL tools, EIM tools, scripting, complex SQL and PL\\SQL scripts, stored procedures, functions and utilities.
• Provide expert advice and recommendations to support effective Departmental decision making.

TECHNICAL SKILLS:

Data Management: Hands On, Technical Leader and Data Arquitect: DB2, Informatica PC, Data Stage, SAP DS, SAP BW, SAP BO, Oracle: ASM, RMAN, RAC, Data Guard, Streams, Golden Gate, OEM, EBS, DW, Exadata.

Data Base Expert: Hands On and Technical Support: Capacity Planning, Logical and Physical Design, Application Programming, Backup and Recovery, Data Partitioning, Compression, Data Quality, Data Governance, Data In-Memory, Data Replication, Monitoring, Troubleshooting, Performance Tuning, High Availability, Replication and Automation: Oracle OEM, DB2 Tools.

Infrastructure and Middleware: Hands On and Technical Support: Solaris, AIX, Linux, z/OS, Websphere Application Server, Weblogic, Tomcat, Apache, SAP AS, CICS, Tuxedo.

Application Development: Hands On and Programming: C, C++, C#, COBOL, ABAP, Java, SQL, PL/SQL and UNIX scripting.

PROFESSIONAL EXPERIENCE:

Oracle Technical Support

Confidential

Responsibilities:

• Data base administration and technical support for +600 Oracle databases over VMs from version 9, 10, 11 and 12c.
• Participation with innovations at Oracle Administration, Monitoring, Performance Tuning and Automation in order to improve productivity of database global team (On Site, On-shore, Offshore).
• Enhancement of several standards on arquitecture, data modeling, design, security, development, implementation and delivery for new applications.
• Enhancement of standards for backup and recovery, high availability and data replication of new applications: Oracle RAC, Data Guard, Streams, Golden Gate.
• Development of automation tools for monitoring, tuning and replication between several systems that proactively alerts before infrastructure/services downtime: Command Line, OEM, AWR, ADDM, SQLT, Streams.
• Development of diagnosis/troubleshooting tools for enforce accomplishment of SLAs and to be in compliance with security standards to reduce impact for client. Use of information from OEM, Embarcadero, Toad, Oracle Operational Views, RMAN.
• Delivery and replication of databases between its different landscapes: Development, QA and Production environments using RMAN and Data Pump.
• Migration of 10 critical databases from Oracle 11g to Oracle 12c
• Responsible in charge of Performance and tuning critical INCs up to find the solution. Designing a program to combine AWR, ADDM, SQLT and Explain reports in one chart in order to analyze quickly the information and send recommendations to Development Team.
• Responsible of lead bridges and explain to Top Management and Technical teams the diagnosis and troubleshooting of critical INCs.
• Working closely with Exadata, Virtualization and storage teams for troubleshooting Oracle infrastructure and application issues.
• Responsible of checking and troubleshooting Oracle services after Exadata Patching in databases over RAC, Data Guard and different environments.
• Responsible of analyze and recommend changes in parameters, sizes, structure and SQL for critical oracle databases: Stale parameters, database excessive growing, partitioning, Top SQL consumers, and Top I/O consumers.
• Implementation of policies for Recovery: TSM Backup, Flashback, database/tablespace level and restoring/recovering using RMAN.
• Developing of automation tool that combines information of Data Dictionary in order to retrieve tablespaces, tables, indexes and other Oracle objects information in a handy report to visualize easy the structure and operation of objects.
• Developing of automation tool for search alert logs information with important messages to DBA Team.
• Coordination of movements and decommissioning of databases in virtual servers.
• Coordination with client DBAs for implementation of new functionality and upgrades over Oracle databases.
• Reduction of processing time, costs and resource utilization for Oracle core application processes OLTP /Batch on 30-50%.

DW Architect and Data Base Team Technical Leader

Confidential

Responsibilities:

• Assessment, planning, leadership, implementation, delivery and maintenance of Legacy and DataWarehouse/BI systems: Oracle EBS/DB2/Java/SAP,Solaris & AIX.
• Participation with innovations inside a Service Transformation Project developed for Outsourcing Services; offered with two major clients in Mexico (Insurance and Banking): Governance, Technical and Management areas.
• Establishment of standards on arquitecture, data modeling, design, security, development, implementation and delivery for new applications.
• Establishment of standards for backup and recovery, high availability and data replication of new applications: Oracle RAC, DB2 HADR/Purescale, IIRS, QRep.
• Development of automation tools for monitoring, tuning and replication between several systems that proactively alerts before infrastructure and services downtime.
• Development of diagnosis/troubleshooting tools for enforce accomplishment of SLAs and to be in compliance with security standards to reduce impact for clients.
• Delivery and replication of systems between its different landscapes: Development, QA and Production environments using Change Management Tools.
• Enforcement of Testing and Quality Assurance procedures and methodologies.
• Project Management and Technical Leadership for backup and recovery strategy.
• Project Management and Technical Leadership on automation project for monitoring and performance tuning of Oracle-Weblogic and DB2-WAS and SAP applications.
• Migration of more than 30% of core banking applications to a new platform.
• Responsible in charge of Performance and tuning team for RDBMS technologies.
• Reduction of processing time, costs and resource utilization for key SAP Oracle/DB2 applications: Batch processing 20-40%, OLTP /OLAP on 5-20%.

Project Manager, Sr. Technical Leader, Data Architect, DBA

Confidential

Responsibilities:

• Planning, Leadership, Implementation, Delivery and technical support of SAP Netweaver/BW, SAP Bussiness Objects Applications, Oracle Applications.
• Oracle Data Warehouse System and Reporting Automation and Health Checking
• Oracle/DB2 applications integration several platforms: Weblogic, WAS, AIX, Solaris.
• Content Manager on Demand report migration from DB2 z/OS to DB2 AIX.
• Implementation of Z/OS Cryptography and High Availability for XFB on z/OS
• Implementation of XFB (Institutional Applicative File Transfer SW)
• Development of Z/OS, Oracle and DB2 Academy Project
• Assessment, design, delivery, implementation and maintenance of Data Warehouse / BI and Legacy systems with SAP over Oracle and DB2.
• Establishment of standards on arquitecture, design, security, developing, implementation and delivery for new applications.
• Establishment of standards for backup and recovery ad DRP of new applications.
• Development of automation tools for monitoring, tuning and replication between several systems that proactively alerts before infrastructure and services downtime.
• Oracle, DB2 and Informix. Reduction of processing time, costs and resource utilization for key applications: Batch processing 20-60%, OLTP /OLAP up to 50%.
• Development, QA, Pre and Production environments using Change Management Tools.

Senior Technical Leader

Confidential

Responsibilities:

• Planning, Leadership, Implementation, Delivery and Technical support of Oracle and DB2 Applications.
• Oracle and DB2 application conversion for Banking and Retailer applications.
• Conversion of 3 core banking applications from Oracle and VSAM to DB2.
• Implementation of SOA on z/OS for 3 new banking applications.
• ZOS implementation over 2 Parallel Sysplex: Activities for implementing, customizing, monitoring and cloning ZOS images on 12 LPARS: LPARs weight, capping, memory and logical/physical dedicated/shared CPU assignments. Workload distribution, CF structures sizing, SFM, ARM, MAS, WLM configuration, IRD, VSAM RLS, ZOS libraries, parameters and procedures customization.
• Implementation of DRP Plan for Oracle Applications using Oracle RMAN, Oracle RAC.
• Oracle and DB2 SW evaluation in order to accelerate time of conversions
• DB2 Applications Health Check: Collaborating in analysis and recommendations with Confidential DB2 Labs (Silicon Valley) specialist for DB2 applications tuning.

Sr. Technical Leader, DBA

Confidential

Responsibilities:

• Conversion of 4 major applications in Costa Rica Government from Oracle to DB2.
• Conversion in Mexico Government from 2 major applications and consolidation of Data warehouse with +10 different data sources.
• Downsizing all applications from Mainframe z/OS to DB2 on Solaris.
• Technical Support levels 1-2 for Oracle, DB2, Informix, z/OS, Solaris, AIX, Linux Weblogic, Websphere, Tuxedo, MQseries, CICS, SAP, Siebel, Content Manager and Peoplesoft infrastructure and applications.
• Capacity Planning: AIX. Linux, Oracle, Oracle Applications, DB2 and WAS
• VLDB, Data modeling, Data Base Logical and Physical Design, ALM: Erwin, Rational.
• Backup & Recovery, DRP: AIX, Linux, DB2 &TSM, Oracle RMAN.
• Advisory, Technical Support, Diagnosis and Troubleshooting, Skill Transfer.
• Confidential, Oracle and vendors SW upgrade.
• Storage Management, Partitioning & Compression.
• Security Management and Audit: RACF, Top Secret, LDAP, TCPIP & Crypto
• High Availability: DB2 ZOS Data Sharing, DB2 LUW HADR/PureScale, Oracle RAC.
• Data Replication and DRP: CDC, SQL Replication, Q-Replication, InfoSphere RS.
• HW, Operating System and DB upgrade: z/OS SMP/E, AIX, DB2, Oracle
• Application & Transaction Server troubleshooting: WAS, SAP, CICS, and Tuxedo.
• Automation: REXX, COBOL, ISPF, C, C++, shell scripting, SQL, PL/SQL.
• Health Checking/Performance Tuning for databases/applications: Improving CPU & I/O utilization +30%, reducing elapsed times of top ten SQL consumers +%50. Advisory/Tuning: LPAR, O.S. /DB, CPU, I/O, SQL, Indexing, Utilities, Autonomics.
• AIX, Solaris and Linux robust knowledge System Administration: SW Installation, Configuration, Storage Management (LVM, FS), NFS, Security Management, Networking, WEB, shell scripting, C programming. Diagnosis and troubleshooting.
• Data Center re-location, DRP site re-location with Downsizing ( Confidential Mainframe to SUN/HP, Application Conversion and Re-Hosting: Oracle, Informix and DB2 several platforms).

Change Management and Technical Support Manager

Confidential

Responsibilities:

• Responsible of Change Control Area for all IT Area.
• Reporting directly and closely interaction with all IT Senior Management Staff
• Responsible of authorization and tracking of all major changes.
• Responsible with a very talented team of success movement in less than one day of all Data Center from Palo Alto Mexico to Tlalpan Mexico
• Homologation from applications of Bancrecen Costs Rica to Confidential Mexico
• Responsible of development technical and administrative plans for improvement of methodologies and techniques.
• Responsible of contracts of SW for change Management like CA and BMC.
• Development of standards, procedures and documentation of all activities of the area.
• Skill Transfer in all technologies for people in charge
• HW / SW new implementation and major changes
• 16 peoples in charge with 4 ships

Operations and Data Center Manager / Technical Leader

Confidential

Responsibilities:

• Responsible of Data Center and all processing for the organization.
• Downsizing of all applications from Mainframe z/OS to Oracle over Solaris.
• Reporting directly and closely interaction with all IT Senior Management Staff
• Responsible of leadership and tracking of all Data Center and Tape/Printing areas.
• Responsible with a very talented team of success downsizing from Confidential Mainframe to HP HW/SW infrastructure and applications
• Responsible of development technical and administrative plans for improvement of methodologies and techniques.
• Responsible/Technical Leadership on assessment and contracts of HW/ SW for all organization providers like Confidential, BMC, Oracle, and CA and so on.
• Development of standards, procedures and documentation of all activities of the area.
• Skill Transfer in all technologies for people in charge
• HW / SW new implementation and major changes