Seth Kwitko

Boca Raton, FL 33428

Professional Summary

Business and Data Analyst with strong analytical, research, communication, customer service and collaboration skills - well-organized, detail-oriented, and ability to multi-task. Experience analyzing datasets to uncover trends and insights that are subsequently used to make informed organizational decisions. Extensive experience building and running sophisticated reports using SQL, Crystal Reports, Power BI, advanced Excel, and other tools.

Relevant Work Experience

GL Homes – Applications Support Analyst

October 2020 – Present

  • Liaison between business users and developers to triage and resolve system errors for JD Edwards ERP and related systems. Provide role-specific training for ERP users.
  • Coordinate operations and system improvements for users working remotely and in satellite offices across Florida. Create profiles for new users for multiple software platforms, monitor system security, and resolve related IT tickets.
  • Convert SQL Server stored procedures from custom-built CRM to consume data from new CRM built on OutSystems platform. Utilize Visual Studio to revise and deploy converted SSRS reports to report server.

Meggitt PLC – IS System/Technical Analyst

April 2019 – April 2020

  • Support Quantum ERP system by managing users and security, and resolving ServiceDesk tickets.
  • Clarify and document user requirements, and writing Crystal reports.
  • Use Oracle SQL to collect and analyze Quantum data, perform data extracts, imports and updates using Oracle tools.
  • Document and support service change requests.
  • Improved security and retention policies for SharePoint portal.
  • Developed Power BI dashboard- using Azure data warehouse- for supply chain.
  • Improve ERP data quality by 20% through creating SQL queries and performing data cleanup, for loading into company's SPEC2000 database, an aviation standard for extraction and reporting of reliability data.
  • Built application that reduced input error by 30% when receiving inventory into ERP.

Good Shepherd Services – Application Specialist

May 2015 – February 2019

  • Supported myEvolv electronic health record (EHR) and child welfare system by managing user security, resolving Cherwell tickets, and customizing modules and reports.
  • Saved several hundred work hours per week by designing and automating Crystal Reports.
  • Provided application support that included testing, design, integration, automation and analysis.
  • Developed data integration processes to extract data from various external sources and internal Microsoft SQL servers.
  • Explored and executed improvements to Agency data analysis, integration capabilities and reporting.
  • Created ad hoc queries, views, triggers, and stored procedures using SQL Server.
  • Prepared EHR for transition to health homes and managed care for Medicaid by integrating new plan providers, ensuring correct billing codes, and validating claims form output.
  • Integrated electronic prescribing module into EHR, and trained doctors and LPNs.
  • Created training documentation using PowerPoint and other tools.

Karp Associates, Inc. – ERP Systems Analyst

January 2004 – April 2015

  • Supported Visual Manufacturing ERP system by managing users and security, resolving support tickets, and customizing modules and reports.
  • Reduced shipping errors and late orders by 40% through automated Crystal Reports.
  • Created automated customer invoices, customer acknowledgements, and bills of lading.
  • Created and reviewed financial documents for accuracy, including P&L, balance sheets, and various KPIs.
  • Reduced data entry errors by developing auditing triggers in SQL Server. Automated emails sent alerts about data entry errors.
  • Implemented ERP system and became subject matter expert on all modules; analyzed and revised processes; extracted, transformed, and loaded data from previous ERP into new database.
  • Set up classes and trained each department on ERP standard operating procedure.
  • Reduced supply chain errors by integrating bar-coding into ERP for shipping, and receiving of raw material and finished goods; created dynamically-printed product labels using SQL data and third-party applications.

Software

  • Microsoft SQL Server 2016
  • Oracle Database 12c
  • Transact SQL
  • PL/SQL
  • SQL Server Integration Services (SSIS)
  • Microsoft Power BI
  • Advanced Microsoft Excel
  • Microsoft Access
  • Microsoft PowerPoint
  • Microsoft Visio
  • Crystal Reports Developer/Server
  • Python
  • Quantum Control ERP
  • Netsmart MyEvolv EHR
  • Infor Visual Manufacturing ERP

Certificates and Training

  • Microsoft 20778 – Analyzing Data with Power BI
  • Microsoft 20461 – Querying Microsoft SQL Server 2014
  • Microsoft 20462 – Administering Microsoft SQL Server Databases

Education

Hofstra University, Uniondale, NY

Bachelors of Business Administration – Banking and Finance
Graduated 1997