Bobby Williams Email & Phone Number

Raleigh, Nc, Us

Raleigh, North Carolina, Us

As a Sales Engineer at COZYROC, I'm at the forefront of empowering organizations to revolutionize their data integration processes. Leveraging my extensive background as an ETL Developer providing technical support for COZYROC solutions, I now specialize in presales, collaborating closely with clients to understand their unique challenges and architecting tailored solutions with our innovative SSIS+ component suite.

Raleigh, North Carolina, Us

Virginia Beach, Va, Us

• Created stored procedures to extract/parse data from LoanSphere MSP (BlackKnight’s loan servicing system) canned reports and stored data in SQL data tables.• Created stored procedures to create export files using extracted/parsed data from MSP canned reports.• Re-write Passport queries in stored procedures using LFN/BDE data from SQL data table.• Create scheduled SSIS packages to export daily and monthly export files with file system task and C# script task to refresh excel template data sources and distribute to end users.• Build ad-hoc queries within Passport for client and internal requests.• Utilized Navigator to identify transaction structure for canned reports to be parsed.

Raleigh, Nc, Us

• Technical role for three areas within the Data & Analytics group for the Risk Management Department.• Daily Monitoring and troubleshooting of file uploads, report refreshes and over 100 SQL jobs and packages for Daily, Weekly and Monthly loads of data that are used in populating data & analytics reports.• Implement solutions for incoming business requests, modifying and creating new reports, developing Stored Procedures, Views and tables to support reporting data that is distributed through excel (pivot tables) on SharePoint and Tableau reports.• Stored Procedure enhancements, uploading files, and automating processes that were previously manual for the Filings, Edit Checks, Reconciliations and Attestations steps of the Comprehensive Capital Analysis and Review (CCAR) federal regulatory process within the Risk Management Department.• Modified over 200 Stored Procedures for deprecated system table references and behavioral changes with SQL join logic in preparation for a SQL 2008 to 2016 migration.• Modification of SSIS packages for additional requirements and functionality as needed.• Developed a C# Windows Forms Application within SSIS Script Task to aid in the monitoring of file upload checks, report refreshes and SQL job run process.

Raleigh, North Carolina, Us

As an Implementation Specialist at FMSystems I have worked writing SQL Server Reporting Services (SSRS) reports, as well as SQL Server Integration Services (SSIS) packages to perform ETL tasks that brought data into the FMSystems FMInteract product.In my primary roles at FMSystems my expertise in writing SSRS reports was put to use first by writing out of the box reports for each of the modules of the FMInteract product. In addition, for each customer I wrote custom reports based on individual customer requirements. I also provided mentoring to my colleagues to help them learn writing SSRS reports as well.One of my key contributions with FMSystems was also in the area of integrations. Using SSIS I built a standardized ETL integration framework to migrate over 30 customers that were using a competitive product to the FMInteract environment.Technical Skills and Professional Qualifications:• Expertise in SQL Server Reporting Services (SSRS)• Skilled in writing Sql Server Integration Services (SSIS) integrations packages to perform ETL (extract, transform, and load data) tasks.• Install, configure, customize and upgrade clients to the FMInteract software.• Converting customers Crystal Reports to SSRS reports.• Creating ASP.NET applications to automate tasks that were previously repetitive in nature.• Create SOAP web services to import and export data to and from FMInteract product.

Raleigh, North Carolina, Us

INC Research – Raleigh, NC 2005 – 2006A global, therapeutically specialized contract research organization.Application Report Specialist• Work with business units to determine required reporting from various enterprise systems.• Develop and work with internal developers to provide customized reporting from system.Convert existing reports to standardized web-enabled distribution environment.

Spring Break Travel – Chapel Hill, NC 2004 – 2005One of the largest spring break travel companies.Web Master• Assisted in migrating Spring Break Travels dedicated server to a new remote server. This consisted of moving ASP code, SQL database, data files, registering .dlls, testing to make sure everything was working and reinstalling the Verisign payment solution.• Writing reports in ASP against a SQL database to assist in accounting for traveler counts and options.• Trouble shoot payments through Verisign credit card processing software.• Maintaining and adding content to Spring Break Travels website as needed.

WEBBASIX, INCA leader in eBusiness solutions, software development, web site design and business class hostingSALES• Created qualified leads through leveraging networking and sponsorship opportunities and building referral relationships.• Delivered on site client and prospect demos and needs assessment meetings.• Served as central point of contact between sales, proj management and development team.• Successfully generated leads through cold calling and site visits.SOLUTIONS DEVELOPER• Built VB, Access app to gather enter and search for information related to organization, technologies and patents as well as make changes and additions for ASP website.• Created content management tool to allow customer to change sections of their website using C# .NET, SQL, and Stored Procs• Added additional product types and made changes to pricing application using Excel and VBA• Made changes and additions to eCommerce store using VB.NET, SQL, and Stored Procs

CISYS, INC. - Raleigh, NC 1998 - 2002 High-tech consulting company providing customized application development and systems integration services for wireless, web and e-business applicationsSYSTEMS DEVELOPERKey ContributionsServe as lead or co-developer on projects for large and mid-size corporate clients Review, analyze, and modify programming systems including encoding, testing, debugging and documenting programs. Create project specs and develop or write new code to support existing applications.

Basking Ridge, Nj, Us

MCI – Cary, NC 1993 - 1998Client Call Center and Network Services Division of leading global telecommunications providerENGINEER I 1998HELP DESK ENGINEER/ TECHNICAL SUPPORT 1996-1998TECHNICAL SERVICE SPECIALIST 1993-1996Key Contributions§ Provided exceptional customer support to highly-visible clients by responding to, diagnosing and resolving network and circuit-related problems§ Supported MCI's Intelligent Call Routing Products division including consulting, programming and troubleshooting§ Responsible for Internet and Intranet development for the group, including design, HTML, coding and site maintenance.§ Performed switch testing of DEX600, DMS250, DMS100 and Siemens for MCI’s local telecom service