*** ***** **** *****, ******* Hills, CA ***** 818-***-**** ac0e0t@r.postjobfree.com

Shay Shalom

Objective

Multi-tasking, results oriented effective manger that moved through the ranks of IT management roles into Executive Managements of various companies. In additional to Application and DB Development skills, Shay poses myriad of business operation knowledge, transformed and created processes and procedures to maintain companies growth while maintaining stronger P&L and balance sheet at better than expected. Holds accountability with direct reports with KPI’s. Establishes strategic and tactical road-maps and detailed plans to execute on time and under budget.

Summary

AWS/SaaS

SQL-SERVER / T-SQL

SSRS, SSIS, Crystal Reports

Oracle / PL-SQL, Forms

AS400 / DB2, RPG, CL, SYNON

Modeling Tools / ERWIN, ER-Studio, Cool:2E

Data-Warehousing: Cognos, Brio

DB-Access: Store Procedures, Triggers, Functions

Data Architect

ERP Implementations (SAP-B1, Oracle, JDE, NetSuite, Epicor, Island Pacific, Others)

Project Management Skills / RAD, Agile, Scrum

Platforms / Windows Servers, AS400, Unix

Global Distribution

Manufacturing

Logistics

e-commerce / Social Marketing

Retail

Banking

Entertainment

Experience: Executive/ IT Director/ERP Developer/DB Administrator/Architect

02/2017 - Current

Golden Hippo Media

Calabasas, CA

IT Director

Golden Hippo Media is a parent company of several health products marketed on the web. Company rapidly grew via social media marketing to process in excess of 18,000 new orders a day.

Set IT strategy course to integrate new ERP solution to support growing e-commerce needs. Documented business process and conducted review meetings with SME’s to finalize requirements. Worked with vendors to set project timelines and pricing of applications.

Implemented Oracle-NetSuite as SaaS, interfaced with Shopping Carts and WMS/CRM applications

New applications to support multi-million daily orders with over 20,000 package fulfilments. Extended application to support over 400 Inbound/Outbound call agents in multiple call centers.

01/2009 - 01/2017

General Micro Systems

Rancho Cucamonga

Executive/IT Director/ERP Manager /DB Developer

GMS is a leader in Ruggedized Computers targeting Military/Aerospace market. Joined company to deploy next generation systems to support strategic business requirements of growth for a high technology manufacturing environment. A successful of implantation of new system allowed for over 100% increase in revenues within first year. Maintained strong business process mapping to applications in order allow continued growth and release of new functionalities. Developed multitude of web-based applications to enhance feature not found within selected ERP (Epicor).

Identified NEW ERP, using Scrum Methodologies implemented new system in 3 month

Expanded ERP functionality via Web-Applications via new Instance of MS-SQL utilizing Linked-Servers to access ERP DB

Utilizing T-SQL, SSRS, SSIS and Crystal reports developed dashboard KPI Reports

Revamped 100% of all companies operations, provided documentation and training for staff.

Assisted Quality team achieve AS9100C certifications, implemented 5S program

Participated with executive staff to set longer range strategic plans; executed extremely well to tactical plans measured and reported KPI’s and Actuals to Budgeted results.

02/2002 – 01/2009

ServiceCraft Logistics

Buena Park, CA

IT Director/Manager of Software Development

ServiceCraft is 3PL with over 15MM-SqFt warehouse space. Joined as a hands-on developer/consultant to manage new development of new WMS system; was offered key management position to oversee entire development activities after 6 months.

In charge of all Software development and database architecture with the internal and consulting staff of 10 people

Responsible for new generation software for Global 3rd Party Warehouse and Logistics Company.

Designed and developed large-scale DB2 database systems to handle RF Inbound Appointments and Receiving modules, as well as Directed Put Away and Automated Picks.

Revamped entire ERP system into WMS-V2 feature/options that brought the company into world class application. Allowed Sumitomo to invest millions of dollars into the company.

Created and implemented WMS system that allowed visibility and productivity reporting. System allowed for reduction labor requirements by 30%. Allowed greater planning abilities by 25%, which decreased space facility requirements for the same amount of work.

Designed developed and implemented SQL-Sever based data-warehousing application designed to report facility productivity

Migrated JDE-One World accounting package into SAP-Business One running SQL Sever

04/1997 – 10/2008

American Racings

Long Beach, CA

IT Consultant/DB Developer

ARE is global leader in specialized wheels. Served as a long term application development consultant responsible for all database administration and application development to support core manufacturing/distributions of custom wheels. Processed all application development as RAD (Agile methodology for Rapid Application development)

Managed data architecture to support all accepts of manufacturing including MRP, Demand Planning, Sales tracking/CRM applications

