Develop and maintain new/existing stored procedures, functions and triggers using T-SQL

Monitor, troubleshoot, and resolve ETL, and data interface issues in Dell Boomi, SSIS, and SAP BI

Support and deliver specific SAP Business Intelligence (BI) services

Participate in determining testing approaches and test planning and assists in creating test procedures

Work closely with OIT staff and vendors to provide seamless support of data systems on behalf of end-users

Participate in code reviews and adheres to development standards and best practices

Maintain a positive, service-oriented approach with all faculty, staff, and students

Act as a technical resource for projects that involve data interfaces

Developed ETL process using Dell Boomi, SAP BI, and MS SSIS

Developed applications services using Java, Groovy, ABAP, and JavaScript to build connectors and data transformations for complex ETL processes

Developed cloud-based and on-premises real-time dashboards and reports using Power BI and SQL Server Reporting Services (SSRS)

Designed, developed, and maintained complex database solutions for data delivery among various university systems using Microsoft SQL Server toolset SSMS, SSIS, and SSRS

Collaborating faculties with research to tests data validity, data relations, and statistical modeling to verify research significance

Working with R Studio, STATA SE to run regression model, data analysis and manipulation

Reviewing and summarizing research papers on concurrent market economics, real estate, and businesses

Evaluating undergraduate class assignments

Preparing lecture notes and presentations

Monitored mechanical units in buildings around campus

Worked as a team with other students on changing filters and reporting

Kept track of filter changing logs

Analyzed and gathered user requirements

Designed and implemented software graphical user interfaces

Developed and implemented database solutions using Microsoft SQL server and MySQL

Implemented Visual Basic and SQL to develop applications for Mig33 chatroom administrator and users

Developed and implemented remote access enabled application controlled by Mig33 chatroom administrator’s private chat

Worked throughout the full software development lifecycle (SDLC)