Joseph Serrano Email & Phone Number

Lake Forest, Ca, Us

Lake Forest, Ca, Us

Seattle, Wa, Us

#FoundItOnAmazon-ShopByInterest is new program that shift the way customers shop on amazon. The program offers customers a full sale funnel experience shows casing contents and inspiring them to new interests; then be able to purchase products directly from Amazon. I oversee developing and maintaining the analytics & insights roadmap supporting 7+ teams across multiple organizations with a team of 3+ engineers (Data Engineer, BIE, Data Scientist).❖ Created and implement a data analytics suite for over 250+ stakeholders across several business partners.❖ Developed and scale high quality data warehouse projects across multiples vertical, report-ing numbers to VP/Board of directors.❖ Developed a time spent metric across Amazon to help page owners better understand customers behavior.❖ Lead a new sale attribution model oriented towards the benefit of upper funnel shopping.❖ Architect / Lead the implementation of a data lakes supporting business metrics across 3 organizations.❖ Performed several deep dives on customer behavior, segmentation, ingress, content performance & acquisition.❖ Created, maintain and coach teams to use proper A/B testing framework.❖ Implemented several deep dive analysis to resolve customer problems across multiple teams.

Wilmington, Ca, Us

Trapac is a container terminal operator and vessel stevedore that provides port terminal services to the U.S. West Coast. I am in charge of a team of 12 developers as well as managing the SDLC process from creation to delivery to end-users.❖ Build a successful team of self-independent engineers, promoted and mentored team members on career growth.❖ Implement full SDLC process and CI/CD pipelines increasing productivity by 50% and dropping production rollback to 0.❖ Created a service to optimize the stacking of containers in the yard to help to reduce vessels & trucks & rails turnaround time.❖ Created near real time data solution to capture all the events from the yard to help support and operations team to point problem as they arrived. ❖ Mentor QA team on testing methodology and approach.❖ Weekly code review of the team members.❖ Project management and code delivery.❖ Release schedule and planning across all projects and stakeholders.

Irvine, Ca, Us

Stratacare is a web-based software company reviewing medical bills for insurance companies. In charge of leading a team of 8 on-site and 4 off-shore database developers. Insure that the code delivered meet company standard.❖ Lead and develop an Angular 4 application / C# web API. ❖ Lead data load automation projects and lead the transition to off shore team members.❖ Trained team members on newer technology.❖ Put in place new processes to optimize software delivery quality.❖ Lead several new EDI interfaces projects.

- Analyzed the current Data Warehouse and created a migration plan to the newer version. (Data Dictionary, ETL/Reports migration strategy) - Implemented new process management capabilities with the help of TFS to monitor DW project.- Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the data warehouse- Developed several web self-applications.- Redesign and improve many existing logic to a more efficient way.- Designed and created a cost system for the laboratory.- Create several reports to help the sales department and CFO to take better decision on clients (Using the new cost system).

Irvine, Ca, Us

- Create complex stored procedures to transfer data using different rules and cross reference tables.- Modified and optimize slow stored procedures using different optimization techniques.- Created/modified SSIS packages according to the business requirements.- Created several mapping with the help of a 3rd party software. (Pervasive)- Create stored procedures, functions and logic to parse and cleanse data.- Backup/Restore databases using Full backup and/or snapshot.

Master Of Business Administration - Mba

Master’S Degree, Computer Science