SUMMARY

• About 8 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 Retail, Telecom, Healthcare, Manufacturing and E-Commerce.
• Proficient in Oracle 11g/10g/9i/8i/7.3, TOAD, SQL*Plus, SQL*Loader and PL/SQL Developer.
• Expertise in implementing ETL (Extract, Transform & Load) for supporting Data Extraction, Data Transformation and Data Loading.
• 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 (Korn/C/Bourne).
• 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.
• Extensively worked on monitoring tools like Control-M and Autosys.
• Worked in fast paced AGILE environment and attended daily SCRUM meetings.
• Experience in migration and conversion from MS Access/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.
• Expertise in creating new C/C++, Pro*C Batch Programs with embedded SQLs, PL/SQL procedure calls, arrays and Dynamic SQL.
• Experience in migration of source code using version control systems like Subversion (SVN), Revision Control System (RCS) 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

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

Languages: SQL, PL/SQL, Unix Shell Scripting (Korn/C/Bourne), Pro*C, Java, J2EE, C, C++

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 (Power Center), Erwin 8.1/7.3, Visio 2007, Oracle Forms and Reports, APEX, Golden Gate, Autosys, Subversion, Revision Control System, BMC Control-M

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. Oracle Developer

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), Exchange Partition 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, Framesoft, Putty, JAVA UI

Confidential, Carmel, IN

Sr. Oracle Developer

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. Also, worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• 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.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Implemented Data ingestion process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Implemented various UNIX scripts to generate the data in CSV and txt format
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections.
• Used Bulk Collect feature to improve performance.
• 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, SQL Server, Informatica 8.5, Windows XP/7, UNIX.

Confidential, IL

Sr. Oracle Developer

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, Intersect and Aliases.
• 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.
• Performed unit and integration testing of the applications created using PL/SQL modules and used PVCS for version control in team development.
• 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 Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER, Optimized SQL queries and created Materialized views for better performance.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
• 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, TOAD 9.7.2, SQL Developer, Cognos 8.4, Windows 7.

Confidential, Alexandria, VA

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Designing system work flow diagrams using UML and Visio.
• Involved in ERD Design for Enterprise Application building.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
• 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.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Creating reports like customer details, Premium due based on the entered period.
• 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.
• Knowledge of Oracle ware house builder (OWB), to implement it in loading claims module in Medicaid Application.
• Allocated and involved in managing percentage for asset allocations.

Environment: Oracle 11g, SQL*PLUS, PL/SQL developer, TOAD, FTP, Unix, ERWIN, ETL, Oracle ware house builder(OWB), Oracle Enterprise Manager (OEM), Unix Shell Scripts, JAVA

Confidential

Jr. PL/SQL Developer

Responsibilities:

• Developed technical design documents (MD70s) using AIM methodology by reviewing MD50s and interacted with functional team to build technical extensions.
• Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client’s requirements.
• Analysis, Development and documentation of Importing Vendor Information from external systems.
• Designed and developed multi reports using Oracle Reports 2.5
• Designed and developed PL/SQL functions, stored procedures, packages
• Developed Oracle PL/SQL Packages/Procedures for importing and exporting of hierarchies into the database. Used UTL FILE package to export the data from relational tables to flat file. Inserting Hierarchical data into relational tables using Oracle pl/sql package.
• Coordinated with the business users to collect requirements.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Utilized tools like TOAD during development of the application.

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