Sql Server Manager

Joseph K Robertson

281-***-**** (Cell)

Houston, TX 77041

*********@*******.***

www.linkedin.com/in/josephkrobertson/en

Information Manager Professional that specializes in Data structures, data planning and data mining.

Fluent in SharePoint and can administer farm setup and maintenance to end user site including modification and design. Comfortable with many software suites, can learn and deploy quickly and efficiently. Well versed in SQL server administration as well as server setup and maintenance.

Summary:

Experience, including Information Manager, Sharepoint Administrator, SQL Server / Advantage Coordinator (Contractor). Owner / Operator in business as computer consultant in industries including Engineering, Accounting, Research, Management, and Related Services. Have performed as helpdesk operator and operations as well as Information Technology Manager.

Skills:

My skill set and experiences include: .net, asset management, business intelligence, cabling, computer networking, data access object (dao), data management, data warehousing, database design, database programming, disaster recovery planning, information systems, managed care, network administration, network security, network support, operating systems, primavera, relational database management (rdbm), SQL, SQL Server, system administration, systems analysis, teaching, Aveva VPE and Intergraphs Smart Plant. Technical support, Creating training materials, troubleshooting, visual basic, visual basic for applications (vba). Development including but not limited to C++, C#, J#, Java, JavaScript, Perl, VB, VBA.

Experience

Baker Hughes, Houston, TX

09/2013 – 2/2015

Information Manager / Sharepoint Administrator

Provided financial and market intelligence. Generated reports summarizing business data, economic data. Shared reports with executives and managers. Queried data repositories. Generated periodic reports. Developed methods for identifying trends.

Collected business intelligence data from industry reports, public information, field reports, and purchased sources.

Created BI tools such as databases, spreadsheets, outputs, dashboards. Organized and managed collected data. Supported design and performance standards. Analyzed industry trends. Consulted with business partners on data.

Baker Hughes, Houston, TX

03/2013 – 9/2013

SQL Server / Advantage Coordinator (Contractor)

Accept and locate Mud Diff files and load into Advantage SQL Server.

Consolidate and make corrections to data loaded and to gather data to be loaded into Database.

Data mined for lost Diff Load files and load into SQL Server.

Robertson Services Owner / Operator, Houston, TX, 03/2012 – 03/2013

Tested, maintained, and monitored computer programs and systems.

Coordinated program and systems installation. Expanded systems. Modified systems. Altered systems to improve workflow.

Developed and revised system design procedures. Assisted staff with computer problems. Networked computers. Determined hardware and software requirements.

DTI Diversitech, Cypres, TX, 04/2011 – 03/2012

Director of Information Technology,

Managed technology-related activities in data processing, information systems, systems analysis and programming. Managed data and systems backups. Managed system security. Cooperated in design of computer infrastructure. Coordinated technologies. Planned and coordinated IT projects and project activities.

Designed and implemented databases. Worked directly with vendors. Maintained up-to-date knowledge of relevant technological advances. Evaluated project proposals for feasibility and requirements. Oversaw changes and additions to software and hardware. Assisted in modernizing Business software, equipment and practices.

Deployed SharePoint 2010 and SQL Server 2008 for interaction for clients and Inspectors. set up web pages, customized pages, added requested Web Parts,

Created sites and sub-sites for different departments, also set all security and created groups.

Wrote custom interfaces and connectors using C# and VB.Net for the use of forms and templates. Completely installed and un- installed SP 2010 six times in one year; each had different settings and configurations. Supported deployment and trained end users. Deployed HP G370 Server, Sonic wall.

Total Petrochemicals, Houston, TX

12/2009-12/2010

Microsoft Office Solutions Specialist (Contract)

Modified existing applications for specific purposes. Corrected problems in old versions of applications. Adapted applications to new hardware requirements. Improved software performance. Analyzed user needs. Developed software to fulfill user needs. Customized software for client use. Optimized operational efficiency.

Analyzed and developed databases. Conferred with systems analysts, engineers, programmers and customers.

As an Application Specialist I make existing Access databases and Excel spreadsheets work with an updated software image using VB,VBA and C#. Programmatically modified legacy Access databases and database schema along with updating reports, forms and VB, VBA to operate with Access 2007, Excel 2007 and Crystal Reports, and Microsoft Reports. Modified Dynamic link files (DLL) and operating system files to interoperate with legacy applications.

Help address Level III service desk incident tickets for two months to close excessive incidents, due to rollout. Participated in deploying software packages and deployment using SCCM Assisted with inventory deployment and configuration.

Mustang Engineering, Houston, TX

01/2006-10/2009

Document Control Systems Administrator / DBA

Eighteen Months as Document Control Systems Administrator using Citadon for Data warehousing and distribution. I programmed and developed the Experience Database for the Proposal Department using Access 2007 Database. Extensive PERL scripting and development was done using regular expressions to extract data. These reports were used for proposals for Mustang Engineering bids to potential clients.

