Andrew Badger Email & Phone Number

Lewisville, Tx, Us

Southlake, Texas, Us

Documented and refined a method for organizing information for market programsHelped to exceed expectations of a program and reduce the backlog to nonexistent numbers exceeding the yearly goal by more than 20%Performed in-depth Data Quality work in Salesforce via Data Scrubbing/cleaning daily for a large-scale scheduling project for American Express. Performed weekly data analysis to verify businesses that required further analysis based on external factors. Common issues encountered included bad location data, strange business names, and businesses listed as residential buildings. Performed Data quality work that could not be done using automation tools by using specific GIS Data to verify business informationReviewed and removed 1.25 million records for successful field visitsFocused on identifying low-success industries for lead optimization

Southlake, Texas, Us

Processed Part-time job applications in Workday to allow employees to constantly apply to jobs in multiple marketsCreated internal job postings in Workday for multiple positions in a variety of marketsResolved Multi-Factor Authentication issues for employees using Salesforce Authentication Created new assignments and projects in Salesforce for sales staff through Excel using pivot tables and VLOOKUPS. The data was then uploaded back to Salesforce through Excel and altered to match assignment requirements. Automated Password management procedures

Wichita Falls, Texas, Us

As the Systems Administrator, my primary responsibility was to ensure smooth dailylibrary operations by maintaining the Integrated Library System Horizon (ERP/Database software for libraries) I managed this by producing reports for other departments, including compiling statistical data. I also provided technical support, ensuring a quick response and resolution to problems, collaborating with IT when necessary to support application development, networking systems, and installing upgrades. My previous experience with databases, excellent communication, and organizational skills, and drive to remain on top of current technologies have helped me troubleshoot and support ongoing application development. I have been successful at this job as I have completed these tasks, learned how to do new things, and discovered where I excel with technology and working relationships. I have mastered the ability to know where to look and specifically what to search for in a knowledge base providing in-person technical support for a variety of patrons while maintaining professionalism in difficult situations.Some Specific work accomplishments include:• Updated an SQL code repository by deleting old code and renaming files to better reflect the results of the code when run. This included hardening the existing code and making sure that new queries were added• Ran set SQL reports in Desktop MicroStrategy that were delivered to individual staff members automatically to reduce the load set on the morning SQL reports• Ran Circulation Reports which were Set SQL Reports that involved creating notices and processing the previous day's data into usable reports and data for statistics• Did yearly statistics broken up into monthly increments including statistics on our WIFI usage and gate count• Ran Day End SQL statements and print out reports in the morning to allow for various departments to function.

Shreveport, Louisiana, Us

As a cataloger, my job was to take materials that the library had received/purchased and then make them accessible to patrons in an online database by creating or modifying bibliographic records that contained descriptive metadata detailing basic information on an item, Making it discoverable within the library's online catalog as a new resource or additional copy. As a cataloger, I processed about 175 carts of materials, creating database records for over 17,500 items. The item types I cataloged include Regular adult books of multiple genres, Non-fiction books, Large print books of multiple genres, Juvenile Books, Picture books, Juvenile readers and non-fiction books, Young adult fiction and non-fiction books, Playaways, Reference materials, Graphic novels, DVDs both films and TV series, Music CDs, Audiobooks, Blu Rays, and Genealogy Materials. When cataloging these materials, I followed a process where I looked for records within a cataloging database, selected one, and then edited the available metadata to meet the standards of the Shreve Memorial Library. If I could not find a record then I would create a new one as needed following the libraries cataloging guidelines.When all the records had been edited and reviewed by my supervisor, the labels for the items were then printed and the records uploaded to the catalog. The items were then passed onto another member for further processing. Occasionally, there were projects within the department where we worked collaboratively to get backlogged materials out. Projects included cataloging a backlog of DVD films and TV series and focusing on a set collection of materials piled up and requested by patrons. These projects helped me to improve my cataloging skills and get older materials out of the department. While working in this position, I continued to develop my Taxonomy skills and gained more experience working with Integrated Library Systems and the Microsoft Office Suite.

Canton, Oh, Us

