C# Data Warehousing

Ronald Gaines

407-***-**** · ****@***********.***

*** **** ********* ******, *** Antonio 78212

SUMMARY

Experienced Professional in Cloud Application, Internet, and Client/Server Architecture with a focus on Enterprise- level solutions. Proficient in various technologies including SharePoint, C#, VB.Net, MSSQL, HTML, XML, CSS, JavaScript, and more. Skilled in Data Warehousing, ETL, SOA, and Object-Oriented Programming. Significant project experience includes:

SKILLS AND METHODOLOGIES

SKILLS: SharePoint 2007-2010, AJAX, C#, VB.Net, MSSQL, HTML, XML / XSLT, CSS, JavaScript, Microsoft Expression, Oracle, Data Warehousing, ETL, SSIS, Tran–SQL, PL-SQL, Development Web Part, AZURE Relay service, AZURE ACS, Raven NonSQL, AZURE Messaging, AZURE Service Bus, OLAP, C, C++, SQL, JQUERY, SOAP Web Services, VISUAL C++, ASP.NET, PL/1, ASSEMBLER, SQL Server DTS, Oracle PLSQL, dynamic stored procedures, Microsoft Visual Studio .NET APPLICATIONS: CRM, DATA WAREHOUSE, ETL DATA CHANNEL MIGRATION SERVICES, E-COMMERCE SERVICES, CALL CENTER SERVICES, CONTACT MANAGEMENT SYSTEM, HEALTHCARE, REAL-TIME VIDEO, IMAGE PROCESSING, CLIENT/SERVER (N * TIER)

METHODOLOGIES: RESTFULL, SOA, DATA MODELING, OBJECT-ORIENTED DESIGN SOFTWARE: DATA WAREHOUSING, MFC OOP/OOD, GUI, MS WINDOWS SDK

PROFESSIONAL EXPERIENCE

October 2019 - Present

InjurySnap inc. ( SimRobotics Enterprise Architect / Healthcare Portal) Design and Development of Healthcare Portal Software and systems Infrastructure. Infrastructure includes the Consumer to Business (C2B) Web Portal for Consumers to access health portal information. Design and development of mobile apps Android and IOS that share data with the Web based Health Portal. Data Access is managed by Federated Active Directories (AD) service. Web Client services and API services access is supported by tokens managed by AD services. The Web App and API apps are registered services in InjurySnap AD Services. SSL is used to encrypt traffic to and from all client and API service. The Web application services, and the Mobile application share the same API services. API service and object data models were designed to support data first requirements. Most Web and Mobile API requirement can be supported by the InjurySnap API Service. This includes AD lookup services that are used to map providers to consumers for healthcare services. SimRobotics designed InjurySnap data services to support realtime data exchange. The InjurySnap Message hubs use Signal R to realtime support any updates to medical records, Provider service updates and information messages that target the Web or Mobile portals. The InjurySnap Eco System is made up of core atomist Support systems and data services. Because of the large amount of disturbed systems and services, documentation was needed to support the cross-platform monitoring and integration requirements. System Administration process and policy was not only supported with documentation, but the Active Directory(AD) services also supported the reinforcement of policy thought the use of AD claims and the process and management of system rules that used claims data to control access to InjurySnap services and data resources using AD/claims data. This also help to increase the security of the application by allowing the SimRobotics Development team to build Code-extensions that are used at the API access level to control data and system access at a Realtime and ad hoc. Tools and services used by SimRobotics to build and develop the InjurySnap Healthcare Eco Systems for the Web Portal, Mobile App and Support InjurySnap Services included Visual Studio, Managed Identity (AD), Azure Database for MySQL flexible server, SQL database, Azure Function App, SignalR, Storage account, Application Insights, App Service Certificate, Cognitive services multi-service account, Communication Service, App Service, Azure Cosmos DB account, API Manager, Event Hubs, Data factory (V2), Front Door and CDN, Network Watcher,Virtual network Services, Micro Services.

Marathon Petroleum Corporation (MPC)

(Consultant Enterprise Architect) - 04/2021

Enterprise Resource Planning (ERP –SAP) and Energy Trade Risk Management (ETRM) systems at the heart of the management and information capabilities used to make decisions. Platform is cloud base: Azure, Databricks, Event Hub, Service Bus, SQL Server, C# .Net Core, Web services, API Manager, Power BI. ExxonMobil Software (Consultant Enterprise Architect) 01/2018- 01/2020 Data pipeline for Guyana drilling Automation Project Automated workflow based on Azure Data Factory process. Drilling contractor, drops automation data, workflow pushes data to the Cosmos DB, SQL DB and Data Portal. Support efforts included: Trouble shooting when data is missing. Updates when adding new wells, and data tags.

• Cutting Re-Injection (CRI) Report

Extended data workflow continuous automation data, CRI csv data is received daily including summary data and sensor data.

Challenges included: Data workflow and tracking updates to report data. Exporting data from CSV files and Excel reports.

Support: Data Factory process consulting or advice SQL DB scripting. HSC Vender Integration Services (Consultant, Integration supporting) Integration support using vendor API services and Reporting data. Service supported data feed from offpremise Data Services into MICROSOFT AZURE Database Services where data is processed using Data Factory and submitted to on-premise service through a Fire-Well using Azure SQL Server and Azure Blob Services API.

iCertis Vender Integration Services (Consultant, Integration supporting) Integration support using vendor API services. Service supported data feed from on-premise API Data Services into MICROSOFT AZURE Data Factory Services where data is processed through a Fire-Well using Azure Blob Services API. Once data is loaded into Azure blob, Data Factory is used to process data and submit customer data to vendors using Vendor API services. services. Parking Reservation Software / L&R Investment Company 02/2017-11/2017

(Consultant Enterprise Architect / CEO IT Adviser, Software Developer), Integration of Legacy Application to MICROSOFT AZURE, Agile Project Adviser, Software Product Development Adviser Adviser supporting Migration / Development / Testing of PRS Software as a Service 1.0 to PRS Software as a Service 2.0 using AZURE / API services. Software Developer supporting the integration of SAAS Reservation API with remote Azure Based SAAS Reservation API.Development included integration of security services and Realtime data feeds. Development-tools and services included Visual Studio, C# .NET, AZURE Web Apps.

• Complete Enterprise Code Review and Company Software Service Model Review

• Enterprise architecture mapping business strategy, instrumental in assuring that all technology solutions

• Supported the review and documentation of all legacy applications architectures.

• PRS API Services supported data directly Loaded into WallyPark Data HUB using PRS API Services.

• PRS API Services integrated into WallyPark Mobile App Development.

• Test Application Vendor data against Data and Reports

• Composed business requirements and designed system workflow services

• DEVOPS ALM development and support (Migration to AZURE) WallyPark / Joe’s Parking / L&R Investment Company. 11/2016- 10/2017

(Consultant Enterprise Architect / Project Lead, Conversion & Hybrid Integration of Legacy Application to MICROSOFT AZURE, Software Developer) Complete migration of WallyPark data services into AZURE based Data HUB with API services. This Enterprise architecture included the support AZURE DATA FACTORY services and the development of API services to support the ETL of data from Vendors Realtime. Software Development services using Visual Studio, C# .NET, Web API, Azure Web App service, AzurePush Notification services. Integrate to AZURE included:

• Administrative Interface supports pricing information, sites and updates of pricing data.

• Vendors update data directly in HUB using HUB API

• Test Application Vendor data against Data and Reports

• Share data with CRM/Sales

• Implement Best Practices for Error Handling and sharing Data.

• Publish Data Service API for vendors and WallyPark Mobile Apps, Monitoring and Heartbeat access toData API Services

• Development of mobile app/Web Services for WallyPark Customers. (Third Party Development support)

• Development of Enterprise Reporting Services using Power BI / Web API / ODATA/ SQL Server• Supported implementations of customized systems based on Microsoft Operations Framework standards.

• Conducted virtual planning sessions, established project objectives and tasks, and ensured the alignment of project goals and timelines

• Collaborated with Operations, Marketing, and Vendor to identify system requirements, to drive out issues, and to improve existing processes or implement new solutions

• Composed business requirements and designed system workflow services

• DEVOPS ALM development and support(Migration to AZURE) Orange Lake Resort TimeShare (Largest in the country) 06/2016- 12/2016

