SUMMARY:

Hardware: IBM z - Series Mainframe S/390, IBM i-Series AS/400, IBM PCs

Software: Mainframe Cobol/Cobol II, DB2, SQL, SPUFI, QMF, CSP, CICS, IMS DB/DC/BMP, DL/I, MFS, IBM MQ Series, Easytrieve, SAS, MARKIV, GENERATION V, ADF, File Aid, VSAM, JCL, CLISTS, TSO/ISPF, DMS Panels, Sync Sort, FTP, Panvalet, Intertest, Expeditor.

AS/400: COBOL/400, SQL/400, DFU, CL

IBM PC: Access, Visio, Oracle Express, Visual Basic, Excel, Word

Web Development: HTML, XML, Frontpage, Adobe Dreamweaver, Adobe Photoshop, Javascript,Perl and CGI.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Mainframe Integration

• Integration and stabilization of Revenue Cycle, Customer Service System (CSS) Order Management System. The system was migrated from SAP 2.0 to a Mainframe COBOL, CICS/CSP, DB2, Legacy System with the merger of Glaxo Wellcome and SmithKline Beecham.
• Converted seven years of Orders and Invoices historical data.
• DB2 data extracts from CSS Order Management System using SQL Queries.
• Performed system enhancements to new system.
• Researched EDI issues.
• Extract data from the mainframe to transfer to a Unix Server Data Mart (Oracle Databases). The Data Mart was accessible to end users via Hyperion Brio Reporting Tool.
• Develop interfaces with Ecommerce, Vaccines and Flu Direct Ordering websites.
• System modifications to process return goods.
• Responsible for the support of the Legacy System ($90m daily) while development team migrated to the new JD Edwards Order Management System.
• Decommission old Legacy CSS Order Management System.
• Function as System Security Administrator granting business area users access to appropriate system transactions, while meeting the requirements of Sarbanes-Oxley Controls.
• Perform Quarterly Sarbanes-Oxley Security and System Change Controls and participated in the quarterly testing of those controls.
• Produced investigative queries for Litigation Support .

Confidential, Delaware County, PA.

Mainframe Developer

• At Conectiv Power Delivery developed a new batch extract process from Conectiv Customer Care, COBOL CICS/IMS Billing System. Extract files were transferred to a Unix Server and loaded into the new Conectiv Outage Management System Oracle Database.
• Developed new CICS/MQ Series transactions. A message written by a front-end Visual Basic program is read containing selection criteria. Data is retrieved from Conectiv Customer Care IMS databases. A reply message in XML format is written to the message queue.

Confidential

Certified Web Specialist Training

• HTML topics including hyperlinks, image mapping, lists, table, frames and forms.
• Coding Tools including CCS, Java, JavaScript, CGI, Perl 5.0, Java Applet, ASP, VB Script,
• Software Packages explored: Dreamweaver2, Flash 3.0, MS Frontpage 98/2000, FTP, Adobe Photoshop 5.0.

Confidential, Parsippany, NJ

Data Transmission Analyst

• Converted ACH/ARP banking transmissions from CoreStates IBM 3090-based IMS DB/DC communications application, ATF (Automated Transmission Facility) to First Union’s Tandem-based DataExpress application.
• Data transmissions included inbound and outbound, both asynchronus and bisynchronous, receivables, Payroll, LockBox, EDI, Share Drafts, Mailbox and other miscellaneous transmissions.
• Conducted telephone interviews with customers to determine the type of transmissions, customer’s communications package, protocol, file name and modem speed.
• Created profiles and schedules within DataExpress, based upon information obtained from ATF and customer interview.
• Created logon records and communication scripts (i.e. Kermit, Procomm, PcAnywhere) to be sent to customer and re-compiled at customer site.
• Created and modified JCL.
• Performed scheduled testing and production migration.
• Updated MS/Access Database with results of tests, customer contact information, and production cutover dates.

Confidential, Glenolden, PA

Senior Programmer Analyst/Consultant

• In the Sun Co. Lubricants Marketing System area supported PC packaged software purchased from Application Consulting Group in Morristown, N.J.
• The ACG Forecaster structure is a PCExpress Version 4.8 database with an Express EIS front-end.
• It was designed to help analyze historical sales data and prepare future sales forecasts.
• Sales projections were prepared statistically or manually.
• Individual salesrep territory files are exported out of Forecaster and transferred to salesrep laptop’s via ExcelleNet.
• Files are updated in Suncast, a spreadsheet application. Suncast was developed in Microsoft Visual Basic 4.0 using an underlying Microsoft Access database structure. A third party custom grid control call Formula One was used to develop the interface structure.
• Generated Unit Level Profit and and Loss Statements for Sun Co. Brand Marketing Systems.

Confidential, Newtown, PA

Data Processing Consultant

• Developed new IMS application to keep track of VISA Credit Card purchases for CoreStates BankPurchases. Upon the arrival of a monthly file of outstanding VISA debits and credits, authorized users reconcile the total purchases of their Visa Statement against the on-line entries entered for the reporting period. System consisted of IMS MPP and BMP processing.
• Part of a team to convert data for the Customer Subsystem of an Integrated Merged Health Care (IMHC) System. Other sub-systems included Chargebacks, Contracting, Product and Sales History. New system was developed on the AS/400 with SQL tables. Customer data was converted from mainframe applications. Conversion jobs and ongoing production synchronization jobs back to mainframe applications were developed using COBOL and SQL/400.
• Converted S/36 data to an existing production MVS CICS VSAM system. The conversion was needed when Independence Bank became part of CoreStates Bank. The application was a Real Estate and Construction Finance System (CLCS, Data Select Systems, Inc. ). S/36 files were copied to tape and shipped. Tapes were received and files were downloaded to MVS sequential datasets. Files were run through a series of conversion programs. Conversion programs were modified extensively to satisfy user requirements.

Confidential, Bala Cynwyd, PA

Senior Programmer Analyst/Consultant

• Performed in an exemplary manner in all phases of requirements definition, system analysis and design, and implementation of programming projects. Covering a broad range of Accounting, Financial, Distribution, Municipal and Insurance Applications areas. Extensive system development on a wide range of mainframe, midrange and microcomputer systems. Outstanding user interface skills.