Business Analyst/QA

NARESH ALLA : +91-998*******

: *******.****@*****.***

Summary of experience:

• Around 3+ years of extensive experience in the IT industry with thorough understanding of

Data Warehousing technology and proficient in Data Warehousing tool Ab Initio.

• Having extensive knowledge in Unix and Oracle.

• Involved in requirements gathering, development, enhancement, problem analysis/resolution, designing,

Coding, testing, and implementation phases of several projects.

• Demonstrated ability in grasping New Concepts (Both Technical & Business) and utilize as needed.

• Potential of handling multiple tasks easily and capable of meeting deadlines.

Educational Qualification:

B.Tech from Jawaharlal Nehru Technological University.

Technical Skills:

ETL Tools : AbInitio.

Application Server : Windows XP, UNIX.

Languages : SQL.

Database : Oracle.

Experience Summary:

• Working as Software engineer in Infosys Technologies Ltd., Bangalore from March 2010 to Till Date.

• Worked as Software engineer in Mind Tree Ltd., Bangalore from March 2008 to Feb 2010.

Professional and Project Experience:

Project – 1 Mar 2010 - Till Date

Project : Bank Service for Abbey national bank

Client : Abbey national bank, UK

Role : Team Member

Technologies used : Ab Initio, Unix, Oracle

Team Size : 8

Description:

Abbey National Bank is a leading bank in UK .They has number of customers operating in various parts of the UK. Like every fast growing bank, this bank is searching for new business avenues, wants to increase the customer base and attract more investments. So far the bank is using traditional banking practices for functioning and using the various media for promoting the various schemes. By using the information technology for making better business strategies and decisions this bank wants to have an edge over its competitors.

The aim of project is to maintain a centralized database of all the departments like finace,mutual funds,loans,customer etc, in which bank provides services. The main work scope involves in extraction data from different data sources systems and applies some business rules and loading into the centralized warehouse.

Responsibilities:

• Gathering ETL requirement and design the requirement specification

• Responsible for coding and reviewing Ab Initio code.

• Responsible for the development and integration of graphs.

• Preparing Mapping specification document.

• Worked with Partition components like partition by range, Partition by Round Robin, partition by Expression efficient use of Multifile system which comes under Data Parallism.

• Perform Transformation and validation process

• Coding, testing, modifying, debugging, documenting and implementation of Ab initio Graphs.

• Analyze functional requirements, mapping documents, assist in problem solving and trouble shooting..

• Used EME to checkin /checkout the graphs

Project – 2 Feb 2009 – Feb 2010

Project : Global Data Warehouse for Deutshe bank

Client : Deutshe bank

Role : Team Member

Technologies used : Ab Initio, Unix, Oracle

Team Size : 6

Description:

The customer is a pre-eminent investment management organization with offices in New York, London, Tokyo, Hong Kong and other principal financial centers around the world. The customer wanted to start a Data Warehouse (DW) to meet its analytical reporting and decision support requirements. Main objective of the DW is to Increase business efficiency through a centralized global view of holdings, transactions and trade and facilitate global exposure analysis, global compliance etc.Increase Data Quality by centralized data quality monitoring, Understand the different source System/s that reside on diverse platforms, Identify/Extract data from various source systems, Meta data management Design and create a data mart for downstream applications.

Responsibilities:

• Responsible for coding and reviewing Abinitio code.

• Responsible for the development and integration of graphs.

• Preparing Mapping specification document.

• Worked with Partition components like partition by range, Partition by Round Robin, partition by Expression efficient use of Multifile system which comes under Data Parallism.

• Perform Transformation and validation process

• Coding, testing, modifying, debugging, documenting and implementation of Ab Initio Graphs.

• Analyze functional requirements, mapping documents, assist in problem solving and trouble shooting..

• Used EME to checkin /checkout the graphs

Project – 3 Mar 2008 – Jan 2009

Project : Personal Line’s Warehouse System

Client : Traveler

Role : Team member.

Technologies used : Ab Initio, Oracle, Unix

Team Size : 6

Project Summary

This project involves populating data marts from various source systems constituting various insurance products. It involved extraction of files using ETL and loading it into warehouse after matching the data between various insurance entities of each product.

Responsibilities:

• Gathering ETL requirement and design the requirement specification

• Extracting Data from various sources such as Flat files, oracle and load into Staging Area

• Prepared the test cases and test criteria for the developed graphs.

• Development of generic extraction, transformation, dimension creation graphs, fact creation and loading ABI graphs which can be used for all the dimension and fact tables.

• Prepared the test cases and test criteria for the developed graphs.

• Used EME to checkin /checkout the graphs

Personal Details:

Name : Naresh Alla

DOB : 10-06-1986.

Contact Number: +919*********

Contact this candidate