SUMMARY

• Dynamic professional with 8+ years of extensive experience as an Oracle PL/SQL Developer with ETL, shell scripting experience in diverse sectors including E - commerce, Insurance, Finance, telecommunication, Pharmaceuticals.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g database.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i, Reports10g/9i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Experience in using data sources/targets such as Oracle 12c/11g/10g, MS SQL Server 2008/20012, DB2, XML and Flat files.
• Developed Oracle Forms and Oracle Reports using 11g,10g depending on the functional requirement document.
• Extensively worked in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Proficient in data migrations, data loads, data conversions, interface (Inbound/Outbound) programs, workflows and using Oracle ETL Utility tools like SQL Loader, External Tables, export, import and data pump.
• Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL Collections, Cursors, Bulk Processes (DML), Merge, Dynamic SQL (DDL), Exceptions handling, Autonomous transactions, Pipelined Table Functions, Partitioning, Materialized views.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Experience in creating Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding about Fact and Dimensions
• Very Good Experience in Data Warehouse Created start schema and snow flake schema data model and populated data using ETL tools.
• Experience in creating SQL server SSIS using Microsoft visual studio
• Excellent communications and analytical skills.
• Having experience as Lead. Lead offshore team.
• Highly organized and efficient to prioritize and manage multiple tasks.
• Skilled in all dimensions of functionality, usability, reliability and Agile Methodology

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g, MS SQL 2008/2012, MS Access, DB2

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML

Operating Systems: Windows Family, MS-DOS, Linux

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail in to technical design and specification.
• Analyzed the data, extracted from the different source systems based on the business rules.
• Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure.
• Designing and developing data models using ERWIN tool.
• Creation of Database, table spaces, schema objects and stored procedures.
• Developed various backend application programs such as Views, Functions, Triggers, Cursors, Procedures and Packages using SQL and PL/SQL.
• Responsible for creating functions to be used for calculations. Written database triggers for monitoring the data migration.
• Developed algorithm and PL/SQL code for efficient retrieval and manipulation of complex data sets using PL/SQL packages.
• Written PL/SQL procedures and functions while migrating the data from the source legacy systems to the Target system (Oracle database).
• Extracted and transformed source data from different database like Oracle, SQL Server and DB2 and flat file into oracle.
• Loaded the flat file data into database table by creating multiple SQL LOADER control scripts.
• Have worked on Reports development using APEX.
• Created and modified database objects like tables, views, and constraints.
• Implemented business logic using stored procedures to increase performance.
• Created schema objects like tables, indexes, synonyms, sequences, stored procedures, functions, packages and views.
• Heavily involved in UNIT testing the database code for data integrity, module testing for validating each module independently, application testing for application functionality and integration testing of all modules together.
• Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases.
• Worked on Query Optimization Techniques for complex SQL hints Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Wrote Unix Shell scripts for automating the process
• Enhanced the existing UNIX scripts to run batch processes, oracle background processes using JOBS & achieve better performance and throughput.
• Fixing performance problems with PL/SQL programs.

Environment: Oracle 11g client version,12c, SQL Developer, UNIX Shell Scripts, Perl programming, ETL, SQL*Plus, MS Excel, MS- Visio, VI Editor, HTML, Java script, CSS, APEX, ERWIN, SQL Loader

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Created and managed users, roles and profiles, audited and monitored databases and user access
• Involved in all phases of SDLC as active participant.
• Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Used various Indexing and partition techniques to improve the query performance.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Improved the performance of the application by rewriting the SQL queries.
• Created Materialized Views, tables, complex SQL queries, correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development, database objects, managed partitioned tables, managed table spaces.
• Created Custom tables and new custom objects were designed as per business requirements and Responsible for Partitions on tables and Indexes for managing large tables.
• Designed and developed Oracle PL/SQL Procedures, Functions and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created PL/SQL stored procedures, functions and packages.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules and for moving the data from staging area to data mart.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Developed Unix shell scripts for automating many tasks and for monitoring the database.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Tuned Report performance by exploiting the Oracle's new built-in functions and rewriting SQL statements.
• Used Dynamic SQL to implement DDL statements in PL/SQL programs.
• Created scripts to create new tables, views and queries for new enhancement in the application using TOAD.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Worked with Development team to fulfill the requirements of applications with Database design
• Maintaining data integrity and tune database for optimum performance and availability.

Environment: ORACLE 11g, SQL Developer, TOAD, UNIX, FileZilla & WinSCP, WebLogic, Vector wise.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Created records, tables, collections (nested tables and arrays) for improving query performance by reducing context switching.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Wrote Unix Shell Scripts to process the files on a 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.
• Creation of database objects like tables, views, materialized views, procedures and packages using Oracle tools like Toad, PL/SQL Developer and SQL *PLUS.
• Worked on SQL *Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL *Trace, TKPROF and Auto Trace.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL-FILE package.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created PL/SQL stored procedures, functions and packages for moving the data from the staging area to the data mart.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Created Indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL *Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic

Environment: Oracle 11g, Forms 9i, Reports 9i, SQL Loader, SQL Developer, Windows 7, UNIX Shell Scripts, Perl programming, ETL, MS Excel, MS- Visio, VI Editor, HTML, JavaScript, CSS.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed the complex Packages, procedures, functions, triggers using SQL and PL/SQL efficiently in loading, validating and cleansing the data.
• Worked extensively on tuning of SQL and PL/SQL code using various tools like explain plan, TKPROF, SQL tuning advisor and SQL trace to enhance the performance.
• Developed interfaces using PL/SQL packages, stored procedures, functions, Object Types, Cursors, Pipelined functions, Oracle queues and used Collections and Bulk Collects.
• Developed triggers, sequences and materialized views. Used various pl/SQL objects for backend and as middle level Data Access Layer between Java and Oracle in OLTP and data warehouse applications.
• Wrote complex SQL queries using Joins, sub queries and inline views to create reports in SSRS and Cognos.
• Designed and developed a huge database of 120 tables and its data load process from flat files and also designed complex functional views for Payroll application.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using SQL*Plus, TOAD.
• Extensively used SQL Loader and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled load processes and backup jobs.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables)
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Production support for the backend database and reporting applications.

Environment: Oracle Database 10g, Windows XP, TOAD, SQL Loader, JavaScript, LINUX.

Junior PL/SQL Developer

Confidential

Responsibilities:

• Analyzed business requirements of the project by studying the Business Requirement Specification Document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like SQL Plus, SQL Loader and Exception handling.
• Designed the front-end interface for the users using oracle Forms, Reports using 8i
• Timely monitoring of database and system backups developedOracle stored procedures, functions, packages and triggersthat pull data for reports.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Participated in Performance Tuning for query optimization and program performance.
• Involved in Technical Documentation, Unit testing, Integration testing and writing the Test plan.
• Use joins on various tables and display data from multiple tables.
• Automated Quality Check tasks by creating PL/SQL cursors, functions and dynamic SQL.

Environment: Oracle 10g, SQL Plus, Windows XP, UNIX, HTML, Oracle SQL Developer, Erwin, Oracle, Informatica PowerCenter 8.6/8.1, Java, MS Access 2000/2002.