PROFESSIONAL SUMMARY:

• Seventeen years of technical experience as a Senior Business Analyst, System Analyst and Quality Assurance Analyst.
• Technical experience spans the System Development Life Cycle (SDLC), including
• Logical Analysis, Data Mapping/Reverse Data Mapping (Financial and Non - Financial), Data Modeling, Business Specifications, Plan, Analyze, Design, Build and Testing Application Software Phases.
• Nine plus years of Business Experience in Property/Casualty, Claim, Commercial Lines Insurance, Architecture and Engineering Design, Aerospace, Commercial Real Estate, Healthcare, Broadcast Sports/Media and Utility Industries.
• Experienced in leading medium sized teams through testing phases of SDLC.
• Two plus years’ experience with affiliate radio and international website redesigns within a sports media industry.
• Experienced in both Agile/Waterfall methodologies, CMS implementations, project management and design.
• Skilled in GUI screen mockups and front end user interface, backend processes and documenting system workflows.
• Expert in data mapping and reverse data mapping in a wide range of applications, expertise in billing applications and transactional workflows.

TECHNICAL/APPLICATION EXPERIENCE:

• Web Provider Portal - Commercial/Medicare Claims Healthcare Reform 
• MLR - Medical Loss Ratio Project EDI/BizTalk Provider Mappings HIPPA/ICD09/ICD10 Data Mapping Compliance Projects Mercury Quality Center/MQC Claim IT Data Mappings Microsoft Office Suite Cognos 8 Reporting Tool SharePoint Application MS Visual SourceSafe Database/ Metadata Framework/Data Modeling Financial Reporting and Data Analysis SQL Query Analyzer Oracle Toad Application E-Bond/B2B/E-Commerce Agency Portals/CL Portal Data Warehousing -
• (Led Test Team of 14) P&C/Claim System Implementations & Deployment Processes Executive Liability Application MKS Construction/Commercial Surety Teradata/DQM ETL Process and Data Stage Tools - Source to Stage/Stage to Target Healthcare Data Management Reporting Tools and Applications Serena Business Workflow Process Tool 
• Eleanor Waterfall Methodologies/ AGILE - RALLY Application/User Stories/UML Lotus Notes Altiris Packaging Telelogic DOORS International & Domestic Affiliate Web Sites Syndication - Contract Management Systems WordPress Knowledge SnagIt Editor Axure RP Bookmarking & Field Mappings Security Architecture 
• Homefield SSO Experience JIRA IT Project Management Experience Confluence APIs Cloud Experience (SaaS) ALM JDE PowerPlant ACORD XML Data Mapping T-SQL 2014 Microsoft Management Studio VS 2012 Pro XML Spy SSRS / SSIS Data Governance

PROFESSIONAL EXPERIENCE:

Senior Quality Assurance Analyst 

Responsibilities:

• Self-taught on the policy admin system for all P & C LOBs
• Tested all functionalities of the policy admin system – Quote, New Business, Renewals, and Cancellations etc.
• Acted as subject matter expert for specific assigned coverages, i.e., COP, Package
• Analyzed and created test cases from existing defects on request
• Merged test case documents into one for test execution phase
• Performed test execution of complex test scenarios/test cases under very tight timelines (400 test cases in 3 days)
• Document analysis using Ref Connect, Work Front and PPM tools to decipher gaps in testing documentation
• Raised business process questions while testing and determined root cause to determine if it was a defect or workflow issue

Senior Business Analyst 

Responsibilities:

• Validates ACORD XML paths for data transformation and data flows utilizations via SQL queries for PL and CL LOBs
• Suggests corrected ACORD XML paths, tables and columns in respective databases based on XML Schemas
• Performs required data mapping analysis applying ACORD XML standards for PL and CL data (source to stage to target)
• Participates in external client kick off meetings and requirement sessions to illicit data requirements, data transformations, data mapping specifications and capture other back end interface processes
• Understands the data hierarchy, metadata model, source to stage and stage to target data flows, data transformation processes for both SDI and XML data paths and reporting requirements
• Collaborates with VP of Operations/VP of Client Delivery, Business Solution Architects, BAs, and Lead Developers to effectively deliver data mappings and client requirements for implementation and client delivery needs

