Derek Capps Email & Phone Number

Litchfield Park, Az, Us

Davie, Fl, Us

• Spearheaded the establishment of Bayside’s new data platform, transitioning from manual reporting to a robust system utilizing Hex for data visualization.• Collaborated with engineering teams to design data flow to a Snowflake database, consolidating datasets for improved accessibility.• Developed a machine learning and AI strategy to automate scorecard evaluations, increasing review capacity significantly.

Cheyenne, Wy, Us

· Managed a team of dedicated full-time and contracted data engineers, overseeing their efforts to ensure the successful execution of projects· Create, maintain, and enhance training and development material to support ongoing learning initiatives for data engineers· Developed compelling project demonstrations and crafted persuasive proposals to secure new client engagements· Conducted systematic troubleshooting and resolution of issues within ADF pipelines, proactively identifying and resolving failures through daily pipeline reviews. Documented failure instances and resolutions, contributing insights for potential bug fixes· Facilitated effective communication between business end-users and engineering teams, addressing inquiries and ensuring seamless integration of end-user requirements into both new and existing pipelines and workstreams

Seattle, Washington, Us

· Develop new features and enhance existing data pipelines by working with product owners to identify opportunities for improvement and solve for existing needs· Create architectural solutions for business cases including new pipeline ingestions, migration, and business as usual needs· Primary responsibilities included review of user stories to create new data flows and update existing ones, create technical documentation to lead engineers through new processes· Troubleshoot and resolves issues on ADF pipelines to locate and resolve failures by reviewing pipelines daily, documenting failures and resolutions, and reviewing for possible bug fixes· Liaise between the business end users and engineers to answer questions and ensure the end user requirements are included in new and existing pipelines and work streams· Utilize CI/CD and git to ensure proper mapping of code changes and catalogue of enhancements by checking code into DevOps · Technologies and areas of Focus: Azure Data Factory, ADLS, Azure DevOps, Data Flows, Databricks, Hyperscale, Scala, Python, Scope, Cosmos, Product Owner, Database Migrations

Las Vegas, Nevada, Us

· Develop new features and enhance existing data pipelines by working with product owners to identify opportunities for improvement and solve for existing needs· Identify opportunities to enhance, streamline, improve codebase and work with MGM Dev leads to make that happen· Collaborate and contribute to solution design and technical design for new features· Support data pipeline workload in the Production environment, monitor job execution, triage and troubleshoot job failures and other issues· Make code changes to fix production failures and deploy code in production, maintain code in Git for CI/CD and version control· Monitor infrastructure proactively and identify opportunities to improve operational efficiency, job execution performance and overall cost

Irvine, Ca, Us

· Migrate data from on premise Oracle database to Azure ADLS data lake · Analysis of source information and client needs to determine orchestration and design of pipelines· Determine Sources for data needs and feed into raw data layers for use and storage· Create Azure Data Factory Pipelines to Orchestrate the flow of data for clients on premise Oracle Database to move into the cloud· Create databricks notebooks to facilitate data transformation for ETL process· Create container library in CosmosDB to organize and store curated data for use in web API· Use of CI/CD pipelines for releases and version control· Use of staging in ADLS zones to move and store data· Use of Visual Studio to create SSIS packages to migrate data from on premise database to cloud· Create view inside of Microsoft Dynamics to compare and validate data

Mississauga, Ontario, Ca

· Build Data Warehouse from ground up to support internal needs. Using Azure PostgreSQL create a database to house information to feed into customer facing webpages and analytical tools · Using Azure Date Factory, automate data through APIs and connections from internal resources to move data both internally and externally · Consult with internal end users and Salesforce consultants to create the business cases needed to begin the process of onboarding the Salesforce product· Create a resource using FastFields for CSM’s to use while in the field to capture customer engagements to report on various data points with a report to capture meaningful results· Capture date points from the CSM’s customer interactions to aggregate them into a form that will provide meaning information and create methods to automate the process· Work with marketing and finance departments to create ways of report automation with database· Store form requests from website in database to capture transfer requests and marketing opt-ins to ensure all HIPPA requirements are met

Phoenix, Az, Us

