SUMMARY

• Over 7 years of total IT industry experience analysis, design, testing, development and implementation of client/server applications. Experience covers areas of designing and development of Data warehousing and Business Intelligence applications.
• Expert level hands - on Qlikview experience including design, development, installation/configuration, data management, administration and support.
• Extracted data from different systems transformed and integrated in the QlikView.
• Good experience in design and development of QlikView for OLTP and OLAP Systems.
• Experience in Creating Dashboards using QlikView 11.0 using different data sources like DB2, Oracle, SQL Server, QVD files, text files, excel and developed Complex Graphical User Interactive reports using various QlikView Objects.
• Created scheduled jobs for QVD extracts and report reloads.
• Performed different types of loads like Incremental Load, Optimized Load & Binary Load, and Preceding Load & Buffer Load.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Strong knowledge in basic sheet objects of QlikView Enterprise like List Boxes, Multi Boxes, Table Boxes, KPI's, Charts, Current Selection Boxes, Buttons, custom requests for an Excel Export and Fast Change and reduce the complexity using Set Analysis and experience in for creating variables, fields, and calculated expressions, basic and aggregated functions and edit scripts and objects for Management Dashboard reporting.
• Experience in using ETL Tasks such as data cleaning, joins, keeps, concatenate, aggregation tables, Mappings using QlikView.
• Strong Skills in Providing Custom functionality using Macros and reduce the complexity using Set Analysis and objects for Management Dashboard reporting.
• Excellent skills in Triggers to achieve event based requirements.
• Strong experience in writing SQL Queries, Functions, views and stored procedures.
• Experience in developing different analytical applications using QlikView Product suite (QlikView Server, Publisher, and QlikView Enterprise).
• Extensive experience on developing reports from all RDBMS databases, SAP, Sales- force, MS dynamics AX, Oracle Apps and other tools.
• Worked on FI, SD, MM, OPS, HCM/HR and CRM Data sources and also used BI content HCM cubes for reporting.
• Exposure in all phases of Software Development Life Cycle (SDLC) including Requirement Gathering, Development, Testing, Deployment, Documentation, Migration, Security management, Training and Production support and methodologies in Business Intelligence domain.
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.
• Ability to adapt to new environment and a strong team player.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008, MS-Access 2000, Oracle 11g/12c.

BI Tools: Qlikview11.x/10.x/9.x, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Languages: C, SQL, PL/SQL, T-SQL.

Data Modeling: Star-Schema Modeling, Snowflake Modeling.

Web Technologies: ASP.NET, VB.NET, ASP, HTML, DHTML, XML, XHTML, CSS

Operating system: Win 9x/NT/2000/XP/Vista, MS-DOS, UNIX, Windows 2003 server

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. QlikView developer/ Admin

Responsibilities:

• Gather business requirements and participate in design review sessions.
• Understand the data from different source systems.
• Created applications using QlikView Data File (QVD) technology.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• Create and manage ETL script generation using QlikView Script Builder Application.
• Creating complex data models without synthetic tables and circular loops.
• Developed Qlikview applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of Qlikview.
• Currently assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
• 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.
• Identified Dimensions & Fact table’s form of source tables & implemented multi-tier architecture to create QVDs, data models and reports.
• Created link tables on the needed basis and as per the data.
• Developed executive dashboards in QlikView delivered through the web.
• Worked with Sheets and Sheet Objects in QlikView.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts and pie charts) to show the statistics on different kinds of insurances and loans in various years.
• Used layout conditions to meet various requirements.
• Developed Set Analysis to provide custom functionality in QlikView applications.
• Implemented document event trigger and field event triggers.
• Extensively used variables to meet various requirements.
• Used different color schemes for various charts accordingly to meet various requirements.
• Created daily, weekly, monthly and quarterly reports according to the Customer requirements.
• Back tracking QlikView Data Issues by comparing QlikView Reports with Database tables output using SQL queries through Toad.
• Worked on QlikView server and publisher to automate the QlikView jobs and define the user security and data reduction.
• Deployed QVW’s on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Good understanding in the area of monitoring the various services in QMC, Task setup, Managing client licenses, Mounting folders, session collaboration, enable session, performance and audit logging, type of authorization(NTFS and DMS),loop and reduce and Section access management in PAT
• 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.
• Manages user’s access to the QlikView Server and QlikView Access Point.
• Providing support analyst when internal teams have enquiries.
• Research and troubleshoot technical problems