Senior Business Analyst 

Responsibilities:

• Gathered business requirements, requirements matrix, data mapping from customer data migration project Utiligy
• Coordinated and led all UAT testing meetings, create all accounting, customer service, service delivery test strategies, test cases, use cases, and capture all defects and work with the JDE developers (Vendor) for resolution
• Aligned with business program PM to coordinate all project related tasks for the water company acquisition project documenting repeatable processes
• Assisted with the accounting GL, Trial Balances, AR, AP transactions from a data migration perspective within the JDE system and facilitated data mapping of all utility assets
• Obtained high-level knowledge of all data and financial/billing transaction process flows within their internal interface via Power Plant and JDE applications
• Worked with customers, vendors and contractors from the water company being acquired to ensure a seamless data migration under tight timeframes
• Collaborated with senior management and program manager to ensure all deadlines are met by creating data migration plans, status templates, project milestones for status updates upon request

Senior QA Analyst 

Responsibilities:

• Facilitated UAT and SIT testing for the customer experience group eversource.com cloud based web site
• Utilized Team Foundation Server, ALM and JIRA to understand business requirements and initiated creation of UAT test scenarios, test strategy and test cases
• Acted as liason between the business partners and the development teams
• Performed multiple quality assurance tasks for several projects at any given time

Senior IT Business Analyst 

Responsibilities:

• Worked on Oracle based Accounting/Billing affiliate system
• Redesigned web and oracle UI screens associated to the affiliate accounting system
• Coordinated and maintained BI reporting requests and all new software requests within Confluence
• Managed multiple projects at the same time (over 5 projects at any given time)
• Created wireframes in Axure Pro 7.0, Snag It Editor, Gliffy tools applying UX Design Style Guide Standards
• Gathered affiliate business process rules, workflows, and documents in Visio and Confluence for Development/QA teams as well as business partners/stakeholders
• Worked with Director Level Management on a daily basis and updates them via status reports/meetings
• Led website redesign projects International Affiliate and ESPN Radio Affiliates
• Gathered business requirements to create project timeline, project charter, and functional requirements for development team leads and business partners
• Ran all project status meeting, business requirement meetings, technical meetings and tracks all project initiatives to report to senior level teams
• Built data mappings for Homefield security models for new application and website architecture
• Created complex registration, user profile management and site administration wireframes and workflow process for the redesign project
• Worked one-on-one with senior development team leads on specific project requirements for multiple projects
• Created bookmarks for affiliate agreement templates and corresponding field mapping artifacts for development team
• Worked with QA when testing releases and provide technical explanations of the functional requirements as needed
• Trained team members on International Affiliate Site and ESPN Radio/ESPN Deportes sites

IT Business Analyst 

Responsibilities:

• Gathered business requirements to create Business Requirement Documents (BRDs), Functional Requirement Specifications (FRS), and Technical Specifications for the Business and Technical Teams for specific IS projects
• Provided all project level estimates for BA/Design/QA Phases working with the PM and Development Lead
• Managed resource allocations and provided feedback/insight into upcoming projects specifically around time allotment
• Led the Medical Loss Ratio Mailing Project 2011 to be compliant with the new Health Care Reform Act
• Engaged Marketing/Billing/Finance/PM/Developer/External Print Vendor on weekly basis to gather all member information in order to process 5,000 member mailings for compliance purposes for the MLR Project 2011.
• Created and maintained all BRDs, FRSs, Member Letters, and MLR Reports as well as worked very closely with the SQL Developer/Finance/PM to document a complex data mapping sheet as one of the main artifacts for the external vendor’s mailing distribution. (The timeline for this project was very aggressive (April 2 – August 1st) and met all state and government healthcare guidelines for the project with no errors.)
• Maintained Provider Portal and responsible for all production issues, enhancements, application releases associated to the website and working closely with the business users who are the liaisons to the providers
• Performed SQL queries and create test cases to obtain accurate claim data for both manual and automation testing for the Amisys Application upgrade (Financial Data Warehouse for all claim information)
• Responsible for all Web Portal/Environmental/Batch Processes documentation for the Provider Portal
• Worked with the EDI Developers to understand their mappings and process provider requests/clearinghouse requests to be setup for ERAs

