Experience Summary
Currently I am an ETL DataStage developer in Arab National Bank, RIYADH with around 9 years of IT work experience in Data analysis, design, development and implementation of Data warehousing applications using IBM DataStage (ETL) in DW/BI Technologies. My main area of experience has been project delivery of various sizes. I have worked in the domain of Retail, Banking, Insurance & Automobiles.

    • Having around 9 years of Technical experience in design and development of the ETL jobs and processes to support the business requirements for an enterprise data warehouse.
    • Good Experience on DataStage Parallel Extender (EE) & DataStage Server jobs using various stages with DataStage designer component.
    • Exposed to various Domains of Data warehouses like Retail, Banking, Insurance and Automobiles.
    • Good Knowledge on Data Warehousing Concepts.
    • Has the ability to develop and maintain good, long lasting client relationships.
    • Enjoy challenging and thought-provoking work and have a strong desire to learn and progress (motivated enough to self-learn) Ability to pick up new technology independently.

Technology
Application/Functional areas worked on
 Banking, Insurance, Retail, & Automobiles 
Types of projects worked on
 Development, Enhancement, Support
Environments worked 
IBM Information Server DataStage 7.5,8.1,8.5 ,8.7 & 11, Oracle 9i & 11g, SQL Server, Netezza, Teradata, UNIX
Languages/Tool worked on
 IBM DataStage Designer (Parallel, Server & Sequence Jobs), Business Objects 4.2 and Moody’s Enterprise Risk Solution.
Operating System 
Windows 2003/2000/2008 /XP, UNIX 
RDBMS
Oracle 9i & 11g, SQL Server, Teradata, Netezza

Career Profile

Aug 2017 to till date    
Aspire Technologies, Riyadh
Apr 2016 to Aug 2017
Tech Mahindra, Hyderabad
May 2015 to Apr 2016
HCL, Malaysia.
Dec 2014 to May 2015
Invosystems, Singapore.
July 2012 to Nov 2014
Marlabs Software Pvt.Ltd, Pune.
Oct 2010 to July 2012
Innovative search consultancy services, Chennai.

Qualifications
    • Bachelor of Technology in Electronics &Communications from J.N.T.U Hyderabad.

Work Experience

Project Name: IFRS9 Impairment Calc 
Arab National Bank
Senior Business Intelligence Developer
Aspire Technologies, KSA
Duration
(08/2017) – till date
Team Size
5
Domain: Banking
Environment
(with skill versions)
Software

Database: Oracle, SQL Server
Tools: IBM Information Server Data Stage   8.7
O/S: Unix

Project Description 

The new impairment requirements in IFRS 9 are based on an expected credit loss model and replace the IAS 39 incurred loss model. The expected credit loss model applies to debt instruments (such as bank deposits, loans, debt securities and trade receivables) recorded at amortized cost or at fair value through other comprehensive income, plus lease receivables, contract assets and loan commitments and financial guarantee contracts that are not measured at fair value through profit or loss.
As part of IFRS9 Impairment calc, I will extract both wholesale (Corporate loans, Overdrafts, Treasury, non-funded & Unused Limits) and Retail (Personal loans, Auto loans, Housing loans & Credit Cards) portfolio's on Monthly basis and will reconcile with F&P before going to upload into Moody’s ECL engine. Once we will upload the file and run the ECL engine, the tool will provide the Output file with the LGD, PD, Stage and Provision details by the Instrument wise. the Provision details will be published in the Chart of accounts.

Roles & Responsibilities:
Developed the Data Stage jobs as per the Mapping document. 
Involved in business meetings to understand the requirement.
Maintaining issue tracker and updating the issues to concern team on regular basis.
Done the unit & system integrating testing for the completed tasks.
Prepared the technical guides (Design documents) for the completed jobs.
Created the jobs to send email notification to the business once the Data stage jobs are running successfully.
 Involved in all the phases of testing, i.e. SIT, FT & UAT to get the sign-off from the respective users.
Created Migration check list document to release the code into UAT & Prod environments.
Giving handover documents to Operations team once the code is migrated to Production.

8. 
Project Name: OWS
Client
Ford Motor Company
Role
Team Lead
Organization
Tech Mahindra, India
Duration
(04/2016) – (08/2017)
Team Size
8
Domain: Automobiles
Environment
(with skill versions)
Software

Database: Oracle, SQL Server & Teradata
Tools: IBM Information Server Data Stage   8.7
O/S: Unix

Project Description 

Ford is one of the World’s most leading motor companies which specialized in 4 wheelers. In order to keep the business and customer in high and as a norm they are providing insurance to the products purchased in the company. And the warranty of those purchased claims are maintained locally by the region wise. In order to bring stability in the warranty department and as their motto for ONE FORD the One warranty solution has been brought up. Old systems are being replaced in the newly modified, unified system where all the warranty related claims come under one radar. This was fully done in the front end by pega tool and for data warehousing and for other data movement ETL tool has been engaged.
 The Ford OWS program will facilitate quicker and accurate retrieval of warranty information from dealers using a single global warranty reporting and processing system.  The OWS system will capture the various procedures that make up the warranty claim process in a single container. Thus, the OWS system will allow Ford to manage the warranty process more efficiently.

Roles & Responsibilities:
Developed the Data Stage jobs as per the Mapping document. 
Involved in business meetings to understand the requirement.
Maintaining issue tracker and updating the issues to concern team on regular basis.
Done the unit & system integrating testing for the completed tasks.
Prepared the technical guides (Design documents) for the completed jobs.
Created the jobs to send email notification to the business once the Data stage jobs are running successfully.
 Involved in Dealer Launch of NA and Europe regions done for every quarter of financial year.
Created Migration check list document to release the code into UAT & Prod environments.
Giving handover documents to Operations team once the code is migrated to Production.

7. 
Project Name: SCB-CB-ODS-Staffing
Client
Standard Chartered Bank (SCB)
Role
DataStage Application Support
Organization
HCL Technologies, India
Duration
(09/2015) – 
Team Size
8
Domain: Banking
Environment
(with skill versions)
Software

Database: Oracle,
Tools: IBM Information Server Data Stage 8.1 & 8.7
O/S: Unix

Project Description 

Standard Chartered Bank constructed an information repository for consumer banking – DW CB, (Data Warehouse – Consumer Banking). It is extending the customer service solutions by implementing a BI (Business Intelligences) application named, Customer Experience Management System (CEMS), the system through which, SCB can capture the products utilization and profile information of a customer i.e. a
Single view of a customer.

CEMS is a Customer enterprise management system which is helpful for the managers or call center executives for better knowledge of the customer. This project is mainly for production support project which
We will get the data from different source systems for different countries. We need to take care about the daily runs, weekly runs and monthly runs which will happen. This application is mainly used for all retail countries such as IN, SG, MY, HK, TW & CN countries.

Roles & Responsibilities:
Assist all customers and provide production support for all designs.
Monitor and provide support to DS jobs and provide expert knowledge on all job designs.
Maintaining issue tracker and updating the issues to concern team on regular basis.
Coordinate with various teams & raise support ticket for issues, analyze root cause & assist in resolution                                      
logging, prioritizing and resolving incidents and track them against various SLAs.
Resolving recurring incidents permanently, performing fixes and implementing preventative action items.
 Submitting change requests, documenting impact and benefits & get approval by a change approval team.

6. 
Project Name: AGIC OPUS
Client
Allianz Insurance, Malaysia
Role
DataStage Developer
Organization
HCL Axon, Malaysia
Duration
(05/2015) – (09/2015)
Team Size
12
Domain: Insurance.
Environment
(with skill versions)
Software

Database: Oracle, Sql Server.
Tools: IBM Information Server Data Stage 8.7, IBM Info Sphere Change Data Capture (CDC).
O/S: Windows

Project Description 

Allianz General Insurance Company (AGIC) Open Product Underwriting System (OPUS) is the system used to know about the General Insurance details of the company. The source system is Oracle which contains the General Insurance Details. General insurance is typically defined as any insurance that is not determined to be life insurance. General insurance or non-life insurance policies, including automobile and homeowners’ policies, provide payments depending on the loss from a particular financial event.

Aim of the project is to build a Data mart which is used to store the historical data by capturing the changes happens at the operational data base. From the Oracle source system extract the data by using an IBM – Info Sphere Change Data Capture (CDC). CDC integrated with data stage by Direct connect option. Once the CDC extracted and pulled the data into Staging area then through data Stage jobs loading the data into DIM & FACT tables as per the business rules.

Through CDC daily refresh job will run which will capture the changes (deleted records, new records, updated records) happened at operational database. based on Operational data base changes CDC will generate the Indicator (D for Deleted records, A for updated records, I or inserted records) and loads into staging tables in SQL server from staging table loading into historical tables.

Roles & Responsibilities:
Developed the Data Stage jobs as per the Mapping document. 
Involved in business meetings to understand the requirement.
Maintaining issue tracker and updating the issues to concern team on regular basis.
Done the unit & system integrating testing for the completed tasks.
Prepared the technical guides (Design documents) for the completed jobs.
Created the jobs to send email notification to the business once the Data stage jobs are running successfully.
Created Migration check list document to release the code into UAT & Prod environments.
Giving handover documents to Operations team once the code is migrated to Production.

5. 
Project Name: BCB (Business Corporate Banking)
Client
Hong Leong Bank, Malaysia
Role
Team Member
Organization
Invosystems Pvt.Ltd, Singapore
Duration
(12/2014) – (05/2015)
Team Size
6
Domain: Banking
Environment
(with skill versions)
Software

Database: Teradata
Tools: Teradata Fast Load, Multi Load, BTEQ
O/S: Windows

Project Description 

The BCB reporting is designed to calculate Profit & Loss Report for Items Interest Income, Interest Expense, FTP Income & Expense, Non-Interest Income, Opex, Loan Loss provision, etc. For all Products (Like Trade, Non-Trade, Forex Income etc..).

For every Item we will get an input files on or before every month 7th day. (end of the first week) From different source systems which contains the data for previous month. After receiving the source files earlier, they are applying the business rules/formulas on the source data manually by taking the dump of source files in excel sheet for every individual item.

Aim of this project to develop a dimensional model to load this data into an enterprise data mart and calculate MTD, YTD and variance which is used for business decision making process.
for this we will get the GL & cost centers information which used to get the GL item amount (income/expense) by cost center wise. Once we got this amount then we can get the Profit & Loss by LOB (Line of business) wise. Some group of cost center will give one LOB (like CSF, SME CENTERS, etc.). all LOB'S consolidated will give a final P & L report.

Roles & Responsibilities:

Understanding the business requirement and business rules. 
Involved in developing the BTEQ scripts as per the business rules.
Involved in SIT and UAT testing to fix the code issues.
Monitoring the script runs and providing the support related to data and code issues
Provided the support to business in critical issues
Involved in regular business communications to get an update.

4. 
Project Name: Global Liquidity Reporting System
Client
HSBC, UK
Role
Team Member
Organization
Marlabs Software Pvt.Ltd, Pune
Duration
(07/2012) – (11/2014)
Team Size
30
Domain: Banking
Environment
(with skill versions)
Software

Database: SQL Server 2008
Tools: IBM Information Server Data Stage  
8.1, Control-M, MKS
O/S: Unix

Project Description 

The Liquidity reporting project is designed to deliver automated reporting capability to all sites to meet group and regulatory liquidity reporting requirements. This project aims at delivering a cost-effective long-term solution for liquidity reporting for the FSA (as lead regulator) and other regulators, which can be upgraded or extended to meet future requirements with minimal cost. This will ensure consistency across all HSBC entities for liquidity management / reporting & stress testing.
 
The key benefits of this project include HSBC group compliance with Lead regulatory reporting requirements & Basel 3 Liquidity reporting requirements, as well as giving the ability for the group to conduct best practice liquidity risk management. The Group Liquidity platform will follow a release-based delivery model to deliver core functionality to support Liquidity calculation and reporting with incremental updates to support regional regulatory requirements. The approach is designed to meet regulatory timelines whilst ensuring minimal operational disruption. This project aims at delivering a cost-effective long-term solution for liquidity reporting to meet both internal & external reporting requirements.

Roles & Responsibilities:

Understanding the business requirement and involved in designing and implementation of jobs.
Involved in SIT and UAT testing to fix the code issues.
Involved in Control-m jobs related activities to order the batches
Monitoring the batches and providing the support related to data and code issues
Provided the support for L3 Team in critical issues
Involved in various activities like releasing hot fix and preparing packages
Involved in regular Client Communications.
Involved in coordination with the Offshore and Onshore testing teams as part of Unit, SIT testing.

