User details
AC
AC
Andrew Chen
@andrew_chen_djgrevwxw
Database Architect
Lake Los Angeles, CA, United States
0Follower0Following0Mutual0Post
Member since: Jan 22, 2025Software and data solutions professional with experience ranging from startups to enterprise and consulting environments. Strong technical skills with cloud and micro services, large dataset, streaming, database and data modeling. Well-rounded software development lifecycle from requirements and design to deployment and support. Effectively communicate project requirements to product, technical, and business groups. Self-motivated, resourceful, customer-focused, independent, and team-focused with strong leadership and management skills. Seeking a lead or senior engineering position.
Manager and software engineer, designed and developed custom solutions and integrations in php/python/js/sql for clients, led customer level 3 software support team. Accomplishments include:
• Hired, managed and mentored a team of 4 software support engineers (Pakistan).
• Managed and mentored a team of 3 software solutions engineers (UK, Pakistan, and US).
• Software support team resolved ~95 support tickets per quarter, ticket backlog reduced from 1600+ to single digit.
• Standardized SDLC process for both teams (naming conventions, git process, code review/PR, test, deploy, document).
• Established robust process and automation for updating client data and configuration.
• Created GDPR/CCPA framework to scrub PII data upon client request (ip address, email, phone, xml lead data).
• Created table-driven data retention, backup, deletion framework for click and conversion traffic, and log data.
• Developed multi-tenant ETL Lambda functions to export custom data to external storage (s3, gcs, email).
• Developed multi-tenant data update and reporting tools (python, rds/postgres, sql, php, js, ag-grid, iframe).
• Developed custom APIs within the CAKE platform for customer specific functionality and reports.
Senior Data Engineer specializing in large volume, high-velocity data (10+ billion/month), data architecture, query troubleshooting and optimization, real-time data aggregation and reporting. Accomplishments include:
• Developed new data pipeline in golang and scala using AWS SNS, SQS, Redshift, Aurora, Athena, S3, DynamoDB.
• Large scale migration of SQL databases from on-premises to AWS servers (850+ online client databases).
• Created alerts for failed processes, slow connectivity, database mirroring, click and event data thresholds.
• Created CPC and CPM synchronization process between AWS Aurora and Redshift and SQL Server.
• Enhanced process for archiving very large databases (> 6TB), daily import and export of client data (> 80mm).
• Work with DevOps to create process for new AWS SQL Server setup.
• Successfully deployed database changes and new features (300+) across entire cloud platform.
• Managed SQL request queue for both customers and internal stakeholders.
• Trained junior developers to write and troubleshoot SQL stored procedures.
Senior Software Engineer specializing in large datasets, data architecture, MongoDB/NoSQL research, query optimization, Jenkins continuous integration and build process, application development and setup. Accomplishments include:
• Research and presented the pros and cons of RDBMS vs. NoSQL, with emphasis on MongoDB.
• Reduced continuous integration build process from 9 hours down to
Web and client/server applications architect. Specializing in database design, modeling and migration, legacy data conversion, performance optimization, and application development. Accomplishments include:
• Designed and developed a more efficient logical and physical data model for enterprise property risk management.
• Backend database conversion from Sybase ASA to Microsoft SQL Server (400 tables/500 sprocs).
• Hands-on offshore management of 6 software engineers in India for database conversion project.
• Increased database performance by 400%.
• Decreased database migration defects by 50% using automation instead of manual processes. Created the product roadmap and directed development of CocoCommerce's core product, COCOXT™. COCOXT is web-based enterprise collaboration software that provides business process management, order-to-cash, electronic invoice presentment and payment, online negotiation and dispute resolution, and financial transaction settlement.
• Hands-on management of 5 software engineers specializing in ASP, XML, VB/COM, SQL Server; and 3 QA engineers.
• Managed the conversion of COCOXT from 2-Tier ASP to 3-Tier VB/COM architecture.
• Created user documentation and product development roadmap for COCOXT.
• Established formal change management process (TestTrack) and QA test process environment.
• Defined performance benchmarks and automated test plans (Rational tools).
Created the product roadmap and directed development of CocoCommerce’s core product, COCOXT™. COCOXT is web-based enterprise collaboration software that provides business process management, order-to-cash, electronic invoice presentment and payment, online negotiation and dispute resolution, and financial transaction settlement.
• Hands-on management of 5 software engineers specializing in ASP, XML, VB/COM, SQL Server; and 3 QA engineers.
• Managed the conversion of COCOXT from 2-Tier ASP to 3-Tier VB/COM architecture.
• Created user documentation and product development roadmap for COCOXT.
• Established formal change management process (TestTrack) and QA test process environment.
• Defined performance benchmarks and automated test plans (Rational tools).
Responsible for network infrastructure, software specifications, technical whitepapers, staffing, training, and managing the development of REDSonic products. REDSonic specializes in real-time embedded Linux software for internet appliances, networking devices, and embedded systems. . Co-founder of REDSonic, assisted in securing $4M in Round A fund raising.
• Hired and developed a team of 8 software engineers (C/C++, Java, perl, python), 6 sales and marketing personnel.
• Created technical specifications for RED-Builder, RED-Probe, and REDICE-Linux SDK.
• Established change management process (CVS), QA environment, benchmarks, and technical support department.
• Responsible for the delivery of first versions of REDSonic, shrink-wrap products.
• Developed marketing concepts, written content, and direct mail pieces.
• Participated in customer visits, presentations, product demonstrations, trade shows, and technical forums.