Profile Summary

A result oriented IT consultant with 6+ years of industry experience in the business domain of Capital Markets, Treasury Front Office and Equity Portfolio Management.

6+ Years of IT experience in database development using SYBASE ASE and MY-SQL Database.

Around 4 Years of Experience in Kondor Plus as Technical Developer.

Experience in Database development & Migration of Sybase ASE Database.

Experience into DatawareHousing and ETL using Informatics PC.

Finastra/Misys certified Front office Kondor plus Data base developer.

3+ Years of Experience in UNIX Shell Scripting.

Experience in creating the database objects like Tables, Indexes, Views, Triggers, Cursors and Stored Procedures.

Good understanding of T-SQL and performance tuning processes.

Optimized the performance of Database procedures

Working as an individual contributor and as part of a team for various projects.

Having good knowledge of Reporting through Microstrategy.

Leading a development team for project related activities.

Knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Worked with the onsite team at the Clint location as database consultant.

Employment History

Company

Duration

Designation Held

ITC InfoTech

June 2017-Present

0.10 Years

Lead Consultant

Techno soft Corp.

Aug 2016-June 2017

0.10 Years

Sr.Software Eng.

Genpact Headstrong

Nov 2013-Aug 2016

2.9 Years

Lead Consultant

S-Edge Software

Sept 2011-Nov 2013

2.2 Years

Software Eng.

Technology Summary

Tools / Technology

Products

Operating System

UNIX, Linux, Windows

Database

Sybase,MY-SQL,DB2,Oracle 11g

Language

SQL,PL/SQL,T-SQL

Scripting Language

Shell Scripting

Tools

Informatica PC,Tibco BW,FFC-1.9/2.0,Microstrategy

Functional / Technology Skills

Area(s)

Sub-Area(s)

Domain

Kondor + Suite

K+

Capital Markets

IT Skills

DB Development

Capital Markets, Core Banking & Finance

Education

Degree

College/ University

B.tech

TAT/Biju Patnaik University of Technology, Orissa

Project Summary

Project – 1

Client

Finastra/Misys

Project

1.Kondor FO/BO/MO Database (DB)Development & Maintenance

2.Bloomberg Bonds & Counterparties Rating Interface for K+ & KTP

Employer

ITC InfoTech, Bangalore

Duration

On Going

Location

Offshore work (India), Onsite Work (Greece)

Project Description

Aim Of this project is to develop different Module for a wide range of banks in ASIA, MIDDLE EAST, EUROPE and Australia as per their request In Kondor (FO/BO).Development and maintenance of FO/BO Database for Banks Like Canara Bank, PNB, JFS, SAMBA, T-CORP etc.. As per the request.

Interface Development in K+ & KTP using FFC/MCH.The Interface will request Ratings from Bloomberg Data server for Bonds/ISINs and Counterparties/LEIs from Kondor and KTP in a specific format through SFTP.Once the corresponding response file is generated the interface will get the response automatically and process the Bonds and counterparties ratings values within the file to Kondor and KTP database.

Responsibilities

Requirement Gathering and Technical Analysis.

Responsible for the creation and modification of the database objects (Tables, Indexes, Views, Triggers and Stored Procedures). Involved in Testing and Database Performance tuning.

Created Shell Scripts for the process to be automated.

Modified existing Scripts, and optimized the developed processes.

Debugged and resolved the issues raised by the User.

Configuration for Kondor Open Report, Financial Scripts, Kustom Windows and Kustom Reports.

Automation of various Manual EOD process in Kondor.

Created Staging & History Tables for data processing.

Preparation of documents such as Scope/Approach, Technical and Release Documents.

Post UAT issue resolve and Post GO LIVE support.

Tools/Technology

Sybase 15/16,Oracle 11g, Linux, Shell Scripts, FFC/MCH

Previous Project – 2

Client

Morgan Stanley (India, USA, CANADA)

Project

1.Sybase Database Migration

