Venkat Sai Dhushetty Email & Phone Number

Bellevue, Wa, Us

Bellevue, Washington, United States

- Developed Python Notebooks and created workflows to streamline the process of capturing streaming data from Azure EventHub and storing it in Delta tables on Azure Databricks. - Wrote scripts and created pipelines to manage updates, inserts, and deletions of the streamed data using Delta Live Tables. Wrote Logic to send this data to google cloud storage.- Created python notebooks and pipelines in Azure Synapse Analytics to get data from multiple sources using SAS tokens and service principal.- Wrote python scripts to unzip sales data and logic to transform data to meet client standards.- Configured spark pools to meet the compute demand for seamless functioning of all notebooks.- Developed a forecasting algorithm to accurately predict orders and boost sales.- Conducted daily data validation and provided comprehensive reports to clients.- Setup development, test, production environment through terraform and deployed the updates though git following continuous integration and deployment.- Migrated entire process from Azure Synapse Analytics to Azure Databricks Platform.

Hyderabad, Telangana, India

- Designed and developed a data warehouse to serve as a central repository for the extracted data. - Defined the data warehouse schema, including tables, relationships, and indexes, and implemented dimensional modeling techniques such as star to organize data effectively. - Created data loading processes within SSIS to populate the data warehouse, ensuring efficient and incremental loading of data to minimize processing time. Optimized data warehouse performance by applying appropriate indexing and partitioning strategies. - Developed a multi-dimensional cube using SSAS (SQL Server Analysis Services) to facilitate reporting and analysis. Designed and implemented the cube structure, including dimensions, hierarchies, and measures. - Developed SSIS packages and workflows to extract data from diverse sources, transform and cleanse data, and load it into Azure SQL database for centralized analytics.- Automated ETL jobs and schedules using SQL Server Agent for routine and repeatable data integration tasks.- Worked on data transformation activities, including data cleansing, normalization, and enrichment, to maintain data accuracy and consistency.- Worked on setting up error handling mechanisms within SSIS packages, including custom logging, notifications, and corrective actions to uphold data integrity.- Created and maintained database tables, ensuring proper indexing, keys, and data integrity.- Worked on complex SQL for data querying, manipulation, and optimization, supporting efficient data retrieval and transformation for efficient data analysis.- Created dynamic calculations using DAX, allowing users to interact with reports and explore data from multiple perspectives.- Developed interactive sales dashboard in Power BI with drill-down capabilities, including charts, metrics, and visualizations to analyze sales by time, region, product, customer, representative, and other dimensions.

Master'S Degree, Mechatronics, Robotics, And Automation Engineering, 3.5

Bachelor Of Technology - Btech, Mechanical Engineering, 3.7