(Consultant, Integration/Conversion of Web API services and data into Realtime Data Feed from on premise Data Service into MICROSOFT AZURE Database Services, Software Developer) API services share and update information stored in on-premise systems with reservation services and remote legacy system including AS400 mainframe systems. Development of enterprise API architecture and services that constantly monitors SAGA API updates from SQL Database and Object Store Raven. The service used Azure Service Bus to transmit Realtime system and data updates to Azure. This was part of a migration process to move from on-premise data center to AZURE. During project Primary developer developing Data Migration service using Visual Studio, Azure Service BUS, Web API services, and C# .NET. CoreLink Corp. (Owned by Blue Cross Blue Shield) 01/2016- 06/2016

(Consultant Enterprise Architect, Conversion & Hybrid Integration of Legacy Application to MICROSOFT AZURE)

Enterprise architecture that maps to its business strategy, instrumental in assuring that all technology solutions, either built or bought, comply with the enterprise architecture, enterprise architecture including strategies, trends and products, align enterprise architecture with corporate goals and objectives. Documentation of enterprise architecture environment and procedures to ensure our technical infrastructure remains cost effective, efficient and of high quality. Participate in the analysis, design and planning phases of all CoreLink related projects.

Red Lobster Corporation. 11/2014- 06/2015

(Consultant Support Services, Supply System Development and Migration, Software Developer) Supported the migration of .Net based Supply systems from on- premises servers to Azure Cloud Services. Responsibilities included migration and update of supply system applications that supports all purchases of restaurant products from supporting vendors. System included over 25 subsystem components integrated into the core supply system. Development tools used in this environment included Oracle 10g, Visual Studio 2013, C#, SQL, SOAP Web Services, ASP.NET, Azure Cloud.

Darden Corporation / Red Lobster Corporation 11/2014- 06/2015

(Consultant Support Services, Forecasting System Migration, Software Developer) Supported the migration of .Net based Forecasting system from on- premises servers to Azure Cloud Services. Responsibilities included migration and update of forecasting system. Development tools used in this environment included Oracle 10g, Visual Studio 2013, C#, SQL, ASP.NET, Azure Cloud.

Northrop Grumman Corporation 08/2013- 11/2014

(Enterprise Private Cloud Services, Business Process Automation) (Northrop Grumman) Lead Software Engineer development of SharePoint client-side Private Cloud Request Service. Cloud Request services support the Auto-Build and Deployment of VM services including applications deployment on the VM. Engineered request the build of workstations supporting Number of VM systems, memory size, storage, and desktops. The private cloud service supports the Auto build of the environments including, fire wall deployment, calculation of cost and auto deployment of application on VMs. Visual Studio 2013 .Net, SQL Server, WCF, VCO, VSM, Rest Services, SAP PI, C# (Base Language), Sharepoint 2010-2013, WebPart development, etc.

Northrop Grumman Corporation 02/2011- 02/2013

(Enterprise SharePoint Services, Business Process Automation, Software Developer) Lead Software Engineer on SharePoint Enterprise services team. Sharepoint Enterprise services is a global support service that manages the development and deployment of services, and solutions implemented within Sharepoint. SharePoint Enterprise team members help customers design new products and services for Sharepoint, this also includes the re-engineering of existing solutions into SharePoint Models. Example: Northrop Grumman is a global company with over 120,000 employees. I was a lead developer in the re-engineering and deployment of www.northropgrumman.com into s. As a lead Software developer, I have developed more than 10 large projects within the past 3 years for SharePoint 2007 and 2010. These projects include Development using tools such as Visual Studio .Net, SQL Server, Odata, SAP PI, C# (Base Language), Sharepoint 2007- 2010, WebPart development etc.

ZooLogIt Request Services 04/2012- 02/2014

(Azure Cloud Service Development, Business Process Automation, Software Developer) Lead Software Engineer and Software Developer in development of Internet based product request and wholesales portal. Service allowed users to post request for items into request portal. Requests are placed into Service Request Q. Azure Roles supported the integration of Google API integration, Amazon API integration, Bing API integration and Ebay API integration. Within the Azure Role requests are forwarded using Azure Relay Service bus to remote servers. Request service integrated Data queries with Azure SQL. Database instant and Raven Object Database. All service APIs that support CRUD services are developed using WCF Rest / Odata services.

