SUMMARY

IT Professional with a successful twenty-five year track record in managing, analyzing, developing and maintaining enterprise software applications within the areas of Commercial P C Insurance, Reinsurance, Finance and Manufacturing domains. Proficient in all phases of the software development lifecycle SDLC ranging from project planning to user acceptance testing UAT . Reliable and committed in meeting with business segment stakeholders, obtaining business requirements, managing resource teams, creating project plan requirements, scheduling timelines, project status and ensuring quality assurance.

TECHNICAL SKILLS

Project Management: Custom Software Development, Database Design RDBMS , System Interfaces, EDI Data Exchange

COTS/ Tools: Access, Aldon, AlFresco, Business Objects, Citrix, CSC, DB2, EDI, Excel, Explorer, Genius, GoAnywhere, HPQC, ImageRight, Implementer, Lawson, Lync, Outlook, Oracle, Power Point, PRMS, Project, Salesforce, SharePoint, SQL, UNIX, Visio, Word, Zendesk

EXPERIENCE

Confidential

• Independent Consultant providing professional IT project management, analysis, software development and delivering overall quality assurance.
• Administers all phases of the SDLC to develop software application interfaces to procure medical insurance claims interface applications. Conducts project management, system analysis, meets with applications development team, verifies testing, data governance and quality assurance of ETL projects to produce EDI data exchange processing of insurance claims. Interacts with stakeholders to obtain project requirements, create project plans, facilitates meetings, produced project proposals, defined resources, and developed documentation.
• Performs data modeling, data mining and creates SQL script to analyze claims staging and database files. Conducts data compliance stages by building test cases, conducting regression tests and deploys quality assurance testing. Creates projects plans to implement project applications of: CMS COBA employee eligibility data file exports, ETL of client pharmacy drug claims, claim payment reporting and 1099 tax payment report processing.

IT Project Manager

Confidential

Managed staff, analyzed, developed and supported IT Property and Casualty Insurance and Financial software applications.

• Responsible for the IT project management, overall SDLC and support of MGA Commercial P C insurance applications within Underwriting, Claims and Accounting/Finance areas. Met with business stakeholders to collect project requirements and conduct storyboard sessions. Created MS projects plans and functional specifications based on the business requirements. Developed data flows, Visio data flow charts and Excel data mappings to layout tables and database schemas. Performed data mining utilizing SQL to accurately interpret and map CSC data formats. Met with development staff and consultants to communicate project scope requirements, SQL project specifications and deadlines. Communicated IT project status with business managers and IT executives while maintaining IT project budgets.
• Organized meetings with IT development staff to understand project status and project deadlines. Ensured all developed IT projects accomplished unit/regression testing and verified the change management implementations for enhancement related projects. Attended weekly meetings with stakeholders and management to communicate status of IT projects. Analyzed, recommended, upgraded and maintained third-party vendor software applications and oversees quality control throughout the SDLC project life cycle. Ensured data quality assurance for all IT projects to ensure that the data governance, data compliance, quality assurance and user assurance testing UAT was achieved. Projects included: Property and Casualty claim ETL data transfers, revising Case Detail reporting to correctly declare claim payments, reserves, subrogation and total incurred amounts, creation of procedures to produce Policy and ISO Claim reporting.

IT Consultant

Confidential

• Developed, enhanced and tested user-exit programs, database files and display screens within a Lawson HRIS/ Financial system. Created file transfer solutions to export electronic funds transfers EFTs consisting of ACH file formats. Develops automated invoice payment systems that permit the reconciliation and approval of individual invoice records.
• Analyzed, developed and tested HRIS applications to extract and transfer Lawson Employee Human Resource Benefit data to life/health insurance carriers of MetLife, John Hancock and Aetna. Produced ETL data file information relating to employee long term care, employee disability wages, health/dental insurance plans, Cobra payment benefits, flexible spending data and other payroll deduction amounts. Utilized Implementer change management software to promote projects from test environment to production.

IT Consultant

Confidential

• Designed, developed, maintained and supported custom IT claims programs on IBM iSeries/AS400 servers to establish the production of an automated P C claims interface to process multiple insurance carrier import files. Designed and developed RPG, CL and SQL programs to extract, transform and load TPA/CSC claim data feeds. Ensured that all IT projects were rigorously tested and met with users to establish quality assurance testing.
• Administered full SDLC methodologies to deliver IT solutions by creating insurance claims reporting that reduced processing time by 30 . Facilitated meetings with IT staff, claims users and all stakeholders to collect IT project requirements. Conducted project interviews and storyboard sessions with business users to procure project solutions. Created MS Project solutions to communicate tasks, resources, timelines and completion status.

IT Consultant

Confidential

• Analyzed, developed, maintained and tested RPG programs to create an insurance agency data interface system. Communicated with IT managers and stakeholders to gather project requirements. Analyzed project requirements and developed automated Agency ETL applications that imported and processed original, renewal and endorsed policy data to the Genius database system.

• Performed root cause and impact analysis to determine issues occurring in the Genius claim reserves which originated from a recent software upgrade. Researched, analyzed and deciphered the issues and modified user hook programs to auto-confirm outstanding claim reserves within Genius applications. Utilized MS Excel to reconcile data and conducted various levels of unit and regression testing to ensure successful program delivery and user quality assurance.

Senior Analyst/ Developer

Confidential

• Analyzed, created, maintained and tested a custom proprietary insurance to GL interface system. Interacted and gathered project requirements from IT team members and users. Analyzed and created custom RPG and CL programs to extract insurance transactional records from the Genius applications database.
• Developed automated GL interface that extracted data elements from the Genius reinsurance application system to collect premiums claims payments claim reserves cash journals foreign exchange FX rate and calculated unrealized FX
• loss/gain data and posted data elements to the Lawson General Ledger system. Created SQL queries to validate extracted statistical data to ensure the information is accurate mapped corresponding Lawson General Ledger accounts and ensured accuracy of the GL accounts balance.

IT Manager

Confidential

• Interacted with all levels of users to create project plans, facilitated meetings, produced project proposals, defined resources, and developed documentation. Maintained, tested, supported and implemented PRMS ERP, EDI Mapping,
• processed EDI transaction sets of 850, 856, 857, 810, 210, etc. Supported the PRMS ERP system processing of manufacturing, orders, sales, financial systems on IBM iSeries and AS/400 servers. Created ad-hoc reports utilizing Crystal Reports to report sales order, purchase order, back order and inventory data by product and sales territories.
• Developed and applied infrastructure to complete the acquisition of a Canadian manufacturing plant. Created new RDBMS members and enhanced in-house RPG ILE and CL Sales programs to process new data from a new business venture. Procured and supported network installations of DSL, ISDN, Frame Relay and T1 networks. Developed and proposed plans to perform the hardware migration of an AS/400 model 170 to an iSeries model 270 server. The migration improved system resources, provided faster retrieval of data and increased user productivity by 25 .