PROFESSIONAL SUMMARY:

• Over 8 Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• Hands on retrieving of external data from ORACLE, MS Access toQlikViewDashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Good knowledge of Data Warehousing Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Good working knowledge in Data Modeling including Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Expertise in Creating Dashboards using QlikView 11.0/10 using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated dashboard as per the user requirement.
• Good experience in design, development and maintaining Dashboards and BI applications using Qlikview.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Hands on Qlikview reporting/visualization in development projects.
• Experience on developing and architecting BI Solutions using Qlikview.
• Experience in Database structuring, database application design & development, Entity Relationship Modeling (ERM), Data export/import, SQL programming &ETL procedures.
• Design of Qlikview applications using Qlikview Data (QVD) files generated by ETL logic.
• Experience in designing Qlikview Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Expertise in Development and Implementation ofQlikView Dashboards based on complex data extraction and load architectures.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Assisted less experienced Business Objects andQlikViewuserson building their own reports.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Strong skills in providing custom functionality using Macros, Triggers, Set Analysis.
• Experience in Loading Data from Multiple data sources to develop the QlikView Data Models.
• Good working knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
• Hands on experience in customizing theQlikViewandNPrintingreports as per the business requirements.
• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling (Normalization/De normalization, ER Diagrams, Keys).
• Experience in writing SQL Queries.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills.
• Ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS:

QlikView Tools: Macros, Action, Set Analysis, QVD, Google Maps.Business Intelligence Tools QlikView 11.2, SAP Business Objects 4.0, NPrinting.

QlikView Administration Tools: QlikView Server 11, Publisher, QEMC.

QlikView Security: Section Access, Conditional Hide/Show, Hidden scripting, File Reductions.

Databases: Oracle, MS SQL Server, MySQL, Access, SAP Connector

Operating System: Windows NT, XP, 7, 10.

MS Office Tools: Access, Excel, Word, Power Point.

WORK EXPERIENCE:

Confidential, Austin, TX

Qlikview BI Developer

Responsibilities:

• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Gathering data sources like QVD files, Excel, Oracle, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Roles and responsibilities include developing, enhancing, re-engineering, maintaining and supporting QlikView applications.
• Conduct validation of existing reporting and new solutions to ensure continuous accuracy, and front end ease-of-use.
• Developed and designed comprehensive and innovative ad-hoc dashboard to provide manufacturer with broad
• Visibility into its largest distributor, incorporating sales, forecast, target, and inventory metrics.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Worked closely with visual design team to select the appropriate visualizations for BI deliverables
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Designed and developed the incremental loads where applicable. Created Excel reports, PowerPoint reports and Word Reports usingNPrinting tool.
• Created tasks and scheduled the jobs inNPrintingserver.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Development and Implementation ofQlikView Dashboards based on complex data extraction and load architectures.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data, resolved Circular Relationships, Synthetic Keys.
• Maintained both File and Data Level Security and implemented Data Reduction.
• Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques.
• Published Client application using QlikView Publisher and rolled out to Shared Drive with security permissions using Active Directory features.
• Experience with QlikView Enterprise Management Console.

Environment: QlikView 11, Oracle 11g, Access, Qlikview Server, Qlikview Enterprise and Qlikview Publisher, Windows 2003 Server, SQL Programming, NPrinting.

Confidential, Woonsocket, RI

QlikView - BI Developer

Responsibilities:

• Meetings with end users to gather the functional requirements and customize Qlikview dashboards accordingly.
• Involved in understanding the business from different areas and gather requirements.
• Developed different dashboard with a complex database system which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Validation of Qlikview application at base level against QVD’s and Excel test files.
• Set Analysis in providing custom functionality to QlikView Applications.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String&Input Fields).
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using Qlikview Enterprise Management Console.
• Gathered & loaded data intoQlikViewfrom various data sources (SQL SERVER 2005, Oracle 10g, .CSV and excel files).
• Monitoring of the QVS (Access Point), QVW's and user accounts for the usage of the applications.
• Implemented section access which allows user to see by default their Region’s data and population attached to a particular Region.
• Performance tuning of dashboards was carried out to limit the response time to well under 10 seconds.
• Good knowledge in OLAP design knowledge.
• Implemented security layer and extensively involved in the deployment activities of the Qlikview Application.
• Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory.
• Wrote SQL Scripts to load relevant data in QlikView Applications.

