Jonathan Barszcz Email & Phone Number

New York, Ny, Us

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 maintaining accuracy of greater than 99%.

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.• Identified and acted on opportunities to drive revenue growth and expand on business models.

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.