3. 
Project Name: HI BAL SCORE CARD
Client
Sears Holding Corporation, U.S.A.
Role
Team Member
Organization
Innovative search consultancy services, Chennai.
Duration
(08/2011) – (06/2012)
Team Size
6
Domain: Retail
Environment
(with skill versions)
Software

Database: SQL Server 2008
Tools: IBM Information Server Data Stage 8.0.1, Control-M
O/S: Unix

Project Description
This project is mainly designed For the Home Improvement Business Unit at Sears there is a requirement to analyze the performance of commissioned sales associate. For this purpose 2 reports are identified which will help evince the translation of goals into performance across selected store formats and regions.
 By using These 2 Reports Business will evaluate Total Amount sales by an Associate for a given day in a given location and in a given scheduling Unit. Depending upon the sales The Commission Team will give the Commission to the Associates. 
The object of this project is design to build a data warehouse that manages the sales of different business units by using DataStage 8.0.1 an ETL Tool. Data was extracted from different sources (mainframe, Teradata, sequential files &datasets) transformed as per business requirements and loaded in to the Sql server Target Database.
Roles & Responsibilities:

    Involved in Developing ETL jobs using Data stage 8.1 supporting all phases of the ETL process such as implementing Source to target mapping
    Extensively used Data Stage Client Tools – Data Stage Designer and Director.
    Worked extensively on different types of stages like Sequential file, Dataset, Lookup, Join, Merge, Funnel, Copy, Transformer, Filter etc.
    Used Data stage director to run and monitor the job.
    Involved in Unit Testing.

2. 
Project Name: AUTO LOST SALE
Client
Sears Holding Corporation, USA
Role
Team Member
Organization
Innovative search consultancy services, Chennai.
Duration
(04/2011) – (07/2011)
Team Size
5
Retail
Environment
(with skill versions)
Software

Database: Netezza 4.5.6
Tools: DataStage Enterprise Edition 7.5.x2
O/S: Unix

Project Description 

The process will load the Enterprise Data Warehouse staging, warehouse and reporting tables to create one report for Sears Auto Center Tire Point of Sale, which will enable the identification of sales that have possibly been lost due to inventory levels, assortment, price, etc., and send this data for review to the buying teams.

Daily, at end of day, the lost sale data feeds from the Automotive Centers will be sent to a mainframe server (Host 56) for consolidation. Then this file will be pulled by ETL team and load the data into warehouse table for reporting purpose

Roles & Responsibilities:

    Involved in Developing ETL jobs using Data stage 8.0.1, supporting all phases of the ETL process such as implementing Source to target mapping
    Extensively used Data Stage Client Tools – Data Stage Designer and Director.
    Worked extensively on different types of stages like Sequential file, Dataset, Lookup, Join, Merge, Funnel, Copy, Transformer, Filter etc.
    Used Data stage director to run and monitor the job.
    Involved in Unit Testing.

1. 
Project Name: Application Management
Client
Kmart, USA
Role
Team Member
Organization
Innovative search consultancy services, Chennai.
Duration
(10/2010) – (03/2011)
Team Size
5
Retail
Environment
(with skill versions)
Software

Database: Netezza 4.5.6
Tools: DataStage Enterprise Edition 7.5.x2
O/S: Unix

Project Description 

Kmart is the one of the top retailers and it is the third largest discount store among the world. It has 1,327 stores across 49 states. The client was facing problems with improve of business sales, so decided to build up data warehouse that collects the data from the different sources and stores in the enterprise Data Warehouse.
The object of this project is design to build a data warehouse that manages the sales of different business units by using DataStage 8.0.1 An ETL Tool. Data was extracted from different sources (mainframe, db2, sequential files &datasets) transformed as per business requirements and loaded in to the Sql server Target Database.

Roles & Responsibilities:

    Involved in Developing ETL jobs using Data stage 8.0.1, supporting all phases of the ETL process such as implementing Source to target mapping
    Extensively used Data Stage Client Tools – Data Stage Designer and Director.
    Worked extensively on different types of stages like Sequential file, Dataset, Lookup, Join, Merge, Funnel, Copy, Transformer, Filter etc.
    Used Data stage director to run and monitor the job.
    Involved in Unit Testing.