We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

Columbus, OH

PROFESSIONAL SUMMARY:

  • 12+ years of IT experience with Oracle Forms and PL/SQL Developer in the areas of Oracle Database Administration (9i/10g/11g)/Applications which includes designing, developing, deploying, managing and tuning of databases on Linux, AIX, HP - UX Operating system. Extensive experience in DW/ETL Technologies.
  • Strong knowledge in Oracle Cursor management, Exception Handling.
  • Worked on Oracle Forms 3.0/4.5/6i/10g/11g, Reports 3/6i/10g/11g
  • Oracle Forms Migration experience from Forms3.0 to 6i/10g/11g.
  • Coding, testing and debugging programs in COBOL language.
  • Good knowledge of how to load COBOL flat file data into Oracle tables.
  • Installation and Configuration experience of Sabrix Environment.
  • Designed and developed several automations in E-Business tax set up, AP and AR invoice import, Order import and item import.
  • Designed and developed Interface with E-Business Suite and Maximo 6 & 7.5 with the help of PL/SQL triggers, procedures & packages.
  • Expert in implementations and application support.
  • Experienced in Development of Insurance, GL Accounting Management, Personnel & Payroll, Financial management system software.
  • Strong exposure in Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment.
  • Solid experience in translating business requirements into creation of Database Objects.
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures , Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types & Collections .
  • Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
  • Proficient in tuning queries used in the application.
  • Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Expert in Tune SQL Access workload with physical indexes and materialized views .
  • Having good migration experience from Forms 4.5 application to 6i .
  • Experience in advanced PL/SQL concepts like Bulk collect and for all.
  • Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
  • Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Possess excellent oral / written communication and interpersonal skills.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
  • Knowledge about Tableau to create Basic Charts and Reports by using Business Intelligence Data.
  • Oracle 12c SQL Fundamental, OCP 7.3 and Oracle 8 Certified Professional .

TECHNICAL SKILLS:

  • Databases: Oracle 8i, Oracle 9i, Oracle 10g, 11g RAC, Oracle 11g Golden Gate
  • Oracle E: Business Suite Release 11i/12.1.3, Oracle E - Business Suite Release 11.5.9, 11.5.10.2, R12Red Hat Linux, AIX RISC 6000, Sun Solaris 9, Windows 95/98/NT/2000/XP, UNIX.
  • Database Tools: OUI Grid Control, OEM, Putty, DBCA, RMAN, ADDM, AWR, TKPROFToad, DB Visualizer 9.0, SQL*PLUS, STATSPACK, MSACCESS, MSEXCEL, Enterprise Manager.
  • DB Utilities: EXP, IMP, EXPDP, IMPDP, RMAN, SQL*LOADER.
  • PL/SQL, SQL, MF: COBOL, UNIX Shell scripting, XML
  • Developer Tools: FMW 11g, Web Logic Suite 11g, Oracle 10g Developer Suite, Oracle Application Server 10g, Developer / 2000 Rel.2 (Forms/Reports 6i), D2K (4.5), Forms3.0/Report 2.0, Business Objects (BO), Crystal Reports, Tableau 9.0.16

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Oracle Developer

Responsibilities:

  • Primary responsibility in managing Production and Development SR’s.
  • Core responsibility is to support AIMS (Agent Management Information System), modification of existing screen and involve in the designing and development of new screens.
  • Deployment of new screens to the development and test server.
  • Writing Perl scripts which drive the flow of execution involving file loading into the database as per requirement.
  • Creating complex stored procedures, functions, triggers, cursors, packages, indexes, ad-hoc queries, partitioned tables appropriate User defined functions to implement the business logic.

Environment: Oracle Enterprise Linux, Oracle Forms 12c, Oracle Forms 11g Rel.2, Oracle Database 11g, DB Visualizer 9.0, Toad, Import/Export, PL/SQL, Perl Scripting, GitHub Desktop, Urban Code Deployment (UCD), PL/SQL Developer, Informatica 10.0

Confidential, Northbrook, IL

Sr. Oracle Developer

Responsibilities:

  • Worked on CVS-Anthem project to delivering a complete application that is using by technicians, pharmacists and staff to process prescriptions and related activities.
  • Writing tested, idiomatic and documented Oracle PL/SQL and Oracle Forms .
  • Working with modification with the existing forms and back-end packages/procedures.
  • Involved in the development activities of the existing application.
  • Creating complex stored procedures, functions, triggers, cursors, packages, indexes, ad-hoc queries, partitioned tables appropriate User defined functions to implement the business logic.
  • Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
  • Responsible to Installation of Oracle Forms and Oracle Reports latest Fusion Middleware version and configure Forms/Reports services.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Good knowledge on Upgrading Oracle Forms Reports.
  • Strong Experience in front-end and back-end development using Forms 11g/10g/6i, Reports 11g/10g/6i.

Confidential, Chicago, IL

Sr. Developer/Consultant

