Sitaram Vishwakarma

 Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
 Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.
 Developed complex stored procedures, views, and temporary tables as per the requirement.
 Responsible for developing VBA macros to automate repetitive tasks.
 Developed and maintained multiple databases using VBA and MS Excel.
 Developing dynamic Power BI Reports, Dashboards and KPI for stakeholders and deployed on Power BI Services.
 Develop and implement data models for new and existing databases to support business processes and applications.
 Developed new reports and enhancing existing reports in Power Bi Desktop
 Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts,

Developed Aapplications Tool using VBA, MS Access, SQL to help with process automation and control.
Developing dynamic Power BI Reports, Dashboards and KPI for stakeholders and deployed on Power BI Services.
Write SQL query to extract data from database and use for visualization and analysis.
Providing historical data Analysis for Incoming Volume and Completed Task to plan Capacity.
Productivity and improve overall SLA by 17% in all business area.
Used Power BI Gateways to keep the dashboards and reports up to date.
Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts.
Scatter Plots, Histograms, Tree Maps, Heat Maps, Area Charts, Bullet Graphs in Power BI Desktop.
Automated manual reports using VBA.

Dealing with and resolving problems and issue which arise.
Mentoring the training up for new staff.
Giving the Advance Excel and MS Access training.
Monitoring & Report on standards & performance Targets.
Arranging & chairing weekly team meeting, focusing on targets & achievements.
Providing prompt and accurate information on individual’s performance.
Implementing new initiatives.
Taking 1-2-1 of team members and giving feedback for performance.

Extracting repots like PO Matching, Dummy Supplier, PO & OI Rejections, SSC Duplicate, PO Notification, Non-PO Notification, Force Approval, All Holds vQSM and etc. from SQL Developer, BI (Business Intelligence), Oracle, IT Intranet and vQSM Portal.
Uploading all reports into PMS Tool (Processing Tool) for agents.
Creating agent’s performance report.
Tracking the break of all agents and circulating the report.
Creating Daily, Weekly and Monthly Summary Report, Stack Reports with Ratings, Governance Report team wise, Management Report Manager wise, Dashboard for the Management.
Maintaining the RYG Tracker.

To undertake standard, documented Eproc 1st line support activities to ensure incidents are managed through appropriate investigation or reporting to IT service desk 1st Line support groups by performing a review of the incident details within the vQSM Records.
To initiate the first stage of Major Eproc Incident Management in line with the process where appropriate.
Run Daily reports, extract scheduled data, and work upon the data.
Prepare spread sheet and produce/analyses statistical data as required.
Identify and report potential improvements, raise CR’s when required and monitor the progress and implementation of CR’s.

Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.
Developed complex stored procedures, views, and temporary tables as per the requirement.
Responsible for developing VBA macros to automate repetitive tasks.
Developed and maintained multiple databases using VBA and MS Excel.
Developing dynamic Power BI Reports, Dashboards and KPI for stakeholders and deployed on Power BI Services.
Develop and implement data models for new and existing databases to support business processes and applications.
Developed new reports and enhancing existing reports in Power Bi Desktop.
Deploying rich graphical visualizations in dashboards to create effective views of data such as: Line Charts, Bar Charts, Pie Charts.