18 years of analytical experience in OxyChem Logistics, Customer Service, Sales, Marketing, Purchasing, and Demand Chain Planning. Proficient in data warehousing, building analytical tools and automated reports, designing and implementing custom systems to improve business processes and measure KPIs, developing data extracts from SAP, and managing team sites. Tools used - Spotfire, SSRS reporting, Crystal reports, MS Access, advanced Excel, Informatica, SharePoint, Bizagi modeling, Toad, Oracle, SQL, SAP, and SAP BW. Experienced in SAP and CRM implementation. Experience Senior Supply Chain Analyst - OxyChem. 2003-present Support Customer Service, Rail Operations and Commercial, Truck Operations and Commercial, Purchasing, Marketing, and Demand Chain Planning reports, systems, and team sites. Maintain Supply Chain data warehouse - create custom data extracts from SAP via Informatica, write views. Develop new analytical tools as required by the business, automate processes, design workflows in SharePoint, set up integration between SharePoint lists, MS Access, Excel, Spotfire. Coach recently hired analysts and train users in Excel, Spotfire, SharePoint, and MS Access. Provide data analysis and coordination for Sales and Marketing budget process and loading data into SAP. Provide project management and analytical support for implementing custom systems and process improvements. Past projects, system design and implementation: CRM - team lead on Contacts and accounts team. Data provider and designer for CRM pricing module.
Systems Integration Consultant January 2000 to January 2003
Ship Point Directory - on-line and mobile application to display OxyChem shipping facilities, contacts, and products.
Used by Customer Service, Sales, Logistics.
Terminals/Warehouses Contract system, containing contracts details and providing notifications for contract's expiration.
Customer Survey - on-line system for customer feedback.
Daily Railcar Prioritization system - rail order prioritization, used by plants and demand chain planners to prioritize shipments via rail.
Connect 2 (on-line customer order management system).
Supply Chain Metrics and Savings system and reports.
Lead integration between SAP and i2 SCM solutions using i2 ROI, Rhythm Link, Informatica, and web Methods, on UNIX platform.
Developed data warehouse in Oracle and user interfaces in MS Access and Excel.
Provided user support and training.
Developed Informatica data extract from SAP such as sales orders, purchase orders, shipments, and freight payments.
Collected data in the Oracle data warehouse, later used to develop Supply Chain KPIs for Logistics, Demand Chain Planning, and Customer Service.
Supported earlier versions of SAP and I2 integration solution, utilizing IDOCs, POI interfaces, SQL server, Rhythm Link.
Consultant January 1998 to January 1999Accenture － Dallas, TX.
Systems Analyst January 1997 to January 1998Systems Implementer - OxyChem － Dallas, TX.
monitored background processes in SAP, provided issues resolutions and Help Desk support.
Functional lead on Batch Implementation team - developed, setup, documented, tested, and supported background jobs for MM/PP and FI/CO modules, subcontractor processes, and i2 data extracts; coordinated communications with users to provide data requirements gathering and analysis; coordinated timely issues resolutions; conducted user training; developed Disaster Recovery Procedures for MM/PP module.
Business Analyst on MM/PP functional team - participated in design and development of subcontractor processes in SAP.
Business analyst on Systems Test team - developed testing scenarios and procedures for MM/PP module.
Sales and Operation Planning team on SAP implementation project.
Business in business modeling, system prototyping, integration testing, implementation, and go live.
Configured S&OP module and integrated parts of MM, SD, PA; Analyzed business requirements and created functional designs for custom reports in SAP; Developed reports in PA; Developed test scripts and conducted system test in S&OP and MM; Developed training materials and conducted end user training; Designed and developed master data collection database for i2/SAP integration project using MS Access and MS SQL server.
Information Administrator January 1995 to January 1997Dallas, TX.
Designed, developed and managed Forecasting System database and user interface for PVC marketing, using Visual Basic, Access, MS SQL Server.
Developed reports for PVC marketing managers, production schedulers, sales forces, and Vice President of the department.
Monitored forecasting process with sales regions, sales forces, and headquarters.
Master of Science : Physics Math, 2003Dallas, TXPhysics Math Department of Experimental Physics, State University of Kharkov, Ukraine.
*Basics of Supply Chain Management, Master Planning of Resources, Detail Scheduling and Planning - CPIM education classes
I2 Technologies i2 SCM 5.2 Architecture - Dallas, TX - 2001. Rhythm Optimized Integration for SAP R/3 - Chicago, IL - 2000. ADW/CDM - Dallas, TX - 2000. Rhythm Link Intermediate Advanced - Chicago, IL - 2000.Accenture Schools Business Analysis and Design. St. Charles, IL - 1999. IBSS - Implementing Business Solutions - St. Charles, IL -1998. Fundamentals of Procurement - St. Charles, IL -1998. SAP Schools LO510 - 4.0 Inventory Management - Atlanta, GA - 1999. Management LO935 - Logistics Information Planning - Calgary, Canada - 1998. SAP R/3 Functional overview, MM/PP training, ABAP - Origin Technology, Dallas, TX - 1997. Continued Education HTML Programming - Richland College, Dallas, TX - 2000. SQL Programming - Collin Community College, Plano, TX - 1997. Developing applications in ACCESS, Excel Macros, Lotus Notes - Executrain, Dallas, TX - 1996-1997. Developing Windows applications with Visual Basic - Richland College, Dallas, TX - 1997. Database Management, UNIX, DBASE III - Career Development Institute, Dallas, TX - 1992.
ABAP, go live, ADW, Business Analyst, Business Analysis, business modeling, Business Solutions, contracts, Customer Service, data collection, data warehouse, database, Database Management, DBASE III, Disaster Recovery, Forecasting, Functional, Help Desk support, HTML Programming, Informatica, Inventory Management, Logistics, Lotus Notes, Macros, marketing, ACCESS, MS Access, Excel, PP, Windows applications, 2000, Oracle, order management, Physics, processes, Procurement, Programming, prototyping, requirements gathering, Sales, SAP, SAP R/3, SD, Scheduling, scripts, shipping, MS SQL Server, SQL, SQL server, Supply Chain, Supply Chain Management, user training, user support and training, training materials, UNIX, user interface, Visual Basic