PROFESSIONAL SUMMARY:

• Database and Data Warehouse professional that has architected and developed business solutions.
• I have a financial and business background that allows me to see the business problem that needs to be solved at a high level, and my technical ability allows me to deliver the end product.
• Programs that I have written for companies whether small or large have allowed business to save costs, become more operationally efficient, and realize their strengths and weaknesses.
• I have a passion in what I do as a developer and architect, and enjoy training co - workers in best practices and learning new technologies.

TECHNICAL SKILLS:

• SQL Server (T - SQL)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Reporting Services (SSRS)
• Microsoft SharePoint (SSRS integrated mode, document retention)
• Microsoft PDW(APS)
• Power View
• Oracle
• Microsoft Visio as modeling tool
• CA Erwin Data modeling tool
• T - SQL
• DSQL(distributed SQL Microsoft PDW)
• MDX
• VB.NET
• VB script
• OLTP data modeling
• Kimball dimensional modeling
• Extensive SQL development(queries, triggers, stored procedures, views, bject creation, performance tuning)
• OLAP cube development and query development (MDX)
• ETL, data scrubbing, SSIS scripting, FTP, SFTP
• Light DBA activities
• AGILE/SCRUM development methodology

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

SENIOR BI DEVELOPER CONSULTANT

Responsibilities:

• Architected and developed Enterprise data warehouse using Kimball methodology on Microsoft Parallel data warehouse (PDW/APS) hardware.
• Produced high level dashboards using Microsoft Power View that allowed end users to interactively drill down and explore data.
• Taught interactive training sessions on OLAP cubes and Kimball data warehousing theory.

Confidential, Nashville, TN

SENIOR DATA ARCHITECT CONSULTANT

Responsibilities:

• Created data model for real-time high volume OLTP database.
• Worked with BizTalk analyst to create interface to parse and push HL7 data into SQL server database.
• Developed back end data structures for multi-state, multi-hospital web applications.
• Did company presentation using Microsoft Analysis Services to show drill-down capability of medical information stored in OLAP cube.

Confidential, Nashville, TN

SENIOR ETL DEVELOPER CONSULTANT

Responsibilities:

• Re-engineered manual processes to self-service reporting and business intelligence platforms using Microsoft BI software stack.
• Worked with business users to streamline and automate business tasks using technology best practices.

Confidential, Nashville, TN

SENIOR BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Helped architect data warehouse for Accountable Care Organization.
• Used SSIS to ETL Operational Data Store and Star Schema.

Confidential, Nashville, TN

SENIOR BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Refactored data warehouse using Microsoft BI stack.
• Created SSAS cube that tracked client outcomes allowing greater visibility to member health improvement.
• Developed pivot tables with Excel 2010, and reports with SSRS 2010.

Confidential, Nashville, TN

SENIOR BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Developed OLAP cube to assist management in preventing theft and increase profit margin.
• Used SQL best practices to increase IT productivity and code maintainability.

Confidential, Nashville, TN

SENIOR BUSINESS INTELLIGENCE ANALYST/DATABASE DEVELOPER

Responsibilities:

• Using Microsoft Business Intelligence software platform to create OLAP cubes.
• Interviewed senior management to determine Data Warehousing needs and reporting requirements.
• Created SQL based reports that allowed senior management to increase productivity, and operational efficiency.
• Created process using T-SQL to reconcile insurance payments.
• Installed and manage accounting department software. Created ETL scripts to load data into software database.
• Provided information to Pharmacy department by writing SQL queries and production algorithms.

Confidential, Nashville, TN

DATA ANALYST SPECIALIST

Responsibilities:

• Participated as Business Analyst in File net Workflow Management project in order to increase efficiencies to existing manual production processes.
• Created flowcharts for workflow processes, wrote business use cases for responsibility items, and conceptualized business methods into technological solutions.
• Saved Recovery Department large amounts of manual labor time, and eliminated thousands of pages of paper waste by creating online reconciliation tool.
• Developed tool to audit and track company-wide employee badge access by importing data from two systems, and presenting information to management via a Pivot Table report.
• Used SQL server to write front end database to track “special” manual checks.
• Trained personal backup in job functions, Visual Basic, and SQL Server language.
• Used Medicare claims database to deliver reports and SQL queries.
• Created Visual Basic code and macros to save production analysts time and keystrokes.
• Delivered reports to management by writing complex SQL queries.
• Re-engineered productivity reporting system by producing a back end database that links to pivot tables and pivot charts.

Confidential, Nashville, TN

VOLUNTEER

Responsibilities:

• Took initiative to create budgeting tool for “Off the shelf “software package.
• Literally noticed a stack of papers in Associate pastors’ chair, took papers and spreadsheets, suggested SQL database, and transformed tedious process into semi-automated, online financial management tool.

Confidential, Nashville, TN

SENIOR DATA ANALYST CONSULTANT

Responsibilities:

• Assisted in financial billing system conversion project.
• Utilized Microsoft Access to automate reporting.
• Created database to locate outstanding invoices.
• Transformed 3 day data entry check process to a half hour database upload.
• Programmed Visual Basic subroutines and functions.
• Used Access to perform complex queries for management.

Confidential, MO

SENIOR ACCOUNTANT

Responsibilities:

• Created financial reports using Microsoft Access and Excel.
• Managed books for Confidential Holding Company.
• Assisted Comptroller and immediate supervisor with various projects.
• Worked with external auditors.
• Closed books on monthly and yearly cycles.

Confidential, Des Moines, IA

AGRICULTURAL DIVISION ACCOUNTANT

Responsibilities:

• Prepared management reports.
• Monitored expenses at managements’ request.
• Participated in fixed asset audit.
• Participated in finished goods inventory audit.
• Completed month and year-end closings.