Developed TSQL stored procedures with loops andtable valued parameters to automate reporting.

Did troubleshooting of SSIS connectivity and processing supporting automated ETL.

Advancde TSQL scripting. Developed reports from complex analyst requirements documents. Created User Defined Functions. Performance tuning and query optimization.

Designed Fact and Dimension tables, and the ETL to populate them. Created automated self-documenting tables for Type 2 Slowly Changing Dimensions.Extensive data cleansing and performance tuning for PIM data. Provided upper management with actionable reporting. Also served as EDA (Epicore) administrator.

Developed SSIS Packages for use with CozyRoc adapters and connection managers to automate importing SalesForce backend data into MS SQL Server tables. Exposure to SOQL syntax. Coded TSQL MERGE blocks to perform UPSERTS into SQL tables.