Utilizing CASE tool, designed large-scale relational DB2 database to support business requirements across all plants in the US.

Interfaced with PRMS ERP Systems

02/2001 – 01/2002

Mattel Toys

El Segundo, CA

Lead Application Systems

Overall responsibility included mapping Mattel’s various systems to the vision for next generation application system Global-One-Mattel system

Utilizing existing databases and user operational reviews, documented existing business/data process flow in order to map to new system. Evaluated data across DB2-400 and SQL Servers

Conducted RFI/RFQ for new Supply Chain processes while evaluating Oracle, i2, Manuagistics, Demantra

Evaluated forecasting models while conducting Gap-Analysis to exiting systems

03/2000 – 02/2001

iSuppli

El Segundo, CA

Application/Data Architect

The principle Database Administrator and Application Architect for DotCom Company. Interfaced multiple instances of JDE-Oracle to SQL Server Database where main engine for Supply/Demand Planning application resided.

Administrated Oracle hot-database mirroring from remote server to local. Utilized Oracle Triggers SQL-DTS services to import critical data to SQL-Server.

Utilized PL/SQL Stored procedures to access for data-warehousing for Demand Plans

Designed and managed implementation of Planner-Tool-Box which analyzed global demands to strategic supplies – created commitments records valued into millions of parts.

Developed strategic Capabilities Road Map for application feature releases

02/1993 – 05/2000

Toshiba Electronics

Irvine, CA

IT Consultant

Responsible for a large scale database, developed and maintained data structures for applications to global requirements. Originally signed 6 month contract which kept on being renewed due to excellence in service

Developed and Administrated 3000 entities data model. Tuned, backed up and provided applications to meet growing business requirements defined to global scale

Designed, Created and developed Bar-coded warehouse management system that reduced complex receiving system from 48 hours to less than 1 hour

Architected and developed process control system to monitor/evoke application tasks dependencies across multiple system of Unix-Oracle, Windows NT and AS400

Transformed AS400 and implemented Oracle 11i-ERP based system with full modules (Used TAVIS as ETL).

Utilized Oracle PL/SQL to develop complex data joins and manipulations from multiple Oracle Instances across multiple Unix and Windows servers

03/1995 – 07/1999

House of Fabrics

Sherman Oaks, CA

IT Consultant

While overlapping consulting engagements delivered a large scale database application that assisted HOF come out of Chapter-11 bankruptcy. As the principle DBA, utilizing CASE methodologies developed E/R model over 3500 entities – administrated all aspects of data integrities and application access.

Designed and developed Retail Inventory System RIS. Based on a rare yet accurate accounting method invented and used by large retailer.

Provided Daily Sales Analysis system – Allowed daily control of headquarters over all stores and mission-critical financial reporting.

Designed Price Adjustment Sub-System, facilitated Markup/Markdown price adjustments across the chain; reported financial impact to RIS.

Developed Store transfer and in-transit management system, allowed seamless store requests and transfers.

Designed Physical Inventory systems, which allowed each store to conduct PI and cycle counts; reconciled at HQ.

Designed and implemented all connectors to Island Pacific ERP and Infenium.

03/1994 – 10/1996

KCET

Hollywood, CA

IT Consultant

While overlapping consulting engagements developed and delivered database application systems to support membership services and phone based sales into Video Finder System

Designed and developed Video Finder System, used by public broadcast to take order and stage fulfillment.

Supported Call Center Operation using Call Path auto dialing system with automated scripting to allow marketers to sell products or services on line.

01/1991 – 03/1993

Countrywide

Pasadena, CA

IT Consultant

Overall responsibility included the design development and implementation of Correspondent Lending System. Project size was over 600 entities. Reported directly to a VP level in order to deliver to business requirement needs

Architected Correspondent Lending System for Mortgage Funding Group, and interfacing to a homegrown system.

Enabled a smooth growth for the funding process from 500 Mil/Month to 1.5Bil/Month.

1989 - 1995

Wynn Oil Company

Azusa, CA

IT Consultant

A large project that span multiple phases of implementation whereby an entire ERP application was designed, developed and delivered to support manufacturing and distributions which is still in use late as 2014. Project included over 4000 entities. Database had grown to Tara-bytes of information

Designed and developed a complete ERP solution from ground up with modules included for MFG, Distribution, AP, AR, GL, Order Management, Customer Management and Warranty services.

System had been designed to be Y2K compatible from day one.

Since implementation company has transacted millions of dollars of revenues with this system

System has paid itself many times over in past years. System still operational and critical to business operations 20 years later!

Education

05/1984

California State University, Northridge

Northridge, CA

Bachelors – Computer Science

Minor in math

References

References are available on request.

Contact this candidate