N Chirenjeevi

Andhra University

Master of Computer Applications · Computer Applications

N/A – Present

Junaati Technologies

Senior Consultant

August 1, 2024 – Present

India

INFOVILLE SOLUTIONS INDIA PVT LTD

Consultant

September 1, 2018 – July 1, 2024

India

Syngenta

August 1, 2024 – June 1, 2026

Syngenta AG is a global company agribusiness that produces agrochemicals and seeds. As a biotechnology company, it conducts genomic research. It was formed in 2000 by the merger of Novartis Agribusiness and Zeneca Agrochemicals. As of 2014 Syngenta is the world’s largest crop chemical producer, as of 2009 it ranked third in seeds and biotechnology sales. Roles and Responsibilities: Understanding source systems and customer requirements. Developed Linked Tables, Concatenation and solve the loops issues. Developed Qliksense Dashboards using various Qliksense objects like Charts, List Box, Input Field, Table Box, Master Calendar and Date Island applications. Strong knowledge on Bar chart, Pie chart, Gauge chart, correct Line chart, Pivot tables, Scatter charts and Funnel Chart for different business scenarios. Applied Set Analysis and Joins to meet the business requirements. Duties include enhancement of existing Reports to meet business requirements. Involved in Database Extraction using Qliksense and storing them in QVD. Handle prioritization, distribution and management of customer issues.

Proctor & Gamble

October 1, 2022 – July 1, 2024

Proctor & Gamble is Retail & manufacturing company which offers Baby Care, Beauty Care, Blades & Razors, Fabric & Home Care, Family Care, Feminine Care, Gillette HairCare, Health Care, Home Care, Oral Care, Snacks & Coffee products. P&G has various plants in various countries among them Belleville is one of the biggest plant. Roles and Responsibilities: Understand the requirements from Client and develop Qlik Sense Dashboards. To create reload tasks, add users to streams, providing access permissions, defining security rules, publish and duplicate dashboards to different streams. Created Dashboards with different objects like KPI, Trend, Pie, filter pane, Line, Table, Combo, etc. Sent Adhoc reports to the users. Involved in Daily Scrum Meetings. Create different types of charts for Qliksense Dashboard Analysis. Implementing set analysis in Qliksense. Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client’s current standards and processes. Creating and maintain technical design documentation. Extracting, transforming and loading data from multiple sources into Qlik applications. Worked on migrating reports from QV to QS, BO to QS and BW to QS (Manually). After migration completed then sending reports through mail by using NPrinting.

Hanover Insurance

August 1, 2020 – September 1, 2022

The Hanover Insurance Group, Inc. is the holding company for a group of insurers. The company is ranked among the top 25 properties 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. Roles and Responsibilities: Extracted data from Oracle Databases, MS Excel and load data into QVDs. Developed QlikView Dashboards using various QlikView objects like Charts, List box, Input Field, Table Box, Calendar, bookmarks. Hands on experience in removing of synthetic keys and circular loops. Created Dashboards using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks. Worked with Variables, Set Analysis, Aggregate functions and Mapping Functions. Worked with joins, concatenations cross tables and linking tables for different sheets. Worked on Incremental Loading to reduce the reload time of different application. Created Dashboard using different components of QlikView like List boxes, Multi boxes, slider, and buttons, charts (Bar, Line, Combo, Gauge, Scatter, and Straight/Pivot table). Stunning dashboard and forecasting reports for yearly basis and monthly basis. Create different types of charts for Qliksense Dashboard Analysis. Understand the requirements from Client and develop Qlik Sense Dashboards. To create reload tasks, add users to streams, providing access permissions, defining security rules, publish and duplicate dashboards to different streams. Created Dashboards with different objects like KPI, Trend, Pie, filter pane, Line, Table, Combo, etc. Extracting, transforming and loading data from multiple sources into Qlik applications.

ABInBev

September 1, 2018 – August 1, 2020

ABInBev (Anheuser-Busch InBev) is a multinational beverage and brewing company with global headquarters in Leuven, Belgium. The company was enlarged in October 2016 when AB InBev purchased SABMiller and concluded a merger of the two entities. It was the world's largest brewer even before the acquisition of SABMiller and is considered one of the largest Fast-Moving Consumer Goods (FMCG) companies in the world. Roles & Responsibilities: Generated reports, dashboards using Qlik. Written complex expressions using Set analysis and various QlikView/Qlik Sense functions. Designed and developed dashboards with various levels of complexity including different kind of objects. Created Dashboards using different components of QlikView like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table). Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher. Experience with QlikView/Qliksense sheet objects including multiple charts types, Trends, KPI's, custom requests for Excel Export, HTML, and Fast Change and objects for Management Dashboard reporting. Worked with joins, concatenations, cross tables and linking tables for different sheets. Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field. Creating QlikView/Qliksense applications for analysis reports from multiple data source. Implemented tasks to schedule QVD generation and Dashboard refreshes at regular intervals and appropriate dependencies. Generate QlikView reports to analyze data from multiple data sources like Oracle, SQL Server, Access, Excel, Flat Files, etc. Involved in Extracting, Transforming and Loading data from different data source. Worked on Incremental load, SET Analysis, section access. Developed reports using charts and reports as per the customer requirement depends on Quarter, monthly and analyzes the report with charts provided by QlikView. Used advanced scripting, advanced aggregation functions and advanced charts for applications. Assist in resolving the issues/cases raised by the users for this application. Worked on writing complex SQL Scripts to load Data in QlikView Applications. Mapping source system data using data modeling. Created data model & applied the transformations as per the requirement.