Hi, I’m
Stephanie Taylor
Atlanta,GA
Summary
Enthusiastic Analyst polished in optimizing systems to address dynamic needs, improve collaboration and strengthen security. Expert of defining and solving problems within the Microsoft framework.
Overview
21
years of professional experience
1
Certification
Work History
Operation HOPE
Senior Analyst
11.2021 - Current
Job overview
- Azure AD (auditing, modifying, adding, and removing users) Azure SSO management (develop SSO connectors for external resources)
- Manage FTP file transfers using Azure SFTP, FileZilla, & Kleopatra
- Microsoft 365 Admin center: (Used with Azure AD to manage groups, roles, aliases, licenses, and applications for Dynamics, Office, PowerApps, Teams, and more)
- Dynamics 365 (Product life cycle using Agile story process, development, UAT testing, and data migration project planning, importation, & QA processes)
- SQL Server/SSMS (Building clean data sets by re-engineering prior SSAS SQL instances, writing queries, and leading the QA of data via various departments) Advanced Excel Smartsheet Zendesk and more
Georgia Hospital Association
Senior Data Analyst
05.2018 - 11.2021
Job overview
- Direct the implementation of CRM solution through the requirement, deployment, and testing stages
- Trained approximately 50 people over 45 classroom hours on new CRM solution
- Developed all training materials and successfully achieved an intermediate level proficiency of the solution for 100% of students
- Transformed large database, built on multiple legacy platforms, into one lean and concise system
- Championed both success of the new CRM system and the collaboration of data silos from diverse departments by working closely with Senior Leadership and principle players
- Developed business rules to streamline processes and increase automation of redundant tasks, increasing opportunities to create value for members
- Developed, analyzed, and forecasted feasibility of new service offerings grounded in Cognitive Services and Machine Learning
- Produced budget with clear metrics to gauge ROI and establish annual benchmarks
- Performed querying, cleansing, aggregating, and reporting of data
- Presented results utilizing dashboards, ensuring high degree of accuracy and ease of understanding in an esthetically pleasing structure
- Collaborated with community leaders to build meaningful and relevant partnerships.
Community Bankers Association Of Georgia
Database Specialist
06.2016 - 05.2018
Job overview
- Database Administrator for WebLink, a CRM platform, oversee financial data transfers into QuickBooks Enterprise
- Write queries with SQL and manipulate tables as needed for accurate reporting purposes
- Import data into Excel, using conditional formatting, macros, pivot tables, and VLOOKUP, to provide accurate reports from thousands of rows of data to finance, marketing, and education departments
- Troubleshoot network problems, finding solutions for in-house & remote users
- Collaborated cross-functionality to identify efficiencies and opportunities for improvement
- Perform full-cycle accounting duties, utilizing Accrual-Based accounting and adhering to GAAP principles
- Control cash, credit, & checking accounts, perform A/R & A/P activities and report EOM reconciliations
- Sell memberships, sponsorships, programs and special events to targeted member audience
- Oversee event management, reviewing BEOs, reconciling attendance
- Attend key events, like our Day at the Capital and network with current and prospective members.
Lucid Lounge Studios
Finance & Sales Manager
01.2003 - 10.2015
Job overview
- Create and maintain financials including; analyzing profitability of potential studio equipment, developing depreciation tables for assets, continually assessing fee schedules, and forecasting five and ten-year budgets
- Manage daily operations including budgets and staffing
- Develop and maintain relationships between talent, employees, and other principle players
- Sell production services to potential clients and provide guidance on contract negotiations
- Perform full-cycle duties, using QuickBooks and Accrual-based Accounting
- Control cash, reconcile accounts, and provide monthly financials to investors and CEO
Education
Georgia State University
Bachelors' of Business Administration in Marketing
Georgia State University
Associates of Business Administration in Accounting
Skills
- Accounting (10 years)
- Budgets (10 years)
- Cash (10 years)
- Forecasting (10 years)
- Marketing (10 years)
- Microsoft Dynamics (5 years)
- Microsoft Flow (5 years)
- Microsoft PowerApps
- Power BI (5 years)
- Leadership Training (5 years)
- Manager (10 years)
- Leadership Development (10 years)
- CRM (10 years)
- Alteryx (1 year)
- Project Management (10 years)
- Program Management (10 years)
- Data Entry
- Customer Service
- Database Management (5 years)
- Data Analysis (10 years)
- Machine Learning
- Cognitive Services
- Linear regression
- Director
- AI
- Big Data
- MySQL
- SQL
- Tableau
- Microsoft SQL Server
- Data Warehouse
- SSRS
- Business Analysis
- Data management
- Business requirements
- Data collection
- Business process modeling
- Software development
- Analytics
- Client management
- Client Relationship Management
- Data Analysis
- Performance monitoring
Certification
- Lean Six Sigma Green Belt
- IISE Lean Six Sigma Green Belt and Healthcare Certificate
Timeline
Senior Analyst
Operation HOPE
11.2021 - Current
Senior Data Analyst
Georgia Hospital Association
05.2018 - 11.2021
Database Specialist
Community Bankers Association Of Georgia
06.2016 - 05.2018
Finance & Sales Manager
Lucid Lounge Studios
01.2003 - 10.2015
Georgia State University
Bachelors' of Business Administration in Marketing
Georgia State University
Associates of Business Administration in Accounting