We provide IT Staff Augmentation Services!

Senior Bi Developer Consultant Resume

Franklin, TN

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.

Hire Now