Sean Mccarrell Email & Phone Number

Leads regular prayer calls, recruits Prayer Coordinators, and establishes Prayer Bands for open districts in the Western United States. Mission is to encourage and equip the Church to proclaim the Gospel of Jesus Christ.

Los Angeles Metropolitan Area

- Built and delivered a complex Profit Margin analysis for a global supplier of premium label solutions. End-to-end solution involved transforming data sources, writing SQL code, building an intelligent data model, and designing a Qlikview dashboard—ensuring data quality and integrity throughout. Partnered with the Margin Executive to ensure the solution could instantly identify and compare potential business segment changes over various time periods providing insights that increase margins for its hundreds of customers. - Built and automated (in two weeks) a robust data pipeline for a museum. Deliverables involved writing and configuring a Python script from scratch and developing an insightful Tableau dashboard. The client experienced up-to-date and accurate financial data enabling them to focus on specific donors and events with confidence.- Developed an intelligent dashboard of warranty costs and related metrics for a life sciences company. This solution required analyzing the client’s current data architecture, writing SQL code from a new data source, building a clean data model in DBT, creating an interactive dashboard in Tableau, and presenting this dashboard to current stakeholders. Employees save up to 80 hours every quarter moving away from pushed Excel reports to insightful daily data pulls and real-time summaries.- Engineered a business dashboard that presented sales data grouped by customers and geography for a quality garage door company. Deliverables included designing and implementing a full Tableau site architecture, building multiple interactive dashboards with drill through capabilities and row level security. Also facilitated user enablement sessions and trained employees how to build ancillary dashboards in Tableau. The client’s sales force now leads their industry with insights and can communicate important information to customers that no one else is currently doing.

Irvine, California

- Designed an internal QlikView dashboard with a seamless transition of migrating data from SharePoint over to SSMS database tables, writing SSIS packages to transform the data, and writing the logic into the dashboard. This full-stack BI implementation has given company leaders the analysis they’ve needed to hire employees, track employee’s time, determine budgeting metrics, and allocate future company resources with this data at their fingertips.- Took initiative and wrote a series of ten SSIS packages using data flows, for-each-loop containers, and SQL execution tasks that archived and transferred configuration files from secure file locations to our QlikView environment file share, impacting dashboards viewed by dozens of users daily. This ensured clients such as Walmart, Unilever, Smuckers, SC Johnson, Mars, Sargento, and Bayer that if they dropped off files in a timely manner, their custom dashboards would be updated seamlessly the following morning, resulting in a 50% efficiency increase.- Led efforts to help bring a new lead engineer up to speed by teaching them about our business, reporting strategies, security management, and version management. Done while maintaining current responsibilities and taking on those lead engineer roles for months, giving my team the stability and trust needed to move forward without losing any business while simultaneously strengthening our relationship with current clients.- Took initiative in learning and implementing Windows PowerShell scripting to provide advanced alerting in the form of PagerDuty wake-up calls for our team to fix any nightly process issues for clients like Walmart that required information hours before the day has started. These alerts were put in place because the client was reporting issues early morning that were not being fixed until the end of the work day. The solution found saved and strengthened our relationship with the client while resulting in a 40% increase in reporting efficiency.

Irvine, California, United States

- Responsible for daily upkeep of 266 QlikView dashboards and 91 Crystal Reports for 600+ clients across 500,000 active stores throughout the United States and Canada. Tasks include running SQL queries, troubleshooting complex data issues involving store coverage/call frequency/store activities, and providing quick and concise analysis for solutions.- Instrumental in building over 50 dashboards in a multi-clustered QlikView environment, using row-level security, loop & reduce, and database security tables to find custom solutions for any user. Actively managed the QlikView environment in Platform Manager according to SOC-2 compliance regulations for the internal BI team, resulting in a 12.5% more efficient work day.- Asked by management to be the lead developer in learning a new software in SSRS and migrating over our team’s entire reporting environment from Crystal Reports. Done to alleviate concerns of using an outdated reporting software that could cease to run smoothly with each impending Windows release, while giving users a better look and feel to the reports that were showing up in their inbox every morning. This has given a sigh of relief to our team while strengthening our business relationships with clients, knowing we are using the latest and greatest technology. - Created a Power BI dashboard to track product pricing, ensuring custom products made it to shelf quickly and with the correct price, allowing SC Johnson to make changes in their stores in real-time. Used SSIS packages to move real-time data into SSMS database tables refreshed every hour and leveraged Power BI dataflows to publish this dashboard as an application while managing the security within the application. After the dashboard was demoed, the client used this application to contact field representatives, changing product placement in the store that very day, resulting in a 25% more efficient process while simultaneously strengthening the relationship our company has with the client.

Rancho Santa Margarita, California, United States

Met with the VP of Operations regularly to understand the business of DYM, make sense of the company’s data, and provide insight for future income and budgeting decisions. Responsible for writing ETL processes to create a functional data warehouse that transforms data and loads it into new database tables, while using predictive modeling to build an interactive dashboard that assigns financial value and calculates essential KPI’s. This allowed DYM to perform company-wide budgeting and product analysis to forecast subscription revenue that would be generated in the near future.

Lake Forest, California

La Mirada, California

-Spent up to 40 hours every week developing baseball skills, leadership strategies, and communication abilities while keeping a great GPA in school. -Earned GSAC scholar athlete twice. -Earned NAIA scholar athlete twice. -Team spiritual leader.

Costa Mesa, California

-Created several different network diagrams, using Microsoft Visio. -Normalized phone numbers in our database using Microsoft Excel. -Used technical skills in SharePoint to clean out and organize a specific Knowledge Base. -Completed several different certifications through Microsoft Virtual Academy, including Excel, Database Administration, SharePoint, Visio, and many others. -Researched specific marketing strategies for future company development.

Mission Viejo, Ca

Teaching children foundational biblical principles, application of such principles, and appropriate social interaction among peers.