• Extract, Transform, and Load data from Source Systems using SSIS.• Developed scalable and reusable frameworks for ingesting large datasets from multiple sources using SSIS.• Created SSIS packages to Extract, Transform, and Load data from different sources like SQL Server, Blob storage, and SQL Data warehouse.• Extract data from various sources like NetSuite, OLAP, OLTP, Mailchimp, RAISIN and other APIs to build a structured DataWarehouse implementing ETL/ELT process.• Designed an end-to-end analytical landscape involving Power BI dashboards connected to backend SQL Server 2016.• Create and manage Reports subscriptions and schedules SSRS reports and worked with JSON files.• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.• Troubleshooting reports issues, ETL job failures, optimizing query performances. • Expertise in standard workflow rules, page layouts, Record Types, Approval Processes, Assignment rules, Validation rules, bulk Triggers, etc. • Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016.• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.• Explored data in a variety of ways and across multiple visualizations using Power BI.• Created reconciliation report using Python, for validating migrated data.• Worked with Finance team to build up financial reports to reflect line items and regular metrics.• Created a data framework for launching a new web application.