Namrata K

About

Data Analyst with 2+ years of experience delivering analytics automation, reporting, and process improvement solutions for enterprise finance operations. Experienced in SQL, Excel, ETL workflows, and automation across the full Robotic Process Automation (RPA) lifecycle—from requirements gathering and business rule analysis to deployment, production support, and data validation. Skilled at working with cross-functional stakeholders to ensure data quality, reporting accuracy, and alignment between business processes, automation, and operational requirements in fast-paced delivery environments.

Skills & Expertise (22)

SQL Intermediate

7.8/10

2

Years Exp

Power Automate Advanced

7.3/10

2

Years Exp

Excel Advanced

7.3/10

2

Years Exp

Power Query Advanced

7.3/10

2

Years Exp

Pivot Tables Advanced

7.3/10

2

Years Exp

Power BI Intermediate

6.3/10

2

Years Exp

EDA Intermediate

6.3/10

2

Years Exp

Matplotlib Intermediate

6.3/10

2

Years Exp

NumPy Intermediate

6.3/10

2

Years Exp

Pandas Intermediate

6.3/10

2

Years Exp

Python Intermediate

6.3/10

2

Years Exp

Jira Intermediate

6.3/10

2

Years Exp

Google Sheets Intermediate

6.3/10

2

Years Exp

DAX Intermediate

6.3/10

2

Years Exp

Data Pipelines Intermediate

6.3/10

2

Years Exp

ETL Intermediate

6.3/10

2

Years Exp

Data Reconciliation Intermediate

6.3/10

2

Years Exp

Data Quality Intermediate

6.3/10

2

Years Exp

Data Transformation Intermediate

6.3/10

2

Years Exp

Data Cleaning Intermediate

6.3/10

2

Years Exp

Exploratory data analysis Intermediate

6.3/10

2

Years Exp

n8n Intermediate

5.3/10

2

Years Exp

Work Experience

Process Automation Analyst | Automation & Analytics

Consero Global Solutions

Sep 2021 - Sep 2022

Delivered analytics automation and financial reporting solutions for 36+ commercial and non-profit clients, contributing to process improvements equivalent to 10+ FTE savings. Participated in the full RPA lifecycle, including requirements gathering, process documentation (PDD), bot development, deployment, maintenance, and production support. Collaborated with business analysts to refine business rules and redesign automation logic when production outcomes did not align with operational requirements, improving automation accuracy and process reliability. Built and maintained Power Automate, Power Query, and Excel-based automation workflows for bank statement processing, financial transformation, and reporting. Standardised 50+ bank statement formats into consistent BI-ready datasets supporting downstream reporting, reconciliation, and analytics. Improved AP/AR ageing and KPI reporting performance by redesigning Power Query transformations, reducing execution time from 45 minutes to approximately 30 seconds across datasets ranging from 800 to 15,000+ rows. Managed automation onboarding across 50+ stakeholders during multiple rollout phases by defining standardised input formats, documenting automation requirements, assessing process suitability, and supporting adoption. Investigated data mismatches across bank statements, AP/AR records, and source systems using validation and reconciliation techniques to improve reporting reliability. Supported SQL-based data analysis and data migration by writing joins, aggregations, and validation queries to extract, reconcile, and verify datasets across enterprise systems. Performed data cleaning, transformation, and basic ETL tasks on large datasets; created Excel-based reports and dashboards for internal stakeholders. Worked within enterprise data environments, supporting ETL workflows, database operations, and SQL performance monitoring to ensure reliable data processing. Delivered data analysis and reporting support in a fully remote setup, coordinating work through documented requirements, structured handoffs, async communication and Jira-based issue tracking.

Data Analyst

_VOIS (Vodafone)

Sep 2021 - Sep 2022

Delivered analytics automation and financial reporting solutions for 36+ commercial and non-profit clients, contributing to process improvements equivalent to 10+ FTE savings. Participated in the full RPA lifecycle, including requirements gathering, process documentation (PDD), bot development, deployment, maintenance, and production support. Collaborated with business analysts to refine business rules and redesign automation logic when production outcomes did not align with operational requirements, improving automation accuracy and process reliability. Built and maintained Power Automate, Power Query, and Excel-based automation workflows for bank statement processing, financial transformation, and reporting. Standardised 50+ bank statement formats into consistent BI-ready datasets supporting downstream reporting, reconciliation, and analytics. Improved AP/AR ageing and KPI reporting performance by redesigning Power Query transformations, reducing execution time from 45 minutes to approximately 30 seconds across datasets ranging from 800 to 15,000+ rows. Managed automation onboarding across 50+ stakeholders during multiple rollout phases by defining standardised input formats, documenting automation requirements, assessing process suitability, and supporting adoption. Investigated data mismatches across bank statements, AP/AR records, and source systems using validation and reconciliation techniques to improve reporting reliability. Supported SQL-based data analysis and data migration by writing joins, aggregations, and validation queries to extract, reconcile, and verify datasets across enterprise systems. Performed data cleaning, transformation, and basic ETL tasks on large datasets; created Excel-based reports and dashboards for internal stakeholders. Worked within enterprise data environments, supporting ETL workflows, database operations, and SQL performance monitoring to ensure reliable data processing. Delivered data analysis and reporting support in a fully remote setup, coordinating work through documented requirements, structured handoffs, async communication and Jira-based issue tracking.