Sign in

Java Developer Sql Server

San Diego, CA
March 08, 2018

Contact this candidate


Page *

Adrianne Jean Agsolid

Application Programmer III at UC San Diego


Full stack developer with more than 14 years total experience in conceptualization and implementation of web-based business applications. She has 10 years experience using JEE technologies, and 3 years experience in .Net and MS SQL Server technologies. She has broad experience in translating business needs into technology requirements that support the company’s business objectives, working through all phases of IT projects from needs analysis and requirements definition to implementation. Besides Java, she is also a Microsoft Certified Professional for designing and implementing databases using MS-SQL Server. Specialties: web applications development, database development Experience

Application Programmer at University of California San Diego April 2012 - Present

- Develop and Maintain Java EE applications that use various technologies such as JPA, JSP, Spring, hibernate, XML, JSON,

Version control systems: SVN

Relational database: DB2

web client: CSS, JavaScript, JQuery, Bootstrap

web services: REST, SOAP

Application server: Tomcat

Integration and deployment tool: Bamboo

- Monitor the Splunk Financial dashboard and resolve application issues. Customer Service

- Work with customers to improve / add features to products that have been been assigned to work on.

Database Developer at Total Call International

August 2011 - December 2011 (5 months)

Total call International is a provider of high-quality telecommunication services. Its initial product line are Direct Dial Long Distance, Dial Around Service and Prepaid Phone Cards. The selection of Page 2

services also includes Internet Services, VoIP/Broadband Phone Service, and Mobile International Long Distance. As a Database Developer, the responsibilities included:

• Perform the daily offshore and domestic rate uploads

• Work with the development team to develop, optimize and manage all database objects such as Tables, Indexes, and Stored Procedures

• Design and develop database structures for storing data.

• Generate prepaid card pins

• Design and develop ETL processes using SQL Server Integration Services (SSIS)

• Involve in front-end and back-end development and maintenance of the company's web portal and other internal projects

• Work with other developers and DBA to manage database environments and deployments

• Integrating data from other RDBMS such as MySQL to SQL Server

• Work with the finance department to modify and fix data errors in credit memo and invoices

• Develop solutions to deliver data through APIs

• Schedule SQL jobs and develop SQL scripts

• Create Entity Relationship Diagram for documentation Java Developer at Fujitsu Ten Solutions Philippines, Inc. August 2009 - April 2011 (1 year 9 months)

Fujitsu provides solutions/system integration services focused on information system consulting and integration, and infrastructure services centered on outsourcing services (complete information system operation and management).

Involved in various external projects. As a Java developer, the responsibility includes:

• Evaluate and identify new technologies for migration.

• Software analysis, code analysis and requirements analysis

• Support and maintain the application

• Development and testing of known errors and new features of the application

• Full lifecycle application development

• Software analysis, code analysis, requirements analysis, software review, identification of code metrics, system risk analysis, software reliability analysis

• Front end graphical user interface enhancement

• Software testing and quality assurance

• Support, maintain and document software functionality

• Integrate software with existing systems

• Evaluate and identify new technologies for implementation

• Maintain standards compliance

Page 3

Java Developer at Viewlocity Technologies

July 2007 - July 2009 (2 years 1 month)

Joined the Development Team to work on CTP, which at the time was built using EJB 2 technologies with Websphere, Weblogic, and JBoss Application servers and Java 1.4. After a couple of successful releases, we undertook an effort to refactor the entire application using latest accepted industry standard technologies such as EJB 3.0 with OpenEJB and Tomcat. The responsibilities included:

• Develop new features of CTP in every releases

• Scope out work assignments with Technical Lead

• Liase with Architects and Product Managers in Dallas regarding specifications and scope of work

• Create JUnits for all features implemented

• Fix known bugs raised by the clients

• Create daily status updates using enterprise Wiki system

• Create technical specifications of work done on Wiki

• Propose refactoring to increase quality of application.

• Research frameworks and make pro and con analysis for implementation

• Work with other developers to deliver major new features

• Mentor junior developers, and help them tackle difficult problems Software Engineer at MISNet, Inc.

January 2005 - June 2007 (2 years 6 months)

MISNet is a software development and outsourcing company. It provides proven solutions in Business Intelligence, encompassing Data Warehousing, Reporting, and Analytics as well as Custom Applications Development based on .NET and J2EE framework. As a developer worked on various projects, the responsibilities included:

• Scope out work assignments with the Systems Architect and coordinate with the Project Manager regarding specifications and scope of work

• Developed the object, screen, and program logic extensions of Profit Analyzer

• Responsible in managing the other modules such as Reports, Price Console and Deal Manager

• Performed unit testing and create bug tickets using Mantis if necessary

• Work with other developers to deliver major new features

• Develop various SQL reports having as the core technology. is running on a Windows 2003 Platform, MS SQL Server 2000 reporting services as the business intelligence tool and SQL Server 2000 as the Database Server.

• Manage the database.

• Create the views, functions and stored procedures using MS SQL Server 2000.

• Responsible also for report integration using MS SQL Server 2000 Reporting services. Page 4

• Responsible for migrating scripts and reports in the production server.

• Set up the production Server

Lecturer at Informatics Computer Institute

May 2004 - December 2004 (8 months)

As a lecturer provided the following courses:

• Creative Web Applications (I-net, HTML, DHTML, Javascript, Adobe Photoshop 6.0/7.0, Flash 5.0/ MX, Dreamweaver 4.0/MX)

• CVbD (MS Access, VB 6.0)

• Advanced Excel with Visual Basic Application (VBA)

• C Language

• Visual Basic 6.0

• Corel Draw 10

• World Wide Web Fundamentals

• MS Office Applications


Mapua Institute of Technology

Masters, Computer Science, 2006 - 2012

University of the city of Manila

Bachelors, Computer Science, 2000 - 2004

Page 5

Adrianne Jean Agsolid

Application Programmer III at UC San Diego

Contact Adrianne Jean on LinkedIn

Contact this candidate