Development and optimization of Oracle database procedures for ETL for an application that has OBI as user interface. Development and bug fixes for various reports. Partitioning ill-designed tables in a database warehouse, purging old data and compression of data for saving space. Development of reports using Oracle Reports or a reporting framework in Excel that I designed. Development of user-interfaces using Oracle Forms. Provided support from level 1 to level 3, including supervision of end of day and end of month processing.
Design and development of Oracle database applications. Development of procedures for maintenance of the auto parts catalogue. That included import of parts data from text files and transformation to present the data into structures for a web application used by the clients (meaning auto repair shops) for finding the needed parts. Procedures for "cloning" auto parts obtaining from "original" parts equivalent parts produced by another manufacturer. Procedures for exporting data into text files for import into another application. Design and development of a database warehouse used by a web application for presenting various sales reports. That is I developed an ETL process that ran overnight and procedures returning reports data.
Development of PL/SQL stored procedure for centralizing data from various systems into a central database called Treasury Data Hub. Oddly enough, most of the data processing is done in Java, while the database is used mostly as "persistency" for what the java apps produce. The TDH is used by different other systems for generating various reports.
Design, development and maintenance for the banking information system implemented at several banks. Have participated at the implementetion of the system at: Eximbank Romania, Finsnsbank Romania (that later became Credit Europe), Eurombank (that became Leumi), Daewoo Bank (that became CR Firenze), Anglo-Romanian Bank, RIB, Carpatica and Mindbank (that became ATE Bank). Oracle PL/SQL, Oracle Reports and Forms.
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.