SUMMARY

• 7 years of IT experience in oracle industry as a Pl/SQL developer in design, analysis, supporting oracle 9i/10g/11g, performance tuning, and optimization in production, testing and development environments with large database.
• Experienced in implementation of business application in oracle relational database management system (RDBMS).
• Involved in all phases of SDLC (Software development life cycle) from analysis, design, development, testing, implementation and maintenance.
• Strong experience in data warehouse concepts, ETL.
• Expertise in creating SQL queries, PL/SQL packages, stored procedure, function, triggers, cursor, materialized views.
• Diverse industry experience including Automobile, finance, health, banking.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of terabytes size using tools like Explain - Plan methods.
• Experience in loading data from flat files into database using SQL *Loader and AFL Tools.
• Good knowledge of key oracle performance related features such as cost based optimizer, execution plans, hints, indexes (local/global/B-tree/Bitmap), partitioning, temporary tables, views and External tables.
• Knowledge in Oracle reporting tools like OBIEE (Oracle Business Intelligence Enterprise Edition) v10.x, 11g. Also, knowledge in Informatica power center v8.x, 9.x. Knowledge in data modeling and ERWIN tool.
• Good knowledge of oracle architecture.
• Experience in designing and deploying UNIX commands and shell scripts.
• Experience in monitoring, troubleshooting, analyzing the application issues.
• Excellent communication skills and working directly with co-workers and clients to identify business objectives and establish requirements.
• Worked with oracle forms and reports.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, MySQL, SQL Server

Languages: SQL, PL/SQL, UNIX, perl

Data Modeling: Erwin

Tools: /Utilities: Toad, PL/SQL developer, SQL loader, explain Plan, SQL plus, OBIEE 11g, 10.x

Scripting Tool: UNIX shell scripting

DB utilities: SQL loader, external tables, exp/imp, SQL trace

Operating Systems: Windows, Unix, and Linux

Version Control: Clearcase v7.x, 8.x

PROFESSIONAL EXPERIENCE

Sr. Pl/SQL Developer

Responsibilities:

• According to the business requirements, created a detailed SRA (System Specification Document).
• Created TSD (Technical Specifications document), install plan and participate in review discussions.
• Interacted with data modeler for data modeling and have good knowledge of existing logical and physical data models.
• As per the requirement, created PL-SQL stored procedures and functions, SQL scripts to facilitate functionality for various modules.
• EXPLAIN PLAN and SQL Trace used to tune the SQL queries.
• Interacted with the DBA for partitioning of tables to increase the performance.
• Used SQL Loader to load the data into database
• Developed Shell scripts to automate SQL script execution to check incoming data with master tables. Also worked with UNIX commands.
• Good knowledge on OLAP, hierarchical queries.
• Development of complex SQL queries using joins and various dynamic SQL’s
• Used TOAD to optimize and test SQL and PL/SQL code and complex stored procedure issues were fixed.
• Used oracle collections associative arrays, user defined data types, BULK COLLECT and FOR ALL.
• Worked on MERGE, EXCEPTION handling and developed PRAGMA AUTONOMOUS procedures for audit logging.
• Good knowledge of Oracle architecture (SGA, database buffer cache, redo logs and back ground process) and knowledge of star architecture schema.
• Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK
• Used Oracle INLINE view and sub queries in packages ad procedures.
• Worked closely with the DBA for gathering table level statistics and help generate an effective query plan in the batch processes.
• Was involved in production issue triaging (L3 support) and resolved production issues
• Clear case v8.x used as a version control manager for code development.

Environment: Oracle 11g, SQL, PL/SQL, TOAD 9.5, SQL *Loader, UNIX shell scripts, win XP

Confidential, CA

Oracle Developer

Responsibilities:

• Involved in creating an SRA (requirements document) and TSD (technical specifications document)
• Used Oracle analytical functions, TOP N queries.
• Writing and tuning the queries for handling the large volume of the data and making necessary changes for optimization and performance
• Developed packages, customized functions and triggers based upon the business logics.
• Used TOAD to optimize and test SQL’s and PL/SQL statements.
• Documentation was done on all processes like program specifications, bugs fixing logs and change requests for future references.
• UNIX commands and shell scripts were used to automate the execution of SQL scripts.
• Followed the best practices and standards in writing complex queries and good experience in exception handling, external tables, partitioning.
• Worked on oracle collections, BULK COLLECT and FOR ALL
• Worked on hierarchical queries and good knowledge on star schema architecture.
• Interacted with Oracle DBA for gathering table level statistics and also interacted for the issues in query tuning
• Performed performance tuning and monitored the performance.
• Good knowledge on oracle architecture (SGA, database buffer cache, redo logs and background processes)
• Clear case v8.x used as a version control manager for code development.
• Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK

Environment: Oracle 11g, SQL, PL/SQL, TOAD, Oracle reports 11g, Shell scripts, XML, UNIX, windows XP

Confidential, PA

Pl/SQL Developer

Responsibilities:

• Developed triggers, packages, functions and stored procedures using PL/SQL.
• SQL and PL/SQL queries were tuned by Explain PLAN, cost based optimizer (CBO) and made necessary changes for optimization and performance
• Extensively worked on oracle SQL, PL/SQL, SQL* PLUS, SQL *LOADER, created DDL scripts. Database objects like tables, views, synonyms and sequences were created.
• In order to handle the large datasets, wrote efficient queries
• Worked on SRA document preparation. Created TSD, install plan and participated in review discussions.
• Worked on SQL Loader for loading data from the merchant master files data into staging tables.
• Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK
• Followed high coding standards and maintained the high quality standards.
• Physical database design was very well reviewed.
• Involvement in L3 production support.
• Learned fact and dimension table
• Maintaining and setup documentation and standards
• UNIX commands were used and shell scripts were written to automate the execution of SQL scripts to check incoming data with master tables, valid data would be inserted into the Customer Management System and the invalid data with error tables would be sent back the sender notifying the errors.

Environment: Oracle 10g, SQL, PL/SQL, TOAD 9.5, SQL *Loader, ETL, XML, UNIX, windows XP

Confidential, NJ

Pl/SQL Developer

Responsibilities:

• Developed database triggers, packages, functions, and stored procedures using PL/SQL.
• Performance tuning of the SQL, PL/SQL queries using EXPLAIN PLAN, HINTS and Cost Based Optimizer (CBO).
• Indexes and sequences for faster retrieval of the information and enhancement of the database performance.
• Table level, schema level, system level and Database level statistics were gathered to improve performance of SQL statements.
• Cursors, sequences, indexes in the procedures used according to the requirement.
• Good knowledge of star schema architecture
• Interacted with ETL team for expression transformations, union transformations, used insert else update strategy for target load.
• Interacted with the data reporting teams, which were using OBIEE 10g.
• TOAD to Optimize and test SQLs, PL-SQL statements and resolving complex stored procedure compilation issues fixing.
• Documentation on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: Oracle 10g, SQL, PL/SQL, TOAD 9.5, SQL *Loader, OBIEE 10g, XML, UNIX shell scripts, windows XP

Confidential

PL/SQL Developer

Responsibilities:

• Import/export the data, data maintenance, software installations, configuration.
• Good knowledge of oracle architecture.
• Extensive use of customized functions, procedures
• Creating and managing database objects such as tables, indexes and views.
• Optimization of SQL statements.
• Proper documentation of the code was performed.
• UNIX commands and shell scripting was used to perform to get the data into the flat files which could be then imported into tables using SQL statement execution.
• Used analytical functions and aggregate functions.
• Interacted with DBA for improving performance of the queries.
• Experienced in working with joins.
• Responsible for day-to-day management, monitoring query writing.

Environment: Oracle 10g, SQL *PLUS, Microsoft windows XP

Confidential

Jr. Oracle database analyst

Responsibilities:

• SQL was used to find the genes in the DNA.
• Functions, procedures and packages were used using the PL/SQL programming.
• Daily tasks included writing the queries and doing the performance tuning on them.
• Updating the new entries. Documentation maintenance.
• Triggers and cursors were also used.
• System was also developed to extract the data from the tables and use in the online tools.
• Good knowledge on oracle architecture (SGA, redo logs, data buffer cache, data dictionary, etc.)
• Successfully found the new sequence due to fine querying of the databases.
• Perl was used for scripting purposes.
• Used SQL analytical functions extensively.
• UNIX commands were used to get the data from the server to load into oracle database.

Environment: Linux RedHat, UNIX scripts, MacOS X 10.x, Oracle 9i, Oracle SQL Developer, SQL *PLUS, UNIX, Perl