Jason Nance

Jason Nance

BB&T SQL Server DBA, Platform Services Team

Location
Greensboro/Winston-Salem, North Carolina Area
Industry
Financial Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Jason Nance know in common
  • Get introduced to Jason Nance
  • Contact Jason Nance directly

View Jason's full profile

Jason Nance's Overview

Current
  • Database Administrator at BB&T
Past
  • EPIC Certified Clarity ETL, Hyperspace Configuration, and Chronicles Utility Administrator at Moses Cone Health System
  • Sql Server 2008 Database Administrator / Server Administrator at Moses Cone Health System
  • Attender, Chairman of Budget Committee, Session Elder at Second Presbyterian Church Lexington
Education
  • Pfeiffer University
  • Pfeiffer University
  • The University of North Carolina at Greensboro
Connections

265 connections

Jason Nance's Summary

I am a Database Administrator with 8+ years of Senior Technical Level experience. I have detailed knowledge of:
1- SQL Server: Clustering, Performance Tuning, Maintaining and Creating Structures, Filegroups, Replication, Backup and Disaster Recovery, SSAS, SSIS / DTS, and ETL experience.
2- EPIC 2012 and 2010 Certifications in Hyperspace Configuration, Clarity ETL Admin, and Chronicles Install Utilities.
3- Hyperion 4, 6.5, 7.x, 9.x experience. ASO/BSO development, EIS and custom solutions using star schema.
4- Microsoft Amalga DADE, Message Queue, Parser, Database, and Application Server experience.
5- EDI Gentran and Data Transformation

I do make a positive impact at any company I am employed with by practicing hard work, time management, teamwork and leadership skills! I look forward to growing into more technical and management roles to promote use of IT systems in a efficient and effective manner. If you are looking for a person who can deliver it all to your company and impact the bottom line, I'm your man!

I plan to move into additional DBA's roles / duties and management goals in the near future.

Jason Nance's Experience

Database Administrator

BB&T

Public Company; 10,001+ employees; BBT; Financial Services industry

August 2013Present (1 year 3 months) greensboro, north carolina

EPIC Certified Clarity ETL, Hyperspace Configuration, and Chronicles Utility Administrator

Moses Cone Health System

Nonprofit; 5001-10,000 employees; Hospital & Health Care industry

January 2011August 2013 (2 years 8 months) Greensboro/Winston-Salem, North Carolina Area

Database, ETL, and Server Administrator duties for 9 EPIC servers
Database Experience using SS 2008 and 2012 with backup & recovery, filegroups, Clustering, Performance Tuning, Maintaining and Creating Structures, SSIS, and SSAS.
Automate all backup and DBCC checkdb jobs on a daily and weekly basis
Create new filegroups and maintain filegroups for easier restoration methods
Monitor and improve performance across 17K tables within the Clarity Database
Clarity Administrator for 3 EPIC Environments (POC, TST, PRD)
Fix Full and Incremental Load errors and involve proper application coordinators as needed
Liaison between 9 report writers and EPIC EUD team
Handle data feeds between Cone and outside vendors including Press Ganey, FTI, SER w/FTP using Sql Server Integration Services
SSIS Developer for the Cone Health EUD Team, 78+ Packages Created / Maintained
Business Objects SAP and EPIC Crystal Integration Administrator

Sql Server 2008 Database Administrator / Server Administrator

Moses Cone Health System

Nonprofit; 5001-10,000 employees; Hospital & Health Care industry

October 2009January 2011 (1 year 4 months)

Database Administrator for the Amalga project using Sql Server 2008. Integrated P2P Replication with two production servers. Automated nightly index jobs and predicting quite a bit of data growth over the next few months. Working with Windows Server 2008 and I support clustered servers.
Systems Administrator for the DADE, Message Queue, Parser, Data, and Application Servers. Responsible for security, database, and systems access in Amalga.

Attender, Chairman of Budget Committee, Session Elder

Second Presbyterian Church Lexington

20022010 (8 years) Lexington, NC

Formulated and created budgets for Second Presbyterian Church in Lexington, NC.

Senior Technical Analyst

Moses Cone Health System

Nonprofit; 5001-10,000 employees; Hospital & Health Care industry

September 2005October 2009 (4 years 2 months)

• Plan, Install, and Lead Hyperion ERP rollout system wide
o 110% Return on Investment with savings of 3.1 million over 3 years
• Project Leader on 7 system wide projects affecting General Ledger, IDX Hospital, Human Resource, Accounts Payable, and IDX Physician Reimbursement
o Projects led to savings of 1.8 million in labor costs annually
• Assist CFO, Controllers, and Accountants with financial and reimbursement analysis
• Created executive dashboard (analyzer) and detailed financial reports for monthly processes
• Supervise and assist team members with development tasks affecting hospital services / programs
• SQL Server Administrator and Developer for 10 databases
• Implemented automated financial reporting tool for Finance
• Created reimbursement database for all MCHS payers to provide financial analysis to our reimbursement team

Project Lead / Senior Technical Analyst

Moses Cone Health System

Nonprofit; 5001-10,000 employees; Hospital & Health Care industry

September 2005October 2009 (4 years 2 months)