· Improve, maintain and control the AWS EDW through use of the S3 buckets, lambda system – both the JavaScript and event triggered lambdas, and through CloudWatch event tracking. Bring over complex functions to the Elastic Beanstalk in order to more efficiently and effectively trigger events and data base uploads.· Oversee the Redshift SQL access points and ensure version control of the table schemas. Create automation scripts to provide immediate access to various departments. Debug and enhance schemas to ensure more expedient results to monthly reporting and ODBC connection points· Connect Salesforce to the EDW through the use of the Azura Data Factory by use of Pipelines and Data Lakes. Trigger events into AWS S3 Buckets and into Redshift through Lambdas so information is instantly available. Use of Data Loader and Object API’s for data extraction SQL, schemas, and validation· Onboard new software Looker. Connect to EDW and work with Looker dev team to ensure proof of concept reporting is accurate. Cascade out to pertinent teams and rollout useful dashboards to ensure business need for relevant stakeholders · Work with Salesforce System Admin to create a Kanban Case tracking system. This is broken up by stakeholder and development time. The projects are given a time estimation. Projects are then moved by delivery window and can be tracked by actual time spent allowing stakeholders to see how much time is left on their project and reporting to be generated on how much time is left on a project, how many hours are in the backlog, and how long a project takes versus how much was estimated· Create a possible POC solution in partnership with the CS team and the Salesforce System Admin. Create task management solutions to better control time tables and follow ups with clients and publishers. On board Pardot page builder solution to completely control the POC system from inception to launch with the Salesforce platform.

Oak Brook, Illinois, Us

· Oversee implementation and integration of Tethr cloud application to the customer support center. Plan the training and development of users, admins, and SME’s across multiple departments and teams· Hire, onboard, and manage a team to effectively upload, track, and maintain the parts database· Automate reporting for return reviews, CSAT, call center, and KPIs to ensure timely delivery of metrics· Create dashboards to monitor KPIs on a variety of platforms such as Salesforce, SAP BW, and Lumira· Analyze return metrics to find opportunities to improve call center operations by providing better feedback and support to customers in order to reduce the need for returns, determine what vendors are abusing the return policies· Create and maintain Salesforce reporting and dashboard create to track product capture rates to meet the ongoing objective to more accurately review customer experience · Create and maintain product scorecards focusing on call center reason, model, return reason, return rate allowing department heads to more accurately track KPI’s and determine goals· Automate and streamline the process to more accurately complete parts price books · Collaborate with internal teams in Chicago corporate office and Mexico manufacturing plant

New York, Ny, Us

Global Business Travel | Cisco Finesse Telephony Migration· AMEX GBT migrate telephony contact center platform from Avaya to Cisco across the globe· Worked as a User Acceptance Test Analyst and was responsible for end to end IVR call flows, testing Speech and DTMF grammar for the IVR nodes, testing integration of IVR application with NICE and IEX Scheduler, monitor real-time and historical reports in eGain Analytics· Verifying CTI/Automatic Call routing to ensure calls are routing to correct skill setMerchant Interactive | Cloud Migration· Agile Project Management coordinated in Rally through use of Kanban system and User Stores· Automated regression testing using Eclipse Selenium tools to run application test scenarios comparing current environment against new PAAS cloud environment· Jmeter and Load Runner utilized for load testing to ensure adequate server response and outside connectivity is responsive through server request calls· Perform automated regression testing utilized selenium in an Eclipse environment from test cases generated from application SME to ensure comparable performance of new cloud applications to existing

Schlieren, Zurich, Ch

· Create the algorithms and tracking system do effectively relocate goods from an obsolete warehouse· Demand planning logistics including product analytics, CRM reporting, and transportation optimization· Use of a variety of Demand Planning and Analytics tools such as John Galt Atlas and SAP BW and ECC· Assist in company-wide supply chain management optimization projects; lean management initiatives

· Responsible for a team of up to 30 including sales staff, team leads, managers, and operational staff· Through analytics, historical data, and team development, increased sales from $1.6 million annually to nearly $2.5 million while decreasing cost of goods averages from 30% - 25%· Streamline a pricing strategy that maximizes on what customers will pay for a product based on historical data, while negotiating better vendor pricing to increase margins· Create a call center to provide support to the retail store that managed daily tasks of incoming calls, appointment setting, sales objectives, and issue tracking

· Through Google AdWords and Google Analytics determine best ads and ad times in order to generate sales and reach target audience and meet sales goals and company objectives· Create copy for products, create listings for products, promote listings. Create instructions, advertisements, product packaging, and marketing materials

Plantation, Florida, Us

· Automate tasks including EDI uploads, Excel macros, and reporting· Determine which accounts to pursue based on client regulations, legal grounds, and data analytics · Allocate client budgets up to $500,000 per month to ensure the best return on their investments