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
• 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
• 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 PROFILER, DBMS STATS etc
• Experienced in importing data from SQL Server and Flat files 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, MS-Access, SQL Server, MongoDB

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

Languages: SQL, PL/SQL, HTML, XML

Scripting: Cron scheduling, Vi Editor, Shell, Perl Scripting

ETL Tools: Informatica 7.0/8.5/9.0

Analytical Tools: Lavastorm BRE

Reporting Tools: webFocus

Version Control Tools: IBM Rational Clear Case, Dimensions

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

SCM Tools: I2/JDA SCM Tool

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Oracle 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 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, Informatica, ABPP, UNIX, Shell & Perl Scripting

Confidential, Monroe, LA

Sr. Oracle 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
• 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
• 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, Lavastorm BRE, Informatica, UNIX & Shell Scripting

Confidential

Oracle Developer/DBA

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

Senior Software Engineer

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

Confidential

Senior Software Engineer

Responsibilities:

• Created data flow diagrams and Pseudo codes for the proposed data migration plan
• Took part in the Analysis and Design phase of the Project and created the Source to Target Matrix document
• Analyzed the existing Legacy code and proposed changes for the 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 the Unit testing to check the data consistency
• Performance tuning has been done to increase the 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 the data migration from Pfizer to Wyeth system
• Performed extensive data profiling to cleanse the unfit data from the migration process
• Created and performed Unit test scripts in the Staging environment

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

Confidential

Senior Software Engineer

Responsibilities:

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

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