SUMMARY

• 8+ Years of IT experience in all aspects of Business Intelligence (BI) leveraging QlikView/Tableau/Cognos applications with a strong background in Database development and Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Experience in Installing and Configuring, Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Design and Develop Strategic/Proof of Concept (POC) dashboards using Qlikview and Tableau.
• Experience of working on QlikView scripting, data analytics, data modeling and dashboard designing
• Involved in designing the optimized QlikView Data models, Extract & Transform the data from the different data sources and created QVD files
• Hands on retrieving of external data toQlikViewdashboard in terms of QVDs by making connection through ODBC and OLEDB
• Experience in QlikView Server and creating scheduled jobs for QVD extracts and report reloads.
• Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle for designing and modeling of Qlikview application.
• Experience withQlikViewobjects including multiple charts types, Trends, Pivoting, custom requests for Excel Export for Management Dashboard reporting and other KPI’s.
• Experience in creating customized reports, filters and charts in QlikView.
• Experience in usingQlikViewfunctions (Date & Time, Keep, Join, Mapping, String)
• Experience in working with QlikView development using agile Scrum methodology
• Published Dashboards to QlikView Sever and Migrated QVW files to the source document folder & Created Distribution and Reload Tasks on Publishers.
• DevelopedQlikViewdashboards using Charts (Drill down & Cyclic Grouping), List Box, Input Field, Table Box, Calendar and Date Island.
• Designed and implemented proof of concepts (POC) for clients in the Healthcare, Automobile, Financial and Manufacturing sectors.
• Implemented advanced SET Analysis for aggregation calculations
• Experience in designingQlikViewDocument/User Setting, Layouts to make consistent and professional optimized look to clients.
• Good expertise in handling Section Access for QlikView applications object & data level security
• Experience inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView
• Strong Expertise in QlikView Scripting, incremental loading.
• NPrinting report generation, distribution and scheduling
• 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
• Acquiring data from a wide variety of sources(SQL, Excel, QVD,QVW, CSV etc.) and building Qlik data models in Qlik Sense
• Expertise in building KPI’s and dashboards using Qlik Sense
• Created users, groups and managed server CAL’s in Qlik Sense
• Experience in deploying applications in Qlik Sense Server
• Trained users to develop front end ad-hoc report using Qlik Sense
• Outstanding analytical, interpersonal, organizational, communication and problem-solving skills. Extensive experience working with senior management and client relations.
• Ability to work effectively with individuals at all levels of an organization.

TECHNICAL SKILLS

Reporting Package: QlikView 8.5/9.0/10.0/11.2, NPrinting, Qlik Sense, Qlikview Integration with ETL, Cognos 10, Tableau 8/9.

Computer Application: MS-Word, MS-Excel, MS-Access, MS- Power Point

Databases: Oracle, SQL Server, DB2, Teradata

Operating Systems: Windows, Linux

Languages: SQL, Basic C, Core Java, HTML

PROFESSIONAL EXPERIENCE

Confidential- Detroit, Michigan

Sr Qlikview Developer

Responsibilities:

• Managing overall operations across reporting team and also work as individual contributor.
• Designed, developed, and managed reporting and Qlikview Business Intelligence solutions to meet the business needs.
• Worked Closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Installed and configured QlikView Server Small Business Edition.
• Extracted data from different systems transformed and integrated in theQlikView
• Engaged in developing Dashboard standards such as Template designs, User Interface and Navigation Design patterns.
• Designed the Data-Model using data from various sources like Oracle, Flat files (Excel Files, CSVs),MS Access
• Developed different complex models eliminating closed loops, Synthetic tables and ambiguous relationships
• Created optimized QVDS which loads faster and helps to improve the performance
• Developed, scheduled and distributed report.
• XML external report request, Excel report, on demand report, HTML report using Nprinting
• Implemented complex SET Analysis for aggregation calculations so that set of records can be defined in an expression
• Created Adhoc reports, implemented bulk search features and on demand reports
• Done metadata management by implementing the governance dashboard.
• Developed Linked Tables, Concatenation and solved issues with loops.
• Worked with Alternate States to distinguish the selections for different charts with in a sheet
• Converted Excel and Crystal reports, Cognos Dashboard/Reports to QlikView dashboards.
• DevelopedQlikViewDashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Developed dashboards included customer with detail drilldowns, threshold gauges and alerting mechanisms
• Developed KPI’s, User Interactive Sheets as business needs
• Implemented Incremental Loading and updated the data in the dashboard as close to real time as possible.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Testing the Reports in SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Automated and Scheduled data loads and Dashboard Applications weekly and Notifications by email to assigned users using Server.
• 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.
• Expertise in building KPI’s and dashboards using Qlik Sense
• Created users, groups and managed server CAL’s in Qlik Sense
• Deployed applications in Qlik Sense Server
• Trained users to develop front end ad-hoc report using QLIK Sense.
• Tested and improved Report Performance.
• Analyzed Reports and resolved Data Issues Related to Reports
• Instructed new users on best practices
• Deposit Portfolio: Developed dashboards on Money Market Deposit Account (MMDA)/Savings, Brokerage Deposit, CD’s (Certificate of Deposits) by months, Quarters and Years.
• Loans: Developed dashboards on Commercial Real Estate, Residential Real Estate, Construction, Consumer and Others data for the higher level officials.
• Profitability: Return on equity (ROE), return on assets (ROA), net interest margin (NIM), leverage ratios, Efficiency ratios using key performance indicators, Financial Highlights over the years.
• Trend Analysis: Developed high level dashboards on Spending Trends, Transaction Trends, Average Ticket Trends
• Work Force: Developed Dashboards for the Workforce for the total salaries, Confidential, contingent work force and Contract Vendors.

