Ajay Raina

Designed the Power BI semantic model behind executive KPI dashboards, applying Fabric-aligned modeling practices: around 10 KPIs in one governed model serving 20+ reports. Led a team of 3 on source-to-table design and mentored engineers across SQL Server and Power BI.

Led a team of 4 across SQL Server, Oracle and Power BI, and owned source-to-target data flow design for 100+ tables across the RDARR, IFRS and Wealth lines of business, engaging directly with source teams. Authored STTM documentation and identified data gaps ahead of ingestion into the centralized database, preventing downstream rework.

Led a team of 8 to design a self-service masking framework: DBAs supply the object list and the framework applies masking automatically across SQL Server, Oracle and Snowflake, covering 10+ databases. Designed an automated detection process that flags any sensitive data left unmasked, giving compliance teams continuous assurance.

Led data mapping and modeling for Guidewire policy-center-to-data-hub migrations, enabling downstream data science consumption. Transition lead for the annual SA tax reporting system; documented functional and technical scope and designed the upgrade path from SQL Server 2008 to 2016. Designed an ETL framework and data mart for global e-medicine tracking, built for Power BI reporting and restartab

Analyzed and maintained ETL processes (PETL, SSIS) feeding the enterprise data warehouse for a leading mobile-insurance provider; designed new data models, resolved client-reported data issues and mentored the technical team.

Built SSRS reporting on high-volume customer-care data and monitored supporting SQL jobs.

Built SSIS packages and SSRS reports and provided production support through stabilization.

Developed OSS modules and GUI forms and migrated legacy code from VB6 to T-SQL.

Grade: First Class

Master of Computer Applications in Computer Science from the University of Jammu, completed with First Class.

Bachelor of Science in Electronics from the University of Jammu.