Project Front Office
Resume:
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)
*: ********.***@*****.***
Anshuman Panda
Lead Consultant (ITC InfoTech)
Bangalore, India
*: ********.***@*****.***
Contact this candidate