SUMMARY

Skilled technical department manager that can double as a analyst/developer with broad-based financial, logistic, inventory control, MRP and EDI systems experience in music, video and CD manufacturing, the toy, automotive supply, apparel/textile, health care and chemical industries. Strong analytical skills combine with ability to communicate effectively with employees at all levels to consistently improve end-user productivity and enhance bottom-line performance. Proven IBM I-series/MS .net system administrator and project planner with an excellent track record of successfully managing in house and out sourced talent. Creates easy to read documentation for developers, end users including management SOX and SDLC auditors. Easily handles both ends of a project when needed and technically jump between roles as needed.

PROFESSIONAL EXPERIENCE

Confidential

Analyst/developer

• Managed and preformed analysis tasks for all development projects including database and server software upgrades.
• Created and modified EDI maps using Gentran. Created custom maps for WRNTY and Joor.
• Monitored and managed MS server 2003, 2007 farm running Netapp SAN Mgmt. Dell Virtualization , VMWare Virtual servers using Vmsphere, Redgate Backup , Blue Cherry ERP , Gentran EDI .
• Created and modified Blue Cherry Reports and user defined database fields BROs .
• Installed and Implemented Blue Cherry Logistics module, Analysis and Installation of 3PL module. Performed all analysis tasks for outside stake holders.
• Remotely monitored, upgraded and maintained applications during off hours.

Confidential

• Managed MS server farm running Netapp SAN Mgmt. ESXi Virtualization, Barracuda , VMWare Virtual servers using Vmsphere, Vmotion and Snapshot manager , Priya WMS and Boomi EDI . Migrated Boomi 3.3 to Atomsphere. In process migration to DaVinci Linux CentOS WMS.
• Double ended project management and analysis, V2C, V2R, V2W, W2W, V2V2R.
• Developed primarily in T-SQL, Java Script Groovi , XML. Crystal reports 10,11 and Bartender bar coding for reporting.
• Maintained and reprogrammed Motorola RF equipment Windows CE using Avalanche.

Confidential

• Managed 2 i-series systems WMS operations and for Corporate EDI/Help desk running Lawson, DAS, Oracle, Robot and Pathfinder.
• Analyzed and Developed home grown applications: purchasing, financial, consignment inventory, RF warehousing, EDI and web B2B.
• Systems Analysis and Design, Project management and planning using PMP best practices. Designed forms and work flow documents. Designed and implemented change management and incident tracking. Managed and updated documentation as needed.

Confidential

• Analyzed and led project to pull comments from EDI Work orders inbound and outbound from B2B site into sales purchase orders to reduce re keying and errors. These orders are both inbound and outbound from Primenos.
• Analyzed and Tracked down and fixed a production issue where unwanted information was passed between menus LDA .
• Designed, Analyzed and Created a Pick/Pack/Pull status report for inventory control replacing a series of queries.
• Documented and Analyzed current systems for system upgrade, obtained bids and implemented system upgrade.

Confidential

• Performed all aspects of end-to-end development including system analysis and design without a direct manager for fourteen months and without an assigned security officer/system administrator for almost two years.
• Oversaw and developed a project plan and created a user reporting system to replace a consultant's running of ad hoc queries using pop up windows for data selection and querying and a series of SQL RPG programs to simulate month- end report totals for month-end balancing. Verify using PL/SQL.
• Managed project, preformed systems analysis and developed the following applications: Wild-card searching by Artist or Publisher in the tape library inventory system, month end balancing of record projects with SQL, Automated e-commerce reporting to ORACLE finance, AFTRA and Harry Fox reporting via FTP.
• Supervised consultants and provided IT management with timely oral and written documentation, project status reports/SDLC documentation using e-mail, MS Net Project, Remedy, Tock, Tracker and MKS Implementer on the AS/400.
• Spearheaded the project and performed analysis for Royalties and designed a way to allow the company to be able to pay artists based on tracks and based on a flat rate per song for E-commerce instead of requiring a list price and manufacturing costs. Documentation was created and trained the departments staff on usage.
• Led a project and performed all analysis to better archive and reprint artists statements from history and EU reporting of performance royalties. Documentation was created and trained the operations staff on usage.
• Utilized TOTAL, VISIO, MS Project and EZVIEW in my systems analysis tasks. Tracked urgent open items with Remedy and Team Tracker. Used MKS Implementer to document and promote program changes to production.

Confidential

• Led Project, analyzed and created processes to receive orders and other EDI documents via spreadsheet or text file for processing on the AS/400 with JBA.
• Did the same for the converse applications to send AS/400 reports as e-mail attachments, AS/400 files as Excel spreadsheets and notifications from the AS/400 as Word documents or e-mail text.
• Worked with operations and key users to create a notification system to alert key personnel to problems or completed batch processes. Documentation was created and trained the operations staff on usage.
• Spearheaded, documented and performed analysis in an initiative to design an inventory system in JDA for CD masters using bar-codes to be used in the work order process with TCP/IP devices connected to the AS/400.
• Maintained, documented and enhanced a Windows 2000 server based serial number and lot tracking system using Visual Basic, MS SQL and Crystal Reports.
• Worked with Aldon ACMS and Hawkeye to perform day-to-day analysis and project maintenance tasks in addition to SQL and IBM Query. Helped to support the ALDON financial system.
• Wrote applications and interfaced with Philips corporate SAP systems MFG-PRO and production line devices that used SAP integration. Evaluated and did analysis work as to fees ability to migrate existing applications to MFG-PRO.
• Used ERWIN and MS Project for analysis, documentation and project management tasks.

