Pablo Ramirez

Bio

SUMMARYI had achieved more than twenty years professional experience solving problems in a creative way, in multicultural and multinational environments. High capability to communicate at different organizational levels, negotiator and effective speaker with effective and measurable results in projects assigned. Well integrated team player with fast adaptation to diverse and adverse situations. I am always committed with organizational goals, oriented to provide results and value added in all my duties.
WORKING EXPERIENCE
Laboratorios Grossman(Valeant Pharmaceuticals)
Mexico City, 2007-up to dateIT – Project Manager Mexico, 2008 up to dateIT - PMO for all projects business related. Critical part of the role is to be responsible for the stabilization of the SAP R3 implementation, post implementation follow up and identification of information gaps to be fulfilled.
• Directed all regression testing for Latin America, ensuring all functionality stabilization. Avoided any potential failure caused by Poland’s configuration changes in the global clients.
• Directed the development of an interface to transfer all accounting figures to corporate from SAP R3 to HFM. Ensured proper mapping for all accounts and delivered detail at material and customer level.
• Directed warehouse relocation. Provided all infrastructure, SAP configuration and logistics guidance, not limited by IT scope.
• Identified root causes for inventory issues causing a difference around 1 million dollars. Determined course of action and solved all issues as required by the organization, timely and accurate.
Applications Maintenance Manager, 2007Direct the efforts of internal and outsourced personnel to maintain the operations and transition of the entire operation to SAP, with full responsibility of migration from legacy systems data. Enable the operation to continue with a smooth transition once SAP was implemented and provide feedback on good operational practices based on information driven decision.
• Replaced the Manager responsible for data migration to SAP with minimal issues in the process and minimal impact in the go-live process, even with suddenly quit one month before Go-Live.
• Modified operational processes to perform the accounting & operational monthly closing with minimal situations. Support provided while working with Oracle e-business as well as with SAP R/3.
• Directed the development of the critical information requirements to be fulfilled through SAP.
• Performed required analysis over accounts payable balances, identifying some open balances with more than 180 days previously undetermined, directing a balances cleansing and conciliation.
• When my job started I received 59 pending issues (some more than 6 months old) in 45 days all off them were solved.

Grupo Pochteca
Mexico City, 2000-2006Operations Director, 2000-2006Direct the entire sales flow process, from the order taking, transformation, storage, maintenance and distribution of products, responsible for the factory, warehouse and logistics. Verify the concordance between theoretic and physic inventory. Ensure the dynamic distribution of products from the moment of the customer order to the reception at the customer premises, increasing and sustaining the quality of the delivery. Sustain the production of more than 1,000 tons per month. Recover any refund and control of none-complaint product, determining the ways to dispose those products as needed.
• Modified the distribution chain ensuring at least 95% of deliveries on time, with 3 hours 30 minutes delivery average time from order taking to product release at customer facilities for the entire metropolitan area of Mexico City with an average per load of more than 1 ton.
• Ensured the reception, classification and reprocess of any non-complaint product as required by the company or the customers with an accuracy of more than 99% in the time and reliability of the service.
• Sustained and improved the customer service, answering any complaint in less than 48 hours providing always the service required by the customer. Neither for service a single customer was lost nor for complaints not properly answered.
• Increased the production from 500 tons per month average at 2003 to more than 1,000 tons per month average in 2005, increasing the possibility to deliver personalized orders to more customers.
• Reduced the quality problems in final product to less than 2 rejects for every 500 tons produced and controlled the generation of waste to less than 3%.
• Supervised physical inventories verified and updated in-load and out-load procedures, ensuring more than 99% inventories reliability.
• Optimized the logistic work force reducing the headcount from 63 to 31 employees sustaining the quality of the services.
• Developed the knowledge matrix per position, identifying the skills and knowledge required for each single employee, with the training and reinforcement of the opportunity areas in order to enhance and maintain the level of services provided by each of any of the employees under my direction.
• Directed the equipment acquisition to increase the production and quality of services, reducing operative costs while the final products sustainable reached and exceeded the customer’s requirements.
• Leader in the operations area for the ISO 9001:2000 certification, working close to the ISO manager in the documentation and follow up of the Quality System, developing the key business and quality indicators for all the operations area.

