Sagar Nayak
Hyderabad
Summary
7+ Years of domain experience in MIS Reporting, VBA Macro, T-SQL, Power BI. Currently working with ACS Global Tech Solutions Private Limited as Senior Associates - MIS. Excellent learning skills with strong belief in Teamwork. Excellent communication & interpersonal skills with ability to resolving issue. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
7
7
years of professional experience
Work History
Senior Associates - MIS
ACS Global Tech Solutions Private Limited, MIS
02.2020 - Current
- Roll out various Daily Reports: Daily Production (Global and Domestic) Reports, Internal & External Scorecards, Production Vs Quality Metrics & all other ad hoc and daily reports required by the top management.
- Understand and analyze automation opportunities and provide VBA solutions for various components of the Excel i.e., Creating various automation template to reducing the time frame along with accuracy.
- Integrate advance Excel formulas and VBA techniques to manipulate spreadsheet.
- Successfully Created Various Power BI Dashboard migrating from Excel.
- Create Dynamic excel Dashboard with using of advance Excel formulas and Macro.
- Create various Payroll automation template using VBA to handle daily repetitive task in accuracy.
- Build user defined function and various customized VBA solutions for various work groups to automated tasks.
- Creating Metrics tracker using VBA and Advance excel formula to reduce the time of work and increase the productivity.
MIS Executive
KFin Technologies Private Limited
01.2017 - 02.2020
- Roll out various Reports: Regulatory Reports (Daily and Monthly UCR, UHR Report), Statutory Reports (Daily, Monthly, Quarterly Fund utilization reports, Daily Refund MIS, Dividend Distribution Reports to AMC and Exchange) and Internal reports based upon Client requirement and for our internal purposes.
- Understand and analyze automation opportunities and provide VBA solutions for various components of the Excel.
- Integrate advance Excel formulas and VBA techniques (V-Lookup, H-Lookup, Index, Offset, Match, Array formulas, Loops etc..) to manipulate spreadsheet.
- Wrote and executed SQL queries using Query Analyzer to provide custom reports to management.
- Creating Metrics tracker using VBA and Advance excel formula to reduce the time of work and increase the productivity.
- Reconciling unit capital on day to day basis and sending to fund accountant for the purpose of calculating NAV.
MIS Executive
Adecco India Private Limited, MIS
02.2016 - 09.2016
- Roll out different reports i.e., Collated Trackers, KPM Report, Demand Vs Supply metrics and maintaining day to day MIS Data.
- Maintaining an update tracker of process.
- Prepare MIS reports for Branch wise reporting.
- Preparing & Analysis Business Partner Ageing Report and track the performance on Daily, Weekly and Monthly basis.
- Handling all Incentive process and automated the same.
- Preparing Business process dashboard and presentation slides as per business requirement.
- Successfully analyze live data and provide to the management for to achieve 10K Run Program.
- Write and execute various T-SQL Query from Data base and analyze the data for various reporting.
Education
Bachelor of Commerce - Accounting And Finance
IGNOU University
New Delhi06.2013
Skills
- Domain : Mutual Fund & Stock Broking, Taxi Services & Healthcare
- Functional Area : Reporting & Development
- Technologies : Advance Excel, VBA Macro, Power BI, SQL
- Area of Expertise :
Advance Excel : Office 365 Formulas, V-Lookup, H-Lookup, Index-Match, Offset, Data Validation, Logical Functions, Date and Time, Text & Aggregate Functions, Data Sort & Filter, Pivot Table & Charts, Dashboards
VBA Macro (Dim Statement, Data Types, Loop, Array, User Form, Active X Control)
Accomplishments
- Awarded as “ ACS Innovation 2.0” for to successfully migration from Excel to Power BI and doing an excellent job in automation.
- Awarded as “ACS - Right Click Award” for the 1st Quarter for to understand the business process within short period of time and delivered the requirements without any escalation.
- Awarded as “ACS – ICON of the Month” for the month of March to do an excellent contribution towards VBA automation.
Languages
English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)
Odia
Bilingual or Proficient (C2)
Timeline
Senior Associates - MIS
ACS Global Tech Solutions Private Limited, MIS
02.2020 - Current
MIS Executive
KFin Technologies Private Limited
01.2017 - 02.2020
MIS Executive
Adecco India Private Limited, MIS
02.2016 - 09.2016
Bachelor of Commerce - Accounting And Finance
IGNOU University
Similar Profiles
Nagaraju KayyalaNagaraju Kayyala
Senior Quality Analyst at ACS Global Tech Solutions Private Limited (Client : Verizon)Senior Quality Analyst at ACS Global Tech Solutions Private Limited (Client : Verizon)
Rajesh GondleRajesh Gondle
Senior Business Systems Analyst at ACS Global tech solutions – DeloitteSenior Business Systems Analyst at ACS Global tech solutions – Deloitte
NIKHIL TINGNENIKHIL TINGNE
Sr Software Engineer at ACS Global Tech Solutions Pvt LtdSr Software Engineer at ACS Global Tech Solutions Pvt Ltd