Analyst, Data Analytics
Covasant Technologies Pvt. Ltd. (formerly Dcube Data Sciences LLP) · Dec 2022 – Present
- Build and run the SQL-based data pipeline behind an in-house financial-fraud-detection application, processing SAP-sourced data through five stages data import, data quality, staging, completeness, and mapping before risk scoring.
- Design and apply data-quality and validation rules across incoming datasets: field-length checks against source-system standards (e.g., SAP vendor numbers required at 10 characters), data-type and conversion validation, numeric/amount checks, and date-format checks flagging and resolving records that fail validation.
- Coordinate data loads and ingestion using the SSMS Import/Export Wizard and SSIS (including SSIS fuzzy-matching), and consolidate multiple source files and tables (for example, combining multiple REGUP extracts) into unified staging tables.
- Run data-completeness checks identifying orphaned vendors and missing attributes required for analysis and map data from multiple SAP tables into a single consolidated table for reporting.
- Develop SQL scoring algorithms that flag transactions against defined risk logic, surfacing the results in Power BI dashboards embedded in the in-house product.
- Contribute substantially to application feature development, enhancements, and client-requirement implementations across the platform.
- Sole owner of database deployments for the team single-handedly executed numerous releases, including large version deployments involving full schema-drift changes across environments.
- Migrated reporting dashboards from Sisense to Power BI, redesigning the reporting layer to improve performance and enable self-service analysis.
- Investigated and resolved data issues across production and non-production environments with development and business teams, and tuned slow SQL queries using execution-plan analysis.

