SUMMARY

• About 11+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of Client/Server and multi - tier applications using Oracle Relational Database Management System (RDBMS), SQL and PL.SQL on different platforms like Windows NT/2000/XP, UNIX and LINUX.
• 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.
• Well versed with advanced features like Table Partitioning, Ref Cursor, Collections, Analytical functions, Query Re-Write, Transportable table spaces, Records, Exceptions, Bulk Bind and Dynamic SQL.
• Good experience of Performance Analysis and SQL Query Tuning, while designing scalable application from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, TK-Prof and Explain Plan.
• Involved in all phases of SDLC with timely delivery against aggressive deadlines in Financial, Energy, Heal thcare and Manufacturing.
• Proficient in Oracle 11g/10g/9i/8i/7.3, TOAD, SQL*Plus, SQL*Loader and PL/SQL Developer.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Expertise working in UNIX/LINUX environment and Shell Scripting.
• Experience in developing applications using Oracle Forms 11g/10g/6i and Reports 11g/10g/6i.
• Expertise in Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain Plans, TKPROF, AUTOTRACE and Table Partitioning.
• Worked in fast paced AGILE environment and attended daily SCRUM meetings.
• Experience in migration and conversion from SQL Server to Oracle.
• Design, development and deployment of Data Warehouse solutions and COGNOS tool suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer and Power Play).
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data Warehouse environments including Star Schema, Snowflake Schema and Normalization/ De-Normalization.
• Experience in migration of source code using version control systems like Subversion (SVN), and Microsoft Visual Source Safe.
• Excellent Team Player to work in conjunction with testers (QA and offshore), developers and other team members in validation and testing of complex project scenarios and in maintenance of Quality Standards of products.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILLS

SKILLS: ORACLE, PL/SQL, SQL, UNIX, JAVA

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000 , Postgres Languages SQL, PL/SQL, Unix Shell Scripting, Java, J2EE Web Technologies JSP, Java Script, HTML, XML, HTTP

Operating System: UNIX, LINUX, Windows NT/XP/Vista/98/95, Red Hat (RH5 to RHEL 6), MS DOS, IBM AIX, Sun Solaris

Reporting Tools: Business Objects Developer Suite 5.1, Business Objects XI/XIR2/XIR3.1, COGNOS Suite, COGNOS Report Net, Crystal Reports, Oracle Reports 10g/9i/6i, Oracle Utilities SQL*Plus, SQL*Loader, SQL Developer, TOAD

Other Tools: Informatica 9.1.6/8/6/1/8.5.1 , Visio 2007, Oracle Forms and Reports, Tibco, Talent, Oracle SOA

PROFESSIONAL EXPERIENCE

Technical lead /Architect-Oracle Database

Confidential, Atlanta, GA

Responsibilities:

• Involved in tuning the performance for very large database systems
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG & ROW NUMBER Functions for sorting data.
• Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using TOAD tool.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Created B Tree indexes, Function based indexes on columns to minimize query time and achieve better performance.
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER, Optimized SQL queries and created Materialized views for better performance.
• Tuned SQL queries by getting SQL ID, SQL EXEC ID and using them to get SQL Monitoring reports.
• Created and modified database objects such as Tables, Views, Materialized views,
• Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
• Implemented CTAS (Create Table As Select approaches to optimize archive process.
• Involved in the creation of Database Objects to Oracle database, by using Erwin, Wrote UNIX SHELL scripts to automate Oracle ETL jobs.
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Extensively wrote UNIX Shell scripts to automate the data load from SQL *Loader to staging table.
• Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Involved in performance tuning using Indexes, Hints, Explain Plan, Stats gathering etc.
• Used techniques like direct path load, external tables for loading the data faster.
• Involved in the technical consolidation/integration of various sources trades, orders, market data, positions feeds in LCDB Data warehouse
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• DBMS STATS is used to collect and build various Data statistics to provide information to COST based optimizer, to find chained rows, to build histograms.
• Supported multiple Downstream Application like PLM, GPLM, MANTAS, Trade Surveillance, ACTIMIZE, GWRS/DMS.

Environment: Oracle 10g/11g, TOAD 10.1, SQL*Loader, Windows 7, UNIX, Emptoris v9/v10.1, Combionics, Frame-soft, Putty, JAVA UI

Technical lead /Architect-Oracle Database

Confidential

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models).
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions and packages; ensured that the quality, programming and project management standards were met.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections.
• Created indexes on tables for fast retrieval of data.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the project.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• 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.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Toad, SQL* Plus, SQL* Loader, Oracle 10g, Oracle SOA

