Joseph Kinn Email & Phone Number

Syracuse, New York, United States

Supporting PeopleSoft application and Database functions

Syracuse, New York, United States

. Responsible for developing Power BI and Tableau visualizations for Gas organization. Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and SharePoint development. Responsible for all ETL processes to build data sources for the department. Managed and Built SharePoint Hub and Teams channel for department● Created API connection Oracle Databases, SQL Server, and MS Lists sources and automated data uploads. ● Eliminated several up steps by… Show more . Responsible for developing Power BI and Tableau visualizations for Gas organization. Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and SharePoint development. Responsible for all ETL processes to build data sources for the department. Managed and Built SharePoint Hub and Teams channel for department● Created API connection Oracle Databases, SQL Server, and MS Lists sources and automated data uploads. ● Eliminated several up steps by replacing spreadsheet with a Power Query, Alteryx connected to Oracle databases. ● Redesigned Dashboards to improve visualizations. Rebuilt dashboards and rewrote all DAX codes. ● Performed advanced analysis using Alteryx, Minitab, and Power BI. ● Built 2 application using Power Apps, Access, Power Automate ● Built Gateways to Oracle Databases to Automate Dashboards and Power APPS. Show less

Syracuse, New York Area

Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and SharePoint development. Provides Leadership for development, implementation, and Training for NCCM Application and NCCM Applications. Manage Projects and Community folder on the Tableau and Alteryx Servers.● Created Connections to CMA, Contractor Portal, and ACIS Oracle database for dynamic reporting with Power BI, Tableau, Alteryx, and Oracle SQL Developer● Built several scheduled reports… Show more Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and SharePoint development. Provides Leadership for development, implementation, and Training for NCCM Application and NCCM Applications. Manage Projects and Community folder on the Tableau and Alteryx Servers.● Created Connections to CMA, Contractor Portal, and ACIS Oracle database for dynamic reporting with Power BI, Tableau, Alteryx, and Oracle SQL Developer● Built several scheduled reports using SAP HANA to track discounts, PO Spend, Contracts, and ad hoc reporting from the SAP SCM and Storms SAP HANA Data Sources.● Lead the implementation of Teams and Power BI for our Department. Created Department Teams Channels and Power BI Workspaces.● Designed and built the NCCM SharePoint 365 sites.● Created Tableau and Power BI visuals for Crew Counts, Workforce forecasting, and Project Management. Show less

Syracuse, New York

Senior Analyst, Business Services Credit and Collections Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and MS Access Development● Created workflows with Alteryx and SSIS to create Datasets for SQL Server, Tableau, MS Access, and Excell.● Order Reason Code analysis: Alteryx workflows blending excel data from SAP BI and NUB Aging tables in both SQL Server & MS Access. Published data directly to the Excel report and Tableau… Show more Senior Analyst, Business Services Credit and Collections Responsible for various IT functions with a focus on Data Management, Analytics, Reporting, and MS Access Development● Created workflows with Alteryx and SSIS to create Datasets for SQL Server, Tableau, MS Access, and Excell.● Order Reason Code analysis: Alteryx workflows blending excel data from SAP BI and NUB Aging tables in both SQL Server & MS Access. Published data directly to the Excel report and Tableau Datasets. ● Automating Recertification Letter Mailing process which has eliminated the manual task of creating letter merges with MS Word. Eliminated separate SQL Server Queries for each region and state by creating a Dataset and combining data. Using Alteryx, VBA, and Tableau for the Dashboard.● Built several advanced Webi Reports for Non-Utility Billing.● Created Alteryx workflow to create an Analytics dataset. Publish directly to Tableau Server to update dataset for Tableau workbook.● Started building SharePoint 365 Online site for Credit and Collections incorporating new Office 365 functionality. Show less

Syracuse, New York Area

Administered SAPBI reporting application. Oversee SAPBI Data Warehouse SharePoint 2013 site. Designed data warehouse universes, ETL, Databases. Manage project plans, meeting minutes, action items, and point of escalation tasks. Provided complex analysis using BI reports, data visualization, dashboards to understand complex quality issues.● Created ETL process using SAP Data Services (BODS) replacing manual FTP process. Improved data accuracy, reduced process time 75%, improved data… Show more Administered SAPBI reporting application. Oversee SAPBI Data Warehouse SharePoint 2013 site. Designed data warehouse universes, ETL, Databases. Manage project plans, meeting minutes, action items, and point of escalation tasks. Provided complex analysis using BI reports, data visualization, dashboards to understand complex quality issues.● Created ETL process using SAP Data Services (BODS) replacing manual FTP process. Improved data accuracy, reduced process time 75%, improved data structure ● Streamlined reporting process. Resigned reporting data warehouse to decrease processing time. Self-service reporting eliminated report lead time. Automated report distribution.● Managed SAPBI integration and quality dashboard establishment using SAP Design Studio, Tableau. Improved quality analysis by moving from outdated Microsoft Office applications.● Developed reports with SAPBI, SharePoint KPI dashboards, and Tableau that monitored department metrics. Providing real-time analysis for better financial management and quality issue identification.● Formed strategic alliances with business partners by leading client meetings, marketing campaigns, and gathering / prioritizing core business. ● Project Manager several Baan Warranty System enhancements projects. Reducing process time 60% through automation.● Designed Quality Department SharePoint site. Updated site data. Automated BI reporting distribution and dashboard updates on SharePoint. Show less

Syracuse, New York Area

Managed 3 warranty administrators, oversaw warranty system and department processes and Business Objects Data Warehouse, and provided reporting. Designed and maintained company-wide data warehouse universes.● Designed and implemented CTD Warranty Business Objects Data Warehouse. Online application processing removed the inefficiencies created by ‘cut & paste’ MS Office reports. ● Monitored department project progress consistently. Kept projects in scope as per the approved project… Show more Managed 3 warranty administrators, oversaw warranty system and department processes and Business Objects Data Warehouse, and provided reporting. Designed and maintained company-wide data warehouse universes.● Designed and implemented CTD Warranty Business Objects Data Warehouse. Online application processing removed the inefficiencies created by ‘cut & paste’ MS Office reports. ● Monitored department project progress consistently. Kept projects in scope as per the approved project proposal.● Used Lean Methods (ACE) for Warranty claim processes reducing process times by 80%. Value Stream Mapping removed obsolete process steps decreasing. Paperless online claim processing improved validation accuracy to 98%UTC ACE Lean Business Process Practitioner and Team Facilitator● Facilitated and Trained ACE Events across Carrier. Kaizens, VSM’s for both Manufacturing and business processes, 5s events.● Team Leader for creating department SIPOC, Process Maturity Charts, Monthly 5S events.● Certified ACE Business Process Practitioner, VSM & Kaizen event trainer and facilitator. Show less

Syracuse, New York Area

Established and maintained pricing for all retail accounts. Analyzed current market trends, pricing, market growth, and new opportunities. Worked with VP of Retail Products Division and retail sales directors established pricing for multi-million-dollar bids. Provided management with monthly reports on profit and loss, quotes won, current market conditions.● Ensured Pricing Group complied with Sarbanes-Oxley (SOX) by developing and implementing several procedures.● Created several… Show more Established and maintained pricing for all retail accounts. Analyzed current market trends, pricing, market growth, and new opportunities. Worked with VP of Retail Products Division and retail sales directors established pricing for multi-million-dollar bids. Provided management with monthly reports on profit and loss, quotes won, current market conditions.● Ensured Pricing Group complied with Sarbanes-Oxley (SOX) by developing and implementing several procedures.● Created several Microsoft Access databases for department scorecards and analysis, providing analysis for improving pricing and increasing margins.● Analyzed pricing and business trends in retail home improvement marketplace, establishing pricing guidelines for invoice price and suggested retail pricing for customer based on margin metrics generated through analysis of standard costs, rebates, incentives, and SG&A impact on bottom line. Show less

Syracuse, New York Area

Overall responsible for $3 million annual spend. Strategic procurement of mechanicals, electro-mechanical, Packaging, Precision machined components. Wire Harnesses, Capital Equipment, Plastics. Working in a demand flow environment with SAP R3 system. Monitor and procure all precious metals including Gold and Platinum. Created reports and analysis using SAP BW and ABAP reporting tools.• Designed and implemented a web based supplier interface (e-procurement). Programmed SAP queries from MM… Show more Overall responsible for $3 million annual spend. Strategic procurement of mechanicals, electro-mechanical, Packaging, Precision machined components. Wire Harnesses, Capital Equipment, Plastics. Working in a demand flow environment with SAP R3 system. Monitor and procure all precious metals including Gold and Platinum. Created reports and analysis using SAP BW and ABAP reporting tools.• Designed and implemented a web based supplier interface (e-procurement). Programmed SAP queries from MM and PP modules that are automatically posted to the web site. Reports include inventory levels, Kanban triggers, and 6 month forecast.• Integrated new business unit into the company. This included extracting all data from their system into our SAP system and converting it to match our accounting, BOM, sales, and logistics structure (FI, CO, MM, PP, IMG, SD).• Implemented a consignment program to be used in conjunction with a Supplier webpage. • Team Leader on three cross-functional product development teams.• Integrated purchase order requisition module on their SAP (MM) system for expense items. Show less

Master Of Business Administration (Mba), Business Administration, Management And Operations

Master of Business Administration

Bachelor'S Degree, Political Science And Government

Activities and Societies: Inter-mural Sports, Club Lacrosse, Young Democrats Club