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.
