Executive Summary
•	9 years of functional experience including 5+ years of solid Oracle ERP experience. Areas of interest and strength include Project Management and Oracle Applications Implementation and its Interface/ Integration with 3rd Party Software, including integration with Manufacturing Execution Software, Business Intelligence and customizations.
•	Completed 3 live Oracle Applications full life cycle implementations and 2 upgrade/support project.
•	Project Manager of 8 projects, including 2 full Oracle implementations of Oracle Manufacturing and Supply Chain modules. 
•	Team Leader for Oracle Manufacturing and Supply Chain Modules (Inventory, Work In Process, Bills Of Material, Planning, Production Scheduling, Order Management, Accounts Receivables, Warehouse Management, and Advanced Pricing).
•	Strong in using Oracle Application Implementation Method (AIM) for administering the implementations of Oracle ERP.
•	Solid knowledge in Oracle development tools: JDeveloper, BPEL, TOAD, and Application Express.
•	Solid knowledge in Microsoft development tools: Microsoft Visual Studio .Net, Microsoft SQL Server, Microsoft SQL Reporting Services, and their integration with Oracle technologies by using SOA related tools (Web Services, XML, Oracle BPEL, and Oracle Data Provider for .Net).
•	Country experience including USA and Mexico.
•	Excellent communication, team building and project management skills.
•	Skilled in developing new business, working-out solution proposals, and presenting executive Summaries and reports to managers and steering committees.
•	Business process–driven IT professional, hands-on experienced in reducing costs by implementing Oracle Manufacturing and Supply Chain Management processes for Mexico and US facilities, and increasing revenue by implementing Advanced Pricing solutions, and developing steel optimization algorithms.


Skills Summary
•	Project Manager Professional (PMP).
•	Oracle Applications Modules: INV, WIP, Planning (MDS/MPS/MRP), WMS, SCH, BOM, QA, OM, RLM, QP and AR.
•	Oracle Application Releases: 10.7, 11.5.8, 11.5.9, 11.5.10
•	Integration of Oracle Applications with 3rd Party MES and BI software.
•	Tools: TOAD, JDeveloper,SQL Developer, Application Express.
•	Languages: SQL, PL/SQL, Java, BPEL, XML, Microsoft VB.Net
•	Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including: BP040, RD010, RD020, CV010, BP080, BP090 RD050, BR010, BR020, BR030, MD020, BR100, BR110, MD050, MD060, MD070, CV040, CV060 TE020 and TE040.
•	Productivity Applications: MS Office, MS Visio, MS Project, Microsoft Enterprise Project Manager.



Oracle Apps Skills and Tools
•	Analysis and documentation of current business processes and future business flows, and identification of gaps and workaround.
•	Business Requirements Mapping for INV, OM, RLM, SCH, QP, AR, WMS, BOM, WIP and Planning.
•	Designing Oracle Applications Inventory Organizations and Operation Units - Multi-Org Setup.
•	Testing modules’ setup for inconsistencies and missing steps - Test scripts and User Acceptance Tests (UAT).
•	Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online -Oracle MetaLink and Oracle Applications Patch Management.
•	Setup of Inventory, Work In Process, Planning (MDS/MPS/MRP), Warehouse Management, Bills Of Material, Advanced Pricing, Accounts Receivable, and Order Entry.
•	Data Migration from Legacy systems – API’s and Open Interfaces.


Professional Experience

Client: Nike, Beaverton, OR
Industry:	Sports Equipment Manufacturing
Description: 	The world's leading supplier of athletic shoes and apparel and a major manufacturer of sports equipment with revenue in excess of $18.6 billion USD in its fiscal year 2008


Project:	ACS Project Management Office	February 2009 – Today
Role:	Project Manager at ACS (Affiliated Computer Services, Inc.)
Description:	Project Manager for the implementation of Infrastructure Outsourcing Services to multiple Nike sites around the world. Maintenance of contract budget records, tracking ACS cost and performance, including time sheet collection, verification, payroll/labor accounting, reporting and distribution. Preparation and initiation of contract billing, providing supporting documentation to secure payment for services and other deliverables provided to the client.

