Vikas Shirsath

• Participated in requirements meetings and data mapping sessions to understand business needs
• Designed and developed Trackers to collect operation's data
• Produced monthly reports using advanced Excel spreadsheet functions
• Design and prepare excel Power query-based Dashboard of all operation Reports and convert same reports to Power BI Dashboard
• Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
• Reviewed files, records and other documents to obtain business information and key data informing responses to development requests
• Handling a team of 3 Data analyst and assign all reporting task to them and ensure it will be share with respective teams within given timeframe

• Successful implementation of Pilot project named Aerospace reports and Automate existing process to save the FTE and Time.
• Design and Develop the application (both front end and backend) using VBA, Excel, Access Database & some times SQL as per customized request like SWU Automation, BCP Tool
• Creating and developing Power BI Dashboards (KPI,Scorecards, Charts, Slicer, Matrix and Custom Visuals) like BALCO Report, Divisional Deck and STR
• Implement Row Level Security (RLS) on data and publish the report to stakeholders using Power BI Services
• Handled Financial Reports like Piece Rate, OT and NSA and Non-Financial reports like Productivity, Utilization Reports
• Worked on forecasting reports like Staff Time Report and Divisional deck
• Conducted training sessions on Power queries and Power pivots

• Tracked different Order metrics daily and organized for reporting purposes.
• Used Order Data to input, analyze and model data
• Handling multiple reports in Excel, working with formulae, Power pivot table, Power charts, Performed Trend Analysis of Data and Automation of reports for future planning
• Planned and led administration of management information system for achieving threshold-level performance
• Supervised JK tyre audit processes to address non-compliance and vulnerabilities

• Carried out day-day-day duties accurately and efficiently.
• Ensuring all teachers and coordinators are trained to work with the smart class program
• Collate Daily, Fortnightly or Monthly MIS Reports in excel format and send to the respective Service Area Manager
• Conduct the trainings of newly joined coordinators
• Used critical thinking to break down problems, evaluate solutions and make decisions

• To provide all technical support related to Net Connect (Internet Service provided by the Reliance with DATA CARD as well as CDMA Mobile) to the customers
• To resolve the customer’s technical queries online and to achieve the customer’s satisfaction
• Collaborated with customers to locate technical issue and resolve advanced problems.

· To operate inbuilt software developed in VB (6.0).

· To maintain the Database and generate the daily reports.