Sales Project

*

Sanjoy Kumar Roy

Profile

** ***** *** * ****** [Onsite Assignment in USA from Oct 2013 to till Date] of IT industry experience encompassing a wide range of skill set, roles and industry verticals. Currently working in Cary, NC, USA location(Client : MetLife Inc., USA)

Extensive experience with analysis, design, development, customizations and implementation of software applications.

Proficient in analyzing and translating business requirements to technical requirements

Strong database skills, Object Oriented Programming and development knowledge

Implemented software projects in Banking, Insurance and Retail industry

Good communication skills, interpersonal skills, self-motivated, quick learner, team player. Skill Set

Language/Technologies Java 1.x, J2EE Suite, JSP, Servlets, JAXB, JDBC, JMS, Groovy Web Technologies JavaScript, JQuery AJAX, SOAP, REST, JSON, XML, Micro Services Framework Struts, Spring

Middle layer Technology iBATIS, JPA, Hibernate

RDBMS MS-SQL, Oracle, DB2, Mongo DB

Application Servers WebSphere, BEA Web Logic, JBOSS and Apache Tomcat. IDE/Modelling Tools Rational Application Developer (RAD), Eclipse, NetBeans, Spring Tool Suite(STS)

Version Control Sub version, Clear case, GIT

Database Tools IBM DB2 Client, SQL Plus, SQL Developer, DB Visualizer. Build Tool Ant, Maven, Gradle

Methodologies Waterfall, Agile (SCRUM)

Testing Tools JUnit, SoapUI

Operating Systems Windows NT/2000, UNIX, Linux

Education

B.Sc. Math(H) – 2002 from Vinoba Bhave University, Hazaribagh, India

MCA – 2005 from West Bengal University of Technology, Kolkata, India Experience Summary

Organization Designation Duration

IBM India Pvt. Ltd, Kolkata, India (Onsite

Assignment in USA from Oct 2013 to till Date)

Technical Lead Apr 2010 to Till Date

Mphasis Limited, Mumbai, India Sr. Software Engineer Nov 2008 to Apr 2010 Datamatics Limited, Mumbai, India Software Engineer June 2007 to Nov 2008 iWeb Technology Solutions Pvt. Ltd, Mumbai, India Software Engineer Dec 2005 to June 2007 Email id: **********@*****.***

Cell: +1-479-***-****

2

Professional Experience

Apr 2010 – Ti l l date, Technical Lead IBM India Pvt . Ltd. India Project 1

Name: Global Sales and Service Platform (GSSP)

Client: MetLife, Inc., USA

Start Date: Aug 2016

End Date: Till Date

Role: Technical Lead

Project Description:

The purpose of the project is to provide Global Sales and Service Platform (GSSP) framework which builds multi-tenant Software-as-a-Service (SaaS) platform for hosting MetLife’s Global Sales and Global Service Applications. GSSP will service its clients in different geographical regions across the globe and aims to provide a widely configurable platform to the clients. IBM team specifically engaged in developing micro services and applications that facilitate the MetLife Global Service Sales and Service Platform integration across multiple tenants in different geographical locations. This involves IBM team engagement in roles of consultant architects to validate the technology requirements, Scrum Master to review and evaluate the Sprint scope, API designers to assist with the creation of the data model, presentation service engineers to assist with the application builds around the laid design, testers to conduct functional test cases creation and execution etc. All these resources working together shall pave way to accomplish the successful deliverables for Global Sales and Service Platform

(GSSP).

Project Responsibilities:

• Understand the overall business process and gathering and analyze requirements for new service request. Attend regular meetings with the client for requirement gathering.

• Provided analysis and mitigation of the risks and issues identified.

• Understand the business and its requirements and develop Low level Design Documentation for the same.

• Design and develop Layouts on new requirements. Involved in application development and bug fixing.

• Co-ordinate properly with Offshore and client so that Client satisfaction is also not lost and development activity at offshore also gets improvised.

• Provide Development, Testing and deployment support throughout the life cycle of the project or until am associated with the project.

