Mallory Scott Email & Phone Number

Philadelphia, Pa, Us

Remote, Us

- Build and maintain reporting dashboards in AWS QuickSight across multiple departments and business units within the company, including setting up calculated fields in order to obtain necessary statistical metrics.- Update SQL queries on a daily basis to pull in newly requested data points, create new data sets for complex metrics/KPIs, or correct issues while utilizing GitLab/PyCharm in order to push any updates.- Manage access in AWS QuickSight across the company by monitoring various alerts, granting access as requested, and completing a one-time audit of all access by role and user group.- Wrote out various SOPs for the BI team in preparation for new team members and creating consistency in a young team, including AWS user group access management and dashboard life cycle management.- Partner collaboratively with business leaders across all areas of the company to fulfill their data requests unique to their departments, ensuring their requirements are met in a timely fashion at the highest level of quality.

Remote, Us

- Managed staffing models for the operations departments of the company, empowering leaders of these departments with the necessary data to make decisions about their workforce.- Assisted operational leaders with budgeting for predicted headcount for all operations departments based on staffing models, time studies, and various data analysis.- Utilized AWS QuickSight, AWS Athena, SQL, and Excel to complete all data requests related to workforce planning.- Provided assistance to the Corporate BI Manager with ad-hoc AWS QuickSight dashboard build-outs and SQL data requests for leaders across the business.- Developed a new staffing model for client operations teams that focused on client revenue and overall helped to refine our workforce planning, increase the efficiency of modeling, and produce a new incentive plan.

Remote, Us

- Functioned as a Workforce Analyst by managing staffing models for two of the largest operations departments in the company.- Utilized SQL and Excel to complete all data requests related to workforce planning.- Responsible for day-to-day management of a c-suite level executive, including maximizing capacity for the leader via scheduling, assisting with managing their team and projects, and completing work in the following areas: - Pulled data monthly for the Board of Directors presentation related to client health YTD.- Utilized Salesforce to pull statistics on cross sells, upsells, and renewals relating to the company's 2019 goals of sales revenue.- Fulfilled data requests by utilizing AWS to compile statistics related to specific clients for this executive's direct reports to deploy in their sales conversations with clients.- Operated with the up-most professionalism and discretion as I worked with multiple executives across the company.

Remote, Us

- Responsible for day-to-day management of two market leaders, one in client operations and the other in recruiting, including maximizing capacity for the leaders via scheduling, assisting with managing their teams and projects, and completing work in the following areas: - Pulled data daily for one of the top clients in the market and produced a weekly statistical report related - Maintained open communication with all direct reports under the client operations market leader to gather updates on clients and assist with project management.- Set up integrations between three of the recruiting team's platforms to increase efficiency related to the processes of generating offers and running background checks.- Managed ongoing scheduling for several candidates and ensured efficiency in moving candidates through the interview process.

Remote, Us

*The Professional Development Program is a program for new college graduates to rotate through various departments in the company in order to experience Businessolver on various levels and find the best team for full-time placement.*-Assisted the VP of Workplace & Facilities for 3 months on facilities-related projects, including: helping to organize office events and researching new opportunities for employee offerings in our talent hubs.-Completed a rotation in Member Services (Businessolver's call center) where I spoke with an average of 30 members per day, answering their benefit questions, assisting them with enrollments, and helping to solve their issues with their benefits. -Obtained comprehensive knowledge of benefits and Businessolver's technology platform used for enrollment. -Refined my empathy skills as I dealt with difficult members or members struggling with their benefits during my time in the call center.

- Assisted the Director of the mentoring office with day-to-day functions to maintain the operations of the mentoring programs through critical thinking, administrative support, and organization.- Analyzed survey results from the YAMs program for the director to assist in making future decisions for the success of the program, including matching and different topics of interest to address in mentorships.- Maintained open communication with members of both programs to ensure they are aware of events or deadlines and continue to actively participate in the programs.

Boulder, Colorado, Us

-Built an inclusive, welcoming environment for the residents not only on my floor, but in the entire residence hall of approximately 330 people. -Lead up to 50 students on my largest floor.-Attended several training programs to maintain knowledge in diversity, inclusion, and social justice. -Conducted multiple meaningful conversations with residents and in doing so, learn applicable interpersonal and emotional intelligence skills to maintain an approachable disposition. -Performed various conduct violation write-ups and submit Incident Reports that have thus taught me how to handle conflict and accurately relay information to the necessary people. -Worked alongside a staff of 19 other RAs and Professional Staff members, including a Hall Director and an Assistant Hall Director, where I have learned how to better handle myself professionally and how to be an efficient and helpful group member.

Westminster, Colorado, Us

- Created multiple resource guides on leadership development to be deployed throughout the organization to help HR leaders realize creative solutions to building stronger leaders. These resource guides will help to advance the mission of the Talent Management department at Ball and move the team towards achieving their goals for 2017.- Analyzed workforce data for global operations and engineering to discover solutions for workforce structure and costs within Ball plants.- Provided perspective and assistance in the analysis and development of the pilot mentoring program at Ball.

Denver, Colorado, Us

- Analyzed candidate applications, both internal and external, for various positions within King Soopers/City Market to help decide which candidates to move forward.- Attended recruitment events and career fairs to find and educate potential job candidates, especially those for management positions, while professionally representing King Soopers.- Created various social media postings for recruitment of open positions at King Soopers.- Helped to monitor the progress of the team members in the assistant store manager training program, Leadership Essentials.

During my time spent with this campaign, I assisted with political poll phone calls, sorting flyers, and helping the campaign coordinators with various tasks. Through this internship, I was able to learn how an efficient and successful campaign is run, which can be translated to running a successful business.

Denver, Colorado, Us

In my time as an intern for King Soopers, I worked with the store manager and secretary for Store #78 in daily administrative tasks. In my duties, I worked on DSD reports, 709 reports, and perpetuals for the store. Additionally, I was able to discover how to run operations smoothly and manage a group of employees efficiently as I observed how the store manager handled his profession.

Master Of Science - Ms, Business Analytics

Bachelor’S Degree, Business Administration, Emphasis In Leadership, Operations And Talent Management

High School Degree