o Developed a data pipeline on Google Cloud Platform and automated quality checks to monitor incoming data, reducing daily manual ETL processes from 2 hours to 0 hours a day.o Developed and maintains dashboards and reports on Looker Studio to create visibility over meter data and the performance of deployed solar assets.o Automated calculations for customer-related metrics, making the response time to customers from days to minutes.o Conducts monthly billing and reporting autonomously, reducing days’ work to minutes.o Introduced and currently monitors 10+ CRON jobs scheduled on Google Cloud Platform, reducing man hours to 0 for these tasks. Errors only need resolution when scripted alerts are sent through a Slack channel.o Conducts analysis on customer historic consumption patterns, existing energy plans and A/B testing outcomes. o Uncovered profitability structures for customers and partners, explaining the variables that affect each individual customer’s/partner’s ability to financially benefit from the company’s products.o Continuous scoping, development and maintenance of scripted automations to eliminate repetitive tasks for operations, allowing a smoother scale-up of the company.

o Conducted testing on the cybersecurity integrity of the client’s third parties.o Raised observations and create recommendations to improve the security of the client’s sensitive information when in custody of their third parties.

o Rolled-forward engagement files.o Requested source documents and conducted test of controls and substantive test of procedures. Casted financial statements.

Handled council funds, managed check and balances of petty cash. Responsible for allocating cash for everyday use and for projects. Supplemented the External Relations department in their affairs for managing internal and external parties.

Engaged sponsors and setup meetings to spark their interest in our event. Satisfied their specific requirements and resolved issues for marketing and performance departments. Coordinated a team of council members to manage potential sponsors and temporary on-campus vendors to raise funds.

Facilitated learning sessions between peers to stimulate their learning and interests in Principles of Financial Accounting.