SUMMARY

• 8+ years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• 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 BI.
• Expertise in Installing and Configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Having good knowledge of Data Modeling Concepts (Normalization, Star Schema and Snowflake Schema).
• Sound knowledge of Oracle 10g, Oracle 9.x/8.x/7.x, Teradata, PL/SQL, MS SQL Server 2000/2005(including stored procedures, Views, Materialized Views and SQL programming).
• Experience in Oracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD, Stored Procedures, Functions, Triggers, SQL Server 7/2000.
• Extensively worked with Cognos Tools such as Cognos 8 Suite ( 8.1/8.2/8.3/8.4 ), Cognos Report net, Cognos Impromptu, and Analysis Tools such as Cognos Transformer & Power Play, Access Manager and Server Installation & Maintenance.
• Expertise in Cognos 8 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio).
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Experience in working with different operating systems like Confidential UNIX, Solaris, and Windows NT/2000.
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Coordinated and acted as a liaison between the business groups and the IT department.
• Involved in analyzing the Business objects reports to convert them to Qlikview
• Having knowledge on ETL tools like Informatica.
• Experience in interacting with end users to gather requirements for reporting.
• Excellent interpersonal and communication skills, technically competent and result - oriented with strong problem-solving skills.

TECHNICAL SKILLS

Reporting Tools: Qlikview 8.5/9.0/10/11 , Qlik Sense 2.0/3.0, Cognos 8.1/8.2/8.3/8.4 Suite

ETL: Informatica

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005/2012 , Teradata.

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS).

Languages: JavaScript, HTML

PROFESSIONAL EXPERIENCE

Confidential, Reading, PA

Sr. QlikView Developer/Admin

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Understand the business requirement of the dashboard and making sure that user interface reflect the requirement so that business can make better business decisions.
• Expertise in building complex data model using link tables to join multiple fact tables and dimensions.
• Worked in User Self Serve model, where Data model is build by me and client will be developing front end design.
• All data model changes are made by me
• Helped Users learn Qlikview and build front end objects
• Gave assistance with complex concepts of front end design like set analysis, dual functions, triggers
• Build a data model from which dashboard have a binary load to get data and section access.
• Expert in implementing trigger at field level, onopen. Implemented onopen trigger to select section access fields values
• Expertise in implementing security to dashboard at various levels such as document level using NTNAME, only authenticated users are allowed to access the dashboard
• Field level reduction using to show/hide certain field by having them hidden when a user login
• Data leve reduction, by having reduction fields in section access load script
• Show only few values of a field by having a flag in section access and have a table in section application to reduce to only certain field values
• Implement security with ‘*’ value to have all values of a field to show with out explicitly listing out all possible values by not using Strict Exclusion
• Expertise in recommending/following best practices for Qlikview development as recommended by Qliktech.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Worked on integrating existing extensions to Qlikview dashboards as per requirements
• Worked on developing an existing dashboard to QlikSense to understand the feasibility of migration of dashboards
• Worked on QlikSense POC for business users to get to understand the flexibility, agility and also rigidity of the product.
• Expertise in Qliksense development process of making connections to various data sources like databases, excel documents, CSV files, text files.
• Expertise in Qliksense development process of data modeling of various data tables brought into Qliksense environment like making star schema data model, making keys, remove unwanted fields, doing data transformation with Qlik functions.
• Expertise in Qliksense development process of building UI objects as per user requirements like charts, tables, Maps.

Environment: QlikView 11 SR12, QlikSense 3.0, Oracle 12g,, Windows 10, Windows Server 2012

Confidential, Durham, NC

Sr. QlikView Developer/Admin

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Understand the business requirement of the dashboard and making sure that user interface reflect the requirement so that business can make better business decisions.
• Worked on developing an existing dashboard to QlikSense to understand the feasibility of migration of dashboards
• Expertise in recommending/following best practices for Qlikview development as recommended by Qliktech.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Implemented Qlikview dashboards distribution to business users using Section Access to dashboards, providing CALs to documents,
• Worked on developing an extension to include 3 or more metrics in a single chart with different scales
• Worked on integrating existing extensions to Qlikview dashboards as per requirements
• Worked on QlikSense POC for business users to get to understand the flexibility, agility and also rigidity of the product.
• Expertise in developing Qliksense dashboards for different user base as per user requirements.
• Expertise in Qliksense development process of making connections to various data sources like databases, excel documents, CSV files, text files.
• Expertise in Qliksense development process of data modeling of various data tables brought into Qliksense environment like making star schema data model, making keys, remove unwanted fields, doing data transformation with Qlik functions.
• Expertise in Qliksense development process of building UI objects as per user requirements like charts, tables, Maps.
• Worked on various category of low to urgent tickets as part of production support for a number of dashboards and User groups
• Worked preparing assessments for small changes to dashboards to large scale projects with the provided requirements
• Worked in offshore model leading a team of 6, coordinating work, checking progress and reporting the status to Business Users

Environment: QlikView 11 SR12, QlikSense 2.0/3.0, Teradata 14, Teradata SQL Assistant, Windows 7, Windows Server 2012

