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)