SUMMARY:

• Over 9 years of strong experience in IT industry with Extensive experience in Business Intelligence using Qlikview and Cognos.
• 4+ years in implementation of Qlikview dashboards.
• Involved in all the phases of Qlikview Dashboard developmentsuch as Requirements, Design, Development, Testing, Deployment and Access provisioning.
• Sound knowledge of the entire SDLC lifecycle.
• Expertise in Creating Dashboards using QlikView versions 9/10/11.
• Expertise in creating variety of Qlikview Dashboards catering to different levels of audience ranging from Executives to Retail managers.
• Extensive experience in all aspects of Qlikview Development - Data Modeling, Scripting, UI Design, Development and Optimizing.
• Implemented, optimized large volume data Models in Star, Snowflake format. Followed Best practices to eliminate synthetic keys and circular references in the model.
• Implemented features such as incremental load, binary loads, alternate states and set analysis in Qlikview.
• Implemented three tier architecture - Data extraction layer, Transformation/QVD layer, UI/Presentation layer.
• Experience in using different Qlikview functions like AGGR, Firstsortedvalue, Apply map, Match, Pick, ValueList, ValueLoop and many other Script and UI level functions.
• Developed dashboards using various Sheet Objects - Different Charts, List/Multilist Boxes, Text, Button, Sliders, Lines, Container and Input Box etc. Dashboards used many different kinds of charts such as Bar, Line, Combo, Radar, Mekko, Block, Pie, Stacked Bar, Scatter, Grid, Gauge, Straight and Pivot Tables.
• Extensive Exposure to Qlikview Server providing User access and Creating Tasks.
• Good Knowledge of Qlikview publisher implementing PDF Distribution and Data Reduction.
• Experience connecting with variety of Data sources such as Oracle, DB2, Teradata, Hana, SQL Server, Access and Flat files.
• Expertise in Cognos 10x, 8x BI including Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio.
• Extensive experience in working with OLTP, OLAP and BI verticals in Analysis, Design, Testing, Development and Implementation of Client/Server Applications.
• Excellent written and verbal communication and a very good Team player.
• Experience working in Onsite/Offshore Model.
• Ability to work in Standalone as well as big size teams with minimal transition and provides effective results.

TECHNICAL SKILLS

BI Tools:  QlikView Desktop (10/11), QlikView Server (10/11), QlikViewPublisher,IBM Cognos 10.2/10.1/8.2/8.3/8.4 CognosBI(Framework Manager,  Report Studio, Query Studio, Analysis Studio,)

Databases:  Oracle 10g/9i/8i, SQL Server 2008/2005/2000 , MS Access, HP Vertica

Data Modeling:  Microsoft Visio

ETL Tools:  Informatica 8.1,Talend

Web/App Servers:  IIS, Apache

Programming Languages:  Qlikview Scripting,SQL, PL/SQL, C and HTML

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr.Qlikview Developer

Responsibilities:

• Data churning and input XLS creation for more informative data element.
• Making Proof of concept to justify the value for the Analytics - Next in BNYM.
• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Engaged in developing Dashboard standards such as Template designs, User Interface and Navigation Design patterns.
• Directly worked with End Users to understand their requirements, worked on Demo of Prototypes.
• Designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Developed elegant and professional looking dashboards using different charts and techniques.
• Used QlikView Extensions such as Org Chart, Word Cloud and Webpage Viewer in some of the dashboards.
• Coordinated with Database and ETL teams for Data and Structural follow-ups and Design.
• Created complex expressions using set analysis and functions as per dashboard needs.
• Developed Dashboards to their best optimized format based on best practices and guidelines.
• Created various tasks in Qlikview Management Console (QMC) and managed their schedule dependency to ensure the data gets refreshed in a timely and accurate fashion.
• Created publisher tasks for PDF Distribution, Loop and Reduce for Data Reduction.
• Created QlikView Reports within the UI and used them via Publisher for PDF Distribution as Email attachments.
• Performed Extensive Qlikview Testing within Qlikview and at the data layer. Detail level of testing also performed at Script, Variables and Object level.
• Implemented Section action based on user requirement to restrict data by Service Segment.
• Involved in QA Testing, UAT and Production deployment and Support. Worked closely with QA & Users to identify and fix any reported issues.

Environment: QlikView 10/11, Oracle 9i/10G/11G, CSV Files, Windows 2008 Server.

Confidential, NY

Qlikview Developer

Responsibilities:

• My responsibilities lies with the operation team, and provide them a full-fledged Analytical overview of the present and past operational competencies, including ROI, Internal Operational perspective, ROI on different service offerings.
• Actively involved in Requirement Gathering from Business Users and Developed Technical Documentations for the Business and IT Team.
• Developed relational database model according to business requirements to create QlikView associative data model.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents).
• Created different complex sheets and sheet objects based on client requirements.
• Demonstrated QlikView data analyst to create custom reports, charts and bookmarks.
• Helped client reporting teams migrate from traditional static Excel reporting to a more interactive and powerful dashboard solution.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Used Incremental loading to handle large volume delta loading to reduce reload time and have a cumulative data for the dashboard. Also periodically archived the data based on data retention standards.
• Involved in tuning of reports for better performance.
• Performed SQL Tuning to enhance the performance of the reports.
• Implemented Section Access to filter data based on User Privileges.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Resolved issues resulting from User Acceptance Testing (UAT).
• Coordinated with Development Team & Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.

Environment: QlikView 10/11, Oracle 9i/10G/11G, SQL Server 2005, CSV Files, Windows 2003 Server.

Confidential, MD

Qlikview Developer

Responsibilities:

• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Customized Qlikview Connection with appropriate reports and security measures.
• Worked with the offshore Qlikview team and handed them different responsibilities key to the project
• Designing the Logical model that conforms to star schema concepts, different views (Import, Business and External) as per Business requirement.
• Designed and developed dashboards with various levels of complexity including different kinds of charts and extensions.
• Maintained Row, Column and Sheet level Securities for all Major Dashboards using Section Access.
• Handled the end-to-end implementation of QlikView dashboard deployment.
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Modifying the existing reports based upon the change requested by the user. Involved in resolving Performance issues with various reports.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Unit testing, Integration testing and System testing of the reports in Development, Testing environments.
• Participated in the UAT process along with business users and ensured an effective delivery of dashboard applications.
• Worked on Performance testing of Dashboard and also data validations using independent queries and raw data analysis.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

Environment:QlikView 9/10, Oracle 10g, SQL Server 2008, Access, MS Excel, XML Files, Windows 2003 Server, SharePoint.

Confidential

Cognos Developer

Responsibilities:

• Involved in gathering Business Requirements from Business Analysts and Users
• Identified the dependencies and designed the approach.
• Analyze the requirements for the development/ enhancements/ defects.
• Designed and developed Cognos 8.4 Framework Manager Models and packages.
• Participated in complete implementation process and strategies.
• Developed Ad-hoc Packages as per user requirements
• Develop Customize and Burst Reports using Report Studio.
• Using Report studio developed reports like lists, Grouped lists, Charts, Cross tab reports.
• Unit testing of reports developed in Report studio.
• Provide functional and technical guidance to the team.
• Ramp up the resources on technologies used in the project.
• Ensure reports are developed and deployed in correct environments in time and according to customer requirement
• Deployed packages and reports from development environment to test environment and to production environment.
• Interacted with Development and Management Teams and provided technical assistance to Developers

Environment:Cognos series8 (version8.4), Framework Manager, Query Studio, Report Studio Cognos Connection and Oracle9i.

Confidential

Cognos Developer

Responsibilities:

• Worked on creating List Reports, Cross-Tab Reports and Chart Reports using multiple queries in a single report and by using Filters, Calculations and Conditional Highlighting.
• Developed reports with Value Prompts and Boolean Variable.
• Worked on Summary Reports and Detail Reports.
• Created Drill through Reports and associated with the summary reports to get details.
• Validated report results with the source data and sanctioned the reports to Production Environment.
• Involved Advanced Reports that allows the user select Sort Order using Conditional Block.
• Scheduling the Reports as per the business need of the end users.
• Monitored and optimized the performance of reports, and the server environment when required.

Environment:Cognos series8 (version 8.2), Framework Manager, Cognos Connection, SQL Server 2000 and Windows XP.