Senior Business Analyst

Responsibilities:

• Led JAD sessions and gather requirements to create the Business Requirement Documents, Functional Requirement Specifications, and Technical Specifications for the Business, Operations, Development, ETL, QA and UAT Teams
• Performed Internal and External BRDs and FRS walkthroughs for Stakeholders, Business Partners, Development/ETL, QA and UAT Teams
• Created Requirement Traceability Matrixes, Use Case Scenarios, Process Flows and Crosswalks for end user
• Utilized Toad to run queries and perform data analysis for a Sales Demo/Performance Testing Warehouse Project
• Created Business Impact Analysis documentation for new projects that may impact existing applications using the Warehouse
• Provided BA expertise on a Server Migration Project documenting all new and existing functionality for the project understanding the FTP Protocol system in place and the File Landing Process across the Enterprise
• Worked on the Data Load Automation Project for the Data Quality Management Tool Application that loads files and performs Client concatenation files within the load bundles
• Designed new UI Screens for several projects for the Reporting and Insights Organization
• Understood the Serena Business Workflow Tool in place and how it worked in conjunction with the Data Stage Tools across the organization

System Analyst/Business Analyst

Responsibilities:

• Gathered technical and business requirements for user story, wiki page and technical design specification creation utilizing AGILE/SCRUM methodology
• Documented technical designs for the backend Clinical Application, specifically engine services
• Demonstrated all user stories and the completed UI designs and functionality to the end users, business stakeholders and IT group (over 40 people) every three weeks in a large presentation format
• Responsible for all project tasks and projecting tracking in RALLY for the SCRUM Team in the SCRUM Master role

Functional Designer/Business Analyst

Responsibilities:

• Gathered and documented functional/nonfunctional business requirements during Plan, Analyze, and Design Phases for a global Claim Application implementation
• Completed a Cost Benefit Analysis for Vendor Data Reconciliation Application to reveal the cost analysis on discontinuing with that specific vendor and taking on the data reconciliation on internally
• Worked closely with International based SMEs, Functional Team Leads/Architects, and Business Partners to obtain business requirements - (Traveled to London to train on the new system and work on daily basis with SMEs)
• Created “Claim” Lifecycle Test Scripts for execution Testing Phase of the project
• Analyzed User Interface Designs to perform data mapping for financial and non-financial Claim mappings
• Researched new functionality for Claim data conversion processes utilizing SQL database and data warehouse source system
• Utilized business content code/decode functional mappings from the Source Systems to the Target System
• Obtained working knowledge of front end and back end of the Global Claim System as well as Source Systems
• Documented necessary processes and procedures throughout the lifecycle of the project

Business Analyst

Responsibilities:

• Assisted in the creation of Project Plans and Implementation Tasks for Windows 7/IE8 Upgrade enterprise wide
• Gathered business specifications for multiple ongoing projects and prepared training materials for internal team members and new hires
• Facilitated and scheduled 1900 desktop/web/Citrix applications UAT for XP SP3/IE7
• Managed and led ongoing release deployments and implementations meetings by utilizing MS Project and Visio presentations with the internal project teams
• Reviewed Project Tasks and received and updated feedback into the project plan via MS Project
• Utilized MS Excel to provide metrics to the PM on percentage complete for each segment of the implementations and deployments
• Researched application testing issues working with Test Engineers, UCL and Application Owners
• Worked closely with Application Owners and Project Managers to coordinate large suites of applications for UAT
• Prepared technical documentation for Testing Metrics for Project Managers and Directors
• Maintained Schedule of Applications on SharePoint and follow-up on issues found during UAT with Test Engineers
• Coordinated Deployment Process after the Testing and Integration Phase had been completed

Business Analyst 

