GO BACK
available
Miguel Sosa
Software Developer

Mexico City, MEXICO

42+ years experience

Interested in this profile?

105€/day

PROPOSE A MISSION

MY EXPERIENCE

Procter & Gamble Co. Mexico

January 1976 - January 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.

Power BI

January 1981 - January 1981

Partner

Heuristica Sistemas

January 1981 - January 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.

Pissa

January 2000 - January 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#.

Heuristica Sistemas

January 2000 - January 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.

Cognosite, S.C.

January 2005 - January 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.

Mercedes

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

Freelancer

January 2018 - September 2019

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

Secure Code Warrior, Ltd.

April 2018 - December 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.

MY STACK

Technologies
CICS
Languages
Cobol, C++, Delphi, HTML, Java, Ruby on Rails, Visual Basic
Databases
IBM DB2, DB2, Visual FoxPro
Computer Tools
MS Office (Word, Excel, Powerpoint, Outlook), Microsoft Excel, Microsoft PowerPoint, Microsoft Word
IT Infrastructure
Linux, Unix
Others
Project Management, Spanish
ERP&CRM
SAP

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

Skills

CICSCobolIBM DB2MS Office (Word, Excel, Powerpoint, Outlook)

Newest members that made a profile

Access Our Freelancers

CONTACT US