Skyler N. Email & Phone Number

Chicago, Illinois, Us

Menlo Park, Ca, Us

Data Analysis and Reporting:-Data Visualization: Armed with Tableau, SQL, and Spreadsheets, I transformed complex analytics into actionable recommendations. I summarized business metrics effectively, making them easy to understand for decision makers.-Ad-Hoc Reporting: I generated ad-hoc reports using SQL, Spreadsheets, and Salesforce Reporting. These reports evaluated specific business requirements, providing critical insights for strategic decision making.Database Optimization and Performance:-Advanced SQL Techniques: Leveraging advanced SQL query optimization techniques including ETL, I enhanced database performance and assured high data accuracy.Process Documentation and Collaboration:-Organized Documentation: I created organized documentation for standard processes, SOPs for advanced operations, and working docs for ongoing projects. This documentation facilitated seamless collaboration and knowledge sharing.-Collaboration with Engineering and CRM Teams: Working closely with ENG and CRM admin teams, I ensured data integrity and accuracy within Salesforce. My project management skills led to customizations that streamlined processes and improved the user interface.Technical Troubleshooting and Support:-Root Cause Analysis: When analytics and reporting issues arose, I dove into databases (within and outside Salesforce) to identify root causes. My corrective actions were swift and effective.-Salesforce Advanced Support: I resolved pipeline and user input issues, combining troubleshooting prowess with deep dive SQL/SOQL analysis.Data Management and Quality Assurance:-CRM Data Management: I meticulously managed Salesforce data, ensuring its accuracy and security. This involved running corrective analysis using SOQL and apply changes in Salesforce.-Quality Assurance: Collaborating with sales leadership, I provided quality assurance for imported data. My attention to detail minimized errors and improved the sales team trust in Salesforce.

Salt Lake City, Utah, Us

I enhanced business processes through strategic implementation of technology. Here’s how I’ve transformed operations across various departments:Marketing Automation-Developed a marketing automation system using Zapier and Python, centralizing multichannel marketing efforts into a unified database.Data Transformation-Implemented ETL processes to standardize and enhance the quality of lead data, ensuring compatibility and consistency.-Engineered SQL data marts with ETL processes to minimize errors, facilitating comprehensive marketing analysis and predictive lead generation.Spam Lead Filtering-Created a Python-based spam filter with predictive logic to prevent spam leads from disrupting the sales pipeline.Process Automation-Designed and executed automation scripts with Power Automate, Zapier, and Python to optimize Dynamics 365 CRM operations, improve lead management, and refine overall process efficiency.CRM Customization & User Experience-Partnered with department leaders to customize Dynamics 365 CRM, significantly improving the user experience and boosting team morale and productivity.User Interface Design-Collaborated with cross-functional teams to overhaul the user interface for sales funnel management, reducing the need for manual input and streamlining sales operations.Subject Matter Expertise-Provided expert guidance on data analysis and best practices for data management, supporting recruitment, marketing, HR, sales, and operational teams.My approach to automation is centered around creating seamless workflows that empower teams to focus on their core competencies instead of clunky systems, driving growth and innovation within the organization.

Salt Lake City, Utah, Us

Administrator with a proven track record of developing and overseeing multiple unique Dynamics 365 CRM instances. Expert in integrating these instances into a centralized database system, which I then skillfully converted into comprehensive performance reports tailored for both the owner and the C-Suite of subsidiary companies.CRM System Development & Maintenance:-Architected and sustained four distinct Dynamics 365 CRM instances, ensuring seamless data flow into a unified database.-Transformed data into insightful performance reports, aiding executive decision-making and company performance evaluation.Performance Monitoring & User Experience:-Vigilantly monitored CRM system health, implementing necessary adjustments to maintain peak efficiency and user satisfaction without sacrificing business objectives.-Enhanced user interfaces and system management practices, contributing to strategic planning and ensuring alignment with best practices.Data Integrity & Compliance:-Conducted thorough audits of CRM data and processes, upholding stringent industry standards and organizational policies.-Implemented customizations in collaboration with department heads, optimizing Dynamics 365 CRM to fit unique business needs and boost team morale.Training & Support:-Led improvement projects for Dynamics 365 CRM, fostering organizational growth and operational efficiency.-Mentored staff and delivered ongoing training on CRM functionalities, promoting system adoption and process alignment with business goals.In 2019, I played a pivotal role in the rollout of a new CRM system (Dynamics 365) with a marketing extension (initially Click Dimensions, later replaced with Dynamics Marketing). Collaborating closely with other CRM administrators we crafted custom environments and reports for the sales team, while continuously refining processes, enhancing user experience, and providing comprehensive training and support.

