Dennis Vasquez Email & Phone Number

Las Vegas, Nv, Us

United States

- IT Consulting (SQL Server Development, ETL, Windows Application Dev (.NET), Web Development, etc)- Business Consulting- Internet Marketing Consulting (FB/Meta, Google Ads, Funnels, Copywriting, CRMs, Market Research, Conversion Rate Optimization, Course Creation, etc)- SEO (Search Engine Optimization)- Analyze Trading Data (Futures, Stocks, Crypto, etc) and build out reports, stats and bots. Starting to incorporate AI.- Created/Marketed an Online Course

United States

Tasked with setting up the download and import of EMA/ModMed data to a SQL Server database in order to create reports.Details:- Designed/Created the SQL Server Database to house EMA/ModMed data, and all code (stored procedures, jobs, etc). As well as standard DBA responsibilities (Re-Indexing, Backup, etc)- Set up the full process to download EMA/ModMed data daily, import all the files into the SQL Server DB using PowerShell, and created the ETL processes to transform into useable data- Maintenance that included updating SQL Server tables to ongoing EMA data dictionary changes- Various ongoing Excel reports

United States

Working for various departments, I ended up working exclusively for the Marketing Team for the majority of my time with West Derm.My main focus was developing inside Salesforce Marketing Cloud. But, also included tasks involving creating a custom HL7 interface, countless reports (Visits, Appointments, Conversion Rates, etc), multiple projects and marketing consulting/advice.Details:- Created custom HL7 interface software and database module for Laboratory Information System (LIS), in order to transmit patient biopsy results to EHR system, to meet Meaningful Use guidelines- Helped implement their recall program, within MarketingCloud, which increased their revenue from $300K/yr (in recalls) to over $1M/yr- Set up email, Robo Calls, SMS Journeys that included black out dates, and complicated criteria- Using the backend NextGen SQL Server data and intense data analysis I created monthly reports (using Excel) showing the conversion rates for each call, text and email sent from the recall program. Included in the reports were email subscriber info (new subs, open rates, etc). The conversions showed appointments booked (by marketing efforts) for each of their 50+ locations- Various smaller projects - like setting up a new WordPress for onboarding new doctors, Phreesia consent design/implementation, Podium integration, PhoneTree integrations/maintenance, CallRail implementation/maintenance- Ongoing maintentance, upgrade and support of various MarketingCloud tasks

United States

Worked on an overall project to download ALL their EMA/ModMed data to a SQL Server instance, upload to Salesforce Marketing Cloud and set up a PowerBI environment. Also created a slew of PowerBI reports for gauging effectiveness of marketing initiatives, new/established visits, and many more.Details:- Scoped the necessary requirements to set up a SQL Server instance on AWS- Designed/Created the SQL Server Database to house EMA/ModMed data, and all code (stored procedures, jobs, etc). As well as standard DBA responsibilities (Re-Indexing, Backup, etc)- Set up the full process to download EMA/ModMed data daily, import all the files into the SQL Server DB using PowerShell, and created the ETL processes to transform into useable data- Redesigned their Marketing Cloud set up to include the necessary Data Extensions, Automations+Queries, and other processes to use the aggregated EMA data for (SMS/Email) Journeys- Cleaned up their email list before importing to Marketing Cloud, set up Dynamic Sender Profiles, SAP, etc, to prep sending emails- Trained Marketing team on how to use the Marketing Cloud set up to create emails, Journeys, etc- Worked with Acumatica to download and import their data into SQL Server- Set up PowerBI environment, processes, etc- Created all the stored procedures to support PowerBI reports- Created many PowerBI reports for Marketing, accounting and the CEO- Recorded instructional videos on how to use all the new reports- Maintenance that included updating SQL Server tables to ongoing EMA data dictionary changes- Various ongoing Excel and PowerBI reports

United States

Worked on various web-based projects and supportDetails:- Scraped various websites and aggregated data to show possible profitability of a website- Made this list searchable and expanded the ability to filter according to certain KPIs- Supported, installed for whitelisting clients, etc- Helped with any smaller projects throughout those years

Jersey City, New Jersey

Contracted to work on a Morgan Stanley ProjectDetails:- Optimizing Queries (aggregation Stored Procedures were taking half a day to process. Got it down to a couple of minutes)- Restructured existing databases for more efficiency- Architectured/Created new database for phase 2 Morgan Stanley Project- Misc small application development

United States

Took their organic sales from $3K/month to $30K/month by using optimized SEO strategies.- Wrote high value, subject based quality content and posted on high authority sites- Optimized their sales pages to be more keyword friendly- Created a well formed Keyword Hierarchy for the basis of ALL the on/off site work- Worked to constantly create relevant back links from authority sites

Las Vegas, Nevada

Worked with the marketing department. What started off as a small MS Access Project turned into a 2 year ongoing contract building a SQL Server solution from scratch. Used by the entire company, including varying departments within their 8 Casino properties – I created, maintained, and scaled the database and reports according to evolving needs.- Developed the Corporate Marketing Database for Pinnacle- Developed both the ETL and the QA process for all the data from 8 different casinos- Supported Pinnacle in adhoc Marketing analysis- Scaled a small SQL Server 2000 Database to meet the growing and demanding needs of the marketing department.- Solved many of the problems the marketing team could not figure out previously (ex. Defining/Configuring trips – which is always a challenge for the gaming industry)- Created/Maintained many ETL jobs to pull data from the ACSC and CMS systems from all the casinos Pinnacle owned.- Eliminated a list of static queries by consolidating the code to efficiently create dynamic stored procedures- Performed varying DBA duties, such as managing file groups across many drives because of storage constraints, creating backup jobs, managing security for users, and managing server performance and efficiency- Created a new SQL Server 2005 Database on a larger server and transferred all the data to the new tables- Updated any queries to the newer SQL Server 2005 language/functions/features in order to speed up processes- As more departments across the corporation started relying on the database, more needs arose, tasking me to scale the environment by creating more ETL’s, queries, tables, reports, etc- Later, upgraded the entire 2005 database to the newer SQL Server 2008 – which would reside on a new SAN server