Plan, Install, and Lead Hyperion ERP rollout system wide
110% Return on Investment with savings of 3.1 million over 3 years
Project Leader on 7 system wide projects affecting General Ledger, IDX Hospital, Human Resource, Accounts Payable, and IDX Physician Reimbursement
Projects led to savings of 1.8 million in labor costs annually
Assist CFO, Controllers, and Accountants with financial and reimbursement analysis
Created executive dashboard (analyzer) and detailed financial reports for monthly processes
Supervise and assist team members with development tasks affecting hospital services / programs
SQL Server Administrator and Developer for 10 databases
Implemented automated financial reporting tool for Finance
Created reimbursement database for all MCHS payers to provide financial analysis to our reimbursement team

Business Analyst II

Jefferson Pilot Financial

Public Company; 1001-5000 employees; Insurance industry

April 2005September 2005 (6 months)

Promotion
Jefferson Pilot Finance Team Employee of The Quarter - Q1 of 2005
Responsible for successful rollout of Planning project on August 1st
Project lead for Hyperion Planning project
Essbase Administrator for all 12 Essbase cubes
Work with Cost Strategies to provide adequate financial analysis for JPF life insurance functions
Liaison with Finance and IT teams to develop systematic budgeting and finance concepts within Hyperion applications.
Created automated MAXL / ESSCMD process for Hyperion Applications
Responsible for all Monthly Essbase Loads
Assist clients with help desk issues relating to Finance applications

Business Analyst II

Jefferson Pilot Financial

Public Company; 1001-5000 employees; Insurance industry

May 2004September 2005 (1 year 5 months)

• Responsible for successful rollout of Planning project on August 1st
• Project lead for Hyperion Planning project
• Essbase Administrator for all 12 Essbase cubes
• Work with Cost Strategies to provide adequate financial analysis for JPF life insurance functions
• Liaison with Finance and IT teams to develop systematic budgeting and finance concepts within Hyperion applications.
• Created automated MAXL / ESSCMD process for Hyperion Applications
• Responsible for all Monthly Essbase Loads
• Assist clients with help desk issues relating to Finance applications
• Worked with Investment Analysts to create a new Bond Limit system to limit over/under exposure within certain financial portfolios
• Created and maintained 2005 Budget for Jefferson Pilot
• Used HAL for data loads for Hyperion Financial Management
• Handled maintenance for PL/SQL applications for Jefferson Pilot’s Finance Department
• Worked with DBA group to develop alerts on bonds and stocks

Business Analyst

Jefferson Pilot Financial

Public Company; 1001-5000 employees; Insurance industry

May 2004April 2005 (1 year)

Worked with Investment Analysts to create a new Bond Limit system to limit over/under exposure within certain financial portfolios
Created and maintained 2005 Budget for Jefferson Pilot
Used HAL for data loads for Hyperion Financial Management
Handled maintenance for PL/SQL applications for Jefferson Pilot's Finance Department
Worked with DBA group to develop alerts on bonds and stocks

Applications Programmer / EDI Coordinator

Universal Furniture

December 2002May 2004 (1 year 6 months)

• Created and modified Oracle reports for supply chain managers & end users
• Managed SQL Server databases and assisted in the development of scripts
• Created EDI maps, managed the EDI gateway, and programmed internally for our EDI partners
• Assisted manager with Visual Basic and VBA applications & reports
• Developed project management guidelines for custom applications
• Built a relationship between IT and Supply Chain / Product Development for new products

Applications Programmer / EDI Coordinator

Legacy Classic Furniture

December 2002May 2004 (1 year 6 months)

Created and modified Oracle reports for supply chain managers & end users
Managed SQL Server databases and assisted in the development of scripts
Created EDI maps, managed the EDI gateway, and programmed internally for our EDI partners
Assisted manager with Visual Basic and VBA applications & reports
Developed project management guidelines for custom applications
Built a relationship between IT and Supply Chain / Product Development for new products

Jason Nance's Skills & Expertise

  1. SSIS
  2. DTS
  3. Databases
  4. Microsoft SQL Server
  5. ETL
  6. Hyperion
  7. Hyperion Planning
  8. Hyperion Enter
  9. Oracle E-Business Suite
  10. Oracle SQL
  11. Oracle
  12. SQL
  13. Access
  14. Healthcare Information Technology
  15. Windows Server
  16. Epic Systems
  17. Disaster Recovery
  18. Business Objects
  19. Integration

Jason Nance's Certifications

  • EPIC 2010 Hyperspace Configuration

    • EPIC
  • EPIC 2010 Clarity Extract, Transform, and Load Administration

    • EPIC
  • EPIC 2010 Chronicles Utilities Administration

    • EPIC

Jason Nance's Education

Pfeiffer University

Masters, Business Administration

20082009

Pfeiffer University

Masters, Health Administration

20062008

Activities and Societies: Graduated with Honors, 4.0 GPA.

The University of North Carolina at Greensboro

B.S, Information Systems and Operations Management

19992003

University of North Carolina at Greensboro

BS, Information Systems

19992003

Jason Nance's Additional Information

Interests:

Aj Allmendinger, NASCAR, Taekwondo, fitness, kids, parenting, fishing, leadership, trying new things

Groups and Associations:
Honors and Awards:

National Honors Society, Graduate Level Inductee, 2008

Contact Jason for:

  • career opportunities
  • consulting offers
  • new ventures
  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Jason Nance’s full profile to...

  • See who you and Jason Nance know in common
  • Get introduced to Jason Nance
  • Contact Jason Nance directly

View Jason's full profile

Not the Jason Nance you were looking for? View more »

Viewers of this profile also viewed...