SUMMARY

• 8+ years of IT experience in all facets of Business intelligence applications with a strong background in Database development, Data Warehousing / Decision support systems and Business Intelligence (BI).
• Over 6 years in the field of Business intelligence and Analysis with QlikView 11.2/10.0/9.0 and QlikSense 1.0/2.0 and SAP Business Objects 3.1/4.0 as BI tool.
• Strong experience in Qlik product family such as QlikView Desktop Client, QlikView Management Console, QlikView Server, Qlik Sense Hub and Qlik Sense Management Console etc.
• Expertise in using complex multiple data sources such as Oracle, SQL, Flat Files, Excel and Access for designing and modeling of QlikView.
• Knowledge of QlikView Publisher and NPrinting.
• Experience in using ETL Tasks such as Data Cleansing, Joins, Aggregation Tables using QlikView and Qlik - Sense.
• Designing Data Mart and Data Warehouse and Implementation of QlikView and Qlik-Sense for BI Reporting Solutions.
• Extensive knowledge with Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables and General Ledger.
• Created scheduled jobs for QVD extracts and Report reloads.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Developed business requirements, dashboard development, and data verification and analysis.
• Experience with Multiple Relational Databases including Oracle, MS SQL Server, DB2, DBeaver and MS Access.
• Experience with QlikView sheet objects Pivot, List, Multi box, multiple charts types, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• Created set analysis applications, according to user needs.
• Hands on experience in solving performance problems such as timeouts, rendering delays, session disconnects, etc.
• Proven ability to troubleshoot and solve problems in a production support environment; possess analytical skills to effectively resolve technical problems, identify and implement process improvements, and think creatively.
• Excellent technical, analytical, and problem solving skills. Strict attention to detail and ability to work independently as well as within a team environment.
• Excellent written, oral communication and interpersonal skills.
• Strong experience in writing SQL Queries, views, stored procedures and SSRS processes.

TECHNICAL SKILLS

Reporting Tools: QlikView 11.2/10.0/9.0 , QlikSense 1.0/2.0, SAP Business Objects 3.1/4.0

Project Methodologies: Agile-Scrum, Waterfall, V-Model, Erwin

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/20052000/7.0/6.5 , SAP BW, SAP BPC, SAP BODS

Programming: SQL, PL/SQL, Transact SQL, ANSI SQL, XML, HTML, JAVA

OS Environments: Windows XP/2000/ NT/7, UNIX (HP, Linux)

Microsoft Office Suite: Excel, PowerPoint, Access, Outlook, Lync

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, New Jersey

Sr QlikView Consultant

Responsibilities:

• Importeddatafrom Excel datasources and data modelingas per user requirements.
• QlikView12 implementation and integration for financial data Risk Management.
• Created advanced Dashboard using QlikSense.
• Created Variables and Triggers to enhance the functionality of Qlik View.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complexdatamodels without synthetic tables and circular loops.
• DevelopedQlikViewapplications creating expressions using set analysis for Risk Management control Processes.
• Created and scheduled Complex reports by leveraging the basic components ofQlikView.
• Involved in data modeling and worked on a complex model as per given user requirement by eliminating Circular loops, Synthetic tables and ambiguous relationships.
• Implemented Set analysis and Aggregate functions.
• Developed Drill through Dashboards, which enabled users to drill down between dimensions.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis with charts provided by QlikView.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Created various Flags based on users requirements.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Trained End Users on Using QlikView Tools.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Managed schedules and reloading of QlikView data model QVDs and QVWs through QlikView Enterprise Management Console (QEMC).
• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.
• Installed IE plugins and trained the end users to use the reports effectively, to build and customize their ad-hoc reports.
• Designed a new application to support the dashboard style of layouts using different components of QlikView like List boxes, Multi boxes, current selections box, buttons, charts, text objects, bookmarks, etc.
• Involved in client communication sessions to evaluate client needs & ensure timely project deliver
• Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
• Worked onusing extension objectsin the front end for better visuals.
• Optimizedexisting data models including changing load scripts to load data in optimized way to achieve reduction ofloading time, simplifying complex expressionsin the front-end, improving layout structure.
• Involved in client communication sessions to evaluate client needs & ensure timely project deliver