•	Integration of 4 Nike offices in China, Malaysia, Singapore and Brazil into de standard Nike IT infrastructure, including Remote Server Management and Help Desk routing strategies, in coordination with Nike, Siemens and ACS personnel.
•	Performed the integration of the Vellore, India sales office of Cole-Haan, Nike subsidiary, into Nike IT infrastructure including operations support through the Hong Kong Data Center and revision of the local support contractual agreement.
•	Performed the implementation of a new Bauer representative office in Taichung, Taiwan, including network infrastructure, servers, business applications, operations support, help-desk support and remote access to SAP applications. Negotiation of the commercial agreement with AT&T to provide a new MPLS network circuit for this office.
•	Performed the implementation of a new Bauer representative office in Irvine, California, including network infrastructure, servers, business applications, operations support and help-desk support.
•	Performed the implementation of the Remote Server Management business solution to a Cole-Haan site located in Manhattan, New York, including Mission-Critical monitoring strategies.
•	Performed the implementation of the Virtual Desktop Infrastructure (VDI) solution for Nike World Headquarters (NWHQ) to control the access and grants to External Temporary Workers (ETWs’).

Environment:	SAP, Windows NT, Networking services, Help Desk services, Business Process Outsourcing services, Microsoft Project, Microsoft Enterprise Project Server, Microsoft Office.


Client: Novem, Monterrey, Mexico
Industry:	Retail
Description: 	Novem, the biggest retailer of pools and water treatment systems in Mexico, with presence in the 13 main cities of the country and representative offices in McAllen Texas for their growing US market.


Project:	Implementation of Oracle e-Business Suite	September 2008 – November 2008
Role:	Senior Consultant
Description:	Implementation of the Manufacturing and Supply Chain Management modules of the Oracle e-Business Suite for the whole country operations. Migration of the business information from their legacy system to the new Oracle ERP. 

•	Involved in the definition of the transition strategy from their legacy system to the new ERP.
•	Definition of Inventory and Planning strategies. Guidance to the team that implemented these modules.
•	Implementation of Oracle Advanced Pricing for calculating the final price of products based on modifiers, qualifiers and pricing formulas, according to the customer’s business rules.
•	Use of Oracle API’s for loading price lists.
•	Implementation of Oracle Account Receivables to manage clients, accounts, invoicing, credit and debit memos, and transaction types to determine the accounting distribution.
•	Implementation of Oracle Order Management for quoting and selling products and dealing with returns and spare service orders. Definition of defaulting rules, OM transaction types, integration with AR transaction types, and definition of processing constrains for sales orders.
•	Personalization of native Oracle forms by using the integrated Oracle 11.5.10 Custom Code functionality
•	Configuration of Order Management and Accounts Receivables to support custom workflows, according to the customer’s business rules, and implemented by using the Oracle Workflow developer tool.

Environment:	Oracle e-Business Suite 11i, Oracle AIM, Oracle DB 10g, SQL Queries, Oracle Metalink, Oracle Workflow.



Client: Schlage (Ingersoll Rand), Tecate, Mexico
Industry:	Manufacturing
Description: 	Part of the centenary Ingersoll Rand Company and with worldwide presence. For over 85 years Schlage has provided homeowners with innovative quality security products. Schlage offers home security solutions from a wide selection of mechanical and electronic security locks and accessories.


Project:	Implementation of Oracle e-Business Suite	April 2008 – September 2008
Role:	Project Manager
Description:	The objective of the project was to reduce the Outsourcing Service Providers (OSP) dependence by building a new manufacturing plant, integrating a three stages supply chain (all of them Schlage plants), where the new plant became the middle stage. Oracle e-Business Suite was implemented for the new plant based on their highly customized Oracle ERP along with other legacy systems of the current manufacturing plants (supplier and customers of the new three stages arrangement). The new high-tech plant required the definition of new business process and operation procedures.

•	Leader of the implementation of the Manufacturing and Supply Chain Management applications of the Oracle e-Business Suite, including Work In Process, Planning, Production Scheduling, Shipping, Order Management, Bills Of Material, Inventory and Costing.
•	Conduction of Conference Room Pilots (CRP) events for testing the solution with the whole organization involved in running and validating their business process, including internal suppliers and customers.
•	Definition of inventory levels and safety stocks. 
•	Modeling of the inventory consumption curve based on the ABC classification of products for both the input and the output of the system.
•	Implementation of the Kanban (pull) inventory strategy, fully supported in Oracle Inventory, Oracle WIP and legacy systems.
•	Definition of manufacturing departments and resources, work calendar, working time and lead times.
•	Participation in defining the ramp-up, ramp-down plan for a gradual replacement of the material sourcing from OSP’s with internal production.
•	Conduction of Kaizen events for defining the new suppliers – new plant, new plant – customers, and internal work instructions.
•	Training to key users.

