Data Analyst Software Engineer
Resume:
Robert Quin
*****@************.***
https://github.com/nothing-special20/
My YouTube Channel - https://www.youtube.com/@BillMoreTech_/videos
Summary
Full stack software engineer with an analyst background and self-taught programming skills. I am proficient in creating web apps with Django, Postgres, and integrating them with third party tools like large language models. Also proficient in React.js & Node.js
Data Analyst – Industrious Kraken March 2023 – February Present
Provided IT & analytics support to clients and built web apps using Django.
Developed ETL scripts to bring data from multiple source systems into single cloud postgres database on AWS RDS.
Wrote scripts to identify data reconciliation issues.
Helped with managing operations software & reporting to help a client managing hundreds of brick-and-mortar stores.
Managed operations software, built internal operations reports, and assisted with various IT projects like creating database backups.
Built web app MVP for go-to-market data enrichment using Django and Langchain to integrate multiple large language model providers and models as well as sales/marketing data into a spreadsheet interface.
Built web app MVP using Django, Langchain, and multiple natural language processing libraries to analyze amazon customer reviews, providing actionable insights for product and ad improvements.
Full Stack Javascript Developer – eNotaryLog November 2021 – February 2023
●Worked as part of a team of developers to develop an online notarization and e-sign platform with thousands of users.
●Developed systems that verified signers of important legal contracts using knowledge-based authentication with LexisNexis, credential analysis and facial recognition with Jumio, and recorded signers on video with Twilio.
●Used Google Cloud Platform (GCP) as our cloud provider to host documents and application services.
●Collaborated closely with product and QA teams to ensure robust, well-designed feature releases.
●Periodically led technical sprint planning sessions, facilitating developer understanding and alignment with the product and quality assurance teams on ticket requirements.
Work Experience
Software Engineering Consultant – Bill More Tech January 2020 – October 2021
●Provided data consulting for law firms, private equity, and SMBs. Collaborated with managing partners and IT directors to deliver results.
●Built custom web applications using Django, including dashboards for Amazon Ads and TikTok analytics using Django, Kibana and Plotly.
●Optimized systems data from the ground when integrating multiple third-party tools with Django.
Business Intelligence Developer – FRG Consulting July 2019 – November 2019
●Created QlikView reports visualizing Raymond James advisors' technology usage to help directors track user adoption.
●Developed KPIs and updated QlikView models, integrating cross-unit data and collaborating with stakeholders.
Data Analyst – AmerisourceBergen June 2017 – January 2019
Helped implement Azure EDW in finance to automate workflows and enable advanced analytics, including machine learning.
Created and maintained ETL processes to load third party data into Azure EDW.
Created visualizations using Python & QlikView to evaluate the effectiveness of corporate strategy on winning new customers & improving customer profitability.
Worked with the finance organizations data scientist to distill complex SAP hierarchies into simpler hierarchies for use by directors and less technical analysts.
Created data models and SQL processes that apply complex contract logic used to set the pricing for customers with billions of dollars in sales.
Designed reporting, created dashboards and presentation tables from a variety of data sources including various SAP Business Objects & GUI, Microsoft Azure, Oracle Essbase, & data vendors like IQVIA.
Financial Analyst – AmerisourceBergen October 2015 – May 2017
Drove customer profitability and compliance in Contract Management and Pricing teams.
Collaborated with sales and finance to implement data-driven strategies, yielding millions in additional profit.
Identified KPIs for low-profit and non-compliant customers through contract analysis.
Automated data wrangling tasks, improving efficiency and accuracy in customer evaluations. Scaled to generate reports for hundreds of customers.
Used Python to validate quarterly pricing for Alliant Rx, a major buying group.
Analyzed product leak to competitors for large customers using Python.
Automated reporting tasks.
Trained and supported team members in data analysis techniques.
Actuarial Analyst – Munich Reinsurance America Inc. June 2013 – August 2015
Completed required data preparation, including data input with guidance. Identified data issues requiring specialized actuarial attention. Client data was often imperfect and incomplete which required detailed cleaning in order to be made usable.
Used tools such as VBA and R to automate recurring financial reports and to enhance data preparation and analysis.
Performed ultimate loss projections, trend analysis, pricing studies, portfolio analysis, rate filings and research projects.
Developed premium, loss, expense, and other detailed financial exhibits in Excel.
Dealt with a wide range of insurance products ranging from pet health to heavy trucking to hospitals which presented unique challenges that needed to be handled with creativity.
Active Web App Projects
List Builder AI – July 2024 - Present – Building a sales & marketing data enrichment tool with an intuitive spreadsheet interface using Django & HTMX to simplify go to market strategy for businesses.
oDesign, build, configure and test ETL solutions that originate from ingesting marketing data sources to data manipulation and translation to transformed data residing in specific reportable Client's data stores.
ohttp://listbuilderai.com/
Discontinued Business Projects
Jungle Insights - March 2023 - June 2023 – Used AI to analyze customer reviews, providing actionable insights for product and ad improvements.
oVideo Demo: https://www.youtube.com/watch?v=OLc80dOfa00
Real Estate Investor SaaS – September 2022 – October 2022 - Created interactive Google Map of Florida counties using property appraiser data, enabling real estate investors to filter and identify potential investment properties.
Vyssio - May 2022 - June 2022 – allowed Amazon sellers to fetch their ads data from Amazon’s Advertising API and upload the data into Google Sheets via the Google Docs API. Also let users visualize data with plotly.
oVideo demo: https://www.youtube.com/watch?v=Jw2-rcNqjg8
Tok Lightning - October 2021 - January 2022 – fetched TikTok account data to help TikTok marketing agencies track account performance over time and find inspiration from top TikTok accounts.
Technical Skills
Programming Languages & Frameworks
oFront-End: JavaScript, TypeScript, HTML / HTMX, CSS, React JS, Material UI
oBack-End: Python, Django, Node.js, NestJS, objected oriented programming
oAPIs & Data: GraphQL, REST APIs, JSON, CSV, XML, YAML
Databases & ORMs
oPostgreSQL, MySQL, Microsoft SQL, RDBMS, NoSQL, Elasticsearch
oDjango ORM, Sequelize ORM
Cloud Platforms
oMicrosoft Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP)
DevOps & Continuous Integration / Continuous Development (CICD)
oGitLab, GitHub, GitLab CI/CD, GitHub Actions, Version Control
Containers & Web Servers
oDocker, Docker Compose, Kubernetes, Nginx
AI & Machine Learning
oLangchain, Spacy, Llama, Groq, Claude, Perplexity, OpenAI, GitHub Copilot
oETL with OCR (Image), ETL with Whisper AI (Audio)
Data Analysis & Visualization
oQlikView, Plotly, Pandas, Numpy, Looker Studio, Microsoft Excel
Other Technologies
oCelery, Redis, Auth0
oUnix, Visual Studio Code, Linux, Ubuntu
oMicroservices Architecture, Datadog Monitoring
oSendgrid
Marketing & Automation Tools
oHubspot, Smartlead, NeverBounce, Million Verifier
oMake.com, Zapier, Coupler.io
Project Management
oTrello, AirtTable, Jira, Agile Methodology
Education
The Pennsylvania State University, University Park, PA May 2013
B.S. Mathematics with Actuarial Math Option Statistics Minor
Contact this candidate