Barb Hellmann Email & Phone Number

Duryea, Pa, Us

Dubuque, Iowa, Us

• Design and create business process automation workflows using Phoenix workflow, SQL (SQL Server) and XML Logic.• Create stored procedures to support process automation using TOAD or Sql Server Management (SMS) tools.• Provides support for workflows created and makes changes withing policy guidelines as needed.Work with staff on processes and analyze ways that workflow can enhance their experience.• Assist in product rollout and follow-up with employees to determine if workflows are meeting the expectation with that product's processes.• Answer calls to support, coach and assist employees to provide superior member service and remain aware of front-line processes and procedures in order to develop effective workflows.• Work on an agile team to complete projects quickly and accurately using Jira and Confluence.• Create Adhoc reports using Excel and sql.• Write test plans as needed.

• Write and execute test plans for assigned applications using Jira, Confluence, Zephyr and ALM.• Write sql code to verify data changes. SQL code written for Oracle, SQLServer, MySQL, DynamoDB and Neteeza databases. • SQL Tools used include TOAD and Aginity for Neteeza.• Working on an Agile team to complete projects quickly and accurately, reducing backlog.• Work with analytics development team to test and verify accuracy in changes being made. Testing is done for Java, ETL, JSON, SQL,Hadoop, AWS and Angular technologies.• Work with the analytics development team to test Web API’s using Postman.• Developed project statistics spreadsheet derived from Jira to show project progress.• Document testing as requested.

• Responsibilities include development, testing and maintenance of system using SQL, PL/SQL, discoverer and TOAD for finance (AP/AR/GL/FA), application administration, purchasing, order management, human resources, EIS reporting and iExpense modules of the E-Business Suite versions 11.5.10.2 and 12.1.3.• Worked on a team that upgraded to eBusiness Suite version 12.1.3 from version 11.5.10.2.• Implemented lockbox functionality.• Worked on a team that implemented the Enterprise Asset Management (EAM) module in Oracle EBS version 12.1.3.• Worked on training and internal UPK help documentation within the eBusiness Suite.• Implemented an interface for importing Concur expenses to Oracle general ledger. • Worked on numerous custom reports which are used for corporate reporting.• Worked as part of a team working on a divestiture using ePrentise software.Daily job responsibilities include:1. Work with other team members to support all aspects of the system.2. Maintain Oracle databases to ensure data reliability and performance.3. Troubleshoot issues.4. Implement new eBusiness Suite modules as directed.5. Create reports for all modules as directed using XML (BI) publisher, sql and EIS.6. Create, document and maintain testing scripts for new functionality, upgrades, etc.7. Work with hosting provider in support of keeping system running efficiently.

Los Angeles, Ca, Us

Senior EBS Developer, Rentech Nitrogen, East Dubuque, Illinois. • Responsibilities include development, testing and maintenance of system using SQL, PL/SQL, discoverer and TOAD for finance (AP/AR/GL/FA), application administration, purchasing, order management, human resources, EIS reporting and iExpense modules of the E-Business Suite versions 11.5.10.2 and 12.1.3.• Worked on a team that upgraded to eBusiness Suite version 12.1.3 from version 11.5.10.2.• Implemented lockbox functionality.• Worked on a team that implemented the Enterprise Asset Management (EAM) module in Oracle EBS version 12.1.3.• Worked on training and internal UPK help documentation within the eBusiness Suite.• Implemented an interface for importing Concur expenses to Oracle general ledger. • Worked on numerous custom reports which are used for corporate reporting.Daily job responsibilities include:1. Work with other team members to support all aspects of the system.2. Maintain Oracle databases to ensure data reliability and performance.3. Troubleshoot issues.4. Implement new eBusiness Suite modules as directed.5. Create reports for all modules as directed using XML (BI) publisher, sql and EIS.6. Create, document and maintain testing scripts for new functionality, upgrades, etc.7. Work with hosting provider in support of keeping system running efficiently.

Davenport, Ia, Us

• Duties include applications administration, documentation and support of Oracle E-Business Suite. • Responsibilities include testing, development and maintenance of system using SQL, PL/SQL, discoverer and TOAD for finance(AP/GL/AR), application administration, purchasing, Work in process, bill of materials, Inventory, iSupplier, order management, eCommerce Gateway and daily business intelligence modules of the E-Business Suite versions 11.5.10.2 and 12.1.3.• Worked as part of implementation team for both implementation and upgrade of the eBusiness Suite.• Served as project lead for implementing the iSupplier module.• Designed and created an interface that allowed customers to scan barcodes and send them via the internet as sales orders with no human interruption.Daily job responsibilities included:1. Work with team members to support all aspects of the system.2. Maintain Oracle databases to ensure data reliability and performance.3. Write and maintain complex pl/sql procedures.4. Implement new eBusiness Suite modules as directed.5. Create, document and maintain testing scripts for new functionality, upgrades, etc.6. Work with hosting provider in support of keeping system running efficiently.

• Duties include support & customization in support of the Oracle E-Business Suite. • Responsibilities include testing, development and maintenance of system using SQL, PL/SQL, discoverer, Oracle Reports, XML Publisher and TOAD for finance, purchasing, iSupplier, order management and daily business Intelligence Modules of the E-Business Suite versions 11.5.10.2 and 12.1.3.• Worked as part of implementation team for both implementation on upgrade of the eBusiness Suite.Daily job responsibilities included:1. Write queries to support Discoverer adhoc queries using TOAD.2. Work with team members to support all aspects of the system.3. Maintain Oracle databases to ensure data reliability and performance.4. Create and maintain XML Publisher documents which include, packing slips, invoices and purchase order.5. Write and maintain complex pl/sql procedures.6. Maintain business intelligence dashboards.7. Implement new eBusiness Suite modules as directed.8. Create and maintain testing scripts for new functionality, upgrades, etc.9. Mentor other staff members on use of tools.10. Provide on-call support as directed.

Remote, Us

Duties include writing and maintaining programs using Oracle, C, SQL, PL/SQL, and SAS. Daily job responsibilities include: Develop, enhance and revise software for various systems within ACT. Support Oracle Discoverer by adding users and joins to new and existing business areas. Write queries to support Discoverer Adhoc queries using TOAD. Work with team members to ensure that software is free of defects and bugs. Write and support programs written on Windows and UNIX platforms using C, ProC, SAS, SQL, PL/SQL and various Oracle tools. Maintain Oracle databases to ensure data reliability and performance.

Remote, Us

Duties include writing and maintaining programs using Oracle, C, SQL, PL/SQL, and SAS. Daily job responsibilities include:Develop, enhance and revise software for various systems within ACT.Support Oracle Discoverer by adding users and joins to new and existing business areas.Write queries to support Discoverer Financials Adhoc queries using TOAD.Work with team members to ensure that software is free of defects and bugs.Write and support programs written on Windows 2000 and UNIX platforms using C, ProC, SAS, SQL, PL/SQL and various Oracle tools.Maintain Oracle databases to ensure data reliability and performance.

Us

Duties included design of retail and classified advertising. Responsibilities included creation of special sections and display advertisement placement on display advertising system. Design was done using QuarkXpress on a Macintosh system. Trained several other employees on QuarkXpress software and Macintosh system.

Masters Of Science, Management - Information Technology Management Program

Ba, Computer Information Technology

Associate'S Degree, Accounting Specialist