SUMMARY:

• Creative, hands - on analytics solution expert with a proven track record of providing the next level of business intelligence: Business Discovery. Adept at quickly implementing advanced analysis and visualization techniques to unearth major new business insights.
• Expert in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable Directors, Vice Presidents, and C-level executives to take informed action.
• 8 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 Confidential, 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 EXPERTISE - SKILL MATRIX:

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

PROFESSIONAL EXPERIENCE:

Confidential, Mettava, IL

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 singleQlik Sensevisualizations, 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.
• 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.
• 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.

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

Confidential, Morristown, NJ

Sr.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

Sr.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

Sr.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, Newark, DE

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 modeling 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...)
• 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 analyzing 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, TSQL, MS Access,Visual studio 10, BIDS, Teradata, Windows XP/2003 server, HTML, Excel

Confidential, Franklin Lakes, NJ

QlikView Developer/Admin

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• 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.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• 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 Qlikview.
• Gathered & loaded data into QlikView from various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files.
• Automated and scheduled daily/weekly/monthly data 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.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting using Qlikview 8.5
• Implemented Star schema & snow flake schema (confirmed dimensions).
• Developed Linked Tables, Concatenation and solved the loops issues.
• Read and gather Qlikview Planning requirements.
• Used to solve the issues related to the end users.
• Installation/Configuration of Qlikview 8.5.
• Working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Research and troubleshoot technical problems and provided ongoing Qlikview consultation to the development team.

Environment: Qlikview 11/10, Web Intelligence, Info View, TOAD, MS SQL Server 2005, Visual Studio 2005, T-SQL, MS Access, Windows XP/2003 server, HTML, VB Script & Java Script.

Confidential, Deerfield, IL

Qlik View Developer/ SQL Server Developer

Responsibilities:

• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
• Participate in enterprise DW / BI strategy/Dashboarding.
• Qlikview 9.0 implementation and integration.
• Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complex data models without synthetic tables and circular loops.
• Create and manage ETL script generation using QlikView Script Builder Application.
• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Involved in design and development of QlikView Platform integrated with Expandable Databases.

Environment: Qlikview 9.0/10, Windows 2003 Server/XP, SQLS 2005/08,TSQL,MS Visual Studio, MS Access 2007, MS Excel 2007.

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, 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 Center.
• 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.