Las Vegas, Nevada, United States

As a sub-contractor, I complete projects assigned to me by the main contractor. These projects may include both SQL Server 2000/2005 and VB.NET 2005. The main project was for a POS system that was used throughout some of the clubs in town. Very heavy object oriented programming (OOP) involvedResponsibilities:- Create user controls to be used in Visual Studio 2005 – complete with Intellisense- Create classes with inherited forms, and keep it very generic in order to be used within other applications- Create new objects, make fixes to established code and other programming functions- Create SQL Server Stored Procedures, User-Defined Functions, etc as needed

Henderson, Nevada, United States

Converted a website created/managed in Front Page to a dynamic ASP website with an Access backend database. The GUI interface I created made it easy to add/manage products on their (new) website.- Added the ability to receive email notifications of sales- Utilized Excel VBA to format invoices for the customer and the company’s distributor- Utilized ASP/VB Script to gather customer info (via SSL) and show an overview of products- Ongoing maintenance of site with upgrades as needed (on retainer)

Henderson, Nevada, United States

As a part of a development team, I had to support, upgrade and design the backend of the Mariposa casino application and distribute to all its clients (10-12 major casinos in Las Vegas, Atlantic City and throughout the USA)Responsibilities included:- Optimized/Maintained a Data Warehouse for all the supported casinos- Optimized data downloads + ETL from Atlantic City to Las Vegas (sped up from 4 hours to 28 minutes)- Rewrote Tables, Stored Procedures, Views, etc to be more efficient, smaller, and compliant to new C#.NET version of the Mariposa application- Helped the onboarding of new casinos by creating custom ETLs for each casino- Worked on many in-house applications using C#, VB.NET and Excel VBA

Las Vegas, Nevada, United States

As part of a development team member- upgraded proprietary software communicating with slot controllers.Responsibilities:- Added automation to coin in polling – allows application to be more interactive with user- Created a new interface to remove/move controllers/slot machines from network without losing vital accounting information using a new VB GUI, various stored procedures, and triggers- Helped in updating reports to include current and historic information about controllers, machines, Jackpot Groups and links. All reports were implemented using Crystal Reports- Created detailed documentation for database dictionary, versioning and flow charts using Visio

New York, United States

As the sole programmer on staff, responsibilities ranged from creating a SQL Server driven Intranet that facilitated the jobs of varied departments; to creating/updating/maintaining a custom-made VB.NET application I created for the credentialing department.Responsibilities:- Daily maintenance of SQL Server: Roles/Users, Tables, maintain security, checking efficiency, writing stored procedures, triggers, user defined functions, etc. The SQL Server (Garden City) was the backend for ALL programs, reports, intranet, etc.- Added functionality in an existing Access project to dynamically complete applications for Aetna, GHI, and other carriers by filling the data into an existing Word Document via VBA- Created an ASP version of an issues management solution for the IT department to help keep track of issues, and sends the new issues as emails to the appropriate individual(s)- Created an ASP/DHTML Computer Based Testing environment for the Training department. Each Trainer/student was able to view my website presenting all relevant information to a particular individual. Features: an Excel-like filter of tests, auto grading, uploads images for questions, posts test scores, administer permissions.- Created a time sensitive (3 days) VB Application to help all 22 QLIMG centers become HIPAA compliant. Saving the company $15,000 in fees, my application was distributed to each center with web cams, where pictures were taken of all 3,000+ employees and saved directly to the main SQL Server Database. Where a separate application printed the IDs- Installed .NET Framework on IIS server. Configured, upgraded the server, and configured all the necessary .config files in order to start using ASP.NET within the organization- Created VB.NET program that downloads HIP files, processes, and prints schedules to be entered into IDX

Las Vegas, Nevada, United States

Responsible for installation of new Visual Basic/SQL Server POS system for all stores in Las Vegas (NV), Kingman (AZ), Lake Havasu City (AZ), Bullhead City (AZ), Washington (WA)Details:- Upgraded all Domino's POS systems by running SQL scripts on-site and manually installing the new application.- Trained District Managers and General Managers on using new system- Working knowledge of Windows 2000, VB, SQL, Networking, Hardware- On-Site/Telephone Customer Support for several 100 employees and managers- Delegation of Responsibilities

New York, New York, United States

Designed and implemented a complete recruiting software database, front-end GUI application, and reporting package with website integration. Scaled to support 200+ employees.Details:- Using Access as the backend - imported data from Paradox 7- Created the Front-end Enterprise Level application using Visual Studio/Visual Basic- Created a custom Encryption/Decryption Module for sensitive data- Created a process to create/upload HTML pages from the local database to their website (this was pre-ASP and it was a static HTML website)- Designed/Implemented reports using Crystal Reports 8- Created all necessary technical documentation for employees to use the application- Created various Excel calculators/applications for accounting department