Systems Analyst Resume
Objective
Seeking a senior technical/functional role in Information Technology which provides opportunities to apply my technical background and business knowledge to implement improved processes resulting in major benefits for the organization.
Experience
December 2010 to Current Confidential Columbus OH
Consultant
Currently working for a Confidential. The job involves analysis and design/development of major initiatives related to company expansion in new markets.
May 2008 to December 2010 Confidential Alpharetta, GA
Technical Consultant
Providing support to clients on ERP LX. This involved developing applications on I-series using RPGLE and other OS/400 based utilities. Details are below:
- Worked on a major ERP LX implementation for a client in Japan. This included working with CCSID encoding and working with double byte character sets. Also developed the following applications using RPGLE:
- Order import interface
- Automation of pick release & confirm functions
- Generation of ship confirm file for 3PL
- OLM custom changes
- Worked on a project for a major food company based in Pittsburgh PA.
- Developed application to import supplier invoices into Accounts payable system and posting to General Ledger.
- .Worked on a project for an Automotive client based in Ohio
- Used RPGLE and data queues to import and create requisitions in Purchasing module
- Used ASN coming in via EDI to create supplier invoices and post to Account Payables module
- .Worked on an internal project to create standard interface for inbound & outbound EDI documents for ANS_X12 and EDIFACT.
October 2006 to May 2008 Confidential Atlanta, GA
Senior Consultant
Provided support to clients on Warehouse Management and shipping system (PKMS). Responsibilities included providing support to various clients in the following areas:
- Implementation of inbound/outbound processes in the supply chain area.
- Resolving client production support issues.
- Writing Mod specs/technical specs for client custom requirements
- Managing customer relationship/expectations
January 2003- October 2006 Confidential Ottawa, ON
Systems Analyst
- This role required extensive dealing with stake holders and managing internal customer expectations. Job requirements also include dealing with software vendors, writing business cases to justify project approvals, providing technical specifications to programmer/analysts for development and ensuring mission critical applications are running smoothly.
- Played a key role in Implementing Order Power, an AS/400 based retail order processing system. The role required analysis and design of existing interfaces as they integrated with the Order Processing system. Some of the interfaces designed and implemented include the Web interface, Credit card processing integration with Paymentech, GL interface with the main ERP General Ledger module, design of custom documents such as invoice and integration with the shipping system.
- Key role in Implementing Maestro, an AS/400 based Shipping system. The initiative required ensuring integration with Order Processing system, automation of ship confirm and manifesting process.
- Implemented the FEDEX Trans-border service which involved electronic transmission of shipment data to US customs. This project resulted in improved shipping processes and improved delivery schedules for customer orders.
- Designed and implemented an integrated customer Returns Processing System.
- Implemented Customer Satisfaction system.
- Provide ongoing support on BPCS, Order Power and Maestro.
May 2000-January 2003 Confidential Napa, CA
Senior Programmer Analyst
- Developed the FDA compliant physician Validation system. This system ensured compliance with FDA when providing medicine samples to physicians. The process required that all physician data be sent out electronically to a 3rd party validation company. Once the physician information was validated, the system provided order processing facilities to keep track of samples dropped to physicians. The application was also designed to integrate with Inventory Management module to deplete inventory.
- Provided complex analysis reports on sales performance by territories including realignment of territories.
- Provided ongoing support on BPCS, the core ERP system.
- Supported sales CRM operations
April 1998- April 2000 Confidential Sacramento, CA
Programmer Analyst
- Provided Y2K conversion support. This required complete reengineering of such complex applications as General Ledger, Accounts Payable, Accounts receivable, Inventory Management. The development was done using a Y2K conversion tool.
- Implemented VERTEX, an AS/400 based sales tax calculation system.
- Provided ongoing support on BPCS for the Order processing, inventory, General Ledger, Accounts Payable, Accounts Receivable.
October 1997-April 1998 Confidential Richmond, IN
Consultant
- Implemented CYBORG, an AS/400 based payroll management system. This application required designing interfaces to existing applications such as Costing, Employee pension plan, health insurance.
- Provided application support on BPCS modules such as General Ledger, Accounts receivable and Accounts Payable.
October 1992-September 1997 Confidential Karachi Pakistan
Deputy Manager IS
- Team lead for BPCS ERP implementation. This required managing customer expectations as well as a team of support specialists. Also responsible for hardware and software maintenance. Managed a team of 5 IT resources.
- Supported day to day production issues. This included assigning resources to relevant areas, keeping track of outstanding issues, negotiating with users to determine priority.
Education
- B.S., Management Information Systems
Technical Skills
I-series, RPG, CLP, DFU,DBU, AS/SET, QUERY/400, SQL, ALDON, TURNOVER, TRADEPAQ, FTP, XML , DBU