Salt Lake City, Utah, Us

As a Senior Data Analyst a have a proven track record with engineering data flows, I have demonstrated expertise in optimizing marketing spend, enhancing revenue production, and providing critical analysis to increase business performance.Data Analysis & Reporting-Achieved a 40% optimization in ad spend, significantly boosting the marketing department’s budget and revenue generation capabilities.-Conducted lead acquisition and closing rate analysis, resulting in a 10% budget increase for the marketing department and the development of KPIs to isolate underperforming campaigns.-Recognized as a subject matter expert across various projects, offering insights into data analysis methodologies and best practices for data storage and manipulation for reporting.SQL & Data Modeling-Created ad-hoc reports and comprehensive data models using SQL, which were integral to C-Suite reports in PowerBi, showcasing progress towards organizational objectives.-Developed and maintained data marts using SQL, employing ETL processes to transform raw data into formats suitable for PowerBi Reports and marketing analysis.Trend Analysis & Decision Support-Analyzed vast datasets with SQL to uncover trends, patterns, and insights that enhanced operational efficiency and informed decision-making.Custom Reporting & CRM Management-Designed tailored reports for sales and marketing teams, utilizing PowerBi, Dynamics 365 CRM, and Excel to convey findings and facilitate sales funnel tracking.-Implemented automation scripts with Power Automate, Zapier, and Python to improve Dynamics 365 CRM efficiency, lead management, and process optimization.Marketing Systems & CRM Integration-Managed marketing systems and CRM integrations, leveraging tools like PowerBi, MS Planner, MS Tasks, Teams, Outlook, and Power Automate to assist department heads with projects and develop cross-departmental tools.My focus is on delivering actionable insights that drive strategic business decisions.

Salt Lake City, Utah, Us

As a seasoned marketing data analyst, I have been able to leverage my expertise in data analysis, data visualization, marketing strategy, CRM migration and automation to drive business growthMarketing Analysis & Revenue Growth-Optimized Marketing Strategies: Conducted in-depth analysis of marketing channels and mediums to pinpoint high-potential opportunities. -Sales Funnel Supplementation: Closely monitored the sales team’s engagement with leads, to identify and capitalize on areas ripe for the implementation of targeted marketing customer journeys.Enhanced Visibility & Decision Support-Informed Strategic Decisions: My analytical contributions significantly boosted revenue and provided visibility into marketing effectiveness. The insights I delivered empowered leadership to make data-driven decisions that aligned with the company’s strategic objectives.Data Visualization with PowerBi-Advanced Data Visualization: Utilized PowerBi to transform complex datasets into clear, actionable insights. I developed interactive reports that provided department heads with real-time data, fostering informed decision-making and strategic planning.CRM Migration & Enhancement-Pioneered CRM Optimization: Spearheaded the transition to a cutting-edge Marketing CRM extension, enhancing marketing data management and operational efficiency. -Seamless Enhancement Transitions: My role was pivotal in streamlining the migration process, ensuring a seamless integration of new marketing features and functionalities within the CRM database.Automation with Power Automate-Streamlined Lead Flows: Implemented Power Automate to optimize workflow processes, resulting in the automatic generation and updating of key reports. This innovation not only saved time but also increased accuracy and reliability of data.My passion for uncovering insights and driving business success is at the core of my professional ethos.

Salt Lake City, Utah, Us

As a marketing specialist with a focus on data analysis, I honed my skills in enhancing sales strategies and optimizing lead generation processes. My expertise fell into the following areas:Campaign Management:-Orchestrating Email Campaigns: Spearheaded targeted email marketing initiatives across 20 diverse markets, leveraging a robust prospecting database of approximately 80,000 potential leads.-Strategic Marketing Value: Designed and executed strategic campaigns that significantly boosted revenue streams, contributing an estimated $400,000 from a singular communication channel.Lead Conversion & Sales Support:-Driving the Sales Pipeline: Played a pivotal role in the sales conversion pipeline by efficiently directing qualified leads to the sales team.-Providing Meticulous Support: Assisted in coordinating meetings and meticulously managed lead databases, ensuring timely follow-ups and comprehensive documentation of all interactions.Data-Driven Decision Making:-Strengthened Performance Analysis: Established key performance indicators (KPIs), identified emerging trends, and tracked vital metrics, providing actionable insights to leadership.-Exceeded Performance Targets: My analytical approach resulted in surpassing initial business expectations through data-driven strategies and performance monitoring.My tenure in this role has been marked by a blend of creative campaign orchestration and rigorous data analysis, all aimed at driving sales and fostering a culture of continuous improvement.