Nikhil Rajpuroh

Data analyst

Qatar Airways • Tiempo completo

Nov 2025 - Present • 8 mos

Performed data cleansing, standardization, and validation on Oracle EBS (R12) data, identifying duplicate, inactive, incorrect, and missing records to improve master data quality and migration readiness. • Supported Oracle EBS to Oracle Fusion Cloud migration activities by assisting with data mapping, gap analysis, reconciliation, and identifying inconsistent or incomplete data across business functions. • Extracted, transformed, and validated large datasets using SQL queries, ensuring data accuracy, completeness, and compliance with business requirements. • Utilized Python for data cleansing, automation, reporting, and data quality checks, including handling null values, duplicate detection, fuzzy matching (FuzzyWuzzy), and importing/exporting data from SQL databases. • Developed automated data validation and reporting processes using Python, reducing manual effort and improving data quality monitoring. • Created Power BI dashboards and reports to analyze data quality metrics, visualize cleansing results, track migration progress, and provide actionable insights to stakeholders. • Collaborated with Finance, Procurement, and IT teams to resolve data issues, align business rules, and ensure adherence to data governance and compliance standards. • Validated and enriched data by cross-checking records against internal policies, business rules, and reference sources prior to migration. • Applied advanced Excel techniques including Pivot Tables, Conditional Formatting, Lookup Functions, and Data Validation to identify inconsistencies, missing values, and data quality issues. • Demonstrated understanding of Oracle ERP data structures including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), and Chart of Accounts (CoA). • Worked with project management data structures such as Work Breakdown Structure (WBS) and Cost Codes to support project-related data analysis and migration activities.