Joseph Houck

*** *********** ****, *******, **. *7520

Telephone: Mobile 919-***-****

Email: ad0lzy@r.postjobfree.com

SUMMARY OF QUALIFICATIONS.

Senior Business Systems and Data Analyst with full life cycle experience.

Team member on projects for the following business areas: retail, logistics, banking, finance, insurance, telecommunications, time/attendance/scheduling and manufacturing.

Overall, ten plus years working on analysis, design and implementation of work in process time/attendance/scheduling systems.

Involved in hands on roles in analysis, programming, coordinated testing, QA, UAT and implementation using Waterfall, and Agile/Scrum methodologies.

Conducted JAD and RAD sessions between clients and development staff.

Acted as an in-house instructor establishing training programs on various applications. And creating manuals for new projects.

Responsible for requirements gathering, and creation of requirements, gap analysis, use and test case documents.

Team lead on data migration projects, which included the following task: data analysis and mining, data migration mapping.

Excellent organizational, prioritizing, and time management skills with a dedicated work ethic.

TECHNOLOGY SKILLS

Microsoft Office Suite (Access, Excel, Word, PowerPoint)

Including MS Project and Visio

IBM products: Lotus Notes, OS, Cloud technology

Mainframe and Desktop: DST TA2000

Data Bases: IBM OS, Teradata, Oracle, IBM Client Server, CRM

Operating Systems: Windows 2000 series, OS\MVS

TOAD

Data mining tools

JIRA, Atlassian

Ascential, quality and data stages

Fiserv

MS SQL Server

SharePoint

Azure

Inovalon

CA Agile

Quality Center/ALM

Cisco web-based analysis tools

Screen painter

Project workbench

IBM mainframe and midrange

ERP, HCM applications

Business Intelligence Reporting

Test coordination

Change Control

MySQL.

Azure

Confluence

Lucid

Business Objects Reporting

Solumina

EDI interface protocol

MDM data warehousing configuration

API interfaces

Credit Risk Assessment

Rally

PROFESSIONAL EXPERIENCE

Lockheed Martin -Senior Business Analyst 02/22 08/23

Project: Senior Business Analyst working on SQA Ibase migration for Sikorsky Aircraft division

Responsible for leading creating all interface mapping and documentation for Ibase migration to new Solumina release. Included EDI data transfer.

Organize documentation and develop new procedures in capturing business requirements.

Create all mapping documentation for several interface applications into new system.

Create documentation for new and future migration procedures.

Work hand and hand with development teams during migration project.

Trans Ameerica - Senior Business Analyst 10/21 – 12/21

Project: Senior Business Analyst working on Trans America Life Mod project.

Responsible for leading creating of data flows for various process within the upgraded API and UI processes

Organize documentation and develop new procedures in capturing business requirements

IBM - Senior Business and Data Analyst 8/21 – 10/21

Project: Senior Business and Data Analyst working on AT&T project.

Responsible for all data analysis for source systems used as input for APIs

Created requirements documents for additional API being sourced into data warehouse

Optum - Senior Business and Data Analyst 6/21 – 8/21

Project: Senior Business and Data Analyst working on SDOH project.

Responsible for all data analysis for source systems used as input for SDOH database

Documented all data analysis and issues during reporting.

Also helped in testing activities for new software migration to new reporting systems.

Advance Auto Parts 02/21 – 05/21

Project: Senior Business Analyst working on Delivery Management System integration project.

Responsible for defining project requirements to meet the timeframes, budget, and expectations of the business stakeholders/customers to obtain their signoff.

Document all requirements/user stories using MS Office Suite and storing in Confluence and Lucid

Identify gaps and process improvements during project work to assist in meeting project milestones.

Assist team members in resolving issues.

Worked on epic and user story creation using Jira

Work with external vendor team through development and testing

Worked with external vendor in delivery management system and mobile app interface.

Optum - Senior Business and Data Analyst 9/19 – 12/20

