BALWINDER SINGH
Dallas-Forth Worth Metroplex,USA
Summary
Accomplished Senior Data Engineer with over a decade of expertise in data engineering and business intelligence, leveraging advanced skills in SQL, ETL, and data warehousing for innovative data engineering solutions. Excelled in architecting data solutions that enhanced operational efficiency and data-driven decision-making. Demonstrated leadership in transforming complex data insights into actionable strategies, showcasing exceptional analytical and team management skills.
Overview
14
14
years of professional experience
1
1
Certification
Work History
SENIOR DATA ENGINEER
SEGAL
Dallas, USA
09.2019 - Current
- Delivered and maintained optimal data migration architecture that includes complex data integration solutions involving third party tools
- Designed and developed large analytical data structures that meets business decision making requirements
- Enhance data delivery and re-design framework for greater flexibility and scalability
- Built the infrastructure required for excellent (Extract, Transform, Load) tasks with variety of data, maintaining data integrity and verifying pipeline stability
- Explained data results and discussed how best to use data to support project objectives
SENIOR SOFTWARE DEVELOPER
OUTLINE SYSTEMS INC
Basking Ridge, USA
01.2016 - 09.2019
- Led implementation of Health data ETL and BI programs, streamlining claims audit processes using SQL, SSIS, and SSRS for improved efficiency.
- Managed offshore team and production support, ensuring seamless integration and deployment of database and BI solutions across diverse platforms.
- Conducted in-depth performance tuning of data processing routines, significantly enhancing system speed and reliability for client operations.
- Pioneered client onboarding strategies to Data Warehouse, facilitating smooth transitions and optimizing data utilization from various sources.
- Spearheaded redesign of health data warehouse, creating a more robust and precise system for improved data processing and analysis.
SOFTWARE DEVELOPER
OUTLINE SYSTEMS INC
Chandigarh, INDIA
06.2011 - 01.2016
- Engineered ETL processes for Property & Casualty Agency Onboarding, integrating diverse data sources to streamline operations and enhance data accuracy.
- Led SSIS development lifecycle, overseeing enhancements and deployments for all data loads, ensuring robust and efficient data processing systems.
- Optimized database performance through advanced SQL coding, addressing critical issues and implementing innovative solutions for improved efficiency.
- Mentored team members in crafting complex, optimized SQL code for reporting, extracts, and analytics, elevating overall team expertise.
- Managed client and cross-functional team interactions, resolving data and SQL challenges while managing critical data synchronization processes. and technically assisting the team in optimal OLTP/OLAP database solutions.
Education
Masters of Computer Applications -
Lovely Professional University
Punjab, India06.2011
Bachelor of Science -
Panjab University
Chandigarh, India06.2008
Skills
- Advanced SQL skills
- Python
- SSIS
- SSRS
- Power BI
- Data Engineering
- Data migration architecture
- Data integration solutions
- ETL processes
- Performance tuning
- Business intelligence
- ETL development
- Data pipeline design
- Data warehousing
- Data modeling
- Data integration
- Database design
- Data migration
Certification
- Microsoft Certified in Azure Fundamentals
- Microsoft Certified in Azure Data Fundamentals
- Microsoft Certified Solution Associate SQL Server 2012
- Microsoft Certified Professional querying SQL Server 2012
Projects
- HealthCare Data Warehouse (HDW): Jan 2016 - Present
- SHAPE: Sept 2019 - Aug 2023
- BAS Claims Audit: June 2016 - Present
- Patient Access Network (PAN): Jan 2017 - Present
- ProducerOne (Product): June 2016 - Jan 2016
- SecureOne (Product): Feb 2012 - Jan 2016
Career Interests
- Data Warehouse Architect
- Data Engineering and Analytics Lead
- Data Scientist
- Business Intelligence Lead
Domain knowledge
- Health Care
- Insurance - Property & Casualty (Agency Onboarding)
Languages
English
Full Professional
Punjabi
Native/ Bilingual
Hindi
Native/ Bilingual
Timeline
SENIOR DATA ENGINEER
SEGAL
09.2019 - Current
SENIOR SOFTWARE DEVELOPER
OUTLINE SYSTEMS INC
01.2016 - 09.2019
SOFTWARE DEVELOPER
OUTLINE SYSTEMS INC
06.2011 - 01.2016
- Microsoft Certified in Azure Fundamentals
- Microsoft Certified in Azure Data Fundamentals
- Microsoft Certified Solution Associate SQL Server 2012
- Microsoft Certified Professional querying SQL Server 2012
Masters of Computer Applications -
Lovely Professional University
Bachelor of Science -
Panjab University
Similar Profiles
Zachary Vieira, ASA, MAAAZachary Vieira, ASA, MAAA
Health Actuary / Associate Health Consultant at SegalHealth Actuary / Associate Health Consultant at Segal
Imanni BrittmanImanni Brittman
Actuarial Trainee at SegalActuarial Trainee at Segal
Jenry MartinJenry Martin
IT & Facility Project Manager at Segal TrialIT & Facility Project Manager at Segal Trial