PROFESSIONAL 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 tired applications using teh Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, Perl and Linux. Good experience of Performance AnalysisandSQL 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.
• Developed projects in an OLTP database environment.
• 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 teh database and also creating External Tables to manage data which is store at teh OS level.
• OCP Certified in Advanced PL/SQL on Oracle 11g Database.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Experience in migration of source code using version control system (CVS, Arch, Visual source safe, SVN, TFS).
• Worked on Oracle Forms10g/9i/6i Reports10g/9i/6i.
• Well-versed with distinct 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. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all teh versions of Forms/Reports.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Perl, (Korn shell) 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.

GUI Tools: APEX 4.2,3.2, Oracle Forms 10g,9i,6i and Reports 10g,9i,6i,ERWIN, VISIO, Gloden gate, Autosys Control-M, JIRA and HP quality center.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Involve in designing ER diagram using oracle designer, to set teh logical and physical relationships of database.
• Designing teh data model (logical/physical) by creating new objects and by using existing objects of teh data mart as per teh business requirements.
• DevelopingStored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Extensively used advanced PLSQL features like BULK COLLECT, FORALL, REF CURSORS, COLLECTIONS data types in teh procedures, functions
• Developing data model, SQL Coding, SQL Query tuning process and Schemas. Working on table partitioning and index creation for teh performance improvement.
• Highly involve in writing Test Cases and Unit Analysis and Testing (UAT) to test each logical branch of teh stored Procedure.
• Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
• Extensively used TOAD and SQL DEVELOPERtools to increase teh productivity and application code quality and Performance Enhancements.
• Archived many applications in teh existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).
• Preparing a package to generate teh Trace file for teh Materialized View Groups using DBMS SUPPORT Package.
• Preparing Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
• Preparing test scenarios for Prepared code and distribute across to teh QA along with Knowledge transfer.
• Used Power Designer to read Data Models.
• Written an excellent documentation about teh entire SEAS flow.
• Helped in teh documentation for WGPR team.
• Worked with cross functional teams on gathering requirements and troubleshooting issues.
• Generating software upgrade scripts for cross functional teams like SEBS and WISE teams.
• Supported development teams on design and implement different database objects.
• Provided full technical support to various application teams before teh databases go to production.
• Restored & recovered some of teh show site databases when they got corrupted.
• Perform Backups and Recovery; maintain 24 hours uptime for teh database.

Environment: Oracle 11g, Reports 10g, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Perl, Oracle Development Suite.

Confidential, Plymouth, MN

Oracle PL/SQL Developer

Responsibilities

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all teh ETL needs.
• Prepared data accuracy and consistency reports.
• Developed teh ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
• OWB repository creation/configuration/monitoring, mapping/process flow development.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Loaded teh 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.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Review modifications to existing software to improve efficiency and performance.
• Analyze Korn shell scripts on UNIX platforms.
• Involvedinphysical and logical data modelingusingErwin.
• Involved interfacing with teh following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Part of a development team for creation and maintenance of custom apps/reports.
• PreparedETL design specifications.
• Solid understanding of both teh business and teh technical aspects of BI Solutions.
• Prepared table partitioning based on teh systems and date range.
• Used SQL*Loader with both direct and indirect load methodologies.
• Query optimization using Explain Plan & TK Prof utility.
• Developed extraction, transformation and loading scripts using SSIS.
• PreparedSQL and PL/SQL scripts to detect data defects/anomalies in systems.
• Converted T-SQL to PL/SQL or vice versa to report data consistency cross multiple databases.
• Developed projects in an OLTP database environment.
• Prepared business rules to report all expected missing/defect data.
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Environment: Oracle 11g,PL/SQL, Gloden gate, SQLLoader, Cognos, Korn shell, ODI, SQL*Plus, Windows NT 4.0/2000/XP, Microsoft SQL server 2008.

Confidential, Charlotte, NC

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, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Work with teh Application Development team to implement data strategies and build data flows in OLTP.
• Modify existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Responsible for analyzing tables and indexes regularly to keep teh STATS up-to-date.
• Knowledge of developing BI solutions for enterprise processes such as financials, supply-chain etc.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in Oracle PL/SQL.
• Extensive experience with building application using Oracle APEX.
• 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.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Designing of ER diagrams for Data Modeling was done using ERWIN Tools.
• Develop and maintainPerl scripts that process data from vendors and other sources
• Application Development may involve interfacing with teh following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Worked on Korn shell scripts on UNIX platforms.
• Worked with different teams to set up teh development and test Autosys environments.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Assisted other DBA's with Disaster Recovery.
• Monitoring alert logs, error trace, free spaces, file systems etc.

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

Confidential, USA

Oracle Develope

Responsibilities:

• Prepared and manipulated stored procedures, functions, packages and triggers using TOAD
• Delivering solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Used teh advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Preparing teh dataflow and designing teh database using Erwin.
• Providing technical assistance in identifying, evaluating and developing systems and procedures that are cost effective and meet business requirements.
• Prepared and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Creating technical design. Modifying code modules and compile build components in development environment.
• Validating and baseline teh architecture. Identifying target and implementation strategy and release date.
• Performed SQL and PL/SQL tuningand Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Prepared and modified several UNIX shell Scripts according to teh changing needs of teh project and client requirements.
• Identifying test execution strategy and scope and Establishing test acceptance criteria.
• Supporting teh application throughout teh production release life cycle.
• Documenting Business Requirements Document (BRD) and Project Initiation Review Checklist (PIR).
• Strong analytical and problem-solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Participated in system analysis and datamodeling.
• Worked on XML along with PL/SQL to modify/create interface between systems.

Environment:Oracle 9i, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP