SUMMARY

• Over 3 years of experience in Information Technology with extensive experience in the field of Business Intelligence (BI) leveraging QlikView, designing and developing of QlikView Applications for various types of industries
• In Depth Knowledge in Requirement Gathering, Designing and Data - Modeling for QlikView Dashboards.
• Expert knowledge in Data Visualization and User Interphase.
• Implemented Incremental Loading for various projects using the QVD Files, which would make the QlikView Dashboards to work efficiently.
• Excellent knowledge in extracting data from various Data Sources like Excel Files (.xls), CSV Files (.csv), XML Files (.xml), MDB Files (.mdb,. accdb), Oracle 10g/9i, SQL Server 2005/2008, DB2 9.7 Database and other Databases.
• Expertise in implementing 3-tier architecture (Data-Extract, Data-Modeling and Application Development).
• Responsible for migrating of QVW files from Dev. to Prod environment during the Production window schedule times.
• Interacting with Business Analysts to make them understand the advanced features and capabilities of QlikView Tool for the successful implementation of QlikView Prototype and PoC (Proof of Concept) projects.
• In-Depth Knowledge on How-To eliminate the Synthetic Keys and Loops in the Data-Models, as the existence of Synthetic Keys, Loops might yield unwanted results and sometimes might occupy the entire Server’s memory.
• Extensively usedQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc), Loops, Conditional Statements and Variables.
• Worked Extensively on QlikView Dashboard Prototypes and interacted with Customers, End-Users directly to gather requirements and show the various advanced features of QlikView.
• Expert Knowledge with Set Analysis, which would make QlikView a very Flexible Tool for analyzing Various Sets of Data.
• Well Versed with the latest QlikView Version 11 which has advanced, powerful Options like Dimension Limits, Alternate States to mention a few.
• Worked on all kinds of Charts like (Bar Chart, Line Chart, Pie Chart, Mekko Chart, Block Chart, Funnel Chart, Radar Chart, Scatter Chart, and Grid Chart), Gauges and Straight Table, Pivot Table, Date Pickers, Sliders etc.
• Created QlikView Publisher Task in QMC to Reload & Distribute the QlikView Dashboards to the Access Point (the centralized browser-based app to view QlikView Dashboards).
• Implemented Section Access on various QlikView Application so that the Data in the Dashboard will be filtered based on the User’s Access privilege.
• Business Intelligence experience using Business Objects XIr2/6.5, BO Designer, BO Reporter, Info View, Web Intelligence.
• Created Cross tab reports and Embedded Charts along with report to create an Enterprise Dashboard.
• Strong troubleshooting skills, created error alert dashboard
• Experienced in design and development of Complex Universes
• Good Knowledge of database experience using Oracle 11g/10g/9i/8i, MS SQL Server 2005, MS Access 2000/7.0, TOAD, PL/SQL, SQL and SQL*Loader, SQL Navigator.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Good communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

TECHNICAL SKILLS

BI Tools: QlikView 11/10/9, BO, SSRS

ETL Tools: Informatica Power Center, Data Services, SSIS

Databases: Oracle 8i, 9i, 10g, 11g, MS SQL Server, Postgres, MS Access, DB2

Web Technologies: HTML, DHTML, XML

Packages: MS-Office (MS-Access, MS-Word, MS- FrontPage and MS-Excel)

Languages: SQL, PL/SQL

Scripting Languages: VB Script, Shell Script

Operating Systems: Windows 2008/2005/2000/ XP

PROFESSIONAL EXPERIENCE

Confidential, Tigard, OR

QlikView Developer /Admin

Responsibilities:

• Responsible formigratingthe QVW files from Dev to Prod environment during the Production window schedule times.
• Daily Scheduled includesPublisher TasksDaily/Weekly/Monthly on various Dashboards based on the Database updates.
• Used to createandrunthe.batfile jobs through external command in QMC.
• InstalledandConfiguredQlikView 11 onWindows 2008 R2Servers and clustered 6 servers for our production environment.
• Migrated all thePublisher Tasksfrom QlikView 10 to 11 and applied thedependenciesbetween the tasks.
• Involved in setting up theDevelopmentandPerformanceEnvironments for QlikView.
• Involved inscalingandsizingof the environment.
• Extensive experience introubleshootingthe day-to-dayissuesbased on the priority levels.
• Opened theproblemrecordsand worked closely withQlikTechon different issues.
• Experience in handling thesystembackupsbefore upgrade and migration.
• Experienced in recycling theQlikViewservices,wheneverrequired.
• Responsibleformonitoringtheshared file corruptionsin Production environment.
• Extensive experience incleaningup thecorruptedsharedfiles using power tools.
• Expertise knowledge in creating the differentODBCconnectionsto extract the data from differentdatasourceslike DB2, SQL Server, Oracle and SAS data bases
• Responsible forhandlingthecommunication/noticesto all the QlikView community in Organization.
• Extensive experience inpro-activemonitoringof the environment.
• Extensive experience in performing thedisasterrecovery
• Documentedall the activities performed in QlikView Environment.
• Worked with Business partners
• Worked with QlikView 10.x, 11.x SQL Server, Oracle, SAP, Excel, flat files.
• Involved in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies and related interfaces.
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Implemented the 3-tier architecture, Data Extract, Data Model and Application. Data Extract would load the Data from the data sources into the QVDs. Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Multi boxes, Tables and List Boxes
• Designed the Data-Model using various data sources like Oracle 10g/DB2 Database, XML and Excel Sheets.
• Developed QlikView (dashboards, reports etc.), analyzed the Data and involved in gathering requirement.
• Created Dashboard of reports usingQlikViewcomponents like List Box, Slider.
• Developed Variables, Input boxes, calendar & Macros.
• Developed Linked Tables, Concatenation and solved the loops issues
• Implemented Section Access on the Financial Dashboards where users belonging to specified Windows AD group will be able to view the Dashboards based on their privileges defined in the QlikView Application
• Designed rank, Exceptional reports according to the customer needs
• Expertise knowledge in Data-Modeling
• Extensively worked with Set Analysis in some of the Dashboards which I worked on.
• Partnered with the QlikView team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility
• Involved in gathering customer business and technical requirements and write high-quality requirements documents.
• Involved in Implementing and integrating BI and ETL software platforms into a customer’s environment
• Document all deliverables before moving to production.

Environment: QlikView 11.x,10.x,Oracle 11g, DB2 9.7, SQL Server 2008, Teradata, MS Office, Windows 2008 R2 Server, Toad, Excel Files, Flat files, Informatica Power Center, Agile methodology

Confidential, Menlo Park, CA

QlikView Developer

Responsibilities:

• Worked on Sales force Dashboard (SFDC) on the development and performance side.
• The main agenda of this project is performance and some tweaks on front end
• Cleaning up the data, alerting data issues, Restoring whole QMC and changing dependences
• Working on server performance and alerting dashboard effects on server performance
• Developing some new reports which include ad hoc reports and some sheet objects which include major KPI’s
• Started analytical dashboard from scratch for TurboTax Life cycle, Growth analysis from past years and defects from past years in each tab compared with different states data.
• Implemented section access on dashboards, which give access to only few executives in the group to confidential data.
• Helped end users to design test cases and worked through multiple UAT cycles
• Experienced in creating and running the .bat file jobs through external command in QMC.
• Extensive experience in troubleshooting the day-to-day issues based on the priority levels.
• Opened the problem records and worked closely with QlikTech on different issues.
• Extensive experience in recycling the QlikView Services in Dev., Test and Prod environments.
• Experience in pro-active monitoring of the environment.

Confidential, Tustin, CA

QlikView Developer

Responsibilities:

• We started from scratch and developed many working dashboards in 1 Year with limited resources
• Involved in various Prototype Designs and helped the Business Analyst to understand the capabilities of the QlikView Tool.
• Designed Dashboards like Contracts Module which gives contract details on each single system, Forecasting details, Life cycle and some other analytics requested by users
• Developed Dashboards for the Financial Details of the company with Charts based on the Metrics Revenues, Expenses, Income, Returns, Margins etc.
• Identified the KPIs for the QlikView Dashboards like Loan Revenue Tracking, Portfolio Risk,
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Designed the Data-Model using various data sources like Oracle 10g/DB2 Database, XML and Excel Sheets.
• Implemented the 3-tier architecture, Data Extract, Data Model and Application. Data Extract would load the Data from the datasources into the QVDs. Data Model will define the relationships between the tables (QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and ListBoxes.
• Implemented Section Access on the Financial Dashboards where users belonging to specified Windows AD group would be able to view the Dashboards based on their privileges defined in the QlikView Application.
• Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.
• Scheduled the Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on the Database updates.
• Responsible for documenting all the activities performed in QlikView Environment.
• Involved in setting up the Development and Performance Environments for QlikView.
• Extensively worked with Set Analysis in some of the Dashboards, which I worked on.
• Worked with QlikView 10.x, SQL Server, Oracle, DB2, Excel, flat files.

Environment: Qlikview 10.x, Oracle 11g, DB2 9.7, SQL Server 2008, MS Office, Windows 2008 R2 Server, Toad, Informatica Power Center, Agile methodology.