SUMMARY

• 7+ years of experience in Data Warehousing and Business Intelligence includes experience in various organizations and industries like NGO, Service firm, Automobile, Pharmaceuticals, Oil & Gas.
• 3+ years of experience in designing, developing and deployment of QlikView Applications.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good Knowledge and hands on experience of QlikView Server, Publisher, Enterprise version.
• Implemented Data - Extract, Data-Modeling and Application Development in QlikView.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.
• Developed QlikView Dashboards using Chart, Input Field, List Box, Table Box, and Calendar & Date Island.
• Proficient in design and development of various Dashboards, Reports utilizing QlikView visualizations like bar graphs, scatterplots, pie-charts, Geographic’s and other making use of actions, local and global filters according to the end user requirements.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields etc.)
• Designed efficient Data-Models from Multiple Data sources and Expertise in QlikView scripting, Data Modelling and ETL Process.
• Retrieving external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Implemented security (Authentication and authorization) at document level and at the server level in QlikView applications.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Expertise in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Implemented Section Access and hidden script to protect from unauthorized access.
• Managed the licenses (CALs) of the users based on the position and requirements.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Strong Database experience in Oracle, DB2, MS Access, Teradata, SQL Server, SSIS, SSRS, TOAD, UNIX.
• Extensive knowledge in SQL, PL/SQL & T-SQL programming and trouble shooting.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedure written in different databases.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS

Database: Microsoft SQL Server, Oracle, DB2, Teradata, Access.

ETL Tools: SSIS, Informatica.

Reporting Tools: QlikView 8.5/9/10/11.0/11.2 , Qlik Sense 1.1, Business Objects, Dashboards, Crystal Reports.

Programming: SQL, PL/SQL, HTML, XML, Java Script

Tools: MS Visual studio 2008, Toad, Excel

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

QlikView Developer

Responsibilities:

• Involved in gathering requirements from end users, modifying various technical & functional specifications.
• Interacted with Business Users and Business Analysts to understand the requirement and reviewed High level design documents, Functional Specifications documents.
• Gathering data sources like QVD files, Excel, SharePoint, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Followed Multi-Dimensional Modelling Techniques such as Star Schema, Snow Flake Schema, Link Tables based on the requirement.
• Followed the 3-Tier architecture methodology in developing the QVW document.
• Created QVD’s from the Connection strings & updated on timely basis. Developed ETL Scripts while loading the data, resolving loops, synthetic keys & ambiguity joins.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Designed Dashboards that identify the KPIs, setting thresholds values, informing the end users through the Alerts.
• Developed User Interactive Sheets & Reports as business needs. Writing SQL Scripts to load the relevant Data inQlikViewApplications.
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island and Extension Objects.
• Experienced in using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields, etc.) for creating dashboards, and designing the User Interface based on business/user requirements.
• Managed the QlikView Management Console (QMC) in assigning the license (CALs) to the required, publishing the document on to the server, setting triggers and troubleshooting by verifying the generated Log files.
• Restricting the unauthorized users, applying Section access and Hidden Scripts to ensure the safety of the documents.
• Setting up Server, Publisher configurations and Security authorization at different levels.
• Creating various QlikView reports and publishing them through the publisher as per client’s request.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView v11.2, SQL Server.

Confidential, Harrisburg, PA

QlikView Consultant

Responsibilities:

• Involved in the discussions with End users, Business users in Business Requirements gathering and designing the application.
• Collected Data from different sources like Excel, SQL server, Oracle and designed and developed the complex QlikView Data Models.
• Created and maintained OLE DB/ODBC connections for all environments.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Developed User Interactive Sheets & Reports as business needs. Writing SQL Scripts to load the relevant Data inQlikViewApplications.
• Used different available Load types (Resident, Binary, Incremental, Inline etc.) in QlikView for performance Tuning and Optimization.
• Developed Variables, Input Boxes, Master calendar, YTD, YTM, applied Triggers, Alerts in the application.
• Created Ad-Hoc reports in Dashboards as requested by the End Users.
• Developed QlikView Dashboards using various Sheet Objects, Functions (Script, UI), Set Analysis, and Alternate States etc.
• Extensively worked in creating various QlikView reports and publishing them as per client’s request.
• Implemented security (Authentication and authorization) at document level and at the server level in QlikView applications.
• Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Worked through different testing phases like QAT, UAT and production support after the application has been deployed. Participated in Training sessions for the end users.

Environment: QlikView v11, SQL Server and UNIX.

Confidential, Cleveland, OH

QlikView Consultant

Responsibilities:

• Performed Business Requirement gathering & designing QlikView applications.
• Developed Macros, Set Analysis, and Section Access to provide custom functionality in QlikView Applications.
• Performed analysis, documentation for calculation for various attributes.
• Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual.
• Utilized Incremental load concept for the update of QVD’s.
• Created and maintained OLE DB/ODBC connections for all environments.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island
• Created Dashboards style of reports using QlikView components like Slider, Buttons, Charts, and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc...)
• Worked with QlikView 8.x, upgrade to 9.x, SQL Server, Excel, flat files.
• Experience in setting up Server, Publisher configurations and Security authorization at different levels.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: QlikView v10/9, SQL, Oracle 10g, Access, .CSV Files.

Confidential, Cambridge, MA

Business Analyst/Developer

Responsibilities:

• Coordinated meetings with business users and development teams to gather System requirements and data requirements.
• Involved in design, development and documentation on various phases of product life cycle.
• Conducted discussions with Business Analysts (BAs) and end users to create several test scenarios for running the reports.
• Developed QlikView transformation Scripts.
• Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.
• Implemented Data-Extract, Data-Modeling and Application Development in QlikView.
• Developed Alerts, Variables, Input boxes, calendar & Macros.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER, Oracle 10g, .CSV and excel files).
• Worked with Installation and Configuration of QlikView.
• Developed QlikView Dashboards and QlikView Functions.
• Added the access management by creating users, user groups and folders.
• Applied security settings in Dev, QA, UAT and Production domains by adding row level and object security.
• Performed unit testing, system testing and user acceptance testing (UAT) for reports

Environment: Oracle 10g, SQL Server, Access.

Confidential, Houston, TX

Business Objects Developer

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes.
• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where). Created complex reports using different data sources.
• Developed customized Dashboards for efficient Reporting.
• Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
• Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
• Tested the created reports and modified the relevant objects in the Universe.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence

Environment: Business Objects XIR3, Oracle, Access, SQL Server, UNIX shell programming.

Confidential

BO Developer (AMS-Support)

Responsibilities:

• Work included Developing, Testing and enhancing existing Business Objects Universes.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements,Also solved any issues/errors encountered.
• Responsibilities required acting as the Key Person for maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data analysis etc.
• Have resolvedloops, Fan Traps and Chasm trapsusing context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Used Polestar for better interaction with predefined data sets to generate visualized reports.
• Extensively used Calculations, Variables, Break points, Sorted inputs, Drill down, Slice and Dice, Alerts etcinCreating Reports, formatted old reports, generated charts, bars etc. as per user requirements using Crystal Reports XI, Crystal Xcelsius 4.5.

Environment: Business Objects XI R2, BI 7.0, Crystal Xcelsius 4.5, Crystal Reports XI, WebI, DeskI, SQL Server 2005