Project: Senior Business and Data Analyst working on HEDIS government reporting for CMS Medicare and Medicaid and State Govt Solutions team

Responsible for all data analysis for CMS reporting requirements using MySQL

Documented all data analysis and issues during reporting.

Also helped in testing activities for new software migration to new reporting systems

Acted as Scrum Master for SC and TN reporting projects.

Performed data analysis duties for individual state claims, provider, and prior authorization files for individual state portals.

Participated in QA to include writing use and test cases and system and user acceptance testing.

IQVIA - Senior Business and Data Analyst 1/19 – 7/19

Project: Senior Business and Data Analyst working on a data migration project for new Novartis safety notification website application.

Responsible for all data analysis for migration files loaded to new Oracle data base using SQL.

MDM environment.

Also helped in testing activities for new application.

8/16-12/18

FHI - Freight Handlers Inc - Senior Business Systems Analyst

Project: Lead Senior Business and Technical analyst working on rewrite of current legacy end user and database systems including time/attendance/scheduling to new ERP and HCM systems. The work includes requirement gathering and creation, performing data analysis using SQL data migration, use and test case creation. Train and assist staff in various BA task throughout the life cycle of the project. Plan all hands/JAD sessions with all involved client partners and project team to discuss the new project and develop timelines and initial requirements.

Lead extensive meetings/scrum calls mostly via web and conference calls to plan and orchestrate project work.

Responsible for defining project requirements to meet the timeframes, budget, and expectations of the business stakeholders/customers to obtain their signoff.

Document all requirements/user stories using MS Office Suite and storing in SharePoint.

Identify gaps and process improvements during project work to assist in meeting project milestones.

Assist team members in resolving issues.

Participate in roles such as a data analyst, quality analyst, project manager, and a business analyst to assist in meting project goals and the end deliverable.

Work with external vendor team through development and testing

Environment: SharePoint, MS Office Suite, Agile, SDLC, Waterfall MS, SQL Server. Power BI, Azure.

Responsible for change control, and test coordination

Participated in QA to include writing use and test cases and system and user acceptance testing

Worked with external vendor in delivery management system and mobile app interface.

2/16-7/16

BOA - Senior Business Data Analyst

Project: Lead on corporate DDS warehouse. Involved data analysis using SQL and cleansing of data before it would source and uploaded to various view for end user access. Target data would then be used for financial and human resource reporting systems.

Defined, wrote queries, to perform data quality analysis on data sourced for the DDS data warehouse.

Worked with data governance team for data reconciliation and adjustment into the general ledger.

Identified data sources and documented the sources by building process and data flow maps.

Executed data quality profiling and performing quality assessments by developing and adhering to current and future business rules.

Consulted with all business stakeholders to identify potential gaps in data.

Created all associated mapping and ETL documentation.

Environment: SharePoint, Teradata, MS Office Suite, MS SQL Server.

Responsible for change control and test coordination

Participated in QA to include writing use and test cases and system and user acceptance testing

12/14-12/15

NC DHHS - Senior Business Analyst

Project: Maintained and supported NC DHHS EHR program which provided incentives to hospitals and providers for upgrading technology in sharing patient medical information through EDI interfaces and other data transfer methods.

Gathered and translated business needs into requirements as required for eligible health providers.

Created and maintained project plans to track all assigned task.

Acted as a subject matter expert (SME) for internal and external end user support.

Planned, tested, and executed any development enhancements/upgrades.

Created use cases, specifications and test cases for EHR systems using HP Quality Center.

Coordinate and plan all UAT for external and internal users with development.

Worked closely and collaborated with multiple teams who work within the high net worth call center to ensure all data feeds from My Learning are working as they should and troubleshoot any issues.

Evaluated lab and testing s to meet CMS standards.

Participated in QA to include writing use and test cases and system and user acceptance testing

Environment: SharePoint, HP Quality Center, MS Office Suite, MIPS, SVN Bugzilla Portal, Agile, SDLC, Waterfall.

Responsible for change control and test coordination

02/14-09/14

