Sql Server Back-End
Resume:
Clark H Vera
**** * ***** **, ******** CO 80232
Summary of Qualifications:
• Expert in SSRS Dashboards, Power BI, Mobile Reporting, Tableau
• Expert in Stored Procedures: Microsoft SQL Server, PostgreSQL, and MySQL.
• SSRS Server Configuration and deployment with multiple clients and large dataset sets
• Experienced with Azure SQL Server & Postgres, AWS SQL Server, Docker
• Skilled in Linked Server Queries from SQL Server to Azure & Oracle MySQL.
• Proficient in high-volume website and database design (handling growth of 10 million transactions per day), and large database deployments.
• ERP ETL experience using SSIS and Stored Procedures; skilled in replication and backup. Experienced in Data Warehouses with large datasets
• Skilled in migrating various database structures to SQL and Salesforce.
• Experienced in various languages and scripts: Python/C#/Xamarin, Visual Basic
• Experienced in Project Management, HIPPA Medical requirements, & Jira and Technical Support
Professional Experience:
SwSocial.co, DBA and Reporting
Dec 2023 to Present
• Migrated the system from Azure to a dedicated Linux server, including Docker container migration.
• Introduced Tableau
• Created the first Data Warehouse for this company.
• Created over 30 functions and stored procedures for a modern app with unique features, including real-time mapping.
• Repaired database calls by decompiling Docker DLLs in .NET.
• Dashboards for tracking geographic growth and revenue goals.
• Contract Position
****************@*****.***
https://www.linkedin.com/in/clarkvera
American Auto Shield / Car Shield, Contract Database Engineer/ Reporting Engineer Dec 2020 – July 2022
• Built SSRS Reports for analyzing and reporting on Unidata-converted data.
• Extracted and refactored data from a legacy Unidata system into a relational database format, then installed it into Microsoft Azure SQL Server.
• Collaborated with Salesforce engineers to integrate claims data into the Salesforce database.
• Utilized CDATA to insert and update records directly in Salesforce.
• Became proficient in Unidata, Azure, and SQL Server for claims processing.
• Built SSRS Reports for analyzing and reporting on Unidata-converted data. Brandwise.com, Database Engineer / Reporting Specialist June 2018 – April 2020
• Developed complex stored procedures and SQL SSRS Reports.
• Created SSRS reports for iPad and Mobile Reporting for iPhone and Android platforms.
• Deployed replication for large volume databases and processed data from clients’ ERP systems into the Brandwise database.
• Optimized procedures to insert into Data Warehouses
• Developed new software for iPad reporting utilizing SQL mobile reports.
• Experienced severe downsizing and layoffs due to COVID-19. TruEnergy, DBA
July 2012 – Feb 2016
• Deployed SSRS for reporting services across multiple services
• Created an automated CRM solution with a quoting engine for an energy company in the deregulated energy industry.
• Developed extensive Postgres and MySQL and SQL Server stored procedures, as well as Python/JavaScript applications.
• Led a team of three junior PHP developers in Lima, Peru, enabling 20% monthly growth and expansion to three call centers in Oklahoma.
Superleads.com, DBA & CTO
2004 – 2012
• Developed database technology and front end, bootstrapping the company from startup to
$7.2 million in the second year.
• Hired and trained sales reps and established multiple call centers in Lima, Peru.
• Created Asterisk telephone servers with MySQL linked to SQL Server.
• Integrated health insurance leads into major carriers like Blue Cross and Mega Life & Health.
• The company was sold in 2012.
InsureMe.com, CTO and DBA
1999 – 2004
• Developed the database, back end, and front-end websites, hiring and training entry-level developers.
• Created custom CRM and affiliate tracking systems, collaborating closely with sales and marketing teams.
• Contributed to the company's growth from $600K in the first year to $64 million in annual revenue, leading to its acquisition by Bankrate.com for $85 million. Technology Summary:
• Database design and management: Postgres, Microsoft SQL Server (2000–2017), DMV's for performance monitoring, debugging, and optimization, Linked Servers.
• Technologies: Axure, Postgres, AWS SQL, Linked Servers, SQL, MySQL, Docker, Linux.
• Database features: Postgres Foreign tables, Azure Elastic tables, MySQL Federated tables, SQL Agent jobs.
• Programming: JavaScript, PHP, Ajax, jQuery, .NET, Python, SSRS, SSIS, Mobile Reporting, Xamarin.
• Agile Software Development and Project Management.
• Experience in hiring and developing offshore software teams. Education:
• Bachelor of Science in Geophysical Engineering, with Minors in Economics and Geology
• Colorado School of Mines, Golden, Colorado
Personal Notes:
• U.S. Citizen, born and raised in Denver, Colorado.
• Bilingual in English and Spanish.
Contact this candidate