Resume

Sign in

Data Sql Server

Location:
Boca Raton, Florida, United States
Posted:
January 17, 2019

Contact this candidate

Resume:

January **, ****

For the attention of: Human Resources.

Company:

Reference: Career Opportunity (Full Time)

Dear Sir / Madam,

Position of Interest:

For further consideration, my Resume is enclosed herewith, and gives an account of skills and experience; 8 plus years in Mainframe computer operations. In Programming; have an ongoing exposure to C#; ASP.NET, Visual Studio 2005/08/2010/2012/ 2015 - Experience in using various QA Software Testing methodologies; in support of Software Development projects with databases; using MS SQL Server 2005 Standard / 2008 R2/2012/ 2014; SSIS / SSRS, also have experience in Technical Documentation, and some Web development.

I am very keen and willing to learn new on the job technologies; or skills to achieve success in the position offered.

I would welcome the opportunity to discuss my application further.

I therefore look forward to hearing from you, thank you for your time and consideration.

References: Available on request. Required Salary: Negotiable

Yours sincerely,

Robert Wayne Cotterell.

SQL Professional Skills

Troubleshooting, Database Objects authorization, DTS, ETL Tools; using (SSIS), Objects Creation such as Tables, Views, Good Knowledge of Data Warehouse (SSAS) and SSRS.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities./SQL Server Commands and DTA (Database Tuning Advisor)

Excellent knowledge in system tables and system stored procedures using T-SQL.

Experience with SQL Server 2005/2008/2012, DDL / DML Triggers.

Experience in ETL of data using SQL Server SSIS; migration of Data from Excel, Flat file, and

Retrieval of FTP files for import and archiving once loaded; performed Data analysis for correctness.

Experience with Data Types, Indexes, Stored Procedures, Triggers, Table-Valued Functions.

Experience of loading and merging data from different sources into database table or view in a user-specified format; utilizing the various Control Flow and Data Flow task components of SSIS, and the capturing of errors during a process for correction and later input

Develop, & implement program logic with use of C# scripts in ETL processes..

Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export

Strong skills in documentation of procedures and processes of a system in a format that is easily understood

Experience with MS Office Products / Visual Studio 5 / 6, 2012/2015, Visual C/C++, C#, TFS, SourceSafe. Good knowledge in WCF framework and Web API's.

Familiar with XML technologies

Experience with ADO.NET, ASP.NET and C#, LINQ, HTML, CSS and some JavaScript

Generated reports using the report Wizard, and the report Model Builder approach; used the Query designer in querying database report model and editing the report format to satisfaction

Documenting Relationship model with metadata

Leadership, project management and time management.

Worked with database connections, SQL joins, loops, aliases, views, Designed Sources to Targets mapping from primarily Flat files to Tables within Database

Technology Knowledge& Experience

SOFTWARE

HARDWARE

Microsoft Windows 2008 /Server etc. Winrunner 8.0, Microsoft Word 2007/2010, Excel 2007/2010, Access 2007/2010, Visual Studio 2008 / 2010/15, Microsoft Visual C++ 2.0 /5.0/6.0, Visual Basic 5.0/6.0, C# .Net, MVC/ Telerik WPF Controls. Crystal Report 6.0, JavaScript, SQL Server, HTML 4.0, CSS, Adobe Photoshop CS5, DreamWeaver MX 2004, Corel Draw 5, Visio 5/2000/ 2010, SQL Server Database Tools / SSRS, SSIS (ETL). Mainframe JCL –Version Control:- SVN, SourceSafe, TFS, GitHub, SVN

In-depth knowledge of Mainframe Operating systems; PC hardware and Software

Western Digital / AIT Resources

Irvine, CA

10/ 2017 – 03/ 2018

Position: Contract –SQL Server; SSIS / VB, .Net C# Developer Database Development: SQL Server SSIS (Data Tools)Visual Studio 2015 Development Environment; writing T-SQL / Stored Procedures. Creatiung SSIS packages to replace and automate an internal manual processes; Update, Importing data from embedded Macro sheets (.XLSM), created HTML send Emails and SSISLogs for package runtime.

