Financial Systems Architect / Technical Lead

• Nov 2019 - - Kini

Senior Applications Developer

• Jan 2017 - Okt 2019

• Guided the organization to establish better security standards on Database access.• Improve production support ticket numbers by decreasing 15% of the annual incoming tickets for Oracle EBS system issues by analyzing root causes and resolving recurrent issues.• Established patches installation procedures and best practices.• Served as Leader of the Change Management Working Group and helped stablish Change Management Policies in the Office ofTechnology department.• Active Member on of the Change Advisory Board for Change Management within OOT (IT).• Active member of the Office of Technology Communications Committee for a time period.• Proposed and established new hires procedures for the IT Staff new hires as an active member of the Technology Communication Committee for Office of Technology.• Deployed projects to meet state and federal requirements and file creation/interaction between our system and ERS/IRS systems.• Coached other developers in our team when they needed guidance on their work assignments.• Assisted with payroll audits (state) by performing data mining on information from prior year on the database and existing state files.• Enhanced and adjusted Fast Formulas for Payroll calculation.• Maintained and solved issues using Oracle Workflow Builder.• Resolved production support HRMS and Financial tickets either by helping users and guiding them through the application or by creating new reports or enhancements they can use on their daily work.• Enhanced and generated new Microsoft SQL Server Reports for the organization.• Implemented the Oracle Learning Management module for internal training tracking.

Senior Oracle Consultant

• Jan 2017 - Jan 2017

Project for Cadena Comercial Oxxo as client:• Analyzed, defined and documented a solution in Oracle R12 Inventory module to replace virtual inventories with On-Hand inventories in the system.• Created Technical Documents for the planning and configuration of the processes and modules using OUM documentation.• Designed reports outputs to keep track of the inventory changes after the solution has been implemented.• Oversaw a functional consultant and a documentator to work on the solution.• Delivered and Presented solution to client upper management and stakeholders.• Obtained the proper signatures for the other consultants to implement the solution.

Technical Lead

• Nov 2014 - Nov 2016

• Managed and lead a group of 12 resources including functional analysts, oracle developers, Microsoft SOAand Kofax/Markview administrators and consultants throughout the US, Panama, Colombia and Brazil• Designed a Disaster Recovery (DR) environment plan by meeting with Functional Lead, Managers, DBAs and other interconnected systems key administrators (Microsoft SOA, Markview, Kofax and Synchro) to create the directions for DR.• Designed technical test cases for DR environment testing.• Supervised and approved testing for the Disaster Recovery environment.• Reviewed, Analyzed and assigned level o effort and workload for the technical team.• Performed impact analysis on Oracle Patches, schedule patch testing in lower environments with Production Support team and key business users.• Scheduled and Coordinated Production system outages for Patch Applications, Software Upgrades and Maintenance by coordinating users, contractors and off-shore teams.• Created System Support and Administration Guides to manage Development, Testing, Staging and Production environments.• Developed and enhanced data integration between Oracle and Blackline, Hyperion and DRM systems.• Developed a Training Program Schedule for the team based on the business needs.• Developed and enhanced RICEF for Brazilian Localization.• Provided Technical and Functional Production Support in determining and resolving the day-to-day production issues for Oracle EBS and the following connected systems: Kofax, Markview, Synchro, Microsoft SOA, Blackline and Hyperion.• Resolved internal and external audit needs by being the point of contact to deliver Oracle information via creation of complex queries as per audit requirements.

Oracle Consultant

• Feb 2012 - Okt 2014

Project for Growmark Inc.• Performed Business Analyst Role working directly with internal customers developing a solid understanding of the business application in order to provide an appropriate IT solution for their needs as part of the Production Support team.• Developed new transactions for the business by creating new forms using Oracle Forms 10g• Provided maintenance and improvements for transactions inside custom made ERP software• Enhanced and tuning of several PL/SQL transactions in an Oracle Database 11g• Created operational reports using Oracle Reports 10g for diverse areas of the company• Developed Customer-Bank EDI Process extracting financial data by using PL/SQL and Unix shell scripting to manage the flat files with NACHA standard.• Created solutions for new requirements using Oracle tools and going through every step of the SDLC including Planning, Analysis, Design and Implementation of new solutions.• Provided feedback and technical advice to the Business Analysts and Business Users on requirements.• Researched and support for migration from Oracle Applications Server to a WebLogic Server.• Prepared and delivered database information to be used in SAP Business Objects.• Performed unit, integration, system test procedures as well as user acceptance testing for programs written.• Documented final program and develop user instructions, software requirements, program input / outputs and execution / installation steps for the solutions created.

Oracle Consultant

• Okt 2005 - Feb 2012

Project for Cadena Comercial Oxxo• Implemented Oracle EBS 11i Supply Chain Management (SCM) modules for Stores maintenance countrywide.• Implemented Oracle Enterprise Asset Management module for Gas Station and Motor Vehicles preventive and corrective maintenance.• Created test documents for Upgrade from 11i to R12• Served as SME for the Oracle Upgrade from 11i to R12• Trained key users and stakeholders countrywide by serving as an Oracle Instructor for SCM modules best uses and practices within the organization.• Served as the SME for the Oracle EAM module production support issues and enhancements.• Reviewed and Developed new RICEF as per business needs following Oracle best developing standards on Oracle Forms, Reports, XML and PL/SQL for Oracle EBS 11i and R12.• Oversaw java developers for a Mobile Java/Oracle EAM interfaces project.• Implemented BI solution using Oracle Warehouse Builder (OWB 9) for ETL• Created and Maintained a Data Warehouse and Data Mart up to date based on new business requirements• Created Microstrategy Object like cubes, KPI's, Metrix, Attributes, Prompts and Filters• Developed Microstrategy 9 Reports for BI project• Developed Unix and Linux Scripts• Development and Tuning of PL/SQL programs using Oracle Database 10g• Developed reports for SCM and Financial modules (EAM, OM, PO, INV, BOM, WIP, AP, GL) using Oracle Reports 6i/9i• Developed a VB macro and tuning of a PL/SQL Data load interface program for loading asset information for 10k+ stores (1.2 million assets in Oracle EAM)• Created end user manuals for client internal use.

Oracle Consultant

• Okt 2005 - Feb 2012

Project for Metalsa• Designed a BI solution by creating the proper documentation for High Level approach.• Created the technical documentation of the BI project extracting data from Oracle, Hyperion and Progress Databases.• Developed PL/SQL database objects for the BI solution.• Developed mappings from source to destination DataMart by using Oracle Warehouse Builder 10• Developed PL/SQL using ETL to fulfill the client requirements.Project for Daltile• Developed Inventory and Purchase Order related reports using Oracle Reports 10.Project for Garza Ponce Vivienda• Developed Multiple Reports for different areas using EAM, PO, INV and BOM modules and Oracle Reports 9.Project for Casas Javer• Developed Customer-Bank EDI Process extracting AP module data by using PL/SQL and UNIX shell scripting to manage the flat files.Project for Atari - Grupo GNC• Developed Customer-Bank EDI Process extracting AP module data by using PL/SQL and Unix shell scripting to manage the flat files.Project for Biciclo• Develop PL/SQL financial programs and reports using PL/SQL and Oracle Reports 6.

System Manager

• Ogos 2000 - Sep 2004

• Lead the E-commerce creation project using SQL, classic ASP and HTML.• Provided Technical Support and in charge of the preventive maintenance role for the hardware (Help Desk, Field Service).• Assisted Finance department with the creation of specialized spreadsheets using Microsoft Excel. • Lead the E-commerce creation project using SQL, classic ASP and HTML.• Provided Technical Support and in charge of the preventive maintenance role for the hardware (Help Desk, Field Service).• Assisted Finance department with the creation of specialized spreadsheets using Microsoft Excel.