SUMMARY

• An enthusiast with over 7 years of IT experience in Business Intelligence Tools in development, test and support phases of various reports.
• Experienced QlikView developer - the pioneered in-memory Dash boarding tool.
• Good knowledge and understanding of QlikView server, QlikView publisher and QlikView Enterprise version.
• Developed QlikView Dashboards using Chart (Drill down & Cyclic Grouping), List Box, Input Field, Table Box and Calendar & Date Island.
• 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.
• 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.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Implemented Triggers using Macros to provide custom functionality in Dashboard Applications.
• Designed and implemented proof of concepts for clients in the Healthcare, Agriculture, Automobile, Pharmaceutical, Financial and Manufacturing sectors.
• 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.
• Excellent analytical and teamwork skills. Team player with excellent verbal, written and interpersonal skills and capable of independent work with minimal supervision
• Outstanding problem solving, strategic thinking and data analysis skills, strong focus on teamwork and achieving team goals, result oriented, fast learner and excellent communication skills

TECHNICAL SKILLS

Dash boarding/Analytics: QlikView, Tableau, MS SharePoint

Languages: SQL, PL/SQL, C++, VB, C#

Database technologies: Oracle9i/10g/11g, SQL Server, Teradata, MySQL

Platforms: Windows Server 2008, Linux (Ubuntu).

Others: MS Access, MS-Excel, MS InfoPath, Visio

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Qlikview Developer

Responsibilities:

• Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors. Invloved in complete SDLC life cycle.
• Design, develop and deploy business intelligence presentation layer solutions in the provider healthcare market focused on analytics and reporting components such as dashboards, scorecards, reports.
• Held timely meetings with Solution Architect, Business Analysts, and Healthcare Subject Matter Experts to prototype, design and develop solutions to meet requirements.
• Created Dashboards style of reports using QlikView components like ListBox, Slider, Buttons, Charts, and Bookmarks etc.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more user-friendly in analysis purposes.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Developed Set Analysis to provide custom functionality in QlikView applications.
• Adopted Scrum methodology in the system development process.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback.
• Successfully performed User Acceptance Testing( UAT) before releasing to Production environment.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data from mentioned data source.
• Designed business intelligence dashboards using QlikView (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Very good knowledge in handling and troubleshooting the Qlikview Issues.

Environment: and Development Tools: Qlikview 11.0, MS-Access, SharePoint, SQL

Confidential, Glen Allen, VA

Qlikview Developer

Responsibilities:

• Worked with business requirements, provided technical expertise, and produced system specifications for enhancements & changes in the application.
• Translated the business requirements to system requirements. Traced the high-level business and user requirements to functional requirements and low level Use Cases.
• Presented requirements to the business owners and other IT teams (including design, engineering and QA) and PMO (Project Management Office) to secure approvals from the stakeholders and decision makers on the system functionality.
• Evaluated, analyzed and mapped various business processes and business object modeling to define the overall system functionality.
• Developed and articulated the Use Cases to the business owners and IT teams to demonstrate functional specifications.
• Facilitated collection of functional requirements from system users and preparation of business requirement documents that provided appropriate scope of work for technical team to develop prototype.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Extensively involved in business and functionality requirement analysis, understanding source systems thoroughly by creating the design process flow used for standard ETL implementations.
• Wrote Integrity Checks, SQL Queries to fetch data from multiple tables that had millions of records using Joins that produced Reports & Logs.
• Enhanced Test Cases by analyzing the Documents and tuned many SQL statements as part of De-Bugging.
• Partnered with other business analysts to ensure proper integration and merging of new system requirements and business rules into existing master requirements documents.

Environment: and Development Tools: QlikView 11.0, Cognos 10.0, MS-Access, SharePoint

Confidential, Atlanta, GA

Business system Analyst/Qlikview Developer

Responsibilities:

• Worked with the user community and senior management to identify the business’ reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business.
• Worked with different LOBs to understand the reporting and analytics requirements
• Converted Cognos reports to QlikView dashboards.
• Built multiple dashboards and presented to different user groups to make them understand the functionality of dashboards.
• One of the dashboard build was ATM transaction tracker dashboard. It tracked the ATM usage in the country by region, division.
• Worked with Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping Functions
• Used various KPI's for calculation purposes.
• Data was sourced from db2 environment. Used QlikView functions to load data viz Load, resident load, concatenate and so on.
• Created multiple tier QVD architecture. Created base layer, transformation layer and presentation layers.
• Created various sheets objects like Bar chart, Line graph, Straight table, pivot table, combo chart. Created complex expressions in charts.
• Involved in user training. Mentoring other team members

Environment: and Development Tools: QlikView 11.0, Cognos 10.0, MS-Access, SharePoint

Confidential, St Louis, MO

QlikView Developer

Responsibilities:

• Gathered, documented requirement from the users and developed Complex Graphical User Interactive reports using various QlikView Objects.
• Strong Skills in Data Modeling & Loading data from multiple data sources.
• Worked with Incremental Loading & QlikView document Versioning.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed different complex models eliminating closed loops, Synthetic tables and ambiguous relationships
• Work on requirement specifications for the strategic KPI's that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.
• Performed analysis, documentation for calculation for various attributes.
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds.
• Implemented Section access and Hidden scripting for the Application Security
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoted dashboards to production environment and manage user access.
• Developed Heat map charts with Alternate state for data visualization.
• Developed KPI’s, User Interactive Sheets as business needs
• Identified the highly memory consumption objects and performed necessary steps to reduce memory used by objects
• Developed a systems architecture for QlikView implementation identifying the data sources and target reports
• Analyzed end user requirements and developed technical solutions
• The project initially used Tableau but migrated to Qlikview during the 2nd phase of development.

Environment: and Development Tools: QlikView 11.0, MS-Access, SharePoint, SQL, XML

Confidential

Business Analyst

Responsibilities:

• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Installation & configuration Of QlikView Software.
• Created Drill-down group to study the sales and profit margin and also cyclic group in order to study the sales and profit margin based on various sectors of business.
• Contrasted and compared various parameters with that of their competitor’s.
• Used Check boxes and radio button for dynamic display of dashboards and reports
• Analyzed sales by demography and helped in targeting the right audience. Developed scatter and radar charts for regional analysis.
• Designed and developed easy to use dashboard with different types of Charts, Dynamic Text Objects, and Tables to meet the requirements in the simplest way.
• Developed different complex models eliminating closed loops, Synthetic tables and ambiguous relationships.
• Implemented complex SET Analysis for aggregation calculations so that set of records can be defined in an expression. Used Mapping tables, Apply Map, resident load, concatenate, joins etc. Implemented what-if functionality for analytical purpose.
• Worked closely with end users and developers to validate the data model. Created PDF push reports.
• Reviewed QlikView error logs and daily production support.

Environment: and Development Tools: QlikView 11.0, Cognos 10.0, MS-Access, SharePoint