Banner Image

All Services

Programming & Development

SQL/SSRS/SSRS Developer/Analyst

$35/hr Starting at $30

• 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.

About

$35/hr Ongoing

Download Resume

• 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.

Skills & Expertise

AnalyticsCommunication SkillsData ManagementEnvironmental IndustryEtlMicrosoftMicrosoft Excel Pivot TablesOltpPattern DesignPerformance EngineeringProcess DesignProgrammingRdbmsReportsScrumServer AdministrationSkillSoftware DevelopmentSQLSsisSSRST SQLTableauVisualizationWriting

0 Reviews

This Freelancer has not received any feedback.