Luis Ramírez Email & Phone Number

Área Metropolitana De Querétaro

• Participation in internal projects. Design and execution of solutions focused and adapted to the needs of the work team.
• Training in Snowflake SnowPro Core, AWS Cloud Practitioner. Technical skills used: Windows, Snowflake Interface.

Guadalajara, Jalisco, México

• Assigned to an English bank account.
• Part of the DPaaS (Data Protection As a Service) Support Team.
• Provide support in case of failure, to the ETL processes that are executed through jobs on this services platform. By guaranteeing and meeting established Service Level Agreements (SLA). Technical skills used: Unix.

Ciudad De México Y Alrededores, México

• Administering computer systems: Human Resources (Staff Administration), Payroll, Compensation (Benefits), IMSS (Social Security).
• Migrating payroll systems: Migration of the Oracle 12 Payroll system to the openHR v10 payroll system, carrying out the following activities: system configuration, update of payroll formulas, load of historical.
• Developing high impact projects. Implementing computer systems (Web applications) that were 100% adapted to the operational needs of the business covering all the SDLC: vacation and payment of payroll debts systems.
• Developing of automatic processes (ETL, stored procedures and jobs) to generate information to different areas of the company and creating interfaces for information exchange with suppliers.
• Provided support to the users that required it on the different systems I had in charge. Technical skills used: Microsoft SQL Server Web, T-SQL, SQL Integration Services (SSIS), JavaServer Faces (jsf), eclipse IDE.

México

• Administering computer systems: Human Resources, Payroll, IMSS (Social Security) and Training.
• Implemented information systems of high value and low cost that were 100% adapted to the operational needs of the business and facilitated the execution of processes and decision making of the company (Web.
• Developing of automatic processes (ETL, stored procedures and jobs) to ensure the proper functioning of these systems.
• Participated in the migration of the openHR v2 system (Payroll / IMSS) to the openHR v7.
• Prepared documentation for internal and external audits that were made to servers and applications that I managed.
• Coordinated 3 direct reports to which they were given technical advice to be able to carry out the projects in an optimal way, providing effective feedback and positive energy.

Ciudad De México Y Alrededores, México

• Responsible for managing the YRG System (Yum Recipe Generator), product inventory manager system, recipes, sales products and prices.
• Participated in the development of this system, which allowed for a customized application and flexibility in the changes that were required to be carried out.
• Implemented new features to this application that allowed to make this system more robust as required by business dynamics.
• Creating perl scripts to process text files and upload to Microsoft SQL Server Database. Technical skills used: Informix Dynamic Server, perl, php, Microsoft SQL Server 2000-2005, T-SQL, Unix, Linux, DTS, JavaServer.

Ciudad De México Y Alrededores, México

• Developing web page applications covering the entire SDLC.
• Participated in the development of the Web Sites of Renault, PiP, Mercer, Serfin and Company Intranet Website. Technical skills used: perl, php, mysql, postgres, linux.

Puebla, Puebla, México

• Managed the SAP system on the AMECE server.
• Supported the upgrading of versions of this system. Technical skills used: Unix, SAP, Informix Dynamic Server

Ciudad De México, México

• Responsible for Managing the Database of the Crew Server.
• Automated and monitored the daily update of this Database.
• Participated in the design, development and implementation of the Accreditation and Viatical systems in client / server environment for Aeromexico's crews.
• Collaborated in the development of the Promotions system. Technical skills used: Informix Dynamic Server, Unix, shell scripts.

Ciudad De México Y Alrededores, México

• Responsible for the Information Subsystem of the Secretary of Finance. (SAT)
• Participated in the design, development and implementation of this system which allowed to have information of high value for the decision making of the different areas of this dependence.
• Managed the version control of the programming of this dependence that was sent to offices nationwide.
• Coordinated the generation of the installable packages to be released for this System at the offices nationwide, guaranteeing the correct installation. Technical skills used: Informix Dynamic Server, Unix, shell scripts.