QlikView, SAPBO

Professional Summary:

Around *+ years of experience in IT industry with strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and implementation of QlikView for BI applications

Developed Complex Graphical User Interactive reports using various QlikView Objects

Installed & Configured QlikView Software

Experience in Incremental Loading and QlikView document Versioning

Experience in QlikView dashboard design, aggregate functions, multi-dimensional objects, set analysis, using SQL Scripts, VB Scripts to write Macros in QlikView and/or Excel

Experience with QlikView Publisher and well versed on working with hierarchical data

Experience with QlikView Development, Server setup, configuration and administration in a clustered environment

Implemented Triggers using Macros to provide custom functionality in Dashboard Applications

Involved in Performance Tuning and Deployment of QlikView Applications

Technical expertise in Microsoft Technologies such as MS SQL Server 2008/2005/2000, MS-Access, DTS and worked extensively on Reporting services (SSRS) and Integration services (SSIS)

Extensive experience on Data modeling, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT& Dimensions tables, Physical & Logical data modeling, T-SQL/SQL Development, Stored Procedures, Views, Indexes, data integrity, Error Handling, Data Analysis and Normalization.

Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Parameterized and distributed reports in multiple formats using SSRS.

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

Experience in covering every aspect of the business of customer relationship management (CRM)

Provided Training Sessions on QlikView capabilities to potential clients

Implemented Best Practices & Worked on Data model/Script to resolve Circular Relationships, Synthetic Keys

Excellent analytical, communication, interpersonal skills and also have the ability to work effectively as a team member.

Education:

Bachelor's in Engineering, Acharya Nagarjuna University, India (April 2006)

MS California State University, Fresno (Dec 2008)

Technical Skills:

Operating Systems

Windows 2000/ NT/ XP/ Vista/98/ 95, UNIX/Linux, Windows 2003 server.

Programming Languages

C, C++, C#.Net, VB.Net, JAVA, SQL, T-SQL, PL/SQL, XML.

RDBMS

MS SQL Server 2008/2005/2000, Oracle 8i/9i/10g, MS Access 2000, My SQL.

Client Scripting

JavaScript, JQuery, VB Script.

Web Technologies

ASP.Net, JavaScript, HTML/DHTML, XHTML, XML.

ETL

DTS, SQL Server Integration Services (SSIS).

Analytical Tools

SQL server Analysis Service (SSAS), Performance Point Server 2007, ProClarity Analytics Server

SQL Server Tools

Query Analyzer, SQL Server Profiler, SQL Server Mail Service, Enterprise Manager, SQL Server Agent, DTS, BCP.

Versioning

Team Foundation Server (TFS), Visual Source Safe (VSS), SVN.

OLAP/Reporting Tools

SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), QlikView, SAPBO

Professional Experience:

Client: Polycom, Inc., San Jose, CA May’17- Current

During this assignment:

i.Developed “T4SLO” dashboard to track the Uncommitted Escalations within SLO (Service Level Agreement)

ii.Migrated OBIEE/ QlikView reports (Revenue, Demand Supply) to Qlik Sense self-service discovery applications

iii.Developed PMO Qlik Sense self-service discovery application

iv.Developed Engineering Quality Qlik Sense self-service discovery application

Responsibilities:

Qlik Sense Consultant

Worked with end client/users to gather requirements, documented and provided sign-off from Polycom

Worked on Design and Development of Qlik Sense Data load scripts

Involved in day to day meetings with users to gather requirements, security review, analysis of the data and requirement specifications

Mapped data and configured the connections to pull data from different sources to Qlik

Worked on developing the User Interface, validating the data and scheduling the jobs using the publisher to reload the dashboard for user consumption

As a lead QlikView developer helped other developers and business users in resolving issues with existing and new applications

Environment: QlikView 11, Qlik Sense Hub 3.1, SQL Server 2003/2008 R2, Siebel (Oracle 11g, Access), .CSV Files, Excel, Jira, Salesforce, NPrinting 17, Windows 2008 Server, Toad 12.1

Client: Fox Networks Group, Playa Vista, CA Sep’16-Apr’17

During this assignment:

i.Migrated Fox’s Pace system dashboards to OnAir System

ii.Migrated WebFOCUS dashboards to Qlik Sense self-service discovery applications

