Resume

The TOPS is responsible for establishing and maintaining various transportation programs that will result in the best service at the most cost-effective level. Transportation policy and procedures relative to all modes of transportation, networking concepts,short-and long-term mail transport equipment planning, and international and military mail operations and areas under the direction of manager transporation.

Role:

• Written stored procedures and packages on ORACLE database server

• Involved in the production support and solved critical issues.

• Loading the flat files using sql loader into ORACLE tables.

• Involved in all phases of software development life cycles

• Written SQL (DDL, DML, DCL) and database triggers

• Written SQL Queries from SQL server NASS system to TOPS Oracle System

• Written complex queries for migrating the NASS system to New TOPS System.

• Identified the mappings of source system to target TOPS system

• Tuned the SQL Queries using Explain plan and extensively used hints in Oracle Queries.

• For performance issues data is stored in partition tables

• Checked the latest code into CLEAR CASE system.

• Created indexes on tables for optimization.

• Extensively used back-end procedure, SQL Queries, standard modules, and Database Triggers.

• Used Erwin for data modeling for different databases

• Extensively worked on cursors for manipulating row-by-row for oracle database

• Created the Materialized views for the base tables of other databases in order to avoid redundancy of data

• Entered the bugs into CLEAR QUEST and resolved based on priority

• Created good transportation based on the garbage data loaded into CDI_TABLES

• Extensively worked on shell programming for automation of script loading into ORACLE TABLES

Development Environment: SQL Server, Oracle 10g PL/SQL , SQL , T-SQL,

Unix , Windows, Toad, Eclipse , Control-M. Enterprise Manager , DTS Packages

Global Billing System(GB$) –Feeds Migration British...