Posted on Tue, 1 May 18:5 CDT

                                                                  
                                                                          Priya Sinha

469-242-2405
214-517-1489
priya19sinha@gmail.com


Summary

•	Total 4 + years of IT Experience within all the aspects of the Software 
Development Life Cycle (SDLC).
•	Expertise in PL/SQL, TIBCO, OPAS, Java, J2EE, Java Struts.
•	Experience in writing PL/SQL query, procedures, functions, packages, cursors, 
exception handling, triggers, collections and performance tuning.
•	Knowledge of  PL/SQL data types ,Indexes ,Joins ,views ,Sequences ,Sets 
,Collections, transactions, Large objects ,System packages, System Tables ,user privileges 
as well as inbuilt functions.
•	Possesses a strong foundation in implementing Oracle policy modeling and Oracle 
Policy Automation solutions(OPAS). 
•	Knowledge of  Oracle Business Rules for OPM.
•	Knowledge of IBM Rational Application Developer CVS, VSS ,Nobix tools
•	Experience in Designing and Developing Interfaces using TIBCO Tools like TIBCO 
Active Matrix Business Works, Designer, TRA, and TIBCO Administrator.
•	Strong understanding in Java Concepts.
•	Worked Extensively in J2EE Design and architecture.
•	Experience in working with Java Struts Framework
•	Excellent Team player capable of working independently, willingness and ability to 
quickly adapt and learn new technologies, along with excellent communication and Inter-
personal skills.



Technical Skills:

Operating Systems	UNIX, Linux, Windows
Enterprise Technologies	Java, JMS, JDBC, Java Struts
Web Services	 XML,XSD,XPATH, SOAP, WSDL
Programming Languages
	J2EE, C, C++, PL/SQL,OPAS
Databases
	Oracle 8i/9i,10g ,SQL Server

TIBCO Integration Tools	TIBCO Business Works 5.x , TIBCO Designer ,TIBCO Administrator 
,TRA,TIBCO HAWK















Professional Experience  


1STOPMaintenence, TCS Kolkata, INDIA				                               
Jan’11– Mar’12

Role: Developer

Description: :  This project was also an auto insurance project. In this project, there 
are 4 modules-Auto module-creations of auto policy and its endorsements, BNR-Billings and 
receivables, PUL-Personal Umbrella Liability, TDI- Temporary Disability Insurance.

BNR was the module which was mainly responsible for proper billing purpose. There were 2 
types of policies for BNR-Direct Bill and Group Bill.
Direct Bill policies were those policies for which bills were to be sent to each customer. 
They were of 3 types-1-pay,2-pay and 4-pay.In 1-Pay policy, customer had to pay the entire 
premium in 1 installment while in 2-pay,2 installments was permitted and in 4 -pay,4 
installments were permitted. The records were maintained by ledger and installment 
schedule for each policy.
Group Bill policies were those policies for which automated deduction from credit card 
,bank account, payroll were feasible and no bills were sent to the customer but a 
consolidated deduction was done. They were of 4 types-EFT,RCC,PDP,APD.In case of EFT 
policies, deductions were done via Bank account while for RCC policies ,it was done 
through Credit Card and also in case of  PDP and APD-Payroll was the mode for deductions 
.These policies were maintained via deduction schedule and ledger entries individually.
Also payment, assess/waive of fees, Reverse Payment, Misapplied Payment were also possible 
in this module.

TDI was the modules that used to insurance to companies. Any company could buy a single 
TDI Policy for all its employees. In this module, creation & endorsement as well of 
cancellation of policies were possible. They were of 3 types-monthly, quarterly and 
annually. In each case, an audit was generated monthly or quarterly or annually depending 
on the type of the policy and was sent to the company. the company used to report back 
with the employee count and eventually premium was calculated and bill was sent.


Responsibilities:
•	Involved in the project preparation phase like gathering end application 
requirements, Service Specification Documentations, Designing Interface specification 
documents.
•	Responsible for 24X7 supports related to reported issues.
•	Involved in Batch Monitoring for successful processing of all transactions.
•	Worked on Coding for incorporation of any endorsements in the policy
•	Worked on PL/SQL Query handling and incorporation of requirements.
•	Involved in Performance tuning of SQL Queries and Creation of batches.
•	Worked on PL/SQL function procedure packages programming, exception handling, 
cursors, triggers.
•	Involved in working on  SQL PLUS sessions environment and System tables and 
packages.
•	Involved in working with Transactions and user privileges.
•	Worked extensively on the use of indexes,views,collections,triggers as well as 
linear regression and regular expression functions.
•	Knowledge of OPAS  Attributes, Screen and Screen Order.
•	Worked in creating Public Names, entities, and introducing Business Rules 
Management Systems and exploring existing Systems in OPAS,.
•	Involved in structuring the rule base, testing Rules, explaining Rule Logic, and 
writing Rules in OPAS.
•	Involved in Unit and Integration testing of overall application services.
•	Monitored Services using TIBCO Administrator and HAWK
•	Processed and conducted Unit testing, component testing, system testing & 
regression testing.
•	Fixed bugs according to the software change requirement.
•	Designing and Developing Interfaces using TIBCO Tools like TIBCO Active Matrix 
Business Works, Designer,
•	Developed software processes that involved defining Components, Connections and
•	Identifying the key variables that will be used with all services and defining 
them as GV’s.
•	Created the JDBC based Storage for look-ups and cross-referencing among 
applications.
•	Designed, developed and implemented a horizontally scalable common FTP service to 
provide a common interface to clients in order to transfer batch transactions using FTP 
protocol.
•	Migrated the process to the production environment and deployed the process.



