SUMMARY

• 12 years of experience as Oracle PL/SQL Developer in Oracle 12c, 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Production Support Projects
• Technical areas of experience related to PL/SQL, Informatica, UNIX & Shell Scripting
• Experienced in complete life cycle Implementation of PL/SQL Development
• Experienced in working in OLAP and OLTP Database environments
• 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 XML files and Data Migration
• Experience in working wif XML Type datatype and XMLType Operators
• Experienced in working wif high availability and scalability databases
• 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
• 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 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

Sr. Oracle PL/SQL Developer

Responsibilities:

• Design and Implement teh interaction of data between teh Paperless Office System(POS) and Welfare Management System (WMS) in updating teh case information for people who qualify for Welfare schemes
• Create PL/SQL Packages for implementing teh POS Business logic to update case information across different systems
• Extensively used XML datatypes to read, parse and store data in XML formats
• Extensively used SQL Loaders to load data across different databases
• Created Dynamic SQL’s, Oracle TYPE data types, worked wif different types of indexes and partitions
• Generate ad-hoc auditing reports to Business team

ENVIRONMENT: Oracle 12C, Toad, SQL Developer, TFS, Visual Studio 2012

Confidential, Albany, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Familiar wif teh IAIABC Standards wif NYS Work compensation insurance
• Maintain and Support teh creation of Claims wif teh NYS Worker’s Compensation Insurance
• Create PL/SQL Packages which TEMPhas Procedures, Functions and Triggers which does teh Data Validations as per WCB and IAIABC standards
• Performance tune SQL Queries wif Explain plan to modify all full table scan paths for faster query execution
• Used Oracle Object Types, Analytical functions, Collections, UTL File Package, Dynamic SQL concepts, REF CURSOR, Materialized Views in Oracle PL/SQL Development
• Create XMLType datatype and used XMLType Operators to store and retrieve data from XML files
• Used SQL Loader to move data from Flat files to Oracle Databased tables
• Created Indexes to improve teh Explain plan and teh execution of teh SQL Queries
• Used Extenal Tables, Global Temporary tables concepts
• Perform Unit Testing to validate teh code which was modified as a part of requirement change
• Perform Integration testing to make sure teh modified code doesn’t effect teh other processes
• Create Documentation for teh proposed change

ENVIRONMENT: Oracle PL/SQL, Oracle 11g, .NET, Insurance Domain, PL/SQL Developer

Confidential, Pittsburgh, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Estimate, plan, execute and monitor Projects
• Gather requirements for change requests wif 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 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 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

Sr. Oracle PL/SQL Developer

Responsibilities:

• Create Use case documents for teh functional requirements for teh Change Request
• Setup Sprint calls wif teh End User for Change Requests
• Weekly calls wif teh Business and teh Management for maintaining Change Requests
• Daily status calls wif teh end users during teh Requirement Gathering phase to mitigate risks
• Bring new projects by identifying areas of improvements during discussions wif Management team and Business Users
• Get teh trunk inventory details from teh Trunk 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 wif 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 wif 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

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 training 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

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created data flow diagrams and Pseudo codes for teh proposed data migration plan
• Took part in teh Analysis and Design phase of teh Project and created teh Source to Target Matrix document
• Analyzed teh existing Legacy code and proposed changes for teh data migration
• Created Informatica workflows for data migration and integration from Wyeth Compound and Structure Information database to Pfizer database
• Involved in importing Src/Tgt from respective DB and created mappings, and reusable transformations using Informatica PowerCenter tool
• Involved in teh Unit testing to check teh data consistency
• Performance tuning TEMPhas been done to increase teh through put for both mapping and session level and SQL Queries Optimization
• Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator were mainly used
• Created Oracle PL/SQL packages to implement teh data migration from Pfizer to Wyeth system
• Performed extensive data profiling to cleanse teh unfit data from teh migration process
• Created and performed Unit test scripts in teh Staging environment

ENVIRONMENT: Oracle 10g, SQL, PL/SQL, Informatica 8.5, UNIX & Shell Scripting

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Procedures and Packages to validate Business Rules
• Developed queries for data analysis for teh above mentioned applications
• Maintained Oracle 9i databases for teh above mentioned applications
• Implement EDI setups in Gentran Translation Server and web Methods XML gateway
• Proactively monitor teh data flow for all teh applications to make sure everything is running smoothly
• Monitor all teh health-check alerts and teh connectors for connectivity issues
• Identify and resolve EDI translation errors using teh EDI maps
• Worked wif Technology Partners in developing and implementing AS2 certificate for teh Cyclone and web Methods gateways
• Worked in conjunction wif geographically separate teams all over teh world

ENVIRONMENT: Oracle 9i, SQL, PL/SQL, EDI, WebMethods, XML, Gentran, UNIX & Shell Scripting