About Kiran
English
Native or bilingual
French
Fluent
Experience
- adpSenior AnalystAugust 2025 - Today (10 months)I work as a Senior Analyst at ADP, where I analyze complex data to generate strategic insights.I help companies optimize their performance through data-driven solutions and effective dashboards.
- UCB BelgiumSenior Data Analyst – (Patient Experience & Content Management)PHARMACEUTICALS INDUSTRYNovember 2024 - April 2025 (5 months)
- Designed and maintained robust Power BI dashboards using Power Query for data transformation and DAX for advanced business logic, enabling stakeholders to monitor content engagement KPIs across 15+ patient websites in real time.
- Created automated reporting pipelines by combining SQL (Snowflake/BigQuery) and Power Query to extract and model content approval and publishing data, reducing manual reporting time by 40%.
- Integrated data from Salesforce Marketing Cloud, Google Analytics 4, and internal CMS platforms using Power Query and custom SQL connectors, enabling holistic measurement of digital patient experience.
- Partnered with content, marketing, and MLR teams to build a centralized content performance model in Power BI, using DAX to measure metrics like average time to publish, bounce rates, and patient journey drop-offs.
- Worked cross-functionally with medical and regulatory teams to audit content readiness and ensure publication timelines adhered to compliance SLAs, leveraging SQL to flag outdated or stalled assets.
- Developed self-serve dashboards and reports that empowered non-technical stakeholders to drill into content KPIs by country, therapy area, or campaign — reducing ad hoc data requests by 50%.
- Conducted deep-dive analysis of the content lifecycle (ideation → approval → publication) using SQL queries to identify delays, redundancies, and compliance risks across global markets.
- AutonePower BI Data AnalystRETAIL (SMALL BUSINESS)September 2023 - April 2024 (7 months)- Designed and deployed interactive Power BI dashboards to monitor SKU-level inventory health, enabling fashion retailers to reduce stockouts and overstock by up to 30%.- Leveraged Power Query and DAX to transform and model large datasets from ERP, eCommerce, and logistics platforms, providing stakeholders with real-time insights into supply chain bottlenecks and fulfillment performance.- Built automated data pipelines using SQL and Power BI Dataflows to aggregate data from warehouses, Shopify, and inventory management systems for daily sales, returns, and demand forecasts.- Created custom DAX measures to support advanced analytics features like cohort analysis, days of supply, and restocking efficiency — supporting strategic inventory planning decisions.- Implemented self-serve reporting solutions with row-level security and parameterized views, empowering regional teams to access and filter insights by warehouse, store, or brand.
Reviews
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MSc in International ManagementIMTBS2020I am proud to be a recent graduate of the Master of Science in International Management program. My studies were designed to provide a comprehensive understanding of the global business world, with a focus on international markets and cross-cultural communication. The program covered topics ranging from financial management to global marketing strategies, equipping me with the knowledge and skills I need to succeed in today's interconnected and diverse business environment.
Certifications
- MySQL for Data Analytics and Business IntelligenceUdemy2023
- Advanced PythonDigital Nest2020