BIKASH CHANDRA GHOSH

Need H*B Visa Sponsorship

Email:acql70@r.postjobfree.com

Cell: +91-907*******

SUMMARY

Having 8 years of IT experience in ETL development (Informatica) in Finance, Banking, Telecom, Life Science and Travel domain.

Having 3 Years of working experience on client site (Singapore) in Banking Domain (UBS).

Extensive hands-on expertise using Informatica 9.x/8.x/7.x and Performance tuning with strong business understanding of Banking, Telecom and Finance sectors.

Proficient in UNIX, Shell Scripting, Oracle11G/10G/9i (SQL, PL/SQL), Teradata and is able to meet objectives in team related projects.

Proficient in Monitoring as well as managing/Scheduling various AUTOSYS and Appworx jobs.

Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Data warehousing /Legacy applications for various industries using Data Modeling, Data Extraction, Data Transformation and Data Loading.

Extensive experience working with clients/end-users, requirement gathering, has strong communications, interpersonal skills and has the ability to work under own initiative and respond to peaks in demand.

Research oriented, raise issues upfront and like to address them as soon as they have been identified.

Working Experience of Power Center Administration, Designer, Informatica Repository Administrator console, Repository Manager and Workflow Manager.

Involved in development of Informatica Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc.

Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Extensive Experience in writing SQL queries, stored procedures, functions, packages, triggers, exception handlers, Cursors, 3NF, PL/SQL records & tables.

Worked on active data Warehouses with database sizes up to 10 Terabytes.

Used Unix Shell Scripts to automate day-to-day operations.

Followed complete Software Development Life Cycle (SDLC), agile methodologies in various project.

TECHNICAL/ FUNCTIONAL (Application) SKILLS

Skills

Details

Operating System

Unix(Sun Solaris & Linux), Windows

Domain

Telecom, Banking, Finance, Life Science and Cargo

Scripting Languages

Shell Scripting

Database

Oracle11G/10G/9i(SQL, PL/SQL),Teradata 14

Incident Management

Remedy, Quality Center or ALM, HP Service Manger 11.0,Jira 5.1,Service Now (SNOW)

Scheduling Tool

AUTOSYS 11.0/11.3,Appworx

ETL Tools

Informatica 9.x/8.x/7.x

Data Modeler

Erwin r7.3/r8,ER/Studio 9.0

Reporting Tool

BOXI 6.x/R1/R2/R3

Other Tools

Putty,SQL*PLUS, Toad,SQL developer

PROFESSIONAL EXPERIENCE

Company

Designation

Duration

Cognizant Technologies Solutions

Senior Associate

Nov 2014-Till date

Igate Global Solutions Limited

Project Lead

Mar 2014-Nov 2014

Thomson Reuters India Pvt. LTD

Senior Software Engineer

AugAug 2013–Feb 2014

Dell International Services (India) Pvt. LTD.

Software Development Analyst

Jul 2009- Aug 2013

Perot Systems TSI (India) Pvt. Ltd.

Software Engineer

Jun 2007– Jul 2009

TECHNICAL QUALIFICATION

B.Tech in computer science and Engineering with an average C.G.P.A of 7.11 from Padmanava college of Engineering, Rourkela under B.P.U.T, Orissa in 2007.

Diploma in computer science and Engineering with an average of 65.80% from Kalinga Polytechnic, Bhubaneswar under SCTE&VT, Orissa.

Project No. # 1

Title : Manufacture Me (MME) (continuing from Off-Shore)

Client : Astrazeneca,UK

Organization : Cognizant Technologies Solution

Operating System : Windows

Software : Oracle10g/11g (Sql, Pl/Sql)

Tools : Informatica 9.5, Toad,Sql developer

Team Size : 9

Project Type : Development

Duration : Nov 2014-Till Date

Project Synopsis:

The Project is about integrating data from various source system like RXA, NHS, IMS, SAP, VEEVA(Source System)and integrate that into the commercial data warehouse, in order to get the sales at the hierarchies level(product, Sales & Account Hierarchy ) and to attribute the sales to the Field Reps.

This project develops/supports AstraZeneca’s sales process and provides self-assessment capability to increase market of their Product and services for high level customer satisfaction and to help AstraZeneca in decision making to grow their business. Under this project we have developed and supported 2 applications.

