Anil Kumar

Mobile No: +353-*********

Email id: ac476v@r.postjobfree.com

Summary:

Having 10+ years of experience in IT Industry Working as a Data Quality Analyst in Wipro Technologies with strong skills in Teradata, Sql, PL/SQL Programming, Qlikview and Informatica Data Quality Tools.

Good exposure on banking domain.

Responsible for the gathering business requirements, development, testing, and implement tation of business requirement.

Taking care of end to end development of software development life cycle of projects.

Experienced in Data Quality Analysis, Data profiling, identification data issues and gap assessment.

Maintains data architectural artifacts and ensures that all measures for data quality, data profiling, and data governance.

Developed Data Quality dashboard by using Qlikview tool as per the business requirement.

Works with Product Owners, and Business SME to identify requirements and drive ingestions standards consistent with business processes.

Analyze data Quality issue and provide the fixes as per the issue.

Extensively working on Performance Tuning of Sql.

Having hands on experience in Teradata utilizes like Bteq, Fast Load, Fast export and Mload.

Good understanding of Data Warehousing concepts.

Having experience in Data Migration project.

Trained on Ab initio(ETL tool) and Er Win tools.

Worked on Configuration Tools like (Telecom) Intec Singl.eView Convergent billing system.

Willingness to embrace new technologies and ability to work in a team environment.

Onshore experience at client location in UK and Ireland.

Significant experience of working with customers, Business leaders and heads, process owners including project managers and technical teams.

An effective communicator with relationship management skills with the ability to relate to people at any level of business and management.

Proficient in Documentation of Detailed Design, Technical solution design, ETL Mapping Specs, Unit Test and Deployment and reviewing the same done by others.

Experience in Project Management activities like Project Planning, estimating effort requirements, Task Allocation, Tracking and Reporting.

Working in Agile environment.

Employment Summary:

Currently working as Analyst for Wipro Technologies from Mar-13 to till date.

Worked as Application Developer for IBM India Pvt LTD, from Aug-11 to Mar-13.

Worked as Software engineer for Mahindra Satyam, from Jun-07 to Aug-11.

Education:

Degree

Specialization

University

Year of passing

Graduation

B.Tech

JNTU

2007

Technical Skills:

Operating Systems

Windows 98, XP,UNIX

Languages

UNIX, SQL, PL/SQL Programming.

Databases

Oracle 9i, Teradata

Tools & Utilities

Teradata sql assistance, Singl.eView Convergent Billing System, IDQ,Putty,Qlikview,Tiwoli, Mainframes

Project Details:

Project I:

1.

Project Name: AIB Data Quality

Client

Allied Irish Bank

Role

Data Analyst

Organization

Wipro Technologies, India

(6/2015) – Till Date

Team Size

6

Module: Application Development

Environment

(with skill versions)

Software

Languages : SQL

Database : TERADATA

Tools : TERADATA,IDQ, Qlikview

O/S : Windows

Project Description:

Allied Irish Banks (AIB) is one of the so-called "Big Four" commercial banks in Ireland. AIB offers a full range of personal and corporate banking services. The bank also offers a range of general insurance products such as home, travel, and health insurance. It offers life assurance and pensions through its wholly owned subsidiary, Ark Life Assurance.

Responsibilities:

Discussing with product owners and gathering the business rules.

Design the rules by using IDQ (Informatica Data Quality) tool.

Testing the rules and Share the UAT results with product owners for approval.

Present the rules score card on Qlikview dashboard.

Production deployment of the dashboard.

Attending the scrum meetings with different Data Delivery teams and taking the details on Data quality issues.

Doing the profiling in IDQ and sending it to IT BA for analysis.

Analyzing the production data quality issues and fixing it.

Working with Product Owners, and Business SME on production issues and suggesting the solutions.

Perform variety of in-depth data analysis on production issues.

Added the new dashboard changes in existing score card.

Develop the Adhoc reports as per the business requirement.

Working in Agile software development environment.

Project II:

1.

Project Name: Lloyds Integration

Client

Lloyd Banking Group

Role

Analyst

Organization

Wipro Technologies, India

(04/2013 – 05/2015)

Team Size

6

Module: Application Development

Environment

(with skill versions)

Software

Languages : SQL

Database : TERADATA

Tools : TERADATA Utilities

O/S: MAINFRAMES.

Project Description:

Lloyds TSB is a leading bank in the UK which acquired Halifax bank and Bank of Scotland (HBOS). Lloyds EDW project focuses on developing an Integrated Teradata warehouse by merging the data from the CBS (Source system of Lloyds) and HBOS (Source system). DataStage and Teradata Utilities are used for Staging and Loading purposes.

Responsibilities:

Requirements gathering and Impact assessment.

Preparing high level design document (MLPD) and low level design document (TDD)

Review of technical design documents and suggesting optimal solutions

Review of project artifacts and Code/ Unit test cases to comply with platform code

Standards

Supporting the Implementation activity in the live environment.

Preparing the scheduling documents.

