Experience

• 

  Accenture

  May 2018 - Jul 2021

  • Developed and deployed 25+ ETL pipelines using SSIS to extract data from multiple BOBJ reports into an on-premises data warehouse, enhancing data availability for enriched supply chain insights. • Tackled challenges with slow 3rd party report retrievals by designing a Python-based dataflow, achieving a 40% speed increase in data retrieval from AWS S3 compared to an existing SSIS task. • Mentored 3 new associates in root cause analysis, leading to a 45% improvement in team-wide incident resolution efficiency through proactive issue identification and mitigation. • Addressed a lengthy 1-hour manual record insertion process by developing a Python-based solution for bulk insertions with one click, dramatically enhancing data input efficiency by 80%. • Designed tailored data sources in response to frequent requests for marketing dashboard data, resulting in a 60% reduction in new data requests from marketing teams. Show less • Addressed data discrepancies by designing a custom data quality solution with Python and SSIS, leading to a 90% improvement in data accuracy and ensuring consistent and reliable data ingestion into the database. • Partnered with cross-functional teams to gather specific requirements, leading to the successful implementation of tailored data models that catered to evolving business needs.• Enhanced efficiency by automating up to 67% of repetitive data-related support tickets, leading to reduced manual oversight and quicker incident resolution times. • Addressed inefficiencies in manual email attachment processing from BOBJ in Outlook by developing custom C# scripts, resulting in an automated and streamlined data ingestion process into the SQL server, enhancing overall productivity and data handling accuracy.• Recognized the need for an effective data transmission method from SQL Server to a stock forecasting web app; spearheaded the design and development of a data layer for a .Net API, resulting in enhanced supply chain information delivery, significantly improving forecasting accuracy and operational efficiency. Show less

  • Data Engineer

    Jul 2020 - Jul 2021

  • Associate Data Engineer

    May 2018 - Jun 2020
• 

  Pfizer

  May 2022 - Aug 2022

  Data engineer

  • Orchestrated the migration of 10TB of RAW and compliance data to Azure archival storage, resulting in a 25% reduction of monthly storage costs.• Constructed 16 Azure Data Factory pipelines in response to inefficiencies in transferring data from Amazon Redshift to SQL Server, resulting in seamless data retrieval and a marked enhancement in data accessibility and analytics processing.• Faced with slow-loading times for a key stock forecasting application, tuned stored procedures and views, achieving a 60% boost in data loading speeds and ensuring swifter web application responses. Show less

• 

  Indiana university bloomington

  Aug 2022 - May 2023

  Graduate assistant

  • Conducted research on emerging big data technologies, leading to the successful update and enhancement of course syllabi and lesson plans.• Provided dedicated support during regular office hours, enhancing the comprehension of database and big data concepts for 150 graduate students.• Led the training and mentoring of 5 TA's, emphasizing effective feedback strategies, resulting in improved TA-student interactions and continuous academic enhancement for students.

• 

  Infosys

  Jan 2024 - now

  Data engineer ii