Dan Roe Email & Phone Number

• Complete cPanel website administration.
• Utilized phpMyAdmin to execute SQL scripts in MariaDB for bulk load of SKU based pricing updates.
• Implemented JavaScript modification of website link function.
• Addressed website HTML and provided solutions based on meeting discussions.
• API implementation and support.
• JSON data ingestion from file source and API endpoints.

Jersey City, NJ, US

• Created and unit tested SSIS ETL packages for sequenced execution of T-SQL stored procedures and file generation.
• Defined, created, and managed Domo Workbench processes along with supporting all web visualizations as SME.
• Generated datasets within cloud data warehouse for joining to other sources and analytics ETL pipeline orchestration.
• Determined root cause and provided solutions for stored procedure result concerns based on Jira ticket description.
• Organized daily standup project status calls as needed.
• On a frequent basis, tuned stored procedure performance to lower processing times by 25% and reduce server load.

Indianapolis, Indiana, US

• Developed and deployed various SAP ASE (Sybase) T-SQL DML/DDL scripts and procedures for client plan implementations.
• Modified/enhanced stored procedures in accordance with client requirements.
• Analyzed batch status reports to determine success of data loads.
• Developed custom stored procedures to capture invalid specialty code summary.
• Investigated extract result inquiries via procedure code review.
• Created custom SQL queries based on client needs.

North Chicago, IL, US

• Enhanced Microsoft Access Database interface to enable entry of additional student training rotations.
• Created new database functionality to increase staff productivity via form controls.
• Added sophistication to preexisting reports for displaying newly recorded data.
• Conducted meetings with Clinical Coordinators to devise application specifications.
• Modified preexisting VBA code as a preferred alternative solution to a complete rebuild.

Port Washington, NY, US

• Designed and executed ETL dataflow modules via Alteryx in order to perform statistical analysis of large data sets.
• Assessed certain data validation QC processes in place and revamped the perspective in order to achieve a clearer picture of the data state and assure confidence in the communications provided thereafter.
• Developed and supported Microsoft Access applications to aid analysts in the chain menu survey integration process, improving efficiency and reducing processing time by 75%.
• Supported extensive data migration project by reconciliation of field definitions within new system architecture.
• Documented monthly data processing procedures performed using proprietary tools.
• Managed overlapping processes in order to deliver scheduled data on time.

Chicago, Illinois, US

• Created a multitude of data processing applications via MS Access, MS Excel, Oracle, and Visual Basic to streamline Restaurant Technology Deployment data tracking requirements.
• Maintained the relational integrity of various data source updates, provided via supplier data feeds, internal data repositories, and automated data processes.
• Served as the central contact for troubleshooting most reporting inquiries and discrepancies within the department.
• Developed complex automated event structures made up of Select, Delete, Make Table, Update, Crosstab, and SQL Union queries.
• Facilitated query functionality enhancements on a recurring basis, in order to support evolving business tracking requirements.
• Partnered with IT department to implement business requirements of Oracle based web application.

• Facilitated high volume ad hoc service reporting on rigorous schedules and varying frequencies to meet customer requirements.
• Streamlined frequent report generation process to increase distribution capacity.
• Maintained and monitored high level shipping performance summary workbooks and provided insight on changing trends for Market Facing team.
• Developed and supported multiple customized CRM applications, enabling customer service department to manage customer complaints, claims, and shipping delays.
• Performed raw data analysis via SQL queries to troubleshoot and determine root cause of possible performance issues.
• Mentored new team members to assist with scheduled reporting tasks and necessary analytical functions.