Environment
Oracle, PL/SQL, JDBC, Java Script, JSP, Java, HTML, XML, IBM RAD, NOBIX Scheduler, CVS, 
VSS ,TIBCO Business Works ,TIBCO Administrator ,TIBCO HAWK.,OPAS .


 
IA2 Maintenance, TCS Kolkata, INDIA                                                                                  
Apr ’10– Dec’10 
                                           
Role: Developer

Description: IA2Maintenance was an auto insurance project. The main requirement was to 
create a quote online using individual login id and password and after receiving the 
required payment, the quote was converted into an auto policy. Any endorsement or payment 
was done online by the customer and in case of any error, customer support was to be 
contacted by the customer.


Responsibilities:  

•	Documented functional and non-functional requirements in Requirements 
Specification 
•	Designing, building and deploying system configuration, Testing, Implementation, 
QA, Configuration management..
•	 Responsible for fixing the bugs reported in the Test Director by the testing team
•	Participated in application performance tuning, system documentation, and 
technical support for production.
•	Processed and conducted Unit testing, component testing, system testing & 
regression testing
•	Worked on PL/SQL Query handling and incorporation of requirements.
•	Involved in Performance tuning of SQL Queries and Creation of batches.
•	Worked on PL/SQL function procedure packages programming, exception handling, 
cursors, triggers.
•	Involved in working on  SQL PLUS sessions environment and System tables and 
packages.
•	Involved in working with Transactions and user privileges.
•	Worked extensively on the use of indexes,views,collections,triggers as well as 
linear regression and regular expression functions.
•	Knowledge of OPAS  Attributes, Screen and Screen Order.
•	Worked in creating Public Names, entities, and introducing Business Rules 
Management Systems and exploring existing Systems in OPAS,.
•	Involved in structuring the rule base, testing Rules, explaining Rule Logic, and 
writing Rules in OPAS.
•	Involved in Unit and Integration testing of overall application services.
•	Monitored Services using TIBCO Administrator and HAWK
•	Processed and conducted Unit testing, component testing, system testing & 
regression testing.
•	Fixed bugs according to the software change requirement.
•	Designing and Developing Interfaces using TIBCO Tools like TIBCO Active Matrix 
Business Works, Designer,
•	Developed software processes that involved defining Components, Connections and
•	Identifying the key variables that will be used with all services and defining 
them as GV’s.
•	Created the JDBC based Storage for look-ups and cross-referencing among 
applications.
•	Designed, developed and implemented a horizontally scalable common FTP service to 
provide a common interface to clients in order to transfer batch transactions using FTP 
protocol.
•	Involved in Batch Monitoring for successful processing of all transactions.
•	Worked on Coding for incorporation of any endorsements in the policy.
•	Worked on PL/SQL Query handling and incorporation of requirements.
•	Involved in Performance tuning of SQL Queries and Creation of batches



Environment
Oracle, PL/SQL, JDBC, Java Script, JSP, Java, HTML, XML, IBM RAD, NOBIX Scheduler, CVS, 
VSS ,OPAS.


Initial Learning Program ,TCS Kolkata, India						 
Dec’09– Apr ’10

Role: Developer/Trainee

  

Description: Involved in design and development of online banking application that allows 
customers to manage their accounts, pay bills and also access financial and business 
solutions like capital management, cash management, mortgage lending, investment banking 
and online brokerage services. 

Responsibilities:

•	Designed client-side validations using JavaScript and server side validations 
using JSP and Servlets.
•	Developed Servlets to access the database using JDBC for Oracle 8.1
•	Coded server side using Java Servlets and JSP for updating of balances and also 
for sending the request to the database, adjustment of balances and giving back the 
updated balance for the customers
•	Coded for PL/SQL package for managing accounts.
•	Worked with HTML, XML and JavaScript user interfaces.
•	Performed unit testing and fix bugs.

Environment: 
 Oracle, PL/SQL, JDBC, Java Script, JSP, Java, HTML, XML, Windows NT, Eclipse.

Policy Processing & Financial Needs Project                                                           
Nov’08– Nov ‘09   
Client:  AXA Group, UK
 Role:  Designing.


Tools:    Edit plus, Adobe PhotoShop, Oracle 9i

Project description: This project was developed for Insurance Company for the following 
needs: List of Members in various Insurance groups, Reminders, Notices, Agents, Agent 
performance, Receipts, Daily cash registers for cashier. Also includes reports.

Responsibilities:

•	Designed client-side validations using JavaScript and server side validations 
using JSP and Servlets.
•	Developed Servlets to access the database using JDBC for Oracle 8.1
•	Coded server side using Java Servlets and JSP for updating of balances and also 
for sending the request to the database, adjustment of balances and giving back the 
updated balance for the customers
•	Coded for PL/SQL package for managing accounts.
•	Worked with HTML, XML and JavaScript user interfaces.
•	Performed unit testing and fix bugs.

Environment (With skill versions)
JAVA, JSP, Struts, Apache Tomcat Application Server 5.0.28, HTML



Unified Communication using CISCO IP Communicator Project, Scope Kolkata, India   Jan’08– 
Oct’08

Role: Trainee

 Description:  Involved in integration of real-time communication services such as instant 
messaging (chat), presence information, telephony (including IP telephony), video 
conferencing, data sharing ,call control and speech recognition with non-real-time 
communication services such as unified messaging (integrated voicemail, e-mail, SMS and 
fax) using  CISCO IP Communicator system.

Responsibilities:
    
•	Configuring Cisco Unified Communications Manager, Cisco Unified Call Manager and 
Cisco IP Communicator.
•	Integration of real-time communication services with non-real-time communication 
services.
•	Preparation of menu items and implementing it like cricket news, games etc.
•	Performed unit testing and system testing.

       

EDUCATION:  Bachelor’s in Information Technology, Engineering, Asansol, INDIA.