Praveen E

Project Name: Supply Chain Management, Terminal Pricing Benchmarking, Finance League Tables, Internal Auditing

Role: Senior BI Consultant

In this organization i had opportunity to work on various streams like Supply Chain Management,Finance,Internal Auditing etc.

• Collaborated with business and stakeholders to identify essential metrics and data analysis needs, taking full responsibility for the subsequent analysis and report delivery.
• Expertly extracted data from various sources like SQL, Oracle, Teradata etc and utilized these tools to validate dashboard metrics, ensuring accuracy and reliability of data presented.
• Leveraged data sources to enhance understanding of market trends, competitor activities across finance, SCM, HR, and information security domains, delivering decision-driving insights to stakeholders.
• Specialized in cleaning and transforming large datasets using Power Query and Qlik Scripting, ensuring their quality and relevance for dashboard creation, and enabling accurate and actionable insights.
• Developed robust data models, including star schema and snowflake configurations, tailored to the data's structure, optimizing for efficiency and scalability in analytics applications.
• Involvement in reviewing Mock-up’s, DB Mapping, Qlik Data Modelling, Front end development, UAT, Documentation, Production Deployment and User training.
• Designed and implemented decision-driven dashboards using Power BI, Qlik Sense, and QlikView,SAP Analytics Cloud visualizing key insights and incorporating data-level security to ensure information integrity and access control.
• Delivered insights that informed decision-making across all business levels, from senior management to individuals with no background in business intelligence, ensuring widespread understanding and actionable intelligence.
• Led the creation of Jira tasks and developed comprehensive technical specification documents, ensuring a structured and organized development process. Established clear documentation standards, facilitating knowledge transfer and smooth collaboration within the team.
  
  

Project Name :- Inventory , Polaris Sales

Role:- Qlik Developer

Client Name:- Janssen Pharmaceuticals

The main aim of the project was to develop a dashboard that designed to gather, evaluate, and compare pharmacy data from multiple sources, allowing companies to operate more efficiently, this included major Sales KPI's to analyze sales performance across different sales channels, retailers and impact of each KPI on sales as well as YoY growth.

• Worked end to end on the dashboard from requirement gathering, design, data modelling, UI development till deployment.
• Worked on various pitfalls like eliminating synthetic keys, circular reference, performance issues while data modelling.
• Managed multiple user access groups and document level security using section access.
• Worked on On-demand application to handle huge data sets
• Migrated the QlikView dashboard to Qlik Sense.
• Leading the stand-up calls with business to discuss on new requirements as well as ongoing changes, development and project overall progress.