2.Catalyst Calendar

Employer

Technosoft Corporation, Bangalore

Duration

0.11 Year

Location

Offshore work (India)

Project Description

Database Migration/Upgrade from Sybase 12.5 to Sybase 15.7.

Catalyst Calendar project is to explore technology solutions that can help Research Analysts improve the process by which they communicate important company, sector or economic events to Sales, Trading and clients. The Catalyst Calendar project proposes the development of new, or the procurement of off-the-shelf systems, to maintain and provide centralized access to catalyst data. This system will aim to replace and/or supplement the tools currently used to maintain calendars in Research.

Responsibilities

Modified existing Scripts, and optimized the developed processes.

Debugged and resolved the issues raised by the User.

Responsible for the creation and modification of the database objects (Tables, Indexes, Views, Triggers and Stored Procedures). Involved in Testing and Database Performance tuning.

Verification Of replication Schema between Source and Target Sybase server.

Programmed stored procedures, Unix Scripts, and optimized the developed processes.

Worked with XML processing Through Informatica to load data in to staging and then to Target Tables.

Created Source, Target, Mapping, Sessions and Workflows in Informatica.

Tools/Technology

Sybase,Linux,TCM,JIRA, Shell Script, DB2,PL/SQL,Informatica PC

Previous Project – 3

Client

Societe Generale (ASIA,EUROPE & EMIA)

Project

1.Kondor+ Upgrade and Sybase DB Migration of SGMA.

2.Kondor+ Upgrade and DB Migration and reporting for NEW-EDGE, SG, London.

3.Matrix Automation for ASIA, EUROP & EMIA.

4.Catlog Activities for SG

Employer

Genpact Headstrong, Bangalore

Duration

2.9 Year

Location

Offshore work (India), Onsite Morocco (SGMA) & London (UK)

Project Description

Aim of the Project is to Kondor version Upgrade along with Sybase migration as well as OS migration (From Sun Solaris to Red Hat Linux).Automate Various EOD,EOY processes in Kondor

Responsibilities

Working as Lead consultant and as a Developer with the team.

Designed, developed and deployed Application in Database.

Lead a small team and successfully delivered the project.

Interacted with clients to understand their requirements.

Programmed stored procedures, Unix Scripts, modified existing Scripts, and optimized the developed processes.

Debugged and resolved the issues raised by the User.

Responsible for the creation and modification of the database objects.

Involved in Unit and System Testing and Database Performance tuning.

Provide Development and Enhancement for Multiple project Request from Users in Different Region which involves projects like EMIR-DFA Regulatory Reporting, Istanbul reporting, and Catlog Activities for GHANA

Tools/Technology

Sybase, MY-SQL, UNIX, LINUX, Shell Script, 2LA KIA, TIBCO-BW

Previous Project – 4

Client

Johnson & Johnson

Project

1.DB RE_ENGINEERING (Process Development & Maintenance)

Employer

S-Edge Software

Duration

2.2 Year

Location

Offshore work (India)

Project Description

Migration and Re-Engineering of Data Base and Report Services from Sybase to MY-SQL and Oracle.

Responsibilities

Gathering Task requirements from the client.

Handling the development modules in Stored Procedures and delivering the quality code in time by standards and perform Code review and Unit Testing.

Responsible for the creation of the Database objects.

Debugged and resolved the issues raised by the testing team.

Sending Daily Exception report to clients and Involved in performance tuning.

Analysing and Writing queries and stored procedures for report generation.

Maintenance and Enhancement of already created database objects.

ETL operation development

Tools/Technology

Sybase, Informatica PC, MY-SQL

Anshuman Panda

Lead Consultant (ITC InfoTech)

*: ac6ui8@r.postjobfree.com

(: +91-974*******

Anshuman Panda

Lead Consultant (ITC InfoTech)

Bangalore, India

*: ac6ui8@r.postjobfree.com

(: +91-974*******

Contact this candidate