SUMMARY

• Business Analyst BA /Quality Assurance QA with 20 years combined experience. Full time and Consulting experience includes Aetna Inc. and Financial Services, Mass Mutual MML Investor Service St. Paul Travelers P C United Healthcare, The Hartford Insurance Group, Hartford Life GBD , CIGNA Healthcare, National Council on Compensation Insurance NCCI - Worker' Compensation
• Seasoned IT Professional with comprehensive Business/Technical skill set. A cooperative and flexible team player with proven communication skills trained liaison in all phases of the full SDLC project life cycle, ranging in Elicitation, requirements gathering, specifications writing and quality assurance QA . A proficient problem solver, who envisions multiple perspectives while advocating technical and business solutions. Experience spans all line of businesses, including Healthcare, Life and Disability Benefits, Pensions and Annuity, Property and Casualty in a Commercial lines Auto, GL, inland Marine, Property, WC Retirement Services, Financial and Brokerage environments, Claims and Workers Compensation/Disability, Electronic File Transfer EFT Management systems.

Areas of Expertise

• Applications and Software: Familiar with IBM Mainframe JCL, TSO, CMS, MVS, CICS , Microsoft products, Window XP, 9X, NT 4.0, Query language QMF, DB2, SQL, BRIO , Lotus Notes, VISIO, Automated Test Tools: Test Director - Quality Center , Mercury, WinRunner, Comparex, HTML, UNIX Client/Server and Mainframe, Vantage, Rational Rose Suite tools, Remedy 7.1
• Methodologies: Software Development Life Cycle SDLC - AGILE, Waterfall, Testing Life Cycle, Rational Unified Process RUP , Aetna RUP-USECASE development, Workshop Rapid Application, Development RAD , Joint Application Design JAD

Work Experience

Confidential

• Interviewed Underwriting Unit, Product Unit including management team to solicit and write detailed Umbrella, BOP, General Liability Auto and Garage functional requirements for a New National Commercial, Web Based Rating Application.
• Reviewed Source system DATA elements to for the development of to Target Application and downstream processes and interface
• Provided data analysis in the creation of requirements documentation including Visio process flow, process analysis artifacts including functional test cases and uses cases.
• Solely managed identifying reporting requirements for key back-end and download processes for National Commercial Application Including: ISO, LYNX, IVANS
• Solely responsible for testing Claims process and new tables as result of the New National Commercial Lines App and impact to major back-end Application TRONWEB
• Attended defect Triage involving large-scale web application and downstream multi-platform applications.
• Provided support and engaged in JAD sessions with varying skill levels executive, technical and non-technical .

Confidential

• Wrote and defined high level Business requirements for Criminal Justice Information Systems CJIS for Connecticut Judicial Data Warehouse Project.
• Solely responsible for meeting with State and Local Police agencies to Identify Centralized Repository features.
• Met with State and Local Police Officers to gather requirements and verify operational procedures in field environment to conduct interviews.

Confidential

• Solely responsible for working with CTDOL users/various levels of management Procurement process for State/Federal initiatives to elicit, gather and define user requirements for Integrity application and user interface to help recover Unemployment Insurance Benefits.
• Collaborated with a team leads to write detailed requirements for Connecticut Unemployment fraud Module
• Identified and gathered application requirements to draft Invitation to BID/Request for Proposal ITB-RFP for outside vendor bids.
• Performed Joint Account Development JAD meetings to discuss and conduct detail analysis for requirements and primary tenants for system/application functionality proposals.
• Worked independently and performed thorough analysis on technical documents and vendors materials to formulate application requirement for the draft of Invitation to bid ITB
• Compiled detailed metrics to compare vendor bidding for proposal for CT DOL unemployment fraud Module

Confidential

• Work independently on multiple initiatives collaborating with all levels of management within Pay Roll, Human Resource, Ombudsman and Social Workers acting as liaison to identify critical process improvements and eliminate duplicity within current processes and State system.
• Engaged in interview sessions to document current workflow processes, utilizing strong analytical to skill to evaluate and interpret concepts and information mandated by Federal and State Governance.
• Created and drafted over 50 reporting requirements for Data Warehouse project.
• Report specification for Management teams to reduce dependence on outside vendor and reduction in DCF reporting budget and State budget.
• Responsible for verifying repository data quality and identifying possible community user for Data Warehouse.

Confidential

QA tester

• Electronic File Transfer EFT scripts for Major Raft.Net Migration Project ensuring file transfer meet SOX compliance.
• Responsible for validating script information and utilizing Raft.Net tool to debug and Script View to test script.
• Attend weekly meeting to provide feedback and provide suggestion for process improvements.
• Responsibilities included Managing process include writing, modifying detailed scripts for FTP file transfer, Creating Graphic User Interface GUI Header , and testing data transmission schedules.

Confidential

• Solely Responsible for interviewing team members - application owners and documenting overview of application usage and processes for Life Disability Benefit Underwriting Application PULSE .
• Wrote detailed test material for The PULSE application Leader role included creating reusable test sets and documenting in Quality Center for enhancements and monthly defect releases.
• Wrote enhancement requirements for PULSE application Responsibility include working with meeting deadlines and receiving sign-off.
• Lead QA manage and execute test cases for PULSE application release test included regression, functionality and acceptance.
• Served as production point person, utilizing Remedy Service Console responsibilities include providing production support for View and Pulse Application.
• Produce reports documenting incidents trends used for manager end of months dashboard reports
• Managed internal web Interface enhancements with CMS tool sets between business partners and technical staff, ensuring a high quality product and effective deployment of new information in timely manner.

Confidential

• Responsible for Documenting Business Impact Assessment BIA requirements for eB T and Business Resiliency office in effort to align the business processes and associated disaster recovery needs.
• Solely responsible for preparing complex mapping and baseline inventory of IT applications inventory matrices, utilizing input from SME's while leveraging Business Assessment BIA artifacts and the Business Application Portfolio Management BAPM database.
• Attended and supported workshops to validate BIA business processes with IT applications and assisted in interactive Question/Answer session to address process recovery time needs and requirements validation.
• Provided Follow - up support by contacting applications owner and SMEs to review and identify outstanding applications issues and processes.

Confidential

Lead BA/QA

• solely responsible for testing and debugging New Vendor Application for Brokerage/Direct Business, New Accounts on web based platform for MMLISA back office Project.
• Lead BA/QA responsible writing and executing all functional, integrated and acceptance test cases, test scripts Defects tracking utilizing Test Director/Quality Tool.
• Lead Team of business users in gathering test data criteria, and performed unit, functional and integration test and assisted with acceptance testing and all system and work flow enhancements.
• Acted as data Steward/Administrator during data load to ensure transformational rules were properly applied, ensuring Data transformation was accurate, including No loss of Data quality was ensured and complete.
• Validated date type and data defaults for selected tables and columns

Confidential

• Supervise 30 agents interfacing with victims requesting assistance within call center environment for FEMA emergency assistance program.
• Assisted agents with FEMA system log-in application and phone system maintaining a high volume of calls answered using Government interface for logging detail personal information.
• Performed a variety of duties to help facilitate disaster relief to affected areas during Hurricane Kathrina.
• Obtained High level security clearance to gather personal and sensitive data for completion of FEMA questionnaire.

Confidential

Lead BA/QA

• producing detailed test cases unit/integration/acceptance for Portal/Web based quoting application Issue Express NET in a Property and Casualty environment.
• Analyzed business requirements and developed functional test cases, scenarios and scripts.
• Executed test cases and managed system defects, corrections and testing production error fixes.
• Tested application database utilizing in-house tools including Microsoft SQL queries tool and WinRunner.

Confidential