Environment: QlikView12, QlikSense, Publisher 9, Python, MS Excel, MS PowerPoint.

Confidential, Plano, Texas

QlikView Developer

Responsibilities:

• Importeddatafrom OLEDB and ODBC connections and modelingdataas per user requirements.
• Involved in utilizingQlikSensesolutions to develop complex reports and executive dashboard on Cost center, cost element and WBS levels.
• Created Variables and Triggers to enhance the functionality of Qlik Sense.
• Created Architectural Conceptual documentation and Technical Specification Documents.
• Creating complexdatamodels without synthetic tables and circular loops.
• DevelopedQlikViewapplications creating expressions using set analysis for Balance sheet, P&L report.
• Created and scheduled Complex reports by leveraging the basic components ofQlikView.
• Developed Drill through Dashboards, which enabled users to drill down between dimensions.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis with charts provided by QlikView.
• Strong understanding in creating Dashboards for the required KPI’s in QlikView.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Trained End Users on Using QlikView Tools.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Designed a new application to support the dashboard style of layouts using different components of QlikView like List boxes, Multi boxes, current selections box, buttons, charts, text objects, bookmarks, etc.

Environment: QlikView11, QlikSense, SAP BW, Publisher 9, SQL Server, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel, SAP Solution Manager.

Confidential, Fort Worth, Texas

QlikView Consultant

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Connected to Oracle using OLE DB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule ad hoc reports by leveraging the basic components of QlikView.
• Developed KPI’s and set analysis applications.
• Developed QlikView data warehouse enterprise framework.
• Developed a QlikView Adventure Works Enterprise Template.
• Developed QlikView documents and frameworks for Financial, ERP, and CMMS, point-of-sale and medical industries.
• Used QlikView components such as List Box, Slider, Buttons, Charts and Bookmarks to create Dashboards.
• Generated new QVD files created by ETL logic to feedQlikViewapplications.
• Consulted with project/program stakeholders to understand business problems and translates them into functional and non-functional requirements
• Performed ad hoc duties in accordance to business needs.
• Improved the overall performance of the application and redesigned data model applyingQlikViewperformance tuning techniques.
• Dashboards served to track inventory and sales as well as to monitor various KPIs.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Involved in designing the Data model and Construction of the Data model and implemented the Star schema for QV better optimization.
• Created QVDs by importing data from the database tables using QlikView load script.
• Load Data into Qlik-Sense application from different QVDs files, Excel, Oracle, Inline & txt files.
• Developed the dashboard using chart objects such as Bar Chart, Line Chart, Pie Chart, Buttons, Straight table and Pivot table.
• Created Variables and Triggers to enhance the functionality of Qlik-Sense.
• Implemented Set analysis and Aggregate functions.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented the Navigation among the Tabs and Sub-tabs to show only corresponding charts.
• Implemented document chaining to drive through the channel and direct dash boards.
• Created ETL scripts for optimized reload of data.
• Provided first line of support to clients.
• Created tasks and deployed applications in Qlik-Sense Hub using Qlik-Sense Enterprise Management Console.
• Used Macros, Filters, Variables and Mapping Functions to achieve user requirements.
• Implemented core business model by eliminating ambiguous, Circular joins using Qlik-Sense best practices. Also, involved in ETL testing for validating the outcome.
• Improved the overall performance of the application and redesigned data model applying Qlik-Sense performance tuning techniques.
• Developed Proof of Concept for Customers.
• Complete responsibility of deliverables as well as the production support.

Environment: QlikView 10, SAP BW, SQL Server, MS SQL Server Management Studio, MS PowerPoint, MS Excel, SAP Solution Manager.

Confidential

QlikView Developer/Admin

Responsibilities:

