Duel Farris Email & Phone Number

Austin, Texas, United States

• Successfully created a data warehouse from 5 different ERP systems, utilizing Microsoft SQL Server and SSIS to extract, transform, and load data from various sources into a single, centralized repository.• Developed and maintained ETL processes using SSIS to support the data requirements of the business, ensuring that data was accurate, complete, and timely.• Built Power BI Dashboards to provide executives with real-time insights and analysis, enabling them to make informed business decisions quicker.• Created self-service data cubes utilizing SSAS in a multi-dimensional model, providing users with the ability to access and analyze data independently, reducing the dependency on IT.• Performed DBA tasks such as server maintenance, creating indexes and index tuning, and query optimizations to ensure that the data warehouse and business intelligence systems were performing optimally and efficiently.• Collaborated extensively with cross-functional teams across various departments within the company, including Supply Chain, Demand Planning, Inventory Planning, Sales, and Purchasing, to seamlessly gather and translate requirements into robust, results-driven projects. This involved creating well-defined objectives, setting clear milestones, and establishing key performance indicators (KPIs) to drive project success.

• Designed and developed a forms and workflow process for the product development team to send product designs to external factories for quoting using K2 Blackpearl's low code design environment.• Developed a database schema to support all the data fields required for the product development team to execute the quoting process from the external suppliers.• Created reports that displayed the success rates of approved quotes, which enabled the product development team to make informed decisions about moving forward with the product.• Collaborated with the product development team, external factories, and other stakeholders to ensure timely delivery of quotes and product designs.• Conducted testing and quality assurance activities to ensure that the forms and workflow process was fully functional and met the needs of the product development team.

• Designed and implemented a proprietary reporting system that streamlined the vendor audit process for Walmart stores, resulting in improved accuracy and efficiency in tracking inventory issues and sales.• Developed a RetailLink import process that collected critical data from Walmart's retail management system, enabling our reps to audit vendor items per store.• Created the SmartCom system, an innovative geo-fencing technology that alerted field reps via email to inventory issues and vendor inquiries as soon as they entered a store's designated area.• Collaborated with cross-functional teams to ensure successful implementation of new reporting and data integration processes and provided ongoing support and training to the SmartCom team to ensure maximum productivity and efficiency.• Collaborated with cross-functional teams to understand their reporting requirements and provided solutions to meet their needs.• Monitored and maintained the reporting and import process, ensuring timely and accurate data delivery.• Provided regular updates to management on the performance of the reporting and import process and recommended improvements to optimize efficiency and accuracy.

Bs, Computer Systems Engineering

High School