Lead BA

• responsible for interviewing End Users for defining specifications, articulating key business objectives, implementing and testing data storage tables for web based application.
• Wrote use cases and performed analysis on new and renewal business web based application.
• Worked with End users, Subject Matter Experts SMEs and outside vendors Infosys to calculate project estimates.

Confidential

Lead BA

• Cigna Healthcare systems on transformation project applications ICMS, Provider-CPF, and Clinical Lab and Disability claims .
• Interviewed and met with Business owners to translate and define business requirements.
• Performed data mapping, integrity verification utilizing QMF and SQL in relational database environment.
• Created all test plans and coordinated testing including test plans matrices, scenarios, executing all test cases.
• Provided production support in documenting and researching issues, and proving solutions and presenting business alternatives.

Confidential

• Responsible for gathering activity based data requirements in a Pensions and Annuity systems environment.
• Interviewed users for developing work processes and procedures workflows using Visio.
• Identified process improvements and determined cost savings process enhancements.
• Provided production support while writing Test Plans and scripts and logging defect into Test Director.

Confidential

• Provided research, analysis and support for implementing new compensation plans for sales units.
• Responsible for system functionality addressing all business requirements.

Confidential

• Sole test Lead for producing detailed test strategy and test cases for Mass. Automobile insurance application in a Property and Casualty environment Commercial and Personal Lines on Portal /Web based application
• Solely responsible for developing and writing Unit, Functional and Acceptance test cases, scenarios and scripts for Portal/Web based application.
• Created detailed scripts utilizing MS Excel and MS Access for manual testing.
• Documented system defects and captured enhancements while making recommendations for revised requirements and reporting requirements.
• Responsible for completing cycle testing accurately and on time, and managing defects and corrections.

Confidential

• Responsible for all phases of Y2K testing efforts of Aetna Healthcare MSW integrated systems and peripheral applications.
• Testing performed in a Mainframe and Client server environment SAS .

Confidential

• Responsible for Y2K testing on Aetna Life Annuities Vantage system. Researched and wrote all test plans, scripts and cases for Sales Productivity System, Tax Reporting, Check Writing, H-Client Fund Replacement and Fund Reuse.
• Responsibilities included documenting all defects, regression testing and acceptance testing.

Confidential

• Managed and defined user requirements for CSS Database and reporting systems for entire NSO division.
• Provided support for CSS Inquiries business throughout all system development phases system enhancement, gathering data, writing test scenarios, acceptance testing, SQL queries .
• Designed performance-monitoring reports for all levels of management, using call-tracking data.
• Special Projects: Managed CSS Recovery Test for CSS Applications, Lead on Year 2K software and application survey inventory for NSO call centers.

Confidential

• Manage data quality analysis and produce data quality reports on routine manage care customers.
• Investigated and validated the raw data using insured benefit plans to investigate data quality issues.

Confidential

• Managed Workers Compensation Unit reports, system enhancements and quality of data report cards workers comp data including disability claims.
• Documented and wrote circulars notifying carriers of reporting requirements DCI, HCFA 1450, 1550 etc.,
• Analyzed and resolved carriers Monthly reports for data quality integrity problems related to statistical reporting.
• Coordinated on-line survey for carriers' participation in new reporting expanded format.
• Responsible for coordinating Workers Compensation and disability data for State Insured Funds.

Confidential

Conducted in-depth interviews with users for creation of business specifications for Aetna Health Plan AHP SEAKO systems for the capture of new data requirements in a production environment.

Confidential

Solely Responsible for designing, testing, data mapping and creation of specifications for all lines of businesses in Commercial Division for Information System Architecture Project.

Corrected and rewrote specifications for accounting records resulting in a reduction of errors below a 5 ratio.

Responsible for maintaining claims documentation and premium procedure manuals in Commercial insurance Workers Comp., General Liability, Automobile, BOP, Inland Marine , Environment.