• Taking complete new business requirements from client and as per direction to develop Reports, Packages and Cubes.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• As per direction in client’s mail start exploring business requirement tables, and building logics.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Creating various types of reports like drill down, Parameterized, Table, Matrix, Chart and Sub Reports.
• Development of reports using SSRS and regular validation with copy of report shared by client.
• As per business need modification of Procedures, Views and Functions.
• Deployment of report in DEV server and UAT server for testing purpose and validate data.
• Communication with the Onsite Client & solving Technical problems.
• Following Optimization Technique / Steps for smooth processing and rendering of complex and heavy reports.
• Also responsible for analysis, coding & testing of the objects before delivery to the client.
• Communication with Offshore team and client via Email and Status call.