Uploaded File
add photo
Robert
RobWayCot@Yahoo.Com
239-200-3471
Boca Raton, FL 33432
Contract Production SQL Server Data Analyst/ SSIS
20 years experience W2
0
Recommendations
Average rating
26
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
Contract  Production SQL Server Data Analyst/ SSIS (Worked Remotely and On-site)
Information Technology
Sep 2019 - Oct 2019

  • 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(Design, document, and implement Packages), Database development projects - ERP Data Synchronization of batches of data
  • Tools Used: Visual Studio 2017 Programming in C#, SQL Server 20016 / SSDT (SSIS).
C# Data Analysis Microsoft Excel SQL SQL Server SSIS Visual Studio
Remove Skill
Contract –SQL Server; SSIS / VB, .Net C# Developer | Database Development
Information Technology
Oct 2017 - Oct 2018
Irvine, CA

  • 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 SSISLogs 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; 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 frequeny Project mettings.
.NET Agile Methodology C# HTML JavaScript JSON REST Splunk SQL SQL Server SSIS T-SQL Visual Basic Visual Studio
Remove Skill
Contract –SQL Server / Developer
Insurance
Apr 2017 - Jun 2017
Plantation, FL
  • 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.
Agile Methodology Bootstrap JavaScript SQL SQL Server T-SQL
Remove Skill
Contract ASP.NET / SQL Server Developer Net (Framework 3.5 /4.5) Developer
Manufacturing
Aug 2016 - Nov 2016
Juno Beach, FL
  • 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
.NET Agile Methodology ASP.NET C# Data Modeling Database Design Design Patterns Scrum SQL SQL Server Stored Procedure SVN T-SQL
Remove Skill
Contract (Remotely and On-site) - MS SQL DBA / Data Analyst
Manufacturing
Oct 2015 - Jan 2016
Sarasota, FL

  • 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.
Crystal Reports Data Analysis Database Design DBA ETL Oracle PL/SQL SQL SQL Server SSRS T-SQL
Remove Skill
Contract - Data Analyst/Developer
Information Technology
May 2014 - Oct 2014
Miami, FL

  • 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
C# ETL Microsoft Excel Salesforce SQL SQL Server T-SQL SSIS
Remove Skill
Contract SQL Server (2008R2) / .Net (Framework 4.0) Developer
Banking/Financial
Jan 2014 - Mar 2014
Lantana, FL

  • 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 personel (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 quering the data Objects.
.NET C# LINQ MS TFS Oracle SQL SQL Server
Remove Skill
Contract SQL Server DBA / Developer
Construction/Engineering
Oct 2010 - Jun 2012
Dania Beach, FL

  • 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
Agile Methodology ASP.NET C# Data Replication Database Backups DBA SQL SQL Server Visual Studio
Remove Skill
Contract .Net / SQL Server Developer/ SSIS/ Data modeling
Telecommunications
Feb 2010 - Sep 2010
Miami, FL

  • 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
.NET ASP.NET C# Data Modeling Database Design Microsoft Excel Requirements Gathering SQL SQL Server SQL Server Developer SSIS Visual Studio XML
Remove Skill
MS SQL Server DBA / Developer - SQL Server 2005 Standard Edition
Hospitality and Entertainment
Feb 2008 - Oct 2009
Coral Springs, FL

  • 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 and Conversion (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-hov report requests from Sales Team and SSRS report requests from Management.
  • Writing Stored Procedures, and T-SQL Query statements,
DBA SQL SQL Server .NET C# Database Backups Microsoft Excel SSRS Stored Procedure T-SQL
Remove Skill
Contract - SQL Server 2005 Database Developer/ C# .Net Developer (Web driven application)
Manufacturing
Jan 2006 - Sep 2007
Oakland Park, FL

  • 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.
.NET ASP.NET C# CSS HTML Microsoft Excel Requirements Gathering SQL SQL Server Web Forms
Remove Skill
Web Developer.  / QA Analyst Tester 
Utilities/Energy
Feb 2005 - Dec 2005
Lauderhill, FL

  • As a valued member in the web development process, within a close creative team environment; maintaining, updating, and 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; C# .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.
.NET Adobe Photoshop ASP.NET C# Compatability Testing CSS HTML Quality Assurance Visual Studio
Remove Skill
Computer Lab Tech. Support /Technician
Education
Jun 2003 - Dec 2004
Davie, FL

  • 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 student users of Microsoft Office products, etc.
No skills were added
Remove Skill
Technical Writer / Data Modeler
Information Technology
Aug 2002 - May 2003

Banco Atlantico / Assurant-American Bankers / Perry Ellis

Duties: With a strong understanding of SDLC

  • 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.
  • Produced Instructional Design Methods applied that contained instructions, procedures and guidelines
Data Dictionary Data Modeling Microsoft Excel
Remove Skill
Programmer /Technical Writer
Information Technology
Jul 2001 - May 2002
Cypress, FL

Projects: Marketing Management System / Financial Accounting.

  • Environment; Utilizing Word 2000, Visio 5.0, Visual Basic 6.0, SourceSafe, MS SQL Server 7.0 & MS Access.
  • Contribute to the application project by providing critical support to the project development team, in the Normalization of data, to ensuring data integrity, 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 in view of redesign & improvement of the GUI
  • Oversee the ongoing development coding in view of standardization, Coding in Visual Basic 6 tools working with (Combo Boxes, Grids, SQL coding, and ADO) in the, Amending Visual Basic Source Code, Creating Database Tables, Documented user examples. Documentation of program specifications, & Flow Charting Program procedures.
SQL SQL Server Visual Basic
Remove Skill
Edit Skills
Non-cloudteam Skill
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