Daniel Clark

Principal Software Engineer - Tech Lead & Scrum Master

Owner, founder and web developer of Dotploy Web Design Co. dotploy.com

5/11/2020 - 11/16/2020 Completed EPM Move and Improve Project (Phase 1A Reporting Project) with successful Go-Live for historical data migration, go-forward data loads, and developed systematic processes to export data out of Hyperion and load to OneStream via SFTP & Task Scheduler automation. Utilized SFTP to AWS bucket and encryption processes in order to complete OneStream Phase 1A scheduled data pulls. Coded for Hyperion application with MAXL, Calc, Report, and Batch scripts. Completed OneStream Admin Training Certification. 11/17/2020 - 8/26/2021 Team Lead Developer to lead weekly standup meetings and coordinate between Red Hat and consultants for OneStream integrations. Organized and communicated technical requirements for API's with cross-functional teams on EPM Move & Improve Project (Phase 1B). Assisted in development of integration tasks and discussions related to OneStream Phase 1B design, coding, and testing. Lead Developer on OneStream to RedShift project. Architect of software process design of OneStream to RedShift project with Global Finance Analytics and EDA Team. Automated all data exports of metadata, user security information, and scenario data in OneStream to RedShift data warehouse. Secured, encrypted, decrypted, exported, imported, and migrated historical data needed for OneStream Phase 1B per business requirements from Hyperion to OneStream. Developed OneStream Automation with Data Management Sequences & Steps, Business Rules, and SQL. Learned how to build a Business Rule to pull JSON and CSV data from an API. Managed setup of the OneStream SFTP for file transfers and data encryption. Troubleshooted issues, reviewed logs and error messages, and fixed bugs that arose from OneStream testing. Documented code integrations and processes with help of consultants and EPM Team. Code reviewed and improved code as necessary for performance enhancements and bug fixes.

Consults on SiteLink Software financials by using 6 years of experience to help train, conduct code reviews, and provide documentation as needed.

Developer on the Wealth Management IT team helping to maintain applications used by the bank and vendors. Technology focused primarily on: SSIS packages, SQL database, and Asp.Net web applications using C#. Contractor through The Select Group.

Full Stack Software Engineer using Agile and Scrum methods on a team of 5-7 members. • SiteLink myHub, Web Application Product - C#, JavaScript, JSON, AngularJS, ReactJS, Asp.Net MVC, AWS, GIT, SQL, and SAP Crystal Reports. • SiteLink API, Web API Product - VB.Net, C#, AWS, GIT, and SQL. • SiteLink Web Edition, Windows Application Product - VB.Net, C#, Asp.Net, XML, AWS, GIT, SQL, and SAP Crystal Reports. • Additional Tech - GitLab, Jira, Confluence, Slack, Microsoft Office, Postman, Visual Studio 19 & Code, SQL Management Studio, Salesforce, Zoom

Full Stack Financial Software Developer working with CEO, CIO, and team. • SiteLink Web Edition, Windows Application Product - VB.Net, C#, Asp.Net, XML, SQL, TFS, and SAP Crystal Reports. • SiteLink myHub, Web Application Product - C#, JavaScript, JQuery, HTML, CSS, JSON, AngularJS, Asp.Net MVC, SQL, TFS, and SAP Crystal Reports. • SiteLink API, Web API Product - VB.Net, C#, TFS, and SQL.

Windows Applications and Web Developer • Became a Visual Basic developer by using Microsoft Visual Studio 2012 • Trained by the head developer with 17+ years of experience on how to code in VB.NET • Designed and coded the entire Group Products billing system in Windows Applications including front end design, visual basic calculations, and back end SQL database in 5 months • Helped design, code, test, and debug the online Auto Claims System used by the State of North Carolina in VB.NET, ASP.NET, and FoxPro • Gave status reports and timeframes to supervisors on software being developed • Reconciled data for 1-2 months by checking calculations and input errors from years of Group Products data SQL Server Database Administrator • Analyzed SQL Server requirements for NCAIA • Installed SQL Server 2012 and set up for future database software systems • Worked in SQL databases to design, edit, and set properties to tables • Coded reports using SQL Server Reporting Services (SSRS) utilizing complex queries • Created full backups of SQL Server daily which also included Excel spreadsheet backups • Executed queries in SQL Server and exported Excel to analyze when needed Auto Claims System Database Manager • Managed the Auto Claims System daily by decrypting text files and updating the FoxPro database • Completed monthly data dumps of auto claim financial information from Travelers • Tracked “non-user” information and analyzed using excel pivot charts and tables • Developed and tested code enhancements for the Auto Claims System website • Worked in FoxPro daily to update claim information and troubleshoot code when necessary • Organized and presented monthly webinars on the Auto Claims System to train the employees of N.C. • Created detailed user manuals on multiple database software systems

SKILLS AND QUALIFICATIONS • Financially supported himself throughout college without acquiring debt • Completed North Carolina State University accounting and management courses • Communicates effectively and is detail oriented • Adjusts well to new work environments • Has completed projects and obtained experience with using Microsoft Office Suite, Windows Operating Systems, and Mac Operating Systems