SUMMARY

• Overall EIGHT years of IT experience wif over FIVE years of programming experience in Oracle PL/SQL
• Experience in working in projects wif Agile - Scrum and Waterfall Models; involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance wif 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 wif Oracle PL/SQL Functions, Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions, Materialized Views
• Comfortable writing SOQL queries, working wif 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 wif 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 wif 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 wif business users for requirements gathering
• Experience in Onsite-Off Shore development models and daily Scrum call sessions
• Client interactions wif American, Europe/South Asian and African Customers.
• Coordinated triage meetings wif 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 wif excellent analytical, programming, written and verbal communication skills wif ability to interact wif individuals at all levels.
• Client of appreciation from All Confidential 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, Pittsburgh, PA

Responsibilities:

• Responsible for the successful migration of Order-to-Cash module dat 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 wif Business Users, fixing data issues
• Data Reconciliation checks between the Source and Target systems ensuring data integrity
• Working along wif 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 dis 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 Confidential iSeries Mainframe system, Oracle 11g, TIBCO, Salesforce Cloud ERP.

Confidential, Long Island City, NY

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 wif the data provided from client
• Worked along wif 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.

Confidential, Honolulu, USA

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 wif the data provided from client
• Worked along wif 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.

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

Responsibilities:

• Deputed to onsite at Auckland in New Confidential 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 wif 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 wif the implementation team
• Coordinated status meetings and discussions wif client
• Co-ordinated onsite-offshore teams
• Involved in the Defect analysis call for UAT environment along wif 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.

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 wif the data provided from client
• Worked along wif 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

Environment: OWB 10g, PL SQL, TOAD, VSS, UCM ClearCase.

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
• Worked during Design, Coding and Testing phases
• Developed server side code in core Java and created loading scripts using SQL & PL/SQL
• Managed Internal Releases and Deployment of releases to Testing Team
• Worked in Performance Tuning Team
• Worked along wif the client support team

Environment: OWB 10g, PL SQL, TOAD, VSS, Rational ClearCase.

Confidential,

Responsibilities:

• Worked during the initial phases from OWB tool study, Requirement Analysis, Design, Coding and Testing
• Developed ETL coding for major Facts and Dimensions
• Worked during the Migration Phase of OWB 9i to 10g.
• Managed Internal Releases and Deployment of releases to Testing Team

Environment: Oracle Warehouse Builder (OWB) 10g & 9i, PL SQL, TOAD.

Confidential,

Responsibilities:

• Developed client screens for various modules including Shared Master Screens.
• Developed Java server coding for various modules.

Environment: JAVA, J2EE, Struts, JSP, ClearCase, VSS, Eclipse, Apache Tomcat.