Daniel Franz Email & Phone Number

Sacramento, Ca, Us

- Designed and implemented a Python tool with Financial Operations management to reconcile Third-Party data with the Vendor Management System, streamlining the identification of discrepancies and assisting Financial Analysts in efficiently identifying and resolving errors.- Spearheaded an initiative for the executive leadership team to analyze and improve cross-departmental business processes by meeting with department leaders, identifying KPIs, and creating a dashboard to track and implement process improvements.

Folsom, California, United States

- Consulted with management to understand staffing needs and designed a PTO case management system using Microsoft Forms and Power Automate. This system allows employees to submit requests, automatically identifies scheduling conflicts, and notifies employees and management, ensuring 24-hour coverage while reducing manual review time.- Partnered with the operations team to develop a Power BI dashboard that reconciles third-party time files with Magnit's Vendor Management System, quickly identifying discrepancies while optimizing processing efficiency and reducing compliance risk.- Worked closely with the Learning and Development team to design a dynamic Power BI report that tracks key performance indicators and evaluates departmental performance, providing actionable insights to improve efficiency and drive results

Folsom, California, United States

- Responsible for creating, maintaining, and enhancing a company-wide financial report to meet evolving leadership needs for reviewing account financials.- Engaged closely with stakeholders to gather requirements to develop a financial data consolidation tool in Power Query. Streamlined data scrubbing, analysis, and reporting for management, reducing manual processing time by over 2 hours per week.- Designed a sales tax tool in Power Query that consolidates, cleanses, and validates tax data, reducing compliance risks and improving processing time by 50%.- Worked closely with financial operations management to create a Power Query tool and process that consolidates and validates invoice data from multiple vendors, ensuring accurate reporting and enabling a streamlined billing process.

Folsom, California, United States

- Collaborated with Client Services team to communicate with clients and suppliers and improve processes efficiency - Guides cost analysis process by establishing and enforcing policies and procedures; providing trends and forecasts; explaining processes and techniques; recommending actions.- Improves financial status by analyzing results; monitoring variances; identifying trends; recommending actions to management.- Reconciles transactions by comparing and correcting data.- Maintains database by entering, verifying, and backing up data.- Increases productivity by developing automated accounting applications, coordinating information requirements.- Created and distributed weekly financial reporting to management and Financial Operations Team

Santa Cruz, California, United States

•Produce original photographing and collaborate with in-house graphic designer and videographer to create social media content•Identify growth opportunities by analyzing Facebook and Instagram metrics via Google Data Studio•Increased brand awareness on Facebook, grew weekly Organic reach by 2,000%, weekly engagement by 300%, and follower base by 100 users •Represent the CORE brand online and engage authentically with the target audience by responding to direct messages, and coordinate giveaways increased Instagram followers by 5%

Santa Cruz, California, United States

•Developed digital content distribution strategy and worked with editors and web developers to execute the plan•Increase social media website traffic from 50-570 weekly users and weekly website traffic 180% through social channels, search engine optimization, and email marketing•Used Google Data Studio to visualize and analyze Facebook, Twitter, and Instagram analytics to report weekly to Editors

Santa Cruz, California, United States

• Managed and mentored 5 video reporters to meet deadlines and develop storytelling skills

Santa Cruz, California

• Worked collaboratively to compile data from various sources, investigated, and analyzed information to create an impactful story to represent underreported events, ideas, and voices• Deployed technical knowledge of lighting, audio, and cameras to produce professional footage

Santa Cruz, California, United States

• Consulted with startups and small businesses to understand their business needs and developed and implemented a marketing strategy to build brand awareness, educate consumers, and drive website traffic and conversions• Managed marketing team of 5 people by assigning goals and deadlines - Instagram marketing campaign results include 185% increase in profile visits, 2,592% increase in impressions and 3,280% increase in reach• Produced high-quality brand-specific marketing images and videos for social media and website usage• Used Google Analytics to analyze the website user experience and implementing changes to retain users and drive sales

Santa Cruz, Ca

• Collaborate with the marketing team to find ways to increase site traffic and user retention• Produce high-quality brand-specific marketing images and videos for social media and website usage

Santa Cruz, Ca

• Prepare, demonstrate, and efficiently check-out equipment to faculty, staff, and students.• Using professional lighting, audio, camera equipment to assist the editor in capturing live events• Help troubleshoot and explain technical concepts such as the operation of classroom equipment through the Emergency Hotline• Responsible for the technical operation of audio-visual, computing, and video conference equipment including set up and testing of video cameras, microphones, audio mixers, and media presentation equipment for distance educating classes

Sacramento, California Area

Responsible for greeting all customers in a friendly way and managing payments. Supervised and guided the team, and delegated tasks to maintain an organized parking system in high-pressure settings. Worked at various densely populated areas including restaurants, hospitals, night clubs, and other large-scale events. Communicated with primary contacts such as hotel managers and event coordinators.

Sacramento, California Area

Helped implement and organize a management software system that provided thorough nutritional analysis, production planning, route management, lot tracking, and online ordering. Communicated with vendors for pricing and ingredient information.