SUMMARY:

• Developed job - quoting software that created $200,000 annual profit increase via BOM accuracy
• Eliminated 80 hours/month of manual processing of online gaming data in UK
• Developed program that integrated with accounting software to create $25,000 annual cost savings
• Automated SSIS packages that eliminated 2 hours of daily manual processing
• Saved 10 hours/week by automating Excel Pivot Tables via C# Script Task
• Found and fixed reporting that was $3 million off (after fixing performance issue and reconciling data)
• Created fuzzy-matching program post-merger to create system of record for prospective customers
• Took an SSRS report running in 28 minutes down to less than 2
• Generated $90,000 labor savings with implementation of vacuum manipulator
• Designed hopper-bin partitions which reduced component staging by 75%
• 10+ years SQL Server 6+ years in SSIS 20+ years in IT Application support 60+ users
• 10+ years in Report Design & Development SSRS / MDX / SSAS / Access / Pivot Tables / BI
• 2 years of VB.Net on application that I conceiveddesigned, and developed
• C# automation of Pivot Tables
• Took on unfinished projects and completed them all by going straight to the SMEs
• Supported international customers & analysts while developing invoice DB Confidential
• Meticulous about documentation, code commenting, and preparing materials for presentation
• 10 times I ve been hired to work Confidential, mostly in contracting for a cumulative 7 years. Twice with one group and over 3 years in another (catapulting my career in my transition from Access to SQL Server). Twice with Confidential for a total of 2 years. Add in over 4 Confidential for additional contracts totaling 13 years spent Confidential 3 companies. The real story driving my career is the quest behind it: A thirst for knowledge, a love of problem solving, and a pursuit to be part of something special. My record of commitment can be found on my profile site. Please take a look, as it provides a wealth of insight into what I bring to the table

TECHNICAL SKILLS:

• Microsoft Certified Professional (MCP - 70-461: Querying Microsoft SQL Server 2012/2014)
• Microsoft Certified Professional (MCP-70-463: Implementing a Data Warehouse with SQL 2012/2014)
• Advanced Confidential -SQL Stored Procedures & Functions Dynamic SQL XML/X-Path/X-Query
• Extensive CTE usage Window Functions TRY-CATCH Full-Text Indexing TFS
• Batch Processing Creative use of set-based update construct: @variable = column = expression aka quirky update (avoiding row-by-row processing though well-versed in WHILE Loops & CURSORS)
• Global & Local Temp Tables / Table Variables / Table Value Constructors Integration Services
• Reporting Services C# VB.Net Analysis Services/SSAS MDX Data Warehousing
• OLTP OLAP ASP.Net/Classic Oracle Teradata Informix Access Excel
• Crystal Reports OLE Automation between Access, Word, and Excel SQL Server 2016-2000

PROFESSIONAL EXPERIENCE:

Confidential, Denton, TX

BI Developer

Responsibilities:

• Migrated MDX-based PerformancePoint reports to SSRS
• Automated SSIS package to produce parameters for data-driven subscriptions
• Solved performance problem of a report taking over 2 minutes and took it to 4 seconds

Confidential, St. Louis, MO

BI Developer / Sr. Consultant

Responsibilities:

• Troubleshooting cube, data warehouse, SSIS packages, SSRS reports (including modifying MDX)
• Doing data warehouse interviews with key personnel Confidential the plant in preparation for phase II design
• Writing documentation and providing preliminary requirements
• Spearheading the use of Confidential as a collaboration tool and knowledge base

Confidential, Indianapolis, IN

BI Developer

Responsibilities:

• Developed new SSRS reports and fixed existing ones (including one that ran in 28 minutes and dropped it to 2)
• Assisted others in solving problems in SSIS packages
• Initiated our ongoing discussions to formally establish and refine best practices and standards
• Uploaded SSRS reports to SharePoint (though we later converted to Report Server)

Confidential, Charlotte, NC

Analytics Consultant

Responsibilities:

• Automated Excel processes with Confidential -SQL & ingenuity
• Designed and developed SSIS packages and SSRS reports
• Designed and developed new template for package configurations
• Spearheaded and developed best practices repository in Confidential
• Mentored junior developer

Confidential, Foster City, CA

Technology Lead

Responsibilities:

• Project canceled (Hired as SQL Server Data Warehouse Developer / SSIS / SSRS)

Confidential, Charlotte, NC

SQL Server/SSRS Developer / Analyst

Responsibilities:

• Rewrote ETL procedures—dropping time from 2:37 to less than a second using SQL 2012 features
• Discovered & resolved incorrect calculations and duplicated staging data
• Corrected code fixed reporting that was over $3 million off
• Designed and developed performance improvements to process 60 million rows
• Developed SSRS report for comparing package version builds across all environments
• Automated email processing using FOR XML clause to produce output
• Made modifications to multiple databases and elaborate SSIS packages
• Migrated SSRS reports and resolved 2005-to-2008 conversion issues

Confidential, Reno, NV

SQL Server Developer / Analyst

Responsibilities:

• Developed ETL and procedures for revenue/survey ranking for Confidential analysis of customers
• Supported database that I helped design and develop in previous contract here
• Developed enhancements in both SSIS and Procedures
• Trained support personnel for knowledge transfer
• Wrote in-depth documentation in Confidential to illustrate ETL architecture and procedures
• See Confidential section below for additional background on development

Confidential, Charlotte, NC

SQL Server Developer / Analyst

Responsibilities:

• Identified approach to eliminate convoluted straight SQL pulls from source system in SSIS
• Automated Excel Pivot Tables via C# in SSIS Script Task
• Performed Lead Developer role in documenting and designing data warehouse architecture
• Designed strategy for knowledge sharing and implementing best practices
• Mentored junior developer

