Responsible for providing solutions for data related needs to support existing and new functionalities on the EAGLE STAR accounting investment and data management solution of BNY Mellon.Dealing with complex legacy code at the database level supporting SQL Server and Oracle and its application level designed in C++.Handling the procedures/functions that support the reporting module and the data transfer module.

Working as a part of both the Database and Reporting team. Understanding report requirements and creating low level report designs.Developing stored procedures for applications back end, master data ETL and Reports data ETL.Developing reports using SSRS.Working on database deployment by creating batch files for deploying database objects.

Involved in the development of Reports using SQL Server Reporting services (SSRS) from TFS data source. Worked in support and maintenance of OLAP cube data processing jobs that were scheduled to run daily and designed using SQL Server Analysis Services (SSAS). Did the root cause analysis for any issues that arose from the OLAP cube data processing.

Designed the complete data import framework using SSIS. The data import framework was a SSIS solution that created actual ETL solutions dynamically using the metadata information of source and destinations. Developed matrix and chart based reports using SSRS with SQL server and OLAP cube as source. Worked on OLAP cube using SQL Server Analysis Service. Developed a website for maintenance of the data import framework using ASP.Net.

Analyzing the project requirements by interacting with concerned persons at client location. Responsible for the designing and modification of the SQL 2005 databases.Proposed, designed and developed the entire website in ASP.Net 2.0, to serve as the Maintenance Module that enabled the searching and viewing of contracts, master data maintenance and execution of SSIS packages.Created several data import packages using SSIS to import the master data from Client's system to the SQL Server 2005 database.Designed and developed numerous reports using SSRS by using most of the design functionalities provided in SSRS.Created cube using SSAS for demonstration to the client on business intelligence capabilities and was accessed from Excel using pivot tables/charts.Worked on InfoPath form for implementing new requirements and fixing of issues that required changes in form template, template code and the binding web service.Estimations for new requirements, creating SRS, documenting process flows, assigning tasks to team members and giving trainings on SSRS and SSIS.