Sam D Email & Phone Number

Dallas, Texas, United States

Leading the charge in developing and optimizing advanced BI solutions with a diverse toolkit, including MS SQL Server, SSIS, SSAS, SSRS, Teradata, and Power BI. My role involves driving innovation through data mining, migration, and sophisticated multi-sampling techniques, with a sharp focus on enhancing native data warehouses. As a master of ETL workflows with Informatica PowerCenter, I design and manage complex systems that streamline data processes and deliver actionable insights. From crafting detailed SQL Server reports and building robust SSAS cubes to creating dynamic dashboards, I bring a blend of technical expertise and strategic vision. My proficiency in T-SQL and comprehensive oversight of the entire SDLC ensures that I deliver scalable, high-impact data solutions that propel business intelligence and drive transformative decision-making. Committed to excellence and innovation, I am dedicated to creating data-driven strategies that empower top-tier organizations to achieve their goals.

San Antonio, Texas, United States

Data Integration and Business Intelligence SpecialistLed the design and development of SSIS packages, SQL queries, and complex ETL workflows to streamline data processing. Managed SSAS cube integration, SQL Server migrations, and performance tuning using SQL Profiler. Developed and deployed SSRS and Excel reports, and Power BI dashboards. Configured AWS and Azure Data Factory for scalable data solutions, including automated pipelines and notifications. Expert in dimensional data modeling and cloud data solutions, with a strong focus on optimizing performance and delivering actionable insights through advanced data visualization.

Mumbai, Maharashtra, India

Business Intelligence & Data Management SpecialistLed the SDLC process by gathering business requirements and designing data maps and models. Created functional design documents and developed relational data models and ER diagrams using various tools. Spearheaded the development of business-critical dashboards and enhanced executive KPI decks with graphical data representation. Designed and implemented ETL packages using SSIS for data integration from diverse sources. Managed OLAP cube design, performance, and security. Developed comprehensive reports with SSRS and delivered BI solutions, including data warehouses and marts, to support sales, inventory, and production operations. Environment: SQL Server, Oracle, SSIS, SSRS, Teradata, Power BI.

India

Data Analyst & BI DeveloperCollaborated with business users and technical teams to gather requirements and design workflows for new functionalities. Implemented performance optimizations, including indexing and tuning of stored procedures and queries. Transformed complex business logic into database designs, utilizing SQL objects, stored procedures, and T-SQL scripting. Developed diverse SSRS reports, including parameterized, drilldown, and chart diagrams. Managed data extraction from Oracle, Teradata, and Vertica, and automated updates with COSMOS Workgroup Feed. Scheduled and secured SSRS reports, exporting to various formats and providing email notifications. Engaged with clients to address issues and deliver effective solutions. Environment: MS SQL Server, Teradata, Power BI, MicroStrategy, SSRS.