• 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.• Automating excel based reports using VBA to reduce manual repetitive tasks.• Working in Agile environment, creating user stories with Acceptance criteria’s, attending Scrum calls and meetings with clients/stakeholders.• Conducting and attending KT sessions to upgrade myself on business-related framework.

• 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.• Clients/stakeholders interaction via calls and e-mails regarding the work progress and updates.

• 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

• 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.• Excel formulae, pivot table, charts, DAX functions, data validation, interdependent drop downs, etc.• Clients/stakeholders interaction via e-mails, Web-Ex, Skype and Avaya related to work and update.• Extra initiatives: Transport management, stationary management, sitting arrangement for the team.

• 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.