William Mendoza

About Me

I am a senior software engineer with over 20 years of experience specializing in building and managing software solutions. My experience ranges from cloud solutions, data transformations, API integrations, and web technologies. Recognized for my proficiency in leading full-stack cloud development, designing and scripting databases, and expertise in Business Intelligence. A proactive and self-motivated professional with excellent communication and leadership skills.

  • 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.

Full-Stack .Net Development

Web application and e-commerce design for any need

Data Migrations

Migrate data from one application to another.

Cloud Solutions

Serverless applications with Azure and/or AWS

Back-end Process

Automation of processes.

ETL

Extract, transform, load using different techniques and tools.

Resume

Experience

2001 - Current
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 more than 5 years of experience.

Management Skills

Leadership

100%

Communication

100%

Team Building

100%

Adaptability

99%

Coding Skills

C#

100%

JavaScript

100%

PHP

60%

Phyton

30%

HTML/CSS

100%

SQL

100%

Java

80%

Cloud Skills

Azure

100%

AWS

90%

Google Cloud

20%

Reporting Skills

SSRS

100%

Microsoft Power BI

90%

Tableau

40%

Crystal Reports

50%

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