Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
MSI RecruitingDatabase Specialist, Consultant
Sep. 2024RemoteTemporary, part-time consultant hired to identify and fix system performance issues and to create Power BI reports and dashboards. Root cause analysis (RCA) shows missing indexes, unused indexes, poorly designed indexes, inefficient code in stored procedures and views, unnecessary use of tempDB, and an under performing database architecture. Identified duplicate and missing data from a data migration project from a legacy system. Responsible for backups of production system and restores to staging environment. • SQL Server
• Power BI
Randstad USADatabase Specialist, Consultant
Dec. 2022 - Dec. 2023RemoteChampioned adoption of Snowflake and aided configuration of Snowflake, conducting training sessions for new users and the IAM team on user and role management. Developed efficient, scalable system for retail promotions, reducing processing time from two hours to two minutes, designed to transition from SQL Server to Snowflake. Spearheaded migration of SQL Server stored procedures and views to newly structured database. Engineered and deployed SQL Server enhancements. Created tables, stored procedures, views, and SQL Agent Jobs. Compiled extensive inventory of databases across servers, detailing schemas, data volumes, and index sizes. • Transformed the approach to retail sales promotions, dramatically enhancing efficiency and scalability.
• Modeled 145 databases using Erwin, significantly enhancing data architecture and governance.
• Numerous projects involving MDM warehouse, other warehouses, and source data.
• Rewrote complex stored procedures and views, moving functionality from one database to another with dissimilar schema and business rules.
• Azure platform, OLTP, OLAP, Bank, HTLF
RGP ClevelandDatabase Specialist, Consultant
Dec. 2021 - Nov. 2022RemoteDesigned large-scale data mart (2+TB) using SQL Server ETL techniques and job scheduling. Developed daily ETL processes in Snowflake using DAG tasks and procedures. Enhanced data operations logging within ETL process, incorporating error reporting and deadlock resolution. Produced educational materials including training videos on data mart operations, promoting knowledge transfer and tool proficiency using Lucid Charts. Utilized Google Tools for project management and collaboration.
• Engineered and merged 10TB data mart in Snowflake, setting benchmark for data integration efficiency. This is the MDM (Master Data Management) used by the analytics group.
• Developed data models for SQL Server and Snowflake databases, including stored procedures and data flow diagrams.
• AWS, GCP platforms, OLAP, Medical/Medicare, Privia Health
ProcurantSenior Database Engineer, Data Analyst, Engineering Support
Oct. 2019 - May. 2021Boca Raton, Florida, United StatesConducted root cause analysis (RCA) and troubleshooting as SQL Server and MongoDB database specialist, enhancing system reliability and data integrity. Generated system usage reports for executive management. Responsible for ETL pipeline processes across multi-terabyte database environments.
• Consolidated data from SQL Server and MongoDB, creating comprehensive KPI reports and dashboards monthly for executive review.
• Built dashboards from KPI analysis for execute management.
• Produced ad-hoc reports for domestic and international customers as requested.
• AWS platform, OLTP, OLAP, Food Safety
ParTech, Inc.Senior Database Engineer, Data Analyst, Engineering Support
Aug. 2013 - Oct. 2019Boca Raton, Florida, United StatesResponsible for ETL pipeline processes across multi-terabyte database environments. Optimized database performance by redesigning indexes, refining SQL queries, and implementing advanced database programming techniques. Led development teams in creating support tools for operational and architectural improvements. Authored technical specifications for syncing databases with mobile devices and implementing geolocation detection. Provided ad hoc reporting and custom ETL services to senior management and premier clients. • Administered the SSIS data processing tasks for customers around the globe and within the country.
• Built Power BI and Excel dashboards from KPI analysis for executive management.
• AWS platform, OLTP, OLAP, Food Safety
Integrated DermatologyDatabase Specialist
Jan. 2011 - Aug. 2013Boca Raton, Florida, United StatesMultiple roles including SQL Server Specialist, Business Analyst, Data Analyst, Database Architect, Database Modeler, Database Developer, and Manager of the Web Application Development Team. Responsible for stored procedures, views, triggers, and indexes. Implemented transactional replication to synchronize data feeds between web applications and IPAD applications and between production and UAT environments. Identified performance problems using SQL Server Profiler. Created ETL processes for importing data for new customers. Created SSRS reports designed for use as programmer tools and systems analysis. Supported programmers by writing stored procedures needed for web application and IPAD application. Created SSIS automation for various database updates. Created Data Models in Visio of all aspects of complex database system. Created automated data dictionary for SQL Server database system. Implemented transactional replication. Queries using Change Data Capture (CDC).
• Practice Management System (PMS), Electronic Health/Medical Records (EMR/EHR), Revenue Cycle management (RCM), and Prescribers’ Digital Reference (PDR). • Architect. Analyst. Developer. Medical records. Medical billing. Statistical reports
• ICD-9, ICD-10, CPT, NPI, HL7, HIPAA, Rx, • On Premise, Colocation, OLTP, OLAP, Medical
I-Tech SolutionsIT Consultant
Mar. 2009 - Dec. 2010Des Moines, Iowa, United StatesBuilt a home mortgage database that included data by merging mortgage, property tax, trust information, foreclosure information, etc. from multiple major financial institutions including Wells Fargo, First American, Fidelity, and others. The goal was to have a complete home mortgage database (Master Data Management MDM).
• Redesign databases, data flow, and ETL data extraction and cleaning process of hundreds of millions of records for a third-party client, a major financial institution (WF). Implement QA automation, restart procedures, and audit trail. Imported data feeds from multiple sources, cleaned and merged the data into new databases, which were then sent on to another process for loading into a subscription data system.
• Created hundreds of T-SQL queries, stored procedures and functions in SQL Server 2005/8 Management Studio (SSMS).
• Created reports in SQL Server 2005/8 Reporting Services (SSRS) including matrix (pivot table) reports and drilldown reports.
• Developed SQL Server 2005/8 Integration Services (SSIS) packages for ETL processes, including T-SQL and VSA scripts in VB.Net.
• Developed stored procedures and CLR functions in VB.Net to error check and transform data from flat files and load into database tables.
• Optimized ETL processes for improved performance.
• Develop web applications in ASP.Net, AJAX, VB.Net, and C#.
Intch is a Professional Networking App for the Future of WorkSee more people like Valonne on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
42451 people
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC
25
Tech Analyst @ Capital Online Trade