Alex Aldana Email & Phone Number

Lathrop, Ca, Us

Tracy, California, United States

• Built from scratch a multi-dimensional Snowflake schema data-warehouse for Supply Chain Operations using MicroStrategy Architect.• Integrated multiple Supply Chain transactional systems using Microsoft Integration Services (SSIS) to load and transform data in various formats including NOSQL (Couchbase), JSON, XML, Flat Files and Linked Server Connections.

Tracy, California

• Built and led a high performance cross-functional team of analyst, data architect and full-stack web applications engineer and developed a next generation Supply Chain Business Intelligence and Analytics platform(Microsoft SQL, Postgres, SQL Server Integration Services, Tableau, C#) transforming supply chain into a data-driven organization. • Developed a clear career path for all direct reports and inspired a culture that recognizes employees and supported them in attaining their career goals. • Collaborated with different Senior Leaders in Home Delivery, Distribution Centers, Care Centers and Finance to define and create business KPIs and executive dashboards. • Provided operational reporting to all 68 Home Delivery Centers, 2 Distribution Centers and 3 Care Centers. • Partnered with C-level executives and Senior Vice Presidents to spearhead an initiative to decrease delivery cycle times and reduce deferred revenue from $85M to $70M, in order to meet Q1’2018 EPS targets. • Led and built the “RH Text Alerts” platform enabling Clients to receive order updates, shipment and delivery notices via text messaging. • Created a life time value Client risk assessment model using Tableau to mashup data from our Salesforce CRM with multiple disparate data sources, enabling RH to proactively monitor high value orders and reduce returns and exchanges.

Tracy, California

• Developed and led a Business Intelligence Team with expertise in finance, data warehousing, applications development, data visualization and reporting. • Developed an employee key performance data warehouse integrating over 20 disparate data sources to enable rigorous data-driven decision making by operations leadership (Microsoft Online Analytical Processing Engine, Reporting Services, VBA) • Designed, developed and maintained 60+ productivity, performance, and trending reports including executive style dashboards giving Senior Leadership a big picture of the business, and team performance

Tracy, California

• Planned and Optimized third party workload allocations, in order to maximize service level goals, while, reducing vendor related overhead cost. • Analyzed and forecasted volumes for phone and non-phone channels; determine key impacting trends and evaluated variances to develop plans for handling change effectively. • Created reports using tools such as MS SQL Server and Reporting Services.

Tracy, California

• Designed reports using advanced features in MS Excel and Access such as pivot tables look up reference functions and macros. • Analyzed statistical data regarding the overall operations of the call center: completed reports summarizing activities, trends, and root cause analysis, measured staff performance, recommended improvements, and introduced new methods to support standards. • Provided operations leadership with reports and performance metrics to improve employee performance and customer service.

Stockton, California, United States