Oracle SQL & Data Analysis
· Develop, optimize, and troubleshoot complex Oracle SQL queries.
· Analyze large volumes of customer, billing, payment, usage, and transactional data.
· Work with joins, subqueries, CTEs, analytical functions, views, stored procedures, and PL/SQL where required.
· Perform data reconciliation across multiple systems and identify discrepancies.
· Conduct root-cause analysis for data and billing-related issues.
· Support production investigations and customer-impact analysis.
· Optimize SQL queries for performance when working with large datasets.
·
Python & Automation
· Use Python for data extraction, cleansing, transformation, validation, and analysis.
· Develop reusable scripts to automate recurring analytical and reconciliation activities.
· Work with libraries such as Pandas, NumPy, openpyxl, and Oracle database connectivity libraries.
· Process large datasets from databases, CSV files, Excel files, and other structured sources.
· Automate operational reports and data-quality checks.
· Build utilities to compare datasets across different systems and identify mismatches.
·
Ensemble Billing
· Strong understanding of Ensemble Billing and associated billing processes.
· Analyze customer accounts, billing transactions, charges, adjustments, payments, and billing events.
· Investigate billing discrepancies and support root-cause analysis.
· Understand end-to-end billing flows and dependencies between upstream/downstream systems.
· Support billing reconciliation and validation after system or configuration changes.
· Work closely with billing, operations, application, and business teams to resolve billing-related issues