Azure, Visual Studio .Net, SQL Server, Odata, C# (Base Language), etc. Northrop Grumman Corporation 02/2009- 02/2010

(Business Process Automation, Software Developer) Bulk Transfer Manufacturing Process.

Software Engineering support for application users by Northrop Grumman ES sector, including Software development, Failure Analysis, Development of the Bulk Transfer system, and Development of the Process Change Request System. Development support also included Sentinel integration, Wip Tracking, and Development of the TRTR tracking system (Test Engineering Test Request).

Support included Northrop Grumman Cloud Services and the CloudOne development team. Northrop Grumman Corporation 02/2009- 02/2010

(Business Process Automation, Software Developer)

Software engineer in 2010, support and development of more than four major systems supporting the manufacturing process at Northrop Grumman Laser Systems in Apopka, FL. These systems include the installation and upgrade of the Laser System Accounting system to support a web-based client interface with a bi-directional data feed that supports the manufacturing system QA process. Laser System Manufacturing process has been trying to develop an inventory management process for the past 4 years that supports the Bulk Transfer of parts. Developed the first Bulk transfer system to support this need and help Laser System customers promote the new system to production. The new Bulk Parts transfer system saves man-hours during the report development process and improves the manufacturing process. The Bulk Transfer process developed for manufacturing customers is the new production process supporting part transfers for Laser Systems. Development tools and Systems used on this project included Oracle 10g, Visual Studio, SQL Server, SQL Server Reporting Services, C#, SQL, XML, SOAP Web Services, ASP.NET Northrop Grumman Corporation 02/2007- 02/2008

(Business Process Automation, Software Developer)

Senior Software Developer in support of intranet-based services. Northrop Grumman uses intranet applications that support and control operational tasks and services. The Systems used in this environment included Oracle 10g, Visual Studio 2005- 2008, SQL Server 2005, SQL Server Reporting Services, C#, SQL, XML, SOAP Web Services, ASP.NET MEDAI (Medical Reporting System and Services). 10/2006– 01/2007

(Consultant, Business Process Automation)

Development of web-based medical analysis software. The development environment includes Visual Studio 2005 2.0. NET., Oracle 10g, Infragistics Web Graphics, and Aspose Converter. Medical Reporting system supported display of medical outcome reports, Graphical representation of medical trends, and Web-based Report Export services to Excel. Development of data services included PL\SQL, C#, and VB.

.CIGNA \ CIGNA Dental (Add Hoc Report Email System eService) 04/2006 – 10/2006

(Consultant, Business Process Automation)

Development of Ad-Hoc Report email system. The Report \ Document Email system manages report requests from Customers \ Members. The system supports a member base of over 1.5 million. The service saves over $300,000.00 a month in member mail costs. The Email Report services collect customer documents based on search requirements collected from the member. PDF documents are created ADD-Hoc from customer requests within the Document Request services of eServices. Dynamic Document Creator Service is an ADD-Hoc PDF report creator that is reasonable for the creation of reports that are considered dynamic reports. These dynamic reports are created in a PDF format. The Document Request Service (DRS) submits a report request to the Dynamic Document Creator Service (DCS) once the request is received the DCS creates a PDF version of the report. Once the report is created the report is scheduled for email to the requesting member. The system tools included Oracle 9.2 Database (Corporate Data Store), Crystal Reports, SQL Server 2000(Client Admin Data and Metrics), PL\PDF (PDF creation), SOAP XML \ Web Server (Bridge to Corporate Data Services), ASP.NET, VB.NET. Design Engineer DocReminder (Automated Call Center) 10/2005 – 04/2006

(Business Process Automation)