Confidential, Plymouth Meeting, PA

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 that user interface reflect the requirement so that business can make better business decisions.
• Worked on complex expression to automate the report building and avoid manual sorting process.
• Worked closely with the architects to understand complex phone and MRM data to convert business requirements to QlikView Scripts.
• Expertise in working closely with database team with getting the data in the format that meets the business requirements and also help in building good dashboards.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Worked on designing the complex data model to integrate different data components using concatenate, joins, and complex keys of different relevant fields.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Worked with Microsoft Team Foundation Server to create, manage tasks of the development, deployments works. All the work in logged in TFS to track the progress of the project and meet target dates.
• 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
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Involved in managing the QlikView Licenses to the users (Named CAL, Session CAL, Document CAL)
• Worked on Qlikview management console to schedule jobs, giving user permissions.

Environment: QlikView 11 SR4 SQL Server 2012, Windows 7, Windows Server 2008, MS Visio, MS TFS.

Confidential, NYC, NY

Sr. Qlikview Developer/Admin

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Understand the business requirement of the dashboard and making sure that user interface reflect the requirement so that business can make better business decisions.
• Expertise in working closely with database team with getting the data in the format that meets the business requirements and also help in building good dashboards.
• Expertise in making sure that 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 building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in preparing the System Requirement specification and Design Specification documents
• Involved in dashboard testing by connecting Cognos Query studio to generate reports and compare them with the Dashboard data.
• 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
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Implemented session access to enterprise level document.
• Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)

Environment: QlikView 11 SR2, SQl Server 2008, Windows 7, Windows Server 2008, MS Visio, Cognos Query Studio

Confidential, Berkeley Heights, NJ

Sr. Qlikview 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.
• Expertise in recommending/following best practices for Qlikview development as recommended by Qliktech.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify, etc…
• Analysis the business requirement and collect the necessary information for Dashboard building such as Database objects from EDW team, UI design requirement from users.
• Expertise in writing complex Set analysis for the KPI calculation in the Dashboard.
• Expertise in building QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• 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.
• 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.
• Implemented session access to enterprise level document.
• Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)
• Involved in building smart supplies reports in Business Objects.

Environment: QlikView 11, Oracle 10G, Windows XP, Windows Server 2003, MS Visio, Business Objects 4.

Confidential, Mountain View, CA

Sr. Qlikview Developer

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.
• Involved in managing the Qlikview Licenses to the users (Named CAL, Session CAL, Document CAL)
• Expertise in managing the server configurations for better performance.
• 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 helpful in administration.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• 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 10 SR4 Desktop, Server/Publisher, Teradata SQL Connector, Oracle 10G, Windows 7, Windows Server 2008.

Confidential, Durham, NC

Qlikview Developer

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Analysis the business requirement and collect the necessary information for Dashboard building such as Database objects from EDW team, UI design requirement from users.
• 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 QV objects for different requirement such as straight table, pivot table, different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Extracted information from different data sources like Oracle, Teradata and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify, etc…
• Expertise in defect solving for the Dashboard during the QA testing.
• Involved in publishing of the dashboard to the users using Qlikview Publisher.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Implemented session access to enterprise level document.

Environment: QlikView 10 SR4, Teradata SQL Connector, Windows 7, Windows Server 2003.

Confidential, Commack, NY

Qlikview Developer

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Understood the Micro Strategy reports to produce them with Qlikview.
• Build Dashboard prototypes for the end users with all required KPI s.
• Developed pivot tables, straight tables, chart like bar, line, pie, grid charts for the Dashboard.
• Developed data model compactable with Qlikview for developing Dashboard.
• Developed Link tables, used join, concatenate functions and other functions for the data model in Qlikview.
• Demonstrated QlikView data analyst to create custom reports, charts and bookmarks.
• Involved in testing the prototypes with live data and supporting the application.

Environment: QlikView 9 SR4, Oracle,, Windows XP,, Windows Server 2003,Toad,Microstrategy.

Confidential, Alpharetta, GA.

Qlikview Developer

Responsibilities:

• Involved in gathering and documentation of QlikView application requirements from end users.
• Developed QlikView associative data models and resolved closed loops, Synthetic keys and ambiguous relations.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Worked with SQA team for data validation team and worked with peer for code review.
• Presented QlikView applications to various levels of user.
• Demonstrated QlikView data analyst to create custom reports, charts and bookmarks.
• Supported QlikView Administration tasks.
• Also worked with QlikView administrator to optimize QlikView performance.
• Provided ongoing QlikView consultation to the development team.

Environment: QlikView 8.5/9, SQL Server, Oracle, Microsoft Access, Windows Server 2008 Putty, Toad.

Confidential, New York NY

BI/Report Developer

Responsibilities:

• Involved in Gathering requirements, analyzing the business specifications and the reporting issues provided by the End users and Developed specification documents for reports as per client requirements.
• Interacted with Development and Management Teams.
• Used Framework Manager to import metadata from multiple data sources, to Design and Develop the Framework Manager models.
• Created Packages and published to the Cognos Connection.
• Scheduling and distributing the reports using Cognos administration.
• Designed and developed the reports using Cognos 8 Report Studio, Query Studio, and Analysis Studio.
• Involved in testing the reports and enhanced the performance of the reports by writing Complex SQL queries.
• Involved in moving to Deployment, UAT and Production.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger, SQL Server 2005

Confidential

Cognos Consultant

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the End users.
• Analyzed Business requirements from the analysts.
• Interacted with Development and Management Teams.
• Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Moved projects from development to QA and then Production servers.
• Involved in the Testing of the reports and updating the Bug Tracking Tool.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.

Environment: Cognos 8.0 BI Suite, Cognos Framework Manager, Cognos Impromptu 7.3, Cognos Report net 1.1, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Windows 2003 Server.