Todd Friedman Email & Phone Number

Temecula, Ca, Us

San Diego, California, United States

• Developed ETL/ELT design pattern using BIML (Business Intelligence Markup Language) to generate SSIS packages. Used this design pattern in support of multiple projects. And taught direct reports how to use this pattern on projects they support.

Greater San Diego Area

• Created Visual Studio Database Projects and taught developers how to use capability to source control changes and generate change scripts.• Implemented SQL Server 2016 In-Memory OLTP to improve performance of existing stored procedures.• Performed SQL Server execution plan analysis to tune existing stored procedures to improve performance.• Worked on migration effort to move sql server environment from SQL2008R2 to SQL2016.

Greater San Diego Area

• Developed ETL to move existing eCollege data into new architecture. • Worked within existing SSIS framework and made enhancements to improve performance. • Built stored procedures as source for ETL load. • Created indexes to cover queries. • Developed incremental loading strategy.• Worked with QA team to help test results. • Used ERStudio Data Architect to model database schema changes.

Greater San Diego Area

• Ongoing work to make existing SSIS packages deployable to new environment.• Troubleshoot and fix sql agent job errors for residential lending.• Perform release management duties for our Test and Production environments.• Perform query performance tuning on long running queries.• Deploy SSIS, SSRS, SSAS, and SQL Server objects to Test and Production environments.• Administer TFS for residential lending.

San Diego, Ca

• Worked within an Agile development environment.• Worked with Business Analysts (BA) to define functional requirements. Using conceptual modeling techniques to increase communication between BA and developer constituencies.• Held requirements reviews with BAs, developers, and Quality Assurance (QA) constituencies.• Held design reviews and code reviews with database developers.• Developed Data Warehouse Architecture for multiple projects.• Used Visual Studio Database… Show more • Worked within an Agile development environment.• Worked with Business Analysts (BA) to define functional requirements. Using conceptual modeling techniques to increase communication between BA and developer constituencies.• Held requirements reviews with BAs, developers, and Quality Assurance (QA) constituencies.• Held design reviews and code reviews with database developers.• Developed Data Warehouse Architecture for multiple projects.• Used Visual Studio Database Projects to Source Control database changes.• Used a model driven approach to database development. Where database logical and physical models are created and reviewed before developers start working on a requirement or user story.• Trained junior database developers on all aspects of working within our environment.• Developed SSIS packages to move data though the ETL architecture.• Used SSIS Script Tasks to process SSAS dimensions and partitions using AMO. • Created Dimensions and Measure Groups in SSAS.• Created Calculated Measures using MDX.• Implemented Calculation Dimensions in cubes to standardize common time period calculations.• Implemented PowerPivot Self Service BI capabilities in SharePoint.• Created PerformancePoint Dashboards.• Created SSRS reports.• Created PowerShell scripts for the creation and deployment of SharePoint content.• Created VB.NET console application for deploying SSRS reports to SharePoint libraries.• Created stored procedures to automate the deployment and removal of transactional replication for our transactional environment, which includes Development, QA, Staging, and Production.• Troubleshooted replication deployment issues in Development, QA, and Staging environments. Show less

Greater San Diego Area

• Provided SQL Server DBA and Developer support for PMW164 and the Navy Marine Corps Intranet (NMCI) at SPAWAR (Space and Naval Warfare Systems Command). • Responsible for performing daily data updates to our eMarketplaceReports database. eMarketplaceReports was a database used for executive level reporting on the status of NMCI orders throughout the Navy.• Migrated the eMarketplaceReports database from Access to SQL Server 2000.• Created tables, indexes, constraints, triggers… Show more • Provided SQL Server DBA and Developer support for PMW164 and the Navy Marine Corps Intranet (NMCI) at SPAWAR (Space and Naval Warfare Systems Command). • Responsible for performing daily data updates to our eMarketplaceReports database. eMarketplaceReports was a database used for executive level reporting on the status of NMCI orders throughout the Navy.• Migrated the eMarketplaceReports database from Access to SQL Server 2000.• Created tables, indexes, constraints, triggers, views, stored procedures, and functions.• Performed database optimization using filegroups with hardware-based RAID. • Full database backups were performed daily utilizing Veritas Backup Exec for Windows 9.0.• Monitored the system by utilizing Windows 2000 Event Viewer, and Performance Monitor.• Snapshot replication was used to push published articles to subscribing servers in Hawaii and Norfolk.• Developed adhoc reports and queries on a daily basis to aid management in tracking the progress of the NMCI effort using SSRS. Show less