David C. Email & Phone Number

Houston, Tx, Us

Houston, Tx, Us

Hatfield, Hertfordshire, Gb

-Great experience with Microsoft Power BI (T-SQL, SSIS, SSAS), Azure (SQL Server, ADF, IaaS/SaaS/PaaS, Blob, SQL DW, ADLS2, AKV, Synapse, Databricks and etc.), AWS (EC2, RDS SQL Server, Amazon Redshift, S3 and etc.) and reporting tools(SSRS, Power BI, Tableau).-Excellent skills in creating and managing Databases, and various database objects like Tables, Views, Indexed Views, Complex Parametrized Stored Procedures, DDL/DML Triggers, User Defined Data Types, User Defined Functions, and Indexes (clustered, non-clustered, filtered, covering, with included columns, column stored) using T-SQL.-Created SSIS Packages sourcing data from various data sources such as Flat/Raw File, Excel, CSV, Access, OLEDB, XML, CDC, ADO.NET, etc., and shown familiarity in using transformations like Aggregate, Conditional Split, Derived Column, Merge, Merge Join, Union all, Multicast, Row Count, Lookup, Sort, Audit, Fuzzy Look Up, etc.-Created reports based on the format specified in the design document Documentation of all the processes involved in maintaining the database for future reference Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.-Created Linked Servers to connect OLE DB data sources and providers Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.-Attended in creating SQL stored procedures, Functions, Views, Indexes in Microsoft SQL Server using appropriate business rules, standards for better performance.-Great Knowledge in Performance Tuning of Complex T-SQL codes, SSIS packages, Power BI/SSRS/Tableau reports.-Developed Dashboards with different subject matter views (drill-down/dynamic, Pivot Table, Chart). Created packages to transfer data between OLTP and OLAP database using Lookups, Derived Columns.

Philadelphia, Pennsylvania, Us

-Took an active role in meetings with different Departments, Managers and End Users to capture and document the system requirements.-Designed, developed and maintained BI infrastructure comprised of large data (couple of Billions) using T-SQL, SSIS, SSAS, Relational Database, Tabular Modeling and Reporting tools.Created and worked with complex analytic queries on huge data sets; developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required.-Worked closely with Architecture team to transition old database models into new Data Warehouse, Data Marts and Reporting structures.-Performed Dimensional Modeling for Data Warehousing development using Azure data platform, including Azure SQL, Azure Data Factory, Azure Databricks, Azure SQL, Azure Data Lake Storage, Azure Cosmos DB, SQL IAAS/PAAS/SAAS.-Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.-Wrote parametrized stored procedures to enable user interactivity to filter datasets, functions, expressions and variables for better performance and flexibility.-Created indexes and views, stored procedures to enhance database/application performance.-Generated SSIS packages/projects to pull out, modify and load data from various sources such as Oracle/SAP and SQL Server Database, Flat Files, Excel source files to specific destinations of Data Warehouse.-For populating data into DW/DM, designed and developed various dynamic SSIS ETL packages to extract and transform data incrementally from Merge Tables.-Built SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task.-In addition to migrated reports, designed, developed, maintained and delivered additional new Power BI Dashboards and Reports with complex DAX query measures/columns, drill down/drill through/hyperlink options, dynamic slicing/dicing features.