Environment:	Oracle e-Business Suite 10.7, Oracle AIM, Oracle DB 9i, SQL Queries, Oracle Metalink.

 

Client: Metalsa, Monterrey, Mexico and Roanoke, VA (as External Consultant)
Industry:	Automotive
Description: 	Metalsa, founded in 1956 and part of the Proeza Group, with locations in Mexico, United States, India, China and Japan, provides auto parts and structures for light and heavy vehicles for worldwide customers like Toyota, Nissan, Ford, Chrysler, Volvo, Mack, Kenworth, International, and Freightliner.


Project:	Implementation of Oracle Warehouse MS	January 2008 – April 2008
Role:	Project Manager
Description:	Implementation of Oracle Warehouse Management System, including the Oracle Mobile GUI for executing standard inventory transactions through hand held devices. Customization of the native Oracle Mobile screens to fit the customer’s requirements and business rules, integrating the bundle concept –pretty much the LPN concept but without the LPN constrains.

•	Definition of business requirements for Oracle WMS and Oracle Mobile.
•	Design of the Java-based, custom Oracle Mobile screens.
•	Definition of the transition plan for implementing Oracle WMS in an existing Oracle Inventory Organization, including the configuration of Oracle Inventory, Oracle Purchasing, Oracle Order Management and Oracle Shipping to suite the implementation requirements of Oracle WMS.
•	Configuration of Oracle WMS and Oracle Mobile.
•	Guidance to the programmers for customizing the Oracle Mobile screens, according to the business requirements. Customized, Java enabled screens where in pursuit of more friendly, less steps GUI’s to accomplish day-to-day inventory operations.
•	Integration with the Shipping legacy application.

Environment:	Oracle e-Business Suite 11i, Oracle JDeveloper, Oracle DB 9i, Java 4, Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Standardization of Oracle Shipping Process	October 2007 – January 2008
Role:	Project Manager
Description:	Standardization of the shipping processes for Mexico and United States facilities through a new Shipping Application, as a basis for the expansion of Metalsa in India. Solution fully integrated to Oracle Manufacturing and Supply Chain Management. The solution provided: a Flatbed Configuration Workbench to define which sales order lines to load on each shipping flatbed; an Orders’ Monitor to publish the sales order lines’ status in such way that allows to the Organization to follow-up the production and shipping process in detail for each customer’s order; a Shipping Scheduling Workbench to define the traffic plan for each flatbed, and a Shipping Monitor to publish the shipping process and status in a glance.

•	Conduction of the workshops with the customers in both Mexico and United States facilities to define the standardized processes.
•	Design of the whole solution, including the web based application, the integration with Oracle e-Business Suite and the configuration of Oracle Shipping and Oracle Order Management to suite the solution.
•	Definition of the integration with the Manufacturing Execution Systems (MES) of both Mexico and United States facilities, in order to provide bundling information to those systems.
•	Design of a web based, graphic representation of the flatbeds to be shipped, according to the business rules defined with the Operations in Mexico and United States Logistics departments. Business rules consider weight restrictions, constrains based on particular products attributes, load balancing, sorting criteria and undo activities.
•	Guidance and mentoring of the programmers to develop the web application in Java 5 and NetBeans 5, including AJAX for dynamic HTML rendering.

Environment:	Oracle e-Business Suite 11i, Oracle JDeveloper, NetBeans, Oracle Application Server 10g, Oracle DB 9i, Oracle SQL Developer, Web Services, Java 5, AJAX, Microsoft Visual Basic .Net, Microsoft SQL Server 2005, Microsoft IIS, Microsoft Project, Microsoft Enterprise Project Manager.

Project:	Invoicing Reconciliation 	September 2007 – October 2007
Role:	Senior Consultant
Description:	Due to the mass customization production environment and to a strategy to define the final products’ price based on customized product attributes, the solution matches the Oracle Order Management final selling prices and Oracle Accounts Receivables invoicing, credit and debit memos, for a correct accounting distribution that considers the custom price for each product. The solution was integrated to an extension of Oracle Accounts Receivables that splits a KIT in its different components and applies the payments, credit and debit memos according to the custom price.

•	Definition of business requirements.
•	Design of the solution, including the final price engine implemented in Oracle Advanced Pricing.
•	Design of the integration with the Accounts Receivables extended application.
•	Guidance to the programmers to implement the integration.
•	Configuration of Oracle Advanced Pricing to suit the solution.