Responsibilities:

  • Primary responsibility in managing Production and Development SR’s.
  • Creating complex stored procedures, functions, triggers, cursors, packages, indexes, ad-hoc queries, partitioned tables appropriate User defined functions to implement the business logic.
  • Expertise in Oracle SQL, PL/SQL . Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
  • Good knowledge on Upgrading Oracle Forms Reports.
  • Strong Experience in front-end and back-end development using Forms 11g/10g/6i, Reports 11g/10g/6i, Discoverer 10g/9i, XML Publisher, Workflow Builder, SQL, PL/SQL, Oracle 11g/10g/9i/8i and Oracle Designer10g for Data modeling.
  • Upgrade, maintain and troubleshoot Oracle Forms and Reports
  • Resolve issues with Oracle 11g Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.
  • Resolve issues with Oracle 10g Forms/Reports application running on windows 7 or Windows Server 2008R2, if upgrade option is not feasible.
  • Involve in fast paced Agile environment.
  • Involved in conversion of 10g forms into 11g as well as 32-bit to 64-bit.
  • Resolve issues with Oracle Forms/reports 10g or higher applications to run on or already deployed on Oracle Exalogic Servers as well as windows 7/8 and windows server 2008 R2/2012 use cases, like Development, Virtual machines and Citrix platform.
  • Developed custom Forms using Form Builder and add to Oracle GL & AR Applications .
  • Working with multiple data source types (Oracle, Excel, Mainframe files, FoxPro, SharePoint).
  • Perform the unit testing, system integration testing and assist with user acceptance testing.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Writing Unix shell scripts which drive the flow of execution involving file loading into the database using SQL*loader, Calling of oracle procedures and to transfer the output files using SFTP to the external servers.
  • Applying SQL query and PL/SQL performance tuning techniques like Views, temporary tables, DE normalization, selective indexes, hints, advanced PL/SQL features like pipelined functions and bulk operations to select and process data in large tables.
  • Active participation in release, deployment, and Production Cut-Over activities work.
  • Writing job schedulers in PL/SQL to automate the running of the stored procedures at regular intervals using DBMS SCHEDULER package.
  • Writing Database Triggers, by-passing the mutating table errors, use of row and statement level triggers.
  • Used features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: IBM-AIX Blade Servers, Oracle E-Business Suite 12.1.3, Oracle Forms 11g Rel.2, Oracle Forms 10g Rel.2, HP-UNIX, Oracle Enterprise Linux 6.2, Oracle Database 10g/11g, DB Visualizer 9.0, Toad, Import/Export, PL/SQL, UNIX Shell Scripting

Confidential, Tulsa, OK

Oracle Developer

Responsibilities:

  • Primary responsibility in managing Production and Development SR’s and Core Development in Banking Financial Systems.
  • Working with Production SR’s and modifications in the existing standards.
  • Creating complex stored procedures, functions, triggers, cursors, packages, indexes, ad-hoc queries, partitioned tables appropriate User defined functions to implement the business logic.
  • Developed custom Forms using Form Builder and add to Oracle GL & AR Applications.
  • Working with multiple data source types (Oracle, Excel, Mainframe files, FoxPro, SharePoint).
  • Perform the unit testing, system integration testing and assist with user acceptance testing.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Writing Unix shell scripts which drive the flow of execution involving file loading into the database using SQL*loader, Calling of oracle procedures and to transfer the output files using SFTP to the external servers.
  • Developing Unix shell scripts which control the sequence of operations of Calling SQL*Loader Utility to load the data from the flat files provided by external systems and saved at specific locations Calling Packages / Stored Procedures which perform the business operations on the raw data provided by the external systems.
  • Sending the files generated by the outbound interfaces to the external systems servers.
  • Applying SQL query and PL/SQL performance tuning techniques like Views, temporary tables, DE normalization, selective indexes, hints, advanced PL/SQL features like pipelined functions and bulk operations to select and process data in large tables.
  • Active participation in release, deployment, and Production Cut-Over activities work.
  • Writing job schedulers in PL/SQL to automate the running of the stored procedures at regular intervals using DBMS SCHEDULER package.
  • Writing Korn shell scripts to implement archive file workflow and calling sql stored procedures.
  • Used features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Developed Oracle Reports by using the HRMS/Payroll tables.
  • Proficient in generating Forms using Oracle Forms meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
  • Good understanding and working experience of Oracle E-Business Suite Release 11i/12.1.1 application GL/AP/AR/PO interface tables’ architecture.
  • As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
  • Good Knowledge about Oracle Workflow
  • Experience on Form Personalization and custom.pll
  • Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.

Environment: HP-UNIX, Oracle E-Business Suite Release 12.1.3, Oracle Enterprise Linux 6.2, Oracle 10g/11g, DB Visualizer 9.0, Toad, Import/Export, PL/SQL, UNIX Shell Scripting, Tableau 9.0.16

Confidential, Boston, MA

Oracle Developer/SQL Server ETL Developer

Responsibilities:

  • I was overwhelming in DEV environment; Next support will be System Integration (SIT) that start in Jan 2017.
  • Primary responsibility in managing ETL is to provide the “registered” tables.
  • Worked with end-user to create new reports and modification in the existing reports as well.
  • Compilation of the files used and maintained for the production of the LPRs including sources, retention periods, etc.
  • Co-production of LPRs on existing Third Party Server.
  • Technical Design of Santander Server.
  • Performed Detail Analysis in LDM and created Dimension/Fact tables as per new requirements.
  • Involved in PL/SQL code review and modification for the development of new requirements of the existing reports.
  • Responsible to Installation and Configuration of Oracle 12c database environment on OEL 6.2 on separate server.
  • Responsible to create Oracle Data Guard 12c for this DEV server and testing.
  • Responsible to Installation of Oracle Forms and Oracle Reports latest Fusion Middleware version and configure Forms/Reports services.
  • Worked with developers to optimize the query performances with available tools.
  • Tune SQL Access workload with physical indexes and materialized views
  • Data Analysis by using DB Visualizer tool
  • Analyze and Develop “Liquidity Data Mart” Database and Customize Oracle Forms web-based application.

Environment: HP-UX, Oracle E-Business Suite 12.1.3, Oracle Enterprise Linux 5, 6.1, 6.2, Oracle 10g/11g, DB Visualizer 9.0, Toad, Import/Export, PL/SQL, MF-COBOL, UNIX Shell Scripting, Microsoft SQL Server 2008 R2/2012 R2, MS SQL Server Management Studio (SSMS) and MS SQL Server Integration Services (SSIS)

Hire Now