Power Automate, Reports, Automation, SQL Server

Overview

Looking for gig work

at $10.00/hour

Post-graduate degree (Masters, Doctorate, etc.)

Last Active

April 22nd, 2024 (336 days ago)

Member Since

April 6th, 2015

Profile Description

Skilled in:
- Robotics Process Automation - Microsoft Power Platform - Power Automate
- Spreadsheets - Smartsheet, Google Sheets, Excel
- Microsoft SQL Server - Microsoft Certified Professional (Querying with T-SQL)
-Create Transact-SQL SELECT queries
-Query multiple tables by using joins
-Implement functions and aggregate data
-Modify data
-Query data by using subqueries and APPLY
-Query data by using table expressions
-Group and pivot data by using queries
-Query temporal data and non-relational data
-Create database programmability objects by using Transact-SQL
-Implement error handling and transactions
-Implement data types and NULLs
• Microsoft Technology Associate - Certified (Database Fundamentals)
Jira System Administrator
Developed technical solutions by coordination with internal project teams and understanding of requirements.
Responded to all incoming questions and inquiries related to JIRA applications.
Prepared projects, dashboards, reports and questions for all JIRA related services.
Generated scripts for effective integration of JIRA applications with other tools.
Suggested improvement processes for screens, workflow procedures and reports of applications.
Conducted analysis and evaluation of existing systems to upgrade latest versions of JIRA.
Assisted in assessment of existing production systems and configuration services for upgrading.
Provided technical expertise for analysis and assessment of current security and database configuration services.
• Microsoft Visual Studio – SSIS, SSRS, ETL
• Microsoft Excel – Macros, Visual Basic for Applications (VBA), PowerPivot
• BI Tools (Dashboards) – Qlikview, TIBCO Spotfire, Power BI
• Programming Languages: Python, Java, Visual Basic, R, C++
• System Administration: Atlassian JIRA, Dropbox, SAP, ServiceNow, OneDrive
• SharePoint - Microsoft SharePoint Designer, Microsoft Infopath
• RPA - Robotics Process Automation - UIPath
• College Instructor - Subjects: Java Programming, IT Audit, Microeconomics, Data Warehousing, Autocad, Computer Application for Industrial Engineers, R Programming
• Master of Science in Information and Communications Technology
• English Language Coach - IELTS (International English Language Testing System) and PTE (Pearson Test of English)