SUMMARY

• 10+ years of experience as Oracle PL/SQL Developer in Oracle 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Support Projects
• Technical areas of experience related to PL/SQL, UNIX & Shell Scripting
• Experienced in complete life cycle Implementation of PL/SQL Development
• Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization
• Experienced in Object Oriented Programming concepts with Oracle types and member functions
• Performance tuning and optimization using Explain Plan, SQL*Trace, TKPROF and Oracle Optimizer hints
• Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques
• Expertise in Dynamic SQL and Exception Handling
• Experienced in performing Oracle DBA monitoring activities
• Expertise in Data Integration of data from various data sources like SQL Server, Oracle, Flat Files, and delimited files and Data Migration
• Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS, DBMS STATS etc
• Experienced in importing data from Flat files from Legacy Applications to Oracle DB using SQL Loader
• Creating Users, Roles and Profiles, Privilege management with role - based security.
• Experience as a database architect and worked as data modeler.
• Experience on handling teh team and overall project and offshore team.
• Good experience on Exadata and oracle 12 c
• Maintenance of user accounts and privileges to maintain database security
• Experienced in performing basic Oracle DBA activities like importing and exporting schemas between databases
• Expertise in Data Warehousing and ETL concepts
• Good Exposure to Informatica Transformation concepts
• Expertise in handling 24/7 Production Support projects
• Good exposure to Development, Testing, Production Support, Debugging, Implementation and Documentation
• Experienced in Requirements Gathering and Preparing Use Cases
• Comprehensive and in-depth experience using teh System Development Life Cycle (SDLC)
• Expertise in working with Projects in Agile Methodology
• Developed tasks for SCRUM sprint meetings in Agile Methodology
• Strong Team Building & Leadership capability and excellent Mentoring Skills
• A self-motivated, responsible and reliable team player with a set of strong technical skills
• Strong conceptual, business, analytical skills and innovative problem solving abilities
• Good communication, interpersonal and problem-solving skills

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/2003, UNIX, Red Hat Linux 9

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server

Database Tools: Import/Export, SQL*Plus, SQL loader, Explain plan & TKPROF, T-SQL, TOAD, Data Pump

Languages: SQL, PL/SQL, HTML, XML

Scripting: Vi Editor, Shell, Perl Scripting

ETL Tools: Informatica

Analytical Tools: Lavastorm BRE

Reporting Tools: webFocus, webMethods

Version Control Tools: IBM Rational Clear Case, Dimensions, TFS

Service Desk Tools: HP Service Desk, BMC - Remedy, Rally

SCM Tools: I2/JDA SCM Tool

PROFESSIONAL EXPERIENCE

Confidential, Miamisburg, Ohio

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement analysis, ETL designand developmentfor extracting data from teh heterogeneous source systems like SQL Server, Oracle, Teradata, flat files,and loading into Staging and Data Warehouse Star Schema.
• Create PL/SQL Packages which has Procedures, Functions and Triggers
• Performance tune SQL Queries with Explain plan to modify all full table scan paths for faster query execution
• Used Oracle Types, Analytical functions, Collections, UTL File Package, Parallel execution, Dynamic SQL concepts in Oracle PL/SQL Development
• Perform Unit Testing to validate teh code which was modified as a part of requirement change
• Used PL/SQL to create Packages, Functions, and Procedure.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Worked on external tables to load teh data in stage area.
• Worked on pipe line table functions to retrive data faster in collections
• Worked on plsql collections and ref corsors.
• Tuning of teh SQL queries, which takes long time to process teh request using Explain Plan, Hints to reduce teh response time.
• Perform Integration testing to make sure teh modified code doesn’t affect teh teh other processes
• Create Documentation for teh proposed change

Confidential, Tampa, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement analysis, ETL designand developmentfor extracting data from teh heterogeneous source systems like SQL Server, Oracle, Teradata, flat files,and loading into Staging and Data Warehouse Star Schema.
• Maintain and Support teh creation of legal entities and corp gov related modules
• Create PL/SQL Packages which has Procedures, Functions and Triggers.
• Used bulk collect and forall futures teh retrive data fast and insert bulk operations.
• Used data compression and parllel processing techniques.
• Performance tune SQL Queries with Explain plan to modify all full table scan paths for faster query execution
• Used Oracle Types, Analytical functions, Collections, UTL File Package, Parallel execution, Dynamic SQL concepts in Oracle PL/SQL Development
• Perform Unit Testing to validate teh code which was modified as a part of requirement change
• Extensive use of Unix Shell Scripts, Cron jobs and Autosys to automate process.
• Perform Integration testing to make sure teh modified code doesn’t affect teh teh other processes
• Create Documentation for teh proposed change

ENVIRONMENT: Oracle PL/SQL, Oracle 11g, java, Banking Domain

Confidential, Hartford, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

• Estimate, plan, execute and monitor Projects
• Gather requirements for change requests with teh Business team and create design documents
• Provide User Access to Business End Users to teh Front end tools after getting teh required approvals
• Create PL/SQL packages for implementing Change Requests for adding new functionality to teh application
• Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions
• Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Extensively used Oracle Hints to direct teh optimizer to choose an optimum query Execution Plan
• Extensively used Bulk Collection in PL/SQL Objects for improving teh performance
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.
• Responsible for writing Unix Shell scripts for loading data using SQL*Loader. Teh Control Files for teh tables were created and automated through UNIX shell scripts to perform data load in to Oracle tables. Used SQL Loader and PL/SQL scripts to load data into teh system application.
• Performed Data Cleansing to weed out erroneous Orders from teh DWH tables
• Extensively used Toad to develop Oracle PL/SQL Packages
• Create Procedures and Functions in SQL Server to migrate data from Legacy servers to Oracle Datawarehouse tables
• Create Informatica worflows (7.0 for Flat Roll/9.0 for Tubular implementations) for implementing business logic
• Worked on Sessions & workflows for variety of loads starting from Source to Target
• Created Parameter Files to override session properties for source directory, Bad file Directory, Source, Target & created Mapplet parameters for Mapplets
• Created Mappings using Designer, Extracted teh data from teh flat files and other RDBMS databases into staging area and loaded onto Data Warehouse
• Developed teh Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router Transformation
• Developed reusable Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union
• Create Perl & Shell scripts for automating teh business logic
• Create ABPP (Agile Business Process Platform) workflows which sequences teh execution of Oracle Packages, Informatica workflows, Perl and Shell scripts as per teh business logic
• Deploy teh code across teh environments to main code consistency and update teh same in Clear Case for version control
• Create Test Cases for verification and validation of teh Change Requests

ENVIRONMENT: Oracle PL/SQL, Oracle 11g, SQL Server 2012, Informatica, Java, ABPP, UNIX, Shell & Perl Scripting

Confidential, New Albany, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Create Use case documents for teh functional requirements for teh Change Request
• Setup Sprint calls with teh End User for Change Requests
• Weekly calls with teh Business and teh Management for maintaining Change Requests
• Daily status calls with teh end users during teh Requirement Gathering phase to mitigate risks
• Bring new projects by identifying areas of improvements during discussions with Management team and Business Users
• Get teh inventory details from teh order tables for teh CDR’s from CABS and SS7 source systems for MOU and BNC Application
• Help Developers in translating requirements during coding
• Deploy Code across all environments and upload teh code in Dimensions tool for version control
• Gather requirements from End Users and SME’s regarding teh Change Request and create High Level and Low Design documents
• Create PL/SQL Packages which contains Cursors, Exceptions, Procedures and Functions to load teh daily, weekly and monthly data into teh database table.
• Performance tune End user SQL queries using Explain plan with TKPROF and Oracle Optimizer hints
• Performance tune DML statements for fetching and loading data into teh Oracle database tables using Bulk Binds logic
• Create Range Partitions based on load date and maintain List/Range sub-partitions for different Circuit ID’s for Vendors
• Create DML Triggers for updating teh audit tables for DML activities on teh master tables
• Create Views for Master tables and Materialized views from DWH tables for End User Queries
• Load data from Flat files from Legacy Mainframe Applications using SQL Loader scripts
• Responsible for creating users, granting roles and privilege management
• Perform SQL Testing for verifying proper loading of data in teh DWH tables
• Create adhoc PL/SQL blocks for User requirements
• Resolve teh database issues of teh users whenever in need of
• Create Programmable blocks using SQL Server to migrate data from Legacy applications to Oracle
• Provide Data Integration Support by integrating data from all teh different systems using teh Lavastorm Business Rule Editor(Lavastorm BRE) and load teh data in DWH tables
• Perform Data Integration activity, Data Quality Management and Data Analysis activities using Lavastorm BRE Analytical Tool
• Create Revenue reports for end users using webFocus reporting tool
• Created POC for teh migration of Lavastorm BRE graphs to Informatica PowerCenter 9.X
• Create Unit Test cases for verification and validation for teh Change Request
• Created automation scripts in Shell & PERL Scripting
• Create comprehensive documents of teh changes made for teh end users

ENVIRONMENT: Oracle 11g, Agile, SQL, PL/SQL, SQL Server 2008, Lavastorm BRE, Informatica, UNIX & Shell Scripting

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Provide teh Project Playbooks and teh Component Release Notes (CRN’s) for new projects and Change Requests
• Provide Environments for new projects, Deliver teh components using teh Clearcase tool
• Create PL/SQL code for implementing teh application logic
• Ensuring security of teh database by creating profiles for each user and monitored teh user sessions
• Reporting and resolving all serious Oracle alert log messages
• Responsible for enhancements depends on teh client’s functionality
• Interaction with Development Team in fine tuning teh SQL and PL/SQL code
• Resolve teh database issues of teh users whenever in need of
• Created SQL scripts for static data, views, and synonyms
• Provide Performance Tuning Support to teh Client Sql queries

ENVIRONMENT: Oracle 11g, SQL, PL/SQL, UNIX & Shell Scripting

Confidential, Stamford, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

• Creating database objects and worked on implementation of teh objects.
• Created teh required PL/SQL package for teh Migration of XML data to Oracle tables
• Created stored procedures, functions, triggers and packages.
• Involved in teh end-user activities.
• Took part in teh Unit testing of teh Project
• Took part in defect fixing during teh Integration Testing Phase of teh Project

ENVIRONMENT: Oracle 11g, SQL, PL/SQL, UNIX & Shell Scripting