• Provide training and mentoring activities to the new entrants.

• Deliver new and complex high quality solutions to clients in response to varying business requirements.

Environment: Spring Boot, Groovy, Gradle, React JS, Spring Cloud Netflix OSS, Mongo DB Team Size: 15 to 20 for each Project

Project 2

Name: Order Capture and Order Management Application – D2C Client: Macy’s Inc. USA

3

Start Date: Feb 2016

End Date: July 2016

Role: Technical Lead

Project Description:

Macy's is a U.S. chain of mid-to-high range department stores headquartered in Cincinnati, Ohio and New York. Its selection of clothing merchandise can vary significantly from location to location, resulting in the exclusive availability of certain brands in only higher end stores. The business goal of Order Capture and Order Management program is to deliver one common Order Capturer system across all location and formats, and provide an exception driven and innovative system with customizable alerts that is highly integrated, simple, and easy to use. The new Order Capture and Order Management application project is part of Macy’s program to build and deploy an integrated set of applications to replace its current Order Capture and Order Management systems. The project goal is to migrate the existing order capture system to SOA enabled solution and implementing the new requirements from Client, like automated tool for order creation .This tool was designed to create multiple orders without human interactions. Once the input has been fed to it and the tool is executed, it automatically creates the number of orders mentioned in the tool as per the input given to it. Project Responsibilities:

• Coordinated with the offshore team and ensures timely deliveries for the project. Provide the project updates to the offshore development team on regular basis.

• Worked on Asynch Checkout Project as part of Order Capture and Order Management Application – D2C.

• Created the Technical Specifications Document from the Functional Specification and business requirements.

• Delivered high quality solutions to clients in response to varying business requirements.

• Involved in requirement Analysis, Coding and Unit Testing. Analysis of the existing application and provide enhancement suggestions.

• Involved in application development and bug fixing.

• Understand the overall business process and gathering and analyze requirements for new service request. Attend regular meetings with the client for requirement gathering.

• Provided analysis and mitigation of the risks and issues identified. Environment: JAVA, Spring, Hibernate, SOAP Service, EMS TIBCO, DB2, JBoss 6.3 Team Size: 8 to 10

Project 3

Name: ESS Omni Channel Attribute Tagging

Client: Macy’s Inc. USA

Start Date: Aug 2014

End Date: Jan 2016

Role: Sr. Programmer Analyst

Project Description:

4

Macy's is a U.S. chain of mid-to-high range department stores headquartered in Cincinnati, Ohio and New York. Its selection of clothing merchandise can vary significantly from location to location, resulting in the exclusive availability of certain brands in only higher end stores. In support of the Macy’s Inc. Omni Channel initiative a new ESS (Enterprise Support Systems) application is being developed - Attributes. The project involves Attributes Tagging Application is to create, maintain, inactivate, and search for attribute buckets/values and ability to publish new Attribute buckets/values and attribute modifications and enable tagging of these attributes in near real time. An Attribute defines the property of an object and is an element about a product and tagging is the process of applying an attribute to a business entity. Attribute views will be dependent on Product type to show only those attribute buckets/values that are relevant to the product type within a Department. Project Responsibilities:

• Coordinated with the offshore team (first 3 months for the project) and ensures timely deliveries for the project.

• Delivered high quality solutions to clients in response to varying business requirements.

• Involved in requirement Analysis, Coding, Testing & Documentation

• Involved in application development and bug fixing.

• Involved in the knowledge transition sessions to make the new team members understand the system.

Environment: JAVA, Spring, Hibernate, REST/SOAP Web Service, JavaScript, Ajax, jQuery Team Size: 10 to 12

Project 4

Name: Purchase Order Transformation

Client: Wal-Mart, USA

Start Date: Mar 2011

End Date: July 2014

Role: Sr. Programmer Analyst

Project Description:

Wal-Mart PO transformation project is a multi - team collaboration project between IBM US and IBM India and Wal-Mart. Wal-Mart Stores, Inc. (NYSE: WMT) is an American public corporation that runs a chain of large, discount department stores. It is the world's largest public corporation by revenue, according to the 2008 Fortune Global 500.

