• Responsible for developing customized reports designed to meet company specifications.
• Developing and maintaining reports as well as SQL queries.
• Experience in working reporting on different data sources like Excel, SSAS , SQL Server, Oracle etc
• Advanced T-SQL programming Complex transact-SQL for building queries, procedures, jobs and DB objects SSRS and SSIS implementation including monitoring and incident resolution
• Working with Dashboards Power-BI implementation for Management Reports would be added advantage Development of reports using expressions and dynamic variables
• Experience using SQL Server 2008-2012, SSIS, SSRS, SSAS, ETL tools, Windows Power Shell scripting, and Windows Operating Systems.
• Experience in 2008-2008 R2 SSRS Report Writer.
• Experience SSRS skills writing Reports and creating Data Extracts from a Data Warehouse.
• Ability to effectively translate user requests in to reporting specifications.
• Performing and maintaining data extracts and imports Assist users in creating report specifications .
• Experience in analysis, design and construction of data marts and data warehouses in SQL Server 2014/2016.
• Strong in T-SQL, Stored Procedures, error/exception handling and tuning of tables and views.
Qualification, Experience & Skill Sets:
1. 4+ years as a dedicated Report Developer / Reporting Analyst utilizing SSRS in a SQL Server and .NET environment
2. In-depth understanding of SSRS
3. Expert-level knowledge in creating complex T-SQL queries for data extracts to create a large volume of ad-hoc and scheduled SSRS reports
4. Good communication skills, both written and verbal, to interact with the business in gathering requirements and presenting data from the reports
5. Provide analysis and visualization of data (help define/create the appropriate graphs/charts, not just raw data reports) using Power BI/SSRS Mobile Reports
6. Excellent interpersonal skills, with ability to interact with all members of the agile team.
7. Ability to adapt quickly to new technologies and changing business requirements.
8. Technology skills: Mandatory Strong experience in SSIS and SSRS.
9. Strong background in Software Development/Engineering Methodology