Manager Project

Location:

Irving, TX, 75063

Posted:

April 02, 2010

Contact this candidate

Resume:

Gurudas Pradhan

469-***-****(Work)

Professional Summary

Gurudas Pradhan has around 10 years of experience in IT of which 6+ years in IBM Cognos 8.x /

ReportNet, Cognos 7.x Series(Cognos Power Play & Transformer 7.4 on IBM AIX), Metadata

modeling tool( Frame Work Manager) . Has 7 plus years of domain expertise in Banking & Finance, Data

warehousing & Business intelligence concepts, Healthcare and Life Science. Has involved in

Requirement Analysis, Design, Feasibility Study, FRD Preparation, Development, Maintenance,

Testing and Production Support. Has a certified PMP professional, with proven Project Management

and execution capabilities following the Six Sigma methodology. Expert level skills in various

versions of Cognos and have an extensive knowledge in Software Development Life cycle, Quality

Process and Six Sigma.

Worked extensively in C, C++, IBM Cognos 8.x / ReportNet, Cognos 7.x Series(Cognos Power Play &

Transformer 7.4 on IBM AIX), Metadata modeling tool( Frame Work Manager) IBM TIVOLI 8.3

(Maestro Scheduler), Shell Scripts and Txn Scripts languages and well versed with RDBMS like Oracle

(8i, 9.2, 10g), Sybase (12), DB2UDB (8.2) concepts. He is strong in developing tools and system applications

using C, C++ and Shell Scripts. As an accomplished Business Intelligence Analyst, he has worked extensively

in IBM Cognos 8.x / ReportNet, Cognos 7.x Series (Cognos Power Play & Transformer 7.4 on IBM

AIX). He has worked on Windows NT, 95,98,2000, Sun Solaris (8), HP UX (9.04, 10.20, and 11.0), Digital

UNIX 2000(5.0D) (Thru64) UNIX, IBM AIX (5.2, 5.3) and Linux platforms. He is strong in managing Tivoli

(IBM TIVOLI 8.3) Workload Scheduler from a web browser by Creating and modifying scheduling objects in

the TWS database: Jobs, jobstreams, workstations, workstation classes, domains, calendars, resources,

prompts, parameters, and user definitions. He is conversant with the Software Development Life Cycle

Process, ISO 9001 and CMM LEVEL 5 quality procedures, while executing his projects. He has good

knowledge of Finance and Banking, Treasury, Datawarehousing, Business intelligence concepts and

Healthcare Applications.

Certifications

A PMP Certified Professional

IBM Certified Designer for Cognos8 BI Reports

Education

Degree University Year of Passing

M.C.A University of Lucknow (06/1997)

B.Sc(Chem.) Utkal University (07/1992)

Experience

Organization Designation Duration

Mahindra Satyam Computer Services Senior Systems Analyst 06/2003 – Till date

Limited, Hyderabad

Scope International Limited (A Wholly Product Analyst 08/2002 – 06/2003

owned Subsidiary of Standard

Chartered Bank, U.K), Chennai

MphasiS BFL Software Limited, Associate Systems Engineer 05/2000 – 08/2002

Bangalore (An HP Company)

Technical Skills

HARDWARE PCXTs/ATs (386, 486, Pentium), HP E Class Server, HP NET Server LC Series, DEC

UNIX Alpha Server, Sun Sparc (E 250), IBM AIX 5.2, IBM AIX 5.3

OPERATING SYSTEMS MS DOS (6.2), MS Windows (95, 98, 2000), HP UX (9.04, 10.20, 11.0), Digital Unix

2000 (5.0D) (Thru 64), Windows NT (4.0), Windows XP, Sun Solaris (8), IBM AIX 5.2,

IBM AIX 5.3, Linux.

C++, C, TxnScript, JAVA, XML, Shell Scripts, Perl Scripts.

LANGUAGES

