Visual Basic Reports

STEWART C. McEWAN

** ****** ****** ******, ** ***10 201-***-**** **********@*****.***

Over 18 years of experience in application design and development. Expert knowledge in Oracle PL/SQL, Visual Basic based client server applications, SQR Reports, GUI design and web development. Dynamic team leader possessing strong analytics skills and experience in effective customer communication and problem resolution.

Programming & Web:

SQL, PL/SQL, Visual Basic, Crystal Reports, SQR Reports, Oracle Reports, HTML, JavaScript, AJAX

Database & Development Systems:

Oracle 8.x-10g, MS Access, TOAD, PVCS, Oracle Reports, Brio, Visual Studio, Hyperion

EXPERIENCE

Senior Application Developer & Designer 2000 - Present

Kate Spade & Company (Liz Claiborne Inc.), North Bergen, NJ

Responsibilities: Software development of client server applications, report creation, development of web applications, database design and optimization, requirements and documents design.

-Created a web based application using HTML, JavaScript, PL/SQL Packages and Stored Procedures giving business users ability to modify existing order attributes and remove derelict orders from ERP system

-Produced an Oracle PL/SQL application using PL/SQL Stored Procedures, Database Triggers, Packages and Tables to interface UPC data to external system for hang tag label creation, in addition to a Visual Basic front end and Hyperion (SQR) reports for exceptions

-Created and maintained 100+ Hyperion (SQR) reports on key company subject matters: Sales, Bookings, Inventory, Production, Fabric

-Enhanced and oversaw customer feedback system utilizing a Visual Basic front end application with an Oracle back end that has PL/SQL Stored Procedures, Database Triggers, Packages and Tables

-Managed MS Access application using numerous Queries, Tables, Reports and VBA Code used to analyze and predict retail replenishment requirements

-Improved Crystal Reports used in customer feedback system and enhanced various modules of internal ERP system using Visual Basic

-Built a textile specification and planning system using Visual Basic front end application with Oracle back end applying PL/SQL Stored Procedures, Database Triggers, Packages and Tables

-Supported Oracle Reports used in textile specification and planning systems

-Created and maintained MS Access application using Queries, Tables, Reports and VBA Code used for business planning

2nd Shift Supervisor

Harrison Alloys, Inc. – Harrison, NJ

-Supervised and organized union production duties for 20+ workers

-Promoted to management role after 2 years and acted as union liaison

-Allocated materials for processing and filling necessary orders

-Responsible for updating and maintaining daily production logs

-Handled all production and maintenance emergencies

1993 1999

Route Foreman

1987- 1993

Cali Cartin – Kearny, NJ

-Foreman for 20 men and 7 trucks responsible for daily municipal collection

-Effectively handled resident and town employee inquires

-Oversaw route schedules and team assignments

Installation Mechanic

General Refrigeration – Cliffside Park, NJ

1984 – 1987

-Installed HVAC systems across residential and commercial properties

-Responsible for scoping job requirements and performing installation in a timely fashion

-Ensured all necessary job materials were ordered and stocked

EDUCATION

The Chubb Institute (2000) – Diploma in Computer Programming

Contact this candidate