We provide IT Staff Augmentation Services!

Ifs Erp Reporting Team Lead Resume

Williston, VT

BUSINESS SKILLS:

  • Work well as an individual with minimal guidance or as a team player with specific goals
  • Comfortable working with all levels of the corporation - from the stock clerk to the CEO
  • Ability to write and speak clearly and concisely and to interpret complex technical ideas to a non-technical person
  • Motivated to improve myself by building on my existing knowledge and exploring new technologies and ideas

COMPUTER SKILLS:

IFS: SQL Quick Reports, SSRS reporting and alternate layouts, IALs, Business Analytics, ETL process, custom fields, custom pages, custom menus, permission sets

IFS: basic knowledge of manufacturing, procurement, planning, sales, shipping, DME modules

Oracle: use and trouble-shoot INV, MRP, WIP, BOM, PO, OM, WSH modules

Oracle: Oracle Discoverer, Oracle SQL

Oracle Reports 6i: create custom reports and register with the Oracle application.

MS Access: create databases, queries, forms, reports, macros, links, and hyperlinks

MS Excel: create and manipulate spreadsheets using imported data

PROFESSIONAL EXPERIENCE:

Confidential, WILLISTON, VT

IFS ERP Reporting Team Lead

Responsibilities:

  • Lead a dynamic team of developers and report writers in the effort to provide reporting solutions for hundreds of legacy reports.
  • Collaborated with team members to formulate and implement an auditable deployment process.
  • Contributed subject matter expertise regarding reporting tools, database objects, application and database user setups, and legacy systems and processes.
  • Provided detailed reporting requirements included in the company RFQ to select a vendor
  • Collected, categorized, and tracked thousands of critical reports from all OTS sites
  • Completed training on all BI related tools and all IFS manufacturing and operational modules
  • Tracked all issues related to the reporting implementation and the subsequent solutions
  • Collaborated with the IFS DBAs to find solutions for all reporting issues
  • Produced hundreds of reporting solutions utilizing all available BI Tools
  • Assisted the migration team with scripts required to load legacy data to IFS
  • Produced weekly, monthly, quarterly metrics
  • Managed ad hoc and repetitive Oracle report requests, development of those requests, testing, and user coordination for all of GDATP Operations
  • Participated in the implementation of the Oracle iSupplier module
  • Provided organized training for users on the Oracle Discoverer reporting tool
  • Provided organized training for users on Oracle Navigation
  • Tested Oracle patches for impacts to Oracle Discoverer
  • Collaborated with the DBAs on all Discoverer issues including upgrades
  • Provided guidance on how best to address Operations reporting needs in the future

Confidential, VT

Business Systems Analyst

Responsibilities:

  • Provided Oracle ERP Applications support primarily for the Inventory, Engineering, Bills of Materials, Purchasing, Order Management, and Work in Process modules
  • Created custom reports using Oracle Discoverer, Oracle Reports 6i, Quest's Toad, and Optio Design Studio
  • Utilized Oracle's SQL Loader in Unix and Linux to data load to Oracle's interface tables to speed the process of creating and maintaining items, costs, routing, and bills of materials
  • Installed and configured Optio e.ComIntegrate and OptioFax on a Windows 2003 server.
  • Provided backup Help Desk duties including running network backups and trouble - shooting all hardware, software, and network issues arising in the course of a day
  • Worked in partnership with an off-site DBA service and Oracle's Metalink (My Oracle Support) service to find solutions to bugs and other technical issues that were not immediately solvable.

Confidential, SOUTH BURLINGTON, VT

Oracle Applications Analyst

Responsibilities:

  • Provided support for all Oracle users by resolving daily issues, working on long term projects, and fixing data integrity problems
  • Analyzed and solved application-based errors by identifying the root cause
  • Created Oracle solutions for legacy business procedures through research of complex user guides and Oracle Support’s website
  • Managed Oracle Support Technical Assistance Requests and tested patches on our test instance and cleared the patches for application to our production instance
  • Utilized SQL, Excel, Access, Visio and Reports 6i for data retrieval and reporting on an ad-hoc and long-term basis
  • Managed the Oracle Help Desk
  • Broadened my support areas to include the Order Management, Shipping and Finance modules
  • Acted as a liaison between the Oracle users, Oracle Support, and our in-house DBA

Oracle Implementation Manager

Confidential

Responsibilities:

  • Implemented Oracle’s ERP Manufacturing, Inventory, and Purchasing modules by working on a team with our business managers and an outside consulting firm
  • Ensured that critical business requirements found Oracle solutions
  • Presented demonstrations of Oracle’s best practices to help our users understand how existing routines would change in the future
  • Created training manuals with Microsoft Word detailing step by step procedures our users needed to perform their jobs
  • Developed curricula and provided company-wide training in a classroom and one on one setting
  • Managed Oracle Support Technical Assistance Requests and open issues in order to meet our go-live date
  • Developed testing scripts and procedures to ensure all critical business functions were in working order
  • Educated myself by taking formal Confidential classes, studying the Oracle Users guides, and seeking out information on the Oracle Support website

Hire Now