Uploaded File
no photo
Robert
Contract Production SQL Server Data Analyst/ SSIS
12 years experience W2 Boca Raton, FL
Actively seeking
no photo
Robert
Contract Production SQL Server Data Analyst/ SSIS
12
views
0
Recommendations
Average rating
12
Profile views
C# SQL SQL Server .NET Microsoft Excel ASP.NET Visual Studio Agile Methodology Database Backups DBA
Remove Note
View Note
Recent Experience
Contract  Production SQL Server Data Analyst/ SSIS (Worked Remotely and On-site) 09/19 - 10/19
C# Data Analysis Microsoft Excel SQL SQL Server SSIS Visual Studio
Contract –SQL Server; SSIS / VB, .Net C# Developer | Database Development 10/17 - 10/18
.NET Agile Methodology C# HTML JavaScript JSON REST Splunk SQL SQL Server SSIS T-SQL Visual Basic Visual Studio
Contract –SQL Server / Developer 04/17 - 06/17
Agile Methodology Bootstrap JavaScript SQL SQL Server T-SQL
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

Top 5 Skills
SkillsProficiencyLast Used
C#
2019
SQL
2019
SQL Server
2019
.NET
2018
Microsoft Excel
2019
Education and Certifications
Associate's in HND /BTEC
NENE UNIVERSITY
CSE’s x 6: - Physics, History, Art, Geography, English Language & Technical Drawing,
‘O’ Levels x 4: - Math’s, Physics, Engineering Drawing, & English Language/Literature,
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen