Bryan Nelson Email & Phone Number

Norfolk

Previous employer (FWT) merged with ISI; see below for responsibilities.

Virginia Beach, Virginia

• Created several complex, interactive custom data visualizations via D3 for PowerBI, Cognos, and web applications.• Refactored existing Spark applications for ingestion of DRRS files from NTFS to HDFS parquet format for ease of maintenance and extensibility. • Developed new .NET CORE API in C# and Vue.js UI to replace legacy NEURS application tabs related to fuel messages, fuel prices, and reporting ships. • Started building Vue.js UI to replace legacy NEURS application tabs related to manipulation of Cognos users and roles via active directory services. • Built and published restricted node package with common functionality for new NEURS UI's, which was succesfully integrated into both solutions. • Spearheading bi-directional Spark initiative for ingestion of SQL Server table data to parquet and vice-versa, which will be entirely configuration file driven.

Virginia Beach, Va

• Responsible for working with clients to deliver quality solutions within an agreed-upon timeframe which meet their business needs. • Migrating Chartway databases to new consolidated server environments and working with them to validate updated application connections. • Created donor management system in ASP.NET/MVC and Entity Framework with SQL Azure backend for ODU Athletic Foundation (ODAF) to replace their existing Neulion system; https://donors.olddominionaf.com/. • Collaborated with team at LifeNet to deliver ETL solution via SSIS for their new data warehouse. • Re-developed certain charts related to manufacturing for Continental in Newport News with chart.js to give them a more professional appeal and using MySql stored procedures to improve performance, which are displayed on a site I created for their management team in php. • Developed new SQL Server database and SSIS package to migrate Atlantic University student enrollment data from Access; started initial web application project in ASP.NET/MVC with Entity Framework to replace their current system. • Worked with LIEBHERR management in Newport News – as well as offshore contractors – to fix issues in their truck monitoring system which provides real-time data about mining vehicles (such as location, faults, etc.) to fleet owners via dashboard using ASP.NET/MVC with AngularJs, SQL Server, and Cassandra (Apache database). • Collaborated with other Marathon consultants on miscellaneous projects as needed.

Chesapeake, Virginia

• Responsible for automating processes related to CKS Financial daily operations. • Collaborate with management to design and implement enhancements and new features related to ASP.NET/MVC web applications used by collections agents and managers.• Developed .NET class library in C# and accompanying SQL Server architecture for mechanization of daily scrubs processing, which was being done manually every morning, that will reduce required execution time from a half hour to less than 10 minutes. • Converted several import/export processes from SSIS to purely managed code. • Working with our accountant to migrate analytics currently being done in spreadsheets to the web in the form of a dashboard and reports.

Norfolk, Va

• Work with Government Business Division to maintain legacy Medicare Advantage/Amerivantage invoicing system. • Currently building the Medicare Supplemental migration pieces relevant to billing operations.• Responsible for supporting the flow of invoice data from FACETS (Oracle 11.4) to SQL Server (2012) for outbound processing (via SSIS 2008/2012 on TIDAL) in the form of delimited extract files sent to vendors. • Update related SSRS reports and application portal pages (C#/MVC) while fine-tuning Oracle and SQL Server queries and performing optimizations as needed. • Mentor junior members of the Enrollment/Billing team while further expanding my knowledge of the enterprise.

Norfolk, Va

Six month contract-to-hire position working with Anthem Government Business Division. For responsibilities, see role above.

Norfolk, Va

• Collaborated with project team members to satisfy U.S. Navy-mandated data acquisition and information reporting and warehousing requirements.• Designed and implemented complex SSIS (2008) enterprise level ETL solutions which retrieved/derived data from several sources in various formats (Excel/Oracle/SQL Server) for aggregation and subsequent storage in the data warehouse.• Crafted SQL Server 2000/2008/2012 tables, views, triggers, and intricate stored procedures in the data warehouse. • Created configurable server baseline utility which automates selective restoration of SQL Server production databases, jobs, and SSIS packages in targeted development/test environments, as well as linked server establishment, and user creation/mapping via C# with SMO; what used to take several hours, now takes less than one. • Rewrote C# audit database scripter utility, which was using legacy DMO and ADO database connections, to leverage SMO and Entity Framework while eliminating repetitive code. • Engineered TFS-integrated C# forms application to automate scripting of less complex middle-tier database objects eliminating days of development effort and saving the customer thousands of dollars.• Developed efficient multi-format message parser C# console application which other project teams judged too difficult to accomplish.• Maintained Cognos framework and existing reports while also enhancing current reports and developing new ones. • Received multiple Employee Performance Awards.

Virginia Beach, Va

• Partnered with product development, design, and database teams, as well as other programmers, to discuss, analyze, and implement EmploymentGuide site functionality enhancements and updates. • Maintained legacy ColdFusion website, while actively working toward converting the entire site to php.• Wrote spider scripts in ColdFusion and php to crawl client sites for job listing content. • Created and updated SQL Server 2000 stored procedures.• Designed and developed ColdFusion business and reporting tools for use by customer service and sales representatives, while also providing technical support.• Monitored site performance and resolved issues alongside systems and database departments.

Norfolk, Va

• Analyzed client database requirements and created custom import files formatted for Raiser’s Edge6.x/7.x, Banner, Datatel and other platforms; performed conversions with Data Junction.• Provided off-site customer support through all phases of each project, including data export and import.• Consistently completed client file packages 1-2 weeks ahead of monthly deadlines.• Collaborated with IT department to rebuild Harris Intranet.• Multiple Client Service Center Strive for Excellence Awards.

Chesapeake, Va

• Analyzed customer requirements and implemented custom, web-based business information and reporting solutions for high-profile clients nationwide with little or no supervision.• Modified Crystal Enterprise 8.x/9.x systems to meet customer security concerns, business needs, and desired functionality.• Designed and developed Crystal Reports (8.x/9.x), including corresponding stored procedures, for use with Crystal Enterprise and other reporting systems.• Acted as on/offsite customer service and technical support representative for clients through each phase of the system development process and fellow consultants with troubleshooting issues.

Associate Of Arts And Sciences (A.A.S.), Computer Programming/Web Development, 4.0

Activities and Societies: Phi Theta KappaGraduated Summa Cum Laude with a double major in Web Development and Computer Programming.

Education record