Experience

Konami Gaming, Inc.

• United States
• Gambling Facilities and Casinos
• 300 - 400 Employee

• Senior Database Developer

  • Dec 2019 - Present

  • Work on R&D team doing research and development of new components utilizing all toolsets available in each version of Oracle from 11g to 19c. • Responsible for building and uploading patches into different environments for Konami products using KGPatch tool. • All new development and support done utilizing Oracle PL/SQL, packages, procedures, functions, pipelined table functions along with Edition-based redefinition (EBR) coding. • Work in the office and remotely while successfully solutioning production support tickets for existing customers. Show less



SymphonyAI Retail CPG

• Software Development
• 500 - 600 Employee

• Senior Technical Consultant for both PetValu Conversion Project and Global Partners Project

  • Oct 2018 - May 2019

  • Worked as the Lead Technical Consultant on site to help the client with their definition each of the conversion pieces for the PetValu.• Created over 50 SQL and Unix shell scripts to efficiently drop and reload all tables with the cleansed conversion data.• Created the Technical conversion deliverable document for the client, with the cleansing responsibilities, iterations and conversions defined.• Worked from home as Technical support for Global Partners, loading data from spreadsheets into our Web application using our toolsets that utilize Visual Basic, Microsoft Visual Studio and SQL Server databases. Show less

• Senior Technical Consultant for Longo Brothers Fruit Markets Implementation

  • Mar 2016 - May 2019

  Participate in different phases of the project (technical design, interface mapping, batching, and support for test and integration phases, pilot launch and deployment of the solution). Helped in creating the required technical documentation, along with the configuration of the various applications.• Responsible for technical tasks associated with the following G.O.L.D modules - Central(MDM) - Store Operations - Store Mobility - Stock - Vocal - Warehouse Replenishment - Vendor Portal• Work support tickets in all areas throughout the project, along with managing the customer expectations.• Work with client to successfully configure both the devices for GOLD Vocal and GOLD Store Mobility.• Help with building several environments from scratch along with helping client maintain structure and functionality through all patching efforts. Show less



OLR

• United Kingdom
• Software Development
• 200 - 300 Employee

• Technical Consultant

  • Nov 2015 - Jan 2016

  • Provide technical support in creating PL/SQL scripts, mapping and files for interfacing between RMS and JDA in support of the new Allocation application to replace existing Mainframe Allocation.• Completed the Integration Specification Mapping document needed to interface the Merchandise and Organizational data correctly per JDA's table specifications from the newly upgraded RMS environment and the mainframe system.• Work with project manager to assure all timelines are met and all technical specifications are done correctly. Show less

• Technical Consultant

  • Jul 2015 - Oct 2015

  • Provide technical support for Phase 1 pre-go live interface testing in RMS and RPM with version 14.1 of these applications. • Help with Unit Testing of the setup and execution of RPM price injector batches for price changes, promotions, and clearances.• Work with separate team leads to assure the functional expectations and technical specifications are on track.

• Conversion Lead

  • Jan 2014 - Jun 2015

  • Lead the conversion implementation through six successful conversion cycles in a multi-lingual implementation of Oracle Retail v13.28 (RMS, RPM, ReIM and SIM).• Provided technical support along with ensuring project compliance with OLR Methodology and Standards with the conversion data mapping documents.• Maintained the Conversion run book with all tasks expected for each of the conversion cycles.• Maintained the issue log for the six conversion cycles along with providing status reports to the executive team.• Maintained the project plan for all the conversion cycles to assure they stayed in-sync with the full project plan.• The project was a success and went live on-time and under budget. Show less



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Conversion Lead

  • Mar 2013 - Jan 2014

  • Managing the conversion effort from approximately 45 Legacy systems into Oracle EBS R12. • The 137 conversions cover both Master and Transactional data across the multiple disciplines such as: Idea to Opportunity, Quote to Commit, Service the Customer, Record to Report, and Demand to Deliver. • The project includes divisions in 45 countries that include 28 different languages. • My management role encompassed the reviewing of the functional design documents, direction of the extract team in cataloguing over 750 conversion files along with helping with the Document of Understanding(DOU) process. • The role also requires the management of 18 developers both on site and off shore in their transformation and development efforts which equates to approximately over 24,000 development hours. Along with technical design document review and ultimately responsible for the load and reconciliation of all conversion objects. • Responsible for base lining the project plan for all tasks for both manual and automated conversions using Microsoft Projects. Show less

