Juan Pablo A.

Consultant

460 dollar
Freelancer
21 years
Querétaro, MEXICO

My experience

More

BHTC Mexico (San Miguel de Allende) AutomotiveJuly 2018 - Present

Implementation of External Warehouse HUB in Laredo TX (USA) to allow car companies in USA supply by themselves the required material. It includes the invoicing process, transfer material from plant, transport papers, customs process, goods receipt and goods issue when shipment is created to the final customer’s destination.Improvement of the material management process. From procurement of material, reception, incoming inspection, put away, supply to production shop floor (electronic and mechanic parts), consumption, assembly, WIP, functional testing, identification, quality approval, transfer to WH, delivery/invoicing and shipment to the customer. Making processes more efficient with the use of racks, super markets and barcode scanners and training to the people involved.
Solving issues in sales & logistics department to create correctly schedule agreements, prices, delivery notes, shipments, labeling identification, documentation for the forwarder, ASN/EDI and Invoices.Training users to follow in the correct way, the routings of products, production confirmation and quality release and reporting of Scrap material (by Production, Engineering and Quality department). Implementation on site of new warehouses with HU and production process in INDIA Plant for new projects. It includes raw material like electronic components, mechanical parts and PCBs. Complete process of production.Implementation of new production facilities in CHINA. Because of the grow of production in that plant, was required to implement new facility with all SAP services, new machinery and copy process of production and material management. (Remote implementation).Supporting the engineering changes/new versions, bill of materials, routings, mass changes of matter data, scrap material and finish goods in SAP.
Additional support in EDI/Speedi to send the releases to the vendors ASNs and mapping IDOCS to complete electronic data interchange process according the standards.Global support in different SAP modules working as back up of colleagues in Germany.Reporting in weekly basis the progress of the projects and the current status of the main topics.
In Global projects I use other meeting where I report status to the functional and management areas involved in weekly basis too; in case of some escalation, delay, change of scope or cancellation, I take the chance in the same meeting to do that.
More

FreelanceJuly 2017 - Present

Support in functional modules MM, WM, PP and SD.
Implementation of ASN EDI with automotive sector clients.
Identification of materials within productive areas and shipping to customers with QR, Matrix and BarCode 3 of 9 and 128 labeling.
Implementation of the SAT requirements (CFDI 3.3, CCE 1.1, Electronic Contac
Payment Supplement)
Continuous improvement, support in logistics processes (storage locations, warehouse, shipment, delivery, transfers postings, labels, mass changes, etc.)
Support for customer claims solution, EDI, releases, schedule agreements, purchasing, prices, info records, master data, etc.
Projects and remote support to subsidiaries in other countries.
Training for users and generation of manuals with visual aids.
Reports to local and corporate address in the foreigner.
Scanner connectivity and barecode.
Interfaces with applications outside SAP.
More

-May 2008 - Present

SAP FI, SAP ABAP - SAP MEXICO
More

Consulting DLM.September 2016 - December 2020

Migration of packages with all their content of programs, dictionary of objects, FM, tables, structures, domains, etc from SAP ECC to SAP HANA.
Creation of maintenance screens, corrections, adjustments, translations, validations, etc in SAP HANA Destination.
The packages were mainly focused on the FI and SD modules to imitate electronic billing, electronic accounting and foreign trade complement in the new platform.
More

PAE GlobalJanuary 2017 - June 2017

Support for ticket solutions in MM, SD, PP and FI modules through developments in ABAP.
Modification of screens, reports and functionalities of different transactions according to user requirements.
Development, unit tests and integrals, pass to productive and post-productive support
More

Consultim DLMJune 2011 - August 2016

Development of interfaces for three different servers of SAP R3 to have the integration of accounting movements from two different SAP in a third.
Development of function modules to automate instructions from a web portal and make material movements in SAP and avoid manual rework.
Analysis, construction, testing and start-up of data extraction and loading programs to be able to run both in Background (through automatic jobs) and Foreground modes (with user interaction).
Creation of different maintenance programs for Z tables necessary for the process.
The programming was done directly in ABAP for ECC 6.0 and 4.7 systems
More

