• Created and managed ETL processes with SQL scripts and stored procedures to load via Javascript between external SQL Databases and Salesforce.• Developed Python scripts to extract and transform data from APIs utilizing JSON, XML, HTML, pandas, sqlalchemy, pyodbc, & numpy to efficiently migrated data in a MS SQL Database.• Implemented and designed Salesforce CRM for internal use. Migrated all data from Microsoft Dynamics to Salesforce. Maintained Salesforce through administration. • Produced reports and analytics for internal use and clients via SQL & Salesforce using visualization tools such as Cognos BI, Microsoft Power BI, & Tableau. Linked multiple databases and Salesforce through Power BI and Python for cross data visualization.• Developed custom Apex classes to integrate with other software within salesforce and help automate workflow processes.

Worked with VNC and Putty to manage equipment on machines at port. Identified and resolved IT issues with equipment. Remotely provided support and communicated with vendors to resolve issues in a timely manner.

• Developed database in Microsoft SQL Server to manage data for Long Beach port operations regarding finances used for invoicing. Exported data into Power BI for analysis and presentation.• Created and managed excel macros using VBA to automate creation of invoices and management of data. On call support to assist users. • Created a front-end GUI in C# and Visual Studio for users to upload, modify, and save data. Utilized SQL queries to create imports to upload to financial management systems through EDI.

Audio/Visual support for Chapman University. Set up and striking of audio/visual equipment for events across campus. Answered in office phone calls relating to the scheduling of events, technology assistance, and general questions. Recorded events for clients. Responded to calls for classroom support providing immediate assistance.

Worked as a Stage Manger for multiple shows. Responded to issues with production first hand. Helped with construction of sets. Rewired lighting cables. Communicated between staff for productions. Communicated between client and staff. Organized back stage props, microphones, and various other equipment. Assisted with general office tasks.

Maintenance of campus wide desktop computers and laptops. Cloned and installed hard-drives on computers. Assisted with technology issues for summer classes. Prepared classroom technology for the school year. Assisted with the network management and windows work group and windows domain.