An MIS (Management Information Systems) analyst with expertise in Power BI and SQL

Report Development:Created and modified complex Web Intelligence reports to provide insights into key performance indicators (KPIs) for different departments.Designed dynamic and interactive dashboards using SAP BO Dashboards (formerly known as Xcelsius) to visualize data trends and facilitate data-driven decision-making.Data Modeling and ETL:Developed and maintained data universes using SAP BO Universe Designer to ensure efficient data retrieval and accurate… Show more Report Development:Created and modified complex Web Intelligence reports to provide insights into key performance indicators (KPIs) for different departments.Designed dynamic and interactive dashboards using SAP BO Dashboards (formerly known as Xcelsius) to visualize data trends and facilitate data-driven decision-making.Data Modeling and ETL:Developed and maintained data universes using SAP BO Universe Designer to ensure efficient data retrieval and accurate reporting.Worked on data extraction, transformation, and loading (ETL) processes using SAP Data Services to integrate data from various sources into the SAP BO environment.Performance Optimization:Identified and resolved performance issues in existing reports and dashboards, optimizing query performance and reducing report execution times.Utilized aggregate awareness and indexing techniques to enhance the overall efficiency of the BI solutions.User Training and Support:Conducted training sessions for business users to enhance their understanding of SAP BO tools and empower them to create ad-hoc reports using Web Intelligence.Provided technical support to end-users, addressing their questions and issues related to report generation and data analysis.Collaboration and Documentation:Collaborated with the database team to ensure data accuracy, consistency, and availability for reporting purposes.Maintained comprehensive documentation of developed reports, dashboards, and universes, facilitating knowledge sharing and team collaboration.Upgrade and Migration:Participated in the migration of SAP BO environment from an older version to the latest version, ensuring a smooth transition and minimal disruption to ongoing reporting activities.Project Management:Collaborated with project managers to define project scope, timelines, and deliverables, ensuring that BI solutions were delivered on time and met business requirements. Show less

Database Design and Development:Designed and implemented complex database structures for clients using Microsoft SQL Server, ensuring efficient data storage and retrieval.Developed stored procedures, triggers, and views to optimize data manipulation and enhance database performance.Report Development:Developed interactive Web Intelligence reports tailored to clients' business needs, enabling them to gain insights into key performance indicators and trends.Designed and… Show more Database Design and Development:Designed and implemented complex database structures for clients using Microsoft SQL Server, ensuring efficient data storage and retrieval.Developed stored procedures, triggers, and views to optimize data manipulation and enhance database performance.Report Development:Developed interactive Web Intelligence reports tailored to clients' business needs, enabling them to gain insights into key performance indicators and trends.Designed and customized SAP BO Dashboards to provide dynamic data visualizations that facilitated strategic decision-making.Universe Design:Created and maintained SAP BO universes using Universe Designer, establishing a semantic layer that simplified data access and reporting for end-users.Ensured data security by implementing row-level and object-level restrictions within universes.Performance Enhancement:Identified and resolved performance bottlenecks in SAP BO reports and universes, optimizing data retrieval and presentation speed.Implemented caching strategies and promoted the use of aggregate awareness to enhance query efficiency.Team work:worked with a team of developers in a major SAP BO upgrade project, overseeing the migration from SAP BO 4.1 to SAP BO 4.3 and ensuring seamless functionality. Show less

As a Campus Ambassador, my role was to represent the company on my college campus and act as a liaison between the organization and the student community. I played a vital role in promoting the company's brand, initiatives, and opportunities while fostering a positive relationship between the company and my peers.