SUMMARY

• 8 years of experience in Oracle 10g,11g,12c developing back - end modules, such as Packages, Functions, Procedures, Triggers, Object types, Collections, Indexes, sequences and Views for multi-tier business applications, both Data Warehouses and RDBMS systems, in SQL and PL/SQL.
• 5 Years of Experience in UNIX Shell scripting.
• Good Experience working in Financial/Insurance domain
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Comprehensive Experience in Analysis, Design and Development (Coding, Testing & Maintenance) of various types of oracle technology based projects in multi-tier environment for sectors like Telecom, Energy, Investment and Financial Industry.
• Comprehensive experience in ETL using SQL Loader and Datastage to transfer data from multiple sources into target tables.
• Extensively used Cursors, Ref cursors, Nested Tables, Associative arrays, Aggregate functions, Analytical Functions, Regular Expression, Dynamic SQL, Exception Handling, built in Oracle Packages, Materialized views and Views.
• Expertise in Performance tuning of SQL queries, complex procedures and packages to improve performance & decrease response time utilizing Explain Plan, TKPROF, Bulk Collections, Pipelined table functions, Analytical functions, Table partitioning, Hints.

TECHNICAL SKILLS

Languages: Oracle SQL, Oracle PL/SQL, UNIX Shell Scripting, MYSQL, SQL, Oracle Developer 2000, RDBMS Oracle 8i/9i/10g/11g/12c.

Application Tools: Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, Oracle Discoverer, TOAD, SQL Developer, SQL Navigator, Ervin, MySQL Workbench

Database Utilities: SQL*Loader, Export/Import, ETL Tool Ascential Data stage

ETL Tool: Ascential Data stage

Data Modeling Tools: Toad Data Modeler

Operating System: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Sr. PL/SQL Developer

Confidential, Plano,Tx

Responsibilities:

• Worked on implementing variousPL/SQL procedures to track the customer orders.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Project implementation was done in agile methodology.
• CreatedSQLobjects (PL/SQLProcedures, Functions) for measuring the employee work performance on a daily basis.
• Involved in the continuous enhancements and fixing of production problems.
• Involved in the development of ETL processes such as data transformations, data sourcing, mapping, conversion and loading.
• Responsible for creation of Data Clean-up procedures, transformations, Scripts, Stored Procedures and execution of test plan for loading the data successfully into the targets.
• DevelopedSQL*Loader control file according to the mapping tables to populate the custom load tables using the extract file.
• Worked on implementing Collection Types in thePL/SQLblocks.
• Used of EXPLAIN PLAN and HINTS to tune queries for better performance and also Extensive Usage of Indexes.
• Worked on Report builder 10g for creating new reports and also on report fixes and enhancements.
• Worked on Data Extract Process which is done on demand as per the user requirements. Upon their specific request, data is retrieved from various systems usingSQL/PLSQL coding and delivered in their requested format.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Worked on DynamicSQL by using Execute Immediate and DBMS SQLalong with Bulk Collect.
• Extensively used PL/advanced features like forward declaration, Procedure Overloading in the PL/SQLPackages.
• Extensively used Oracle 11g features like RESULT CACHE, Compound Triggers etc.
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBAs regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Created mappings and workflows for data migration using Informatica Power Center.
• Report the project status and generate milestone reports.
• Developed ETL jobs using ODI tool for data migration operations.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Communicate withdevelopers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project's success.
• Extensively used the advanced features of PL/SQLlike Records, Tables, Object types and DynamicSQL.
• DevelopedForms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of forms.
• Analyzed data, designed and developedOracle forms 10g queries, layout, report triggers, parameter form, data modelsetc.
• Programmed inUNIXshell scripts to provide a user interface toOracle formsandreports.
• Created Cron jobs inUNIXfor scheduling file preprocessing.

Environment: Oracle 11g,SQL*Plus,PL/SQLDeveloper, Data Guard,Toad,SQL* Loader, UNIX, Shell Scripts, Erwin, Windows, Linux.

PL/SQL Developer

Confidential, Illinois

Responsibilities:

• Involved in the creation of Oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created and modified several Perl Scripts for various requirements.
• Analysed production issues and involved in the continuous enhancements and fixing of production problems involving NDM file transfer.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization in a high volume OLTP environment.
• Involved in Exadata Migration of Oracle database
• Developed and tested various alerts using Abinitio.
• Created Autosys Jil files to Schedule the Batch jobs and developed game plans for the jil deployment in Production and other Pre Prod environments.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL and extensively used bulk collection in PL/SQL objects for improving the performance.
• Extensively utilized TOAD for performance tuning by generating explain Plan.
• Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
• Created gameplans for Production deployment and participated in reviewing Install plans
• Involved in Production Support during deployment and Post deployment
• Worked with cross functional teams on gathering requirements and troubleshooting issues.
• Extensively used version control tools like Clearcase or Subversion and Clearquest/UCM Worked with Onshore and offshore resources as part of the team