• Technical Lead

  • May 2012 - Feb 2013

  • Technical lead for offshore development team, managing the reimplementation of over 300 RICE objects, using the Panaya tool that identifies and tracks changes to be made from 11 to R12. • Responsible for remediation for all custom reports, forms, packages, procedures, triggers, tables and views pertaining to the Custom Calculated Billing Process Systems. • Responsible for post support of any defects for AP, PO, AR, FA, PO Quotes and Calculated Billing Process.

• Senior Developer/Analyst

  • Aug 2011 - Apr 2012

  • Developed an AR interface used to bring in Tax Locations for India customers from 11i, in order to map them correctly in R12 for India Localizations. • Developed an AP extension used to release holds on invoices by Organization and by specific hold. • Developed an INV extension used to update COGS account and Sales account in base Inventory tables based on the Business Segment from material categories table. • Modified and transformed several 11i Oracle 6i reports to XML Publisher reports in the new R12 environment. • Worked as on-site liaison to India off-shore technical team, to assure user satisfaction for over 30 reports; for which I was responsible for creating all the Technical documents. Show less



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Developer/Analyst

  • Nov 2010 - May 2011

  • Developed new versions of existing PL/SQL packages utilizing new capabilities in Oracles' 11g database. • Developed new functions in 11g, eliminating original hard coding in the 10g database. • Unit tested and created testing scripts along with technical documentation for all objects developed or modified.

• Senior Developer/Analyst

  • Apr 2009 - Oct 2010

  • Created an outbound consumption interface designed to track all pertinent information regarding daily inventory consumption of consigned items for specific suppliers, using PL/SQL packages, procedures, and functions executed through a concurrent manager job. The interface was to be used to record all consigned material transactions consumed for a specific timeframe for any supplier, by using custom tables to hold all history per supplier. • Led a couple of other developers in the design, development, and support of the Direct Purchase Process, which consisted of three interfaces, one outbound and two inbound. The creation of the outbound direct purchase interface was to send all initially approved PO's and subsequent update PO's to pre-defined suppliers, using PL/SQL packages, and procedures. This outbound interface began by automating all PO’s and Releases being sent out instantly on Approval of document by using table triggers to track all history for documents in custom tables. Flexibility was achieved by custom tables utilized to determine whether the documents were to be sent to just the Supplier, or just the Freight Forwarder or both. The inbound interface automatically handled any changes from suppliers keeping both in sync. • Responsible for conversions for Purchase Orders and Requisitions for Colombia implementation, by modifying existing PL/SQL packages, procedures and functions used for US conversions. Show less



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Reporting Lead

  • Jun 2007 - Jan 2009

  • The reporting lead of developers both on shore and off, for the IBM development team in the implementation of Oracle’s 12i suite. Reports were delivered for all modules, Financials, Purchasing, Order Management, Projects, BOM and Inventory, using Discoverer, Oracle 6i and XML Publisher. • Worked with users to design highly complex reporting structures using Reports 6i, that created dynamic reporting through parameterization and multiple layout constructions for each report, allowing for the reduction of reports from over 400 to 100. • Designed and developed a multi-functional invoice template using XML Publisher, so that the client would only have one invoice, but different layouts defined, depending on the department using the invoice. • Used Discoverer to create a moderately complex AP report used to calculate closing journal entries for custom AP processes, with dynamic parameters for the multiple uses and users involved. Show less



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Developer/Analyst

  • Mar 2006 - Dec 2006

  • Designed and developed conversions and interfaces for GL and AP, with one of the AP interfaces utilizing Unix scripting and PL/SQL packages and procedures executed through a concurrent manager job. • The conversions included the AP invoice history of checking for duplicate invoices and the year to date 1099 reporting conversion, both conversions utilized custom tables and custom fields in standard tables to capture and identify specific data for either conversion. • Interfaces included a chart of accounts values to boundary systems used generically by any boundary system. The GL balances and activity to budgeting and consolidation systems interface. • The AP positive pay interface which utilized one of 3 .RTF layouts of files depending on which bank is executing the process, using PL/SQL package and procedures tied to a concurrent manager job. • The EFT interface consisted of 7 different concurrent manager jobs, in order to create the correct EFT for the 3 different banks that had 6 different layouts expected. The interface uses unix scripting to call PL/SQL procedure to track history, then format the EFT files differently for each of the 6 different layouts before transmitting the file to the appropriate bank mailbox server via a PGP encrypted FTP. Show less

