Sri Venkata Sai Anoop Bulusu Email & Phone Number

Kirkland, Wa, Us

San Jose, California, United States

Utilized Azure Data Factory and Azure Databricks to integrate and process real-time GPS data, transit schedules, weather, and ridership data, handling over 100 GB of data efficiently and ensuring seamless data flow and accessibility.Designed an event-driven architecture using Azure Data Factory and Logic Apps, enabling automated pipeline triggering based on events in Azure Blob Storage, which significantly improved the processing and integration of incoming real-time data.Employed Databricks and Spark for extensive data cleaning and transformation, ensuring data consistency and readiness for accurate analysis, which enhanced the reliability of subsequent analytics and reporting.Designed and implemented dimensional data models to support robust data warehousing and reporting. Developed aggregated queries and stored procedures to facilitate complex analytics and reporting requirements. Improved performance by implementing better partitioning and indexing strategies, resulting in faster query execution times and improved overall system efficiency.Conducted comprehensive descriptive and predictive analysis, leveraging historical and real-time data to enhance the accuracy and efficiency of transit operations. This analysis improved travel-time predictions by 20% and optimized transit routes by 15%.

Bloomington, Indiana, United States

- Facilitated the course 'Information Representation-I308', focusing on distinguishing between data and information and employing effective methods for data representation to enhance information retrieval.- Guided students through the design and development of database systems, from conceptualizing Entity Relationship Diagrams (ERDs) to implementing and populating relational databases using SQL.- Delivered comprehensive instruction on advanced SQL query formulation for data retrieval and management, as well as the creation and use of web-based portals for database interaction.- Fostered a collaborative team-based learning environment, emphasizing the development of interpersonal and team skills essential for successful data management projects.

Bloomington, Indiana, United States

- Instructed students in Python programming as an Associate Instructor for the 'Introduction to Programming (I210)' course, emphasizing core programming principles and Python-specific syntax and functionalities.- Guided students through the intricacies of Python, covering data types, control structures, functions, and modules, to lay a solid foundation for advanced programming concepts.- Administered and reviewed coding exercises, encouraging the practical application of Python to solve a variety of computational problems and real-world scenarios.- Supported a dynamic and interactive classroom experience, fostering an environment conducive to learning, experimentation, and a deep understanding of Python programming.

Bloomington, Indiana, United States

Improved student enrollment management and infrastructure maintenance by upgrading systems and operations to provide insights and data-driven decision-making.Upgraded legacy Student Information Systems (SIS) by leveraging Data Modeling and Data Warehousing Strategies to manage and analyze data on student applications, enrollment statuses, and demographic information, significantly improving enrollment management efficiency and accuracy.Improved the Integrated Enrollment Management System (IEMS) by integrating Tableau, Oracle Data Integrator (ODI), and OLAP strategies, along with custom-built ETL processes using Python, to transform enrollment operations reporting, thereby revamping prioritized student intake, application processing, and budget analytics.Managed complex ETL processes with custom-built Python scripts and ODI, ensuring accurate data extraction, transformation, and loading from multiple sources into a centralized data warehouse, laying the foundation for reliable BI reporting.Created interactive Tableau dashboards and reports, providing comprehensive insights into student enrollment and demographic performance metrics.Collaborated in designing data modeling schemas and architecture of a comprehensive data warehouse strategy to bolster advanced analytics and reporting, promoting a data-driven approach to enrollment management.Improved enrollment and operations reporting by enhancing dashboard functionality within Tableau and leveraging Amazon RDS for analyzing enrollment trends, retention rates, and other key performance indicators (KPIs).

Texas, United States

Architected and implemented data pipelines responsible for ingesting data from diverse sources such as AWS S3, external APIs, and databases into Snowflake.Orchestrated and automated the data ingestion process using Apache Airflow.Utilized DBT along with Snowflake to execute data modeling and transformations, for a streamlined and efficient workflow.Established a hierarchical staging area structure for raw data while implementing SCD Type 1 & Type 2 to ensure accurate historical data in the semantic layer for reporting and historical data preservation.Collaborated with the team to optimize SQL queries and data models, resulting in a 15% improvement in query performance and analytical capabilities.Conducted thorough performance tuning and optimization of data pipelines to handle substantial data volumes efficiently, which was crucial for data-intensive applications.Implemented robust data security measures, including access controls and encryption, ensuring the confidentiality and integrity of sensitive data.

Chennai, Tamil Nadu, India

Constructed GCP data pipelines using Cloud Data Fusion, employing data wrangling techniques to transform raw data into actionable business insights.Managed CIM and EIM data models, enhancing data organization and efficiency by 10%.Managed BigQuery data warehouse, ingesting data for analytics. Orchestrated Cloud Composer workflows, optimizing pipelines in Apache Airflow for a 30% efficiency boost.Worked on numerous POC [Proof of Concepts] on Cloud Data Fusion & BigQuery, ensuring data transformation logic remains static with Oracle SQL during migration.Implemented robust data security measures including Anonymization and De-anonymization of PII data and exception handling. Automated the application lifecycle using Python, shell scripts, Google Cloud Storage, Apache Airflow, and Cloud Functions resulting in a significant 30% reduction in manual effort and increased operational efficiency.Produced interactive reports and dashboards using Looker and Cloud Data Studio, empowering clients to visualize and understand their data more effectively.Collaborated closely with cross-functional teams to implement best practices in data engineering, ensuring scalable and maintainable data solutions.Created comprehensive documentation, including migration plans, architectural diagrams, configuration details, and troubleshooting guides.Created multiple interactive reports and visualizations using Cloud Data Studio & Looker for data insights.

Hyderabad, Telangana, India

Built ELT pipelines to analyze and visualize sales data, utilizing Apache Airflow for extraction, with S3 for storage and PostgreSQL for temporary storage and metadata management.Implemented a robust data cleansing and transformation process in AWS Glue, leveraging its ETL capabilities to preprocess, clean, and normalize the sales data, thus enhancing data quality and consistency for accurate analytics.Developed advanced SQL queries in Athena for complex data analysis tasks, extracting key patterns and trends from large datasets. This facilitated in-depth content analysis, sentiment analysis, and user behavior insights.Designed data warehousing solution with Redshift, and visualized insights using Tableau & Amazon Quick Sight.Implemented a Python-based data preprocessing pipeline, enhancing data integration, and optimizing input efficiency for the forecasting model.Created interactive Tableau dashboards for visualizing and presenting sales forecasts and insights.

Master'S Degree, Data Science, 3.8

Bachelor Of Technology, Electrical, Electronics And Communications Engineering, 9.34