Jennifer Aquino, Developer in West Ryde, New South Wales, Australia
Jennifer is available for hire
Hire Jennifer

Jennifer Aquino

Verified Expert  in Engineering

Query Optimization Developer

Location
West Ryde, New South Wales, Australia
Toptal Member Since
June 18, 2020

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. Before that, she created internal web applications for local banks via TeraSystem. Jennifer can grasp new technologies quickly, train peers, and work comfortably in teams of all sizes.

SQLSQL Server Integration Services (SSIS)SQL Server 2012SQL Server Management Studio (SSMS)Microsoft SQL ServerT-SQL (Transact-SQL)SQL Server 2014ToadData Warehouse DesignData WarehousingUnixOracle 10gAutomationOracle 11gPL/SQL

Availability

Part-time

Preferred Environment

SQL Server Management Studio (SSMS), Visual Studio, Windows, SQL Server Integration Services (SSIS), PL/SQL, Automic (UC4)

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.

Work Experience

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 to process, monitor, and analyze 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-frequency.
  • Trained applications support members for high-level monitoring, debugging, and identifying process blockers.
  • Trained in using UC4 and SAP BusinessObjects tools and provided internal development training to colleagues in Hong Kong, Singapore, and Bangalore.
Technologies: Automic (UC4), Web Intelligence, SAP, Yolus, Shell Scripting, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), Microsoft SQL Server, Oracle PL/SQL

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 that are mapped with database objects using iBATIS.
  • Provided training to colleagues in Spring Web programming and JavaScript and CSS debugging.
Technologies: Jakarta Server Pages (JSP), CSS, XHTML, HTML, JavaScript, JSTL, Jakarta EE, Java

Janus

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

GOLD Realtime (GOLD RT)

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)

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)

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)

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)

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

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 (Transact-SQL), SQL, CSS, HTML, XHTML, JavaScript, Java

Tools

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

Storage

SQL Server Integration Services (SSIS), SQL Server 2014, SQL Server 2012, SQL Server Management Studio (SSMS), 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 Warehouse Design, Data Warehousing, Performance Optimization, Unix Shell Scripting, Shell Scripting, SAP, Web Intelligence, Spring DAO, Office 365

Paradigms

Automation, ETL Implementation & Design

Platforms

Unix, Windows, Jakarta EE

Frameworks

Jakarta Server Pages (JSP), Spring Web Flow, Spring MVC, JavaScriptCore

Libraries/APIs

JSTL

2004 - 2008

Bachelor's Degree in Information Technology

University of Santo Tomas - Manila, Philippines

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring