Senior Technical Consultant
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.
- e-mail williameduardo79@gmail.com
- Phone +1 754-422-9110
What William Mendoza can do:
Resume
Experience
2020 - Current
Krypto It - FreelancerSenior 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 SystemsSenior 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 SystemsLead 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 CorporationData 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 PharmaceuticsDeveloper
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
IDNDeveloper
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 UniversityData 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 CenterDeveloper
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 UniversityBachelor in Information Technology
100% means 10 years of experience.
Management Skills
Leadership
Communication
Team Building
Adaptability
Coding Skills
C#
JavaScript
PHP
Phyton
HTML/CSS
SQL
Java
Cloud Skills
Azure
AWS
Google Cloud
Reporting Skills
SSRS
Microsoft Power BI
Tableau
Crystal Reports
Other Skills
EDC Systems - Veeva CDMS, CTMS, RIM, Medidata
Github
Docker
Linux
Networking
Customer Service
Server Administration
Oracle
SQL Server
MySQL
PostgreSQL
MVC
Razor
Blazor
Web API
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