• Developed a batch-processing ETL data pipeline using Python for data transformations, Airflow for orchestration, and Spark for data processing. Migrated transactional POS data from various on-premise systems to a local database, ensuring data integrity and formatting. Implemented local file storage for backup, resulting in a reduction of 14+ hours weekly in manual data recording.• Architected and implemented a RESTful API using Flask, serving as a gateway for controlled data access. This API included authentication strategies and efficiently retrieved data from a local PostgreSQL database using SQLAlchemy as the ORM.• Developed a Data Dashboard Application using Django, SQLAlchemy, PostgreSQL, and Dash by Plotly. Leveraged the custom-built RESTful API to fetch and visualize data. Through streamlined data analytics, identified over-staffed shifts, achieving a 5% reduction in labor costs ($110k/year) and improving one location’s ratings from 3.6 to 4.3 stars

• Developed and tested a context-switch feature in a Python based CLI tool, enabling users to smoothly transition between AWS cloud environments. Enhanced CI/CD pipeline automation by integrating the CLI tool’s functionality with a middleware to reduce manual intervention in deployment process. Resulted in a 95% reduction in weekly deployments, from 2 hours to 5 minutes.• Managed weekly builds and deployments, enhancing the release process through automation efforts utilizing Jenkins, Bash, and Python. Designed and implemented automation workflows for 2 cross-functional agile teams struggling with manual deployment challenges. Contributed to saving 10 hours weekly, enabling teams to focus on higher-value tasks.• Enhanced Jenkins workflow using AMI and CloudFormation. Automated updates in 50+ repos, collaborating with DevOps for 70% labor savings and 3x faster deployments.

• Prototyped a skill-matching application on Airtable to optimize the sales team’s consultant staffing process. Upgraded the prototype into a single-page application using Node.js, Express, and React enabling managers to sort consultants based on their relevance to business needs using word2vec and K-means clustering. Reduced the sales team workload by 10+ hours weekly.• Analyzed and structured 150+ contracts across Payroll, HR integrations, and IT initiatives worth $700k. Leveraged internal contract management software and achieved a $350k budget reduction, reallocating funds for further project opportunities.

• Designed, developed, and tested an ETL utility program for Data Migration services, leveraging Python, PySpark, and Hadoop to address common data transformation use cases for NetSuite format. Orchestrated workflows using Apache Airflow for transformations and uploads. Integrated RESTful API for data uploads, resulting in a 35% reduction in data migration hours.• Led the implementation of NetSuite Oracle ERP for 20+ businesses including the generation of custom financial reports using Oracle SQL, resulting in 25% higher financial reporting accuracy and a 30% reduction in manual data entry efforts.

• Identified 3,000+ customer account records requiring reformatting using SQL queries and implemented a Python script to automate data reformatting. Resulted in a reduction of an estimated 50 hours saved in manual review and update time.• Mitigated compliance risks by verifying client data for transactions up to $1M+, resulting in a 97% decrease in account errors.