Current Position: Data Engineer at Jellyvision. I'm well-acquainted with Ruby, Angular, JavaScript, HTML, CSS, SQL (sqlite3 and PostgreSQL), Sinatra and Rails frameworks, ActiveRecord ORM, jQuery, RSpec, AJAX implementation, and have experience in working with external APIs through OAuth and OAuth2, namely Twitter and Facebook's Open Graph. I have additional experience working with Masonry and Susy grid frameworks, Compass, Sass, Bootstrap, and Grunt. Previously, I have around two years of experience in Editorial workflow working for Groupon in the Site Admin department and am currently in Chicago. During my tenure at Groupon the company has grown from 2,500 employees to over 12,000 worldwide. I have been involved in numerous beta tests, training, and workflow assistance for transitions in the deal creation process as the company continues to expand, all while maintaining a high productivity and low error rate, completing on average 400 to 500 deals per month. Outside of Groupon, I've been involved in theatrical productions and arts education, directing and assistant directing plays, teaching in area high schools, and acting in numerous Non-Equity productions across Chicago. Throughout my theatre career and education, I have over ten years of experience in deadline-oriented workflow and project completion. Proficient in Word, Excel, PowerPoint; Pages and Numbers for Mac. In addition, proficient in the use of donor software such as Donor Perfect and eTapestry. Carpentry, former SAFD Certified Actor-Combatant in Knife, Unarmed, and Rapier-Dagger, Classically Trained, Sketch Writing

Data Engineer @ From March 2015 to Present (10 months) Greater Chicago AreaSoftware Engineer @ - Front-End and App development across various systems, namely for Channel IQ's client-facing Portal. - Construction of new implementation of Product Search Catalog UI, utilizing Angular, Kendo, and additional UI tools/ libraries such as Bootstrap, Sass, Compass, Masonry, Grunt, and Jasmine testing. - UI work for launch and beta of Where To Buy program. Built variety of charts for analytic reporting via Kendo. Third-Party JavaScript delivery and .NET web services including use of multiple external APIs, including Google Maps. From July 2014 to March 2015 (9 months) Greater Chicago AreaData Acquisition Engineer @ - Repair and development of currently running and new data collection bots. - Construction of internal testing tools and implementation of data collection on QA and Production Servers. - Provided and developed automated solutions for process improvement related to data collection, Git workflow, and Agile processes. From February 2014 to July 2014 (6 months) Teacher's Assistant @ 9-week intensive Web Development course. Additionally assisted students on Ruby, Sinatra, Javascript, jQuery, HTML, and CSS fundamentals. From July 2013 to October 2013 (4 months) Quality Assurance Editor - EOD Checker @ - Communicate daily with several internal departments to verify and optimize city's schedules are correct on backend of site. Additionally checked city's email pre-flights/blasts and verified subscriber counts for each deal. Mentioned in All-Hands meeting for subscriber error that would've prevented deal being received by 900,000 subscribers. - Coordinated launching of Prefeature Program within editorial, assuring early completion in all prefeature markets. - Mediate between editorial and external department policies to quickly resolve concerns that would prevent deal completion. Help develop editorial department policy to alleviate workflow hold-ups. - Trained peers on End of Day Checks processes. Assist in company transition of Checks responsibilities. - Led initiatives to reduce merchant payment errors from over 250 errors to less than 20 per month. - Runner-up for Editorial Employee of the Month, Nov. 2012 for assistance in pre-feature deal completion and tracking of deal estate errors. - Assisted in automation of checks and QA role. Created documentation of Deal Estate errors. Assisted in master deal creation for National cloning. - Finished automation of stage February 2013. From November 2011 to February 2013 (1 year 4 months) Quality Assurance @ - Validate and manage data that the editorial team has created for each daily deal in the United States and Canada as the final step in the web-facing Groupon deal creation process. Act as final backstop to protect customer and merchant relations while adapting to high fluctuation of company workflow. - Lead final check on issues/concerns with Editorial, Sales, and Development departments while maintaining a high productivity and low error rate (under 2% on average) consisting on average of 500 deals a month. - Testing and troubleshooting of various deal-creation solutions, including automation programs. - Led shadowing sessions and webcasts on Salesforce.com and the backend of Groupon.com. Shadowers included Larry Lyons in Competitive Intelligence at Groupon; Ryan Miller, director of Deal Factory; Betsy Ziegler, consultant, Kavita Kochar, Product Manager, & Hoyoung Pak, SVP of Operations. From November 2010 to November 2011 (1 year 1 month) Greater Chicago AreaDevelopment Intern @ - Coordinated donation requests for the Blue Moon Ball (annual fundraising gala); Collected donations from Midwest businesses; Oversaw Silent Auction, solidifying Chicago Dramatists achieving their fundraising goal. - Edited grant-writing proposals for funding of new American theatre works; Presided over donor research, record management, and composition of donor thank-you letters. - Managed data, reports and queries with eTapestry; Guided ticketing and sales for productions, classes, and donations. From January 2010 to June 2010 (6 months) Greater Chicago AreaActor - "The Body Snatchers" @ Appearing in "The Body Snatchers" as Nick Grivett. Adapted from Jack Finney's novel and directed by Paul Edwards. From February 2010 to April 2010 (3 months) Circulation Desk Assistant @ Checked in books, assisted account inquiries, organized books. From June 2007 to February 2008 (9 months)

Bachelor of Science, Theatre @ Northwestern University From 2005 to 2009 High School Diploma @ Cypress Falls High School From 2001 to 2005 Andrew Jorczak is skilled in: Editing, Acting, Theatre, Ruby on Rails, Ruby, Facebook, Social Media, CSS, Git, Github, Creative Writing, Sinatra, jQuery, AJAX, Test Driven Development