SUMMARY:

• Energetic and experienced IT Business Analyst with a strong technical and functional experience in IT focused on manufacturing environments, data analysis, requirements gathering, ERP analysis, manufacturing process, database administration/reporting and technology integration to manufacturing and warehouse processes.
• Fluent in English and Spanish, Green Card holder, with excellent presentation skills looking for a position where critical analysis and thinking are highly valuated.

TECHNICAL SKILLS:

Languages: C#, .Net, VB, Delphi 5ETL

RDBMS: MSSQL

PROFESSIONAL EXPERIENCE:

Confidential

IS Specialist - Project Manager

Responsibilities:

• Budget Analysis and definition
• Personnel Shift Management
• Business enablement between Toyota Baja California and Toyota North America

Confidential

IT Sr. Business Analyst (Coordinator)

Responsibilities:

• ERP Business Analyst in SAP system, gathering requirements for new reports and providing support on the daily usage.
• Provide orientation and to end users of SAP system for SCM and Manufacturing departments.
• Design and develop the EDI interface from Hisense WMS to Hisense SAP and vice versa.
• Provide leadership and development of the Business Applications area personnel in IT.
• Project manager and Analyst for the development of the Production Scanning System (own developed MES)
• Architected the Warehouse Management System for Finishgoods material
• Architected the SMT Manufacturing System to keep the traceability of the Main Board production from machine load to board warehousing.
• Work with SCM team to gather business requirements to prepare and deliver SAP reports for all functional areas and business units across the department.
• Architected the solution and managed the development of the abnormal production processes (Refurbish and Rework).
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, TSQL.
• Designed different reports with Crystal Reports reducing by 20% the manual work (excel) from production and warehouse departments.
• Designed the interaction interface between MES and SAP, following up with the interface development for the maintenance of the MES data (for manufacturing) and SAP data (for sales)
• Work with developers to coordinate the creation and management of reporting environments.
• Lead role in the planning, design and development of the application legacy migration from Delphi 5 to C#.
• Architected the migration of legacy databases reformatting and standardizing the structure.
• Administration of internal systems databases.
• Administration of vendor databases (Customs and Trade: SEERT, I-Xport. Human Resources: Tress)
• Developed and tested storage strategies plan for large manufacturing company’s operational database.
• Review and analyze China Factory systems and processes, and develop strategies for improve and implement in Mexico Factory.
• Implemented the current software management procedures for new development
• Lead the definition of IT Software process methodology for development, deployment and test. This allowed non-IT departments to understand the working process of the department.

Confidential

IT Business Analyst (Supervisor)

Responsibilities:

• Leaded the Upgrade from SAP GUI
• Reduced SAP users from, saving 10,000 USD per month in SAP support.
• ECNet first line of contact for purchasing PO process.
• Gathered technical and functional requirements for SAP procedures modification.
• Responsible for of production/warehouse SAP operators to ensure the understanding of the process and ensure the real time data within SAP and WMS.
• Designed the report for accurate material usage end date in BOM.
• Work with warehouse team to create and implement an interface between WMS and SAP.
• Leaded the release and cleanup of all the databases on the SQL 2008 and 2012 servers.
• Leaded the data migration project from Japan and New Jersey DB services to Tijuana.

Confidential

IT Software Developer

Responsibilities:

• Developed an End User Application to facilitate the entrance to all the in-house development systems through one standard interface, improving the user organization by removing the usage of more than 1 password for different applications (.NET/MSSQL)
• Design and develop the warehouse shipping system to keep control of all the FG that enters and exits from the warehouse (Delphi/.NET/MSSQL)
• Developed the manufacturing process reports and charts based on production times, shifts and models (.NET/MSSQL)
• MES (Packing Area)-Co-Lead the definition and development of the packing process system, used by production lines to validate the content of the packing reducing 600,000 USD yearly in reworks, inspection and repacking of finished goods (VB/MSSQL)
• Implementation of .NET application to ensure the integrity, allowance and location of the incoming and outgoing containers from the point they go out of the carrier facility to the time they leave SEMEX increasing Security Area performance by 30%, reducing the manual work by 70%.
• Rating based IT services implementation, increasing the IT department performance by having a work measurement tool that helps to improve over the services weak areas. Development made over an existing application, using Delphi 5 and SQL 2005/2008.
• Improved the old budget system and achieved the 100% control of the purchases in MRO by controlling any purchase requisition by establishing a total allowed budget and an authorization process from the requesting department to the purchasing department. Development made over a previous application, using Delphi 5 and SQL 2005/2008
• Analysis and deployment of stored procedures, triggers and tables normalization over legacy databases in MS SQL 2008.
• Migration of SQL Server 2005 databases to SQL Server 2008 and SQL Server 2012
• Replication for all the databases to ensure backups in case of emergency.
• Ad Hoc SQL complex query development and data extraction from different databases.
• Performed analysis of existing data sources by accessing data from MSSQL databases, Oracle databases, MySQL databases and Excel Spreadsheets.