Experience
Dan Yosua Creative (Founder/Freelancer) Aug 2019 – Present
• Product photography, video, podcasting, and social media management. Passionate about podcast production, YouTube growth, and helping companies grow their content projects.
• Tools that I use in this space include: Adobe CC (Photoshop, Lightroom, Premiere, Audition), Recut, Riverside, GPT-4.
• Proficient in every part of the podcast production lifecycle, including being on camera myself.
• Special interest in bootstrapped B2B SaaS. Have worked with Userlist’s shows, currently Startups for the Rest of Us.
• Have worked with several YouTube channels, and have grown my own to several thousand subscribers targeting search.
BorrowLenses @ Shutterfly (Manager, Business Analytics) Jan 2022 – July 2023
• Led our analytics pilot and cutover to Domo. Established data connections and ETL flows for operations reporting.
• Developed reports using Incorta, Alteryx, SQL, Excel. Supported SAP go-live for new site and data architecture.
• Maintained metrics for warehouse operations efficiency and fraud detection. Trained new hires and covered for our financial and customer insights analyst role following our SAP go-live.
Aktana (Customer Success Engineer) Jan 2020 – Dec 2020
• Maintained ad hoc data files, internal wiki documentation, data loading jobs, and JIRA tickets to help prioritize work.
• Works directly with both internal and customer teams as the technical resource in translating business
requirements into SQL-based data rules. Relates these rules to technical and non-technical audiences.
Prometrics LLC, A Concerto HealthAI Company (Data Analyst) Dec 2018 – Jan 2020
• Delivered weekly and monthly reports using T-SQL for data pulling and Excel for visualization.
• Performed quality checks against T-SQL code for specialty pharmacy reporting on Prometrics’ largest client team.
• Identified areas of manual analysis then documented and automated Excel processes using better T-SQL data pulls.
Energage (Data Analyst, Technical Customer Support) Dec 2015 – Dec 2018
• Specialized in T-SQL data manipulation and ad hoc Excel reporting for larger, enterprise client deliveries.
• Supported internal teams to advance clients through workplace survey life cycles and updated survey application database
using T-SQL and SSMS to maximize client value in the online survey results tool.
• Acted as an intermediary between our survey support team and dev/customer success/consulting/sales teams.
• Defined opportunities for dev teams to automate solutions to frequently requested support tasks.
• Effectively triaged and prioritized support tickets in Salesforce and Zendesk.
• Ran ad hoc analyses to inform culture tech content written by marketing and leadership.
• Scheduled and facilitated weekly team meetings for T-SQL skill sharing and collaborative process improvement.
Blue Mountain Quality Resources (Business Intelligence Reporting Analyst) May 2013 – Dec 2015
• Facilitated discussions to assess clients' reporting requirements, then created and modified T-SQL reports in SSRS
to run within the Blue Mountain RAM platform.
• Authored reporting solutions in SSMS, SQL Server Data Tools, Crystal Reports and Excel.
• Ensured T-SQL code quality, documented deliverables, and trained groups in Blue Mountain's reporting methodology.
Yosuatreegames LLC (Co-founder & Designer) Feb 2013 – Dec 2016
• Designed interfaces and features, created digital assets and video, and discovered customers for 3 mobile games and apps.
Education
The Pennsylvania State University, University Park PA Aug 2010 – Dec 2013
B.S. Information Sciences & Technology w. Distinction, 3.78 GPA, Business & Liberal Arts Minor (BUSLA)
PSU IST Alumni Spotlight Apr 2015