Environment:	Oracle e-Business Suite 11i, Oracle JDeveloper, Oracle Reports, Oracle DB 9i, Microsoft Excel (including Visual Basic for Applications), Microsoft Project.


 

Client: Semaforos Mexicanos, Monterrey, Mexico
Industry:	Manufacturing, Installation Services
Description: 	Semex, established in 1960, is the leading traffic-control product and service company on the Mexican and Central American markets, and with growing operations in United States. Their products include traffic signs and lights, traffic controllers and roadwork protection signals, along with the installation services of those products.


Project:	Inventory Management for long WIP services	June 2007 – September 2007
Role:	Senior Consultant
Description:	Once the final client confirms a sales order, the Inventory Control department releases the products to the installation teams. This project implemented a solution to control the inventory quantities in the hands of the installation teams, which requires from one day to months for finishing the installation, meaning a long Work In Process period. The solution modeled each installation team as an Oracle subinventory, controlling the products and quantities through subinventory transactions, move orders and WIP completions.

•	Design of the solution, including an extension to the native Order Management, Inventory and Work In Process Oracle applications by using Oracle Forms.
•	Configuration of Oracle Order Management, Inventory, Work In Process and Shipping modules.
•	Alignment of the Engineering, Manufacturing and Inventory Management departments to adopt the new solution.
•	In charge of presenting the project status to the Steering Committee.

Environment:	Oracle e-Business Suite 11i, Oracle AIM, Oracle DB 10g, PL/SQL, Microsoft Project.



Client: Metalsa, Monterrey, Mexico and Roanoke, VA (as Employee)
Industry:	Automotive
Description: 	Metalsa, founded in 1956 and part of the Proeza Group, with locations in Mexico, United States, India, China and Japan, provides auto parts and structures for light and heavy vehicles for worldwide customers like Toyota, Nissan, Ford, Chrysler, Volvo, Mack, Kenworth, International, and Freightliner.


Project:	Redefinition of the Shipping Process for Mexico facilities	March 2007 – May 2007
Role:	Project Manager
Description:	This solution provided guidance on the production and material management priorities in order to deliver on time and well-configured shipments for any kind of product. The solution included a workbench to schedule shippers, considering actual customer’s orders, on-hand quantities, ship dates, flatbeds’ weights, product types, and customers’ shipment business rules. The functionality provided include configuring flatbeds as Oracle standard trips, assure ship date accomplishment, generate picking and packing programs, cancel or change sales orders, and change ship dates. Along with the shipment schedule workbench, this solution provided a shipping monitor to show the information for each scheduled shipper. This monitor provides status for scheduled departures (ready, shipped, in-transit, received, etc), expected sales for the week, expected sales at the current date and time, actual sales, sales’ accomplishment (percentage), shipped orders’ accomplishment at both week and order level, customers’ orders, on-hand quantities identifying sub-inventory and locator, delivered orders, pending quantities to ship, ship date, ship to location and products’ weight.

•	Definition of business requirements in coordination with Logistics department.
•	Design of the solution, including the integration with Oracle Manufacturing and Supply Chain Management modules: Order Management, Inventory, Shipping and Warehouse Management System. Integration with the Manufacturing Execution System through web services.
•	Responsible of presenting the project status to the Steering Committee. Final responsible of the success of the project.
•	Guidance to the programmers for developing hand held oriented screens.

Environment:	Oracle e-Business Suite 11i, TOAD, Oracle DB 9i, Microsoft Project, Microsoft Enterprise Project Manager, Web Services developed with Microsoft Visual Basic .Net, Microsoft SQL Server 2005.



Project:	Definition of intercompany Capacity Model 	January 2007 – March 2007
Role:	Business Analyst
Description:	Process mapping of the existing capacity models of Mexico and United States plants, and definition of an integrated capacity model for the whole organization, useful as an input for the Sales and Operations Planning process to determine a better intercompany load balancing and distributing new projects considering the lowest cost and the highest profitability. This effort includes Finance, Logistics, Manufacturing and New Product business processes.

•	Mapping of the capacity models of each plant.
•	Definition and mapping of the new intercompany capacity model.
•	Functional design for implementing the Oracle Rough Cut Capacity Planning application for United States and Mexico locations.
•	Analysis of the impact and definition of the integration of Oracle RCCP to the rest of the Oracle Manufacturing and Supply Chain Management modules.
•	Guidance to the process owners for implementing the solution.

Environment:	Oracle e-Business Suite 11i, Oracle DB 9i, Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Implementation of Oracle Advanced Pricing 	October 2006 – January 2007
Role:	Senior Consultant
Description:	Solution implemented for United States facilities. Final clients send standard 866 EDI documents to define the shipping sequence for the orders they request to Metalsa. This information comes in the first place into Oracle e-Commerce Gateway and Oracle Release Management. The clients also send custom specifications for each item they order. These custom specifications, named “geometries” are handled by a legacy system. Both the 866 EDI and the geometry documents are merged by an Oracle BPEL process that orchestrates the business rules for releasing sales orders into Oracle Order Management (bypassing the Oracle Demand Processor). The custom specifications come into Order Management as pricing attributes. In turn, the Oracle pricing engine calculates the final price for each product in a sales order through dynamic pricing formulas.

•	Definition and design of the pricing strategy based on pricing attributes and pricing formulas.
•	Redesign of the current integration strategy of Oracle Release Management, Oracle Order Management and the “geometries” legacy system by using Oracle BPEL as the orchestrator of non-standard business processes.
•	Configuration of Oracle Advanced Pricing and Oracle Order Management for implementing the pricing strategy.
•	Analysis of the Return Of Investment for the project, resulting in a more than 500% ROI considering a 5 years amortization.
•	Configuration of Oracle Inventory to avoid creating new items due to new finished good configurations.
•	Guidance to the programmers to implement the Oracle BPEL process flows based on business requirements.

Environment:	Oracle e-Business Suite 11i, Oracle JDeveloper, Oracle BPEL, Oracle DB 9i, Microsoft SQL Server 2005, Microsoft Excel (including Visual Basic for Applications) , Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Redefinition of the Order To Cash Business Cycle 	March 2006 – September 2006
Role:	Project Manager
Description:	The Order To Cash business cycle, mostly supported by Oracle Manufacturing and Supply Chain Management modules, required an extensive integration with non Oracle applications. Oracle BPEL was incorporated as the orchestrator for non-standard workflows and for integration with third party and legacy applications. The integration included Oracle Order Management, Oracle Release Management, Oracle Shipping, Oracle Planning, Oracle Inventory, Oracle WIP, and the Manufacturing Execution Systems (MES) of two plants in United States and one plant in Mexico.

•	In charge of evaluating solution proposals.
•	In charge of defining the Return Of Investment of the project.
•	Project manager, in charge of the implementation team (twelve members), and following the Oracle Application Implementation Method (AIM).
•	Guidance to the functional consultants and developers to meet the business requirements.
•	Responsible of the functional design of the solution, considering the reconfiguration of the following Oracle modules: Oracle Order Management, Oracle Release Management, Oracle Shipping, Oracle Planning, Oracle Inventory and Oracle WIP, and the incorporation of phantom items, new processing rules and disabling and bypassing the Demand Processor for Mass Customization items.
•	Responsible of the technical design for the incorporation of Oracle BPEL and the integration model of the Oracle Modules and the legacy applications.
•	Responsible of presenting the project status to the US Steering Committee. Final responsible of the success of the project.

Environment:	Oracle e-Business Suite 11i, Oracle BPEL, TOAD, Oracle DB 9i, Oracle Reports, Microsoft SQL Server 2003, Microsoft Excel (including Visual Basic for Applications) , Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Stabilization of Oracle e-Business Suite 	August 2005 – April 2006
Role:	Oracle Support Center Manager
Description:	Once implemented for the first time, the Oracle e-Business Suite required fine tuning and business processes revisions, as well as the implementation of the daily-basis Support and Continuous Improvement processes and the creation of a knowledge base for a rapid solution to common problems.

•	In charge of tracking the stabilization process and presenting results to the steering committee.
•	In charge of selecting and defining roles and responsibilities for the Oracle Support Center team members.
•	Responsible for supervising and evaluating contractors’ duties and deliverables, and for approving their payments.

Environment:	Oracle e-Business Suite 11i, TOAD, Oracle DB 9i, Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Implementation of Oracle e-Business Suite 	August 2004 – July 2005
Role:	Project IT Manager
Description:	Implementation of the Manufacturing and Supply Chain Management applications of the Oracle e-Business Suite for United States and Mexico manufacturing locations, including: Order Management, Release Management, Demand Planning, e-Commerce Gateway, Work In Process, Manufacturing Scheduling, Inventory, Planning (MDS/MPS/MRP), Shipping Execution, Accounts Receivables, Cost Management, Bills Of Material, Engineering, Quality Management and Pricing. The primary objective of the project was the redesign of Metalsa’s processes looking for flexibility, standardization, interplant collaboration, and best practices replication according to Metalsa’s global growth plans, enabled by an integrated platform.

•	Member of the team that defined the high-level business needs statement for delivering a Request For Proposal.
•	Member of the team to research the ERP that best suited the Metalsa business requirements, and evaluation of vendors’ solution proposals.
•	Member of the team that calculated the Return Of Investment of the project, resulting in more than 200% considering a five years amortization period.
•	IT Manager of the project. Responsible for presenting the technical solution to the Steering Committee.
•	In charge of a twenty members developer’s team. Guidance to the developers to meet the business requirements.
•	Definition of business requirements for the integration of Oracle e-Business Suite and the third party and legacy systems: Manufacturing Execution Systems of three plants, the Orator legacy system for handling mass customization production data, Datakits legacy system for handling engineering information and operations information, and Loftware for label printing.
•	Risk Assessment and definition of the risk mitigation and contingency plans.
•	Responsible for the information migration and data load processes, from the Manufacturing Pro ERP to Oracle ERP. Guidance to the data load team on defining the strategy to perform these activities.
•	Validation of the functional designs, ensuring they consider the integration strategy and requirements.

Environment:	Oracle e-Business Suite 11i, Oracle JDeveloper, TOAD, Oracle DB 9i, Microsoft SQL Server 2003, Microsoft Excel (including Visual Basic for Applications) , Microsoft Project, Microsoft Enterprise Project Manager.



Project:	Optimization of steel 	January 2004 – July 2004
Role:	Project Manager
Description:	The mass customization production environment for manufacturing chassis requires steel coils as raw material, and the output is a “C” shape steel rail with a custom length according to the clients’ “geometry” document. The objective of this solution was to reduce the waste of steel by programming each coil with an optimized combination of custom length rails, but without messing the production sequence. The solution reduced the wasted steel from 10% to less than 2% in a 200 Tons of daily steel consumption environment. The solution considered the on-hand inventory from the Manufacturing Pro ERP, and integration to the production tracking system of the MES.

•	Definition of the high-level business requirements to deliver the Request For Proposal to external suppliers.
•	Evaluation of the vendors’ proposals, including system suppliers, hardware suppliers and manufacturing automation contractors.
•	Analysis of the Return Of Investment for the project, resulting in a more than 1000% in a 3 years amortization period.
•	Design of the mathematical algorithm to ensure an optimized use of each steel coil and the accomplishment of promised delivery dates to final clients. Unified Modeling Language (UML) was used for modeling the solution.
•	Responsible for aligning Logistics and Operation departments in order to support the new solution.
•	Responsible for building a sequencer mechanism in order to regroup all the rails that belong to a same chassis.
•	Responsible of integrating the new sequencer to the production line, including the physical structure, control systems and the integration to the Manufacturing Execution System (MES) for tracking the production process and storing the product’s genealogy.

Environment:	Microsoft Visual Basic .Net, Microsoft SQL Server 2000, T-SQL programs, PLC Ladder programs, RS Logix, Microsoft Project, UML.


Project:	Statistical Process Control for manufacturing indicators 	August 2003 – December 2003
Role:	Senior Developer
Description:	Development of a web based SPC tool for analyzing the manufacturing statistics. The project included the integration to the Manufacturing Execution System for getting the statistical information, and the rendering of standard X-R, Histogram and Pareto graphical representation of such information. Once the solution was implemented, and based on the SPC analysis, the Quality department certified or rejected the production lot. Initial analyzed variables included the steel hardness of heat-treated products, physical dimensions and visually detected out of specification conditions. 

•	Preparation of solution proposal to the Quality department.
•	Design and development of the solution by using UML and Microsoft Visual Basic .Net languages.
•	Integration of charts by using Chart FX.
•	Design and development of the database components, including tables, stored procedures and entity-relationship links, using Erwin Data Modeler with deployment in Microsoft SQL Server 2000.
•	Deployment of the solution in Internet Information Services (IIS) web server.

Environment:	Microsoft Visual Basic .Net, Microsoft ASPX,T-SQL, Microsoft SQL Server 2000, Chart FX, UML, Erwin.


