Sahaja Yalla
Roanoke,TX
Summary
Team manager with over 9 + years of experience in the technology in healthcare, real estate domain. Skilled in systems design, designing of a data warehouse environment, and data analysis. Organized, goal-oriented, highly motivated collaborative team player with excellent problem-solving and analytical skills. Desire to design complex and efficient data warehouses to support the growing transactional and analytic needs of business users. Passion for data, process, and resource optimization. Motivated to stabilize operations, continuously monitoring and improving processes. Excellent written, verbal, and communication skills.
Professional with strong track record in technical leadership and project management. Adept at guiding teams to achieve operational excellence and implement innovative solutions. Known for collaborative approach and adaptability to dynamic environments. Key skills include strategic planning and technical troubleshooting.
Overview
10
10
years of professional experience
Work History
Data Engineering Technical Manager
Baylor Scott & White Quality Alliance
01.2022 - Current
- Manage a team of junior and senior ETL developers.
- Delivered the migration project on schedule and received strong positive feedback from stakeholders
- Train and mentor team members. Take care of the monthly loading process.
- Set strategies and goals. Track progress towards goals and track all team activities
- Lead and manage multiple complex projects in an Agile environment.
- Responsible for managing medium to large-sized projects involving resource teams to manage and maintain ongoing data sharing requirements for our internal and external customers.
- Engage with appropriate teams to identify and implement best practices for data tools, methods, processes, and technologies, and develop and establish procedures for accurate and reliable data reporting.
- Moving data from on-premises to Snowflake, the table architecture and data flow processes have been redesigned.
- Build and maintain working relationships with data users while designing architectures in Snowflake Data Warehouse.
- Ultimately determine the direction of the inbound migration strategy. It leverages Azure Data Factory to orchestrate data pipelines for seamless data flow between on-premises systems and the cloud.
- Standardize robust dbt modeling, data transformation, and robust governance processes. This reduces ETL processing time and improves data quality.
- Collaborate with stakeholders to ensure information needs are aligned. Database migration was successful with zero downtime. and no data loss
- Conducted training sessions for team members on Snowflake, ADF, and dbt, promoting a stronger understanding of cloud data architecture. and facilitate a smoother transition for business units.
Senior Developer - ETL/Data Warehouse
Baylor Scott & White Quality Alliance
05.2016 - 12.2021
- Maintained and enhanced the load process of 2TB healthcare claims data warehouse for a nationally top-performing Accountable Care Organization with over 800,000 members.
- Use a full System Development Life Cycle (SDLC) including requirement gathering, analysis, design, development, testing, and implementation for various clients.
- Created tables, views, functions, and stored procedures to insert data into Type 2/1 Tables.
- Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
- Automated data loading process by developing the SSIS packages to clean, verify, and load the client data that varies from 1 GB to 3 GB into a format usable for running regression analysis. Created Indexes to get the high-level performance during data load monthly and reduced to runtime.
- Designed and implemented ETL processes to ensure efficient data integration across systems.
ETL/Data Warehouse Developer
CBRE
11.2015 - 03.2016
- Gathered requirements in setting up replication databases, which involved source data feed from the OLTP Production database to the reporting data warehouse database.
- Collaborated with business analysts and other team members to determine data extraction and transformation requirements.
- Built, deployed, and automated the execution of SSIS packages using SSIS life cycle and Checksum, Lookup, and Conditional Split techniques.
- Created stored procedures, functions, views, and SSIS packages.
Education
Bachelor of Engineering - Information Technology
Jawaharlal Nehru Technological University (JNTU)
Hyderabad, IndiaSkills
- Cloud Data Migration: Migration of SQL Server data to Snowflake with Data Transformation in Azure Data Factory and modeling in dbt
- Team Management & Coaching: Experience leading technical teams on large data projects with a focus on collaboration and productivity
- Project Management: Proficient in coordinating cross-functional teams, project completion on budget, and to targets
- Data Warehousing & ETL: Proficient in Snowflake, Azure Data Factory, SQL Server, and dbt for effective data warehousing and ETL work
- Process Optimisation: Expert in process inefficiencies and process optimization improvements to improve data infrastructure performance
- SDLC & Programming Ideas: Proficient understanding of software development life cycle, programming concepts, Slowly Changing Dimensions - Type I & II
- Microsoft Database Stack: Proficient in Snowflake, SQL Server, SSMS, Microsoft Visual Studio, SSIS, Azure Data Factory, Azure DevOps, SQL Server Agent
- Proficient SQL: Proficient in stored procedures, indexing, tuning, dynamic SQL, and functions
- Data Modeling: Strong knowledge of relational and star schema data architectures, data warehousing concepts
- Multitasking & Planning Skills: Highly organized, able to multitask and work across multiple teams to reach multifaceted goals
- Project Management Approaches: Knowledgeable in requirements gathering, writing, and Agile processes for project delivery
- IT staff leadership
- Employee development
- Technical innovation expertise
- Team collaboration
Timeline
Data Engineering Technical Manager
Baylor Scott & White Quality Alliance
01.2022 - Current
Senior Developer - ETL/Data Warehouse
Baylor Scott & White Quality Alliance
05.2016 - 12.2021
ETL/Data Warehouse Developer
CBRE
11.2015 - 03.2016
Bachelor of Engineering - Information Technology
Jawaharlal Nehru Technological University (JNTU)