Data Sql Server

Prithvi K

Email: *****@*******.*** Phone:508-***-****

PROFESSIONAL SUMMARY

* ***** ** ** ************* proficiency in Data Warehousing, Data marts, ETL, Data Integration, Data Analytics, Business Intelligence across Technology, Supply chain & Logistics, Pharmaceutical, Healthcare, Insurance, Retail domains.

5+ years strong hands on experience in Designing, Developing, Deploying, and Publishing analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).

Expertise in creating Designs using QlikView 11/10/9 and Qlik Sense 2.0 using data sources like SAP BW, Oracle, SQL Server, Teradata, QVD files, text files, Excel, Access to generated dashboard as per the business needs.

Experience in different kinds of data sources and experienced in all kinds of loads in QlikView it is a data con

Strong Experience in VISUAL BASIC 6, created macros.

Over 6 Months of Proficient experience in Creating Dashboards in QlikSense, Migrating Dashboards from QlikView and worked extensively on JavaScript.

Strong understanding on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema), multiple fact tables and Kimball/Inmon methodologies.

Extensive experience in Data Analysis, including profiling, cleansing, transforming and confirming.

Experience in creating Complex Data Models, Performance Tuning with best practices for QlikView Applications.

Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up, & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.

Good Exposure to working with QlikView Functions and Expression Scripts and streamlining reporting operations of QlikView Applications.

Strong hands-on experience in Section Access, Set Analysis and Apply Map conceptsin QlikView

Excellent Experience in Qlikview Dashboards using different types of Qlikview Objects including multiple charts types, Trends, QlikMap, Org Chart, Whisker Pie, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and utilizing Set Analysis, Google Maps API, VB Script/ JScript macro modules etc.

Strong Experience in working with Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Line-Charts, Bar-Charts, Trellis)

Extensively used various Qlikview Scripting and UI functions such as aggregations, Sum, rank, rangesum, firstsortedvalue, applymap, match, concatenate, Noconcatenate, numeric and date functions, etc.

Implemented Incremental ETL to handle high, historical and incremental volume of data, resolved Circular Relationships, Synthetic Keys.

Proficient in providing Data Warehousing and Business Intelligence Tool solutions with Qlikview, SSRS, Oracle BIEE (OBIEE).

Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) to Build Application Objects

Strong Experience in Extract, Transform & loading data in QlikView Applications & Develop Data models using Star Schema & Snow Flake Schema's

Co-ordinate system and user Acceptance Testing and performed Data Validation for all the reports and dashboards generated from various database sources.

Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files.

Implementation of security in QlikView Applications at Document and Server Level.

Strong hands-on experience in QlikView Enterprise Management Console (QMC) (QlikView Publisher/Server), Managing licenses & Securities.

Expertise in relational databases such as Oracle 11g/10g/9i, SQL Server 2000/2005, DB2 8.0/7.0

Good knowledge with web analytics applications like Omniture, Google Analytics

Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.

TECHNICAL SKILLS

Analytical/BI tools: QlikView 11.2/11.0/11.1, QlikSense 2.0.6, OBIEE 10g/11g, SSRS, Tableau, NPrinting

Database/Backend: Oracle, SAP BW, SAP HANA, Teradata, MySQL, Teradata, SQL Assistant, Advanced Query Tool, TOAD, SQL Server, PL/SQL, MS Access

Languages:SQL, PL/SQL, VB .NET, Java, Java Script, Shell Scripting, HTML, XML

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Client: KraftHeinz Inc, IL March2016 – Present

Role: Sr.Qlikview Developer

Kraft Heinz Company is the 5thlargest food and beverage company in the world and 3rd largest in North America providing high quality, taste, nutrition, delicious foodsdedicated to the sustainable health of people, our planet and the Company. The Company’s iconic brands include Kraft, Heinz, ABC, Capri Sun, Classico, Jell-O, Kool-Aid, Lunchables, Maxwell House, Ore-Ida, Oscar Mayer, Philadelphia, Planters, Plasmon, Quero, Weight Watchers Smart Ones and Velveeta.

Work closely with stakeholders to gather requirements and convey technical content in easy to understand ways both verbally and in writing - to develop solutions to meet their needs

Develop reports and dashboards against SAP Business Warehouse (BW) data sources, including Business Explorer (BEx) queries.

Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.

Design and Develop Data Model and dashboards using QlikView.

Worked on data acquisition, integration, modeling and delivery for many Qlikview initiatives.

Created and maintained user guides and documentation for QlikView applications.

Develop QlikView Dashboards using Charts, Drill through, Cyclic Groups, List, Input Field, Table Box, List Box, Straight table, Pivot table, Selection box, Container etc.

Advanced scripting and Integrate data from multiple data sources into a QlikView Data Model.

