SUMMARY:

• Highly motivated, experienced data professional with extensive hands - on experience in business/data analysis, requirements gathering, database design, systems integration, PL/SQL development, oversight management and post-implementation support of complex database applications using various ERP and B2B Systems (e.g., Oracle Financials, Oracle Supply Chain, Avalara Tax Solutions, FICO Debt Manager Collections and Recovery, CommerceHub Unified Drop-Ship Network, Optoro Retail Returns Portal) interconnected with custom home-grown in house developed applications.
• Experienced Oracle ERP Backend Manager/Senior Systems Analyst with over twenty-five years of cumulative IT experience in application architecture, database design, PL/SQL development, functional configuration, implementation, and support of Oracle EBS Applications.
• Proficient in software development lifecycle models: Agile and Waterfall.
• Excellent reputation as a meticulous detail oriented, team player with strong programming /analytical abilities and outstanding interpersonal skills.
• Twenty-five plus years of experience using Oracle Tools in Application Programming, System Analysis & Design, Requirements Gathering, Design Documentation, Data Conversions, SOX Compliance, System and Module Maintenance, Data Integrity Analysis and Data Modeling.
• Broad knowledge of logical and physical Data Modeling using normalizing.
• Integral part of numerous full life-cycle projects: including 2 Oracle Upgrade Projects, 2 Mainframe to Oracle ERP Conversion Projects, 2 Ecommerce to Oracle EBS Integration Projects, 5 extensive Third Party B2B Portal to Oracle EBS Integration Projects.
• Areas of expertise include technical developments and keen functional knowledge in Oracle EBS Modules: GL, AP, AR, PO, Order Management, INV, Oracle Projects.
• Extensive experience using PL/SQL in the development of complex database objects and the utilization of advanced database/programing techniques: Stored Procedures, Functions, Packages, Triggers, Constraints, Indexing, Views, Materialized Views, Synonyms, Sequences, Ref Cursor, Dynamic SQL, PL/SQL Tables, Bulk Collect, SQL Performance Tuning, HINTS, Exception handling.
• Served as an IT partner with Treasury Department Leadership in providing technical/functional subject matter expertise in Customer Contract Portfolio Management to assist in the process of securing capital market financing.
• Directly assisted the CFO, Chief Accounting Officer, Controller and Accounting Staff as a subject matter expert in the Revenue Recognition and Gross Margin reporting process in support of EBITA
• Supported Executive Leadership with functional/technical expertise ensuring system processes adhere to company’s Credit Management Policy, minimizing credit risk and optimizing cash flow.
• Operated as Technical Tax Analyst ensuring all sales tax transactions were systematically stored and transmitted in accordance with all regulatory and compliance requirements providing monthly audit summary reports to the Tax Accountant.
• As a Supply Chain Management Functional/Technical SME interfaced with the Supply Chain/AR/AP departmental leaders and end users in the generation/transmission of purchasing data to and from third-party vendors for drop ship customer orders. Partnership also included Reverse Logistics processing in terms of the customer returns valuation and the customer credit accounting applications.

TECHNICAL SKILLS:

Data Science Skills and Tools: Exploratory Data Analysis (Variable Identification, Univariate analysis, Bi-Variate analysis), Data Pre-processing, Customer Profiling, Logistic regression, Multicollinearity, Finding optimal threshold using AUC-ROC curve, Decision trees, Pruning, Hypothesis Testing, a/b testing, Data Visualization, Statistical Inference, Bagging Classifiers(Bagging and Random Forest), Boosting Classifier(AdaBoost, Gradient Boosting, XGBoost), Stacking Classifier, Hyperparameter Tuning using GridSearchCV

Microsoft Products: Microsoft Excel, Word, PowerPoint, Access, Microsoft Projects

Oracle eBusiness Suite R12: Oracle Financials (AR, AP, GL, FA), Oracle SCM (OE), Oracle Procurement (PO)

Database Systems: ORACLE RDBMS 12/11/10G/UNIX

