I am experienced data professional with over a decade of experience developing data platforms and data teams for Fortune 500 companies.
• Work closely with large enterprise customers in the US to design solutions utilizing Azure data services
• Implement PoC's for customers to rapidly realize value of implementing cloud services
• Form and develop strategies with customer executives on how to improve their data teams and align solutions to their business’s goals.
• Develop demo solutions and utilize tools such as Synapse, Databricks, Data Factory, AI/ML services, and many Azure native services to showcase features and functionality
• Train and develop customer teams on how to utilize services
• Track and manage milestones and opportunities of customers for tracking overall Azure spend to ensure sufficient return on investment
• Perform as the lead technical point of contact for sales teams to help bring answers to customers with complex technical problems quickly.
• Create detailed architecture diagrams for specific use cases and present them to many different business and IT stakeholders.
• Build, lead, and guide multiple teams of data engineers and data architects to deliver new data pipelines, data marts, and reporting functionality
• Develop data strategies for the organization to achieve low latency reporting and move the organization to a “stream first” data principle to allow for more data availability.
• Aid in organizing the data analytics team budget and providing guidance on needed projects for the upcoming year
• Work closely with senior IT leadership to guide new greenfield architecture into GCP to ensure we can utilize full capabilities of the cloud platform.
• Lead the IT organization with the adoption of Google Cloud and partner with Google to implement new streaming data for more rapid decision making.
• Architected a new data platform for managing transactions from stores and digital sales with high velocity streaming and consuming 30m+ rows of data per day
• Work with multiple IT leaders on a daily basis to remove blockers and continue to allow teams to move forward on project progress.
• Create strategy for strategy and management of single view of customer leading to the development of a customer data platform
• Manage work associated with customer loyalty data including architecture and performance
• Created and utilized a selection system for identifying new vendors and tools used across IT
• Developed the architecture review board system that brought together senior leadership with technical subject matter experts to drive standards and principals
• Led the evaluation and selection of the organization’s next ERP system involving multiple leaders from multiple departments in the evaluation process
• Developed digital strategy for better customer engagement and acquired project buy in for executive and board leadership.
• Led the development team responsible for implementing customer data platform as part of digital strategy
• Implemented technology focused on an omnichannel engagement strategy for customers which led to data enrichment of the single view of customer
• Present new technologies to executives to show case potential use cases and ROI’s
• Create detailed team roadmaps for setting development expectations and improving communications with senior leadership
• Manage and implement a new customer data platform to be used for multiple digital channels including pump, mobile, and web.
• Provide guidance as data subject matter expert on multiple projects throughout IT
• Create ETL’s to pull data from multiple locations and data sources including Teradata, SQL Server, Hadoop, and API Calls
• Lead Analytics and Data mining efforts on new projects to drive value from large data sets
• Perform trending and predictive modeling on data sets using R and Python to show new insights to business
• Write extensive queries in Teradata and SQL Server to populate data models.
• Meet with business units regularly to help address issues that their business unit is facing
• Create Dashboards using Power BI to display graphical representation of trending and forecasting data
• Create SSRS reports to show block list style data for more intensive reporting needs of the business
• Designed machine learning models to adjust percentage of bib syrup usage based off pump exhausts to accurately show total remaining volume in containers.
• Acted as project manager and business analyst for emerging technologies team while also performing as data analyst for the team and relating sensor data to transaction data
• Assisted in performing a full industry analysis in comparison to internal operations and highlighting points of interest for executives.
• Developed and maintained hundreds of SSRS reports which contained highly scrutinized data.
• Developed ETL jobs using SSIS, SQL Agent, and Tidal to move data from government files to a data warehouse
• Developed data warehouse dimensions to satisfy customer needs and provide aggregated reports at a much faster speed.
• Worked directly with the business users to produce requirements for visualized data needs.
• Led the push for SSRS 2016 upgrade and spear-headed the organization and shift over to the new environment from 2012.
• Navigated approval for moving PHI data to the cloud for use on PowerBI by working heavily with IT Security team.
• Developed the organizational structure for PowerBI and assisted with creating the developer and user standards for creating dashboards.
• Trained end users on how to fully utilize PowerBI as well as trained business users on how to use Power Query.
• Administrate SQL Server instances that house dozens of databases containing large sums of data.
• Perform vigorous security checks and ensure security compliance takes top priority.
• Generate T-SQL Stored Procedures for various tasks, reports, and other business needs.
• Perform various support needs for the SQL Server instances when needed including index optimization, transaction locking investigations, memory tuning, Parallelism tuning, and general performance investigation.
• Create SQL Server Agent Jobs and SSIS packages to perform various duties.
• Assist with querying Teradata ad-hoc.
• Perform in depth data investigations to resolve data discrepancies
• Develop various multi-tiered SSRS reports
• Create Ad-hoc MDX queries against SSAS cube
• Support and Develop on high transaction Always On SQL Server database clusters to maintain high availability with instantaneous failovers.
• Supported highly sensitive data environment and remained fully PCI compliant.
• Lead all new IT initiatives with the company
• Primary administrator of the ERP system CSB
• Construct complex analytics for the management team to make decisions via MSSQL and MySQL
• Perform all primary server maintenance via VMware as well as maintain host servers
• Develop SSRS reports and deployed on reporting website for easier access to information
• Develop data integration ETL’s between two core business systems via MSSQL ETLs
• Optimize SQL performance for ERP services and manage all MSSQL Agent Jobs.
• Create SQL MDX queries for cube structure reporting
• Create SQL stored procedures for various purposes – primarily reporting
• Generate SSRS reports for every function of the business
• Assist in creating ETL’s to improve efficiency
• Work closely with Accounting and Finance to deliver business needs for both SSRS and ETL’s
• Worked with Senior Developers on moving data from two to three dimensions
• Assist with maintaining a Report Server with 500+ reports located on it.
Apart from working with Data for enterprises I love spending time with my wife and children, working on home improvement projects, and exploring new technologies that are released.