You profile has been submitted for review.
Shubham Advance Excel, Power BI
No reviews yet
SHUBHAM
ABRIDGEMENT
Working As Manager with YES BANK AUG 2023 TO FEB 2024
Worked AS MANAGER with HDFC BANK FROM JUL 2021 TO AUG 2023
Expertise of using Advance Excel and Power Bi.
Strong analytical and problem-solving skills.
An efficient multi-tasker with an ability to shoulder important responsibilities and carrying them out to the
hilt.
ACADEMIC/ PROFESSIONAL QUALIFICATION
Graduate Diploma in Computer Applications, Panjab University (2021)
HANDS-ON SOFTWARE EXPERIENCE
MS Office, Advanced MS Excel
Certification in Power Bi
Power Query
PROFESSIONAL EXPOSURE
WORKING AS MANAGER WITH YES BANK FROM AUG 2023 TO FEB 2024
Roles & Responsibilities: -
Collected and processed complex data sets for statistical modeling and graphic analysis.
Financial reliability and compliance with all applicable directives and regulations.
Managed quarterly financial reports by Table, PivotTable, Data Tools, Charts, Lookup, Sort and Filter etc.
Preparing reports and direct report to Management
Reporting Skills: -
Familiar with MIS.
A working knowledge of advanced Excel functions and ability to read, write, and debug
advanced Excel formulas is required.
Provide analytical solutions to new and existing applications and defect correction through VBA Macros.
Analyzing data and creating final Report.
Automation and optimization of existing processes with VBA.
Hands on Good Experience in Ms-Excel. Using advance functions.
Automating Excel reports like dashboard, coverage report and other reports too through VBA.
Prepared monthly reports using Proc Report, ODS/Excel and SQL.
Prepared Dashboards, Chart Reports as per Business requirements.
Hands-on Experience on POWER BI, Visualization, Custom Visuals, Dashboard Creation, Report Publish,
Direct Query and Data Import. Defined Bookmarks, Drill Down, and Drill Through in the Power BI reports.
Working on migration of Database and Reports to DASP platform. In-
Depth analysis and documentation of existing database and report.
Manipulating data with complex Excel, VBA, Power Query- Editors, Power-BI, Google Tools (i.e., Spreadsheet,
Forms and Data Studio etc.) and SQL Coding.
WORKED AS MANAGER WITH HDFC BANK FROM JUL 2021 TO AUG 2023
Roles & Responsibilities: -
Ensuring compliance with financial regulations and internal policies.
Design, implement, and maintain MIS systems to facilitate efficient data management and reporting
processes.
Develop customized reports based on management requirements.
Ensure accuracy and completeness of financial reports in compliance with regulatory standards.
Collect, analyze, and interpret financial data.
ABRIDGEMENT
Working As Manager with YES BANK AUG 2023 TO FEB 2024
Worked AS MANAGER with HDFC BANK FROM JUL 2021 TO AUG 2023
Expertise of using Advance Excel and Power Bi.
Strong analytical and problem-solving skills.
An efficient multi-tasker with an ability to shoulder important responsibilities and carrying them out to the
hilt.
ACADEMIC/ PROFESSIONAL QUALIFICATION
Graduate Diploma in Computer Applications, Panjab University (2021)
HANDS-ON SOFTWARE EXPERIENCE
MS Office, Advanced MS Excel
Certification in Power Bi
Power Query
PROFESSIONAL EXPOSURE
WORKING AS MANAGER WITH YES BANK FROM AUG 2023 TO FEB 2024
Roles & Responsibilities: -
Collected and processed complex data sets for statistical modeling and graphic analysis.
Financial reliability and compliance with all applicable directives and regulations.
Managed quarterly financial reports by Table, PivotTable, Data Tools, Charts, Lookup, Sort and Filter etc.
Preparing reports and direct report to Management
Reporting Skills: -
Familiar with MIS.
A working knowledge of advanced Excel functions and ability to read, write, and debug
advanced Excel formulas is required.
Provide analytical solutions to new and existing applications and defect correction through VBA Macros.
Analyzing data and creating final Report.
Automation and optimization of existing processes with VBA.
Hands on Good Experience in Ms-Excel. Using advance functions.
Automating Excel reports like dashboard, coverage report and other reports too through VBA.
Prepared monthly reports using Proc Report, ODS/Excel and SQL.
Prepared Dashboards, Chart Reports as per Business requirements.
Hands-on Experience on POWER BI, Visualization, Custom Visuals, Dashboard Creation, Report Publish,
Direct Query and Data Import. Defined Bookmarks, Drill Down, and Drill Through in the Power BI reports.
Working on migration of Database and Reports to DASP platform. In-
Depth analysis and documentation of existing database and report.
Manipulating data with complex Excel, VBA, Power Query- Editors, Power-BI, Google Tools (i.e., Spreadsheet,
Forms and Data Studio etc.) and SQL Coding.
WORKED AS MANAGER WITH HDFC BANK FROM JUL 2021 TO AUG 2023
Roles & Responsibilities: -
Ensuring compliance with financial regulations and internal policies.
Design, implement, and maintain MIS systems to facilitate efficient data management and reporting
processes.
Develop customized reports based on management requirements.
Ensure accuracy and completeness of financial reports in compliance with regulatory standards.
Collect, analyze, and interpret financial data.
Subjects
-
Power BI Beginner-Intermediate
-
Advanced & Basic Excel Beginner-Expert
Experience
-
Manager (Feb, 2022–Aug, 2023) at HDFC Bank
My profile as manager in the project of data analytics, I have team of 2 people, I completed the first project in first month
Education
-
Bachelor of computer application (May, 2015–Dec, 2018) from arya college ludhiana
Fee details
₹1,200–2,500/hour (US$14.27–29.73/hour)
Fees can vary for a multitude of reasons depending on the service or product in question. Depends on Content.
-
-
Ludhiana, Punjab, India
-
Can travel:
No
-
- Last login: Jun 5
- Registered: Jun 3
- Total Teaching exp: 2.0 yrs.
- Teaches online: Yes
- Online Teaching exp: 1.5 yrs.
- Teaches at student's home: No
- Homework Help: Yes
-
Gender: Male
- Works as: Individual teacher
-
Fee:₹1,200–2,500/hour(USD 14.27–29.73/hour)
Reviews
No reviews yet. Be the first one to review this tutor.