Andrew Dubin

Experience

• 

  California Tortilla

  Oct 2014 - Apr 2016

  Cashier

  • Took customers’ orders. Dealt with customer grievances, mistakes, or refunds. Ensured customer experience was satisfactory to maximize potential of repeat business.• Ran report at end of shift to determine cash sales. Reconciled cash in drawer against report.

• 

  Artery Capital Group LLC

  May 2016 - Aug 2016

  Data Intern

  • Digitized accounting records of the group. Organized files by entity; sub-organized by date Results allowed Artery to save storage costs and have ready access to past financial records that could then be used in analyzing corporate performance to target elements for improvement or continuation.• Determined whether boxed paper files should be kept or destroyed• Created a booklet for the office art collection in Adobe Photoshop. Listed the artist, dimensions, name, and date alongside a picture of the piece. Booklet used for collection showcasing. Show less

• 

  Investing Daily

  May 2017 - Aug 2017

  Data Intern

  • Recorded stock recommendations into Excel from two portfolios spanning seventeen years. Recorded purchase date, sell date, and sell price recommendations. Project enabled company to have ready access to substantial data to utilize in advertising success of company recommendations to potential customers.• Input data into Excel on success of seasonal returns versus annual returns of company’s stock recommendations. Used these data to advertise seasonal stock recommendations.

• 

  Business Management Daily

  May 2018 - Aug 2018

  Data Intern

  • Tabulated hundreds of feedback surveys for Admin Pro Forum and Labor and Employment Law Advanced Practices Symposium. Calculated scores for each portion of the conference, to be used for future program improvement.• Researched conference attendees for potential future marketing partnerships.• Proofread state-specific HR Specialist: Employment Law monthly newsletters.• Contacted existing BMD customers to explain latest benefits included in their subscription.• Scrubbed customer database to update information and remove redundancies. Show less

• 

  Business Management Daily

  May 2019 - Aug 2019

  Data Intern

  • Cleaned and updated numerous Excel spreadsheets containing large quantities of customer data to enable import into newly licensed Outreach Sales Engagement Platform.• Assisted Director of Sales in designing sequencing strategy for customer contact to increase probability of positive response.• Analyzed data on executive customers to target potential sales of other products.• Aggregated data on webinars created and conducted by BMD. Data included registrations, attendance, subscriptions and customer feedback. Created Tableau visualizations to assist BMD in making business decisions on which webinars to continue as is, improve, or discontinue.• Customized auto-emails to be sent to customers.• Conducted external research on possible conference sponsors. Show less

• 

  Arlington County

  Feb 2021 - now

  Business Systems Analyst

  • Systems Administrator and Enterprise Manager for Arlington County's Homeless Management Information System (HMIS)• Project Lead on the Continuum of Care Report Card, a quarterly and annual program demographics and performance metrics tracker using data pulled from HMIS. Improved process by creating Python script automating data extraction and processing.• Developed a Python script to automate data transformation and calculations for monthly submissions to a nonprofit partner for funding purposes.• Constructed a racial disparity report using Python. Report analyzes client racial demographics, income, and program exit destinations during specific timeframes. Results are used to equitably support various communities.• Manage and process data requests for reporting purposes. Data are provided for State, Federal, and Non-Profit funding purposes, and must comply with Federal and State regulations.• Conduct data audits to identify problem areas and maintain data integrity.• Provide trainings, guidelines, and technical support to case workers and non-IT partners for HMIS operation and reporting purposes. Show less