Responsible for ELT, guiding azure data platform design and standards, data analysis, validation, and reporting.• Nominated for an award for identifying issues that were over-stating costs and miss-categorizing revenue.• Collaboratively designed metadata-driven, dynamic, ELT using Azure Synapse (combines Azure Data Factory, Databricks Notebooks, and Azure SQL DW), strategically using Spark and Polybase for performance.• Provided triage and DBA production support for critical databases (Azure SQL DB, Synapse, and PostgreSQL).• Agile Scrum development team used Jira and Azure DevOps (ADO) to plan sprints, track tasks, source control code, submit and approve PR’s and deploy DB releases.• Surfaced valuable data about external systems modifying our production system by efficiently parsing out multiple complex JSON files stored in a PostgreSQL DB.• Designed and created customer-facing Power BI Embedded report with Row Level Security (RLS).• Created the standard for Power BI workspace creation, source control, management, and security.• Developed new revenue and cost tables for the DW to provide a single source of truth for financial reporting.• Mentored many colleagues on data and reporting best practices, performance tuning, and tools.• Worked with business stakeholders to define multiple terms and categories and then implemented cleansed categories in the DW that enabled consistent and efficient reporting.• Improved IPO readiness by performing system and data analysis that identified data gaps, bugs, and enhancements needed to facilitate better reporting and audits. • Implemented Azure Alerts using Azure Monitor, Azure Log Analytics, and Slack.• Spearheaded Data Governance and initiated the creation of the Data Governance committee.

Responsible for ETL, guiding azure data platform design and standards, data analysis, validation, and reporting.• Saved over $60,000 per year by right sizing and deleting unused resources in one Azure subscription.• Automated online banking conversion data validation allowing for entire population to be verified. This required data from 4 systems and 2 additional data sets to be integrated, compared, and reported on.• Created dynamic Azure Data Factory linked services using parameterized Azure Key Vault secret names.• Created dynamic, reusable Azure Data Factory pipelines using parameterized database and table names.• Designed and implemented an Azure Active Directory security strategy and request process.• Provisioned and configured Azure resources.• Agile development team used a mix of Kanban and Scrum to plan and track tasks.• Administered, maintained, monitored, and performance tuned data processes and resources in Azure.• Developed Power BI reports with Databricks as a source, using Hive over a parquet-formatted Delta Lake.• Mentored data engineers by providing technical guidance, training, and encouragement. • Identified multiple system integration and data integrity issues and collaborated with partners to remediate.

Responsible for creating SSRS reports, data analysis, requirements gathering, and SSRS server config guidance.

Responsible for ETL, integration, data analysis, database design, reporting, and client optimization presentations. • Wrote numerous programs to pull data from third party API’s, then parse, transform, and load the data.• Designed custom, dynamic, client-facing data visualization using GIMP (open source photoshop) and Excel.• Provided performance tuning for long running processes and efficient table designs for large tables.• Configured Redshift Workload Management to allow analytical and ETL processes to run concurrently.• Created analytical processes and visualizations to identify and visualize cloud optimization opportunities.• Part of an agile development team that used Scrum or Kanban methodologies to plan tasks.

Responsible for ETL, integration, data analysis, database design, reporting, and database administration. • Cut hours off post-conversion/upgrade downtime by creating variance reports and automation. • Performed extensive data analysis and quickly learned data models for numerous mergers and conversions.• Designed and created a dynamic and reusable ETL process that saved significant development time and maintenance for mergers, conversions, and daily integration.• Designed dimensional models and created reports for measuring and paying out incentives.• Spearheaded an effort to create a team Wiki that has become the team’s knowledge base.• Branded SQL Server Reporting Services 2016 server.

Responsible for SQL Server database administration and performance, systems analysis, data warehouse design, ETL processes, scheduled database jobs, reporting, and leading my teammates by implementing best practices for programming and documentation, and prioritizing tasks.• Reduced labor spent on data warehouse maintenance from 75% to 10%, and increased data integrity and availability by designing a process that sends an email when a job step fails, and by improving job logic. • Improved SFTP functionality by converting jobs to use WinSCP C# classes instead of the GUI.• Parsed merger files delimited with extended ascii characters that are "invisible" to parsing functions in C#.• Lead the data merger team to a successful data merger in 10 weeks from start to finish.

Responsible for creating SSRS reports, SSIS packages, performing systems analysis, and documentation.• Improved database performance significantly by applying indexes to critical tables; reduction in single-query time was as high as 10 hours in one report.• Considerably reduced the number of daily ETL processes by working with stakeholders to prove that system generated “green bar” reports tied out to DW data, which allowed us to stop loading the redundant text files. • Designed, documented, and implemented a policy and SOP for documenting business intelligence reports.

Responsible for analyzing marketing strategies, systems, and processes and making recommendations for improvement.• Design and create SSIS packages that import, export, and process analytical data from various sources.• Write custom T-SQL queries to report on and analyze the performance of marketing campaigns.• Provide executive-level reporting with insights and recommendations for each campaign.

Responsible for inventory forecasting for 400 stores, and maintaining the systems used to manage them.• Performed system and database administration for the Inventory Planning and Merchandising departments• Provided guidance and training to the Allocation team in best practices for analysis and programming• Developed daily ETL processes using SQL Server DTS packages, and maintained Stored Procedures• Designed, created, and published company-wide reports to track trends, and identify opportunities and risk• Partnered with cross-functional teams to create an application that automated Outlet inventory allocation

Responsible for maximizing store sales, turnover, and margins by developing allocation plans and strategies; maintaining stock levels in all stores appropriate to seasonal set up needs, sales trends, and capacity.• Identified and corrected a logical system issue that caused inventory in the lowest-volume sizes to be over-bought saving the company over $2 million dollars annually. • Created Excel models that enabled the Allocation team to quickly perform complex analysis resulting in significant time savings for the department.• Wrote and used T-SQL queries to extract analytical data from multiple servers and databases.• Automated many processes using VBA and SQL programming

Responsible for preparing and reconciling Seconds Valuation; monitoring “in-transit” inventory; processing stock adjustment and transfer error corrections and monitoring stock adjustments. • Created numerous Visual Basic for Applications (VBA) programs to automate daily tasks in SAP, Remedy, Excel, Outlook, and Internet Explorer resulting in significant time savings for eight departments.• Designed and executed tests used for Change Control documentation.• Created and ran test plans in Quality Center for annual SAP Support Stacks projects (upgrades).• Tested system changes in the Sandbox, Development, Quality Assurance, and Production SAP environments• Process owner for the Free Goods/ Open Accounts portion of the SAP system implementation project.• Wrote Business Process Requirements and Design Documents (BPRDDs) for SAP system implementation.• Created an Internal-Audit approved process that allowed our department to go paperless.

Responsible for coordination and maintenance of the sample library used by the Product Specialists and Trainers. • Improved processes resulting in a $28,000 annual revenue increase in the Employee Sample Sale Events

Responsible for creating and updating Technical specifications and assisted in production approval of garments.