Anand Singh
BI AND REPORTING MANAGER
Bangalore
Summary
Experienced BI & Reporting Manager with 14 years of expertise in leading data-driven projects and optimizing reporting tools. Skilled in project management, client relations, and delivering tailored solutions to drive business insights and enhance decision-making processes. Proven track record of managing cross-functional teams, delivering on-time solutions, and training end-users. Adept at data modeling, stakeholder management, and optimizing data workflow. Committed to delivering high-quality, user-centric BI solutions while staying updated with emerging technologies and best practices. Passionate about leveraging advanced analytics to meet business objectives and drive organizational success.
Overview
13
13
years of professional experience
6
6
Certifications
2
2
Languages
Work History
BI & Reporting Manager
London Stock Exchange Group
12.2021 - Current
- Managed a team of 7 software engineers and deliver the project on time by following all the best practice and setting up the Power BI infrastructure from scratch.
- Developed a comprehensive SharePoint site and Viva Engage group that improved technical skills (Power Platform) and competencies among team members and helped new members to get started with Power BI and Power Automate.
- Conducted a comprehensive comparison of various BI tools (including Power BI, MicroStrategy, Tableau and BO), evaluating features, performance, and scalability, while providing a clear roadmap for migrating to Power BI, outlining critical steps such as data extraction, model optimization, report re-creation and end-user training.
- Collaborated with team members to identify and resolve technical issues, resulting in a 30% reduction in downtime in report execution.
- Developed a SharePoint page, outlining all best practices which has helped various team to deliver high-quality deliverables.
- Implemented innovative Power BI solutions, including export Power BI data to PDF using Power Automate without using Premium Capacity, conditional bold formatting in cells, cross-report slicer value passing, and automated extraction of usage data from Power BI workspaces, resulting in significant project cost savings.
- Received multiple excellence awards for successfully delivering projects ahead of schedule while maintaining high standards across key deliverables.
Specialist Metric Analyst
Bank of New York Mellon
04.2020 - 12.2021
- Developed dashboards and interactive reports on investment, client, and compliance data for the Executive Committee, providing actionable insights to support strategic decision making and enhance regulatory compliance.
- Collaborated with database team to develop a data catalog to improve data discovery and enable self-service analytics.
- Optimized the performance of existing BI solutions, resulting in a 20% decrease in query execution time and report loading time.
- Received 2 excellence awards for delivering efficient Power BI solution by automating the deployment model, resulting in 25% reduction in development time.
Sr. Application Development Analyst
Iqvia
05.2016 - 04.2020
- Developed and monitored dashboards, using MicroStrategy to track KPIs and report on progress based on Oncology and healthcare data.
- Created a dashboard that visually represented key business metrics in real-time, allowing for quick and informed decision-making by management.
- Collaborated with cross-functional teams to understand business requirement, ensuring key reports and dashboards were replicated accurately in Power BI.
- Created a dashboard comparing MicroStrategy and Power BI in detail.
- Trained end users and stakeholders on Power BI features and functionalities, ensuring smooth post-adoption migration.
Senior Business Analyst
Ocwen Financial Corporation
05.2015 - 05.2016
- Designed and developed complex reports and dashboards on Mortgage data using MicroStrategy, to streamline analysis and enhance decision making for lending and foreclosure team.
- Optimized report performance by tuning SQL queries, leveraging intelligent cubes, and applying best practices in data modeling.
- Managed and monitored MicroStrategy environments including server health, user access and system performance to ensure high availability and optimal efficiency.
- Implemented security roles and permission, ensuring data governance and compliance across all MicroStrategy users and groups.
- Authored a comprehensive knowledge article on MicroStrategy for Confluence, providing best practices, troubleshooting tips and user guidance to enhance team collaboration and knowledge sharing.
Staff Consultant
Oracle Financial
08.2014 - 05.2015
- Designed and developed reports and dashboards using MicroStrategy to meet business requirements for Citibank.
- Created advance metrics, filters, and prompts to enhance report flexibility and deliver actionable insights.
- Maintained and updated existing reports, incorporating new data sources and metrics as business needs evolved.
Consultant
ICreate Software Technologies
07.2012 - 08.2014
- Assisted in the development of reports and dashboards under the guidance of senior developers, ensuring alignment with business requirements and standards.
- Created basic metrics, filters, and attributes to support data analysis and reporting needs across various departments.
- Performed unit testing and validation of MicroStrategy reports to ensure data accuracy and functionality before deployment.
- Provided support for report modification and troubleshooting, helping to resolve user issues and optimize report performance.
Education
Bachelor - Information Technology
Uttar Pradesh Technical University
05.2011
Skills
- Business Requirements
- Stakeholder Management
- Power Platform and Power BI
- Micro Strategy
- SQL Server Analysis Services
- Agile Methodology
- Data Modeling
- SQL Server Integration Services
- Snowflake
- Tableau (Software)
Certification
Power BI Analyst - December 2021
Timeline
BI & Reporting Manager
London Stock Exchange Group
12.2021 - Current
Specialist Metric Analyst
Bank of New York Mellon
04.2020 - 12.2021
Sr. Application Development Analyst
Iqvia
05.2016 - 04.2020
Senior Business Analyst
Ocwen Financial Corporation
05.2015 - 05.2016
Staff Consultant
Oracle Financial
08.2014 - 05.2015
Consultant
ICreate Software Technologies
07.2012 - 08.2014
Bachelor - Information Technology
Uttar Pradesh Technical University