Deepak Verma
Section Engineer
Hisar
Summary
Data Analyst professional with 3+ years of experience in solving business problems across domains and industries Practiced in clarifying business requirements, performing analysis between goals and existing procedures, and designing process improvements to increase productivity and reduce costs Proven ability in moving up the learning curve quickly, with solid academic and employment achievements.
Overview
3
3
years of professional experience
6
6
years of post-secondary education
Work History
Senior Data Analyst
Talentedge Pvt Ltd
Gurgaon
01.2022 - Current
- MIS Reporting by Using advance MS Excel at Operational and Client level Fetching data from database in PHY Admin
- Analysis the riders data & create report
- Responsible for Preparation of MIS/ Dashboard Report and Presenting it to the Concern Department using PowerBI
- Preparation of Automated reports by using advance functions like using advance function in Excel like Pivot, Sumproduct, Sumif, Countifs, Offset, Datedif, Subtotal, Vlookup, Hlookup, Substitute, etc
- Responsible for all day-to-day analytical operations generating close reports with capturing scope effects safely, in a timely manner with successful accomplishment under contract requirements
- Prepare briefings or support documents related to the specific issue, researching the issue to identify errors and/or omissions, and the proposal of recommendations
- Perform data analysis including; data collection in gathering, maintaining, and providing monthly and cumulative tracking of all related data
- Conduct analyses and investigations of raw data collected by applying analytical methods to elaborate, advice and provide insight into probable effects of alternative solutions to problems.
Tech Support Engineer
Motherson Sumi Infotech Design & Ltd
Noida
06.2021 - 10.2021
- MIS Reporting by Using MS Excel at Operational and Client level.Generate timely and Accurate Reports for analysis
- Identified data discrepancies in key business reports that were leading to incorrect reporting of crucial financial data
- Create automated report using advance function in Excel like Pivot, Sumproduct, Sumif, Countifs, Offset, Datedif, Subtotal, Vlookup, Hlookup, Substitute, etc
- Responsible for preparation of MIS / Dashboard Report and Presenting it to the Concern Department
- Conduct adhoc Analysis of Key Data Metrics for Trend and Cost Analysis
- Responsible for doing Doing Budget Analysis on the Data for the company and Update Data on SPMS.
Business Analyst
RBL Bank Ltd
Gurgaon
09.2020 - 05.2021
- Providing complex analytical support through the analysis and interpretation of data in support of cross-functional business operations by MIS Reporting
- Working cross-functionally in analyzing, designing, and developing solutions by Creating automated report using advance function in Excel
- Developing annual and Monthly Reports new business initiatives (cost/benefit analysis)
- Dashboard Report and Presenting it to the Concern Department
- Conduct adhoc Analysis of Key Data Metrics for Trend and Cost Analysis
- Generate timely and Accurate Reports for analysis
- Report Automation by Using VBA Programming.
MIS Executive
UK Express Logistic Ltd
Gurgaon
07.2017 - 12.2018
- Performed analysis and presented results using Excel
- Profile consists of maintaining complete track record of service delivery of goods to various companies, coordinating with clients & branches in UK and other parts
- Maintaining documents, track record, MIS, reporting IN & OUT time
- Create automated report using advance function in Excel like Pivot, Smart Pivot, Data Validation, Text to column, Date & Time Function, Sumproduct, Sumifs, Countifs, Datedif.
Education
MBA - Business Data Analytics
Institute of Management And Technology
Gaziabad 09.2019 - 12.2021
Bachelor of Business Administration -
Amity International University
Greater Noida 08.2016 - 04.2019
Higher Secondary - Commerce
National School of Learning
06.2017 - 07.2018
Skills
Advance MS-Excel, Functions, Formulas etc
Advance Excel
SQL
VBA
Power BI
Time Management
Willingness to LearnWorkflow Analysis
Multitasking Abilities
Self-Motivated
MS-Office
Timeline
Senior Data Analyst
Talentedge Pvt Ltd
01.2022 - Current
Tech Support Engineer
Motherson Sumi Infotech Design & Ltd
06.2021 - 10.2021
Business Analyst
RBL Bank Ltd
09.2020 - 05.2021
MBA - Business Data Analytics
Institute of Management And Technology
09.2019 - 12.2021
MIS Executive
UK Express Logistic Ltd
07.2017 - 12.2018
Higher Secondary - Commerce
National School of Learning
06.2017 - 07.2018
Bachelor of Business Administration -
Amity International University
08.2016 - 04.2019