SUMMARY:

• For over 12 years smart, agile information management with Microsoft SQL Server Business Intelligence. 20 years overall as SQL Server data architect.
• Athletic integration of business sources with well organized, highly structured services; data hub ETL: SSIS, MapReduce, wizards, etc.
• Teams: project management & BI solution; with spiral & agile methods.
• Timely business events stored in Data Warehouse; fresh, unspoiled, honest facts.
• Enabler of dashing dashboards using the Business Intelligence Semantic Model. Where we use Power BI, Power Pivot/Views and Excel to share with alacrity, the most agile of agile BI.
• Variance analysis on neural - net intelligence with an amino acid solution for human learning.

• spiral DW; risk based projects
• Hybrid Cloud integration; DevOps, DW, data lakes, Azure
• DBA; AlwaysOn, security
• Complex integration tier using SSIS 2014/2016, MapReduce
• T-SQL including window functions
• agile BI projects: BEAM, extreme scoping
• Semantic tier: SSAS, Power BI; KPI
• Dimensional tier: normalized/incremental models

Confidential

Tucker Ga

Sr. Data Warehouse Engineer

• Converted and redesigned 45 packages for project deployment. New ETL control flows; modular and audited data flows and transforms. Rewrote T-SQL in lookups to end transaction blocking and reduce memory use. Wrote T-SQL for incremental data extraction. Optimized run time by 89%.
• Reduce size of database by factor of 4 to reduce SSAS bottlenecks from DW loads and MDX queries.
• Rewrote Revenue by Employee packages to balance employee counts; measure group and hierarchies merged with GL database. Used windows functions for product, sales and customer packages.
• CAO proposal; to produce Cash statement by direct means; subtract COGS from Receivables.
• Resolved 1.5% variance between Sale and General Ledger reporting through forensic analysis of SSIS packages. Tabular T-SQL data model with PowerPivot DAX functions to filter and Calculate.

Tucker, Ga.

BI Architect

• Managed DW projects on SharePoint to lead agile 3 members, off shore team; with spiral model.
• Reduced daily ETL process from 7 hours to 3 hours for 20 TB Financial Data Warehouse.
• Switched BI services in 3 domains from NTLM to Kerberos, using Azure VM Datacenter strategy. As SME, trained domain administrators on cloud OS needs.
• Transformed a LX ERP sales sub-ledger into agile tabular data model using DAX Calculate function. Deployed for sales analysis in SAP BW using PowerPivot.
• Machine learning using linear regression; monitored variance of industrial weighing machines. Designed MDX calculated members to show if a machine needed adjustment.

Atlanta, Ga.

Data Warehouse Engineer

• Engaged to do a complete rebuild; assisted BI Director in off shoring application to a team in India.
• Recommend BI workflow to identify exceptions without stopping ETL daily process.
• Standardized legacy data warehouse Invoice Journaling exception handling in SSIS. Reduced issues with SQL Agent jobs, SSAS cubes, SSIS packages and data warehouse schemas by optimizing the Invoice process using Sale data.

Atlanta, Ga.

Senior Data Modeler

• Integrated Hadoop-like text mining within SSIS; combined windows functions, fuzzy lookup and term extraction transforms to classify text from customer surveys. Implemented SSIS MapReduce case task algorithm for Term frequency / inverse document frequency (tf-idf) with calculations for significance and similarity in data warehouse. Business strategy; to engage 5 member BI development team for their help in outsourcing to department.

Milton, Ga

SQL Server Consultant 

• Model JD Edwards Costing and Manufacturing formula in SSAS using BEAM; use regression formulas within SSAS and develop drill down between actual and standard Cost ledgers in the data.
• Designed and implemented multidimensional Cost database; MDX calculated members for regression; optimized MDX functions, sets and tuples for other databases.

Atlanta, Ga.

SQL Server BI OLAP Lead

• Data Warehouse project management team; using extreme scoping agile methods; in DW Architect role gathered and defined business requirements and rules with BEAM.
• ETL, BI and DW tracks, developer for all SSIS packages; SSAS cubes and management tools.
• BI database modeler and developer for Integration, Dimensional tiers and BI Semantic layer with SSAS cubes.
• Data mining track; designed and implemented custom MDX calculated members; developed with pre-prepared case task for linear regression daily Churn Rate formula over 5 variables model.
• BI semantic modeling strategy; improve scalability; incorporate individual business BI data models from Excel; into multidimensional cubes, accessible for everyone with Excel/PowerPivot. Featuring calculated measures, security and capacity to automate development; deployment and operation of the BI solution.
• BI Engineer; designed technical specification of servers to host application that saved $200,000 each.

