Paul Kostanski Email & Phone Number

Deerfield, Illinois, United States

Deerfield, Il

84.51° brings together customer data, predictive analytics and marketing strategy to drive sales growth and customer loyalty for Kroger and more than 300 consumer-packaged-goods companies in the U.S.

Chicago, Il

Waystar provides next-generation, cloud-based technology that simplifies and unifies the healthcare revenue cycle. Our platform removes friction in payment processes, streamlines workflows and helps improve financials for providers in every care setting. · Design, write, and deliver software to improve the availability, scalability, latency, and efficiency of Waystar’s software solutions- Overcome challenges relating to mission critical services and build automation to prevent problem recurrence- Automate and solve complex business issues via T-SQL and MS Business Intelligence- Oversee all ETL troubleshooting - Investigate and resolve data issues as they arise on load/extract-specific assignments- Create and optimize SSIS packages- Act as a technical expert for the Waystar Software Solution- Engage in service capacity planning and demand forecasting, software performance analysis, and system tuning.- Conduct periodic monitoring and/or on call duties (early morning and weekends)- Understand and troubleshoot issues in the database environment using T-SQL- Ability to execute and prioritize a large number of tasks, and resolve issues and resource conflicts without aid from direct manager or project sponsor - Responsible for gathering the technical requirements for Waystar’s software support and monitoring the reporting and analysis configuration for each client set-up- Work with client services team members to coordinate research and change requests / work documented and tracked through Salesforce platform- Perform client software version upgrades/go-live’s with coordination from several organizational departments involved

Chicago, Il

· Initiated and developed US Data Support Team which became responsible for data load support on over 600 accounts· Develop & implement client data loads by building & utilizing processes using SQL queries, mapping views, and stored procedures to import, transform, and load data into the client’s database on the Salesforce cloud platform· Complete Salesforce Platform Essentials training program through the Salesforce Trailhead program· Perform data integration quality validations for developed loads/extracts· Investigate and resolve data issues as they arise on load/extract-specific assignments· Monitor all aspects of the ETL process in ongoing data loads, troubleshoot issues & load failures, document issues and resolutions in internal CRM, and provide timely communication & status updates to client contacts· Automate ETL processes by setting up integrated Job Scheduler jobs to call & perform all functions across a data load· Participate in on-call support rotation for US-based loads/extracts· Work with client services team members to coordinate research and change requests· Facilitate the client services team with addressing client concerns & issues by being Data Dept. representative on client calls & meetings· Engage TPA’s on behalf of clients to resolve data questions & issues· Communicate data projects across organizational departments, with client contacts, and with TPA contacts while using the different ‘languages’ needed based on each target audience’s comprehension level of the concepts involved· Utilize and/or troubleshoot the following technologies: Salesforce (internal CRM as well as client- facing), VisualCron, SQL Server, SQL Server Integration Services (SSIS), FileZilla

Chicago, Il

· Responsible for monthly and quarterly risk management data analysis and client database updates for over 100 clients· Provided accurate and timely data, as outlined in the CS Stars client contract / SOW· Increased company revenue by meeting and exceeding client expectations, resulting in renewed contracts· Saved CS Stars money by avoiding set penalties for sub-standard data procedures set in client contracts· Provided support and answers to client service colleagues and client data inquiries· Participated in client meetings regarding client issues or additional data conversions· Maintained account documentation· Maintained and improved the quality and efficiency of each account assigned· Provided support for other Data Operations employees· Assisted in efforts to maintain overall efficiency by improving daily practices· Served as a member of internal training committee, developed training on various topics/software· Maintained SAS70 standards and various Q/A initiatives on all clients responsible for

Melrose Park, Il

· Perform and maintain daily EDI (Electronic Data Interchange) transactions between various vendors/clients including PO’s, invoices, and ASN’s· Troubleshoot EDI software as well as company database (IFS – Oracle Application)· Increased company productivity by combining EDI responsibilities into one position instead of the two previous departments. Handle network backup procedures as well as hardware/software/license inventory and purchasing

Pursued Graduate-Level Courses In Master'S Degree Program, Predictive Analytics

Bachelor Of Science (B.S.), Business Information Systems