Dustin Elery Email & Phone Number

Indianapolis, Indiana, United States

Fishers, Indiana, United States

Indianapolis, Indiana Area

- Lead a cross functional team to implement three different brand CRM solutions and patient support strategies including design decision support, solution identification, requirements gathering, capabilities roadmap, and the implementation plan against the disparate release cycles.- Cross-functional partnership with Legal, Compliance, IT Groups, Senior Management, and Brand stakeholders to collect business requirements and direct the build of a compliant, efficient, agile, and scalable customer support solution.Key Areas of Engagement and Leadership:• Data and Analytics Architecture Support• Visualization and Reporting Consumption Development and Architecture• Strategy Setting and Implementation• Team Building• Change Management• CRM Solutions Development –agile development of a Salesforce CRM platform

Indianapolis, Indiana Area

- Warehouse Architecture and development - Application to end business consumer data management, structure, flow, and reporting solutions - Data and Technology Solutions Architect and Lead- End-to-end Reporting Process SOP creation and maintenance- Data Governance - Data Quality Analysis and Automation- Requirement Gathering- SQL Development- Tableau Development- Tableau Server Maintenance- Agile development using Salesforce - Salesforce reporting- Self Service Reporting architecture and development- Data Refresh Automation

Indianapolis, Indiana Area

I provide tutoring to graduate level students in Accounting, Finance, Microeconomics, and Macroeconomics during the evenings and weekends.

Business Intelligence Consulting - Tableau Server and Desktop Development and Maintenance - SSAS (Tabular and Multidimensional) - Visualizations - Tableau as a specialty, SSRS and PowerBI experience - SSIS - ETL creation and troubleshooting - Alteryx Solutions - Architecture - Warehouse and data mart builds and guidance - Custom solutions end-to-end, specializing in the Tableau platform - SQL development

- Lead and develop an outstanding team of 16 Business Intelligence consultants - Project scoping - Resource Planning- Client Management

Indianapolis, Indiana Area

Support the development and implementation of a new Global Software Asset Management (SAM) service.Analyze software usage, spend, and control data to find opportunities for efficiency and savingsDevelop tools, dashboards, and BI assets to assist in decision making and guide process improvement effortsDesign and implement processes to support robust license and contract managementDevelop and implement a database and Business Intelligence platform for reporting and decision support using SQL Server and TableauForm and foster relationships with software publishers, management and key client contacts to help clients achieve maximum value from each existing, and potential, publisher.Key Achievements:o Targeted cost savings achieved within 6 months. Achieved approximately 186% of stated goal by contract end, equating to over $1.4 million in total cost avoidance and savingso Integral in achieving contract extension for another year and developing the packaged BI solution for future SAM clients

Carmel, Indiana

Developed SQL queries, views and stored procedures to retrieve data from a 10 terabyte, multiple server and database system using fact and dimension tables on a designated BI server. Wrote SQL queries against the BI database for focused and efficient queries to support BI tool data integration.Import results into Tableau or Excel for analysis with a focus on forecasting, variance, trend and exploratoryCreate content for industry leading, proprietary web based BI tool – monitoring the entire revenue cycle and alerting when critical aspects begin to deviate from statistical expectationsCreated an inbound call model for three call centers that estimates call volume within 5% accuracy and is used for staffing decisions to achieve modeled hold times.Develop ad hoc T-SQL queries for internal and external client requestLead analyst for reporting and analysis on new process and product development or enhancementsDirect reporting and interaction with executive management and clients

Indianapolis, Indiana Area

Modeled potential acquisitions using market data, financial models, and sensitivity analysisPrepared budgets and projections for managed assets, performing quarterly and annual actual-to-budget variance analysisLead analyst of due diligence team for both the acquisition and disposition process - $60 million in refinances and $95 million in dispositions completed

Research and model high yield corporate debt and private placementsValue investments of distressed firms to find opportunities throughout corporate structureSpecial techniques used to estimate bankruptcy recoveriesUnderwrite commercial property loans up to $50mmCollect, analyze, and present High Yield market metrics to the VP of Distressed Securities. Assisted in CRE portfolio sales totaling approximately $150mm

Analyzed and maintained leases for 10 properties. Processed all lease changes as Simon, or tenants, exercised covenants or options. Processed all RET and CAM billings for each property, passing through costs to tenants according to lease language.

Managed the cash reconciliation, movement, and investing of up to 150 mall accounts.Participated in a select group of analysts to integrate acquisitionsCreated and maintained spreadsheets for daily, weekly, and monthly reporting and analysis on an insurance fund which was invested in fixed income securities amounting to over $250 million. Presented summary reporting presented to the CFO monthly.

Assisted clients in analyzing market conditions, technical charts, and placing trades on: stocks, ETFs, mutual funds, fixed income, and derivative investments.

Managed up to 5 managers and over 40 associatesAnalyzed the profit and loss statements to improve store operations, budgeting, and forecasting.Brought store to third in the nation in sales growth during the third year open. Increased sales from weekly averages of approximately $18,000 to average weekly sales of $40,000.Selected by President of franchise to travel, analyze, and implement value adding initiatives for underperforming stores in the Franchise

Executive Education - Data Analytics Bootcamp, Data Analysis, Data Engineering, And Visualization

Curriculum/Skills Learned: VBA, Python, NumPy, Pandas, Matplotlib, API Interactions, MySQL, MongoDB, ETL, HTML, CSS, Bootstrap.

Mba, Finance

Activities and Societies: Beta Gamma Sigma Member, ACG Cup Competition, FIND EnterpriseEmphasis in Investment Management, Private Equity.

B.A. Degree, Business Management

Chemistry/Chemical Engineering

115 credit hours completed