Dennis H. Email and Phone Number

Clients Include:Estée Lauder CompaniesArizona State UniversityYale UniversityManaged the development of dimensional data warehouses and data marts' physical schemas on the Azure platform, preparing SQL scripts for ETL/ELT pipelines from relational databases (RDMS) and populating staging environments and target Star and Snowflake schemas. Led code reviews, data dictionaries, mapping reviews, and optimized SQL statements while providing architectural guidance. Designed and prepared conceptual, logical, and physical data models, adhering to business intelligence (BI) and data platform principles such as stability, scalability, performance, security, and reusability.Led the development and optimization of AI prompts, improving the accuracy of AI-driven interactions by 30% and user engagement by 25%. Managed the end-to-end development and deployment of chatbot solutions using Generative AI, resulting in a 40% improvement in customer satisfaction and a 35% reduction in response time. Conducted data analysis and QA testing to ensure chatbot responses aligned with business goals, leading to a 50% increase in task automation and a 15% reduction in manual intervention. Optimized prompts for natural language processing, improving chatbot response accuracy by 20% across various platforms.Developed Python scripts to automate the generation of hundreds of DDL scripts, reducing development time by 90%. Optimized SQL and SOQL scripts for data extraction and validation, improving data accuracy by 25% and reducing query execution time by 40%. Leveraged AI and machine learning algorithms to enhance data processing efficiency by 35%, enabling quicker decision-making and streamlining operations.Led the implementation of Azure cloud-based technology projects, transforming data from multiple systems and overseeing SQL optimization, resulting in a 30% improvement in performance and a 20% reduction in infrastructure costs. Applied prompt engineering strategies t...

Lead Data Architect at Marsh & McLennan Companies, Inc.Senior Business Intelligence/Data Engineer at Mindspark Interactive Networks, Inc.Oracle Data Warehouse Architect/Project Manager at RealNetworks Inc.Business Intelligence Specialist II at NYC Housing AuthorityData Analyst at NY Mercantile ExchangeBusiness Analyst at Jewish National FundSenior Management Consultant/Data Analyst at MetroPlus Health PlanDatabase Reporting Associate at TheStreet.ComSenior Report Writer/SQL Developer at Jewish Theological SeminaryDatabase Reporting Analyst at Sleepy's, Inc.