ABDUL NAHID

Mobile : +** – 990-***-****

E-Mail : adhi39@r.postjobfree.com

Professional Summary:

12+ years of IT experience in Design, Analysis, Development, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications Which includes Around 8 years of solid experience in Extraction, Transformation and Loading (ETL) using AbInitio 2.15, 3.1 & 3.3,3.5

Worked at Client Place being in UK for TESCO retailer and Citi Bank Projects.

oHas extensive experience in the implementation of large-scale applications with leading technologies in Data warehousing and Database management.

oWell versed with ETL experience using AbInito(GDE,Co-Operating system and EME with components like Rollup, join, Agg, sort, Reformat etc..) Informatica PowerMart v 5.0/4.7, Power Center v 6.1, (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Maple Designer, Transformations Designer, Warehouse Designer)

oExcellent in production support, process flow management of the applications, scheduling, ticket resolution using HP process flow.

oExtensive exposure in Agile projects on daily scrum, status updates, sprints and tight schedules.

oGood Knowledge in Dimensional Modeling (Star and Snow flake).

PROFESSIONAL EXPERIENCE (ORGANIZATION, DURATION & ROLE)

TCS – Feb 2018 – Till Apr 2020 - Tech Lead.

IBM – Aug 2012 to Mar 2016 – Onsite (UK)

HP – Dec 2011 – Aug 2012.

JPMC – Mar 2008 to Apr 2010 – Module Lead.

Tesco HSC – Oct 2005 to Feb 2008 – SSE, 7 Month onsite (UK)

Satyam Computers – Apr 2004 to Oct 2005 – Developer.

Qualifications:

Bachelor of Engineering in Computer Science from Mangalore University, Nov 2001,

Diploma in RDBMS from SSI, Bangalore, July 2002.

Awards & Recognitions:

Citi Bank, UK – For the ACE and BRE, Project Design & Implementation – AUG 2013.

TESCO, Team Excellence Award: Information Services team received team excellence award for Smooth transition & best implementation for PL/SQL - June 2009.

Appreciation: For conducting AbInitio training – Feb 2012.

Satyam Computers, Pat on the Back: For successfully Implementing and completing complex data migration - May 2005.

Projects Profile:

1.

Project Name: Legal & General

Client

TCS

Role

TECH LEAD

Duration

Feb-2018 Till DATE

Team Size 25

Project: Solvency II

Module: Solvency II

Environment

Software

Languages: Unix, PL/SQL

Database: Oracle

Tools: Ab Initio 3.3 & 3.5

O/s : Windows and XP

Project Description:

Solvency II is a fundamental review of the capital adequacy regime for the European insurance industry to protect the interest of policy holders and beneficiaries, by ensuring financial stability of insurance companies to adopt regulatory capital requirement that are aligned to risk of insurance business.

It focuses on bring about a balance between policy holders and the share holders and the share holders quality and timely disclosure to different stake holders great transparency better communication between stake holders is what aimed at deployment solvency II.

.

Responsibilities:

Worked with Business analyst/ Business users to understand business requirements, prepare technical specifications documents, and develop solutions to business problems.

Involvement in designing New Jobs as required if any.

Responsible of requirement gathering, creating technical design documents for data extract, Transformation and Load process.

Developed Generic Ab Initio Graphs for extracting data from Source Systems onto staging area and loading data from Ab Initio load ready files into Target systems.

Projects Profile:

2.

Project Name: GENESIS DAP EMEA LRR (Local Regulatory Reporting)

Client

CITI Bank Through IBM

Role

TEAM LEAD

Duration

Aug-2012 Mar-2016

Team Size 20

Project: GENESIS DAP EMEA

Module: LRR

Environment

Software

Languages: Unix, PL/SQL

Database: Oracle

Tools: Ab Initio 3.1

O/s : Windows and XP

Project Description:

The Project GENESIS DAP EMEA LRR (Local Regulatory Reporting) is a banking sector project for Citi Bank UK. In this project we created application configurations using ACE/BRE to load the input files in target tables. This data is used to generate report on daily, weekly and monthly basis which is then sent to Central Bank of respective country. For loading the tables we need to modify the input files according to the target tables.

Responsibilities:

Worked with Business analyst/ Business users to understand business requirements, prepare technical specifications documents, and develop solutions to business problems.

Involvement in designing New Jobs as required if any using ACE/BRE.

Responsible of requirement gathering, creating technical design documents for data extract, Transformation and Load process.

Used Generic ACE Templates for extracting data from Source Systems onto staging area and loading data from file Feeds into Target systems.

Developed FTP scripts to get source files from various external systems.

Projects Profile:

3.

Project Name: Data Disguisment

Client

Key Bank From HP

Role

Team Lead

Duration

Dec-2011 Aug-2012

Team Size 14

Project: Data Disguise

Module: DDG

Environment

Software

Languages: Unix,SQL

Database: Oracle/DB2

Tools: Ab Initio 3.0

O/s : Windows 2000 and XP

Project Description:

Data Disguisment is a simple process of masking the sensitive elements of a customer’s data which includes his personal identity like first name, last name, personal address and business address by applying the cipher algorithms to make use of the few built in functionality to disguised the original form to a non-guessing form for the end users for various line of Business.

Projects Profile:

4.

Project Name: Anti Money Laundering – Transaction Monitoring

Client

J P MORGAN CHASE

Role

Applications Developer

Duration

Mar-2008 Till April-2010

Team Size 5

Project: AML

Module: BSA

Environment

Software

Languages: Unix, PL/SQL

Database: SQL Server

Tools: Ab Initio 2.14.

O/s : Windows and XP

Project Description:

Anti-Money Laundering Transaction Monitoring & Reporting (AML-TM) applications are used to monitor customer transactions for suspicious behavior indicative of money, As part of JP Morgan Compliance to Banking / AML Laws in USA and other parts of world.

AML-TM maintains a Data warehouse of Transaction Data in order to run Transaction-Filter to identify suspicious activity.

Data Source Feeds contains Records of Transactions across various Business Lines and include Wire Transfers (Treasury Services), Travelers Checks, Money Orders (Private Banking), Stock Positions (Investment Banking) etc.

Feeds are provided by systems of various Lines of Business, and are supplied by daily/weekly/ or monthly ftp or ndm or db-load jobs.

.

Responsibilities:

Involved in full life cycle of AML project.

Responsible of requirement gathering, creating technical design documents for data extract, Transformation and Loading process.

Developed various Graphs based on business requirements in the Ab Initio GDE using Dataset Components, Partition & Depart ion Components, Transform Components, Sort Components, Miscellaneous Components and Validate Components.

Experienced using Ab Initio built in string functions, date functions, miscellaneous functions, inquiry and error functions, lookup functions and math functions.

Projects Profile:

5.

Project Name: ODS/GMIS/CRST

Client

TESCO

Role

Senior Team Member

Duration

Oct-2005 Till Feb -2008

Team Size 7

Project: ODS

Module: TIME ODS

Environment

Software

Languages: Unix, PL/SQL

Database: ORACLE, Teradata

O/s : Windows and XP

Project Description:

The Group MIS implementation to CHINA and JAPAN is essentially a clone of the code/database object base developed for Group MIS in Korea along with the new set of Jobs developed to cater the Non merchandising data and other Local requirements specific to the country.

Contribution:

As a Senior Team member, was responsible for

Analysis, Design, Coding and Testing..

Execution of the project as per company’s quality processes

Ensuring that Incident Records are updated and customers are communicated to on a regular basis.

Identify Root Causes of issues that arise and provide improvements to remedy them

Responsible for overseeing the Quality procedures related to the project.

Projects Profile:

6.

Project Name: General Electric Consumer Finance

Client

GE From Satyam Computers as a consultant.

Role

Team Member

Duration

April-2004 Till Oct-2005

Team Size 48

Project: GECF

Module: CDCI

Environment

Software

Languages: Unix, PL/SQL

Database: ORACLE

Tools: Toad

O/s : Windows 2000

Project Description:

GE Consumer Finance is well-known renowned private finance company in US, sponsors to the customers on behalf of their clients(JCP, Wal-Mart, Exxon mobil, etc.) on their credit cards. The goal of CDCI Warehouse, is to consolidate data from CDW, FDR, Fraud, and ADS warehouses into a single source of consumer card data which supports business requirements for reporting and analysis. It provides a single view of consumer data and allows new products The Project was successfully developed and is delivering the service to clients. Warehouse for various credit cards used in Wal-Mart, JC Penny etc, evaluate the performance of their customers viewed by their Managers.

Contribution

As a Team member, was responsible for

Analysis, Design, Coding and Testing.

Historical Migration of data from CDW to CDCI warehouse.

Execution of the project as per company’s quality processes

Ensuring that clarify tickets are updated and customers are communicated to on a regular basis.

Identify Root Causes of issues that arise and provide improvements to remedy them

Responsible for overseeing the Quality procedures related to the project.

Providing implementation support.

Responsibilities:

Fully Involved in Historical Data Migration from different data warehouses into a single Data warehouse.

Contact this candidate