Giri Mallena

Orama-Interactive insights is a dedicated Business Intelligence Visualization platform for Cyber security Technology & Control (CTC) Line of Business (LOB) Unit ,which serves as single point of entry to all CTC apps/dashboards which allows to enhance service offering of user centric solutions which support decision making

Roles/Responsibilities:

• Collaborated with functional heads to identify Oppurtunities for operational improvement and strategic decisions in respective functions based on data
• Defined and tracked key performance indicators for existing and new functions/projects across the Line of Business
• Data Interpretations to draw Conclusions to improve strategies and operations and Remediate risks
• Improved data accuracy ,visibility and value by improving the stream lining process regarding data flow and data quality.

Parts Net project is aimed to automate many existing reports and also build new one’s using BI tools like Qlik and tableau using SQL and other technologies for handling data. Almost 40 dashboards were built by gathering requirements from various teams across Penske analytics and performed testing to ensure accuracy. The overall business impact was around $4 Million and Productivity was of $500k. The 4 member team had won Global award for the delivery & service excellence in town hall meeting.

Roles/Responsibilities:

• Working with Business Users across various domains to understand the ways behind data preparations.
• Working on SQL and QlikView extracts to gather and transform data .
• Working on three tier architecture of Qlik(Extract, Data model and dashboard).
• Working with End user team for preparing security templates for proper authentication and authorization.

IMRS Qlik view Dashboards Provides BI solution for different metrics captured from various up streams and maintained in IMRS data ware house to the users across the globe for their reporting needs on a daily basis.

Roles/Responsibilities:

• Analysing, understanding and validating the requirement given by the clients.
• Developing Data Model and Front end Design.
• Improvements to Existing process.
• Developing Dashboards, charts up on the data model.
• Performance optimization, code review.
• Assisting Business Users on Adhoc Reporting.
• Scheduling automation tasks, backlog data capturing.
• Authentication & authorization.
• Data back loading