Manager Data

ISAAC DAPPU

Employer E-mail: ***@**************.***

Employer Contact: 734-***-****

SUMMARY

. Eight Plus years of IT industry experience in all aspects of Business

intelligence applications with a strong background in Database

development, Data Warehousing/ Decision support systems and Business

Intelligence (BI).

. Five Plus years of experience in Designing and Development of Business

intelligence applications with Qlikview 11.2/10.0/9.0 as BI tool.

. Strong Knowledge & experience in all phases of Software Development Life

Cycle (SDLC) such as developing, testing, Migrating, Administrating,

security management and production support.

. Strong experience in Qlikview Product family such as Qlikview Desktop

Client, Qlikview Management Console, Qlikview Server.

. Strong experience in Scripting, developing and designing dashboards using

QlikView by extracting data from multiple sources (Oracle, Flat files,

Excel, Access).

. Experience in using ETL Tasks such as data cleansing, joins, aggregation

tables using Qlikview.

. Designing Data Mart and Data Warehouse and Implementation of Qlikview for

BI Reporting Solutions.

. Extensive knowledge with Dimensional data modeling, star schema, snow

flake schema, Fact and dimensional tables.

. Created scheduled jobs for QVD extracts and report reloads.

. Developed business requirements, dashboard development, and data

verification and analysis.

. Deployed QVW's on the production server, Created Reload and Distribution

tasks on QlikView Server/publisher.

. Experience with Multiple Relational Databases including Oracle, MS SQL

Server, DB2 and MS Access.

. Experience with Qlikview sheet objects Pivot, List, Multi box, multiple

charts types, KPI's, custom requests for Excel Export, and Fast Change

and objects for Management Dashboard reporting.

. Excellent technical, analytical, and problem solving skills. Strict

attention to detail and ability to work independently as well as within a

team environment.

. Extensive use of SET Analysis expressions in the charts for achieving

complex logics.

. Implemented Best Practices to resolve Circular Relationships, Synthetic

Keys in QlikView and designing an optimized Data model.

. Expertise in implementing Oracle BI Apps like implementing Out of order

Box prebuilt mappings, Creating Oracle provided Data Warehouse,OBIEE RPD

development, OBIEE reports and Dashboards, Upgrading the versions.

. Expertise in complete lifecycle Implementation of Business Intelligence

with Star and Snow flake Schemas.

. Worked extensively on Informatica power center 9.x/8.x/7.x. (Repository

Manager, Designer, Workflow Manager, Workflow Monitor and Administrator

console)

. Implemented data warehousing methodologies for Extraction, Transformation

and Loading using Informatica Designer, Repository Manager, Workflow

Manager, Workflow Monitor.

. Experience in creating Reusable Transformations such as Update Strategy,

Lookup, Expression, Joiner, Aggregator, Sorter, Sequence Generator,

Router, Filter, Rank and Normalizer and Mappings using Informatica

Designer and processing the tasks using Workflow Manager to move data

from multiple sources into the targets.

. Three layers (Physical Layer, Business Model & Presentation Layer), Time

Series Objects, Interactive Dashboards with drill-down capabilities using

global & local Filters.

. Strong experience in writing SQL Queries, views and stored procedures.

. Leadership skills and Goal Oriented, Good Co-ordination and Co-operation

with the Team and Management. Adept at learning and adaptable to complex

work environment

TECHNICAL SKILLS

Business Areas Applications & Systems Analysis, Design and Development

Business Functional Areas Sales and Marketing, Finance, Operations

Operating Systems Windows

Languages PL/SQL, VB Script, Java Script

Databases ORACLE, MS-SQL Server, MS-Access, MySQL

Reporting Tools Qlikview 11.2/10.0/9.0, OBIEE 10

ETL Tool Informatica 8.x (Source Analyzer, Data warehousing designer,

Mapping Designer, Mapplet Transformations)

Data Modeling Dimensional Data Modeling, Star

Join Schema Modeling,

Snow Flake

Modeling, FACT and dimensions tables,

Physical and

Logical Data Modeling, Erwin 8

EDUCATIONAL BACKGROUND

Bachelors in Computer Science & Engineering, JNTU, Hyderabad, India.

PROFESSIONAL EXPERIENCE

DTE Energy, Detroit, MI

Feb'13 to Present

Sr. Qlikview Developer

DTE Energy Co. is a diversified energy company involved in the development

and management of energy-related businesses and services nationwide.

Electric Choice is a statewide initiative giving customers the option to

choose the company that supplies their electricity. These companies are

referred to as Alternative Electric Suppliers (AES). Providing electricity

to customers includes three separate activities: generation, transmission

and distribution. The Midcontinent Independent Transmission System Operator

(MISO) sells power from generating plants and arranges for transmission of

power over high-voltage lines for DTE Electric, Alternate Electric

Suppliers and others.

Responsibilities:

. Gathered the requirements from Business Users and passed on the

requirements to the team.

. Involved in designing the Data model and Construction of the Data

model and implemented the Star schema for QV better optimization.

. Created Dashboard reports to track all the way through ship to final

acceptance phases.

. Developed executive dashboards in QlikView delivered through the web,

enabling to measure the performance of the business with analytical

capabilities.

. Installed, configured and deployed the application on QlikView server

and Imported data from different sources such as Oracle, SQL Server,

MS Access, XML files and flat files using OLE DB/ODBC.

. Created dashboards with complex sheets which include List boxes,

Statistic boxes, and containers, different charts (bar charts, scatter

charts, Heat charts, and Block charts and pie charts) to show the

statistics of the sales held on different products in different

years.

. Created static reports using straight tables and pivot tables with

spark lines and mini charts

. Dynamically creating the WHATIF analysis reports by modifying the

input data though slider object and input boxes

. Created Layout themes and applied it to several QVW's and experience

working on QEMC

. Performed different tasks like repeat tasks, reload tasks and

distribution tasks using the QlikView Publisher.

. Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0

versions.

. Designed, developed, implemented and tuned multiple QlikView

applications for the Sales, IT.

. Used advanced scripting, Alternate states for comparative analysis,

set analysis, VBScript and JavaScript macros, advanced aggregation

functions, advanced charts for applications and Document chaining

. Involved in performance tuning of dashboards to improve the response

time for the users accessing the documents via access point by

reducing the size of the QVW

. Good understanding in the area of monitoring the various services in

QMC,Task setup, Managing client licenses, Mounting folders, session

collaboration,enable session,performance and audit logging,type of

authorisation(NTFS and DMS),loop and reduce and Section access

management in PAT

Environment: Qlikview 11.0, QEMC, SQL Server, DB2, Windows 2008 server,

HTML, VB Script & Java Script, QViewer, Microsoft TFS, MS Excel.

Systems in Motion, Ann Arbor, MI

Nov'11 - Jan' 13

QlikView Developer/Admin Consultant

Systems in Motion (SIM) are a leading enterprise IT services and Solutions

Company based in California, Michigan and Indiana. SIM's high-performance

software development centers are located in lower-cost US metropolitan

markets, but plugged into the San Francisco Bay Area's technology ecosystem

through its Silicon Valley Innovation Hub. By tightly integrating the

Innovation Hub with the development centers, Systems in Motion can deliver

the applied innovation that enterprises need, while generating significant

cost efficiency. Over the past four years, SIM has proven that its next-

generation delivery model combined with its technology expertise provides

business solutions better, faster and at a lower cost than traditional IT

services providers.

Responsibilities:

. Gather customer requirements from Business Analyst and understand the

data from different source systems.

. Extracted data from the database, stored into QVD files, and wrote

load scripts.

. Implemented QlikView 3 tier architecture data model.

. Eliminated Synthetic keys and circular loops in the data model.

. Created link tables on the needed basis and as per the data.

. Created Master Calendar and worked with date fields as per the user

needs.

. Applied mapping function to look up and fetch the required field

. Created User Interface of reports and designed the dashboard according

to the requirements.

. Created dashboard style of layouts using various components of

QlikView like List boxes, Multiboxes, slider, current selections box,

buttons, charts, text objects, bookmarks.

. Developed QlikView Dashboards using Chart Box (Drill Down, Drill up &

Cyclic Grouping).

. Constructed various graphs such as Straight table, Bar graphs, Pie

charts, Line charts Gauge charts.

. Implemented Pick Dimensions and Pick Measures as Custom reports tab at

the Dashboard.

. Extensively used variables to meet various requirements.

