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.

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.04–29.24/hour)

    Fees can vary for a multitude of reasons depending on the service or product in question. Depends on Content.

Reviews

No reviews yet. Be the first one to review this tutor.