SUMMARY OF QUALIFICATIONS

• Overall EIGHT years of IT experience with over FIVE 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 Sales force 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
• Comfortable writing SOQL queries, working with Sales force objects, Force Workbench, IDE and Data Loader
• Driving Enterprise Data Hub Testing for Enterprise Data warehouse running batch jobs on daily basis, monitoring job status, analyzing and reporting issues.
• Experience with Informatica in designing Mappings, Workflows, Work lets, 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 Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in UNIX shell scripting
• Experience in providing database administrator services in Oracle 9i 10g development environments.
• 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,
• Generated periodic AWR reports of production schemas to identify performance bottlenecks
• Analyzed and fixed the performance bottlenecks by executing Explain Plans and Performance Query Tuning,
• Co-ordinated daily and weekly meetings with business users for requirements gathering
• 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.
• Experienced in Java Server side programming.
• 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

TECHNICAL SKILLS

ERP Software: Sales force Cloud ERP, BPCS.

ETL Tools: Informatica Powercenter 9.x/8.x, OWB.

Languages: SQL, PL/SQL, SOQL, Core Java JDK 1.5 , XML, HTML.

Operating Systems: UNIX, Windows.

Data Modeling Tools: MS Visio, TOAD, SQL Developer.

Databases: Oracle 11g/10g/9i/8i, BPCS Mainframe database system.

Configuration Management: MS SharePoint, CVS, Clearcase, SVN, VSS.

IDE: Eclipse.

Defect tracking tools: JIRA, Bugzilla, Rational ClearQuest.

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for the successful migration of Order-to-Cash module that covers the Sales Order generation to
• Customer Payment process.
• Involved in Data Analysis, Sprint user story sessions for Data Migration
• 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 Kenandy Package upgrades and refreshing Staging schemas
• Designed process and solution for refreshing Staging schemas
• Preparation of daily and weekly status reports
• Configuration Controller for database scripts and procedures using CVS

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

Confidential

Oracle PL/SQL Developer, ETL Developer

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, analyzing 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

Environment: Oracle 11g, SQL, PL SQL, TOAD, VSS, UCM ClearCase.

Hawaiian Airlines, Honolulu, USA Jan 11 Aug 11

Oracle PL/SQL Developer

Confidential

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

Environment: Oracle 11g, SQL, PL SQL, TOAD, VSS, UCM ClearCase.

PL/SQL Developer

Confidential

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
• 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, assigning roles and privileges, setting up QA environment
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• 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.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, VSS, UCM Clear Case.

Confidential

ETL Developer

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

Environment: Informatica, PL/SQL, SQL, SQL Developer, TOAD, SVN, UCM Clear Case.