PROFESSIONAL SUMMARY:

• More than 9 Years of real time IT experience in Architecture, analysis, design, development and implementation of QlikView and QlikSense applications.
• 4+ years of experience as a QlikView Developer.
• Extensively worked on QlikView to implement applications as per client requirement
• Expertise in QlikView performance optimization.
• Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (Oracle, Flat files, Excel, Access).
• Extensively worked on Data Analysis/Mining using QlikView.
• Worked on different QlikView objects like straight tables, line charts, bar charts and pivot tables Etc.
• Expertise in Installing and Configuring QlikView/QlikSense Desktop, QlikView/QlikSense Server, QlikView Publisher and also QlikSense Server.
• Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.
• Expertise on set analysis, advanced aggregation and section access.
• Hands on Experience with QlikView Architecture in development and deployment.
• Expertise in the Qliksense SDLC and governance.
• Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
• Extensive experience in using NPrinting for quick generation of reports and QlikMaps analytics engine.
• Can write and analyse complex SQL queries.
• Trained the end users effectively to use the reporting tool, to build and customize their ad - hoc reports.
• Strong understanding of Dimensional Modelling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Automation and Macros interface, Section Access, Set Analysis in QlikView and DW concepts.
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
• Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading.
• Improved Performance of the queries by creating Clustered and Non Clustered Indexes and by optimizing the T-SQL statements using MS SQL profiler, Job Activity Monitor and Performance monitor.
• Developed Triggers, Stored Procedures and Functions for the custom database objects.
• Customized and optimized the existing stored procedures according to the Technical specifications and performed performance tuning on the existing stored procedures using performance monitor, SQLprofiler, query execution plan, Query Analyzer.
• Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.

TECHNICAL SKILLS:

Dashboarding/Analytics: QlikSense, Qlikview 11.0/10.0/9.0, Qliksense 2.0, Tableau, Microsoft SSRS, Cognos, Power BI, Tibco, Spotfire, Micro Strategy, Crystal Reports

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

Database Technologies: SQL Server, Oracle 10g/11i, SQL Server, Toad, Teradata, DB2, MS Access.

ETL Tools: Informatica, Cogno s, SSIS,SSRS

Operating systems: Windows7/XP/Vista, Windows 2000/2003/2008 Server, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential - Montvale, NJ

Sr. QlikView (QlikSense) Developer

Responsibilities:

• Involved in full project life cycle implementation (i.e., from requirement gathering to deployment) of Qlikview dashboards.
• Designed & developed Qlikview dashboards for Operations & Marketing business groups.
• Developed HR dashboard to track the trends and needs of staffing over time.
• Created Retirement Eligibility analysis trend for the next 5 years based on the retirement age group and eligibility dates.
• Integrated Payroll related data into the HR Dashboard for all the FTE staff and developed forecast analysis related to Bonus and Profits.
• Analyzed position grade changes and created charts to show the journal of salary increments and position changes.
• Designed many Data visualizations with Qlikview.
• Took active role in the design, architecture and development of user interface objects in QlikView applications.
• Connected to various data sources like SQL Server, Oracle and flat files.
• Worked with Big Data, Hadoop and Data warehouses.
• Involved in Implementation of ongoing changes and control of the data model.
• Worked on Optimizing existing data models including changing load scripts which is used to load data in an optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Implemented Section access and hidden scripting for the Application Security.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Extensively worked with Set Analysis. Expert in writing complex set analysis expressions in Qlikview applications.
• Extensively Used Advanced Aggregations and Used Set Analysis.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publisher.
• Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher.
• Maintained and administered source documents, source document sets, user profiles and executed resource management services like Access point resources, distribution folders and email servers.
• Reviewed QlikView error logs and provided production support.
• Involved in resource training & team building activities.
• Also, involved in creating charts and dashboards in QlikSense.

Environment: Qlikview 11.SR 10, QlikSense 2.0, NPrinting, Microsoft SQL Server, Oracle, HTML.

Confidential, Buffalo, NY

Sr. QlikView /Qliksense Developer

Responsibilities:

• Full life-cycle development and implementation of QlikView for a packaged Help Desk/Service Desk module. Involved in Analysis, design, installation & implementation of the BI solution. Converted and enhanced an older Oracle Discoverer BI solution and implemented QlikView.
• Extracted data from the database, stored into QVD files, and wrote load scripts.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Use of Set analysis and aggregation functions for sheet objects.
• QlikView dashboards optimization.
• Strong working experience in Load script and Data modeling.
• Building the QlikView extensions.
• Working with all types of data loads and functions like Automap.
• Working experience with SQL/Server T-SQL, SSIS and SSRS (MSBI).
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Implemented drill down and cyclic dimensions.
• Excellent knowledge of JavaScript, CSS and their behavior on different browsers.
• Extract, transform, cleanse, and load ( ETL ) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server .
• Developed data base tables and created SSIS packages .
• Eliminated Synthetic keys, ambiguous relationships and closed loops.
• Designed proficient dashboards according to the requirements.
• Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections.
• Developed dashboards for data analysis with strong programming skills.
• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Use of Set analysis and aggregation functions for sheet objects.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources there were 4 million records with incremental loading of … Enhancement and translation of the already existing Dashboards in Business Objects into QlikView.
• Debugging the QlikView server issues through server logs, Fiddler logs.

