Scroll To View More
Jennifer Aquino, SQL Developer in West Ryde, New South Wales, Australia
Jennifer Aquino

SQL 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

Portfolio

Experience

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

Availability

Part-time

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.

Employment

  • 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

Experience

  • 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

Skills

  • Languages

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

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

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

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

    ETL Implementation & Design, Automation
  • Platforms

    Windows 8, Windows 10, Unix
  • Frameworks

    Spring Web Flow, Spring MVC, JavaScript Core
  • Libraries/APIs

    JSTL

Education

  • Bachelor's degree in Information Technology
    2004 - 2008
    University of Santo Tomas - Manila, Philippines
I really like this profile
Share it with others