COMPILERS GNU Compilers (gcc 3.3.2, g IBM Visual age compiler (xlc_r7, xlC_r7), Forte in

Solaris 8, Rogue Wave Libraries Makefile and ANT Scripts.

DATABASES CA OPENINGRESS (1.2), ORACLE8I, ORACLE9.2, ORACLE10g, SYBASE 12,

DB2UDB 8.2

APPLICATION SERVERS WebSphere Application Server 5.1, WebSphere Portal Server 5.1 and IBM HTTP

Server 2.0.47, Directory Server: LDAP (Sunone 4.5)

HTML, DHTML, XML

WEB RELATED

GUI SQL ADVANTAGE, Oracle SQL Developer 1.5.4

IBM COGNOS8.x, Cognos ReportNet MR2, Report Studio, Query Studio, Analysis

BI TOOL

Studio, Cognos Power Play & Transformer 7.4, Frame Work manager, Access

Manager, Content Management Administration

UML, MS VISIO

CASE TOOLS

TOOLS & UTILITIES Citrix Client, Rational Rose, Actuate e. Report Designer Tools, Make File, C++

Standard Template Libraries, Xercesc C++ XML Parser for AIX 5.2, GDB Debugger,

XML Spy, Remedy, Bugzilla, IBM TIVOLI 8.3 (Maestro Scheduler), ETL TOOL

ABINITIO

VERSION CONTROL TOOLS CVS, RCS, SCCS, VSS, IBM Rational ClearCase

Finance, Banking, Treasury Management, Healthcare &Life Science, DataWarehousing

DOMAIN KNOWLEDGE

and Business intelligence

Trainings

Sl# Title Location Organized by Duration

1 Actuate e. Report Designer Tools MphasiS BFL Software Ltd. (An EDS 2 Weeks

Bangalore Company)

2 JAVA Bangalore MphasiS BFL Software Ltd. (An EDS 2 Weeks

Company)

3 QMS Training for PL and PM Hyderabad Mahindra Satyam Computer Services 1 Day

Limited

4. XML and XSL Training Hyderabad Mahindra Satyam Computer Services 2 Days

Limited

Project Name: Citi – CBG

Client: Citigroup, Irving, Texas, USA

Role: BI Tech Lead

Environment: IBM Cognos 8.2 server with 6 CPU 18GB RAM, SunONE LDAP Server 5.2, Cognos ReportNet

MR2 server with 4 CPU 12GB RAM, Powerplay Transformer 7.4, Frame Work Manager, Report Studio,

Analysis Studio, IBM AIX 5.2, IBM AIX 5.3, Shell Scripts, IBM – Tivoli 8.3 (Maestro Scheduler), Oracle10g,

Oracle SQL Developer 1.5.4, WebSphere Application Server 5.1, VSS, CVS, Rational ClearCase

Organization: Mahindra Satyam Computer Services Limited

Duration : (March’2004 – Till Date )

Project Description:

The primary objective of the project is the development and deployment of a central data warehouse across

the entire commercial business group to improve and in some areas initiate MIS reporting processes. The

existing MIS reporting processes are fragmented, incomplete or non – existent, lack reliability and do not

provide a common view across businesses. This is due largely to the fact that the business has undergone

many transitions including multiple acquisitions resulting in a significant number of disparate source systems,

business definitions and MIS processes. The integration and standardization of this data is critical to building

MIS processes that are comprehensive, standardized and reliable.

• The MIS reporting processes (both automated and manual) for all businesses and functions in the

Commercial Business Group will be reengineered to function with the data warehouse.

• The systems for sourcing data will be impacted, as they will be needed to feed data to the data

warehouse.

• The reconciliation processes will need to be enhanced or initiated to ensure reconcilement between

MIS reporting and the source systems as well as the downstream systems (the financial statements,

risk management, etc.)

• The initiation and standardization of assigning customer identifiers will likely involve the leveraging

existing processes and systems.

Commercial Business Group (CBG) is the one of the major Line of Business for the CitiGroup.

CBG initialized the consolidation of the Business Intelligence needs and focused to build the

centrilized Business Intelligence Solutions for “Customer Profitability and Performanace

Metrics” and “Customer HUB”.

The following suites of BI reports release are the part of Citi – CBG Project.

CBG Customer Profitability – Banking Integration (Nov’2008 – Till Date)

Environment: IBM Cognos 8.x, Frame Work Manager, Report Studio, Cognos Access Manager, Content

Management Administration, Oracle SQL Developer 1.5.4, Oracle 10g, AIX – 5.3, IBM – Tivoli 8.3 (Maestro

Scheduler)

Team Size: 10,

Role: BI Tech Lead

Description:

The project specifically covers Banking Integration comprising of the following work:

1. Incorporate all commercial accounts into the CPDW (Customer Profitability Data Warehouse).

Non CBG Commercial contracts received currently but excluded from the Customer Profitability Data

Warehouse (notably Business Banking) are to be included. Attribute Revenue, Expense, Cost of

Credit, Cost of Fund to businesses banking contracts.

2. Inclusion of Division information from segmentation feed.

Division level Segmentation information directly from PNT Source System.

3. The Line of Business (LOB) Hierarchy will be modified.

A new level named as entity would be added which will be the ultimate parent and still the hierarchy

would be a four level since the LOB GROUP is ignored from the hierarchy.

Processes using pre calculated/stored aggregates would be reviewed.

4. Annual CoB Test for CBGDWH Group

CoB* Environment Setup and Testing

• Mirror Production Server Installation and Configuration of Cognos8 environment in the COB Server

• Prepared COB Execution Plan for DWH/BI Group

• Successfully executed and Tested the CoB for DWH Group

• Test the Cognos Server DWH/BI applications during the COB Test

• Coordinate with external group like DB OPS Group, UNIX SYS Admin Group and Site Minder Group, Entitle

and Security Group

CoB – Continuity of Business Environment

CBG Customer Profitability – Restatement (Dec’2007 – Oct’2008)

Environment: IBM Cognos 8.x, Frame Work Manager, Report Studio, Powerplay Transformer 7.4, Analysis

Studio, Cognos Access Manager, Content Management Administration, Oracle SQL Developer 1.5.4, Oracle

10g, AIX – 5.3, IBM – Tivoli 8.3 (Maestro Scheduler)

Team Size: 10

Role: BI Senior Developer

Description:

There are situations that arise within the Banking Group (and presumably in all CBG divisions) wherein a prior

month’s Customer Profitability must be restated. Examples include:

The funding rates used in our CoF calculation are “flash rates” (i.e. preliminary rates). Sometimes the

final rate is significantly different than the flash rate.

Contracts are reclassified according to new NACMD product groupings, and the revised classification

is to be applied retroactively.

A defect in the CP model is corrected, and the fix must be applied retroactively in order to standardize

results.

These are examples but many scenarios can be imagined in which the ability to restate prior months’

profitability would be invaluable. The Restatement Implementation serves to protect the monthly production

timeline (by achieving faster throughput), and to protect the validity of Management book reconciliation.

There are various production issues (encompassing business declarations, data quality, and processing

defects) which necessitate restating historical financial results. As these results will be used by Relationship

Managers to make business decisions involving their customers, this capability is critical. The successful

historical Financial Restatement validation and validity of Management book reconciliation and sign off on the

updated Financials.

Contribution:

General maintenance of Staging reports during the Restatement process.

Developed a number of new Customer Hub reports for validation of certain keys of input files in

Staging versus those of the pre existent data in the Customer Hub.

Enhancement of Restatement BI Run Book for new releases of ongoing projects.

Coordination with Production Support team towards smooth delivery of reports and power cubes

during Restatement.

CBG Customer Profitability Cubes (Feb’2007 – Nov’2007)

Environment: IBM Cognos 8.x, Frame Work Manager, Powerplay Transformer 7.4, Analysis Studio, Oracle SQL

Developer 1.5.4, Cognos Access Manager, Oracle 10g, AIX – 5.3, IBM – Tivoli 8.3 (Maestro Scheduler)

Team Size: 4,

Role: BI Senior Developer

Description:

The project involved development of a flexible base model capable of extrapolation into four different cube

models each providing different functional view of the data mart in terms of context and sources. The work

involved end to end development from design and development of the original framework manager model for

generation of IQDs and further, the development of the cube models. The four extrapolations of the model

were for different ‘Tiers’ of customers in ‘Regular Profitability’ and ‘Financial Restatement’ of data.

The fifth cube was unique in design in that it sourced data from multiple data sources (both Regular Profitability

and Restated data) and Tier wise contextual views, simultaneously in the same cube. This cube was used by

the business to determine the validity and deviance levels of calibrated metrics after the restatement of the

Profitability module and determining the acceptance levels for sign off of restated data into the Data mart.

Contribution:

Involved in design of the cube models.

Developed and tested the base model and a few variations of the original set of four cubes.

Developed and tested the ‘Summary cube’ model.

Debugged deviation of certain calculated facts in the base model.

Involved in determination of precision and presentation design of the facts.

Responsible for maintenance and enhancement releases of the Profitability cubes.

Worked with data analysts on full scale test plans of cube data after various Restatement activities

and enhancements.

Customer Hub Reports & Data integration Metrics Cube (April’2006 – Jan’2007)

Environment: Cognos 8.x, Frame Work Manager, Report Studio, Powerplay Transformer 7.4, Analysis Studio,

Oracle SQL Developer 1.5.4, Cognos Access Manager, Oracle 10g, AIX – 5.3, IBM – Tivoli 8.3 (Maestro

Scheduler)

Team Size: 5,

Role: Senior Cognos Developer and Cognos Admin

Description:

Customer Hub is a customer centric application to store all types of customers in Consumer Banking Business,

their details, the parties associated with customers like relationship managers and the products. In the life time

of this application, there are lot of data discrepancies loaded in to the database. This project is a major initiative

taken up by CBG technology team to bring up all the irregularities, discrepancies and anomalies into business

notice to correct existing data and avoid the future problems. As part of this project, lot of data validation

reports and anomaly reports are developed and they are very helpful to business analysts, senior management

and the business.

Cognos 8 environment Setup and Migration from CRN to Cognos 8 BI (July’2005 – Mar’2006)

Environment: Cognos ReportNet MR2, IBM Cognos 8.2, Frame Work Manager, Report Studio, Content

Management Administration, Access Manager, Oracle 10g, AIX – 5.3, IBM – Tivoli 8.3 (Maestro Scheduler)

Team Size: 3

Role: Cognos Admin

• Installed, Configured Cognos 8.2 environment.

• Existing Production CRN components migrated to Cognos 8.2.

• Test and validate the New Cognos 8 behavior on AIX 5.3

• Assisted development team in fixing the migrated reports issues from CRN to C8.

• Assisted offshore team to validate and fix the migration issues and successfully deployed the c8

reports in UAT and Production.

Credit Processing Initiative (CPI) Reports (June’2004 – June’2005)

Environment: Cognos ReportNet MR2, Frame Work Manager, Oracle 9.2, AIX – 5.2, IBM – Tivoli 8.3

(Maestro) Scheduler

Team Size: 7

Role: Senior Cognos Developer and Cognos Admin

Description:

The purpose of the Credit Process Initiative (CPI) Reporting Project is to implement a consolidated reporting

solution to produce standardized reports for credit banking origination information. The solution will provide

standardized reports, both on demand and scheduled delivery, from a centralized reporting repository, gaining

efficiencies in cost, turnaround times and resource utilization by automating manual processing.

The Business Groups that are involved in this project are:

• Business Banking

• Commercial Banking

SWDC Migration (Phase I PROD/UAT Environments/Phase II Dev Environment) (Mar’2004 – May’2004)

Environment: Cognos ReportNet MR2, Oracle 9.2, IBM AIX 5.2, IBM AIX 5.3,

Team Size: 5

Role: Cognos Admin

All Solana Data Center Servers are moved to South West Data Center (SWDC) as CitiCapital Technology Data

Center consolidation process. Following roles played as a Cognos Administrator.

• Installed, Configured and setup the exact CRN environment as existing.

• Migrated the existing CRN Components to new environment.

• Test and validate the new CRN behavior on AIX 5.3 (existing AIX 5.2).

Responsibilities: Worked as a Tech Lead in Citi – CBG project and accomplished the following

responsibilities.

COGNOS ANALYST ROLE

• Interact with Business User, gather requirements and prepare technical specifications.

• Prepare Estimation based on the business requirements.

• Involved in User meetings for requirements gathering, status updates, communicating issues, delays.

Preparing the MOMs of these meeting and responsible for follow up sessions.

• Do the Impact Analysis for Change requests and implement changes after the approval.

• Design and develop Framework Manager Model.

• Design dimensional and standard reporting models in Framework Manager (Physical Layer, Logical

Layer, Business Layer) from multiple data sources.

• Create Data source query subjects, model query subjects and stored procedure query subjects based

on the requirements.

• Create segments links to work multiple developers on the same project.

• Define the relationships and cardinalities between query subjects.

• Worked on parameter maps to define data level security.

• Create different Packages for different business areas.

• Publish the Packages to Report studio users.

• Create/ Review Framework Model Design Specification.

• Design, Develop and publish the Framework Model with appropriate folder & security access.

• Developed and integrate Reporting scripts in the Cognos framework as per the Business

Requirements.

• Involved in Reporting data model Design based on the reporting needs.

• Design and creation of Standard and Complex Reports.

• Developed List Reports, Cross tab Reports, Section Reports, and Drill Through Reports

• Developed summary and detail reports

• Creation of multi Page and multi Query reports.

• Creating Multi dimensional Cubes using PowerPlay Transformer.

• Creating the .mdl file using Transformer and running the .mdl file in AIX 5.3 environment to generate

the .mdc file.

• Publishing the Cubes and reports to Poweplay Enterprise Server.

• Involved in testing of the Cubes.

• Developed drill through reports and migrate to a Development /Production environment.

• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.

• Tested and improved Report Performance.

• Scheduling reports in Schedule management.

• Coordinate with offshore team to understand the requirements and resolve queries and issues.

• Review the Technical Design Specification and Unit Test Plan prepared by Offshore Team.

• Involved in the development and review of reports, unit testing and Integrated System Testing.

• Mentor Offshore Team Members.

• Review and testing the reports developed by others.

• Review the cognos reports against the Citigroup standards and validated against the requirements.

• Promote/deploy the FM Model/packages to SIT, UAT and PROD environments.

• Validate SIT/UAT Test Plan & results.

• Create the CHANGE REQUEST for deployment/promotion to UAT/Production.

• Prepare deployment/promotion documentations for cognos report XML and Framework Manager

Model.

• Developed scripts to perform code promotion in various systems (ETL UAT, ETL Production).

• Follow up the User Acceptance Testing and analyze the defects, if any.

• Prepare the Run Book, Knowledge Repository and Best Practices documents.

COGNOS ADMIN AND PRODUCTION SUPPORT ROLE

• Proficient with Cognos Software Installation (Multi Server – UNIX / Windows), configuration, up

gradation, Migration and support on IBM AIX (5.x) UNIX.

• Involved in Cognos Report Net and Cognos 8 installation and configuration at Citigroup CBG DWH

UAT and Production Environment.

• Involved in successful migration of CRN Report Net to Cognos 8 in Citigroup CBG DWH UAT and

Production Environment.

• Actively involved in Content Management Administration. Make the Sync in between Production and

UAT environments using the Content Management Administration.

• Creating user groups, assigning roles and setting the privileges through Access Manager

Administration.

• Involved in the annual CoB (Continuity Of Business) Testing and taken the leadership from Cognos

side and responsible for building the C8 Cognos environment in CoB and execute all reports in CoB

environment when the Production and UAT environments were went down.

• Implement the security and publish the model and provide appropriate access to the use groups.

• Deployment of reports and users set up to other environments.

• Setting capabilities to various user roles.

• UAT / Production Server Administration using Access Manager.

• Promote/deploy the FM Model/packages to UAT and PROD environments.

• Interact with External Team (UNIX & DBA) and Cognos Technical Support for any technical issues.

• Version Control the codes/artifacts in the UAT/Production Environment.

• Level I Cognos Administrator for DEV, SIT, UAT and Prod Environment.

• Developed code for EERSFeed (retrieving users and group information from Sun One Directory

server and creating a text file with users and groups information).

• Developed Shell scripts for executing Java programs, automated Customer Hub specific jobs such as

EERSFeed, AuditLogReport and DisablementLogReport.

• Developed shell scripts to check and remove core dump files to tune server speed.

• Supporting monthly Production cycle and solely responsible for Production Support.

• Responsible for ETL and BI Production Support.

MAESTRO DEVELOPER ROLE

• Create and Modify Scheduling Objects (Cognos Jobs and jobstreams) in the TWS (IBM Tivoli 8.3)

database: Jobs, jobstreams, workstations, workstation classes, domains, calendars, resources,

prompts, parameters, and user definitions.

• View and modify Cognos jobs, jobstreams, workstations, domains, prompts, resources, and file

dependencies in the current plan.

• Submit ad hoc Cognos jobs and jobstreams.

• Apply and save filters for TWS database and TWS plan views for Cognos jobs and jobstreams using

the IBM Tivoli 8.3 (Maestro Scheduler)

• Creating dependencies between Cognos Jobs and Jobstreams in the IBM Tivoli 8.3 (Maestro

Scheduler)

• Track and filter TWS events for Cognos Jobs and Jobstreams in the IBM – Tivoli 8.3(Maestro

Scheduler)

• Generate automatic email alerts for specific Cognos events such as jobs and jobstreams

abends/success using the IBM Tivoli 8.3 (Maestro Scheduler)

Project Name: Consolidated Content Management System – Data Factory

Client: Thomson Scientific Healthcare, Philadelphia, USA

Role: Tech Lead

Environment: C++, Solaris 8, AIX 5.2, Oracle9.2, DB2UDB 8.2, Shell Scripts, Perl Scripts, Makefile, CVS

Organization: Satyam Computer Services Limited

Duration : (Nov’2003 – Feb’2004)

Project Description

• Derwent (A part of Thomson Scientific group) is a product development company in Publishing and

Life Science domain. Derwent product basically deals with different types of data such as Patent,

Journal, Publication, World Drug Alerts and the Derwent chemical registry. The data received from

the International patent office (IPO) is loaded into the source Oracle databases running on SOLARIS

Machine.

• The Loader applications which are written in C++ which run on SOLARIS machine are responsible

for getting the data from different data collection centers (Oracle databases) and load the data into

the destination DCMS Oracle database running on SOLARIS Machine.

• The customer's business interests required the C++ code to be ported to IBM AIX machine and

destination database to be changed to DB2 (Presently, the destination is Oracle database). The

loader applications are written in C++, which uses Pro* C++ to fetch data from ORACLE DATABASE.

• CLI (Call Level Interface) of DB2 is being used as an interface to load the data into the destination

DB2 database.

• PERL and SHELL scripts are being used to automate the loader jobs. These scripts take care of

generation of reports for all the database activities done by the loader applications.

• Loaders take data from source database, do the conversion of data into XML format, do the required

QA checking and load the data into destination database.

• The other module apart from Loaders is known as EXTRACTORS. Extractors are used for extracting

the data from the central repository, which has been loaded by the Loaders. These applications are

written in PERL and SHELL scripts.

Responsibilities: Worked as a technical leader in Derwent and accomplished the following responsibilities.

Involved in Requirement Analysis, Design and Feasibility Study.

Involved in the Scope Verification & FRD Preparation

Designed and Developed the Proof of Concept for DB2 CLI and ensure the success of the POC.

Actively involved in the re design of the CCMS Derwent (loader applications) while migrating the

loader modules from Oracle7 on Solaris8 to DB2UDB 8.2 on AIX5.2.

Porting of C++ Applications from Solaris AIX and modifying the ORACLE’s SQL Statement to DB2

SQL.

Involved in writing new Makefiles and modifications of existing Makefiles.

Actively involved in the migrations and testing of derwent extractors.

Actively involved in the design process of different loader modules which was redesigned from

Pro*C++ to the DB2 CLI way.

Involved in understanding the business functionality and developing different approaches for

migrations document.

Responsible for development and unit testing of the Derwent product.

Solely responsible for Unit, Integration, Performance testing.

Actively involved in the SIT and UAT for the Derwent product.

Solely responsible for the implementation of the Derwent Product

Solely responsible for customer communications and the weekly status report.

Project Name: ENTERPRISE BUSINESS SERVICES (EBS)

Client: Blue Cross Blue Shield (BCBS), Missouri, USA

Role: Tech Leader

Environment: VB 6.0, HP UX (11.0), Sybase 12, Shell Scripts, XML

Organization: Satyam Computer Services Limited

Duration : (Aug’2003 – Oct’2003)

Project Description

The BCBS MO Well Point policy is to achieve parity across Major Business Units (MBU) with a common

platform based on Call Care Browser. Well Point currently maintains multiple customer user interfaces and

customer service applications. Each customer service application employs its own business process.

Responsibilities:

Developing each service as stored procedures in Sybase

Writing Shell scripts to compile/run the Sybase Stored Procedures

Developing VB Components for Parsing the XML, getting the required input attributes, passing it to

the back end.

Formatting the output data in XML format

Project Name: Loan Administration System

Client: World Bank, Washington, D.C. USA

Role: Module Leader

Environment: C, C++ on Solaris 8, Oracle9.2, Shell Scripts, Makefile

Duration : (June’2003 – July’2003)

Project Description

World Bank provides loans and donations to different countries (under developed/developed) for their

development of health care system, child education systems. The different types of loan schemes are:

• IBRD International banking for reconstruction and development

• IDA – International development agency

• HIPC – Highly indented poor counties

• TF – Trust funds, treated as low interest loans or donations

The LAS system, on which the World Bank operates consists of four sub modules, they are disbursement,

accounting, billing and reference module. The functionality of disbursement module is,

Setting up of different types of loans and associating it to different countries.

Maintaining the document details in the system for making the loan effective.

Releasing the loan to treasury for the actual payment.

Handling the cancellations, in case the borrower is not eligible for the loan.

Handling of repayments, when borrower repays the remaining loan amount before the maturity date.

Handling the adjustments of loan amounts against the cancellations and adjustments.

Responsibilities:

Maintenance of Disbursement Module and Reference Module

Enhancement of the Original C and C++ code as per the new business requirements.

Conversion of the VMS Scripts to Shell Scripts

Involved in Unit, Integration and Regression Testing using Simulator.

SIT and UAT (Preparation of Test Plan, Test Data and involved in Testing)

Project Name: EQUINOX NON OPICS FOR TREASURY

Client: STANDARD CHARTERED BANK, U.K

Role: Tech Leader

Environment: Rogue Wave C++ on Solaris 8, Sybase12, SQL Advantage, Shell Scripts

Organization: Scope International Limited, India (A Wholly owned subsidiary of Standard Chartered

Bank, U.K)

Duration : (Aug’2002 – June’2003)

Project Description

The Equinox Non Opics is a Treasury Product for Standard Chartered Bank, U.K. Generally Deals are flowing

from Front Office to Back Office via different products and finally those deals are reconciled at Back Office.

The deals may be a FX Deal or MM Deal. The Deals must be flown across the following Products to be

reconciled at back office. These Products are:

CASTOR (The Components are Inspector, Converter and Publisher)

ETX (It is a Message Queuing System)

POLLUX (The Components are Subscriber, Messenger and Monitor)

OPICS (Operation Processing Control System)

PEGASUS and SCSTAR

Responsibilities:

Production Support and maintenance (Health Checks) for all the above Products.

Direct Interaction with business users to solve their problems.

Back Office Processing related new releases and patches that moved to Production (Analysis of the

specifications provided by the clients)

SIT and UAT (Preparation of Test Plan, Test Data and involved in Testing)

Client site for implementation

Project Names: RFS FOUNDATION PROJECT

Client: CITIBANK, JAPAN

Role: Module Lead

Environment: C++ on Solaris 8 and Tru64 UNIX, Oracle 8.1.6, Txn Scripts, Shell Scripts, Makefile

Organization: MphasiS BFL Software Limited, India (an EDS Company)

Duration: (May’2000 – Aug’2002)

Project Description

RFS Foundation Projects are a suite of banking applications mainly used for online banking. Conceptually this

software consists of three layers. The user Interface layer, the middle layer and the backend processing. We

at MphasiS – BFL, handle the middle layer. The middle layer consists of two components RFS layer that acts

as Online Transaction Processor and IST that acts as the switch to route the message to respective backend

servers. This being a multi layered software, only the business layers are being developed here making use of

the available objects that are generated using Factory objected methods, a facility provided by RFS.

RFS CitiDirect Online channel, Citibank Japan

CitiDirect is a web interface for Citibank customers to carry out transactions on their accounts. The message

based interaction between CitiDirect and Systematics is through RFS (Regional Front end System). RFS

switches all the request messages from CitiDirect to Systematics and all the responses from Systematics to

CitiDirect. CitiDirect interacts with Systematics because all the information on the customer’s accounts resides

with Systematics.

The following suites of product releases are the part of RFS Citidirect Project for Citibank.

Address Change Release through CitiDirect Channel (May 2002 – Aug 2002)

Environment: C++ on Solaris 8, Oracle 8.1.6, Txn Scripts

Team Size: 8,

Role: Module leader

RFS Porting – Tru64 UNIX to Solaris 8 (Jan 2002 Apr 2002)

Environment: C++ on Tru64 UNIX, Forte C++ on Solaris 8, Oracle 8.1.6

Team Size: 6,

Role: Module leader

Tools Development (FMF Tree from FMF Buffer and ISO Tree from ISO Buffer (Oct 2001 Dec 2001)

Environment: C++ on Solaris 8, Shell Scripting

Team Size: 1,

Role: Module leader

CitiDirect 2000 – Q2 release – MY FIRST GAIKA (Dual Currency Placement deposit) (June 2001 Sept 2001)