Paulson Anthony SR. Oracle Developer – Oracle Forms/PL/SQL / ERP

adxv8d@r.postjobfree.com

+1-614-***-****

Summary:

● Oracle Professional with 10+ years US experience in various roles as a Software Engineer / Developer/ Designer/ Architect with in-depth knowledge of Oracle 12c/11g/10g/9i Forms, Reports / PL/SQL etc.,

● Capable of handling software projects with full-fledged experience in all aspects of SDLC, IT operations, Change Management, Performance Improvement Techniques etc.

● Expert in Data analysis, Query optimization, ETL and Database solution design and development using Oracle, Teradata, Microsoft SQL databases in Health Care, Retail, Banking, Salesforce CRM and Manufacturing domains.

● Application Migration experience from Teradata to Oracle 11g/12c.

● Expert in Creating Stored Procedures/Packages, Functions, Database Triggers, Materialized Views, Ref Cursors, Collections with Bulk Operations, Creating/rebuilding indexes, adding partitions, analyzing tables, using Optimizer Hints, Analytical Functions, XML Mapping etc.

● Expert in developing application software using Oracle Forms, Oracle Reports, SQL, SQL*PLUS, PL/SQL programming, WEBUTIL, TOAD, SQL Navigator, SQL*Loader/Data Pump, PL/SQL Developer, VB.NET, Crystal reports etc.

● Expert in creating interfaces to external systems, conversion programs to transfer data from legacy stem to new systems, IT Project Management, Database and Application system administration, System integration, preparing technical design, planning and executing data conversion activities, driving test planning, execution, Prepare UAT scripts, documentation etc.

● Experience working in an Agile/Scrum environment, Strong knowledge of OOD, software design patterns and principles.

Technical Skills:

RDBMS Oracle 12c / 11g / 10g / 9i, SQL Server, MS- Access etc. GUIs Oracle Developer Suite (Forms and Report

12c/11g/10g/9.0/6.0), Oracle Discoverer, Oracle

Designer, JDeveloper, SQL Developer, SOA, Application Development Framework, Oracle Application

Framework (OAF), Oracle Enterprise Manager (OEM),

XML Publisher, Visual Basic .NET etc.

Languages SQL, PL/SQL, Visual Basic .Net, C#, Oracle workflow etc. Reporting Tools Oracle Reports, Crystal Reports etc. Software Tools Toad, SQL Navigator, PL/SQL Developer, SQL developer, SQL Trace, TKPROF, Visio, Erwin, Source Serena PVCS Version Manager, CVS (Source

Configuration Management -SCM), ECMS (Enterprise

content Management system), HP Application Lifecycle Management (ALM), JIRA, Microsoft Office etc.

Web Technologies HTML, DHTML, XHTML, JavaScript, Ajax, XSL, CSS, J2EE, Web Services etc.

Operating Systems UNIX / Linux, Windows etc.

Middleware JDBC, ADO, RDO, ODBC, OLE etc.

Network LAN, WAN, VPN, Wireless etc.

Pro fessional Experience:

FDACS (Florida State Govt. Project). Nov 2022 Onwards SR. ORACLE LEAD DEVELOPER

Responsibilities:

● Design and Develop new interfaces for Revenue System / Finance Application Modules using Oracle12c Forms and Reports, PL/SQL and involve in code reviews etc.

● Develop/Enhance DB Packages/API's for INBOUND/OUTBOUND operations across multiple system at remote locations.

● Create Application Interface for PII Systems with XML files and work with XML Queries for extraction of various components in the applications, UTL_FILE package for file handling etc.

● Work in UNIX/Windows environment for working with Application/Database servers for various operations etc.

● Create PL/SQL packages for data extraction, SQL and PL SQL performance tuning etc.

● Create Logical/Physical Database designs and prepare ERD for multiple DB Schema.

● Troubleshoot application for various issues and enhance the system process flow.

● Prepare Technical design document and Process Flows for new and existing system and support UAT/Production release.

Cummins Inc. Apr 2022 to Oct 2022

SR. ORACLE LEAD DEVELOPER

Responsibilities:

● Develop new interfaces for AR/Finance application Module using Oracle forms, PL/SQL etc and involve in code reviews.

● Develop/enhance packages/API's for INBOUND/OUTBOUND operations across multiple system at remote locations.

● Create PL/SQL packages for data extraction, SQL and PL SQL performance tuning etc.

● Create reports for Service and Finance Modules in OneBMS application.

● Troubleshoot application for various issues and enhance the system process flow.

● Prepare Technical design document and Process Flows for new and existing system and support UAT/Production release.

Newell Brands Jun 2020 to Mar-2022

SR. ORACLE LEAD DEVELOPER

Responsibilities:

● Create PL/SQL Packages for data extraction, SQL and PL SQL performance tuning etc.

● Create concurrent programs for reports activities for various SCM, Financial Modules etc.

● Upload and Download .ldt files in UNIX environment using FNDLOAD utility for Concurrent programs, Value sets, Request groups, Profiles etc.

● Setup necessary application Responsibilities, Run Concurrent program manager activities for error handling and other functionalities.

● Design system, Data analysis, Extract files to various networks, file handling using UTL_FILE operations etc.

● Prepare SOX- AuditTrial setup for application, create Oracle reports, forms for application enhancement and modifications.

● XML Publisher reports and RTF Template preparation for new reports / modify existing reports.

● Data extraction and upload data between various systems for Order Management, Inventory, Supply chain, Financial modules etc.

● Maintain Data quality, data security for Application/file handling and business operations.

● Create database objects( Package, Function, Synonyms, Materialized views, database triggers etc), Prepare scripts for Grants, Create Oracle Directories.

