We provide IT Staff Augmentation Services!

Consultant, Resume

2.00/5 (Submit Your Rating)

Bristol, Pa

SUMMARY

  • Over 20 years of extensive experience in Software Development in the areas of Mainframe and Client Server Systems.
  • Analyzed and Designed extensive business applications.
  • Business systems experience includes Insurance, Pharmaceutical, Manufacturing, Sales and Distribution, Brokerage,
  • Customer Service, Accounting, Human Resources, Payroll, Financial (AR, AP, GL, Billing), Sales, Invoicing,
  • Allocation, Marketing, and Inventory among others.
  • Excellent exposures to Data Warehousing techniques like
  • Data Modeling, Mapping, Warehousing, Data Extraction, and Transformation & Loading. I have used the system development life cycle to develop applications.
  • I have good communication and interpersonal skills.

TECHNICAL SKILLS

  • LANGUAGES: COBOL II, OS/JCL, CICS/GTB/SDF II, EASYTRIEVE, IMS, IDMS, DB2/SQL/STORED PROCEDURES, MQ Series and FTP for porting Information to servers, Knowledge of C and JAVA, extensive use of ACCESS, EXCEL and WORD for analysis.
  • Confidential BASES: DB2, IMS, IDMS, ORACLE (People Soft), ACCESS, and VSAM.
  • ENVIRONMENT: OS/390/MVS, TSO/ISPF, CICS/ESA, CMS, VSAM, QMF/DB2I, OLQ/DMLO, MICROFOCUS COBOL WB File Aid for DB2/IMS/VSAM, Windows (95 2000, NT, XP), MS DOS.
  • APPLICATIONS: File Management: Confidential UTILITIES, FILE - AID (DB2/IMS/VSAM), SYNCSORT, IDCAMS, SDSF, RMDS. Data Transfer: Confidential MQ SERIES, FTP. Library Management: SCLM, LIBRARIAN, PC ENDEVOR, CA-11, CHANGEMAN, PANVALET. Database Development: DB2 - (SPUFI, DECLGEN, MERGECOPY, RECOVER, LOAD, REORG, and RUNSTATS). IDMS - (OLQ/DMLO).
  • Data Modeling: People Soft Oracle and IEF.
  • Development Tools: XPEDITER, VIASOFT/SMART TEST, CICS INTERTEST, EXTRA FOR WINDOWS Documentation: MS OFFICE Applications (WORD, EXCEL, ACCESS, PROJECT, and POWER POINT), VISIO.
  • HARDWARE: Confidential SYSTEM 30XX, Confidential PC, DELL and GATEWAY PC’s.

PROFESSIONAL EXPERIENCE:

Consultant,

Confidential, Bristol, PA.

Responsibilities:

  • Developed and implemented a Microsoft Access database for Accounts Receivable.
  • This system was developed from Source Documents (Billing Sheets) and check details from the Insurance Provider.
  • The database was fully normalized and included such information as date of service, amount due, paid, service type, therapist, check number, client, and invoice. System was upgraded to add a client demographic capability and a system for accounting for Medical Records Revenue.
  • This system was developed out of the accounting matching process of source documents against checks to reconcile that all that was billed was paid.
  • A JAVA application was written to maintain an Address Book containing demographics information.
  • Numerous reporting functions were developed to list therapist clients, list services provided, and other various audit functions.
  • I managed Accounts Payable and General Ledger by loading bank information into Quickbooks.
  • I produced Profit and Loss Statements and Balance Sheets for tax preparation and expense tracking.
  • I prepared Confidential Tax Returns for BCMHC from 2011 forward. Electronically collected all manual forms into Microsoft Word and used macros to produce client charts.
  • Terminated lease for Canon printer, replacing it with a purchased printer to eliminate monthly payments.
  • Removed old printer and installed new printer into BCMHC Network. Maintained and upgraded BCMHC Network for all PC’s. Upgraded phone system/internet from Verizon to Confidential, this provided voice mail capability which was non-functional on our old leased system.
Consultant.

Confidential, Weehawken, NJ.

Responsibilities:

  • Was responsible for developing and implementing upgrades to Documents on the DCS system.
  • Developed and implemented a CICS upgrade to allow multiple documents to be processed for options.
  • Developed and implemented templates to formulate International and Domestic Documents separately as well as maintain the master template of all documents available for each office.
  • Developed and implemented a Commission System upgrade for COBI which identified brokers with outstanding documents so they could be charged fees for missing documentation to enable greater SEC Compliance.
  • Downloaded various client based Reports from Brokerage Systems to Microsoft EXCEL reporting formats.
  • Used CHANGEMAN, DB2, VSAM, CICS, Confidential DEBUG Batch and Online to deliver various brokerage initiatives.
Consultant.

Confidential, Paramus, NJ

Responsibilities:

  • Was responsible for developing and implementing a CICS System to retrieve information from 7 different DB2 tables across regions for COW System.
  • Developed and implemented a CICS System to Update VSAM Control Table to control 7 different CICS Backend Applications for COW System.
  • Developed and implemented a CICS Utility to update two DB2 Control Tables across regions for the Claims on the Web System.
  • Responsible for modifications, enhancements, and production support of the Claims on the Web System.
  • Project included processing upgrades and cloning the Error Log Control Module within CICS for the Claims on the Web Phase Two Project.
  • Project included developing a new Input Output Module to work with the VSAM Control Table developed above to control the processing of the backend functions throughout the Claims on the Web System.
  • This would enable management to turn on and off specific systems and control commit thresholds and timing functions.
  • Developed and Implemented a Claims History Download Function which operated as a started batch task, this avoided allocating an initiator and was recycled each morning at 6 AM.

Consultant.

Confidential, Woodcliff Lake, NJ.

Responsibilities:

  • Was responsible for maintaining and upgrading code to Capture Cars which have been activated for Telematics Service.
  • Project grew from 400 cars a week to a full fledged 6000 per week being activated for the service.
  • Responsible for modifications, enhancements, and production support of Telematics.
  • Project included processing Rolls Royce, Domestic Production Feeds, and Canadian Vehicles weekly.
  • The Canadian Feeds have currently been consolidated into the domestic feeds to eliminate one process
  • Canadian Geo Coding was in effect until consolidation which involved Deactivating generic units and Activating Geo Coded Units.
  • Was responsible for the development of a consolidation of external Deactivation Feeds into one central deactivation conduit called The Sweep.
  • Developed an extract to ATX a vendor which supports On Star and Telematics to communicate and identify new activations Implemented the Everest Extract Process which feeds the universe of Telematics enabled cars to an Oracle Server for Business Unit Queries.
Information Systems Consultant.

Confidential, Bridgewater, NJ.

Responsibilities:

  • Moved to Production all jobs running out of TSO IDs in preparation for People Soft Conversion and Analysis so all processes were cataloged with balancing procedures for upcoming conversion activities.
  • Cleansed METFACS data in preparation for conversion from IDMS and DB2 sources into People Soft Processes.
  • Upgraded to most current release of IDMS so legacy support would not lapse during cutover to People Soft.
  • This included Upgrading IDMS to Release 14 and DB2 to Release Version 7. Migrated PANVALET/VM resources over to CHANGEMAN and TSO to eliminate VM to ease the conversion effort with source being centralized under one TP environment and to provide a way to search source more readily for elements to enable easier analysis.

We'd love your feedback!