PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle EBusiness Developer /DBA / Architect

Responsibilities:

• Lead the scoping, solution design, architecture, estimating, and implementation planning aspects of Oracle EBusiness, Datawarehousing / Anaytics, Oracle Cloud ERP and HCM implementation engagements ensuring high quality, integrated software solutions.
• Combines a deep understanding of technology, applications, industry best practices, business processes and architectural patterns to drive IT transformation initiatives that meet the business objectives of customers.
• Conduct strategy, architecture, roadmap and planning workshops providing assessment of current state architecture and recommendation of future state architecture. Provide detailed sizing recommendations and associated justification.
• Cloud Solutions Architect Focused on providing services for the Cloud Integration and API management in helping customer connect applications, such as CX, CRM, HCM, E - Business Suite as the endpoints.
• Oracle DBA (12c, 11g), Oracle Application DBA (12.2, 11.5.10) & SQLSVR DBA supporting production and test instances, applying patches, upgrades, automating routines, cloning test instances, periodic refreshes, Configuring and administering Oracle Exadata & Database Appliances, Proficient with RMAN, ASM, ODI, Goldengate. Helping develop an overall ERP engagement strategy, architecting Transaction processing and Reporting solutions.
• Techno Functional EBusiness Architect proficient in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries
• Multiple full lifecycle Implementations R12 with GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, E-business tax and Sub ledger Accounting (SLA) .
• Solid understanding of integration of Oracle Applications modules, Systems Administration, User Security Administration, Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Expertise in AIM Methodology to enrich project management and documentation processes.
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.
• Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.
• Collaboration with the Business users during the various stages of project lifecycle.
• Wide experience in requirement analysis, GAP analysis, Data Modeling, Data Flow, Data Analytics, Fintech functionals, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system), Uploads ADI /ADFDI / FBDI / BIP, REST API’s, SOAP WebServices.
• Developing Human Resource Recruitment & Management System (ThreeWiz)

Confidential, NY

Oracle EBusiness & Database Administrator

Responsibilities:

• Managed core technologies of Mortgage Banking business by identifying and implementing strategies and programs in collaboration with Mortgage Banking, Accounting, Cash Management, Remix (Insurance), HR, IT Departments.
• Driving Technology Management with key focus on analyzing industry trends, define strategy, and thought leadership; Driving synergy across People, Process and Technology in delivering business excellence.
• Sole DBA administering all Production Databases, EBusiness (including workflow), OBIEE, Mortgage Billing, Benedict (Mortgage Application - SqlSvr), Emphasys and XRT (Cash Mgt).
• Upgraded Oracle Apps (from 11.5.9/9i to 12.2/12c), resolved long standing contentions in Forms Server, Workflow and Database performance issues.
• Implemented NetIQ alerts to email all database, user and server errors.
• Implemented standby instance at Dewitt Disaster Recovery Site.
• Implemented RMAN Backup for APPS and XRT Databases.
• Troubleshooting Oracle EBS issues including performance, WorkFlow, Forms, Reports and Concurrent programs and processes
• Performed 11i cloning to support projects when no documented method existed
• Successful 11i platform migrations from Windows 2003 env to Oracle Enterprise Linux (OEL 4)
• Mentored development teams on best practices for Oracle EBS development methodologies
• Research, plan, coordinate and perform patch, clone, maintenance activities to reduce service window
• Design/deploy technical architecture to securely (DMZ) support EBS products (iExpense, iSupplier, etc.)
• Deploy non Oracle Database integration with EBS (Emphasys, Benedict) using HSODBC / DG4ODBC
• Support and troubleshoot application tier issues with 9iAS, 10gAS, WebLogic, http/https, etc.
• Perform installation and configuration of Oracle databases from release 9 through 12c in different platforms
• Perform database architecture design and deployments to support large document management and data warehousing applications with high-availability requirements
• Developed document mgt integration between EBS & Markview 170 Systems, Kofax (document management and capture solution)
• Automating loads to Oracle EBS, Troubleshooting ADI issues
• Developed Discoverer reporting solutions for Oracle EBS, non EBS & nonOracle applications
• Setting Up and Administering ETL and Datawarehouse infrastructure (Informatica, OBIEE, DAC)
• Automated process to handle data warehouse loads from Informatica
• Upgraded OBIEE 10G to 11G (Weblogic)
• Designed and oversaw the successful product delivery of several key business intelligence and analytic applications including Bank Account & Statement management, Cash Forecasting & Positioning

Confidential, NY

Oracle Financial Systems Architect

Responsibilities:

• Trading platform & Analytics (FENICS) Backend developer, integrating platform with Oracle Receivables, General Ledger.
• Rearchitecting Trading Platform backend software stack to support SOX Compliance, trade automation, predictive analytics, higher data volumes, faster speed.
• Built execution management, analytical, and automation solutions to provide financial professionals with an integrated multi-asset class trading platform to manage their order lifecycle, monitor real-time analytics, and connect with multiple broker destinations and trading venues globally.
• Built Oracle custom modules covering trading functionality across a wide range of asset classes, including equities, options, futures, sovereign and corporate bonds, FX, repos, mortgages, derivatives.
• Manage Oracle ERP 11i Integration projects through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support. Managing project issues, Status reporting, Client/Project team coordination and risk mgt.
• Effectively training, motivating and mentoring onsite and offshore Analysts, engineers, developers involved in the Oracle 11i (11.5.7) GL, AR, and Payables implementation.

Confidential, Stamford CT

Oracle Applications (EBusiness) DBA, Applications Developer

Responsibilities:

• Oracle Financials and HRMS (General Ledger, Account Receivables, Account Payables, Purchasing, Fixed Assets, Order Entry, HR/Payroll modules) Techno-Functional Architect. Setting up applications, developing custom API’s to migrate legacy data into Oracle Apps and developing software to automate financial statement generation and distribution to field offices.
• Handling general maintenance and upgrade issues for Oracle Financials (AR, AP, GL, FA, OE), Oracle HR/Payroll. Troubleshooting Applications issues, working with Oracle Support, applying yearend patches, tuning database, concurrent processing, payroll run, SQL statements. Developing concurrent programs, Request Sets, managing concurrent requests, Tuning Concurrent Managers.
• Administer Financials and several custom databases, cloning new instances, applying patches, upgrades, database replication, refreshing TEST instances, developed numerous DBA utilities, wrote programs for monitoring database and applications, uploading data into APPS from interface tables, implementation of backup procedures.
• Was involved in implementing the Procure to Pay (P2P) cycle and Set up of Oracle PO/AP modules, conversion of static data(Vendors, Employees) and dynamic data (PO, Receipts, AP Invoices), AME Approval process, ASL and Souring Rules, Blanket Purchase Order, Release, OSP operations in manufacturing, maintains Supplier and sites, Bank and Branches, AP to GL transfer
• Handling Month-End balancing and financial reporting; Developing and troubleshooting Journal Import Routines, Budget upload from spreadsheets.
• Developing Software & Business intelligence tools with Cognos Powerplay / Impromptu

Confidential, St. Louis MO

Oracle Applications DBA

Responsibilities:

• Requirement Analysis, Installing and configuring Oracle Application (11i HRMS on NT), Applying latest Patchsets, VERTEX
• Setting up Oracle HRMS modules with required functionality; Setting up security and user auditing procedures.
• Database Administration, Setting up optimal backup and recovery procedures, Building DBA utilities; Cloning Test Instances.
• Developing custom API’s to migrate legacy data into Oracle Apps; Developing scripts for legacy Migration to Oracle ERP; Data migration and integration with inbound and outbound systems.
• Developed programs to load Employee /Payroll data from interface tables; Configuring HR tables to tune payroll run.