PROFESSIONAL SUMMARY:

An IT professional having experience in data analysis, systems design, coding development/ maintenance & project management. Work experience has provided mainframe as well as server/client IT problem - solving skills. The work skillset allows the ability to contribute to single or multiple roles in an IT environment. Database experience ranges from mainframe DB2, Quickbase, Oracle, MS SQL & MSSql along with VSAM & sequential file processing.

SKILLS:

Quickbase, Cobol VS, Cobol II, Cobol MVS, Cobol CICS, Basic, Fortran, Pascal, Assembly, DB2, DB2 SQL, Clist, Rexx, Edit Macros, PanValet, Librarian, ESP, OMS, CA11, CA7, SAR, BUNDL, $AVRS, View Direct, TSO/ISPF, FileAid, FileAid DB2, QMF, QuikJob, Dyl280, Expediter, TraceMaster, AbendAid, Dump Master, InSync, Sort (SyncSort, DFSort, PLSort), VB.net Visual Basic, VBA (MS Office Suites Products), MicroFocus Cobol, PL/SQL, Access, HTML, PVCS, MS Project, Excel, Word, Power Point, Visio, Oracle 8, TOAD, SQL 7, MySQL, JQuery

TECHNICAL SKILLS:

Mainframe: Cobol VS, Cobol II, Cobol MVS, Cobol CICS, Basic, Fortran, Pascal, Assembly (ALC), TSO Clist, Rexx, TSO/ISPF Edit Macros, PanValet, Librarian, ESP, OMS, CA11, CA7, SAR, BUNDL, $AVRS, View Direct,, FileAid, FileAid DB2, QMF, QuikJob, Dyl280, EZtrieve, Expediter, TraceMaster, AbendAid, Dump Master, InSync, Sort (SyncSort, DFSort, PLSort).

Client/Server: VB.net, VBA Developer (MS Office Suites Products), MicroFocus Cobol, Access, HTML, JQuery, CSS, MS Exchange & Office 365 support, Domain & FTP server support, Windows XP, Vista, 7 8 & 10 support

Database: DB2, Quickbase, FoxPro, MySQL, PL/SQL, MS SQL, Oracle, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

IT Consultant

Responsibilities:

• Software development VB.Net/VBA, VBScript, SQL, Quickbase Administration (online web based database formerly owned by Intuit).
• Developed VB.net applications: vacation accrual for HR staff for reporting of staff time off. Data retrieved from Quickbase. interfaced biometric Foxpro database from FingerTec device to Intuit Quickbase
• Developed VBA applications to access Quickbase databases & automate User processes
• Inventory Management
• Field Tech Vehicle tracking System
• Outlook VBA
• Extract Flight/Vehicle Rental information & insert to Quickbase.
• Excel VBA
• Web scarping off Hotels.com to expedite Travel team financial reporting.
• Quickbooks applications:
• Generated .IIF files to feed into Quickbooks from Bank Credit card extracts
• Quickbase applications: designed from ground up, w/ Roles for specific duties and reporting for those roles.
• Set up email notification, subscription and reminder messages to various individuals or roles.
• Extensive use of Quickbase Formulas to merge/calculate data automatically for user viewing.
• JQuery page(s) setup to enhance Quickbase data queries to represent data that would not be available w/ standard Quickbase methods.
• Relationships to both internal table applications as well as external Quickbase table applications.
• Interfaced FAS SAGE to Quickbase using VBA in Excel/Word to reconcile source data (SAGE) to the data values Techs input into the online Quickbase. Excel VBA queries Quickbase tables and reads in SAGE extract to perform reconciliation. This allows more user access to Quickbase w/out having to “invite” user to Quickbase to view data.
• Trained assistant Quickbase developer
• Trained assistant IT hardware/software support personnel.
• Financial reporting, ie Projections, Cash Flow
• User assistance both in office & field tech support.
• Resolve issues with software vendors & techs.

Confidential

System Consultant

Responsibilities:

• Software development VB/VBA, VBScript, SQL, MS Access for client’s purchased vendor software.
• Installation & Maintenance of client networking, software & hardware issues on server & workstations.
• Participated in third party demonstrations to assist in evaluation of products for purchase.
• Worked on web-based Java project for 4 months using eclipse IDE.
• Directly communicate with client management/owners
• Documented work for both client & echsys2

Confidential

Senior Systems Analyst

Responsibilities:

• Enhanced processing on New Business and Inforce Issues designed by Users for new products. This required research of CyberLife programs/processes to isolate the ones that would require modifications.
• Created One-Time program/s for CyberLife file fixes for various segments.
• Performed Adhoc DB2 database updates via Cobol & File-Aid DB2.
• One fix involved modifying History Master as well as current Inforce Master files.
• Created Excel VBA to pull Actuarial data off spreadsheet into VPMS format to test accuracy of data in CyberLife using batch utility jobs.

Confidential

Senior Systems Analyst

Responsibilities:

