William Mendoza

About Me

I'm a Senior Software Engineer and a Senior Technical Consultant skilled in solving problems and crafting cost-effective solutions. I've successfully integrated enterprise systems using Microsoft Azure and AWS, and built robust full-stack web applications. Clients appreciate my reliability and ability to explain technical details in a way that makes sense to them. I am known for delivering successful projects that exceed expectations through innovative problem-solving.

  • Experience in data manipulation and data migration.
  • Experience creating, connecting, testing, and using API's.
  • Experience integrating systems.
  • Experience in MS-SQL development, T-SQL, DAX, ETL, and architecture.
  • Experience with web technologies
  • Experience with Reporting Services (SSRS), and Crystal reports.
  • Experience in Business Intelligence and Professional Services working closely with clients to analyze and document their specific requirements.
  • Experience with Microsoft Azure and AWS.
  • Experience setting up and managing multiple data visualization tools such as Power BI, Tableau, D3, and SSIS.
  • Management and consulting experience.
  • Self-managing, self-motivated, and quick learner.
  • Strong organizational, problem-solving, and analytical skills.
  • Fluent in English and Spanish.
  • Excellent communication skills, and teaching skills.
  • Worked with sensitive information.
  • Take the initiative to find solutions and improve productivity.

What William Mendoza can do:

Integrations

Research and/or develop integration scripts, API gateways, or Webhooks to consume data from one application to another.

Cloud Solutions

Serverless applications with Azure and/or AWS

Lead a Team

I possess an innate ability to inspire others with the company vision and empower each member to contribute their best. My adept communication skills and inclusive leadership style foster collaboration, ensuring everyone's strengths are utilized effectively toward common goals.

Outsourcing

My strategic mindset, enables me to identify tasks suitable for delegation and select competent partners to execute them efficiently maximizing the benefits of outsourcing while maintaining quality standards.

Full-Stack .Net Development

Web application and e-commerce design for any need

Back-end Process

Automation of processes.

Data Migrations / ETL

Migrate data from one system to another and/or extract and transform data for various purposes.

Project Management

My strong leadership capabilities enable me to motivate team members, resolve conflicts, and adapt to changing circumstances, ensuring successful project completion while fostering a collaborative and productive work environment.

Veeva SDK

Create triggers, Create Objects, Import/Export Data, Create Jobs, Create solutions.

Resume

Experience

2020 - Current
Krypto It - Freelancer

Senior Full Stack Developer

  • Created data visualizations using Power Bi.
  • Created a web portal using C# Net Core to keep track of prospects, customers, and projects.
  • Designed and architect Databases with SQL Server.
  • Architect a solution in C# to automatically print from Woocommerce when orders are paid.
  • Managed outsourcing projects for custom development.
  • Maintain and update SSRS reports.
  • Built a full-stack payment system for monthly subscriptions using C# and Microsoft Azure that integrates with Adobe Cloud for PDF invoicing.
  • Outsource IT projects and tasks.
  • Managed AWS and Azure environments.

2021 - 2024
Veeva Systems

Senior Technical Consultant

Project Management:

work closely with clients and their teams to properly assess timeframes and deliverables.

  • Create reusable, robust, reliable, and cost-effective solutions that save more than $28,000.00 on future projects.
  • Coordinate meetings to learn existing processes and gather requirements to create workflows and timelines of deliverables.
  • Evaluate the amount of work needed to complete the application lifecycle by breaking the project into deliverable units.

Developer:

Build solution designs based on requirements within budget and timelines.

  • Save 2 million dollars a year by integrating medical trial software that prevents human error duplicate entries.
  • Modify integration scripts that will result in a reusable process that will reduce development hours by 20%.
  • Adapt to requirement changes and budget adjustments by creating cloud solutions that would easily adapt to modifications.

Cloud Engineer:

Develop creative solutions using AWS services and best practices for data migrations and integrations that are scalable and within budget.

  • Program over 20 lambda functions with JAVA and design over 50 MySQL databases for ETL processes.
  • Create workflow charts, documentation, and test plans for user acceptance testing (UAT).
  • Monitor integrations by creating status reports and flash reports based on logs.

Advisor:

Offer expertise in Veeva Systems implementation and best practices to customers when solutions are under client ownership.

  • Create and present demonstrations on how to properly call the API and answer questions related to API limitations.
  • Raise concerns to the customer when their planning hits the limitations of the API and provide solutions or alternatives to challenges.
  • Spearheaded a customized safety integration project from inception to delivery.

Veeva White Belt Certified:

Fine-tuned existing Veeva SDK custom scripts that run based on user actions throughout the application.

  • Standardize the use of the SDK by creating libraries that reduce trigger development from 40 hours to 8 hours a week.
  • Modify over 100 triggers improving execution time from 20 seconds to 1 second.
  • Create JAVA SDK scripts called triggers that generate data validation messages based on user entries.
  • Manage and develop triggers for CTMS and CDMS for multiple clients to prevent human error.
  • Integrated non Veeva EDC systems with CTMS to centralize data management.
2012 - 2020
Ledgex Systems

Lead Technical Consultant

Management