iii.Developed CAS Reporting and Sold Dollars Analysis Qlik Sense self-service discovery applications

Responsibilities:

QlikView/Qlik Sense Developer

Worked on requirements gathering, analysis, mapping, design, development, testing, deployment and production support of client’s OnAir dashboards

Analyzed business requirements related to various projects, estimated hours and communicated effectively with management, business users and technical team members

Scoped projects and Completed within fixed period of time accordingly

Trained full stack developers, Senior Executives and end users on QlikView and Qlik Sense software

Involved in the maintenance and support of QlikView applications

Supported and made enhancements to the client’s existing Neo Financial Reporting, Post Air, Market Place Analytics, Market Place Audit Report apps

Participated in Code and Data Model reviews during daily scrum and weekly BI team meetings

Worked on migrating QlikView apps from Actian (Vector), Discovery(Matrix) to Cloud (Amazon Redshift)

Created Active Directory Groups, Controlled user access to various applications using QMC

Environment: QlikView 12, SQL Server 2003/2008 R2, Oracle 12g, Access, .CSV Files, Excel, Windows 2008 Server, Db Visualizer, Qlik Sense Desktop 3.1 SR4, Qlik Sense Hub 3.1, Tableau 9.2, Actian(Vector), Discovery(Matrix), Amazon Redshift

Client: Polycom, Inc., San Jose, CA Jul’15- Aug’16

During this assignment:

Developed a dashboard named “Polycom Global Services Utilization” (PGS) to track and monitor Polycom and its subsidiaries’ work force utilization globally

Developed a dashboard named “PM Revenue Reports” to track the revenue numbers for Polycom Professional Services teams across the globe (NALA, APAC, and EMEA)

Developed a dashboard named “Service Request Dashboard/CCA” to track the flow of service requests/ tickets from PGS to Engineering

Responsibilities:

QlikView/Qlik Sense DW Lead/Sr. Developer

Worked on the analysis, design and development of Business Intelligence reports using the QlikView V11

Created new dashboards, and helped in maintenance of the existing dashboards which have been developed over time

Involved in requirement gathering, analysis, design and development of the QlikView applications/dashboards as per user requirement

Involved in day to day meetings with users to gather requirements, security review, analysis of the data and requirement specifications

Mapped data and configured the connections to pull data from different sources to QlikView

Developed Initial load scripts and built the data model as per the requirement

Worked on developing the User Interface, validating the data and scheduling the jobs using the publisher to reload the dashboard for user consumption

Worked on Proof of Concept (POC) of Qlik Sense, also migrated couple of applications to qlik sense

As a lead qlikview developer helped other developers and business users in resolving issues with existing and new applications

Environment: QlikView 11, Qlik Sense 2.2, SQL Server 2003/2008 R2, Siebel (Oracle 11g, Access), .CSV Files, Excel, Jira, Salesforce, NPrinting, Windows 2008 Server, Toad 12.1

Client: Toshiba America Information systems, Irvine, CA Dec’14-Jun’15

This project is mainly to develop an executive dashboard for the CEO of Toshiba America Electronic Component. This dashboard is used as a POC for the client to migrate their existing BO environment reports into QlikView

Responsibilities:

QlikView Expert/Sr. Developer

As the QlikView expert solely responsible for the POC and development of client’s executive dashboard to replace the existing BO report environment

Developed the proof of concept of the client’s executive dashboard.

Worked on the requirement gathering, analysis, design, development, testing, deployment and production support of the client’s executive dashboard

Worked extensively on extracting data from various data sources like QVD files, BODS(Oracle), Excel and CSV File

Worked extensively on Set Analysis to achieve the user time in analysis requirement

Trained other developers and end users on QlikView software

Helped the client’s executive team in decision making of clients QlikView software environment

Involved in the maintenance and support of QlikView server and QlikView applications

Environment: QlikView 11, SQL Server 2003/2008 R2, Oracle 10g/11g, Access, .CSV Files, Excel, Windows 2003 Server, BODS, Toad 10.6

Client: Reliance Steel and Aluminum Co., Cypress, CA Aug’12-Dec’14

QlikView Developer

This project mainly involves developing a new common dashboard to serve all the subsidiaries of the client company to facilitate decision making.

Responsibilities:

Worked on the design and development of Business Intelligence reports using the QlikView V10/V11 dashboard tool in support of the Reliance Business Intelligence initiatives