• Modified and researched CyberLife programs & data that generated XML files to “BizLink” which adhered to the ACORD Insurance standards.
• Used File-Aid DB2 to update Masterfiles saving time coding a specific adhoc program.
• MIB Upgrade from mainframe processing to the Web Service.
• Worked w/ Confidential India on resolutions of Client-side problems.
• Worked on implementation of WSUL (Work-Site Univ. Life) products and AAB increases.
• Handled variety of New Business and Inforce Daily Support questions which resulted in mods to the CyberLife system. (i.e. CyberLife Browser on screen errors that were direct result of Host mainframe issues, Target Premium issues).
• Created new programs to automate “receipting” New Business Pending Requirements that received transmitted data from CRL, Lab 1 and EMSI.
• Handled applying numerous Confidential SPR projects.

Confidential

Senior Systems Analyst

Responsibilities:

• Supported processing lead data on DB2 from variety of Business Partners thru Aegon USA.
• Business Partners included numerous companies from Canada.
• Processed leads from DB2 Lead Management to Call centers based on Aegon USA criteria.
• Supported Business Partner that required travel to Seoul, Korea to process data onsite.
• Travelled to Seoul Korea along w/ Marketing Business partner to assist in data analysis. Data involved monitoring call center’s productivity and efficiency of marketing campaigns.
• Provided business analysis of billing for AIG Korea that resulted in recommendation of third party billing companies.
• Developed PL SQLs to assist Oracle data processing.

Confidential

Senior Systems Analyst

Responsibilities:

• Thomas Insurance Admin. System: Initially hired to work on the Assembly language Thomas Insurance Admin system. Typical work scenarios were to enhance code due to new products being marketed.
• Find and resolve problems in the Admin system that were detected by users designated to work on the insurance admin system.
• TMLM (initial version) and Combo LM (2nd version)Tele-Marketed Lead Management DB2 system: Assigned to code for the 1st version of TMLM that would provide JCPenney Marketing the data necessary to better manage the market products and reconcile w/telemarketing agencies any leads that may not have been processed.
• Assisted Marketing department in analysis of campaign progress. This required ETL of data from call centers to Cognos product such that management could use the dashboard to direct call center’s activity for increasing marketing campaign success.
• Supervised the Combo LM (new version of TMLM) that would enhance Marketing’s ability to put more products in the hands of the agencies per lead. Intimately worked with DBA’s designing initial database schemas and then implementing them.
• Used Declares in Cobol programs as well as standard SELECT/UPDATE/INSERT to process data in Lead Management DB2 system.
• Maintained milestones and other variables in MS Project for management awareness.
• Supported Insurance and Billing system areas in researching and pinpointing problems:
• Other Support Systems: Project lead on the development of peripheral support systems that would reduce user input errs. These errs caused policies not to issue due to product incompatibility w/the Insurance Admin system and/or cause incorrect billing to occur.
• These projects required telecommunications to liaison with an India consulting firm.

Confidential

Responsibilities:

• Assigned to conversion team to migrate policies from and old 62CFO Insurance admin to the new Vantage admin system.
• Support of Billing and Collections and other subsystems inherited from Confidential (detailed below).
• Set up new clients on the billing systems.
• Understand new or modified Insurance Admin products.
• Ensured client/policyholder billing was set up according to the policy product.
• Resolved billing problems that occurred due to insurance Admin errs or due to other processes that may have misdirected the billing to occur.
• Developed programs to find all policies that were incorrectly billed.
• Developed temporary programs to adjust billing dates to the policy on the Admin system.
• Developed temporary programs to re-transmit corrected transactions to the policyholder’s financial account.
• Developed temporary programs to correct ledger on the accounting system for policies that were incorrectly billed.
• Trained on the Vantage Insurance Admin system as this was the new insurance software for Confidential .
• Vantage Insurance system was developed in New Hampshire, USA.

Confidential

Responsibilities:

• Developed processes to notify system/users of potential incorrect billing to policyholders.
• Developed temporary billing logic to correct any of the 4 different Insurance Admin’ billing problems and coordinate with the Admin system for implementation of the corrections.
• Developed temporary processes to send account transactions to correct accounting ledger for the various billing errors.
• Communicated with banks and other financial institutions concerning:
• Data transmissions
• Resolved billing issues
• Set up new or altered billing processes
• Maintained, enhanced and eventually supervised ‘Southwestern Life’ billing system.
• The SWL billing was primarily credit card and direct mail billing. This was an older billing system that was developed by SW in Assembly language.
• Modifications to enhance the Insurance admin system for new products or variations of older products.
• Updated policies whose products were not initially set up correctly.
• Developed and maintained process where the Insurance admin would send accounting transactions to ‘McCormack and Dodge’ accounting system.
• Researched accounting discrepancies.
• Determined system that originated the incorrect accounting transaction.
• Generated correct accounting transactions to the ledger.
• Made corrections to IMS database due to incorrect processing.
• Programmed for the Civil and Criminal court systems.
• Modernized the Probate court to use the computer system.
• Developed the Victim Awareness system that notified victims of upcoming court procedures possibly related to their past court hearings.
• Assisted making minor court IMS database changes to maintain data integrity.