Analytics Executive

• Aug 2021 - Present

Worked on long-term project with a pharmaceutical client involving daily CDM refresh, making updates to the python script if any changes requested, and maintaining the database.Created ETL pipeline to prepare master table using python and SQL to calculate revenue, sales, and other business related factors. Used warehouse data to create Power BI dashboards for the stakeholders.Interacted with clients to understand business requirements for reporting and designing the dashboards according to brand guidelines.Created pipelines in ADF and Helped to write stored procedures for the integration project.Designed Power BI dashboards with DAX calculations for hierarchy levels like representatives, managers, and presidents. Worked on normalization tasks to avoid data redundancy and improve the dashboard quality. Show less

Analytics Executive Intern

• Feb 2021 - Jul 2021

Worked on bug fixes in python for an ETL project.Created SOPs for the clients to deliver clear explanation on the process. Worked on Database management.Helped with EDA and data preparation.Took care of daily CDM refresh in UAT and production.Developed project management skills with guidance of a mentor. Worked on the data preparation tasks.

Analytics Executive

• Aug 2021 - Present

Created an automation flows to fetch the data from SharePoint to Power BI using Power Automate and send alert to the stakeholder whenever the dashboard is published. Designed a SharePoint site to trigger Power Automate flows and publish the dashboards. Worked on row level security to SharePoint so that user can access only relatable dashboards. Created an automation flows to fetch the data from SharePoint to Power BI using Power Automate and send alert to the stakeholder whenever the dashboard is published. Designed a SharePoint site to trigger Power Automate flows and publish the dashboards. Worked on row level security to SharePoint so that user can access only relatable dashboards.

Analytics Executive

• Aug 2021 - Present