Daniel Frank Email & Phone Number

Atlanta, Georgia, United States

Alpharetta, Ga

- Lead SSAS multidimensional cube architect, SSRS report developer, SSIS ETL developer, data warehouse designer, and Power BI dashboard creator for enterprise supply chain data management solution.- Developed a multidimensional OLAP cube in SSAS complete with 30+ dimensions, 10+ fact tables, 36 partitions, query-log-based aggregations, attribute relationships, user-defined and parent-child hierarchies, KPI’s, calculations, and actions.- Helped design and develop our Data Warehouse by creating de-normalized views in OLTP and table structures, indexes, stored procedures and views in the data warehouse. I also populated ad-hoc data using SSIS dataflow tasks. - Created dynamic SSIS cube processing package that only processes current partitions. Also created cube staging table and view structures in TFS and cube staging ETL package in SSIS utilizing package containers and error logging.- Used agile scrum methodology through TFS and visual studio to keep track of tasks, bugs, and product backlog items. In addition, worked with Octopus deployment software to deploy our data warehouse to different database environments.

Sewanee, Ga

- Lead BI developer, SSAS tabular model architect, and SSRS report developer for all company departments. - Created a fully automated, enterprise-scale tabular model utilizing dimensional star and snowflake design schemas.- Developed and maintained 300+ active SSRS reports to 100+ SharePoint 2013 document libraries for all departments and customers using T-SQL and MDX queries from OLAP SSAS cubes, tabular models, and SQL Server databases.- Assisted in developing views and stored procedures using temporary tables, common table expressions, subqueries, joins, and other logic in T-SQL. I also performance tuned queries and used XMLA analysis services processing scripts.- Oversaw SSRS and SSAS project decisions. Collaborated extensively with business intelligence team and sales team to provide reporting solutions that communicate savings performance, key benchmarks, and metrics for the company.- Learned how to use R to forecast company sales and outline trends in cost analysis.- Provided reports using Microsoft Excel such as Macros, V-lookups, PowerPivot, and PivotTables and created interactive drill down dashboards and powerful data visualization in Microsoft Power BI.

Atlanta, Ga

Resolved $250,000 in outstanding accounts.Worked 15 to 25 hours a week in the finance services department while taking a full course load. Maintained a database for 400 accounts per month for corporate customers, vendors, and bottlers. Worked extensively in excel and learned pivot tables, vlookups, and macros.

Bachelor Of Arts, Economics

Activities and Societies: Volunteer Emory, FugeesFamily, Economic Student Society, Phi Delta Theta, Walk to Defeat ALS

Education record