Darren Tonks Email & Phone Number

United States

Proficient in Tableau for creating interactive and insightful visualizations that drive decision-making and communicate complex data trends effectively.Skilled in data processing techniques, including cleaning, transforming, and validating large datasets to ensure accuracy and reliability.Experienced in automating data processing workflows using tools such as Python, streamlining operations and increasing efficiency.Strong programming abilities in Python, SQL, VBA, and FoxPro for data manipulation, analysis, and integration across different platforms.Develop and maintain data pipelines for extracting, transforming, and loading data from various sources into databases, ensuring data integrity and accessibility.Continuously explore technologies and methodologies in data analytics to enhance processes

California, United States

• Built and maintained relational databases for revenue and tenants; SQL queries, form creation, and reports.• Test database to identify issues and make any necessary modifications.• Coordinated with management on database development timelines and project scope.• Excel Power Query, VBA, and Formulas to streamline invoicing, revenue analysis, and ad-hoc reporting.• Automated monthly and yearly reports, eliminating user error, and cutting the processing time by 90%.• Data visualization using Tableau Public and Excel Charts.• Spearheaded data clean-up in preparations for new software implementation.• Deployed web application using REST API, Flask, and Python.• Data mining scripts using VBA and Python to gather information.• Developed forecasting tools to analyze revenue and marketing budgets.• Created inventory management system using Excel.• Supervised 3 staff members - onboarding, delegating projects, assisting with issues, and training.• VBA developer streamlining processes for all staff.

Greater San Diego Area

• Responsible for analyzing, and leading meetings on +$50mil in monthly revenue using Oracle Hyperion, Microsoft Access, and SQL.• Admin user for HFM and Hyperion Financial Planning (P&L, Workforce, Balance Sheet and Cash Flows); maintained database, back-end load rules, scripts, IT infrastructure status, and all reporting processes.• Worked in a small team to maintain a +half Billion dollar annual budget and rolling forecast for 10+ domestic and international entities• Built relationships with department leaders to allow clear communication on all business activities, and provided various ad-hoc analysis to assist with the understanding of the business. • Built business models and management reports to support planning activities of senior management leaders across the following functions: Executive, IT, Sales & Marketing, Account Management, Operations, HR, Legal.• Responsible for maintaining and publishing over 20 monthly/quarterly financial reports consisting of board packages, and variance reports with commentary for executives and managers.• Worked in a team oriented environment with an emphasis on cross training.• Automated A/R's manual invoicing process and bank reconciliations, cutting the processing time by over 50% and nearly eliminating billing errors.

Greater San Diego Area

• Manage the accurate and timely processing of invoices for 32 restaurant locations.• Handle daily A/P processes, expense reports, credit memos.• Maintain vendor relations and accurate weekly check runs.• Reconcile general ledger.

San Diego, California

• Maintain A/R records for over 3,000 housing units.• Prepare statements, bills and invoices.• Process lockbox, ACH, check, and wire payments.• Aged receivables improvement by following up on open accounts and working with homeowners during collection calls.

Greater San Diego Area

• Assess risk and costs for potential investment properties.• Manage expenses and maintain cash flow.• Assist in the management of construction crews.• Launched the first company website.

Full-Stack Web Developer, Computer Programming

Attended Le Wagon Bali (batch #253) 9-week intensive coding bootcamp learning HTML, CSS, Bootstrap, JavaScript ES2015, SQL, git, GitHub.

Bachelor Of Science (Bs), Business Administratoin - Human Resource Management

Education record