Robert Cotterell

Freelance Software Tester & Database Programmer

Location:Pompano Beach, Florida, United States
2 Skills
Robert Cotterell
2500 N. Federal Highway
Boca Raton
Florida, 33431

Telephone: (239) 200 3471

Email: RobWayCot@Yahoo.Com

January 11, 2012

For the attention of: Human Resources. :
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; in Programming; have an ongoing exposure to C#; Visual Studio .NET 2005/08. - Experience in using various QA Software Testing methodologies; in support of Software Development projects with databases; using MS SQL Server 2005 Standard / 2008; 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. Salary range: Negotiable.

Yours sincerely,
Robert Wayne Cotterell.

2500 N. Federal Highway,
Apt. 317
Boca Raton, Florida, 33431

Tele: (239) 200 3471

SQL Professional Skills

• Expert in installation, upgrade and configuration of MS SQL Server and databases in non-clustered environments.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Experience with MS Office Products / Visual Studio 5 / 6: Visual Basic, Visual C/C++, C#,
familiar with Java, Cobol.
• 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
• Excellent knowledge in Performance tuning using various SQL Server Commands and DTA (Database Tuning Advisor)
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Experience in ETL of data using SQL Server SSIS; migration of Data from Excel, Flat file, etc.
• Experience with SQL Server 2005/2008, DDL/DML Triggers.
• Excellent knowledge in system tables and system stored procedures using T-SQL.
• Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export
• Troubleshooting, Database Objects authorization, DTS,ETL; using (SSIS), Objects Creation such as Tables, Views, Good Knowledge of Data Warehouse (SSAS) and SSRS.
• Strong skills in documentation of procedures and processes of a system in a format that is easily understood
• Experience with Data Types, Indexes, Stored Procedures, Triggers.
• Familiar with XML technologies
• A Microsoft Certified Professional.
• Experience with ADO.NET, ASP.NET and C#
• 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: Microsoft Windows 3.1/ 95/98/2000 /Server, MSDOS 6.2, Front Page 98/ 2000, Winrunner 8.0, Microsoft Word 97/2000, Excel 97/2000, Access95/97/2000, Visual Studio 05 / 08, Microsoft Visual C++ 2.0 /5.0/6.0, Visual Basic 5.0/6.0, C# .Net, Crystal Report 6.0, SourceSafe, SQL Serve). HTML 4.0, CSS, Adobe Photoshop CS2, DreamWeaver MX 2004, Corel Draw 5, Visio 5/2000, SQL Server Database Tools / SSRS, SSIS (ETL).
• Hardware: In-depth knowledge of Operating systems; JCL -Mainframe, PC hardware and Software components.
Professional Experience

Date: 11/ 2010 – 01/ 2011; Company: Continental Group (FSR) Dania, Fl.
Position: Contract SQL Server DBA / Developer
Duties: Maintaining Indexes on production Database / Backups/ optimization of Queries /Trouble-Shoot and Monitoring Deadlocks with the use of SQL Profiler. 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: .NET 4. / Windows 7, Visual Studio 2010

Date: 3/ 2010 – 08/ 2010; Company: (TeleFonica) InsightGlobal Consultants, Fl.
Position: Contract SQL Server DBA / Developer / SSIS-
Duties: Client discussions to gather requirements, 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 2008 Team, .NET 3.5. / Windows 7 environment.

Date: 5/ 2008 – 7/ 2009; Company: Target Point Media/ Coral Springs, Fl.
Position: MS SQL DBA / Developer - SQL Server 2005 Standard Edition / 2008.
Duties: Performed SQL Server 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) solutions using SQL Server Integration Services (DTS/SSIS packages); Visual Basic Scripting, and some working knowledge of SSRS) ; writing Stored Procedures, and T-SQL Query statements for creating, displaying contents and altering of tables, in facilitating the Sales And marketing departments in their task of E-mail Campaigning Delivery Services (Marketing, Advertising, Mail Shot).

Date: 12/ 2007 – 03/ 2008; Company: Bartec Group / (Tyco Safety Products) Boca Raton, Fl.
Position: Contract – SQA Analyst - Working with Hardware / Software
Duties: 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.
Project documentation: The procedural flow of steps taken in performing tests, and the logging of faults found as a result of tests conducted.

