Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion to create SSIS packages.
Extracted and transformed transactional data packages from multiple different sources into target destination to support multiple ad-hoc analysis.
Developed complex Stored Procedures/Functions, used them directly to generate reports on the fly.
Designed and implemented Parameterized and cascading parameterized reports using SSRS.
Worked with Excel reports and VBA Macro.