SUMMARY:

• Over 7 years of IT experience with almost 6 years of experience in Designing and Development of Business Intelligence application with QlikView 9.0/10.0/10.2/11.0/11.2.
• Worked on multiple Full Life Cycle Developments including Planning, Analysis, Design, Implementation, Testing and Product Support for QlikView applications.
• Involved in QlikView upgrade project from QlikView 10.0 to 11.0 and 9.0 to 10.2.
• Thorough understanding on QlikView security, architecture and design components, user profiles, and authentication mechanisms.
• Expertise in creating Design Specification Documents to facilitate the development cycle.
• Extensive knowledge on Data modeling, Dimensional Modeling, Star/Snowflake Modeling, Data Marts, OLTP, OLAP, FACT& Dimensions tables, Physical & Logical data modeling.
• Expertise in Developing QlikView Data Models using various data sources like Oracle, Teradata, SQL Server, Inline Load, QVD files, text files and excel documents.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, synthetic tables and ambiguous relationships.
• Experience with QlikView sheet objects including multiple charts types, Trend Lines, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Implemented Alternate States in the Application for comparative analysis.
• Implemented security using Section Access script that dynamically hides selected areas of the dashboard depending upon user privileges.
• Expertise in implementing triggers using macros to provide custom functionality in Dashboards.
• Expertise in optimizing the existing QlikView Dashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Expertise in writing test case scenarios.
• Experienced in writing complex SET Analysis expressions.
• Experience in QlikView Server and Publisher maintenance - scheduling and monitoring Incremental Loads and Report Reloads.
• Good understanding in QlikSense features.
• Good understanding in Tableau visualizations using Tableau desktop.
• Good Knowledge and experience in Performance Tuning of reports and remediating issues with complex database joins and refining the query logic in reports without compromising on the reporting results and functionalities.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.
• Ability to write complicated SQL queries, Views and Stored Procedures to source data for QlikView applications - Oracle, Microsoft SQL Server, etc.
• Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks.
• Proficient in coordinating and managing the activities between on-site and off-shore teams.

TECHNICAL SKILLS:

Data Modeling: Erwin 3.5/3.0, MS Visio

BI Tools: QlikView, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Tableau, SAP BO, SAP BW, IBM Cognos Workspace Advanced 10.2.1

Databases: SQL Server 2008/2005/2000, NetSuite, MS-Access 2000/2010, SAP R/3, Oracle10g/11g, DB2

Languages: SQL, PL/SQL, C, C++, HTML,JAVA, CSS, VB Script

Operating Systems: Microsoft Windows XP/Server 2003/2008/LINUX, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NY

QlikView Analyst/Developer

Environment: Oracle 11g,IBM Cognos Workspace Advanced 10.2.1, HP ALM 11.0, QlikView 11.2

• Was part of the business team to finalized the requirements for Risk Control Self Assessment, Issues & Action Plans and Risk Event Dashboards.
• Analyzed the excel mock-ups provided by the Business and formulated an end to end project plan which includes Requirement Gathering, Prototype design, Preparation of Design Specification Document, Development, Testing and Deployment.
• Created QlikView working models with test data extracted from IBM Cognos Workspace Advanced.
• Created mock-up Dashboards with differentQlikView components like List Box, Slider, Buttons, pie charts, bar charts, mini charts, straight tables, pivot tables, current selection box and Bookmarks etc. Also, used the new QlikView 11 features such as Alternate States, Conditional enabling etc.
• Presented the working models to the business and got their sign-off.
• Created Design Specification Documents which would have all the necessary information for a developer to develop the Dashboards such as screenshots of the dashboard layouts, list of attributes to be used and their DB mappings, List of filters, Charts and their functionality, Colors Codes, Navigation between sub-tabs, logic (expressions) for charts and other calculations and suggestions for future enhancements.
• Provided support for Design Specification Documents whenever any updates were needed.
• Presented the QlikView working models and Design Specification Documents to the development team.
• Worked closely with the development team to facilitate the development process.
• Wrote test scripts for SIT, UAT and PROD environments and uploaded in HP ALM.
• Created Defects if the result was not in agreement with the test script and assigned them to the development team in HP ALM.
• Provided sign-off for Production Go-Live.
• Worked on few QlikSense POC’s for Risk analysis.
• Worked closely with COR team to find a solution for implementing Operational Risk Dashboard (ORD).
• Extracted data (RCSA, Risk Events, Stress and Key Risk Indicators) from multiple sources using ODBC and OLEDB connectors to create the data model.
• Created front end UI objects and implemented the desired navigation.
• Provided access to the users in QlikView Management Console by adding their corresponding SIDs.
• Scheduled reloads for Operational Risk Dashboard in QlikView Management Console.
• Supported the Operational Risk Dashboard both as a developer and an admin.
• Distributed and shared tasks efficiently and effectively with off-shore team.

