NAGA acp78o@r.postjobfree.com +91-784*******

Highly motivated, conscientious, detail-oriented and competent Database and Business Intelligence

developer with over 5 years of professional experience in IT with progressive development and

implementation of various Data Warehousing Projects within Banking, Telecom, Finance and Retails

domains. Excellent team player with ability to work individually when required and having good

problem solving and analytical skills. Skilled in working with both outsourced and off shore resources

and maintain worthy working relationships.

Skills Matrix

Experience in QlikView in designing and modeling of qlikview complex multiple data sources.

Good Knowledge of dimensional modeling techniques Star and Snow Flake Schema.

Extensive experience in end-to-end implementation of Qlikview life cycle Data Modelling using

Qlikview developer, Qlikview publisher, Management Console, Qlikview server and Admin skills .

Experience with thorough knowledge of scripting, data source integration and advanced GUI

development in QlikView applications and building qvds and qvws.

Involved in Requirement gathering & designing QlikView applications . Expertise in generating

reports using global variables, expressions and functions for the reports.

Experience in optimizing applications by using QVDs, removing non key fields and script

variables (Loading Phase).

Working with different type of Charts, List box Objects and Current Selection Objects.

Good Knowledge in designing Dashboards and Reports in QlikView.

Design, Build, Test, Debug, Monitor, and Troubleshoot QlikView solutions.

Experience in designing QlikView Document/User Setting, Layouts to make consistent and

Professional Optimized look to clients.

Experience in creating customized reports by applying Section Access for different clients.

Developed Scripts to load the relevant Data in QlikView Applications.

Experience in Using QlikView Functions (Date and Time, Peek and Intervalmatchetc.).

Worked with SAS BI tools such as SAS Enterprise Guide, SAS Data Integration Studio.

Worked with Excel and MI Dashboards which automatically updates the data periodically.

Experience on Teradata and Utilities like BTEQ, FastLoad, FastExport MultiLoad, Tpump,

Teradata SQL, Informatica and Oracle.

Experience working in Agile Methodology.

Mentor and monitor juniors and new joiners providing knowledge transfer, training offshore team and

track daily progress.

Familiar with complete data warehousing development lifecycle working closely with Stakeholders,

coordinating with clients when required and attending project meetings.

Ability to communicate with both technical and non-technical (customers, management) personnel.

Ability to quickly master new software and flexible to work with new technologies. Experience of

working on multiple projects concurrently.

Technical

Operating system : MS Windows, UNIX.

DBMS : TERADATA, SAS, Oracle, SQL Server, MySQL

Languages : SQL, Base SAS.

ETLTools& Utilities : Informatica, Teradata SQL, BTEQ, Fastload, FastExport, MultiLoad,

Tpump

BI : QlikView V10/11

Web Applications : HTML, PHP, Ajax, Dreamweaver, CSS.

Packages : MS Office.

Academic Background

Masters in Information Technology, UK.

Working Experience

Working as a QlikView Developer in Utopia from April 2011 to Present in India.

Went To UK for 6 Months from Sept 2014 to March 2015.

Worked as a Software Developer in Exilant Techonologies from Jan 2010 to March 2011 in India.

Worked as a Team Member in HMRC (Inland Revenue Govt of UK) from 2005 to 2009 in Newcastle,

UK (Part Time).

Worked as a Team Member in RPA (Rural Payments Agency Govt of UK) from Oct 2005 to August

2006 in Newcastle, UK (Part Time).

Professional ExperienceClient: Nationwide

Duration: March2014 to Present

Environment: QlikView, SQL Server, Oracle

Description: Nationwide is a full-service commercial bank, providing a broad mix of financial

services to businesses and individuals. The bank also offers investment and financial management, trust services,

private banking, insurance services, and global custody services.

Responsibilities:

Created Dashboards style of reports using QlikView components like List Box, Buttons, Charts and

Bookmarks.

Involved in business requirement gathering and development of functional and technical specification

documents.

Developed different dashboards with a complex database system behind it, which includes extracting

data from the database, storing into QVD files, write load scripts, and develop UI according to user

requirements.

Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the

development team.

Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview

Publisher and notified load status by email.

Optimizing existing data models including changing load scripts to load data in optimized way to

achieve reduction of loading time, simplifying complex expressions in the front-end, improving

layout structure

Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and

schedule different complex reports as per given business requirement by leveraging the basic

components of Qlikview.

Implemented Star Schema & Snow Flake Schema (Confirmed Dimensions).

Developed Linked Tables, Concatenation and solved the loops issues.

Gathered & loaded data into QlikView from various data sources.

Read and Gathered QlikView planning requirements.

Extracted data from multiple complex hierarchies from cross table flat files and websites.

Used to solve the issues related to the end users.

Installation/Configuration of QlikView

Good Working Knowledge of QlikView server, QlikView Publisher.

Client: Orange

Duration: June2013-Feb2014

Environment: QlikView, Oracle, Teradata

Description: Orange is the wireless phone provider that owns and operates the second largest mobile

telecommunications network in the United Kingdom.

Responsibilities:

Involved in Requirement gathering & designing QlikView Applications.

Gathering data sources like QVD files, Excel, Oracle& Teradata DWs, binary QVW, Inline&txt files

in developing the QlikView Data Models.

Developed QlikView Dashboards using Chart Box (Drill Down, Cyclic Grouping), List, Input Field,

Table Box and Calendar.

Developed KPIs and Set analysis applications.

Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input

Fields and more).

Developed User Interactive Sheets & Reports as business needs, Writing Scripts to Load the relevant

Data in QlikView Applications.

Created QVDs and updated on timely basis as databse updates.

Developed ETL Script while loading the data, resolving loops & Ambiguity Joins.

Testing Applications, reports using review checklists, Data Quality for Quality Assurance before

delivering to the end users.

Client: Boots

Duration: Feb2012-May2013

Environment: QlikView

Description: This Company is a leading seller for a variety of consumer goods with several branches in different

countries. The company services 5000 outlets directly. The project is implemented with the aim of analyzing and

estimating the sales trends over the time. The project includes OLAP reports were generated for decision support

to various departments of the company i.e. The Finance, Sales and Marketing departments. The project involved

building of business intelligence tools for an enterprise wide Data Warehouse.

Responsibilities:

Involved in collecting the business requirements, Building the Data Model, Creating reports as

per clients requirements.

Hands on retrieving of external data (Shared Path, Network drive, SQL etc.) to QLIK View

Dashboard in terms of QVDs by making connection through ODBC and OLEDB.

Provided support as some changes were required at the script level.

Implemented Incremental loads using created qvd files.

Used concatenate (concatenate, auto concatenate, No Concatenate) to concatenate data between

different tables.

Used Interval match function to identify discrete matching values over time.

Created Dashboard using different components of QlikView like Listboxes, Multiboxes, slider,

and buttons, charts (Bar, Line, Combo, and Gauge, Scatter, and Straight/Pivot table) etc

Client: MTS Telecom

Project: Enterprise Data Management

Duration: April2011 to Jan 2012

Environment: QlikView, Teradata, SQL Server

Description: MTS the leading telecommunications provider in Russia and the CIS, has turned to

Teradata, to make its customer retention efforts more effective and more profitable. Transactional social network

analysis and rapid outreach are now competitive advantage for MTS as the mobile operator improves customer

retention in the highly competitive Russian mobile telecommunications market. Because of the nature of business

and risk involved, accurate data is essential for efficient, profitable operations, so they introduced Active

EnterpriseData Warehouse (EDW) as the source for FIMS (Financial Information Management System).

Responsibilities:

Involved in collecting the business requirements, Building the Data Model, Creating reports as

per clients requirements.

Hands on retrieving of external data (Shared Path, Network drive, SQL etc.) to QLIK View

Dashboard in terms of QVDs by making connection through ODBC and OLEDB.

Provided support as some changes were required at the script level.

Implemented Incremental loads using created qvd files.

Optimizing existing data models including changing load scripts to load data in optimized way to

achieve reduction of loading time, simplifying complex expressions in the front-end, improving

layout structure

Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create

and schedule different complex reports as per given business requirement by leveraging the basic

components of Qlikview.

Implemented Star Schema & Snow Flake Schema (Confirmed Dimensions).

Developed Linked Tables, Concatenation and solved the loops issues.

Gathered & loaded data into QlikView from various data sources.

Read and Gathered QlikView planning requirements.

Extracted data from multiple complex hierarchies from cross table flat files and websites.

Client: Morrisons

Project: Store Ordering

Duration: Jan 2010 to March 2011

Environment: TERADATA, BTEQ, FastLoad, MultiLoad, UNIX, Informatica, Oracle

Description: Morrisons is of one of the three largest home improvement chains in UK and has 205

stores in the South. Morrisons has deployed a Teradata Data Warehouse as previous Data marts could not provide

information which business users were demanding.

Responsibilities:

Understanding mapping document, SRS, BRD, DRD.

Involved in writing the scripts using Teradata warehouse for BTEQ, FastLoad and MultiLoadto

populate them (Sales, Inventory, Vendors, Purchase Orders, and Guest Relationship Management).

Worked on the transformations in Informatica.Use of Transformations such as Source Qualifer,

Aggregator, Lookup, Filter, Sequence Generator, Router Update Strategy etc.

Implemented Join Indexes and Partitioned Primary Indexes to achieve the desired performance.

Implemented the Conversion of Legacy Files (Flat Files) module.

Involved in building the data summary by pulling the data from ODS (Operational Data Store)

into EDW (Enterprise Data Warehouse). This was done by using the existing scripts.

Client: HMRC Govt of UK

Duration: Worked as Part-time Contractor (2005-2009)

Environment: Windows XP

Description: An image is passed to an intelligent character recognition (ICR) engine to try to work

this out. If the ICR software cannot confidently read the data, the image is passed to a workstation for an operator

for keying. The images are passed to operators in a series of work steps, one for each different kind of validation.

Responsibilities:

Keying the images which are not read by ICR and doing validation.

Preparation of unit test plan, test cases, debugging and fixing the defects.

Responsible for populating data into existing tables.

Pre-validation of the Images.

Attending Monthly business update meetings, where the progress of the business was discussed.

Client: RPA Govt of UK

Project: Rural Land Entitlement and Single Payment Schema

Duration: Oct 2005 August 2006 (Part-Time)

Environment: Windows XP, Oracle

Description: Rural Payment Agency is a Government executing agency which is sponsored by

Department for Environment, Food & Rural Affairs. Project involved was Rural Land Entitlement and Single

Payment Schema.

Responsibilities:

Analysing the system, coding, Review and Testing.

Level1, Level2 Validations and Quality Control.

Responsible for populating data into existing tables.

Preparation of unit test plan, test cases, debugging and fixing the defects.

Resolved Integration and environment issues.

Attending issue resolution meetings to discuss errors raised while executing queries.

Communicating directly with the clients to validate the data and to identify genuine customers.

Contact this candidate