Environment: Qlikview11.2SR7, Oracle 11g, MS Excel, CSVs, Crystal Reports, SharePoint

Confidential - Raleigh, NC

Sr Qlikview Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Developed relational database model according to business requirements to create QlikView associative data model
• Developed Proof of Concepts for the business requirements both in Qlikview and Tableau.
• Worked with different Line of Businesses to understand the reporting and analytics requirements. Built multiple dashboards and presented to different user groups to make them understand the functionality of dashboards
• Designed and developed QlikView software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives
• Imported/transformed data from different sources like SQL Server, MS Access, XML files and flat files using OLE DB/ODBC into QVDS and integrated in Qlikview.
• Created optimized QVDS which loads faster and helps to improve the performance
• Wrote, Edited and Debugged ETL Scripts for data cleansing, resolving synthetic keys & circular loops
• Created various sheets objects like bar charts, line graph, straight table, pivot table, combo chart, funnel chart, Pie charts and Radar charts etc.
• Developed KPI’s, User Interactive Sheets as business needs
• Designed and developed extensive QlikView reports using combination of charts and table.
• Preparing, Stabilization, centralization of reporting activities.
• Analyzing and reporting the data with Budget and Forecast, SCM, Operation, finance. Transition of new reporting activities.
• Developed dashboards with detail drilldowns, Cyclic Groupings, threshold gauges and alerting Functionality.
• Maximum utilization ofQlikViewfunctions for aggregating, formatting and performance enhancement.
• Extensively used Join, Keep and Concatenate operations in scripts involving multiple tables
• 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 &QlikViewdocument Versioning.
• Monitoring of the QVS, QVW's and user accounts for the usage of the applications.
• Created reports in PDF, HTML & Excel using Nprinting and distribute to Users.
• Implemented advanced SET Analysis for aggregation calculations
• Developed comparative analysis used alternate state
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Section Access to filter data based on User Privileges.
• Testing the Reports in SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Tested and improved Report Performance.
• 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, Fort Worth, TX

Qlikview Developer

Responsibilities:

• Responsible for Requirements Gathering, Data modeling andQlikviewApplication development.
• ManagedQlikviewreporting environment which includes Qlikview Server,QlikviewPublisher andQlikviewDesktop.
• Delivered advanced and complex-reporting solutions such as dashboards and standardized reports using Qlikview
• Loaded data intoQlikviewfrom Database, text file and also from excel file
• Implemented incremental load by creating QVDs and optimized the periodic data additions.
• Created optimized QVDS which loads faster and helps to improve the performance
• Created different complex sheets and sheet objects based on client requirements.
• Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
• Implemented complex SET Analysis for aggregation calculations so that set of records can be defined in an expression
• Designed and developed different types of charts (Drill Down, Cyclic Field grouping) Bar charts, Straight Tables, Pivot Tables, Pie charts and Radar charts etc
• Created multi boxes, table boxes, and input boxes to fetch data based on the input given.
• Developed Linked Tables, Concatenation and solved issues with loops
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges
• Created Layout themes and applied it to several documents.
• Moving reports from development to testing and testing to production server.
• Involved in resolving Performance issues with various reports.
• Developed a standard/optimized theme which is further used across the system.
• Modifying the existing reports based upon the change requested by the user.
• Provided administration support and Development support for development and production issues.
• Prepared Unit Test Scripts, performed unit testing, System Integration Testing
• Documentation and training of the End Users

Environment: Qlikview10SR2, Oracle, MS Excel

Confidential, Cleveland, OH

Qlikview Developer

Responsibilities:

• Interacted with Business users to identify key dimensions and measures for business performance.
• Worked effectively and created complex reports by connecting it to various data sources like Oracle, MS Excel, and flat files.
• Successfully retrieved external data toQlikViewDashboard in terms of QVDs through ODBC and OLEDB connections.
• Effectively developedQlikViewDashboards using Drill down and Cyclic Grouping (Charts), List Box, Input Field, Table Box and Calendar & Date Island.
• Worked with variousQlikViewfunctions such as Date and Time, Keep, Join, Mapping, peek, pick etc.
• DevelopedQlikViewDocuments, Layouts to make consistent and professional outlook to clients.
• Successfully created reports like Open Purchase Order Detail Report, Open Requisition Purchase Order Detail Report using Straight Table and Pivot Table as per client requirement.
• Migrated Cognos 8 Reports to Qlikview Dashboards/Static Reports.
• Converted Cognos Prompts to interactive List box, Mulitple List box objects in Qlikview Dashboard.
• Testing of Qlikview dashboards/Reprots to Cognos Reprots
• Created Test case documents and trained the end users.

Environment: Qlikview, Cognos 8.2, Oracle, Excel, CSVs, MS Access

Confidential

Cognos Consultant

Responsibilities:

• Created Multiple Reports with Cognos 8.1and Power Play Client.
• Created LIST, Group and Cross tab reports with Drill Through functionality
• Created business Mix and Reports for Comparison
• Created Multi-Dimensional Cubes using Power play Transformer for multidimensional (IQD) reports.
• Drill Down and Drill Through functionalities were used in the cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Developed solution models for Ad-hoc reports.
• Involved in optimizing power Cubes.
• Outstanding Onsite support.

Environment: Cognos 8.1, Oracle 8i, Windows 2000, Cognos Transformer