• Develop Enhance, Re-Engineer and Maintain and Support QlikView applications to create robust services around business requirements to inform business decision-making.
• Take responsibility for Management Information report design and production. Scope and prioritize work stream.
• Participate in the analysis of trends and common issues to prevent future problems.
• Communicate problems and issues to key stakeholders, including management, development teams, and business end users.
• Participate in the design, development and implementation of QlikView applications.
• Analyze source data; understand relationships, hierarchies, groups, trends etc.
• Design QlikView dashboards, reports, data load procedures (ETL Scripts).
• Deploy all QlikView components and configure schedule for ETL procedures.
• Test QlikView application, script & QVDs as per the requirements.
• Test fixes and perform post-resolution follow-ups to ensure problems have been adequately resolved.
• Liaise with IT service center to facilitate solutions where applicable and assist in data understanding i.e. schemas and data definitions.
• Work with relevant teams within the business to scope and define reporting & dashboard requirements and KPIs.
• Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.
• Understanding the business functionality & Analysis of business requirements.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Assist with schema design and development of ETL processes.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Used QlikView Scripting and Complex SQL coding for loading, and transforming.
• Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions.
• 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.
• Implemented Data Level Security, Object Level Security & Document Data Level Security.

Environment: QlikView 9, Publisher 9, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, MS PowerPoint, MS Excel

Confidential

SAP Business Objects Developer

Responsibilities:

• Interacted with Business Users to know their requirements in developing and modifying Universes and Reports accordingly.
• Involved in translating these requirements into system solutions and developed implementation plan and schedule.
• Designed and Built the Universes, Classes and Objects.
• Specified the Joins, checked the cardinalities.
• Defined Cardinality based on the Business Requirements.
• Fine-tuned the joins avoiding outer joins and implementing shortcut joins.
• Improved the performance by resolving loops using Aliases or Contexts.
• Exported the universes to the Repository to share the resources among the users.
• Created different types of reports such as Master/Detail, Cross Tab and Charts.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Good experience in working with Ranks, Alerts, Filters, Prompts on reports.
• Extensively worked with multiple data providers and linking these data providers based on the requirements.
• Worked on Application Foundation and Dashboard Manager along with creating Matrix.
• Created reports on the web using Business Objects Web Intelligence.
• Extensively worked on Broadcast Agent server and customized scheduling and publishing reports.
• Published and Retrieved documents in Corporate document repository.
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Involved in migration from Business Objects 6.x to Business Objects XIR2.
• Performing the unit testing of the universes after the development.

Environment: Business Objects (Designer, Reporter, Supervisor), Dashboard/Performance Manager, Web Intelligence 6.0, InfoView, ZABO, Oracle 9i and Windows 2000.

Confidential

SAP Business Objects Developer

Responsibilities:

• Played a role of a Developer in developing Universe according to the Requirement from Data Source.
• Played a role of a Developer in developing Reports according to the Requirement from Universe.
• Perform Unit Testing and Capture Unit Test Logs.
• Work on Defects/incidents during the phase.
• Working with all BI and DWH concepts and architecture.
• Experienced with all the phases of project life cycle and full life cycle implementation (end to end).
• Designed dashboard & building business logic for creation of reports.
• Performed unit Testing and script review.
• Involved in System testing / UAT & resolve issues.
• Providing support to reports and Business Objects Applications.
• Getting in to a discussion with the team members to get the best approach in the implementing the logics in order to deliver the report in the most effective and efficient manner.
• Deploying code in different environments and preparing Data validations.
• Analyzed and developed best practices for data management and Extract, Transform, Load (ETL) processes from multiple data sources.
• Developed Proof of Concept for Customers.
• Complete responsibility of deliverables as well as the production support.

Environment: Business Objects 3.1, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, MS PowerPoint, MS Excel

Confidential

SAP Business Objects Developer

Responsibilities:

• Created and maintained around Business Objects reports and Web Intelligence reports.
• Built Cross-Tab reports.
• Added/created complex objects to the universe to enhance the report functionality.
• Built Custom Hierarchies in universe to facilitate drill down in the reports.
• Analyzed the reports using Slice and Dice, and Drill Down.
• Created graphical representation for existing reports.
• Performed data validation by creating ad hoc reports.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Created complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).
• Documented the deviations from the original specifications.
• Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications
• Enhanced the reports by providing event-handling features.
• Optimized the usage of user objects, conditions and universe level filters.
• Extensively used multiple data providers for building reports
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Performed Check Integrity in universe.
• Tested the universe structure to ensure the tables are properly updated along with the database

Environment: Business Objects 3.1, SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, MS PowerPoint.