SUMMARY:

• Accomplished Senior System Analyst/Software Tester with over 15 years of experience in mainframe and GUI functional specification writing and testing for both enterprise wide and stand alone applications.
• Special Expertise in SQL Structured Query Language, QMF Query Management Facility, Requirement Gathering, Bugzero Bug Tracking System, Mercury Test Director and Lotus Notes. Repeated success in upgrading technology infrastructure testing (SQL Upgrades, disaster recovery exercises).
• Self motivated, detail oriented leader with excellent written and verbal skills and industry/insurance product knowledge.

TECHNICAL SKILLS:

Software: Microsoft Access, MS Office, Bugzero, Crystal Enterprise Reporting System, QMF, Solar, Cyberlife, Lotus Notes, XML and PDF readers, GUI standalone applications such as Customerlink, FinancialProlink, Voice Response System VRS, Trade Reporting System TRS, DMS for agent commissions and licensing, DCMS for non - compete distributive tracking system. Experienced in SDLC (Agile/Scrum)from estimation/design to implementation/rollout.

EXPERIENCE:

Confidential, Jamaica Plain, MA

Responsibilities:

• Performing life cycle analysis and management information systems analysis for data management functions involved in collecting, storing, analyzing, and sharing clinical and research data through the two web based portal systems (SharePoint and Data labs)
• Developing vendor requirements and fiscal estimates for acquisition of hardware and software
• Preparing backup documentation and justification for acquisition of hardware and software
• Evaluating vendor/contractor service and equipment performance factors used in the storage, access, and transmission of data
• Having in - depth knowledge of healthcare research in order to evaluate vendor/contractor service and equipment performance used in the storage, access, and transmission of data
• Determining requirements for collection, storage, migration, and sharing of data
• Developing operating study manuals
• Working with researchers to determine needs for storage/accessibility of data
• Developing guidelines to protect vulnerable information
• Planning and coordinating security measures to safeguard information
• Analyzing and evaluating effectiveness of program operations and to develop new or modified management processes
• Testing and evaluating products and processes for effectiveness
• Maintaining, evaluating, and recommending improvements to backup systems
• Communicating orally to determine user needs and translate these needs to technical IT staff
• Working with Information Resource Management (IRM) staff to perform systems administration work
• Conveying needs to vendors
• Training staff and users

Confidential, Springfield, MA

Senior Consultant/Analyst

Responsibilities:

• Devised, developed and implemented test plans and scripts for Annuities Products on the Asia Platform
• Devise, developed and implemented test plans for Defined Contributions 403(b) products
• Act as a QA Lead and liaison between Quasar/USIG business community and systems departments
• Provided solutions to the business needs and expert problem solving.
• Research VSAM files for data/testing/analysis purposes
• Utilize mainframe to retrieve (EZ Trieve) archived data
• Utilize modified Scrum/Agile environment for testing and tracking deliverables
• Coordinate and Manage compensatory testing and testing resources with 27+ downstream applications and testers
• Publish a united concise test calendar to facilitate coordination of multiple cross functional downstream compensatory feeds for both developers and downstream app testers
• Use Mercury Testing Director as test case and bug tracking utilities
• Use QTP for Automated testing
• Coordinate and participate in usability testing, and identified and resolved complex actuarial business issues.
• Maintained time sensitive project deadlines, status reviews and performed analysis of data output
• Provided expert consultation (SME) on product functions and features
• Rolled out new products and performed production support fixes on cross divisional /enterprise wide applications.
• Represent the BA/QA division in project status meetings
• Utilized expert communication skills with all types of users; end users, systems staff, management and team members
• Extensive use of Microsoft Excel (importing, exporting into various programs)
• Ability to expertly read and interpret data extracts from various systems and provide analysis on outstanding design issues.

Confidential, Wellesley, MA

Senior Analyst

Responsibilities:

• Devised, developed and implement system specification documents as well as test plans for Crystal Reporting using Mercury Test Director and Crystal Enterprise Reporting.
• Provide experienced research into various systems per request (including SQL and QMF data queries, testing current system functionality, analyzing various processes associated with both financial applications as well as life insurance applications, researching downstream applications including Customer Websites as well as Agent Websites). Ability to govern system modification impacts as to minimize risk and leverage current processes to meet current change demands.
• Exercise strong analytical thinking
• Repeated success in infrastructure enhancements/maintenance including SQL upgrades and Disaster Recovery exercises
• Act as liaison between international business community, systems developers and senior management
• Provided senior level solutions to the business customer and provided expert problem solving.
• SME on requirements processing (including data extracts, new functionality and system modifications)
• Knowledge of project life-cycle (including SCRUM, estimating, micro-project management)
• Research VSAM files for data/testing/analysis purposes
• Utilize mainframe to retrieve (EZ Trieve) archived data
• Provide developer support by reading and reviewing Cobol code changes
• Performed senior level analysis of data output and reported bugs in Bugzero application.
• Provided expert SQL coding to perform testing in both the IDR database structure as well as Group WEW structures
• Experienced in building partnerships, negotiating (specifically negotiating with IT (developers) and the consumer (business area)
• Effectively communicate with end users, systems staff, management and International team members to facilitate requirement gathering, code migration, bug resolution and project milestones
• Act in a senior mentor role to help others write and test business requirements using Breeze (to train Ireland on product features where there was a knowledge gap)
• Ability to multi task and prioritize key issues

Analyst

Confidential

Responsibilities:

• Devised, developed and implemented specification documents and test plans for CYBERLIFE, SOLAR and all downstream Web Applications using Mercury Testing Director.
• Acted as a liaison between international business community and systems departments and provided solutions to the business needs and expert problem solving.
• Research VSAM files for data/testing/analysis purposes
• Utilize mainframe to retrieve (EZ Trieve) archived data
• Provide developer support by reading and reviewing Cobol code changes
• Coordinated and participated in usability testing, and identified and resolved complex actuarial business issues.
• Maintained project deadlines, status reviews and performed analysis of data output and reported bugs in Bugzero.
• Performed complex actuarial calculations for product re-prices, product support items and commission calculations.
• Provided expert product knowledge / features to perform testing both the mainframe and GUI structure as well as Fund knowledge for investment portfolio testing.
• Rolled out new products and performed production support fixes on cross divisional /enterprise wide applications.
• Represent the BA/QA division in project status meetings
• Utilized expert communication skills with all types of users; end users, systems staff, management and international team members and provided training to Offshore Business (Bermuda) staff.

Confidential, Worcester, MA

Business Analyst / QA Tester

Responsibilities:

• Devised, developed and implemented test plans for the end of Phase 1 and for Phase 2 of the Beacon Navisys variable annuity mainframe interface software.
• Communicated across division and departments to deal with all skill and levels of management.
• Coordinated testing and recorded and tracked bugs and fixes.

PC Consultant

Confidential

Responsibilities:

• Published quarterly newsletter on intranet and made facility changes on website.
• Trained end users on various functions of software and web site.
• Contributed to audits performed to maintain user databases and contributed to version control audits.
• Performed software testing on new products prior to release and facilitated intranet problem solving.
• Acted as conduit between agent / end user and developers.
• Facilitated distribution and installation of over 15 software products produced both in-house and externally.

Confidential, Worcester, MA

Medical Billing Specialist

Responsibilities:

• Entered medical charges into software requiring knowledge of Confidential and CPT codes for data entry.
• Acquired knowledge of multiple insurance plans, their billing requirements and applied knowledge of system applications.