SUMMARY:

Confidential is a top - notch Confidential and MS SQL Server expert with hands-on experience with hundreds of ERP implementations. Confidential was a key resource at Confidential for five years; as one of the original designers and a Chief Architect of the Confidential Enterprise product line. Confidential left Confidential to establish a consulting service for Confidential clients that provides a complete ERP solution; including Implementation, customization, integration and reporting. Confidential expanded his practice to Confidential Manufacturing using E10, E9, Vantage & Vista. He is highly experienced in conversion and integration of the Confidential database. Confidential has an extensive technical network and is often called-on to assist in support and customizations where other consultants failed. He is the solution for getting the best ROI out of Epicor.

TECHNICAL SKILLS:

E10/E9/Vantage: versions 8.0, 8.03, 8.04, 8.06, 9.0, 9.04.05, 9.05.702A, 10.0.700.1 Modules Inventory, Shipping/Receiving, Purchasing, G/L, A/P, A/R, Production (Engineering, Scheduling, Kanban, Lean, MRP) Project Mgmt., Project Accounting, CRM, DMT, Service Calls, Service Jobs, Engineering, QA, BAQ, Dashboards, BPM, Quotes, Orders, Manufacturing, AEP, APM, AFR, Doc-Link, Verify, Replication, Mobile Field Service, Service Connect

Confidential Enterprise Financials & Distribution: Versions 1.0 through 7.4

Modules: G/L, A/P, A/R, Inventory, Purchasing, Sales Order, Shipping, Receiving, Procurement, EDI, Asset Management, Cash Management, Multi-Currency, Job Costing, Work Order Management, Promotions, Service Connect, Quality Mgmt., Doc-Link (2.5&2.6), Clientele Interface, Credit Card/PayPal Interface, Bank Interfaces, Sales Tax Interface, Shipping Company Interface, FRx, Workbench, Import Manager

Databases: MS SQL Server (2000, 2005, 2008R2, 2012, 2014, Azure, TSQL, SSIS, SSRS, SSAS, Cluster, Replication), Sybase (12.0, 12.5, 15.0, TSQL), Oracle (9i, 10G, 11i, PL/SQL, PRO*C)

Development/Reporting: Crystal(7, 8, 8.5, 9, X, XI, 2008,2011), SSRS(2005,2008,2012, Report Builder 3.0), C, XML, HTML, C#, .NET, WCF, JavaScript, Excel VBA, Access, Script(Korn, Perl)

Applications: Citrix, MS RDP Server, Informatica, DataStage, Kronos, Prophix, Xytech, Concur

Operating Systems: Windows (2012, 2008, 2003, XP, 2000, NT) UNIX (Solaris, Linux, AIX)

Tools: Veritas, Confidential, SQL Backtrack, ArcServ, TFS, Subversion, StarTeam, PVCS, SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Principal Epicor & DB Consultant

Responsibilities:

• Provided E9 reports customization and BPM programming that adhere to various companies’ look and feel.
• Created processes that automated complex business rules in a multi-level BOM structures.
• Created auto-maintained multiple weight roll-ups according to BOM structure.
• Extended Job Traveler to auto-print Engineering drawings from their native programs.
• Created data and report to support state mandated VOC requirements from Confidential data.
• Created a DB interface and custom Picking Report to support in-house bar-coding software.
• Rewrote Crystal reports for BackLog, PO, Order Ack., Invoice, BOL, PickList, & Job Traveler.
• Multiple upgrades of Confidential 9.05 starting from 9.05.607, all the way to 9.05.702A
• Provided E9 development of AFR consolidated reporting for Confidential and non- Confidential companies.
• Created ETL processes to extract GL data from Legacy data sources. (AcuXDBC, SQL 2008 R2)
• Created mapping structures and rules to support transformation of the Legacy GL to Confidential GL.
• Created shadow-companies in Confidential to facilitate AFR multi-company consolidated reports

Confidential

Responsibilities:

• Implementation of APM module for AR Invoice, Vendor Invoices, Order Ack., PO, and Quote.
• Created an auto-distributed Tiered Pricing Report from Confidential data that updated a Website
• Created an Confidential interface to web site that interacts with inventory directly
• Customized screens with new Tabs, new fields and additional logic to support UD data.
• Created data extracts & interfaces between Confidential and all other internal and external systems.
• Created interfaces that matched Legacy extracts and ensured a smooth transition to Vantage.
• Created custom MRP, Engineering, Cost accounting crystal report

Confidential

Responsibilities:

• Created BAQs to support business needs in AP, AR, GL and Engineering.
• Created BAQ that allows a consolidated view of secured notes in AR & AP.
• Created a customized form for secure notes access by the collection department

Confidential

Responsibilities:

• Provided Confidential Enterprise upgrade of GL, AP, AR, Import Manager, Assets Management, and Explorer to 7.4; while
• Upgraded Confidential to 7.4 in parallel to upgrade of MS SQL Server to 2008R2 on a Virtual machine.
• Reverse engineered all undocumented customization and recreated customization in 7.4
• Trained users on Distribution and Active Planner modules.

Confidential

Responsibilities:

• Built an Confidential Data Warehouse built to interface to Prophix budgeting and reporting product.
• Automated data extraction from Epicor, and transformation to Phropix cubes data formats.
• Constructed multiple cubes to support multiple views of the data and various analytical reports.

Confidential

Responsibilities:

• Reversed engineered undocumented customization and recreated customization in 7.4.
• Integration of eProcurement with internal systems and vendors’ system using EDI & XML
• Defined XML and created a custom XML interface for ordering of specialized parts
• Customized eProcurement to support a consolidated purchasing model for 500+ buyers
• Provided Confidential implementation, customization, integration, and training services
• Implemented GL, AR, AP, Inventory, Sales Order, Promotions, Shipping
• Integrated E-commerce website (Lazslo) with Epicor, including and Credit card processing.
• Implemented Sales Tax, CRM, and shipping cost interfaces.

Confidential, San Francisco

Responsibilities:

• Upgraded from Sybase to version 7.3 on MS SQL Server and
• Upgraded forms customizations and rewrote custom crystal reports for AP, AR & GL.
• Created exports and imports processes interfacing to Informatica
• Extensive customization of Crystal reports and Forms in AP, GL, and Explorer modules
• Created processes that verified data integrity and self-correct anomalies
• Provided Confidential Enterprise implementation, database interfaces and customization services.
• Functional Implementation of GL, AP & AR with extensive forms and reports customization.
• Created interfaces to credit card & check verification and extracts to support reconciliation.

Confidential

Responsibilities:

• Provided Confidential forms and reports customization and upgrade services.
• Report and form customization in AP, AR, GL, IV, PO and OE modules.
• Upgraded from 4.2 to 4.2a to 7.0 of all modules and all customization.
• Reverse engineered lost customization and created custom Crystal reports in AP and AR.
• Created database connectors for WebMethods.
• Reconfigured GL, AP & AR applications, and guided finance through processes modifications.
• Established new independent company and modified COA structure to reflect new company.
• Led the restructuring of the IT department and a major website redesign.
• Established hardware & software architecture; including load balancing and content distribution
• Led the extraction of data from HTML into a database in support of corporate strategy enabling easy creation of new sites for delivering movie/celebrity/TV info. (MS SQL Server)
• As Vice President of Engineering recruited and managed engineers, contributed to business plan, helped secure first round VC financing, established technology direction and architecture.
• Led development of a network traffic sniffer that reconstructed HTML, UDP, FTP, DHTML. Established unlimited scalability architecture, which proved invaluable to the company’s growth.

Confidential, Santa Monica, CA

Responsibilities:

• Hands-on management of a fast growing development division, tripling in size.
• Led the development of a decision support suite of applications for bank profitability mgmt.
• Established development plans, led development tools selection, and established software releases. (MS Visual C++, OLE, ActiveX and Oracle 8)
• Incorporated SCRUM & Agile development methodologies; including detail design documents, design sessions, Booch notation OO design, ER diagrams, and code reviews. Managed the full development life cycle of multiple product suite releases with perfect on-time delivery record.
• Successfully managed a large team of talented developers in the redesign of TSER UI. The new UI was highly praised for its improved usability and interoperability to 3rd party tools.
• Established an efficient and thorough screening process that identified candidates of the highest caliber with minimal impact on staff. As result, TSC became a highly thought-after workplace.

Confidential, Irvine, CA

Chief Architect

Responsibilities:

• Researched technical trends and their applicability to Epicor. Served as a primary source of technical info. for executive management in establishing new project teams and new products.
• Performed Impact analysis study of conversion of SQL Server T-SQL code to Oracle and DB2.
• Resident Sybase and MS SQL database expert.
• Provided DB design and development guidance to developers on all database issues.
• Concentrated on optimization, and consultant certification.

Client/Server Technical Services Manager

Confidential

Responsibilities:

• Technical management of all customers' issues. Technical guidance of 120 system engineers and consultants, management of system administrators of UNIX, and NT.
• Created sizing tools that produced accurate system recommendations from answers to simple financial questions.
• Approval authority on hardware, software and network configuration.
• Managed Rapid development of new features, enhancements, and customization.
• The software created was used in demos and as a base for implementation of new features. (C, SQL)

Project Leader

Confidential

Responsibilities:

• Designed and developed financial software for windows using a custom developed GUI to communicate to MS SQL Server that was the first in its market.
• Developed major parts of Confidential Enterprise system manager, Accounts Receivable, Accounts Payable and General Ledger modules. (Workbench, SQL Server)