SUMMARY:

• IT Professional with a successful track record in managing, analyzing, developing and maintaining enterprise software applications within the areas of Property/Casualty Insurance, Reinsurance, Finance and Manufacturing domains.
• Proficient in all phases of the software development lifecycle (SDLC) ranging from project planning and business requirements 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:

IT Projects: Custom Software Development, Database Design (RDBMS), System Implementation, System Interfaces, ETL Data Warehousing, EDI Data Exchange

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

PROFESSIONAL EXPERIENCE:

IT Business Analyst/ Consultant

Confidential, Sandy Hook, CT

Responsibilities:

• Meets with business stakeholders to understand and define the business requirements of Lawson HRIS IT projects. Analyzes requirements and develops business requirements documents (BRDs) and functional specifications to scope the ETL enhancements of a major HRIS employee benefit and timekeeping system interface. Forms a liaison with IT teams to manage the data interface upgrade between a Lawson HRIS system and a new Kronos Cloud - based application. Ensures that IT projects successfully complete the SDLC phases and data quality assurance.
• Administers all phases of the SDLC to develop software application interfaces to procure employee benefit administration and medical insurance claims interface applications. Conducts project management, business analysis, meets with applications development team, verifies testing, data governance and quality assurance of ETL projects to produce EDI data exchange of employee insurance medical benefit claims. Interacts with stakeholders to obtain project requirements, create project plans, functional specifications, facilitates meetings, produced project proposals, defined resources, and developed change management documentation.
• Performs data modeling, data mining and creates SQL script to analyze claims staging and database files. Meets with IT team to deploy business projects and conducts data compliance stages by building test cases, conducting regression tests and deploys data quality assurance testing. Creates Business Requirement Documents (BRDs) to develop COBA/CMS employee eligibility data file exports, Client Pharmacy RX Drug Claims file imports, Claims Payment Report processing, and 1099 Payment Tax Reporting.

Project Manager/ Business Analyst

Confidential, New York, NY

Responsibilities:

• Responsible for the IT project management, business analysis, overall SDLC and support of MGA Commercial P&C insurance applications within Underwriting, Claims and Accounting/Finance areas. Worked in a functional organization within a JAD methodology and BABOK; met with business stakeholders to collect project requirements and conduct storyboard sessions to develop policy life-cycle and claims projects. Created Business Requirement Documents (BRDs) and functional specifications based on CRM Salesforce requirements.
• Developed data flows, Visio data flow charts and Excel data mappings to layout tables and database schemas. Performed SQL data mining to accurately align and map CSC data formats. Hosted meetings with IT teams to communicate project plans/functional specifications, deadlines and monitored project status. Hosted meetings with business managers and IT executives to communicate IT project status. Created Claims Bordereau to report claims and reserve detail data to clients using MS Excel.
• Created Functional Specifications and Business Requirement Documents (BRD) for Property and Casualty Claim ETL File Transfers, Claims Detail Reporting (including Claim payments, reserves, subrogation and total incurred amounts) and Policy/Claim ISO reporting.

IT Consultant/ Business Analyst

Confidential, Iselin, NJ

Responsibilities:

• Interacted with the HRIS group to develop HRIS interfaces with Lawson. Analyzed the HRIS business processes for understanding the present and the future business model process by authoring artifacts such as the Business Requirement Document (BRD), Functional Requirements Document (FRD), Process blueprints, and Technical Specifications.
• Designed, developed, enhanced and tested AS400 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 invoice data.
• 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. Created Lawson HRIS/ Financial interface projects relating to database maintenance/reporting for Employee Long Term Care, Employee Disability Wages, Employee Health/Dental Insurance Plans, Cobra Payment Benefits, Employee Flexible Spending and other payroll deductions. Utilized Implementer Change Management software to promote projects from test environment to production.

IT Consultant

Confidential, Sandy Hook, CT

Responsibilities:

• 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.

Senior Analyst/ Developer

Confidential, White Plains, NY

Responsibilities:

• 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 FXloss/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.