Stone Ridge Insurance - Senior Business Analyst and PM

Project: Supported new implementation of Tropics workers compensation system.

Conducted analysis of business needs and creation of clear thorough business requirements including test scripts, workflows, and technical specification documents.

Documented all requirements and user stories using MS suite.

Processed full tests and quality assurance requirements to ensure accuracy and consistency for effective software enhancements/solutions.

Planed and managed requests from internal business partners for changes and enhancements to requirements.

Liaised and explained business requirements for system fixes/issues, new enhancements, and other project requests to external vendor.

Executed testing using Tropics tool in UAT environment.

Lead daily scrum sessions as a scrum master to manage and plan projects and ticket expectations and results.

Created training manuals for new Tropics system.

Environment: SharePoint, HP Quality Center, Tropics, MS SQL Server, MS Office Suite, Agile, SDLC.

ITS State on North Carolina – Senior Business Data Analyst

Project: Supported new migration of financial application to ITFM web-based systems.

Performed analysis meeting with SME’s to create a gap analysis document. The document would encompass all necessary information to aid in migration from current state to new ITFM tool.

Performed data analytics on include invoicing, budgeting for forecasting.

Conducted statistical analysis reporting for project updates as well as time frames and account trend analysis.

Assisted team in understanding the gaps perceived through analysis and relay back to vendor for assistance.

Environment: SharePoint, HP Quality Center, ITFM Tools, MS Office Suite, Agile, SDLC, Waterfall.

1/13-3/13

Comcast - Senior Business Data Analyst

Project: Lead on implementations, enhancements, and rollouts of XFINITY web base application. Site would provide retail channel for customers in products and services.

Gathering and translating business requirements for data warehouse systems and dashboard reporting systems

Coordinated upgrades and rollouts of processes including implementation, training and monitoring performance within Microsoft SharePoint.

Identified and analyzed data issues during test phases.

Partnered with project sponsors to define and document new project requirements.

Created project and business requirements documents.

Worked with Infinity customer portal and mobile app interface.

Organized and chaired meetings and walkthrough sessions for related activities using Citrix Go TO Meeting. Environment: SharePoint, InfoPath, Agile, SDLC, Waterfall, MS Office Suite, HP Quality Center.

3/12-11/12

GSK- Senior Business Data Analyst

Project: Supported alignment and sales representative systems TO RAM and Flex systems. New systems to be used for tracking sales, areas and commissions for sales representatives.

Gathered and created business requirements for migration to new platform.

Documented and monitored changes based on new implementation of ICD-10 codes.

Created SOP for lab procedures for providers and hospitals based on GSK standards.

Support defects and problem resolutions for various selling face teams

Acted as POC and SME for various selling teams.

Profiled multiple source data using SQL for tracking and trending reports

Responsible for coordinating content management for source information.

Created procedures for validation of daily- monthly reporting processes.

Environment: SharePoint, Agile, SDLC, Waterfall, MS Office Suite, HP Quality Center, SQL Server.

11/11 -2/12

BCBS of North Carolina - Senior Business Data Analyst

Project: Supported conversion of conversion to new billing system which included effects of ICD 9 to ICD 10 upgrade.

Gathered and created business requirements for migration to new system.

Performed extensive data analytics in identifying source information for new data bases.

Reconciled and analyzed all data issues involved in the transition.

Partnered with internal teams and provide extensive research and documentation for all system changes.

Environment: SDLC, Mainframe 3290, MS Office Suite.

8/11-11/11

Wells Fargo - Senior Business Data Analyst

Project: Supported migration to a new platform for wholesale credit data mart to support end user reporting.

Gathered and translated business requirements.

Worked with development team through development and testing.

Performed extensive data analytics and analysis using SQL

Environment: Teradata, SQL Server, MS Office Suite.

1/11-7/11

BOA - Senior Business Data Analyst

Project: Supported migration to treasury reporting system to CTDM DataMart.

Gathered and translating business requirements for international banking and E-commerce Corporate Treasury reporting system.

