PROJECT: ONLINE MERCHANT SYSTEMS Feb’06 – Sep 2009

Description:

OMS is developed for JAPA and LAC Regions of all markets like ARG, MEX, and AUS etc. It maintains the Payments, Disputes and Account information of a Merchant and to track the count of new disputes, About to Expire and Expired Disputes by using their AMEX Logon ids. And able to view the list of all disputes by corresponding case number, card number and disputed amount. It also shows the how much time available for the corresponding dispute case.

Merchant can be able to see the list of all types of disputes as a location wise like single or multi location wise. And also it gives the Detail description of each dispute like reason for dispute with corresponding reason code of that corresponding card number. And it also shows the list of chargeback’s as per the location wise.

Responsibilities:

Ø Identifying the information needs within and across functional areas of an organization.

Ø Modelingthe process in the enterprise wide scenario.

Ø Identify the integration points between functional areas in an enterprise wide model.

Ø Identifying benefits of cross-functional integration in an enterprise-wide system.

Ø Worked on optimizing existing PL/SQL packages, procedures, functions and views to suit business needs. Used parametric cursors and ref cursors for performing DML operations involving multiple records.

Ø Managed database optimization and table-space fragmentation.

Ø Tuned the performance of queries by working intensively over indexes.

Ø Used the dynamic SQL to perform some pre and post session task required while performing Extraction, transformation and loading.

Ø Used PL/SQL tables and records in transaction processing.

Ø Created shell scripts to execute PL/SQL procedures and packages.

Ø Created different source definitions to extract data from flat files and relational tables for Data mart.

Ø Created different target definitions.

Ø Created, modified, deployed, optimized, and maintained Cubes using Cognos.

Ø Designing the ETL process using Informatica in order to populate the Data Mart using the flat files to Oracle database.

Ø Writing Unix shell scripts to automate the processes Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.

Ø Created complex mappings in order to populate the data in the target with the required information.

Ø Created workflows and sessions in order to perform the required transformation.

Environment:

Windows Server 2003, Oracle 11g,XML , Repository Manager, Workflow Manager, TOAD,JAVA.