Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Profile & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Ankit Chakraborty
Email: ankitchakraborty@gmail.com
Mobile: (001) 415-885-8176
DOB:
|
Nationality: Indian
Current Location: Rahway, New Jersey
Visa Status: H1-B valid until Sep
2014
|
Career Profile:
·
Software
engineer having in total 8 years 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 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.
·
Proficient in Microsoft SQL Server and
T-SQL.
·
Having data warehousing concepts, and have
lead and delivered a BI solution in DataStage.
·
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:
I was
associated with Tata Consultancy Services Ltd
for the last 7 years and 9 months, that being my first job. Currently I
am associated with Mphasis Corporation
for the last 3 months.
·
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
·
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).
·
Currently
I am working 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
involves 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.
Organisation
|
Month-Year Of Joining
|
Associated Till
|
Designation
|
Mphasis Corporation
|
Oct-2011
|
Till Date
|
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 Technology
|
Information Technology.
|
Higher Secondary (1999)
|
Margaret (SN) High School (W.B.C.H.S.E)
|
Science
|
ICSE (1997)
|
N.A
|
Client Side/Onsite Experience:
Client
|
Deputed Location, Country
|
Start Date (Mon, Year)
|
End Date (Mon, Year)
|
Duration
|
J.P. Morgan Chase & Co.
|
Newport, New Jersey, US
|
Oct, 2011
|
Till Date
|
Ongoing
|
J.P. Morgan Chase & Co.
|
Feb, 2011
|
Sep, 2011
|
8 months
|
|
Cricket Communications
|
Aug, 2010
|
Jan, 2011
|
6 months
|
|
British Telecommunications
|
Sep, 2006
|
Sep, 2009
|
36 months
|
|
Agilent Technologies
International PVT Ltd
|
Mar, 2004
|
Sep, 2005
|
18 months
|
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++
Database: Oracle 9i, Oracle 10g
(RAC), Microsoft SQL Server, Teradata
Front End
Tools/Utilities: Visual Basic, Glade in Linux,
L, 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 in TCS Ltd are listed
here, in the reverse chronological order of the period worked for.
Project
|
JPMC IB
Touchpoint Solutions
|
Customer
|
J.P. Morgan Chase & Co.
|
Employer
|
Mphasis Corporation
|
Period
|
10-03-2011 to till date
|
Role
|
Tech Lead (Development Lead & Solution Designer)
|
Location
|
Newport, NJ, USA
|
Description
|
J.P. Morgan Chase &
Co. (JPMorgan Chase) is a financial holding company 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
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.
|
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.
|
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
|
Onsite Lead (Delivery & Development Lead, Solution Designer)
|
Location
|
|
Description
|
J.P. Morgan Chase & Co.
(JPMorgan Chase) is a financial holding company 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
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.
|
Solution
Environment
|
HP Unix, Windows XP, Oracle 10g, PL/SQL, J2EE, JAVA
Springs and iBATIS Framework, Eclipse
Platform
|
Project
|
Cricket Payment
TRECS System
|
Customer
|
Cricket Communications
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Onsite Lead (Data Architect, Solution Designer, Delivery &
Production Support)
|
Location
|
|
Description
|
Cricket Communications is mobile
wireless operating unit of Leap Wireless International, headquartered in
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.
|
Solution
Environment
|
HP Unix, Windows XP,
Oracle 10g, Microsoft SQL Server, TRECS from Chesapeake System Solutions, IRB
Billing System
|
Project
|
AT&T CIM
Re-Design
|
Customer
|
AT&T
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Delivery and Design Lead
|
Location
|
|
Description
|
AT&T Inc.
is the largest provider of fixed telephony in the
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.
|
Solution
Environment
|
HP Unix, Windows 2000
Professional, Oracle 10g, Teradata, DataStage
|
Project
|
BT Billing –
Billing Access Layer (BAL) Design
|
Customer
|
British Telecom
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Solution Design Lead (Design Lead of the BAL Payment Module)
|
Location
|
|
Description
|
BT Group is one
of
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.
|
Responsibilities
|
-
Requirement
gathering, carry out feasibility study in liaison with the E2E designers
-
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
|
BT
Billing – Billing Access Layer (BAL) Jeopardy Management
|
|
Customer
|
British Telecom
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Production Support Lead
|
Location
|
|
Description
|
BT Group is one of
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.
|
Responsibilities
|
-
In-depth
analysis of business critical billing issues encountered
in the day to day 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.
-
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.
|
Solution
Environment
|
HP Unix, Windows 2000 Professional,
Oracle 9i, Oracle 10g (RAC), Geneva/IRB Billing System
|
Project
|
|
Customer
|
British Telecom
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Designer and Lead Developer
|
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
|
Project
|
AGILENT – TRADE LOGISTICS (GTT)
|
Customer
|
Agilent Technologies International PVT Ltd
|
Employer
|
TATA Consultancy Services LTD
|
Period
|
|
Role
|
Team Member In Onsite Production Support
|
Location
|
|
Description
|
Agilent
CFS (Corporate Functions Solutions) comprises of many towers including GT
(Global Trade). The
|
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 software engineering along
with technologies like C, Pro *C, C++ and UNIX.
|
|
TCS Internal Training on Oracle 9i DBA
|
Overview of Oracle 9i DBA Fundamentals
|
|
Certification in VB from Aptech Solutions
|
Visual Basic
|
Jan 2002
|
TCS Internal Training on Teradata Architecture and Teradata SQL
|
Teradata
|
Jun 2010
|
Extra Curricular Activities:
- 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.
Aakit
Chakraborty
Download Resume Format
0 comments:
Post a Comment