Was part of the rollout team for PaceSetter. PaceSetter is a custom program using SharePoint 2005 and C# languages. I tested and very deeply examined project to prepare for deployment. I was involved with the PaceSetter project for two years.

Two-year’s experience on BP projects in the Project Information Management Department. I have worked with Oracle for a year as the back end of the AVEVA VPE database. I have supported and trained clients such as Anadarko, BP, Chevron, Conoco Phillips, Hess, Aker, Valero, Gusto, Heerema, JP Kenny, Kiewit Offshore, Nobel Energy, OXY, Statoilhydro, and many more. Vantage Plant Enterprise Data Base Administrator. Set up AVEVA’s VPE Workbench application for the project and programmed interfaces for the import and developed functionality utilities using C++ and VB. Wrote Visual Basic and PERL CLI code for data manipulation in preparation and extraction for Vantage Plant Enterprise (VPE). Programmed utility functions using Java and C++ and C# with embedded JavaScript and PERL Languages. I maintained (using programming methods) SQL scripts for exporting data out of VPE. Set up users and permissions for the use of VPE. Utilized TOAD application for data management within the Oracle database. Managed licenses for the VPE Workbench program. Helped to set up the client side of AVEVA’s VNet web-based portal application for the VRD project using SharePoint.

Atos Origin, Houston, TX

06/2005-01/2006

Level One/Two Desktop Support (Contractor)

Provided tech support to computer system users. Resolved computer problems. via phone, remotely. Provided assistance with computer hardware, computer software, program installation, email, operating systems. Detected problems and errors in computer operations.

Trained users in proper software and hardware use. Used internet directory services software such as active directory software.

Exxon/Mobil Refinery/Coorporate, Houston, TX

04/2004-06/2005

Level Two Support (Contract)

Provided tech support to computer system users. Answered user questions. Resolved computer problems. in person, via phone, remotely. Provided assistance with computer hardware, computer software, printing, program installation, word processing, email, operating systems. Oversaw daily performance of computer systems. Detected problems and errors in computer operations. Set up equipment for others to use. Correctly installed operating systems, software, applications. Performed minor repairs on peripheral equipment. Maintained records of computer problems and actions taken.

Recorded installations and equipment replacements. Conferred with users. Level two support for the largest chemical / refinery in the United States.

Supported control center computers, Lab production computers and other plant resources. Interacted with network discovery programming PERL CLI to find profiles and obscure data.

Support base 2000+ Computers SCCM was used to push software packages throughout the company. Excelled in working with and training users. Level two support for corporate office in Houston TX. Supported over 2000 clients for hardware and software in an NT environment.

Specialized in programming and modifying Access databases and Excel spreadsheets. I had the opportunity to work with a wide range of positions including executives to administrators.

Job Site Information Manager

Foster Wheeler Engineering / Valero Texas City TX. 02/2002-11/2003

•Network administrator, Systems analysis and level one and two support for a Coker Unit new construction at the Texas City Port. Responsible for setup of project, Cabling, deployment and PBX Rolm Phone system. Back up administrator using VERITAS. In charge of subcontractors for infrastructure installation.

•Created reports and database schemas programming VB, JavaScript and PERL scripting for formatting and extracting data in preparation for custom reporting.

•Programmed applications using VB, C++, C# and PERL to interact with Access databases, Primavera, Intergraph Smart Plant and very large text files and programmatically created applications to load custom reports (Crystal Reports utilizing Access Databases). Used SCCM to push software packages to clients.

•Created SharePoint Team sites and granted permissions to our group, Customized our site and sub sites. Trained users How to use and interact with SharePoint.

•Implemented several reporting programs including Microsoft Reports and Cristal reports.

•This position gave me the opportunity to supervise and participate in every part of the project from the physical layer to imaging servers, Programming applications and maintaining inventory to handover utilizing complex databases and inventory and asset management software.

Skills

.net, Asset Management, Business Intelligence, C++, Cabling, Computer Networking, Computer Skills, Crystal Reports, Data Access Object(dao), Data Management, Data Warehousing, Database Design, Database Programming, Disaster Recovery Planning, Information Systems, Inventory Maintenance, Java, Javascript, Managed Care, Microsoft C#, Microsoft Excel, Microsoft Office, Microsoft Sharepoint, Network Administration, Network Security, Network Support, New Construction, Operating Systems, Oracle, Perl, Primavera, Relational Database Management (rdbm), Repair, Led Seminars, Software Maintenance, Software Systems, Spreadsheets, Sql, Sql Server, SSRS, SSIS, System Administration, System Design, Systems Administration, Systems Analysis, Teaching, Technical Support, Training Materials, Troubleshooting, Visual Basic, Visual Basic For Applications (vba), Visual Basic For Applications(vba),Word Processing

Education

2001 University of Houston Clear Lake, Houston, TX Bachelor of Science Computer Information Systems

Contact this candidate