SUMMARY

• 7 years of diversified experience in analysis, design, development, testing and implementation in Oracle Development.
• Good experience with Oracle RDMS (9i, 10g and 11g) and Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes and AOL.
• Good working experience in Reports 6i/9i & Forms 6i for both development and customization of several Reports as per client specifications.
• Working Knowledge on Unix Shell Scripting with sh, bashes csh and ksh shells.
• Working in performance oriented environment dealing with Oracle E - Business suite Applications R11i/R12 in doing technical work within its various modules such as the Accounts Receivable (AR), Accounts Payable (AP), Order Management (OM/OE/ONT), General Ledger (GL) & Service Contracts.
• Worked on RICE Components like Interfaces, Conversions and Extensions.
• Strong in using tools such as TOAD, SQL Navigator, SQL*Loader, and SQL*Plus.
• Good experience with version control systems such as CVS, PVCS and tools like Quality Center, Kintana and Client specified custom tools.
• Thorough understanding of Rational Unified Process (RUP).
• Good experience in advanced PL/SQL concepts like build in packages DBMS SYSTEM, DBMS OUTPUT etc to achieve commendable improvement in performance.
• Good experience in web technologies like HTML/DHTML, XML.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance.
• Involved into Data Migration from Oracle 8i to 9i & 9i to 10g and extensive hands on Data Extraction and Data Comparison.
• Extensive development experience with Oracle 10g and 11g database.
• Have acquired basic knowledge on Oracle Applications Framework (OAF).
• In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, Java

ERP Systems: Oracle E-Business Suite R11i, R12

Database Systems: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS access 2005/2008

Developer Tools: SQL Loader, TOAD, Oracle SQL Developer, Oracle JDeveloper, MS VISIO 2007

Operating Systems: Windows 95/98/2000/XP/NT/7, UNIX, RH Linux, Windows Vista, Windows server 2000/2003.

Source control: CVS, PVCS

Scripting/Web technologies: Unix Shell Scripting, XML, JavaScript, HTML/DHTML

GUL Tools and Frameworks: Oracle Reports Builder 10g/9i/6i, Oracle Forms Builder 10g/9i/6i, Crystal reports, Developer 2000 and Oracle Applications Framework.

OS Tools: Putty, FTP/SFTP, WinSCP

Project Management Tools: Adobe works, MS Office Suite 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Sr. Oracle Developer

Responsibilities:

• Improved the performance of the application by rewriting the SQL queries.
• Used Bulk Collect feature to improve performance in stored procedure.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Extracted data from oracle database and spreadsheets and staged into staging tables and applied business logic to load them in the central oracle database.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Created procedures to truncate data in the target before the session run.
• Test case/data preparation, execution and verification of the test results.
• Used Git for version control and flyways for deploying code into environments.

ENVIRONMENT: Oracle 11g, TOAD

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked on Analysis, Detailed Design, Development, Testing, Documentation and Technical Requirements for the database applications and procedures as per quarterly and monthly release requirement.
• Provide timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues.
• Developed API’s, Stored Procedures, Functions and complex Packages and Triggers extensively using PL/SQL to meet business requirements.
• Involved in month-end and quarter-end activities and generate reports using sql queries.
• Participated in the design, development and creation of custom reports based on the customer requirements and interacting with the customer for requirement analysis.
• Designed and developed database objects such as tables, views, synonyms, partitioned tables, indexes, sequences, database links, cursors, functions, procedures and packages and data loading using SQL Loader utility for new/enhance requirements.
• Developed some of the basic customized OAF pages.
• Ensure that all deliverables are thoroughly documented and Prepared source to target Data mapping documents, Unit Test case, Unit Test Plan documents
• Worked on automating process for weekly and daily jobs using UNIX Shell Scripts
• Developed inbound interfaces by extracting data from different sources like Excel, flat files and loaded in to development database then using API’s and Standard Concurrent programs.
• Involved in fine-tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Used partitioning and sub partitioning of tables to improve performance.
• In Oracle Apps, created AOL objects such as Program registering, defining responsibilities, users, request group, Value set, flex-fields, profile options.
• Developed PL/SQL scripts for Data loading and Data extraction.
• Worked on writing Data Migration scripts such as PL/SQL procedures/create table scripts to load data successfully from legacy system to new structured schema or in to repository database.
• Worked on Performance tuning of SQL & PL/SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN, HINTS and TKPROF.
• Used Bulk Collect, parallel processing, bulk insert feature to improve performance.
• Developed and maintained scripts for monitoring, troubleshooting and administration of the databases.
• Debugging and enhancing existing applications by modifying existing packages and to optimize the performance.
• Extended few reports from Reports 6i to Report 10g.
• Generated report outputs in the PDF, XML etc formats using Reports 10g.
• Facilitated easy user interface implementation and consistent data entry into the database by creating Views with Triggers.
• Created Snapshots and Materialized Views.
• Utilized TOAD 9.2 for developing all back end database interfaces and objects.
• Good knowledge of Normalization and Software Development Life Cycle (SDLC).
• Created and compiled DDL scripts and see the output errors when executing stored DDL.
• Developed batch programs to load various types of feeds from external sources into the Oracle database using SQL*Loader and PL/SQL procedures.
• Handled errors using Exceptions like DUP VAL ON INDEX, INVALID NUMBER and CASE NOT FOUND.
• Developed PL/SQL to process input files and generate output files using UTL FILE utility.
• Interacted with business analysts to develop modeling techniques and re-structuring strategies
• Used SQL Loader in Oracle for bulk Data Loading
• Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
• Involved in writing automated data loading Shell Scripts which will watch the incoming files and load them automatically and emailif the data load is successful or failure.
• Developed and tested UNIX shell scripts to call the PL/SQL packages.
• Unit Test the module and deliver to the QA team.
• Written complex SQL Scripts in SQL*Plus for data reporting to business and write ad-hoc queries for various customer-reporting requirements.
• Maintained version control of the code in PVC’s.
• Migrated setups and code from dev. env to test and from test to production through Kintana.
• Involved in various stages of testing - code testing, Integration Test, System Test, and UAT and in Go-Live activities and provided instant support for client testing.
• Created Excel tools to aid data validation, which enabled team members to work more efficiently.
• Monitored defect tracking activities using Quality Center.
• Provided KT to fresher’s and mentored junior team-members.
• Ensured that weekend data loads, month-end & quarter-end processing ran successfully and completely, transparent to user community.
• Worked with DBAs for performance problems, fix the problem and make recommendations to technical staff to improve performance.

ENVIRONMENT: Oracle 9i/10g/R12, PL/SQL, SQL developer, TOAD, SQL*Plus, Reports 9i/10g, Windows XP/7, UNIX Shell Scripting, MS Office, SQL*Loader, JDeveloper, Oracle Applications

Confidential, Columbus, OH

PL/SQL Developer

Responsibilities:

• Involved in migrating the code from one instance to other instance
• Created database objects such as tables, indexes, synonyms, sequences and views
• Developed PL/SQL stored procedure, functions and packages for migrating the data from staging instance to repository database
• Developed SQL scripts to test and validate the information
• Worked on AOL objects.
• Implemented complex business rules with the use of integrity constraints and Database Triggers.
• Responsible for optimizing queries and query tuning using Explain plan and auto trace.
• Used TOAD to extract and test the data in the database.
• Modified the code as per standards.
• Prepared Unit Test Cases and Unit Test Plan documents.
• Worked on the RFC’s provided by client by delivering them on time.

ENVIRONMENT: Oracle Applications 11i, Oracle 9i, PLSQL, TOAD, SQL developer, Windows XP, SQL *Plus, MS Office, UNIX.