Uploaded File
David
Danielsbik@yahoo.com
405-334-6679
155 Camp Creek Way
Georgetown, KY 40324
Senior Business Systems Analyst
10 years experience W2
0
Recommendations
Average rating
156
Profile views
Summary

Qualifications

Highly skilled and versatile Senior Business Systems Analyst with experience as a Technical Project Manager and Technical Project Leader, Senior Data Analyst, Data Architect, Data Modeling Analyst, MS SQL DBA. Has led or been a key resource on 12 conversion and implementation projects on Financial Applications for such companies as EverBank, TD Bank, Tempur+Sealy, Liberty International Underwriters (Guidewire), Bank of America (Basel II); Citigroup (Basel II); DHL; Harris Bank (Basel II); Northern Trust; Baker & McKenzie; Aon Consulting; Grant Thornton; Maine Dept of Education; Oklahoma Corporation Commission and Oklahoma State Dept of Education among others.

  • Expertise in Data Analysis, Modeling and Architecture, Database Administration, ERD Creation, Data Conversion Validation, Data Warehouse Development, Data Flow Modeling, Master Data Mapping, User Report Creation, Applications Development and Testing, Software Quality Assurance, User Acceptance Testing, Training and Support.
  • Thoroughly experienced and knowledgeable in Systems Development Life Cycle (SDLC) and Agile (Scrum) Software Development.
  • Exceptional ability to research, analyze and convey complex technical information to diverse end-users at all levels.
  • Recognized for partnering with business leaders and technical teams to plan, integrate, document and execute complex project plans on time and on budget.

Technical Skills

Platforms: Windows 7/Vista/XP/2000/NT/98, UNIX, Novell, AS/400, OS/2, IBM 3090.

Databases: MS SQL Server 2012/2008 R2/2005/2000/7.0, Oracle dB, MS Access, Sybase 10, DB2, and R:Base 4.5+ .

Software: MS Office Suite, Guidewire Contact Center & Claim Center, Informatica, Axio Data Profiler, RedGate SQL Tool Belt, .Net, Visual Studio 2008/2005, Virtual Source Safe, Jira, Queryman, MS Project, Business Objects, Crystal Reports, MS Visio, Outlook, Enterprise Manager, SQL Server Management Studio, SSIS, DTS, SSRS, SSAS, Query Analyzer, PL/SQL, Transact SQL, Toad, Citrix, pcAnywhere, Solution 6 CMS Open (Aderant), Elite Time & Billing, iManage, Lotus Notes, MicroFocus COBOL, HP Application Lifecycle Management & HP Application Lifecycle Management (HP ALM)

Experience
Sr. Business Systems Analyst/Project Manager
Banking/Financial
Jul 2015 - Feb 2016
  • Business Analyst and Project Manager on a data mapping project for System of Record of Home Loan system to forecasting reporting system.
  • Gather User requirements and systems current state, create Business Requirements & Functional Requirements and Technical Requirements Documents.
  • Manage resources in QA, UAT and deployment to Production.
Project Management Business Analysis Data Mapping BSA Quality Assurance System Analysis
Remove Skill
Sr. Business Systems Analyst
Banking/Financial
Feb 2015 - Jul 2015
  • Coordinate BAT (Business Acceptance Testing) efforts on upgrade of the FIS IMPACS application.
  • Gather User Approval verification on all BAT Test Scripts & Load and maintain scripts in HP ALM (HP Application Lifecycle Management) application. Monitor HP ALM Test Cycles during BAT execution. Defect remediation and tracking.
  • Update Weekly Project Status documents & gather all Audit Approval documentation.
Documentation HP ALM Auditing BSA System Analysis
Remove Skill
Senior Business Systems Analyst
Information Technology
Nov 2014 - Jan 2015
  • BSA supporting firm wide conversion from two Legacy ERP systems.
  • Interviewed Users to create BDD & FDD Requirement documents for Inventory and Warehouse Management functions.
  • Support QA and UAT testing of Inventory and Warehouse Departments financial implementations for Tempur+Sealy companies.
Quality Assurance UAT Warehouse Management BSA System Analysis ERP
Remove Skill
Senior Financial Systems Analyst
Information Technology
Mar 2013 - Dec 2013
  • Supported 25 Financial Applications on 44 Servers Firm wide including Thompson Elite Legal Billing System.
  • Setup hardware and software for a Development and Testing environments for SSIS & SSRS development support.
  • Managed and maintained SSIS and SSRS projects in Visual Studio 2005/2008.

Environment: MS Office, MS SQL Server 2012/2008 R2, Visual Studio 2008/2005, SSRS, SSIS, Visio, Red Gate SQL Tool Belt 7.0, Windows 7.

SQL SSIS SSRS Visual Studio Windows 7 System Analysis Windows SQL Server
Remove Skill
Senior Business Systems Analyst QA Consultant
Information Technology
Jun 2012 - Nov 2012
  • Quality Assurance Testing of Savi Applications in support of the Development Team.
  • Setup hardware and software for a Quality Assurance Testing Lab.
  • Creation of ERD, Data Analysis & Migration from Legacy version of Savi Application to application new database
Data Analysis Quality Assurance BSA System Analysis
Remove Skill
Senior Business Systems Analyst & Senior Data Analyst
Information Technology
Mar 2011 - Apr 2012
  • Technical Lead on Claims Data Conversion from Genius Legacy Application -AS/400-DB2 to Guidewire Application, .NET & MS SQL Server 2008 R2. Data Mapping and Reverse Engineering of Guidewire UI & DB for Claims Data conversion. Created SQL Server Integration Services (SSIS) Packages to transfer data from the Legacy A/S400-DB2 database to a standalone Staging MS SQL Server dB and loading into the Guidewire SQL Server dB.
  • Assisted in the QA and UAT of Guidewire application after each Agile Sprint Cycle.
  • Business Analyst role for working with Regional SME Users to define Guidewire functionality & historical Claims data conversion needs.
  • Provided data mapping and unit testing of converted data sets. Development Database Support for the Guidewire dB & .NET build deployments.
  • Lead the Deployment to Production Guidewire code deployment team with Application, Database updates and converted data uploads post Project Go Live.
.NET AS/400 Guidewire Visual Studio SQL UI DB2 Agile Methodology Data Conversion Data Mapping SQL Server BSA Business Analysis Data Analysis System Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
SSIS
2013
1
Windows 7
2013
1
SSRS
2013
1
System Analysis
2016
3
BSA
2016
2
.NET
2012
1
Agile Methodology
2012
1
AS/400
2012
1
Data Analysis
2012
1
Data Conversion
2012
1
Data Mapping
2016
1
DB2
2012
1
ERP
2015
1
Guidewire
2012
1
Quality Assurance
2016
1
SQL
2013
1
SQL Server
2013
1
UI
2012
1
Visual Studio
2013
1
Application Development
0
1
Auditing
2015
1
Business Analysis
2016
1
Citrix
0
1
Crystal Reports
0
1
Documentation
2015
1
GW ClaimCenter
0
1
HP ALM
2015
1
JIRA
0
1
MS Project
0
1
Project Management
2016
1
Scrum
0
1
TOAD
0
1
UAT
2015
1
UNIX
0
1
Warehouse Management
2015
1
Windows
2013
1