BILL CARLTON
Ankeny,IA
Overview
5
5
Years of wrangling data and automating processes
Summary
Proactive Data Analyst skilled in communicating complex data and enhancing business processes through technical solutions. Knowledgeable liaison between technical and non-technical stakeholders, who uses Python, SQL, and data analysis tools to reveal actionable insights and achieve business outcomes. Self-motivated learner eager to contribute in a role that fosters innovation and growth.
Skills
Retrieves and manipulates data via SQL queries and API requests
Scrapes and evaluates data with Selenium and spaCy
Explores data and discovers business insights with Pandas
Creates Microsoft Power Apps applications to expose data
Manages and organizes data in Microsoft Excel and SharePoint
Automates exacting tasks and data processes with Python
Streamlines workflows and communication via Microsoft Power Automate
Communicates and aligns business outcomes with technical requirements
Recent Project
Executed a data migration from Smartsheet to Microsoft SharePoint via Python scripts and APIs. Leveraging automation greatly reduced the project completion time and increased data accessibility.
Work History
Data Analyst – Contractor
Cisco Systems, Inc.
10.2020 - Current
- Developed Python scripts to clean and structure data, resulting in improved data integrity and countless work hours saved
- Performed SQL queries and called API endpoints to increase data accessibility for business stakeholders
- Scraped web pages with Selenium and identified issues to correct, reducing resolution time and customer tickets
- Generated reports with Pandas to understand customers’ priorities and better direct team’s efforts
- Designed and maintained SharePoint sites and libraries to manage and display data for a technical training catalog
- Coordinated with business stakeholders and engineers to implement new user stories and expand database schemas
Technical Editor – Contractor
Cisco Systems, Inc.
07.2018 - 10.2020
- Developed Python scripts to automate tasks and manage a technical training catalog, increasing team availability for new projects
- Used Pandas and Git to generate quarterly reports, greatly reducing reporting work time and providing a data backup
- Scraped web pages with Selenium, collecting and organizing data to recommend personalized training for technical audiences
- Leveraged the Smartsheet API to create and populate Smartsheet sheets and reports, resulting in increased data integrity and accessibility
- Collaborated with customers to design customized curricula based on technical training needs
Audiovisual Editor – Contractor
Cisco Systems, Inc.
10.2011 - 07.2018
- Created web pages and Microsoft Excel spreadsheets to organize projects
- Produced polished presentations on technical subjects
- Performed research to ensure content accuracy
Education
Master of Arts - History
01.2016
The Master of Arts in History laid a strong foundation in researching, analyzing diverse information sources, synthesizing distinct perspectives, and summarizing conclusions, while accounting for complexity and nuance.
Bachelor of Arts - History
01.2010
Timeline
Data Analyst – Contractor - Cisco Systems, Inc.
10.2020 - Current
Technical Editor – Contractor - Cisco Systems, Inc.
07.2018 - 10.2020
Audiovisual Editor – Contractor - Cisco Systems, Inc.
10.2011 - 07.2018
Iowa State University - Master of Arts, History
Clearwater Christian College - Bachelor of Arts, History
Similar Profiles
Mohammad Shoeb ShaikhMohammad Shoeb Shaikh
Software Engineer Leader at Cisco System India Pvt. Ltd and Cisco Systems Poland Sp. z o.oSoftware Engineer Leader at Cisco System India Pvt. Ltd and Cisco Systems Poland Sp. z o.o
Pankaj RainaPankaj Raina
Team Lead,Escalation – (HTTS) at Cisco Systems, Inc.Team Lead,Escalation – (HTTS) at Cisco Systems, Inc.
Kanav SharmaKanav Sharma
Technical Consulting Engineer at Cisco Systems, Inc.Technical Consulting Engineer at Cisco Systems, Inc.
Cooper LuceCooper Luce
Sales Business Development Executive - IIoT at Cisco Systems, Inc.Sales Business Development Executive - IIoT at Cisco Systems, Inc.
Daniel EllisDaniel Ellis
Hvac Automation Programmer at Basepoint Building AutomationHvac Automation Programmer at Basepoint Building Automation