SUMMARY

• 9 years of experience in IT, Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems.
• 6+ years of experience in Designing and Development of Business intelligence applications with Qlikview 12/11/10 as BI tool.
• 2 years of experience in preparing dashboards using Qlik Sense 3.0 and above/2.0 and above with extension objects and mashups.
• Worked in Agile methodology environments and involved in scrum meetings.
• Trained end users to develop and use QlikView and QlikSense applications.
• Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).
• Experience in using QVW, QVD, QVX and QVF (Qliksense) files effectively.
• Skilled at developing reporting and data solutions.
• Eminent with Functional Areas like Banking and Finance, Healthcare.
• Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView/Qlik Sense BI.
• Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
• Strong analytical database design and Data Modeling (Star Schema, Snow Flake Schema) skills in QlikView
• Experience on MS SQL Server (BI) and SQL Programming.
• Good Understanding of Relational and Dimensional Database Concepts.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Expertise in designing in Qlikview with complex multiples data sources (SQL, Flat Files) relational designs and optimizing applications by using QVD’s, removing non key fields and script variables (Loading phase).
• Developed User Interactive Sheets & Reports as business needs.
• Developing SQL Scripts to load the relevant Data in both QlikView and Qlik Sense Applications.
• Developed Macros, set analysis to provide custom functionality in QlikView Applications
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Experience in creating ETL Applications for QVD’s and Qlikview Scripting variables and File, Date, System, Mapping and Table functions.
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP and Bulk Insert).
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Exceptional analytical, troubleshooting and communications skills to communicate directly or remotely with business partners/clients to identify key areas where Business Intelligence can solve business problems by delivering pertinent and timely information.
• A well-organized, goal-oriented, highly-motivated effectual team member with excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008, R2,2012, MS Access 2000, 97, Netezza,Teradata, Oracle

Languages: C, C++,TSQL, PL SQL

Business Intelligence(BI) Platforms & Processes: Qlikview 12.2/11.2 SR9/12 /10,QlikSense 2.0/2.0.2/3.0/3.2 , MS BI(SSIS,SSRS,SSAS), SAP Business Objects, NPrinting, EDX, ETL (Extract, Transform, Load) processes and best practices; Advanced aggregation techniques; Full data model design; Data cleansing/scrubbing; Data mining; Data quality assurance/validation; Database normalization/denormalization; Creation of data hierarchies; Extraction and analysis of metadata,SAS connectors and data sets

Enterprise Security: Firewalling; Microsoft IIS; Domain security and Group Policy configurations; Network administration (Active Directory)

Operating Systems: Windows NT XP/2000, Windows 2003, 2008 R2, Windows 7

Web Technologies: HTML, CSS, XML, Java Script/Jquery

Database Tools: Microsoft Visio 2008, SQL Loader, SQL * Plus, AutosysOthers: SQL management studio, Visual studio, BIDS, Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, Apache Tomcat 5.0, Visual Basic 6.0,Jmeter

PROFESSIONAL EXPERIENCE

Confidential, South San Fransisco, CA

Qlikview Developer/Admin

Responsibilities:

• Currently Working on developing couple of dashboards that captures the variance types, Source to Target Variances, Variance in Names/Licenses etc of HCPs.
• Integrating various Google docs with Qlik by generating code via Google Connectors.
• Generation of data exports in various formats from the dashboard.
• The dashboard also captures the transaction IDs and corresponding counts and other KPIs that are presented on various Qlik objects as per the business requirement.
• Setting up the waterfall triggers using QMC and schedule the dashboard Publishing for predefined list of users.
• Maintenance of the Project directory at the system level and monitoring the performance.
• Developed the pdf export option for the data table in qlik dashboard using NPrinting.
• Imposed Alternate states for few tabs to break the association among them as per the business requirement.

Confidential, Montvale, NJ

Qlik Sense Developer

Responsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders.
• Participated on business requirement document preparation.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Developed Custom Extensions.
• GeoAnalytics - integration of google maps in the Application and providing the user with link/url to fetch the real time traffic scenarios.
• Extensively worked with Qlik Sense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in Qlik Sense applications.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Extracted data from multiple complex hierarchies from cross table excel files.
• Created Line Charts to show different trends of finance information over years using set expressions, year function, max() function etc.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Worked as QlikSense administrator to optimize Qliksense performance.
• Trained users to build their own apps in QlikSense.
• Worked on Qlik sense new objects Maps, KPI and object and document extensions for wire frames, and proof of concept applications.
• Implemented optimized loadings and performance tuning with the help of qlik support.
• Security and mobile ability enabling and taken care of QlikSense QMC, repository and hub access.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Create, manage, clone, and delete nodes in Qlik Sense sites that are deployed in cloud computing environments.
• Installation of IE plugins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.

Environment: Qlik Sense 3.2, Qlikview 12.2, NPrinting 17.0 SR1, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, Windows 2012 Enterprise server, Excel, MS Word, Adobe PDF,JSON

Confidential, Mettava, IL

Qlik Sense - Sr.Qlikview - NPrinting Developer/Admin

Responsibilities:

• Actively participated in Production meeting for requirement gathering working closely with business users and stakeholders.
• Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards.
• Participated on business requirement document preparation.
• Responsible for Self-Business analysis tool Qlik Sense initial setup and end to end development of Qlik Sense applications.
• Migration of Qlikview QVW files to Qlik Sense QVF files.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the Qlik Sense dashboards.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlik Sense.
• Building QVDs, QVFs using source systems like Oracle, SQL Server, Excel files, Sales Force & SAP.
• Extensively used Qlik Sense - Developer Hub's - Single configurator, Extension Editor, Mashup Editor and worked on Qlik Sense Cloud.
• Building HTML Mashups for Qlik Sense, Embedding objects in web pages
• Integrating single Qlik Sense visualizations, sheets/snapshots into an iframe.
• Used Some Qlik sense extension objects like Buttons, Horizontal List Box, Range Slider etc
• Involved in performance tuning of Qlik Sense apps for faster data reloads and efficient response times.
• Involved in creating test case scenarios for end users to test the applications.
• Perform error handling process, debugging and troubleshooting the applications.
• Involved in testing process and performing the Unit testing and System testing.
• Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Migration of Qlikview QVW files to Qlik Sense QVF files.
• Worked on HCP related Calls and Medical Activities and transforming the data as per the requirement.
• Enhancing the dashboard to include new calls, transactions, medical activities etc.
• Used Concatenation techniques to merge the new inflow of medical activities and calls from new data source to the existing data model.
• Redesigned the existing master calendar to include the date range of the medical activities’ new inflow.
• Used multiple joining and mapping techniques.
• Optimizing the application with scripting/designing techniques and also optimizing the application at the server level.
• Developed waterfall triggers with a timely schedule in the process of automating the reloading process of the entire application.
• Using NPrinting 17.3 to provide excel reports to the business.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Both static and dynamic reduction techniques have been used to provide the business with desired dashboard/application outputs.
• Distributed QS reports using NPrinting in the form of Excel/PDF/Power Point/Word etc. to users.
• Used link table techniques to associate multiple fact tables with different levels of data granularity.
• Calculation of KPIs on the new data inflow as per business requirements.
• Set analysis/expressions to calculate the KPIs.

Confidential, Sunnyvale, CA

Sr.Qlikview - Qlik Sense - NPrinting Developer

Responsibilities:

• Understanding the requirements from the business users and their reporting needs. Suggested better way of presenting layout /Sheet Objects and developed the PDF reports and printable reports.
• Developed the reports for Passing the values/parameters from the database to Qlikview reports based on adhoc requests and generated customized reports as per the business needs.
• Created triggers that automatically select the fields values as soon as the parameters are passed to the reports.
• Created themes for different clients in different reports and also generated the reports in landscape and portrait views.
• Developed the reports that takes Parameter Value to navigate from one KPI in Dashboard to another.
• Written the script that imports pre-set variables in an excel file where in the user updates the variable values every week.
• Used macros to reload the qvws as soon as the parameters are passed from external source.
• Defined the Excel, Word and PDF templates that are necessary to generate Excel, Word and PDF reports using NPrinting and publish the reports as per the schedule to the distribution list.
• Developed the reports in such a way that just by passing the parameters the app would generate County Wise Weekly, Monthly, Quarterly and Annual Reports and also by region.
• Generated Excel Report with KPIs where in clicking the KPI cell, the excel sheet would jump into its respective detailed transaction. Used NPrinting to develop this kind of reports. In short, Linking the KPi and the transaction in the other sheet of excel.
• Developed the qvw and generated word reports that has the county wise aggregated transaction counts along with the county wise breakdown.
• Embedded the Client logos into headers and footers of the PDF,Excel and Word Reports using NPrinting.
• Automated the Whole end to end process from passing the parameters to publishing the reports to the End Users.

Environment: Qlikview 12.0 - SR5, NPrinting, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, Windows 2012 Enterprise server, Excel, MS Word, Adobe PDF

Confidential, Waltham, MA

Sr.Qlikview - Qlik Sense - NPrinting Developer/Admin

Responsibilities:

• Understanding the requirements from the business users and their reporting needs. Suggested better way of presenting layout /Sheet Objects and developed the architecture of prioritized reports which were accepted and successfully implemented in the dashboards.
• Mashups that use HTML consumable objects that can be surfaced via your existing Web Portal.
• Installation and configuring of QlikSense Desktop on Windows Server 2008 R2 Enterprise/cloud.
• Developed the report by passing a Parameter Value to navigate from one KPI in Dashboard to another.
• Used a KPI/gauge object which has built in color switching to color code the fonts.
• Scripted using dollar sign expansion which is a text replacement that happens before the actual statement is parsed and evaluated.
• Implemented performance tuning techniques both in the scripting and UI.
• Created Line Charts to show different trends of Product Sales over years using set expressions, year function, max() function etc.
• Involved in the business requirement gathering and development of functional and technical specification documents.
• Created connections and Extracted data from multiple complex hierarchies from cross table excel files.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Multiple levels of Hierarchies are implemented such as Cohorts, Sales, Products, Partner, Customers and Service Hierarchy etc.
• Provided custom functionality in QlikSense Applications.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Developed Bar Charts to show the total/Average sales of products for the current and previous years.
• Frequently used statements/functions while developing were Where Exists(),Get selected functions,If(),Distinct,Join,Concatenate,Resident,AutoNumber,Mapping load, ApplyMap(),ceil (), Len (), calendar functions.
• Used Set Analysis in the Line and Bar charts (Combo Charts) to show the user different trends of product sales over years.
• Used Calendar/Slider Object to set a custom Date in the Adhoc tab, a tab which is specially designed where the users can create their own graphs/charts.
• Created Dashboard reports to track all the way through the ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• The Process was Agile and strict time line oriented. Worked closely with Project manager.
• Performed technical leadership in dashboard application design, visualization, automation, e-mail alert and notification, data modeling and the integration with the Portal platform.
• Used Data Model Optimizing techniques to reduce the size of the application, improve the performance/speed of the application and was involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years. Also showed the statistics in bar charts and pie charts as per the client needs.
• Converted A pivot Table into a Static Selection table box using some techniques like conditional Show, Multiple Dimensions imposed with conditional calculations etc
• Developed heat maps (Google Maps and also Picture embedded text objects) with alert mechanism to show US State wise and scatter maps. Also Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Used .svg map with .qar extensions to design a web view heat map/Choropleth using Qlikview.
• Developed an Ad hoc sheet where the users have the freedom to select their own dimensions and metrics to create their own personalized Pivot/straight table.
• Developed .nsq files to export the excel reports based on the business requirement.
• Configured the distribution of the reports with the EDX triggers from QMC on .nsq files.

Environment: Qlikview 11.2 - SR12, QlikSense 3.0, NPrinting, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, Jquery, JSFiddle, SAS connectors and data sets, Windows 2012 Enterprise server, Excel