| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name EMAIL AVAILABLE PHONE NUMBER AVAILABLE
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.
|
