ARUNABH RAY

Kolkata, India

Canadian Permanent Residency Holder

Mobile: 908-***-****

E-mail: ac4q20@r.postjobfree.com

LinkedIn URL: https://in.linkedin.com/in/arunabh-ray-373168a9

Skype ID: arunabh_ray Best time to call: 2 PM – 8 PM (IST)

Seeking a suitable position which provides opportunities to demonstrate skills and expertise in design, development and maintenance of Data Warehousing projects

SUMMARY

IT Professional with over 7 years of experience in Ab Initio Development for Banking and Telecom projects

Experience with various Ab Initio products which primarily includes development in GDE, and advanced features like BRE and Ops Console

Currently associated with Tata Consultancy Services as IT Analyst (Ab Initio Developer) since Dec 2010

Over 7 years of experience as ETL Developer for Data Warehousing projects, providing strategies for design and definition of Data Warehousing projects using Ab Initio

Sound knowledge of developing UNIX scripts for automating the execution of Ab Initio graphs, SQL database programming, and Autosys automation tools

Ability to manage functional and non-functional requirements, supervise and provide technical guidance to Ab Initio Developers

Strong communication, inter-personal, and team-working skills.

Also capable of working as a team lead and handling a team.

AVAILABILITY

No bond obligation with the employer

Ready to relocate in 3 to 5 months

SKILL SET

ETL Tools: Ab Initio

Scripting Tools: UNIX Korn Shell Scripting

Databases: Oracle, MySQL

Operating Systems: Microsoft Windows XP, Unix

LANGUAGE SKILLS

Proficient in English (Overall band score of 7.5 in IELTS)

EDUCATION

Bachelor of Technology – Silicon Institute of Technology, Bhubaneswar, India (2010)

GLOBAL EXPOSURE

Deputed at client site (Commonwealth Bank of Australia) to work on ‘Customer Reporting System’ Project. Client location –Sydney, Australia.

Deputed at client site (VISA) to work on ‘Data Feed Manager’ Project. Client location-Reading, United Kingdom.

PROJECTS

Title #1:

REL ODS

Client:

Citi Bank

Duration:

Jun2017-Till Date

Role:

Abinitio Developer

Description:

Worked for RELODS application in which is the main application for CITI Mortgage Banking

Data used for storing CITI’s mortgage loan data throughout North America. Working currently as

A Tech lead and leading a team of developers in creating and developing code based on new business logic.

Key Responsibilities:-

Develop fresh code based on new business logic.

Tag creation and code migration.

Work on advanced Abinitio concepts like parallelism.

Mentoring team members as part of team lead activities.

Title #2:

DFM(Data Feed Manager)

Client:

Visa Inc.

Duration:

May 2016-May2017

Role:

Application Support Analyst (L3 Support).

Description:

Worked as a senior Application Support Analyst with Abinitio expertise in VISA (formerly VISA Europe) in one of the Support Application i.e. DFM which is the principal application for all front end VISA Authorizations data transactions in UK and European market. Have to provide real time solution for production fixes and also involve in production deployment. Also take part in real time development and enhancement of existing code for all support activities and have in depth domain knowledge of VISA systems.

Key Responsibilities:

Enhanced the existing code based on new business logic.

Code Migration and unit testing.

Created unix scripts to automate the manual work.

Title #3:

EDW

Client:

Visa Inc.

Duration:

Jun2015-April2016

Role:

Abinitio Developer.

Description:

Worked for STC Client as an Abinitio Developer in EDW Application.

EDW is the main Data warehouse in all the domain in STC and it has different subject Area i.e. Event, Party. Master, Finance. This application was mostly used for the STC daily telecom transactions in the Middle East Region.

Key Responsibilities

Enhanced the existing code based on new business logic.

Code Migration and unit testing.

Created Unix scripts to automate the manual work

Title #4:

CRS (Customer Reporting System)

Client:

Commonwealth Bank of Australia, Australia

Duration:

Nov 2014 – May 2015

Role:

Ab Initio Developer

Description:

Aims to improve reliability of Client Reporting, capabilities to deliver ISO 20022 Cash Management Reports, and SWIFT Cash Management Reports for Foreign Currency Accounts

Key Responsibilities:

Developed Continuous Graphs for new subscription, Automated Graph for e-mass log gathering, complex plans for scheduling graphs

Created new jobs in Ops-Console (Ab Initio Scheduler)

Automated existing manual test scenarios for reuse.

Title #5:

BARCLAYS – TCV ABSA

Client:

Barclays Bank Plc, United Kingdom

Duration:

Aug 2013 – Sep 2014

Role:

ETL Developer

Description:

The TCV – ABSA project aims at setting up an integrated platform which provides a ‘Golden Copy’ and 360-degree view of the customer, thus bypassing ID&V and KYC processes when he signs up for different products. It also strives to transform their legacy source system to MDM (new customer repository for ABSA)

Key Responsibilities:

Developed Ab Initio Generic Graphs for updating customer data dropped by daily MDM services

Understood structure of MDM database, its inter-relationship and dependencies, and validated each customer type mapping with respect to MDM tables

Assisted SIT and UAT teams for implementation, defect analysis and fixing

Designed and developed Ab Initio graphs for migration of database ODP (Source System generating KYC compliance list for ABSA customers) to TCV MDM

Performed SIT Testing/E2E Testing after post-deployment to the respective environment

Created Automation Scripts to automate the manual testing scenarios

Title #6:

BBCR (Broadband Customer Reporting)

Client:

British Telecommunications Plc, United Kingdom

Duration:

Jul 2011 – Aug 2013

Role:

ETL Developer

Description:

BT uses a Business Intelligence platform to run business critical applications like BBCR Orders, BBCR Faults, Network Builds, SFJ BB, Vodafone, Bluebird, NetOps, NetView, and WBC. Here, Service Providers request for on-line display of the Broadband Orders data augmented by reference data in the form of reports via the BT Wholesale Portal using Actuate / OBI. Actuate accesses the BBCR Data Mart for these data. The Order data will use a combination of various source systems into the data warehouse using Ab Initio ETL tool

Key Responsibilities:

Analyzed Ab Initio graphs, suggested and implemented changes intended to enhance the performance of the graphs

Extracted, transformed and loaded data into Data Mart and Data Warehouse using Ab Initio and Oracle PL/SQL tools

Reviewed and approved delivery work items, and identified code related issues

Created scripts for scheduling activities in KORN in a live environment

Title #7:

CAS (Common Application Support)

Client:

Deutsche Bank AG, Germany

Duration:

Jul 2010 – Aug 2011

Role:

ETL Developer – Production Support

Description:

The CAS provides a framework for making data available to ‘Simply Instantaneous’ (consuming applications), cutting down the number of data exchanges between the provider source system data and the consuming applications, and resulting in process efficiencies across the Global Markets business areas

Key Responsibilities:

Interacted with U.S, U.K and Asia business clients for requirement study

Monitored service events, Ab Initio jobs in Tidal tools

Executed monitoring scripts

Performed daily health checks and reporting

Contact this candidate