• Designed and created an ETL solution to consolidate applications received from various sources. Numerous reports were also created to meet the client’s need.• Worked on all activities related to the development, implementation, administration and support of ETL processes.• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.• Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.• Enhanced performance using optimization techniques-normalization and indexing• Performance tuning of Queries and Stored Procedures.• Performance tuning on existing ETL packages.• Designed various SSRS reports as requested by the client.• Rendered reports in different formats like pdf, excel etc. Scheduled to be executed automatically on weekly or monthly basis and managed subscriptions.• Applied security to reports on item and folder level.• Scheduled report and exported in PDF format.