GO BACK
available
Miguel S.
Cio

Mexico-Mexico City

42+ years experience

Interested in this profile?

105€/day

PROPOSE A MISSION

MY EXPERIENCE

Secure Code Warrior, Ltd.

Apr 2018 - Dec 2018

Cobol Developer

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.

Mercedes-Benz

Jan 2008 - Jan 2017

Chief Information Officer

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).

Pissa

Jan 2000 - Jan 2005

Implementation Manager

* 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#.

Cognosite, S.C.

Jan 2005 - Jan 2008

IT Consultant

* 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.

Power BI

Jan 1981 - Jan 1981

Partner

* 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.

Heuristica Sistemas

Jan 2000 - Jan 2000

Expert

* 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.

Procter & Gamble Co. Mexico

Jan 1976 - Jan 1981

IT Area Manager

* 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.

Freelancer

Jan 2018 - Jan 1981

Cobol Developer

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).

Heuristica Sistemas

Jan 1981 - Jan 2000

Partner & Project Manager

• Design, development, support and maintenance of applications based on SAP, Borland Delphi, Cobol, Foxpro, HTML, C++, Java, PL/I in mainframes and Windows and Linux servers.
• Support and maintenance of Cobol applications in American Express (Mexico), for the AmexCo credit card area.
• Support and maintenance of a third-party application in Cobol for Procter & Gamble Mexico, for the Sales area (customers).
• Design, development, support and maintenance of:
• an integrated system for diagnostic laboratories, in C++ on a Unix environment.
• a hospital application for patient management: administrative control of incoming patients and invoicing. • an Excel-based payroll system (which allowed the end user to create and/or modify all calculations and cumulative figures without any help from IT personnel).
• an inventory management application that allowed the end-user to create and define inbound and outbound transactions, as well as the impact it would have on the theoretical material inventory, without any requirement to the IT area.
• Mexico representative of Exactus, ERP from Costa Rica: in charge of implementation, configuration, support and maintenance. Exactus included the following modules: sales, finance (accounting, accounts receivable, accounts payable, banks, budget), human resources and payroll.
• Partner of Solomon ERP for small and medium (Latin American) companies, which covered sales, finance, distribution and production tasks and activities.
• I developed an application for medical private practice, initially under FoxPro, which later I also migrated to Borland Delphi. In charge, additionally, of support and maintenance as well as presentations for medical doctor prospects and the creation of individual proposals for each case.

MY TESTS

NAME
SCORE
English language quiz B2
76/80
MS Word 2010 quiz beginner level
22/27
MS Excel 2010 quiz beginner level
27/28

Newest members that made a profile

ACCESS OUR FREELANCERS

CONTACT US

OK