S. Jefferson Davis IV

Experience

• 

  United States Marine Corps

  Oct 2001 - Nov 2001

  Officer Candidate

  Candidate to become an Officer in the USMC. While I was unsuccessful in completing the program (dropped early but recommended for re-enrollment), I found it very valuable. It was quite an experience to be pushed and to push yourself literally 24/7 and to be challenged physically and mentally at levels never before undertaken.Notable Accomplishment:Recommended for re-enrollment, but after careful consideration opted not to do so.What I learned from the experience: *Stress and time management, the challenges of having more things to do in a day that could be done with a day and learning how to prioritize and face the consequences of what could not be completed. *Teamwork, individuals will fail, even when you were great at something, it was a failure if you succeeded at something, but your teammate failed. Show less

• 

  The Salvation Army - Dalton, GA

  Oct 2002 - Dec 2002

  Kettle Coordinator

  Ran the Red Kettle Drive in Dalton, GA in 2002. Coordinated the scheduling of volunteers and employees to maximize revenues at minimal cost. Achieved a record high gross in a poor economy, having lost two locations, in a season shorter by one week than the previous record. Also reduced direct labor costs (paid bell ringers) by roughly 15% from the previous year.What I learned from the experience: *Team management, I had a team of paid bell workers that I had to motivate to do what can be a every boring job. Overall, I had a great team that got great results and I was very proud of how they performed.*Volunteer management, volunteer management is much more like sales, and this was a great experience to work with some fantastic volunteers in the community and hopefully I let them realize the great impact of their contribution. Show less

