add photo
Robert
RobWayCot@Yahoo.Com
239-200-3471
Boca Raton, FL 33432
Contract  Production SQL Server Data Analyst/ SSIS (Worked Remotely and On-site)
23 years experience W2
0
Recommendations
Average rating
101
Profile views
Summary

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.
  • 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 / 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

Technology Knowledge& Experience

SOFTWARE

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, Dream Weaver MX 2004, Corel Draw 5, SQL Server: 2005, 2008 /2012, 2015, 20016 / SSRS, SSIS (ETL). Mainframe JCL –Version Control:- SVN, SourceSafe, TFS, GitHub, SVN/ Visio 5/2000/ 2010,

HARDWARE

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

Experience
Education
Associate's in HND /BTEC
NENE UNIVERSITY

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’

Certifications
CSE’s x 6: - Physics, History, Art, Geography, English Language & Technical Drawing
‘O’ Levels x 4: - Math’s, Physics, Engineering Drawing, & English Language/Literature
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
Trouble shoot Locks / Database Tuning & Optimization of Queries / Data Encryption / Creating File gr
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
RPA Awareness
RPA Business Analyst
RPA Implementation Methodolog0079
RPA Solution Architect
RPA Developer
Skills
C#
2019
8
SQL
2019
8
SQL Server
2019
8
.NET
2018
6
Microsoft Excel
2019
5
ASP.NET
2016
4
Visual Studio
2019
4
Agile Methodology
2018
3
Database Backups
2012
3
DBA
2016
3
HTML
2018
3
T-SQL
2018
3
CSS
2007
2
Requirements Gathering
2010
2
SSIS
2019
2
Data Modeling
2016
1
Data Replication
2012
1
Database Design
2016
1
JavaScript
2018
1
JSON
2018
1
REST
2018
1
Splunk
2018
1
SSRS
2016
1
Stored Procedure
2016
1
Visual Basic
2018
1
Web Forms
2007
1
ADO.NET
0
1
Adobe Photoshop
2005
1
Bootstrap
2017
1
Compatability Testing
2005
1
Crystal Reports
2016
1
Data Analysis
2019
1
Data Dictionary
2003
1
Data Warehousing
0
1
Design Patterns
2016
1
ETL
2016
1
LINQ
2014
1
Metadata
0
1
MS TFS
2014
1
Oracle
2016
1
Performance Tuning
0
1
PL/SQL
2016
1
Project Management
2005
1
Quality Assurance
2005
1
Salesforce
2014
1
Scrum
2016
1
SQL Server Developer
2010
1
SVN
2016
1
Triggers
0
1
Web Developer
2005
1
WPF
0
1
XML
2010
1