Freelancer Adisan Patel
BASIC
$ 25

SQL Developer Adisan Patel, Websites, IT & Software

Adisan Patel
Joined Jan 26, 2021

About Adisan

• 15+ years of IT experience in Data Design and Development on Microsoft SQL Server 2017/2014/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing. • Experience using SQL Server Management Studio (SMS), SQL Reporting Services (SSRS), and SQL Server Integration Service (SSIS). •...Expand

About freelancer

Adisan
BASIC
Adisan Patel
(0 reviews)
Joined Jan 2021
Last seen
1 months ago
• 15+ years of IT experience in Data Design and Development on Microsoft SQL Server 2017/2014/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing. • Experience using SQL Server Management Studio (SMS), SQL Reporting Services (SSRS), and SQL Server Integration Service (SSIS). • Strong conceptualization, problem-solving, and analytical skills. • Ability to work closely with business customers, analysts, and developers as part fast-paced environment being a team player while capable of working independently. • Ability to effectively interface and collaborate with non-IT teams across the organization. • Ability to verbalize and communicate technical issues to non-technical audiences. • Experience working with remote resources. • Ability to think strategically and be innovative in a team-oriented environment. • Strong critical thinking, decision making and problem-solving skills as well as excellent interpersonal skills. • Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2017/2019. • Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity. • Extensive knowledge of Normalization and Relational Database Management Systems. • Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2017/2014/2012. • Great ability to create and manage various database objects like tables, views. • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. • Experience in Performance Tuning and Query Optimization. • Experienced in using ETL tools in (SSIS) MS SQL 2017, MS SQL 2014 and DTS in MS SQL 2000 • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. • Data Loading Experience in SQL Server 2017 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task. • Data analysis and data migration by transferring them using SSIS packages. • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). • Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. • Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler. • Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Capable of forming and maintaining positive and productive working relationships in internal/external and team environments. • Exposure on Data visualization tools like Tableau, QlikView, Microsoft Power BI, Elegant JBI

Recommended For You

use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
    WONO