Summary
Work History
Education
Skills
Technical Overview
Education Overview
Disclaimer
Profile Overview
Timeline

MRIGANK SHEKHAR

BI Analyst
Bangalore

Summary

3+ years of IT work experience as an Oracle SQL with Power BI developer with basic knowledge in Python Scripting. Understand user requirements and develop reports that meet business needs Hands-on experience in application support and scripting. Collaborating with stakeholders to understand their business requirements and provide appropriate BI solutions. Performing data quality checks and ensuring data accuracy. Maintaining and updating existing reports and dashboards. Involved in the projects' Design, Development, and Validation activities. Involved and contributed to the code review process, and documented the review comments to use it for the Root cause analysis (RCA). Participate in code reviews to ensure code quality and adherence to coding standards. Created high-quality visualizations, reports, and dashboards in Microsoft Power BI. Knowledge of all Software Development Lifecycle (SDLC) activities, including, requirements, design, Coding, Unit Testing, Deployment, Maintenance, and support. Provide detailed design specifications to the LOB partners Good knowledge of support activities, Troubleshooting, Analytical Skills, Client Focused, Applications Health Checks Prototype dashboards to engage users and create excitement about solutions Utilize Power BI to build interactive, visually appealing dashboards and reports. Reviewing and analyzing change requests to determine the scope of work. Collaborate with the team to understand the business needs and translate them into technical specifications. Strong understanding of data analysis and visualization techniques

Work History

BI Developer

Myzas technologies private limited
Bengaluru, Karnataka
08.2021 - 10.2023
  • Company Overview: Ensuring a first class customer and candidate experience through verifying standard education, employment, and reference information as well as conducting credit, criminal and database checks in line with qualitative and quantitative performance targets for the role, utilizing available resources such as telephone or electronic processes in a professional and timely manner, adhering to company policies and procedures in order to help candidates get hired.
  • Build and maintain interactive and visually appealing dashboards and reports using BI tools such as Microsoft PowerBI.
  • Working within a team to document user/business requirements, translate into technical designs, and explain technical issues clearly and accurately to both technical and functional users.
  • Strong understanding of data modeling, ETL processes, data warehousing, and data governance principles.
  • Sending the weekly status reports to LOB.
  • Ensure data accuracy, integrity, and consistency across all BI solutions.
  • Provide technical expertise and guidance to junior team members on BI best practices.
  • Participated in all client discussions on the project.
  • Working on Incident Management: Handling tickets effectively and providing solutions.
  • Ability to analyze and resolve complex infrastructure resource and application deployment issues.
  • Ensuring a first class customer and candidate experience through verifying standard education, employment, and reference information as well as conducting credit, criminal and database checks in line with qualitative and quantitative performance targets for the role, utilizing available resources such as telephone or electronic processes in a professional and timely manner, adhering to company policies and procedures in order to help candidates get hired.

BI Support and Developer

Myzas technologies private limited
Bengaluru, Karnataka
12.2023 - 03.2025
  • Company Overview: Finnovation is a leading financial institution specializing in providing loans to individuals. Design, develop, and maintain robust SQL databases to store financial data, ensuring data integrity and security.
  • Analysis of project requirements as per the Business needs.
  • Strong understanding of business intelligence, data warehousing, and data visualization concepts, as well as experience with Power BI.
  • Understanding and analyzing the requirements and design documents.
  • Involved in Coding & Unit Testing and maintaining client standards. Involved in Code Reviews.
  • Interact with the On-site coordinator to clarify the work details.
  • Strong understanding of data modeling, visualization, and analysis techniques.
  • Writing SQL queries using joins, sub-queries, and correlated sub-queries to retrieve data from the database.
  • Worked on Parameterized cursors and explicit cursors.
  • Created and modified the objects in the database.
  • Worked on inline Views and correlated sub-queries based on business context.
  • Clarify the client’s issues and work with them to solve them on a regular basis with in SLA.
  • Finnovation is a leading financial institution specializing in providing loans to individuals. Design, develop, and maintain robust SQL databases to store financial data, ensuring data integrity and security.

Education

B.Tech - ECE

Bengal College of Engineering and Technology
01.2014 - 01.2018

High School Diploma -

Buxar High School, Buxar, Bihar
01.2011 - 01.2013

GPA: 72%

Skills

Business intelligence tools

Technical Overview

Oracle 11g, Oracle 12c, Oracle 18c, Oracle SQL, PLSQL, Windows, LINUX, Git-Hub, SVN, SERVICE NOW, SQL Developer, PUTTY, WinSCP, Jira, SharePoint, TOAD, Microsoft Power BI, Microsoft Excel

Education Overview

  • B.Tech, ECE, Bengal College of Engineering and Technology, Durgapur, 08/01/14, 05/31/18
  • High School, Buxar High School, Buxar, Bihar, 01/01/11, 12/31/13, 72%

Disclaimer

I hereby declare that the particulars of information furnished above are true to the best of my knowledge and belief., 10/01/23, MRIGANK SHEKHAR

Profile Overview

3, Oracle SQL with Power BI Developer, Python Scripting, Application Support, Data Quality Checks, Report Development, Dashboard Maintenance, Code Review, Data Analysis, Visualization Techniques

Timeline

BI Support and Developer - Myzas technologies private limited
12.2023 - 03.2025
BI Developer - Myzas technologies private limited
08.2021 - 10.2023
Bengal College of Engineering and Technology - B.Tech, ECE
01.2014 - 01.2018
Buxar High School - High School Diploma,
01.2011 - 01.2013

Similar Profiles

CREATE PROFILE
MRIGANK SHEKHARBI Analyst