Experience Summary:

• Over 10 years of experience as Oracle Developer with Extensive knowledge and work Experience in design and development of Database applications in Client/Server environment using Oracle Database and PL/SQL programming
• Expertise working with Oracle11g, 9i, SQL PL/SQL, Oracle Forms 11g/9i, Reports 11g/9i, SQL Loader, Shell Scripting.
• Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on Oracle using SQL Loader.
• Experience in software development of databases that include design, analysis, development and deployment of software related to database application systems.
• Customized and developed Forms and reports using Forms9i, Reports 10g/6i.
• Experience in performance tuning and SQL optimization using Hints, Explain Plan, Auto Trace, and TKPROF , restructuring tables, de-normalization tables.
• Adept Knowledge in writing UNIX shell scripts, DBMS JOB, DBMS SCHEDULER and UTL FILE utilities.
• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user training, Project demonstration and Implementation.
• Possess strong communication and problem solving skills developed through a variety of projects.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
• Ability to work independently and also can be a great team player.
• Given 24/7 production support and involved in implementation of coding standards and Data Base change requests.
• Self starter can work independently as well as a good team player.

Technical Skills:

• Databases: Oracle 11g/10g/9i, SQL server 2005/2008, MS Access
• Languages: SQL, PL/SQL, Pro C and JAVA, J2EE, Servlets with JDBC DB Utilities: SQL Navigator, PL/SQL Developer, Export/Import, SQL Loader Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer, TOAD, MS Office Tools, SQL Advantage and isql Interactive Tool. Web Development Tools: HTML, JavaScript, JSP, XML.
• Version Control: Rational Clearcase, PVCS, CVS and Subversion,GIT
• Operating Systems: Windows 98/2000/2003/XP/NT4.0, UNIX IBM-AIX
• Documentation Tools: MS Office 2010

Professional Experience:

Programmer Analyst

Confidential

Responsibilities:

• Analyze user software application functional and reporting needs, determine and evaluate alternative solutions and develop approaches to meeting those needs.
• Communicate effectively with users to identify and document software/system requirements, work flow, output and technical system and report specifications.
• Design, develop, modify or support fully integrated systems which may include software applications, interfaces between disparate computer programs or vendor supplied software applications and utilities, databases, networks, and related systems.
• Develop succinct, timely programming code or modify software in a logical fashion which optimizes programming resources and meets functional user requirements, while ensuring system integrity and efficiency.
• Maintain and support assigned systems to ensure minimal downtime and loss of productivity and service.
• Design and develop user-friendly interfaces to systems, applications, and databases.
• Design and develop complex automated computer programs to produce a wide variety of reports, procedures or other outcomes as required by the university.
• Structure, implement and maintain database systems to optimize data access and security.
• Recommend and develop modifications to third party software to meet user needs.
• Develop and maintain program specific documentation, including program operating procedures, program changes and other relevant information to accompany designs and changes to any code developed or modified.
• Provide documentation and assist users of university software applications and systems.
• Act as a software vendor liaison.

Environment: Oracle 11g, PL/SQL, SQL Developer, UNIX,LINUX and APEX.

Senior Oracle Developer

Confidential

Responsibilities:

• Involved in analysis, Design, Development phases of the project
• Developed Requirement Specifications, Functional and Technical Design Documents.
• Transferred knowledge to paper using Architectural diagrams, process flows and documented the whole system which includes data modeling according to SDLC guidelines.
• Communicate with both technical and non-technical groups on a regular basis to pass along important information and to ensure the design and implements are understood by all parties.
• Maintain, troubleshoot, optimize and improve existing database applications and database objects
• Designed table structures, developed scripts to create tables, indexes, views for CIS module
• Involved in writing database triggers, procedures, functions in PL/SQL and incorporated business rules and constraints for Key Customer System KCS
• Developed new stored procedures and modified existing ones as per the business requirements using Oracle 11g to calculate tariffs for different energy usage levels.
• Performed tuning on the existing code for better performance.
• Co-ordinate with reports team to generate the reports.
• Built and modified reports using Reports9i for better formatting and ease of use by the end users.
• Developed complex forms from scratch and worked on enhancements of the existing forms using Oracle forms
• Created Shell Scripts to transfer the data and to run the SQL Scripts and run the jobs.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
• Designed and developed user test scripts for the UAT and migration of the developed codes.
• Schedule the jobs with heavy dependencies.
• Analyzed and resolved defects in Tariffs
• Tables, Views, Procedures, Alter Scripts and SQL Scripts are checked in clearcase repository.
• Involved in 24/7 production support.

Environment: Oracle 11g, Forms/Reports 9i, PL/SQL, TOAD, UNIX,LINUX and clearcase..

Oracle Developer

Confidential

Roles Responsibilities:

• Created tables, schemas, views, Indexes etc using TOAD tool created complex Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections using PL/SQL for implementing complex business logic.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Extensively used TOAD and SQL Developer tool for effective application development.
• Extensive experience in using Oracle Utilities like export/import utility and SQL Loader
• Used SQL Loader and PL/SQL programs to Convert data from legacy system to Oracle 10g and to store data in the Oracle database 10g from different types of flat files.
• Developed Packages to validate the new raw data which was loaded into the database tables from the flat files by SQL Loader.
• Optimized critical queries to eliminate Full Table scans.
• Legacy Data mapping with Oracle system 10g.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Overall coordination with customer for requirements, approvals for DB models etc.

Environment: Oracle 11g, PL/SQL, TOAD, UNIX,LINUX and clearcase..

Oracle Developer

Confidential

Responsibilities:

• Involved in analysis, Design, Development phases of the project
• Developed Requirement Specifications, Functional and Technical Design Documents.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
• Coding and Unit testing .
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Used SQL Loader and PL/SQL programs to Convert data from legacy system to Oracle 10g and to store data in the Oracle database 10g from different types of flat files.
• Communicate with both technical and non-technical groups on a regular basis to pass along important information and to ensure the design and implements are understood by all parties
• Designed and developed user test scripts for the UAT and migration of the developed codes.
• Actively involved in the maintenance and enhancement of the application.

Environment: Oracle 10g, Oracle Forms/Reports ,PL/SQL, TOAD, UNIX,LINUX and clearcase..

Oracle Developer

Confidential

Responsibilities:

• Responsible for analysis, requirements gathering, documentation of functional/technical specifications, data mapping, development and testing.
• Developed control files for SQL Loader and PL/SQL scripts for loading data into interface Tables Staging area from different source systems and validating the data .
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Unit Testing System Testing
• Reviews and Code Walkthroughs
• Construction, preparation of Test Scripts, Unit Test Plans System Test Plans
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Creating Scripts for the Installation of the Product.
• Implementation of the product at client site.
• Create new database users as required

Environment: Oracle 9i, PL/SQL, TOAD, UNIX,LINUX and clearcase..

Oracle Developer

Confidential

Responsibilities:

• Produced Scripts to cleanse source data, ETL process Extract, Transform Load data with business rules.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Coding and unit testing
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle.
• Creating Scripts for the Installation of the Product.
• Implementation of the product at client site.
• Create new modules as required

Environment: Oracle 9i, PL/SQL, TOAD, C,UNIX,LINUX and clearcase..