
Ajay Raina
@ajayraina
Enterprise Data Architect | Microsoft Fabric & Cloud Modernization | 16+ Yrs Enterprise Warehousing & Data Governance | Medallion & Direct Lake Expert
What I'm looking for
With over 16 years of experience driving enterprise data strategy, cloud modernizations, and platform governance, I specialize in transforming fragmented database landscapes into high-performance, secure, and AI-ready SaaS analytics ecosystems. My career bridges the gap between traditional enterprise data warehousing and cutting-edge cloud architectures—most recently focusing on building scalable frameworks within the Microsoft Fabric ecosystem.
As a Technical Manager and Solution Architect, I don't just engineer data movement; I design comprehensive blueprints that balance high-speed computation with financial guardrails and strict security compliance. I have a proven track record of guiding global enterprise clients through the architectural shifts required to transition legacy SQL Server, Oracle, and SSIS environments into modern, cloud-native structures.
Core Architectural Specializations:
• Microsoft Fabric Platform Design: Designing unified enterprise SaaS data estates using OneLake architecture, Medallion storage footprints, and PySpark notebooks.
• Performance Optimization: Engineering high-throughput Direct Lake semantic models utilizing V-Order byte alignment to stream multi-million row datasets instantly into memory, eliminating import latency.
• Capacity Management (Cost Control): Managing enterprise F-SKUs, optimizing compute distribution, and leveraging native smoothing and throttling patterns to prevent infrastructure bottlenecks while protecting operational budgets.
• Enterprise Governance & Security: Architecting highly automated, self-service Dynamic Data Masking (DDM) frameworks across multi-database environments (Snowflake, Oracle, SQL Server) and integrating Microsoft Purview for end-to-end data lineage tracking.
• Technical Leadership: Heading and mentoring cross-functional engineering teams, defining source-to-target mapping (STTM) schemas, and managing business stakeholder communication.
I am passionate about helping enterprise organizations unlock the true value of their data at scale without sacrificing security or inflating operational overhead.
Let’s connect to discuss modern cloud data design patterns, data mesh strategies, or enterprise Microsoft Fabric modernizations.
Experience
Work history, roles, and key accomplishments
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.
Education
Degrees, certifications, and relevant coursework
University of Jammu
Master of Computer Applications, Computer Science
2006 - 2009
Grade: First Class
Master of Computer Applications in Computer Science from the University of Jammu, completed with First Class.
University of Jammu
Bachelor of Science, Electronics
2003 - 2006
Bachelor of Science in Electronics from the University of Jammu.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Job categories
Skills
Interested in hiring Ajay?
You can contact Ajay and 90k+ other talented remote workers on Himalayas.
Message AjayGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
