Mark Jelenek

Experience

• 

  Tarrytech Computer Consultants

  Feb 2016 - Aug 2016

  Centralized Services Assistant & Information Technology Intern

  ● Provided exceptional customer service at a Managed Service Provider.● Created tickets to resolve IT issues from 50+ clients using ConnectWise.● Learned the basics of utilizing both a 3CX VoIP phone system and Skype for Business to communicate with a team of 10+ IT professionals.● Monitored client workstation patch health via LabTech.● Aided with various tasks such as preparing monthly newsletters, updating client information within ConnectWise, and researching various information about potential clients within the Westchester, Rockland, Stamford, and New York City areas. Show less

• 

  University at Albany, SUNY

  Aug 2018 - Dec 2019

  ● Handle confidential documents pertaining to students.● Support a cohesive community of ~35 upper-class students through oral communication in order to develop interpersonal relationships in the Paine Residence Hall.• Participate in on-call duty rotation for more than 1,200 residents of the Colonial Quadrangle.● Prioritize and efficiently complete assignments and projects in a deadline-intensive environment.● Provide exceptional customer service on the phone and in person during quad office duty through knowledge of proper office procedures and campus resources.● Act as a mediator during conflicts that arise between residents within Paine Hall and throughout the Colonial Quadrangle. Show less

  • Course Manager & Teaching Assistant, Information Technologies for Business

    Jan 2018 - Dec 2019

  • Resident Assistant

    Aug 2018 - May 2019
• 

  Apple

  Sept 2019 - Mar 2020

  Technical Specialist

  ● Provided efficient technical support, solutions, and product knowledge in non-technical terms to more than 300 customers.● Cultivated strong and positive relationships between customers and desired line(s) of products and services.● Assisted operations team with merchandise purchasing processes and store promotions greater than 1 thousand dollars per sale.

• 

  Tokyo Electron US

  Sept 2019 - Dec 2019

  Manufacturing Business Analyst Intern

  ● Documented database relationships between 20 tables housing 3 million rows of semiconductor operations data via pivot tables, SQL queries, and Entity Relationship Diagrams.● Synthesized 36 months of historical employee labor efficiency data with regards to usage of semiconductor production machinery into Microsoft Excel through implementation of macros and manipulation of basic VBA scripts.● Restructured each data set to identify metrics hindering business process efficiency by nearly 25%.● Presented visualizations based on key findings to Management and Research & Development stakeholders. Show less

• 

  Argus Information and Advisory Services

  Sept 2021 - Jan 2024

  ● Managed 6 credit card payment studies' monthly ETL processing cycles, ensuring accurate and prompt data delivery to desired AWS Redshift and Redshift Spectrum databases utilized by more than 100 international employees.● Incorporated onboarding of 5 new financial institutions and product portfolios into current studies’ data sets via updates to existing SQL code, Pentaho Data Integration automation structures, and GitLab version control repositories.● Improved project efficiency by 30% through technical requirements documentation detailing proper data transformation methods, quality validations, and exploratory SQL analyses.● Investigated ad hoc impact and root cause analyses on dynamically-driven project data sets with 200 historical metrics. Show less ● Leveraged big data sets greater than 10 million rows by implementing complex SQL queries to execute quantitative analyses.● Interpreted intricate credit card and deposits data interactions to help identify key strategic business opportunities for a wide range of financial institutions with product portfolios in excess of 100 million dollars.● Standardized existing statistical data models used in development of client strategies.● Analyzed results of reports and statistical models supporting business solutions for individual projects yielding revenues above 100 thousand dollars.● Composed and communicated business opportunities greater than 50 million dollars to key C-suite stakeholders. Show less

  • Associate Data Engineer

    Sept 2022 - Jan 2024

  • Data Strategy Analyst

    Sept 2021 - Sept 2022
• 

  Allstate

  Oct 2024 - now

  Rating & Ratemaking Insights Analyst