Octaviano Ledesma

Redesigned data model/database schema for storefront (website, mobile app) applications to reflect product hierarchy relationships and merchandising relationships and implemented successive sections/components.  Perform continuing investigation, troubleshooting and remediation of data integrity issues throughout the site applications. Developed data conversion and migration programs for PIM system installation. Data migration to new ecommerce platform. Designed and developed history tracking of application (product and merchandising) tables to facilitate investigation, analysis and ETL to the data warehouse.

Designed and developed ETL jobs, designed warehouse tables (fact and dimension), and developed reports for tracking and analytics for a Video on Demand ad serving application.  Developed quantitative algorithms for supply (available impressions) calculation and forecasting.

• Design of analytical frameworks for investment performance analysis.
• Determining appropriate specifications for calculating period profit from accounting results.
• Supervising development of applications for tracking investment results and risk adjusted profitability. Ensuring compliance of application modules to functional specifications.  Development/coding of quantitative/analytic components, including robust internal rate of return calculations (that converge when defined).
• Design and architecture of data warehouse of investment performance results for analytic and reporting purposes, developed in Microsoft SQL Server /Transact-SQL.
• Supervising development and ensuring compliance with analytical functional specifications. Development/coding of APIs for Data Marts.
• Troubleshooting reported financial results from financial accounting systems, determining accuracy, planning and implementing corrective action.
• Test and evaluation of RDBMS alternatives, including Oracle 11g, and MySQL 5.4

Designed data model to meet site application and business intelligence requirements.   Tuned application SQL. Investigated and tested alternative data management and propagation technologies, including RAC, object oriented databases, JDO compliant object-relational mapping tools.  Developed PL/SQL packages and Java Stored Procedures to manage application data.  Developed scripts using SQL*Loader to populate the application database.  Redesigned data warehouse to handle increased volume and functional requirements.  Managed database changes through release cycle.  Administered development and QA databases.

Tech Stacks: Oracle 9i/9.2/10g RDBMS on Solaris, JDBC, PL/SQL,  SQL*Loader, Quest Central, Indepth for Oracle (Symantec/Veritas), Embarcadero ER/Studio, Toplink, Kodo, Weblogic

Developed and implemented a database design to meet analytical information requirements. Administered  development and production databases.  Implemented replication of databases to  staging and to foreign sites.  Developed PL/SQL packages to manage client and provider data.  Developed scripts using SQL*Loader to import client data.  Supported developers with database code, security and JDBC access.

Tech Stacks: Oracle 8i/9i RDBMS on Solaris, JDBC, PL/SQL, SQL*Loader, Resin

Developed the data model and database architecture and design for a commercial website application.  Administered development and production databases.  Implemented  java data access classes to interface Java server application with Oracle database,.  Analyzed  market making optimization modules and developed application code to interface with these modules,.  Developed PL/SQL procedures to manage data.  Developed data warehouse for sales and marketing information

Tech Stacks: Oracle 8i RDBMS on Solaris, Erwin 3.5.2, PL/SQL, Veritas Volume Manager, BEA WebLogic 5, JDBC, RMAN