Visual Studio 2017 C# .NET Development of an HTTP Client Application; calling to a remote Splunk Rest API Service; returning Json Data to interface with a JavaScript WebGel app. Exception Handling, Validating the returned Jason Data (Deserializing, Serializing). Asynchronous Programming, Trouble shooting connection errors with the Splunk and Network Staff.

Configuration of an LMS (Docebo) application; creation of Groups, Users and Languages for associated courses held via Intranet. Other Duties: Documenting, Testing Debugging and Participated in frequeny Project mettings.

Position: Contract –SQL Server / Developer

Responsive Auto Insurance

Plantation, Fl.

04/ 2017 – 06/ 2017

Troubleshoot and resolve issues in order to develop enhancements; fixed bugs in existing applications to meet business needs to a Production StingRay Insurance Policy and Claims Processing System, and reporting projects; Data Validation / Importing, and test appliaction changes before promoting to code review through Jira (issue and project tracking) task sheduling. Other Technologies utlized: BootStrap, JavaScript, HTML5/CSS, SQL Server 2008R2, writing T-SQL/Queries/ Cloud based Source Control repository: SVN. Project Environment: Agile

TBC Corp. (MMD Services, Miami, Fl)

Donald Ross Road, Juno Beach, Fl.

08/2016 – 11/2016

Position: Contract ASP.NET / SQL Server Developer Net (Framework 3.5 /4.5) Developer

Application Solution Debugging, Application Migration to higher .Net Framework, C# .NET

Creating database stored Procedures / T-SQL Scripts.

In Documenting Process Flows; diagraming using Visio.

Unit Testing, Troubleshooting Windows Workflow.

Design Pattern Used: Repository. Software Tools: SQL Server 2014/Visual studio 2015

Environment: Agile (SCRUM) Environment, Using SVN repository.

Michigan Commercial Insurance

Wood Street, Sarasota, Fl.

10/ 2015 – 01/ 2016

Position: Contract (Remote/ On-site) - MS SQL DBA / Data Analyst

Software Tools: SQL Server 2008R2; SSIS/ SSRS / MS Access Database/ Crystal Reports, Gensource Claims DW, Tropics Policy DB, and Oracle 11G Pl/SQL.

Creating T-SQL Scripts and Updating Stored Procedures.

Worked independently, with a sense of urgency and within a deadline-oriented team environment interacting with clients and users. Responsible for daily, weekly, monthly, and quarterly data and configuration actions.

Resoving problems in identifying the root cause of issues in support of business functions

Interpret results using a variety of techniques, ranging from simple data aggregation to complex. Identify (troubleshooting) root causes in case of ETL (SSIS) failures of content delivery systems, analyze, design, and develop specifications for enhancements, maintenance, and extensions to existing reports as well as develop new reports and Ad Hoc reports. Implementing and scheduling of operational automation using scripts in a task scheduler and SQL Agent.

Position: Contract – Data Analyst/Developer

Ryder Systems ( Bridge Technologies )

Medeley, Miami. Fl. USA

05/2014 – 10/2014

Microsoft: Word, Excel, Visio and Development Software, Visual C# SQL Server 2008R2 /2012.

Identify improvement opportunities and enhance processes as necessary. Worked with Sales,

Marketing and development teams; to enhance Salesforce and Eloqua processes as necessary. Participate in the migration of the required changes from Test environment to Production.

Provided resolution to issues that have been logged to the bug tracking system.

Ensure that the necessary or all parties are notified and kept abreast of status during both release and issue instances. Gathered and documented functional and technical Process flow requirements for development. Hand coded some ETL Processes for a DW using T-SQL / SSIS.

Pinnacle Finance

Hypoluxo Rd, Lantana, Fl.

01/2014 – 03/2014

Position: Contract SQL Server (2008R2) / .Net (Framework 4.0) Developer

Interfacing with an Oracle 11G database, using ODBC connection; to extract data (read only) as required for the application I created using Visual Studio12,

Interviewed and gathered requirements from key personel (users).

Writing documentation to describe programming development, logic, and C# coding.

Application type created, WPF.

