Azure Cloud Microsoft

Rick Norman LinkedIn Profile +1-539-***-**** *******@*****.*** Broken Arrow, Oklahoma 74012

Professional Summary

Accomplished technologist with extensive experience in advanced SQL/SAS development, SAS administration, ETL/ELT processes, data curation, data analysis, and Microsoft Azure cloud computing. Proven track record of solving complex challenges and providing support/advice to business teams regarding vast/evolving enterprise data. Expert in translating business needs into actionable code, aligning technological capabilities with strategic objectives, and continuously enhancing skills. Eager for new challenges, poised to make a transformative impact.

Notable Achievements

Developed code resulting in approximately $100 million in new revenue and savings.

Spearheaded projects that enhanced visibility into product, customer, and operations profitability.

Utilized advanced SAS Data Step techniques, including Hash Objects and fuzzy logic processing for enhanced transaction/basket analysis, intelligent de-duplication, and data cleansing/curation.

Pioneered simulation techniques to study concurrent usage of self-serve machine inventories at ~1,700 retail locations optimizing inventory to meet customer demand and reduce machine costs.

Proficient in SAS macro code development, parameterization, streamlining workflows, and enhancing productivity through dynamic execution of code driven by data and metadata.

Professional Experience

Software Engineer Advisor

FedEx Services, Broken Arrow, OK

July 2004 - November 2023

Innovation:

Developed PySpark code in Jupyter Notebooks to migrate curated transaction detail data sets from the SAS Business Intelligence Server to Parquet/Delta files in Microsoft Azure Cloud Data Lake.

Advised business users during the migration of existing SAS, Oracle, and Teradata queries/reports to Microsoft Azure Cloud, sourcing from new Synapse and Data Lake data sources.

Strategic Impact:

Created and maintained meticulously curated data sets from various platforms, including Oracle, Oracle Retail Cloud, Teradata, Teradata in Azure Cloud, SQL Server, ODBC sources, and Excel spreadsheets.

These data sets influenced operations, customer service, audits, tax, security/loss prevention, marketing, pricing, and profit enhancement initiatives trusted by dozens of business teams.

Revenue Growth:

Developed code for new pricing strategy models proposed by the Finance team, resulting in ~$42 million in new revenue (2023-2024).

Created a royalty compensation report for the Marketing team, focusing on Canva.Com originated orders within the FedEx Office network.

Supported the Sales Finance team in identifying revenue from Salesforce.Com customer bid orders managed by the FedEx Office National Bid Center.

Fraud Detection Solutions:

Collaborated with the Corporate Security/Loss Prevention team to develop proprietary fraud detection models using SAS Stored Processes, SAS Enterprise Guide, and SAS Add-In for Microsoft Office.

Resulting in average yearly recovery of ~$500 thousand bolstered defenses against fraudulent activities.

Labor Forecasting:

Assisted the Operations Planning team, using curated data sets and SAS Econometric Time Series software to forecast the budget required for retail print labor. across ~1,700 locations, saving ~$1 million per year.

Operational Efficiency:

Enhanced credit card pre-authorization policy changes, saving ~$1.2 million per year in write-offs by credit card companies due to lack of funds on some customer credit cards.

Profit Recovery:

Led the development and support of dormancy and reoccurrence reports of store value cards, resulting in recovery of over $40 million in escheat revenue profit over 15 years.

SAS Administration:

Maintained SLAs and administered the SAS Business Intelligence (BI) Server, SAS Cost and Profitability Management (CPM) Server, and SAS Activity Based Management (ABM) Server for over 15 years.

Automation:

Automated the daily upload of customer bid orders to InMoment.Com for Center/District Managers, representing a potential $1 million in incremental daily revenue.

Consultant

FedEx Office, Dallas, TX

February 2004 - July 2004

Optimization:

Enhanced efficiency of SAS reports, significantly benefiting thousands of SAP Business Objects users within the FedEx Office Data Warehouse.

Senior Application Developer

Duke Energy, Houston, TX

November 2002 - November 2003

Cost Savings:

Led the development of Mark-to-Market, Daily Value at Risk, and Stress Analysis Graph reports using SAS Risk Dimensions software, potentially resulting in savings of ~$700 thousand per year.

Skills

Data Collection Data Cleansing Data Wrangling Data Analysis Data Analytics Basket Analysis

Extract, Transform, Load (ETL) Advanced SAS Coding Advanced SQL Coding Ad-Hoc Development

Report Development Data Modeling Business Analysis Data Warehousing Team Collaboration

Production Support Technical Support Customer Service Troubleshooting Problem-Solving

Critical Thinking Optimization Adaptability Automation Simulation Innovation

Education

Bachelor of Science, Computer Science

Southwestern Oklahoma State University, Weatherford, OK

Awards

FedEx GEM (Going the Extra Mile), 1st Half Fiscal Year 2023

FedEx Office Finance Partner, 3rd Quarter Fiscal Year 2011

Contact this candidate