SUMMARY:

• 6+ Years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Over 3+ Years of diverse progressive experience in Information Technology, with emphasis on Business Analysis using QlikView.
• Capable of gathering Requirement Specifications, performing Requirement Analysisand delivering end user documentation.
• Strong working knowledge of QlikView scripting, Set analysis, aggregation functions, multi - dimensional objects and layout including chart properties and formats.
• Performed detailed analysis of source systems and source system data and model that data in QlikView and QlikSense.
• Designed, developed and tested QlikView/QlikSense scripts to import data from source systems, data feeds, flat files.
• Strong Skills in QlikView 11, 10, 9.0, 8.5/8.0 in designing and creating dashboards and reports with various graphs and analysis.
• Experience in developing User Interfaces and QlikView Dashboards using several sheet objects Chart-Box (Drill Down and Cyclic Group), List Boxes, Input Fields, Table Boxes, and Calendars.
• Strong Experience in working with various Charts (Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Line-chart, Combo-chart, Bar-chart, Scatter-chart).
• Good Exposure in working with QlikView Functions (ApplyMap, Interval Match, Peek), Expression Scripts and Streamline Reporting operations of QlikView Applications.
• Good experience in using the functionality Join, Concatenate, Keep in the preparation of QlikView data model.
• Good understanding of Synthetic Key, Circular Loops and implemented the process to eliminate.
• Comfortable to use various sources like QVD files, MS Excel, Relational Tables, Binary QVW, Inline & txt files in developing the QlikView reports.
• Hands on experience in various loads - Binary Load, Inline Load, Partial Load, Incremental Load.
• Designed and utilized master calendar for time related dimensions.
• Proficient in SET ANALYSIS to provide customized functional QlikView applications.
• Tested Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users.
• QlikView Expert in full development Lifecycle reloads automation and management.
• QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model, QlikView scripting language, Macro, VBScript, JavaScript, AJAX, PDF reporting, QlikView Enterprise Server and Publisher, QlikView Developer, Section Access and Security/Entitlement model.
• Experienced in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good Knowledge on QlikView Extensions (Geomaps, Geo Qlik).
• Familiarity with QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• In-depth knowledge of industry best practices in both business management and technology domains.
• Experienced in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Worked in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Strong experienced in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• Excellent experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Trained the end users effectively to use the reporting tool (QlikView), to build and customize their ad-hoc reports.
• Worked in problem-solving and trouble-shooting capabilities, creation and implementation of KPIs, deliveries as per SLAs. Possessing in-depth understanding of the business needs on multiple domains, logical problem solving approaches, good communication and motivation skills.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS:

Business Intelligence Tools: QlikView/QlikSense 11.0 SAP Business Objects 4.0, Crystal Reports

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

Databases: MS Access 2000, DB2, MS SQL Server 2005, 2012 and Oracle, Excel & .CSV Files

ETL Tools: Informatica Power Center, Sql Server Integration Services (SSIS), SSRS

Operating systems: Windows 2003, Windows xp, 7/8, Ubuntu, UNIX

Domains: Retail, Financial, Banking, Healthcare, Services

Others: Microsoft SharePoint 2010, Adobe Captivate, Adobe FrameMaker, SnagIt

PROFESSIONAL EXPERIENCE:

QlikView Developer

Confidential, San Jose, CA

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications and Participated on business requirement document preparation.
• 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.
• Performed redesign of QlikView BI platform to improve availability, scalability and performance to accommodate high volume of data with 60+ dashboards.
• Performed time over time analysis of sales volume and revenue.
• Designed various Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Experienced in QlikView Dashboard design, aggregation functions, Set analysis, use of SQL scripts.
• Designed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.
• Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers.
• Implemented Set Analysis in sales dash board & Involved in Production.
• Involved in Extracting, Transforming and Loading data from different data source.
• Involved in Dashboard development & Unit Testing.
• Worked on writing SQL Scripts to load Data in QlikView Applications.
• Ensure consistency across applications as they are developed.Designed dashboards identifying the KPIs and to support the time comparison between budgets and actual.
• Design, develop, and test QlikView/QlikSense dashboards to meet customer requirements
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Create PDF push reports using QlikView report editor.
• Maintained user guides and documentation for QlikView applications.

Environment: QlikView 10/11, Oracle, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, Informatica, QlikView Enterprise Server, QlikView Developer

QlikView Developer

Confidential, Chicago, IL

Responsibilities:

• Study and analyzes the system, prepared technical & functional documents, create data model and generate required reports and support.Regularly interact with user and understanding issues.
• Created mock-ups or showcase the existing samples on intended functionality, visual aspects of the dashboards to be developed.
• Develop dashboard using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Line Chart, Pie Chart, Combo chart and so on.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Developed dashboards pertaining to KPI monitoring using QlikView 10.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
• Considering huge amount of records performed daily incremental reload.
• Participated in design workshops, providing technical insight and knowledge
• Worked with QlikView 11, SQL, Excel files and flat files.Worked on Incremental Loading to reduce the reload time of different applications and removed synthetic tables.
• Involved in Dashboard development & Unit Testing.
• Create PDF push reports using QlikView report editor.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to the development team and Maintained user guides and documentation for QlikView applications.

Environment: QlikView 10/11, My SQL, Windows Server 2003, Windows XP, Microsoft Visio.

QlikView Developer

Confidential

Responsibilities:

• Developed project documentation, testing materials, training materials, requirements gathering including downstream and upstream interface requirements and adhering to a project management methodology
• Gather requirements by regular interviews, document analysis, workshops, business process descriptions, use business case scenarios, business analysis, task and workflow analysis
• Analyzed, transformed and optimized large data sets, built dashboards using flat files and RDBMS databases that will feed the dashboards
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Create PDF push reports using QlikView report editor.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins
• Implemented security through section access at row level, tab level, report level at single sign-on window.
• Report published, group generated, privilege granted through QMC and Access Point.
• Created Dashboards using QlikView using various components like List Boxes, Sliders, Buttons, variety of Charts, Book marks.

Environment: QlikView 10, Oracle 10g, SQL Server 2008, MS Access, MS Excel, QlikView Server and Publisher

Business Data Analyst

Confidential

Responsibilities:

• Extensively used SQL queries for Insert/Delete/Update data using SQL Server
• Worked in data cleansing activities for data cleanup to remove any duplicate entries in the data.
• Participated in the design discussions and prepare the Data Migration Strategy
• Responsible for defining the unique identifiers for each mapping/interface
• Created Technical specifications documents based on the functional design document for data transformations and Data cleaning
• Created data quality mapping documents and performed Data Quality
• Involved in defining the source to target data mappings, business rules and data definitions
• Documented data quality and traceability documents for each source interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Worked with project team members to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Worked on preparation of the training material for end users.

Environment: MS office (MS Visio, Word, Excel, PowerPoint, Outlook, Access)