Scroll To View More
Hire the top 3% of freelance developers
Jennifer Aquino

Jennifer Aquino

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
Full-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
    Societe Generale (formerly Newedge Financial Singapore, Pte., Ltd.)
    2010 - 2015
    • 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
    TeraSystem, Inc.
    2008 - 2010
    • 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
    SQL, T-SQL, CSS, JavaScript, Core Java (J2EE), Java
  • Tools
    Toad, PuTTY, Automic (UC4), CVS, Eclipse IDE, Adobe Dreamweaver, TortoiseSVN, DTS, Adobe Photoshop, Notepad++, Microsoft Office 365, Apache Tomcat
  • Storage
    SQL Server 2012, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server Management Studio, SQL Server 2014, FileZilla FTP Server, Oracle 11g, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Oracle 10g, PL/SQL, Oracle PL/SQL, Oracle 9g
  • Other
    SAP Business Intelligence (BI), Query Optimization, Yolus, Data Warehouse, Performance Optimization, Unix Shell Scripting, Spring DAO
  • Paradigms
    Automation, ETL Implementation & Design
  • Platforms
    Unix, Windows 10, Windows 8
  • Frameworks
    JavaScript Core, Spring MVC, Spring Web Flow
  • Libraries/APIs
    JSTL
Education
  • Bachelor's degree in Information Technology
    University of Santo Tomas - Manila, Philippines
    2004 - 2008
Hire the top 3% of freelance developers
I really like this profile
Share it with others