Business analyst

SUMMARY

Sharp analytical, organizational and multi-tasking skills as well as project management

Exceptional requirements gathering skills including deep dive determinations and negotiations with stakeholders

15 years business technical analysis skills as product owner developing specifications, use cases, test cases and test scripts; worked with initial start up processes as well as transitional processes including most recently over a year in banking

Experience in all aspects of iterative, waterfall and Agile SDLC methodologies

BRD and FRD development and maintenance experience using RUP, RTC, JIRA and SharePoint

Proficient in Microsoft Office applications including Access and Project

QA, SIT, UAT and regression testing experience responsible for test cases and differing scenarios and publishing results

Ad hoc reporting including state and federal regulatory reports

Accomplished in Teradata, DB2, Oracle and Sybase databases and SQL; data validation, daya parsing, data enrichment and fata standardization

Quick learner with excellent technical and communications skills

Data modeling experience in data warehouse environment and with relational databases

Successful managerial experience; work well independently or as a team player as required

CERTIFICATION

Scrum Master Certificate

Six Sigma Yellow Belt Certified

EXPERIENCE

BUSINESS ANALYST

Insight Global, St Petersburg, FL Jun 2019 to Sep 2019

On assignment with Franklin Templeton Investments with Fiduciary Project and Data Management team

Work closely with stakeholders to write functional specifications in current state and design future state implementations assuring all KYC and compliance requirements were met

Generated BRD and FRD as use cases and user stories

Analysis of client software to improve user friendliness and testing for functionality requirements for capital market products

Research to migrate current system to new web portal for both internal and external clients; gap analysis

TECHNICAL ANALYST

LTI, Tampa, FL Jul 2017 to Dec 2018

On assignment with Citi, Inc. with anti money laundering and bank management teams

Responsible for mapping documentation for source to system transition and technical analysis for business team

Quality testing for system application

Determined tests required for data fields for data validation and logic development

Worked closely with regulatory team encompassing all KYC requirements

Wrote test scripts using SQL as well as results tracking documentation

BUSINESS TECHNICAL ANALYST

HM Health Solutions, Pittsburgh, PA Oct 2013 to Feb 2017

Business Technical Analyst for Membership Staff Services Team responsible for member enrollment inbound files and Service Components

Assigned to Medicaid implementation including defining inbound file requirements and mapping from source file data; worked with downstream systems to elicit needs to enhance existing service components and new service component requirements; and built new table requirements within the membership database for Medicaid specific data

Subject matter expert for transactions with providers to determine member's coverage following federal guidelines

Delivery Owner responsibilities for Agile Scrum Team to negotiate reasonable delivery expectations for stakeholder, assure development and testing priorities, and to guarantee successful and timely delivery of requirements

Worked efficiently with both internal and external clients including migration of data from client legacy system to HM Health Solutions' platform, investigating and resolving defects and utilization management

Mentoring responsibilities for new hires and instructional requirements on required by any team business analyst

Groomed and developed Use Cases and user stories to clearly define client requirements for efficient development and testing for completion within two-to-three-week sprints

Advanced use of Excel and DB2 SQL for reporting, analyzing and retrieving test data

SENIOR BUSINESS ANALYST

CIBER, Pittsburgh, PA Jul 2007 to Sep 2013

On assignment with Highmark, Inc. to maintain claims data warehouses, legacy system ACE (Automated Claims Expert) and EDW (Enterprise Data Warehouse)

Access IBM mainframe utilizing IMS and TSO to retrieve data for testing and reporting purposes; experience with Batch systems processing; perform data analysis for data validation and data mining requirements with Teradata SQL

Quarterly functional and technical specifications written for product changes, system defects, etc.

Participation in JAD sessions for federal requirements in health claims reporting and electronic claims submission

Write and implement test plans that include unit, integration, system, user acceptance and regression testing for each quarterly release and non-quarterly release as needed using SQL and application reporting

Responsible for updating and maintaining all pertinent documentation for job responsibilities, and warehouse content as well as any procedural changes necessary including end user notifications and reference documents

SharePoint use for both storage and approval workflows of system documentation

Weekly reports created and analyzed for balancing, and data conversion errors; research out of balance using Excel and Access

Help desk; responsible for reporting and resolution of trouble tickets specifically related to warehouse

SUPERVISOR

OSI, Canonsburg, PA Sep 2002 to Jul 2007

Developed functional specifications of new account treatment system for 3 separate lines of business plus a general operational specification for common data; developed and implemented functional test plans for each specification

Performed user acceptance testing; developed training documentation and evaluation for user implementation

PROJECT MANAGER

SENIOR BUSINESS ANALYST

Adelphia Communications Corp, Canonsburg, PA Jun 1998 to May 2002

Promoted to project manager for $5 million software package used to automate electronic ordering between Adelphia and trading partners

Developed functional and technical specifications for software development

Participated in JAD sessions with product marketing, end users, and developers to assure systems incorporated all required aspects for ordering, billing, and provisioning of telephone products

Wrote and implemented test plans for each specification written using SQL. Have developed software for Remedy Action Request System based client server order entry billing system.

Created Oracle SQL statements to verify, update, and report information contained within database

Implemented procedural changes to generate $200,000 monthly sales tool to decrease reporting time by 90%

Worked closely with field representatives and with centralized help desk to troubleshoot ordering, provisioning, and billing errors

Received bonus awards from field in recognition of assistance to customer service personnel

Worked closely with vendor and other trading partners to implement external interfaces required for telephony service including business management and utilization

Acted as team lead to assure all specifications, testing, connectivity to trading partners and end-to-end implementation achieved within time frame

EDUCATION

INDEPENDENT COURSE STUDY

JIRA

Eliciting Requirements

ReqPro, RTC

SharePoint

Integrity, Compliance Training

Workplace Harassment

Introduction to Oracle for Database Administrator

Crystal Reports

Business Analysis Professional Certification training

Core Concepts in Business Analysis

CALIFORNIA UNIVERSITY OF PA

California, PA

Credits towards Master Degree in Math and Computer Science

SCHOOL OF COMPUTER TECHNOLOGY

Pittsburgh, PA

Technical certificate in business programming

PENNSYLVANIA STATE UNIVERSITY

State College, PA

Bachelor of Science in Elementary Education

Minor in Arts and Humanities

Contact this candidate