MSBI Developer
Acumen Aircool Pvt Ltd
Total years of experience :4 years, 9 Months
-MS SQL Server database administration, including
configure Scheduled Tasks for regular Database
Backup and Maintenance Activities.
-Create and modify tables, stored procedures,
triggers, check constraints and functions. Create
triggers to keep track of changes to the fields of
tables when changes are made.
-Designing complex reports using Drill down and
Drill-through features in SSRS.
-Having good knowledge on expressions to filter,
group, parameterized, cascaded parameter format
of reports in SSRS.
-Develop reports using SQL Server Reporting
Services and utilizing complex SQL queries and
stored procedures. Configure and maintain
Report Manager and Report Server for SSRS.
Environment: SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio 2017(SSMS), Windows Server 2012, Jira
Bharti Infratel was one of the infrastructure providing companies to different telecom operators. Through this software we were locating power consumption, Running hours of Diesel Engine, whether the network management system(NMS) working or not and looking and optical fibre theft cases and resolving that theft cases and preparing a chart report for future help and providing that to zonal manager of Infratel for further detailing and making the shortage clear.
Work on smart city during major project using IC555 and Arduino kit .