I consult with study teams via email and on teams to find out their business needs and requirements in order to fulfill their data request utilizing Aqua Data Studio (Oracle/SQL) and Microsoft Excel. I import and export data from 1 location to another location using CSV files to house datasets between the locations. I help maintain an Agile Board by preparing documents and assigning them to their right departments in JIRA Ticketing System. I create projects (Long Forms) and maintain the project instruments in Redcap. I am an administrator for Redcap where I make changes to online surveys base on the study teams request. I create projects in NView Health, and map out the variables associated within the projects.

TEMP AssignmentTools: Excel, Access Database, SQL Queries, Infrastructure As A Service Designer, IBM Control Desk (ICD), AMED, NESSUS, SolarWinds, Tripwire, BigFixI wrote ADHOC queries in Access Database using specific criteria’s given by the clients in order to builds ADHOC and Statistical Forecast Monthly Reports and Weekly Reports (including adding charts, and Pivot tables) in Excel. I was in charge of maintaining the Authorized System of Records. I would utilize AMED to reconcile discrepancies by a LAAS designer platform called ICOS, Device Matrix, and IBM Control Desk (ICD) to locate what was causing the discrepancy, then I would place a ticket to the department which was responsible for fixing the discrepancy.

TEMP AssignmentTools: Access Database, Excel, POWER BI Desktop, Vba, SQL Queries, App Sheet, IBM IseriesIntegrated AS 400 records into excel then Excel into access database. Due to there wasn’t any data connection to link access Access Database to Iseries, I integrated IBM AS 400 Iseries to Access database so that access data could be updated by using excel to link the 2 two databases. In order to update the data, all I had to do is refresh in excel then, open a new instance of access database which contained the Iseries table, or refresh the table, and the data will be updated. I changed the properties in Excel to refresh every 3 hrs, so that the data is consistent with AS 400.I created an Excel userform client incident search engine and macros, using Excel Vba code to search all the records in an Access database to locate the same order number and output the row(s) with the same order number into an Excel spreadsheet. The userform was created to help the other analyst increase their work performances, so instead of them having to gather data from multiple sources, they could gather it from 2 sources the client incident userform, and the other in-house system.I created mobile apps using a tool called App sheet application which keeps up with the warehouse inventory, employees’ clock in and out, employee’s complaints and issues, and other request.I troubleshot whatever issue that was brought to my attentions from downloading the new apps to tablets to pairing the tablets with handheld scanners which was used by the warehouse employees.

* Analyzed data, troubleshot, and provided solutions to issues relating to technology hardware and software* Communicated effectively, both orally and in writing to fellow employees and clients* Established and maintained good working relationships with agency staff and the user community* Assembled, configured, installed, and maintained computer equipment and peripherals* Utilized working knowledge of Windows 7 & 10, Microsoft Office, Internet Explorer and other internet browsers, SharePoint, networks and network printing* Utilized programs: SQL, Alteryx, SharePoint, and Excel (Macros coding- VBA)* Assisted in supporting new applications during implementation- SQL* Participated in individualized training as well as training sessions for other departments to use my skillset* Performed ETL process (SSAS, SSIS, SSRS)* Consulted with business vendors to consolidate their business needs* Generated SQL tables data scripts into Excel worksheets to clean up the data (SSAS)* Performed data consolidation into excel data warehouse, and manipulated the data within excel and Alteryx tools (SSIS)* Used advanced Excel formulas such as VLookup formula, concatenation formula, Pivot tables, & etc.* Imported and exported data to Excel and from SQL from SQL* Created table back ups in the SQL database index* Manipulated data in SQL using an variety of row and aggregate functions to view data in various data subsets.* Used advance queries such as Inner, Full Joins, wrote Adhoc Queries, Pivot and Unpivot queries* Manipulated SharePoint scripts in SSMS to update data in SharePoint and to update column headers within SQL server reporting service (SSRS)* Manipulated SharePoint such as removing and adding personal to and from SharePoint* Used the fundamentals of coding to create Macros within Excel (VBA)* Used Envoy ticketing system to get assignments that was marked high, medium, or low priorit* Used Lotus Notes

I was an Implementation Support Tech at General Information Service (GIS) in Chapin, SC. My job consisted writing queries to maintain the SQL database, queries such as using insert statements, update statements, sub queries, joins, etc.. I created new accounts on a web based background screening platform. I had the experience of mirroring accounts to house the same data. I used a ticketing system called equestPlus to get my assignments that was marked high, medium, or low priority