PROFESSIONAL SUMMMARY:

• Around 8yrs of software development life cycle experience in Software Design, Development and Implementation of Oracle, SQL and PL/SQL applications.
• Extensive experience in Database Design using SQL and PL/SQL Programming using StoredProcedures, Functions, Packages and Triggers.
• Worked in Client-Server applications using Oracle 9i/10g/11g, Forms, Crystal Reports with Oracle report builder.
• Proficient in analyzing the end user requirements and converting them into efficient Technical design documents.
• Created database objects such as tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements.
• Experience on working with DBA skills like creating users, managing passwords, granting/revoking privileges on database objects and Disaster Recovery Drill.
• Strong in using tools such as PL/SQL developer, TOAD and SQL Plus.
• Experience in writing complex SQL Queries.
• Strong Knowledge on Oracle Architecture and Database Design.
• Extensive experience inOracle 10g/9i/8i RDBMS.
• Tuning the SQL Queries using TKPROF and EXPLAIN PLAN facilities.
• Expertise in loading data from legacy systems using SQL Loader.
• Involved in Unit level testing, Module level testing and System testing.
• Exposure to the entire process of Software Development Life Cycle from Requirements Gathering, Analysis, Design, Development, and Testing of business applications in Web Based and Client/Server applications.
• Highly motivated team player with good communication skills and excellent problem solving abilities.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Ability to work individually and as a member of a team.

Technical Skills:

• Programming Languages : SQL, PL/SQL, Crystal Reports, Forms
• RDBMS : Oracle 9i/10g/11g, MS-Access
• Dataanalysis :Requirements/Business analysis, low level design and flow charting
• Operating Systems : Windows, UNIX, LINUX
• Database Back-End Tools : TOAD, SQL Plus, SQL Loader

Professional Experience

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Developed and modified various PL/SQL programs.
• Wrote a number of control files for loading data into Oracle tables.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL Loader
• Designed and developed various reports using Crystal Reports as per requirements. Created security profile at database level and object level.
• Involve in Tuning, Performance, and Optimization of queries and standardization of the codes.
• Wrote a number of shell scripts for extracting data from Oracle tables
• Maintenance of all the source code in version control library PVCS
• Reporting Requirements to develop Purchase Order and Spending Data warehouse.
• Involved in Extraction, Transformation and Loading ETL of the data in the data warehouse for Oracle 9i/8i database.
• Extensively worked with stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Worked on table partitioning Range and List and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Extensively worked on Explain plans and various hints for Performance tuning.
• Involved in writing complex scripts for Data Transformation, ETL process Extract, Transform Load .
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL
• Creating Test scripts for the generated final Reports.
• Attended meetings and review to discuss current issues and processes to tackle such issues.

Environment: Oracle 11g, Oracle 10g, Oracle 9i, Oracle Forms 10g, Crystal reports, PL/SQL, TOAD, SQL Developer, SQL loader, SQL Plus, AIX, Windows XP.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Developing SQL and PL/SQLscripts for problem solving.
• Generating reports using Report builder.
• Developing Shell Scripts.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL Plus, PL/SQL and TOAD.
• Wrote complex SQLqueries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g, PL/SQL, UNIX, Windows XP.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Gathering requirements from the client and translated the business details into technical design.
• Developing services like Insert, Update, Delete and Prepared dynamic procedures.
• Developing Stored Procedures, Materialized views, Functions, Packages, Exceptions and Cursors.
• Performance tuning, which included creating indexes and providing Hints using explain plan utility.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Creating Database Objects like Tables, indexes, views, sequences, synonyms, tables, partitions, Global Temporary Tables, External Tables etc.
• Developing ETL Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and SQL Loader various UNIX Shell Scripts.

Environment: SQL, Oracle 10g, SQL Loader, Unix/Linux shell scripting, TOAD

Oracle Pl/Sql Developer

Confidential

Responsibilities:

• System analysis and design for enhancements, Testing Forms, Reports and User Interaction.
• Database development included writing PL/SQL stored procedures, triggers, and functions.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Design and execute complex SQL Queries and PL/SQL codes to enhance the existing Reports.
• Accessed remote databases using DB-Links.
• Tuning the SQL scripts to improve performance.

Environment: Developer 2000, PL/SQL, SQL Loader, Windows 2000

Trainee - Pl/SQL Developer

Confidential

Responsibilities:

• Extensively involved in coding of the Business Rules through PL/SQL using the Functions,Cursors, Triggers, Stored Procedure, and Packages in the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Designed ER diagrams and normalization of database.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL Plus.
• Migrated the data from external files into Database tables using SQL Loader.
• Extensively involved in performance and tuning of all SQL and PL/SQL code.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures Functions developed by the team members.
• Wrote triggers to handle user-generated events.
• Developed UNIX shell scripts to schedule the jobs.
• Used Developer 2000 to generate reports of statements for users.

Environment: Developer 2000, SQL, PL/SQL, Oracle 9i, UNIX, Windows 2000