Environment: Oracle Database 11g/12c, Toad, SQL*Plus, Perl, UNIX, Autosys, SVN, Clear quest, Abinitio

Sr. PL SQL Database Developer

Confidential

Responsibilities:

• Managed requirement gathering, Estimation, Data Model, database scripts, functional & technical design and ETL development of integrating data into data Warehouse
• Logical and physical Data modeling and Design of the system
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
• Optimal in loading data from various Flat files using SQL* Loader and implementing Data Cleansing Procedures.
• Well Experienced in Tuning SQL queries, database objects on OLTP Systems by Creating Indexes, Optimizers, hints and analyzing the Explain Plan.
• Building Data warehouse by summarizing the Data on Yearly Granularity and Populating the Data in Star Schema and Snowflake Schema
• Maintaining and organizing the Data Warehouse Building in Hierarchical level as per the Business Rules of data management.
• Performing Performance Tuning on the SQL Queries.
• Developing the Scrips by Using UNIX Shell Scripting.
• XML file generation from database based on demand web service input, Consumer database
• Delegating the task to the Team and preparing the check list for the same.
• Participating in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
• Used SQL Loader to load data from flat files to the testing databases by using Oracle R12.
• Evaluated BI solutions from vendors. (OBIEE, QlikView)
• Created materialized views (snapshot) for remote instances.

Environment: Oracle 11g, SQL, PL/SQL, Informatica9.0, TOAD, PL/SQL Developer tool, UNIX Shell Scripting.

Senior PL SQL Developer

Confidential

Responsibilities:

• Gathered requirements from business users and performed analysis.
• Reviewed and Analyzed Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, and unit testing.
• Designed and created Database objects.
• Used oracle discoverer for logical grouping of tables & views.
• Used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Explain plan to improve database performance.
• Involved extensively in the analysis and tuning of the Application code (SQL).
• Increased performance by fine-tuning PL/SQL Procedures.
• Wrote shell scripts for scheduling jobs.
• Used PVCS for source code configuration management.
• Assisted in testing and deployment of the application.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created a new work book and open an existing workbook.
• Created and Modified OLAP worksheets using IDS.
• Analyzing and sharing data using Discoverer viewer.
• Wrote PL/SQL procedures and packages as per the requirement.
• Implemented complex SQL queries.
• Created views for better performance.
• Created indexes for faster access of tables.
• Worked on Materialized Views and Query Rewrite.
• Wrote scripts to merge data from one system to another system.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX, Oracle Discoverer 10g.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Created custom table, triggers, stored procedures, functions, packages to modify the existing oracle database.
• Created a series of procedures and functions for loan and facilities transactions.
• Analyzed business functionalities related to back-end database interfaces and utilized PL/SQL developed tool to develop all back-end database interfaces.
• Involved in daily, weekly and monthly loading of data from Mainframe data sets to Oracle RDBMS.
• Developed triggers for error handling and to keep track of changes to the fields of tables when changes are made.
• Worked on the stored Procedures, Functions, and Constraints, Tables, Indexes and Tuned queries for performance.
• Created views which require complex joins and quick response time.
• Developed data entry forms using Forms Builder 6i.
• Carried out technical specification documents for back-end and interface with front-end.
• Modified Stored Procedures and Packages using PL/SQL.
• Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.
• Defined relationships using primary keys for the entities and normalized the entities.’

Environment: Oracle 9i, PL/SQL, Toad 8.0, JSP, JDBC, Windows NT, HTML, SQL *Plus, Discoverer, Crystal Reports, Forms & Reports 6i, Test Advisor, Test Director, Business Objects.

PL/SQL Developer

Confidential

Responsibilities:

• Interacting with the business users at the bank for gathering and managing the requirements.
• Performing gap analysis activity to understand and document the gaps between the source and the target system.
• Preparing Business Requirement Document based on the gap analysis activity for capturing the business requirement for all the missing functionality in the target system.
• Understanding all the interfaces in the source system and helping the technical team in preparation of interface & layout specification document.
• Charting out different impact analysis on the migration activity with an alternate strategy for system conversion.
• Prepared the High Level -Technical Design Document for offshore team to proceed with the Code Development.
• Review of code changes, test procedure, test plans and modification of stored procedures.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Loader, Toad, Windows NT/XP.