We provide IT Staff Augmentation Services!

Erp Business Analyst And Technical Solution Architect Resume

Lenoir, NC

SOFTWARE:

Syteline ERP System SQL Server 2000, 2005, 2008, 2012... Epicor ERP SQL Reporting Services (SSRS) ... Factory Track Warehouse Mobility Crystal Reports Labr - Trak Doc-Trak Ross ERP System (iRenaissance) Gembase Great Plains Microsoft Visio Preactor DML Microsoft .Net (Visual Basic, C#) Highjump Warehouse Management Projectwise ... Webwise... MQ Series... XML... SSAS SSIS Natural ... Adabas Construct Delphi Fortran... COBOL... Access ... TSO ... VMS ... MVS / OS / XA ... SAS ... Microsoft Office Predict... PAC ... JCL... DB2 CICS Remedy Informatica

EXPERIENCE:

Confidential, Lenoir, NC

ERP Business Analyst and Technical Solution Architect

Responsibilities:

  • Design, consult, modify forms, write front and back end code (C# and VB .NET), modify, customize, and administrate for SyteLine ERP System and SQL.
  • Developed coding and documentation standards for company.
  • Oversaw, and verified outside vendors SyteLine modifications and ensured they met company coding standards.
  • Added or modified functionality that doesn’t currently exist in SyteLine.
  • Direct issue materials to multiple jobs, update labor hours, automate shipping functionality from HighJump, send and receive financial information to / from JDE while keeping SyteLine and JDE financial books in sync.
  • Developed vendor contacts so vendors could have multiple and different types of contacts. Extended item attributes. Added additional layers of user security. Wrote customized royalty, and commission modules and integrated with SyteLine.
  • Customize code in modules and SyteLine addons to fit Confidential functionality: CPQ, Shop Trak, Sales Portal, Labor Trak.
  • Designed / development new reports in SQL using SSRS.
  • Meet with customers to gather requirements, write specifications and code SyteLine customizations, reports, implementations, data extractions, add functionality, and guide company through SyteLine ERP upgrade.
  • Use ETL and SSIS to transition data from legacy systems, or standalone databases.
  • Write complex SQL stored procedures and queries, SSIS packages, and insure SQL databases / queries were operating efficiently.

Confidential, Ohio

ERP Specialist

Responsibilities:

  • Design, consult, modify forms, write front and back end code (C# and VB .NET), modify, customize, and administrate for SyteLine (Infor 10) ERP System and SQL.
  • Designed / development new reports in SQL using Crystal Reports 2011, and SSRS.
  • Meet with customers to gather requirements, write specifications and code SyteLine customizations, reports, implementations, data extractions, add functionality, convert Progress code to SQL, and guide companies through SyteLine ERP upgrades.
  • Use ETL and SSIS to transition data from legacy systems, or standalone databases.
  • Modify / Design triggers, indexes, constraints, design tables / schemas, security / administration in SQL.
  • Write complex SQL stored procedures, SSIS packages, and insure SQL databases / queries were operating efficiently.
  • Troubleshoot SyteLine ERP problem(s), write interfaces to and from external systems to interact with SyteLine.

Confidential, Greensboro, NC

SQL Developer and Report Designer

Responsibilities:

  • Write complex SQL queries for reports and help troubleshoot data problems.
  • Designed and development new reports using Crystal Reports 2011.
  • Designed reports to run within various ERP’s including Epicor, SyteLine, and SAP.
  • Meet with customers to gather requirements, write specifications for web portal and reports.
  • Use ETL and SSIS to transition data from legacy systems, and from client ERP systems / databases.
  • Modify / Design triggers, indexes, constraints, design tables / schemas, security / administration in

Confidential, Greensboro, NC

ERP Systems Consultant

Responsibilities:

  • Coordinated the implementation of Syteline at Confidential ’s Greensboro, NC plants.
  • Conducted high-level software evaluations; directly accountable to the CFO.
  • Designed and development of new functionality and forms within Syteline ERP System using VB.Net, VB script, and C#.
  • Write complex SQL queries for reports and help troubleshoot data problems.
  • Designed and development new reports using Crystal Reports 2011.
  • Meet with customers to gather requirements, write specifications for web portal and reports.
  • Use ETL and SSIS to transition data from legacy systems, and from client ERP systems / databases.
  • Modify / Design triggers, indexes, constraints, design tables / schemas, security / administration in SQL.
  • Designed and trained application users; conferred with system users to design, formulate business models and translate business models.
  • Install and configure Syteline ERP system, APS, QCS, and Labr-Trak on new servers.
  • Write complex SQL queries to maintain, sync, import / export data to and from SyteLine.
  • Write interface application for SyteLine to interact with outside systems.
  • SQL 2008 R2 installation and maintenance.
  • Use SSIS to import data from AS400.

Confidential, Pineville, NC

ERP Systems Consultant

Responsibilities:

  • Coordinated the implementation of Syteline at Confidential ’s Tennessee plant.
  • Write SQL queries that help troubleshoot data problems.
  • Designed and development of new functionality and forms within Syteline ERP System.
  • Designed new business reports using Crystal Reports.
  • Designed and trained application users; conferred with system users to design, formulate business models and translate business models.
  • Syteline ERP is written in Visual Studio the forms designer allows a user to use any .NET programming language.

Hire Now