Candidates About

Akhil T

 

PROFESSIONAL SUMMARY

·         Around 6+ Years of IT experience in Analysis, Design, Development, and Implementation of Business Intelligence applications.

·         Exceptional analytical, troubleshooting and communication skills to communicate with clients to identify key areas where Business Intelligence can solve Business problems by delivering relevant and timely information.

·         Good Experience in developing different analytical applications using QlikView Server, QlikView publisher, and QlikView enterprise.

·         Experience in Qlik families such as QlikView Desktop Client, Qlik Management Console(QMC), QlikView Server and Qlik Sense hub.

·         Experience in Qlik Sense initial setup and end to end development of Qlik Sense applications.

·         Expertise

·         Experience of deploying Qlik Sense Dashboards on the Qlik Sense Server.

·         Experience analytical database design and data modeling skills in Qlik Sense.

·         Experience in designing QlikView documents and layouts to make consistent and professional optimized look to clients.

·         Experience in implementing N-tier architecture (Extracting the data model, Transforming the data model and Application development).

·         Experience in Optimizing QlikView applications at the server level, scripting level, and design level.

·         Experience in Data modeling including Dimensional Data modeling, Star Schema and Snowflake schema, FACT and Dimensions tables, Physical & logical data modeling.

·         Experience with QlikView sheet objects including Multiple Charts Types, Trends, KPI's and Bookmarks.

·         Proficient in creating QV Data Models, QV Objects, Custom Reports and Data Visualizations using different data sources.

·         Worked on Set Analysis for inclusion and exclusion of Dimensions.

·         Experience in implementing Incremental load for the update of QVD's.

·         Efficient in writing complex SQL Queries using Inner, Left, Right, Outer and Cross join.

·         Experience in using NPrinting to generate Reports.

·         Experience in using QlikView Functions (Date and Time, Keep, Join, Mapping & input Fields etc.) Conditional Statements and Variables.

·         Expertise in Agile Software Development Process and techniques.

·         Experience in extracting, transforming and loading data from multiple sources into Qlik Sense applications.

·         Expert in Designing and Developing database applications, Entity Relationship Modelling (ERM), Data export/import, SQL programming &ETL procedures.

·         Experience in Qlik Nprinting Server, Designer and Engine.

·         Experience in optimizing Qlik Sense performance.

·         Good Understanding of Relational and Dimensional Database Concepts.

·         Deployed QVW's on the production Server, created Reloads and Distribution tasks on QlikView Server/publisher.

·         Connected to different ODBC, OLE DB data sources to create and schedule different complex Reports as per given the client requirements by using the basic components of Qlik Sense.

·         Experience in generating static reports using Qlik Nprinting.

·         Created PL/SQL module which was used to integrate the existing data from third parties on to the database

·         Communicated with clients to gather data and constructed data sources using ETL/SSIS.

·         Experience in RDBMS concepts like User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.

 

 

 

 

PROFESSIONAL EXPERIENCE 

BI Developer, DEUTSCHE BANK, CARY, NC                                                                           JAN 2017 – MAY2018

RESPONSIBILITIES:

·         Collaborated with Business Analysts to know the requirements for Application Development.

·         Worked on a large scale and data volume based applications.

·         Worked on SQL scripts to load the data into QlikView applications.

·         Worked on migrating applications from QlikView to Qlik Sense and took part in resolving critical compatibility issues during migration.

·         Worked on optimizing QlikView performance.

·         Responsible for gathering requirements, business, and technical rules, implementing QlikView and Qlik Sense applications.

·         Implemented Incremental load & Binary loads to optimize the Reports and for performance tuning.

·         Loaded the data from multiple data sources to build the consolidated Dashboards.

·         Distributed the Workload across multiple-threaded engines using Nprinting.

·         Worked on various QlikView functions to generate different kinds of visualizations.

·         Suggested a better way to represent the charts by understanding the user requirements, which are successfully implemented in the Dashboards.

·         Worked with Nprinting apps and organized various entities.

·         Developed QlikView Dashboards using Hierarchic groups (drill-down) & Non-hierarchic groups (cyclic grouping).

·         Wrote scripts to obtain the Information such as Date, Year, Month & Quarter from existing data.

·         Extensively worked on functions like Lookup & Apply map for Data connectivity.

·         Reviewed QlikView error logs and provided production support.

·         Extensively Worked with Qlik Nprinting Server, Designer and Engine.

·         Worked on NPrinting Tool and customized Reports as per the client requirements using the NPrinting reporting features.

·         Implemented security for the Reports based on the responsibility hierarchy.

·         Worked with Qlik Sense upgrade at the lab environment.

·         Generated various kinds of reports using Qlik Nprinting.

·         Used various visualizations like distribution plot, histogram, and Boxplot in QlikView.

·         Worked on Data Modelling and built QVD's as per business requirement and Optimizing applications by using QVDs, removed synthetic keys and circular loops.

