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
Joined Jan 2021
Last seen
9 days 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

Marvin Arnold
BASIC
United States, New Brunswick
Web Producer Marvin Arnold, Websites, IT & Software
HTML5, CSS3, JavaScript/RxJS/ES6 Node.js/Express/MongoDB/GraphQL ElectronJS/Chromium/THREE.js AWS/EC2/APIGateway/Amplify/SLS Adobe CC/XD/Illustrator/After Effects VueJS-CLI/Vuetify/Vuex React/JSX/Redux Angular2+/CLI/Typescript Wix/Webflow/Weebly/WordPress CMS Lottie/Bodymovin/SVG Animations 03/2014 — Present NY, NJ, CA Dame Agnes Productions, LLC — Contract Web Producer UX/UI Design, Website & Web application production Website development with VueJS/Vuetify/Vuex Utilize CSS3, HTML5, JavaScript/jQuery, MEAN Stack WordPress CMS; Angular, (MVC); Bootstrap; AWS/Subnet/CIDR eLearning Web App for online training — MongoDB, Express, NodeJS, Adobe Captivate optimize registration and login forms, Single Page Applications, and site routing 4/2016 – 5/2016 Los Angeles, CA Creative Circle/CauseForce, LLC — Freelance Web Dev. Manager, Managed the development team through the Website development process Utilizing CSS3, HTML5, Javascript Frameworks React/Vue/Angular for UX/UI development Worked with Project Coordinators and Brand Leads to allocate Web development tasks 9/2015 – 12/2015 New York, NY Havas Health/H4B — Project/Resource Manager Developed & maintained the launch timeline for HCP/DTC new product for Actavis Worked with creative and developer teams to update and maintain print and digital collateral for HCP & DTC Consulted on instituting Resource Management in a current project environment 04/2005 – 3/2014 New York, NY Geometry Global — Resource Manager/Web Producer Assisted project managers to allocate all resources efficiently across all projects Worked with HR and Finance Scrum/Agile methodology and developed Scope-of-Work MS Excel, MS Project, HTML, CSS, JavaScript/jQuery React/Angular Website and Web App development
Websites, IT & Software
CSS3
Full Stack Development
ES8 Javascript
Database Programming
HTML5
$40
use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
    WONO