Jose Carlos Rojas Albornoz

Jose Carlos Rojas Albornoz Cell Phone number - email:-/-José Carlos Rojas Albornoz https://www.linkedin.com/in/carlos-rojas-albornoz-2381bb16 Summary • 15+ years of experience as a Oracle technology consultant, with extensive technical and functional experience in the architecture of Hyperion HFM, EPM HYPERION - FCCS, EPBCS, ARCS, EDM, Hyperion Planning, Oracle EBS, Oracle Cloud HCM, Oracle EPM, ODI (Oracle Data Integrator), SOA (Service Oriented Architecture), OBIEE (Oracle Business Intelligence Enterprise Edition) and Oracle Essbase for the management and exploitation of information. • 10 years of experience with Oracle Forms, Reports and PLSQL development aligned to agile methodology, building new forms, applying customizations and creating or modifying Reports and with XML Publisher to Designing new applications with Forms, Reports like tech based solutions for different customers and markets • Expert in complex and extensive developments, installations and complete migrations, Integrations with Oracle EBS through SOA and ODI with legacy systems or in Cloud environments. ODI & Dell Boomi management as an ETL tool for WareHouse • Extensive experience as Oracle Architect 11g, 12c, Windows, Unix and Linux. Experience working with Oracle EBS Functional modules like GL, AR, AP, PO, OM & IExpenses with technical customizations, reports and development. • 15+ years of experience in with PLSQL development, designing solutions for Oracle EBS and custom applications with diffentent goals, building ETL with PLSQL or managing information between Oracle and 3rd party applications • 12 years of experience in KSH, PERL , Analytical and debugging skills • 5 years of experience in Agile, Quality Assurance and User Acceptance Testing • 4 years of experience in GIT • Java Technical Lead for Java J2EE Projects for Government dependencies and private companies. Basically implementation projects to build and fix operational applications. • I have the ability to design, develop and implement solutions to automate the operation and management of applications using information and communication technologies so that the services provided to the company are compliant with the ITIL and COBIT standards. • IT professional certified with ITILv3 best practices and with a strong experience with the analysis requirement with the customer and aligned to ITIL processes. • 12 years of experience in Source Control and Shell scripting • 4 years of experience in Automation and Monitoring tools in the cloud - database environments • I have experience with devops with multiple teams around the world giving support for the same development Education • Autonomous University of Yucatán, Mérida, Yucatán, Bachelor of Computer Science,- Certifications • ITILv3 Foundations Licencia- Mérida, Yucatán, 2010 • ITILv3 (Operational Support & Analysis Certification) Mérida, Yucatán, 2012 • Project Management, Mérida, Yucatán, 2013 • Scrum Certified Course name: • Oracle 8i DBA Certification Diploma. National Computing and Credentialing Center. Federal Electoral Institute 2000. • Diploma in Microcontroller Programming. Faculty of Mathematics 2004 UADY. • Oracle ADF Technologies Training Diploma. Oracle Monterrey Offices 2007. • Participation Diploma II ITIL FORUM 2009 Service Management. TecMilenio University Las Torres Campus Monterrey, Nuevo León. • SOA Suite 11g Course Diploma from Oracle Partner Condor Consulting. Merida Yucatan • ITILv3 Foundations Certification Mérida, Yucatán. Registration Number:- • ITILv3 OSA Certification Mérida, Yucatán. • Oracle Hyperion HFM • Oracle EBS Sysadmin • Oracle Hyperion Reports • Hyperion WebAnalysis. Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • Hyperion Essbase Sysadmin. Proof of teaching module II and III of the Diploma “ITILv3 Information Technology Management Models” at the Faculty of Mathematics of the UADY Technical Knowledge: • Main Profile:Oracle ODI, Oracle Database, OBIEE, Hyperion Planning, HFM, Essbase • Secundary profile:SOA, EBS. Python, Jython, PHP, Java J2EE Developer • Operating Systems:Ms-Dos 3.1 al 6.2, Windows 95, 98, XP,7, 8, 10, 2000,2003 Server, 2008 • Server, Windows 2012 Server, Unix IBM – IAX, UNIX - SUN SOLARIS, LINUX – UBUNTU / Redhat. • Programming Languages: Web: Html, JSP, PHP, XML, Perl, Dreamweaver 6.0, 8.0, Java, Java J2EE, Eclipse, Netbeans, Oracle ADF, Oracle OAF. • Cliente servidor: Ensamblador, Clipper 87, Dbase, Pascal, Turbo C, ProC, Basic. Visual Basic 4, Visual Basic 5, Visual Basic 6, Visual Basic 7, Visual .Net, Java Applet. • Additional Languages: Oracle PL/SQL, RuleScripts & Scripts de Hyperion Essbase, Shell Script, C,C++,Visual C++, PHP, Python. • Databases:ORACLE, SQLServer, Informix, Postgresql, Firebird, MySQL. • Others: Office software: Office 95, 97, 2000, Xp, 2003, 2007, 2010, 2013, 365 (Word, Excel, Power Point, Access, Outlook, Project, InfoPath, Publisher, Visio). Professional experience Afore Banamex, México, Distrito Federal April 2022- February 2024 Oracle DBA • DBA modeling and scripting for datawarehouse in Tableu, Posibles Duplicados, • DBA Management for PLATA database. • Incident solution for different PLATA issues in PROD • Experience working with Service Now and Bitbucket in order to follow up incidents. • Prepares system documentations related to data model, database/table/view, and application use cases. • Produces migration scripts to be used during staging or production deployment. • Supports application development teams in designing physical database, creating database objects in development, developing stored procedures, packages, data copy or refresh procedures. • Daily meetings to follow up on pending Oracle DBA development tasks. • Experience with agile teams agile teams in order to develop new applications • Management for Service Now tickets in order to solve incident and requests from customers. • Design, develop and implement solutions using Oracle Packages with AbInitio • Tools:Oracle Database 12c, SQL Developer, Tableu, AbInitio Qualtop April 2020 – March 2022 Oracle Developer • Technical leadership in the development given to the Seguros Monterrey applications in Oracle Forms, PLSQL & Oracle Database 12c. • Implementation with BPM in order to solve client requests related with the workflow approval between different Oracle ERP versions and environments. • Support and Maintenance to the application developed by Qualtop for Seguros Monterrey aligned to Standard Procedures from Seguros Monterrey. • Daily support meetings in order to analyze and assign the enhancements for the Seguros Monterrey application. • Experience giving support to EPM in OnPremise and Cloud environments. • Building new reports in Financial Reporting Studio. • Prepares system documentations related to data model, database/table/view, and application use cases. • Produces migration scripts to be used during staging or production deployment, coordinates database implementation and/or deployment with production DBA. • Supports application development teams in designing physical database, creating database objects in development, developing stored procedures, packages, data copy or refresh procedures. • Experience implementing MDM (Master Data Management) with deep understanding for MDM concepts and creating plans for different teams, ledership for teams with agile methodology. • Experience working with ETL, AWS and MDM for different implementation and support projects. • Experience with agile teams in order to develop new applications. Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • Oracle Developments and customizations in Oracle EBS R12 Experience with Finance EBS modules like GL, AR, OM, AP and IExpenses building new reports and customizations in XML Publisher and Forms Tools: Oracle Database 12c, Oracle Data Integrator 12c, Oracle ADF, SQL Developer, OTBI, OIC. Valtre June 2020- August 2020 Oracle SOA Developer • Development in Oracle SOA for customer Farmacias del Ahorro in order to complete a development of Service Bus for the company integrations. • Experience with Finance EBS modules like GL, AR, OM, AP and IExpenses building new reports and customizations in XML Publisher and Forms • Attendance for technical incidents with the SOA environments and the test process before to apply in Production environment. • Experience with integrations between Oracle and AWS environments by ETL process in ODI. • Tech Leadership end to end for testing the MDM efforts. • Experience creating testing plans with large teams. • Daily meetings with the customer technical leader in order to collect all the new features that the customer needs for new integrations with third party applications. • Development in ODI in order to build integrations between Oracle EBS 12.2.X and Oracle Cloud 18c through OIC for Alsea customer. • Analysis for integrations between Oracle EBS 12.2.x and Oracle Cloud for Inventory module. • EPM HYPERION - FCCS, EPBCS, ARCS, EDM • OTBI Reports in order to extract information from Oracle Cloud to SFTP server and build another integrations with third party applications. • Documentate the integration processes and the technical reference for the database objects. • Daily meetings with the technical team aligned with the scrum methodology. • Experience working with implementation of Master Data Management for the customer objective in the new integrations between AWS environments and another Oracle instances by the ETL process developed in OIC. • Tools: Oracle Database 12c, Oracle Data Integrator 12c, SQLDeveloper, OTBI, OIC, Oracle SOA, Oracle JDeveloper 12c. Amdocs Oct 2019- Jan 2020 Software Support Lead • Technical leadership in the support given to the AT&T applications in Java J2EE & Oracle Database 12c. • Support and Maintenance to the application developed by Amdocs for AT&T aligned to Standard Procedures from AT&T. • Daily support meetings in order to analyze and assign the enhancements for the AT&T application. • Development of code fixes for the daily incidents and problema management for each one of the critical services from the AT&T application. • Maintenance for the setup of WebLogic applications and performance issues reported by the end users. • AMS experience with Incident, Problem and Change Management processes for IT Support. • Experience with analysis and technical solution for integrations between third party applications and Oracle environments. • Experience with agile teams in order to develop new applications. • Tools: Oracle Database 12c, Java J2EE, EJB, Oracle WebLogic. Ataway July 2019- Oct 2019 OBIEE Specialist (Oracle Business Intelligence Enterprise Edition) • Programming in PLSQL for Oracle EBS 12.2.5 developments. • Development of WebServices in PLSQL and Java J2EE for Weblogic and Oracle EBS 12.2.5 for Payment Engine with BBVA and American Express. • Maintenance and support to developments in production for the Edenred customer of Mexico. • Documentation with Oracle AIM methodology for developments in Oracle EBS 12.2.5 • Report development in XML Publisher for Oracle EBS 12.2.5 • Development of integration interfaces with PLSQL for customer peripheral systems. • Experience with APIs, PLSQL, XML Publisher, Reports and Forms for the Oracle APPS EBS. • Experience with Functional modules like GL, PO, AP and INV in order to build integrations with legacy third party applications. • Experience implementing MDM (Master Data Management) with deep understanding for MDM concepts and creating plans for different teams. • Experience working with ETL, AWS and MDM. Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • Experience with install and setup for EBS environments for R12. Incident, Problem and Change Management experience with AMS methodology in order to attend tickets at 2nd & 3rd level of support. Tools: Oracle EBS 12.2.5, PLSQL, XML Publisher, TOAD, SQLDeveloper, JDeveloper. Tech Mahindra July 2018- July 2019 OBIEE Specialist (Oracle Business Intelligence Enterprise Edition) • Technical leadership in the support given to the Televisa applications in Oracle EBS 11.5.9 and legacy systems. • AML implementation on customer Oracle environment. • BPM implementation for Televisa customer, working on approval hierarchies between the new cloud environments. • EPM HYPERION - FCCS, EPBCS, ARCS, EDM • AML management with functional users of the customer in order to have a Good knowledge leve lof the financial operations of the company. • FCCM process implementatio for customer applications. • Support and Maintenance to the management boards in OBIEE / Discoverer / Qlikview by attending support tickets for incidents and problems based on ITILv3 best practices. • Training to technical team in the implementation of ITILv3 in relation to the care of incidents and problems. • Hyperion Essbase development of Business Rules, CalcScripts for technical support on financial environments for Televisa company. • Hyperion Planning development for dataforms, reports in Financial Reporting, tasklists and workflow for the financial teams. • Development for adhoc reports in SmartView • Giving technical support at 2nd level for all the hyperion applications and integrations with MaxL for different applications with the Oracle EPM plataform. • Experience design applications with hyperion planning for the customer. • Management of problems related to the BI boards, as well as implementation of new tracking methodologies to the changes requested. • Documentation of processes and configurations of the applications developed in the BI and Discoverer tools. • Experience implementing MDM (Master Data Management) with deep understanding for MDM concepts and creating plans for different teams. • Support and Maintenance to the Consolidation application in Hyperion Financial Management, as well as change management with the different infrastructure teams. • Analysis and proposals for improvements in the performance of the load and generation of cubes of financial information processes through the use of ODI, Qlikview and OBIEE. • Tools: Oracle Business Intelligence, Qlikview, Oracle Data Integrator 11g, PLSQL, Jython, Java, Oracle EBS 11.5.9, Oracle Weblogic, Oracle Database 10g. Oracle VM Virtual Box. Softtek Oct 2017- July 2018 ODI Specialist (Oracle Data Integrator) • Implementation of Oracle EPM and Oracle Hyperion Planning/HFM for IMSS customer. • FCCM implementatio process for IMSS customer. • AML analysis and implementation with functional customers in order to have a Good knowledge level for the company process. • Development in Financial Reporting in order to deliver new reports for IMSS customer. • Implementation for Hyperion workflow in order to approve the Budget management. • Support for new features in Oracle EPM for IMSS customer. • Development and Maintenance of the ETL processes for the NECOSPE application (New Scheme for the Survival of Pensioners Abroad) of the IMSS. Support in the operative continuity of the same following the incidents reported by the client through the PPM platform, as well as documentation of incidents reported for the elaboration of the Knowledge of the same. • Maintenance in Python code for information loads from flat files to ODI databases, as well as code maintenance in PLSQL and Java for PDF report generation functionality from ODI. • Hyperion Essbase development of Business Rules, CalcScripts for technical support on financial environments for the IMSS dependancy government. • Hyperion Planning development for dataforms, reports in Financial Reporting, tasklists and workflow for the financial teams. • Development for adhoc reports in SmartView • Giving technical support at 2nd level for all the hyperion applications. Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • • • • • Support in consultation processes and monitoring of the SISAT Database (Occupational Health System), making documentation and adapting consultations to deliver information to the client. Installation and configuration of Oracle Weblogic, ODI and connectivity agents for the nonproductive ODI environment of the IMSS (Analytical and Survival Testing). Documentation of installations in Linux and Windows environments on 32- and 64-bit platforms. Experience with Santander bank in order to give analysis and support for integrations between Oracle databases and Essbase analysis cubes. Application Administration and Oracle EBS R11 and R12 Databases. Cloning of Oracle EBS environments, installation of patches, CEMLIs, backups, management of updates on the modules of the EBS applications of each Tekappro client. Proactive management of new updates for the different Tekappro clients according to the different infrastructures of each client. Tools: Oracle Database 10g, 11g, 12c, e-Business Suite R11 y R12. Módulos GL, AR, AP, OM, XML, Payroll, HR Bepensa Motriz Feb 2008- Sep 2018 Oracle EBS - System Administrator • Analysis and design of new features in Oracle EPM for Bepensa customer. • Develoment of new reports in Financial Reporting for Oracle Planning and HFM. • Giving support for Oracle EPM for Bepensa customer. • EPM HYPERION - FCCS, EPBCS, ARCS, EDM • Administration and control of the processes involved in the Bepensa Motriz applications according to the ITILv3 Management industry standard. • Project management implementation of Oracle Hyperion Financial Management, Planning, OBIEE. • Administration of Oracle Data Integrator and Hyperion FDM • Change management management of the OnDemand ERP application hosting to DataIntensity. • Management with suppliers of new applications and their integration to existing applications in the Bepensa Motriz group. • Documentation and implementation of the Service Desk in the company, according to the ITIL standard in the management of Incident Management, Change Management and Release Management in coordination with Oracle Service Desk. • Preparation of quarterly and annual maintenance and update plans on all the technologies under my responsibility. • Participation with the responsibility of delivery / reception for the new IT solutions that have been implemented for Bepensa Motriz by the Technical Services of Databases team or other implementation teams. • Management with users and functional leaders to improve the applications, as well as management with internal and external suppliers to the company. • Incident management with OnDemand through the use of Oracle Support. Coordination of activities with teams of analysts from the United States and India in English, management of activities on OnDemand instances and interaction with Oracle OnDemand teams and processes. • Reception and review of documentation of (Developments for Oracle EBS) CEMLIs for the live departures of the different companies of the Group, all according to the AIM (Application Implementation Method). • Training to the IT staff of Bepensa Motriz in the management of Oracle technologies. • Relationship with commercial contacts, technicians and suppliers to discuss the requirements and review the proposals for new IT solutions. Participate in the process of selecting new IT solutions • Installation and Configuration of the Oracle Enterprise 10g Database for the Outsourcing System of Rental Result and Tivoli Service Management. • Audit of Instances, installed products and Database. • Administration and Management with application providers with Jboss and Cognos 8. • Installation and configuration of Cognos BI Analysis 8.1 on Windows 2008 R2 in IBM Blade infrastructure on Oracle Database 10g. • Upgrade of version of Cognos BI Analysis 8.1 to 8.3 on Windows 2008 R2 in IBM Blade infrastructure on Oracle Database 10g. • Analysis and Development of report boards in Cognos BI Analysis 8 on Oracle Database 10g using Oracle Data Integrator as ELT for the information load. Achievements: • Implementation of Long Term Plan (PLP) for Bepensa Motriz. Implementation of the PLP project for Bepensa Motriz in Hyperion Planning • Integration of HFM with businesses Bepensa USA Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • • • • • • • • • Integration of the companies of Bepensa USA to HFM through adjustments to the existing application of Financial Consolidation. Provider Portal Project Integrate the supplier portal in synchronization with H2H with Banamex with the aim of automating payments to suppliers of the Bepensa group. Oracle Cloud Integration Project IExpenses Integration of Oracle Cloud platform IExpenses as part of the Bepensa Group applications H2H integration project with Banamex H2H integration between Banamex and the ERP systems of the Bepensa group Implementation of Oracle EBS with BPEL SOA in 2008, allowing the Bepensa group to have its first ERP application. Implementation of Oracle EBS UPK, iRecruitment, OLM, HR and Payroll in 2012 Implementation of Oracle ODI, OBIEE and Hyperion in 2013 Implementation of a second ERP instance for payment to suppliers in 2015 Implementation of Oracle Cloud Expenses for managing travel expenses of the Bepensa group Implementation of Cognos BI Analysis 8 as a source of information for decision making on the Heavy Equipment Rental System Rental Result. Tools: Oracle 10g, 11g, 12c, e-Business Suite R12, Hyperion, OBIEE, Linux OEL, Oracle Data Integrator, Oracle Forms, Reports, XML Publisher, WorkFlow, BPEL, Oracle ADF, J2EE, JSF,Hibernate Edcon Consulting Sep 2007- Feb 2008 Oracle & Java Developer • Development in Oracle Forms for the operations module of Garza Ponce Vivienda in the city of Monterrey, N.L. • Development in Java J2EE ADF of the School Control system for the Universidad Iberoamericana de Torreón, Coahuila. Achievements: • Implement in Garza Ponce Vivienda the customized module (CEMLI) to ensure that customers can acquire in a personalized way the different housing and land options that Garza Ponce Vivienda manages. • Implement the school control system for the Universidad Iberoamericana de Torreón, Coahuila. • Tools: Oracle 10g, e-Business Suite R11, Linux, RedHat, Java, MVC, Struts, JSP, Servlets, XML, WebServices, Linux SuSe, 9.0, OC4J, JSF, ADF, jDeveloper 10.1.3, Forms, Reports, WorkFlow. OT Consulting, Monterrey, Nuevo León June 2007- Sep 2007 Oracle Developer • Installation and configuration of the Oracle 10g Database for the development, QA and Production environments. Patches, installation, backups, capacity Management. • Tunning of the Database, as well as the review of processes in it, stored procedures, triggers, views, tablespace configuration, creation of users. • Installation and configuration of servers with Cluster technology (RAC), OAS for Development, QA and Production environments. • TAR survey for development environments, QA. • Configuration and maintenance of servers and applications with Windows 2003 IIS. • Development of WebService in Java jDeveloper for ING Comercial América Hipotecaria • Development of MiniSite to consult inventories and stocks in an Oracle Database 10g for the eBusiness Suite. • Implementation of the i-Store for the Oracle 10g e-Business Suite. Achievements: • Migration of Oracle version 9 to 10 in OXXO. • Integration of the systems of ING Comercial America with the Sociedad Hipotecaria Federal. • Integration of Control Corporation applications with its different subsidiary companies through WebServices. • Tools: Oracle 10g, e-Business Suite R11, i-Store, IIS 5.0 for Windows 2003, Java, MVC, Struts, JSP, Servlets, XML, WebServices, Linux SuSe 9.0, OC4J, JSF, ADF, jDeveloper 10.1.3 Facultad de Matemáticas UADY June 2004- June 2007 Application programmer in J2EE andDatabase Schemma • Creation and configuration of the database schema in Informix IDS 9.3 of the School Control System of the State of Yucatán (SICEEY). • Development of Java J2EE applications with JavaScript, HTML, XML, JSP. • Development of Stored Procedures for the management of the Informix Database. • Installation and configuration of the SUNONE 8 Appserver. Jose Carlos Rojas Albornoz Cell Phone number - email:-/-• • • • • • Solaris Server Administration. Development of the School Control System of the State of Yucatan for SEGEY. Development of the Internet Qualification Query System for SEGEY. http://educacion.yucatan.gob.mx:8080/siceey_pub/ (System of Consultation of Qualifications for Parents of Family)http://educacion.yucatan.gob.mx:8080/siceey/ User: DPR0962UDVM password: DPR0962UDVM Achievements: • Implementation of the first comprehensive control system for the state of Yucatán and was the second nationwide to achieve such implementation. • Optimization of duplicate emission times for certificates at the Basic Education level. Implement a web portal to track grades for parents at the state level. • Tools: Oracle 10g, Java, MVC, Struts, JSP, Servlets, XML, WebServices, Informix 9.3, SunOne, Solaris 9, AIX, Db2 Instituto Electoral del Estado de Yucatán Dec 2003- June 2004 Web Applications Programmer • Installation of SuSe Linux 9.0 Server for development of Web applications. • Development of a training control system for unqualified citizens. • Programming of applications in Php, JavaScript and Postgresql for the capture of trained citizens in the state of Yucatán with a view to the Electoral Process of May 16, 2004. • Programming of console interfaces in java and C ++ for Web environments. Achievements: • Integrate the web application for the Institute. • Implement the training solution for citizens elected as polling officials (unqualified). • Tools: Postgresql, PHP, Linux SUSE, Ubuntu, HTML, CSS. Instituto Federal Electoral Dec 1999- Dec 2003 Head of Digitalization of Base of Images • Migration of the Image Base of the Genesys optical disk controller (under OS / 2 operating system) to the Oracle 8i database management system (under the IBM AIX operating system). • Design, generation and printing of reports with Crystal Reports software from Seagate Software. • Programming of applications in ANSI / C for AIX, as well as in PL / SQL of Oracle 8i and applications under Windows 98 and 2000. • Programming capture forms for the CRC Support department in Oracle Forms. • Installation and configuration of Citizen Attention modules for the states of Yucatán, Campeche and Quintana Roo under Windows 2000 and connectivity to the ORACLE8 Database. Achievements: • Detection of possible duplicates in the Nominal list of the Federal election of 2000 at the southeast level vs. the rest of the country and its management until the clarification of the citizen status. • Optimization of voter credential issuance times through the implementation of an internal web consultation for IFE DBAs nationwide. • Implemented a web portal in PHP that allowed to review the citizen's digital file by means of a query to the Oracle BLOB field where the image of the citizen in Oracle is saved. • Tools: 6,7,8i,9, Oracle PL/SQL, Shell Script, Oracle Forms, Oracle Reports, Crystal Reports, AIX, Linux Debian, HTML