Skills:

• IT Business Data analysis, developing requirements, and program development for leading industries including finance, healthcare, and Insurance
• Experienced Mainframe developer using COBOL, CICS, ASSEMBLER, PL/1, JCL
• Database experience including VSAM, DB2, ADABAS, MS Access, SQL Server
• Experience in transferring business analysis requirements to specifications for developers
• Experience is design and development of drug utilization review technology to prevent accidental misuse of prescription medications and drug combinations based on medical databases
• Research methodologies including: data validation, aggregation of data, and data reporting
• Experience in life and casualty insurance, health insurance, and re-insurance
• Experience working with multiple stakeholders including business, IT, and subject matter experts
• Developed health risk factors, drug to drug interaction rules, compensation rates analysis
• Demonstrated interviewing techniques, data analysis, and problem solving skills
• MBA, and M.Sc. in Computer Information Systems
• Experienced communicator, listener, and problem solving skills

Work experience

• Computers: Mainframe, PC, Operating system: Windows, Unix, Web, .NET
• Languages: COBOL II, CICS, ASSEMBLER, C,C ,C , Java, Java script, HTML, Visual Basic, Microfocus COBOL, PL/I
• Databases: DB2, MS Access, SQL Server, RACF, VSAM, ADABAS with NATURAL language
• Utilities: TSO/ISPF, Xpediter, Syncsort, BMC for DB2, File Aid, Endevour, Easytrive, ChangeMan
• Expert in Microsoft Office products including Word, Excel, Access, Power Point, and Microsoft Project, VBA.
• Statistical package: SPSS, SAS
• Development tools: ADW CASE, PowerBuilder

Confidential

Co-owner of Healthcare provider company

• Manage the development of Office manager PT Notes , a PC software for small healthcare offices. The software provides Patients Scheduling, Payments, Accounting modules, and reposting function including Claim form printing HCFA 1500. Language used Visual Basic with MS Access DB and Microsoft SQL database connectivity.
• My responsibility include business requirements gathering, writing program specifications, writing test scenarios, writing some of the code, and testing the package.

Confidential

Consultant, Project Leader

Manage the Customer Outreach development team working to support a class action suit. My team and I were responsible for the development of data mining rules and external data acquisitions to assist in resolving client compensations as result of class action lawsuit. I wrote several programs to extract information including policies' classifications that were used to analyze the projected settlement cost. Some programs were written in Assembler to access proprietary database, reports were written in COBOL II. Data analysis was done using SAS extraction to export to Excel spreadsheets and then manipulated further to create high level financial results based on assumption rules. Developed data versions capacity to track changes in data and decision history. Some data was loaded onto DB2 database to track down clients' claims, and COBOL II programs reported from that database.

• We team also wrote applications for Prudential reengineering Demutualization efforts. Accomplishments include development of several Client/Server applications written in Visual Basic for handling various tasks within the Customer Complaints System. Database used is SQL Server. Languages: COBOL II, , Assembler, DB2, JCL, SyncSort, Easytrive, VB, C , SAS

Confidential

Project Leader

Accomplishments: Reengineered the Mutual Fund Variable Price Financial History data repository, converting VSAM files into DB2 Database. These efforts included writing programs in Assembler to access compressed legacy data, COBOL II to analyze and than convert the VSAM to sequential files, and DB2 utilities to load the data to DB2. The result was a 500 Million row database available 24x7 for both Batch processes and On-line inquiries. Developed process and Logical data models, designed database and tables. I wrote several COBOL CICS programs that use voice commands to allow users to access their data over the phone. Optimized database for size and for handling mass row update and customer inquiries simultaneously. Efforts include, column distribution using statistical usage analysis, partitioning of large tables, and the use of index type 2 definition combined with the UR clause. Implemented backup and recovery procedures that allow partial table recoverability of several generations back. Languages: COBOL II, CICS, Assembler

Confidential

Project Leader. Managed the Drug utilization Group. Responsible for DB2 application development, implementing and maintaining client requirements. Worked with clinical staff to develop drug utilization review technology to prevent accidental misuse of prescription medications and drug combinations based on medical databases Develop state of the art Rule based software for an instant Drug Utilization Review to provide safety and healthcare managed decisions for point-of-sale drug dispensing nationwide. Worked on application performance improvement using Assembler routines to access clinical rule tables in memory under CICS region, and COBOL II applications that provide instantaneous clinical decision making response with 700,000 inquiries a day. Languages: COBOL II, CICS, Assembler, Tools: TSO, ChangeMan

Confidential

• Project Leader and Manager of DB2 multi-project development efforts.
• Responsible for the development of the future US Customs system, a client/server Power Builder application under Windows.
• Responsible for the development of Military Contract shipment application comprises of tracking, rating, invoicing and accounting functions.
• Developed Data and Process models, Evaluated Database design alternatives, Designed DB2 database for the Military application, Construct application using the ADW CASE, and PowerBuilder tool.
• Manage the development efforts of multi-projects within the Military Business Initiative.
• Evaluated PC platform for Distributed software packages and implemented an Infront software package that communicated with CICS application for exchange of data.
• Conduct training classes for programmers and analysts in SQL Concepts, DB2 Application Design and ADW CASE tool - Design and Construction.

Confidential

Project Leader/Manager for two groups of 12 people combined.

• Application type: Trailer Tracking system.
• Responsible for a group of 12 developers that maintained large interconnected Mainframe and PC application which controls the flow of trailers in North America.
• Full development life cycle experience from Analysis to Design and Construction with a conversion project from VSAM to DB2. The new software used COBOL/II for both CICS and Batch programs using SQL embedded code to access the DB2 Database.
• Responsible for a project to rewrite the legacy application into SQL base database and Client/Server approach. Project activities include the following: Database Design, Business Analysis, Logical and Physical Analysis, Capacity Planning. Database design by Normalization and later on tune up of the Database by denormalizing and redesigning of some applications to increase performance. The application supports Reports printing on a local PC printer LPT1: , Remote printer or using a PC with IRMA card.
• The application has a front end PC software written in C using NOVEL Token Ring LAN to share the data locally and File Transfer IBM SDLC GATEWAY to send data to the mainframe - CICS region. Languages: COBOL, CICS, Assembler, C, File Aid, Endevour, Easytrive, Xpediter CICS

Confidential

Project Leader of group of 6 people.

Application type: Accounting. Responsible for tickets processing system, part of the airline accounting division. Languages: COBOL, CICS, Assembler, Database ADABAS with NATURAL language

Confidential

Consultant, Leading development project.

• Application type: Reinsurance Accounting system
• Responsible for the development of an on-line Accounting system - from user requirements, system design and leading the development. Languages: COBOL, CICS, Assembler. Database ADABAS with NATURAL language

Confidential

• Senior Programmer/Analyst in the department for Technical Assistance, section of On-line Applications. Application type: Banking/Brokerage
• Experience: CICS application system which connect and service Personal computers to the Main frame. Banking transaction with interest calculations. Brokerage transactions - stock rates foreign currency exchange rates. Languages: COBOL, CICS, Assembler, PL/I, TSO, Easytrive