Systems administrator

Joma A. Rodriguez, BSIT

Treasure Island, FL ***** 786-***-**** Email. ********@***.***

Highly accomplished professional with over 8 years of experience in Data Analysis and Reporting Software. Specializing in the development of system tools to optimize business processes and data management using Data Warehousing and Database Normalization. Passionate about quality and customer satisfaction. Ability to learn quickly and adapt to different projects. Experience with processes to increase efficiency, productivity and profitability through automation and process improvement.

Work Experience

Ultra Forensic Technology WAI Inc. Largo, FL

GCS Systems Administrator 12/2016-Present

• Analyzing business requirements and coming up with complex MySQL queries, triggers and stored procedures to meet business needs and automating it when required.

• Creating reports for operation managers to inform of data errors, inconsistencies and outliers on the data in order to identify trends and come up with solutions to handle problems.

• Lead role in numerous projects utilizing C#, Jscript and Microsoft SQL Server to create and maintain the fully- integrated client management system.

• Managed weekly meetings with operation managers to identify new and evolving business needs and suggest different types of business solutions.

• Configure necessary components to ensure database is always accessible and checking on database performance to identify and solve any issues.

• Assist report writers with custom requests for change requirements on ongoing reports using Crystal Reports.

Road America Miami, FL

Junior Database Business Administrator 07/2016-12/2016

• Develop, run, and maintain all company reports using PL/SQL and Microsoft SQL queries, stored procedures, and views.

• Develop and maintain the standardization of company reports and when capable provide automation to the process of running reports.

• Monitor and maintain the Oracle databases to ensure they are running at top performance.

• Identifying issues with the database and resolving them.

• Optimize performance of the database objects.

Merck & Co. Miami Lakes, FL

Systems Analyst 04/2015- 07/2016

• Develop and modify stored procedures, queries, and functions using MySQL through Microsoft SQL Server Management Studio to obtain specific data requested from users and create custom views and tables to organize data.

• Develop VBS and Batch scripts to automatically start daily tasks which include the distribution of daily reports used by the financial department through Microsoft Outlook and execute tasks on the servers to ensure the servers are running properly.

• Develop and maintaining our proprietary validation website using JavaScript and HTML for users to upload documents and track which users modifies each file.

• Modify existing commands on the proprietary MRP software in order to perform custom desired tasks without having to purchase additional packages from the distributor using the SQL database manager and SSRS.

• Import data from different sources such as Excel and Access database files into the Microsoft SQL Server and extracting the desired data from such files using the import wizard and then manipulating the data using SQL queries to insert the records into the desired views and tables and using the data to then create and standardize custom reports for daily use.

• Develop custom report designs using Visual Studio Reporting Services (SSRS) with data obtained from Microsoft SQL Server Management Studio by linking the database and creating a custom view according to the client’s needs and then deploying the report to the Report Manager.

• Develop and maintain a new web application used locally which stores data files consisting of PDFs and Word documents using C#.

• Consolidated 5 servers into an upgraded server which hosted all the files and applications of the old 5 servers and setting the proper permissions on all users to match the previous settings all the servers had in the previous hardware, allowing the company to save space and resources

Accountax Office Services Miami, FL

Accountant Assistant 05/2009- 04/2015

• Perform comprehensive analysis based from income statements and generate balance sheets, general ledgers, income reports, variance analysis etc.

• Managing month-end closing cycles and reporting the amounts to the Florida Department of Revenue using the appropriate forms.

• Create a network environment connecting all the computers to the same network and setting up a centralized database for all employees to backup their data.

• Keeping track of budget and making decisions on new application software to obtain the best possible software available at the cheapest price.

• Meeting with IRS agents to discuss returns and reconcile amounts to obtain the best possible outcome. Education

BA, Information Technology Software, Florida International University, Miami, Florida Spring 2015 MA, Information Technology Software, Florida International University, Miami, Florida Expected 2018 Knowledge, skills & abilities

Programming languages: Java, C#, JavaScript, ANSI C, Visual Basic, PHP, HTML, SQL. Software: Eclipse, NetBeans, Visual Studio, Microsoft SQL Server Management, Code::Blocks, Android Studio. Software testing: Junit, Selenium.

Database languages: MySQL, Oracle.

Database management: Database architecture, Database migration, Database schemas. Web Technologies: HTML, XML, CSS.

Web/Application Server: Tomcat, FileZilla.

Knowledge in development methodologies such as Object-oriented programming, data structures, and algorithms. Knowledge in developing UML diagrams. For example, Use cases, Class diagrams and Sequence diagrams using Papyrus. Knowledge in Architectural patterns including MVC, n-tier, Data transfer object etc. Fluency in English and Spanish (reading, writing, speaking).

Contact this candidate