Ramesh Kumar Reddy Panga

• Developed custom dashboards and visualizations using Qlikview,Qliksense and Tableau to provide actionable insights for key stakeholders.
• Participated in all the phases of requirement gatherings, Data analysis, proof of concepts,scrum ceremonies,data modelling,dashboard development & production releases.
• Designed scalable and optimized solutions by incorporating best practices in BI architecture, ensuring seamless integration with existing systems.
• Building QVDs,QVWs,QVFs,TWBXs with customized SQLs for the databases Oracle,Teradata,SQL,Server,SAP,Dremio & Other Sources.
• Developed visualizations using all the UI components like listboxes,charts,KPIs,tables,containers,sheets,stories,set analysis,fitlers,LODs, functions,variables,parameters etc.
• Strengthened data security measures by implementing section access in Qlik & application level security in Tableau.
• Migrated all the Qlikview Dashboards to Qliksense and Tableau as per the firmwide strategic reporting solutions.
• Experience in admin level activities using Qlik Management Console,Tableau admin,publisher,Nprinting and other admin level activities for various BI solutions.
• Experience in developing dashboards using Power BI,performing ETL transfermations using Pentaho & Alteryx.
• Mentored and trained the team members and end users on Self Service BI solutions using, fostering a culture of continuous learning within the team.

• Gathered all the end to end business and technical requirements for the complete project suite of Business Intelligence solutions.
• Developed visually interactive customized Dashboards for Group Finance ,Digi banking applications using Qlikview & Qliksense as per the business needs.
• Created optimized models using star and snowflake schemas following the best practices.
• Collected data from wide-ranging sources like Oracle,SQL and manual files and
• Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
• Leveraged advanced SQL skills to conduct in-depth data mining for the purpose of uncovering previously hidden insights,optimized the dashboards,data models & UI using various KPIs.
• Taken care of all admin related activities in QMC,assigned dashboards to the users using Named CAL/Document CAL and prepared design document & operational documents.
• Implemented Incremental loads using best practices to lessen the load on the source databases.
• Identified patterns and trends in large data sets and provided actionable insights for the senior management decision making.

· Provided end to end solutions like presales, prototypes, requirement gathering for all the QlikView dashboards for manufacturing, finance, Quality & sales divisions.

· Developed the dashboards at the summarized and detailed level to serve higher level management to lower level management. Developed interactive Dashboards with SQL, SAP BW as the backend.

· Managed the applications through QMC for access controls.

· Prepared end user documentation and training. Migrated all the dashboards to the server through QV Access point.

· Automated the ETL process using SAP BW, slashing the data preparation time by 50% and enabling real-time data analysis for critical business units.

• Worked on other projects like Monsanto, Sansera Engineering & TTP Technologies for end-to-end data analytics, Datawarehouse and dashboarding solutions using SAP BW, MS SQL Server, Business Objects, Web Intelligence, Crystal Reports & Xcelsius
• Extensive experience in developing Dashboards using Xcelsius
• Hands on experience in creating and customizing reporting solutions using Web Intelligence and Crystal Reports
• Experience in ERP warehouse systems like SAP BW,Oracle,SQL Server,SAP HANA,SAP Data Services & Universe Design.
• Actively participated in team meetings sharing knowledge expertise contributing towards a collaborative work environment.
• Developed customized reports to improve decision-making with the use of SAP Business Objects reporting tools.