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.
• 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.
• 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.

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.
• 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.
• 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.

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.
• 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.
• Built several advanced Webi Reports for Non-Utility Billing.

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.
• 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.
• 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.

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.
• 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.
• Facilitated and Trained ACE Events across Carrier. Kaizens, VSM’s for both Manufacturing and business processes, 5s events.

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.
• 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.
• 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.

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.
• 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.
• 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.
• 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.
• Implemented a consignment program to be used in conjunction with a Supplier webpage.
• Team Leader on three cross-functional product development teams.

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