***** ******* ***** ***. ****** Alcazar 773-***-****

Steger, IL 60475 adjk5h@r.postjobfree.com

Technical Experience

• Java, Python.

• SQL: RANK, DENSE RANK, DECODE, CASE, SUBQUERY, UNION, DISTINCT, COUNT, LEFT OUTER JOIN, SUM, outer applying tables, post-query calculations. Strong understanding of primary keys, especially effective dated tables.

• Excel Skillset: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, pivot tables, conditional formatting.

• Additional (Limited) Skillsets: HTML, CSS, MS Access, PeopleSoft, SSMS, SSRS, EDW, AutoHotKey, Mainframe scripting, Erlang Employment

Analytics Coordinator Northwestern Medicine Feb. 2016 – Aug. 2019

• Workflow analysis, optimized implementations, ad-hoc data reporting, PeopleSoft SQL query development.

• Built PeopleSoft queries to automate 120+ weekly and monthly employee list and audit reports with IT Department.

• Project - Multi Prompt Queries - Development of various queries in PeopleSoft and EDW with multiple optional prompts.

• Project – Company-wide Employee Hierarchical Reports-to Mapping - Custom actives table in PeopleSoft and EDW to allow for queries capable of pulling a complete company-wide manager hierarchy. Table allows for the fast data extraction of questions similar to “all employees that roll up to” a director/VP. Invoice Analyst / Accounts Receivable Anixter Inc. Feb. 2014 – Feb. 2016

• Department-wide balancing of payments, payment application, research and back up retrieval.

• Excel template and VBA macro development. Trained employees on use and developed how-to guides for future training.

• Project - Invoice Selection Automation - Multi-language macro solution for invoice selection in the mainframe. Full automation resulting in over 30 times manual invoice selection speed.

• Project - Invoice Comparison Template - Intuitive invoice-matching template designed to resolve large payment discrepancies. Capable of comparing thousands of applied invoices against a remittance within seconds.

• Project - Employee Hours Google Sheet Template - Development of a privatized Google Sheet for employee activity tracking. Prior open format caused employee dissatisfaction. Data Entry Berkshire Refrigerated Warehouse Feb. 2013 – Sept. 2013

• Receipt and purchase order entering, document printing, scanning and archiving.

• Project - Automated Receipt Entering - Macro-assisted receipt entering. In addition, purchase orders were cross-referenced against a client’s list, preventing unexpected goods from entering the warehouse, limiting the company’s financial liability.

• Project - Billing Calculation Script - Development of a billing script used to calculate thousands of client charges. Prior to this automation, the on-demand nature of the business required them to be manually calculated on a weekly basis. Education

Chicago, IL Loyola University Chicago Aug. 2019 - Dec. 2020

• Bachelor’s degree in Computer Science. Final GPA: 3.879

• Minor in Mathematics

• Computer Science Tutor – Fall 2020

• Notable Courses: University of Kent (UK) Introduction to Artificial Intelligence, Functional Programming (Erlang). Chicago, IL Harold Washington College Dec 2018

• Associate degree in Computer Science.

• Notable courses: Advanced Physics, Japanese, Introduction to MS Access.

• Academic Tutor: Mathematics including Calculus, Chemistry, Physics

Contact this candidate