Sandra Nesmith
Overview
26
26
years of professional experience
Work History
Senior Data Analyst
CTM Media Group
07.2012 - 11.2024
- I was responsible for maintaining and upgrading various Access databases that supported key business operations, including Time and Attendance, Brochure Inventory, and Logistics
- Through these efforts, I streamlined processes, ensuring accuracy and efficiency across critical business functions
- I then collaborated with off-site international developers to migrate these databases to a MariaDB SQL server, hosted in the cloud
- As the main point of contact during this transition, I communicated our needs, tested completed processes, and ensured there was no interruption in service to end users
- During this migration, we added two additional databases: Expenses and Fill Charts/Data Warehouse
- These upgrades significantly enhanced data accessibility, improved workflows, and provided better reporting capabilities for the business
- I also helped support the drivers with troubleshooting technical issues with the tablets to determine if it was an equipment issue or a software problem and guide them through the next steps
- Additionally, I have supported multiple acquisitions by analyzing data for due diligence, importing data into our systems, and assisting new employees in learning our systems
- I regularly created ad-hoc reports for various departments using Heidi SQL and Access databases with an ODBC connection
- I also assisted Operations daily with inventory corrections and closing routes, while maintaining data across multiple databases
- My daily tasks involved using Access and Excel, leveraging advanced functions such as pivot tables, VLOOKUP, XLOOKUP, and macros to optimize data analysis and reporting
Applications Analyst/ Billing
DST Output
08.1998 - 03.2012
- I was initially hired as an Inserting Machine Operator, but quickly took on additional responsibilities by assisting the office team with closing jobs during quieter production periods
- This allowed me to gain experience with the ASI and MK systems
- When a position in the Billing Department became available, I leveraged this knowledge to transfer into the role
- There, I handled data entry across multiple systems (MK, ASI, AXIA), reviewed contracts for billing accuracy, and collaborated with the Accounts Receivable (A/R) department to ensure timely payment processing and issue credits as needed
- Additionally, I created reports, organized files for the billing system, and helped develop an Access database that improved the efficiency and accuracy of file uploads
- I also gained experience in extracting data from the database to streamline business processes
Timeline
Senior Data Analyst
CTM Media Group
07.2012 - 11.2024
Applications Analyst/ Billing
DST Output
08.1998 - 03.2012
Similar Profiles
Jesus BritoJesus Brito
Truck Driver at CTM Media GroupTruck Driver at CTM Media Group
Amber AbramAmber Abram
Vice President of Digital Programs at CTM Media Group (Ettractions, Inc.)Vice President of Digital Programs at CTM Media Group (Ettractions, Inc.)
Carmelo TolingCarmelo Toling
Senior Sales Manager at CTM Ventures and Equity Group Inc.(Citimotors Inc)Senior Sales Manager at CTM Ventures and Equity Group Inc.(Citimotors Inc)
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino
Gopala ChandraGopala Chandra
Senior Consultant/Senior Data Analyst/Data Science Specialist at Gopala RSenior Consultant/Senior Data Analyst/Data Science Specialist at Gopala R