Summary

• Over ** years of IT Experience in Business Intelligence, Data Integration and Data Migration for Banking and Insurance domain.

• Worked closely with Business Users during Requirement Gathering, Designing, Development and Testing Phases.

• Capable of understanding business requirements and translating into technical requirements.

• A keen understanding of Business Intelligence Tools and Technology, ability to understand Business processes.

• Proficient in handling the calls with the Users and capable of closing the issues on time.

• Dedicated and responsible for deliverables as per timelines given.

• Keen interest towards on learning and development.

• Do possess thorough analytical skills and can blend well with new technologies in a very short span of time.

• Dedicated, hardworking, responsible and sharp in understanding the requirements

• Excellent interpersonal skills and leadership abilities.

• Good team player with excellent communication and problem-solving skills.

• Has the motivation to take independent responsibility as well as ability to contribute and be a productive team member.

Key Domain and Technical Knowledge

• Domain : Banking, Insurance and health care domains.

• Technical :

Languages Used: C, C++, Java, Python.

Database Used: IBM DB2, SQL Server 2005, 2008, Greenplum, Amazon Aurora.

Operating Systems: HP-UNIX, Windows Server 2003, Windows Server 2008..

Tools & Utilities: SQL Client, Amazon EMR, Amazon S3, Amazon Glue, Amazon Athena.

Business Intelligence / ETL Tool: Informatica Powercenter 9.6, Informatica BDM, Informatica Intelligent Cloud Services (IICS) and Informatica 10.4

Reporting Tool: Cognos Report Studio 10.0, SSRS and BO.

Scheduling tools: Autosys.

Big Data: Sqoop, Pig, HDFS, Spark, Oozie, MapReduce.

Middleware: IBM Message Queues, Attunity, Oracle Golden Gate. Academic Qualification

Title of the Degree with

Branch College / University

Year of

Passing

B.Tech In ECE ITME / WBUT 2011

XII

Denobili School /

CISCE 2007

X

Denobili School /

CISCE 2005

Somnath Banerjee

Contact No : +1-608-***-**** Current Location : Madison – Wisconsin USA Email id : ads1nt@r.postjobfree.com Role Designation and Job Level : Technology Lead - US Certifications / Professional Awards:

No. Name of Institution Diploma or Certificate Year of Completion 1 IBM Cognos Developer 2013

Foreign Languages known:

• English

Total Work Experience: 10.7 Years (Aug,2011 to Till Date) Name of the

company Designation

Address of the

employer From To Duration

Infosys Limited

Technology

Lead

44 Infosys Avenue,

Electronics City,

Hosur Road

Bangalore 560100

India

April

23,

2018 Till date 4

Cognizant

Technology Solutions

Associate -

Projects

Plot GN-34/3, Salt

Lake Electronics

Complex,

Salt Lake Sec V,

Kolkata 700091,

West Bengal- India

October

20,

2014

April

20,

2018 3.4

Infosys Limited

Senior System

Engineer

44 Infosys Avenue,

Electronics City,

Hosur Road

Bangalore 560100

India

August

1, 2011

October

16,

2014 4.8

PROJECT PROFILE # 1

Project Title: - BIC Re-Design Informatica powercenter to Cloud Migration & Informatica Intelligent Cloud Services and support

Duration:- April 2018- Till Date

Product / Tool:- Informatica Intelligent Cloud Services, Informatica Powercenter 9.6, Informatica BDM, AWS, Python

Operating Systems: -Unix

PROJECT DESCRIPTION:

The objective of this project is to build Financial and Regulatory Data Warehouse and Advance Data Warehouse using ETL and Big data technology cloud tools to load data into Amazon Aurora database to address all Business Intelligence and Business Process requirements, reduce manual activities, improve accuracy of data, automate calculations and reporting. Also, build frameworks to load data into data lake, data transformation and knowledge layers using Amazon service provided tools. This project involves requirements analysis, design, build, testing, implementation and support. The system will be developed in multiple releases using the agile development methodology. ROLES AND RESPONSIBILITIES:

• Production Support, Incident Management and Problem Management.

• Prepare estimations, release plan and road map for future releases.

• Solution road map for future growth, process architecture and mapping of DR Functions.

• Working with functional team to get business requirement understanding.

• Requirement’s elicitation and translation to technical specifications.

• Provide knowledge transfer to new team member, prepare and review support document.

• Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products.

• Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.

• Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.

• Perform performance optimizations on Shell Scripts.

• Prepare estimations, release plan and road map for future releases. PROJECT PROFILE # 2

Project Title: - BigData Migration

Duration:- Oct, 2014- April,2018

Product / Tool:-Informatica 10, Informatica BDM & BO Operating Systems: -Unix

PROJECT DESCRIPTION:

Client intends to migrate away from the existing traditional Data warehouse model to a Data lake for analytics and business development. As part of this project, all the existing Informatica PowerCenter code would be rewritten using Informatica BDM and the data would move to a new Hadoop cluster. Involved in the development of this data lake, the data migration and end-to-end rewrite of all existing ETL and Cobol code.

ROLES AND RESPONSIBILITIES:

• Implementing unsupported transformations in BDM and working around the limitations of Hive for Data ingestion using Informatica BDM.

• Developing necessary workflows, scheduling then, and the re-development of all existing Cobol Code.

• Unit testing, code comparison and Integration testing would be carried out in multiple phases spread across subject areas.

• Migration of the developed components to higher environments after unit testing through version tool.

• Coordinating and working with testing team / Client during QA, SIT and UAT to debug and fix the data migration and integration components.

PROJECT PROFILE # 3

Project Title: - L&C Implementation IC

Duration: - Oct, 2013- Oct, 2014

Product / Tool: - Callidus Cloud, Informatica cloud, Informatica Powercenter 9.6, BO, Cognos 10 & SSIS Operating Systems: -Unix

PROJECT DESCRIPTION:

Customer will use the Licensing and Commissions software (“Callidus Solution”) from Callidus Software Inc. (“Callidus Solution Vendor”) as a consolidated licensing and commissions platform for all producers of the business units listed below (the “Project” or “Program”, whether capitalized or not). The Producer information were migrated from the legacy system to cloud and various policy admin systems were integrated with callidus for commission, bonus calculation and payout. ROLES AND RESPONSIBILITIES:

• Working with functional team to get business requirement understanding.

• Analyzing business requirements and performing low-level designing for data migration and data integration components.

• Walk-through low-level design and implementation strategy with Client through Webex.

• Developing the ETL components for data migration and data integration.

• Migration of the developed components to higher environments after unit testing through version tool.

• Coordinating and working with testing team / Client during QA, SIT and UAT to debug and fix the data migration and integration components.

• Create various complex reports using BO & Cognos 10

• Enhance/modify existing reports by creating new Parameters, Formulas etc,

• Evaluate each Report request, verifying whether the request may already be answered in another report, whether the request is valid, the possibility of getting the request completed, and estimating.

• Optimize various SQL queries to make the reports run faster

• Used SQL extensively in command objects of Crystal reports Designing the High level TrueComp Plans for the TrueComp functionality.

• Simple rules writing in callidus.

PROJECT PROFILE # 4

Project Title: - FPS Integration – Enhancement

Duration: - Aug, 2011 – Sept, 2013

Product / Tool: - Cognos 10, Informatica 9.6

Operating Systems: -Unix

PROJECT DESCRIPTION:

The Financial Platform Strategy, the FPS Application was newly developed system which was designed to handle 25 million transactions a day; the data mart was created to contain client’s financial accounts. The system used to process data from 189 upstream systems and feed 25 downstream systems. ROLES AND RESPONSIBILITIES:

• Coding of new of ETLs.

• Unit testing of the ETL’s.

• Unit testing, system testing and integration testing of the ETL’s.

• Client acceptance testing and interacting with clients.

• Working on Defects at the time of client acceptance testing

• Creating financial reports using cognos10.

Personal Information

• Gender : Male

• Marital Status : Married

Contact this candidate