SUMMARY

• 8+ years of Working Experience, 6+ 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
• Qlik Certified Professional.
• Skilled at developing reporting and data solutions.
• Eminent with Functional Areas like Banking and Finance, Healthcare, Real Estate.
• 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 11.2, 12 SR2,3,5,9/12,QlikSense 1.0.1/1.1/2.0/2.0.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

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

Others: 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

Designing, Simulation Tools: AutoCAD, SolidWorks (with COSMOS), Pro/E,CATIA V5,ANSYS,Algor

PROFESSIONAL EXPERIENCE

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.
• Installation and configuring of QlikSense Desktop on Windows Server 2008 R2 Enterprise/cloud.
• 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.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the 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.
• 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, Windows 2012 Enterprise server, Excel

Confidential, Morristown, NJ

Qlikview Developers/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.
• Development of QlikView BI Applications from Scratch with all Performed planning, design from the gathered requirements which were focused on Aggregating/Counting/Reconciliation Physician’s Sample requests to a Pharmaceutical company which manufactures the drug and the distribution of the drugs from the company in different US States.
• Used Index(),Concat(),Chart Field Functions like GetSelectedCount(),GetCurrentSelections(), GetCurrentField() etc functions for Enabling the Conditions on the Dimensions in the Ad hoc Sheet.
• Used Drill Down and cyclic groups on Bar Charts and Table Charts.
• Created Some triggers like Document OnOpen Action trigger to set current date, Field Event Trigger - OnSelect and OnChange etc.
• Used ApplyMap(),MapSubString(), Autonumber() as part of some data modeling techniques while creating composite keys .
• Used Some inter record functions like Exists(),peek(),Previous(),FieldValue() while scripting/Data modeling and FieldValue(),FieldIndex(, Above(),Below(),RowNo() etc while designing the User Interface.
• Developed Fast Change Charts by using both Cyclic Groups (merged Expressions and also the fields) and Drill Down groups.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
• Installed Qlikview Server and configured the Publisher and was involved actively in the Server migration and also the Fresh QlikView Installation process.
• UtilizeQlikViewPublisher for client application rollout toQlikViewAccess Point and administrator security using Active Directory technology. Set up NPrinting server, designing withQlikviewmachine.
• Advanced report generation, distribution and scheduling application for QlikView using NPrinting Designer. Scheduled the reports, provide On Demand buttons in the Dashboard and to process XML files to kick off jobs using Nprinting Server.
• Good Knowledge ofQlikviewpublisher implementing PDF Distribution and Data Reduction.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC connections.
• Conducted and managed the design and development of high volume, high performance QlikView in-memory solution to support over 1 billion daily transaction volumes.
• Collected and analyzed business requirements, developing engineering prototypes and using POC to facilitate KPI Metrics dashboard design across different regions and business units.
• Participated in design and code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
• Worked with 64 core processor with 1TB RAM server and two 512GB RAM servers, having weekly refresh.
• Involved in the development/implementation of Single sign on (SSO) and implemented security for company’s Active Directory Users and external users.
• Task set ups were done using QEMC and created architecture for the interdependent applications and to execute in proper order.
• Created Custom Users list for the external users who are not a part of the Client’s Active Directory and made the application accessible.
• Created QMC tasks/scheduled windows automated jobs and also used batch files to reload the applications.
• Implemented Security & involved in daily Deployment of QlikView Applications.

Environment: Qlikview 11.2 - SR9, Oracle SQL Developer 3.2.20 TSQL, HTML, CSS, Jquery, JSFiddle, Windows 2012 Enterprise server, Excel, QlikSense 2.0.2, NPrinting

Confidential, Northbrook, IL

Qlikview Admin- Developer /QlikSense Developer

Responsibilities:

• Leading the team of 4 onshore and offshore members while managing ECRs Tickets and resolving P1, P2 and P3 tickets on time and ensured on time delivery of the deliverable to the client.
• Troubleshooting the issues and reviewed the log files to resolve the issues, maintain daily reports of session logs, performance logs, audit logs and event logs.
• ImplementedQlikviewupgrades and software patches. Worked with QlikTech to coordinate on the upgrade procedures and resolving any environment related issues using the Client Qlik Support Portal.
• Upgraded 4 Standalone servers(Dev,QA,2Prod) and 1 clustered (4Nodes - 3QVS and 1 publisher, 4 IIS web servers) environment to SR9 from SR2,SR3 and SR5, i.e Was responsible for Qlikview Server migration and the Fresh QlikView Installation process.
• Create PDF push reports using Qlikview report editor.
• Played a vital role in Resolving the QV CALs wipe out issue on Dev and prod Servers.
• Provided in-depth analysis for Low CPU RAM Utilisation on Prod server and resolved the existing issue on same.
• Resolved the issue of Document Clear State with help of document trigger, conditional Variables/On Open of dashboard on the QV Acesspoint.
• Provided/revoked licenses (CALs) to the users on different server's application via QMC.
• (1100CALs on Cluster, 27, 96,250, 260 CALs on Dev, QA, Prod1, Prod2 respectively)
• Dealt and maintained iSmart (1Application of 8 sheets, 18 data model tables - 45min of reload time for 68109679 rows in fact table), Alinc(6Apps),Retail Adhoc(3Apps-calls,sales and Main),Oncology Adhoc(7), iFocus(retail, hospital, SABU-3) Applications - total of 20 Applications’ weekly and monthly refresh/reload.
• Responsible for Weekly Publishing/migration of refreshed applications to the salesforce field/Users and Created PDF push reports using Qlikview report editor.
• Redeveloped the data model/Involved in number of Minor Enhancements (MEs) like Adding new territories, new pharma products, adding/deleting RAMs/CADs (including Script, data model and UI) etc. In the above applications.
• Developed the dashboards, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Used Document Clear State/Set Clear State to set a home page for a document on users’ request.
• Used Dimension limits to restrict the number of values that are displayed.
• Application Performance optimization by following some of the Qlik’s Suggested methods like avoiding macros (at some places where it can be replaced by other means), Set Analysis for some ‘if’ conditions etc.
• Responsible for modifying and finishing some of the Dashboards’ UI and DataModel.
• Installed ODBC Drivers v 6.00.03.17780 for Qlikview/Netezza on prod server.
• Task set up are done using QEMC and designed the architecture for the interdependent applications and executed in proper order. Categorized numerous applications/Documents in the Access point via QMC.
• Created tasks for the auto reload/using create task wizard via QMC for couple of applications and Batch files (on servers) and used them to auto reload the qvws while automating the ETL process.
• Worked with 64 core processor with 512MB RAM Standalone server, two 108GB RAM - 16Core Processor servers, two 128GB - 24Core processor Servers, 256GB RAM - 32Cores processor Clustered (3QVS, 1 QMS) environment having Weekly refresh.
• Involved In performance testing/tuning - Load balancing of servers using JMeter.

Environment: Qlikview 11.2 - SR2,SR3,SR5,SR9, QLikSense 1.0.1,Aginity Workbench for Netezza 4.1.1136(2013),Oracle SQL Developer 3.2.20 TSQL, Jmeter, Windows 7 Enterprise server, Excel.

Confidential, New Port Beach, CA

Qlikview Developer-Administrator/SQL-BI developer

Responsibilities:

• Analyzing the call statistics and report the results and take the information and create reports.
• 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 modeling 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.
• Research and troubleshoot technical problems and Provided ongoing Qlikview consultation to the development team

Environment: Qlikview 11.0, SQL Server 2008, TSQL, MS Visual studio 10,Windows XP/2003 server, Excel.

Confidential, - Cleveland, OH

Responsibilities:

• Provided individualized training with innovative teaching methods to a diverse student population, at Confidential, in Physics, Mathematics, and Mechanical Engineering (Engineering Mechanics, Dynamics of Machines, SolidWorks, Pro/E)