John Slesinski Email & Phone Number

Hartford, Connecticut, United States

• Understand sources of data within BioSafe Systems, and work with stakeholders to identify reporting and metrics requirements.• Identify methods to link or compare data already in our systems with new information.• Propose solutions to improve and standardize processes that enable new data and capability assessment opportunities.• Create static, and adhoc reporting and metrics from existing data stores as required.• Work with new data sources to cleanse, format, data quality validation, and upload to company data stores.• Commit to overall deliverables with business partners and/or management.• Work with stake holders to analyze data points to look for new opportunities

Manchester/Hartford, Ct

• To develop and manage vendor partnerships and control the contractual and commercial obligations of each supplier, working closely with Production Manager and Warehouse Manager.• Administrating all subcontracts and purchasing order processes including monitoring performance, prices and certifications. Conduct market analysis and negating prices, maintain contracts and purchase order files.• Obtain multiple quotes for existing material, future material needs and for current projects.• Responsible for the data quality and data cleansing of the information within enterprise resource planning software.

Rocky Hill Ct/Albany Ny

• Responsible for all purchasing of material and equipment for large scale roofing projects in Connecticut/Western MA/Albany NY areas. Manage material purchases up to and exceeding $300,000.• Ensure all inventories are accurate and documented accordingly and all discrepancies are addressed as needed.• Maintain all inventories of material and equipment within SAP and run weekly reports to supply to management the current status of the warehouses. Responsible for roughly $550,000 of material and equipment at one given time both onsite and offsite.• Manage offices Invoice/Payment transactions within SAP and follow up with Corporate Accounting to ensure payment. • Maintain and manage fleet of vehicles and report any issues with maintenance, careless driving and driver assignments.• Manage and review JJ Keller E-Logs daily for any discrepancies, incorrect hours of service, pre and post trip inspections and any other DOT and non-DOT vehicles. Install and manage both the DOT E-Logs and monitor and manage the GPS tracking for the fleet of Production, Service and Management vehicles.• Manage, maintain and update yearly vehicle inspections, insurance cards, and registrations. Including IFTA and HUD.

Hartford, Connecticut Area

Wethersfield Ct

-Was a stay at home father to my 5 beautiful and wonderful children.

Hartford, Connecticut Area

-Analyzed and supplied reports for Disease/Case Managers from multiple databases using PC SAS and MS Access.-Exported reports to Excel and Word using PC SAS's ODS functionality, which populated multiple dashboard applications.-Analyzed Disease/Case Management programs of members with chronic illness from heart failure, asthma, post traumatic stress syndrome and other medical issues using both PC SAS and MS Access.

Hartford, Connecticut Area

-Managed AWCA Network Reporting daily operations along with providing reports using data from Business Objects and MS Access. Reported to AWCA President and was part of the management team. Directed team of data specialists in support of network requirements.-Supported key sales for various clients including The Hartford, Liberty Mutual, and Concentra. Prepared weekly and monthly data feeds to each company. Managed the specifications for data layouts and exported text delimited files for each client.-Served as an expert on data information needs that required changes to existing systems. Also included changing specifications to Aetna's Enterprise Provider Database and created understandable and meaningful reports.

Hartford, Connecticut Area

-Supported HIPAA Medical Code Initiative. Researched HIPAA laws that pertained to Medical Codes and reviewed CMS reports for updates. -Researched and evaluated 100,000 + provider contracts for those with expired medical codes that would no longer be valid once the HIPAA law became effective. Used Crystal Reports and MS Access to forward data to Network Managers and contract individuals.-Used Aetna's Data Warehouse to perform analysis of expired medical codes showing the amount of claim and claim dollars billed . Prioritized those contracts by the largest impact of total bills and total dollars to minimize financial impact on the company. Exported the information to Excel where reports were supplied to regional managers.-Performed adhoc reporting for other business needs related to HIPAA and other organizational business requirements. -Evaluated Aetna's opportunities in developing a Workers Compensation product and if it could be profitable in the Rental Network Workers Comp business. Presented to The Aetna Executive Committee strengths of current Aetna Provider Networks and financial impact of state specific pricing, fee schedules of current Aetna contracts and which states were to be profitable and those that would restrict growth of the business.

Hartford, Connecticut Area

-Managed provider data support and reporting needs for GeoNetwork, MapInfo, Access and Paradox systems. Supplied various consulting firms with Aetna data to perform disruption analysis of their clients. Performed monthly updates of 13 + million records obtained from Mainframe systems and converted into PC DB formats.-Continuously supported Network Development, NCQA Accreditation, HEDIS yearly updates and RFPs. -Supported adhoc reporting as needed. Managed vast amounts of data and complied into analysis that business areas used for continued development of Aetna's products and services. -Created and developed baseline data for Mainframe SAS Application for Radius reporting. Saved 1 hour per report from Geo Networks application to Mainframe SAS application.

Hartford, Connecticut Area

-Managed GIS Data production and reporting for RFP response, Network Development, NCQA accreditation and other business needs directed by sales, network management and internal audit. Used both MapInfo and GeoNetworks to create understandable and readable reports. -Trained on and off site employees on MapInfo and GeoNetworks systems. Instructed individuals and organizations on how to produce and interpret reports for specific business needs. -Converted DOS based systems to Windows environment, converted 5,000+ files to allow streamlined entry.-Lead a Team of National Account Geographic Specialists in analyzing and producing reports for RFPs and offered assistance to the team leader of the middle market and small market units.-Assisted in the creation of the MARS (Market Area Rating System) project. Aligned zip code/counties into 135 + markets for site match and marketing purposes, by using US Census data and MapInfo. -Provided adhoc reports for CHAMPUS/TRICARE military bid, State HMO/Managed Care filings that required specific data needs and data layout for input in state systems for audit purposes.-Analyzed US Census data and performed demographic analysis that allowed Aetna to open individual Urgent Care centers in Maryland.-Represented Aetna at national healthcare conferences and discussed the strengths Aetna Health Plans would bring to each respected company.