SUMMARY:

• Around 9 years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using QlikView.
• Strong knowledge in designing and developing QlikView and QlikSense dashboards by extracting data from various sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.
• Worked installation & configuration, environment, system analysis, design, deployment, testing of projects.
• Experience in optimizing QlikView and QlikSense applications to improve the performance.
• Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
• Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
• Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
• Hands on experience in customizing the QlikView and N Printing reports as per the business requirements.
• Created incremental load process to load the data into QlikView applications from different source systems.
• I n - depth knowledge and understanding of data warehousing concepts, ETL, OLAP, OLTP, Cubes and normalizations to translate business requirements into effective business intelligence solutions
• Involved in Performance Tuning and Deployment of QlikView and QlikSense applications.
• Hands on experience in QlikView advanced features like Alternate States and Direct Discovery.
• Worked in Agile methodology environments and involved in scrum meetings.
• Experience on QlikView Scripting, Set analysis and Section Access.
• Scheduled the jobs and distributed to end users from QMC.
• Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub-Queries.
• Trained end users to develop and use QlikView and QlikSense applications.
• Managing job failure analysis and production support for various applications.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Understanding of data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract, Transform and Loading process of data.
• Created detailed design, development, testing & migration documents and performing Proof of Concepts (POC).
• Delivered all the projects and assignments within the specified time lines with accuracy.
• Strong ability to work within a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS:

Reporting Tools: QlikView 10/11,QlikView Publisher, ETL QlikSense 1.10, 2.0, nPrinting, QlikMaps, Tableau, Micro strategy

Languages: C, C++, Java, HTML, PL/SQL, HTML, CSS, Bootstrap, XML, JavaScript, .NET, Hadoop, Ruby On Rails, Shell Scripting

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling

Databases: Oracle 10g/9i/8i, SQL Server, Sales force, SAP

Operating Systems: Windows, Unix

WORK EXPERIENCE:

Confidential, Ridge, NJ

Qlikview Developer/Business Analyst

Responsibilities:

• Collaborated with Business Intelligence team to learn current processes and practices.
• Identified the Sales metrics for various businesses by interacting with users and analyzing Business Objects Reports.
• Experience in identifying user requirements, business reporting needs, layout, and development of prioritized reports by working with Business Analyst and Business user.
• Actively participated in the design, architecture and development of user interface objects in Qlikview applications.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in Qlikview delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application on Qlikview server and Imported data from various sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes to show the statistics of the sales held on various products in different years.
• Showed the statistics in bar charts and pie charts as per the client needs.
• Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.
• Created Layout themes and applied it to several documents.
• Used advanced scripting, set analysis, VBScript and advanced aggregation functions an advanced chart for applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Published reports, schedule report processing, or access reports on-demand.
• Successfully passed through the QA Environment and implemented on Production and worked as post production support.

Environment: Qlikview 11/12.0, Qliksense 2.0 Qliview Server and publisher, Business Objects, Oracle 11g.

Qlikview Developer

Responsibilities:

• Developing the high-end visualization Qlikview Dashboards using Qlikview objects.
• Designing, developing and deploying using QlikView Server & Publisher.
• Developing the QlikView reports, dashboards, building semantic/data models for adhoc reports, (QVD) generation etc using QlikView.
• Expertise in recommending/following best practices for Qlikview development as recommended by Qliktech.
• Expertise in building QV objects for different requirement such as straight table, pivot table,Different charts (Bar Chart, Line Chart, and Scatter Chart).
• Performed data modeling on requirements analysis by creating table displays, logical data model, star schema models and table designs.
• Expertise in managing QlikView Server, QlikView Publisher, QlikView Enterprise Version.
• Implemented Qlikview dashboards distribution to business users using Section Access to dashboards, providing CALs to documents
• Created Qliksense Dashboards as a Migration Project and Source change as well, including extension Object
• Worked on developing an extension to include 3 or more metrics in a single chart with different scales
• Working with Star Schema/Snowflake modeling, FACT & Dimensions tables.
• Working with QVD’s and tuning queries for QVD generation
• Integrating QlikView with web and thick/thin clients.
• Developed applications in Sense Desktop as well as in the QlikSense Hub and shared the apps with the team through QlikSense Cloud
• Drill Information by creating Groups/Cycles in QlikView.
• Entitlement and data level security for dashboard using SECTION ACCESS
• Extracting data from Oracle/SQL Server, TeraData database.
• Developed QlikView applications creating expressions using set analysis
• Analyzed and developed best practices for data management and Extract, Transform,
• Load (ETL) processes from multiple data sources.
• 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).

