Joshua Rao Email & Phone Number

I have a Bachelors of Science in Computer Science and a Minor in BusinessI am currently employed as a Senior Analyst at Dell Technologies. My role is to manage databases containing financial information concerning Dell Technologies. Below you can find projects I have worked on and tasks I do daily at Dell Technologies■ Developed advanced full-stack proficiency, encompassing SQL database development alongside front-end expertise■ Automated secure transfer of files between servers with varied security requirements in compliance with regulatory standards■ Highly skilled in Visual Studio, creating front-end reports accessible through Excel and Power BI■ Maintained daily accuracy of Data Marts housing large amounts of financial data, delivering live information to end users■ Automated 10+ ETL processes to efficiently extract, validate, and present extensive financial datasets in user-friendly formats■ Worked in SQL Server Agent to automate daily ETLs which delivered live accurate financial data overnight■ Designed and implemented architecture diagrams mapping IP/Port connections between applications and servers■ Proficient in Oracle server administration for database management and query optimizationActive Directory (AD) Management Utilizing Powershell Automation and SQL Server Scripts (3 Months)● Leveraged PowerShell to read SQL Server tables and execute Active Directory (AD) commands● Extracted and transformed live data from AD into SQL Server-compatible format through Powershell automation● Executed SQL stored procedures to compare employee data to identify discrepancies and determine necessaryaccess adjustmentsFinance Data Mart Migration from Oracle Backend to SQL Server Backend (6 Months)● Validated data and processes to ensure accuracy during transition between environments for 1000+ employees● Translated Oracle objects such as tables, views, and stored procedures to be SQL server compatible● Maintained development and production servers which allowed full control from product inception to deploymentI am have been previously employed as a Data Analyst working with a focus on SQL Development with Centene Inc. in Austin, TX. Daily tasks include working in SQL Server Management Studio in order to modify T-SQL stored procedures, build complex database relationships, and create SSRS reports to make database information accessible to other associates. Assignments are frequently automated and modified in SSIS and Visual Studio using C# and Visual Basic Tools

• 

  Texas A&M University

  Computer Science