Amanda Rorabaugh Email & Phone Number

New York, Ny, Us

Jersey City, Nj, Us

Charlotte, Nc, Us

Designed a normalized SQL Server database and used Python to automate data collection for an enterprise-wide data protection web-based product used by over 3,000 application owners and delegatesLeveraged Python, Perl, SQL Server, and Alteryx for manipulating data sets and created Tableau data visualization reports, reducing internal consumers’ manual work by an estimated 80 hours per monthPresented finished data visualization reports to upper management audiences of 20-30 people, as well as research projects with extracurricular employee networks to audiences of over 200 peopleImproved data quality by extracting, transforming, and loading (ETL) data via Python scripts, replacing client’s previous system of manually combining and correcting CSV files

Charlotte, Nc, Us

Conducted data analysis on remote storage business operations data to help create dozens of interactive web reports in the storage centralized reporting website, which receives over 30,000 visits per monthStandardized formerly regional reporting efforts into one global dashboard that calculates and displays health ratings for 28 data centers across the worldAutomated vulnerability reporting on 2,200 storage devices by designing a dashboard and the needed processes to gather incident ticket data, then running daily stand-ups for development of the dashboard

Gainesville, Florida, Us

Assisted an average of five students weekly in becoming competitive candidates for professional internships by revising resumes, practicing elevator pitches, and conducting mock interviews

Charlotte, Nc, Us

Created and documented business requirements, workflow, and screen mock-ups for the development of an enterprise-wide central software repository systemLead a team of three in a SQL project that extrapolated data from three security databases and created consolidated tables matching patches to their respective defects and execution details Performed gap analysis on information security data to identify technology standard violations that were previously not being addressedConducted user acceptance testing to ensure Bank of America’s cloud-based application hosting service satisfied business requirements and defects were resolved prior to deploymentVoted first place out of ten teams in "High Impact Low Technology" national intern case competition

Chapel Hill, North Carolina, Us

Collaborated with 12 other students across eight universities using Basecamp software to strategize marketing the Graduate Management Admission Test, 96 Elephants, and International Volunteer HQOrganized and executed marketing events throughout each week to increase brand awarenessUtilized social media to compliment these events and promotion

Chapel Hill, North Carolina, Us

Digitized tracking for sales calls by transitioning from paper tracking to cloud reporting on mobile devices leading to an increase in efficiency and communication between sales teammatesAttended the Sales Foundation Academy, a week-long training in Chapel Hill, NC, to learn a variety of sales techniques and relationship-building approachesWorked with the University of North Florida sales team daily to create strategic marketing campaigns for local businesses and uncover business needs through asking questions and listeningReceived the “Blue Collar Award” for averaging 35+ sales calls per day

London, Gb

Reinvented the digital sales tracking system used for daily operations through advanced use of Microsoft Excel and Visual Basic programmingCreated and documented processes for sales operations to streamline workflowAnalyzed the sales pipeline and strategies utilized by the marketing department in order to create sales reports displaying cohort analysis

Master Of Science, Analytics

Bachelor Of Science In Business Administration, Bachelor Of Art, Information Systems And Operations Management, Economics

Education record