. Worked on set analysis and advanced aggregation functions.

. Implemented document event trigger and field event triggers.

. Implemented secure environment using QlikView Section Access.

. Worked on QlikView server and publisher to automate the QlikView jobs

and define the user security and data reduction.

. Deployed QVW's on the production server, Created Reload and

Distribution tasks on QlikView Server/publisher.

. Troubleshooting the issues and reviewed the log files to resolve the

issues.

. Manages user's access to the QlikView Server and QlikView Access

Point.

Environment: QlikView11.0 (SR2), QlikView Server and Publisher (QMC), Toad

for Oracle Base (10.6.1.3), MS Excel, Windows 2008 Enterprise.

Ameriprise, Minneapolis, MN

Jul '10- Oct'11

Qlikview Consultant

Financial Accounts application under Ameriprise is a client portal that

provides 360 degree view of clients Ameriprise accounts. This application

provides a portal that consolidates all the accounts available to the user

and provides summary, detail and transaction information for all of

client's investments & insurance accounts which clients wish to consolidate

at one place. Clients registered for Financial Accounts application will

have ability to add and remove his/her accounts which they wish to

consolidate at one place and take the advantages provided by this

application. The client can login through Single Sign-On interface

securely, check his/her account balances, and documents posted by advisor

and can make Trading, Transfer Money.

Responsibilities:

. Gathered the requirements from Business Users and passed on the

requirements to the team.

. Involved in designing the Data model and Construction of the Data

model and implemented the

. Star schema for QV better optimization.

. Created QVDs by importing data from the database tables using Qlikview

load script.

. Expert in Working with Charts such as Table Box, Pivot table, Straight

table, Pie, Gauge etc.

. Experience in Using Qlikview Functions (Date and Time, Keep, Join,

Mapping, String & input Fields etc.)

. Implemented Macros, Filters, Variables, Set Analysis, Aggregate

functions and Mapping functions to achieve user requirements.

. Created reports using Qlikview functionalities like combined queries,

include KPI formula.

. Performed functional testing of the application.

Environment: Qlikview 9, SQL Server 2005 Enterprise, Windows Enterprise

Server 2003, Visual studio 2005, SQL Server, HTML, MS-Access and MS-Excel.

WESTERN UNION, Edison, NJ

Jan' 09 -

Jun '10

Informatica Developer

Western Union Company is a financial services and communications

company having several divisions with products such as person-to-person

money transfer, money orders, business payments and commercial services.

For the money to transfer from one location to another depends on

information provided by the sender and is verified by 7 different

departments, one of which is Risk Management and Currency Control. The

details of both sender and receiver should be verified as risk free

transaction and also should meet the business rule (different for each

country) then only it is approved and the whole process of verification and

satisfaction of business rules should be finished within seconds.

Responsibilities:

. Analyzed the business requirements to implement coding using Informatica

Power Center.

. Performed migration of objects in all phases (DEV, INT and PRD) of

project and trained developers to maintain system in production.

. Analyzed the architecture to propose an ETL design solution for DWH.

. Documented the approach in the Technical design document to be approved

by the client and performed part of the data modeling in Erwin.

. Was involved in logical and physical data model for Admin Server

Project. Built the DDL and DML Scripts from the Erwin tool.

. Designed mappings and created a range of transformations to obtain

appropriate conversion between the sources and targets.

. Worked on creating the delta process, eliminating the duplicates and

implemented excellent exception handling strategies while developing

the Informatica mappings.

. As a routine, while working with design of mappings, used various

transformations like Aggregator, Lookup, Filter, Router, Expression,

Stored procedure and Sequence generator transformations.

. Developed entity diagrams and data dictionaries to accomplish tasks.

Develop logical and physical data models that capture current

state/future state data elements and data flows using Erwin.

. Generated Informatica Mappings to populate the data into dimension and

Fact tables for data classifications.

. Developed pre-session and post sessions routines for sessions to drop and

re-create indexes and key constraints for bulk loading.

. Automated the schedules for running sessions and processes with

Informatica scheduler.

. Created a database for various phases and assisted the QA team in

building test cases.

. Participated in Incident Management and production support tickets

resolution.

. Developed an understanding on grids, nodes, repository services and

integration services.

. Solved various production issues and worked along with the Informatica

