Jonathan Barszcz Email & Phone Number

Norwalk, CT, US

• Utilize SAS programming to produce data files for acquisition, cross-sell, and retention DM campaigns, ensuring timely and accurate delivery.
• Collaborate with external data bureau and suppliers to access new data sources and generate direct marketing campaign data.
• Generate regular marketing campaign response reports providing valuable insights into marketing effectiveness, offering recommendations for improvement and identifying opportunities.
• Support the resolution of customer and partner complaints regarding data usage through data mining and investigations.
• Create Tableau Dashboards for territory mapping, insights, and ad-hoc analytic requests.
• Developed a highly efficient SAS program to combine and automate data from over 70 affiliate partners across various media campaigns, improving productivity by over 300% while adhering to partner-specific rules and.

Norwalk, CT, US

Norwalk, CT, US

• Conducted data mining operations utilizing SQL queries to generate tailored ad hoc reports for clientele.
• Developed an interactive dashboard in Excel to effectively present project performance metrics
• Monitored and reported on sales trends, inventory planning/projections, and market dynamics.
• Devised Excel macros to automate repetitive tasks, significantly enhancing daily workflow.
• Collaborated closely with Database Administrator to optimize internal processes, resulting in optimal efficiency.
• Reported on sales trends, inventory projections/planning and market trends.

Norwalk, CT, US

• Managed product administration for company websites and third-party marketplaces, ensuring accuracy and efficiency.
• Led a project to extract, transfer, and load all product data to Salesforce Commerce Cloud (formerly Demandware cloud platform).
• Produced comprehensive reports, offering market insights, analysis, trends, and opportunities.
• Developed and maintained Excel templates for seamless transfer of product data to XML, optimizing productivity and precision.
• Provided training to employees on product data uploading and imparted knowledge on the product cycle and company operations.
• Conducted extensive research to identify and resolve product, operation, and order issues.

Norwalk, CT, US

• Responsible for uploading and managing products to third party market places (Amazon.com and 11Main.com)
• Generated sales reports and provided market insights, analysis and trends.
• Maintained and updated company websites and ensuring consistency between them and the third party market places.
• Managed and completed projects accurately within set deadlines.
• Determined how to market and present products within third party market place guidelines.
• Advanced Microsoft Excel skills (Macros, VLookups, pivot tables, charts, formulas, data sorting, record keeping, analysis.

Norwalk, CT, US

• Responsible for uploading all products to company websites.
• Maintained and updated websites by ensuring consistency on all the three websites.
• Managed and completde projects accurately within set deadlines.
• Determined how to market and present products with various personalization options.
• Customer support - Answering product related questions, resolving order issues and placing and updating orders over the phone.
• Understanding how the back end of websites function and basic knowledge of HTML.

CH

• Monitored and meticulously updated deductibles for employment practice liability claims undergoing litigation.
• Efficiently administered all billing correspondence, prepared spreadsheets, and diligently ensured precise fund balances for each account.
• Successfully resolved intricate deductible issues, demonstrating exceptional problem-solving abilities and attention to detail.