ABHAY SINGH
Contact No.: +91-995******* E-Mail: ***********@*****.***
Objective
To obtain a position as a Business Intelligence Consultant in a challenging environment, where I can utilize my Business Intelligence knowledge and experience, to achieve the best possible solution and benefit the organization.
Professional Summary
Over 5+ years of professional experience in the field of Business Intelligence and Analysis.
Handling multiple projects as a Technical lead under my supervision.
Knowledge of industry best practices in both business management and technology domains.
Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment.
Experienced in QlikView/Qliksense Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
Worked as a QlikView/Qliksense Technical Consultant for a wide variety of business applications.
Experience in complete project life cycle including documentation, analysis, and development and testing.
Always worked in close association with customers and a single point of contact for many major implementation projects.
IT industry experience in Aviation, Retail, Paints, Travel, Liquor, Food Safety, Financial and Manufacturing, with Functional knowledge in daily operation of these industries.
Knowledge of ETL, RDBMS, Developing Dashboards, Data Models optimization, Set Analysis, N-Printing reporting, Creating Charts, Reports and Deliver them to Executive level etc.
Technical Skill Set
Dash boarding/Analytics: QlikView, Qlik NPrinting, Qliksense.
Languages : C, SQL
Database Technologies: SAP, SQL Server, MySQL.
Platforms: Windows Server 2008/2012 R2, Linux.
Others: MS Access, MS-Excel.
Skills
Prefer to work as pro-active person and like to help other employees as much as possible.
Considerable Reporting and Dash Boarding (UI/UX Design) experience.
Participating in pre-sales activity working with prospective client and assisting with technical contributions to help my employer win new business.
Self-starter & Team Player with pleasing personality.
Adapt to learn new technology and inclined to fast changing Mobile applications.
Deeply involved in developing logic to solve complex industry problems.
Education
Bachelor’s Degree in Engineering, VITS UPTU Lucknow, India, pass-out 2011.
PGDM in Embedded System Design from ICIT, Pune University
Certified Qliksense System Admin v2 and Qliksense Business Analyst v3.
Professional Experience
Qlik Consultant – HCL Technologies (Aug 2017 – Present)
Working on HCL In-house Digital Analytics Project having 10 Modules in single integrated platform called HCL LiVE.
Business Intelligence Qlik Consultant – Team computers Pvt ltd (April 2015 – Aug 2017)
Client : Wipro infotech (Dec 2016 to Jan 2017)
Worked at Wipro Infotech for Qliksense NPrinting 17.2.1 for Report Designing and Distribution of the reports.
Client: NBC Bearings Jaipur, India leading into Bearings Production worldwide (Jan 2016 to Nov 2016)
This QlikSense Project is for Digitization, to exclude Complex Manual Reporting, which includes Complex reports like Production Evaluation, P&L, Raw Material Ageing, Vendor Ageing, AR, AP etc
Leading team of 2 onshore Members.
Worked with 16 core processor with two 125GB RAM server.
Was actively in the Server migration and the Fresh QlikView/Qliksense Installation process.
Worked with Best Data Modeling Practices, Scripting and Designing using Advance expression like Set Analysis etc.
Multiple tier of QVD architecture is implemented depending upon the complexity of the application.
The application is used by Top Management and Business User
Task set up are done using QMC and created architecture for the interdependent applications and execute in proper order.
Did the SAP Connector configuration for extraction of Data from SAP through Qlikview
Worked with Optimization technique to improve the performance of the Dashboard, Data Libraries and Reports.
Worked with end user for User Acceptance Testing.
Handling Qlikview 11.2 for Development and Qliksense 3.0 at Production to show the Dashboard’s.
Business Intelligence Consultant – Qliksense (Sep 2015 to Mar 2016)
Client : Hawk Safety, United Kingdom
Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
Leading Single Handed End to End Development and Deployment
Extracted data from cross table flat files and MY SQL.
Created Dashboard with using Extension to achieve Customer Requirement. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
Worked with 12 core processor with 150 GB RAM server, having daily refresh. 3-tier QVD architecture is implemented and the final application is taking 5 Minutes to reload.
The application is used by 10 Named CAL licensed user.
Created Document for the project planning and production Interface Documentation.
Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
Qlikview Developer / Admin, (1st Sep 2015 to 20th Sep 2015)
Did Server Migration from UAT and Production server to another UAT and Production server
N-Printing Reports Creation and Distribution.
Business Intelligence Consultant -Qliksense (July 2015 - Aug 2015)
Client :Brindco Sales Ltd is the leading Liquor Distributor.
Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.
Dashboards included Finance Kockpit and Business Kockpit.
Maintained Server for smooth Qliksense development. Checked and updated environmental file, assigned task.
Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
Fetch Data from Multiple Data Source and build the Consolidated Dashboards.
Extensively worked with Set Analysis.
Helped end users to design test cases and worked through multiple UAT cycles.
Worked with Qliksense 2.0, SQL Server, Excel, flat files.
Previous Employer
Qlikview Developer – Nine A Business Connect Pvt Ltd (April 2014 – April 2015)
Client :Thomas Cook India Ltd (Jan 2015 to April 2015)
To configure SAP Connector on Server and Transport file, Roles and Authorization at SAP end.
To Make Database Connection between Qlikview and SAP, extract data from it and store it into QVD’s with 3- tier Architecture followed with best optimization Practices.
Requirement Gathering and Data Modeling/Scripting and Validations, Designing Dashboard, Reports etc.
Designed Airline Inventory Dashboard
Qlikview Developer
Client: Shalimar Paints (April 2014 to Jan 2015)
Handle Sales vertical in which my responsibilities was to collect the requirements from business users and accordingly developed the logics.
Did Database connection with multiple Data sources like SAP, MS SQL Server and MS Excel
Good experience with knowledge of scripting, data source integration and GUI development in Qlikview.
Data modeling and Creating/Designing Dashboards etc.
Worked on Google Map, Incremental load, Adhoc Reporting, Section Access.
Worked on OFFLINE DESKTOP VERSION for Qlikview and I-Pad Version.
Knowledge of assigning CAL’s and QlikView Management Console (QMC).
Did up-gradation part like SAP connector SR Versions, Qlikveiw and Server 2012.
ACHIEVEMENT’S
Awarded by CIO of Client Shalimar Paints ltd.
PERSONAL DOSSIER
Date of Birth : 04th February 1990
Marital Status : Married
Permanent Address : R-4 Sector-12, Vakil colony Pratap Vihar, Ghaziabad (U.P).
Date:
Place: (ABHAY SINGH)