Project:	Datakits Processing System 	January 2003 – July 2003
Role:	Project Manager
Description:	Final clients send tech specs for mass customization products as non-standard “geometry” documents. The geometry defines in detail the physical attributes of each chassis, along with shipping sequences and dates. The Orator (legacy) system receives such documents and converts it in a standard document called datakit. This project consisted in developing a solution to process the datakit documents, to provide a web-based workbench to Engineering department to setup punching standards based on drawing codes, to provide to the Operations department a web-based solution to follow-up the production and shipping sequence based on the datakit dates, and to provide a graphical representation of the final configuration of flatbeds based on datakits information. In addition, the solution included an engine for evaluating business rules, in such way that conditions out-of normal operational constrains send alerts to the specific personnel, according to a configurable business rule, alert message matrix.

•	Definition of the high-level business requirements to deliver the Request For Proposal to external suppliers.
•	Evaluation of software vendors’ proposals.
•	Definition of detailed business requirements and functional design, including the business rules engine and the integration with the Orator legacy system and the Manufacturing Execution System. Unified Modeling Language (UML) was used for modeling the solution.
•	Design of the entity-relationship data model with Erwin Data Modeler.
•	Development of the Datakit Processing engine for storing the datakits information in a Microsoft SQL Server 2000 database.
•	Development of a process to create the punching programs for making holes in the chassis, and the communication to the CNC modules to execute such punching instructions, developed with Microsoft Visual Basic .Net.
•	Guidance to the programmers for developing the web applications according to the business requirements and definitions.
•	Responsible for aligning Engineering, Logistics, Operations and Quality departments in order to support the new solution.
•	Final responsible of the success of the project, reporting to the Logistics Manager.

Environment:	Microsoft Visual Basic .Net, Microsoft ASPX, Microsoft SQL Server 2000, UML, Erwin.


Project:	Web based, Human Machine Interface (WebHMI) 	October 2002 – January 2003
Role:	Senior Developer
Description:	Web based solution for representing the shop floor conditions at any moment. The solution included a graphical overview of the shop floor, with real time conditions and production status. Though a web browser, the Operations department could follow up the production process, evaluating the load of each work center and determining the position of each rail in the production lines. The solution also indicates the operational variables of the main work centers, out-of control conditions and the tack frequency of the production lines.

•	Definition of the high-level business requirements to deliver the Request For Proposal to external suppliers.
•	Evaluation of control and automation vendors’ proposals.
•	Definition of detailed business requirements and functional design, including the integration with the new MES solution and the USData XFactory OPC Server.
•	Development of an asynchronous JavaScript process for rendering XML files to a web server and delivering the Web HMI pages to the browser.
•	Development of a Microsoft Visual Basic 6 module for logging Control Logix driven PLC’s data to a Microsoft SQL Server 2000 database.
•	Design of the Web HMI screens and guidance to the external developers to achieve business requirements.

Environment:	Microsoft Visual Basic .Net, Microsoft ASPX, T-SQL, Microsoft SQL Server 2000, USData XFactory OPC Server, RS Logix software.


Project:	Manufacturing Execution System (MES) 	July 2002 – October 2002
Role:	Senior Developer
Description:	The MES project consisted in developing a solution to provide a production schedule to the manufacturing lines, tracking the products during the work-in-process phases, to generate the product’s genealogy of manufacturing indicators and variables, to maintain in-sync the control system and to provide to all the shop floor related departments with tools an reports to help them take the right decisions for running the plant.

•	Member of the team that defined the high-level business requirements.
•	Member of the developer’s team, in charge of defining the integration of the MES solution with the Manufacturing Pro ERP.
•	Definition of tech specs for the external developers in order to accomplish the business requirements.
•	In charge of the quality assurance of the programs and other deliverables from external developers.

Environment:	Microsoft Visual Basic .Net, Microsoft ASPX, T-SQL, Microsoft SQL Server 2000.




Client: GE Power, Monterrey, Mexico
Industry:	Manufacture
Description: 	GE Power, a division of General Electric, works in all areas of the energy industry including coal, oil, natural gas and nuclear energy, as well as with renewable resources such as water and wind energy.


Project:	Maintenance to the Configure To Order Application 	January 2002 – June 2002
Role:	Team Manager
Description:	Softtek’s Near Shore® outsourcing services for GE Power to provide a continuous improvement process to their Configure To Order application, through which GE configures transformers, airplane turbines, energy converters, and any GE Power product for the global market.

