Systems Analyst Resume
OBJECTIVE:
- I am seeking a company that can utilize my management and technical skills as well as my extensive knowledge of business processes.
- I would be an asset to any company.
- Extensive experience with IT Management, Infor M3, Confidential, StreamServe, SharePoint, Infopath forms, Order Management, Warehousing,
- Transportation Management, Inventory Control, EDI, Accounts Payable, Accounts Receivable, Sales Rep systems, General Ledger and ETL.
TECHNICAL SKILLS
Management: IT Director, IT Manager, IT Supervisor, IT Team Lead, 20 years of Marine Corps (E7/GySgt)
Hardware: Windows Servers, HPUX, IBM AS/400, Personal Computers, IBM Mainframe, some VM Ware
Languages: RPGILE, RPGIV, RPGIII, RPGII, CL/400, SQL400, Cobol400, Java, VBS, C# .NET, C, C++, Cobol, Visual FoxPro, Jot (JBA software), ABAP (SAP), Oracle Stored Procedures, Sql Stored Procedures and Unix Scripting
Software: SqlServer 2005/2008/2012 , Highjump WA 12.2,Stream Serve 5.4/5.5,SharePoint 2003/2007, Confidential 9.4/10.3,Eclipse,InfoPath, SharePoint Designer, Visual Studio 2005/2008, SPS, SAP, Extol EBI/ESX, Trusted Link EV5/EV6, Frontpage, Peak Performance, Quota Tool, Daly.Commerce A+, Pitney Bowes Fulfillment Solutions, BizManager, MS - Office, Lotus Suite, Lotus Notes, Oracle 8/9i
Operating Systems: OS/400 (AS/400), Windows 3.1/95/98/2000/ XP/NT/2007, MS-DOS, Unix
ERP: Infor M3,SAP,Oracle 8/9,Peoplesoft
EMPLOYMENT HISTORY:
Confidential
Director of IT
Responsibilities:
- Managed small team of 3 + 1 consultant and competed day to day processes
- On budget and on time for numerous projects over 4 years
- Saved over 63k for Confidential projects for FY16 totaling > 300k
- Modified many Confidential maps and SP's to support M3 to Highjump WA and DCA integrations
- Managed numerous consultants and vendors for enhancements to M3 and Highjump
- Applied fix packs and MCP's to 14.2 M3
- Created weekly maintenance process for ensuring stability of M3 servers
- Automated many processes to better the experience of M3 to the users
- Managed EDI - Infor M3 to Confidential to SPS
- Created maps and tested/go-live for over 15 customers for new Confidential 856 process.
- Trained non-IT persons to become Developers and support the organization as an IT Systems Anaylst
- Assisted in many process engineering projects such as B-B/B-C website and new WMS for the organization
Confidential
Systems Analyst III
Responsibilities:
- EDI Specialist using Extol EBI & AS/400 Programs to create translations and to setup trading partners for all documents (810, 846, 850, 856, 860, 870, 997) for all Vendors and Customers.
- Setup and maintained EDI trading partners, which includes, interconnects to and from Extol's van
- Confidential as well as AS2 connections with Freight Forwarders and Customers.
- Setup and maintained new AS2 process for Proxy Server to Extol ESX ( Confidential ).
- Projects included:
- Inventory Feeds (846) threshold. Created Confidential programs and files to create output files using a output file which was created from an M3 (Lawson) screen.
- Applied business logic to control output to specific customers.
- Invoice Gross Up. Created modifications to existing inbound Confidential programs to utilize the calculated fields that were populated by the incoming 850 maps and called the M3 API's to load the discounts in the orders so that the customers can continue to send in the adjusted value that the sales rep has promised.
- M3 (Lawson) upgrade to 10.1 - Modifications to existing files and programs to support the new version of M3.
- Upgrade Extol EBI from 2.3 version to 2.5- Install and create new process for AS2 using Proxy Server to Extol ESX (
- Confidential ) as well as make modifications on new servers for traditional edi customers using new version of EBI.
- Confidential Migration from Extol EBI. Created Confidential Maps for xml BODS to pass through into M3 using M3 API's and ebedded sql.
- Maintained OS functions for AS/400 520 & 550 to include backups, PTF's, restoring libraries/files and hardware installations.
- Updated workflow for Performance Forms (Infopath forms).
- Provided support for all things Sharepoint.
Confidential
SharePoint Developer
Responsibilities:
- Designed, created and published numerous Infopath 2007 forms to sites
- These forms used sql data connections as well as internal sharepoint data to display dropdowns and other controls to make the user experience more friendly.
- Designed, created and deployed workflows using SharePoint designer.
- Workflows that send emails, created and updated list items, and sent the form via approval heirarchy.
- Diagnosed and fixed issues with setup and deployment of sharepoint MOSS site.
Confidential
SharePoint Admin / Developer
Responsibilities:
- Designed sites and setup permission groups for several departments.
- Created workflows that created multiple list entries upon upload of one document.
- When a document was uploaded the workflow would create a task list entry and another list entry on a sub-site.
- Created DVWP’s using SharePoint Designer that created a dropdown using data from another site.
- Created css files and a new master page to modify the branding and color schemes for the sites.
- Analyzed requirements for Sales Force query tool and provided solution documents.
Confidential
Sr. Systems Analyst
Responsibilities:
- Created numerous WebParts for use within SharePoint Moss2007 server that accesses SqlServer data directly and stored procedures that retrieve data, and present it to pages or sites.
- Created Workflows for processing incoming xml data within document libraries and creating sites or pages programmatically.
- Created InfoPath forms for users to submit data to SharePoint document libraries.
- Created Infopath forms that had code behind to create pages and sites based upon data within the Infopath form.
- Provided support for Ascentium app within SharePoint that used InfoPath forms to create project pages and provided a means for Project Managers to manage projects.
- The Infopath forms submitted to a Public Folder within
- MS-Exchange and there was a document library that monitored the public folder and loaded the document library with the attached xml document.
- Created Reports using VS2005 and C# for display in SharePoint 2003.
- Reports used SqlServer 2005 data and Stored procedures to produce table data within an IFRAME on pages within SharePoint Server.
- This allowed the users to sort, filter and retrieve data using stored procedures by selecting it in dropdown lists.
- EDI Specialist using SAP & GXS (AI) to create translations and to setup trading partners for all documents (810, 812, 820, 850, 856, 864, 870, 997).
- Setup and Maintained EDI Trading Partners to include all IDOC's and internal mapping within SAP for Vendors as well as Customers for Carlisle's multiple Company structure.
- EDI Specialist using Trusted Link software to create translations and to setup trading partners for all documents (810, 816, 820, 850, 856, 864, 997).
- Setup and maintained EDI trading partners, which includes, interconnects to and from Sterling Commerce as well as AS2 connection with Lowes and documentation tracking.
- Created and modified existing Unix scripts and User Exits to accept and translate data, based upon business needs, for outgoing and incoming EDI transactions.
- Created correlation documents for mapping diagrams for all documents.
- Assisted in helpdesk support to include creating desktops for scratch and setting up printers, etc.
Confidential
Team Lead - Project Manager / Sr. Programmer
Responsibilities:
- Project Lead for development teams that expanded the functionality within the Quota Tool, a Sales Rep system that allows Sales Reps Managers to set Quotas for the next year.
- Developed functionality and led projects that included:
- Sales Reps Spiffs, which saved company 8 million.
- Inclusion of Commercial Reps, SAP, into Peak Performance.
- Inclusion of Retail Invoices into Peak Performance.
- Data integration, which provides data from an SAP system through Peak Performance.
- Lead for .net, As/400, Oracle, Mainframe and Data Stage developers during this project.
- Created project plans, flow diagrams and other project documents to conform to user’s requirements.
- Gathered requirements from, set timelines and provided expenditure documents directly to requestors.
Confidential
Sr. Programmer / Analyst
Responsibilities:
- Developed a Test environment for Peak Performance Dashboard software. Sales Rep pay and incentive software.
- Developed programs and processes using RPGILE, CL400, SQL400, Cobol400, TCPIP, FTP, Unix Scripts and Oracle stored procedures.
- Modeled the Test environment mirroring the Production environment, which utilizes the same process flow.
- The Test environment copies all needed files from production and processes the required month(s) of invoices for requested locations then sends the data to Unix for processing into a Data Mart on Oracle 9i.
- Developed Peak Performance Position change Project.
- Created programs using RPGILE and CL400 to modify files during an ECTL process.
- This process will check for a Rehire code and update all the files so that the invoices will give credit to the appropriate Sales Agent.
- Created programs using RPGILE and CL400 to modify files on month-end. This process checks for end-of-month and cleans up records that are being closed for multiple files.
- Created File maintenance programs using RPGILE with embedded SQL, SQL400, and CL400.
- Created year-end file setup programs and programs to modify files for sales reps based upon a request from the sales staff.
Confidential
Manager, AS/400 Development Team
Responsibilities:
- Managed and instructed team of six programmers / analysts
- Project manager for all AS/400 based projects, which assisted in the performance of functional users as defined by priority.
- Projects such as EDI Invoice Consolidation, Pre-Ticket printing utilizing EDI (CTP segment) data for Nordstroms, shipping software transition and separation of International Orders.
- Member of Vendor Compliance team which ensured that the projects understood the needs of the company as a whole.
- This team would understand the direction of the company and fulfill the needs utilizing the developers.
- Member of Sparc. A committee that understood and applied all the suggested sales programs as they apply to current and upcoming systems.
- Effected integration of data from AS/400 to mainframe systems for merger of companies (LCI and RC/Ertle) using RPGILE, SQL400, SQL 7, and DTS packages.
Confidential
Project Manager / Sr Programmer
Responsibilities:
- Wrote and maintained programs for an Extract, Transform and Load (ETL) process into numerous NT Servers in support of an
- E-Commerce Web application and Data Warehouse database which supports business intelligence.
- Designed and wrote programs to process and pass order data from an industry leading Website.
- Modified programs that used an MS-Commerce Server pipeline to create and process XML data into
- EDI purchase orders (850) and process them through the AS/400 order management system.
- Created programs to process integration data for merger of company for two product lines (Eden and Madeline).
- EDI Specialist using Trusted Link software (formally Premenos) to create translations and to setup trading partners for all documents (214, 810, 820, 832, 850, 852, 856, 864, 860, 869, 870, 997) and the UCC128 labels.
- Setup and maintained 35 EDI trading partners, which includes, interconnect from van to host and documentation tracking.
- Modified existing programs to accept and translate data, based upon business needs, for outgoing and incoming EDI transactions.
- Grew existing EDI capabilities from 1 customer to 35 customers. Established automated pre-ticket printing.
- Created XML translation using Java and a MS-Commerce Server Pipeline to send EDI 850 to backend AS/400 order tracking software. Transitioned EDI software package.
- Installed numerous PTF’s, created OutQs, user profiles, hardware resource definitions, Sub-Systems as well as other various administrative duties within the OS/400 for @ 200 people.
- Installed upgrade for Daly.Commerce (A+) software with no loss of production time or money.
Confidential
Programmer / Analyst
Responsibilities:
- Wrote Inventory Management, Freight Bill Auditing, Sales Order and Transportation
- Management Programs, Print files, Display Files and Queries using RPG400, RPG400 with embedded SQL
- Analyzed systems for maintenance on programs and files
- Over 1000 hours of hands-on programming experience including coding, debugging, testing and documenting
Confidential
Stock Control Supervisor
Responsibilities:
- Responsible for accounts worth over $37 million
- Monitored custody records and reports for over 50 accounts
- Managed all aspects of budget for an account worth over $1.2 million
- Supervised and motivate culturally diverse workforce
- Communicated with staff in all departments and at all levels