Joel Lipkowitz Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, United States

• Create and maintain 100+ SOPs for Capital, Operation Budgeting, and Management. Reporting modules to increase productivity on daily tasks by over 50%.• Manage 20+ projects every 2 weeks across 12+ different clients. • Learned Strata software effectively becoming a SME in Capital projects in 6 months.• Develop custom SQL scripts to calculate budgets for Capital projects up $3M.• Build Data Extracts, and custom SQL views to help analyze $500k to $1M budgets.• Design Income Statements, and Balance Sheets to help clients analyze monthly P/Ls.• Troubleshoot Pivot Tables, Ad Hoc Reports, and Workflow errors.• Build relationships with Accountants, Managers, and Finance Directors meeting together via Zoom to discuss requirements, achieving milestones, and analyzing budgets.

Greater Chicago Area

Lincolnwood, Illinois, United States

• Led Full Cycle A/P, 2k+ invoices/month averaging $1M+• Created and maintained 50+ SOPs for Finance Dept to increase productivity on daily A/P tasks by over 50%, and trained 3 new staff effectively.• Communicated with Logistics weekly to solve challenges on open POs averaging over $40k each for accuracy and completeness.• Negotiated, and researched cost savings to save $20k+/year on internet, and $6k+/year on utilities, and researched OCR to cut processing time by 30%.• Lead A/P team in NetSuite Implementation from Quickbooks Desktop.• Analyzed credit card spending with Pivot Tables, and VLookUps to save $1k+ per quarter.• Recovered $100k+ from contested invoices for old AP accounts.

Lincolnwood, Illinois, United States

• Ensured payments (invoices, expense reports, check requests) for 5 different healthcare locations were processed timely and accurately. • Reconciled 50+ accounts each month to ensure correct billing. • Processed Full Cycle A/P, up to 150 invoices/month averaging $200,000. • Improved 15+ SOPs to increase productivity on daily A/P tasks over 50%.

Skokie, Illinois, United States

• Troubleshoot, diagnose, and resolve technical issues of hardware, software, and WiFi. • Advise customers on what products to purchase to solve their problems. • Resolve dozens of customers concerns with calm, relaxed communication. • Document troubleshoot processes and customer feedback

Chicago, Il

•Led department-wide migration of over 100 projects from CA to TFS via SharePoint, converting the two week project life cycle from Waterfall to an Agile/Scrum model. •Gathered requirements from over 80 outside agencies, 400 to 8000+ members, and internal departments to develop reporting solutions for standard and custom company data formats. •Eliminated blockers for team of 8 developers on 10 projects each release cycle. •Designed and implemented SSRS reports and SSIS packages utilized by 50+ Account Managers to drive client engagement and provide employee information to clients. •Initiated and launched SSRS reports utilized by Billing and Eligibility teams to process new members and invoice them for workout devices and Vitality rewards. •Successfully assigned and monitored 10 projects per 2-week release cycle to meet strict internal department and external client deadlines. •Programmed ad hoc SQL queries to gather requirements and analyze incidents. •Trained team members to use CA, SharePoint, TFS, and JIRA project work flow platforms. •Managed and maintained existing SSIS packages and jobs to deliver over 300 reports daily. •Solved incidents for IT Support and Eligibility teams related to delivery files for internal and external clients.

Jerusalem, Israel

•Edited lectures for students, faculty, and public consumers on the Ohr Somayach website •Managed and maintained full sound system for guest speakers in the main hall •Repaired and maintained software and hardware issues on computing devices for students and faculty •Trained staff members in the use of Adobe Audition CS6

Jerusalem, Israel

•Planned and organized charity events, trips, and classes to help students experience Israel •Led group of students on tours of Israel to educate on Jewish Heritage and Israeli culture •Maintained schedules to keep students prepared for upcoming events on a daily basis •Taught students about ancient and modern Jewish cultural, history, holidays, and Israeli political events

Iowa City, Iowa

Movie Critic AppThe University of Iowa - Class: Database Management Systems II Our team developed an Oracle Express application parsing, and integrating XML and JSON data from Rotten Tomatoes. We produced consumer tools for evaluating movies such as critic biases for actors and genres, critic credentials, critic history analysis, and ratings.

Iowa City, Iowa Area

•Performed IT maintenance on staff computer systems in order to keep them up and running •Repaired malfunctioning hardware issues on University machines and devices for students and faculty •Trained 5 staff members in the use of University inventory database •Implemented solutions for students and faculty members with a variety of software issues

Iowa City, Iowa Area

The University of Iowa Computer Science Department, Iowa City, Iowa*Assisted Dr. Juan Pablo Hourcade in developing software for children with autism*Programmed multi-touch software to help children with autism develop social skills*Developed ‘Save and Load’ functionality with user friendly interface

Iowa City, Iowa Area

Cargill Shipping DatabaseThe University of Iowa - Class: Database Management Systems I Our team developed a prototype shipping DB with a website for Pork Enterprises. We migrated an Excel data set into an Oracle environment with Oracle SQL DM11g, and normalized tables accordingly to fit User Requirements. We produced an interactive dynamic method for calculating shipping charges to customers for animal feed. We also solved human calculation errors regarding customer costs by integrating constraints and shipping equations.

Bachelor Of Arts (B.A.), Informatics: Human-Computer Interaction, 3.4/4.0

Activities and Societies: Member of Hillel, Member of Hawks Nest, Member of Iowa Retail Association

Jewish/Judaic Studies

Jewish/Judaic Studies