Design Project
Resume:
Resume Arijit Chakraborty
Arijit Chakraborty
Email: ************@*****.*** Nationality: Indian
Mobile: (001) 415-***-**** Current Location: Rahway, New Jersey
DOB: 08 21 1980 Visa Status: H1 B valid until Aug 2016
Career Profile:
Software engineer having in total 8 years and 11 months of industry experience, and adept in all stages
•
of project lifecycle, right from capturing of business requirements, publishing application/e2e designs,
development, testing, coordinating user acceptance testing (UAT), production support, and maintenance.
Proven expertise in designing and coding of complex real time, business critical applications on Advanced
•
PL/SQL, Java, and UNIX.
Very proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers in
•
PL/SQL with extensive use of Oracle Advanced Queues and Oracle XML DB.
Having extensive experience in SQL query tuning, analysing of explain plans, and troubleshooting of
•
Oracle DB level problems like session locks, resource crunch and so on.
Have extensive working knowledge on Oracle 10g RAC environment, in active active mode on clustered
•
file systems (CFS).
Well exposed to JAVA Springs and iBATIS framework.
•
Very clear and vivid understanding of the Oracle Architecture.
•
Very thorough understanding of the Object Oriented Programming Concepts.
•
Having working experience in the design and implementation of numerous E2E solutions on Java/J2EE
•
and Perl.
Working knowledge with IBM MQs and Apache web server.
•
Having data warehousing concepts.
•
Have worked on assignments that required knowledge of programming languages like C and C++.
•
Have worked in maintenance assignments for the Logistic domain, involving enhancements and production
•
support.
Have worked in delivering numerous E2E solutions for the Telecom Billing domain and have been well
•
acclaimed for leading a production support team for the billing application of one of the world’s largest
Telecom Service Provider.
Have always exhibited excellent vocal and written communication skills and have always been an ardent
•
communicator at all levels, including supervisors, subordinates and of course clients.
Have always exhibited excellent analytical skills and continuous learning ability.
•
Strong interpersonal and presentation skills and proven leadership qualities.
•
Experience Summary:
Currently I am associated with HCL America, Inc, since Mar 2012. I started off my career with Tata Consultancy
Services Ltd, where I served for a long tenure of 7 years and 9 months. In between I was associated with
Mphasis Corporation for a period of 5 months.
Page 1 of 13
Resume Arijit Chakraborty
In my first assignment, I have worked primarily in the domain of financial needs of Agilent Technologies
•
International PVT Ltd. Involved in Requirements gathering/analysis, Design, Development, Testing and
Production Support for Agilent (GTT) Project.
Intermittently I was involved in a design and development assignment in BT, working as the development
•
lead for the module Billing Access Layer which shields the underlying complicacies of the Geneva billing
system. My role as a developer primarily involved requirement gathering, carry out feasibility study in
liaison with the component and E2E designers, and provide inputs to designer in determining modularity,
development and thorough unit testing.
From Sep 2006 till Sep 09 2009, I was working as the Production Support Lead for British Telecom Billing
•
and Payments Platform, positioned at onsite Cardiff, UK since 09.11.2006. My role demanded more of
techno managerial skills, attending/coordinating face to face meetings with the clients, problem solving
and decision making abilities and ability to debug application as well as resolving database performance
issues.
From Sep 14 2009 till Mar 2010, I worked as Solution Designer, leading the design and development team
•
of the BAL payment module. I was the design SPOC of the Manage Payment Capability, which
encapsulates every intricacies involved in the payment journey, including interfacing with PSP (Payment
Service Provider) to successful ledgering on the billing platform. Besides the technical expertise, my role
required thorough understanding of the payment systems and the associated complexities.
From Apr 2010 till Aug 13 2010, I lead the CIM module for the AT&T account of TCS. Besides leading the
•
offshore development team, I worked as the design and delivery SPOC for the module that aimed in
congregating customer address data across all lines of business of AT&T into one centralised enterprise
data warehouse.
From Aug 16 2010 to Jan 31 2011, I worked as the data architect and onsite lead for the Payment
•
Reconciliation and Reporting System for Cricket Communications, operating from San Diego, California.
Besides working on the data model my role also involved owning and compiling the system designs for the
ongoing and future CRs, managing the deliveries and also leading the production support activities from
onsite.
From Feb 2011 to Sep 2011, I am worked as the Development and Delivery Lead for one of the biggest
•
banking account of TCS, JP Morgan & Chase. My role as an onsite lead involved attending release
scoping meetings, capturing requirements, identification of changes, implementation and management of
the deliveries. So essentially my role spanned right from requirement gathering, development, unit testing
and validation of test cases, to the management and quality assurance of the overall deliveries (for both
onshore and offshore).
From Oct 2011 to Feb 2012, I worked as the Tech Lead for the development and delivery of an enterprise
•
application of the Investment Banking line of business for JP Morgan & Chase, based at Newport, NJ. My
role involved providing optimal business solutions, chalking out design, continuous interaction with clients
to gather requirements, perform database developments and also manage and streamline the deliveries of
the offshore development team.
Currently I am working as the Development & Maintenance Lead for the Clinical Data Repository
•
application of Merck & Co, Inc.’s clinical domain, based at Rahway, NJ. Besides debugging and resolving
business critical application and database performance issues and supervising a team of 9 members, my
responsibilities also requires owning several development assignments aimed towards application
enhancements and delivering the same with the best of my capability.
Organisation Month Year Of Joining Associated Till Designation
Page 2 of 13
Resume Arijit Chakraborty
HCL America, Inc Mar 2012 Till Date Technical Lead
Mphasis Corporation Oct 2011 Mar 2012 Project Lead
Tata Consultancy Services Ltd. Dec 2003 Sep 2011 Assistant Consultant
Qualification:
Degree and Date Institute Major and Specialization
Bachelor of Technology, 2003 Sikkim Manipal Institute Of Information Technology.
Technology
Higher Secondary (1999) Margaret (SN) High School Science
(W.B.C.H.S.E)
ICSE (1997) ST. Joseph’s Convent N.A
Client Site/Onsite Experience:
Client Deputed Location, Start Date (Mon, End Date (Mon, Duration
Country Year) Year)
Merck & Co, Inc. Rahway, New Jersey, Mar, 2012 Till Date On going
US
J.P. Morgan Chase & Co. Newport, New Oct, 2011 5 months
Feb, 2012
Jersey, US
J.P. Morgan Chase & Co. Chicago, Illinois, US Feb, 2011 Sep, 2011 8 months
Cricket Communications San Diego, Aug, 2010 Jan, 2011 6 months
California, US
British Telecommunications Cardiff, UK Sep, 2006 Sep, 2009 36 months
Agilent Technologies Gurgaon, India Mar, 2004 Sep, 2005 18 months
International PVT Ltd
Technology Proficiency:
Below is a list of important software products, tools and methods that I have worked with.
Computer Languages: Advanced PL SQL, UNIX Shell Scripting, JAVA, Transact SQL, C, C++
Page 3 of 13
Resume Arijit Chakraborty
Database: Oracle 9i, Oracle 10g (RAC), Microsoft SQL Server, Teradata
Front End Tools/Utilities: Visual Basic, Glade in Linux, HTML, D HTML, JAVA Script
Tools/Utilities: Toad, PL/SQL Developer, Microsoft Visual Source Safe 6.0, MS Office, SQL Navigator, OVSD
(Open View Service Desk – HP), Putty, AMDOCS Clarify, Teradata SQL Assistant, Eclipse
Platform
Other Proficiencies: Geneva/IRB Billing System, Oracle Advanced Queues, JAVA Spring and iBATIS Framework,
IBM MQ Series, Oracle XML DB, TRECS from Chesapeake Solution Systems,
DataStage
Operating Systems: Windows XP, HP UNIX
Project Summary:
The details of the various assignments that I have handled are listed here, in the reverse chronological order of the
period worked for.
Project MERCK Clinical Data Repository
Customer Merck & Co, Inc.
Employer HCL America, Inc.
Period 03 05 2012 to till date
Role Database Development & Maintenance Lead (Maintenance and Operations)
Rahway, NJ, USA
Location
Merck & Co., Inc. is one of the largest pharmaceutical companies in the world. Merck
Description
headquarters is located in Whitehouse Station, New Jersey. It is currently one of the
world's seven largest pharmaceutical companies by market capitalization and revenue.
The company describes itself as "a global research driven pharmaceutical company"
that "discovers, develops, manufactures and markets a broad range of innovative
products to improve human and animal health, directly and through its joint ventures".
The Clinical Data Repository is one of the most critical applications in the Merck
Clinical Vertical, designed based on industrial standards acceptable by the FDA and
other Pharmaceutical companies. The application has been conceived to hold patient
and clinical data, with feeds from the upstream systems. Several business translations
are applied to the data feed to transform the data to SDTM (Study Data Tabulation
Model) format, which is then published to CDR’s outbound systems to subsequently
publish reports for FDA’s verification.
Page 4 of 13
Resume Arijit Chakraborty
Design, develop and deliver application enhancements, and several generic
Responsibilities
components primarily on Oracle PL/SQL and UNIX, as stored
procedures/programs or standalone scripts.
Performance tuning of the existing PL SQL/SQL code.
Design and review data models pertaining to the requirements outlined. Compile
the most optimum and feasible design in terms of performance and maintenance,
after thorough analysis of the requirement.
Gather business process requirements, high level business model design,
business process re engineering.
In depth analysis of business critical issues encountered in the day to day
functioning.
Supervise a team of 9 members ensuring that the work is equally distributed and
each team member has got an important role to play within the teams activities.
Streamline and monitor the several routine processes of the team.
Engage the team in automating the recurring tasks/activities by coming up with
reusable components.
Attend and organising face to face meetings/con calls with clients and other
business stake holders.
Decide on the reporting formats and maintain and publish regular status reports.
Ensure program/deliverables meet standards and technical specifications and
perform technical analysis and component delivery.
Create technical specifications, process/workflow design, user acceptance test
planning and cut over planning.
Set up processes for monitoring the database health at regular intervals and
engage the application DBA in setting up relevant traps at database level so as to
raise alerts for any DB/system failures.
Solution Environment HP Unix, Windows XP, Oracle 11g, PL/SQL, J2EE, Eclipse Platform
Project JPMC Wholesale Customer Relationship Management
Customer J.P. Morgan Chase & Co.
Employer Mphasis Corporation
Period 10 03 2011 to 03 02 2012
Role Tech Lead (Database Development Lead & Solution Designer)
Newport, NJ, USA
Location
Page 5 of 13
Resume Arijit Chakraborty
J.P. Morgan Chase & Co. (JPMorgan Chase) is a financial holding company
Description
incorporated in 1968. The Company is a global financial services firm with operations in
over 50 countries. Its principal bank subsidiaries are JPMorgan Chase Bank in New
York, and Chase Manhattan Bank USA in Delaware. JPMorgan Chase's principal non
bank subsidiary is its investment bank, J.P. Morgan Securities Inc.
Touchpoint II has been conceived to be a single point reference for the
statistical data relevant to all types of meeting, events and activities
organized with the clients. The application provides features for the JPMC
associate to perform search on several criteria and pull out the aggregated
data for the underlying meeting, event and activity records. For each
event/activity/meeting arranged, a reward point is determined based on the
dimension and accordingly the final aggregate date is projected on the UI for
a give search criteria.
Engage actively in the implementation/development of newly scoped work items.
Responsibilities
Attend regular meetings/con calls with clients and vendors to derive the accurate
requirement
Provide inputs for the most optimum and feasible design in terms of performance
and maintenance after thorough analysis of the requirement
Plan and track deliveries, negotiate and obtain timescales from the client.
Manage review of test specs and ensure proper validation of subsequent test
results.
Liaise with client parties and close all open issues.
Manage and delegate work within the team and ensure highest level of delivery
standards.
Solution Environment HP Unix, Windows XP, Oracle 10g, PL/SQL, J2EE, Flex, Eclipse Platform
Project JPMC Wholesale Customer Relationship Management
Customer J.P. Morgan Chase & Co.
Employer TATA Consultancy Services LTD
Period 02 01 2011 to 09 30 2011
Role Database Development Lead (Delivery & Development Lead, Solution Designer)
Location Chicago, Illinois, USA
Page 6 of 13
Resume Arijit Chakraborty
J.P. Morgan Chase & Co. (JPMorgan Chase) is a financial holding company
Description
incorporated in 1968. The Company is a global financial services firm with operations in
over 50 countries. Its principal bank subsidiaries are JPMorgan Chase Bank in New
York, and Chase Manhattan Bank USA in Delaware. JPMorgan Chase's principal non
bank subsidiary is its investment bank, J.P. Morgan Securities Inc.
JPMC WCRM (Wholesale Customer Relationship Management) System has been
conceptualised to be the underlying core application, providing essential business
services to numerous interfacing front end applications. WCRM (Whole Sale Customer
Relationship Management) system is implemented using service oriented architecture
that can be leveraged by multiple LOBs via Web services, real time or scheduled batch
interfaces. Built on Oracle 10g database with RAC architecture, WCRM has several
JVMs designed to cater to specific consumer systems. WCRM primarily extends one
stop data management capabilities for all the distinct entities involved in the banking
domain, starting from clients, contacts, deals, products, activities and so on.
Responsibilities Attend regular meetings/con calls with clients and vendors to derive the accurate
requirement
Engage actively in the implementation/development of newly scoped work items.
Provide inputs for the most optimum and feasible design in terms of performance
and maintenance after thorough analysis of the requirement
Plan and track deliveries, negotiate and obtain timescales from the client.
Manage review of test specs and ensure proper validation of subsequent test
results.
Liaise with client parties and close all open issues.
Manage and delegate work within the team and ensure highest level of delivery
standards.
HP Unix, Windows XP, Oracle 10g, PL/SQL, J2EE, JAVA Springs and iBATIS
Solution Environment
Framework, Eclipse Platform
Project Cricket Payment TRECS System
Customer Cricket Communications
Employer TATA Consultancy Services LTD
Period 08 16 2010 to 01 31 2011
Role Onsite Lead (Data Architect, Solution Designer, Delivery & Production Support)
San Diego, California, USA
Location
Page 7 of 13
Resume Arijit Chakraborty
Cricket Communications is mobile wireless operating unit of Leap Wireless
Description
International, headquartered in San Diego, CA, serving more than 4 million customers
in more than 50 markets in 23 US states, with an objective to serve upwards of 9
million customers 2 years from now. It provides a simple, affordable wireless service
offering consumers and local businesses a flat rate unlimited service over the latest
technology, high quality, all digital CDMA2000 1X and 1xEV DO wireless network.
Cricket Payment Reconciliation system has been designed to automate the
reconciliation of all the customer payments received via multiple payment points and
vendors. It has been implemented using the TRECS application from Chesapeake
System Solutions. This project focuses primarily on reconciling the customer payment
data from various heterogeneous sources and automating the customised payment
reports.
Responsibilities Attend regular meetings/con calls with clients and vendors to derive the accurate
requirement
Design and review data models pertaining to the requirements outlined and assist
developers based at offshore in implementing the same.
Compile the most optimum and feasible design in terms of performance and
maintenance after thorough analysis of the requirement
Circulate the component design and data model across all stake holders and
arrange regular design walk through sessions for developers and other component
designers.
Plan and track deliveries, negotiate and obtain timescales from the client.
Manage review of test specs and ensure proper validation of subsequent test
results
Liaise with client parties and close all open issues.
Proactively monitor the operations of the production system and help in resolving
any live problems detected/reported.
Perform thorough analysis of any existing problem on the production system,
identify the root cause and design and lead the implementation of the proposed
resolution.
Manage and delegate work within the team and ensure highest level of delivery
standards.
HP Unix, Windows XP, Oracle 10g, Microsoft SQL Server, TRECS from Chesapeake
Solution Environment
System Solutions, IRB Billing System
Project AT&T CIM Re Design
Customer AT&T
Employer TATA Consultancy Services LTD
Period 04 01 2010 to 08 13 2010
Role Delivery and Design Lead
Location Kolkata, India
Page 8 of 13
Resume Arijit Chakraborty
AT&T Inc. is the largest provider of fixed telephony in the United States, and also
Description
provides various other services to the customers like Wireless, Wireline, Digital TV,
Broadband, Mobile etc. AT&T is the second largest provider of mobile telephony
service in the United States.
For each of the individual lines of business, the billing and customer information
management has been implemented on different systems.
CIM or Customer Information Management, as the name suggests, is targeted to
achieve a common centralised enterprise data warehousing system, which extracts
data from different Data Sources (DB tables, flat files, views etc), transforms the whole
data and finally load it on a Target Warehouse DB.
Responsibilities Attend regular meetings/con calls with clients to derive the accurate requirement
Compile the most optimum and feasible design in terms of performance and
maintenance after thorough analysis of the requirement
Circulate the component design document across all stake holders and arrange
regular design walk through sessions for developers and other component
designers.
Assist developer in implementation and perform thorough code review.
Plan and track deliveries, negotiate and obtain timescales from the client.
Manage review of test specs and ensure proper validation of subsequent test
results
Liaise with client parties and close all open issues.
Manage and delegate work within the team and ensure highest level of delivery
standards.
HP Unix, Windows 2000 Professional, Oracle 10g, Teradata, DataStage
Solution Environment
Project BT Billing – Billing Access Layer (BAL) Design
Customer British Telecom
Employer TATA Consultancy Services LTD
Period 09 14 2009 to 03 31 2010
Role Solution Design Lead (Design Lead of the BAL Payment Module)
Location Kolkata, India
BT Group is one of Europe's leading providers of telecommunications services. Billing
Description
Access Layer has been conceived to be a layer over BT’s entire billing platform, hiding
the underlying complicacies of billing system from all the interfacing systems and
exposing n number of capabilities to be invoked from CRM.
BAL Manage payment module as the name suggest is strictly to do with the payment
journey, right from authorising of the card payments on banks via the PSP, top
ledgering of the payments against the customer’s account on billing.
Page 9 of 13
Resume Arijit Chakraborty
Requirement gathering, carry out feasibility study in liaison with the E2E designers
Responsibilities
Suggest most optimum and feasible solution on thorough analysis of the
requirement and the E2E design
Perform data modelling to achieve a normalised database design, best suitable for
a OLTP system
Compilation of the component design document and arrange design walk through
sessions for developers and other component designers.
Assist developer in implementation and perform thorough code review.
Test spec compilation and validation of test results
Liaise with external parties and close all open issues.
Thorough functionality as well as performance review of the application codes.
Solution Environment HP Unix, Windows 2000 Professional, Oracle 10g (RAC), Geneva/IRB Billing System
Project BT Billing – Billing Access Layer (BAL) Jeopardy Management
British Telecom
Customer
TATA Consultancy Services LTD
Employer
09 11 2006 to 09 09 2009
Period
Production Support Lead/Data Architect
Role
Cardiff, United Kingdom
Location
BT Group is one of Europe's leading providers of telecommunications services. Billing
Description
Access Layer has been conceived to be a layer over BT’s entire billing platform, hiding
the underlying complicacies of billing system from all the interfacing systems. As such
BAL has been designed to be the single entry point to BT’s billing domain,
encapsulating 100s of capabilities within, that enables CRM systems to make use of the
BAL exposed operations and make changes on the billing system.
The BAL Jeopardy Team is essentially an effective cushion in between the BAL ASGs
and the delivery team. Primary scope of the BAL Jeopardy Team involves detailed
analysis of business critical scenarios encountered in the day to day functioning of the
BAL production instance.
Primary scope of the BAL Jeopardy Team involves detailed analysis of business critical
scenarios encountered in the day to day functioning of the BAL production instance.
In depth analysis of business critical billing issues encountered in the day to day
Responsibilities
functioning of the BAL production instance.
Business feasibility study of any changes proposed from operations, taking into
consideration the entire end to end stack
Supervise a team of 7 members ensuring that the work is equally distributed and
each team member has got an important role to play within the teams activities.
Streamline and monitor the several routine processes of the team.
Engage the team in automating the recurring tasks/activities by coming up with
reusable components.
Page 10 of 13
Resume Arijit Chakraborty
Decide on the reporting formats and maintain and publish regular status reports.
Design and assist in developing several generic components primarily on Oracle as
stored procedures/programs or standalone scripts.
Attend and organising face to face meetings/con calls with clients and other
business stake holders.
Set up processes for monitoring the database health at regular intervals and
engage the application DBA in setting up relevant traps at database level so as to
raise alerts for any db/system failures.
Co ordinate and manage deployment activities.
Assist team in debugging technical issues reported on the application as well as on
the database front, and for issues identified to be relevant to the database that
stretches beyond the scope of the application, involve the 3rd line production DBA
team.
HP Unix, Windows 2000 Professional, Oracle 9i, Oracle 10g (RAC), Geneva/IRB Billing
Solution Environment
System
Project BT Billing – Billing Access Layer Development
British Telecom
Customer
Employer TATA Consultancy Services LTD
09 07 2005 to 09 08 2006
Period
Role Designer and Database Developer
Kolkata, India
Location
Description The Billing Access Layer (BAL) which is predominantly a layer over the Geneva Billing
system is an application that shields other systems from the complexities of the
underlying billing system. The development of BAL Phase II aims in being the single
entry point into the Billing and Payments Domain for all transactional and most batch
interactions. This layer is being developed on a resilient platform to ensure that a
response is available to all calling platforms so that the Billing & Payments Platform
may provide the Capabilities and Operations, which are used, by other platforms to fulfil
their requirements. BAL has been designed to be the single entry point into billing. The
calling system does not need to know which specific Retail, Wholesale, Global, ASD, or
ICT billing instance is being used. BAL aims to provide an XML based interface, which
hides the internals of billing from the outside world.
Responsibilities Requirement gathering and feasibility study in liaison with the component and
E2E designers
Provide inputs to designer in determining modularity
Development and thorough unit testing
Solution Environment HP Unix, Oracle 9i, Geneva/IRB Billing System
Page 11 of 13
Resume Arijit Chakraborty
Project AGILENT – TRADE LOGISTICS (GTT)
Agilent Technologies International PVT Ltd
Customer
TATA Consultancy Services LTD
Employer
03 08 2004 to 09 06 2005
Period
Team Member In Onsite Production Support
Role
Gurgaon, India
Location
Agilent CFS (Corporate Functions Solutions) comprises of many towers including GT
Description
(Global Trade). The Agilent GTT Tower further comprises of a group of applications
that provide logistic and Administration services to Agilent departments and
businesses. ESSEC, WWClass and RPL are few of such critical applications. They
provide global, real time and fully integrated support system providing complete
operational functionality. The project involves providing support throughout the year in
Asia Pacific, US and European regions. The application involves maintaining the
automated licensing and part classification system of Agilent. The application is based
on Client/Server architecture. The server is HP 3000 UNIX system and the client is a
PC based application build in Oracle Forms.
Responsibilities Investigate customer complains as routed from the helpdesks.
Proactively monitor system health and implement vets/traps as and where
applicable for automating the system health checks.
For any changes requested, carry out requirement gathering, discuss design
with team lead, develop and then perform thorough unit testing.
Attend con calls with clients when required, to provide further clarity on any
ongoing issues.
Solution Environment HP Unix, Windows 2000 Professional, Oracle 9i
Training/Continuing Education Summary:
Program or Course Coverage Dates
TCS Initial Learning Program Foreign Language (French), soft skills and 12 29 2003 to
software engineering along with technologies 03 05 2004
like C, Pro *C, C++ and UNIX.
TCS Internal Training on Oracle 9i DBA Overview of Oracle 9i DBA Fundamentals 11 24 2004
Certification in VB from Aptech Solutions Visual Basic Jan 2002
TCS Internal Training on Teradata Architecture and Teradata Jun 2010
Teradata SQL
Extra Curricular Activities:
Page 12 of 13
Resume Arijit Chakraborty
Taken active part in several dramas/skits in the school and college days and have directed plays in college.
•
I hereby declare that the information provided above is true and accurate
to the best of my knowledge.
Arijit Chakraborty
Page 13 of 13
Contact this candidate