ABB Mexico (Consultoria UST Global)August 2015 - March 2016

Strategic consultancy for the implementation of application interfaces to connect them with SAP.(Payroll, Banks, eComerce, Customs Agents, Applications developed by third parties).
* Support to document development requirements, technical designs and other requirements to clarify the activities to be carried out to achieve the connection of the applications.
* Definition of mappings for information loading through Biztalk, IDoc, RFC, Flat files, XML files and EDI.
* Management and follow-up of work plans, notification activities, meetings to advance pending issues.
* Call for meetings to define requirements, pending, dates commitment, design of solutions and creation of technical designs.
* Within applications are managed Electronic Invoicing, Electronic Accounting, Human Resources, bank movements, project movements, orders, etc.FI, SD and MM.
More

Humman Access - ProdubanAugust 2014 - August 2015

Follow-up on infrastructure projects In house, Third Party and Group.
Call for meetings for follow-up, release of issues, definition or changes of scope, agreements, work plans, project closures, etc.
Weekly / monthly committees with different areas, clients and users to inform or obtain status, priorities, emergencies, cancellations, etc. of projects.
Control / Notification / Authorization tracking released by the bank to start projects.
Registration of new initiatives and updating of status in the PPM and PMO tools.
When required, it is supported to make necessary documentation and carry out activities that are within reach to advance or undo pending and continue with the process in benefit of project times.
Generation of monthly progress reports for countries.
Publication of status in web portal to inform users 24 hrs X 7 days.
More

EGO Componentes Electrónicos SA de CVAugust 2007 - October 2013

Main Activities:
* Received training from implementations team of Germany HQ and participate in the rollout implementation of SAP in Mexico.
* I provided all master data to be loaded into the system, for instance: all customer's data, GL accounts, products, direct and indirect materials, routings, BOMs, users, printers, etc.
* Re-mapping of EDIs to receive PO from customers in USA.
* Customizing, request for changes and release to production all modules in scope. (FI, SD, MM, WM and PP).
* Sending of functional testing results to the consultants in USA.

* Receive tickets from all key users to solve the issues for invoices, reports, material movements, etc.
* Implement and fix problems with the barcode scanner in warehouse.
* Administration of users in SAP, rights access, modules, parameters, reports, etc.
* Checking if does not exist conflict of interest in the area, function or transaction with the user that asked for access.
* Support all Servers and Communications infrastructure (Servers, Routers, Switches, Firewalls, PBX - IP Telephony, etc.)
* Install network connections (local and wireless) for new areas and users.
* Second and third level support in desktop and production applications.
* Implementation of procedures to be prepared in case of disaster. (DRP)
* Manage the backups of data and create images of main computers.
* Implementation of preventive maintenance of all computers in the plant (Servers, Desktops and Laptops)
* Implementation of virtual machine to make interface between SAP and tablets in production department.
* Check which others functionalities of SAP we can use in Mexico to continue improvement. What are using in other countries that can be implemented here.
* Programming some small applications in Visual Basic, Crystal, and Html.
* Administration of the people that gives first level support (MS office, printers, MS Win 8,7 and XP, electronic invoice, lotus notes, plm)
* Manage the suppliers. (Tonners, Computers, Appliance Devices, Spear Parts, etc)
* Manage the licensing of software. (Microsoft, symantec, etc)

Plus of my work:
* Be part of the SAP R3 Implementation Team when the company started up.
* Help to Engineering department to support machines in the shop floor.
* Be a Lead Auditor in ISO9001 and ISO14000 and achieve the certifications.
* Be responsible of Health and Safety area and help to prevent accidents and accomplish the law requirements.
* Be responsible in some time for the maintenance of the facilities.
* Participate actively in training of lean manufacturing and quality audits
* Make some projects of energy saving. In a team with production and maintenance departments.
More

Mexico SA de CVApril 2000 - December 2006