Oversaw the professional services department of a hedge fund software called Ledgex by estimating resources, hiring personnel, trainingpeers, handling escalations, and planning application lifecycles.

  • Negotiated billable hours with clients, offering a discounted set of hours when purchasing a block in advance, increasing company revenue by 80%.
  • Hired and trained data analysts on the proper use of SSRS and querying SQL Server data to prevent locks.
  • Developed a coverage plan for escalation issues to provide fast resolution.
Full Stack Developer:

Developed and maintained a full stack MVC investor portal that would integrate with Ledgex for investor access.

  • Reduced escalations by 60% programming application health check reports.
  • Reviewed, approved, and denied code pull requests using GitHub to keep best practices and code readability.
  • Reimagined front-end controls using Telerik tools for a better user experience.
  • Designed the backend with C#, SQL Server, and Dapper for CRUD operations using stored procedures, views, and functions.
Cloud Engineer:

Built a serverless reporting solution with Power BI and SSRS embedded in the application dashboards for data visualizations.

  • Increased productivity by 30% by creating report templates for custom report offerings.
  • Created connectors and over 20 API endpoints for SSRS consumption and data visualizations.
  • Implemented Power BI over other reporting solutions such as Tableau, and Crystal Reports by researching and learning their compatibility with Ledgex.
  • Developed Azure functions using C# for data migrations and scheduled tasks.
Team Player:

Teamed up with the product developers to create enhancements to the application that would benefit client integrations and professional services.

  • Collaborated in the Ledgex API development for reporting consumption and data migrations.
  • Added storyboards and contributed to scrum meetings when needed.
  • Crafted proof of concept modules and enhancements for future application features based on customer needs.
2011 - 2012
Eliza Corporation

Data Analyst

Create multiple SSIS packages at Eliza Corp to import files into SQL Server for the voice recognition software.

  • Built a .Net full stack application dashboard that would connect to SSIS packages to report on failed packages to reduce over 1000 email notifications from packages
  • Developed over 50 SSIS packages to load data into multiple databases for multitenant clients.
2010 - 2011
VPX Pharmaceutics

Developer

Built a complex API application to support front-end applications Mobile and Web for VPX Pharmaceuticals.

  • Maintained, supported, and extended the ASP.Net e-commerce website.
  • Build administrative web pages for other departments to add web content.
  • Developed a SQL Server database based on business workflow for the API.
2008-2009
IDN

Developer

Built a reporting solution for IDN.

  • Created multiple Business solutions by implementing SSRS, ETL, and SSIS to be accessed through an intranet website.
  • Supported existing Crystal Reports by creating and optimizing reports and T-SQL queries.
  • Created an intranet website using VB.net and ASP.Net technology implementing sitemaps, master pages, JavaScript, AJAX, CSS, and IIS.
2007-2008
Kaplan University

Data Analyst

Provided 3rd-level support for Campus Vue application.

  • Configured the student portal for 100 campuses so students can log into their classes online using .net technology while providing application support over the phone.
  • Modified Crystal Reports with SQL statements when needed.
  • Used various SQL tools to find and fix issues and create T-SQL scripts to fix application errors.
2005-2007
Morris 4x4 Center

Developer

Saved Jeep Morris $20,000 in a 3-month period by developing an online price update system using .Net and SQL.

  • Created multiple ASP.Net applications for employees to locate merchandise, prizes, descriptions, and competitors info using VB.NET technology and AJAX.
  • Created an ETL process that uploaded Excel or Access files to SQL 2005 manipulating data to make changes on product prices and information.
  • Leaded the data department

Education

2008
American Intercontinental University

Bachelor in Information Technology

100% means 10 years of experience.

Management Skills

Leadership

15 years

Communication

20 years

Team Building

15 years

Adaptability

9 years

Coding Skills

C#

15 years

JavaScript

15 years

PHP

6 years

Phyton

3 years

HTML/CSS

20 years

SQL

20 years

Java

3 years

Cloud Skills

Azure

10 years

AWS

9 years

Google Cloud

2 years

Reporting Skills

SSRS

15 years

Microsoft Power BI

8 years

Tableau

4 years

Crystal Reports

5 years

Other Skills

EDC Systems - Veeva CDMS, CTMS, RIM, Medidata

100%

Github

100%

Docker

80%

Linux

20%

Networking

70%

Customer Service

100%

Server Administration

90%

Oracle

40%

SQL Server

100%

MySQL

100%

PostgreSQL

30%

MVC

100%

Razor

100%

Blazor

95%

Web API

100%

Knowledges

  • Full-Stack
  • Management
  • Developer
  • .Net
  • SQL
  • AWS
  • Azure
  • Bilingual (English and Spanish)
  • Veeva White Belt
  • ETL
  • SSRS
  • MVC
  • Web API
  • Razor
  • Blazor
  • HTML
  • CSS
  • Javascript
  • C#
  • Java
  • VB.Net

Certificates

Vault Platform Associate Administrator

Membership ID: e46a28b8-d688-4161-b885-da9bce90029a
December 31, 2024
Veeva Systems

Vault Platform Associate Administrator

Membership ID: b3382b97-6b51-4cf9-a032-a87f3976bc51
December 31, 2023
Veeva Systems