Think Lens C.

Collaborated with the Product Ownership team to understand and refine User Requirement Specifications (URS) and translate them into detailed Functional Requirement Specifications (FRS) following a waterfall delivery methodology.

Worked across enterprise systems including SAP ECC6, SAP S/4HANA, SAP ECP, and Salesforce (SFDC) to gather, analyze, and document cross-system data requirements.

Led data model design and finalization, including identification of key objects, tables, joins, filters, conditions, and data precedence rules (e.g., prioritizing S/4HANA data over SAP ECC where SDS information is available).

Defined and documented business rules and logic for SDS (Safety Data Sheets) reporting, including:

Tracking missing SDS over the last 12 months

Measuring number of SDS sent

Identifying opportunities through product extensions

Collaborated with technical teams using tools such as DBeaver and Eclipse for data exploration, validation, and query analysis.

Designed Power BI reporting requirements, including:

Report structure, KPIs, measures, and calculated metrics

Field definitions and mapping to destination data model

Filters, slicers, and visuals aligned to business needs

Country/language-specific logic using flat files

Performed data validation and reconciliation post data model integration by testing joins and conditions to ensure accurate data separation and consistency across SAP ECC, S/4HANA, and SFDC sources.

Conducted cross-environment validations (Dev/QA/Prod) to ensure consistency of data and reporting outputs.

Engaged with SAP technical teams to identify and validate key fields (e.g., publishing flags, status indicators) required for SDS tracking and reporting.

Facilitated regular status calls and stakeholder communications to track progress, resolve dependencies, and align on deliverables.

Prepared and conducted JAD (Joint Application Development) sessions, including walkthroughs of requirements, data models with business and technical stakeholders.

Acted as a Data Steward for Material Master data, ensuring data quality, consistency, and governance across enterprise systems including SAP ECC and SAP S/4HANA. Maintained and updated end-to-end data lineage from source to gold layers by validating and documenting source systems, tables, and transformations.

Led Data Quality (DQ) monitoring and remediation through weekly DQ score reviews, root cause analysis, and coordination with business and technical teams to implement corrective actions. Proactively monitored and resolved failed or blocked DQ jobs in Informatica Data Management Cloud (IDMC), ensuring smooth production operations.

Cataloged datasets with missing metadata, defining ownership, classifications, and business definitions before deployment to production. Managed GDO-wise tracking templates to monitor data quality KPIs and governance metrics. Configured and monitored Databricks job schedulers for timely execution of pipelines and DQ processes.

Handled incident management via ADO trackers, ensuring timely resolution within SLA. Participated in daily scrums and governance meetings, providing updates on DQ status and remediation progress.

Collaborated with business SMEs and technical teams to define and enforce data governance standards. Performed data profiling and validation using SQL and Excel to identify anomalies and improve data quality.

Worked across SAP domains including MM, SD, FICO, and PP, ensuring alignment of master data across functions. Utilized Power BI/Tableau for reporting and DQ monitoring dashboards.

Demonstrated strong data stewardship by defining data standards, validating datasets, and maintaining governance documentation while independently managing deliverables.

•Analyzed user complaints, identified root causes in existing reports, and implemented BI enhancements to improve reporting quality.

•Converted legacy Spotfire reports and custom SQL scripts into Tableau dashboards using industry best practices.

•Validated data accuracy in dashboards by verifying record counts, field values, and business rules.

•Identified missing data elements (tables and columns) in GCP and collaborated with data engineers to incorporate them.

•Interacted with business users to gather requirements, prioritize key functionalities, and incorporate them into dashboards.

•Replicated and enhanced key Spotfire features (marking, filters, action controls, buttons, conditional logic) using Tableau capabilities.

•Worked within Agile methodologies using Azure DevOps for sprint planning, PI planning, backlog grooming, and progress tracking.

•Participated in daily stand-ups, user story grooming sessions, review meetings, and report walkthroughs to ensure alignment with business needs.

•Conducted stakeholder walkthroughs comparing Spotfire and Tableau reports and gathered feedback for improvements.

•Managed pre-production deployments, performed thorough testing, and incorporated user feedback post-deployment.

•Delivered executive-level reporting solutions that enhanced decision-making and improved supply chain visibility