Saikat Sengupta's Curriculum Vitae

I have established my career with over Nine years experience in the development of quality enterprise-scale software, primarily using Java Enterprise technologies. I have worked the entire software lifecycle as developer, mentor and module  lead.

I would like to pursue my career working on leading edge projects where I can continue to improve my technical knowledge whilst developing my mentoring and leadership skills.

• Over Nine years of  Software experience in design and development of business applications.
• Extensive experience building web-based enterprise systems(Struts1.1 ,Custom Tag Libraries, WebServices ) and with a strong knowledge of enterprise Java (J2EE, including EJB, RMI,Servlets, JSP, JDBC) on a variety of application servers (Weblogic, Borland, JBoss, JRUN).
• Experience in Internet Programming with Java, Multi threading and RMI programming.
• Experience in writing Stored Procedures using PL/SQL and SQL.
• Entrusted by several clients to reengineer their business processes and provide appropriate solutions using application software as the medium.
• Excellent Interpersonal and communication skills.

Insurance Agent/Agency Portal Website (Office of the Commissioner of Insurance, State of Wisconsin, USA)

The State of Wisconsin, Office of the Commissioner of Insurance (OCI), regulates the business of insurance in Wisconsin. OCI licenses insurance companies and agents. This Portal website developed to provide online, current information regarding insurance companies, agents, and agencies to the public. The new search feature for the Agent/Agency Lookup provides information regarding licensee information including address, license status, license type, lines of authority, appointments and terminations, and administrative actions

• Design and implementation of an Model View Architecture framework.
• Involved in Designing Usecase Diagram, Class Diagram, Object Diagram and Sequential Diagram through TogetherJ.
• Work with the team to move to the newly defined Struts framework
• Used Custom Tag Libraries/JSP for View, Struts Actions Classes for Controller ,Data Value Object as a Model
• Developed Business Logic and Presentation Layers in Java, JSP and JDBC.
• Design the database model and generic access beans to store/retrieve business data via JDBC.
• Installation and Configuration of Tomcat WebServer.
• Wrote stored procedures and SQL to access data from Oracle.
• Production link:
  http://ociaccess.oci.state.wi.us/ProducerInfo/PrdInfo.oc

Financial Data Entry System  (Office of the Commissioner of Insurance, State of Wisconsin, USA)

The current financial database relies on downloads from the NAIC to populate its tables. However, certain companies and company types do not file, or do not timely file, with the NAIC. This requires manual entry to capture the data. The company types retained in the financial data system are limited to property and casualty, life, and fraternal companies. There are a number of other company types for which the data is retained in a haphazard system on multiple platforms. Those company types include: Blue Plans, Continuing Care, Dental Plans, Health Maintenance Organizations, Limited Service Health Organizations, Motor Clubs, Title Companies, Town Mutual, Viaticals, Vision Plans, Warranty Plans, Gift Annuities, Accredited Reinsures, and Surplus Lines. The purpose of this project is to create an interface to allow data entry into the financial database for those companies where information is not available from the NAIC. Having all the data in one central location facilitates access to the data and eliminates the need for redundant data entry.

• Involved in development including system analysis, project planning, coding, testing, prototyping, documentation, end user training, end user support, troubleshooting and maintenance for the application.
• Used Common J2EE Design Patterns like Session Facade, Value Objects, Data Access Object and Model-View-Controller.
• Designed and developed EJBs, Session Beans, Data Value Object using JBuilder 9.0 Enterprise Edition and deployed on Web Logic 8.1 Application Server ,Designing Screens on Delphi 6.0.
• Evaluated use of EJB 2.0 CMP with EJB QL.
• Designed and implemented several Stateless Session and Entity EJBs. The Entity beans utilized Container Managed Persistence (CMP). Many of the Session beans used JDBC for direct access to complex Queries and performance was an issue.
•  Implemented SOAP Web Services for communicating between EJB and Delphi 6.0 Client.
•  Generated Webservices (WSDL) for Connecting between EJB and Delphi.
• Used SQL, Stored Procedures, Triggers and PL/SQL with Oracle 8i database.

Premium Tax System  (Office of the Commissioner of Insurance, State of Wisconsin, USA)

This system is used to allocate taxes on insurance companies’ premiums and to process those payments made by insurance companies. Payment processing includes premium taxes, fire dues, and other fees owed by insurance companies.

• Involved in development including system analysis, project planning, coding, testing, prototyping, documentation, end user training, end user support, troubleshooting and maintenance for the application.
• Used Common J2EE Design Patterns like Session Facade, Value Objects, Data Access Object and Model-View-Controller.
• Designed and developed EJBs, Session Beans, Data Value Object using JBuilder 9.0 Enterprise Edition and deployed on Borland Enterprise Server ,Designed Screens on Delphi 6.0.
•  Designed and implemented several Stateless Session and Entity EJBs. The Entity beans utilized Container Managed Persistence (CMP). Many of the Session beans used JDBC for direct access to complex Queries and performance was an issue.
• Configured DataSources and Connection Pools in Weblogic.
• Using XML/SOAP communicated Delphi client to Borland Enterprise Server.
• Used SQL, Stored Procedures, Triggers and PL/SQL with Oracle 8i database.
• Operating System: Window 2000

E – Office ( e – Governance solution for New Delhi, India) 

• Design and Development of File Movement System.
• Wrote top level Classes to encapsulate complexity of GUI programming using AWT.
• Wrote DAO classes, which uses JDBC for database operations.
• Wrote Servlets for interaction with client and DAO classes for any database operation.
• Introduce dynamic HTML generation for this project.

khazana Business Information System (KBIS)  ( Taj Trade & Transport Co. Ltd, New Delhi  ,India) 

• Integrated System Developed on Client Server Architecture.
• Features of Multi Threading Process like Online Customer Bill Printout, Dialing up for Credit Card verification.
• Features of Online Profitability Analysis/Costing Analysis /Marketing Analysis/Sales Analysis
• Features of Income Tax Report /PF Reports/Sales Reports/Customer Purchase Report/Profit Reports.
• Integrated with 35 Branches throughout India through Intranet.

Timeshare Vacation Ownership Management System ( Toshali Resorts International , New Delhi ,India) 

• Integrated System Developed On DBMS Platform.
• Integrated Reports /Incentive Reports Availability of different Resorts Status and Accounting Outstanding Statements of Different customers and written 35-45 Reports on Foxpro2.6
• Implemented in 16 Resorts throughout India
   

Degree:

Bachelor Degree in Computer Science (92-95) from Delhi University, New Delhi, India

• Working as Software Engineer in  iGate Capital  USA since May 2000.
• Worked as Sr. Software Engineer in Logicsoft International, India. During March-1996- May 2000.
• Worked as Sr. EDP Programmer in Toshali Resorts International, India, During May 1994- Feb 1996.

2925 Fish Hatchery Road
Madison Wisconsin -53713
USA

001-608-658-6365 (Mobile)