Lohith Babu Avadhani +** ********

Profile Summary

. A proactive and committed individual, who is highly efficient and has

excellent organizational skills, having comprehensive experience over

5 years and almost 4 years in the field of Murex and also the required

relevant academic qualification,

. Able to play a key role throughout the life cycle of a project and

thereby ensure quality solutions meet business objectives.

. Most recently was responsible for Murex reports migrations and

previous experience includes Murex Datamart configurations.

Skill Summary

Stream Murex Implementation

Complex Trading Murex 3.1,2.11

Products

Core Competencies Murex Datamart, Murex reports migration & Data

warehousing

In-house Product Murex Datamart, M-reports,DWH(SSIS,SSAS,SSRS &

Trainings BOXIR2)

Stream Murex Implementation, Migration

Complex Trading Murex 3.1,2.11

Products

Core Competencies Murex Datamart, Murex reports migration &

Data warehousing

Professional Experience

derivIT Solutions Pte.Ltd Analyst - 2 July 2013 - Present

Client: SCB, Tianjin, China

Project - 1 - MXG 2000 Report Migration & Implementation SCB

Description of the project:

Datamart reporting & Migration work from Mreports to Datamarts in

MXG2000 on existing reports in SCB.

Key Responsibilities involves, working on assigned BOW (Book of work)

which includes the below activities:

. Murex reports migration from Mreports to Datamart in MxG2000

. Datamart report development in MXG2000

Capco Technologies Pvt. Consultant -2 March 2009 to July

Ltd 2013

Client: CACIB, India, PARIS

Project - 1 - Mx3 Implementation CACIB-GDM-IMPL

Description of the project:

Project is to replace the FO and risk application in GDM business line

Replace Summit and MX v2 reports by building new MX 3.1 system

(MX3.1.28)

Responsibility:

. Reports to be created in the Murex 3.1

. To replace the existing FO and MO (Risk) application with the Murex

3.1.28 version for the CACIB GDM business line.

. To replace the summit application activities in the Murex 3.1 version

. The project is not a Murex migration but to build a new integrated

platform in Murex 3.1

. The Functional scope includes (Trade booking, Trade workflow)

. Reports to be created in the Murex 3.1

. It includes reports for different products like Bonds, Repos, IRS,

CDS, Futures, FX cash products etc.

. Reports like PnL,Cash flow, Deal deatails,Simulation,Market data

viewer has to be generated through Datamart extractions

Client: Landesbank, Berlin - Germany

Project - 2 - Mx3.1 Report Migration LBB

Description of the project:

Responsible on Murex reports migration. The task is to migrate all the

existing reports from MXG2000 to MX3.1.26 by incorporating the changes

based on Data model changes /Functional change.

Responsibility:

. The project is a Murex migration to build a integrated platform in

Murex 3.1

. Thorough analysis on both technical and functional end for existing

reports using industry DWH concepts like Bottom top approach, SCD

(Slowly changing dimensions) to find the dependencies using the Murex

provided documents such as scan book and Data model changes documents

etc.

. Amend the Data model changes to the existing report as per the suggest

Murex road map

. Compare the test results using the in house tool called Sparta(Sparta

helps in finding the mismatches, missing of records in a granular

level) and provide a report in Flat file format

. Based on the level of issues communicate to Murex on understanding the

behavior

Reports development:

. Migration of Datamart reports from MxG2000 to Mx3

. Migration of Mreports from MxG2000 to Mx3.1

. Migration of EndUser Views(Client specific)

. Migration of Mreports to Datamart

Client: Sweden Bank, Sweden, India

Project - 3 - Mx 3.1 Reporting re-architecture Project

Description of the project:

Design of the Datamart reporting architecture solution for the

existing reporting set-up in SEB.The project aims to restructure the

reporting architecture to achieve consolidation of business logic,

streamlining of data exports, storage and presentation of processed

data in accordance with industry data warehousing standards and to

provide Meta data and report catalogue structures for easy monitoring

and maintenance. It will introduce guiding principles and processes

for the maintenance of existing reports and the creation of new.

Responsibility:

. Preparation of Report Catalogue based on existing reporting design

setup

. Preparation of Data dictionary based on report analysis

. Technical optimization of reports by doing a detailed analysis for

individual reports

. Involved in new Report design and data model which will be specific

for supporting EOD/Intraday/Ad hoc reports

. Involved in preparing Reverse engineering queries for data analysis,

consolidation and creation of the various datamart objects

. Involved in creating the layer 1 reengineering report setup document

. Change management activities

. Involved in creating an XML Load tool for importing and converting all

XML files into readable format

. Involved in creating user guide for the XML Load tool

Reports development -

. Understanding and configuration of Dynamic Tables/Reporting View,

Datamart Tables & Mapping, Feeders & Batch of Feeders, Datamart

Extractions

. Migrating all M-report to Datamart reports

. Creation of Dynamic view for different products

Client: National Australian Bank, India

Project - 4 - Murex3.1 Project Everest

Description of the project:

The overriding objective of Project Everest is to implement Murex

MX.III as the global front-to-back solution for FX & Commodities,

enabling the business to transform and capture new business

opportunities.

Responsibility:

. Understanding and configuration of Dynamic Tables/Reporting View

. Datamart Tables & Mapping

. Feeders & Batch of Feeders

. Datamart Extractions & Batches of Datamart extractions

. Datamart Viewer

. Processing scripts

. Knowledge of database programming (stored procedures), SQL, Oracle

. Unit testing

. Maintain technical documentation (including issues lists, flow charts,

risk assessments, and use cases) which explains the details of the

changes made to the existing objects

Client: Deutsche Bank, London

Project -5- Pre Issuance Packs

Description of the project:

PIPs Project which is fully engaged across different streams like

Emerging Markets, Core rates, GCT (Global credit trading), GME (Global

market equity)

Responsibility:

GCT FinCon for Monthly PnL Reports:

. To prepare the Feasibility Analysis and Requirement Analysis of

reports

. To prepare the design documents for the reports

. Develop reports to assist in the timely and efficient production and

to automate the PIPs functionalities

GME FinCon for Monthly PnL Reports:

. Assist in maximizing the granularity and PIP production efficiency

. Develop functionality for facilitating more granular commentary

Client: Commerz Bank, India

Project -6- Archiving and Decommissioning

Description of the project:

Archiving and Decommissioning project involves the archiving solution

for applications which needs to be decommissioned by the Commerz Bank

Before the decommissioning of applications the data is backed up and

will be archived

The project ensures that the data which is backed up can be retrieved

on demand The archived data is stored for a specific period as defined

in the respective application reference document After archival, these

the applications will be decommissioned and will be no longer in use

Responsibility:

. Database development and Execution

Client: Central Western European Consortium, India

Project -7- CWE Market - Simulation Tool

Description of the project:

Power Exchanges of Five countries, Netherlands, Belgium, Germany,

Luxemburg and France are participating in a project that aims at

coupling the day-ahead markets of these Power Exchanges These power

exchanges require a Simulation Facility (SF) that would help them to

accommodate the various investigations and analysis to solve some

potential scenarios and help in future decisions

The Simulation facility (SF) project includes an implementation of a

Reporting tool used to create, manage reports and carry out various

statistical analyses on the results and input data this will help the

power exchanges in better managing the electricity prices and trade

volumes between the participating countries

Responsibility:

. Design and develop various Reports for statistical analysis using

historical and current data

. Converting the Business Requirements to Functional Requirement

Documents for the Software team

. Prepare the Release Notes Document indicating the dependencies, the

paths and the procedure for uploading Reports to Report Server

. To prepare the Feasibility Analysis and Requirement Analysis of

reports

. To prepare the design documents for the reports

. Design & Build simple ETL Packages

. Design & Build Cubes

. Design and Developing reports in reporting Services 2005/08

. Writing Test Plan and developing Test Cases based on the requirements

. Test data preparation using a tool developed in VB Applications as per

the customers need, execution and verification of the test results

. Involved in Test case execution using Test Link

. Preparing Review Reports based on review of Test Cases, Scenarios and

Test Data

. Involved in Black box Testing, Sanity Testing (Smoke testing),

Functional Testing, Regression Testing and UAT Testing

. Involved in executing the Test scripts through Canoo Web Test

. Reported bugs through JIRA and Defect tracking sheet

. Prepared Test Summary Report and Defect report

. Performing sanity testing, Functionality testing, Regression Testing

and GUI Testing

. Mapping all test cases using Tractability Matrix

. Knowledge/Exposure in SDLC & STLC

. Prepared Configuration management plan

. Created Branches in SVN repository for every new build using Tortoises

Education

. Bachelor of Degree (Bsc) - Computer science from Sri Krishna Devaraya

university - 2002 - 2005

. Master of computer Application from Presidency college, Bangalore

University - 2005 -2008

[pic]

Contact this candidate