Analyze and identify reporting requirements for system reports and develop recommendations to effectively report data of mid to high level complexity related to varied business metrics and for designing, coding, testing, debugging, and documenting reporting solutions, while enhancing existing reports to ensure that solutions continue to meet business needs. Implement new features and maintain existing functionalities using best practices, while keeping the code base maintainable, testable, and easy to read. Utilize software engineering, data management (database theory and design) for implementation. Work on Transfer of Reports Data from Production Server to Client Server. Work on Data Fixes for any data gaps caused by logic. Work on complex design reports, implementing the datasets and data source through dynamic scripting methods using SQL, Azure and PowerShell. Analyze existing software features and functionality, including performance and troubleshooting, as well as design and development using Stored Procedures, Functions, Triggers, Views. Work on Relation Data Modelling and writing complex stored procedures and queries through data from different servers and displaying it in the report as per the design documents. Extensively perform Unit testing for code and mappings documenting all the testing results. Responsible for validations, analysis, ETL, SSIS Packages, SSRS Reports and assisting with problem identification, integration test, performance test and quality assurance. Work on performance tuning process to tune and optimize code to reduce run times thereby ensuring the mappings run within the designated load window. Create reports specification documents, source to target mapping documents and unit test plans. Analyze software and data requirement and support project activities by assisting with problem identification and monitor performance of the application.