Submitted by: Submitted by vijaymalka
Views: 212
Words: 1641
Pages: 7
Category: Other Topics
Date Submitted: 10/07/2012 12:10 PM
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...