Satish Malviya

Satish Malviya-- Career Objective To work in a challenging environment demanding all my skills and efforts to explore and adapt myself in different fields and realize my potential where I get the opportunity for continuous learning. Professional Background Manav Energy Pvt. Ltd., Bangalore, Karnataka Designation: Senior Engineer (Data Analysis) (August 2014 to June 2019) Roles and Responsibilities          4+ years of experience in MIS Reporting, Dashboard Excel Reports, Coordination, Invoice Reconciliation, PO Creation, Inventory Ordering and Receiving. Proficient in MIS reporting, Advanced excel, VBA (Macro) programing in MS excel. Solid knowledge of Advanced Excel functions Like VLOOKUP, HLOOKUP, Index, Match, Pivot table, Data Validation, Indirect, Concatenate, Logic, String, Date functions and Combo graphs etc. Analyze sales history and trend to maximize sales potential by developing allocation strategies that maintain proper store inventory levels. Budget Analysis like Revenue tracking, Profit & Loss checking and MIS report preparation monthly/Quarterly/annually. Decides important terms and conditions of contract for different projects as and when required. Coordinating with internal teams for obtaining status updates on daily/weekly/monthly progress. Prepare and execute project processes, Dashboards, Trackers, Template & formats, Presentations as per requirement. Strong coordination with management, vendor and related teams for end to end value chain. Key Skills Data analysis, Problem Solving, Critical Thinking, Data Management, Demand planning, Data Preparation, PowerPoint, Advance Excel, Data Validation, VLOOKUP, HLOOKUP, Conditional Formatting, Pivot Tables, VBA (Macros) programming, Client Handling. VBA (Macro) Projects    Bulk reports generation and save in selected folder/path. Data retrieving from different workbooks/sheets. Data splitting and sending to respective email ID’s. Strength  Confidence to work on my own initiative and as part of multidisciplinary teams, good listener and have good thinking capability, good team player and can work under pressure. Academic Details PGDC - Operations & Maintenance of Transmission & Distribution Central Board of Irrigation and Power in 2013 Bachelor of Engineering in Electrical & Electronics Engineering Oriental Institute of Science & Technology -) Hobbies   Watching motivational videos Listening to music Software Skills Advance Excel, VBA (Macro) programming, Ability to work in different Operating systems, Windows-8, Windows 10, MS Office (Advance excel, power point, word etc.). Personal Profile Date of birth :- 20th June 1989 I hereby declare that the information given above is true to the best of my knowledge & belief.. Place: Bangalore Satish Malviya