1) Sales and Channels--(To see sales of particular product corresponding to Territory, customer, Account) to compare with competitive products.

2) Activity To Track the Targets and Actual Calls of Market representative.

Roles and Responsibilities:

Responsible to attend requirement gathering calls and review the requirement document.

Involved in gathering requirements and created design documents and mapping documents.

Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow.

Fine-tuned existing Informatica mappings for performance optimization.

Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Involved in the Unit test case preparation and System test case review.

Worked on bug fixes on existing Informatica Mappings to produce correct output.

Project No. # 2

Title : Last Calendar Date (LCD) (Carried out from Off-Shore)

Client : GE Capital Solutions, USA

Organization : IGATE Global Solutions Limited

Designation : Project Lead

Software : UNIX, Shell Scripting, Oracle 11g (Sql, Pl/Sql), Teradata 14

Tools : Informtica 9.5, Putty, Sql developer, HP ALM, SAP BO 4.0, WinScp

Team Size : 12

Project Type : Development

Duration : Mar 2014 – Nov 2014

Project Synopsis:

The Federal Reserve has required GE Capital to move from a Fiscal to a Calendar monthly/quarterly close cycle by January 2015. All systems must change and comply by that time period. GECA needs to manage this drastic change across over 20 core sub-ledgers and 300+ upstream/downstream systems and meet the demands by the Federal Reserve to be successful. EDW is the Enterprise Data Warehouse that supports various analytical reporting needs for Risk, Marketing, Finance, Lending/Leasing businesses. As LCD changes impact EDW and down streams, it’s critical to understand the exact areas of impact for mitigation planning. Design changes required for absorbing LCD changes needs to be documented as per standard development practices.

Roles and Responsibilities:

Responsible to attend requirement gathering calls and review the requirement document.

Responsible for managing a team of 9 off shore members, assigning and prioritizing works accordingly as per requirement.

Responsible to provide the estimation to the client.

Responsible to make changes in existing Bteqs codes and informatica mapping as well.

Responsible for developing new codes as per client’s requirement.

Responsible to perform QA testing as well as addressing QA defects.

Worked closely with Business Object’s reporting team in order to meet users/business ad-hoc and other reporting needs.

Responsible for release activity with admin team to push the codes to production as per specified release date.

Project No. # 3

Title : Siebel Source Reporting (SSR) (carried out from Off-Shore)

Client : Thomson Reuters, USA

Organization : Thomson Reuters India Pvt. Ltd.

Designation : Senior Software Engineer (SSE)

Software : UNIX, Shell Scripting, Oracle10g/11g (Sql, Pl/Sql)

Tools : Informatica9.1, Toad, Putty, Sql developer, jira, HP service manager 7.11, BOXI R3, HP Quality Center 11.0, WinScp

Data Modeling : ER/Studio Data Architect 9.0

Team Size : 26

Project Type : Development

Duration : Aug 2013-Feb 2014

Project Synopsis:

SSR is an ad-hoc reporting system used by TR users. Sales, Install, Pending reporting driven by Siebel Sales Order process. Siebel is the primary ordering tool used for turning on / off billable and non-billable products. Siebel orders manage entitlement process and are the creation point for changes in SAP billing .Siebel utilizes Orders to drive changes to Assets, same time Orders communicate to SAP changes to billing.

Siebel sourced data directly from Siebel. Contains data before the application of the SSR rules which is applied before loading into EDW Data Warehouse where it is used for Order Management, Commercial Position and Pending Universes. To be used for reconciliation between Siebel and the reporting universes.

Roles and Responsibilities:

Responsible to attend requirement gathering calls and review the requirement document.

Responsible to provide the estimation to the BAs.

Involved in preparing High level design document (HLDD) and low level design document (LLDD) as well.

Involved in preparing data model of the requirement and same time need to review with architects before proceeding further.

Responsible to handle and respond production issues.

Responsible to perform QA testing as well as addressing QA defects.

Worked closely with Business Object’s reporting team in order to meet users/business ad-hoc and other reporting needs.

Responsible for release activity with admin team to push the codes to production as per specified release date.

