SQL/SSRS/SSIS Developer
I’ve been working with SQL Server technology for over 4+ years. I’m SQL/SSRS/SSIS Developer and my work involves creating solutions using MS SSRS/SSIS features as well as using T-SQL language.
• 4 + years of experience as a SQL developer in Production, Development and Staging Environment using T-SQL, SSIS, SSRS and MS Office
• Good knowledge of RDBMS and data warehouse concepts, OLTP & OLAP
• Proficient with all aspects of T-SQL programming including views, stored procedures, CTE’s, functions, triggers and cursors.
• Experience with writing complex sql queries, sub-queries involving multiple tables
• Have developed various formats of SSRS reports including ad-hoc, parameterized, tabular, matrix, charts and sub-reports/drill down reports
• Have improved performance of sql queries, views and stored procedures by reviewing execution plans, indexes and recommending improvements accordingly.
• Experience in automating sql scripts using Jobs, sending alerts using SQL Mail.
• Have hands on experience with using SSIS for ETL process and automating the process using SQL agent jobs and sending alerts.
• Identified data source and defining them to build the data source views for Data mining to identify rule and pattern in the Data in SSAS
• Maintain positive communications and working relationships at all business levels.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Strong analytical and visualization skills to analyze large data and interpret required results
• Strong Knowledge in Data Analytics tools such as Power BI , Tableau
• Proficient in Iterative Agile programming methodology using Scrum & Waterfall methodologies.