Devender Rawat Email & Phone Number

Gurugram, HR, IN

Gurugram, Haryana, India

• Working for a UK based client that deals in multiple divisions like Fashion, Electrical, Sports and Home Decor items. Also worked in P&C under Insurance vertical for a short period of time.
• Developing and maintaining Power BI reports and Dashboards related to Forecasting and Availability.
• Creating, amending, and optimizing SQL code in SAS job to create packages as per the requirements and validating the output in design environment before making it live into production.
• Working on time series-based data and using functions like week-to-date, month-to-date, year-to-date, etc. to create reports/dashboards.
• Teradata to pull out data for the reports, dashboards, and ad-hoc requirements.
• Creating complex DAX formulas/measures, establishing relationships in Star and Snowflake schema.

Gurugram, Haryana, India

• Handling multiple projects related to digital marking of Microsoft’s campaigns in MaSH (Marketing Services Hub).
• Analyzing data of KPIs and OMIs for multiple areas and subsidiaries to get trends and key insights to prepare the reports for higher management.
• Developing Power BI Dashboards using complex DAX formulae and managing, creating MS flows.
• Automating reports using VBA to reduce manual repetitive work, enhance report quality and accuracy.
• Creating and optimizing SQL queries, stored procedures, views, scheduling and managing SQL jobs.
• Data modeling, data manipulation, Entity relationships using schemas like star schema, snowflake schema, DAX, ETL, SSIS packages creation, emails triggers.

Gurugram, Haryana, India

• Reporting and Automation, data analysis, trends analysis, dashboards, KPIs, budgeting, forecasting, SLAs and getting insights from the raw data.
• Automation in VBA to reduce the manual repetitive work, enhance report quality, accuracy and saving time.
• Creating and optimizing SQL queries, stored procedures to pull out data from multiple sources to create meaningful reports.
• Working in Power BI to create Dashboards and reports for better and attractive visualization.
• Clients/stakeholders interaction via calls on Web-Ex, Skype and via e-mails regarding the work progress and updates.
• Conducting and attending KT sessions within or outside the team to enhance the skills on different-2 technologies

Noida, Uttar Pradesh, India

• Projects /tools development & management in VBA, SQL, QlikView and Power BI for claims data in insurance industry.
• Team handling like work allocation, trainings, SLA management & resource utilization etc.
• Working in Agile environment, creating user stories with Acceptance criteria’s, attending Scrum calls and meetings with clients/stakeholders.
• Data analysis, planning and developing business specifications, providing insights to develop and modify systems to meet client(s) requirements and planning UAT.
• Creating SQL queries, Store Procedures, Data Modeling, SSIS, SSA, job scheduling and triggering.
• MIS Reporting and Automation, dashboards, KPIs, excel based reports, budgeting, forecasting, SOP creation, pulling out raw data from multiple sources like CMS Avaya, Oracle BI Publisher.

Noida, Uttar Pradesh, India

• Creating multiple Sales based reports like dashboards, scorecards, sales KPIs, sales report trackers, employee attendance tracker and many other reports.
• Analyzing actual and forecasting data for the reports, task accomplishments, discover the best ways to solve the problems, ensure deliverables on a fixed cadence (Daily, Weekly, Monthly…)
• Using Excel formulae, aggregate functions, pivot table & charts, data validation, dynamic ranges, conditional formatting in reports.
• Interaction with clients/stakeholders via e-mails and calls, communicate to superiors and give understandable instructions to subordinates.