Prangshu Mitra
Mississauga
Summary
Prangshu Mitra has 12+ years of experience in data warehousing while performing various roles as BI developer, Data engineer, Module lead, BI lead with good command over ETL logic and modeling concepts for building BI reports. Presently in a client facing role at onshore and directly working with customers to develop BI strategy and roadmap. Supported multiple RFPs (request for proposal) and estimations efforts. Experience and result-driven Power BI Solution architect in designing and implementing enterprise level BI solutions. Proven expertise in Power BI data modeling, DAX, Azure services and stakeholder engagement. Worked for translating business requirements into scalable and secure data solution that drive strategic decision making.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Power BI Solution Architect
Cognizant Technology Solutions
03.2023 - Current
- Requirements gathering and understanding business needs. Developed complex dashboards based on business requirements using Power BI desktop for insurance data.
- Designed and implemented enterprise-wide Power BI architecture.
- Developed calculated measures using data analysis expression language (DAX).
- Worked on all types of transformations using Power BI Query editor.
- Implemented static and dynamic row level data security (RLS) for Power BI reports and worked for report deployment.
- Designed and developed reusable data models to standardize reporting across business units.
- Data profiling and cleaning
- Content migration across all the environments such as DEV, QA, and PROD.
- QA and UAT support.
- Responsible for providing solution inputs for proposal and supports effort, cost and resource estimation based on the project.
- Led migration from legacy reporting tools to Power BI.
Power BI Consultant
Cognizant Technology Solutions
01.2021 - 02.2023
- Developed multiple dynamic dashboards using Power BI desktop.
- Used/created various data sources to extract data into Power BI desktop from Oracle, DB2, Snowflake, Power BI datasets, Power BI dataflow, Azure databases etc.
- Used various Power BI DAX functions to create the calculations and derived fields.
- Used DAX Studio for Query generation and semantic data model optimization.
- Published Power BI dashboards in web clients and mobile apps.
- Delivered end to end BI solutions for Insurance clients.
- Automated data refresh using Power BI Automate.
Power BI Developer
Cognizant Technology Solutions
07.2016 - 01.2021
- MicroStrategy to Power BI Migration projects- MicroStrategy to Power BI was the conversion project. Almost 450 MicroStrategy reports were converted into Power BI. I worked on building the data model in Power BI and Implemented the complex logic in Power BI to replicate the same functionality of MicroStrategy like Consolidation, Custom Group etc.
- Actuate to Power BI Migration projects - Actuate to Power BI was the conversion project. Almost 250 Actuate reports were converted in Power BI. I worked on building the data model in Power BI and Implemented the complex logic in Power BI to replicate the same functionality of Actuate.
System Engineer
Tata Consultancy Services Limited
02.2013 - 07.2016
- ETL and BI Report developer.
- Worked for Cube refresh. Building & maintenance of mdc, IQD files.
- Worked for report and cube scheduling.
- Developed Star & Snowflake schema in Framework Manager.
- Jasper to Cognos Migration.
- BI report development in Jaspersoft iReport studio, data source creation and SQL query framing.
- Autosys JIL modification. Scheduling & monitoring Autosys jobs.
Education
Bachelor of Technology - Electronics and Communication Engineering
Skills
- Power BI Architecture & Governance
- Data Modeling & DAX
- ETL Pipeline
- Data Warehousing
- Performance optimization
- Stakeholder management
- Security & Compliance (Row Level Security, Data Masking)
- Azure services
- SQL DB
- Agile Practices
- SQL Query framing
- Power BI services (Workspace)
Certification
- 1Z0-051Oracle Database 11g:SQL Fundamentals
- Azure Data Fundamentals
- SAFe 4 Practitioner
- ITIL
- Bigdata-IBM Infosphere Big Insights Technical Professional v2
Languages
English
Full Professional
Additional Information
Canadian Permanent Resident
Timeline
Senior Power BI Solution Architect
Cognizant Technology Solutions
03.2023 - Current
Power BI Consultant
Cognizant Technology Solutions
01.2021 - 02.2023
Power BI Developer
Cognizant Technology Solutions
07.2016 - 01.2021
System Engineer
Tata Consultancy Services Limited
02.2013 - 07.2016