Shyam Maddi
Austin,TX
Summary
Accomplished Sr. Data Engineer at Braun Intertec Corporation, adept in SQL Server and Azure data services. Proven track record in designing scalable data solutions and optimizing ETL processes, enhancing data accuracy and efficiency. Strong collaborator with a focus on delivering impactful business intelligence solutions and driving data-driven decision-making.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Sr. Data Engineer
Braun Intertec Corporation
Austin, TX
08.2019 - Current
- Designed and managed data solutions on Microsoft Azure cloud platform.
- Implemented data integration and ETL processes using Azure Data Factory.
- Handled large data volumes with Azure Databricks and Apache Spark for analysis.
- Ensured data security through encryption and role-based access control measures.
- Collaborated with analysts and developers to optimize data workflows effectively.
- Developed reusable dataflows and semantic models to support enterprise-wide KPIs.
- Migrated legacy ETL workflows to Azure Data Factory for enhanced scalability.
- Provided technical documentation on best practices for cloud-based data processing.
Sr. Azure Data Engineer
Oregon Department of Transportation
Salem, OR
02.2015 - 07.2019
- Engineered data architecture and application design utilizing cloud and big data solutions on AWS and Microsoft Azure.
- Designed and developed data integration pipelines in Azure Data Factory, ingesting 50 TB of data daily from on-prem SQL servers to Azure SQL Data Warehouse.
- Created dimensional data models using Star and Snowflake schemas based on Kimball methodology, enhancing analytical capabilities.
- Managed scalable data warehouses with Snowflake, optimizing efficient data storage and retrieval processes.
- Implemented a data fabric architecture connecting diverse sources for seamless integration across cloud and on-premises environments.
- Developed and maintained complex DBT models that streamlined data transformation and ensured high-quality outputs.
- Utilized Matillion to design intricate ETL workflows, enhancing integration and transformation efficiency.
- Executed loading of data pipelines from web servers using Sqoop, Kafka, Spark, and Apache Flink Streaming API.
SQL BI Consultant
BCBS of Illinois
Aurora, Illinois
10.2014 - 02.2015
- Collaborated with cross-functional teams, including clients and analytics, to ensure seamless project execution.
- Addressed critical production bugs in subsidy and invoice data pipelines using advanced T-SQL and SSIS workflows.
- Re-architected stored procedures to enhance complex join logic and exception handling.
- Managed end-to-end project lifecycles utilizing agile methodologies from planning through deployment.
- Led the design and implementation of data warehouses and marts tailored for specific reporting requirements.
- Oversaw user access and security permissions for Power BI dashboards while performing complex DAX queries for analytics.
- Provided backend support for Tableau and Power BI reports, ensuring reliable performance and data delivery.
- Played an integral role in Azure application migration using Azure Data Factory and Logic Apps to create scalable solutions.
ETL Developer/Business Intelligence Developer
California Dept. of Conservation
Sacramento, CA
06.2014 - 10.2014
- Created SSIS packages for development, unit testing, and deployment in Dev and QA environments.
- Collaborated with business and technical teams to transform requirements into ETL specifications.
- Led investment banking initiatives, including M&A, capital raising, and financial modeling projects.
- Built financial models and valuation analyses to enhance client presentations and strategic decisions.
- Integrated SaaS platforms with on-prem and cloud BI tools for unified insights.
- Conducted market research to underpin strategic investment recommendations.
- Designed optimized T-SQL queries for Azure integration and application performance.
- Implemented SQL Mail, backup strategies, and disaster recovery plans for production databases.
SQL Server Developer
Provant Health Solutions
Warwick, Rhode Island
06.2013 - 04.2014
- Contributed to design and execution of data migration initiative across all SDLC stages.
- Collaborated with technical and functional teams in Agile environment to define data transition requirements.
- Established staging environment, migrated relevant business data to Hybris using SSIS workflows.
- Developed integration interfaces for SAP processes including Sales Orders and Customer Accounts.
- Executed dimensional modeling, managing dimensions like Product and Region in Snowflake schema.
- Designed and managed SSIS packages for data extraction aligned with data model specifications.
- Conducted end-to-end testing encompassing System Integration Testing and staged rollouts.
- Created automated processes for daily ingestion and archival of flat files with date stamps.
Education
Master of Science - Computer Science
Texas A&M University
Kingsville, TX12.2013
Bachelor of Technology - Computer Science
JNTU
Hyderabad, India05.2011
Skills
- SQL Server and Oracle
- Data visualization tools
- ETL and data migration
- Business intelligence solutions
- Azure data services
- Python programming
- Reporting and analytics
- Interactive dashboards
- Data modeling techniques
- Cloud computing platforms
- Agile methodologies
- Data pipeline design
- Data warehousing
- Business intelligence
Certification
- Azure Fundamentals
- Power BI Data Analyst Associate
Timeline
Sr. Data Engineer
Braun Intertec Corporation
08.2019 - Current
Sr. Azure Data Engineer
Oregon Department of Transportation
02.2015 - 07.2019
SQL BI Consultant
BCBS of Illinois
10.2014 - 02.2015
ETL Developer/Business Intelligence Developer
California Dept. of Conservation
06.2014 - 10.2014
SQL Server Developer
Provant Health Solutions
06.2013 - 04.2014
Master of Science - Computer Science
Texas A&M University
Bachelor of Technology - Computer Science
JNTU
Similar Profiles
Emanuel RodriguezEmanuel Rodriguez
NDE Technician at Braun IntertecNDE Technician at Braun Intertec
Jesse TrevinoJesse Trevino
Drillers Assistant at Braun IntertecDrillers Assistant at Braun Intertec
Charles WhitfordCharles Whitford
Driller at Braun IntertecDriller at Braun Intertec
Jeffrey KeimJeffrey Keim
Global Head of Account Management at AtlassianGlobal Head of Account Management at Atlassian
SONIA ANDERSONSONIA ANDERSON
Operations/Warehouse Inventory Specialist at Crate and BarrelOperations/Warehouse Inventory Specialist at Crate and Barrel