Jayraj Parsa
Austin,TX
Summary
Azure Lead Data Engineer/Architect with over 13 years of expertise in database management, business intelligence, and data engineering. Proficient in delivering end-to-end data solutions using Azure Data Factory, MS SQL Server, and Power BI. Adept at designing scalable architectures, optimizing ETL pipelines, and integrating diverse data sources to drive operational efficiency and strategic insights.
Overview
14
14
years of professional experience
1
1
Certification
Work History
MS SQL BI Engineer/Lead Data Engineer
CCL
Greensboro, NC
08.2020 - Current
- Spearheaded data migration projects, leveraging Azure tools for seamless integration
- Built robust ETL pipelines and Power BI reports to improve data accuracy and accessibility
- Architected Azure-based solutions, optimizing performance and streamlining operations
- Enhanced database performance through advanced T-SQL optimization
- Collaborated with cross-functional teams to align technical implementations with business goals
- Automated key workflows, reducing manual intervention by 40% and saving 200+ hours annually
- Designed a centralized metadata repository, improving data governance and traceability
MS SQL Database/Business Intelligence Developer
Key Risk
Greensboro, NC
10.2018 - 07.2020
- Designed and optimized ETL processes with SSIS and Azure Data Factory
- Delivered actionable insights through Power BI dashboards and dynamic reporting
- Implemented centralized metadata repositories for improved operations
- Enhanced query performance and reduced execution times with optimized T-SQL
- Developed dynamic Power BI dashboards, enabling real-time decision-making for leadership
- Improved ETL processing speed by 30% through advanced optimization techniques
MS SQL Database/Business Intelligence Developer
CVS Health
Greensboro, NC
06.2017 - 09.2018
- Automated and optimized ETL workflows for data integration efficiency
- Developed Power BI reports to improve decision-making processes
- Streamlined data pipelines, reducing processing time and improving accuracy
- Established a framework for real-time analytics, boosting operational efficiency by 25%
MS SQL Database/Business Intelligence Developer
King County
Seattle, WA
08.2012 - 05.2017
- Created Star and Snowflake schemas for data warehouse solutions
- Built predictive analytics models and automated dashboards for strategic insights
- Conducted data quality audits, ensuring accurate reporting and analytics
- Led a cross-departmental initiative to standardize reporting, reducing redundancy by 50%
SQL Business Intelligence Developer/Data Analyst
Cleveland Clinic
Cleveland, OH
07.2011 - 08.2012
- Enhanced system performance through optimized SQL solutions
- Designed automated reporting frameworks for efficient data delivery
- Implemented data validation protocols, reducing reporting errors by 20%
Education
Master of Science - Computer Science
CUNY New York City College of Technology
NYC, NYSkills
- RDBMS: MS SQL Server (2000-2019), Oracle, MS Access, DB2, Azure
- Data Modeling Tools: MS Visio, ER Studio, ERWIN
- Programming Languages: SQL, T-SQL, PL/SQL, C#Net, ASPNet, PowerShell, XML
- ETL Tools: SSIS, Azure Data Factory, Synapse Analytics, Pentaho, BCP
- Reporting Tools: Power BI, SSRS, Crystal Reports, Power Apps
- Source Control: GitHub, TFS, VSS
- Methodologies: Agile
Certification
- Azure Data Engineer Associate, DP-203
- Technology Specialist (MCTS) in Querying Microsoft SQL Server 2012/2014, 70-461
Timeline
MS SQL BI Engineer/Lead Data Engineer
CCL
08.2020 - Current
MS SQL Database/Business Intelligence Developer
Key Risk
10.2018 - 07.2020
MS SQL Database/Business Intelligence Developer
CVS Health
06.2017 - 09.2018
MS SQL Database/Business Intelligence Developer
King County
08.2012 - 05.2017
SQL Business Intelligence Developer/Data Analyst
Cleveland Clinic
07.2011 - 08.2012
- Azure Data Engineer Associate, DP-203
- Technology Specialist (MCTS) in Querying Microsoft SQL Server 2012/2014, 70-461
Master of Science - Computer Science
CUNY New York City College of Technology
Similar Profiles
Sachin PanchalSachin Panchal
Offset Printer at CCLOffset Printer at CCL
Miel DellaertMiel Dellaert
Printing Assistant at CCLPrinting Assistant at CCL
SURESH BABU THONDAPUSURESH BABU THONDAPU
Service Desk Engineer at CCLService Desk Engineer at CCL