Devang More
Database Analyst @CanPrev
Signup · Get unlimited contacts
WORK HISTORY
Database Analyst @CanPrev
Toronto, ON, CA
Designed and implemented data pipelines using Airbyte to integrate QuickBooks with MySQL, ensuring seamless financial data transfers.•Deployed pipelines locally with Docker and leveraged Intuit Developer tools, including OAuth 2.0 playground, for secure data connections.•Migrated reports from an old database to a new one, audited report functionality, and developed new reports when existing ones failed.•Created a centralized reporting dashboard with automated subscription features, enabling scheduled report delivery.•Developed end-to-end data pipelines using Apache Airflow and Python to fetch and process financial data from QuickBooks into MySQL.•Hosted and managed pipelines on a server using DigitalOcean Droplets, ensuring efficient and reliable operation.•Enhanced pipeline security by implementing multi-factor authentication (2FA) with Okta.•Collaborated with stakeholders to generate tailored reports, meeting business and team-specific requirements.•Authored comprehensive project documentation for seamless knowledge transfer and future scalability
EDUCATION
Dharmsinh Desai University
Bachelor's degree
Lambton College
Postgraduate Degree
ABOUT DEVANG MORE
At CanPrev, our team excels in streamlining financial data workflows, thanks to the deployment of robust data pipelines and my expertise in integrating QuickBooks with MySQL. With a Postgraduate Degree in Computer Software Engineering from Lambton College, my educational background fortifies my proficiency in designing and implementing complex technical solutions. Our latest achievements include the creation of a centralized reporting dashboard and the development of end-to-end data pipelines using Apache Airflow, all hosted on DigitalOcean Droplets. Our success is driven by a shared commitment to Agile software development, ensuring secure, efficient, and automated solutions that support the company\'s operational excellence.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.