Date: 04/ 2007 – 06/ 2007; Company: S Florida Electronics. Oakland Park Blvd. Fort Lauderhill Fl.
Position: Contract - SQL Server 2005 / Database Developer (Web driven application)
Duties: 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: Project requirements documentation, after initial meeting with client Flow charts / Excel spreadsheets in the use of documenting the contents of database tables, etc.


Experience Continues

Date: 01/ 2006 – 07/ 2006; Company: ZERO-NOW. Bletchley, Milton Keynes, Buckingham (UK)
Position: Web Developer. / QA Analyst Tester
Duties: As a valued member in the web development process, within a close creative team environment; maintaining, updating, 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 .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.
Date: 11/ 2005 – 01/ 2006; Company: CAD STAR. Grange Farm, Milton Keynes. (UK)
Position: Contract Programmer / Software QA Analyst Tester
Duties: Debugging Software Applications develop using Qt interface classes within C++ Visual Studio Environment. Q.A Analysis of the software usability. Proposed and suggested GUI design in design review meetings.

Date: 06/ 2003 – 12/ 2004; Company: NOVA Southeastern University. Davie, Florida, USA.
Position: Computer Lab Tech. Support /Technician
Duties: 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 users (of Microsoft Office, etc.).

Date: 05/ 2002 – 04/ 2003; T.A.G. Tamarac FL USA
Position: Software Tech. Support
Duties: Technical Support, for a Satellite pay Internet Industry. IBM PC’s; & PC Tools Installation /Configuration Providing level 1-2 Technical Support via Telephone to end users of HUGHES Satellite Internet Connectivity with MS Windows 98, 2000, & XP, E-mail issues, and Utilizing TCP/IP

Date: 08/ 2001 – 05/ 2002; (TekSystems) Companies: (Banco Atlantico / Assurant-American Bankers / Perry Ellis Supreme). South Miami, FL USA.
Position: Technical Writer / Data Modeler (Contract)
Duties: With a strong understanding of SDLC; in 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 (Instructional Design Methods applied) that contained instructions, procedures and guidelines.

Date: 01/ 2000 – 05/ 2001; Company: Coverall Inc. Cypress Creek, Fort Lauderdale. Florida USA
Position: Programmer /Technical Writer (Contract)
Projects: Marketing Management System / Financial Accounting. Environment / Duties: Client Server -IBM PC’s; Windows 2000 Networking, Utilizing Word 2000,Visio 5.0, Visual Basic 6.0, Source Safe & MS SQL Server 7.0 Contribute to the application project by providing critical support to the project development team, in the Normalization of data, to ensuring data integrity. And 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. Some coding - using Visual Basic 6 tools working with (Combo Boxes, Grids, SQL coding, and ADO) in the redesign & improvement of the GUI, Amending Visual Basic Source Code, Creating Database Tables, Develop documented user examples, Technical Documentation of program specifications, and Flow Charting Program procedures.


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

MERTON TECHNICAL COLLEGE (Merton) Computer Science & Programming in COBOL
(City and Guild Diploma Course)

(HND/BTEC. Hardware/Software Engineering) 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, Structured Programming, Electrical & Communication Studies, Digital Electronics, System Design & Computer Architecture.
Professional Education and Certification

HND /BTEC (Higher National Diploma / Business & Technology Education Council).
• Programming in Pascal and ‘C’
• Microprocessor Systems: Intel 8085/8086, & Motorola 68000
• System Design Software Tools ( SDST )
• Digital Electronics.

Microsoft Related - Certificated course:
• MS SQL Server 2005 / 2008 Implémentation / Maintenance (MCITP):
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.
• Microsoft .NET Framework 2.0 & 3.5 – Application Development Foundation (MCITP).
• Microsoft ASP.NET Framework 2.0 & 3.5 – Application Development Foundation (MCITP).
• Configuring Microsoft Office SharePoint
• Access / 97 , Excel / 97
• Mastering Visual Basic 6.0 for Developers, Visual Basic II Advance

MCT Transcripts: link to MCT Transcripts: ID = 877643 Access Code, verbatim. = RobWayCot