Julio Guzman Email & Phone Number

Salt Lake City, Ut, Us

Marcy-L'Étoile, Auvergne-Rhône-Alpes, Fr

Primarily using C#, .NET MAUI, and unit testing framework NUnit in conjunction with Angular and SQL for the ongoing development of diagnostic testing technology for infectious diseasesWorking within a Scrum team, we are employing agile methodologies for efficient and iterative project delivery.

Salt Lake City, Utah, Us

Leveraged Figma, Google Analytics, Salesforce (APEX, CSS, Experience Builder, JavaScript, LWC’s, SOQL, Tokens), Node.js, third party proprietary technologies (analytics and development) to build software and tools that best serve small businesses

Salt Lake City, Utah, Us

Built website landing page via Salesforce Lightning Web Components and APEX to test data injection into data fields created by external vendorCustomized and automated (sent daily via email with excel attachment in addition to email body) Lightning URI Event report via Salesforce APEX and SOQL to see who is creating, deleting, reading, or updating records in our Salesforce OrgDeveloped code via APEX and JavaScript to perform POST request to REST API using data from website

Salt Lake City, Utah, Us

Managed 8 client by building surveys, reports, and dashboards using InMoment’s proprietary softwareImplemented JavaScript to perform QA and build over 10 survey logicsLeveraged CSS and HTML to design survey graphics

Salt Lake City, Utah, Us

New York, New York, Us

Automated reports and daily functions resulting in a total time savings of 600+ hours and counting, utilizing Microsoft Excel Visual Basic for ApplicationsCarried out multiple projects with local and global teams to increase daily processing time savings, reduce risk, and yield higher profits across the firmAnalyzed, reconciled, and processed over hundreds of Corporate Actions such as Liquidations, Maturities, Mergers, and Name Changes up to 5 billion USD value for our clients’ and firm’s positionsManipulated data via excel pivot tables and VLOOKUPS to resolve cash and stock discrepancies on thousands of client, firm, and custodian accountsTrained new hires and current colleagues on functions, systems logic/communication, and other teams financial, reputational, and risk impact to our team’s Key Performance Indicators (KPIs)

New York, New York, Us

Automate reports and daily functions resulting in a total time savings of approximately 100+ hours and counting utilizing Microsoft Excel Visual Basic for ApplicationsCarry out multiple projects with other teams to increase daily processing time savings, reduce risk, and yield higher profits across the firmProcess over hundreds of company Corporate Actions such as Liquidations, Maturities, Mergers, and Name Changes up to 5 billion USD value for our client’s and firm’s positionsMentored and assisted 5 interns who successfully received and accepted returning offers throughout a 3 month rigorous summer intern program.

New York, New York, Us

Created databases using Microsoft Access VBA to consolidate daily reports and identify areas of inefficiencies through data analysisImproved efficiency within systems used by global teams through multiple projects focusing on schedule management and employee knowledgeAnalyzed complexity, criticality, and risk levels of more than 50 tools including applications, excel sheets, and external websites used throughout the company and identified and strengthened weaknesses

Rigorous 9 month program with two focal points: “How to write a business plan" and "Major components of a business plan"Developed a business plan of creating a digital calendar that syncs with phone and other calendarsPresented business plan to alumni, the board, and investorsCreated monthly income statement and balance sheet projections, up to three years on a cash basis, for business planPerformed intensive market research through interviews, questionnaires, surveys, and via the web

Washington, Dc, Us

Created techniques to archive 80 years of data, which helps save countless hours when researchingResearched and presented, to Senior Management, on the 1.2 trillion student loan debt in America alongside providing possible alternative solutions and its effects on FDIC bank membersRated banks based on the CAMELS rating system while also analyzing each bank’s Uniform Bank Performance Report during Bank Examination School

New York, Ny, Us

Performed stock fundamental and technical analysis using thinkorswim software and financial statementsCreated a 50 page analysis research report on Caesars Entertainment Corporation that was handed to the Senior Vice President of Global Wealth with a no buy recommendationResearched companies by analyzing financial ratios and financial statements

Woodland, Ca, Us

Created excel spreadsheets on data collected before, during, and after harvesting periods, focusing on yield and quality analytics, which I presented to the head of Research and DevelopmentManaged and supervised about 40 harvesters and tractor drivers on a 10-14-hour shift 6 days a weekTraveled to tomato fields in Northern CA to gather and analyze experimental data which helped the company determine type of seeds, number of seeds, and fertilizers helped produce a high rate of yield and quality in tomatoes

Gustine, California, Us

Advised and directed a group of 10 kids in summer youth campCoordinated activities and events such as award ceremonies, games, and registration for 80 kidsInteracted comfortably with the kids and professionally with their parents and sponsorships

Westlake, Ohio, Us

Managed the truck wash shop by maintaining cleanliness and answering client and employee questionsProduced excellent customer/client service by washing their trucks, disinfecting the inside of their trailers, and assisting technicians with oil changes, filter replacements, and grease parts of the truck and trailer

Atlanta, Ga, Us

• 6 week Engineering program held at the University of California Berkeley where I was 1 of 20 high school students accepted globally• Learned Python to build out Magic-8-ball game• Learned Autodesk to engineer and design windmill prototypes which then were tested for quality and efficiency in high wind controlled environments

Master Of Software Development

Bachelor’S Degree, Managerial Economics

Full Stack Web Developer