SUMMARY

• More than 11 years of software engineering experience as an Oracle Certified Professional. Committed to quality and excellence.
• Expertise in Oracle platform migrations. Worked extensively in migrations from 10g to 11g and 11g to 12c.
• Expertise in writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
• Good experience with the usage of Collections, Bulk Insert, Nested tables, External tables, Advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors.
• Highly skilled in Performance Tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, and SQLTRACE.
• Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).
• Involved in developing various inbound and outbound interfaces to integrate legacy systems, mid-range applications to Oracle applications using ETL, XML, and web services, PL/SQL, SQL Loader, FTP and UTL Files.
• Extensively worked on Data Migration using Flat files and Data Mapping through SQL* Loader Imp/Exp utilities, UTL-File Package on Oracle 9i /10g/11g/12C Databases.
• Experience in Performance tuning, Application tuning and Query Optimization using Hints, Explain plan
• Hands on experience with tools like SQL Navigator, Toad, Sql * Plus, Oracle Enterprise Manager (OEM)
• Expertise in writing Wrapper/Scheduler jobs and UNIX Cron Jobs
• Expertise in Oracle Forms, Oracle Reports, Oracle Fusion Middleware, Oracle WebLogic Server, Synergy DE Proficient in working and conceptual knowledge of Oracle Forms 9i/10g/11g/12C, Reports 9i/10g/11g/12c.
• Hands-on experience with source control tools like Visual Source Safe (VSS)
• Diverse domain knowledge of industry includes Finance, Collections and General Ledger, Merchant processing, Credit Card processing, Mortgage, Commodity, Healthcare, Pharmacy and Claims processing.
• A team player who is adept at prioritizing, multitasking to achieve individual and team goals.
• Proficient in Installation and Configuration set up of Oracle Web Logic, Oracle Forms 11g/12c and Reports 11g/12c using Oracle Console and Oracle Enterprise Manager (OEM)
• Experienced with Full Project life cycle and well versed with scrum, Agile and standard SDLC methodologies.
• Extensive experience in Implementation, Customization, Production and Support.

TECHNICAL SKILLS

Database : Oracle 9i/10g/11g/12c, DB2 10, SQL Server, MySQL

Front-E nd A pplication T ools: Oracle Developer Suite - Forms 9i/10g/11g and Reports 9i/10g/11g/12c

Fusion Middleware : Oracle WebLogic Server 11g, Oracle Application Server OC4J

Language : Oracle PL/SQL, PRO*C, JAVA, C++, Snergy/DE, UNIX Shell scripting,HTML

Tools: /Utilities: SQL Developer, PL/SQL Developer, TOAD, Informatica , SmartTerm, ClearCase, Microsoft Visual SourceSafe, JIRA, Visual studio, Visio, RAD, Putty

Operating Systems : Windows NT, MS-DOS, UNIX, LINUX, AIX

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Responsibilities:

• Support for Oracle and Java applications for Food and Confidential Administration ( Confidential ).
• Wrote SQL scripts, created PL/SQL Packages, database triggers, and stored procedures to support Web-enabled applications.
• Participated in system analysis, design, and implementation of the 11G to 12C Conversion project and was involved in database design and modeling.
• Experience with effective debugging and performance tuning
• Build and maintain Database PL/SQL Stored procedures, packages, triggers and views.
• Created Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statement.
• Involved in SQL Query tuning and provided tuning recommendations to scheduler jobs, time/CPU consuming queries
• Full life cycle experience Oracle Form and Report Development.
• Development of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with effective debugging; and performance tuning
• Worked on Report layout design, Data models which used Placeholder, Summary, Formula Columns
• Worked with designing the front-end screen multiple Canvases, Windows, Object items and Form Triggers
• Troubleshoot bugs and determine the root cause of problems.
• Using SVN as a version control system. Used JIRA as a software development control system.
• Apply appropriate standards, processes, procedures, and tools throughout the development life cycle
• Analyze system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques and controls
• Develop unit and functional/integration tests.

Confidential

Software Engineer

Responsibilities:

• Understanding the application flow and process. Participate in the development and implementation of software version and change control processes, policies, and procedures across multiple development teams.
• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Installation and configuration setup of Oracle Fusion Middleware - WebLogic server, Oracle Forms 11g, Oracle Reports(11g)
• Upgrade Oracle Forms and Reports application from web based 10g to 11g
• Expertise in server setup and configuration in various regions. Participate in defining and documenting CM tools and processes.
• Hands on experience in working with Oracle admin console and Oracle Enterprise manager
• Setting up the Forms and Reports Services on 11g standalone Server/In-process Server
• Worked with Crontab jobs calling UNIX scripts to download and manipulate files.
• Creation of firewall requests to have proper link with the interface applications
• Working with UNIX shell scripts
• Trouble shoot performance issues and bugs within packages, forms, and reports using Forms debugger, Plan Explain, DBMS Output.
• Perform file transfer via NDM Connect Direct, SFTP.

Environment: : Oracle Fusion Middleware - Oracle WebLogic Server (10.3.6), Oracle Forms (11g), Oracle Reports(11g), PL/SQL, SQL, SQL * PLUS, UNIX Shell Scripting, Toad, SQL Developer, Putty, VSS, Confidential, UNIX, AIX, SFTP, Connect Direct, CA service desk manager.

Confidential

Senior Oracle Developer

Responsibilities:

• Developing of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with effective debugging; and performance tuning
• Understanding dependencies and relationships between Oracle Forms, Oracle Reports and Oracle Databases
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data
• Involved development of Synergy code, Unit testing and implementations and Code review.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Used UTL JOB to automate the PL/SQL procedures and packages.
• Develop UNIX shell scripts to administer the system.
• Perform knowledge transfer in the areas of Oracle SQL and PL/SQL programming, Oracle Developer suite (Forms and Reports) to Cognizant employees.
• Better Health care domain Knowledge

Environment: PL/SQL, SQL, Oracle forms (10G), Oracle Reports, Synergy DE, UNIX, TOAD, SmartTerm, SQL * PLUS, JAVA, ETL, Oracle Warehouse Builder, SQL Navigator, Microsoft Project Planner

Confidential

Software Engineer

Responsibilities:

• Constructions/Coding of PLSQL and PRO*C programs.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Expertise in requirement gathering and preparing low-level & high-level design document and traceability matrix. Reviewing unit, integration and system test case.
• Preparation of PS, UT and IUT documents.
• Working with the main modules like Booking, Disbursals, closure.
• Generated SQL and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonym
• Working with UNIX shell scripts
• Worked with Crontab jobs calling UNIX scripts to download and manipulate files.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

Environment: Oracle 9i, PL/SQL, PR0*C, TOAD, UNIX, SQL * PLUS, SQL developer, VSS, ASP, HTML, Java Script, VB Script, XML, UNIX Shell scripting, ClearCase.