Human Resources Sql Server

Location:

United States

Salary:

130000.00

Posted:

September 18, 2024

Contact this candidate

Resume:

September **, ****

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/2019/2022 - 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/ 2019/; 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.

Professional Skills

Technical Skills in Programming Languages and Tools:

Proficient in C# ASP.NET and experienced with various versions of MS Visual Studio.

Strong command of SQL Server, including T-SQL, SSIS (Integration Services), SSRS (Reporting

Services), and good knowledge of SSAS (Analysis Services).

Familiarity with bug tracking software for issue management.

Skilled in creating data models, including Entity-Relationship (ER) diagrams.

Experience with version control software for managing code changes effectively.

Diverse Experience and Roles:

Versatile background with roles spanning Technical Writer, Web Developer, Software QA Engineer,

Programmer Analyst, Data Analyst, and Database Developer, Chief Mainframe Operator,

IT. Support Technician, Application Developer (Programmer).

Exposure to large mainframes as an operator, demonstrating adaptability to different environments

and technologies.

Database Proficiency:

Extensive experience in working with database-driven applications, including handling database

Inputs and Outputs.

Ability to develop and optimize database structures and queries to ensure efficient data retrieval and

manipulation.

Analytical and Problem-Solving Skills:

Proven ability to analyze complex problems and develop effective solutions.

Experience in troubleshooting and debugging software applications to resolve issues efficiently.

Communication and Documentation:

Effective communication skills demonstrated through roles such as Technical Writer and

Programmer Analyst.

Proficient in documenting technical specifications, user manuals, and system documentation.

Adaptability and Continuous Learning:

Demonstrated adaptability by transitioning between different roles and disciplines.

Openness to learning new technologies and programming languages as evidenced by exposure to

various forms of programming languages.

OSG Services / Zeta Global.

100 Challenger Road, Ridgefield PK. NJ 07660

09/2022 – 04/2023

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

Duties: Working on multiple Projects; Data Migration. Developed complex SSIS ETL Processes (Data: Extract, Transform and Load) with the use of SMTP, .NET 5 Framework,T- SQL scripts to gather data from various databases and to make data available for analytics and reporting. C# coding & Debugging within Visual Studio, MSTest tool, Troubleshooting and correcting issues in various Production Applications. Rest API, XML/JSON Content. Creating Dash Boards with Power BI., SSRS Reporting. Database Documentation of Procedures and Objects. Creating Performance Metrics with Microsoft Power BI with Data input from Excel and SQL Server. PostMan used for Testing API’s, Within an Agile working environment.

Repository used: GitHub. Use of Jira + Confluence for story building and creating Tasks.

BC Forward / JPM Chase

10 S Dearborn. Chicago, IL 60603

09/2021 – 01/2022

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

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), Within an Agile working environment.

OTLS (Life Solutions)

10342 Palermo Circle. Tampa, Florida 33619

11/2020 – 09/2021

Position / Title: Senior Database Developer (SQL Server)

Duties: Attending meetings architecting a SQL Server Database for an application 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, Agile 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 Unit testing 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# coding .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