SUMMARY

• Over 5 years of experience in IT industry in USA and 5 Years of previous experience in UAE as Oracle PL/SQL Developer and SQL developer expert in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle, Quality testing, Implementation & Production support, Team & Project management.
• Expertise on Create oracle pl/sql packages, procedures, functions, triggers, cursors.
• Testing activities using Oracle (SQL, PL/SQL), Oracle Forms 9i/10g/11g/ include PL/SQL Programing
• Expertise on teh following Oracle HRMS modules. Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources(HR), Oracle Payroll, Oracle Advanced Benefits(OAB), Oracle Time and Labor(OTL), Oracle iRecruitment, Oracle Learning Management and Oracle Self Service Human Resources(SSHR).
• Ability to simultaneously handle multiple projects of different sizes.
• Extensively worked on SQL Loader to load flat files from various source systems.
• Strong management, organizational and communication skills displayed during communication wif clients, project stakeholders, key users, technical team and project status/review meetings.
• Experience in testing of RICE (Reports, Interfaces, Customizations and Extensions) objects to as per teh custom business process wifin Oracle HRMS implementation.
• Sound understanding and expertise in Oracle E - Business Suite architecture and integrations between modules especially for HRMS areas.
• Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
• Excellent ability to support multiple simultaneous technical assignments in a fortune organizations as well as leading teh team.
• Sound experience Oracle E-Business Suite R12 new features including Multi-Org Access Control.
• Successfully utilized performance enhancements features of Oracle to optimize teh batch processes.
• Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.
• Good team player and ability to work independently.
• Expertise in Oracle Payroll configuration wif Oracle Time and Labor and Oracle Benefit modules in Multi-Org environments.
• Experience in designing and generating different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Extensive work done in Oracle … SQL, PL/SQL. Knowledge about handling user roles, privileges, designing of tables.
• Attend monthly agile sprint planning sessions to identify user stories for upcoming iteration and develop initial vision.
• Interact wif teh Business Analyst for any clarifications on business requirements.
• Coded and debugged teh stored Procedures, functions, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user - oriented application modules.

PROFESSIONAL EXPERIENCE

Confidential, Vienna, VA

Senior Oracle Pl/SQL Developer

Responsibilities:

• Reviewed PL/SQL code and modified teh development of new requirements.
• Worked wif Dynamic SQL, Composite data types & Global Temporary Tables.
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Attended weekly meetings and interacted wif client to gather business requirement.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Worked wif reports and resolved critical bottlenecks which enabled teh capability to map reports to be available on real time oracle forms submission
• Possess strong cross team/group collaboration skills, ability to foresee and analyst project risks, develop risk management plan and mitigate subsequent issues.
• Worked on Complex SQL queries involving inner joins, outer joins, unions involving many tables and many records having huge amount of data using TOAD.
• Modifying teh queries to reduce teh time for performance issues.
• Tested all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker’s compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports wifin teh Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under teh System Administrator responsibility.
• Created scripts for new table creation in teh application using TOAD.
• Implemented business logic wif Oracle-stored procedures, functions and triggers using PL/SQL.
• Developed several SQL's to standardize data for converting dates and business rules to fit into Oracle form.
• Used various Triggers and Stored Procedures to validate data at each level.
• Worked on various projects involving Oracle Applications Human Resource Modules Implementation (11i, 12i), Upgrades (from prior releases), Production Support, Agile Product Lifecycle Management (9.3.1) Implementation and its integration wif Oracle EBS.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Used various LOVS (List of Values) and record groups at various points in teh runtime.
• Did Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.

Confidential, Washington DC

Oracle PL/SQL Developer

Responsibilities:

• Performed extensive investigative analysis on teh incidents reported and scripted appropriate work around in a timely manner to fix teh issues.
• Increased performance of teh outgoing feeds by tuning teh underlying extraction SQL's
• Wrote complex Oracle SQL code (containing materialized view logs, analytical functions, Regular expressions, sub queries, joins, Pipelined functions, REF cursors and dblinks) to publish data from source to target
• Created indexes on teh tables for faster retrieval of teh data to enhance database performance.
• Created and modified PL/SQL Triggers, Procedures, Functions and packages
• Was responsible for File Based Loader (FBL) for worker details includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Created/Customized teh reports to get data output in required format.
• Well versed wif teh setup of Work Structures - Location, Organization, Job and Grade in HR.
• Planning, building, performing HRMS Data Conversion to upload employees experience, skills & competencies, Training etc.
• Modifying teh queries to reduce teh time for performance issues
• Used tools like TOAD and SQL Developer to make working environment flexible and for faster applications.
• Developed many database objects like Triggers, Indexes to debug any problems related to database.
• Worked on various DDL, DML, and DCL (TCL, ACL) statements
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues wif TEMPeffective defect management.
• Provided technical support to teh user wif regard to operational aspects.
• Make Post Implementation Support for Oracle Application HRMS 11i.
• Created SQLcode for generating PRIMARY KEY using SEQUENCE objects.
• Involved in teh Analysis, Design, Coding and Testing of teh application.