Preview: For the complete resume and contact info please download it.
[var] => content
[type] => preview
[var] => cut_url
Praveen S. M.
Mobile no. +
obtain a leading position in the banking & Financial Sector, that
will provide opportunities to utilize my present experience and interpersonal
skills for the growth of firm and self as well.
Chartered Bank, Singapore
– Business Analyst
Interacting with Business
Analyst to understand the business requirements;
Design Document required for future reference and maintenance of designed
and folders using Repository Manager;
with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping
Extracted Source Data
using Informatica tools and Stored procedures from Source Systems;
logic and designed various Complex Mappings using the Designer;
Designed various mappings
using transformations like LookUp, Router, Update Strategy, Filter,
Sequence Generator, Joiner, Aggregator, and Expression Transformation;
Used Mapplets, Parameters
and Variables to implement Object Orientation techniques and facilitate
the reusability of code;
Developed and executed
UNIX scripts as pre/postsession commands to schedule loads, through
Configured and ran
the Debugger from within the Mapping Designer to troubleshoot predefined
in Finetuning the Informatica Code mapping and sessions, SQL to obtain
optimal performance and throughput;
PowerCenter/ PowerMart .. & .., Oracle i/g, SQL, SQL*Plus,
TOAD, IBM AIXKsh, Sun Solaris Bsh, Windows NT
Smartstream TLM Implementation:
Understanding the user
requirement document prepared by Operations BA;
Design Document with respect to both TLM and BI;
– Tree View, Grid View etc .Parent Child Relation, Business Logic
Tools , Search Rules. Hands on with Workflow Tools, Events, EventLists,
Loading the data from
the TLM frontend via validation server and also configuring UNIX and
Oracle to pick up the data on its own STLFETCH and LOAD_TRIG oracle
Smart Schema &
Generating KB file
Services Indaia Pvt. Ltd., Mumbai
November – February
– Senior Software Engineer
Experience in User
Requirement gathering, understanding the same and implementation.
Knowledge of TLM .,
. and . also have operational knowledge of SSR
Hands on with TLM concepts
as well as implementation of Categories, Sets, Leadsets, Message Feeds,
Passes, Passlists, Initiation, Scheduling, Various segments of rules,
Workflow Tools, Dashboards, Users, Roles etc.
Well versed with UNIX
Operating system and Oracle g SQL and its usage with respect to TLM.
Knowledge of loading
the data from the TLM frontend via validation server and also configuring
UNIX and Oracle to pick up the data on its own STLFETCH and LOAD_TRIG
oracle table configuration.
Knowledge of ClearCase
Smart Schema &
Generating KB file
Training the New Comers
in project on TLM tool, Reconciliations, Capital Markets Basic Understanding
Advanced Features understanding
Like Reference Masking, Monitor Proposing, Exception Header, Counterparty
and Product Aliasing.
Have also worked on
Informatica Transformations like Lookup, Union, Expression, Filter,
December – November
Brothers Services India Pvt. Ltd., Mumbai
Design new reconciliation
builds scheduled for operation in and migration of existing
Reconciliation to TLM from old system GSSR.
To design and enhance
existing matching rules and automation of Business logic. In addition,
creation of TLM dashboards and MIS processes.
Working with key users,
sponsors, technology team to ensure efficient test execution and migration
of Reconciliations across all regions of the Firm.
Identification of bottlenecks
and casual events in upstream processes impacting STP.
To include analysis of existing feeds to isolate data deficiencies and
introduce data enrichment wherever possible.
To execute integrity
and control functions on the new Reconciliation platform TLM
in collaboration with line members of the Global Operations Control
& Reconciliation Team.
Helping user groups
understand and train them on functionality of new Reconciliation product
during the implementation phase.
Writing business scenarios
and Test cases from Business Requirement Document BRD.
Executing Test cases,
logging and tracking of Enhancements / Bugs within TLM.
Coordination of testing
& implementation of new Reconciliation on TLM.
Morgan Services India Pvt. Ltd., Mumbai
– Team Member
To take the ownership
of all the Nostro accounts opened by any Line of Business LOB
across the Firm, acquire all external as well as internal approvals
for opening and / or Closing of these accounts and monitoring of balance
movement in these accounts post opening.
To be a control point
and first contact point for out LOB’s across the firm for issues /
queries related to Nostro Accounts.
Setup of Nostro Accounts
with its corresponding internal sub account/s on Firm’s reconciliation
system SSR. In addition, doing other required system amendments
to facilitate uninterrupted feed for these accounts.
Nostro accounts which are, while remaining open, a cost as well as
exposure of the Firm to the counterparties and following up for the
closure of these accounts with LOB’s, closing them with appropriate
approvals in the books of our Nostro banks and on SSR as well.
Monitoring of various
control reports linked to SSR and heritage system DDA, i.e. GNSCTL
Report EMEA & ASIA, Suspense Reports, CB Report for Nostro
Substantiation of balances in Nostro Accounts on SSR, on the GLRS online
database, being a very critical monthly reporting had to be completed
prior to BD of the following month.
Preparation of Report
titled ‘FRT Tokyo Report’, summarizing and substantiating the balances
for the LOB’s locates in Japan, separately.
Development India Pvt. Ltd., Mumbai
– Accounts Executive
Handling accounts of
Pubs allotted to me and recording of transaction in specially designed
accounting software named ‘Sage ’ on biweekly basis.
Preparing Bank and
Cash Reconciliation Statements involving numerous transactions and multiple
parties. Reporting of such statements to our clients in UK.
of accounts of allotted Pubs after giving effects to all adjustments.
Preparation of VAT
Reconciliation Report on monthly basis and sending the same to UK Clients.
Maintenance and updation
of database of all parties dealing with out main client MSLTA in Access
Bank Limited, Mahalaxmi, Mumbai
– Executive II
Data Preparation: Preparation
of Data for reconciliation of ATM's situated all over India.
Reconciliation of ATM:
Reconciling differences arising at various locations by finding causes
Taking summarized weekly
balances and taking steps to find and reconcile difference.
Checking Mails for
relevant Details for reconciliation of ATM's
Data Preparation: Preparing
data received from Central Response Centre Team four times a day
and giving effect in online program known as Finacle so that it
is picked up on the next day for production keeping in mind the customer
MIS: Preparation of
MIS containing Daily cards processed and other productivity details
in a presentable format.
Distributors HLL & C&F Agent
– Accounts Assistant
accounts of records in Tally program.
records manually as well as in computer.
&status of stock ins and outs.
various clients on day to day basis.
Looking after cash
receipts and payments.
Preparation of bills,
handling Bank matters.
Skills categorized as Beginner, Medium, Advance Level