This project has been divided into teams as per the domains like Application Development, Functional, Architecture, QA & Testing etc. Under each domain there are team members from IBM US, IBM India and Wal-Mart, with different roles and responsibilities based on the scope of activities. PO Transformation project is one of IBM's biggest engagements in Retail Area. IBM is responsible for Application development tasks to deliver design, development and testing services for new PO Application as well as synchronization / integration with the old PO systems. The existing mainframe based legacy PO system of Wal-Mart doesn’t fulfill the existing requirements from functional & technical view and difficult to enhance primarily due to cost of maintenance/development of legacy applications. Objective of this project is to re-platform the legacy PO application on J2EE platform and sunset the old mainframe system application (legacy PO System) at the end of all releases. OMS build the order and pass it on to the legacy PO system. There will be a UI, and therefore maintenance will be performed in the new system. Invoice matching will occur in legacy systems 5

for accounting. The data feeds from GRS will contain some indicator to tell OMS which Order Requests should be combined to create a purchase order.

Project Responsibilities:

• Coordinated with the offshore team and ensures timely deliveries for the project.

• Worked on both Development and Support Project.

• Delivered high quality solutions to clients in response to varying business requirements.

• Involved in requirement Analysis, Coding, Testing & Documentation

• Involved in the bug fixing and giving support of Production issues.

• Involved in the knowledge transition sessions to make the new team members understand the system.

• Provided support to existing products and involved in maintenance of the application. Environment: JAVA, Spring, EJB 3, JPA, RSA 7.5, Web Service, DB2, Websphere 7.5 Team Size: 10 to 12

Project 5

Name: Deutsche Bank Mortgage Re-plat forming

Client: Deutsche Bank, Germany

Start Date: May 2010

End Date: Feb 2011

Role: Sr. Programmer Analyst

Project Description:

Deutsche Bank needed a solution to streamline their existing Mortgage Systems which consisted of subsystems like BKS, PHD, Access Database. The existing mainframe based legacy Loan/ Mortgage Applications of the Bank doesn’t fulfill the existing requirements from functional & technical view and difficult to enhance primarily due to cost of maintenance/development of legacy applications.

• Objective of this project is to re-platform the mortgage application on J2EE platform and sunset the old mainframe system application (PHD & BKS) at the end of all releases (R0.1, Phase 1-4).

• Implement core loan functions as multiple contracts with conditions & options, collateral management, product and calculation engine.

• Implement a booking engine to manage mortgage related transactions.

• Comply with new mandatory legislative requirements as required by German Law.

• Migration & Synchronization of legacy data as in PHD and BKS systems. It describes the transformation of the different source databases to be migrated into one integral target database, based on the MORE Phase 1 COM-model. A migration map is also available in addition to the UC, which describes the functional transition in detail. The transformation enables a loan transfer to the COM structure with all its necessary parameter values. Project Responsibilities:

• Analyzed the requirement which is documented within the Use Case and also the migration map which is available in addition to the UC which describes the functional transition in detail. Analyzed all the logical groups (i.e. around 40) and the rules defined in each of groups (i.e. total around 400). Also done the gap analysis.

• Followed the standard template and coding best practices during coding. I was responsible for the development of transformation of the different source databases to COM (Common Object Model) 6

and also written few test cases.

• Contributed to Release Note by adding migration guideline comment whenever needed. The release note is basically delivered with the Every Code Baseline to client and it includes how do client Team install this new code to their existing and already running environment and what new features and defect we fixed on that particular release.

• Reviewed all deliverables after finalizing the worked Peer review with Team lead.

• Delivered objects timely without sacrificing its quality. Environment: JAVA, Servlet, EJB 3, JPA, Eclipse 3.2, Oracle 10g, Weblogic 10 Team Size: 10 to 12

Nov 2008 – Apr 2010, Senior Software Engineer Mphasis Ltd. India Project

