Summary:

• Around 8 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL that 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, and 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 knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensive experience in writing Static Dynamic REF Cursors, Dynamic SQL, Records, PL/SQL tables Exception handlers.
• Wrote Proc C programs to handshake data with other projects.
• Designed and implemented pre and post processing Pro C programs for ETL process.
• Extensively worked on SQL Loader, creation of control files to load the 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.
• expertise 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:

Professional Experience:

Confidential

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 the production life cycle in accordance with the 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 the data across various data source.
• Extracting the 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 the 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 the Lightweight Directory Access Protocol LDAP process to update user attributes in Oracle Internet Directory using DBMS LDAP.
• Responsibility for planning and performing the system testing of the software to determine whether the software product satisfies its requirements.
• Extensively tested the Oracle Modules, UNIX Processes and Programs for achieving accuracy, timely processing of the data.
• Responsible for production support. Resolutions of production issues and fixing the technical problems in Scheduled Oracle and UNIX Crontab jobs of Applications.
• Developed Oracle backend and Forms process that track employment security and suitability screenings through the certification processes that 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 at 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 the interface between the 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

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 the 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 the requirement given by business.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Extracted data from Flat files using SQL LOADER.
• Designed and developed various Oracle Forms for the new business flows.
• The 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 the data warehouse extract transform load ETL process.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Understanding of the Functional specifications based on that prepared design documents using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions,Insert All, Global Temporary tables.
• Handling all the application roles both in the 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 there are no missing elements, and perform integration testing.
• Constructing complex SQL queries with sub-queries, inline views as per the 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 the 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 the 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 the database. Created Partitions on the tables to improve the performance.
• Wrote Proc C programs to handshake data with other projects.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Interacted with client to gather the requirements and implement the same in the 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

Oracle Developer

RESPONSIBILITIES:

• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL Loader.
• Gathered 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 the database depending on the business logic.
• Designed Dimension and Fact tables for Star Schema and Snow Flake Schema to develop data warehouse.
• Executing and maintaining the data warehouse extract transform load ETL process.
• Tuned queries using EXPLAIN plan, SQL Trace, OracleHints, Optimizers and Indexes for better query performance.
• Developed the 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 the procedure to retrieve the 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 the 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

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 the Queries toenhance theperformance.
• Analyzed Indexes on regular basis.
• Involved in the 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 OracleHints, Optimizers and Indexes for better query performance.
• Implemented Triggers based on the business rules.
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to Staging Area Tables.
• Analyzed the 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 the audit log tables using the old and new column attributes.
• Loading data into the Database using SQL LOADER.
• Build several Unix Shell wrappers for Pro C programs to schedule them on Cron.
• Used the Oracle Import/Export utilities for taking the backup of a particular partition data.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.

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

Confidential

Oracle Developer

RESPONSIBILITIES:

• Responsible for capturing the 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 the Project Plans, efforts estimate, preparing schedules, task assignment to team members.
• Interacting with the customer AT T for inputs, reviews, software deliveries, deployments on Production in live environment.
• Customization and development of Forms10g, Reports10g. Designed the various Forms and complex Reports layout that has complex queries.
• Managed multiple databases. Handled the various oracle database background processes on UNIX system. UNIX shell scripts and oracle database processes
• Providing technical and functional guidance to the 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 the end-user to gather business requirements.
• Resolved application problems to maintain high level of customer satisfaction.
• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL Loader.
• Managing Tables, Indexes, Constraints, Views,Sequences, and stored program units.
• Developed database triggers required for the 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 the performance of the application.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Written PL/SQL cursors for transaction processing.
• Written Queries for the management in the 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 the tables to improve the 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