Project System

Steve Dubrovsky

**** ****** *

Brooklyn, NY *****

347-***-**** **********@*******.***

Summary

Proven IT professional with 14+ years experience as a Developer, Business

Analyst, Team Leader and Project Leader with strong written and verbal

skills. Successfully led and delivered high-impact multi-user systems in

diverse IT environment for various business applications including Banking,

Accounting, and Supply Chain Management. Self motivated, solution-focused,

quality-minded with recognized creative and analytical problem solving

skills.

Technical skills

Hardware IBM 30XX, IBM43XX, IBM PC

Software COBOL, COBOL-II, CICS (Command level), CICS Transactions, BMS, SDF II,

MICRO FOCUS (COBOL II, CICS), IBM MQ Series, Intertest, Expediter,

DB2/SQL, QMF, SPUFI, File Aid, IDCAMS, VSAM, OS/MVS, TSO / ISPF, JCL /

Utilities, MS/DOS, SCLM, EASYTRIEVE, CLIST, RMDS, VIASOFT, WINDOWS,

NIKU, PROSIGHT.

Professional Experience

IBM / Panasonic of North America Account, SECAUCUS, NJ

2005 - 2009

Senior Programmer / Team Leader

Supported, developed, and enhanced PNAIT billing application, lead team of

3 offshore resources. Billing application supports internal PNA IT billing

as well as Id Administration function. Based on multiple feeds from other

systems application perform monthly billing for all the internal Panasonic

companies for various IT services. System contains both On-line and Batch

portions utilizing VSAM and DB2 as database.

. Designed and developed new unified master database to increase

application efficiency by waiving 12 separate DB2 tables.

. Enhanced and implemented month end billing process by combining 23

separate interfaces into 12. Decreased by 50% interfaces to SAP,

minimizing application size and processing time.

. Supplied client with ability to verify billing data in real time by

constructing various reports based on user requirements utilizing DB2 SQL

and Microsoft Excel.

. Built new ID administration system to register new employees and

consultants as well as update existing personnel. Reduced manual data

entry work for ID administration team by 90%.

. Participated in yearly company reorganization project. Developed

conversion database to remove hard coding in application and increase

application efficiency.

. Eliminated manual review process by VPN administration team by delivering

new sub system to notify clients about expiring IT services.

PANASONIC, New Jersey

1999 - 2005

Application Project Leader

Played leading role in system analysis, business design, technical design,

technical specification, estimation, development, and implementation for

more than 25 projects. Led team of 7 people, including 4 offshore

resources, in all stages of project life cycle. As part of IBM outsourcing

process, designed, created and executed knowledge transfer plan for remote

development center resources.

. Designed, developed and implemented weekly and monthly products

forecasting system. Saved company $1M+ yearly by reducing in stock

inventory and decreasing product lead time to customer.

. Created master and transactional data interfaces for PSI (Purchase,

Sales, Inventory) system replacement project, enabling company to save

over $.5M yearly.

. Reduced company inventory for 3 product categories by 30%. Invented new

VMI (Vendor Managed Inventory) system, which controlled inventory in

customer warehouse.

Steve Dubrovsky Page Two

. Performed yearly PNA (Panasonic of North America) reorganization, which

minimized number of product categories and restructured product

distribution network for more efficient ordering and delivery process.

. Improved company ordering process by introducing mixed method of

transportation for factory collaboration. Gave users ability to create

purchase orders with different transportation methods minimizing lead

time to customer.

. Increased planning accuracy by introducing product tentative P-Price,

which gave users ability to set product price prior to purchasing

department.

Quantum information Resources Inc, New Jersey 1997 - 1999

Senior Programmer

Developed and implemented new application control system, which produced

different real time reports based on client requirements. Enhanced, tested

and implemented various on-line and batch applications utilizing COBOL II,

DB2, VSAM and CICS Command Level.

. Designed and developed new reporting system to allow users to create

various on-request reports. System was able to produce 100 real time

reports based on different combinations of input parameters.

. Setup SCLM software for PSI application. Reallocated all PSI system

source code from librarian into SCLM. Allowed more efficient management

of changes to application data, software auditing and versioning, and

easily controlled movement of application data between staging libraries.

. Prepared program's documentation and catalogued procedures for production

systems to insure proper production implementation.

. Communicated with users to obtain specifications for system enhancement

and new development to guarantee complete project development cycle.

. Solved real time production problems, including night time batch

processes, to insure uninterrupted process flow.

Major Consulting Agency, New York 1996 - 1997

Programmer Analyst Consultant

Created and implemented Global Investment Management and Global Accounts

Processing on-line systems, which enabled users to retrieve detailed

information on selected accounts, brokers, transactions, securities and

transactions current status.

. Developed front-end data entry screens, validation and edit

modules, multi-function summary screens, PF-keys function

control. Programs were written in COBOL2/CICS utilizing DB2

database.

. Created production implementation package to guarantee proper production

move.

. Created reconcilement process for batch activity reports to

insure system tuning and performance optimization.

. Worked on system interfaces analysis, data flow

specifications to cover complete process flow.

. Prepared program documentation, recovery procedures to establish base for

straightforward future enhancement and development.

Education

Diploma, Computer Programming and Design Techniques,

Globe Institute of Technology, Inc. New York, NY

PROFESSIONAL DEVELOPMENT

UNIX: A Hands-On Introduction Learning Tree International.

Parsippany, NJ

SAP Overview SAP of America, Chicago, IL

SAP: Processes in Sales & Distribution SAP of America, Chicago, IL

SAP: Demand Planning SAP of Canada, Toronto, Canada

Contact this candidate