•	In charge of leading the developers team, their assignments, progress and productivity.
•	In charge of managing the Request Of Change from GE Power personnel, located in Atlanta GA.
•	In charge of presenting key performance indicators and results to the customer and to the Softtek Operations Director.

Environment:	GE Power legacy system, Microsoft Project.





Client: Tec de Monterrey, Monterrey, Mexico
Industry:	Education
Description: 	The Tec de Monterrey is a Mexican private educational institution that was founded in 1943. At the present time it has campuses distributed throughout the country, and academic centers in Mexico and other Latin American countries; it also has international offices in North America, Europe, and Asia. Through its Virtual University it is present all over the world, by means of learning networks and advanced information technologies.


Project:	Implementation of Onyx Customer Portal	September 2001 – December 2001
Role:	Junior Consultant
Description:	The Tec of Monterrey offers manufacturing services to the public and private industry. Through the web based, Onyx Customer Portal, the clients can request technical information, quotations, buy a product or service (manufacturing services, training courses), request support activities for their projects and resolve issues related with the products and services offered by the Manufacturing Center. 

•	Configuration of the Onyx Customer Portal, including customer’s catalog, service and support issues, quality surveys and employees.
•	Development of extensions to the original functionality, in order to implement custom workflows for approving projects and quotations.
•	Configuration of Symantec WinFax 10 for massive broadcast of faxes to the clients.
•	Training to Onyx Customer Portal Administrators
	
Environment:	Microsoft Visual Studio 6, Microsoft SQL Server 2000, Microsoft IIS, Microsoft Visio, Onyx CRM.




 

Client: Grupo Garza Ponce, Monterrey, Mexico
Industry:	Construction 
Description: 	With country wide presence, Group GP was founded more than 40 years ago in Monterrey, participating in the construction business, and it was a pioneer in the professional structuring of construction projects both for the private and public sectors. Today, Group GP is structured into 4 divisions: Construction, Real Estate Developments, Housing, and Urbanization.


Project:	Implementation of Onyx Employee Portal	May 2001 – September 2001
Role:	Developer Analyst
Description:	Implementation of the Onyx Employee Portal as the Customer Relationship Management tool for controlling the selling front desk operations, including the customer’s catalog maintenance, selling and follow-up activities, support and issues resolution.

•	Configuration of the CRM Employee Portal, including employees, roles, customer’s catalog, and workflows.
•	Development of extensions to the original functionality, in order to implement custom workflows to fulfill house building Mexican regulations.
•	Training to final users.

Environment:	Microsoft Visual Studio 6, Microsoft SQL Server 2000, Microsoft IIS, Microsoft Visio, Onyx CRM.





Client: Softtek, Monterrey, Mexico
Industry:	IT Services
Description: 	Founded in 1982, Softtek is a global provider of IT and business process solutions with over 6,000 associates across 30 offices in North America, Latin America, Europe and Asia, with eight Global Delivery Centers in Mexico, Brazil, Spain and China.


Project:	Implementation of Operations’ Scorecards	September 2000 – May 2001
Role:	Junior Developer
Description:	Web based solution for publishing projects and support operations scorecards. The scorecards and dashboards included key performance indicators for measuring progress, productivity, rework rates, team members’ compensations, On Time Delivery rates, costing and revenue for each project and support assignment.

•	In charge of developing the scorecards web application, according to the defined business requirements.
•	Development of scorecards and dashboards by using the Microsoft Office Web Components (OWC) and Microsoft ASPs.
•	Definition and development of the database components and programs by using Microsoft SQL Server 7 and T-SQL stored procedures.
•	In charge of the maintenance and continuous improvement process for the solution.

Environment:	Microsoft ASP’s, Microsoft SQL Server 7, Microsoft IIS, Excel (including Visual Basic for Applications), Microsoft Office Web Components, XML.



Education
•	Tec de Monterrey, Campus Monterrey, Mexico – B.S. Electronic Systems Engineering.


Certifications and Continuing Education
•	Project Management Professional Certification (PMP).
•	APICS CPIM – Certified in Production and Inventory Management (in process).
•	Internal Auditor for ISO/TS16949 – Automotive industry quality standard.
•	APQP – Advanced Product and Quality Planning for the automotive industry.
•	Oracle Advanced Pricing – Oracle University, Chicago, IL.
•	Training in Software Engineering Techniques for Analyzing, Designing and Developing Business Solutions – Softtek, Mexico.