Sreedevi Yerroju

Experienced data analyst with 5+ years of industry experience, strong track record in developing and implementing data solutions to streamline processes, optimize data storage, and enable data-driven decision-making. Has a background in Data Analytics, Data Science, Data Architecture, and Programming. Highly adaptive and adds a creative dimension to every task taken up. Follows best practices and has strong problem solving and logical thinking skills with excellent written and verbal presentation skills.

EXPERIENCE

WhiteHaven Asset Management                                                                          February, 2021- Present

Data Analyst (Full time; April 2022- Present)                                                                   Remote, Canada                                                                                         Data Analyst (Contract; February 2021- March 2022)                                                         Remote, India                                                                                       

• Developed and built Azure Data Factory pipelines to streamline and store custodian data, while also working on developing required stored procedures for the ETL (Extract Transform Load) 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.

Capgemini                                                                                                                March, 2017 – April, 2018

Data Analyst                                                                                                                              Richmond, USA                                                                                                                                                                                 

• Played a key role in the redesign and migration of the organization's data warehouse to cloud services resulting in optimal data flow for improved business insights.
• Worked on ‘Engagement’ dashboard to analyse 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 flavours which provided valuable insights into consumer behaviour, enabling data-driven decision making.

Synopsys                                                                                                                 June, 2016 – August, 2016

Graduate Intern                                                                                                                Mountainview, USA                                                                                                                                                                 

• Developed interactive LMS JavaScript webpages to enhance functionality and user experience.

Netcracker                                                                                                                    June, 2013 – July, 2015

Software Developer                                                                                                               Hyderabad,India                                                                                                           

• 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' for which I was awarded a certificate of appreciation for the significant contributions made.

Master of Science                                  Dec 2016

Oklahoma State University               

Management Information Systems

Bachelor of Engineering                      May 2013

Osmania University                           

Computer Science and Engineering