• Senior Developer/Analyst

  • Nov 2005 - Mar 2006

  • Designed technical specifications for AP, GL, CE, and PO interfaces. These interfaces were for both inbound and outbound with various legacy systems. • Designs included a standard process for multiple banks which minimized the ongoing support for these interfaces. The AP interface was created for regulatory agencies including the state of California.



EchoStar Satellite Services L.L.C.

• United States
• Telecommunications
• 100 - 200 Employee

• Senior Oracle Programmer

  • May 2003 - Sep 2005

  • Technically designing the new implementation of EDI utilizing Oracle e-Commerce Gateway and Sterling Commerce Gentran mapping tool. • Part of Development team that ensured a smooth Re-implementation of Oracle Financials from 11.0.3 to 11i. • Helped to migrated over 30 financial custom objects from11.03 to 11i; including Oracle 6i Reports and Forms. • Developed solution to ensure payables department would continue to have ability to check for duplicate invoices since only open transactions were converted. • Technically led and re-designed 3rd party GL reporting tool FRx, residing on Sql Server Database and interfacing with Oracle’s database utilizing Informatica as the job scheduler. Show less



Compri Consulting

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Oracle Consultant

  • Jan 2001 - Dec 2002

  • Helped to resolve regular production problems with Oracle Financials 10.7, in General Ledger. • Worked with customized Oracle Revenue Accounting module using the 11.0 concurrent manager and 6.0 forms. • Created Summary Template process that identifies all modifications to summary accounts as often as needed. • Unix scripting used for custom jobs that automate daily steps, interface data, report data and notify users. • Helped to resolve regular production problems with Oracle Financials 10.7, in General Ledger. • Worked with customized Oracle Revenue Accounting module using the 11.0 concurrent manager and 6.0 forms. • Created Summary Template process that identifies all modifications to summary accounts as often as needed. • Unix scripting used for custom jobs that automate daily steps, interface data, report data and notify users.



Ajilon

• United States
• Staffing and Recruiting
• 700 & Above Employee

• Senior Programmer/Analyst

  • Oct 1998 - Jan 2001

  • Responsible for Accounts Payable Y2K fixes utilizing; PL/SQL, SQL Plus, Forms, 2.3 & 4.5, Reports 2.5, SQL Loader and Smart DB. • Resolved regular production problems with Oracle Financials 10.7; in Accounts Payable and General Ledger, Oracle Manufacturing, Purchasing, inventory and Order Entry. • Technical lead for EDI Purchase Order Project involving documenting business requirements/project design. • Responsible for creating a procedure to fix a problem with the GL balances table not rolling balance for the whole year for one of the sets of books; that way the company could get correct FSG's and close the year. Show less



International Arabian Horse Association

• Greater Denver Area

• Programmer/Analyst

  • Sep 1997 - Oct 1998

  • Maintained and created reports using Reports 2.5 and Reportwriter 1.1 and forms using Forms 4.0 and 2.3 for both Oracle Financials and IAHA's customized Oracle systems. • Worked directly with users to establish business requirements for customized reports and forms. • Helped with the mentoring of a new oracle programmer. • Created an IAHA Youth Achievement and Membership Program utilizing Forms 2.3 and Reportwriter 1.1. • Maintained and created reports using Reports 2.5 and Reportwriter 1.1 and forms using Forms 4.0 and 2.3 for both Oracle Financials and IAHA's customized Oracle systems. • Worked directly with users to establish business requirements for customized reports and forms. • Helped with the mentoring of a new oracle programmer. • Created an IAHA Youth Achievement and Membership Program utilizing Forms 2.3 and Reportwriter 1.1.



Allied Signal Aerospace

• United States
• Biotechnology Research
• 1 - 100 Employee

• Systems Analyst/Programmer

  • Oct 1995 - Sep 1997

  • Maintained Oracle Financials 9.4.2 A/P dealing directly with users, utilizing Forms 2.3 and Reports 3.0. • Assisted with project design for new unique application, NASA PR/PO system, using SQL Menu and Case tools. • Assisted with construction of new system, utilizing Forms 3.0, Reportwriter 1.1, PL/SQL and SQL Plus. • Maintained Oracle Financials 9.4.2 A/P dealing directly with users, utilizing Forms 2.3 and Reports 3.0. • Assisted with project design for new unique application, NASA PR/PO system, using SQL Menu and Case tools. • Assisted with construction of new system, utilizing Forms 3.0, Reportwriter 1.1, PL/SQL and SQL Plus.