Confidential,NY

QlikView Developer

Environment: Oracle 11g, MS Access 2010, DB2, QlikView 11.2, Informatica Power Center 9.0, Tableau 9.0

• Gathered and analyzedthe requirements for developing and designing of PCP Global Tool Matching, SPC Chartsand Customer/Manager KPIs QlikView dashboards.
• Worked closely with the UI team to create the High Level Design Document.
• Prepared Technical design document to facilitate smoother transition to newer designs.
• Created a Prototype in QlikView environment using development data to get sign-off from the end users.
• Designed QlikView Document/User Settings, Layouts to make consistent and professional optimized look.
• Extracted Data from various data sources such as Oracle 11g, MS Access, DB2, CSV files and Text files and stored them into QVDs.
• Also extracted data from Informatica Power Center by creating QVX files.
• Involved in the developing of star schema and snow flex schema dimensional data models based on the requirement.
• Developed QlikView Dashboards usingQlikView object such as List Box, Text Box, Input Field, Table Box, Current Selection Box, Straight Table, Pivot Table,Box Plot, Bar Chart (Drill down & Cyclic Grouping), Line Chart, and Trellis Chart.
• Used Variables, Triggers and Alternate States concept to enhance the functionality of the QlikView application.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Performed optimization techniques on the QlikView Application by removing unnecessary fields, avoiding complex joins, avoiding date functions and conditional functions inside the application.
• Provided Demo sessions to end users at the end of each iterative phase of QlikView application development.
• Implemented Section Access to make the application available to desired users.
• Prepared test cases for application development/testing and validating accuracy of the reports generated.
• Worked closely with business users and analysts to validate the numbers represented at the graphs.
• Conducted User Acceptance Testing.
• Conducted end user training sessions and prepared the training documentation.
• Worked with large User Group based in USA and Germany.
• Deployed the QlikView application on production server, set up automated data reloads and assigned CALs for users based on their areas using QMC.
• Implemented Incremental load for updating QVDs.
• Provided continuous production support by reviewing QlikView log files and recertifying any errors.
• Developed Tableau workbooks from multiple data sources.
• Created Tableau Dashboards with interactive views, trends and drill downs
• Worked on onsite and offshore model.

Confidential,FL

QlikView Developer

Environment: Commander, BIG Center,CasiRusco, MS SQL Server 2008, QlikView 11.2

• Involved in the end to end implementation of Badge Swipes, Space Utilization and Work Management Dashboards.
• Extracted Data using Extractor QVWs from multiple Databases such as BIG Center, HR, Commander and CasiRusco and stored it into Extract QVDs.
• Loaded the Extract QVDs into Transform QVWs and performed necessary transformations such as renaming the columns, Apply Maps, text to number or number to text conversions. Also performedInner Joins, Left Joins and Right Joins to attain the desired resultant Data Set and stored it into Transform QVDs.
• Loaded the Transformed QVD into a QVW and designed the Data Model as per the business requirement.
• Used Apply Maps, Right Joins and Left Joins wherever necessary to reduce the no of tables in the Data Model to aid better performance of the Dashboard.
• Resolved and removed any Circular Loops or Synthetic Keys by renaming orremoving unwanted columns, using Qualify statement, performing Join operations and by concatenating the tables.
• Used Vlookup function to create Excel sheets for Mapping between two similar columns from different Databases and later used this Excel sheet in QlikView Load Script to bridge the GAP between multiple Databases.
• Aggregated the day level (Report Date)data to the month level (Report Month) in order to improve the Performance of the Dashboard.
• Designed the Dashboard with various objects such as Pie Charts, Line Charts, Bar Charts, Combo Charts, Gauge Chart, Table Object, Straight Table, Pivot Table, List Box, Multi-Box, Current Selection Box, Buttons, Slider Object,Text Objects, Bookmarks Calendar Object, Search Object etc.
• Used Drill Down and Cyclic groups in Charts for better Data analysis.
• Designed the Template for the Dashboard.
• Used Set Analysis in the Expressions for various charts.
• Used Conditional Dimensioning technique to created AdHoc reports.
• Followed best practices by documenting the Field Names and the Expressions in an Excel sheet.
• Wrote an Include Script to rename the columns into proper business names for the better understanding of the users.
• Interacted actively with the Testing Team and performed Data Validation. Identified and analyzed the data irregularities and pointed out key solutions.
• Implemented Section Accesson the QlikView Application.
• Scheduled Data Extractions, Data Model and Dashboard Reloads using QlikView Management Console (QMC).
• Assigned Named, User and Document CALs using QlikView Management Console (QMC).
• Published the reports to QA environment for the Users to Test.
• Interacted with the Users on a weekly basis to get their feedback and made the requested changes.

