Jayraj Parsa, Developer in Leander, TX, United States
Jayraj is available for hire
Hire Jayraj

Jayraj Parsa

Verified Expert  in Engineering

Bio

Jayraj is a highly skilled and accomplished Microsoft SQL business intelligence developer with over a decade of experience working in the information technology sector. He's adept at partnering with business leaders to identify needs, define strategy, and implement the delivery of tools, systems, interfaces, and analytics to measure business against goals and facilitate business decisions. Jayraj has the proven ability to understand new technologies and best practices quickly.

Portfolio

Dermalogica - Main
SQL Server Integration Services (SSIS), Oracle, SQL, Azure, Azure SQL Databases...
Key Risk
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)...
Child Care Aware of America
SQL, Microsoft SQL Server, T-SQL (Transact-SQL), C#, .NET, Java, MySQL...

Experience

  • T-SQL (Transact-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

Availability

Full-time

Preferred Environment

SQL Server Integration Services (SSIS), Bitbucket, IBM Db2, TFS, XML, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), Snowflake

The most amazing...

...thing I've been able to finish was a data migration project at King County in 12 months, which the previous vendor left unfinished after nearly five years.

Work Experience

Database Engineer

2024 - PRESENT
Dermalogica - Main
  • Evaluated on-prem infrastructure and designed 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.
Technologies: SQL Server Integration Services (SSIS), Oracle, SQL, Azure, Azure SQL Databases, Azure Data Factory (ADF), Cloud Migration, Data Integration, Cloud Platforms, SQL Server 2012, Data, Database Performance, SQL Performance

MS SQL Database/Business Intelligence Developer

2018 - PRESENT
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.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Jira, Bitbucket, TFS, IBM Db2, T-SQL (Transact-SQL), Visual Studio, Microsoft SQL Server, ETL, Data Engineering, SQL Server 2017, Data Migration, Windows Server, ETL Tools, PostgreSQL, SQL, SSAS, Oracle, Reporting, FTP, Database Administration (DBA), SQL Server DBA, Project Management, Data Integration, SQL Server 2012, Database Analytics, Data, Microsoft Power BI, Data Visualization, Dashboards

Senior Developer

2024 - 2024
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.
Technologies: SQL, Microsoft SQL Server, T-SQL (Transact-SQL), C#, .NET, Java, MySQL, AWS Database Migration Service (DMS), Windows PowerShell, SQL Server DBA, Project Management, Data Integration, SQL Server 2012, Database Analytics, Data, Microsoft Power BI, Data Visualization, Dashboards, Database Performance, SQL Performance

Senior MS SQL Developer

2024 - 2024
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.
Technologies: SQL, Microsoft SQL Server, T-SQL (Transact-SQL), C#, .NET, Java, MySQL, AWS Database Migration Service (DMS), Database Administration (DBA), Project Management, Data Integration, SQL Server 2012, Database Analytics, Data

MS SQL BI Developer | Lead Azure Data Engineer

2020 - 2024
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.
Technologies: SQL Server 2016, SQL Server 2019, Azure Synapse Analytics, Microsoft Dynamics 365, Microsoft Dynamics 365 for Finance and Operations, Microsoft Access, T-SQL (Transact-SQL), Visual Studio 2013, Azure Data Factory (ADF), Azure DevOps, Visual Studio 2017, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure, Microsoft Power BI, Azure Key Vault, SQL Server 2014, Data Engineering, Data Analytics, Data Reporting, ETL, JSON, Python, Databases, Data Analysis, Tableau, Backups, Migration, Database Migration, Windows Server 2019, Data Modeling, Warehouses, Data Pipelines, Data Build Tool (dbt), SQL Server 2017, Data Migration, Windows Server, Microsoft SQL Server, ETL Tools, Azure Cloud Services, Streaming Data, Azure SQL, Microsoft Azure Cloud Server, SQL, Microsoft 365, Data Science, Reporting, Windows PowerShell, Data Cleaning, Data Conversion, Database Administration (DBA), SQL Server DBA, PySpark, Cloud Platforms, Azure Service Fabric, SQL Server 2012, Azure Data Lake Storage, Database Analytics, Azure Data Lake Analytics, Data, Data Visualization, Dashboards, DAX, Database Performance, SQL Performance

MS SQL Database/Business Intelligence Developer

2017 - 2018
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.
Technologies: SQL Server Profiler, TFS, VSS, XP, Windows, C#, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2012, SQL, ETL, Data Engineering, SQL Server 2017, Data Migration, Windows Server, Microsoft SQL Server, ETL Tools, Reporting, Data, Data Visualization, Dashboards, Database Performance, SQL Performance

MS SQL Database/Business Intelligence Developer

2012 - 2017
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.
Technologies: T-SQL (Transact-SQL), Visual Studio, ActiveReports, SQL Server Profiler, TFS, C#, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2008, ETL, Data Engineering, Data Migration, Windows Server, Microsoft SQL Server, ETL Tools, SQL, SQL Server Analysis Services (SSAS), Reporting, Data, Data Visualization, Database Performance, SQL Performance

Experience

Total Enforcement - Records Management System (RMS)

A records management system where cops can write cases and secure property. I was the back-end developer and liaised with the front-end developer to design a data model and migrate data from a legacy application to the new system and integrate external tools that used for display and for full customization of data views.

Azure Data Engineer

Dermalogica is a global leader in personal care products, operating in more than 80 countries. The project involves migrating four on-premises servers hosting various applications, databases, and integration jobs to Microsoft Azure.

Education

2007 - 2009

Master's Degree in Computer Science

City College Of New York - New York, NY, USA

Certifications

DECEMBER 2024 - PRESENT

Microsoft Azure Data Engineer – Associate (DP-203)

Microsoft | via Coursera

APRIL 2015 - PRESENT

Querying Microsoft SQL Server 2012/2014

Microsoft

JUNE 2011 - PRESENT

Microsoft Certified Technology Specialist: SQL Server 2008 Database Development

Microsoft

JUNE 2009 - PRESENT

Microsoft SQL Server Business Intelligence Development

Microsoft

Skills

Libraries/APIs

PySpark

Tools

SQL Server Profiler, Microsoft Power BI, 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, T-SQL (Transact-SQL), XML, Snowflake, C#, Python, Java

Paradigms

ETL, XP, Azure DevOps

Platforms

Azure, Oracle, Visual Studio 2016, Windows Server 2019, Windows Server, Azure Service Fabric, Azure Data Lake Storage, Windows, Azure Synapse, Azure Synapse Analytics, Microsoft Dynamics 365, Visual Studio 2017

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, 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

Frameworks

Windows PowerShell, .NET

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, 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, AWS Database Migration Service (DMS), Cloud Migration

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring