Sumanth Nunna Venkata
Lead Consultant
Hyderabad
Summary
- Having 4.5 + years of IT experience in Analysis, Design,Development and Implementation of Database/BI applications in Qlik View and Qlik Sense and Power BI.
- Sound Knowledge of the entire SDLC lifecycle – right from Requirements gathering , Analysis, Design, Development ,Unit Testing ,QA Testing ,UAT, Prod Deployment ,Bug Tracking ,Change and Version Management .
- Implementation of BI applications using Qlikview, Qliksense and Power bi and also involved in Requirement gathering & designing Qlik Applications and Power bi Applications.
- Well versed with Qlik View/Qlik Sense reporting using N Printing and also created apps and connecting in N Printing from Qlik Sense and Qlik View.Developed different static reports in N Printing like Excel , Pixel Perferct ,PPT and CSV reports.
- Delivered N Printing reports to the user through Email,Folder locaation,Newstand and Qlik Sense Hub.
- Scheduled Data Extractions , Data Model and Dashboard reloads using Qlik Management Console (QMC)
- Implemented all levels of security at data level , sheet level and row level.
- Extracting the data from various data sources into Power BI desktop
and transforming the data in Power Query Editor and to generate Reports and Dashboards. - Worked on DAX expressions like Time intelligence functions (YTD,
MTD, QTD …,). - Providing security by using Row Level Security (RLS) implementation.
Well knowledge on Power BI licenses Power BI Pro, Power BI Premium
and Gateway types - Strong Experience in Performance optimization,Improved the existing application performance by using best practices.
- Good Experienced in concepts of Business Intelligence and Data warehousing.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Work History
Lead Consultant
Genpact
6 2021 - Current
Project Description:
Client : Danone Domain : FMCG BI Tools : QlikSense, Power BI
Danone is a French multinational food-products corporation based in Paris. It is dedicated to bringing health through food to as many people as possible, we are a leading global food & beverage company built on four businesses: Essential Dairy and Plant-Based Products, Waters, Early Life Nutrition and Medical Nutrition.
Roles :
- Developed interactive Dashboards for Danone based on water, Dairy and Plant-Based Products.
- Also we created different KPI's which depicts the various Markets ,Order status, Order Quantity , CFR (Customer Fill rate) and Truck fill rate.
- Extracted the data from Snowflake, transformed and integrated in the QlikSense.
- Extensively used set Analysis to calculate / Aggregate the fact table as per the requirement.
- Prepared documentation for easy to understand the QlikSense Functionalities.
- Delivered N Printing reports to the user through Email,Folder location, Newsstand and QlikSense Hub.
Project Description:
Client : Chubb Domain : Insurance BI Tools : QlikSense
Chubb is a global provider of insurance products covering property and casualty, accident and health, reinsurance, and life insurance and is the largest publicly traded property and casualty insurance company in the world.
Roles :
- Developed interactive Dashboards for Chubb based on reinsurance, Insurance claims data (Property & Causality and Life & Health data)
- Also we created different KPI's which depicts the various policy status, quote status and profitability for each agency level.
- Extracted the data from SQL, transformed and integrated in the QlikSense
- Provided expertise and guidance to clients on complex issues
- Collaborated with stakeholders to identify opportunities for improvement
Qlik Sense Developer
WNS Global Services
02.2020 - 02.2021
Project Description:
Client : Aviva Domain : Insurance BI Tools : QlikSense
Aviva is the largest general insurer and a leading life and pensions provider. Aviva is also the second largest general insurer in Canada.
Roles :
- Developed interactive Dashboards for on reinsurance, Insurance claims data (Property & Causality and Life & Health data).
- Also we created different KPI's which depicts the various different insurances, Claim status, Agents performance and Claim settlements.
- Analyzed data and trends to make informed business decisions
- Responsible for unit testing,UAT and Data validation.
Education
Bachelor of Engineering - B.E
Andhra University
06.2009 - 04.2013
MBA - Finance
Vikrama Simhapuri University
Nellore 04.2001 -
Skills
Qlik View
Accomplishments
- Successfully implemented a Qlik Sense solution for a large manufacturing client , resulting in a 40% reduction in manual reporting time.
- Developed a self- service dashboard for the sales team resulting in a 40% increase in data- driven decision making
Qlik Sense Implementation:
Languages
English
Bilingual or Proficient (C2)
Interests
Reading books , Playing cricket
Strengths
Data Visualization
Passionate about creating visually appealing dashboards to simplify complex data.
Data Analysis
4.5 years of experience in data analysis including data collection, data cleaning , and visualization , resulting in a 25 %increase in efficiency.
Reading
Enjoy Reading, staying updated with the latest trends in data science and software development.
Timeline
Qlik Sense Developer
WNS Global Services
02.2020 - 02.2021
Bachelor of Engineering - B.E
Andhra University
06.2009 - 04.2013
MBA - Finance
Vikrama Simhapuri University
04.2001 -
Lead Consultant
Genpact
6 2021 - Current
Similar Profiles
Zaki Uddin SyedZaki Uddin Syed
ITSM Consultant (IM,PM,CM) at GenpactITSM Consultant (IM,PM,CM) at Genpact
María Fernanda Granados ArroyoMaría Fernanda Granados Arroyo
Customs Process Developer at GenpactCustoms Process Developer at Genpact
S SrinivasS Srinivas
Senior Associate at GenpactSenior Associate at Genpact
Savi JangidSavi Jangid
Management Trainee at GenpactManagement Trainee at Genpact
Mannan LuthraMannan Luthra
Barista Intern at Thunderbolt FoodsBarista Intern at Thunderbolt Foods