Confidential, PA

QlikView Developer

Environment: Windows 2000 Server, Oracle 11g/10g, MS Access 2005, MS SQL Server 2008/2005, QlikView 10.0/11.0

• Actively participated with Business users and Functional team to understand the reporting requirements and worked on all phases of the project.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Developed Linked and Concatenated tables and solved the loops issues.
• Worked on QlikView Server, QlikView Publisher, and QlikView Enterprise version.
• Designed and developed General Ledger, Payables, Receivables, Profitability dashboards.
• Developed Dashboard pages like Income statement, Balance Sheet, Year-Over-Year, Revenue Loss, Trail Balance and Financial Over view reports in General Ledger.
• Developed Dashboard pages like AP Balance, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Order Process, Sales Revenue, Order Lines, Bill of Material, Customer Activity, Balances, Transactions, Backlog Lines, Invoice Lines Customer and Supplier returns Dashboards.
• Customized Order Management, Order Fulfillment and Inventory Dashboards.
• Designed an application for supporting the lending process and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, Slider, Current Selections Box, Buttons, Charts (Table Box, Pivot, Straight, Pie, Line Gauge, Trellis), Text Objects, Bookmarks, etc.
• Scheduled QVW reloads on server and handled troubleshoot errors.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Rectified irregularities in existing mappings by analyzing the data flow. Redesigned and made necessary changes for improving the performance.
• Wrote SQL Scripts to load the relevant Data in QlikView Applications.
• Tested QlikView Applications and reports using review checklists before delivering to the end users.
• Setting access permissions and assigning CALs based on users.
• Involved in up-gradation of QlikView environment from QV 10.0 to QV 11.0 version.
• Conducted end user training sessions and prepared the training documentation.
• Implemented security on QlikView Applications.

Confidential

QlikView Developer

Environment: Windows 2000 Server, Oracle 10g, MS Access 2005, MS SQL Server 2005, QlikView 9.0/10.2

• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• Involved in gathering data from sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops.
• Monitoring of the QVS, QVW's and user accounts for the usage in applications.
• Designed and customized Dashboard pages like Forecast and Predictive Analysis, Budget vs. Actual, GL Balance, Cash Flow, AP Balance, Payments Due, Invoice Details, Supplier Reports, AR balance, Customer Report, AR Transactions in Financial Analytics.
• Developed straight table and bar charts for computing Year Ago, YTD, MTD, WTD measures.
• Designed and developed different types of charts such as bar charts, straight tables, pivot tables, pie charts and gauge chart etc.
• Created different types of sheet objects like list boxes, Buttons, Multibox etc.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Configured and deployed the applications in the access point using QlikView server/publisher.
• Scheduled jobs for incremental and full loads using publisher.
• Involved in production support for various applications - Failure Analysis using error logs.
• Improved the overall performance of the application and redesigned data model by applying QlikView performance tuning techniques.
• Communicated and trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Involved in upgrading QlikView dashboard applications from QlikView 9.0 to 10.2.
• Monitored the work done by offshore team.

Confidential,WI

QlikView Developer

Environment: QlikView 10.0, SQL Database, Windows Server 2003, oracle 10g

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.
• Supported in modifying, testing and implementation of existing reports.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Performed redesign of the existing QlikView BI associative model to improve availability, scalability and performance by eliminating synthetic keys and circular loops in the data model.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented multiple levels of hierarchies such as sales, product, partner, customers and service hierarchy etc.
• Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Table box, Lists, Input box, Master Calendar.
• Implemented Incremental load for the update of QVD’s.
• Implemented section access, section authorization and sheet access to make the application available to desired users.
• Was actively involved in server migration and the fresh QlikView installation process.
• Used booking, revenue applications and created 4 year forecast model and successfully implemented in QlikView.
• Considered best practices of QlikView and created heat map and KPI graphs.
• Creating section access code and binary loads for un-compromised security and quick reloading of applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Confidential

SQL PL/SQL Developer

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL Developer, MS Access

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Used joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques developed various backend application programs, such as views, functions, triggers, procedures and packages using SQL and PL/SQL language for the top management for decision making.
• Solved troubleshoot performance issues and bugs within packages, forms, and reports using DBMS OUTPUT, forms debugger, explain plan.
• Used hints for SQL query tuning to reduce the response time.

Confidential

SQL PL/SQL Developer

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL Developer, MS Access

• Incorporated complex business logics by using stored procedures/triggers.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed complex queries using inline views, correlated sub queries, complex joins, merge, cursors, ref cursors and grouping/aggregation functionality.
• Created different types of reports such as parameterized reports, matrix report, charts etc.
• Performed SQL tuning using Explain Plan, TkProf, Hints and indexes.
• Partitioned tables and indexes for better performance of application.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.