Developed new dashboards, and to also helped in maintaining the existing dashboards which have been developed over time

Worked extensively on extracting data from various data sources like QVD files, Oracle, Excel, CSV File, MDM and ODS

Worked extensively on Set Analysis, wrote and resolved complex macros issues

Worked on Server and QEMC maintenance. Scheduled jobs for incremental and full loads using publisher

Worked extensively on security

New Common Dashboard: Involved in delivering both company and enterprise focused analytic capabilities in a scaled down and simplified version of the client’s common dashboard.

BI Dashboards Migration to QlikView v11: Migrated all QlikView dashboards successfully to the QlikView Application Version 11 and migrated to new servers

Assisted in the maintenance of existing dashboards in Crystal reports and Business objects area

Environment: QlikView 10/11, SQL Server 2003/2008 R2, Oracle 10g/11g, Access, .CSV Files, Windows 2003 Server, MDM, ODS, Informix

Client: JPMC, NYC, NY

QlikView Developer Sep'10-Jul’12

The primary focus of this project is business enhancement and competitive edge using QlikView to make better business decisions. Client wanted to have Reports in Data Warehousing system for analyzing trends in business and make key strategic decisions (includes product, geographical and time based analysis)

Responsibilities:

Involved in Requirement gathering and designing QlikView applications

Worked on Gathering data from various sources like QVD files, Excel, Oracle, Teradata, Binary QVW, Inline and text files in developing the QlikView Data Models

Developed QlikView Dashboards using Chart Box (Drill Down & Cyclic Grouping), List, Input Field, Table Box, Calendar & Date Island

Developed KPI’s and set analysis applications

Worked on various QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc

Developed User Interactive Sheets and Reports as per the business requirement

Worked on writing SQL Scripts to load the relevant Data in QlikView Applications

Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications

Implemented Security and involved in Deployment of QlikView Applications

Created QVD’s and updated on timely basis as database updates

Worked on Developing ETL Scripts while loading the data, resolving loops and ambiguity joins.

Worked on Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users

Worked on Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.

Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: QlikView 9/10, SQL Server 2005, Oracle 10g, Access, .CSV Files, Windows 2003 Server

Client: Jeffries LLC, Jersey City, NJ May'09- Jul’10

BI Developer (SSIS/SSRS)

Responsibilities:

Involved in SDLC of the project from requirements gathering to system design and database implementation of the project.

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis,

Involved in project planning, scheduling for database module with project managers.

Developed the necessary Stored Procedures and created Views using Joins for robust and fast retrieval of data in SQL Server 2005.

Created and maintained Database Maintenance plans and also created logins, assigned roles and granted permissions to users and groups.

Implemented SSIS Import/Export Wizard, for performing the ETL operations.

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.

Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.

Worked on Enhancing and deploying the SSIS Packages from development server to production server.

Created the reports based on the requirements using SSRS 2005.

Developed reports using SQL Server Reporting Services (SSRS) & Security using LDAP, Active Directory.

Participated in client-server, multi-tier application (Internet/Intranet) development, and enhancement and testing. Resolved all production issues and provided the deliverables at the right time.

Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Worked on automation of maintenance jobs, locks and indexes configurations.

Administered SQL Server security, SQL Server automatic e-mail notification.

Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.

Monitored the system regularly for bottlenecks (CPU, RAM, Disk I/O and Networking).

Ensured developers coordinated their efforts in managing and maintaining different application databases

Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Environment: MS SQL Server 2008/2005, DTS, Windows 2003, SQL Server Management Studio, SSAS SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, OLAP, MDX, ETL, Erwin, MS Visual Source Safe

Client: Dow Agro Sciences, Fresno, CA Apr’08-Aug’09

LIMS/Report Developer Intern

Responsibilities

• Worked on coordinating the needs of functional departments and established priorities for LIMS requirement gathering, system design and implementation

Worked on complex LIMS configuration to meet end user requirements for users

Worked on LIMS documentation and wrote test plans

Developed and configured different reports like ad hoc, tabular and pie charts

Worked on reviewing company documentation to assess the LIMS impact

Trained end users and other LIMS users

Environment: SQL Server 2000, ASP.NET1.1, C#, Microsoft Visio, DTS, Query Analyzer, Crystal Reports, Windows 2000.

Contact this candidate