We provide IT Staff Augmentation Services!

Sr. Qlikview - Qliksense - Nprinting Developer/admin Resume

San Ramon, CA

SUMMARY

  • 6 years of experience in IT, Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modelling, Development, Testing and Implementation of Data Warehousing and Database Business Systems
  • Skilled at developing reporting and data solutions.
  • Eminent with Functional Areas like Banking, Pharma, Finance, Healthcare, Telecommunication and Educational .
  • Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView/Qlik Sense BI and Cognos .
  • Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support.
  • Strong analytical database design and Data Modelling (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.
  • Experience in extracting data from different sources by using Informatica .
  • 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 BO reports and then developing the dashboards in Qlikview integrating with SAP BO reports.
  • Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients .
  • Having good knowledge/trained on IBM Info Sphere Information Server , IBM Cognos and Corticon business rules .
  • Experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP and Bulk Insert).
  • 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, Teradata, Oracle

Business Intelligence (BI) Platforms & Processes: QlikView 11.2 SR2, 3, 5, 9/12, QlikSense 1.0.1/1.1/2.0/2.0.2 , Cognos, SAP BO, MS BI (SSIS, SSRS, SSAS), NPrinting, EDX, ETL (Extract, Transform, Load)Processes and best practices

Data Integration Tools: Informatica, SSIS

Enterprise Security: Firewalling; Microsoft IIS; Domain security and Group Policy configurations

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, Autosys.

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr. QlikView - Qliksense - 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.
  • Installation and configuring of QlikSense Desktop on Windows Server 2008 R2 Enterprise/cloud.
  • Implemented the Qliksense cloud using AWS - EC2 and also using Azure.
  • Hands on experience Qliksense administration performing installation, upgrades and configuring the Qliksense setup in cloud servers.
  • Installed and configured the Qliksense June 2017 release.
  • 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 colour switching to colour code the fonts.
  • Scripted using dollar sign expansion which is a text replacement that happens before the actual statement is parsed and evaluated.
  • Performance the performance of the business with analytical capabilities.
  • Dashboards were served to track inventory and sales as well as to monitor various KPIs . Dashboards included customer detail drilldowns , threshold gauges and alerting mechanisms.
  • 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.
  • Extracted Data from Different Sources by using Informatica .
  • Worked on modelling 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 the fields) and Drill Down groups .
  • Developed Bar Charts to show the total/Average sales of products for the current and previous years.
  • Involved in testing the prototypes with live data and supporting the application. Involved in dashboard testing by connecting Cognos Query studio to generate reports and compare them with the Dashboard data .
  • Frequently used statements/functions while developing were Where Exists), Get selected functions, If, Distinct, Join, Concatenate, Resident, AutoNumber, Mapping load, Apply Map, 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 modelling 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 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 Qlikview Applications using SAP BO reports
  • 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, June 2017 release, Cognos, SAP BO Printing, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, JQuery, JSFiddle, Windows 2012 Enterprise server, Excel, Informatica Power Centre 6.1,AWS - EC2, Azure.

Confidential, PA

Sr. QlikView/Qliksense Developer-Administrator

Responsibilities:

  • Analyzing the call statistics and report the results and take the information and create reports.
  • Hands on experience on Qliksense administration.
  • Installed, configured and upgrades done from Qliksense version 2.x to 3.x shared persistence
  • Analyzed the database and provide detailed information on their operational and Forecast for future years.
  • Maximum Application size is 0.5 to 1 GB, with 56 Booking and Call related fields, 500 million rows and associated with 98% data density.
  • Worked with 40 core processor with two 1TB RAM server and two 256GB RAM servers, having monthly refresh.
  • Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
  • The application is used by 46 Named CALs and 30 Document CALs licensed users with additional session licensed users as needed.
  • Developed different dashboards with a complex database system behind it, which includes extracting data from the database , storing into QVD files, write load scripts , and develop UI according to user requirements.
  • Document event trigger and field event triggers is created. Incremental reloading is implemented
  • Worked as Subject Matter Expert (SME) for various projects. Taught the users to get along with QlikView .
  • Automated the whole ETL process using SSIS 2008 and T-SQL and performed some occasional DBA functions.
  • Automated and scheduled daily/weekly/monthly data Refresh/loads of QVW documents using QlikView Publisher and notified load status by email.
  • Optimizing 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.
  • Worked on modelling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
  • Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.

Environment: QlikView 11.0, Qliksense 2.x, 3.x, SQL Server 2008, TSQL, MS Visual studio 10, Windows XP/2003 server, Excel.

Confidential, Phoenix, AZ

Qlikview Developer/Admin

Responsibilities:

  • Involved in business requirement gathering and development of functional and technical specification documents.
  • Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models .
  • Connected to different ODBC , OLE DB data sources (SQL Server, MS Access, Oracle, Teradata) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView .
  • Application size is 39MB , with 178 demographic fields, 5 million rows associated with 95% data density
  • The application is used by 46 Named CALs and 30 Document CALs licensed users with additional session licensed users as needed.
  • Worked with 32 core processor with 200GB RAM server, having daily refresh. 2-tier QVD architecture is implemented and the final application is taking 27 second to reload.
  • Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
  • Ad hoc excel reports are created based on the business user requirements.
  • Developed QlikView Dashboards using Chart Box ( Drill Down , Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
  • Developed KPI’s and set analysis applications.
  • Performed different tasks like repeat tasks , reload tasks and distribution tasks using the QlikView publisher .
  • Worked on modelling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
  • Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc...)
  • Experience in creating reports in Qlikview using Hive (Hadoop) Database and also worked along with Redshift Data ware house to develop the reports in Qliksense.
  • Developed User Interactive Sheets & Reports as business needs.
  • Writing SQL Scripts to load the relevant Data in QlikView Applications.
  • Developed Macros , SET ANALYSIS to provide custom functionality in QlikView Applications.
  • Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified load status by email.
  • Performance tuning by analysing and comparing the turnaround times between SQL and QlikView .
  • Optimizing 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 .
  • Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
  • Build reusable macros to control QlikView objects for ease of use by the users.
  • Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.

Environment: QlikView 11.2, SQL Server 2005/2008, Hive(Hadoop), Redshift, TSQL, MS Access, Visual studio 10, BIDS, Teradata, Windows XP/2003 server, HTML, Excel

Confidential

SQL Server Developer/SSIS/ SSRS

Responsibilities:

  • Developed T SQL code for the application.
  • Modified the existing database by adding the tables and maintained relationships between the tables.
  • Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
  • Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
  • Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
  • Implemented Incremental loads using different kind of tasks using SSIS.
  • Used Event Handlers for Exception Handling in SSIS packages.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created, Managed and Support existing reports using SSRS .
  • Involved in creating, deploying and configuring reports according to the requirements using SSRS .
  • Developed different types of Tabular Reports, Matrix Reports, and Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) .
  • Developed cubes using SSAS involving multidimensional data.
  • Supported various sectors like Development, testing, Production, Maintenance and Application teams .
  • Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard .
  • Executed Test cases manually Using Quality Centre.
  • Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
  • Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, XML, SQL Profiler, Windows 2003.

Hire Now