Payel Mukhopadhyay

As a Data Analyst at GSK in the Human Biological Samples Management Consumption Domain, I played a pivotal role in various initiatives:

Data Warehouse Design & Implementation: Led the creation of a data warehouse that aligned with GSK’s business goals and technical architecture, ensuring data consistency, quality, and seamless integration across domains.

Azure Data Fabric Development: Architected a scalable Data Fabric to centralize bio-repository data supporting clinical trials and drug discovery. This integration improved research workflows and contributed to vaccine development and clinical trials.

Collaboration with Cross-functional Teams: Worked closely with Product Owners and Business Analysts to translate business requirements into actionable data models. Integrated these models with BI tools like Power BI and Celonis, delivering real-time insights.

“Data as a Product” Philosophy: Managed data as a strategic asset, ensuring high-quality, accessible data that aligned with business needs and SLAs. Focused on data governance, usability, and continuous delivery.

Agile Methodology & Backlog Management: Managed the Agile backlog, prioritized tasks, and tracked progress using JIRA, ensuring timely delivery of critical features after discussing them with PO.

Data Modeling & Pipeline Development: Designed scalable data models in Erwin and collaborated with ETL teams to develop automated data pipelines using ADF, Talend, Databricks, Snowflake, and MS SQL Server. Developed interactive Power BI dashboards to support data-driven decision-making.

Functional Specifications & Documentation: Created detailed design documentation and data transformation rules and business requirements to ensure scalability and traceability for all the change requests.

Release Coordination: Managed deployments and mitigated risks, ensuring error-free releases and smooth integration of updates and coordinated with End User for hassle free release.

As a Senior Functional Analyst in Johnson & Johnson in Artemis Project, main responsibility was to understand the complex business requirement and then Communicating the same in technical terms to ensure product features objectives are met in each Sprint.
Responsible for sprint delivery, code deployment to higher environments, story completion, maintaining development and testing code standard.
Create and maintain design specification documents and data lineage.
Design and code review for all the job/workflows developed in Data Build Tool(DBT) ETL Tool.
Coordinate with BAs, BPO and other stakeholders to continue project delivery. Leads a team of 25 associates across multiple geographies - UK, USA, & India.

As a Business Analyst - Johnson & Johnson - OneMD( Robotic Surgery Project, collaborated with business and technical teams to align on product feature objectives.Prioritizing feature and story requirements for each sprint, understanding business priorities, and leading sprint planning and daily scrum meetings..
Analysed the data and gathered users requirements using business use cases, mock up and elicitation meetings, created and maintained business requirements specification documents and prepare simple Tableau reports for supporting and understanding business requirements.
Transformed complex business needs into detailed Functional and Non-Functional Specifications, ensuring alignment with data warehouse architecture and downstream BI/reporting tools.
Worked closely with data architects and ETL developers to validate source-to-target mappings for key datasets, including SAP, Salesforce, and legacy systems across EMEA markets.
Supported the design and testing of data models and data marts, ensuring accurate representation of sales metrics, customer profiles, product categories, and rebate calculations.
Conducted data quality assessments and gap analysis to identify inconsistencies in
customer master data, rebate eligibility, and product coding across different regions. Enabled self-service analytics by collaborating with Power BI developers, defining KPI logic and dashboard wireframes for commercial and regional leadership.
Managed stakeholder expectations across multiple EMEA markets, ensuring clear communication, timely delivery of milestones, and alignment with compliance and data privacy standards.
Provided ongoing support during UAT and production rollout, including test case validation, issue resolution, and user training sessions.
Created detailed process flows and user stories to document system requirements and design solutions.

As a Technical Team Lead and Onsite coordinator for Change Management - Medical Devices, JNJ, I have lveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
As onsite Coordinator, successfully managed a Team of 7-8 resources and able to met deliverables as per project commitment.
Developed and monitored key performance indicators (KPIs) to assess team effectiveness.
Reviewed completed work to verify consistency, quality, and conformance. Forecasted and planned accordingly to efficiently manage the workload within the team.
Worked on preparing design, process flow diagram, job design, Data validation after developing the code. ETL code review and prepare cut over plan for Production Deployment for CR.
Built and maintained relationships with Product Owner and Business Analyst and other Team Members from different Vendors.

As a Talend ETL Developer for building Data warehouse - Medical Devices, JNJ, I have participated in the Development for a data warehousing environment, with expertise in: CDC, type-2 processing, dimensional surrogate key handling, exception data processing, etc.
Talend Job Design and develop ETL process using - Talend jobs/work-flow, PL/SQL code write for Redshift and Postgre Database, Production Job scheduling through Control-M/Tidal, CICD pipeline, BitBucket repository along with code-base. Support other ETL developers; technical assistance, Bugfix, troubleshooting and alternative development solutions.