Responsibilities:

• Acted as a technical liaison between Business Customer and Development Teams
• Gathered preliminary scope of project and identified in and out of scope Items with Project Manager and Business Partners
• Created business specifications and design specifications for the Business, PM, Dev Team & QA
• Identified “Showstoppers” escalating the issue(s) to the PM with resolutions to meet the Release Date
• Created training materials for all new features and answered QA Team questions during the testing phases

Senior QA Consultant/Test Lead 

Responsibilities:

• Led QA Test Team (14 person Onshore Team) for Base Layer Data Warehousing Project
• Performed gap analysis on pre-existing business specifications, data mapping and revised and rewrote business specifications and test cases
• Managed the development of SQL based test cases with Test Team for Data Warehouse testing effort
• Coordinated and assigned all project related tasks to fourteen person Test Team
• Reviewed team members’ Test Plan, Test Cases, and Test Strategies for Data Warehouse
• Worked closely with Project Managers, Teradata and Business Customers on Data Warehouse Financial Reconciliations across Commercial Lines Products for Regional Vice Presidents and Finance
• Troubleshot and analyzed all defects found during the Testing Phase by the Test Team
• Responsible to transfer the knowledge on the ETL process from Source to Stage and Stage to Target on a Teradata Platform to Team

Assoc.Information Engineer 

Responsibilities:

• Created test strategies and implemented test strategy walk-through for Customers
• Tested Business Intelligence Financial Reports via CL Portal on COGNOS8 Platform
• Tracked defects utilizing Mercury Test Director Tool
• Validated Teradata to compare data calculations and cross balancing in financial reports
• Formulated and executed test scripts throughout testing lifecycle utilizing Test Director
• Defined business requirements working closely with Business Analysts, Developers and Customers
• Understand Data Mart Model and extract SQL statements during Testing Phase

Senior Quality Assurance Analyst 

Responsibilities:

• Formulated business specifications for the Underwriting Workstation Application quarterly releases
• Utilized Test Director Application to formulate test requirements, test cases, testing metrics
• Coordinated execution of test plans/test requirements with Customers and Business Leads
• Reported defects, recreated, validated and assigned as required to Development Team
• Created training sessions and training documents as needed for the UWS Releases
• Test implementation of Audit Controls for SOX Compliance
• Researched and validated SOX Requirements for Internal Auditors –KPMG
• Documented Technology’s Controls for Auditor’s Evaluation
• Identified any inconsistencies with SOX Compliance to Development/Sr. Mgmt.
• Supervised test Lab work with Build Developers and Operations Group
• Verified solutions for reported defects and coordinated distribution with Technical Support
• Approved Tivoli and Info man Tickets on request

Assistant Account Underwriter/BA

Responsibilities:

• IT/Business BA for all new changes and updates to specific LOBs and product screens within a P&C/Commercial Lines Underwriting/Claim Application
• Trained Agents and Underwriters on Compliance Controls when processing policies using Underwriting Applications
• Handled quoting, binding & billing (follow-up & voidance of expired binder letters), policy issuance, policy mid-term changes
• Cancellation and renewals (pulling, reassigning, sending non-renewal letters)
• Utilized Underwriting Applications to implement account underwriting processing related to quoting and underwriting Executive Liability Products, Private D&O and EPL

Senior Business Analyst/Sr. Information System Specialist

Responsibilities:

• Gathered and documented all preliminary Business/IT requirements during the initial UWS – P&C Application implementation
• Created training documentation for every subsequent UWS release
• Tested new Underwriting Applications for releases and production enhancements and defects
• Performed financial analysis of policies and trained Underwriters on financial implications
• Analyzed application defects and implemented Application Workarounds for End Users
• Provided technical/business support for all BOND desktop applications
• Possessed solid understanding of business and technical concepts, desktop support, install software and hardware

QA Engineer

Responsibilities:

• Test site migration on Client Websites
• Created QA strategy and architecture process for the QA Team
• Utilized DOORS Software Application to formulate and execute test cases
• Managed Test Track Application to track defects found on Client Websites