OBJECTIVE

• Senior IT Analyst in search of a rewarding position as a senior technology leader in a web based, client/server, or mainframe environment utilizing state of the art analysis and development tools.

TECHNICAL SKILLS

Languages/Utilities/Software: COBOLII, JCL, Syncsort, TSO/ISPF, Clists, Fileaid, DB2, IMS, VSAM, IMS DB/DC, CICS, MFS, MVS, ZOS, Intertest, Xpediter, MS/Office Suite, C, ProC, SQL*Plus, PL/SQL, Visual Basic, C++, ASP, HTML, Javascript, VBScript, Java, SQL Server, Access, Oracle, UNIX, MS/Project, Visio.

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Wrote and maintained programs used for reading Policy and Claims data and providing the information to Health Care Providers, Policy Holders, and other Health Care Specialists.
• Collaborated with DBA’s to develop new DB2 tables and add new columns to existing tables as normal Project Life Cycle Development.
• Designed conversion processes to extract Policy and Claims data from VSAM files to logically designed flat files which are then used to load selected data to DB2 tables for use in reporting.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Project lead analyst for Accounts Receivable and Finance systems which provide web, client server, and mainframe solutions for Credit analysts, Revenue Owners, and Financial Accountants.
• Provide detailed analysis and design of small to medium sized systems which interface with larger mainframe packages to enable revenue collection and cash flow, as well as feed the General Ledger Confidential month end close to ensure reconciliation of financials. All project deliverables completed on or ahead of schedule 100% of the time.
• Integrated vendor package system with interfaces from Custom Accounts Receivables System. This Client/Server 3 - tier system enables revenue associates to track payment trends and late or near late payments and allows automated triggered emails and faxes of invoices to past due accounts. The system reads customer account and invoice related files sent via FTP from AR and updates open invoices as appropriate. Implemented the system which delivered an increase of on-time payments by 30%.
• Designed relational databases for payment EDI transaction (820) and Credit/Debit EDI transaction (812) for use in a DB2 integrated environment. These payments tables are used in joining other system data from the front-end ordering systems (850, 810 data which is also in table format). Realized $700,000 annual savings with project implementation.
• Designed and programmed a Cycle Counts website to support a Warehouse Management system. Written in ASP with an ODBC connection to Sql/Server, the site provides data entry forms to accumulate scheduled physical inventory counts of Confidential & Confidential products as well as periodic unscheduled counts. The site also provides management reports for inventory metrics.
• Support the Accounts Receivables system for Confidential & Confidential Consumer Products. The AR system includes both vendor customized on-lines CICS system and internally developed processes with interfaces from the bank (BOA), EDI transactional process, AR preprocessor (for validating/formatting data), order/invoicing system, promotionals system, and to the General Ledger system and Getpaid Client/Server System. Designed and coded production efficiencies and tuning, reducing run-time/cost by 70% for daily batch schedules.

Confidential, Philadelphia, PA

Consultant

Responsibilities:

• Modified an Inventory system for a textile manufacturing business.
• Written in Java and HTML, the manufacturing inventory site provides a more detailed breakout structure of various components of threads including their raw material costs, inventory stock on-hand, and materials ordered in the pipeline.
• Made changes to Inventory system to expand components structure within Oracle database.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Designer and developer for the Enhanced Order Tracker System which provides order completion processing and order recovery.
• Developed and maintained EOT’s profile processing which updates to and downloads from an ORACLE database and utilizes ProC in a UNIX environment. EOT interfaces with a mainframe/DB2 environment which transfers files back and forth from UNIX.
• Incorporated various systems knowledge and experience to provide an efficient and sound system.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Project leader responsible for the coordination, delegation to three team members, and support of the Online Service Order Entry System which provides a service order vehicle to any customer wishing to use Confidential &T, Universal, or Confidential calling or credit cards.
• Lead designer and developer of a mainframe on-line system written in COBOLII with MFS as well as a GUI front-end add-on written in Visual Basic with a DB2 interface to store service order information.
• Presented OSE system with both view graphs and hands-on demonstrations to potential customers Confidential various meetings.
• Ensured project schedules were maintained and deadlines met.
• Mentored new team members on the project.
• Retrofitted Y2K code to avoid future system failures.