global support to troubleshoot failures.

. Created Folders and managed user group access to objects in the

repository.

. Performance tuning of the Informatica mappings using various components

like parameter files, variables and Dynamic Cache.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL*Plus, PL /SQL,

UNIX, TOAD.

Pyramid Solutions, Hyderabad, India

Aug'08-Dec'09

OBIEE Consultant

Pyramid Solutions is an application development services enable

organizations to create a comprehensive application strategy to enable

business transformation. I was involved in Designing and developing

database packages, procedures, functions and involved in various other

modules. The Patient Billing Software is a local software system. This

system can be used to maintain the location (bed no.) of each patient

either in the ward or the ICU. Information about the patient and the

charges to be paid is also stored. This system keeps track of transfers

from ICU to GEN or vice versa.

Responsibilities:

. Translated the business requirements into conceptual and detailed

technical design documents.

Identified the granularity level of the data required to be available

for analysis.

. Worked as an Application Designer for Mapping & Designing RPD and ETL

development.

. Documented Application Design Mapping & ETL Mapping, which helps

Developers to implement ETL and RPD.

. Designed and Developed Custom Business Intelligence Solutions

(Metadata and Dashboards/Reports) using OBIEE platform.

. Developed the OBIEE Metadata repository (.rpd) model with the

necessary logic that involved creating the Physical, BMM layers with

aggregates, dimensions & time series functions, Presentation layer

with catalogs & folders and external table security using Siebel

Server Admin tool. Also created hierarchies, variables, and event poll

strategies in the repository.

. Designed report sand dashboards in Siebel/OBI Answers as per the user

requirements.

Configured Interactive Dashboards with drill-down capabilities using

global and local Filters.

. Implemented Dynamic Navigation to allow the system to pass parameters

from the summary dashboards to the details dashboards.

. Managed OLAP databases in development, test, staging and Production

Environments.

. Implemented Groups and Hierarchy Level Based security to dashboards

based on Role.

. Configured and automated iBots to deliver daily and weekly reports

based on schedule.

. Performance Tuning of Reports by implementing the aggregate

navigation, Cache and Oracle Materialized Views.

. Involved in the Development of Custom Mappings, Sessions and Workflows

using Informatica.

Environment: Oracle 9i, Oracle Enterprise Manager, Oracle Developer 6.0/6i,

SQL, Informatica8.6.1, SQL*Plus, Windows 2000, UNIX (Sun Solaris), TOAD.

UBS, Hyderabad, India

Dec '06- May'08

PL/SQL Developer

It's a comprehensive ecommerce application aimed at providing secure twenty-

four hour online Banking support. The application primarily consists of

modules that provide a consolidated statement of all your UBS accounts and

loan activity, and also used to see which checks have cleared, or review

the complete transaction history of any of your accounts, provide

functionality for fund transfer between accounts with UBS Online banking

and provide support for all the other UBS products & services like checking

accounts, saving accounts, installment loans, overdraft protection.

Responsibilities:

. Interacted with users, team lead, DBA's and technical manager to fully

understand the requirements of the system.

. For complex business queries involving multiple tables from different

databases used Joins, correlated and non-correlated sub-queries

. Created new Procedures, Functions, Triggers, Materialized Views,

Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table

functions as part of requirements.

. Enforced business rules via checks and constraints.

. Developed SQL queries to fetch data as per the business requirements

with proper tuning techniques.

. Created checks and constraints to maintain data integrity across the

data in the database.

. Created Stored Procedures to generate various Drill-through reports

and functions to support efficient data storage and manipulation.

. Migrated actuate code of data extract to PL/SQL equivalent and Created

PL/SQL functions, packages, procedures and joins.

. Worked on various back-end Procedures and Functions using PL/SQL.

. Wrote necessary PL/SQL API scripts for successful running of the

programs.

. Created required technical documents, technical specifications, Test

results.

. Scheduled SQL Server Agent Jobs to run every day to update changes in

the base tables.

. Used Exception Handling for handling errors of programs, scripts and

procedures.

. Analyzed the pros and cons of migration and conveyed the same to the

Business Analyst.

. Followed company guidelines and processes to complete the tasks.

. Complete responsibility of deliverables as well as the production

support.

Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP.

Contact this candidate