Project No. # 4

Title : Global General Ledger (carried out from On-shore)

Client : UBS, Singapore

Organization : Dell International Services (India) Pvt. Ltd.

Software : UNIX, Shell Scripting, Oracle 9i/10G (Sql, Pl/Sql),

Tools : Autosys, Informatica 8.x, Erwin r7.3/r8, Toad, putty.

Team Size : 17

Project Type : Development

Duration : Jul 2009-Aug 2013

Project Synopsis:

A web based application that was developed to integrate the various data sources across businesses for GGL operations to have a centralized and consistent data store. It provided a detailed cockpit view of daily/ weekly/ monthly/ quarterly/ annual reports based on each operational tower and their respective processes. This provided a single window to all stakeholders for tracking and reviewing the metrics and reporting details and automated the reporting process. It is a central repository of data/ metrics for historical references and statistical analysis and to provide automated mail alerts to stakeholders for monitoring and tracking of operations.

For every transaction generated by a Front Office, Risk Management, Settlement or Cash and Current Accounting System, the Investment Bank is required to record this activity in Finance’s Global General Ledger (GGL). The IB’s integrated front-to-back process supports straight through processing with upstream systems sending daily end of day feeds to the GGL. The Finance architecture, with GGL as its centerpiece, supports the IB’s detailed financial books and records. The GGL is the repository for client, instrument, and position details to support management and financial reporting requirements. Finance staffs whether BUC, FAE, Global Controlling, Control Group, Treasury, or Change-the-Bank (CTB) need to understand how Finance’s architecture works and how it supports their daily and month-end controlling and reporting activities.

Roles and Responsibilities:

Converted user defined functions of business process into Informatica defined functions.

Developed and support the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica.

Worked closely with Business Object’s reporting team in order to meet users/business adhoc and other reporting needs.

Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.

Prepared and implemented data verification and testing methods for the Data Warehouse as well as to design and implement data staging methods and stress testing of ETL routines to make sure that they don’t break on heavy loads.

Performed ETL Administrator jobs like maintaining Folder/User level Privileges.

Scheduling Jobs based on target system dependencies using Autosys.

Project No. # 5

Title : Forecast Tracking System (carried out from off-shore)

Client : Alcatel-Lucent, USA

Organization : Perot Systems TSI (India) Pvt. Ltd.

Software : UNIX, Shell Scripting, Oracle 9i (Sql, Pl/Sql),

Tools : Autosys, Informatica7.x, Toad, Putty, Remedy

Team Size : 9

Project Type : maintenance and enhancement

Duration : Jun 2007– Jul 2009

Project Synopsis:

FTS is an ad hoc reporting system used by NAR-based CFO, Product Management, and Project Management Associates. The system is primarily used for its flexibility to report recognized revenue, costs, and SGP at various combinations of the customer and product financial hierarchy, and for various periods. The system holds 7 years of historical financial data, and states financial results based on the current customer and product financial hierarchies. This feature supports the creation of trend reports at the level of customer and product that satisfies an individual user's needs. Also, FTS reports on customer and product configuration hierarchy. Data mart FTS is an online reporting system used to report recognized revenues, costs and Sales Gross Profit at various combinations of the customer and product financial hierarchy for various periods thereby supporting creation of trend reports at the level of customer and product resulting an individual user's needs as well as storing 7 years of historical data.

Roles and Responsibilities:

Analyzed the data models of the source systems to develop comprehensive mapping specifications.

Designing a Database for the loading and Staging Area.

Extracted data from Sql Server, Oracle, flat files to pull it into the Staging area.

Produced specifications for mapping from various source Systems to Data Warehouse.

Performed Informatica Administrator functions like creating repository, Groups Users, Folders, giving permissions on the folders to the users etc.

Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager. The objective is to extract data stored in different databases such as Oracle and DB2 and to load finally into a single Data Warehouse.

Extensively worked in the performance tuning of the ETL mappings and workflows using partitioning, external loaders, lookup cache etc.

Involved in writing shell scripts and added these shell scripts in Cron Job, as scheduled daily, weekly, monthly

Extensively created mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.

Written JIL to schedule various Autosys nightly jobs.

Contact this candidate