Lead Architect in the design and development of an automated Physician call center. The automated call center automates the process of contacting Patients and informing them about their medical appointments and records. The service is a Web-based Application service that automates the customer phone call by using a text-to-speech data connection, Telephony Phone services using TAPI 3, Automated Report distribution using Crystal Reports, and Crystal Report Enterprise Report services. The automated call center was developed using Visual Studio ( C# and Visual Basic ), SQL Server 2000, Crystal Reports 9.0, Crystal Enterprise Server, TAPI 3.0 phone services, Speech SDK \ Voice to Text Data services.

Design Engineer / Lead Architect Orlando Clerk of Court 05/2005 – 10/2005

(Consultant, Business Process Automation)

Lead Architect in the development of Orange County Court Systems Restitution service. The Restitution service automates the process of collecting payments from Defendants and redistributing those payments to Victims. At any one time, the system will manage thousands of Court Case Restitution payments. The Presentation / Client services of the Restitution Payment system is available to Orange County Employees throughout Orange County. The development environment of the Restitution system is Microsoft.Net. The Database tier is Oracle 9.2. The system also includes a report server system supported by Crystal Reports 10.0. The patterns used in the baseline architecture include functional integration patterns to support the integration of the Restitution Payment system into the Orange County's Court systems accounting system. Corsolutions Corp. 09/01 –01/2005

Project Lead, Corporate Data Warehouse:

This role supports the management of CIF services, CIF Architectural Projects, CIF Metadata Management, CIF Capacity Planning/Database Sizing, CIF Data Management, CIF Warehouse Integration and Application Development. Sr. Dir. of CIF services is also responsible for the management and development of CIF data services that support the day-to-day operational task of CIF services. Project roles also include the management of CIF team member activities and the support of third-party data sources in the migration of data to the CIF data services. This includes management of the deployment of application performance modeling techniques with Business Intelligent third party tools and services. The Automated Identification and Stratification systems are managed by the Sr. Dir. of CIF services. These tasks include the Design, and development of the Automated Identification and Stratification systems. Other activities include the support and management of CIF information sharing services and CIF training services. These services are provided to CIF internal and external customers. ESSENTIAL FUNCTIONS AND RESPONSIBILITIES INCLUDED

• Coordinates CIF Data project activities and project requests.

• Management of CIF Data Architecture Projects

• Management of Automated Identification and Stratification systems

• Architect and Design Engineer

• Data Integration Modeling.

• Systems Analyst and Programmer.

• Project role also includes the management of team member activities and the support of third party datasources in the migration of data to the Data Warehouse.

• Point person for routine discussions with senior leadership to ensure the Data Warehouse reflect reporting requirements of individual departments.

Tyco, ADT Security Services 05/01 - 07/01

Senior Engineer, ADT CRM System

ATD is the country’s largest Home security service company. The ADT CRM system was a large client \ server application that was developed with VC++, PL-SQL on an Oracle multi-tier database service and P-SQL services. The project had been under development for over two years. My role was to perform a software systems Architectural review, assist in refactoring of object code and classes, and system debugging. Sensormatic Inc. 01/01 – 05/01

Project Lead, Systems Architect, and Senior Engineer in the development of the Control Center 1.0. Sensormatic is a 1.5 billion company providing products and services in video systems and product theft detection. The company has opened new integration departments to develop new products and services that integrate its core product lines. Project Lead and Senior Engineer in the development of Control Center 1.0. Control Center 1.0 provides remote security services that integrate video monitoring services and theft tag detection systems. The system is made of four core services developed in C++. The core services communicate through TCP/IP and use an SQL database to support the storage of system state data and client configuration data. Client Services of Control Center 1.0 uses RAS to connect to the Control Center Server. Through RAS, Users can connect to the Control Center Services, view historical data, monitor alarm activities that have occurred on the remote system, and view the System Video that was stored with that information.

ERT Group. /00 – 10/00

Chief Architect of CRM Application Design and Data Integration Modeling. Lead Application design Engineer, Roles and Responsibilities: Design of data channel integration services. Worked with Dot Com customers facilitating integration design of CRM, ERP and Contact management systems. CRM application services included Seibel 6.0 and Sales Logix. Integration of ERP services included Great Plans “Dynamic software”. Provide extraction transformation and loading (ETL) services using SQL Server 2000 Data Transformation Services (DTS). ETL services supported the migration of data from existing customer CRM services. SQL Server 2000 DTS services provided a mechanism for the transformation of data from heterogeneous data sources to a single homogeneous customer relationship management system.

(CRM).

USA Network Inc. \ PRC Inc. 12/99 – 07/00

Chief Architect Dynamic Elements / Lead Architect Data Warehouse Roles and Responsibilities: Architect Project Lead, Metadata Management, Capacity planning/database sizing, Telephony volume calculations. As lead developer and Application architect, my responsibility was the design and development of data channel services that supported the migration of data from homogeneous and heterogeneous data sources to an enterprise data warehouse service. My project role Included the management of team member activities. The Data services also had to support third party data sources in the migration of data to the data warehouse.

The system developed incorporated the movement of remote data from each data-Island to the centralized data warehouse. The system converted remote data into XML/DTD data that was constructed by an XML DOM. Once the data was constructed at the remote site the data was then loaded into Message Queuing services that migrated to data to the centralized data warehouse. XML data at the centralized warehouse was then polymorfied into the data warehouse Star Scheme for use by CRM services. Architect / Design Engineer / Lead Architect AT&T Call Center Roles and Responsibilities: Project Lead, Project Manager Design of call center application services to support AT&T call center agent. Agents manage the daily inbound and outbound calls from AT&T customers. As Design Architect and Project manager requirements included the management of team member activity in support of the discovery phase for system requirement and design of system service functionality requirement.

Computer Science Corporation, Winter Park Florida 03/99 – 12/99 CSC is developing shrink rapid applications that hold the business-critical services of banking customer collections and banking customer acquisitions (loans). The system allows the user to design the business process through a flow design tool. Once the business design is made the workflow can be compiled to put into operations for business process software that runs the business process. I have worked on the development of both the Design tool and the business process services. The development is primarily COM and DCOM services providing an interoperation of processing for the application services. The system is made up of over 244 COM services. The development tools are Visual C++ and Visual Basic. Other tools and Services are ALT, MFC, STL, and VB collections. Harris Semiconductor, Palm Bay, Florida 05/97 – 03/99 Development of Enterprise Internet and Extranet web applications. The electronic commerce information systems developed provide the personalization services of information, products and services for Harris Semiconductor customer base. It is important to provide information services to customers for customer development. The development of the Electronic Commerce services includes the complete development life cycle. The architecture of the application services are N- tier Client / Server providing fault tolerant scalable services for millions web hits daily, operating 24-7 timetables. The tools used in the development IIS, Site Server, ASP, SMTP, MTS, COM & DCOM, Visual Interdev, Visual C++, Visual Basic, Oracle 8 & SQL Server 6.5 and FrontPage 98. As the lead developer, I have a requirement to know all of the development tools at an Expert level. Analyst and developer in the development of prototypes for Critical Information systems in the migration of Mainframe Information systems (IDMS, VMS, CICS) that facilitates the processing and transactions for product sales. New system utilizes Distributed Transactions that enable the global information system to manage transactions on a Windows NT Platform and Incorporated transaction servers (Distributed Business Object) that Handles business rules and processing. Development Experiences and Requirements include CORBA, DCOM, JAVA and Object Orientated analysis and design (BOOCH methods). Senior engineer in the development of Object-Oriented Prototype in JAVA n-tier client /server global products and sales system. JAVA and (CORBA, DCOM) are used to scale the performance by 10X. The Client/Server system is providing the migration from IDMS mainframe to a Windows NT Oracle 8.0 data- store, utilizing DCOM and or CORBA as the mid-ware. (Prototype is built in both). The client development environment is Java.

Java serves as a Very light client utilizing the CORBA and DCOM objects. On the DCOM side MTS is used to manage the Object-Context of the COM objects. The development environment for DCOM objects is J++ and Visual C++. The development environment for CORBA is VisiBroker for Java as the CORBA ORB, the development of the CORBA objects is a combination of J++ as the Java editor and VisiBroker Compiler. ODBC and JDBC serve as the connection services to the Oracle 8 server. They also provide a Client/Server plus architecture. Responsible for providing detail systems migration plans for IDMS systems to Oracle 8.0 data store. The migration plan provided for a method of migration. The migration plan includes detail Phase level migration steps and the development of Object oriented tools and techniques that can be used in the migration services of multiple systems and projects. Senior engineer in the development of Client Information system that extended the conceptual management of NT Servers through domains by Integrating the concepts of the management of Business and Organizational business groups, sectors, divisions and functional areas with NT servers and the services that are provided on the servers. Client

Contact this candidate