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.● SSIS ETL data processing followed by file generation and SFTP transmission.● Customized FormMail.pl script for new email account distribution.● Providing frequent progress updates to stakeholders.

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.● Redesigned SSIS ETL packages for transmittal of XML policy data to IVANS, reducing processing times by 50%.● Adhered to bi-weekly Agile sprint ticket ETA commitments.● Supported business on various SSRS report data inquiries.● Enhanced SSRS SQL queries and created reports from scratch.● Completed various AWS and Azure cloud computing courses.

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.● Served as Preauthorization Extract Guild Lead and SME.● Adopted Visual Studio SSIS ETL diagnosis (ICD) to procedure (CPT) code mapping processes.● Led and participated in daily Agile Scrum standup calls.● Executed (InRule Business Rule Management System configured) application feature test cases via SOAPUI.● Completed a multitude of SSIS, SSRS, SOAPUI/API, and RESTful API training lectures.● Configured over 30 ACOM EzConnect EDI, XML, and CSV extract maps utilizing C# to facilitate conditional results.● Produced documentation for EDI process and training on EDI X12 mapping file software and compliance.● Assisted in server migration project, including testing of data loads.● Documented process steps of various functions for new hires.● Trained and mentored new team members.● Produced custom MS Access Interface to track and record iterating projects hours worked.● Minimized stored procedure processing time by following code development best practices.

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.● Performed in depth regression testing prior to releasing monthly report viewers.

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.● Obtained data compliance from technology vendors per requirements defined. ● Provided accurate analysis of recorded data and inconsistencies backed by 10 years troubleshooting experience. ● Utilized SQL statements to seek out database object references and determine current relevance.● Implemented/Enhanced complex Excel formulas/calculations to achieve desired beneficial results.● Adopted ownership of VB intensive, macro driven workbooks to maintain current reporting structure.● Produced/Maintained a 75 page reporting process user’s manual, accounting for all actively administered reporting applications.● Transitioned report processing while mentoring expanded staff overseas, in order to take on new reporting developments.● Provided query logic assistance to departmental staff to maintain productivity where design obstacles were encountered.● Combined business experience with technical background to provide a valuable spectrum of service and knowledge to the department.

● 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. ● Served as communications liaison between IT and sales staff, helping to determine feasibility of more intensive customer needs. ● Supported end users concurrent to leading optimization projects of online tools written in Crystal Reports.