Profile
Working on MSBI, SSIS, SSRS.
• Extracted data from internal data warehouse system to SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports.
• Developed different type of Financial reports including:Balance Sheet Report, Income Statement Report,Trial Balance report etc.
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Generated various Monthly, Quarterly, Yearly reports using SSRS.
• Maintaining daily activities related to ETL Packages.
Worked on Data Transformations like Sorting transformation, Aggregate transformation, Sampling data, RowCount transformation, combining data using union all and Synchronous and Asynchronous transformation.
Using Datatype and Data conversion, Expressions, Conditional Split and derived column transformations, Lookup transformations.