Plexco de Mexico SA de CV (Chevron Phillips Chemical Company)
Main Activities:
* First level support in SBT accounting system. Finance department.
* Implementation of SAP R3 in modules of FI, SD, QC and PP.
* Be the main contact between headquarters in IT and SAP support.
o Receive and run the scenarios in the modules, send the feedback to Houston, fix problems and give training to end users.
o Loading of master data by preparing in CSV and use processes in SAP. Import from SBD database and load to SAP database.
o Training to users.
o All testing of reports, transactions and processes.
* Administration of users in SAP, rights access, modules, parameters, reports, etc.
* Support all Servers and Communications infrastructure (Servers, Routers, Switches, Firewalls, PBX - IP Telephony, etc.)

* First level support in local applications (Payroll system, SAT applications, System to manage the Import/Export material.
* First level support in desktop applications (MS office, printers, MS Win XP, MS Exchange mail
* Install network connections and computers for new areas and users.
* Implementation of procedures to be prepared in case of disaster. (DRP)
* Implementation of preventive maintenance of all computers in the plant (Servers, Desktops and Laptops)
* Manage the suppliers. (Tonners, Computers, Appliance Devices, Spear Parts, etc)
* Manage the licensing of software. (Microsoft, symantec, etc.)

Plus of my work:
* Be part of the SAP R3 Implementation Team when the company decided change SBT to SAP R3.
* Help to Engineering department to support machines in the shop floor. (PLCs siemens, Alliance, etc)
* Be a Lead Auditor in ISO9001 and achieve the certifications.
* Programming some application in MS Access to manage the Corrective and Preventive actions for ISO9001
* Participate actively in training of quality audits

My stack

Application servers

BizTalk

Other

German, ISO 900X Standard, Microsoft Access, Microsoft Windows NT, Microsoft Office, IT Manager, Microsoft Windows XP, Microsoft Windows 7, Microsoft Visio, Router, Lotus Notes/Domino, Microsoft Windows Server 2012, High Availability, BizTalk Server, SAP ABAP, Microsoft Exchange Server, Microsoft Outlook, Adobe Go Live, SAP-FI- reporting, EDI, SAP SD, SAP ABAP iDOC, SAP FI, SAP ECC, SAP WM, SAP PP, SAP ABAP BAPI, External Consultant, Systems Administrator, Seagate Crystal, Information Technology, SAP ABAP XML, Lotus cc:Mail, CAPA, Linux Suse, SAP ABAP EDI, User Interface, Middleware, 1st Line Support, give support, WIP, Wide experience, database manager, SAP SD Sales, SAP FI GL, English, Sense of Urgency, Switches, SAP FI TR FM, Business Continuity, SAP PP MRP, SAP QM QC, Remote implementation, Global support, rollout implementation, Manage the backups, EDI IDOC, SAP-PP- PP, SAP WM MM, SAP OTC, additional support, SAP PTM, Certification of SD, Diploma > Diploma NETWORK SECURITY, a Lead Auditor, Second and third level support, PMO - Project Management, Applications Integrator, mechanic, Personal Home Page, Microsoft Project, SAP PTP

Languages

XML, PHP, HTML, ABAP, JavaScript, C++, Visual Basic

Software testing

Functional testing

IT Infrastructure

Linux Red Hat, Windows, Firewalls, Linux

ERP&CRM

SAP

Embedded and Telecom

PBX

Environment of Development

Visual Studio

Frameworks

.NET

Computer Tools

Microsoft PowerPoint, MS Excel, Microsoft Word, MS Office (Word, Excel, Powerpoint, Outlook), Microsoft Excel

Others

SAP R/3, Negotiation, Strategic Planning, SAP 7.0, ITIL, Project Management, SAP MM, Teamwork, SAP (FI/AA/CO/PS modules)

Databases

Microsoft SQL Server, Oracle 10g, MySQL

My education and trainings

- SAP R3

Maestría, Administración y Finanzas - Universidad Autónoma de Querétaro

Licenciatura Sistemas Computacionales - Instituto Tecnologico de Queretaro1991 - 1997