Name: Application Support, Maintenance and Enhancements of MAC Application Client: JP Morgan Services Pvt. Ltd., USA

Start Date: Jan 2009

End Date: April 2010

Role: Senior Software Engineer

Project Description:

MAC stands for ‘Markets Asia Console’. MAC has been selected as the global CRM tool for Cash Equities, including Equity Research, for all locations. Initially, MAC application has been made only for Asian Market. The intention is to create a single CRM toolset to support a more global approach to Client Management in Equities Sales & Research. In the future an extension to a common platform for the Global F&O business will come and other businesses have expressed interest in using MAC. Working Groups were established to perform a comprehensive review of the MAC application with specific focus on scalability and resiliency. Overall objective is to deliver full rollout of Market Asia Console (MAC) to following LOBs-.

• Asia Equity Sales

• US Equity Sales

• US Equity Research (includes Emerging Markets)

• US, EMEA Futures and Options

• selected EMEA Equities Derivatives

Project Responsibilities:

The MAC Project Working Group continue to provide rapid enhancements to MAC users in every 5 weeks. I have actively participated in enhancing and delivering MAC releases in every five week cycle.

• Understanding Requirements.

• Customer interaction.

• Providing solution to customer.

• Requirement Analysis, Coding, Bug Fixation

• Testing & Documentation

Environment: JAVA, JSP, Servlet, AJAX, Spring framework,Eclipse 3.2, SVN Tortoise,Sybase 10,Weblogic 10 Team Size: 5 to 8

7

Jun 2007 – Nov 2008, Associate Consultant Datamatics Ltd. India Project

Name: Development of Forecast Module and Scheduling Engine Client: MICROS, USA

Start Date: June 2007

End Date: Nov 2008

Role: Associate Consultant

Project Description:

This provides enterprise applications serving the hospitality and specialty retail industries exclusively. With an objective to expanding the product, is looking at including the Forecast Module and Scheduling Engine. The List of functions which are in-scope of this project is as below –

• Addition of a Forecast module – This module accepts the historical data which is already available in the existing system (e.g. – Gross sales, Net sales, Discounts etc.). These are called Forecast Components. Then the Forecast engine applies the algorithms (i.e. business rules) to arrive at the values of Forecast drivers. These Forecast values in turn, be used for the staff scheduling.

• Addition of a Scheduling Engine in the existing myLabor Module – The existing myLabor module now accepts the Forecast Drivers as the input and come out with scheduling of the staff by checking the details such as labor laws, employee availability, Resource skills and Rates etc. These details are already available in the existing myLabor module.

Project Responsibilities:

• Understanding the requirements of the client and act as a sole functional resource.

• Coordinating & clarifying the queries regarding the project functionality etc.

• Design and coding for the doc customizations.

• Involved in the design & coding of some of the Java modules.

• Unit, System, Integration Testing & debugging

Environment: JAVA, JSP, Servlet, AJAX, Struts framework, Eclipse 3.2, VSS, Oracle 10g, JBOSS 4.0.5 Team Size: 12 to 15

Dec 2005 – Jun 2007, Senior Programmer Iweb Technology Solutions Pvt . Ltd, India Project 1

Name: Payroll Management and Finance Management System Client: Brightest Circle Jewellery Pvt Ltd, Mumbai Start Date: May 2007

End Date: June 2007

Role: Senior Programmer

Project Description:

PRM Module is state-of-art, open ended, completely integrated, user-friendly software that caters to the compete automation of Human Resource Department. The PRM Module includes the following: Recruitment Mgmt., Induction and Training Mgmt., Payroll Mgmt. including Attendance Mgmt., Leave Mgmt., Shift Mgmt., OT calculations, Holiday Pay calculations, Salary Pay head structuring, Calculating Deductions etc. 8

Automated the overall functionality of Finance Management System like Voucher Creation, Trial Balance, Balance Sheet, General Ledger, Account Payables & Receivables Management and Bank Reconciliation Process.

Project Responsibilities:

• Involved in implementing the business rules along with designing the forms in coordination with the team members.

