Sumanth Burada

Experience

• 

  South Central Railway

  Jan 2019 - May 2019

  Business Data Analyst

  • Streamlined data ingestion and cleansing processes by developing Python-based web scrapping scripts for loading data into MS SQL Server, increasing efficiency and reducing errors by 20%• Developed a performance monitoring dashboard on an ad-hoc basis in MS Excel that increased team efficiency by 90%,

• 

  Capgemini

  Jun 2019 - Oct 2022

  •Designed and implemented data integration pipelines to collect, extract, transform, and load (ETL) data from various sources into a centralized data repository. •Utilized Agile methodologies and tools to effectively prioritize and manage data analysis tasks, ensuring efficient utilization of resources and meeting project deadlines.• Ensured data quality and consistency throughout the ETL process. • Performed advanced procedures like text analytics and processing, using the in-memory computing capabilities of SparkSQL. • Worked on streaming data using Kafka with multiple producers, to produce data into Kafka topics with multiple partitions, also spark streaming to consume data from Kafka topics and write into HDFS. • Ingest the data from the SQL server to the BDA System by using spark jobs. • Load and transform large sets of structured, semi-structured, and unstructured data using Hadoop/Big Data concepts • Train the team on Big Data architecture and development activities to bring the team up to speed. Show less • Conducted data analysis using advanced analytics techniques to derive actionable insights. • Utilized machine learning algorithms to automate and improve data analysis processes. • Collaborated with stakeholders to gather and document detailed technical specifications. • Utilized SQL and HiveQL extensively to query, manipulate, and analyze large datasets, demonstrating proficiency in database management and data warehousing techniques.• Executed complex data transformations and optimizations, contributing to streamlined data pipelines and enhanced data-driven decision-making processes.• Worked on agile software development teams, following Confluence, Jira, Scrum methodologies. • Employed database normalization and indexing strategies to optimize SQL queries. • Developed and implemented a Python script to generate daily sales reports, Automated the generation of monthly customer reports using Python. • Created a Python script to generate weekly inventory reports. • Developed interactive dashboards and reports, enhancing data accessibility and facilitating informed decision-making across the organization using Tableau and PowerBI Show less

  • Data Engineer

    May 2021 - Oct 2022

  • Database Administrator

    Jun 2019 - Jun 2021
• 

  Consumers Energy

  Dec 2023 - now

  Data Engineer

  • Worked on delivering user traffic data to drive insights and decision-making across CE.com and third-party sites to optimize engagement/conversion and marketing campaign results.• Defined key performance indicators (KPIs) and objectives in collaboration with stakeholders, focusing on increasing customer engagement, enhancing brand awareness, and driving conversion rates.• Employed database normalization and indexing strategies to optimize SQL queries.• Accelerate time to market by rapidly turning data into actionable insights for data visualization and analysis.• Promoted data and reporting standards within the organization through targeted training sessions, fostering a collaborative environment for effective communication.• Utilized analytics tools such as SQL, Python, R, and Power BI. Azure Data factory pipelines to extract, transform, and analyze marketing data, enabling informed decision-making and optimization of campaign strategies. Show less