Change management and Implementation support

Project II:

Project Name:

ARC

Client

MEDCO

Role

Team member

Organization

IBM

Duration

Sep 2011 – Mar 2013

Languages

SQL,UNIX

Database

Teradata

Tools

Teradata SQL assistant, Putty Mload, Fast load, Bteq

O/s

Windows, Unix

Project Description:

ARC (Analysis and Reporting Consolidation) Maintenance.

Characteristics: ARC reporting is used as a tool to monitor and measure the overall

effectiveness of Client's Care Management programs. ARC is a production maintenance and enhancement type project

Responsibilities:

Analyzing the Business Requirements of the client.

Written queries to move the data from source to destination.

Extensively involved in PL/SQL

Used Mainframes JCL for scheduling jobs.

Worked on error fixings and did performance tuning in sql assistant.

Worked on finding and fixing errors in Actuate report failures

Created appropriate indexes depend on the table situation and requirement.

Worked with various types of tables such as Derived, Volatile, and Global temporary.

Involved on answering ad-hoc requests.

creating Unit test cases, Technical specifications according to the business specification or source map

Writing the unit testing

Project II:

Project Name:

Custom Reporting

Client

Scotia Bank

Role

Team member

Organization

Mahindra Satyam

Duration

Dec 2009 – Jul 2011

Languages

SQL,UNIX

Database

Teradata

Tools

Winscp, Teradata SQL assistant, Mload, Fast load, Bteq

O/s

Windows, Unix

Project Description:

This was developed for a Banking Major to manage its Markets in different parts of the world. The aim of the project is to extract the data from the source systems which might be a Flat File and then applying transformations and loading the data into the Warehouse using Teradata.

Responsibilities:

Analysis and Review of the specification (Design) document provided by client.

Coding all members required for project development i.e. BTEQ AND FLOAD scripts as per Barclays Standards

Execution of the scripts in development environment.

Performing Code Review as per Barclay’s code standards.

Performing Reconciliation check between source and target.

Executed scripts in UAT environment.

Project III:

Project Name:

Faster Compensation Payout

Client

Scotia Bank

Role

Team member

Organization

Mahindra Satyam

Duration

Oct 2008 – Nov 2009

Languages

SQL,UNIX

Database

Teradata

Tools

Teradata SQL assistant

O/s

Windows, Unix

Project Description:

As per FSA policy, all deposit takers have to submit a single customer view report (SCV) within 72 hrs of request being made. For this bank has built a DataMart which contains all customer data and related account data. The project is designed to populate data into DataMart using BTEQ. The system should be able to validate all customer related data with respect to different status attributes of account and customer and eliminate the customer and account related information from the DataMart which are identified as irrelevant for faster customer payout for FSCS. Finally report data is prepared and archived in a table for prescribed no of days

Responsibilities:

Supporting the application and running daily job

Monitoring the job and logs

Adding new features to the applications

Extracting report and submitting it to the client

Project IV:

Project Name:

MTNL-CCBS

Client

Mahanagar Telephone Nigam Ltd., India

Role

Team member

Organization

Mahindra Satyam

Duration

Sep 2007- Aug 2008

Languages

Oracle(SQL/PLSQL),UNIX Shell Programming, Pro*C,PERL

Software’s

Intec Singl.eView

Database

Oracle 9i,Oracle 10g

Project Description:

The Project involves implementation of Convergent Customer Care and Billing System for all Lines of Business of MTNL like GSM, CDMA, Leased Circuits, Broad band and Fixed line. The Project is an integration of various functional areas like People soft CRM, Intec Singl.eView Convergent Billing, SYSTEAM Provisioning, Mediation, Revenue Assurance and Interconnect Billing System.

MTNL is Telecom Service Provider, operating its Wireline & Wireless businesses from Delhi & Mumbai in India, providing a wide spectrum of voice & data related services to its customers using different OSS/BSS systems.

The data from the source system is loaded into the target system through Data Migration.

The purpose of the Data Migration is to extract the required data from the disparate legacy data sources, validate and transform this data into the expected destination system formats, then load this data into the ‘to-be’ environments. The scope for the migration is to port the existing customer base, bills, payments and adjustments into the target databases.

Responsibilities:

Preparing Staging Data Entities to stage data from various Legacy Systems.

Field to field mapping of source data to Singl.eView billing system.

Development of Extraction Script to extract & transform data from legacy system to Oracle Data files (to stage data into staging database).

Data loading from the data files to the Staging Database using SQL Loader.

Development of Extraction Script to extract & transform data from staging system to Oracle Data files (to stage data into Singl.eView database).

Preparing reconciliation reports at both Source Database and target Database (Singl.eView Billing System).

Preparing automation script to Validate, Extract data from staging database and generate data files, load data from the generated data files into Singl.eView Billing system database and finally to validate the migrated data generating reconciliation reports.

Personal Details

Name

Anil

Email Id

ac476v@r.postjobfree.com

Mobile Number

+353-*********

Contact this candidate