·         Worked on deploying Qlik Sense Dashboards on the Qlik Sense Server.

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

ENVIRONMENT: Qlik Sense 3.1/3.0, QlikView 12, Qlik publisher, NPrinting 17, QMC, SQL Server.

 

QlikView / Qlik Sense Developer, TRANSAMERICA, CEDAR RAPIDS, IA                       JUL 2015 – NOV 2016    

RESPONSIBILITIES:

·         Worked with Business Intelligence team to learn about ongoing practices and processes.

·         Developed Reports & Interactive sheets as per the requirement of the clients.

·         Developed Dashboards using QlikView to monitor insurance and policy information.

·         Used various types of sheet objects for Dashboard creation.

·         Worked on various visualizations in Qlik Sense.

·         Generated reports using Nprinting.

·         Worked on Qlik Sense Dashboards using Qlik Sense extension objects and mashups.

·         Worked on QlikView and SAP database connection to extract the data and store it into QVD'S for best   optimization practices.

·         Worked on converting QlikView applications to Qlik Sense.

·         Created custom schedules for reports using Qlik Nprinting Newsstand.

·         Developed Qlik Sense applications using various extensions.

·         Created Static reports using QlikView Nprinting tool.

·         Extensively worked with Variables and Aggregate functions.

·         Worked with Qlik Nprinting Server, Designer and Engine.

·         Experience in use of Set Analysis for data comparison.

·         Developed complex Dashboards using KPI's, Filters, Variables and Prompts as per the client requirements.

·         Implemented multiple tiers of QVD architecture depending upon the complexity of the applications.

·         Implemented triggers to provide custom functionality in Dashboards.

·         Created event trigger and field event triggers and implemented Incremental reload.

·         Scheduled the Reloads as per demand and published Reports on the access point.

·         Involved in performance tuning & deployment of applications in QlikView environment.

·         Used Qlik Sense story telling module in presentations.

·         Maintained the sheet security & controlled the sheets.

ENVIRONMENT: QlikView-11.2, Qlik Sense 2.2/2.0, NPrinting 16, QlikView Server/Publisher (QMC), SQL Server.

 

QlikView Developer, HCA, NASHVILLE, TN                                                                   APR 2014 – JUN 2015

RESPONSIBILITIES:

·         Used QlikView to develop Dashboards supporting the tracking and performance of patient and physician progress with new pharmaceutical treatments, showed daily feedback into functional and exciting visualizations.

·         Used various charts for data representation and creation of Dashboards.

·         Worked on QlikView Server and Publisher for user access management and to schedule refreshing of documents.

·         Worked on the design and delivery of complex Dashboards. Created Dashboards style of Reports using various components of QlikView like List Box, Slider, Buttons, and Bookmarks making Reports more user-friendly for analysis purposes.

·         Worked on scripts that made use of Variables and assigned data values to them & used them in various QlikView sheet objects Extensively worked on various functions like Above, Below, Pick, Peek & Previous.

·         Implemented schemas like and Star and Snowflake.

·         Worked on creating multilayer QVW applications.

·         Worked on comparative analysis for comparison of the data.

·         Identified Facts and Dimensions in relation to design Specifications.

·         Improved load time using Incremental load.

·         Made clients understand the applications by enabling the features which are requested by them.

·         Used different color schemes for charts according to meet requirements.

ENVIRONMENT: QlikView-11.2, SQL Server, QMC.

 

QlikView Developer, JPMORGAN CHASE & CO, WILLMINGTON, DE                      FEB 2013 – MAR 2014

RESPONSIBILITIES:

·         Collaborated with business users and application developers to Identify business needs and provided Solutions.

·         Worked on with Qlik Management Console(QMC).

·         Retrieved external data to QlikView Dashboards in terms of QVD's by making the connection through ODBC and OLEDB.

·         Designed, Built, Tested and Debugged QlikView applications in QlikView test server environment.

·         Analyzed QlikView Data models, Script logics and the ETL business logic for the existing QlikView applications.

·         Distributed and scheduled tasks for reloading using QlikView Management Console.

·         Eliminated synthetic keys and ambiguous relationships.

·         Extensively worked on advanced aggregation functions.

·         Experience in using Set Analysis on the front end to control the display of the data.

·         Developed macros, Set Analysis and section access to provide functionality in QlikView applications.

·         Built complex data into easily understandable for analyzing operations data by creating informative Dashboards reflecting data in different graphical interpretation with charts and table.

·         Worked on the deployment of QlikView applications in the production.

ENVIRONMENT: QlikView-11.2, QlikView Server/Publisher (QMC), SQL Server 2008 R2 Enterprise.

EDUCATION

University of Illinois, Master of Computer Science                                                                                      Aug 2016 – Dec 2017

Osmania University, B.E Computer Science                                                                                                  Aug 2008 – Apr 2012