Oracle Application Tools: Alerts, Financial Statement Generator (FSG)

Oracle Technology Products: Oracle XML Publisher, Oracle Workflow, Oracle Application Framework (OAF)

Oracle Development Tools: TOAD, PL/SQL Developer, SQL*Loader, Developer, Oracle Forms 6i, Oracle Reports 6i, Oracle Discover 4i, Application Object Library (AOL), SQL Script, UNIX Shell Scripting

Languages: PL/SQL, Python/Pandas, PHP, SQL, SQL*PLUS

Methodology: Agile, Waterfall, Oracle AIM

Mainframe Tools: Assembler, SAS, VSAM, Syncsort, TSO, JCL, Roscoe

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Oracle Backend Manager

Responsibilities:

• Designed, Developed, Tested and Implemented a solution to reduce reconciliation issues related to legacy Revenue Recognition and Customer Open Receivable Invoice set up.
• Migrated multiple open receivable invoices linked to a Customer Contract to a single source open receivable invoice.
• Introduced Line Level Revenue Recognition Invoice to move Deferred Revenue to Actualized Revenue as shipping notifications received.
• Identified all systems, processes and applications affected by new configuration.
• Designed, developed, tested and implemented solutions to retro fit all affected systems, processes and applications to new configuration .
• Updated GL Accounting Set Up to accommodate new configuration.
• Architected, Re-engineered and Streamlined legacy Revenue Recognition process from an Order Level Revenue Recognition procedure to a Line Level Revenue Recognition procedure.
• Developed, Tested and Implemented new Line Level Revenue Recognition process.
• Allowed Confidential to recognize revenue faster as revenue now recognized as individual items ship instead of waiting for shipment of all items on the order.
• Designed, Developed, Tested and Implemented a streamlined process to improve customer return experience and facilitate accounting transactions in a timely manner.
• Streamlined process linked eCommerce front end, Order Management, Purchasing, Accounts Receivable. Accounts Payables and Third-Party vendors in an automated manner where 90% of returns could be processed hands off.
• Designed, Developed, Tested and Implemented an End-to-End AP ACH Payment Process that integrates Oracle AP payment processing with Confidential ’s CashPro to facilitate Oracle AP ACH vendor payments.
• Utilized Eprentise Software to transform GL Accounting Segment from 5 to 8 Segments as well as reorder segments.
• Developed Deployment Plan in consultation with the business for COA Implementation
• Executed Post Go-Live Validation (Trail Balance Verification) Pre and Post Go-Live
• Execute Post Validation (Oracle R12 Drop Ship Cycle) to bring Oracle Processing back on-line
• Designed, Developed, Tested and Implemented automated process to extract, validate and propagate Orders from eCommerce site to Oracle Order Management.
• Designed, Developed, Tested and Implemented a purchased item interconnection between a child and parent item where the linkage could be traced throughout the eCommerce Storefront, Oracle EBS and fulfillment Supplier.
• Functional/Technical Lead for Upgrade
• Analyzed all custom code (PLSQL, Unix Shell Scripts, Forms and Reports) for upgrade issues and coordinated with a team of programmers ensuring all issues resolved
• Created Functional/Technical documents using AIM Methodology
• Designed, Developed, Tested and Implemented a Month End Closing Customer Contract Portfolio Management Datamart based on Business Requirements.
• Portfolio Datamart contains contract data sourced from data found in Oracle AR, GL and OE modules as well as data stored in custom data structures including eCommerce Storefront. Sourced data is summarized in monthly snapshots.
• Created a process to reconcile the AR/GL data fields in the Customer Contract Portfolio Datamart to Oracle GL Trail Balance report
• Created a process to Reconcile Sales Tax liability transactions calculated in Oracle AR to the Sales Tax liability committed in the Avalara Sales Tax System as well as the Sales Tax Liability determined on the eCommerce Storefront.
• Provided any production support to ensure business users can close Oracle Modules in a timely manner.
• Developed and validated queries on an as needed basis to quickly answer questions raised by business users regarding business metrics, accounting anomalies and financial audit disputes as well as providing financial audit supporting details.
• Designed, Developed, Tested and Implemented a solution that captured the output from the daily reconciliation process between cash deposits and loaded AR Remittance Batches and systematically stored that output into custom data structures to be used for further process improvement.
• Reduced the time it took the Treasury Analyst to determine contract cash balance based on AR Remittance Batches where cash had been received and the subsequent contracts to which the corresponding receipts had been applied.
• Reduced the time it took the Treasury Analyst to determine contract pre -load balance based on AR Remittance Batches where cash had not yet been received and the subsequent contracts to which the corresponding receipts had been applied.
• Designed, Developed, Tested and Implemented a Hardship payment adjustment process for customers effected by COVID Pandemic based on business requirements.

