SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience in Designing, Developing, Converting, Implementing and Upgrading of Oracle Applications R 12/11.5.10/11 i using ORACLE 9i/10g/11g, SQL, PL/SQL, Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/10g.
• Worked extensively in Application development using Forms and Reports 6i/9i/10g, Discoverer 4i/10g, SQL, PL/SQL in Client Server architecture using UNIX/ LINUX/ Windows.
• Experience in data warehouse applications using ETL tools and programming languages like SQL/PLSQL Oracle and Informatica.
• Proficient in Data conversions between Modules via interfaces and APIs, using stored procedures, functions, packages and triggers.
• Good Hands on database developer with a strong technical background with Oracle databases Data Mapping, Data Exports & Imports, Application Support, Performance Tuning, Security Administration, Software Maintenance, User and Security Management, Oracle Tuning, Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience on working and designing Physical/Logical data models during initial phase of project.
• Experience in ETL Concepts Workflow, Monitor and Design.
• Have good Experience with the use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, and Materialized Views, Query Re - Write and Transportable table spaces. Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in data warehouse applications using ETL tools and programming languages like SQL/PLSQL, Oracle.
• Knowledge with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in performance Tuning- Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing TkProf, Explain Plan and Hints.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Used Complex partitioning strategy, partition exchange, split partition etc.
• Have experience on Eclipse on how to migrate code between system environments and Using Jenkins to deploy the code to Multiple Environments and Have experience with source control tools such as GIT STASH and SVN, SVN used for code Subversion Control.
• Expertise in distributed query performance tuning by using EXPLAINPLAN, SQL Trace and TKPROF Utilities, Hints provided by Oracle.
• Have experience with ETL process ensuring proper implementation of Loggings, breakpoints, Checkpoints, Save points Transactions and package configurations.
• Have a good experience with financial domain especially in banking sector and system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS.
• Strong experience on various programming techniques, BULK COLLECT, User defined exceptions, MERGE, Global temporary tables.
• Hands on experience on various database batch jobs to run weekly base using Tivoli and Jenkins.
• Expertise in Extract Transfer Load (ETL) Process, PL SQL Development, Oracle RDBMS, Performance Tuning, Data Modeling, Data Warehousing and Testing.
• Experienced with all phases of Methodologies Agile and Waterfall, Enterprise Reporting Life Cycle, Problem management.
• Have good communication skills and good performance within the Team combined with self-motivation and hard work, involved with communicate Offshore and onsite team.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX, Linux

Programming languages: C, C++, VC++, C#, Java, PL/SQL programming.

Web Technologies: HTML, JSP

Script Languages: JavaScript, Shell scripting, Perl

Tools: Toad, SQL Developer, OEM, PL/SQL Oracle Developer/2000, Oracle Forms/Reports 6i/9i/10g, Autosys, Putty, Citrix, Reflections for Unix, Informatica Powercenter 8.6

Database: Oracle 10g/9i/8i/8, MS Access 2000, MySQL, MS SQL server 2005/2008

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, SC, TX

Oracle PL/SQL Developer

Responsibilities:

• Working in data analysis, data modeling, development, testing and documentation.
• Developing advanced PL/SQL scripts using Cursor, REF Cursor, and Native Dynamic SQL; develop complex triggers using PL/SQL for data integrity and enforcing reports.
• Working on Exception Handling extensively debugs PL/SQL Code, DDL, DML and display the error messages in the application.
• Interact with Business Analysts, gather business requirements and convert them to technical Specs.
• Created the Oracle database, tables, tablespaces.
• Create new indexes, views, materialized views, synonyms and sequences.
• Create Database links to connect to remote Tables, Views and Materialized views.
• Create Oracle store procedures, packages and functions.
• Used functionalities like package overloading, global variables.
• Created tables and index partitioning.
• Used partition methods - Range, List and Hash.
• Involved in creating local and global indexes.
• Moved data across different databases using import and export Oracle utilities.
• Used explain plan, Autotrace and Tkprof in tuning SQL queries.
• Used Oracle hints to tune queries.
• Extensively used parallel, driving site, all rows, first rows,no index, use nl and other optimizer hints.
• Extensively used Aggregate and Analytical functions.
• Performed direct loads using append hint.
• Used Exception Handling to handle runtime & user defined exceptions.
• Used Oracle Database Triggers for error log and auditing.
• Support in developing, maintaining and supporting a business intelligence strategy.
• Develop strategy on Open Source Data Integration, Data Ingestion using latest Analytics tools.
• Working with excellent organization and communication skills.
• Performed Extract Transfer Load (ETL) Process, PL SQL Development, Data Modeling, Data Warehousing and Testing.
• Created Table partitions and materialized views to improve the performance of slow running queries.
• Partitioning of Large Tables and Indexes.
• Created Local and global indexes based on the need on partitioned tables
• Performance tuning of complex SQL queries using Explain plan, Tkrpof and PL/SQL code.
• Used Explain Plan, creation of new indexes to improve the performance of SQL statements.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Work closely with java developers and tune the queries used in Applications.
• Provide queries or data to Java applications through ref cursors.
• Understand java code and debug issues related to queries.
• Worked on Informatica Power Center client tools - Mapping designer, Workflow Manager, Workflow monitor, Repository manager, Mapplet designer and Transformations.
• Extensively used Informatica debugger to figure out the problems in mapping. Also, involved in troubleshooting existing ETL bugs, created a list of the inconsistencies in the dataload on the client side to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database and written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Oracle 11g, SQL, PL/SQL, Unix, Korn Shell Scripting, Python, Jira, bitbucket, Windows NT, Reflection for Unix, Oracle Forms/Reports 6i, Windows XP Pro, MS Office 2003 (Excel, Word)

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Contributed to the Software Development Life Cycle (SDLC) from Conceptual analysis and design stage to implementation and maintenance of systems.
• Develop and manage multiple schemas that represent each layer of Dev, SIT and Production. Maintained moderate to complex PL/SQL applications including - performance tuning with indexing, native compilation, bulk loads etc.
• Performing data export, import, and various operations using TOAD and SQL Developer.
• Developing advanced PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL; develop complex triggers using PL/SQL for data integrity and enforcing business rules.
• Involved in designing of required end user forms and reports using Oracle forms 9i & Reports 9i
• Working on Oracle server-side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables.
• Working on Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
• Working in data analysis, data modeling, development, testing and documentation.
• Working on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
• Writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
• Working on Exception Handling extensively debugs PL/SQL Code, DDL, DML and display the error messages in the application.
• Creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in UI development using JAVA framework and jQuery.

Environment: & Tools: Oracle 10g/11g, SQL developer, PL/SQL developer, Oracle Forms, TOAD, Informatica power center, SharePoint, PUTTY, Shell script, HP Quality Center, Erwin.