SUMMARY

• About 4 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• Good experience of Performance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, TK - Prof and Explain Plan.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Knowledge on data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Ability to coordinate several tasks at a time and excellent decision-making skills, demonstrated excellent problem solving and active listening skills.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Records, Types and Dynamic SQL for DML operations for better performance.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with large volume of data.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Perl, Python, Perl, Unix Shell Scripts, JSP, C, C++, java, CSS, HTML, XML.

RDBMS: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005/2008 , Sybase, DB2 MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, MI

Oracle PL/SQL Developer

Responsibilities:

• Developing SQL and PL/SQL scripts for problem solving.
• Established onsite/offshore communication between onsite users and offshore project teams.
• 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.
• Involved in SDLC including designing, coding and testing.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and Maintained database objects like tables, indexes, triggers, procedures, packages.
• Worked closely with DBA team to take backup of tables and schema objects.

Environment: Oracle 11g,PL/SQL, SQL Loader, UNIX, SQL*Plus, Windows NT 4.0/2000/XP, Microsoft SQL server 2008.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems .
• Created data accuracy and consistency reports.
• Created complex relational database queries/SQL, dynamic SQL.
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Built physical data structures like tables, views, constraints & Indexes.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Analyze Korn shell scripts on UNIX platforms.
• Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
• Created table partitioning based on the systems and date range.
• Used SQL*Loader with both direct and indirect load methodologies.
• Query optimization using Explain Plan & TK Prof utility.
• Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Environment: Oracle 11g,PL/SQL, SQL Loader, UNIX, SQL*Plus, Windows NT 4.0/2000/XP, Microsoft SQL server 2008.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Used SQL hints and Indexes as needed to improve SQL performance.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Pro-actively participated in SQL tuning, Used ANALYZE, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database
• Modify existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Coordinate with the DBA for Table creation and other administrative activities.
• Deliver solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in Oracle PL/SQL.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Involved in writing several Queries and Procedures.
• Worked on Korn shell scripts on UNIX platforms.
• Involve in the continuous enhancements and fixing of production problems.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Solving the offshore technical issues and co-coordinating between offshore team and client.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Perl, Korn shell.

Confidential

Jr.Oracle SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Loaded the data into database tables using SQL*loader from flat files.
• Performed SQL tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Evaluating new techniques for enhanced functionality.
• Developed Perl scripts for data sources for data migration.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle, Perl, UNIX, Windows XP/2000.owb 10g.