SUMMARY:

• Expert in analyzing technology and business requirements, has a strong accounting background and designs systems that are highly configurable. He anticipates the needs of his users and his systems stand the test of time. He is able to bring experience gained in many different industries.
• Extensive experience designing, scripting and analyzing Oracle databases.
• Strong functional knowledge of CC&B and expert understanding of the data model.
• As an Oracle SQL developer wrote PL/SQL, views, functions and triggers.
• Solid leadership abilities, has had the role of Architect, SME and Senior Developer on CC&B projects.
• Has the ability to drive the business process for the client, to work with the end user to obtain desired results.
• Proven business analyst skills, worked with end users to define requirements, developed functional and technical specifications, test cases and test scripts.
• Has designed, developed and installed company wide applications in several industries.
• Use SDLC (Software Development Life Cycle) methodology, proponent of the agile method of development.
• Has proven project management skills and is proficient in Microsoft Project.
• Has outstanding oral and written communication skills.
• Proven utility experience, worked with meter reading, billing, interfaces, work order management and collections for large utility companies.
• Twenty plus years UNIX and COBOL development experience.

EXPERTISE AREA:

• Product Development
• Technology Goals/Issues Definition
• Software Development Life Cycle Planning
• Project Management
• Coding/Troubleshooting/Debugging
• Testing/Scripting/Documentation
• Solutions Engineering
• End User Training & Support

TECHNICAL SKILLS:

Mainframe: MVS JCL, IMS, DB2, QMF, SPUFI, VSAM, TSO/ISPF, Panvalet, Librarian, Tivoli Output Manager, Tivoli, Scheduler, Princeton Utilities, SyncSort, Easytrieve, TOM

Midrange: Unix (HP - UX, SCO, AIX), MPE, IMAGE, VIEW, ADAGER, Putty, Vi, and TOAD

Network: Microsoft SQL Server 2008, SQL Server Management Studio, DTS, SSIS, Windows XP, Oracle 11g, SQL Developer,Rapid SQL, SQL*PLUS, ODBC, Microsoft Office, MS Project, Visio, Micrografix, Crystal Reports, SourceSafe, PVCS, PGP, Image Caf, Test Director, Coffee Cup HTML Editor, PowerTerm, SharePoint, Quality Center

Languages: OS/VS COBOL, MicroFocus COBOL, Microsoft Access, Visual Basic 6, Transact-SQL, Stored Procedures, UNIX Scripts,InstallShield Developer, HTML, Perl, Java

Databases: Microsoft SQL Server, Oracle, DB2, Sybase

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

Business Analyst/Senior Developer

Responsibilities:

• Defined field activities for AMR installation and make Oracle CC&B configuration changes, setup dispatch groups, operation areas and field activity characteristics.
• Built Triggers on the customer name, premise and meter tables to capture online demographic changes.
• Added database tables to capture the premise id on demographic changes.
• Created Cobol program to produce XML files to update the customer care system for specific field activities and demographic changes.
• Created Cobol program to update meter and item inventory from flat files sent by the manufacturer.

Environment: Oracle DB 11g/UNIX, SQLDeveloper, SQLPLUS, Putty, Filezilla, Micro Focus Cobol

Confidential, Merrillville, Indiana

Business Analyst/Senior Developer

Responsibilities:

• Created Cobol program to create extract for the CMA consumer protection program data.
• Created Cobol program to extract for ARCA Appliance Recycling files. Also produced Opower and Franklin Energy Program files for consumer energy usage reporting systems.
• Standardized the meter reading codes used across all companies.
• Made database design and structure changes based on the project requirements.
• Updated the C# XML interface program to create NIE import and export files.
• Worked with adTempus job scheduling system.
• Changed Cobol interface between the mainframe billing system (CIS) and FCS.
• Configured FCS for the production environment and generated production JCL.
• Developed test procedures, test scenarios, test cases and test scripts for the NIE companies.
• Identified problem queries and optimized them to increase their efficiency and reduce run time. Took a group of the month end jobs runtime from 40 hours to 4 hours based on my SQL changes.
• Interacting with the other developers on an ad - hoc basis and resolving their issues based on their queries.
• Confidential has 10 million gas and electric customers.

Environment: DB2/IBM z/OS v1.11, QMF,MVS JCL, TSO/ISPF,Librarian,Tivoli,TOM,OS/VS Cobol

Confidential, San Francisco, California

Oracle PL/SQL Developer/Tester

Responsibilities:

• Built SQL queries to extract test data from the Oracle CC&B billing tables.
• Responsible for testing of Customer Billing and Third Party Supplier systems.
• Produced testing strategy and test plans. Developed test procedures, test scenarios, test cases and test scripts.

Environment: Oracle DB 11g/UNIX, SQLDeveloper, SQLPLUS, Putty, Filezilla

Confidential, Cleveland, Ohio

Business Analyst/Lead Developer

Responsibilities:

