Interested in this profile?
105€/dayPROPOSE A MISSION
Procter & Gamble Co. Mexico
January 1976 - January 1981
* Support 24/7 of P&G's main system that handled orders, billing and shipping (OSB); written in PL/I, running on an IBM 370 with DOS and VSAM and ISAM files. * Developed an ``instant report'' system for end users that allowed them to define and obtain an ad hoc report in minutes, without the need to place a request to the IT area nor waiting days or weeks for it. * Designed, structured and developed a system to identify and compute the cost for each job run, based on the cost or income center associated, and taking the exact and detailed information directly from the system logs (thus eliminating a manual, inaccurate and error-prone task). * With a small number of colleagues, we developed: * some 50 utilities of widespread use for the IT department * naming and coding standards for interactive applications that used CICS and the Total data base manager.
January 1981 - January 1981
January 1981 - January 2000
January 2000 - January 2005
* Design, development, maintenance and support of Lotus Notes applications for several customers. * Implementation leader for a Purchasing application for the federal government entity; developed in C#.
January 2000 - January 2000
* Design, development, support and maintenance of applications based on MS Project (proficient in reporting features to identify critical activities SAP, Borland Delphi, Cobol, Foxpro, HTML, C++, Java, PL/I in mainframes and propose alternatives). and Windows and Linux servers. * Support and maintenance of Cobol applications in American Express Advanced (Mexico), for the AmexCo credit card area. MS Visio (above average knowledge * Support and maintenance of a third-party application in Cobol for Procter & Gamble Mexico, for the Sales area (customers). to create clear, attractive and self- * Design, development, support and maintenance of: explanatory diagrams). * an integrated system for diagnostic laboratories, in C++ on a Unix environment. Advanced * a hospital application for patient management: administrative control of incoming patients and invoicing. Languages * an Excel-based payroll system (which allowed the end user to create and/or Spanish modify all calculations and cumulative figures without any help from IT personnel). Native * an inventory management application that allowed the end-user to create and define inbound and outbound transactions, as well as the impact it would English have on the theoretical material inventory, without any requirement to the IT area. 100% spoken, read and written * Mexico representative of Exactus, ERP from Costa Rica: in charge of Italian implementation, configuration, support and maintenance. Exactus included the following modules: sales, finance (accounting, accounts receivable, 75% read and written; 50% spoken accounts payable, banks, budget), human resources and payroll. * Partner of Solomon ERP for small and medium (Latin American) companies, Project Management which covered sales, finance, distribution and production tasks and activities. Waterfall * I developed an application for medical private practice, initially under FoxPro, Critical Path Method (CPM) which later I also migrated to Borland Delphi. In charge, additionally, of support and maintenance as well as presentations for medical doctor PMI/PMBok (simplified) prospects and the creation of individual proposals for each case.
January 2005 - January 2008
* Project leader for development of web applications for DaimlerChrysler USA. Java programming. * Support and maintenance of Cobol batch applications with DB2. * Develop system's project proposals, liaison and coordinator for Mexico between MS Excel Power User: Power Pivot, end users and both the local IT area and the USA IT area.
January 2008 - January 2017
Mercedes-Benz Mexico * Sales information ETL design and development to eventually load it into Tableau, a visual data analyzer, and replace the DDiver application. This allowed a considerable reduction of the daily process time from 6 hours to 10 minutes; in Visual Basic. * Design and development of Tableau control panels for sales, product development, marketing and top management. * Development, support and maintenance of ``batch'' processes to send and receive data files to and from vendors (using stored procedures, DB2, isql and batch jobs (.bat)). * Implementation, support and maintenance of RFTS and Axway CFT (secure file transmission applications).
January 2018 - September 2019
Design, development, support and maintenance of Cobol applications, involving mainly but not exclusively, DB2 and CICS, on IBM mainframe environments as well as other platforms.
Excel-based dashboard design and development, using Microsoft Power Pivot, Power Query and Power BI (Business Intelligence).
Secure Code Warrior, Ltd.
April 2018 - December 2018
Secure Code Warrior, Ltd.
Coding of Cobol program ''sets'' (consisting of one vulnerable situation, one secure and correct solution, and three incorrect solutions), with specific vulnerabilities for training purposes. Aimed at developers through gamified training and real-life, customizable online assessments.
Newest members that made a profile
Join for free to access our full freelancer catalog!GET STARTED