josejuanisaac AT taveraslopez DOT com
Software engineer with 15+ years of experience in database design & maintenance, data analytics & visualizations, fullstack web development. Proven ability to conduct research in order to produce reports and applications that directly drive organization goals and improve operational processes.
- From May 2023 to present
- Designed, tested and built report automation and distribution pipeline using Microsoft 365 Services (PowerAutomate, OneDrive, Sharepoint, PowerBI), Windows batch scripts and Oracle/SQLPLUS scripts which feature self-refreshing dashboards, manager administered distribution lists and email notifications. Impact: 8 reports were fully automated which impact at least 5 departments comprised of at least 700 personnel, as well as external sales partners.
- Adopted and improved internal Report Gnerator Web App (RGWA). Available reports increased from 15 reports used by 7 users, to 45 reports used by 25 users across 4 departments. New report development time decreased from 5 days to 1 day to allow time for testing and validation. Designed and maintain daily automation pipeline in order to reduce request processing time.
- While functioning as the provisional email marketing administrator, built an (as of this writing) self-hosted URL shortening service in order to supplement the functionality of the in-house email marketing application to provide real time updates on campaign KPIs.
- From October 2022 to December 2022
- From March 2022 to August 2022
- Counted full inventory daily in order to ascertain relevant information for product resupply orders which occurred 3 times a week,
- Learned to manage and supervise each store section: makeline, driver dispatch, backend office,
- Closed and opened store on a weekly basis, ensuring till count and daily deposits are completed accurately and successfully,
- Dealt with customer complaints and follow ups in order to maintain store's good standing.
- From January 2022 to March 2022
- Completed order delivery requests, ensuring all items are accounted for and pizza ingredients match order,
- Contributed to the good working order of the store by learning all store section tasks.
- From 2019 to December 2021,
- Conducted target development such as open-source research and signals analysis,
- Authored and contributed to publishing several reports used by federal organizations,
- Maintained and organized documentation of collected data for presentations,
- Used network analysis tools to produce pattern-of-life visualizations,
- Collaborated in a joint military environment by developing knowledge management and project communication strategies to overcome workspace restrictions imposed by COVID-19,
- Developed browser-based tools to visualize and edit structured data sets (JSON, CSV).
- From 2014 up to 2017, stepped away for 10 months between 2015 and 2016 conducting web development bootcamp,
- Produced descriptive analytics to display aggregate user information using Qlikview BI software,
- Designed query scripts while verifying the data that was produced matched expected results,
- Performed maintenance and optimization on Qlikview backend server.
- Provided project-based development from 2010 to 2015,
- Designed initial SQL ER diagram and implementation using MySQL,
- Integrated Open Source chat software into underlying system and built custom group management interface,
- Implemented payment process flow with local banking provider that used XML SOAP for secure information transfer.
University of Puerto Rico, Mayagüez Campus
- Bachelor of Science in Computer Engineering (2014)
- U.S. ARMY Fully Qualified as Basic Target Digital Network Analyst, Fort Meade, MD (2020)
- Army Analysis and Reporting Course, Goodfellow AFB, San Angelo, TX (2018)
- Web Development Bootcamp, DevBootcamp, San Francisco, CA (2016)
- Front-end: HTML, CSS, JavaScript
- Back-end: PHP/Apache, Ruby/Ruby on Rails
- DB Environments: MySQL, Oracle 11, SQL*Plus, Active Record
- Data Orinted: Excel, Power BI, Qlikview
- MS 365: PowerAutomate, PowerShell
- Languages: Native Spanish, native English, conversational French and Italian.