• Created functional and technical requirements for the required interface and wrote the Cobol interface programs.
• Made necessary configuration changes, define new service agreement types etc.
• Designed test plan, identified test conditions, chose accounts to test based on the test criteria and made the necessary data changes so the accounts would bill. Monitored and documented test results.
• Created SQL to extract and analyze test results, exported results to Excel table.
• The Service Line Interface enrolled accounts in the program, canceled delinquent service agreements and sent financial transactions to Dominion a third party service provider
• This project increased CWD revenue and allowed them to offer additional services to their customers

Environment: Oracle DB 11g/UNIX, SQLDeveloper, SQLPLUS, Putty, Filezill, Micro Focus Cobol

Confidential, Warrenville, Illinois

Architect/SME/Business Analyst/Lead Developer

Responsibilities:

• Wrote business and technical requirements for the legacy billing project. Re-wrote the Cobol legacy interface program with threading and restart recovery.
• Developed the testing methodology to ensure that the data that was being sent to the billing system was in balance with the host system and was the same that had been produced in the old interface. Created SQL queries that extracted data from both the baseline and regression testing and loaded them into comparison tables. Wrote SQL join queries to compare the results and show any out of balance amounts.
• Worked on extracting data from billing flat files, transforming and massaging it and loading it into the database billing upload staging tables.
• Changed and tested rate components, rate service quantity lines, rate message lines and rate G/L distributions for new bill components.
• Was SME for the CC&B billing interface upgrade from version 1.5 - 2.2 and was responsible for producing a fit/gap analysis between the releases. Also analyzing already developed PL/SQL packages and procedures used in the billing process for faster processing by using explain plan.
• Technical Lead on the Customer Select enrollment and payment processing projects using the CC&B interface tables. Worked on the COBOL programs that extract data from flat files, transforming and massaging it and loading it into the database (ETL process) in a format acceptable to the upload staging tables.
• Redesigned custom meter reading interface upload program (COBOL) which would look at high/low reads to determine if, based on various characteristics, the read could be valid.
• Designed and created test bed tables used to identify accounts that could be used to test various billing scenairios.

Environment: Oracle DB 10g/UNIX, SQLDeveloper, SQLPLUS, RapidSQL, Putty, Filezilla,Micro Focus Cobol

Confidential, Waukegan, Illinois

IT Manager/Architect/Business Analyst/Senior Developer

Responsibilities:

• Worked with the Fringe Fund Office staff to develop a Medical Claims Processing System used to pay participants medical bills for a self-insured Taft Hartley Labor Fund. System is used by an 800 participant fund office to pay their participants medical bills with a minimal staff
• Eligibility for Welfare is determined by contractor contributions.
• Allows for multiple health plan support
• Can processes up to three years of claims concurrently
• Checks for duplicate claim and procedure
• Allows for out of network and failure to pre-certify penalties
• Uses standard medical ICD9 coding for procedures, diagnosis etc.
• Can use reasonable and customary checks on Medical, Dental, HCPCS, Anesthesia and Outpatient Facility procedures (ADP Context)
• Electronic interface to Confidential of Illinois
• HIPAA 4010 EDI compliant electronic claims interface
• Has the ability to set yearly or lifetime limits on specific types of claims (either dollars or visits)
• Allows for fixed rates on specific procedures
• Deductible calculation is based on family and/or individual
• Has a separate deductible for dental and orthodontia claims
• Co-pay percentage is based on maximum out of pocket
• Claims are entered immediately into the system and will remain in a hold status until processed
• Automatically produces correspondence requesting missing or incomplete information from the participant
• Produces deductible, denial and explanation of benefit letters to employee and service provider
• System uses ICD9 coding for diagnosis and procedures
• Uses reasonable and customary checking for procedures from outside R&C providers (Medicode, ADP Context).
• System allows for death/dismemberment, coordination of benefits and prescription drug reimbursement benefits.
• Interfaces to CMS (Medicare) and RDS (Retiree Drug Subsidy) programs. Currently modifying system to use IDC10 coding and HIPPA 5010 EDI record layouts
• Maintain participants medical records
• Pay claims through BCBS, direct deposit or fund office check.
• Check reconciliation module.
• Multiple company, location General Ledger.
• Call Center module including, medical claim history and participant contact history.
• Worked with the Fringe Fund Office staff to develop a Pension Processing System used to record the hours/dollars paid on behalf of the participants for their pension.
• Eligibility for Pension is determined by contractor contributions.
• Calculates vesting and service credits.
• Payment to retirees by check or direct deposit.
• Worked with the Fringe Fund Office staff to develop a network based Taft-Hartley labor fund system which automates all activities of the fund office including contractor contributions, participant’s pension, medical benefits, cash disbursements, check reconciliation and general ledger.
• IT manager responsible for network and database administration, migration and planning, equipment installation, software upgrades and training.

Environment: Oracle DB 10g\Windows Server 2008, Microsoft SQL Server 2008, SQLDeveloper, SQLPLUS, SQL*Loader, ODBC,UNIX, Micro Focus Cobol