Environment: QlikView 10, QlikView dashboard, Business Objects, SVN, Oracle 10g/11g, Subversions, MS Access, MS SQL server, Agile Methodology.

Confidential, Libertyville, IL

QlikView Developer

Responsibilities:

• Creating dashboards by extracting data from database write and externalized the load scripts, store the data as QVD files.
• Experience in generating of QVDs .
• Experience in working with QlikView Functions .
• Experience in Incremental Loading to reduce the reload time of QlikView applications .
• Developed Scripts to load the relevant Data in QlikView Applications .
• Implemented set analysis in QlikView Applications .
• Developed dashboards for data analysis with strong programming skills.
• Created QVD'S & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys .
• Data Extract would load the Data from the data sources into the QVDs, Data Model will define the relationships between the tables(QVD) and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds on calculation and defining server sizing for optimal performance of QlikView dashboards .
• Maintain tested applications for quality assurance and production support .
• Creating mock up with the sample data, created model with Extract, Transformation and Data Model in QlikView.
• Debugging the QlikView server issues through server logs, Fiddler logs.
• Developed SQL scripts to load business data and used VB macros and set analysis to create customized reports for regulatory reporting.
• Developed KPIs and set analysis application with QlikView functions (join, concatenate, keep, apply map).
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models
• Expertise in working with multiple modules of business with 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.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modelling the data accordingly the requirements.
• QlikView data modeling by building the Star schema and resolving loops/synthetic keys.
• Implemented the Various scenarios of section access.
• Use of Set analysis and aggregation functions for sheet objects.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Working knowledge in SAP Business Objects (3.1, 4.0) and CMC.

Environment: Qlikview11, QV publisher, QV access points, QMC, QVWS, SQL server2008, CSS, HTML.

Confidential, Bloomfield, CT

Qlikview Developer

Responsibilities:

• Created and Monitored Batch processes and Sessions.
• Created Proof of Concepts, Prototypes, and Business rule documents.
• Designed and populated Time hierarchy, Geography hierarchy, and Transformation tables.
• Experience in Healthcare payer used in the transactions.
• Experience in medical claims and created reports on claims database.
• Used HIPAA rule for personal health information held by covered entities and gives patients an array of rights with respect to that information and also claim according to the plan benefits.
• Scheduling the created reports to users by creating Narrowcast Subscriptions and Services.
• Tested Micro Strategy Reports.
• Responsible for interacting with the Business Users regarding information about the Project Deliverables, and on finalizing System and Reporting Requirements.
• Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modelling and Data Warehousing applications.
• Responsible for designing and executing Application objects and Schema objects using Micro Strategy Desktop.
• Retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB .
• Developed different types dashboards using Qlikview like charts Bar charts, Line charts for Trend Analysis, Straight, Tables, Pivot Tables, Pie charts etc.
• Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.
• Designed and deployed customized reports and Documents into Micro Strategy web.
• Highly involved in creating Advanced Reports in the desired formats (Grid, Graph, or SQL) involving multifaceted data analysis using Micro Strategy Desktop and Web.
• Responsible for improving the performance of the reports by efficient usage of Data Marts and Report Cache Sharing.
• Involved in extraction of data from different Sources like SQL Server, Oracle, Flat Files into Teradata Global Repository Database, using Informatics.

Environment: Micro Strategy 7.5 (Administrator, Architect, Desktop, Object Manager), SQL Server, Informatica, Oracle 9i, HTML & DHTM

Confidential - Hartford, CT

SQL Server Developer

Responsibilities:

• Understand and evaluate UNIX, SQL, and or Data Modeling.
• Design and develop T-SQL procedures, query performance tunings, and SSIS packages.
• Develop underlying data models and databases.
• Develop, manage, and maintain data dictionary and or metadata.
• Ensure compliance of standards and conventions in developing programs.
• Design, develop, and implement complete life cycle of data warehouses.
• Translate business requirements into software applications and models.
• Resolve and troubleshoot complex issues.
• Perform and execute data extraction, transformation, and loading using ETL tools.
• Maintain and manage all versions of data models for production, testing and developing databases

Environment: Oracle 8i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows .