SUMMARY

• 8 years of experience in state - of-the-art mission critical and scalable end-to-end Business Intelligence/Data Warehousing/Analytics industry solutions with expertise in Discovery BI-QlikView, MS-BI (SSIS, SSAS and SSRS), Microsoft Office Performance Point Server 2007(PPS), Informatica and Business Objects and QlikView hands-on experience in analysis, and development for BI project solutions in PLC, banking, insurance, retail, Healthcare and C&HT applications.
• Technically hands-on experience incorporating full range of BI Skills with QlikView 11, QlikView Designer, QlikView Developer, QlikView Server & QlikView Publisher, MS SQL Server 2005, SSIS, SSAS, SSRS, MS Performance Point Server 2007 (PPS 2007).
• ETL, OLAP analysis and reporting processes using QlikView BI, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).
• Involved in the implementation and maintenance of high performance BI solutions-Discovery BI -QlikView, ETL, analysis (OLAP) and reporting of techno-commercial solutions for Biz Ops.
• Wrote SQL queries to test the OLTP & OLAP Databases based on changes in the functionality.
• Good knowledge of Business Intelligence/Data Warehousing (BIDW) Fundamental architecture concepts, dimensional modeling, requirements gathering.
• Knowledge on BI emerging Technologies such as SP 2012, and SSAS data mining using various mining algorithms.
• Used different functions such as counter, date and time, conditional, aggregation functions etc., for data transformation.
• Created different types of sheet objects like List Boxes, Buttons, Multi Boxes.
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Strong experience in various top ranked vendor specific tools such as QlikView & MS BI.
• Well rounded Business Intelligence/DWH background professional with experience in growth oriented and reputed organizations that give me scope to apply my knowledge and skills and be a valuable member of a team that dynamically worked towards success and growth of these organizations.
• Attention to detail & ability to work in a pressurized and time sensitive environment.
• Excellent Communication and interpersonal skills.
• Self-motivated energetic person with a positive outlook who enjoys challenging assignments and while also being good at working on multiple engagements.
• Versatile team player with excellent analytical and presentation skills.

TECHNICAL SKILLS

Dash boarding/Analytics: QlikView, Informatica, MS SharePoint, Cognos

Languages: SQL, PL/SQL, C++, VB

Database technologies: Oracle9i/10g/11g, SQL Server, Teradata, MySQL

Platforms: Windows Server 2008, Linux (Ubuntu).

Others: MS Access, MS-Excel, MS InfoPath, Visio

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Evansville, IN

Sr. QlikView Analyst/Developer

Environment: QlikView 11/11.2, Oracle 10g,SQL Server 2005, MS Access, MS Excel, .CSV Files, Windows 7.

Responsibilities:

• Analyzed requirements and gathered data for designingQlikViewapplications.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Proposed and created new business analysis for data, which has no prior reports.
• Created Dashboards style of reports using several QlikView components like List Boxes, Sliders, Buttons, Charts, and Bookmarks.
• Created these reports using charts like Pie, Bar, Line, these made reports more user friendly to analyze.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Extracted information from different data sources like Oracle, SQL Server, MS Access and flat files by using different scripts like add, concatenate, resident, qualify and unqualify.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Working knowledge of QlikView Server, QlikView Publisher and QlikView Enterprise Version.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards.
• Responsible for post-production support and maintenance.

Confidential, Little Rock, AR

QlikView Developer

Environment: QlikView 11, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows 7, Microsoft Visio.

Responsibilities:

• Delivered advanced and complex-reporting solutions such as Dashboards and Standardized Reporting using QlikView 11.
• Enabled the features that are requested by the clients and made them understand the new features.
• Created Dashboards style of reports using QlikView components like List Box, Multi Box, Slider, Buttons, Charts and Bookmarks.
• Developed extensive Alerts, Variables, Input Boxes, calendar & Macros.
• Developed ad-hoc reports to see how revenue, cost and gross profit are comparing against forecasted budgets and actuals.
• Implemented Star schema & Snow Flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved issues with loops.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Implemented Incremental Load to improve Load Times.
• Read and gathered QlikView planning requirements.
• Tested Applications, ensuring the application met the requirements, Data quality for Quality Assurance before delivering to the end users.
• Installation/Configuration of QlikView 11.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Participated in the UAT process along with business users.
• Supported multiple clients and responsible for ad-hoc queries which were raised by client users.
• Creating client setup on server for different clients and providing the access to the users, distributing the application.

