Project Software Engineer
Resume:
Summary of Experience
. PeopleSoft CRM Technical Consultant with 10+ years of experience in
the architecture, programming, integration, business analysis,
design, development and testing of web based & networked client-
server systems and CRM Marketing, Partner Management, Sales,
Communication, FieldService, Support and HelpDesk applications.
. Undergone training by PeopleSoft Corp., PMI and have sound
knowledge of CRM application architecture, People Tools, BORM,
Business Objects & PeopleSoft Integration framework.
. Worked on multiple CRM and web applications with extensive
integration requirement using various integration technologies.
. International work experience in countries like US, The
Netherlands, Germany, South Korea, Sri Lanka, India and Thailand.
. Strong experience in designing and modeling relational databases,
Middle-tier and User Interface for enterprise applications using
state of the art object oriented methodologies and software design
patterns.
. Experience in Use Case/Functional requirements, System Requirements
Specification documentation.
. Experience in making fit gap analysis, technical proposals, effort
estimates and POC executions.
. Experience in designing middle-tier ActiveX components for
developing client server applications in Visual Basic 6.0; web
applications in Active Server Pages and VBScript with Oracle 9i and
SQL Server 2005 as the backend database.
. Has in depth knowledge in setting up and configuring MQ Servers and
Client.
. Has hands-on experience in Object Oriented Analysis & Programming.
. Has implemented OOAP concepts in various projects and platforms
using multiple technologies.
. Has good experience on leading Test effort of Banking and Financial
Applications using Test Automation Tools like Win Runner, Quick
Test Pro and Test Director.
Hardware and Software Environment:
Hardware : Intel based PCs, Motorola 68000 base Minies
Operating System : MS Windows 2000/ MS Windows NT, UNIX
Products/Tools :
. PeopleSoft (PeopleSoft CRM 8.9, People Tools
8.42,8.45,8.48 & 8.50, People Code, Application
Designer)
. Visual Basic 6.0, VB Script, IE 6.0, Microsoft
Transaction Server, Active Server Pages using VB script,
Internet Information Server, XML
. ActiveX, COM, COM +, DCOM, Business Objects
. ISAPI, LDAP, IBM MQ Series
. TOAD, ERWIN, VISIO
Reporting Tools : nVision, Crystal Reports and SQR
Test Automation Tools : Win Runner, Test Director, QTP
Languages : C, C++, COBOL, People Code
RDBMS : ORACLE 9i, MS SQL SERVER 6.5, MS SQL SERVER 2005
Business Domains :
. Banking, Public Housing, CRM, Marketing, Call Center and
ITES
. Material Management, Finance, Sales and Distribution,
Production and Planning
. Office automation, payroll management, Hospital
Management, Hire Purchase and Leasing, building
construction, Lab Information System
. Natural Language Processing and Machine Translations.
Professional Experience: Project Highlights
1. Project Name : Public Housing (PeopleSoft CRM 8.9 Support & HelpDesk)
Project Duration : 2008 December - 2011 May
Client : PHA (Philadelphia Housing Authority)
Environment : PeopleSoft CRM 8.9
Roles : Sr. Technical Analyst/Programmer
. Design & code correspondence framework in PeopleSoft
. Used Integration Broker for PeopleSoft CRM to Financial
integration
. Design & code of an analytical tool on top of the core
functionality using PeopleSoft Charts and custom online
views pages. This includes java and html scripting to
develop clickable chart objects.
. Setups, customization and migration of pages, records
and components
. Develop the functional design documents for the online,
business objects and crystal reports used for public
housing projects.
. Co-ordinate with Oracle support team to get solutions to
the existing product issues.
2. Project Name : Partner Campaign Management (PeopleSoft CRM 8.9)
Project Duration : 2007 August - 11/28/2008
Client : PHA (Philadelphia Housing Authority)
Environment : PS CRM 8.9 Marketing & Partner Planning
Roles : Sr. Technical Analyst/Programmer
. System Technical design documentation
. Setups, Customization and Configuration of components,
pages and records
. Designed AAF for work list notifications.
. Setup ERMS and integration of CRM with external mail
servers.
. Writing People Code to integrate CRM marketing and
Partner planning. Modify the SQL and PS Queries for
performance tuning.
. Designed and Customized components, CI, pages, App
Packages, records and respective People Code
3. Project Name : Service Support System - (PeopleSoft CRM 8.9 Support &
Help Desk)
Employer : Hexaware Technologies Inc, 1095 Cranbury
South River Rd, Suite 10, NJ 08831
(12/20/2004 - 06/30/2007)
Project Duration : 2006 July - 2007 June
Client : Getronics
Environment : PS CRM 8.9 Support & Help Desk
Roles : Technical Consultant
. Identify PeopleSoft development and configuration items
for each functional requirement
. System Requirement Specification documentation and
Technical design documentation
. Setups, Customization and Configuration of components,
pages and records
. Writing People Code and Application Engine programs.
Modify the SQL and PS Queries for performance tuning
. Customize components, pages, records and respective
People Code
4. Project Name : Multiple projects (Citibank CRM CP Upgrade, TRUE POC)
Employer : Hexaware Technologies Inc, 1095 Cranbury
South River Rd, Suite 10, NJ 08831
Project Duration : 2005 April - 2006 June
Clients : Citibank, NA; Dialog Telekom, Srilanka; TRUE, Bangkok
Environment : PS CRM 8.9
Roles : Technical Lead, Technical Consultant
. Executing POC, customization of PeopleSoft pages and
components
. Making Proposals, technical design and pilot
implementations
. Managing/executing Upgrade project (from PS CRM 8.4 to
CRM 8.9)
. Writing People Code, Integration with Billing Systems
5. Project Name : Concierge Release 5 (PeopleSoft CRM - Commercial Account
Opening)
Employer : Hexaware Technologies Inc, 1095 Cranbury
South River Rd, Suite 10, NJ 08831
Project Duration : 2004 Dec - 2005 April
Client : Citibank, NA
Environment : Win NT, Weblogic, PeopleSoft CRM 8.8
Tools/Technology : People Tools 8.42, DB2, SQR, App Packages, IBM
Websphere MQ, Test Director
Role : Project Leader
. Modify and fine-tune the architecture of the existing
CRM application (Concierge) to meet the new requirement
for Release 5 (Commercial Account Opening).
. Review the integration architecture, data architecture
and integration technologies used for the current
application and suggest solutions to enhance the
performance of the CRM application.
. Propose different change control and version control
tools and made presentations and help the client to
select the right CRM product and testing tool that meet
the requirement.
. Other responsibilities include project management, build
and coordinate a team of 16 designers, developers and
testers, HLD and LLD design reviews, test case analysis
and review and risk management. Reporting to Citibank PM
and project director.
6. Project Name : PeopleSoft CRM -Marketing, Help Desk- Change request and
Enhancements
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
(04/1/2000 - 11/30/2004)
Project Duration : 2004 July - 2004 Nov
Client : Citibank, Poland
Environment : Win NT, Websphere, PeopleSoft CRM 8.8
Tools/Technology : People Tools 8.45, nVision, IBM Websphere MQ,
Oracle 9i, TOAD,
Erwin, Win Runner, Quick Test Pro and
Test Director
Testing Tools : Win Runner, Test Director
Role : Project Leader
. Recommend CRM solution in compliance with technology
architecture to incorporate the enhanced
functionalities. Develop or modify components, pages and
records. Write People Code, PS Queries and App Engine
Programs.
. Evaluated different architectural solutions and helped
the client to select the best one to meet some of the
new database, reporting and interfacing architectural
requirements.
. Propose, evaluate, define, modify and implement various
processes for change control and migration management.
. Other responsibilities include effort estimation for
testing, analysis and review of Test Cases, daily
reporting to Citibank management, conflict management,
program management, project management, release
management, risk management, defect management and
upgrade management (from PT 8.42 to PT 8.45).
. Interfacing with PeopleSoft Inc to get and apply the
correct patch to meet certain requirements.
. Assist the Test Manager in the Consolidation of the
Defects for Reporting. Coordinated the SIT and UAT team.
7. Project Name : PeopleSoft CRM - Campaign Management and SFA (Citibank
Europe)
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Duration : 2003 June - 2004 June
Client : Citibank, Turkey & Poland
Environment : Win NT, Websphere, PeopleSoft CRM 8.8
Tools/Technology : People Tools 8.44, nVision, Crystal, IBM Websphere
MQ, Oracle 9i, TOAD, Erwin
Testing Tool: Win Runner, Test Director
Role : Technical Developer
. Involved in the technical assessment of CRM application.
. Performed solution fitment analysis.
. Recommended solution after studying various Proof-of-
Concepts for multi-country implementation.
. Designed the overall architecture of the CRM
application. Also was guiding the design, development
and testing team to follow the best CRM, PeopleSoft and
testing practices.
. Reviewed high level design documents, test cases, data
Requirement for Automated Test Scripts and report
architecture requirements and suggest best approaches.
. Developed the interface architecture, which involves IBM
MQ Server, CRM Web/Application server and various
external systems of Citibank.
. Also was helping out the DBA to design the data base
model for the CRM application.
. Played the role of report architect and designed the MIS
Reports which uses nVision and Crystal tools. Developed
PS Queries for all the CRM reports.
. Set up IBM MQ server and client to interface with
external systems to make online data available in CRM
Application.
. Interacted with different vendors for the selection of
right reporting tool. Designed and developed Application
Engine programs to interface different external systems
with CRM application.
. Assist the Test Lead in the Consolidation of the Defects
for Reporting. Reviewed test conditions, test cases and
test data.
8. Project Name : OLO (Online Loans Origination)
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Project Duration : November 2002 - May 2003
Client : JPMC
Environment : MS Windows 2000
Tools/Technology : ASP, VB, HTML, Oracle 9i, COM+, ADO, IBM MQ
Series, getAccess, Visual Studio 6.0
Role : Senior Software Engineer
. Was involved in the Low Level Design and Development of
OLO.
. Developed all the OLO to mainframe interface components,
designed and implemented OLO security model and help
pages.
. Done the deployment of OLO pages and Components in
development and QA servers.
. Coordinated the onsite testing team with offshore
development team.
. Preparation of Data Guidelines, Test Script, Test Cases
and Run Plan. Executed Test Scripts and Recording of the
Results. Involved in UAT and SIT of the application.
The online origination system is aimed at providing online
application for SBFS Loan and credit products and Consumer
unsecured loan product for CHASE Branch representatives.
The Branch would be able to submit a loan application
directly and receive a decision via the web site. An Email
would be send to the branch representatives once the loan
application is decisioned.
On site off site tem model has been used for this
project. IBM MQ Series is used to send and receive data to
and from mainframe system, which takes the decision. ADO is
used as the interface to the Oracle Database. COM
components are developed to implement business logics which
interact with stored procedures and other database objects.
VB6.0 is used for all the component development. Users are
authorized and authenticated using getAccess. SMTP is used
to generate and send Emails. Oracle 9i built in DES 3
algorithms are used to Encrypt/Decrypt vital customer
information.
9. Project Name : WWID
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Project Duration : August 2002 - September 2002
Client : J & J
Environment : MS Windows 2000
Tools/Technology : ASP,VB, HTML, SQL Server 2000, ADO, LDAP, ADSI,
Visual Studio 6.0
Role : Senior Developer
. Involved in the High Level, Low Level designs and
development of the WWID project.
. Developed all the ASP pages and job scripts to upload
database tables from CSV files.
. Developed test cases and executed functional and
regression testing.
WWID is a report generating intranet application developed for
Johnson & Johnson. Scripts running on a daily basis will
generate CSV files from Active Directories. These CSV files
are uploaded to SQL Server database. Application will use
these tables to generate various report s, which are
displayed using asp pages.
10. Project Name : SSOSimulator
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Project Duration : June 2002 - 5 July 2002
Client : JPMC
Environment : MS Windows NT
Tools/Technology : ASP, VC ++, SOAP, XML, ISAPI
SSOSimulator is developed for CHASE functional testing
team to remove the dependency between Chase-on-line and
eBanking sites. EChase Cookies, ISAPI plugin and SOAP
interface are the three elements of SSOSimulator.
eChase Cookies will be simulated by setting cookies
from ASP page within eBanking IIS web server. A browser-
based form will be presented to capture cookie data and on
submission will set the cookie for chase.com domain.
A VC++ based ISAPI plugin is installed on eBanking
IIS server that will intercept the HTTP request. This
plugin will read cookies set by the eChase cookie element
and will convert cookies into corresponding HTTP request
header that can be used by eBanking application.
A new SOAP interface is developed which has methods
required by eBanking application. This interface will read
static XML text files and will simulate chase-on-line SOAP
call.
11. Project Name : COLA (Chase OnLine Anytime)
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Project Duration : March 2002 - May 2002
Client : JPMC
Environment : MS WINDOWS NT
Tools : ASP, VB,HTML, Oracle 8.0, COM, ADSI, LDAP, IBM MQ
Series, Visual Studio 6.0
Role : Technical Leader
. As the technical leader representing MphasiS Corp New
York, involved in the High Level Design and
Development of COLA.
. Have developed all the COM components, stored
procedures and all important asp pages.
. Coordinated the team and helped to develop the Low-
level design (LLD) and project plans.
. Developed and reviewed the test cases and executed
test scripts and logged in defects through defect
tracking applications.
COLA will enable a customer to view product descriptions of all CHASE
Automotive Finance (CAF) loan and lease products, navigate
through frequently asked questions, utilize a glossary and
locate a CAF dealership based on an entered zip code and
car manufacturer.
The customer would also have the ability to view the current
CAF loan rates and an estimate of a monthly payment based
on different terms and credit tiers. Finally, the customer
would be able to submit a loan application directly to CAF
and receive a decision via the web site.
On site off site team model has been used for this project.
LDAP and ADSI are used for CHASE employee validations. IBM
MQ is used to send and receive information to mainframe
program, which takes the decision. ADO is used as the
interface to the Oracle Database. COM components are
developed to implement business logics which interact with
stored procedures and other database objects. VB6.0 is used
for all the component development.
12. Project Name : RDAM - Rights and Digital Asset Management System
Employer : MphasiS Inc, 460 Park Avenue South Suite #
1101 New York, NY 10016
Project Duration : March 2000 - Dec 2001
Client : Viacom Inc
Environment : MS WINDOWS NT
Skill/Tools : VB, Oracle 8.0, ActiveX/DCOM, Erwin3.0, Studio Central,
ADO disconnected recordsets, MS Visual modeler
Role : Senior Consultant
. As a senior consultant, was involved in the design,
testing, development and deployment of the and User
interface, Database, Middle Tier components for
Rights and Digital Asset Management (RDAM)
application developed for the different business
units of Viacom Inc.
. Involved in Functional and regression testing of the
application using different automation tools.
RDAM facilitates maintaining Rights such Licenses, Contracts for
Original, Acquired Movies and other various Television
Productions. The system also maintains digital assets such
as video clippings, Images etc. RDAM provides a finance
module which tracks the amortization and License fee
calculations for productions and provides OLAP Reports.
Since RDAM is designed as a single application which
supports the different business units of Viacom, which
follows similar yet different business, practices, the
system followed an n-tier architecture using reusable
ActiveX/DCOM components deployed on MTS in a network
server. Due to the Enterprise nature of the application the
system provided increased reusability using its state of
the art Object Oriented Design and was designed utilizing
Software design patterns for repeating themes. The database
was designed using Erwin3.0 and implemented in Oracle 8.0.
The business components were modeled using UML. The
class/state diagrams etc were created using MS Visual
modeler. The GUI was provided to the business layer using
VB 6.0 for the client server app and using DHTML, XML, ASP,
RDS on MS IE 5.0 for the intranet. The intranet application
also utilized Databinding technology of IE 5.0 / DHTML
using ADO disconnected recordsets. Various reports were
provided for the application using Office 2000 Pivot Table/
Spreadsheet component and using server side Active
Reports component. The system provided a digital asset
repository using Silicon Graphics' Studio Central software
and the interface was written using Visual C++ . A scanner
interface to Visioneer Paperport Scanner was provided for
inputing digital images/ Contracts etc to the application.
13. Project Name : Branch Connectivity using proxy Server
Employer : Indo European, Mumbai, India (08/1/1998 -
03/30/2000)
Project Duration : Dec 99 - Mar 2000
Environnent : Win NT
Skill/Tools : VB, SQL Server 7 and Proxy Server
Role : Team Leader
This project enhances the existing office automation
systems developed by the company by adding the branch
connectivity feature using Replication technique of SQL
Server 7 and Proxy Server so that the head office can
distribute the data to branch offices and vice versa. From
Head office we can monitor the up-to-date information,
transactions etc. of the branches.
14. Project Name : Complete Solution to Diamond Industry
Employer : Indo European, Mumbai, India (08/1/1998 -
03/30/2000)
Project Duration : Feb 98 - Dec 99
Environment : Windows NT
Skill/Tools : VB, SQL Server
Role : Sr. software Engineer
This project provides complete solution to the diamond
industry. It contains four major modules; Material
Management, Finance, Sales and Distribution and Production
Planning. Worked as the team leader for 10 developers.
Worked extensively with the database design and hard core
coding for the pilot project. Executed functional and
performance testing.
15. Project Name : Rich Data Systems
Employer : Indo European, Mumbai, India (08/1/1998 -
03/30/2000)
Project Duration : 1999 July - 1999 Oct
Environment : Windows NT
Skill/Tools : VB, SQL Server
Role : Team Leader
The Client is a chain of Cyber caf stretched across Mumbai
suburbs. The project contains three applications. A Master
application, a Server application and a node application.
Customers with membership in one center, is allowed to surf
the net from any other centers. Membership information is
stored in a magnetic card. The member who wishes to surf
the net will be logging in from any of the nodes. Once
logged on to a node, the membership account starts debiting
the hours let. The connection is controlled by the server
application.
Responsibilities include complete design of database,
interface, test cases, test conditions and components
16. Project Name : HawkEye
Employer : Indo European, Mumbai, India (08/1/1998 -
03/30/2000)
Project Duration : 1998 Feb- 1999 April
Environment : Windows NT/95
Skill/Tools : VB, SQL Server, ADO, ODBC
Role : Sr. Software Engineer
The project is a swipe card controlled security, attendance
and payroll system which grants access and release latch to
authorized persons only. The system has been broadly
divided into three modules; Security module, Attendance
module and Payroll module. Developed the complete Payroll
module and lead a team of 5 developers. Designed all sub
modules in payroll as Active X DLLs. Developed the ActiveX
controls used in the entire project. Designed the full
interface of the project. The project has an open back end.
Performed functional and performance testing.
17. Project Name : Ortho Manager
Employer : OVM Consultancy, Trivandrum, Kerala, India
(01/01/1997- 12/30/1997)
Project Duration : Jan 97- Dec 97
Environment : Windows 95
Skill/Tools : VB, Access
Role : Software Engineer
Ortho Manager is comprehensive and modular software
designed and developed in close association with a team of
leading orthodontists. It is a feature -rich, specialist
friendly package, which enhances productivity and optimum
utilization of resources. The project consists of ten
modules. Namely CaseSheet, Case Record, Case Analysis,
Photo Manager, Scheduling, Finance, Inventory,
Communication Manager, Reports, Analysis and Utilities. The
first four modules keep track of patient's treatment
details. Scheduling incorporates automatic
daily/weekly/monthly scheduling, Cancel/Postpone/Fasten
appointments, summary report of appointments
daily/weekly/monthly. Worked in a team of 5 developers
designed the interface and coded first four modules.
18. Project Name : Estimation Manager
Employer : Saafaa Infosystems, Changanassery, Kerala,
India (07/01/1995- 12/30/1996)
Project Duration : July 95 - Dec 96
Environment : Windows 95
Skills/Tools : VB, Access
Role : Software Engineer
Contact this candidate