The Coca-Cola Export Corporation
Mexico City, 1992-2000Manager - Latin America Regional Support Center, 1996-2000Direct the efforts of a high performance team, supporting the software implementations related with the Supply Chain throughout Latin America. Supervise the hot line telephone to provide assistance in any problem in the Supply Chain caused by the use of the proprietary software. Achieve by 1999 that 80% of the Coca-Cola Latin American sales were processed through the proprietary software. Participate and coordinate a group of specialist in the SAP – Infinitum project from the operations standpoint in Coca-Cola Femsa.
• Supervised that all field services were delivered on time, within the budget and with a high quality service. Providing to the regional divisions and bottlers the know-how to be independent in subsequent rollouts.
• Verified that the hot line resolved every call from anywhere in the Latin America Region. This resulted in 0% detainment of any operation under any circumstance. Provided required alternative solutions to continue with the daily operation if required.
• Supervised the proper training of more than 2000 Coca-Cola associates in the best use of the software, control tools, business administration and best operational practices in the Supply Chain. Those trainings generated more independent operations across Latin America.
• Supported the Y2K project all over Latin America, reviewing required software updates and establishing a backup network, where in case a bottler mainframe went down, the nearest Coca-Cola divisional office could be their remote support to continue the daily operation, the same for the regional support center to be the back-up of the divisions.
• Achieved earlier than the established period, in conjunction with the Latin American Divisions, the goal of sales processed by the proprietary software reaching the target by end 1998, one year earlier.
• Member of the leader team that defines every six months the best operational practices in the Supply Chain to be integrated in the proprietary software, this participation required my assistance to several meetings in Vienna Austria for three years.
• Directed the guidelines for Supply Chain in the pilot SAP project in Coca-Cola Femsa between 1996 and 1998.
Manager - BASIS (Bottlers Advanced Sales Information System), 1994-1996Administrate a group of project leaders to implement the proprietary software to support the Supply Chain. Convince the bottlers to use it.
• Designed a standardized methodology to implement the software; making a profile of each bottler based in their particular operation, this methodology was used at least until 2000.
• Determine size and type of hardware and servers including AS/400 to be used in every bottler facility to process all the required transactions, considering customers, warehouses, users, and statistical analysis an so on.
• Coordinated the implementation efforts of 7 bottling groups all over Mexico, including first implementation and procedures for the rollout.
• Directed all physical relocation during the Mexico branch relocation from Rio Amazonas building to the new premises at Ruben Dario, with no impact to the employees, leaving on a Friday afternoon and arriving to their new office on Monday with all their resources and personal stuff in place.
Coordinator - BASIS, 1993-1994Project leader in the implementation of the proprietary software in Coca-Cola FEMSA, unique bottler in Mexico City.
• Adequate the sales entry process in order to fulfill the newly introduced presale requirements. Directed the hand held terminals configuration as well as the entire Supply Chain adjustments required to fulfill the delivery on time.
• Trained personnel to transfer the know-how to build their self-sufficiency, in order to continue the system support with minimal additional help.
• Managed a group of personnel working for the bottler to perform several implementations at the same time, configuring the software as required.
• Participated in the negotiations with the union as required to smooth the implementation process.
Trainee (Managerial Trainee Program), 1992Received a wide training during one year in all aspects of the supply chain and standards for production, warehousing and sales of The Coca-Cola Company as well as managerial skills and tools.
• Analyze seven bottlers to generate a feasibility study to identify the possibilities to implement the sales and distribution proprietary software.
• Produced individual reports allowing the company improved comprehension of the real business operation.
• Convinced the bottlers with the reports generated as well as with effective presentations, to utilize the software.

Sweda de Mexico
Mexico City, 1989-1992Systems Manager, 1989/1992Search around the globe for point of sales solutions to be sold in supermarkets and departmental stores. Perform any required customization or developments to hardware or software for the Mexican market. Provide support to the sales force to get the sales contracts. Configure networks and customize the products according with customers needs.
Manage a team to review an adequate point of sale equipment to sell it in department stores. Provide support to the sales force to sell the hardware and software.
• Managed the total review and modification of an Irish product that was sold in Mexico, introducing on-line inventories and the use of bar codes for the first time in Mexico.
• Coordinated the efforts of a development group in association with regional offices in USA, Sweden, Ireland and Germany, having a product for supermarkets that was sold in the USA.
• Participated as speaker in COMPUMUNDO 91, talking about the PC based point of sales.
• Exhibited Sweda products in 1990 and 1991 in New York.
EDUCATION
Universidad Nacional Autónoma de Mexico, Mexico City, 1982-1986Mathematician (Computer science specialization)ADDITIONAL EDUCATIONSAP Business Warehouse (WM), Mexico City, 2008
SAP Sales Database (SD), Mexico City, 2008
Auditors training for quality systems based on ISO 19011:2000, Mexico City, 2006
Documentation required to implement a quality system and process mapping according with ISO 9001:2000, Mexico City, 2008
Introduction and interpretation of the quality requirements based on ISO 9000:2000, Mexico City, 2008
ISO 9000 Introduction for the top management, Mexico City, 2001
Market Analysis, Vienna, Austria 1994
Key Account Analysis, Vienna, Austria 1994
Sales Databases, Vienna, Austria 1994
Contribution Analysis, Vienna, Austria 1994
Outlet Selection, Vienna, Austria 1994
Promotion Analysis, Vienna, Austria 1994
Sales Budget, Vienna, Austria 1994
Finish Goods Inventory, Vienna, Austria 1994
Warehousing, Vienna, Austria 1994
Projects Administration and Control, Mexico City, 1994
RS6000 (Grocery Stores) Programming and Communications, Hamburg, Germany, 1992
RS7000 (Department Stores) Programming and Communications, Hamburg, Germany, 1992
7300 (Department Stores) Software Development , Dublin, Ireland, 1989
ADDITIONAL SKILLSLanguages• Advanced level, oral and written in Spanish, English and Portuguese.
Systems• ERP and MRP applications: MFG-Pro, SAE, SAP and BASIS (Coca-Cola proprietary)
• Microsoft applications: Advanced Office (Outlook, Excel, Word, PowerPoint), Project.
• Lotus Notes
• Language C.
• UNIX and OS/400 Operative Systems.
• Data Bases Management.
• Configuration and usage of diverse Windows and non-Windows based software.
Others• Professor of several credits at college level (UNAM and UVM).
• International experience on the field in all Latin America and Caribbean, USA, Ireland and Austria.