cwandrews_resume
TRANSCRIPT
Christopher W. [email protected]
7318 Red Bank RoadWesterville, Ohio 43082(614) 565-6755
Career Objective: Looking for a data engineering and/or development position. I enjoy and am
good at coming up with creative solutions and consistently improving myself and my work. I mainly work in Python but am confident that I would be able to learn and use new languages and technologies effectively.
Regarding Python I have experience with the following: Data processing and typing Comprehensions (dict, list, set) as well as other Python idioms Generator expressions (“lazy processing”) and decorators
(wrappers) Good naming conventions for code readability as well as docstrings Unit and functional testing (pytest, unittest, and hypothesis) Logging, exception handling, and troubleshooting Scripts, command line tools, and GUI programming SQLite, Postgres, and NOSQL document databases (RethinkDB)
directly and using an ORM package (SQLAlchemy) Scalable automation
Please check-out my GitHub profile to see actual work:https://github.com/cw-andrews
Projects/Contributions:MegaSchemaBuilder
Description: Standalone Python tool for delimited files (CSVs) to analyze and
typify file encoding, formatting, the datatype of individual fields, as well as max field lengths for individual field lengths. Built with a GUI allowing users (Technical Support Staff) to quickly analyze one or more files and generate a schema.ini file detailing field names, datatypes, and max field lengths (rounded-up for margin of error).
Utility: The existence of a schema file for an individual flat file allows
utilization of Microsoft Jet Database and therefore select statements when loading inventory, sales, and service data into our primary database, that being Microsoft SQL Server. Not only does this allow technical support staff to filter the data going into the database, it also allows the composition/manufacturing of new fields from those in the file.
CSVSanitizerDescription: A robust and reusable pre-processor which can be scheduled as
well as run on demand to sanitize and normalize files with abnormal formatting, encoding, and/or corrupted data. Using this program to sanitize files allows data to be loaded into the database successfully which otherwise would either contain errors (broken URLs, incorrect VINs) or cause data loads to outright fail. Includes integrated logging using a timed-rotating file handler and located near near it’s associated file for quick access and troubleshooting.
Utility: Allows quick-integration of third-party data providers and vendors
which would otherwise require weeks of back-and-forth about what is wrong with the file they are sending as well as how they should fix it.
Education:
❖ Bachelor of Arts in History (December, 2013)The Ohio State University (Columbus, Ohio)
▪ Phi Alpha Theta National Honor Society in History
Work Experience:
❖ Senior Technical Support AgentAutoSweet (April, 2014 - present)
AutoSweet provides inventory management and marketing solutions for automotive dealerships. I work in the support department to set-up, maintain, and provide technical support for AutoSweet employees, direct customers, and third-party vendors.My responsibilities include:
Responsible for setting-up, maintaining, and troubleshooting AutoSweet inventory, sales, and service data polling operations. Additionally, I am required to modify data processes based upon dealer and third-party vendor requirements, as well as ensuring the processes are as automated as possible.
I also work to resolve dealer and vendor issues via phone and email on a case by case basis. I must separate the pertinent information from the impertinent, troubleshoot the issue, and offer explanations which customers and third-party vendors can understand.
Experience with a variety of Dealer Management Systems (DMS'), including Reynolds & Reynolds, ADP (now CDMK Global), and Dealer Track. I regularly work to set-up and maintain data polling from these DMS' as well as a variety of others.
Technologies and programs I work with include but are not limited to:
• Daily use of Microsoft SQL Server for inserts, updates, stored procedures, and advanced select queries.
• Microsoft Jet Database for loading to our database.• Powershell, including customization and scripting.• SSH tunnels for remote connections, polling via Telnet, etc.• VPN clients including Cisco VPN Client, Microsoft VPN, etc.• Setup, scheduling, and modification of exports (inventory, sales,
service).• Writing of data pre-processors (Python), .ini config and schema files,
etc.• Extensive experience developing and writing quality documentation
for complex processes and workflows.• Salesforce Service Cloud for case and issue tracking.
❖ Sales ConsultantOfficeMax: Store 0475 (Westerville, OH) (July, 2010 – February, 2014)
• Sales leader - demonstrated consistent and judicious sales ability.• Sales coaching - responsible for teaching sales to others.• Work with planograms, signage, and D&D returns.
Volunteer Experience:
❖ Vineyard Kids Leader Vineyard Columbus (August 2014 - Present)
• Deal with issues as they surface and one at a time, often in overwhelming situations.
• Gained appreciation for regularly giving-back to the community.
❖ Tutoring: Cincinnati Public Schools, Taft Elementary (grades 1-6) Imani Family Center: After-School program (April, 2008 - May, 2009)
• Effective teaching of various skills including mathematics, writing and reading comprehension.
• Demonstrated ability to work effectively in multiple environments and situations.
References:
❖ Jim Pryor, Independent Python [email protected]
❖ Sarah Nerad, Director of RecoveryThe Ohio State University n [email protected] (614) 292-0744
❖ Kevin Hill, Customer Support [email protected](614) 459-3558 x 2