Miguel S.


246 dollar
41 ans
Mexico City, MEXICO

Mon expérience

Voir plus

Independent projects: COBOL applications support & maintenance + Excel-based dashboardsJanuary 2018 - Présent

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

FreelanceJanuary 2018 - Présent

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

Code Warrior, Ltd.April 2018 - December 2018

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.
Voir plus

Mercedes-BenzJune 2008 - October 2017

• 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).
Voir plus

Cognosite, S.C.January 2007 - 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 end users and both the local IT area and the USA IT area.
Voir plus

Grupo PissaJanuary 2000 - January 2006

• 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#.
Voir plus

Heuristica SistemasOctober 1984 - October 2000

• 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 reative 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 ations for medical doctor prospects and the creation of individual proposals for each case.
Voir plus

Procter & Gamble CoJanuary 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.

Mes compétences

Visual FoxPro, Visual Basic, UNIX, TSO, SQL, Spanish, SAP, Ruby on Rails, Project Management, Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Mainframe, Linux, JCL, Java, HTML, Delphi, DB2, COBOL, C++, Business Intelligence