Jayraj Parsa
Verified Expert in Engineering
Software Developer
Leander, TX, United States
Toptal member since December 27, 2023
Jayraj is a seasoned BI & lead data engineer who transforms complex data into business clarity. With 10+ years of expertise spanning Azure Data Factory, Azure Synapse Analytics, Power BI, SQL Server, Microsoft Fabric, Copilot Studio. He architects robust pipelines and dashboards that drive real decisions. From SAP to cloud-scale data lakes, Jayraj bridges the gap between raw data and strategic insight, delivering clean, reliable solutions that help organizations move faster and smarter.
Portfolio
Experience
- Transact-SQL (T-SQL) - 10 years
- SQL Server Reporting Services (SSRS) - 7 years
- SQL Server Integration Services (SSIS) - 7 years
- Team Foundation Server 2015 - 4 years
- XML - 3 years
- IBM Db2 - 3 years
- Jira - 2 years
- Bitbucket - 2 years
Preferred Environment
SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), Azure Data Factory (ADF), Azure Synapse Analytics, Microsoft Power BI, PySpark, Microsoft Fabric, Git GUI, Microsoft, Microsoft Copilot Studio
The most amazing...
...thing I've accomplished was a data migration project at King County in 12 months, which the previous vendor left unfinished after nearly 5 years.
Work Experience
Data Architect for Technology Consulting Company
Searce Inc. - Main
- Refactored and optimized an existing Sales Order Book SSAS Cube, redesigning the data model, restructuring calculations, and tuning aggregations to deliver faster, more accurate sales reporting.
- Designed and built ETL pipelines integrating three new ERP systems into the data warehouse, engineering a unified Item Master Data model to establish a single source of truth across all sources.
- Designed end-to-end medallion architecture (bronze/silver/gold) pipelines in Microsoft Fabric using Lakehouse, Data Warehouse, and Delta tables for healthcare transaction data.
- Developed custom Copilot Studio agents grounded in enterprise data, configuring topics, generative answers, and knowledge sources for business users.
- Hands-on experience building and troubleshooting Dataflow Gen II pipelines and watermark-driven incremental loads (T-SQL MERGE) across Fabric workloads.
- Integrated Copilot Studio agents with Microsoft Fabric and Azure data sources, enabling natural-language access to semantic models and Lakehouse data.
Data Visualization Expert
Sparq Holdings, Inc. - Main
- Reviewed and upgraded Power BI reports from v48 to v61 and tested them.
- Lead QA and data validation efforts for 10+ existing Power BI reports.
- Collaborated with internal and client teams in a consultative capacity, offering insights and solutions.
Database Engineer
Dermalogica - Main
- Evaluated an on-premises infrastructure and designed an ADF process to replicate the SSIS package and start running on cloud infrastructure. Analyzed and documented end-to-end steps in the process flow for ADF migration.
- Identified and converted the current integrations involving SSIS packages, SQL Server agent jobs, stored procedures, and APIs.
- Evaluated the current infrastructure, identifying all components involved in the migration and acting upon that to ensure a smooth and efficient migration to Azure.
Senior Developer
Child Care Aware of America
- Created a migration strategy for modules like Family, Provider, and Document to support the migration process from Legacy to the new application. Built scripts and automated processes fully for data migration updates on daily and weekly schedules.
- Tracked and fixed bugs using Jira as a reporting tool.
- Oversaw the migration from Legacy to NexGen data flow and flow back from NexGen to Legacy on a few critical data elements.
Senior MS SQL Developer
Child Care Aware of America
- Developed a migration process from legacy to new instance for data sync-up process. Created AWS jobs using AWS Database Migration Service (AWS DMS).
- Fixed data quality issues/cleansing of data prior to migration.
- Completed documentation of the migration process for proper understanding by the end users and technical team.
MS SQL BI Developer | Lead Azure Data Engineer
Center for Creative Leadership
- Led the business operations transformation initiative (BOT). With the help of this project, CCL was able to better serve its clientele through enhanced technology and streamlined internal processes.
- Oversaw and developed the MS SQL Server 2019/2016/2014, Azure, T-SQL, D365 customer engagement, D365 Finance & Operations, MS Access, Azure Data Factory, SSIS, SSRS, Power BI, Azure DevOps, Azure Synapse analytics, storage accounts, and Key Vault.
- Pioneered data migration and integration, requirement analysis, C#, Automate ETL, and SSRS testing. Built ETL pipelines, PowerShell, and Databricks. Developed Power BI reports and SDLC management.
MS SQL Database/Business Intelligence Developer
Key Risk
- Contributed to the decommission of a legacy system that was in place for 25 years and a data migration project for the key risk claims system.
- Tracked and fixed bugs using Jira as a reporting tool, and created Confluence pages.
- Optimized the current month-end process to run under two hours compared to six hours.
MS SQL Database/Business Intelligence Developer
CVS Health
- Developed and created a process that replaced the existing accordant care management system with a new clinical system, EPIC.
- Created a data validation process to compare the existing system and new application.
- Launched a new process with zero errors for a smooth transition.
MS SQL Database/Business Intelligence Developer
King County
- Developed process to move data from legacy system into new application using the data model that was built within new applications.
- Logged users' issues using team foundation server and worked through them.
- Completed the migration in 12 months where 1,200 users can use the new application and write cases.
Experience
Total Enforcement - Records Management System (RMS)
Azure Data Engineer
Education
Master's Degree in Computer Science
City College Of New York - New York, NY, USA
Certifications
Microsoft Azure Data Engineer – Associate (DP-203)
Microsoft | via Coursera
Querying Microsoft SQL Server 2012/2014
Microsoft
Microsoft Certified Technology Specialist: SQL Server 2008 Database Development
Microsoft
Microsoft SQL Server Business Intelligence Development
Microsoft
Skills
Libraries/APIs
Complex SQL Queries, PySpark, Entity Framework
Tools
SQL Server Profiler, Microsoft Power BI, Microsoft Report Builder, Claude, SSAS, Jira, Bitbucket, Stash, TFS, Visual Studio, Visual Studio 2012, VSS, ActiveReports, Azure Key Vault, Microsoft Access, Microsoft Dynamics 365 for Finance and Operations, Visual Studio 2013, Tableau
Languages
SQL, Transact-SQL (T-SQL), XML, Snowflake, Python, C#.NET, C#, Java
Frameworks
Spark, Windows PowerShell, .NET
Paradigms
ETL, Business Intelligence (BI), XP, Azure DevOps
Platforms
Azure, Microsoft Dynamics 365, Oracle, Microsoft Fabric, Visual Studio 2016, Azure Synapse, Azure Synapse Analytics, Windows Server 2019, Windows Server, Azure Service Fabric, Azure Data Lake Storage, Databricks, Windows, Visual Studio 2017, Microsoft, Microsoft Copilot Studio
Storage
Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Databases, Database Migration, Data Pipelines, SQL Server 2017, Azure SQL, Azure SQL Databases, Database Administration (DBA), SQL Server DBA, Data Integration, SQL Server 2012, Database Performance, SQL Performance, SQL Joins, SQL Stored Procedures, Operational Data Store (ODS), Microsoft Entra ID, IBM Db2, JSON, Azure Cloud Services, PostgreSQL, SQL Server Analysis Services (SSAS), SQL Server 2008, SQL Server 2019, SQL Server 2016, SQL Server 2014, MySQL, SSAS Tabular
Industry Expertise
Project Management
Other
Team Foundation Server 2015, Data Engineering, Data Analysis, Backups, Migration, Data Warehousing, Warehouses, Data Migration, ETL Tools, Reporting, Data Cleaning, Data Conversion, Database Analytics, Data, Data Visualization, Dashboards, Debugging, IT Support, Enterprise Resource Planning (ERP), SSRS Reports, Data Architecture, Change Data Capture, Blob Storage, Concurrency Patterns, SQL CTEs, Performance Optimization, Locks, ELT, APIs, ETL Pipelines, Medallion Architecture, Azure Data Factory (ADF), Data Analytics, Data Reporting, Data Modeling, Data Build Tool (dbt), Streaming Data, Microsoft Azure Cloud Server, Microsoft 365, Data Science, FTP, Cloud Platforms, Azure Data Lake, Azure Data Lake Analytics, DAX, API Integration, AWS Database Migration Service (DMS), Cloud Migration, Git GUI, SAP ERP
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring