Muraleedhara Varrier K A ***, Tharwani Heritage Co op
Housing Society,
Plot no 24, Sector 7,Kharghar,
Navi Mumbai 410 210.
Telephone (Res.): 91-22-277*****
Mobile : 981-***-****
Email : ********@*****.***
********@*******.***
Professional Profile
Has 14 Years of Experience in IT Department of Custodial/ Depository
Segment of Financial Services Company and Shipping Company.
Specialization:
> Web Panel Development in Eagle STAR
> Message Center Development in Eagle STAR
> Data loading using PACE Uploader
> File Processing using Perl Script
> Application development using PL/SQL
> Shell Scripts using UNIX
> File processing using Perl
> Client reports using Crystal Report
> Windows Service using VB .Net 2005
Strengths:
> Exceptionally good in Coding & Testing Techniques
> Powerful analytical skill
> Quick adaptability to changing environment
> Commitment, Accountability & Ownership
> Problem solving techniques
> Skilled at handling multiple tasks simultaneously.
> Ability to work well under pressure.
> Maintaining and effectively utilizing public relation.
> Highly organized team player.
Technical Skills
Databases Oracle 10g (SQL Plus, PL/SQL)
Languages C, Proc*C, UNIX shell script, Perl Script, VB .Net
Reporting Tools Developer 2000, Crystal Report
Source control Visual Source Safe 6.0, Star Team
Operating Systems UNIX, Windows XP
Other Tools TOAD, Eagle PACE, Eagle STAR, Datamart
Professional Experience
Hexaware Technologies Ltd (India) (January 2006 - Till date)
Project Name : BBH - Eagle PACE Customization
Client : BBH Bank
Role : Project Leader (On-site -US)
Environment : Oracle 10g, Eagle PACE, Oracle SQL Developer
Duration : October 2009 to till date
Project Profile:
The client is among the leading providers of global custody, foreign
exchange, private equity, merger and acquisition services, investment
management for individuals and institutions, personal trust & estate
administration and securities brokerage. Eagle PACE Uploader is used to
upload data from various data feeds. Account, Security, Position, Trade and
Performance data used to upload to PACE data base on daily basis.
Roles and Responsibilities:
> Preparation of Specification Document based on Business Requirement
Document
> Work allocation to team and monitoring of development activities.
> Review of code developed by team members to adhere to coding standards
> Preparation of Unit test plans and Integration test plans
> Perl script creation for file processing and file transfer
> Developed Packages and Procedures in Oracle PL/SQL for Uploaders
Project Name : STP - Eagle Client Reporting
Client : P.R.P Performa
Role : Project Leader
Environment : Oracle 10g, Crystal Report, Eagle PACE and Data mart,
Oracle SQL Developer
Duration : June 2009 to September 2009
Project Profile:
Client is one of the largest independent financial services institutions.
It basically focused exclusively on fund management for captive insurance
and reinsurance companies. The current process used for generating reports
is highly manual, very time consuming and requires a great demand of human
resources. Client decided to implement its own accounting and warehouse
solution using Data mart and Eagle STAR & PACE. Client reports developed
using Eagle Data Mart and Crystal Report 11.
Roles and Responsibilities:
> Preparation of Specification Document based on Business Requirement
Document
> Mapped Data Warehouse fields with Data mart table fields and populated
Data mart
> Developed reports based on specification using Crystal Report.
> Created packages and Procedures for reports
> Preparation of Unit test plans and Integration test plans
Project Name : BBH Bank - SunGard Implementation
Client : BBH Bank
Role : Project Leader
Environment : SunGard Cache Data Base, VB .Net 2005, Microsoft Query, VB
.Net 2005
Duration : December 2009 to May 2009
Project Profile:
The client is among the leading providers of global custody, foreign
exchange, private equity, merger and acquisition services, investment
management for individuals and institutions, personal trust & estate
administration and securities brokerage.
SunGard's AddVantage is real time, browser based an asset management and
trust accounting system solution with workflow management, investment tools
and reporting capabilities. Client is replaces existing legacy system with
SunGard's AddVantage. Scope of the project is to develop a windows service
to create output files, which will be used to import/export the data from
client's existing Applications and SunGard AddVantage Application
Roles and Responsibilities:
> Preparation of Specification Document based on Business Requirement
Document
> Preparation of Unit test plans and Integration test plans
> Created a windows service to generate the expected output file in
VB.net.
> Developed a query to fetch the expected set of data from SunGard
AddVantage Application using Cache Database.
> Created the log file for each interface to record the error as well as
the status of file generation activity.
Project : Core Accounting System Solution - Eagle STAR
Customization
Client : Fidelity Investments (USA)
Role : Team Leader (Onsite - United States)
Environment : Oracle 10g, Eagle PACE/STAR, Subversion, TOAD, UNIX
Duration : July 2008 - November 2008
Project Profile:
The Core Accounting System Solution (CASS) is a multi-year project that
encompasses the replacement of the Fund Accounting Systems and their
satellite applications. Consisting of the Eagle STAR Accounting system and
the Eagle PACE data warehouse, CASS will replace over 20 applications and
over 20 databases with one solution. The benefits of the project are:
> Support of the growth in business, whether in assets, volumes or
products
> Ability to rapidly deliver new functionality to our customers
> Support of multiple customers including Pyramis, FMR Co, Strategic
Advisors and Geode
> Reduced unit costs resulting from fewer applications in the
environment
> Reduced risk through the simplification of our infrastructure
Project includes the development of following:
> Web Panel Development
> Uploader Development
> Engine File Updating
> Updating engine files for web panels
Major Contribution:
. Web Panel Development for customizing user inputs.
. Uploader development for uploading data to database.
. Updating engine files for web panels.
. Writing the functions, stored-procedures and packages in Oracle 10g.
. Developed UNIX Shell Script for File Processing.
Project : Deutsche Bank Eagle ARM implementation
Client : Deutsche Bank
Duration : January 2006 - June 2008
Environment : Oracle 9i, Eagle PACE, Visual Source Safe, TOAD, Message
Center
Role : Team Leader Onsite Coordinator for United States
Project Profile:
The Account Reference Manager (ARM) is a tool for collecting, processing
and storing client, account and portfolio information. User groups will now
have responsibility for creating, maintaining and viewing their own data,
using the application's panels. Specifically, it allows groups to do the
following:
> Requirement gathering and prototype development.
> Create new client, account and portfolio(s) information.
> Create a new account and associated new portfolio(s).
> Create a Portfolio(s), when a client changes their mandate.
> Implementation of User Access and Review Process
> Maintain client, account and portfolio information.
> Update administrative data related to client, account and portfolio
instances.
Major Contribution:
. Onsite coordination.
. Web Panel Development for customizing user inputs.
. Message center development for uploading data to database.
. Uploader Development for Data loading.
. Updating engine files for web panels.
. Writing the functions, stored-procedures and packages in Oracle 9i.
. Preparation of Test Cases for web panel development.
. Developed UNIX Shell Script for File Processing. Programming in Advanced
PL/SQL (Table Type, Objects, REF Curosr).
. Implementation of Field level user access in the Web Panels.
. Multi row processing and validation in Web Panel.
. Customization of Account Client Manager Tool.
Stock Holding Corporation of India Limited: (01st December, 2000 to 22 nd
December 2005)
Stock Holding Corporation of India Ltd. (SHCIL) is a Financial
services company promoted by seven All India Financial Institutions. SHCIL
is the country's largest Depository Participant serving more than seven
lakhs retail clients and over 40 institutional clientele including the
country's leading Mutual Funds, FII's and other Financial Services Majors.
SHCIL's IT Division having more than 200 software professionals working for
it has an acknowledge history of technical self-sufficiency. It has also
attained CMM Level 3 Certification and ISO 9001/2000 certification too. The
state-of-the-art Information Technology tools deployed by SHCIL, has
received global recognition in the form of selection as a Laureate of
Computerworld Honors Program. SHCIL has also received National IT Award
from the Computer Society of India.
Designation : Executive (IT) [Senior Programmer]
Reporting to : Manager (IT)
Duration : From 01st December, 2000 to 22 nd December 2005
Roles and Responsibilities
. Preparation of Program Specification and pseudo code
. Preparation of System Test Plan, Stress Test Plan for project.
. Trouble-shooting within and across project.
. Enforcing/Participating in Quality reviews.
. Software Configuration Control
. Quality Co coordinator for the department.
Projects
1. Accounts CDSL Module (Team Size 6) December 2002 till date)
Developing and designing of Accounts Module in order to cater to relevant
user requirements and changes in CDSL systems and general financial
requirements from time to time.
DBMS : Oracle 8i
Front End : D2K Forms
Languages : PL/SQL
OS : Unix (Aix)
2. Accounts NSDL Module (Team Size 5) December 2000 till date)
Developing new enhancements and re-designing of Accounts Module in order
to cater to relevant user requirements and changes in NSDL systems and
general financial requirements from time to time.
DBMS : Oracle 8i
Front End : Forms 3.0
Languages : PL/SQL
OS : Unix (Aix)
Designation : Junior Executive
Reporting to : Deputy Manager
Duration : February 1999 to November 2000
Roles and Responsibilities
. Coding according to Program Specifications.
. Testing as per Function Condition List and Peer Review
. Participating in Quality reviews.
. Using Software Configuration Control
Projects
1. COMS (Computer Room Operation Management System (Team Size4) (April 00
to Nov 00)
Operation Management System developed for Computer Room Operation
Department for creation and maintaining of media and its movement to
different branches inventory management and creation of reports for various
Management Information Systems.
2. Mail Delivery System (Team Size 2)(Feb 1999 to Mar 2000)
Mail Delivery System was developed for Mail Counter to keep track of
mails coming to SHCIL as well as going out of from SHCIL. The system was
designed to handle the various types inwards like shares, cheques and other
securities, generate an online report to various departments.
Shiva Shipping Services: (Two Years)
Shiva Shipping Services is a C/F Agents for various pharmaceutical
and reputed MNCs in Mumbai. Shiva Shipping Services has an IT Department
which was catering to in-house requirements.
Designation : Junior Programmer
Reporting to : Assistant Manager
Duration : Nov 1996 to Jan 1999
Projects
1. Back Office for Clearing and Forwarding Agent :
Member of the maintenance and enhancement of the Back Office System of
Clearing and Forwarding Agent Module including generation of Bill of
Lading, Document Management System and Employee Pay roll.
Personal Information
Age and Date of Birth : 39 Years, 15th May 1969.
Marital Status : Married
Gender : Male
Nationality : Indian
Passport No : A7193101
Visa : H1B (USA)
EDUCATION
Degree Name College Year Marks
PGDCA LBS Centre for Science 1996 71%
and Technology
B.Sc (Mathematics ) Govt College, 1993 48%
Kasaragod, Kerala
Courses/ Workshops Attended
Year Course/ Workshop Conducted by
2002 Designer 2000 SQL Star International
2001 Developer 2000 SQL Star International
2001 Star Team Star Team
(Configuration
Management System)
2000 Oracle 8I Concourse Information
Technology
Certifications
. Oracle Developer Certification from Brain Bench