Optimization of a Data Model for performance Publish and distribute dashboards to users.

Implemented different types of data loads in QlikView/Qliksense including Resident load, Binary Load, Incremental Load and Inline Load.

Developing KPIs using SET Analysis to provide load Data in QlikView Applications.

Handled the end-to-end implementation of QlikView /Qliksense dashboard deployment.

Prepared QlikSense proof of concepts as per the requirements and specifications.

Create report in QlikView and used QlikView Publisher and QlikView PDF Distribution to send individual reports to recipients

Created and Scheduled Weekly QlikView reports to distribute on email using NPrinting and publisher

Experience in integration of NPrnting setup with Qlikview reports for creating automated reports, pixel perfect reports

Finding and Understanding the essential data, eliminating the data which doesn't suit the requirement.

Connected to different ODBC, OLE DB data sources (Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.

Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Imported various data sources like QVD files, Excel, Oracle, Binary QVW, Inline & text files in developing the QlikView Data Models

Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields etc)

Promoting dashboards to production environment, Scheduling and Distributing through QMC and manage user access.

Expertise in setting up users and groups and performing Performance tuning for slow running reports.

Developed Linked Tables, Concatenation (Resolving Loops & model ambiguity).

Efficiently used Hierarchy and Interval match for grouping.

Developed Macros, Set Analysis, Section Access to provide custom functionality in QlikView Applications.

Worked on setting up Server, Publisher configurations and Security authorization at different levels.

Worked with OLAP data sources, SAP HANA, non-relational databases (NoSQL)

Worked on Qlikview applications with backend SAP BW, SAP HANA, Oracle, MS Access, Excel, text files

Scheduled the delivery of reports in different formats such as PDF, Excel, to generate all daily, weekly, monthly and quarterly reports

Environment: QlikView 11, SAP BW, SAP HANA,Oracle, Excel, MS Access, Windows

Client: AMPLIFON, Plymouth, MN August 2014 – February 2016

Role: Sr.Qlikview Developer

Amplifon S.p.A., the worldwide leader in the hearing health care industry for over 65 years. Amplifon USA supports the global mission to help people with hearing problems rediscover what it means to live life to its fullest through solutions based on individual needs and that guarantee complete satisfaction.

Responsibilities:

Gathering, understanding client requirement, develop and Design QlikView Reports

Created User Manual, Technical Documentation & Expression Documentation.

Implemented Direct Discovery Feature extensively in order to fetch data from a huge fact table that consists of users account information.

Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, Containers, Calendar object, Fast Change objects etc.

Wrote several macros for the dynamic construction of Multi Box based on the user selections, for triggering External Web services using SOAP request, exporting data to excel etc.

Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.

Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI

Developed QlikView applications based on Incrementally Load Transactions using QVD files.

Created Variables to select date ranges as Calendar objects.

Created QVD's from different types of Source Databases (Oracle, Excel Files)

Used SET Analysis and Aggregate functions to look back time horizonand get the required information.

Developed QlikView Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Button Objects, Input Field, Table Box, Statistics Box etc.

Implemented various levels of security through Qlikview Scripting, Section Access, Document/ Sheet level Security.

Resolved synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.

Designed QlikView Dashboards using different types of Objects.

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

Created PDF reports using RTF templates in BI Publisher

Used different types of joins to join Data from different types of tables.

Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

Integrated Qlikview with Web Analytics tools such as Omniture and Piwik.

Connected to various data sources like Oracle, SAPBW and flat files to create and schedule different complex reports.

Developed different KPI’s as per requirement using advanced set analysis.

Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

Automated and scheduled daily data loads of QVW documents using QlikView Publisher.

Manage Schedule QlikView applications using QlikView Enterprise Management Console (QMC).

Environment: QlikView 11, Teradata, Web services, Oracle, Excel, Salesforce, SAP

Client: Hanover Insurance Group Inc., Worcester, MA July 2012 – August 2014

Role: Qlikview Developer

The Hanover Insurance Group, Inc. is the holding company for a group of insurers. The company is ranked among the top 25 property and casualty insurers in the country. Scope of this project is to build the dashboards for Business Intelligence team to help analyze the claims with Hanover Insurance Group Inc.

Responsibilities:

Actively participated in requirement gathering working closely with business users and stakeholders.

Involved in Design, Development, System Integration Testing, User Acceptance Testing of dashboards and moved them to production environment.

Adapted Kimball’s approach for building data marts.

Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server,Oracle,Informatica, binary QVW, Inline & txt files in creating the QlikView dashboards.

Used various QlikView Functions in building the script (Date and Time functions, Mapping, String functions)

Extensively worked with QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikView applications.

Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.

Worked with QlikView administrator to optimize QlikView performance.

Implemented Star & snowflake schema (confirmed dimensions). Writing SQL Scripts to load the relevant Data in QlikView Applications.

Developed report using Chart, Table Box, List Box and Button Objects.

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

Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users.

Published QlikView applications on the server and scheduled jobs in QlikView Publisher for reloading data and distribution of applications.

Designed QVWs to generate QVDs for faster and efficient data reloads.

QlikView-BW Integration: Connected QlikView to SAP BW DSO Data.

Closely worked with the release management team to facilitate smooth deployments of QlikView documents in addition also helped with database administration and development.

Migrated existing QlikView 10 dashboards to QlikView 11 environment, also added new QV11 features to the Dashboards.

Worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.

Environment: QlikView11, QlikView Informatica Connector,Oracle 10g,DB2, MS SQL Server 2008, Toad, Informatica 9.0.,Windows 2008 R2,Excel,MS Access, SAP

Client: TIAA-CREF/TAPFIN, Charlotte, NC January 2011 - June 2012

Role: BI Consultant/Qlikview Developer

TAPFIN program at TIAA-CREF, managed by TAPFIN Process Solutions, a Manpower Company. Econometrix, a 100% web-based solution, is designed to acquire contingent staff, approve timesheets, perform contractor evaluations, extend contractors, and generate reports on your contingent labor.

Responsibilities:

Created Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community

Created Variables to select date ranges as Calendar objects are not user friendly on IPad

Built QVD’s from SQL Server Database, Stored procedures and Excel files

Designed UI based on the Business requirements

Developed QVD scripts to load history and current data using Incremental logic

Used Store function to store QlikView Data into CSV files to create other reports

Created PDF reports and scheduled to generate PDF’s every week

Installed and configured QlikView 11 SR2.

Worked with cross functional team and business user to develop Business requirement document(BRD), define key performance indicators(KPI’s) and identify data sources

Used Section access and Sheet access to make the application available to desired users

Used SET Analysis and Aggregate functions to look back 30 days or 60 days and get the required information.

Excel dashboard KPI formulae's were converted and replicated in the QlikView dashboard that involved complex modeling techniques.

Performed different tasks like extraction, reload tasks, distribution tasks, reduction, deploying apps, scheduling, User management, license management, Clustering and licensing using QMC.

Deployed the QlikView applications in the server. Created Publisher Tasks in QMC for the QlikView Application to Reload and Distribute the QlikView Application on to the Access Point.

Responsible for Performance tuning of reports.

Assisted in demoing QlikView application to users and gather feedback at every phase

Communicating with the Users to evaluate satisfaction and Identifying needs

Took part in designing a User document for Business Analysts

Environment: QlikView 11, Set Analysis, SQL server, Excel

Client: MPHASIS LIMITED, Mangalore, India November2009 - December 2010

Role: SQL Developer

Mphasis is a leading IT solutions provider, offering Applications, Business Process Outsourcing (BPO) and Infrastructure services globally through a combination of technology knowhow, domain and process expertise.

Responsibilities:-

Involved in managing security for users by creating logins.

Tuned quires, T-SQL stored procedures to enhance the performance of applications.

Created database objects like tables, views, indexes etc.

Created and modified stored-procedures, triggers, cursors, and views.

Installed and configured SQL server 2000 and development software.

Created non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.

Maintained and monitored SQL Server 2000 regularly to ensure uninterrupted operations

Managed logins and users, including permissions and restrictions, for MS SQL Server

Used Performance Monitor and SQL Profiler to enhance database performance

Generated SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences and synonyms.

Wrote T-SQL code for creating cursor and handling the data validations.

Environment:SQL Server 2005/2000, Business Intelligence Development Studio (BIDS), SQL Server Management Studio, SIS, T-SQL, SQL Profiler.

Client:Proxim Wireless, India July 2007 – November 2009

Role: SQL Developer

Proxim is a leading company providing advanced high-speed Internet and Entertainment services to consumers and businesses nationwide in offering 4G mobile Internet wireless network (WiMax) with high speed and mobility. The project aimed to develop Intranet Application by gathering and synthesizing data into a single centralized database.

Responsibilities:

Involved in analysis, design and development of the system.

Promote emphasis on tools and process to facilitate analytics

Created database Objects Tables, Indexes, Views, Synonyms

Used SQL Developer to Load / Extract data into and from Excel files.

Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.

Used Hints, Explain Plan, and Indexes for query tuning and optimizations.

Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.

Created stored Procedures, Functions, and Triggers by generating the specified reports.

Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.

Tuning of the SQL queries using Explain Plan, SQL*Trace.

Handled unit and system integration testing

Created the database from full export for the Table space point in time recovery.

Prepared a help guide to system usage for the convenience of end users.

Environment: Oracle, SQL Server, Putty, SQL/PLSQL and Windows 2000.

Contact this candidate