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 wif 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 wif 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 wif role - based security.
• Experience as a database architect and worked as data modeler.
• Experience on handling the 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 the System Development Life Cycle (SDLC)
• Expertise in working wif 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 wif 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 the heterogeneous source systems like SQL Server, Oracle, Teradata, flat files,and loading into Staging and Data Warehouse Star Schema.
• Create PL/SQL Packages which TEMPhas Procedures, Functions and Triggers
• Performance tune SQL Queries wif 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 the 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 the 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 the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Perform Integration testing to make sure the modified code doesn’t affect the the other processes
• Create Documentation for the proposed change

Confidential, Tampa, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement analysis, ETL designand developmentfor extracting data from the heterogeneous source systems like SQL Server, Oracle, Teradata, flat files,and loading into Staging and Data Warehouse Star Schema.
• Maintain and Support the creation of legal entities and corp gov related modules
• Create PL/SQL Packages which TEMPhas Procedures, Functions and Triggers.
• Used bulk collect and forall futures the retrive data fast and insert bulk operations.
• Used data compression and parllel processing techniques.
• Performance tune SQL Queries wif 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 the 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 the modified code doesn’t affect the the other processes
• Create Documentation for the 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 wif the Business team and create design documents
• Provide User Access to Business End Users to the Front end tools after getting the required approvals
• Create PL/SQL packages for implementing Change Requests for adding new functionality to the 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 wif Analytical Functions
• Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan
• Extensively used Bulk Collection in PL/SQL Objects for improving the 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. The Control Files for the 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 the system application.
• Performed Data Cleansing to weed out erroneous Orders from the 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 the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse
• Developed the 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 the business logic
• Create ABPP (Agile Business Process Platform) workflows which sequences the execution of Oracle Packages, Informatica workflows, Perl and Shell scripts as per the business logic
• Deploy the code across the environments to main code consistency and update the same in Clear Case for version control
• Create Test Cases for verification and validation of the 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 the functional requirements for the Change Request
• Setup Sprint calls wif the End User for Change Requests
• Weekly calls wif the Business and the Management for maintaining Change Requests
• Daily status calls wif the end users during the Requirement Gathering phase to mitigate risks
• Bring new projects by identifying areas of improvements during discussions wif Management team and Business Users
• Get the inventory details from the order tables for the 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 the code in Dimensions tool for version control
• Gather requirements from End Users and SME’s regarding the Change Request and create High Level and Low Design documents
• Create PL/SQL Packages which contains Cursors, Exceptions, Procedures and Functions to load the daily, weekly and monthly data into the database table.
• Performance tune End user SQL queries using Explain plan wif TKPROF and Oracle Optimizer hints
• Performance tune DML statements for fetching and loading data into the 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 the audit tables for DML activities on the 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 the DWH tables
• Create adhoc PL/SQL blocks for User requirements
• Resolve the database issues of the 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 the different systems using the Lavastorm Business Rule Editor(Lavastorm BRE) and load the 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 the migration of Lavastorm BRE graphs to Informatica PowerCenter 9.X
• Create Unit Test cases for verification and validation for the Change Request
• Created automation scripts in Shell & PERL Scripting
• Create comprehensive documents of the changes made for the 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 the Project Playbooks and the Component Release Notes (CRN’s) for new projects and Change Requests
• Provide Environments for new projects, Deliver the components using the Clearcase tool
• Create PL/SQL code for implementing the application logic
• Ensuring security of the database by creating profiles for each user and monitored the user sessions
• Reporting and resolving all serious Oracle alert log messages
• Responsible for enhancements depends on the client’s functionality
• Interaction wif Development Team in fine tuning the SQL and PL/SQL code
• Resolve the database issues of the users whenever in need of
• Created SQL scripts for static data, views, and synonyms
• Provide Performance Tuning Support to the 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 the objects.
• Created the required PL/SQL package for the Migration of XML data to Oracle tables
• Created stored procedures, functions, triggers and packages.
• Involved in the end-user activities.
• Took part in the Unit testing of the Project
• Took part in defect fixing during the Integration Testing Phase of the Project

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