Worked on migration for loan and mortgage systems.

Created system analysis packages for Business units using SQL and MS tools..

Responsible for coordinating content management for source information.

Create all necessary source to target mapping documents.

Monitored and responsible for coordinating UAT and Systems testing for CTDM.

Involved in testing and providing data validation as needed using TOAD and SQL Teradata Assistant, Testing coordinator for sales migration systems.

Environment: Teradata, MS Office Suite. HP Quality Center., TOAD, Oracle.

Part of team for change control and test coordination

Participated in QA to include writing use and test cases and system and user acceptance testing

Independent Tutoring and Instruction –

Tutored in various courses elementary and junior high level. 6/10-12/10

08/09-5/10 RBC Bank – Senior Business Analyst

Project: Business Analyst working Basel II. compliance project.

Performed analysis on effects of Basel Accord requirements on existing systems to include Commercial, Real Estate and Personal Systems.

Worked on migration for loan and mortgage systems.

Conducted business process analysis, requirements gathering, use cases, and all related data analytics to record needed source data.

Performed data mining and profiling for risk loan systems.

Conducted risk analysis and assessments

Coordinated client communication throughout the project life cycle informing clients of updates and potential impacts as well as scheduling and coordinating client meetings.

Environment: SDLC, Sql Server, MS Office Suite, Teradata.

10/08-06/09

First Citizens Bank- Senior Business Data Analyst

Project: Business Analyst working on AML project and compliance for all banking systems

Organized and chaired meetings and walkthrough sessions for related activities using Citrix Go TO Meeting.

Performed analytics and trending analysis for E-commerce risk reporting system, insurance (life, P&C) and credit markets using Cobol, CICS, DB2 and SQL.

Performed data mining and profiling for risk and loan systems.

Gathered and translating business requirements for AML compliance requirements.

Worked on migration for loan and mortgage systems.

Communicated with shareholders and financial representatives of account activity and procedures.

Environment: SDLC, Sql Server, MS Office Suite, IBM Mainframe, VSAM, DL1.

02/08-09/08

Carquest – Team Lead Senior Business and Technical Analyst

Project: Team Lead working on for new Web based Parts Ordering and Security Systems Weblink 2.

Created business requirement, impacts assessment, risk management, testing and target mapping documents eservices automotive E-commerce parts ordering system

Responsible for coordinating all systems and UAT testing between business and development

Designed maps and screens for development.

Created structured use and test cases for development team.

Created BPM documents for product and sales using WebSphere

Performed data analysis, data mining, and data migration mapping of source data for target database

Responsible for working with various vendors involved in providing software for the project.

Environment: SDLC, Sql Server, MS Office Suite, Oracle.

03/06-01/08

CISCO - Senior Business Analyst

Project: Team Lead working on for new TL9000 Quest customer satisfaction and response project.

Created business requirement, impacts assessment, risk management, testing and target mapping documents for new onboarding of TL9000 software.

Responsible for coordinating all systems and UAT testing between business and development

Designed maps and screens for development.

Performed data analysis, data mining, and data migration mapping of source data for target database

Responsible for working with various external customers on the Quest forum.

Environment: SDLC, Sql Server, MS Office Suite, TOAD, Teradata

08/05-3/6

BB&T- Senior Business Analyst

Project: Business Analyst working Basel II. compliance project.

Coordinate source data analysis activities and requirements for Commercial Loans, Responsibilities included risk analysis for in house Loan Origination Mortgage System, Mortgage pooling investments

Responsible for leading and coordinating the analysis, design and management of source data transformed from multiple source systems for the data warehouse.

Responsible for coordinating all systems and UAT testing between business and development teams using Quality Center 9.0

Worked on migration for loan and mortgage systems.

Assigned to support all vendor communication for the life cycle of the project

Designed maps and screens for development.

Performed data analysis, data mining, and data migration mapping of source data for target database

Environment: SDLC, Sql Server, MS Office Suite, TOAD, Teradata

Participated in QA to include writing use and test cases and system and user acceptance testing

01/03-09/05

RBC- Senior Business Technical Analyst

Project: Business Analyst working Basel II. compliance, AML and item processing projects.

Coordinate source data analysis activities and requirements for all banking channels.

Responsible for leading and coordinating the analysis, design and management of source data transformed from multiple source systems for item processing database...

Responsible for coordinating all systems and UAT testing between business and development teams.

Assigned to support all internal customer communication for the life cycle of the project

Provided detailed requirements specification documents.

Worked on migration for loan and mortgage systems.

Performed data analysis, data mining, and data migration mapping of source data for target database

Environment: SDLC, Sql Server, MS Office Suite, Mainframe IBM 3090.

Participated in QA to include writing use and test cases and system and user acceptance testing

04/02-08/-02

BOA - Senior Business Technical Analyst

Project: Business Analyst working on conversion of financial applications to Siebel database platform.

Responsible for leading and coordinating the analysis, design and management of source data transformed from multiple source systems for item processing database...

Responsible for coordinating all systems and UAT testing between business and development teams.

Worked with various Line of business using business process methodology to complete analysis and documentation

Performed data analysis, data mining, and data migration mapping of source data for target database

Environment: Siebel, MS Office Suite, Mainframe IBM 3090.Teradata

10/00-03/-02

IBM – Lead Senior Business Analyst

Project: Business Analyst working on Shop IBM web base customer retail ordering system.

Responsible for leading and coordinating the analysis, design and management of source data transformed from multiple source systems to support the Shop IBM website.

Responsible for coordinating all systems and UAT testing between business and development teams.

Worked with various Line of business using business process methodology to complete analysis and documentation

Performed data analysis, data mining, and data migration mapping of source data for target database to support migration of IBM related system data to CI database.

Environment: Siebel, MS Office Suite, Mainframe IBM 3090.IBM/OS

09/97-10/-00

MetLife – Lead Senior Technical Analyst Programmer

Projects: Senior Business Analyst working on batch claim system for General Relief Claim Project and Life & property.

Senior Business Analyst POMP Public Offering Project and property & casualty systems, systems.

Senior Programmer/Business Analyst/ Define Contributions Project and Life annuities.

Senior Programmer/Business Analyst) Year 2000 Conversion Multiple Systems.

Responsible for the analysis, requirements creation.

Responsible for coordinating all systems and UAT testing between business and development teams.

Performed data analysis, data mining, and data migration mapping of source data for target database to support migration of client data to target database.

Environment: Mainframe IBM 3090.IBM/OS

07/93-08/-97

Prudential – Lead Senior Technical Analyst Programmer

Projects: Senior Business Analyst working on Define contributions project.

Senior Business Analyst payment history and retirement systems.

Senior Programmer/Business Analyst/ Define Contributions Project and Life annuities.

Senior Business Analyst working on time/attendance/scheduling for claims team.

Responsible for the analysis, requirements creation.

Responsible for coordinating all systems and UAT testing between business and development teams.

Performed data analysis, data mining, and data migration mapping of source data for target database to support migration of client data to target database.

Responsible for programming for new enhancements and modifications to payment history systems

Environment: Mainframe IBM 3090.IBM/OS

Independent Consulting - Programmer Analyst, Business and Systems Analyst 12/81-06/93

Projects include working on a time/attendance, scheduling systems for USPS and a time tracking WIP system for International Paper.

Other Professional Experience

College Misericordia – Part time information technology instructor 09/83-09/84

Wyoming Seminary - -Elementary and Junior high teacher 09/77–11/80

Bullis Prep - Elementary and Junior high teacher 09/75–7/77

EDUCATION

Wilkes College, Wilkes-Barre, Pa. B.A. Elem. Ed.

Continuing Study: Wilkes College - Computer Science,

University of Scranton, Scranton, Pa - Mathematics.

In-house Project Management instruction (Project Management Institute)

IBM data and business analysis training.

CMMI training participant.

Contact this candidate