Environment: QlikView11.2 (SR10), QlikView Server and Publisher (QMC), Toad for Oracle Base (10.6.1.3), MS Excel, Windows 2008 Enterprise.

Confidential, Pennington, NJ

Sr. QlikView Developer

Responsibilities:

• Responsible for developing reports for ACH, ACH operations, Commercial Lending, Content Management System, workout, loan servicing, loan initiation and financial reports using Crystal Reports 2008,Crystal Reports 2012,Qlikview 11.
• Document event trigger and field event triggers is created. Incremental reloading is implemented
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Document event trigger and field event triggers were created. Incremental reloading is implemented
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Created dashboards with complex sheets which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts, Heat charts, and Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT.
• Created Layout themes and applied it to several QVW’s.
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, and User Objects in the creation of reports.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects 3.1
• Used Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the business requirements using WEBI.
• Create different report formats like Report Template, sub reports, cross-tab and standard reports.
• Developed reports with different and multiple parameter fields and multiple grouping for different requirements.
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Involved in tuning of Crystal Reports for better performance and worked with SQL server 2012.

Environment: Qlikview11.0 (SR2), QEMC, SQL Server 2012, DB2, Windows 2008 server, HTML, VB Script & Java Script, QViewer, Business Objects 3.1, SAP Crystal Reports 2008,SAP Crystal Reports 2012.

Confidential, Raleigh, NC

QlikView Developer

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• This Project is related to marketing analytics, concern about the marketing of various insurance products and accepted pattern of the customers.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• The Process was Agile and strict time line oriented. Worked closely with Project manager and scrum master.
• Created PDF push reports based on 'loop and reduce'. Alternatively, wrote VB scripts to perform the same (based on requirement of user). Monthly distributed to specific user group via email, through publisher.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Application size is 39MB, with 178 demographic fields, 5 million rows of census data, associated with 95% data density.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• The application is used by 20 CAL licensed user, with additional session licensed users.
• Document event trigger and field event triggers is created. Incremental reloading is implemented.
• Created Document for the project planning and production Interface Documentation.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: QlikView 10.x, SQL Server 2008 R2, Netezza, Excel, CSV files.

Confidential, Woonsocket, RI

QlikView Developer/Admin Consultant

Responsibilities:

• Involved in Extraction, Transformation and loading data from different data sources.
• Creating Dashboard style of reports using Qlikview components.
• Charts are used in making reports more user friendly in analysis purposes.
• Involved in Dashboard development and Unit testing.
• Assist in testing and giving access to application after migration.
• Data modeling for Dashboard design.
• Used script functions in designing application development.
• Set analysis to provide custom functionality to application.
• Provide document level security for the application.
• Performance tuning to application.

Environment: SQL Server 2008 R2, Excel, XML, CSV, QlikView 9.0, Windows Server 2008

Confidential

QA Analyst

Responsibilities:

• Analyzed the requirement and design documents.
• Involved in writing Test Plans for the above applications by incorporating Performance Testing Objectives, Testing Environment, Workflows to be tested, Risks, Test Scenarios, Explanation about the Tools used, Schedules and Analysis, Monitors and Presentation of results.
• Responsible for creating Load Runner Scripts for above applications using Virtual User Generator and enhanced scripts with C functions, Parameterized Users, stored dynamic content in Load Runner functions. Included Text checks to ensure that the correct page has been loaded while executing tests, Created scenarios as per the requirements to bring down the testing scenario to the real world scenario. Monitored Response Time, CPU, Memory, throughput, UNIX and Web Logic Metrics while running the various scenarios in the Load Runner Controller.
• Involved in creating Load Runner Scripts using different protocols of Virtual User Generator.
• Responsible for preparing the data for performance testing.
• Oversaw installations, upgrades of SQL 2000, SQL 7.0 to SQL Server 2005.

Environment: Windows 2000 Server, C#.net, IIS and MS - SQL server 2005, MS Office.