Felix Stany G

• Having 13+ years of experience, out of that I have 8+years of experience in NON-IT and 4+ years of IT experience, with diversified fields of Analysis,Design, Development and Maintenance of Qlik View and Qlik Sense applications.
• Developed QlikView Dashboards using different charts (drill-down, cyclic grouping), list boxes and other QlikView components.
• Experience in using QlikView functions (date & time, keep, join and string functions).
• Used Set Analysis to provide custom functionality to QlikView dashboards. Implementation of Incremental load to populate the real time data.
• Hands on retrieval of external data (Shared Path, Network drive, Oracle etc.) to QlikView Dashboard in terms of QVDs by making connection through ODBC and OLEDB.
• Good experience in creating dashboards with optimization techniques.

Client : Novartis

Environment: QlikSense

Role : Developer

Description:

Novartis AG is a Swiss multinational pharmaceutical corporation based in Basel, Switzerland and Cambridge, Massachusetts, United States (global research). Consistently ranked in the global top five, Novartis is one of the largest pharmaceutical companies in the world and was the fourth largest by revenue in 2022. In this project my responsibility was to gather requirements from Data science team and stakeholder, fetch data from database and share drive to implement in the qliksense application with better data visualization.

Roles and Responsibilities:

• Understanding the requirements of the client, Data science team and the functional specification.
• Used Qliksense to develop and design dashboards.
• Worked on managing the applications in Qliksense and Report Design.
• Worked on validating/Testing the Qlikapp as per the requirements.
• Worked closely with data science team and database team to provide inputs for snowflake connection.
• Assisted in testing and giving access to application after migration.
• Make changes in the Front End Designing as per the Client’s Requirement.
• Publishing Qliksense applications on server.
• Pricing excellence walkthrough for Poland, Italy Bio and Italy Non-Bio dashboard.
• Worked on Poland, Italy Bio and Italy Non-Bio dashboard under Pricing excellence team.
• Worked on US KAM dashboard under SFE team.

Project : Indian Oil Corporation Limited.

Client : IOCL

Environment: QlikSense

Role : Design and Development

Description:

IOCL-Indian Oil Corporation is one of the largest leading oil and gas company in India. It is having nearly 25000 Ros in India currently. As part of technology partner, it is our (wipro) responsibility to deliver and help their business development and in assisting the Quality standards and Quality Checks. We also provide the different analytics to IOCL as part of technology partner like wet stock Analytics, sales Dashboards, Health of Automation data checks, Q&Q Dashboards and reports, customer survey, and feedback analysis. As part of BI team, it’s our responsibility to gather requirements, fetch data from IOCL systems and create a DWH for Analytics purpose.

Roles and Responsibilities:

• Analysis of business requirements, documents, design, and functional specification.
• Used Qliksense to develop and design dashboards.
• Developed ad-hoc reports on demand whenever client/end users needed.
• Worked on creating tasks, splitting tasks in QMC, and scheduling them as per the requirement.
• Worked on managing the applications in Qliksense, Report Design, Dashboard Design and involved in server capacity checks with Qlik team.
• Worked on troubleshooting the existing apps to resolve the issue.
• Worked on performance tuning of apps.
• Educated the users to navigate and access the Qlikapp.
• Participated in UAT testing and given support to the users/clients.
• Fixing of bugs during UAT testing and production bug fixes after deployment.
• Worked on validating/Testing the Qlikapp as per the requirements.

Client: HP

BI Tool: QlikView, Qlik Sense

Role: Developer

Description:

HP provides products, technologies, software, solutions and services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors.HP is a technology company that operates in more than 170 countries around the world.EWS (Enterprise workflow Services) has different kind of products and each product has different customers. This project involves improving the accuracy and granularity of the products and customer

information to have better execution control over the product. For this purpose various kinds of dashboards are generated on the basis of types of product, region, and customer wise sales in order to provide more flexible analysis.

Roles and Responsibilities:

• Understanding the requirements of the client, business scenario(s) and the application and prepare the design documents.
• Design various reports like Tables, Charts, Pivot tables and Narrative views and publish them in dashboard.
• Creating different type of KPIs as per business requirement.
• Involved in Dashboard development and Unit testing.
• Assisted in testing and giving access to application after migration.
• Implemented prompts to provide dynamic filter condition to end users.
• Provided object level security for different web groups based on responsibilities.

Client: MRF

Role: QlikView Developer

Description:

MRF holds the No.1 position for the last 21years. Established as toy-balloon manufacturing company in 1946 by KM MammenMappillai, MRF quickly emerged as the leading maker of tread rubber. Since then, the company hasn’t looked back. The fact that it is the first tyre company in India to reach a turnover of 5000 crores is testament to its dominance of the industry. This project based on sales originating from various subsidiaries based in India the reporting system provides executives, senior managers and business analysts with access to accurate, consolidated information.

Roles and Responsibilities:

• Involving created modelling and dashboard creation using different type of functionalities.
• Developed different type of charts.
• Working on existing dashboards based on client specification.
• Implementation star schema & snow flake for dimensional data modelling in QlikView.
• Created user interface reports using QlikView sheets objects like list box, Input Box, Buttons, Text Input, slider
• Bookmarks, Charts(Pivot/straight tables, Pie, Bar, line etc)
• Created QVDs and developed Dashboard style of reports as per business needs.
• Developed extensively Variables, Input boxes, Triggers.
• Created Set Analysis for Comparison analysis eliminating additional complex coding.
• Gathered and loaded data into QlikView from various source of data like SAP and excel files.
• Maintained log file and Data Level Security and implemented Data Reduction.
• Used to train and solve the issues related to the end users.
• Involved in Performance Tuning and Deployment of QlikView Applications.