Professional Summary:

• About 7 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 the Oracle Relational Database Management System RDBMS , SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience ofPerformance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, usingQuery Optimizer, Indexes, Execution Plans, Hints, TK- Prof andExplain 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.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• 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 the database and also creating External Tables to manage data which is store at the OS level.
• Ability to coordinate several tasks at a time and excellent decision-making skills, demonstrated excellent problem solving and active listening skills.
• Mentored and trained junior team members.
• 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 .
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Worked on Oracle Forms10g/9i/6iReports10g/9i/6i.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Well-versed with different stages of Software Development Life Cycle SDLC .
• Extensively used PL/SQL to buildOracle 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 the versions of Forms/Reports.

Key Skills:

Work Experience:

Confidential

Role: sr. Oracle Developer

Responsibilities

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Created data accuracy and consistency reports.
• Created complex relational database queries/SQL, dynamic SQL.
• Used various report items like tables, sub report and charts to develop standard and customized reports
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Developed the ETL mappingsin PL/SQLvia packages, procedures, functions, views and triggers.
• Built physical data structures like tables, views, constraints Indexes.
• Loaded the 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.
• Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
• CreatedETL design specifications.
• Created table partitioning based on the 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.
• Created SQL 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.
• Created 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, SQLLoader, Cognos, ODI, SQL Plus, Windows NT 4.0/2000/XP, Microsoft sql server.

Confidential

Role: Sr. Oracle 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.
• 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
• Modify existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Coordinate with the DBA for Table creation and other administrative activities.
• Responsible for analyzing tables and indexes regularly to keep the STATS up-to-date.
• Involve in Data Extraction, Transformation and Loading ETL process from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Deliver solutions that are reliable, easy to maintain and meet or exceed established performance measures.
• Create new database objects like tables, Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in Oracle PL/SQL.
• 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.
• Involve in the continuous enhancements and fixing of production problems.
• Worked with different teams to set up the development and test Autosys environments.
• Used SQL hints and Indexes as needed to improve SQL performance
• Work in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Solving the offshore technical issues and co-coordinating between offshore team and client.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project

Environment:Oracle 10g, SQL Plus, TOAD, SQL Loader, SQL Developer,Shell Scripts, UNIX, Windows XP

Confidential

Role: Oracle Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Experienced with bulk collections and for all operations on tables to improve the performance of manipulation language statements.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic sql statements.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g, UNIX, Windows XP/2000.owb 10g.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Used tortoise svn version control for changing the codes.
• Making changes to the existing apex applications in the production.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used ORACLEsqlDEVELOPER for creating PL/SQL trigger, sequence, stored procedure .

ENVIRONMENT:Oracle 9i/10g, Reports 9i, SQL, PL/SQL, TOAD, SQL Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential

Role: Oracle Developer Team lead

Responsibilities:

• Created 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 the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Providing technical assistance in identifying, evaluating and developing systems and procedures that are cost effective and meet business requirements.
• Created 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 the 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.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Identifying test execution strategy and scope andEstablishing test acceptance criteria.
• Supporting the application throughout the 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

Confidential

Role:Database Developer

Responsibilities

• Used Oracle JDeveloperto support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API's like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Strong analytical and problem solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Sequences packages and procedures.
• Involved in Logical Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Participated in system analysis and datamodeling
• Worked on XML along with PL/SQL to modify/create interface between system Performed Database Administration of all database objects including tables, clusters, indexes, views, Performance tuning of Oracle Databases and User applications.
• Used SQL Loader as an ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment:Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL LoaderAnd SQL