Rupesh Sharma Email & Phone Number

Delhi, India

Faridabad, Haryana, India

• Advance skill in Excel functions like if, countif, Sumif, Sumifs; counta, SumProduct, V-lookup, H-lookup, Index-match, Indirect, Date time, etc.• Understanding several built-in tools for data analysis, such as PivotTables, Pivot Charts.• Expertise in data formatting, data alignment, and conditional formatting.• Good understanding of concepts such as tables, columns, primary keys, foreign keys, and indexes.• Competent in SQL database operations, including select, delete, append, update, and Make table.• Applied SQL for query, function, and procedure development, including work with DDL and DML.• Ability to write complex SQL queries for data investigation, repair, and migration to new structures.• Experience in creating and developing Power BI Dashboard in to rich look.• Experience in utilizing various transformations within the Power BI query editor.• Skilled in DAX functions for Power BI.• Using Power Query for the data transformation and data cleaning.• Creating interactive visualizations, reports, and dashboards in Power BI.• Experience in different types of joins such as left join, right join, inner join and outer join.• Knowledge of Python coding for data fetching by multiple queries.• Reduce manual activity on raw files by using Python coding.• Knowledge of handling databases like MySQL, Excel, and CSV files with Python.• Knowledgeable in data sorting, data filtering, What-if Analysis, data consolidation, grouping, and validation rules.

Master Of Business Administration - Mba, Finance And Marketing

Bachelor Of Arts - Ba, Art/Art Studies, General, A+