Randy Sims Email & Phone Number

Staunton, Va, Us

Staunton, Va, Us

Irvine, Ca, Us

Irvine, Ca, Us

Irvine, Ca, Us

Led developers in implementations of Azure Synapse data lake solutionsWork with network and infrastructure teams to define Azure resources, firewall rules, and access controlsRe-architected python classes and data flow to implement more performant data structures and methods in DatabricksTrain developers to transition from developing SQL Server to a cloud-based solutionLed developers with assigned tasks to implement requested changes and best practicesTools: Azure Portal, Azure Storage Explorer, Azure Synapse Analytics, Databricks, Azure DevOps

Cincinnati , Oh, Us

Architect solutions for trade feeds, ETL, and Data Warehousing both on premises and in AzureDesign and create Azure cloud solutions using Data Lake Storage, Databricks, Logic Apps, and Data FactoryPerform Azure-based infrastructure changes utilizing Terraform and Azure DevOpsAdvance and implement coding and testing standards, coding reviews, and repository standardsCreate developer-friendly documentation and provide training to the software engineering teamDevelop SSIS solutions for data exports, faxing, and SFTP transfersCreate C# Dynamic Link Libraries (DLLs) to interact with WinSCP, webservices, and web API interfacesDevelop complex queries, stored procedures, views, and notebooks in SQL Server, Oracle, and Spark

Develop and Support Microsoft SQL Server and Oracle 11g Databases for government clients.Administer SQL Server Reporting Services for reporting.Create ETL packages using Integration Services.Create reports utilizing Microsoft Business Intelligence Development Studio (BIDS) and JasperReports.Write technical documents such as government contract proposal responses and software design documents.

Herndon, Virginia, Us

Perform daily database checks, backups, restores, and other administrative functionsCreated tables, triggers, jobs, views, and indexes on MS SQL Server 2000 and 2005Developed complex T-SQL stored procedures and functionsTune stored procedure and view results; use Profiler to find queries in need of tuningImplemented snapshot and transactional table replicationDeveloped and maintained SQL Server Integration Services (SSIS) PackagesCreated Crystal Reports and SQL Server Reporting Services (SSRS) Reports Created automated SSRS solution to dynamically create reports and distribute to file system.Developed web applications in ASP.Net/VB.NET using themes and skins to maintain the consistent look and feel throughout the applicationInvolved in the full system development life cycleImplemented XML solutions for importing and exporting database information, including the use of XML Style Sheets (XSLT or XSL).

Newport News, Virginia, Us

• Query and develop PL/SQL code on an Oracle 10g Database • Developed Access database/VB program, which formats and imports data files from an external unibasic database or queries PeopleSoft. Exports include XML documents, inserts and updates to external databases and reports. • Migrated Access database to Visual Basic 2005 application • Developed Visual Basic 2005 User Auditing program that imports users, verifies their existence in Active Directory, and outputs results • Troubleshoot and maintain HighJump Warehouse Management Software, including Oracle database queries and DMLs, executing packages, and troubleshooting RF scanning devices • Worked Closely with HighJump developers to resolve issues, including recreating and logging errors, and searching PL/SQL code for errors • Worked with Problem Manager in the administration of software problem resolutions • Designed and Implemented training program for new associates

Us

· Developed Access database program for tracking deployment of security personnel. · Provided help desk assistance to approx 300 employees · Maintained and configured laptops and desktops · Performed troubleshooting on Microsoft Network · Installed CAT-5 cabling and jacks for hurricane relief trailers · Formulated spreadsheets for tracking information

Omaha, Ne, Us

· Installed, maintained, troubleshot, and configured desktop PCs within a Windows 2000 environment · Performed tape backups · Manufactured Cat-5 cabling · Assisted call-in and on-site users with technical and user-related issues

· Developed MS Access Program that allocated expenses for 13 resorts as part of their P&L Statements; imported data from the server farm; · Developed mileage calculator for the resorts using Visual Basic 6.0 and Crystal Reports.

· Administered two MS SQL Database Servers · Developed with Visual Basic and deployed SQL Server database software that allowed the tracking of rental cars and tickets · Developed SQL Server and MS Access database and Visual Basic business systems utilities · Produced reports using Crystal Reports · Installed, maintained, troubleshot, and configured desktop PCs within a Novell/NT network environment

Aa, Fine Arts/Studio Arts

Associate Of Science (A.S.), Electronic Systems Technology

General Diploma