Jennifer Aquino, Query Optimization Developer in West Ryde, New South Wales, Australia
Jennifer Aquino

Query Optimization Developer in West Ryde, New South Wales, Australia

Member since October 27, 2016
Jennifer has five years of professional experience as a data analyst delivering reporting solutions to global teams and maintaining systems delivery and compliance in a trading and brokerage company now merged with Societe Generale. Prior to that, she created internal web applications for local banks via TeraSystem. She can grasp new technologies quickly, train peers, and work comfortably in teams of all sizes.
Jennifer is now available for hire



  • Query Optimization, 7 years
  • SQL, 7 years
  • SQL Server Management Studio, 5 years
  • Microsoft SQL Server, 5 years
  • T-SQL, 5 years
  • SAP Business Intelligence (BI), 5 years
  • Spring MVC, 2 years
  • JSTL, 2 years


West Ryde, New South Wales, Australia



Preferred Environment

Windows, Unix, Visual Studio, SSMS

The most amazing...

...thing I've streamlined was a data warehouse's real-time feed from cleared market executions to automatic or complex booking for display on dashboards.


  • Data Group Analyst

    2010 - 2015
    Societe Generale (formerly Newedge Financial Singapore, Pte., Ltd.)
    • Gathered requirements, formed specifications for development, and provided quality assurance testing, optimization, and automation in Windows and Unix systems with SQL Server and Oracle databases.
    • Decommissioned Yolus, a third-party solutions provider, by developing a data warehouse that meets more functionality and faster data delivery for internal systems and users for processing, monitoring, and analysis of data delivered.
    • Developed optimized SQL queries involving various data sources some of which are different database structures, XML data, or delimited text files, to meet report delivery and time constraints.
    • Trained applications support members for high-level monitoring, debugging, and identifying process blockers.
    • Trained myself in the usage of UC4 and SAP Business Objects tools and provided internal development training to colleagues in Hong Kong, Singapore, and Bangalore.
    Technologies: Oracle PL/SQL, SQL Server, T-SQL, SSIS, SAP Web intelligence, Shell scripting, UC4, Yolus
  • Analyst Programmer

    2008 - 2010
    TeraSystem, Inc.
    • Developed web pages using CSS and Spring form tags.
    • Created dynamic menu using JSTL and scriptlets with data tree defined by the application role and database.
    • Developed controllers, interface, and Dao layers using Spring MVC framework.
    • Created beans which are mapped with database objects using iBATIS.
    • Provided training to colleagues in Spring Web programming and debugging, JavaScript, and CSS.
    Technologies: Java, J2EE, JSP Scriptlets, JSTL, JavaScript, HTML, xHTML, CSS


  • Janus (Development)

    Provided almost real-time market position and transaction reports for Sponsored Direct Market Access (SDMA) clients.

  • GOLD Realtime (GOLD RT) (Development)

    Enabled display of almost real-time market transactions into Position and Transaction dashboards for internal global users by onboarding ASIA market feed using automatic booking of trades to client accounts.

  • Global On-Line Data warehouse, Newedge Product Referential, Newedge Client Referential (GOLD, NPR, NCR) (Development)

    Initiated onboarding of the first APAC market feed - SGX into these data warehouse structures. These enhanced the availability of end-of-day reports.

    Involved from project initialization, development, and going live to business as usual and support.

    These applications made a decommission of Yolus in Newedge possible and later on a lot more features such as real-time reports, dashboards, and faster ETL.

  • Electronic Modified Disbursement System (eMDS) (Development)

    Tailored web application for banks with an existing disbursement system such as LandBank of the Philippines.

    Formatted documents are digitally transmitted for use of the Department of Budget and Management, the Bureau of Treasury, and the National Government Agencies of the Philippines.

  • Financial Reporting Package System (FRPS) (Development)

    Application providing a financial reporting solution compliant in the Central Bank of the Philippines utilizing an existing network infrastructure for branches and other subsidiaries of LandBank of the Philippines involving Excel file parsing and writing for offline and online mode through web application.

  • Online Approval (OA) (Development)

    Online application providing Bank of the Philippine Islands a report management for loans, properties, and sales, as well as application approval of the bank’s client proposals.

  • SQL Performance Tuning (Other amazing things)

    7 years total (T-SQL & PL/SQL) performance tuning experience for small to large scale databases. Techniques used:
    - Client statistics
    - Execution plans
    - Indexing
    - Live query statistics
    - Optimizer hints
    - Plan pinning
    - SQL costs
    - Table partitions


  • Languages

    T-SQL, SQL, CSS, JavaScript, Core Java (J2EE), Java
  • Tools

    PuTTY, Automic (UC4), Toad, Eclipse IDE, Adobe Dreamweaver, TortoiseSVN, DTS, CVS, Adobe Photoshop, Notepad++, Apache Tomcat
  • Storage

    SQL Server Integration Services (SSIS), SQL Server 2014, SQL Server 2012, SQL Server Management Studio, Microsoft SQL Server, SQL Server 2008 R2, SQL Server 2005, FileZilla FTP Server, Oracle 11g, SQL Server 2008, Oracle 10g, PL/SQL, Oracle PL/SQL, Oracle 9g
  • Other

    Query Optimization, Yolus, SAP Business Intelligence (BI), Data Warehousing, Performance Optimization, Unix Shell Scripting, Spring DAO, Office 365
  • Paradigms

    Automation, ETL Implementation & Design
  • Platforms

    Unix, Windows
  • Frameworks

    Spring Web Flow, Spring MVC, JavaScriptCore
  • Libraries/APIs



  • Bachelor's degree in Information Technology
    2004 - 2008
    University of Santo Tomas - Manila, Philippines

To view more profiles

Join Toptal
I really like this profile
Share it with others