Sreedevi Yerroju

Experience

• 

  NetCracker

  Jan 2013 - Jan 2015

  Software Developer

  • Developed a regression framework using SQL/PLSQL to ensure seamless code integration safeguarding against potential issues or breaking changes.• Played a pivotal role in the development and implementation of revenue-generating features such as 'loyalty points' and 'Itemized billing', recognized with a certificate of appreciation for the significant contributions made.

• 

  Oklahoma State University

  Jan 2016 - Jan 2016

  Graduate Teaching Assistant

  Utilized Python web crawlers to support and enhance research efforts. These web crawlers automated data collection processes, enabling efficient data gathering from various online sources and providing valuable inputs for research analysis.

• 

  Synopsys Inc

  Jan 2016 - Jan 2016

  Intern

  • Worked on building and scheduling multiple data integrations in SuccessFactors Integration center• Configured and customized the LMS.• Developed interactive web pages using HTML, CSS and JavaScript for an LMS training item.• Documented the Budget Tracking IT procurement process in the company.

• 

  Capgemini

  Mar 2017 - Jan 2018

  Data Analyst

  • Played a key role in the redesign and migration of the organization's data warehouse to cloud services resulting in optimal data flow enabling informed decision for improved business insights.• Worked on ‘Engagement’ dashboard to analyze the digital engagement of customers using Tableau and SQL which helped in enhancing targeted improvements in existing offers leading to an increase in conversion rates by 20%.• Developed python web crawlers to gather data from multiple sources for sentiment analysis significantly reducing manual data collection efforts.• Developed compelling visualizations like the Sankey Chart, to depict consumer preferences across brands and flavors which provided valuable insights into consumer behavior, enabling data-driven decision making. Voir moins

• 

  WhiteHaven

  Jan 2021 - Jan 2023

  Data Analyst

  •Developed and built Azure Data Factory pipelines to streamline and store custodian data, while also working on developing required stored procedures for the ETL process using SQL.•Independently built and designed the data warehouse, taking full ownership of the data architecture, from conception to implementation, ensuring optimal data organization and storage for efficient analysis and reporting.•Designed and implemented complex SQL scripts to efficiently extract and analyse data, empowering data-driven insights.•Developed impactful visualizations in PowerBI to evaluate KPI metrics, enabling stakeholders to make informed decisions and drive practical benefits for the business.•Developed a ‘Performance Report Generator’ using Python libraries like Pandas, NumPy and Matplotlib which enhanced the client experience and provided in-depth insights for portfolio managers enabling evidence-based decision making.•Automated multiple processes like API read/writes and file generation using python and Azure Data Factory, resulting in a significant reduction of 500 hours of manual work per year which improved operational efficiency and productivity.•Implemented the 'Alternate Payee' feature in the company's billing system which enabled more flexible payment options for clients, generating an annual revenue of CAD 20,000.•Spearheaded the development of the mobile app (which has a traction of 500 clients) by collaborating with cross-functional teams to gather requirements, working on the BRD, leading scrum meetings and ensuring progress. •Successfully implemented the ‘Billing System’ by designing and developing efficient stored procedures to accurately calculate bill amounts for each customer, ensuring seamless and error-free billing processes.•Implemented a robust email alert system using Logic Apps to proactively send daily success/failure updates of automated processes to internal stakeholders, ensuring timely awareness facilitating prompt actions when necessary. Voir moins