Sr. Oracle Developer

Confidential

Responsibilities:

• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data.
• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions and Aliases.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS and FORALL statements to improve performance in insert and update statements.
• Performed unit and integration testing of the applications created using PL/SQL modules
• Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Extracted data from different sources like excel spreadsheets and transformed the data based on Business requirements and loading into Oracle target database.
• Extensively used error and exception handling techniques for validation purposes in code.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Developed an effective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Designed and maintained project data models like ERDs (Entity Relationship Diagrams) using Toad Data Modeler tool using forward as well as Reverse Engineering techniques.
• Interacted with developers and Quality Assurance team for resolving application and database related problems.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data. Environment: Oracle 10g, SQL*Plus, PL/ SQL Developer

Sr. Oracle Developer

Confidential

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Participated in Performance Tuning using Explain Plan and TkProf
• Written stored procedures, functions and packages for application development.
• Copying of data from development to test and production by using utilities like Export/Import.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user defined functions.
• Automating data loading, extraction, report generation using PL/SQL coding.
• Expert in analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
• Creating reports like Billing Report etc as per customer needs.
• Used FTP to transfer dump files from production server to testing server.
• Worked with Front end application team to build Reconciliation Application using JAVA, J2EE.
• Helped in resolving Middle Tier issues when connecting to backend database structures.

Environment: Oracle 11g, PL/SQL Developer

Sr. PL/SQL Developer

Confidential

Responsibilities:

• Leading and guiding a team of 5 people for State Transfer and Rapid Tag.
• Analysing the tickets and delegating to the team.
• Reviewing the Impact Analysis, Estimation and UTC documents.
• Database Tuning.
• Involved in code reviews and helped team technically to resolve issues and Change Requests.
• Creating and modifying PL/SQL procedures, tables, indexes, sequences etc. as per requirements.
• Had daily status call with Client Tech Lead to understand the requirements

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Plus, UNIX, Windows 2000.

Sr. PL/SQL Developer

Confidential

Responsibilities:

• Understanding the requirements of the client through conference calls and the documents provided by them.
• Interacting with the client on various forums to clarify any queries regarding the functionality etc.
• Project Coding includes creation of the Database objects (Packages, Procedures, Synonyms, MVs etc),
• Create Alter scripts, DMRs (Data Manipulation Requests), testing them.
• UTC Review.
• Mentoring junior team members, explaining the requirements to them, code review and testing of the applications developed by them.
• Database Tuning.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Plus, Windows 2000.

Sr. PL/SQL Developer

Confidential

Responsibilities:

• Understanding the requirements of the client through conference calls and the documents provided by them.
• Interacting with the client on various forums to clarify any queries regarding the functionality etc.
• Project Coding includes creation of the Database objects (Packages, Procedures, Synonyms, MVs etc.), Create Alter scripts, DMRs (Data Manipulation Requests), testing them.
• UTC Review.
• Mentoring junior team members, explaining the requirements to them, code review and testing of the applications developed by them.
• Database Tuning.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Plus, JSF, JSP, Informatica.

PL/SQL Developer

Confidential

Responsibilities:

• Analyzing the client requirements and making enhancements.
• Preparing Estimation, Impact Analysis document, Technical Design document and Unit Test Cases.
• Coding on Forms 6i, PL/SQL (Procedures, Packages, Triggers, Views, Tables etc.)
• Unit Testing of the application.
• Release to client impact Analysis, Estimation, UTC & Release Review of team members.

Environment: Oracle 8i, SQL, PL/SQL, TOAD,

PL/SQL Developer

Confidential

Responsibilities:

• Database Tuning.
• Maintenance and Support of the existing system.
• Design and Create Forms/reports/procedures as per business requirements.
• Debugging and problem solving from existing procedures data lever routines.
• Enhancement in existing procedures/functions/Forms/Report for performance.
• Migration of Forms 6i to 10g.

Environment: Oracle 8i,10g, SQL, PL/SQL, TOAD.

Trainee Software Engineer

Confidential

Responsibilities:

• Interaction with users for understanding the requirements.
• Designing the Database in Oracle8i.
• Coding the modules using PL/SQL server Pages.
• Designing reports using Seagate Crystal Reports.

Environment: Oracle 8i, SQL, PL/SQL, Crystal Report