Teresa Anzalone
Phone: (985) 510-9876
teresa.anzalone@gmail.com
Summary:
Professional Experience:
- Updated BR.100 from UAT Environment.
- Performed WMS setups for Go-Live in Production Environment.
- Supported Desktop and Mobile Supply Chain Applications (Inbound and Outbound)
- Document and Label Printing
- Supported one of six Distribution Centers through Go-Live.
- Gather Business Requirements, Build
Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and User End
Training.
- Setup WMS to drive Pick to Light Carousel
and Flowrack operations.
- Built Order Interface Wrapper to handle
receiving Orders from Third Party Systems
- Modified Oracle’s Pick Release process
to release specified number of Orders per Batch
- Interfaced Picking with External Pick to
Light system for Pick Confirmation
- Built External Java Program for Packers
to use.
- Modified Oracle’s Packing Workbench to
improve efficiency.
- Created Custom Shipping Interface that
handles finalizing order shipment from the Packing Workbench by calling
Oracle API’s.
- Run background interfaces from Custom
Shipping Interface to Print Invoice to put in the last box.
- Ensure proper Accounting Entries are
processed.
- Work testing and rolling out Mobile
Supply Chain Applications
- Document and Label Printing
- Supported Solution through Full
Life-Cycle.
- Gathered requirements for multiple Acquisitions
and new Companies.
- Prepared setup documents for new
Acquisitions and Companies.
- Setup GL, AP, AR, INV, and PO for the
new Acquisitions and Companies.
- Supported Solutions through Full
Life-Cycle.
- Built program to extract Commission data
from POS system
- Run data through several proprietary
formulas.
- Load data into Oracle Payroll through
BEE (Batch Element Entry)
- Gather Business Requirements, Build
Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and User End
Training.
- Built program for Users to create and
update Position information.
- Mass Assignment of Positions to Employees.
- Approval through Custom Workflow.
- Reports to manage Interface data as well
as view Position and Employee data.
- Mass update of Employees and Positions from
flat file using Oracle API’s.
- Update Position Hierarchy programmatically
so that Purchasing Approval is not affected by Position changes.
- Supported Solution through Full Life-Cycle.
- Built program for User to upload flat
file retrieved from Sales Tax Clearing House.
- Parse the data and load into a Staging
Table.
- Wrapper program to call Oracle’s Sales
Tax Interface and feed it the new data.
- Retrieved Oracle’s Drilldown logic from
Oracle’s Drilldown Forms.
- Packaged the logic into Stored
Procedures.
- Put procedures together to generate a GL
Drilldown Report.
- Used Oracle’s Total Compensation architecture
to setup Employee Benefit Reports.
- Used BI Publisher to build Report
Templates for Oracle Total Compensation to use.
- Gather Business Requirements, Build
Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and User End
Training.
- Built Custom Subledger in Oracle for
storing the POS Data.
- Built Setup Forms for Users to map GL
Accounts and control access to the Application.
- Built extraction program to retrieve
data from POS System into Oracle.
- Built validation program for data being
pushed into Oracle GL.
- Create GL Journals to represent data
coming from POS System.
- Built Reports to be used to manage and
audit the data.
- Supported Solution through Full
Life-Cycle.
- Working on role out plan for
upgrade to Oracle E-Business Suite Release 12.
- Researching changes from Set
of Books to Ledgers and effect on Customizations.
- Researching and reporting to
team new Oracle Financials functionality.
- Researching and reporting to
team SLA Architecture.
- Testing and Fixing
Customizations created in 11i to ensure they are still needed and work
properly in Release 12.
- Gather Business Requirements,
Build Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and
User End Training.
- Configured, Tested, and Documented Order Management, Shipping Execution, Receivables, and CRM Setups in Oracle E-Business Suite 11i.
- Built Programming Interface to Load and Maintain Customers in Oracle E-Business Suite using Oracle TCA API’s.
- Secondarily assisted in the Implementation of Telesales, Receivables, Advanced Pricing, Customer Support, Service Contracts, and CRM Foundation in E-Business Suite 11i.
- Used CUSTOM.PLL to add Functionality required by the Business in Order Management, Receivables, and Telesales.
- Built Custom Credit Card Form to provide Call Center Users with a quick and easy procedure for entering and assigning Credit Card Information to a Customer.
- Customized Workflow so that the Address associated with the Credit Card on an Order would be sent to the Credit Card Authorization Company for AVS Verification.
- Built Custom Product Launch Program to Massively Generate Customer Orders (Using Order Import) based on Customer Classifications and Contractual Agreements with the Customers.
- Worked with a Team by steering and assisting in the Customer Data Cleanse for Bulk Load into E-Business Suite 11i.
- Ensure flow of all Transactions to Accounting.
- Supported Solution through Full Life-Cycle.
- Gather Business Requirements,
Build Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and
User End Training.
- Worked with a Team to prepare Company’s Re-Implementation Plan.
- Consolidated Two Business Groups into One in order to accurately represent the Company’s Organizational Structure.
- Transferred Balances from Obsolete Business Group into Remaining Business Group.
- Eliminated the use of Several Operating Units and replaced them with one Operating Unit. This included Purchasing, Inventory, Receivables, and Payables.
- Eliminated the use of Multiple Inventory Organizations to use One Inventory Organization with multiple Sub-Inventories, which more accurately represented the Physical Warehouse.
- Configured GL Account Security to control the use of Restricted Accounts in Certain Responsibilities.
- Performed User, Responsibility, and Menu Analysis and Cleanup.
- Created a Consolidated Set of Books to generate Financial Reports for Multiple Sets of Books with different Calendars.
- GL Account Combination Analysis and Cleanup.
- Account Balance Validation and Corrections due to Users loading Entries into the wrong Set of Books. This includes eliminating the source of the problem by employing ADI Functional Security.
- Configuring and Deploying Oracle Web ADI.
- Configured Pay Slips and W2’s Online in Self Service.
- Modified Payroll Costing to match changes made to Organization Setups.
- Supported Solution through Full Life-Cycle.
- Gather Business Requirements,
Build Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and
User End Training.
- Configuring and Testing Order
Management, Shipping Execution, and Receivables Setups.
- Loading Customer Data into
E-Business Suite 11i Using Oracle Customer Interface.
- Supported Solution through Full Life-Cycle.
- Built Canned Transaction to
Load General Ledger Data Daily from existing Legacy System into E-Business
Suite using Oracle GL Interface.
- Built Canned Transaction to
Load General Ledger Data from Stores Owned and Managed by the Company into
E-Business Suite using Oracle GL Interface.
- Built Canned Transaction to
Electronically Transmit Company’s Payroll Payment Information to Chase
Bank.
- Determined Employee Balance
inaccuracies and made the necessary corrections using Balance Adjustments
for W2 Reporting.
- Built Interface to load
Vendor Items into E-Business Suite using a Spreadsheet Template.
- Built General Ledger
Drilldown Report using Oracle’s Subledger Accounting Architecture. Also
included in the report is a drilldown into Payroll Journals for Employees
with an HR or Payroll Responsibility.
- Customized various Oracle
Reports with Oracle Report Builder and Oracle XML Publisher.
- Transfer Tested FSG Reports
from Test into Production Instance.
- Gather Business Requirements,
Build Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and
User End Training.
- Loading and Updating Employee
Data by the use of Oracle Public API’s.
- Built Interface to Import
Timecard Information into Batch Element Entry Tables by the use of Oracle
Public API’s.
- Modified Fast Formulas to add
Business Logic to User Define Payroll Elements.
- Developed Proprietary Payroll
Reports Required by the Business, which were not supplied by Oracle.
- Supported Solution through Full Life-Cycle.
- Gather Business Requirements,
Build Specifications, Design, Test, and Deploy Solution
- Facilitate CRPs, UAT, and
User End Training.
- Assisted in the Setup of General Ledger, Payables, Purchasing, Inventory, and HR in E-Business Suite 11i.
- Imported Vendor Items into E-Business Suite using SQL*Loader.
- Customized Purchase Order Report and Built Host Program to send the Purchase Order to the Vendor.
- Built Programming Interfaces between Oracle Applications and Company’s Legacy Systems.
- Developed and maintained General Ledger, Payable, Purchasing, and Inventory reports using Oracle’s Report builder and PL/SQL.
- Supported Solution through Full Life-Cycle.
- Troubleshooting problems and issues encountered by Company’s Users.
- Developed new and maintained existing programs and reports for General Ledger, Accounts Payables, Accounts Receivables, Inventory, Purchasing, HR, Payroll, and Sales in company’s existing proprietary system, Progress.
- Developed internal and external sales reports using PHP and the company’s Progress Database.
- Maintained company’s W2 magnetic media reporting program as well as employee’s W2 forms.
- Maintained existing programs and reports for General Ledger, Accounts Payables, Accounts Receivables, Inventory, Purchasing, HR, Payroll, and Sales in company’s existing proprietary system, Progress.
Education:
Bachelor of Science Degree (Nationally accredited by the Computing Accreditation Commission of The Accreditation Board for Engineering and Technology)
Date of Graduation: December 2004
Additional Education:
Activities/Honors:
Computer Skills:
- Oracle E-Business Suite 11i, R12 (Functional and Technical)
- Oracle OUM/AIM
- Oracle RICEW/RICEF
- Oracle PL/SQL
- Oracle Forms Builder
- Oracle Reports Builder
- Oracle Workflow Builder
- Oracle Discoverer Admin and User Applications
- Oracle BI Publisher (formerly Oracle XML Publisher)
- Oracle JDeveloper
- Oracle ADF
- Oracle Custom Library
- Oracle Database (8i, 9i, 10g, 11g)
- Oracle SQL*Loader
- Oracle SQL*Plus
- Oracle FSG Reports (Financial Statement Generator)
- Linux, Unix, and Windows Operating Systems
- All Microsoft Office Products
- Java
- PHP
- Dataload
- HTML
- SQL
- JavaScript
- Shell Scripting
- C/C++
- Perl
References:
Available Upon Request
Download Resume Format
0 comments:
Post a Comment