TFS Repository versioning control used,

Inserted extracted data from an Oracle Database into a SQL Server Database

LINQ to SQL in quering the data Objects.

DigDev Direct

Deerfield Beach, Fl.

03/ 2012 – 06/ 2012

Position: Contract –SQL Server Data Analyst / Developer

Provided support to analytical and reporting projects; applied to the strategy of email marketing by extracting data feeds to build data marts, Data Validation /Extraction / Importing / and Cleansing (Metadata and Data Quality, Data Standardization) to a Data Mart to aid various companies in their marketing campaign. Using ETL Tools (DataBase Studio), SQL Server 2005, SSIS and writing T-SQL Queries.

First Service Residential (FSR)

Dania Beach, Fl

10/ 2010 - 03/ 2011

Position: Contract SQL Server DBA / Developer

Maintaining Indexes on production Database / Backups/optimization of Queries /Trouble-Shoot and Monitoring Deadlocks with the use of SQL Profiler.

Identify and resolve any performance issues.

Database development projects producing; documentation for setting-up SQL Replication Server and Reporting Server, Using SQL Server 2008R2, Visio 2008, Collaborated with Developers to define detail requirements, best approach and practices

Environment: C# ASP.NET 4. /Windows 7/ Visual Studio 2010

TeleFonica

Brickell Ave. Miami Fl.

02/ 2010 – 08/ 2010

Position: Contract .Net / SQL Server Developer/ SSIS

Client discussions to gather requirements, Design and create SQL Server Databases; Data modeling, Data Normalization, Referencing XML Data, Writing complex Queries to manipulate Date / Time Data, Excel spreadsheets Data import using SSIS, Database development projects with front end interface (multi-tier), Using Visual Studio 2008 (Team),Programming in C#, SQL Server 2008 /Visio, ASP.NET 3.5./ Windows 7

Target Point Media

Coral Springs Fl.

05/2008 – 10/ 2009

Position: MS SQL Server DBA / Developer - SQL Server 2005 Standard Edition / 2008.

Performed SQL Server / C# .NET Developer and Administrative functions, in both production and development environments: The installation of SQL Server with services packs; Planed, organized, implemented and maintained multiple new and existing databases (Consistency checks).

Database Security Backups and Recovery, Liaised with Microsoft on issues; Managing data requirements, standards and conventions in support of the development of data loads, extractions, and transformation (ETL) Data Imports and Conversion (CSV, Excel, MS Access data, Raw files, Text files) solutions using SQL Server Integration Services (DTS/SSIS packages Metadata and Data Quality).

Working experience of SSRS: Serviced ad-hov report requests from Sales Team and SSRS report requests from Management.

Writing Stored Procedures, and T-SQL Query statements,

Tyco Safety Products ( Bartec Group )

Boca Raton, Fl.

12/ 2007 – 03/ 2008

Position: Contract – Software QA Engineer - Working with Hardware / Software

Embedded software testing on retail security products; Performing Manual / Automated Tests Methodologies: Regression, Black Box, User Acceptance; Documentation, writing Test Scripts, and Test Plans on the integration of Hardware and Software, with the use of Compuware Software Tools; version 6.01, Assigning IP addresses to hardware devices for connectivity, Setting up DSN’s through ODBC for MS SQL 2005 Database connection. Interrogation of Database using T-SQL for expected results.

Project documentation: The procedural flow of steps taken in performing tests, and fault finding.

South Florida Electronics

Oakland Park Boulevard, Lauderhill Fl

02/ 2007 – 06/ 2007

Position: Contract - SQL Server 2005 / Database Developer(Web driven application)

From Conceptual through Business Requirements Gathering, to development of a Mortgage Database for a small company using HTML, CSS, ASP.Net web Forms, Master Pages, and C# for the code behind. Creating SQL Queries. The Importing of data to various tables of the database; using BCP (Batch processing) command line and SQL SSIS; DTS packages.

Project documentation: after initial meeting with client; Project requirements documentation, Flow charts / Excel spreadsheets in the use of documenting the contents of database tables, etc.

ZERO-NOW.