Environment: QlikView 11.2 SR 12, Qliksense 2.0, MS Visual Studio, SQL Server, Oracle, Tera Data, MS Access 2007, MS Excel 2007.

Qlikview Developer

Responsibilities:

• Analyzed database, tables and views for the underlying SEIBEL system
• Worked on requirements documents and design documents for the dashboards and reports
• Used the information in the section access for authentication, authorization and for dynamically reducing the data, so that users can only see their own data.
• Worked on dashboards for Sales force activities, Account calls, performance
• Created multi - layer data load scripts in QlikView. Wrote the extract layer, transformation layer and presentation layer scripts
• Scheduling the automation of QV jobs using QlikView/ Qliksense Management Console.
• Had worked on conditional show for different charts and using buttons in QlikView.
• Used load, resident load, concatenate, link tables. Created Master calendar for the Time dimension. Resolved synthetic keys, resolved loops
• Developed and designed the dashboards with diverse types of charts in Qlikview.
• Designed visualizations like bar chart, line chart, Combo chart. Created Drilldown and Cyclic groups
• Used Set analysis to perform data comparison for current vs previous years
• Involved in testing and code review.
• Deployed QlikView dashboard on the Server
• Managing and updating QVD files and dashboards. Interacting with business users. Resolved users’ queries.
• Created mockup dashboards on QlikSense to show how effective it is in decision making.
• Created maps using NPGeoMap QlikView extension object. Maps were created for different regions along with their sales.
• Worked on documenting Qlikview environment.

Environment: QlikView10.0 &11.0 SR2, QlikSense 1.1.0, QlikView Server/Publisher, Oracle 10g,MS-Word, MS-Excel, SEIBEL Compass system

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS SQL server 2005.
• Involved in migration of SQL server 2000 to SQL server 2005 using Upgrade Advisor.
• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS's using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.
• Involved in extracting the data using SSIS from OLTP and OLAP.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: SQL Server Reporting Services 2005/2008, SSAS, MS SQL Server 2005/2008, SSIS, PL/SQL, MS Excel and T-SQL

Business Analyst

Responsibilities:

• Responsible for gathering requirements (Business, User, System Functional and Non-Functional) by working closely with Subject Matter Experts, end users and development leads.
• Conducted interviews with end-users through JAD sessions and one on one session.
• Worked closely with the development team to ensure that the product meets all the requirements gathered from the business users.
• Created high level and detailed business requirements using Word, Visio, Power Point and Excel. Experience in preparing use cases for Functional Specification Documentation (FSD) and maintained the technical design document. Involved in preparation of design document, and data flow diagrams (DFD).
• Involved in Analyzing the as-Is process, Re-engineer some processes to develop To-Be Model and conducted Gap Analysis to identify discrepancies.
• Created logical data models to define business and project requirements for new system. Good at creating process models using UML (Use Cases, Sequence Diagrams, and Activity Diagrams).
• Worked along with testing team to ensure the testability of the requirements, and preparation of test criteria and test plans. Also, worked in conjunction with QA, Development and Client teams in UAT validation involving complex business scenarios.

Environment: SQL server, Jupiter, Windows NT, UML, Oracle.