SUMMARY

• Overall 8 years of IT experience with 7 years of programming experience in Oracle PL/SQL
• Experience in working in projects with Agile-Scrum and Waterfall Models involved in all phases of SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in Retail, Airline Cargo , Logistics/Transportation domains
• Experienced working on Salesforce Cloud web application
• Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL PLUS, TOAD, SQL Developer and Oracle MERGE statements, External Tables.
• Experienced working with Oracle PL/SQL Functions, Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions, Materialized Views
• Experienced creating ERDs and Data Models using MS-Visio, Toad for Data Analysts for Database Design
• Comfortable writing SOQL queries, working with Salesforce objects, Force Workbench, IDE and Data Loader
• Driving Enterprise Data Hub Testing for Enterprise Datawarehouse running batch jobs on daily basis, monitoring job status, analysing and reporting issues.
• Experience with Informatica in designing Mappings, Workflows, Worklets, Configuring Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.x/8.x
• Extensively worked with different Data sources ranging from BPCS Mainframe systems, Oracle, Flat files
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in generating AWR reports of production schemas to identify performance bottlenecks
• Analyzed and fixed the performance bottlenecks by executing Explain Plans, TKPROF and Performance Query Tuning,
• Experienced in using JDK for Java Server side programming, Oracle PL/SQL procedures
• Experience in UNIX shell scripting
• Experience in providing database administrator services in Oracle 9i 10g development environments.
• Co-ordinated daily and weekly meetings with business users for requirements gathering
• Day-to-day development DBA tasks involving Database Installation, creating users, tables, indexes, views and other objects, assigning roles and privileges setting up QA environment, taking periodic backups of development and testing schemas using oracle 10g data pump utility exports and imports.
• Experience in Onsite-Off Shore development models and daily Scrum call sessions
• Client interactions with American, Europe/South Asian and African Customers.
• Coordinated triage meetings with development, testing and production support teams for issue resolution in production
• Worked as Single point of service delivery for customer on Data Migration and Data purging solutions.
• Team player with excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.
• Client Certificate of appreciation from All Nippon Airlines for implementation and post implementation support

SKILL SET

WORK EXPERIENCE

Confidential

Role : Oracle PL/SQL Developer

Software : BPCS IBM iSeries Mainframe system, Oracle 11g, TIBCO, Salesforce Cloud ERP

Responsibilities:

• Involved in Data Analysis, Sprint user story sessions for Data Migration
• Responsible for the successful migration of Order-to-Cash module that covers the Sales Order generation to Customer Payment process.
• Involved in Design, creating Logical Data Models
• Involved in Designing the migration process from BPCS Mainframe system to Salesforce Cloud ERP application
• Development of PLSQL Loading programs for Migration using Oracle MERGE statements
• Data Validations and testing with Business Users, fixing data issues
• Data Reconciliation checks between the Source and Target systems ensuring data integrity
• Working along with the TIBCO Integration team, responsible for the Data side
• Driving Enterprise Data Hub Testing --- running scheduled batch jobs to test the data load from Salesforce Cloud ERP to EDH. Monitor the jobs, test the job status, data reconciliation and reporting This forms the source for Enterprise Data Warehouse and other internal ERP applications
• Day-to-day development DBA tasks involving creating users, assigning roles and privileges, setting up QA environment
• Taking periodic backups of development and testing schemas using oracle 10g data pump utility
• Responsible for weekly Salesforce version upgrades and refreshing Staging schemas using Perl scripts
• Designed process and solution for refreshing Staging schemas using Perl scripts
• Preparation of daily and weekly status reports
• Configuration Controller for database scripts and procedures using CVS

Confidential

Role : Oracle PL/SQL Developer, ETL Developer, Development DBA, Configuration Controller for database scripts

Software : Oracle 11g, SQL, PL SQL, Toad, VSS, UCM ClearCase

Responsibilities:

• Involved in Requirements Analysis for Data Migration
• Design the migration process flow
• Involved in Design, creating Logical Data Models
• Development of PLSQL Loading programs for Migration
• Migrate data to the production database
• Analysis of CR's
• Day-to-day development DBA tasks involving creating users, tables, indexes, views and other objects, assigning roles and privileges setting up QA environment
• Taking periodic backups of development and testing schemas using oracle 10g data pump utility exports and imports
• Performed SQL and PL/SQL tuning , analysing queries using EXPLAIN PLAN, SQL TRACE, TKPROF
• Fine-tuned procedures and optimized SQL queries for maximum efficiency using Oracle Hints
• Application setup ,Test the application with the data provided from client
• Worked along with the production support team
• Analysis of Issues in Production Runs and Implementing Production Fixes
• Prepared scripts for entity wise data purging based on business rules defining purging criteria of each entity defining retention period, analysing dependencies on other entities
• Preparation of daily and weekly status reports
• Designed process and solution for database maintenance scripts and procedures
• Worked as Configuration Controller for database scripts and procedures using Clearcase

Confidential

Role : Oracle PL/SQL Developer, ETL Developer, Development DBA, Configuration Controller for Database scripts

Software : Oracle 11g, SQL, PL SQL, Toad, VSS, UCM ClearCase

Responsibilities:

• Involved in Requirements Analysis for Data Migration
• Design the migration process flow
• Involved in Design, creating Logical Data Models
• Development of PLSQL Loading programs for Migration
• Migrate data to the production database
• Analysis of CR's
• Day-to-day development DBA tasks involving creating users, tables, indexes, views and other objects, assigning roles and privileges setting up QA environment
• taking periodic backups of development and testing schemas using oracle 10g data pump utility,
• Performed SQL and PL/SQL tuning , analysing queries using EXPLAIN PLAN, SQL TRACE, TKPROF
• Fine-tuned procedures and optimized SQL queries for maximum efficiency using Oracle Hints
• Application setup ,Test the application with the data provided from client
• Worked along with the production support team
• Analysis of Issues in Production Runs and Implementing Production Fixes
• Prepared scripts for entity wise data purging based on business rules defining purging criteria of each entity defining retention period, analysing dependencies on other entities
• Preparation of daily and weekly status reports
• Designed process and solution for database maintenance scripts and procedures
• Worked as Configuration Controller for database scripts and procedures using Clearcase

Confidential

Role : PL/SQL Developer, Development DBA, Configuration Controller for Database scripts

Software : Oracle 10g, SQL, PL/SQL, Toad, VSS, UCM ClearCase

Responsibilities:

• Done Team Management ,Team Tracking, Estimation and Project Plan preparation for Data Migration
• Single point of contact for onsite team and client for Data Migration
• Co-ordinated daily and weekly calls with clients and onsite team
• Design the migration process flow
• Development of PLSQL Loading programs for Migration
• Involved in Design, creating Logical Data Models
• Migrate data to the production database
• Involved in Unit testing, functional testing of iCargo Modules for Qantas
• Done System and Integration Testing
• Done User Acceptance testing along with client team
• Reviewing the code and Scenarios written by junior Team members.
• Managed internal Releases and Deployment of releases to Testing Team
• Has done Configuration Control and Defect Prevention activities
• Co-ordinated triage meetings with production support team
• Designed process and solution for database maintenance scripts and procedures
• Worked as Configuration Controller for database scripts and procedures using Clearcase
• Analysis of Issues in Production Runs and Implementing Production Fixes
• Provided offshore support on issues and new requirements
• End-to-end testing of the designed flows
• Preparation of daily and weekly status reports
• Generated daily/weekly AWR reports to identify the poorly performing queries
• Worked on Oracle external tables to load data from flat files obtained from various facilities every day.
• Day-to-day development DBA tasks involving creating users, tables, indexes, views and other objects, assigning roles and privileges setting up QA environment
• Performed SQL and PL/SQL tuning , analysing queries using EXPLAIN PLAN, SQL TRACE, TKPROF
• Fine-tuned procedures and optimized SQL queries for maximum efficiency using Oracle Hints
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Confidential

Role : Oracle PL/SQL and ETL Developer

Software : Informatica, PL/SQL, SQL, Sql Developer, Toad, SVN, UCM Clear Case

Responsibilities:

• Deputed to onsite at Auckland in New Zealand for Requirements Analysis and migration support phases
• Design the migration process flow
• Development of PLSQL Loading programs for Migration
• Migrate data to the production database
• Has done Dimension Modeling based on the client requirements
• Designed Facts and Dimensions for ETL coding
• Implemented extraction/transformation/load ETL interfaces
• Performed data profiling and data cleansing in order to remove data inconsistencies
• Developed Informatica mappings, sessions, workflows for transforming and loading data into Staging.
• Hands on experience with most of the transformations Source Qualifier, Filter, Router, Rank, Sorter, Update Strategy, Union, Expression, Aggregator, Sequence Generator, Joiner , Lookup connected/Unconnected , Normalizer .
• Preparing Unit Test Cases and validating Test Results
• Implemented Full and Incremental loading of mappings using Mapping Variables and Parameter Files.
• Prepared unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment
• Analysis of CR's
• Involved in the continuous enhancements and fixing of production problems.
• Managed internal Releases and Deployment of releases to Testing Team
• Has done Configuration Control and Defect Prevention activities
• Conducted review meetings and discussions with the implementation team
• Coordinated status meetings and discussions with client
• Co-ordinated onsite-offshore teams
• Involved in the Defect analysis call for UAT environment along with users to understand the data and to make any modifications if suggested by the user

Confidential

Role : Oracle PL/SQL Developer, ETL Developer, Development DBA, Configuration Controller for Database scripts

Software : OWB 10g, PL SQL, Toad, VSS, UCM ClearCase

Responsibilities:

• Involved in Requirements Analysis for Data Migration
• Design the migration process flow
• Development of PLSQL Loading programs for Migration
• Migrate data to the production database
• Analysis of CR's
• Day-to-day development DBA tasks involving creating users, assigning roles and privileges, setting up QA environment
• Taking periodic backups of development and testing schemas using oracle 10g data pump utility
• Application setup ,Test the application with the data provided from client
• Worked along with the production support team
• Unit Testing and Integration of Informatica components
• Analysis of Issues in Production Runs and Implementing Production Fixes
• Prepared scripts for entity wise data purging based on business rules defining purging criteria of each entity defining retention period, analysing dependencies on other entities
• Preparation of daily and weekly status reports
• Designed process and solution for database maintenance scripts and procedures
• Worked as Configuration Controller for database scripts and procedures using Clearcase