Business Analytics & Database Modernization Consultant

Jacques Pelman

U. S. Citizen – 347-***-**** – *******@*****.*** – linkedin.com/in/jacquespelman

Education

Lehigh University MS in Business Analytics Graduation: May 2025 Lehigh University BS in Management Consulting & Minor in Philosophy Graduation: Dec 2022 Extracurricular Activities: Head analyst at Lehigh Consulting Group, Grad Student Liaison for Lehigh Entrepreneurship Club, NSBE Region 2 Member, Habitat for Humanity Volunteer Site Leader, Resident Hall Association President Work Experiences

EMG Associate Sep. 2025 – Present

TRS - Consultant

· Modernize 3+ databases using proprietary software while ensuring data integrity and functionality for 200,000 members. Ensure all benefits, deductions and service are updated for members.

· (IBM SPSS, Rocket Terminal, Google Forms, Office Suite, Tableau) Data Control Specialist May 2024 –June 2025

NJ Transit – Internship

· Collected & analyzed relational data from 100+ transportation databases using EMX AppXtender, ensuring government archival compliance standards are met. Sanitized and visualized excel and pdf formatted transportation data using Adobe Suite following guidance outlines by senior staff.

· Organized and scanned 3000+ sensitive physical documents for archival purposes using Zscaler. Completed 9000+ database tasks, including document creation and quality assessments, and developed a contractor guide for virtual workflows. Using quality assessments, I assessed financial risk of different database structures. · (OpenText, Zscaler, OneDrive, Office Suite, Adobe Suite) Assistant Professor & Research Assistant Dec. 2023 –June 2025 Office of SCM at Lehigh University

· Conducted research on growth patterns of produce and supply chain efficiency impacts of produce loss in transportation. Obtained relevant research articles/academic papers for summarization. Used R for data cleaning, analysis, modeling, forecasting and transformation. Combined R, xlsx, csv and pdf file types into easily readable reports. · (Python, R, Git, Visual Studio, Power BI, LLM) Aquatics Director Jan. 2023 – June 2023

Making Waves

· Collaborated on a team numbering 7-10 people to facilitate a safe learning environment for NYC public school students. Completed admin duties including student attendance, employee/contractor timesheets, lesson planning & pool chemical maintenance. Completed over 200+ hours of swim instructor & aquatics director duties across 6 schools in NYC. Data Analyst June 2022 – Aug. 2022

Ankura LLC - E-Discovery Internship

· Contributed to research projects and client cases using Disco & Relativity 1. Using test data, I compared two version of the relativity 1 software to ensure 100% uptime and realize efficiency gains after migration. The findings from these research projects allowed the firm to reduce Relativity 1 training time by 15% and decrease the Relativity 1 guidebook length by 40%. · Documented and made a guide on using 9 new Relativity 1 forecasting functions for upper management. Optimized and implemented 2 AI based functions that pre-classify various legal data. Ensured that notes, document archival, and client communication were up to date for client reference.

· (Disco, Relativity 1, Office Suite, Azure, Co-Pilot, Salesforce, Tableau) NLP Analyst Jan. 2022 – Aug. 2022

Nurture Culture - Internship

· Researched and analyzed hundreds of financial documents to identify relevant qualitative variables, quantitative variables and created a mathematical formula to gauge viability of potential clients. For this I optimized NLP python scripts and organized data on GitHub.

· Directly presented to CEO my findings on how to improve their business model and client acquisition strategy. Completed a magazine article about the internship for University. Used AI assisted graphs · (Python, R, Git, Visual Studio, Office Suite, AI) Projects

Data Analyst Aug. 2021 – Dec. 2021

Office of Management at Lehigh University

Published a research article on medrxiv.org and organized project data using R and Python on GitHub. Developed a detailed database creation plan. Scheduled tasks for all team members. Presented findings with PowerBI using PySaprk Project Manager Aug. 2020 – Dec. 2020

Lehigh Valley Social Impact Fellowship

Conducted research on COVID-19's disproportionate impact on NYC communities of color by analyzing articles and open-source datasets using R. Presented findings at university research expos. Technical Skills Programming Languages: Python, Java, R, Oracle SQL, MATLAB, Arduino Applications: Rocket Terminal, OpenText, Power BI, Disco, Relativity, ArcGIS, AutoCAD, MySQL, SaS, SAP, Office Suite, Access, GIT, Zscaler, OneDrive,Visual Studio, Google Collab, Notepad ++, Qualtrics, Google Forms, IBM SPSS, Adobe Suite, Azure, Co Pilot, Salesforce, Generative AI, LLMs, Tableau

Contact this candidate