Confidential, Detroit, MI

Business Systems Analyst/QlikView Developer

Environment: QlikView 10, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows 7, Microsoft Visio.

Responsibilities:

• Worked with the user community and senior management to identify the business’ reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Worked with different LOBs to understand the reporting and analytics requirements
• Converted Cognos reports to QlikView dashboards.
• Built multiple dashboards and presented to different user groups to make them understand the functionality of dashboards.
• One of the dashboard built was ATM transaction tracker dashboard. It tracked the ATM usage in the country by region and division.
• Worked with Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping Functions.
• Used various KPI's for calculation purposes.
• Data was sourced from db2 environment. Used QlikView functions to load data viz Load, resident load, concatenate and so on.
• Created multiple tier QVD architecture. Created base layer, transformation layer and presentation layers.
• Created various sheets objects like Bar charts, Line graph, Straight table, pivot table, combo chart. Created complex expressions in charts.
• Involved in user training. Mentoring other team members.

Confidential, Malvern, PA

QlikView Developer

Environment: QlikView 9, SQL Server, Team Foundation Server, MS Excel.

Responsibilities:

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing QlikView Applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Used QVD generator QVW file to create the QVD’s. In the QVD generator file the data is imported from the SQL Server.
• Used Macros and Extensions in the dashboard developed.
• Used Document level and Field level triggers based on the requirements.
• Good experience in using the QlikView functions (Trim, Match, Like, String etc.)
• Implementing the Section access to the application developed and then deploying it to the server.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards.

Confidential, Irvine, CA

QlikView Developer

Environment: QlikView 9, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows 7, Microsoft Visio.

Responsibilities:

• Wrote scripts to build a relational data model within QlikView from multiple sources: SQL Server, Oracle, Access, Excel, and text files.
• Designed star / snowflake schema and hierarchies for best practices.
• Expert level understanding in writing Macros and variables to expand QlikView functions, add user-friendly features, and build reusable master framework.
• Solid understanding of QVD / QVW / QVS and QMC / QEMC management, bulk data and incremental load.
• Set up security for applications and data reduction by business sectors by using QlikView Section Access and Hidden script.
• Implemented QlikView Desktop and Server, managing user authorization, established Publisher tasks, streamlining loading procedures, and reviewing logs.
• Generated and controlled security of PDF reports, bookmarks, collaborative panel.
• Tested Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Confidential, Smithfield, RI

QlikView Developer

Environment: QlikView, SQL Server 2005, Oracle 10g, Windows Server 2003, Windows XP, Microsoft Visio.

Responsibilities:

• Worked with the user community and senior management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Developed a systems architecture forQlikViewimplementation identifying the data sources and target reports match.
• Developed a technical architecture of the ETL process and the refresh challenges/resolution.
• Worked on a plan to develop the process for remote systems administration and ongoingQlikViewapplication enhancement and maintenance.

Confidential

Informatica Developer

Environment: SQL Navigator 4.5 Oracle 9i, Windows Server 2003, Windows XP.

Responsibilities:

• Gathered business user’s reporting requirements and prepared the requirement specifications document. This involved interviewing the business users and understanding the current reporting system.
• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.
• Analyze, Design and Developed CP/CR Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model / layers with dimensions & time series objects, presentation layers with presentation catalogs, LDAP security using variables
• Design and developed various Dashboards /Reports that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
• Used BI publisher to customize and extend the reporting content delivered.
• Created Role based authorization and access to report folders and data sources for BI Publisher.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed many Mappings using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the CP/CR data
• Extensively used DAC to configure, monitor and schedule ETL routines.