Senior Technical Consultant
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.
- e-mail williameduardo79@gmail.com
- Phone +1 754-422-9110
What William Mendoza can do
Resume
Experience
2001 - Current
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 more than 5 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