DEBOPRASAD BHATTACHARYA
Phone – +91-950*******
Email: ****.**************@*****.***
Professional Summary
Having Total 13+ years of work experience in Object Oriented Design, Modeling, Programming and Testing in Java, J2EE, XML and Relational Databases.
Expertise in Object Oriented Programming using Java and J2EE related technologies.
Worked on project with Agile methodology
Implemented Test Driven Development process
Proficiency in developing secure web applications and server side development using Spring Framework, RESTful Web Services, Hibernate, JDBC, JNDI, Struts, Spring, JSP, JSF, Servlets, Java Beans, JavaScript, XML, CSS, HTML, Oracle, DB2.
Expertise in developing the web applications using Struts, Spring, Hibernate and J2EE Application Servers such as Jboss, and Websphere
Extensively worked on Spring MVC
Wrote dependence injections, used annotation and inner bean in Spring Framework
Extensively used RESTful web services by using all four methods of HTTP (GET, POST, PUT, DELETE)
Hands on experience with databases including Oracle, PL/SQL, DB2 and MySQL involving stored procedures, triggers, functions, indexes, and packages.
Extensively uses designing tools such as MS-Visio, EA for preparing Work Flow diagram, System flow diagram
Experience in working with web/applications servers JBOSS, Apache Tomcat and Apache HTTP Server.
Worked on CRM tools such as Infor EAM, E.Piphany Sales & Service
Working knowledge on CSS, XML, XSD & XSLT Stylesheet
Used Jasper Reports to create pdf report documents as the output reports of the Java scheduler job executions
Strong knowledge of Design patterns J2EE Design Patterns, Singleton, MVC framework
Having excellent understanding on Software Development Life Cycle(SDLC) including Analysis, Requirement Gathering, Data modeling, Design, Development/Coding and testing
Hands on the tools such as Eclipse, JDeveloper, Textpad, Linux vi editor, etc.
Hands on experience on Linux in writing shell scripts for job
Hands on experience in VPN, Putty, WinSCP etc.
Experienced in MAVEN 3.0 to build and deploy Java applications.
Hands on experience in project management tools like Clear case, CVS and SVN.
Writing the JUNIT test cases
Solid foundation in software programming concepts of OOPS
Worked on design and application development in Banking, Retail, Automobile, and Insurance domain
Technical Skills
Programming Languages: JAVA, J2EE, XML, SQL, PL/SQL
Web/XML Technologies: HTML, DHTML, CSS, JavaScript, JQuery, Servlets, JSP, XPATH, XML, SOAP, RESTful Web service
Frameworks: Hibernate 3.0, Spring 3, Struts 1.2
Apache Projects: Log 4j, Struts1.4 and Apache CXF.
Tools & Utilities: Eclipse, JDeveloper, Textpad, WinSCP
Application/Web Servers: BEA Web logic, WebSphere, Jboss, Tomcat
RDBMS: Oracle 10.x, DB2, MySQL 4.0, MS SQL Server 7.0, MS Access
Source Control: Rational Clear Case, CVS, SVN
Design Patterns: Singleton, Factory, Front Controller, DAO (Data Access Object).
Operating Systems: Windows 7/2000/XP, Linux
CRM: SFDC, Epiphany Sales & Service
Build Scripts: Maven, ANT
Domain Knowledge: Retail, Banking, Automobile, Insurance
Certification:
Sun Certification Java Programming (SCJP) cleared 1st level with 87% marks.
Experience:
Organization
Designation
Duration
Infor Global Solutions India
Principal Technical Consultant
(Sep/2010) – Till date
Mahindra Satyam Ltd.
Consultant
(Apr/2005) – (Sep/2010)
eBusinessware
Sr. Software Engineer
(Aug/2004) – (Apr/2005)
NIIT Ltd.
Executive Education Delivery
(Dec/2000) – May/2004)
Projects Profile:
Pioneer Natural Resource, TX Feb 2014 – Till Date
Infor
Languages: Java/JDK1.6, Spring framework, RESTful Web service, Infor EAM, EAM Mobile, XML, XSD, JQuery, Java Script, JSP, JBoss, Oracle 11g, Junit, Mavan, Eclipse, CVS
Project Description
Pioneer Natural Resource is an Oil and Natural Gas producing company. The business function to provide invoices for work completed through Infor EAM has been established for Pioneer Natural Resources Pumping Services. This business function provides an estimated invoice record and a final customer invoice record. These records are used to create printed documents for the estimate invoice and the customer invoice as well as staging the customer invoice for an interface to DO2, and the third party service from ADP.
Responsibilities:
Involved in writing java coding for different modules
Wrote dependency injection (DI) of type setter injection, constructor injection in Spring Framework
Wrote Inner Bean and used autowire annotation in Spring
Involved in requirement gathering, design, Analysis, preparing the use cases and Responsible Designed and developed backend services implemented through REST service and Integrated with presentation layer using HTML
Used AOP (Aspect oriented programming) in Spring Framework
Created RESTful web services by using different HTTP methods (GET, POST, PUT, DELETE)
Involved in Analysis and Design of various modules using J2EE Architecture and MVC Design Pattern.
The project is implemented on Agile methodology
Wrote Junit test cases
Configuring POM.xml file for Mavan
Implemented complete SDLC life cycle of the project
Working as a support resource and works on tickets raised by customer on EAM
Worked on new enhancements such as designing new custom screen, designing new reports
Do requirement gathering and prepare design document based on the requirement
Submitting weekly status report to the manager (Customer)
Involved in doing Code Refactoring and peer reviewing of code
Following coding standard as per client specification
Involved in code checkin and checkout to CVS
Going to field (Pumping Service) and giving training on EAM to field workers and supervisor
Giving training to Supervisor on EAM Mobile Enterprise and explain them how to use EAM application in Apple iPad
Banco De Credito(BCP), Peru Oct 2010 – Jan 2014
Infor
Languages: Java/JDK 1.6, Spring Framework, RESTful web service, Sales & Service (Epiphany) 7.0.3, XML, XSD, JQuery, Java Script, JSP, Oracle 10g, Genesys, Websphere-6, IBM Http Webserver 6.1, Junit, Mavan, Eclipse, CVS
Project Description
BCP the bank of Peru has initiated to implement Customer Relationship management Sales & Service using Infor CRM. BCP has business requirement to implement both inbound and outbound functionality, where a Genesys dialer an existing application which receives calls from customer and then it executes outbound of Infor S&S to handle that call and maintain the data for future reference. The aim is to provide all functionalities of Infor Sales & Service with respect to the requirement. The application will be used by the BCP sales team to capture all information of BCP customer for creating lead and opportunities. The application will allow to create new opportunities and publish to customer by using inbound of Infor S&S which will bring more business to BCP. This will help BCP in below different ways:
It is on Open Architecture platform (OA). In which OA refers to the data layer of the application while Sales & Service consist of both data layer and UI layer
It will help in enabling the sales team to manage their activities more effectively.
It will help in managing and tracking existing customer’s detail, new Leads, Campaigns, Opportunities, activities, forecasting etc
Automate the inbound and outbound module
Responsibilities:
Extensively wrote java classes for different service levels and created bean object(BIO)
Wrote controller class, Dispatcher servlet in Spring MVC
Used dependence injection, annotations in writing code in Spring
Created RESTful web services by defining GET, POST methods.
Consumed RESTful web services methods
Involved in Analysis and Design of various modules using J2EE Architecture and MVC Design Pattern.
The project is implemented on Agile methodology using Scrum
Interacting with onsite team to understand the requirement for different module assigned
Handling the team and assigning task to individuals
Wrote Junit test cases
Configuring POM.xml file for Mavan
Involved in doing Code Refactoring and peer reviewing of code
Following coding standard as per client specification
Doing development and customization in S&S as per the requirement for different modules
Doing development for different nightly batch jobs in doing java coding for importing and validating data into S&S database
Created transactions for batch files
Involved in code checkin and checkout to CVS
Preparing weekly status reports for the work done
OC-Tanner Utah Aug 2009 – Jul 2010
Mahindra Satyam
Languages: Java/JDK, JBoss-Seam, JSF, Hibernate, Jira, Java Script, JSP, Junit, Mavan, Eclipse, Oracle 10g, SVN
Project
Project 42 (forty-two), the answer to the great question of life, the universe and everything (The Hitchhiker Guide, Douglas Adams) is the internal working name for one of O.C. Tanner’s largest initiatives. When complete, O.C. Tanner will have one system and platform that will combine and enhance our on-the-spot, performance and incentive offerings. Doing this enables us to meet client’s increasing demands for a single recognition partner, Incentive based programs, variety of flexible program combinations (including sales, safety, performance, wellness, ideas, spot and others)and more customizable solutions that all work together to provide one singular view with their program results.
Project 42 is divided into several modules Catalog, Material-Master, User-management etc. User-Management provides the facility for data capture, editing, approval and creation of users. Created user can be nominated to a Nomination, which will be approved by his manager and the nominated user will be awarded based on his good work done with the award level such as sending appreciation e-certificate etc.
Responsibilities:
Extensively worked on front end, business and Hibernate frameworks.
Involved in design, development and testing phases of project.
Involved in design, analysis and architectural meetings. Created Architecture Diagrams and Flow Charts.
Handling the team and assigning task to individuals
Wrote Junit test cases
Configuring POM.xml file for Mavan
Preparing status reports and discussing with onsite coordinator
Followed Agile software development practice paired programming, test driven development
Developed use case diagrams, class diagrams, database tables, and mapping between relational database tables and object oriented java objects using Hibernate.
Involved in doing java coding on different modules
Involved in doing Code Refactoring and peer reviewing of code
Following coding standard
Designing page by using JSF
Involved in code checkin and checkout to SVN
Fixing the bugs raised by testing team.
Abercrombie & Fitch, OH Apr 2008 – Jul 2009
Mahindra Satyam
Languages: Java/JDK, Spring JDBC, Spring MVC/WebFlow, XML, Tomcat 6.x, Mavan, Eclipse, JUnit
Database: Oracle 10g,
Tools: Bamboo, Maven, SVN
Defect tracking tools: Mercury
O/s: WIN XP, Unix
Project Description
AAA is an application which allows store employees to purchase "hot" items at an additional discount. This application has two main interfaces: Store Operations access the application from core TOMCAT to create new AAA items. During each sales transaction, Store21 performs verification to determine eligibility for AAA sales. The AAA UI is implemented by using technology Spring MVC/Webflow. To implement this we have defined view-state for a JSP page. In the view-state is an XML file where we defined the state of a page by using Webflow. For example if the next button is pressed this will call Action class and will send some information to next page when it gets displayed. In the view-state file we need to define the flow of each page and there actions. The user interface is divided into three modules:
Country Control: In this one has to create discounts on a country level, can edit discounts. Once the discounts are created or edited, it will allow approving those discounts
Create AAA: In this module one can create an AAA for an employee or for a store based on job code and job group code. Once a AAA is created on a store level for a country. If any employee of AnF goes to a store to buy an item, during that time when a cashier swaps the card of that employee it checks in the background whether that employee is eligible for an AAA or not and it will tell how much discount he can avail and based on that the bill will be generated for that employee
Store Control: In this module one can create a new store control, edit store control and approve store control. This module will tell that for which stores and for which brand an employee who is working in a store or in home office can avail discounts
Responsibilities:
This application is a new development and was involved in requirement gathering of different modules by attending meetings with business
Implemented complete SDLC life cycle of the project
Developed technical design document
Involved in database designing
Involved in the development of all three UI modules
Wrote Spring controller class for web application
Writing configuration XML files for WebFlow (Spring MVC)
Implemented Spring MVC.
Writing JSP pages for each modules
Involved in writing view-state files and Action classes etc.
Build applications using Build tool Maven.
Writing Pom.xml file for Mavan
Involved in writing JUnit test cases and unit testing
Involved in code checkin and checkout to SVN
Involved in effort estimation
Abercrombie & Fitch, OH Sep 2008 – Mar 2009
RMS center
Mahindra Satyam
Languages: Java/JDK, Spring JDBC, XML, XSD, JUnit
Web Server: Tomcat 6.x
Database: Oracle 10g, DB2
Tools: Maven, SVN
Defect tracking tools: Mercury
O/s: WIN XP, Unix
Project Description
ANF currently runs power builder based Store21 POS and Java based handheld applications at the stores with a mainframe/DB2 backend. Several applications exist on the mainframe to support these applications. ANF has decided to replace this mainframe system with Oracle’s comprehensive retail solutions suite which includes Integrated Store Operations apps, Pricing, and Merchandising solutions.
The end to end Implementation of Oracle Retail application will include integration and interfacing with other corporate systems including Oracle retail Merchandising Operations Management systems, PeopleSoft, back end financial systems, and various other third party systems for an end to end data flow to fully leverage the features of the Oracle retail applications.
Migration of application in Abercrombie & Fitch for future growth, expansion, and superior customer service by providing a successful implementation of Oracle Retail application for all its brands & countries.
Responsibilities:
Involved in requirement gathering of different applications for migrating from Mainframe/DB2 to Java/Oracle by attending meetings with business team
Extensively writing java coding in core java
Wrote Junit test cases
Developed solution design document for different applications such as Transfer, Receiving, PC Inventory, eUSR, Sensource etc.
Worked as a lead/coordinator for offshore and onsite to give knowledge transfer of requirements of different applications
Developed technical design document for all applications
oAssigning task to offshore team to develop modules of different application
oInvolved in coding, Unit testing and deployment of applications such as Transfer, PCInventory, Receiving, eUSR
oClosely interacting with testing team while doing system testing testing
oWorked on defects which are raised by testers during system testing
oWriting Pom.xml file for Mavan for different application
oInvolved in code checkin and checkout to SVN
CITI Cards, TX May 2007 – Sep 2008
CITI Pays
Mahindra Satyam
Languages: Java, XML, XSD
Database: Oracle 10g
Tools: Websphere, RAD6.0, Java/JDK, ANT, XML Bean of Apache, XSD, CVS, Autosys, CDM, TIBCO, JAX-WS Webservices, ab initio
Bug tracking tools: Clearquest, Infoman
O/s: WIN XP, Sun Solaris, WinSCP
Project Description
Equinox Project named as ‘Citipays’ is a Citigroup initiative, focused on bringing multiple lines of business together, demonstrating collective strength to consumers and delivering value in a way which is unmatched in the industry today. This program is more about selling products; its main objective is to help customers save and plan for their future.
Citipays program is about enrolling a customer into equinox by opening eligible accounts like checking, savings, Home Equity, Mortgage and credit card. Based on customer choice of enrollment, rewards amount will be credited into checking account after completion of tenure if all the requirements are met.
Responsibilities:
Involved in writing java coding for different modules
Wrote XSD files and used XML bean of Apache as a parser to parse XML files comes for TIBCO or Ab Initio
Involved in implementing the JAX-WS web services.
Wrote Web Services which send and receive xml message from TIBCO
Use cases for different functionalities (Enrolment, Payout, Account Change Activity etc) and HLD
Data model which includes Conceptual design, Logical design and Physical design
Involved in requirement gathering by attending meetings with business
Worked as a coordinator for offshore to give knowledge transfer of requirements
Detail Design document
oDeveloped a complete architecture of project Citi Pays
oDeveloped Work Flow, Class diagram for different functionalities.
oDeveloped System flow diagram for Real Time, Nightly batch jobs interaction with different Lines Of Businesses (LOBs) and Enterprise Dataware Housing (EDW).
Involved in assigning task to offshore team to develop modules and giving guideline the way to be implemented
Involved in coding and testing of Batch enrollment modules and eligibility modules
Involved in co-coordinating the IST and UAT testing
Giving solutions to implement certain scenarios to business
Involved in code checkin and checkout to CVS
Nissan TN Apr 2006 – Apr 2007
NNA AMES Transition
Mahindra Satyam
Languages: Java 2, PL/SQL, Shell Scripts
Database: MS SQL Server 2000, Oracle 9i
Tools: WSAD 5.1, Epiphany S&S 6.5.1, BCP utility, Batch processing, File Transfer
O/s: Windows NT, Unix
Project Description
It is a support and maintenance project. The Customer Database (CDB) application is a part of the Marketing which a one of the application of entire NNA project. The application contains data about all customers who have purchased, leased, serviced or expressed their interest in a Nissan or Infiniti Vehicle. Data is received from various sources like internal Nissan systems & external vendors and processed on mainframe every month and loaded into the CDB monthly. All the customer data is then downloaded into Epiphany database through UNIX batch jobs.
Responsibilities:
Resolving tickets which are raised by customer related to UNIX scripts, SQL scripts and Java code.
Small enhancements in adding new functionality through java code and SQL scripts.
Assigning tickets to team members.
Writing and modifying extensions as per the need
Updating attributes in bios, recordsets
Created tabs, popup screens as a part of requirement
Given training on Epiphany to team members to handle defects raised by customer
CIGNA, DE Aug 2005 – Mar 2006
IMPACT
Mahindra Satyam
Languages: Java 2, PL/SQL
Database: MS SQL Server 2000
Tools: Epiphany 6.5.1 Sales & Service, Crystal Report 8.1, Websphere 5.0
O/s: Windows NT
Project Description
Impact contact center, a solution that will be used by Cigna International expatriate benefits (CIEB) Contact Centers within United States & United Kingdom.
The solution will provide operational service capabilities using Epiphany software. To meet the objectives, the solution will utilize epiphanies e-service functionalities. As integrated solutions, these capabilities will be configured to meet CIEB’s specific objectives.
Responsibilities
Involved in writing business login in Java which runs on server side
Developed different reports like interaction report, monthly metrics report etc. by using Crystal Reports tool.
Involved in loading & publishing reports.
Involved in developing & customizing different Forms.
Involved in writing java extensions for bio, form level and computed attributes.
Cigna Hong Kong Apr 2005 – Jun 2005
RCS (Regional Claim System)
Mahindra Satyam
Languages: Java 2
Database: MS SQL Server 2000
Tools: Epiphany 6.5.2 Sales & Service, Web logic 8.1
O/s: Windows NT
Project Description
CIGNA has taken an initiative to build an Epiphany solution for the existing web based Regional Claim System (RCS) storyboard application of CIGNA. Epiphany RCS Storyboard provides a common platform to obtain a single, consistent view of all customer information, irrespective of where the information is stored: whether in a local database or in remote systems or in legacy system.
Responsibilities
Prepared the Workflow document for RCS Storyboard.
Prepared the Functional Requirement Specification Document.
Involved in developing different screens in Epiphany service.
Involved in developing writing java extensions to implement business rules.
Prudential Annuities NY Aug 2004 – Apr 2005
ECMS
eBusinessware
Languages: Java 2, PL/SQL
Database: Oracle 9i
Tools: Epiphany 6.5.3 Sales, Websphere 5.x, Crystal Reports 10
O/s: Windows NT
Project Description
Prudential Annuities, USA has initiated to develop a contact management system in Epiphany. Our aim is to provide the functionalities in the Epiphany Sales App., which will be used by the Wholesalers and the sales persons (employees of prudential) to capture all the information of the IP's (Investment professional, Prudential's client), which will bring business (for e.g. Life insurance policy) to prudential.
Responsibilities:
Understanding Epiphany product and customize it
Responsible for designing and developing Use Case documents
Making unit test cases.
Writing server side Java classes which holds the business logic
Configuring Websphere as an application server
Developed various modules
Writing SQL procedures
Creating views, tables
Involved in writing java extensions for Bio levels & UI levels
Involved in writing java extensions for computed attributes
Involved in writing EPI extensions
Developed various reports using Crystal Reports
Loading and configuration of various Epiphany modules (*.ebm & *.ebmd)
Persoft
PHEMS
Languages: Java 2,XML, Servlets, JSP, C-Sharp, PL/SQL
Database: DB2 7.0
Web server: Tomcat 5.x
Project Description
In this project Persoft engineers are using pocket PC where c# is loaded. Through GPRS or GSM connectivity it is communicating with server which is having servlet and database DB2. When in a pocket PC one complaint record is updated and saved. The record flows through GPRS to central server and servlet interprets it and updates the database, at the same time it acknowledges it and sends the message to pocket PC. If any new complaint is added to database through admin staff then one SMS is send to pocket PC through GSM connectivity.
Responsibilities:
Documents designing like HLD, LLD
Designing of sequence diagram, use cases, class diagram by using Enterprise Architect tool
Responsible for developing JSP Screens, Servlets etc
Involved in developing XML parser engines
Responsible in writing PL/SQL procedures, creating tables, views etc
NIIT Ltd Dec 2000 – Mar 2004
ENCORE
Role: Executive Education Delivery
Languages: Java 1.2, PL/SQL, Websphere
Database: MS SQL 2000
O/S: Windows NT
Project Description
This project deals with complete student’s automation system. It includes forms like students personal details, attendance entry, marks entry, Batch allocation form, Fees submission form etc. are all made in Frame (Swing) and which communicate with an instance EJB object (CMP) in J2ee server the EJB object further then communicate with SQL database for saving and retrieving records.
Responsibilities:
Giving training to students on different subjects such as Java, .NET etc
Developing Forms in swing.
Writing Java classes for defining business rules
Making unit test cases.
Education:
MBA from SMU, India
Bachelors in Science from CCS University, India
Honors Diploma in Information System Management (HDISM) from APTECH, India
Visa Status:
H1B visa – Valid till Sep-2016
B1 visa – Valid till 2022