Sql Developer Server

Wayne Paull

Phone: 901-***-****

Email: *.*********@*****.***

WORK EXPERIENCE

Net Tec Solutions

SQL Database Developer 01-01-2017 / current

Over 10 years experience in creating complex Structured Query Language (SQL) and Transact Structured Query Language (T-SQL) queries in the data warehouse, for stored procedures, and in retrieving or manipulating data within relational databases using SQL Server Management Studio (SSMS).

Skilled in writing efficient queries to join tables in a relational database to create stored procedures to generate comprehensive datasets to create reports in Power BI for a data visualizations reports, SSRS reports, Excel reports from the dataset

Good analytical in gathering and utilizing information, and organizing data into readable formats for clear understanding across various reports.

Experience in extracting and transforming data into clean usable data, to have good readable reports that will make good business decisions

Experience for over 6 years with Power BI and the variety of different visualizations reports to help determine with decisions making

Experience with SSRS reports for over 6 years using Report Builder to create dynamic, customizable fields, enabling the report to change the information output and allowing various departments to access up-to-date information at any given time.

Experience with Excel, Excel formulas, Excel pivot tables, Excel charts and graphs, and macro

Proficient in troubleshooting issues through a structured approach by gathering information, analyzing problems.

Blue Scope

Computer Programmer Analyst 01-01-2015 – 12-31-2016.

Experience with C, C++, and C#, PHP, XML, JSON and other programming languages to create a software application

Experience working with Visual Studio, Dot .NET Framework in C++ or C# to build software application

Skilled in creating SQL queries to modify reference data within databases, ensuring the software application functions correctly.

Skilled in writing SQL and T-SQL queries to create reusable SQL stored procedures.

Experience working with Excel, Excel reports, Excel formulas and pivot tables when needing to gather information or to analyze a issue

Experience in Identifying or troubleshooting application issues within the software

Need a Website

Mobile Responsive Web Developer 01-01-2013 –12-31- 2015

Designing and creating dynamic website or mobile responsive websites for different clients that were updating or revamping their company website

Experience creating custom website or work with content management such as SharePoint, WordPress, Joomla, and others and installing the database to the server

Experience working with HTML, CSS, PHP, XML, Jason, JavaScript, when working to create, develop or fix issues within a website or responsive website

Successfully install web applications, content management systems on to different servers and created the database connection to that application

ServiceMaster

SharePoint Administrator / SharePoint Developer 01-01-2012 – 12-01-2014

System Administrator

Experience SharePoint Farm Admin that maintained six SharePoint farm with 100 to 300 users on each SharePoint Farm

Successfully as a SharePoint farm admin that also maintained 8 front end servers and one physical server through the central admin and working with the servers

Successfully kept the SharePoint farms up-to-date by applying critical patches, updates, and version upgrades to the SharePoint farm, and servers when needed.

Assigned permissions to SharePoint users, by controlling access to the SharePoint sites, libraries, and lists of what each SharePoint user had access to.

Proficiently utilized SharePoint reporting tool to craft insightful reports to inform decision-making.

Epic Solutions

Management / Web Developer 01-01- 2010 – 12-31- 2011.

Managed e-commerce platforms, and optimized content management systems by plug-ins for enhanced functionality.

Proficient in using Google analytics, keywords, and meta tags to optimize marketing strategies and search engine rankings

Familiar with managing social media campaigns, analyzing data trends, improving graphic designs, and conducting email marketing to boost page traffic and conversions

Education

University of Memphis

Skills

AD HOC,BUSINESS REPORTING,BUSINESS INTELLIGENCE,DATA ANALYSIS,DATA MODELING,DATA REPORTING,DATA WAREHOUS,MICROSOFT EXCEL,C++ • C# • R • PHP,SQL SERVER REPORTING NEXTGEN,SQL SERVER MANAGEMENT NLS,SHAREPOINT,DAX FORMULAS,ETL,EXCEL FORMULAS,POWER BI,PYTHON,R-STUDIO,SSAS,SSRS,SSIS,SQL,TSQL,NLS

Contact this candidate