Resume

Sql Server Human Resources

Location:

Boca Raton, FL

Posted:

December 17, 2023

Contact this candidate

Resume:

December **, ****

For the attention of: Human Resources.

Company:

Reference: Career Opportunity (Full Time)

Dear Sir / Madam,

Position of Interest:

For consideration, my Resume is enclosed herewith, and gives an account of skills and experience; 9 plus years in Mainframe computer operations. In Programming; have an ongoing exposure to C#; ASP.NET, Visual Studio 2005/08/2010/2012/ 2015/ 2017 - 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 /2016; SSIS (SSDT)/ 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 Server / ASP.NET 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.

Understanding of object-oriented design and S.O.L.I.D design Principles.

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 / Data Modeling

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 and XML Technologies.

OSG Services/ ZetaGlobal

100 Challenger Road, Ridgefield PK. NJ 07660

09/2022 – 04/2023

Position / Software Engineer C# / SQL Server Developer Framework 4.7.2

Duties: Working on multiple Projects; Migrating Data, Creating SSIS Packages SMTP, .NET 5 Framework. Database Physical SQL scripting. Debugging C# code within Visual Studio Troubleshooting and correcting issues in various Production Applications. Rest API, XML/JSON Content. Creating Dash Boards with Power BI., SSRS Reporting. Database Documentation and Troubleshooting of Procedures and Objects.

Creating Performance Metrics with Microsoft Power BI with Data input from Excel and SQL Server.

Repository used: GitHub. Use of Jira for story building and creating Tasks. PostMan – Testing API’s

BC Forward / JPM Chase

10 S Dearborn. Chicago, IL 60603

09/2021 – 01/2022

Position / Title: Contract ASP.NET C# / SQL Server Developer Framework 4.7.2

Duties: Migrating Legacy Web Application to .NET 4.7.2 Framework. Documentation, Database Physical Implementing Single Sign On (SSO) with ID Anywhere, SQL scripting. Java Scripting,

VB Scripting. Debugging code within Visual Studio 2019 and Perceptive Intelligent OCR Software (Brainware); Setting up Clients Invoice templates Troubleshooting and correcting issues in Brainware.

Repository used: GitHub (BitBucket)

OTLS (Life Solutions)

10342 Palermo Circle. Tampa, Florida 33619

11/2020 – 09/2021

(http://www.otls-life.com)

Position / Title: Database Developer (SQL Server)

Duties: Attending meetings architecting a SQL Server Database for an applications that is to be developed. (Development & Design), Database Documentation (Data Dictionary, Database Physical Model), Database creation and Tables in the Normal Form, Indexing, SQL scripting. Software tools used: Creately, Asana, MS Visio, MS. SQL server 2016. MS. Office, Experience in a virtual team development with SQL Server on Azure (cloud) platform.

SOLIX / Opteamix

30 Lanidex Plaza Parsippany, New Jersey

09/ 2019 – 10/ 2019

Position / Title: Contract Production SQL Server Data Analyst/ SSIS (Worked Remotely and On-site).

Client discussions in identifying the root cause of issues; tickets stored in Jira for resolve.

Writing complex Queries to manipulate Date / Time Data, Excel spreadsheets Data import using SSIS

A combination of production and development duties (designing, coding, testing, and implement Packages), Database development projects - ERP Data Synchronization of batches of data

Troubleshooting issues of a production application (Root Cause Analysis).

Tools Used: Visual Studio 2017 Programming in C#, SQL Server 20016 / SSDT (SSIS, UNIT Test).

Western Digital / AIT Resources

3355 Michelson Dr. Irvine CA 92612

10/ 2017 – 10/ 2018

Position / Title: 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 SSIS Logs for package runtime. Environment: Agile methodologies practiced. Visual Studio 2017 C# .NET Development of an HTTP Client Application; calling to a remote Splunk Rest API Service (used PostMan in Testing API); 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; Collaborate with teams to integrate systems.

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 frequent Project meetings.

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 methodologies practiced.

TBC Corp. (MMD Services, Miami, Fl)

Donald Ross Road, Juno Beach, Fl.

08/2016 – 11/2016

Position / Title: 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; Data Modeling; diagraming using Visio.

Unit Testing, Troubleshooting Windows Workflow.

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

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

Michigan Commercial Insurance

Wood Street, Sarasota, Fl.

10/ 2015 – 01/ 2016

Position / Title: Contract (Remotely and 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.

Resolving 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.

Ryder Systems ( Bridge Technologies )

11690 NW 105 St. Miami. Fl.

05/2014 – 10/2014

Position / Title: Contract – Data Analyst/Developer

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 SalesForce Integration

Pinnacle Finance

Hypoluxo Rd, Lantana, Fl.

01/2014 – 03/2014

Position / Title: 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 personnel (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 querying the data Objects.

First Service Residential (FSR).

Dania Beach, Fl

10/ 2010 - 06/ 2012

Position / Title: Contract SQL Server / C# .NET 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: Agile methodologies practiced, C# ASP.NET 4. /Windows 7/ Visual Studio 2010

TeleFonica. ( Insight Global)

Brickell Ave. Miami Fl.

02/ 2010 – 09/ 2010

Position / Title: Contract .Net / SQL Server Developer/ SSIS/ Data modeling

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.

02/2008 – 10/ 2009

Position / Title: MS SQL Server DBA/ ETL / 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, Conversion and Migration (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-hoc report requests from Sales Team and SSRS report requests from Management. (Writing Stored Procedures, and T-SQL Query statements ).

South Florida Electronics.

Oakland Park, Lauderhill Fl

01/ 2006 – 09/ 2007

Position: Contract - SQL Server 2005 Database Developer/ C# .Net Developer (Web driven application)

Participated in all phases of the Software Development Life Cycle, 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.

School / College / University

Certification

SOUTH THAMES COLLEGE (Putney)

Major: Science / Engineering

Country: England (UK).

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

NENE UNIVERSITY (Northampton)

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

Major: Hardware/ Software Engineering

Country: England (UK).

HND /BTEC Diploma (Associates Degree)

Software design: - The use of Structured Development

Methodologies and CASE Tools (Teamwork Unix sys).

Presentation Skills, Project Management, Discrete and Quantitative 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® Certified Professional.

Microsoft® Certified Technology Specialist: SQL Server 2008, Database Development

Microsoft® Certified Technology Specialist: Microsoft Office SharePoint Server 2007, Configuration

Microsoft® Certified Technology Specialist: .NET Framework 3.5, ASP.NET Applications

Microsoft® Certified Technology Specialist: SQL Server 2005