SUMMARY

• Around 8 Years of Experience in teh field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL dat includes Complete System Development Life Cycle from Analysis and Design to Implementation
• Involved in Design of Data modeling including logical, physical data modeling and dimensional data modeling using ERWIN.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Hands on experience in design, development of end user screens and reports using Oracle Developer (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite 10g and other front - end tools
• Expert in Oracle Database Development. Designed and implemented OLTP and Data Warehouse Systems, application schemas, reports, and application interfaces using PL/SQL, Stored Procedures, Packages, Triggers, Functions, SQL*Loader, External Tables, Utl File, Objects Types, Collections, Bulk Collect, Cursors, Ref cursors, Table functions, Global temporary tables, Analytical functions and Dynamic Sql on Oracle (8i - 11g), Oracle Flashback table & query.
• Solid experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, Profiler, EXPLAIN PLAN, TKPROF and SQL Trace.
• Extensive experience in utilizing Collections to boost performance in PL/ SQL block.
• Used several Oracle provided packages such as DBMS JOB, DBMS PROFILER, DBMS STATS and DBMS SCHEDULER packages.
• Experience in creating Indexes, Range partitions, Materialized views and DBLinks
• Proficient using TOAD, SQL Navigator, SQL/PLSQL developer, Clear Quest, Clear Case, DOORS and FTP tools (Humming bird, Putty, Fsecure etc.)
• Strong experience with DATAPUMP utilities like EXPDP/IMPDP.
• Strong Background in implementation of RDBMS and OOPS concepts
• Worked on Database links and materialized views.
• Experience in developing reports and forms using Oracle forms and reports 6i/9i
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Strong noledge with PL/SQL Wrapper to protect teh PL/SQL procedures or packages.
• Extensive experience in writing Static & Dynamic (REF) Cursors, Dynamic SQL, Records, PL/SQL tables & Exception handlers.
• Designed and implemented pre and post processing Pro*C programs for ETL process.
• Extensively worked on SQL Loader, creation of control files to load teh data from flat files.
• Hand on experience in creating different kinds of partitions for managing large tables.
• Worked on operators in PL/SQL like Union, Union all, Intersect and Minus.
• Experience on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Hands on experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure and WinSCP. xpertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes
• Skilled in Unix Shell and Perl script writing. Created load scripts in Korn shell and Perl on Unix, called by scheduler (Crontab and Autosys), to format and transfer data from various platforms and databases.
• Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit
• Used existing processes and procedures for application deployment and provided 24x7 production support as Primary.

TECHNICAL SKILLS

Operating Systems: WINDOWS98/NT/2000/XP, Solaris 5.8, UNIX, Linux

Languages: Java, C, SQL, PL/SQL

Scripting Languages: Shell, Perl, Java Script

Markup Languages: HTML, XML

RDBMS Database: ORACLE 11g/10g/9i/8i, SQL Server 2008

Tools: Informatica 8.6/7.1.1/7.1.3

Application/Web Servers: Oracle Application Server 10g, Tomcat

Other Tools: Forms 6i/9i/10g/11g, Reports 9i/10g/11g, Erwin r7/r4.5, Pro*C, TOAD, SQL Navigator, Clear Case, Crystal Reports XI, Business Objects XIR2, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr Oracle PL/SQL Developer

RESPONSIBILITIES:

• Handling all phases of SDLC in analysis, design, development implementation and deployment of large software products in both Client/Server Environment using Oracle 11g database.
• As a Senior Oracle Developer extensively worked on development and enhancement of PLSQL Programming, Forms 11g/10g, Reports 11g/10g and Oracle Web Application Server.
• Coordinated with business analysts and users to gather requirements and analyzed them to design software applications.
• Prepared functional specification and efficient technical documents throughout teh production life cycle in accordance with teh business standards.
• Created, customized, and managed Oracle10g Database Packages, Stored Procedures, Functions and Triggers for applications using PL/SQL and SQL*PLUS.
• Developed ETL processes using PLSQL and Shell script to transfer teh data across various data source.
• Extracting teh data from different sources to load into Oracle database stage tables to target.
• Developed applications for High Volume OLTP and Data Warehouse batch processing.
• Designed and Documented teh Logical and Technical architecture to extract and integrate data.
• Heavily involved in designing and development of UNIX Shell scripts and PL-SQL processes to transfer data between multiple Unix/Database servers using Secure (SSH) File Transfer Protocol (SFTP, SCP). Worked on data conversion.
• Created Multiple Windows and Canvas Forms, PLSQL packages, extensively used Forms Triggers, Object Groups, Record Groups and PLSQL Libraries.
• Developed teh Lightweight Directory Access Protocol (LDAP) process to update user attributes in Oracle Internet Directory using DBMS LDAP.
• Responsibility for planning and performing teh system testing of teh software to determine whether teh software product satisfies its requirements.
• Extensively tested teh Oracle Modules, UNIX Processes and Programs for achieving accuracy, timely processing of teh data.
• Responsible for production support. Resolutions of production issues and fixing teh technical problems in Scheduled Oracle and UNIX Crontab jobs of Applications.
• Developed Oracle backend and Forms process dat track employment security and suitability screenings through teh certification processes dat fully comply with Federal Law.
• Worked on various performance issues and design issues of backend processes, forms and reports.
• Developed and organized complex SQL Queries, Procedures, Functions, Packages, Materialized views and Triggers to handle errors and exceptions Confidential database level using PL/SQL.
• Worked on NRM Applications migrations from Oracle10g/Forms10g to Oracle11g/Forms11g and Oracle9i/Forms6i to Oracle10g/Forms10g as well.
• Extensively worked on Split project of NRM Applications. Converted main database into multiple Oracle 11g database for each application and design teh interface between teh application for data access and transfers.
• Developed Test cases and performed Unit and Integration testing for every development tasks.
• Worked mostly with System and Database Administrators (DBA) to design and create relational database, data modeling, data conversion, data transfer, deployment and production support.

Environment: ORACLE Database 11g, Oracle Enterprise Manager (OEM), SQL* Loader, SQL* Plus, PL/SQL Developer, UNIX Shell Scripting, Oracle Forms and Reports, Discoverer, XML, MS Office, Java.

Confidential, Portland, OR

Sr PL/SQL Developer

RESPONSIBILITIES:

• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Developed Unix Shell Scripts to automate backend jobs, loading data into teh database using SQL* Loader.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per teh requirement given by business.
• Gatheird Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Designed and developed various Oracle Forms for teh new business flows.
• Teh Oracle Forms 6i was upgraded to Forms 10g with a brand new platform.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Executing and maintaining teh data warehouse extract transform load (ETL) process.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce teh run time of complicated queries on Oracle 10g.
• Understanding of teh Functional specifications based on dat prepared design documents using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Handling all teh application roles both in teh application tier (Oracle Forms) and in Database tier (Database Roles and Synonyms).
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure their are no missing elements, and perform integration testing.
• Constructing complex SQL queries with sub-queries, inline views as per teh functional needs. Create SQL scripts to perform unit and component testing.
• Handling code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest.
• Performing teh performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor teh database processes and performance.
• Creating shell scripting for generating reports for clients.
• Tuning of Queries, Packages using Oracle utilities Explain Plan, DBMS Prof.
• Developing procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from teh database. Created Partitions on teh tables to improve teh performance.
• Wrote Proc*C programs to handshake data with other projects.
• Created Cursors and Ref cursors as a part of teh procedure to retrieve teh selected data.
• Quickly learned a wide range of technology skills and business noledge required for my projects.
• Interacted with client to gather teh requirements and implement teh same in teh project.
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary

Environment: Oracle 10g/11g, PL/SQL Developer, HP-Unix, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, Pro *C, Oracle forms, UNIX Shell Scripting.

Confidential, Charles Town, WA

Oracle Developer

RESPONSIBILITIES:

• Developed Unix Shell Scripts to automate backend jobs, loading data into teh Database using SQL* Loader.
• Gatheird Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL*LOADER.
• Coded complex SQL queries to retrieve data from teh database depending on teh business logic.
• Designed Dimension and Fact tables for Star Schema and Snow Flake Schema to develop data warehouse.
• Executing and maintaining teh data warehouse extract transform load (ETL) process.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.
• Developed teh ETL mappings in PL and SQL via packages, procedures, functions, views and triggers.
• Worked on DBMS SCHEDULER to schedule jobs.
• Worked on UTL FILE to read and write data from database.
• Work towards a balanced, risk-driven SDLC target.
• Worked on DBMS STATS and DBMS PROFILER to enhance performance of PL/SQL programs.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Created Logical and Physical Models using ERWIN.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Created Cursors and Ref cursors as a part of teh procedure to retrieve teh selected data.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Worked on DBMS STATS and DBMS PROFILER to enhance performance of PL/SQL programs.
• Used features like bulk collect to process large amount of data in data base.
• Created Logical and Physical Models using ERWIN.
• Wrote custom support modules for upgrade implementation using PL/Sql,Unix Shell Scripts and Pro*C.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL, Pro*C and Unix utilities.
• Managing Partitioned tables and Indexes for efficient and robust access of data.
• Written PL/SQL cursors for transaction processing.
• Involved in interacting with teh end-user (client) to gather business requirements.

Environment: Oracle 10g/11g, HP-Unix, Oracle Enterprise Manager, VSS, SQL*Loader, SQL*Plus Pro*C, Toad Data Modeler, UNIX Shell Scripting.

Confidential, Newark, NJ

Oracle Developer

RESPONSIBILITIES:

• Created Database Objects like Tables and Views as per Client Requirements.
• Actively Participated in different phases of SDLC.
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing teh Queries to enhance teh performance.
• Analyzed Indexes on regular basis.
• Involved in teh optimization of Oracle queries.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Design, development and implementation of complex ETL Processes with Informatica 7.1.3
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.
• Implemented Triggers based on teh business rules.
• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Analyzed teh existing Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Worked with Dynamic Queries (SQL).
• Served as a technical expert in developing database designs for Data Warehouse.
• Created users privileges and managed user roles and grants.
• Worked on DBMS SCHEDULER to automate jobs.
• Made use of DB LINKS for accessing data across different databases.
• Stored data in teh audit log tables using teh old and new column attributes.
• Loading data into teh Database using SQL* LOADER.
• Build several Unix Shell wrappers for Pro*C programs to schedule them on Cron.
• Used teh Oracle Import/Export utilities for taking teh backup of a particular partition data.
• Gatheird Statistics and Analyzed Tables and Indexes for Performance tuning.
• Performed debugging of teh PL/SQL codes using teh DBMS OUTPUT.

Environment: Oracle 9i/10g, HP-Unix, Oracle Enterprise Manager, VSS, SQL*Loader, SQL*Plus, Toad, Pro*C, Data Modeler.

Confidential, Alpharetta, GA

Oracle Developer

RESPONSIBILITIES:

• Responsible for capturing teh requirements and impact analysis, preparing High and Low level design documents.
• Extensive hands-on designing and developing numerous packages, procedures, functions and triggers using PL/SQL and SQL/PLUS.
• Creation and maintenance of database objects, Materialized Views, Dynamic SQL, complex queries. Performing Import and Export, data interface across databases, data transfer between multiple databases and loading using SQL Loader.
• Organizing teh Project Plans, efforts estimate, preparing schedules, task assignment to team members.
• Interacting with teh customer ( Confidential &T) for inputs, reviews, software deliveries, deployments on Production in live environment.
• Customization and development of Forms10g, Reports10g. Designed teh various Forms and complex Reports layout dat TEMPhas complex queries.
• Managed multiple databases. Handled teh various oracle database background processes on UNIX system. UNIX shell scripts and oracle database processes
• Providing technical and functional guidance to teh team members and reviews their work.
• Managing and executing project in Web-based environment using Oracle Application Server 10g.

Environment: Oracle 10g, Forms10g, Reports10g, UNIX, Oracle Application Server 10g, TOAD

Confidential 

PL/SQL Developer

RESPONSIBILITIES:

• Involved in interacting with teh end-user to gather business requirements.
• Resolved application problems to maintain high level of customer satisfaction.
• Involved in performance fine-tuning of teh queries/report using PL/SQL and SQL Plus.
• Developed Unix Shell Scripts to automate backend jobs, loading data into teh Database using SQL* Loader.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Developed database triggers required for teh Integrity constraints.
• Created Logical and Physical Models using ERWIN.
• Performed performance tuning and query optimization.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve teh performance of teh application.
• Coded complex SQL queries to retrieve data from teh database depending on teh need.
• Created Cursors and Ref cursors as a part of teh procedure to retrieve teh selected data.
• Written PL/SQL cursors for transaction processing.
• Written Queries for teh management in teh form of stored procedures and packages.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Developed batch programs in Pro*C and wrote Scripts to run them on Unix Cron Scheduler.
• Created partitions on teh tables to improve teh performance.
• Extracted data from Flat files, Oracle and SQL server sources.

Environment: Oracle 8i, Solaris 5.9, SQL Developer 1.1, Serena PVCS, Oracle Enterprise Manager, Windows 2000, Oracle forms 6i