SUMMARY:

• Over 13+Years of Experience as an Oracle PL/SQL Developer with Proficiency in SQL, Oracle PL/SQL, Oracle Forms Builder, Oracle Reports Builder 10g/9i/6i, Java, UNIX Shell Scripting.
• Hands on experience in designing and developing of end user screens and reports using Oracle Developer/2000 (Forms, Reports) Oracle Developer Suite 10g and other front - end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Extensive experience in using Cursors and Ref-Cursors for processing of data.
• Good Knowledge on advanced PL/SQL constructs such as Oracle supplied packages and Collections including PL/SQL Records, Associated Array, Nested tables and Varray.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Expertise in handling errors using Exceptions.
• Experience in creating Materialized Views and DB links.
• Strong understanding of Object Oriented Analysis and Design.
• Extensively worked on Materialized Views, Database links and Table partitioning Oracle 11g.
• Experience in logical and physical design of Databases, Data Modeling and Data Architecture.
• Excellent experience in Performance tuning SQL queries to optimize system performance.
• Proficient experience in optimization of ETL procedures and packages.
• Experienced in Systems Analysis & Design, Application Development, Data Modeling, Business Intelligence, Database Administration and Performance Tuning.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS:

• Highly qualified, Oracle developer with solid history of designing, developing and deploying innovative solutions to highly complex software needs. Deep knowledge of SQL, PL/SQL, database design and data modeling, performance tuning, Oracle Forms, Reports, Designer and development lifecycles and practices. Thorough understanding of business logic in developing comprehensive software solutions.
• SQL & PL/SQL Programming, Systems Analysis & Design, Application Development Oracle Forms & Reports 6i/9i/10g, Data Modeling & Relational DB Design, Business Intelligence, Database Administration, Performance Tuning, Oracle EBS (HCM, SCM, FIN, AP, AR, GL, FA, & CE)

PROFESSIONAL EXPERIENCE:

Confidential, FL, USA.

Oracle PL/SQL Developer / Oracle Apps.Technical Consultant

Responsibilities:

• Interact with the client to gather the requirements and implement the same in the project
• Experience in migrations of project's application interfaces.
• Responsible for handling the Billing application and related Change requests.
• Responsible in implementing JSP pages for project specific, team member's assigned workflow details and for proper monitoring of tasks assigned.
• Implement PL/SQL queries, triggers and Stored Procedures as per the design and development related requirements of the project.
• Extensively work in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Work on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Handle errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Create indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively used the advanced features of PL/SQL like Collections including Records, Tables, Object types and Dynamic SQL.
• Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Has done end to end testing of the applications and Error casual analysis
• Involved in testing the application for Oracle 11g to 11g R1 and R2 upgrade.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Involved in all phases of database development, from needs assessment to QA/QC, design and support.
• Generated log files for Procedures using UTL File
• Created job scheduling tables
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics
• Extensively used spring framework modules like core, IOC, AOP modules throughout the apps.
• Involved in retrieving the images from database and converting them into different file formats (JPEG, BMP) using JavaComm technology
• Involved with OLTP relational databases system analysis, design, implementation & management.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports

Environment: Oracle Database release 11g/12c, Oracle EBS release 11/12 HCM, SCM and FIN, GL, AP, AR, FA, CE, XML Publisher, Oracle Developer Suites r11g (Forms, Reports), Oracle Workflows, Oracle Alerts, and TOAD.

Confidential

Oracle Designer / Application Developer

Responsibilities:

• Developed many integrated systems starting from designing the database structure using the Oracle Designer toolset such as Entity Relationship Diagram ERD then developed the system modules such as Forms, Reports and the Sub-programs based on Function Hierarchy Diagram FHD. Tested the modules to assure the quality, trained the users and documented all process.
• Actively involved in requirement gathering stage by investigating the users and review meetings.
• Designed the Logical Data Structure ERD, Function Hierarchy Model FHD and conducted the cross reference between them
• Applied the business rules by creating the database triggers using Head Start Oracle Designer.
• Designed the Server Model and created the scripts that used to create the database objects.
• Developed the modules including the Oracle Forms, Oracle Reports and Sub-Programs.
• Wrote and modified UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Developed the new sub-programs and also modified the various existing packages, procedures, functions, triggers according to the new business needs.
• Created the test scripts to check the quality of the new modules.
• Trained the end users on the new system according to their roles and responsibilities.