SQL Server Consultant

• Time Clock Journal; detected and resolved OLTP SQL Server 2008 memory and I/O contention using statistics and indexes I created and managed dynamically with views, stored procedure and functions. I modified T-SQL DML and DDL to mitigate performance, blocking and deadlocking issues from contention. To increase integrity; reviewed backups, index rebuilds, recovery models, database shrink operations, DBCC commands and clustering operations. And recommended and/or implemented operational automation.
• Improved T-SQL performance in a data warehouse for a SQL Server 2000 inventory application with resource lock/blocks, data flow waits and process costs for CPU and IO.
• Improved the performance of SQL Server 2000 advertising and a 2005 media sales application by designing server to perform 25,000 random IOPs with 50 Terabytes DB.

SQL Server BI Lead

• Created Tabular Mode SSAS (CTP1) application to calculate Revenue by Employee for media sales.
• Engineering Budget Data Mart using SSIS and T-SQL DM; Implemented BCNF on 20 vector arrays to transform Procurement attributes using a set of 69 SSIS packages to extract budget amounts for 50,000 projects. Loading into Budget sub-journal data warehouse. Implemented best practices data flow transformations reducing 90 minutes daily receiving process to 4 minutes.
• Optimize Business Objects queries to SQL Server 2005 by deploying a disk partitioning solution.

Marietta, Ga.

Production Support DBA & SQL Server

• Chief financial officer said Data Center costs were too high. I was hired to fix all the SQL Servers. Optimized C drives and LUNS; offset partition starting blocks and consolidated SAN and Ethernet adapters.
• Budget consolidation; As BI developer, solved latency issues on SQL Server 2005 Analysis Services with a fast server that Chief Financial Officer said was critical in reducing layoffs during quarterly budget process.
• AS DBA led 3 person team, implemented 24/6 worldwide support for Dynamics GP accounting system. Database backup solution that mitigated risk of incomplete SQL Server backups when using NetApp network shares by tactical use of Microsoft best practices.

Smyrna, Ga 

SQL Server general specialist

• As solo DBA built administration from 1 Frankenstein Purchasing server to 25 enterprise class production servers. Frank was able to consolidate 42 distribution center’s POs in 80% less time.
• Dealer services; Cloud based, Software as a Service (SaaS) data architect; implemented AlwaysOn using a devOps approach with extended stored procedures called from SQL-ODS API.
• As BI developer led a 7 person team, analyzed, designed and implemented data stores for central purchasing, merchandising and pricing requirements that increased profits for the business.
• Pricing; As DB developer led a 3 person team, implemented optimistic locking strategy to increase concurrency of federated server’s implicit type transactions without the overhead of row level versioning for Performance Point system.

Atlanta, GA

SQL Server general specialist

• Payment Card; As DB Administrator led a 3 person team; implemented highly available solutions with Windows 2000 active/active failover cluster that saved money
• As DB developer led 3 person team, analyzed, designed and implemented DW strategy by deriving a consolidated conceptual model using Erwin
• As BI developer led a 7 person team, analyzed, designed and implemented DW; mapped ETL of master data from OLTP instance into DW import tables using data flow diagrams.

Atlanta, GA

SQL Server DB Administrator

• As DB Administrator led 3 teams, implemented lifecycle deployment process for secure change management of every client server or 3 tiered PowerBuilder or Visual Basic 4.0 code release.
• Implemented HIPAA security across CDC Chronic Diseases Web Portal; in depth defense, every Internet Protocol page moving between web and database shielded by Active Directory authentication.

Atlanta, GA

Director product development

• Credit Card; led 8 person team; Migrated Bank Clearing House Data to SQL Server
• As DB developer, analyzed and designed extremely (millisecond) fast transaction process for SQL Server 6.5
• AS BI developer, analyzed, designed and implemented process models that consolidated multiple OLTP credit card data flows from regional bank clearing houses into merchant accounts for this credit card processor

Atlanta, GA

SQL Server Data Analyst as consultant

• Dimensional design for SQL Server 6.5 data warehouse

Norcross, GA

SQL Server database manager

Responsibilities:

• One of the first to use multi-dimensional data warehouse from IRI Software. They trained me for 3 years on cube design.