Confidential, Atlanta, GA

Oracle EBS Consultant

Responsibilities:

• Monitored daily support inbox, prioritized and resolved internal support tickets.
• Processed Client implementations and enhancements requests.
• Designed and Developed New Strategic Initiative Projects based on business requests.
• Enhanced current processes based on business requests.
• Provided Documentation and trained users on applications.
• Opened, managed and resolved SRs with Oracle Support

Confidential, Atlanta, GA

Systems Analyst Lead

Responsibilities:

• Led users and business unit managers in all aspects of SDLC process for upgrading AR, PA, GL and all Custom Applications.
• Created Functional/Technical documents using AIM Methodology - BR.100, MD.120, MD.50 & MD.70
• Designed and implemented Discoverer 4i end user layer for business intelligence using Discoverer with Oracle Applications 11i
• Responsible for Multi-Org Set Up and Implementation
• Upgrade and create custom Oracle Application module extensions using Forms, Reports, PLSQL and Unix Shell Script
• Provided quality assurance, adhering to SOX compliance standards. Created end to end test scripts using Mercury Test Director
• Provided post implementation production support.
• Member of technical project team for the GEAC Legacy System/Oracle Financial 11.5.10 Conversion
• Designed and developed interfaces between Oracle AP and Acorde (Invoice Imaging System)
• Technical Lead of AP Conversion
• Develop, Maintain, and Enhance custom payment interfaces between Oracle AP and third-party systems (SunTrust, CIBC, WORKS) including Supplier payments (ACH, PCARD, Outsource Checks and in house Checks), Employee ACH and Positive Pay
• Created numerous audit and informative reports pertaining to payments, invoices, suppliers, employee set up, bank account set up, AP/GL cash clearing accounts, AP/PO 2- and 3-way matching
• Develop, Maintain and Enhance custom process to load employees, create suppliers and create bank accounts
• Designed, Develop and Implemented Custom App Framework and subsequent Applications in Forms 6i for Credit Market Services Group
• Developed in house Pricing Advice Application (Forms 6i) that interfaces with Oracle AR
• Developed Sales Forecast Application (Forms 6i) integrating forecast, budget and revenue data
• Developed Mainframe Tape Tracking Application (Forms 6i)
• Maintained and enhanced Revenue Sharing Application (Forms 6i) that integrates Oracle Project Accounting and Oracle AR
• Coded numerous interfaces with various Oracle Modules in Oracle E-Business Suite
• Supported 300+ Users located around North America on various Oracle Modules as well as all home-grown custom applications integrated in with Oracle 11i
• Developed a “Trusted Advisor” relationship with users
• Provided Documentation and trained users on applications
• Opened, managed and resolved SRs with Oracle Support

Confidential, Atlanta, GA

Senior Programmer Analyst

Responsibilities:

• Design, develop and validate application programs in system support capacity emphasizing clarity, maintainability and efficiency of program code.
• Function as an internal consultant, advising on coding techniques, system usage efficiency, error correction and departmental programming standards.
• Develop, track and prioritize programming schedules on multiple projects in high pressured, deadline-oriented business.
• Streamlined production processes so tactical departmental goals could be achieved, such as improving project turnaround time and reducing project processing costs.