Bletchley, Milton Keynes, Buckingham (UK)

06/ 2005 – 07/ 2006

Position: Web Developer. / QA Analyst Tester

As a valued member in the web development process, within a close creative team environment; maintaining, updating, and modified current websites with use of a Content manager.

Create design new web graphics, coding with HTML, CSS, and some ASP.Net related projects.

Tools: Visual Studio; C# .Net, Photoshop CS2. Provided Software Quality Assurance of the HTML pages; their content, Web Link Verification, and Compatibility testing, by testing how well the application performs, using different Internet protocol browsers.

CAD STAR

Grange Farm, Milton Keynes (UK)

01/2005 – 05/2005

Position: Contract Programmer / Software QA Analyst Tester

Debugging Software Applications developed using QT Interface classes within C++ Visual

Studio Environment.

Code correction.

Analysis of the software usability. Proposed and suggested GUI Design in design reviews

NOVA Southeastern University.

Davie, Florida, USA

06/ 2003 – 12/ 2004

Position: Computer Lab Tech. Support /Technician

Technical support of PC’s; Build/ Installation /Configuration/ Networking/ & Internet Connectivity with MS Windows 95, 98, 2000, E-mail issues.

Utilizing PC Tools & providing technical support to hardware and software to student users of Microsoft Office products, etc.

TekSystems

Banco Atlantico / Assurant-American Bankers / Perry Ellis

08/ 2002 – 05/ 2003

Position: Technical Writer / Data Modeler (Contract)

Duties: With a strong understanding of SDLC

Communicating with development team and users, in the order of Writing Technical Documentation of Relational Database functionality (RDBMS): Data dictionary, Schema, Entity relationships (ERD), Data Flow Diagrams (DFD’s), technical descriptions of APIs, Programs, Excel Pivot tables; Variable lookups, and procedures for Batch Processing of International Transactions; International Bankers Financial Accounting System.

Utilizing Microsoft Office 2000, BM PC’s; Windows 98 Networking, dBase IV, Visio 2000 6.0, to Generating (Document) work flow activities, software program procedures and processes.

Produced Instructional Design Methods applied that contained instructions, procedures and guidelines.

Coverall Inc.

Cypress Creek, Fort Lauderdale. Florida USA

07/ 2001 – 05/ 2002

Position: Programmer /Technical Writer (Contract)

Projects: Marketing Management System / Financial Accounting. Environment

Utilizing Word 2000, Visio 5.0, Visual Basic 6.0, SourceSafe, MS SQL Server 7.0 & MS Access.

Contribute to the application project by providing critical support to the project development team, in the Normalization of data, to ensuring data integrity, performing Software Maintenance, Q.A Analysis of the software, and advice of software usability, resulting from applied testing. Proposed and suggested GUI design in design review meetings in view of redesign & improvement of the GUI

Coding using Visual Basic 6 tools working with (Combo Boxes, Grids, SQL coding, and ADO) in the, Amending Visual Basic Source Code, Creating Database Tables, Develop documented user examples. Documentation of program specifications, & Flow Charting Program procedures.

Eritmo.Com

Miami, Florida, USA

02/ 2000 – 06/ 2001

Position: Technical Writer /QA Software Analyst Tester

Business Objective of the company: Providing an online service (WEB based Order system) of various types of Music and Video for purchasing Project Applications Worked on: Web driven.

Product: WEB based Order system, of Music and videos on different type of Media’s

Environment: UNIX / IBM PC’s; Windows 95/NT Networking,

Utilizing Word 2000, & Visio 2000 - Documented & Test Web and client server applications Solely responsible for writing Functional Specification Documented on how the Vignette Story Server (Content manager), services the entire Web site.

Written Test Plans, and Performed Software Quality Assurance of the HTML pages; their content, Web Link Verification, and Compatibility testing – testing how well the application performs, using different Internet protocol browsers, Bug tracking and Reporting.

Proposed and suggested GUI design, and Beta testing, before the final release.

Technical Documentation of the Oracle Database creation, Data Flow Diagrams, Schema relationships, The Order fulfillment procedures, System set up procedures of the Servers, assisted the development team of programmers, and their procedures by gathering information, writing the draft version of the document, and then modifying it.

