Mark Loftus Email & Phone Number

Produce initial technical specification and prototype for Power BI Reporting Services deployment. Analyze Cobol Federal Report data model; transform for Microsoft Power BI reporting. Perform impact assessment for medium level compliance with Federal Risk and Authorization Management Program (FedRamp). Encrypt column level Sensitive Personally Identifiable Information (PII) on Microsoft Azure Government Community Cloud (GCC). Design schema for Semantic and Visual layers in SQL Server. Create paginated and visual reports.

Basking Ridge, Nj, Us

California Consumer Privacy Act, or CCPA initiative, to automate describing 10,000,000 IT schema column names into English. Supervised training of a Verizon dictionary. Using Python Language Processors to produce a one directional neural net meaning repository for testing.

Atlanta, Ga, Us

Inspire data management professionalism. Model a complex medical system’s Accounts Receivable, Revenue and billing. Produce their ETL, system architecture, data warehouse and Power BI visual layer. Develop 250 BIML markup language packages; deploy onto 2016 SQL Server Integration Services. Use C# to automate BIML package development.

Tucker, Ga, Us

• Migrated Financial Data Warehouse application to SQL Server 2014. Resolved 1.5% variance between Sales and General Ledger reporting through forensic financial analysis of SSIS packages. • Rewrote Revenue by Employee packages to balance employee counts.• Applied Kimball standard practices; removing NULL, adding row counts to packages. Normalized Sales and GL tables to enable incremental data loads.• Studied CIO proposal to validate SSIS packages for Receivables with Balance Sheet and P&L. Suggested strategy to produce Cash statement by direct means; subtracting COGS from Receivables. Map GL to AR; comparing Margin to Cash Flow through Receivables.

Bertrange, Lu

San Antonio, Texas, Us

AS BI Architect;• Document workflow of their data warehouse for a complete rebuild. • Recommend design patterns in SSIS packages to audit invoices. Organize BI workflow, identify exceptions and automate investigation processes.As Engineer in emergency session to backfill 5 person BI team• Troubleshooting current data warehouse exception handling. I resolved issues with SQL Agent jobs, SSAS cubes, SSIS packages and data warehouse schemas. Results were off shored to an operations team in India.

Dallas, Tx, Us

April 2014 - August 2014• AS Lead BI Developer; implement machine learning to classify text from customer surveys in SSIS. Use Big Data Term frequency / inverse document frequency to calculate significance and similarity. Business strategy; to engage 5 member BI development team for their help in out sourcing to business. Demonstrate proficiency of standard design pattern for Integrated Services package

Wilmington, Delaware, Us

3 Month Rapid Development Sprint• AS LEAD SSAS Developer; produced detailed dimensional model; designed OLAP database; as proof of concept for SSAS cube. Optimized legacy MDX filters, sets and calculations.

Melrose Park, South Australia, Au

Various short contracts around town as SQL Server Expert at:Apto Solution, IBEC, Cox Media, Georgia National Guard, Consolidated Container CompanyAs SQL Server development DBA: • 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. • Designed server to perform 25,000 random IOPs with 50 Terabytes DB that sold cable advertising.As SQL Server BI Lead • Engineering Budget Data Warehouse using Integrated Services and T-SQL DM; backfilled 69 sets of 20 identity column plus converting and deriving their Procurement attributes into Budget sub-journal data warehouse. Prepared best practices data flow transformations reducing 90 minute daily receiving process to 4 minutes. • Optimize Business Objects queries to SQL Server 2005 by designing a disk partitioning solution.

Atlanta, Ga, Us

SQL Server product manager solved problems in design, performance and database maintenance.

Atlanta, Ga, Us

Systems Science And Theory

Associate Of Science - As, Programming And Analysis