SUMMARY

• 7 years of experience in architecture, development, and deployment of information delivery systems with extensive focus on Data Warehouse/Business Intelligence using QlikView Business Objects.
• Domain experience includes Retail, Insurance, advertisement and Banking.
• 4+ years of experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance of different analytical applications using QlikView Products (QlikView Server, Publisher and QlikView Desktop).
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• Extensive experience in Prototyping Qlik Sense dashboards using Story Telling, Beta maps integrations, Pivot Table, KPI Object etc. For evaluation to Business.
• Solid hands on experience designing mobilefriendly dashboards using Qlik Sense.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Hands on experience in formulating KPI's within Qlikview using functions and set analysis.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI’s.
• Created QVD’s & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Maintenance of data in form of QlikView/Qliksense data files, pulling the data from relevantdatabase.
• Developed Complex Graphical User Interactive reports using various QlikView Objects.
• Experience in Data Modeling along with resolving Synthetic Key and Circular Loop issues.
• Data Extract would load the Data from the data sources into the QVDs.
• Good at performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Experienced in Create, evaluate and select appropriate design alternatives which meet requirements and are consistent with standards and processes.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Experience in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong Communication, Organizational and Interpersonal Competencies along with Detail-oriented and problem solving skills in the technology arena.
• Always worked in close association with customers and a single point of contact for many major implementation projects.

TECHNICAL SKILLS

Reporting Tools: QlikView 9.x, 10.x, 11.x seriesLanguages C, Visual Basic, Unix Shell scripting and SQL

Databases: GreenPlum, Teradata, DB2, MS SQL Server 2012 and Oracle

Tools: / Utilities Pg. Admin, TOAD, Visio, Jira, Wiki

Scheduler: OPSWise, Cronacle

Configuration Mngt Tools: VSS

Operating System: UNIX, Linux, WINDOWS ... server

Software Development: Agile Methodology

PROFESSIONAL EXPERIENCE

QlikView Developer/ QlikSense Developer

Confidential

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• Involved in designing, developing, testing, publishing, maintaining and supporting QlikView and QlikSenseapplications.
• Developed applications in Sense Desktop as well as in the QlikSense Hub and shared the apps with the team through QlikSense Cloud
• Managed schedules and reloading of QlikView(TM) data model QVDs and QVWs through QlikView(TM) server.
• Involved in designing and construction of the Data model and implemented the Star schema for QV better optimization.
• Created dashboard style of layouts using different components of QlikView Enterprise such as List boxes, Multi boxes, slider, current selections box, buttons, text objects, bookmarks, etc.
• Created QVDs and developed Dashboard style of reports as per business needs
• Developed different KPI's as per requirement using advanced set analysis.
• Good knowledge of deploying Qlik Sense dashboards on the Sense Server.
• Involved in Dashboard migrations from Qlikview to Qlik Sense.
• Created dashboards using various sheet objects such as pie charts, bar charts, trend analysis, and Straight tables.
• Transfer knowledge to the services and support teams.
• Developed dashboards pertaining to Revenue and Sales monitoring using QlikView 11 SR2.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, and RDW) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView/Qliksense.
• Developed complex SET ANALYSIS to provide custom functionality in QlikView(TM) Applications.
• Have Good Experience with Quality Management Systems and compliance.
• Participated actively in the Server migration and the Fresh QlikView Installation process.
• Worked with QlikView/Qliksense administrator to optimize QlikView /Qliksenseperformance.
• Experienced in QlikView Server and Publisher maintenance andcreating scheduled jobs for QVD extracts and report reloads.
• Scheduling the automation of QV jobs using QlikView/Qliksense Management Console.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: QlikView10.0 &11.0 SR2,QlikSense 1.1.0, QlikView Server, SQL Server,Netezza, Toad, Windows 7, Windows Server 2008.

QlikView Developer/ QlikSense Developer

Confidential - NY

Responsibilities:

• Worked with Business Analyst and Business user to understand the user requirements, layout, and lookand feel of the application to be developed.
• Worked with QlikView 10.x, SQL Server, TeraData, Excel, CSV files.
• Two Dashboards were developed and served to track all the way through Ship to Final acceptance phase, which include Installation.
• Developed Proof of Concepts (POC) for various projects using QlikView and Qlik Sense.
• Gained experience in creating mobile friendly applications using Qlik Sense.
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields that help in modelingthe data according to the requirements.Split the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• A master calendar was used for time related dimensions and a strong source control methodology was used for tracking changes.
• There were 4 million records with incremental loading on daily basis.
• Enhancement and translation of the existing Dashboards in micro strategy into QlikView.
• Extensively worked with Set Analysis.
• Written complex expressions using Set analysis and various QlikView/Qliksensefunctions.
• Implement Actions/Triggers in the QlikView interface.
• Handled the end-to-end implementation of QlikView /Qliksense dashboard deployment.
• Involved in Performance Tuning & Deployment of QlikView Applications.
• Worked with QlikView 10.x, SQL Server, Oracle, DB2, Excel, flat files.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: QlikView 10.x, flat files, Oracle 11g, SQL Server, Access, Windows XP Professional.

QlikView Developer/ Consultant

Confidential - NY

Responsibilities:

• Interacted with End Users and Documented the Requirements.
• Developed various internal prototypes for acceptance testing. Followed the agile pattern of working and work execution.
• Creating scheduled jobs for QVD extracts andreport reloads.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Connected to multiple data sources such as Oracle, DB2, Flat files, Excel Spreadsheet's and prepared close to business requirement like model. (Especially star model and snowflake).
• Established a Standard structure for Test and working files (QVW) and version controlling to maintain clarity between production and Test environment.
• Implemented 3-Layer architecture, Binary loads and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.
• Incorporated necessary log files and failure mailing mechanisms for smooth day to day operations.
• Developed dashboards and KPI's using set analysis, variable creation.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application

Environment: QlikView 9, Oracle 9i/10G/11G, SQL Server 2008, Access, CSV Files, Windows 2008 Server.

Confidential

SQL Developer

Responsibilities:

• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Assisted new and existing clients with integration and data conversion activities.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Aided in development, execution, and maintenance of disaster recovery plans for all data services.

SQL Developer

Confidential

Responsibilities:

• Created, manipulated and supported the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported data from one server to other servers using tools like Data Transformation Services(DTS)
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedureand maximized the readability of such Stored Procedures.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Handled development and production support, document reviews, test plan, integration of the system.

Environment: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MSWord, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler