SUMMARY

• Over 6+ years of professional experience in the field of Business Intelligence and Analysis.
• Knowledge of industry best practices in both business management and technology domains.
• Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.
• IT industry experience in Insurance, Internet Security, Manufacturing, Supply-Chain Management and Financial with Functional knowledge in daily operation of these industries.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.

TECHNICAL SKILLS

Databases: MS-SQL Server 20XX, MS Access

Reporting: QlikView 11.0, 10.0, SQL Server Reporting Services, Excel Sheets

OS: Windows 7/XP/NT, Linux, Win Server 2003, WinServer 2008.

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

QlikSense/QlikView Developer

Responsibilities:

• Currently working on QlikSense Proof of Concept, this involves measuring QlikSense requirement in terms of total usage, new server installation and maintenance. Managing tasks and triggers, managing QlikSense Hub.
• Installed and Configured QlikView and performed clustering among global servers using round-robin load distribution, handled all licensing tasks.
• Implemented field level and bookmark reduction on apps, applied security using combination of both document level and server level approaches.
• Assigning different (document, supervision etc.) roles. Implemented Impersonation. Integrated EDX with AutoSys for scheduling tasks.
• Collaborated with Business Intelligence team to learn current processes and practices.
• Develop database procedures, transformations, integrations, and queries to access and transform data.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Document design, development, optimize and maintain, reliable, repeatable and scalable ETL packages utilizing SSIS.
• Develop, maintain, and administer complex ETL processes using MS SQL Server 2008 (DTS and SSIS)
• Create Tables and Service broker process for asynchronous data transfer.
• Created SQL server jobs and SSIS packages.
• Involved in creating ETL tasks and jobs using DM Express
• Developed executive dashboards inQlikViewdelivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Design, Develop, Test, debug and implementQlikViewsolutions based upon specified requirement.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimizing reports.
• UsedQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc )
• Extract, transform and load data from multiple sources intoQlikViewapplications.
• Generated new QVD files from the EDW by writing scripts inQlikViewapplications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys.
• Developed KPIs, SET ANALYSIS to provide custom functionality inQlikViewApplications
• Create PDF push reports usingQlikViewreport editor
• Develop, troubleshoot and fine tune existing and new reports

Environment: SQL Server 2008 R2, Windows Server 2008, QlikView 11.2

Confidential, Wayne, PA

QlikView Architect

Responsibilities:

• Participating in business requirements and design review sessions
• Providing input on proposing, evaluating, and selecting appropriate design alternatives which meet requirements and are consistent with our current standards and processes extracting, transforming and loading data into QlikView applications
• Extract, transform and load data from multiple data sources into the QlikView applicationby following implementation standards.
• Developing, testing, debugging QlikView applications
• Creating views, stored procedures and QVDs for QlikView app consumption
• Tuning data loads and QlikView application for efficient performance
• 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.
• Leading team of 4 Member, which includes two offshore Qlikview developers, one Database Admin.
• 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.
• 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.
• 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.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: - SQL Server 2008 R2, Excel, QlikView 10.0

Confidential, PA

Responsibilities:

• Performed planning, design and development of QlikView BI dashboards and data integration in a highly complex environment.
• Customized and deployed Governance dashboard and Optimizer for App’s usage and health at granular level helping optimize QlikView investment.
• Integrated QlikView with Firm-wide intranet portal. Created Comparative analysis to allow customized groups on demand using alternate states.

Environment: SQL Server 2008 R2, QlikView 9.0, Windows Server 2008

Confidential, NYC

SSIS/QlikView Developer

Responsibilities:

• This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
• Leading team of five onshore Members, three offshore QlikView developers and one Database Admin.
• Analyzed the database and provide detailed information on their operational and Forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Maximum Application size is 8.5 GB, with 56 Booking and Revenue 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.
• Was actively in the Server migration and the Fresh QlikView Installation process.
• 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.
• 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.
• Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
• Worked with QlikView 10.x, SQL Server, TeraData, Excel, CSV files.

Environment: SQL Server 2008 R2, QlikView 9.0, Windows Server 2008