● Prepare Technical design documents based on MD50, Prepare MD120 for Project implementation, Prepare scripts for UAT, implement developed objects and functionalities in development and other schemas as and when required.

BANK OF AMERICA

SR. ORACLE DATABASE DEVELOPER Feb 2019 to Dec-2019 Responsibilities:

● Develop best practices, processes, and standards for effectively carrying out data and code migration activities. Create/Modify new/existing SQL/PL/SQL codes for various corporate business Applications.

● Perform migration and testing of static data and transaction data from one database to another.

● Converted JCL Embedded SQL from Teradata to Oracle Syntax equivalent and assist the ETL process

● Convert Netezza code to Teradata for Bank of America - WLF and CORP systems.

● Identifying USHARE tables, involving respective users to test the script in their environment.

● Create/Modify complex SQLs using joins, sub queries and correlated sub queries. Reporting defects, new patterns and code conversion etc.

● Perform migration and testing of static data and transaction data from one core system to another.

● Perform source data analysis in order to manage a source to target data mapping.

● Work with subject matter experts and project team to identify, define and communicate the data migration Requirements.

Environment: Oracle 11g/10g Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, Unix/Linux & Windows. FDA (Food and Drug Administration) March 2015 to Jan 2016 SR. Application Software Engineer

Responsibilities:

● Develop and maintain application software for the FDA MARCS system using Oracle11g/10g Forms,Reports, PL/SQL, Erwin, SQL developer, TOAD etc.

● Develop API/Packages for Transaction Processing and Data extractions etc. SQL Query tuning, Create PL/SQL packages, PIPELINED Functions, materialized views, Database triggers for audit and transaction processing.

● Troubleshoot software defects and implement new software solutions using various software's and tools. Create MDCR script for Production database deployments etc.

● Design and develop new forms/reports for enterprise application modules, code review and manage SVN repository configuration. Participate in business requirement gathering meetings, UAT and production deployment releases etc.

● Identify data discrepancies, data quality issues, and ensure data consistency and integrity. Environment.

Oracle 11g/10g Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, Unix/Linux & Windows. Oracle / Micros Systems Inc. Sep-2013 to July-2014 Software Engineer

Responsibilities:

● Develop and customize new/existing application software's using Oracle tools (Forms, Reports, PL/SQLetc.), in Scrum/Agile software development methodology, Modular application development to enable software systems reusable with object oriented principles (OOP), write functional specifications, design documentation, coding, unit testing, debugging, integration, source code review, performance tuning, and maintenance of software modules.

● Manage competing priorities for business and Technology requirements, Participate in User Acceptance Testing phases for defect fixes, enhancements etc. and provide necessary solutions to meet the goals

● Create complex Oracle reports that utilize multiple queries with bind and lexical parameters, parameterized forms, multiple groups and levels of repeating frames, calls to PL/SQL packages, procedures and functions, formula and summary columns etc.

● Develop API for integrating various interface applications, provide guidance, assistance, and technical leadership on complex large projects. Create business events, provide translation features for multiple languages, securities to applications through application permissions, encryption and transformations etc., Identify data discrepancies and data quality issues, and ensure data consistency and integrity.

● Develop packages, database triggers and all other database objects. Solve technical issues in development, QA, Production application/database environments.

● Provides Application and database tuning along with complex system development for the various business needs.

● Create business events, provide translation features for multiple languages, provide securities to the applications through application permissions etc.

● SQL Query tuning, providing adequate security to the application data through encryption and transformations etc.

● Involved in regular meetings/discussions with business analysts, project managers, end users, team members, production support personnels, customers for maintaining systems and developing enhancements.

Environment: Oracle 11g/10g Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, Unix/Linux & Windows. Tomax Inc. Jan-2012 – Aug-2013

SR. Oracle Programmer

Responsibilities:

● Create Optimized PL/SQL procedures to load huge tables and provide support by offering suitable technical design and security standards to the POS systems, design and develop necessary database objects for ETL operations for various RetailNet/Financial cloud business systems.

● Maintain headquarter and store functions within Retail.net© software products.

● Design, develop software applications (Scrum/Agile software development methodology) and provide software solutions for various production issues, participate in design and code reviews, write required design and analysis documents for related applications.

● Participate in various development activities of Merchandise Management and Store Operations and involve in other projects and tasks as assigned by the management/Team.

● Provide PL/SQL development and support to the Java POS.

● Create Database packages to upload data to the RetailNet cloud system.

● Provide detailed and enhanced Technical System design for new projects.

● Executes Enhanced system support and provides guidelines and solutions to their various client systems installed in multiple servers and locations.

● Provides Application and database tuning along with complex system development for the various business needs in the RetailNet application development. Environment: Oracle 11g/10g Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, Unix/Linux & Windows. Mississippi State Department of Health - MSDH March 2009 - Oct-2011 SR. Oracle Analyst Programmer

Responsibilities:

● Customized forms and reports in MDI Application to meet the business requirements.

● Designed new forms and reports for Amortization, Scheduling, Loan Project Details and Amendments of Loans/Grants etc. using oracle forms for Mississippi State Water supply loan management system.

● Applied various business rules for better functionality and performance.

● Worked with object libraries and APIs, Created complex Master detail forms based on procedure based blocks.

● Applied best practice for error handling through user defined exceptions etc.

● Completed data conversion and migrations as per the project requirements.

● Created complex queries for reporting. Analyzed and translated business requirements into reports Developed complex Oracle reports utilizing the multiple queries, multiple groups, PL/SQL packages, procedures and functions, formula and summary columns etc. Wrote various testing scripts and test plans to assist unit testing.

● Modified/Created Database triggers, Packages, Procedure and Functions according to the application requirements.

● Provided support for the existing systems by offering suitable technical design and security standards.

Environment: Oracle 11g/10g Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, Unix & Windows.

Contact this candidate