
U Singh
Excel and Python Business Automation Specialist
Kompetenzen

Arbeitserfahrung
Business Automation Developer (Insurance Analytics)
Independent
Jun 2017 - Present • 9 yrs 1 mo
I bring extensive experience building and validating Excel and Python automation in high-stakes insurance environments—where messy data, complex rules, and strict accuracy requirements mirror real-world business challenges. What I’ve built: Excel Automation: • Advanced lookup formulas across large, multi-source datasets • Conditional formatting to flag anomalies and exceptions • Dynamic templates enabling consistent decision-making • Data validation systems to prevent downstream errors Python Data Processing: • Automated cleaning of inconsistent, multi-source datasets • Rule-based fraud detection handling 10,000+ records weekly • Batch processing across CSV, Excel, and text files • Robust exception handling for missing and inconsistent data Automated Reporting & Triggers: • Auto-generated workload and performance reports • Red-flag alert systems based on business rules • Dashboards that update dynamically with new data • Consolidated reporting across multiple data sources Data Cleaning & Transformation: • Standardization of inconsistent data across teams and periods • Deduplication logic across overlapping systems • Data quality checks beyond manual review capabilities • Structuring unorganized data into analysis-ready formats Why this matters: I’ve worked with legacy systems, messy exports, and workflows combining automation with human decision-making. I build solutions that handle real-world complexity—designed to scale, adapt, and perform reliably beyond ideal conditions.