Jerry Yang Email & Phone Number

Greater Atlanta Area

-Generated 4K+ incremental sales annually for Nissan/Infiniti USA across various campaigns.-Developed executive dashboards and quarterly business reviews with insights into their Off-Lease, Open-Lease, Open-Retail, and Non-Captive customers.-Provided leadership and direction in all phases of the annual budget development, securing $11 million in funding for FY18 OCP, tactical, and multi-tier campaigns.-Created direct mail and email strategy proposals for Nissan/Infiniti CRM to target new segments and increase repurchase rates.-Used TSQL variables and executions extensively to automate 50+ query generating processes.

Atlanta, Ga

-Utilized Tableau and PowerBI to build 20+ dashboards that include: Tactical Campaign Sales Match, Model Demographic Profiles, Dealer Heat Maps, Hand Raisers/Leads/Reservationists rates, etc.-Wrote over 100+ queries in SQL, Base SAS, and SAS Enterprise Guide to pull and generate data to feed into Tableau.-Data Mining – analyzed purchase patterns to identitfy incremental revenue opportunities.-Identified data integrity issues with Business Objects in order to explain discrepancy between reports housed on different servers.-Partnered with the modeling team to develop and analyze a new In-Market-Timing model for Nissan/Infiniti USA.

Atlanta, Ga

-Wrote over 100+ queries and store procedures in SQL to pull HD.com gross demand and net sales for various channels/modes.-Helped analyze and explain declines, cancels, and returns for HD.com's 4.5 billion dollar business.-Created various queries and volatile tables in Teradata for analysis and also exporting into Tableau using the custom query capability.-Built 20+ Tableau reports that include: HD.com in-store/online returns, major appliance decline rate, .com customer growth by region, average number of .com orders per store by region, customer satisfaction, etc.-Automated many process using SQL job's to update sql tables, Teradata tables, and Tableau reports.-Identified system issues with epiphany, web sphere commerce, jda oms, etc. in order to explain gross to net variation.

Atlanta, Ga

- Ensured that THD’s supply chain is secured by having factories conduct a security audit, sealing containers with ISO 17712 high security seals, and upon arrival at THD’s SDC.- Managed an oversea team of 7 in order to conduct on-site security audits and making sure all 1,197 active THD factories are C-TPAT compliant.- Implemented multiple queries to pull data such as factory on-boarding due date, factory supplier relationship, and master C-TPAT re-audit list using MS SQL Server.- Worked with Teradata to extract container seal information from the SDC’s to ensure seal compliance.- Retired Home Depot’s old Pre-Qualification On-Boarding System to the new FlexPLM system.- Worked extensively with THD Global Operation Manager’s to ensure that their products are transported safely and in a timely manner.- Implemented an Audit On-Time Delivery KPI that tracks the percentage of audits being completed within a 10 business day period.

Nashville, Tn

-Worked extensively with MS SQL Server and JMP to gather and analyze defects, hours, and number of work items in order to improve quality, throughput, estimation accuracy, and productivity.-Wrote SSRS reports to capture lead time, delivery time, and cycle time out of Team Foundation Server.-Assisted in identifying KPI applications, such as availability and financial accountability to back office teams in order to help identify areas for improvement.-Built and maintained a balanced scorecard in order to provide high visibility to IT executives on focus areas, such as retention rate, availability of back office applications, project spend over budget, top ten strategic labor spend, and estimation accuracy-Initiated a new automated system of collecting data from multiple sources using InfoPath and SharePoint.