• 

  The Salvation Army

  May 2003 - Aug 2013

  Coordinate the data conversion and migration aspect in an organization wide deployment of a Constituent Relationship Management (CRM) system. Develop SQL conversion routines that use complex queries, stored procedure and stored functions. Consolidated database size is over 5,000,000 constituent records and over 42,000,000 revenue records. Responsibilities:-Develop complex SQL program to convert multiple databases comprising several million records into a staging environment.- Develop back-end SQL scripts on production database to clean up data points and make corrections.- QC and test development of customized reports. - Deliver classroom training - Catalog donor data sources throughout a territory comprised of 10 Divisions, ~30 Metro Areas and ~600 locations.-Coordinate with the field and 3rd party vendors to get this data converted and imported into a unified system.Accomplishments:*Designed and developed a standardized evaluation tool weighted to RFP requirements to help in the software selection process.*Utilized public speaking and presentation skills to deliver classroom based end user training to two divisions. *Developed data mapping tool help automate the data mapping process.*Rapidly mastered use of vendors non-commercially supported conversion tool.*Learned SQL to a functional level in less than a month. Show less Property Accounting for 6 of 10 divisions. Divisions maintained about 35 open construction and renovation projects totaling over 120 million dollars.Responsibilities:-Process and inspect divisional check requests. -Maintain accurate acct. records in project database and reconcile against acct. system.-Process capitalization of property in accordance to Minute Book.-Pay all building maintenance related invoices.-Open, fund, close and return funding for all projects.-Support and advise divisional staff.Accomplishments:*Designed and built database program to integrate and partially automate processing and reporting of additions and deletions.*Developed new electronic forms used Territory wide.*Designed and developed personal database to automate frequent job task and increase work efficiency and help track past work.*Designed and developed MS Dynamics 'Smart List' export with macros to automate some reconciliation saving the Trust Accountant hours of work each month.What I learned from the experience: *I knew little of construction or facilities management when I took this role and gained much more insight about what it takes to build and maintain a property.*My database and application development experience really began to emerge here as I had a continued need to develop new tools to help manage the workflow and track budgets.*This position also prepared me for working with high dollar transactions that extended into seven figures for a single contractor payment or property purchase. Show less Position Responsibilities:-Provide user support for all department personnel on all department software, including Microsoft Dynamics Great Plains.-Train new hires on all software.-Create and maintain training documentation for all system processes.-Maintain Customer Records for Lotus Notes Catalog Ordering System and Great Plains.-Setup integration import for annual inventory.-Maintain accurate inventory records.-Process all subscription billing utilizing GP Dynamics integrations.-Process customized billing for graphics section.-Develop Inventory and Sales Reports.-Serve as backup for Phone Order Clerk, Invoicing Clerk and Accounting Clerk.Notable Accomplishments:*Took initiative and developed new sales and inventory reports, which became a regular job duty.*Created a computerized way to track items between when items were received at the dock and entered into inventory.*Was able to fully support staff on day one of implementing Great Plains.What I learned from the experience: *Retail, this position created a fantastic opportunity to learn the practical mechanics of a retail shop (Invoicing, Receiving, Drop Shipment, Point of Sale, and Inventory*Initiative, actions I took to make better use of idle time lead to new job responsibilities and ultimately a substantial reclassification of the position. *Reporting, this was my first opportunity to really develop some sales and inventory reports from the ground up.*User support and training, this was the first opportunity I had to serve in a user support role and learned about developing support manuals and also gained experience training new hires on the software of various age ranges and computer literacy. Show less

  • Donor Data Analyst/CRM System Data Architect

    May 2013 - Aug 2013

  • Donor Data/SQL Development Specialist

    Jun 2008 - May 2013

  • Property/Project Accountant

    Mar 2005 - May 2008

  • Information Systems Specialist

    May 2003 - Mar 2005
• 

  Apex Systems

  Aug 2013 - Oct 2013

  SQL Database\SSAS\SSRS Developer

  Contracting as part of the Sales BI Team at Georgia Pacific developing reports and analysis cubes. Responsibilities:- Modify SSAS Cubes and supporting queries, views, and SSIS packages.- Gather business requirements.- Debug and enhance existing reports.- QC and test development of customized reports.- Participate in daily Scrum meetings- Utilize TFS for Agile project management and source control. Accomplishments:*Worked with the senior Business Analyst to develop executive level report to display project status relating to various strategy streams.*Created an automated tool to send out notifications of delinquent time entry in the time management software.*Developed a comprehensive project detail report against EPM data. Show less

• 

  The Salvation Army

  Nov 2013 - Aug 2017

  Donor Data Architect

  Design, analyze, and implement the modeling of data. Serve as a technical expert for donor data integration and donor data movement.Responsibilities:-Data warehouse development-Building of customizerd reports and queries-Data hygiene management-Donor data project support-Data modeling, architectural design, & planning-Donor data integrationAccomplishments- Created a data warehouse from scratch for the exchange of data for our marketing partners as well as for report and dashboard development.- Created and designed architecture for an SSIS project to automate the transfer of gifts from out online donation software into our CRM.- Took initiative to redesign a marketing acquisition report to reflect the long term impact of an acquisition effort. Show less

• 

  MarkeTeam

  Aug 2017 - Jan 2019

  Data Analyst

  Using predictive models, long term value analysis, and strategic variable targeting. We select the best donors to engage with your not-for-profit via direct mail fundraising. Responsibilities: Build targeted mail selects for our clients Build new analytical reports for both our clients and internal team members Build, update and improve SSIS packages for client data loadsAccomplishments: Immediately upon hire built SSIS package to transform data from our client that had just converted to Blackbaud CRM Streamlined marketing select queries for increased efficiency Delivered several executive level analysis reports to client Created a BI Dashboard suite for clients planned giving program Show less

• 

  Georgia Tech Foundation, Inc.

  Jan 2019 - now

  One of the key personnel for the implementation and execution of the Blackbaud CRM product to Georgia Tech. Responsibilities: Supervise support and training staff. Recruit new staff. Utilize Page Designer to created custom functionality. Develop light query view customization to enhance functionality. Design and Create Training Material for Fundraising Staff and Administration Users. Deliver Training to Fundraising Staff and Administration Users. Interface with Application Development Team in a Business Analyst role to insure business requirements are met. Interface with Business Users to Collect Business Requirements and translate to technical requirements for the Application Team.Accomplishments: Learned how to create custom listbuilders, datalists, and global processes in Blackaud CRM. Utilized page designer to create custom functionality for our end users exposing instance access instead of general access to certain global change processes. Implemented a new helpdesk platform Freshdesk. Lead the recruitment and hire of a new Training & Support Specialist for my team. Quickly familiarized myself with The Georgia Tech configurations with CRM and built a training program from scratch within a couple of months from starting. Designed and implemented remote training program. Trained around 200 end users for introduction training in a classroom setting. Recorded Classroom Based web learning videos. Developed several executive reports and dashboards in Power BI and Excel. Implemented automation tools to help my team be more productive. Show less

  • Director of Enterprise Systems and Business Analysis

    Jul 2024 - now

  • Director of Business and User Services

    Jan 2019 - Jun 2024