Environment: Qlikview 11, Qlikview Server, Qlikview Enterprise and Qlikview Publisher, Business Objects, Excel, MS SQL Server 2005, SQL, Oracle 10g.

Confidential, MWashington. DC

QlikView Reports Developer

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.
• Played a part a Business support solution provider and closely work under the environment of WAR room meeting, complete brain storming.
• Develop front end applications using QlikView technology.
• 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 parity between production and Test environment.
• UsedQlikViewdirect discovery along with Document chaining to fetch on-demand report from linear database after creating View inside the database to protect performance from huge data loading during mass data accumulation due to Granular data fetching.
• 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.
• Worked on data model according to the user requirement and successfully created an optimized QlikViewapplication.
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard.
• Developed Dashboard and What-If predictive analysis based on complex price calculation.
• Developed reports / KPI's for Supply Chain mechanism, including supply demand GAP and self-life stock monitoring reports.
• Developed dashboards and KPI's using set analysis, variable creation etc. for individual payroll details, comparison with peer and comparison with the market.
• Performed testing of dashboards for functionality, data, performance, and UI design.
• Created weekly PDF report distribution for a set of users using Loop and Reduce functionality through QV Publisher.

Environment:QlikView10, Oracle 9i, SQL Server 2008, SQL, Qlikview Server, Qlikview Enterprise and Publisher, Access, CSV Files, Windows 2008 Server, SharePoint.

Confidential

QlikView Consultant

Responsibilities:

• Involved in User requirements and Documentation and Dashboard Prototypes.
• Created various dashboards using different kind of charts - Bar, Line, Combo, Scatter, Grid, Block, Spider, Pivot and Crossable.
• Written complex expressions using Set analysis and various QlikView functions.
• Build sales dashboard for secondary / distributor's network.
• Including analytics for on CRM data, trend analysis, performance analysis for sales reps, after sales service dashboard, part supply chain management, JIT dashboard for logistics.
• Create a robust model by adding multiple source of data from Sales Data warehouse and CRM.
• Create a significant Analytics to find out Assortment and commissioning no. of different model parts which are laying unused in the assembly line after testing release of the cars.
• Developed data model to reflect a Start model after translating various sources into Dimension and Facts.
• Eliminated all Synthetic keys and Circular References in order to make data model efficient.
• Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies.
• Implemented Section access and Hidden scripting for the Application Security.
• Involved in QMC Administration, Server/Publisher installation and Configuration.
• Implemented Data security using Section access and Publisher Data Reduction.
• Create KPI's on comparative analysis by using Alternate State functions for different car variant.
• Developed QlikView Reports for PDF Distribution via Email.
• Involved in the entire lifecycle of QlikView Dashboards.
• Involved in Testing Dashboard data using extensive SQLs, Excel Pivots and Mappings.

Environment:QlikView9, Oracle 10g, Access, XML Files, MS Excel, Windows 2003 Server, Crystal Report.

Confidential

SQL Developer

Responsibilities:

• Develop, test, and tune database code and information.
• Support product development and quality assurance teams.
• Design and maintain SQL scripts.
• Provide technical support and guidance to staff and clients.
• Generate reports and spreadsheets detailing database changes and performance
• Created standard filters, prompts, calculations, and conditions in Catalog.
• Defining join conditions, table aliases and views for the user requirement
• Created Joins, folders, reusable filters, pre-calculations, prompts.
• Updated Impromptu Catalog by adding tables and creating new joins
• Developed drill through reports, developed filters, conditional formats and prompts using Prompt manager.
• Created IQDs are used as data sources in power play Transformer to generate Transformer models.
• Published Power play reports to Upfront.
• Scheduling Impromptu web reports in upfront.
• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications.

Environment: MSSQL Server 2005/2008, T-SQL, C#, Asp.net, Windows NT.