Manager Microsoft Office

An accomplished I.T. professional with demonstrated success in many areas including end-user and software applications.

Software & Languages: Crystal Reports, SAS, Excel-VBA, Microsoft Office suite, vb.net, asp.net, SQL,

Visual Studio, HTML

Experience:

TEKsystems Parsippany, N.J. September 2015 – August 2016

Consultant/Data Analyst – (client: Turtle & Hughes)

Solely responsible for all corporate reporting and data analysis

Created VBA macros to for Excel reports to improve production time by over 50 percent

Designed, created and executed complex and professional business Crystal Reports

Created SQL Server code to validate report data

National Exchange Carrier Association, Whippany, N.J. August 1992 – September 2015

Senior Systems Analyst/Senior Applications Developer

Lead developer and company subject matter expert - Crystal Reports and Excel

Provided SAS support to the entire NECA user community including software installation, maintenance, troubleshooting and coding assistance

Created internal front-end applications using Visual Studio with SQL server and Oracle

Customized .asp code to allow for additional user requirements

Created stored procedures utilizing both Transact and Oracle PL SQL

Developed a reporting system using Excel & Crystal Reports to track the Information Technologies budget

Consultant (October 1996 - November 1998 - evenings)

Conversion of mainframe SAS to PC-SAS

Conversion of Lotus spreadsheets and macros to Excel including VBA code

Associate Manager- Earnings Assessment (August 1992 - October 1996)

Produced accurate and timely assessments of FCC Tariff Rates & Costs

Produced financial projections for current and future tariff filings

Completed conversion of all programs into the SAS system, including complete rewrites of spreadsheets for new file imports

Data-mapping between Census Bureau data and telephone exchange data

Nabisco Inc./RCG Information Technologies, East Hanover, N.J. September 1997 – November 1998

Systems Developer/Consultant

Developed a proprietary inventory management system using SAS to assist the field sales force

Wrote SAS conversion code to incorporate new SAP files into an existing system that uses SQL/DB2 and Natural

Ajilon Consulting Services, Somerset, N.J. November 1996 – August 1997

Consultant – (client: Prudential)

Worked on Erisa data management and file creation

Participated in the development of the Erisa reporting system

Wrote, tested and moved SAS programs into production in addition to creating ad-hoc reports for external clients

Prudential Insurance Co. Roseland & Florham Park, N.J August 1987 – August 1992

Acceptance Test Coordinator

Developed test plans, and test cases using JCL with prediction of results for an on-line insurance agents’ maintenance system

Reviewed test output, document system changes, and communicate errors to programming staff

Assistant Pricing Specialist

Created and enhanced software programs and utilities

Provided accurate and timely costs for annuity purchases including reconciliation and documentation for sold contracts

Financial reporting for year-end processing

Training & supervision of new employees

IMEX Discovery LTD. New York, N.Y. June 1984 – November 1985

Assistant Manager

Initial set up and maintenance of all software and hardware

Full charge of inventory and warehouse distribution system

Heavy client contact with buyers and warehouse personnel

Training of office personnel on systems and office procedures

Monchik Weber Wall St. Concepts New York, N.Y. September 1982 – July 1984

Portfolio Services Analyst

Formulated and evaluated portfolio analysis for 1000 clients in the financial community

Analyzed clients’ financial holdings to ensure accuracy and timely distribution of financial data involving capital changes

Served as a problem solver for quality control reports in detecting errors of financial output, and effect necessary changes to ensure accuracy

Dealt with the public in resolving clients’ inquiries and furnishing of pertinent financial data affecting their holdings

Education:

September 1978 Queens College – C.U.N.Y. Flushing, N.Y.

to June 1982 Major: Education Minor: Communications – Dean’s List

Contact this candidate