Dylan Forck Email & Phone Number

Westminster, Co, Us

Palo Alto, Ca, Us

Oversaw maintenance, optimization, and security of databases, utilizing Microsoft SQL Server Management Studio.Developed finance applications, automating data finance models required for account entries during month-end close.Led the management and maintenance of multiple Power BI dashboards for the Contra Finance department, ensuring 100% data accuracy and integrity.Extracted and integrated data from Snowflake and other sources to populate Power BI dashboards, executing daily data refreshes and updates to maintain timely and accurate reporting.Conducted deep dive analyses to identify and rectify errors, updating stored procedures to align with evolving business requirements.Collaborated with stakeholders to design effective solutions, enhancing end user satisfaction.

Palo Alto, Ca, Us

Spearheaded the migration of revenue data from Oracle and Zuora RevPro into SAP S4, ensuring accurate recording of revenue backlog for amortized services.Developed and delivered key reports from SQL and Oracle BI to support system migration planning and execution.Led the implementation and quarterly testing of Robotic Process Automation, significantly reducing manual labor and improving process efficiency.Conducted quarterly SSP Carve Trend Analysis, ensuring accurate revenue recognition and compliance with accounting standards.Collaborated with business users across multiple functions, including Finance and Sales Operations.

Santa Cruz, California, Us

Directed data integrations between RevPro and Oracle systems architecture, ensuring precise and timely financial reporting.Led the monthly close process for Zuora RevPro, encompassing data validation, reconciliation, and journal entry postings to Oracle General Ledger, reducing completion time by 50%.Coordinated and performed User Acceptance Testing for new system enhancements and integrations, ensuring business requirements were met.Served as the go-to individual for RevPro defects and enhancement requests, providing timely and effective resolution of issues and ensuring system functionality and accuracy.Verified RevPro compliance with ASC 606 Standards for automating revenue recognition of services.Created and maintained Standard Operating Procedures for all recurring analysis.Provided recommendations for process and system improvements to increase efficiency in revenue forecasting and revenue close, resulting in an improvement in overall process accuracy.Generated SQL Queries and Scripts for system testing and debugging.

Broomfield, Co, Us

Managed SQL Database for Timberline Estimating Objects.Developed and presented cost estimate proposals for large-scale projects valued between $100 million and $1 billion.Customized and revised estimates to meet client needs as the project developed.Created project tracking dashboards and automated reports, increasing team productivity and streamlining project management.Prepared cost model projections and associated presentations, improving communication and understanding of project cost structures.Excel expert, proficient in utilizing Pivot Tables, Macros, and VBA debugging, improving data accuracyProduced ad hoc reports for estimate package updates and budgeting requirements, resulting in improved decision-making for management and stakeholders.Updated and retrofit estimating templates for updated functionality, improving accuracy and consistency of cost estimates.Conducted team training for Excel and various software packages, improving team efficiency.

Denver, Co, Us

Prepared and presented successful bid proposals for diverse projects, each valued over $150,000.Conducted thorough quantity takeoffs for HVAC equipment, ensuring accurate project estimates.Streamlined customer order processes, resulting in increased satisfaction and repeat business.Demonstrated proficiency in updating department estimate templates and supporting documents, ensuring consistency and accuracy across all projects.Coordinated timely and comprehensive submittals of equipment schedules for engineer/architect review, demonstrating strong project management and communication skills.Produced O&M Manuals that contained highly technical and accurate product information, ensuring customer satisfaction and compliance with regulatory requirements.

Advised customers on suitable products for their projects, achieving high customer satisfaction rates.Conducted thorough quantity takeoff analysis for Masonry and Landscape products, minimizing material waste and maximizing project efficiency.Managed inventory levels and projections, optimizing stock levels to meet sales needs.Collaborated with team members to identify process improvement opportunities, specifically with yard and delivery operations, resulting in increased efficiency and cost savings.Planned and scheduled timely deliveries to project sites, ensuring on-time delivery.Supervised the transfer of materials to and from the branch, ensuring proper handling and storage.Handled incoming shipments from third-party vendors, processing invoices and maintaining accurate inventory records.

Masters, Data Science And Artificial Intelligence

Bachelor Of Science, Business Administration; Economics