SUMMARY

• 6 years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing and Business Intelligence.
• Certified Qlikview developer Version 10.Attended direct training from Qliktech.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview. Good at working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• 5+years of Experience in working with Qlikview components such as Qlikview Desktop, Qlikview Enterprise Management Console(QEMC), Qlikview Publisher.
• Experience in working with different operating systems like Linux, Windows XP, Windows 7, Windows 2003 Enterprise Serverand Windows Server 2008 R2.
• Hands on experience with Creating QVD’s, working on incremental loads, data model designing and writing complex functionalities or KPI’s in Qlikview.
• Interacted with Customers for requirement gathering and effective analysis.
• Experience in interacting with end users to gather requirements for reporting.
• Coordinated and acted as a liaison between the business groups and the IT department.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Having good noledge of Data Modeling Concepts (Normalization, Star Schema and Snowflake Schema).
• Experience in development of ETL scripts for Data Modeling along with resolving Synthetic tables and Circular Loop issues
• Expertise in Installing and Configuring QlikviewDesktop, Qlikview Server components.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Expertise in handling all four environments of Qlikview Development, QA, UAT, Production servers and configurations.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Adept in reviewing and analyzing the Business Processes, Business Process Flows and implementing Qlikview Solutions
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Involved in analyzing the Business objects reports to convert them to Qlikview
• Having sound noledge on ETL tools like Datastage.
• Worked with clientsto migrate from traditional static Excel reporting to a more interactive and powerful dashboard solution.
• Excellent interpersonal and communicationskills, technically competent and result - oriented with strong problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Qlikview 8.5/9.0/10/11

ETL: Datastage

Databases: Oracle 9i/10g, UDB2,Flat files.

Operating Systems: Windows 2003 Enterprise Server, Windows Server 2008 R2, XP,.

PROFESSIONAL EXPERIENCE

Confidential - New York

Sr. Qlikview Developer

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Understand the business requirement of the dashboard and making sure dat user interface reflect the requirement so dat business can make better business decisions.
• Expertise in working closely with database team with getting the data in the format dat meets the business requirements.
• Expertise in preparing the System Requirement specification and Design Specification documents
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Developed Link tables, used join; concatenate functions and other functions for the data model in Qlikview.
• Working noledge on QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart, Pie Chart, Grid chart).
• Experience in developing User Interfaces and objects for Management Dashboard reporting using Chart-Box( Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars and Date Islands.
• Demonstrated QlikView data analyst to create custom reports, charts and bookmarks.
• Good Exposure to working with Qlikview Functions and Expression Scripts and Streamlining Reporting operations of Qlikview Applications
• Expertise in making sure dat all the development of dashboard is done with Qlikview development checklist. We will be doing a code review of dashboard and point out the teams the changes need to be made to make the dashboard performance improve.
• Involved in User acceptance testing of the dashboard to validate the data and correct any issues regarding the dashboard or data.
• Involved in creating change request for the dashboard deployment to production and support the dashboard after the production Implementation of security in Qlikview Applications at Document and Server Level.
• Implemented session access to enterprise level document.
• Involved in managing the Qlikview Licenses to the users (Named CAL, SessionCAL, Document CAL)

Environment: QlikView11 SR4, SQL Server 2008, Windows 7, Windows Server 2008

Confidential -Detroit, MI

Sr. Qlikview Developer and Jr. Datastage developer

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Expertise in preparing the System Requirement specification and Design Specification documents Using MS word, Visio. Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad-hoc reports by leveraging the basic components of Qlikview.
• Expertise in recommending/following best practices for Qlikview development as recommended by Qliktech.
• Analyze the business requirements and collect the necessary information for Dashboard building such as Database objects from EDW team, UI design requirement from users.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify, etc…
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in building QV objects for different requirement such as straight table, pivottable, differentcharts (Bar Chart, LineChart, and Scatter Chart).
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Involved in the writing scripts for extracting of QVD’s for different cuts of data.
• Expertise in writing complex Set analysis for the KPI calculation in the Dashboard.
• Expertise in building the dynamic and robust dashboards using latest Qlikview 11 features like dimensions, expressions enable conditions, comparative analysis
• Expertise in defect solving for the Dashboard during the QA testing.
• Supported QlikView Administration tasks.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Involved in publishing of the dashboard to the users using Qlikview Publisher.
• Implemented session access to enterprise level document.
• Involved in managing the Qlikview Licenses to the users (Named CAL, SessionCAL, Document CAL)
• Automated Qlikview jobs in Qlikview Publisher and rolled out to Qlikview Access Point and administered Security using Active Directory
• Analyzed the existing Qlikview data model, script logics and the ETL business logic for the existing Qlikview applications
• Executed the scripts and checked the incorporated script changes in the Application
• Improved the overall performance of the application and redesigned data model applying Qlikview performance tuning techniques
• Published Client application using Qlikview Publisher and rolled out to Shared Drive with security permissions using Active Directory features
• Implemented & involved in Security Deployment of Qlikview Applications.
• Involved in UAT of the Dashboards and make necessary changes required

Environment: QlikView 10,11, DB2, Windows 2008 R2,Datastage 7.5

Confidential

Qlikview Developer and Support Member

Responsibilities:

• Working closely with the Business users to get the requirements for managing Qlikview Server and publisher.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Involved in gathering and documentation of QlikView application requirements from end users.
• Developed data model compactable with Qlikview for developing Dashboard.
• Gathering data sources QVD files, Excel, Oracle, SQL Server& Teradata DWs, binary QVW, Inline &txt files in developing the Qlikview Data Models.
• Developed KPI’s and set analysis applications
• Involved in managing the Qlikview Licenses to the users (Named CAL, SessionCAL, Document CAL)
• Expertise in managing the server configurations for better performance.
• Expertise in migration of dashboards to production following the guidelines set by Confidential like to get 4 levels of approvals, migration of the document, setup the tasks in publisher and test them.
• Expertise in recommending best practices to all the development teams in Confidential Corporation.
• Expertise in making sure dat all the development of dashboard is done with Qlikview development checklist. We will be doing a code review of dashboard and point out the teams the changes need to be made to make the dashboard performance improve.
• Expertise in implementing Localization of the Qlikview Access point to any native language the users requests for.
• Expertise in handling all four environments of Qlikview Development, QA, UAT, Production servers and configurations.
• Expertise in implementing Governance Dashboard to monitor the QVD, QVW statistics which is very halpful in administration.
• Developed pivot tables, Straight tables, charts like bar, line, pie, grid charts for the Dashboard.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify,unqualify,etc…
• Involved in UAT of the Dashboards and make necessary changes required
• Involved in analyzing the Business objects reports to convert them to Qlikview

Environment: QlikView 8.5,910 SR2Desktop, Server/Publisher, Oracle 9i, Windows 7,Windows Server 2008 R2.