 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.

 Prepared and organized relevant documents for the project of Benxi City Inland Port.

 Interacted with third party organizations like the government of Benxi city for Benxi City Inland Port.

 Completed database design and implement training.

 Worked on Excel sheets, Excel reports and VBA Macro programing.

 Worked on SQL programing including creating complex SQL queries, sub queries, tables, stored procedures and user defined functions.

 Developed Reports using Cascading Parameters, Sub-Reports, Charts and other graphical tools.

 Worked on cleansing and maintaining the SSIS packages using multiple transformations such as Conditional Split, Derived Column, Lookup, Fuzzy Lookup and Data Conversion.