ARUNABH RAY

London,Ontario

Express Entry Profile Number: E000534759

Mobile: +1-226-***-****

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

Skype ID: arunabh_ray Best time to call: 9 AM – 5 PM (CST)

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 9 years of experience in ETL 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

Currently holding PR.

Relocate to any location in Canada within 15 days.

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:

IDM Reporting

Client:

CanadaLife

Duration:

Oct2019-Till Date

Role:

Abinitio Developer

Description:

Worked as an Ab initio Developer in IDM Reporting for Developing an application called Unitrax

And done E2E coding for the project.

IDM is an application used for end reporting for most Canada Life Investment Source systems,

.

Key Responsibilites:-

Develop fresh code based on new business logic.

Tag creation and code migration.

Work on advanced Abinitio concepts like parallelism.

Provide solutions on different data iisues.

Liase with Testing for defect and bug fixes.

Also coordinate with production support for all support related work..

Title #2:

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 Responsibilites:-

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 #3:

DFM(Data Feed Manager)

Client:

Visa Inc.

Duration:

May 2016-May2017

Role:

Application Suport 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 Authorisations 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 actiivities and have in depth domain knowledge of VISA systems.

Key Responbilities:

Enhanced the existing code based on new business logic.

Code Migration and unit testing.

Created unix scripts to automate the manual work.

Title #4:

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 Responbilities

Enhanced the existing code based on new business logic.

Code Migration and unit testing.

Created unix scripts to automate the manual work

Title #5:

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 #6:

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

REFERENCES

Mohit Sharma ( Contact Number :+1-204-***-****).

Andy Devito (Contact Number 519-***-****)

Contact this candidate