Objective:

Seeking a challenging position as a Sr MS DW/BI Developer in an environment where my initiatives and creative thinking can be nurtured, valued, and rewarded.

Skills:

More than 18 years of experience working within an IT sector providing software development, data analysis, data management, project work and requirement gathering.

Excellent communication, problem solving, and decision making skills

Experienced in identifying and organizing the implementation of solutions to issues both within and outside of own areas of responsibilities

Experienced in negotiating the issue resolution process, risk assessment, and decision point

Ability to make constructive recommendations to management and peers

Excellent understanding of project methodologies and software development cycle

Ability to learn new applications and apply development knowledge to package implementation

Software: MS Visual Studio.Net2000/2005/2008/2013/2015

RDBMS: MS Sql Server 2005/2008/2014/2016, Oracle

Work Experience:

Apex Systems, Charlotte, NC: Sr. SQL/BI Developer, May 2018 – Present

Support development and maintenance of SSIS packages for client’s DCOE business unit using Visual Studio 2015, Sql Server 2016. Modifying existing Dashboard to meet’s users’ requirements.

Avidxchange, Charlotte, NC: Sr. Data Warehouse, June 2017 – April 2018

Support development and maintenance of Company’s Data Warehouse. Converted existing Data Warehouse from Postgres SQL to SQL Server. The old DW was built on a product called Greenplum. The process involved re-writing the postgres sql to T-Sql. Creating new SSIS packages using Visual Studio 2015 and Sql Server 2016 to Extract, Transform, and Load the Dimension and Fact tables that make up the Warehouse. Business users were provided access to the data using ODS tables.

Cardinal Innovations Healthcare, Kannapolis, NC: Sr. BI Developer, Oct 2016 – June2017

There are approximately 550 SSIS packages that are used to Extract, Transform, and Load the Dimension and Fact tables that make up the Warehouse. SSAS is used to support the Cube. Existing SSIS and SSAS solutions are built on Visual Studio 2008, Sql Server 2008. Currently working on migrating to Visual Studio 2015 and Sql Server 2016. This project will complete in first week of April. The SSIS packages are being converted into Project Deployment model.

SonicAutomotive, Charlotte, NC: Sr. BI/DB Developer, April 2016 - Oct 2016

Support development and maintenance Inventory Model. This model predicts what vehicles to buy at auctions, which stores to send the bough vehicles, how to replenish stores when a vehicle is sold using historic data. It is implemented in SQL and called via SSIS packages. SqlServer 2014 and Visual Studio 2013.

Tek Systems, Charlotte, NC: Sr. BI Developer, Aug 2015 –March 2016

Support development and maintenance of SSIS packages for line of business using Visual Studio 2008, Sql Server 2008. Working on re-designing the existing Data Warehouse

Piedmont Natural Gas, Charlotte, NC: Sr. BI Developer, Nov 08 –July 2015

Delivery of architecture/solutions and taking ownership of business requirements, issues, integration to various source applications, development of full life cycle data models using Kimball methodology and innovative business intelligence delivery(SSAS, SSIS, SSRS) to users using Visual Studio 2008/2013, Sql Server 2008/2014 and Oracle DB server. Provide training/guidance to current and new associates.

Designed & developed the Data Mart for Power Plant database. Designed and developed the dimensional model for Accounting and Power Plant. Designed and developed the CUBE with flexibility to add more Power Plant modules in future. Build MDX calculations to compare Actuals, Budgets, Forecast, and other calculations.

Used tools like dbForge Studio for Oracle, Golden6 for refining SQL Queries, troubleshooting, and creating DDL for DBAs

Converted Legacy VB6 Web Application to C#/ASP.Net using Visual Studio2008 and TelerikRadcontrols for ASP.NET AJAX Q3 09

Attended “Dimensional Modeling in Depth” training at Kimball University in San Francisco, CA in March 2012. Ralph Kimball is the instructor for the course.

Bank of America, Charlotte, NC: Consultant – Apps Programming, July 04 – Oct 08

Extensive experience using MS Sql Server2000,2005 including but not limited to DDL, DML, DCL, TCL, Stored Procedures, Jobs, Triggers, DTS/SSIS Packages, Dynamic Queries, Link Servers

Extensive development experience using MS Visual Studio2005 developing Windows & Web Applications using C#.Net using built-in and third party controls including AJAX

Attended week long training on CognosReportNet 1.1 - Authoring and Modelling

Built strong working relationships with all component workgroup participants

Completed the Peer review report, which documents the recommended changes during the Peer review

Bank of America, Charlotte, NC, Senior Business Analyst, Nov 02 – June 04

Supported various initiatives within LoanSolutions Technology as Lead Analyst

Supported the deliverables for design throughout the Measure and Analyze stages of the SSP lifecycle to support Six Sigma methodology

Primarily responsible for creation of Software Requirement Specification, High Level Design, & Low Level Design documents

Provided technical expertise and background to component work effort during analysis and design

Point of contact and escalation for Component Work Teams for communications with LoanSolutions Technology Build teams and Event Build Management

Built strong working relationship with all component workgroup participants

Primarily responsible for creation of use cases, data mapping, and other supplementary design documents

Leveraged contact with technology experts and developers to ensure viability of technical solutions being designed

DST Innovis, El Dorado Hills, CA, S/W Engineer, Dec. 00 - July 02

Converted legacy product functionality from Tandem/Guardian to communicate with Client Applications running on a variety of platforms using XML

Identified and managed software build issues in a complex environment with multiple libraries and databases

Managed product code and bug fixes for a team of engineers

Executed manual and automated test procedures to verify product quality

Created extensive documentation of processes and instructions

Participated in the entire software development life cycle – requirements, design, development, unit test and change control

Conducted code walk through and design meetings

Unify Corp., Sacramento, CA, Software Porting Engineer, May 99 - Nov. 00

Built and tested Accell/SQL, DataServer, and eWave on Unix platforms

Installed and configured Oracle, Sybase and Informix databases

Trained new employees on processes and responsibilities

Executed manual/auto tests to verify product quality

Documented processes and instructions as well as created web site to post them

Education:

B.Sc. of Computer Science, University of Central Florida,

Orlando, FL May 99

Contact this candidate