Avijit Das

• Report important KPI metrics and assisting the stakeholders to take business decisions by creating ad-hoc reports, developing dashboards and performing automation activities. Utilizing tools like Power BI, Excel, Datorama, SQL and Power Query.
• Execute the assigned projects / analysis as per the agreed timelines and with accuracy and quality. Sharing weekly status reports with the stakeholders and documenting change or updation requests for quick implementation. Working with Clients like Citi, Comcast, KFC etc.

• Projects:

1. Marketing Evolution (ME):

• This project captures the market awareness of Citi’s products and the performance of various campaigns against the business KPIs like click, spend, impressions etc.
• Data is extracted from various sources including campaign manager platforms, cloud servers (GCP), excel and flat files and transformed into an uniform format for further analysis. I use multiple tools to carry out the ETL procedures including Excel, Big Query, Datorama, Power Query and DAX. Transformed data is then used for visualization purposes.
• The KPIs and the success or failure of each campaign is captured in a Power BI report, which is shared with the Stakeholders on a monthly basis. We collect all the requirements in the beginning of each month to incorporate those in the monthly report. Any ad-hoc requirements are taken into account in our weekly status calls.

2. Market Mix Modelling (MMM):

• It deals with Citi’s existing customers and how to improve its services and offerings. This project is carried out each quarter and tools used for this project are Excel and Power BI.
• Campaign and Spend data are collected, aggregated and transformed for each LOB (Card, Bank, Mortgage, Custom Cash, Co-Branded etc). The prepared report is shared with POCs of each line of business for validation of the spend and impressions.
• The validated reports are then processed and a detailed Power BI report is prepared, with a dedicated page for each LOB and shared with the stakeholders.
• Any additional requests or detailed report for a particular campaign or demographic is also incorporated in the report. I keep track of all these requirements in the monthly BRD document, which is prepared before initiating the project.

3. IAS & GDPR:

• This is brand safety and visibility report for Comcast. Tools utilized for this report are: Datorama and Excel. Reports are shared on a monthly basis.
• Server data is ingested in the Datorama data streams. A dashboard is prepared each month which includes viewability and safety metrics for a 13 month running average. This is particularly useful for historical data analysis.
• Excel reports are prepared capturing imports metrics and shared with the stakeholders at the mid of each month.

• Analyze and prepare team’s KPI Metrics, Business continuity plans, assisting management to take proper business decisions, automate daily reporting using power query, create interactive dashboards and ad-hoc reports as per the requirement of the leadership team.
• Create reports and dashboards in Tableau, experience in handling cloud platforms like GCP. Familiarity with other visualization tools like Power BI and experience in writing custom queries in SQL.

• Projects:

1. BT:

• BT has its own Video on Demand (VOD) Platform. My responsibility was to keep track of the image coverage ratio for the programs appearing on their platform. All the channels have to maintain a minimum benchmark to meet the SLAs.
• A Tableau dashboard was prepared and maintained on a daily basis to keep track of all the required metrics. Reports were shared with the client on a daily basis.
• I also kept track of the resources working on the deliverable side for BT. A separate productivity report capturing weekly deliverable numbers for each resource was shared with the clients and internal management team.

2. Weekly Log – Automation:

• Weekly log collation for a team consisting of 25 team members was a hassle for the leadership team. I carried out an automation activity which completely automated the reporting process. Tools utilized for this process: Excel, Power Query, DAX, SharePoint.
• A dedicated folder for each resource was created in the SharePoint server and Excel Power Query was connected to the server folder. Carried out several ETL procedures to prepare the data for further modelling.
• Utilizing the Power Pivot created a MIS dashboard for the internal management team which incorporates productivity trend, target KPIs, resource performance, leave details and comparison matrix for each resource, with interactive slicers to drill down on a granularity level of a day.
• Impact: Drastically reduced the time for the management team to create productivity and resource reports on a weekly basis. Saved almost 8 hours of productive time each week.

3. Content Discovery – Reporting:

• Handled the entire reporting and analytics workflow for a team of 25 content researchers.
• Prepared weekly productivity reports for each client, developed dashboards and ad-hoc reports for the stakeholders.
• Presented team performance report in monthly governance calls. Shared process improvement ideas and prepared BRD documents for any upcoming projects. Requirements were also casketed down to the team for implementation in the workflow.
• Prepared process documents and placed it on the internal servers for easy access and reference in future use cases.

4. Task Management – Automation:

• The team used to receive its daily task list in a CSV file, which had thousands of rows and it was cumbersome to find the daily tasks for each resource. Several filters needed to applied to find the tasks that needed to be carried out on that particular day.
• I automated the entire process using Excel, Power Query and Power Pivot. The model which I prepared aggregated and presented daily level tasks for each employee. They could simply go to their respective tabs and with a single button press, they found the tasks they needed to work on that day.
• Impact: Saved 125-man hours for a team of 25 resources each week. This entire time was utilized to work on other activities.

• Provided technical support to US-based Technicians of Comcast and troubleshoot customer equipment to ensure operability. Created schedules of technical installations.
• Coordinated timely responses to online customer communication and researched complex issues.
• Maintained and managed customer files and databases.
• Employed comprehensive benchmarks to establish and monitor customer service standards.