In my role at Stark, I helped patrons with various circulation issues, provided reference services, and processed items for holds at various library branches. That included finding and retrieving items for inter-library loan processing. I would frequently help open and close various library branches by cleaning up different areas, following shutdown procedures, pulling holds before opening, and checking any materials turned in overnight. Some of my work activities include• Issuing patrons new library cards and updating accounts in the Integrated Library System.• Checking out items to patrons and checking them in when they are returned.• Processing holds and inter-library loans and distributing them throughout the system, handling over 100 items a day. • Process missing items and adjust accounts to notify patrons of the item.• Help with partially returned items and mark them in systems/edit them when the full item is returned• Help with a DVD/Video Game vending machine that would occasionally jam or have issues dispensing discs• Assisting patrons with automated checkout procedures.• Working to find lost and overdue items on the patron's accounts.•Managing the ILS System Sierra, expanding my knowledge of various ILS Systems/ databases as a result. • Referring patrons to appropriate services and staff members for complex procedures.• Helping patrons with the library catalog, printing, scanning, faxing, and photocopying. • Performing research in multiple databases to find information for patrons.

Kent, Ohio, Us

In my role at Kent State, I organized and streamlined data throughout several databases. I created workflows to help catalog information throughout the library. I also integrated new and uncatalogued materials into the catalog. I utilized specialized software to do this called an integrated Library System which gave me experience managing documents for an academic library. Some achievements include • Providing easy access to critical information within the database. • Slashing document discovery downtime. • Accepted and helped to process new FDPL materials into the collection, working with shipping lists• Recognized by senior management for exceptional communication skills and escalation resolution. • Overlaid and supersede duplicate information to purge the database of outdated and unnecessary resources. • Updated/transformed the entire GOV DOCS CD Collection into a digital library by finding/using both the virtual CD-ROM library and the USGS publications warehouse to update older PDFs with new information and link to full copies of the original data files. • Performed copy and original cataloging for government documents and print monographs using OCLC and Innovative Millennium. • Preserved a collection of rare 19th-century geological records by creating a digital library with high-quality PDF scans of the documents from a government website. • Gained knowledge of OCLC, SUDOC, RDA, LSCH, MARC, Innovative Millennium, Catalogers' Desktop through practical applications.• Fixed and repaired broken web links within catalog records monthly, allowing users to easily locate the information they are looking for within the library's extensive database. • Discovered multiple government databases with accurate information to utilize in the replacement of aging, underutilized physical documents. • Worked with an Integrated Library System (ERP/Database software for libraries), learning how to perform document management at a master's level and develop workflows.

Stow, Ohio, Us

In my role at the library, I assisted library patrons by providing training, education, and assistance with the library's computers and locating different resources throughout the library environment. When teaching patrons about the library computers, I frequently instructed people on how to access online cataloging systems to research and find desired items. During my practicum, I learned about the different departments in a public library and observed how work is performed in them. This included learning more about how the circulation department works, how book clubs at a public library function, how the children's department works, the procedures surrounding notary and passport services offered at the library, and the processes that tech services follow to prepare items for the library collection.During my time there, I helped and participated in a previously planned Harry Potter night where I learned how library programs function and the planning and work required to succeed. At the end of the practicum, I created a website detailing everything I had done, reflecting on my experiences, and drawing conclusions on what I had done. I also learned how Integrated Library Systems work and led a project where I worked with the local history librarian to digitize several rare films, preserving them for future generations to view and enjoy.

Wooster, Oh, Us

Worked within multiple dining halls, helping to serve food and maintain the dish-washing area of the kitchen. Before opening the dining hall, any leftover materials from lunch/meal prep were washed and put away or utilized by the kitchen staff as soon as they were dry. Brought in the dishes from the main dining room and washed them by rinsing them off and putting them through the dishwasher. Once the dishes had been run, they would be put on carts and taken back out to the dining area. At the end of the night, any remaining dishes were put through the dishwasher, and then serving utensils and trays used during food preparation and serving would be washed, and then put away. Each shift ended with the dishwasher being drained, cleaned, and shut off for the next day's use.

As a student at Wooster, I joined a local Coffee House called Common Grounds where in addition to regular shifts throughout the week and weekend I served as the Social Media Manager for a year and then as the Inventory Manager.As the Social Media Manager, I Maintained the Facebook page, ensuring that consistent, accurate information was published and that information about Common Grounds reached the public by posting events on various social media platforms As the Inventory manager, I ordered supplies from Hospitality services and delivered them to the house. I also kept track of inventory and made a list of what we needed to get for the program. If we ran out of an item during open hours, I would replace it ASAP so service could continue. Occasionally went to the local party shop and Wal-Mart to purchase new materials for that week and supply the baking crew with needed ingredients.

Master Of Library & Information Science (M.L.I.S.)

Bachelor Of Arts, History & Film Studies