PROFESSIONAL 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, Informatica, 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 XML files and Data Migration
• Experience in working with XML Type datatype and XML Type Operators
• Experienced in working with high availability and scalability databases
• 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
• 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 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, Tampa, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like SQL Server, Oracle, Teradata, flat files, and loading into Staging and Data Warehouse Star Schema.
• Familiar with the IAIABC Standards with NYS Work compensation insurance
• Maintain and Support the creation of legal entities and corp gov related modules
• Create PL/SQL Packages which has Procedures, Functions and Triggers which does the Validations as per WCB and IAIABC standards
• 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
• Create XMLType datatype and used XMLType Operators to store and retrieve data from XML files
• Perform Unit Testing to validate the code which was modified as a part of requirement change
• 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,

Confidential, Hartford, CT

Sr. Oracle PL/SQL Developer

Responsibilities:

• Estimate, plan, execute and monitor Projects
• Gather requirements for change requests with 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 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 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 with the End User for Change Requests
• Weekly calls with the Business and the Management for maintaining Change Requests
• Daily status calls with the end users during the Requirement Gathering phase to mitigate risks
• Bring new projects by identifying areas of improvements during discussions with 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 with 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 with 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 training 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