SANJOY KUMAR KARMAKAR
Mobile: 972-***-**** ~ E-Mail: ***************@*******.***
Seeking Technical assignments in Software Development/ Analysis/
Designing/Testing in IT sector.
PROFILE SNAPSHOT
. Over 15 years of experience in pure IT services organization for Software
Delivery, Software Development, Software Testing (Manual & Automation),
Quality Assurance, Project Management in IT sector for different clients
in USA and Europe.
. Distinction of having knowledge in Banking and Healthcare payer segment
. Domain expertise in end-to-end design and development of software
products from requirement analysis to system study, designing, coding
testing, de-bugging, documentation and implementation.
. Vast knowledge in Legacy Modernization projects for the whole SDLC.
. Adroit at preparation of test documentation, test plans, test scenarios,
test cases and familiar with testing tools like Quality Centre, Xpeditor, Vantage YR2000, etc.
. Skilful in Software Testing Life Cycle & performed various testing
following QA standards as per project requirement and having sound
knowledge in Software testing estimation process.
. Extensive knowledge of data warehouse testing procedures, data
transformation stage, and data storage systems. Well versed in data
warehouse architecture, data modeling, and ETL process
. Adept in understanding the technical & functional specifications as well
as guiding efforts towards post-implementation, enhancement and
maintenance support to clients for application.
. Comprehensive experience in technical solution architecting and
conceptualization for enterprise wide IT solutions / application
development using with alignment of business/information systems;
effective in delivering technology-driven / enterprise solutions using
cutting edge technologies
. Vast knowledge in software designing for Software Development and
Maintenance projects
. Well versed with Mainframe, MVS, SQL,DB2,Oracle, IMS DB/DC, C' Language
as well as VB script and QTP
. Demonstrated abilities in comprehending new technologies with ease and
managing vendor based products and production support
. Exemplary communication, relationship management, analytical and
organizational skills
CORE COMPETENCIES
Technical:
Operating Systems : IBM ES-9000, IBM S-390, Windows XP
Programming Languages/Processes : Cobol, JCL, DB2, IMS DB, IMS DC,
Easytrieve,, 'C',MS Quick Basic,
Data Ware house and ETL Process
Databases : DB2, IMS, Tablebase
Tools : QMF, Fileaid, Quality Center, Xpediter,
Endevor, QTP
Domain : Healthcare, Finance, Insurance, Telecom,
Credit Card
Functional:
Testing / Quality Assurance Technical Management Team
Management
Software Development Software Designing & Maintenance
Client Servicing
ORGANISATIONAL EXPERIENCE
Since Mar'03 with Dell Services (Formerly Perot Systems)
Highlights:
. Functioned in Banking, Healthcare, Insurance and worked majorly in
Mainframe Technology
. Efficiently handled a team of 20 members in maintenance role
. Successfully managed design of the software & projects
PREVIOUS EXPEREINCE
Sep'02 - Feb'03 with RS Software for the client Scottish Widows, Scotland
as Technical Lead role
Jan'97 - Feb'03 with RS Software Pvt Limited using Mainframe and other
Technology for clients in USA and Europe .
Highlights:
. Worked as Individual Contributor and Team Lead - Onsite and Offshore
. Worked at onsite in different Software Development, Maintenance and
Support projects for clients like Visa USA, Scottish Widows Bank of
Ireland etc.
PROFESSIONAL ENHANCEMENTS
. Completed QTP Automation Testing Course.
. Certified in ITIL Foundation Course in 2012
. 3 months Course in SAP SD Module from an Institute in Bangalore, 2010-
2011
. Diploma in Computer Application, 1989 - 1990
. Certificate on 'C' language programming in 1993
. Training on MVS/ESA (IBM S 390 AND IBM ES 9000), JCL, VSAM, DB2, CICS,
ISPF, VS COBOL-II, and Quality in 1997
. 3 days course on Project management, PMI in USA
. Passed HIPPA exam for Healthcare
. Training on Healthcare
EDUCATION
. Diploma in Computer Application, Computer Bhawan, Kalyani,West
Bengal,India,1990, 87%.
. Post Graduation in Science (M. Sc.), University of Kalyani, West Bengal,
1988, 64.3%.
. Bachelors in Science - B. Sc. (Hons. in Mathematics), University of
Kalyani, West Bengal, 1986, 61.2%.
PERSONAL DETAILS
Address : 1111 Newchester Dr, Roanoke,Tx-76262
Linguistic Abilities : English, Hindi & Bengali
USA Visa- Applied renewal for EAD .
Refer Annexure for Project Details:
Annexure:
Projects Executed:
Title: Test Process Assessment, Bangalore
Tenure: Oct'12 - Dec'12
Client: Experian, UK - Bangalore,
Role: Test Process Consultant
. Experian is the leading global information services company who helps
businesses to manage credit risk, prevent fraud, target marketing offers
and automate decision making
. Experian also helps individuals to check their credit report and credit
score, and protect against identity theft
. This particular project is to assess the test processes of 7 modules of a
product used by Experian customers
Deliverables:
. Reviewing test requirements and preparing questionnaire for assessing
test process
. Functioning on assessment of test processes and working to redefine QA
process as per client's requirement
Project: CCPRS- Legacy Modernization Project and Support (USA)
(MAY'08 - OCT'12)
Client: Mckesson, USA - Carrollton, TX, USA, Role:
Project Manager /Technical Manager
Platform:
. MVS/ESA, COBOL, SQL, DB2, IMS DB & DC, DB2, CICS. Tools: Xpediter,
Endevor, Fileaid and Quality Centre
Brief:
. Maintenance and production support of CMS application (Contract
Management System ) for McKesson
. Support on all requirements for the legacy modernization
Deliverables:
. This is part of legacy modernization project. Main objective of this
project was to migrate data including EDI data from mainframe to SAP
. The tasks involved were Analysis, design, coding and testing new programs
to migrate data from mainframe to SAP
. Other part was Maintenance and production support of CMS application
(Contract Management system) for McKesson
. Handled the Project, Understanding client's requirement, assigning work
to team members at offshore and deliver to client. Involved in day to day
CMS application maintenance as per business requirement. Functioned on
24x7 production support team for CMS application to resolve any
production issue meeting the SLA
. Conducted the status meetings and send the Status Report (Daily, Weekly
etc.) to the client
Project: MORE - Marketing Optimization Revenue Engine for Bank of
America
Tenure: Oct'06 - Apr'08
Client: Bank of America, USA,
Role: Individual Contributor at client's site in Dallas, USA
Platform:
. MVS/ESA, COBOL, SQL, DB2, IMS DB & DC, DB2, CICS, Tablebase / Tools:
Xpediter, Endevor, Fileaid.
Brief:
. Main objective of this project is to expand several key card marketing
capabilities that will drive additional revenue and bridge a competitive
gap
Project: Application Development & Maintenance Project
Tenure: Mar'03 - May'06
Client: Blue Cross Blue Shield of Rhode Island, USA,
Role: Onsite Coordinator, Transition Manager, SME, QA Manager
(Subscriber Id Expansion Project)
Platform:
. MVS/ESA, COBOL, SQL, DB2, IMS DB & DC, DB2, CICS, Tablebase / Tools:
Xpediter, BTS, Fileaid.
Brief:
. Main objective of this project is initially to plan for transition and
execute. Assure all testing phases are completed as expected. Later
provided maintenance and production support (24x7 hrs incident
resolutions) for the different applications in Membership, Claims,
Provider and ITS (Inter-Plan Teleprocessing Services)
. From Mar'03 to Jul'03 completely worked as QA Manager for Subscriber Id
Expansion Project where main intent was to expand the current Subscriber
ID field of 12 characters and/or a check digit to 13 significant
characters to accommodate NEMCI requirements as defined by Anthem
Project: Pension Benefit Statement and Unitised Annuities Yearly
Statement
Tenure: Augr'02 - Feb'03
Client: Scottish Widows, Scotland Role:
Technical Lead
Platform:
. MVS/ESA, COBOL, SQL, DB2, IMS DB / Tools: Xpediter, Fileaid, Data
Manager.
Brief:
. For new formatted Benefit Statement the main three goals were Data
Gathering, Produce a new formatted Benefit Statement and reformat the
layout of the Yearly Statement for Unitised Annuities.
Project: MCA-Multi-Channel Architecture
Tenure: Sept '00- Aug'02, Client: Bank of Ireland, Dublin,
Role: Individual Contributor
Platform:
. MVS/ESA, COBOL, SQL, DB2, IMS DB / Tools: Xpediter, Fileaid, Endevor.
Brief:
. It was completely a development and Testing Project based on rapid
deployment and reuse of core business application function across an
increasing number of delivery channels and started with B365 phone
application. Later we provided maintenance and support.
Project: VISA Y2K Conversion and Testing
Tenure: Mar '97- Aug'00, Client: VISA, San Mateo, USA,
Role: Individual Contributor/Technical Lead
Platform:
. MVS/ESA, COBOL, SQL, DB2 / Tools: Xpediter, Fileaid,Endevor,Vantage
YR2000.
Brief:
. It was completely a Y2K conversion and testing project followed by
Maintenance and Support.