Edwin Ramirez Email & Phone Number

San Bernardino County, California, United States

Monitoring and responding to system alertsTroubleshooting and resolving system issuesPerforming system maintenance and upgradesProviding technical support to usersCreating and maintaining system documentationDeveloping and implementing system automation processesCreated a windows file watching service for incoming filesDeveloped data parsing scriptDeveloped windows desktop application toparse data from excel and auto populate pdfCreate Esri maps and Online dashboardWork with development teams and product managers to ideate software solutionsDesign client-side and server-side architectureBuild the front-end of applications through appealing visual design and API to populate data from on prem SQL serverBuild automated process using UI Path that grabs files from ftp server, extracts important values from XML and uploads data to Azure data lakeBuild a script that connects to Outlook and searches for XML values and extracts those values to a text fileCreate SQL queries and stored procedure that interact with other internal applicationsBuilding front end WordPress site, managing WordPress plugins, and providing support

Developing new and modifying past SQL scripts that perform CRUDoperations to manipulate data requested by data analystsRunning SQL scripts to automate day to day requestsCross verifying that the data received is correct to maintain dataqualityLeading production support team to assure that daily scripts arecompleted by end of dayGenerating daily reports containing the number of scripts completeddaily using MS Excel to ensure changes are made as soon as possible.Documenting error codes generated by MS SQL server and providedsolutions to corresponding errorsTechnologies (MS SQL Server,SQL)

Phoenix, Arizona, United States

Created a full stack website using Oracle, Springboot, and AngularCreate orders based on available book options and store order in databaseSearch orders based on method of orderingCreated program that would parse XML document using JDOM parserLook for specific elements and store themTook stored elements and created a csv out of stored elementsTurned into an executable JAR file

Phoenix, Arizona, United States

Provided regular updates to codebase using JavaWrote SQL queries to extract data and use retrieved data to test on swaggerCreated Splunk tables to identify points where project would failCreated synthetic monitors using Dynatrace to monitor project performanceDocumented code behavior and project details using Confluence

Phoenix, Arizona, United States

Completed training period in various topics such as SQL, Python, Java Spring, and AngularWorked on e-commerce site in group. Built "add item" functionality using Angular, Oracle, Rest API, and Java spring