Created structure and improved communication in our development area.

Documented all our projects working directly with our programmers, administrators and web masters.

My skills in quality assurance helped in the user design and management of the back-office systems.

Integrated Medical Solutions Group

Woburn Sands, Milton Keynes, UK

04/ 1999 – 01/ 2000

Position: Analyst Programmer/ Quality Assurance Software Tester

Business Objective: Responsible for providing a large portion of the UK Hospitals National Health Service (NHS) with computerized administrative solutions.

Types Applications Worked on: DOS screen driven, and Web driven.

Environnent : Client Server - IBM PC’s & UNIX. Windows 98 Networking environment

Reporting bugs to a database tracking system as a result of performing analysis, execution, and evaluation of Software by way of writing & execute test plans/test cases, and applying various testing procedures to Functions & Triggers (Testing Types: Integration, Regression, Functional, Web Link Verification, etc.) of Client Server, Architecture.

Writing pseudo code on proposed changes of the software.

Writing test scripts to an approved QA. ISO 9000 standards. Used PostgreSQL statements to interrogate database Tables. In order to check that the correct Contract ID, and Practitioner (GP code) have been assigned to a patient record, depending on the various variables (Area code, Hospital code, and patient type whether Patient: Out/In-patient, Overseas, Private, etc) that I had previously set up for a particular test execution.

Also documentation of changes to procedures and software defects incurred.

DBA,

School / College / University

Certification

CHRISTOPHER WREN COMPREHENSIVE SCHOOL

CSE’s x 6: - Physics, History, Art, Geography, English Language & Technical Drawing

SOUTH THAMES COLLEGE (Putney)

‘O’ Levels x 4: - Math’s, Physics, Engineering Drawing, & English Language/Literature

NENE UNIVERSITY (Northampton)

HND /BTEC (Higher National Diploma / Business & Technology Education Council)

Hardware / Software Engineering.

HND /BTEC (Associates Degree)

Software design: - The use of Structured Development

Methodologies and CASE Tools (Teamwork Unix sys).

Presentation Skills, Project Management, Discrete Math’s, Assembler Programming for the Microprocessor:

Intel 8085/8086, & Motorola 68000,

Electrical & Communication Studies, Digital Electronics, System Design Software Tools, Computer Architecture,

and Structured Programming in Pascal and ‘C’

Professional Education and Certification

Microsoft Related - Certificated course:

MS SQL Server 2005 / 2008 Implémentation / Maintenance.

SQL Server 2008 Database Development :-

Trouble shoot Locks / Database Tuning & Optimization of Queries / Data Encryption / Creating File groups / Data partitioning / SSIS / SSRS (Report models) / SSAS (Designs: Star schema, Snow Flake).

Database Mirroring, and Replication.

NET Framework 2.0 & 3.5 – 70-536 Application Development Foundations.

ASP.NET Framework 2.0 & 3.5 – 70-562 Application Development Foundations.

Configuring Microsoft Office SharePoint

Access / 97, Excel / 97

Mastering Visual Basic 6.0 for Developers, Visual Basic II Advance

SQL Server Mastering SSIS - Workshop 2013 (Pragmatic Works):

How to load a data warehouse How to performance tune SSIS Advanced data cleansing patterns

Scripting in SSIS De-duplicating data with fuzzy logic Implementing an SSIS framework

Performance Tuning SSIS Scaling Out SSIS Change data capture (CDC) in SSIS 2012 and 2008

MCP Transcripts: link to MCP Transcripts: ID = 877643 Access Code (verbatim) = RobWayCot

https://mcp.microsoft.com/authenticate/validatemcp.aspx

382 East Royal Palm Road

Apt. 2, Boca Raton

Florida, 33432

Cell: 239-***-****

ac78di@r.postjobfree.com

SKYPE ID: RobWayCot

ROBERT WAYNE COTTERELL

Boca Raton, Florida, 33432

E-mail: ac78di@r.postjobfree.com

Visa Status: Green Card



Contact this candidate