Business Analyst

ABHISHEK KARMAKAR

Mobile: 080******** ( E-Mail: ********.*******@*****.***

Business Analyst

Strengthening Business Opportunity through Strategic Technology Planning,

Enterprise Roadmaps, & Execution

> Currently working with Tata Consultancy Services, Kolkata as Business

Analyst involving

> Proven expertise in driving business requirements, performing gap

analysis and designing and documenting application architecture for

complex IT projects

> Highly adept in facilitating client interaction management for eliciting

and clarifying project requirement, ability to work seamlessly with

Cross-Functional Team and designing and implementing tests of Processes

> An Oracle certified expert SQL Developer having nearly 4 years of

experience in advanced PL/SQL programming handling complex and high-

volume data for different IT projects

> Bringing the best of both worlds - one having in-depth UK Insurance

knowledge as a Functional Test Analyst and another as an ETL Analyst

which involves analysing large volumes of legacy data-set, data

cleansing, transformation and finally load in client schema

> Excellent proficiency in Performance Tuning Oracle Database augmented by

the prior experience in HP LoadRunner

> Experience of installing, configuring, testing Hadoop ecosystem

components; capable of processing large sets of structured, semi-

structured and unstructured data

> Strong communication, collaboration & team building skills with

proficiency in grasping new technical concepts quickly

Key Accomplishments

> Proven and verifiable record of displaying excellent technical

superiority as a Technical Lead for building and implementing a financial

reporting application ecosystem and database over the existing TCS

proprietary BaNCS financial solution suite

> As a Data Migration Analyst successfully spearheaded two large-scale UK

Life and Pensions administration systems, delivering on time and within

budget and with zero post-implementation issues or corporate incidents

> Accredited with back to back 'Best Team Award' by TCS on Jul'14 and

Oct'13 respectively, for displaying technical excellence and team

management skills

> Received 'On the Spot' award on Feb'13 award for stellar performance as

an ETL Developer

> Handpicked among the pool of 10 to work as the sole Business Testing

analyst for Pensions and Annuity module for accomplishing User Acceptance

Test for a large scale and fast-paced Transformation Program spanning

from Aug'10 to Nov'11

> Holds the distinction of being the 6th Best Team in SQL Sep'13 coding

challenge which was held across all TCS

> Awarded with Service and Commitment Award by TCS on Sep'07 and Sept'12

Areas of Exposure

- Big Data Technologies like Cloudera CDH, HDFS, MapReduce in Java

- Hands on knowledge of setting up Single-Node Hadoop Cluster on Linux

- Excellent Knowledge of key Hadoop technologies as - Pig, HIVE and

Impala

Skills Set

Technical

Programming Languages : PL/SQL, UNIX Shell Scripting, R Programming

language, Core JAVA

Tools : Oracle Warehouse Builder - 9, PUTTY, PL/SQL

Developer, HP Quality Centre, HP Load Runner,

HP Quick Test

Professional, GIT, GITHUB, RStudio

Software & OS : MS Office, Windows XP/Vista/7, Linux

Databases : Oracle 10g, Oracle OWB, HP-Unix 11i, Oracle 9i

Functional

? Process Management ? Project Management ?

Reporting & Documentation

? Process Management ? Client Relationship Management

? Resource / Team Management

Career Contour

Since Sep'07 with Tata Consultancy Services, Kolkata

Career Path

- Nov'07-Nov'08 ASE-T (Assistant System Engineer-Trainee) on Nov

2007

- Nov'08-Oct'09 ASE (Assistant System Engineer)

- Oct'09-Oct'11 System Engineer

- Oct'11-Oct'14 IT Analyst

- Oct'14-Till Date Assistant Consultant

Key Projects Handled

Project: FP Corporate Data Migration and Valuation Reporting

Duration: Jun'14-Till Date

Client: Friends Life Group Limited

Role(s): Business Analyst; Technical Lead

Tools: Oracle 10g, PL/SQL Developer, Oracle Warehouse Builder 9, PUTTY

Description: The objective of carrying out the BaNCS Transformation of FP

to configure & customize the TCS BaNCS Insurance product and migrate data

from the legacy systems onto Diligenta's in-house and proprietary database.

Working in a techno-functional role of requirement gathering from source

data, end-to-end designing ETL structure on Oracle Warehouse Builder,

process flow deployment and run. Tuning & optimizing the ETL code &

mappings developed using OWB at various stages. Designing & developing MI

reports like month end valuation report and interface file generation for

LinkPlus, a 3rd party reporting tool of FL International.

Project: CEB Data Migration

Duration: Feb'13-May'14

Client: Phoenix Group Services

Role(s): Technical Team Lead; ETL Developer

Tools: Oracle 10g, PL/SQL Developer, Oracle Warehouse Builder 9, PUTTY

Description: It was aimed at carrying out BaNCS Transformation of CEB to

configure & customize the TCS BaNCS Insurance (TCS BaNCS) product & migrate

data from the Capita Hartshead (CHH) legacy systems onto TCS BaNCS. Handled

the end-to-end design & maintenance of the policy and claim administration

data-flow through an ETL process from a legacy flat-file data to a TCS

BaNCS data-model on an Oracle database. Designed & developed various

automation processes like OWB mapping deployment & process flow deployment

of an end-to-end migration run. Conducted data quality analysis;

coordinated with the client for discrepant legacy data.

Project: FIS-ALIS Data Migration

Duration: Mar'12-Jan'13

Tools: Oracle 10g, PL/SQL Developer, Oracle Warehouse Builder 9, PUTTY

Client: Phoenix Group Services

Role(s): ETL developer

Description: It was established to deliver significant business & IT

benefits to Diligenta through the rationalization of the inherited PHOENIX

application portfolio and its associated business process improvements.

Managed end-to-end development & maintenance of claim main and satellite

administration system data-migration through various ETL stages.

Project: D2R2 Performance Testing for the Diligenta Transformation Program

Duration: Nov'11-Mar'12

Tools: Oracle 10g, HP Load Runner, PL/SQL

Description: Involved as Team Lead in identifying & scripting new

scenarios; identified critical performance snags through performance

testing appropriate benchmark and testing parameters. Carried out

performance testing benchmark timing achieved well before delivery

deadline.

Project: D2B Functional Testing for the Diligenta Transformation Program

Duration: Jan'09-Oct'11

Tools: Oracle 10g, PL/SQL, Quick Test Professional

Description: Involved as the sole functional tester of Annuity LoB for

Phoenix Group Plc. Job description include - system testing, unit testing,

specifying business use cases and writing test scripts and expected result, defect management, regression testing via automated test tool QTP.

Project: AEGON UK

Duration: Jun'08-Dec'08

Tools: METACOBOL, Datacom DB, IDEAL, CICS and JCL

Description: The objective of this project was to provide offshore & onsite

consulting services to AEGON UK (AUK) in the areas like development of new

systems, enhancement and maintenance of the existing systems, conversion of

the existing systems, if required, any other mutually agreed services.

Involved in development/ enhancement of a new application; oversaw

operations of code review & prepared unit test plan, requirement/technical

specification; maintained proper document for each development/ enhancement

task.

Training

> Attended TCS - ILP training at TCS, Greater Noida (Sep'07-Oct'07)

> Information Security Certification(TCS Internal)

> Oracle Certified Expert on Oracle Database SQL

> Currently pursuing Cloudera Certified Specialist in Apache HBase

Academia

> B.Tech. (Hons.) in Electrical Engineering from National Institute of

Technology, Jamshedpur in 2007. (GPA 8.21)

> AISSCE Exam school Topper in Delhi Public School, Farakka

Personal Dossier

Date of Birth : 17th November 1985

Languages : English, Hindi, Bengali

Address : Flat 211, Vanshee Eldorado, Marathahalli, Outer Ring Road,

Bangalore - 56

Location Preference: Bangalore

Contact this candidate