• Developed the whole Income Tax Module which helps to generate the TDS for an employee and also involved in other related processes.

• Implemented the automated Voucher Creation for both purchase and sales.

• Handled aging analysis with TDS effect in Account Payables & Receivables Management. Environment: JAVA, JSP, Servlet, NetBeans 5.0, VSS, MS-SQL 2000, Weblogic 6.1 Team Size: 3 to 5

Project 2

Name: Customer Relationship and Supply Chain Management System Client: Brightest Circle Jewellery Pvt Ltd, Mumbai Start Date: Dec 2006

End Date: April 2007

Role: Senior Programmer

Project Description:

CRM Module includes Pre-Sales activities, Sales Order processing– Order generated either through Direct Inquiry (Sales or Service) or Tender Inquiry i.e. Inquiry till Sales Invoice generation following Installation at Customers’ site, after sales support through Service Module and Generation of Reports (as per the customers’ business requirement).

SRM Module includes Warehouse Mgmt., Inventory Mgmt. along with a set of general supplier related processes i.e. Generation of PRs, POs, Receive Goods with Delivery Orders against POs, QC, Stocks updation and finally raising Purchase invoice. During QC, besides internal QC, this module also facilitates outside QC through service providers registered in the system. So It is an effort to computerize the overall functionality like Sales Inquiry, Cost Estimation, Quotation, Sales Order, Work Order, Inward (creating GRN), Quality Control, Actual Cost, Standard Cost, MRP, Issue Challan, Packing List, Sales Invoice.

Project Responsibilities:

• Involved in customizing the existing processes as well as adding new business processes.

• Involved in the module as per the Customers’ wish list and gap analysis document.

• Involved in designing and coded the user interface.

• Implemented the Costing module and worked for the customization to map all the related processes. Environment: JAVA, JSP, Servlet, NetBeans 5.0, VSS, MS-SQL 2000, Weblogic 6.1 Team Size: 3 to 5

Project 3

Name: Helpdesk Management System

Client: Avon Weighing Systems Pvt. Ltd, Mumbai

9

Start Date: May 2006

End Date: Nov 2006

Role: Programmer

Project Description:

The project is an effort to computerize the overall functionality of HelpDesk Management System. The Helpdesk is essentially a central point through which problem or issues (Calls) are reported and subsequently managed and coordinated. It is san integral part of the service function, responsible for bringing resources together to address a problem or other issues (Calls). The calls are received by a helpdesk and passed through various support levels until it is resolved. Calls are received and logged. A ticket number is issued to uniquely identify the support log. A series of events often need to be managed–such as ringing back, sending email updates, obtaining more information, escalating, writing notes, arranging visits to resolve the issue.

Project Responsibilities:

• Worked as part of the product team.

• Involved in customizing the existing processes as well as adding new business processes involved in the Module as per the Customers’ wish list and gap analysis document.

• Involved in developing the Service Desk Management module of the Help Desk Management System. Environment: JAVA, JSP, Servlet, NetBeans 5.0, VSS, MS-SQL 2000, Weblogic 6.1 Team Size: 3 to 5

Project 4

Name: Payroll Management System

Client: Avon Weighing Systems Pvt. Ltd, Mumbai

Start Date: Dec 2005

End Date: April 2006

Role: Programmer

Project Description:

The project is an effort to computerize the overall functionality of Payroll Management System. Payroll is one of a series of accounting transactions dealing with the process of paying employees for services rendered, after processing of the various requirements for withholding of money from the employee for payment of payroll taxes, insurance premiums, employee benefits, garnishments and other deductions. Project Responsibilities:

• Worked as part of the product team.

• Involved in customizing the existing processes as well as adding new business processes involved in the Module as per the Customers’ wish list and gap analysis document and also involved in developing Payroll Calculation Module.

• Implemented the Payroll Calculation and Loan Management System. Environment: JAVA, JSP, Servlet, NetBeans 5.0, VSS, MS-SQL 2000, Weblogic 6.1 Team Size: 3 to 5

Contact this candidate