Confidential

• Led project, performed analysis and created processes for vendor operations: Bill of Lading tracking, Container tracking, Separated Purchase Orders by Vendor and or Planner, Shipping/Routing request update with automatic e-mail of forms between internal departments, external departments, vendors and shipping companies , added vendor unit of measure to purchasing system, a conversion table for reporting purposes, a tooling cost analysis system. Was a key member to help set up the first international distribution center in Mexico using PKMS.
• Spearheaded analysis and development for MSDS reporting project for all manufacturing system and Pigments where used system users.
• Controlled the roll-out of an expanded system options control file and changed all programs currently in production that used it. Documented all steps.
• Team led a project to reduce the number of screens on key entry programs by enabling a 132-column screen if the display allowed. Documented all steps and created a plan to gradually roll it out to the various plants.
• Led Y2K project, re-doing the analysis and performing 70 of all changes and implementing the changes on all local systems.
• Chaired the implementation and analysis, helped create and maintain an Oracle/Cognos Data cube using FTP and Verified using PL/SQL.
• Worked with Implementer, TOTAL and ABC Flowcharter for Systems Analysis tasks.
• Completed Mattel Visual Basic, JAVA and HTML training. Maintained an Oracle/Cognos Data cube using FTP and Verified using PL/SQL.

Confidential

• Coordinated documented and completed projects for remote location and the corporate office.
• Integrated personal computer systems into Mapics DB version 4 manufacturing, PKMS Warehousing and Daily and Walcott Aplus version 2.05 accounting systems. Created new user documentation and did analysis for the project.
• Maintained and documented Fastfax and Bosanova servers.
• Evaluated replacement systems for future system upgrade QAD MFG/PRO , performed all user modifications and created all migration programs for SAP. Performed migration analysis and documentation.
• Completed AS/400 portion of fiscal budget. Documented process to make easier next year.
• Led the project and handled all aspects in data processing for semi-annual physical inventory and yearly price increases. Performed analysis and documented to streamline the process next year.

Confidential

Senior Programmer/Analyst

• Implemented and performed all analysis for the merger of financial information, sales and order processing of a newly acquired company with the NMC accounting system in AS/400 model 310 and F35 environment.
• Integrated Unisys 2200 Mapper with corporate AS/400. Improved documentation
• Maintained and modified Mapics DB manufacturing system code including adding of product lines and corporate divisions. Performed impact analysis of all changes.
• Led a project that designed a new menu system that allowed for better security and improved the interfaces between the manufacturing, financial and homegrown systems including customer service. Performed all analysis tasks, trained the user and created new documentation
• Chaired an auditor-mandated project to improved security in quality control application. Preformed all analysis.
• Managed a project to create a new vendor purchase order system, profit and loss statement and coordinated the project to implement it across all divisions and subsidiaries. Performed analysis, documentation and test scenarios
• Analyzed production system for production planning system. Documented all steps.
• Evaluated and implemented projects using SQL SQL/4 less .

Confidential

• Spearheaded an initiative to track down and migrate all queries and sequels from system 38 to AS/400
• Led project, performed analysis and implemented incentive payroll, payroll data entry, sales forecasting and production planning, packaging inventory and order processing programs with connections to the EDI system Primenos . Created new documentation and trained all users.
• Designed all corporate labeling mainly UCC using Zebra and RJS printers with custom BASIC and packaged software connected to personal computers and the AS/400. Documented all label formats.
• Setup PC based PKMS system for warehouse control at 2 warehouses, wrote JD Edwards interface from Mfg., to HR
• Managed and performed analysis tasks to consultants contracted to implement an RF terminal system, using Intermek Trakkers programmed in IRL directly connected to the AS/400 and others connected to a UNIX server using Auto-Soft software which was connected to the AS/400 for inventory put up and custom order packing for K-mart's positive verification standards and for other customers requiring custom order packing. Created user documentation.
• Project managed, performed analysis and implemented J.D. Edwards payroll, human resources and benefits packages, and all ties to the general ledger for a major hosiery manufacturing company. Updated vendor documentation.
• Maintained and managed hundreds of legacy COBOL programs and converted all RPG3 and RPG-ILE, some without COBOL source code. Analyzed process where there was no source code to reverse engineer the process.
• Managed all aspects of personal computer maintenance, installation, training, programming and repair. Used ERWIN on PC for program diagramming and analysis tasks.

Confidential

• Project led, performed analysis and implemented waste management systems and General Motors automated forecasting systems.
• Led a conversion projects to convert Canada X12 EDI order process to proprietary systems using Sterling software's EDI system, Old system 38 COBOL programs to native AS/400 RPG programs, and dye cost and dye waste system for a remote location with a system 36. Documentation was created and trained the operations staff on usage. Created multiple plans during analysis stages of projects.
• Managed the system 36 and maintained and led projects involving the BPCS manufacturing system. Preformed all analysis for all projects involving the system 36.

Confidential

lDivision Lead Analyst

• Led projects, performed analysis tasks and implemented all new systems for the Emb-Tex division, including new inventory system with work-in-process inventory and a time and attendance system both with bar codes.
• Spearheaded and analyzed an initiative to migrate the corporate S38 to an AS/400 model B30 and integrate it with division system 36 and another division using APPN. Documented and created system flows of all processes
• Developed, analyzed and managed projects using RPGII1/2 and RPG 400 and PASCAL. Programmed and maintained Data General Micro Ellipse and personal computer systems. Programmed personal computers using Turbo Pascal 5.0.
• Performed maintenance changes to software on Northern Telecom SL-1 telephone switch.