SUMMARY:

• About 8 years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL Developer. Solid experience in Financial, Government, Automotive, Retail Management system
• Expertise in SQL and PL/SQL programming and strong knowledge on Oracle architecture and database design.
• Good knowledge in Relational Data Modelling.
• Expertise in using Oracle 9i/10g/11g databases, PL/SQL.
• Strong experience in designing and developing oracle objects Tables, Views, Indexes, PL/SQL Stored Procedures, Functions, Packages, Triggers and fine tuning them.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Dynamic SQL, Analytical functions, PL/SQL Collections, Bulk Collections, Nested Tables, VARRAYS, Records, Type.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyse business requirements and translating requirements to functional and technical design specification.
• Developed normalized Logical and physical database models to design OLTP system.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes and materialized views and managing database.
• Extensive knowledge in designing Oracle Forms and Reports using Oracle developer.
• Strong knowledge in Oracle Cursor Management, Exceptional Handling, REF - Cursor.
• Good Understanding of Oracle Data Dictionary, RDBMS, Normalization Techniques.
• Proficient and Designed numerous Oracle Forms and Reports by interaction directly with End Users and Business Analyst.
• Expertise in using tools such as TOAD, SQL* Plus, SQL* Loader, PL/SQL Developer.
• Strong working experience in both Agile and WaterfallSDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Experience in building Dataware houses/Data Marts using Informatica Power Centre
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Good knowledge in Performance tuning, SQL Tuning, Data optimization, query optimization, job scheduling.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Experience on Autosys Job Scheduling.
• Experience in Migration of source code using Tortoise Subversion(SVN) and good knowledge in code merging and maintenance using SVN.
• Quick learner and a team player with strong communication and interpersonal skills.
• Worked on production support, troubleshooting the application and resolving bugs.
• Excellent Analytical, Conceptual and root cause analysis and problem solving skills.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g, Forms 10g/9i/6i, MS Access, DB2

Scripting: SQL, PL/SQL, UNIX Shell Scripting, Autosys

Languages: C, C++, HTML, PHP, CSS, Pro *C

Operating System: Windows 2000/NT/XP/7/98/8, OS X and UNIX

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, PL/SQL Developer

ETL Tools: Informatica Power Centre

Other Tools: SQL*Loader, MS Office(Word, PowerPoint, Excel, Visio), Oracle Forms 11, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Developer

Responsibilities:

• Created Functional Design and prepared technical documentation for development and implemented on the DQS and IMP application based on the requirement.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Written various complex SQL queries and PL/SQL Procedures/Functions, collections, triggers and Exceptional Handling.
• Written complex sub-queries and Join Conditions based on the requirement.
• Used analytical functions and worked on different aggregate functions for data retrieval.
• Was involved in development and core review and involved in identifying design issues and fixing them.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching betweenSQL andPL/SQLengines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad andSQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Extensively used the advanced features ofPL/SQL like Records, Tables, Object types and DynamicSQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Written procedures for bulk uploading, and used ref cursors are parameters.
• Tuned various SQL queries that were long running to overcome performance issues.
• PerformedSQL andPl/SQLtuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Worked in Production Support environment as well as QA/Test environment for projects, maintenance, bug fixes, enhancements, data changes.
• Performed Unit testing and worked with Quality Centre along with the testing team.
• Worked on Unix Environment and Autosys job scheduling to run monthly/weekly or daily batch jobs.
• Used Pragma autonomous Transactions to avoid mutating problem in database trigger.
• Maintained SVN Repository, deploy code base to SIT and UAT environments as requested.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Worked on automating the ETL processes using Autosys Job Scheduler.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Oracle 11g, SQL Developer, SQL* Loader, Toad, Unix, Quality Centre, Autosys, Informatica Power Centre 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), SVN.

Confidential

Oracle Database Developer

Responsibilities:

• Created database design and technical documentation for database objects and work flow for reengineering or implementing additional modules to ECMPS/ Data& Maps (Data Warehousing) applications.
• Created oracle database objects like table, sequences, collections, packages, View, Materialized Views, collections, Triggers, Pl/SQL object types.
• Performed weekly oracle database migrations from development databases to staging database.
• Actively involved in all phases of SDLC and worked in Scrum environment.
• Executed PL/SQL blocks using cursors, REFCURSORS, exception handling, Collections, Index of Table and Dynamic SQL.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export, Text IO Package and Copy Command (Migration).
• Used Table partitioning and Partition Exchange for Archiving Emissions data Used DBMS XML, DBMS XSLPROCESSOR built-in packages for loading XML data into Oracle Tables.
• Extensively used oracle Built-in packages like DBMS LOB, DBMS OUTPUT, UTL SMTP, UTL FILE, DBMS SQL, DBMS STATS, UTL COMPRESS, UTL ENCODE
• Extensively used variable like CLOB, BLOB, and XMLTYPE.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs f the project and client requirements.
• Wrote extensive Exception handling procedures to handle exceptions.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Used DBMS Scheduler package for creating Scheduler jobs daily OLTP data updates and DataMart updates.
• Extensively used analytical functions such as lag, lead, rank, dense rank.
• Extensively used SQL*Loader for loading data into oracle database from flat files.

Environment: Oracle 10g/11g, PL/SQL Developer, SVN, SQL*LOADER, TOAD, Oracle SQL Developer

Confidential

Oracle Database Developer

Responsibilities:

• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages.
• Creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Programs and Jobs.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Was part of Job scheduling for Snapshot tasks like inserting history data into history tables when the original tables are overloaded and the data needs to be moved.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Designing the control file to load data from flat files obtained from various interfaces using SQL*Loader.
• Creating several UNIX shell scripts according to the project and client requirements.
• Writing Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Wrote extensive Exception handling procedures to handle exceptions.
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Performance tuning and query optimization were extensively needed in these projects and worked on the same.
• Designed and created an internal product querying system usingOracle Reports and Forms.
• Developing triggers and audit tables to insert update and delete on Master Tables for Audit purpose.
• Have worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc.).
• Performance tuning,Pl/SQLtuning and application tuning using various tools like EXPLAIN PLAN andSQL*TRACE.
• Creating PL/SQLscripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Supported AdvancePL/SQL using Cursor, REF Cursor.
• Worked on indexes, rebuilding indexes online, invisible indexes, parallel hint.
• Made use of cursors in procedures to generate high performance queries and PL/SQL code.
• Used SVN source control software to track code changes.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Created Materialized views and Materialized view logs.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Development experience inOracle with full SDLC agile process and scrum methodologies.
• Participating in the continuous enhancements and fixing of production problems.

Environment: Oracle 10g/11g, PL/SQL, SQL*Plus 10.1, SVN, SQL*Loader, Toad 8.6 & 9.1, UNIX, Windows

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in developing and testing of PL/SQL stored procedures, packages and triggers.
• Developed complex SQL and PL/SQL queries.
• Created database objects like Tables, views, synonyms, indexes.
• Used SQL* Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into base tables.
• Created Forms and Reports using Forms 9i and Reports 9i respectively.
• Extensively wrote SQL queries (Sub Queries, correlated sub queries and join conditions) for generating various kinds of reports as per the user requirement.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed the form with menu system and linked the related form with the respective button.
• Deployed the forms in the development environment.
• Developed stored procedures using PL/SQL Tables and records to generate the output in XML format.
• Worked on Developing Forms Screens used by Oracle Developer Suite for forms
• Scheduled jobs using corntab in UNIX.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Developed forms using forms 9i based on business requirements.
• Using UNIX Shell scripting created batch jobs to create index and analyze tables once the imports are done.
• Involved in coding, debugging and trouble-shooting.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Worked on SQL Query performance issues. Used index logic to obtain good performance.

Environment: Oracle 10g/11g, SQL*Plus, SQL, PL/SQL, UNIX (HP), Shell Script, SQL*Loader, Oracle Forms 9i, Windows 7.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in PL/SQL coding, Designing.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Developed Functions and Procedures for extracting data from different tables using joins and insert them into a table.
• Gathered statistics and analysed tables and Indexes for performance tuning.
• Developed SQL Queries (Sub queries and Join Conditions), PL/SQL programming to extract data from large databases.
• Involved in the creation and testing of database objects like tables, views, stored procedures, functions, packages, DB triggers Indexes and Collections.
• Created Object Types in PL/SQL.
• Utilized SQL*Loader to load flat files database tables.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Developed Cursors for flagging of records.

Environment: Oracle 10g/11g, PL/SQL, SQL* Loader, TOAD, Oracle SQL Developer.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Created web pages using HTML, CSS and added dynamic features to it using PHP.
• Created tables and worked extensively on SQL queries.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Developed various queries using views, sub-queries, joins, merge and grouping aggregation functionality.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed complex queries and subqueries to update and insert data into the database.
• Created Web Pages that save rmation and the data is then stored into database.

Environment: Oracle 10g, HTML, PHP