Confidential, Reno, NV

SQL Server Developer / Analyst

Responsibilities:

• Developed invoicing database for online gaming in United Kingdom
• Conceived, designed, and developed ETL architecture for handling complex customer files
• Delicately convinced UK customers to make slight file modifications to allow for automation
• Customers were under no obligation to assist us, so this was no small feat
• Interacted with UK finance department to work out specifications
• Developed procedures, functions, and triggers for ETL and front-end application
• Co-developed data model, mentored junior developer, and implemented extensive documentation in Confidential along with in-depth code commenting

Confidential, Charlotte, NC

SQL Server Developer / Analyst

Responsibilities:

• Automated SSIS packages that eliminated 2 hours of daily manual processing
• Retooled fairly complex workflow to account for failures and out-of-date source files
• Collaborated with other developers and support personnel for design considerations
• Troubleshot and resolved mysterious memory issues with package configurations

Confidential, Charlotte, NC

SQL Server Developer / Analyst

Responsibilities:

• Developed OLTP database for loan escalation tracking
• Anticipated customer concerns and took initiative to develop solutions
• Assisted in development of data model
• Created all procedures, functions, and triggers, and indexes
• Created SSIS packages to pull system of record data and automate daily Excel extracts

Confidential, Charlotte, NC

SQL Server Developer / Analyst

Responsibilities:

• Designed and developed procedures to handle high-volume of data (100 million+)
• Created and maintained fairly complex SSIS packages pulling from multiple source types
• Implemented SSIS package configurations (Environment Variable and SQL Server)
• Developed loan portfolio data warehouse in team environment driven by SDLC
• Worked with business analysts and others to develop project specifications
• Maintained data model in Visio Architect (with some experience in Erwin)
• Conceived, designed, and developed SSIS solution to compare databases to data model

Confidential, Catawba, SC

SQL Server / ASP Developer / Analyst

Responsibilities:

• Developed and maintained complex Confidential -SQL stored procedures
• Modified ASP web pages and Crystal Reports for production reporting
• Supported Accounting to troubleshoot SQL procedures, jobs, ETL, and VB code

Confidential, Charlotte, NC

Access Developer / Analyst

Responsibilities:

• Designed and developed Business Intelligence tool for Oracle database
• Conceived solution out of conceptual requirements given no specifications
• Exceeded expectations by providing scalable UI driving dynamic reporting

Confidential, Charlotte, NC

SQL Server / Excel Pivot Table Developer / Analyst

Responsibilities:

• Created standardized stored procedure model for Pivot Table reporting
• Utilized Dynamic SQL to eliminate repetitive queries and hardcoded reporting
• Created entirely new report design that users preferred as dept. standard
• Automated DTS jobs and reports to require virtually no manual involvement

Confidential, Charlotte, NC

SQL Server / Oracle / VB.net / Access Developer / Analyst

Responsibilities:

• Created entirely new project by redesigning Pipeline OLTP database
• Provided dynamic data entry & reporting environment through VBA and SQL
• Modeled data sources to consolidate into new Prospect database (marketing utility)
• Developed SQL Server back-end for both databases (used nationwide and overseas)
• Designed matching functionality for merging data using SQL Server Full-text engine
• Migrated SQL Server database to Oracle post-merger
• Wrote stored procedures / functions / cursors to handle external data sources
• Automated Trend Analysis and SMART/CIBR Matching reports via Excel OLE

Confidential, Rutherford College, NC

Access Developer / Analyst

Responsibilities:

• Developed highly complex inventory control database
• Automated import of forecast & inventory Excel files in various country-based formats
• Coded interface to control data quality during import and scrubbing process
• Structured mapping tables to generate advanced and streamlined reporting capabilities

Confidential, Charlotte, NC

Access Developer / Analyst

Responsibilities:

• Rehired for high-visibility project to create Performance Analytics reporting tool
• Utilized Automation between Access and Excel to create and populate 240 workbooks

Confidential, Charlotte, NC

Lead Access Developer/ Analyst

Responsibilities:

• Redesigned existing database to create a more robust and scalable application
• Automated multiple processes and databases into a more streamlined operation
• Supported end-users, developers, and managers to optimize program design
• Created documentation for operation and development

Confidential, Charlotte, NC

Access Developer / Analyst

Responsibilities:

• Redesigned reporting database that uses Oracle via SQL Pass-Through Queries
• Streamlined database by 90% to improve accuracy of data and scalability
• Utilized modules to normalize and update data based on structured documentation
• Created user-friendly interfaces and standardized application with naming convention
• Developed & wrote procedure for processing quarterly marketing data via Access

Confidential, Charlotte, NC

President / Access Developer / Analyst

Responsibilities:

• Designed & Developed Job Quoting Software for Manufacturing & Repair facilities
• Created unique, complex but user-friendly functionality utilizing VBA, DAO & SQL
• Authored Online Help File, also being used for Instructional Booklet
• Developed marketing materials and strategy
• Customized software for individual companies to meet specific needs

Confidential, Charlotte, NC

Access Developer / Analyst

Responsibilities:

• Redesigned 95% of existing Project Mgmt. database to create a robust application
• Designed & Developed complex functionality using extensive VBA, DAO & SQL
• Utilized security for securing & manipulating DB, automating tasks & user awareness
• Developed Document Management System via OLE Automation & Microsoft Word
• Provided end-users with dynamic interfaces for intuitive querying of forms & reports
• Created an automated & secure Recognition database for voting on project managers
• Wrote Online Help File for Project Management database