Sales Analyst

MARY ESSANDOH

**** ***** **** **** 469-***-****

Richardson, TX, 75082 **********@***.***

Programmer Analyst w/ AS400, RPG ILE

Objective

A Senior RPG Programmer/Analyst with full Project cycle experience, specializing in Financial application, Forecasting, Retail, inventory Control systems and Warehouse Management systems seeking a position as a Programmer Analyst, utilizing my strong analytical, organizational, Communication and programming skills.

Summary

Successfully led a project that resulted in 20% decreased shipping time and increased inventory accuracy by 25%.

Team leader in the conversion and testing of the mainframe sales data into the AS/400 database.

Designed new application programs including order entry, purchase order management, customer inquiry and import system.

Created technical design specification based on identifying and/or defining the business rules and acted as a primary point of contact.

Ability to work independently and with a team; excellent organizational, communication, and interpersonal skills.

Import/export data from excel spread sheet to IBM I-Series.

Technical Skills

Software - Island Pacific Merchandising, Financial and Sales Audit modules, BPCS, MS Office. Languages - RPG, ILE/400, CLLE, DBU, SDA, Query 400, Embedded SQL, Service programs, Store Procedure, C#, SQL Server 2005.

Technical and business areas of expertise - Trained and experienced in Systems Analysis & Design utilizing IBM midrange systems, AS/400, I-Series, software development, Fujitsu POS systems, Inventory controls and system integration.

Education

B.A. in Computer Science Queens College University, NY, NY

Technology Specialist, 2010 Tech Skills, Addison, TX

Professional Experience

Data Analyst/Department Assistant (Part time) 2010-Present

Brookhaven College, Farmers Branch, TX

Assist in setting up the computer lab for testing; check-in students as they arrive to take

Various tests.

Ensure students have the correct tests; monitor lab to prevent cheating.

Perform researches and analysis data for accuracy

Senior Programmer Analyst 2005-2009

Sanden International USA, Inc. Wylie, TX

Designed and developed an extensive sales management reporting system over BPCS

(Business Planning & Control System).

Implemented asset tracking system for all procurement activities resulting in a $110K cost savings.

Coordinated with key stakeholders to gather project requirements and procedures.

All work was done on the IBM AS/400, I-Series using RPG ILE and embedded SQL.

Senior Programmer Analyst 2001-2005

Value City Furniture, Columbus, OH

Member of a team responsible for creating and implementing a Reservation (Fulfillment) System resulting in a more efficient inventory process.

Maintained and enhanced existing POS systems and provided additional troubleshooting. Participated in a store database consolidation project resulting in improved quality of the database.

All work was done on the IBM AS/400 using RPGILE, embedded SQL and service programs

Senior Programmer 1999-2001

Capitol Manufacturing, Columbus, OH

Designed and created an internal software system to better track the flow of information throughout the company.

Led a team of five who analyzed, identified and corrected ERP software issues resulting in better efficiency and user friendly system.

Coded, tested, documented and implemented new applications and enhancements using RPGIV.

Programmer Analyst 1998-1999

Lane Bryant, Columbus, OH

Recruited to the team to coordinate the implementation sales audit system utilizing the

Island Pacific Merchandising software system for the Y2K initiative to ensure company

Compliancy. Project implemented on time and on budget.

Developed programs to migrate data to and from AS400 IBM mainframe including technical documents and coding in RPGIV

Performed unit tests on data converted from mainframe and assisted in user training.

Programmer 1989-1998

Nautica Enterprises, New York, NY

Developed and implemented shipping and receiving automated warehouse system.

Updated the Warehouse Locator system improving inventory controls.

Developed and implemented an automated warehouse system for shipping and

receiving.

Wrote Warehouse Management System quality control modules improving efficiencies by

30%. All work done on the IBM AS/400, I-Series using RPGIII, RPGIV.

Contact this candidate