Monica I.

Database Developer

500 dollar
Freelancer
24 years
Bucharest, ROMANIA

My experience

More

IF SOFTApril 2007 - Present

* Create and execute development plans and revise as appropriate to meet changing needs and requirements;
* Manage day-to-day operational aspects of multiple projects while working with a team of developers;
* Apply significant knowledge of industry trends and developments;
* Communicate and enforce coding standards, perform code reviews;
* Mentor junior developers, coach on agile software development techniques;
* Review work of development team.
More

IF SOFT ProjectsMarch 2005 - Present

January 2010 – April 2010 (Scrum Master/Senior Programmer)
Client:TribalGroup UK
Project: EBS4 Business Intelligence Solution (Proof of Concept project) - Allows UK colleges to monitor funding and student/staff data to optimise profits

Responsibilities/tasks:

-Gather/Analyse business requirements and design data warehouse (dimensional modelling - star/snowflake schemas);
-Implement ETL process using SQL Server Integration Services (SSIS)/Tribal Unity tool;
-OLAP Cube development using SQL Server Analysis Services (SSAS);
-Create Dashboard Web UI for delivering OLAP Cube data to key stakeholders;
-Create custom reports using SQL Server Reporting Services (SSRS).

Technical environment:  SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server, Oracle


May 2007 – September 2010 (Scrum Master/Agile Senior Programmer)
Customer:TribalGroup UK
Project: SQL Server Port - Migrates existing Oracle database to SQL Server and ensure dual databases support for existing WPF/Web applications (.Net).

Responsibilities/tasks:

-Coordinate the Romanian team using SCRUM methodology;
-Coach team members on agile software development techniques;
-Report progress and team achievements to Tribal Software Development Manager;
-Plan activities/resources/delivery dates;
-Manage risks/solve impediments;
-Develop code as part of an XP-Team (Pair Programming, TDD using NUnit, Continuous Integration);
-Migrate database objects from Oracle to SQLServer and ensure dual databases support.

Technical environment:  Oracle, SQL Server, SQL Server Migration Assistant (SSMA), NUnit, SQL Server Reporting Services (SSRS), C#, ASP .NET, WPF, Silverlight, JavaScript


May 2005 – January 2009 (Team coordinator and Oracle DBA)
Client: TribalGroup UK
Project: EBS (Student Information System) – Oracle 6i development platform using Oracle 9i as database platform

Responsibilities/tasks:

-Estimating projects duration, milestones, resources;
-Planning, managing, monitoring tasks and assigning them to team members;
-Supervising code review and unit testing;
-Monitoring, backup/recovery and tuning for the Oracle databases.

Technical environment:Oracle 9i/10g; SQL/PLSQL; Oracle Forms & Reports 6i, TOAD;


March 2005 – November 2006 (Senior Programmer/Team Leader)
Client:Metrosystems
Project:Goods Management System (GMS-SCS) and MMS Store

Responsibilities/tasks:

-Development, application maintenance and customization;
-Analysis and implementation of new functionalities;
-Application maintenance and support (incident resolution, root cause analysis);

Technical
environment:
Oracle 9i; SQL/PLSQL; Oracle Forms & Reports 9i; Pro*C, IBM Tivoli Workload Scheduler, Oracle Designer, Peregrine Service Center Application Call

More

IF SOFT ProjectsMarch 2005 - Present

November 2015 – April 2019 (Oracle consultant)
Client:Metrosystems
Project:Metro Main Cashier

Responsibilities/tasks:

-Development, application maintenance and customization;
-Deployment of new countries (India. Japan, Pakistan);
-User training on site for 4 countries (Bulgaria, Moldavia, Serbia, Croatia);
-Improve the performance by identifying high-load SQL statements, gathering performance-related data (SQL Tunning).

Technical environment:Oracle 12g, Oracle 10g Forms and Reports, Oracle Shell scripting, Pro*C/C++, Jenkins.


September 2011 – October 2015 (Scrum Master)
Client:Metrosystems
Project:AI Standard Interfaces/JTEXT

Responsibilities/tasks:

-Ensuring that Scrum methodology is understood and used;
-Acting as a servant leader to the development team, removing any impediments to their progress, facilitating their ceremonies, coaching team members
-Assisting the Product Owner with grooming the product backlog, creating a customer-value prioritization schema;
-Sharing to all stakeholders the real-time progress and dependencies between tasks, combining traditional PM techniques with Agile practices;
-Applying Agile Scrum process framework while adapting and improving it over the years.

Technical environment:Jira (Scrum/Kanban boards), IBM WebSphere Message Broker, Java.


October 2010 – January 2011 (Oracle Consultant)
Customer:Unicredit Leasing Romania
Project: Data migration project

Responsibilities/tasks: Work on extract/migration design, mapping rules, integrity tests and recovery plan.

Technical environment: Oracle 11g



More

KEPLER ProjectsJuly 2000 - March 2005

February 2001 – March 2005 (Team Leader/Senior Programmer)
Client: McDonald’s
Project: International Data Warehouse deployment

Responsibilities/tasks: 

-    Design, development and implementation of the WebIntelligence system (Business Objects) for all European Markets;
-    Development of McDonalds database reporting using Business Objects tools (multiple Business Objects documents, universes, working with corporate data as well as with personal data);
-    Design, implementation, management and support of the data movement process from the source systems (AS400, Oracle, flat files) into the centrally hosted Data Warehouse (Oracle 9i) for more than 15 European markets;
-    Participate in redesigning the IDW Data Movement process using ETL tool (Mercator) and MQSeries to support a rapid decision-making process;
-    Regional Incident monitoring, resolution and escalation to the global team (with a minimum 80% compliance to the SLA) using Peregrine tool for more than 28 countries.

Technical environment: Business Objects, MQSeries, ETL tool – Mercator (WebSphere Transformation Extender), Oracle (star schema data model)


November 2000 – January 2001 (Programmer)
Client: KIABI - House of fashion
Project: Development of a software system for the management of the client's contracts, payments and cheques

Responsibilities/tasks: Involved in the application front-end design and in the implementation of a variety of shell scripts and Oracle packages used to enforce business rules, access control and multilevel security (i.e. restricted printing using Oracle pipes between client and server)

Technical environment: Oracle 8i Database on Sun Solaris 2.7., interfaces in Oracle*Forms, Oracle*Reports, Pro*C, Pro*Cobol, PL/SQL


July 2000 – November 2000 (Web Programmer)
Client: Finance/Stock Exchange Start-up
Project: Development and implementation of stock management website at the client headquarter located in Paris

Technical environment: PHP, HTML, CSS, VBScript, JavaScript and MySQL database


More

Romanian-American UniversityNovember 1998 - November 2000

Faculty of Computer Science for Business Management

Responsibilities/tasks: Guide students on lab assignments, provide feedback to improve programming technique and efficiency

Courses: DBMS Oracle, Systems Analysis and Design Methods (SSADM, MERISE, OMT, UML) and Basic of programming languages courses (Pascal and C).

More

Raiffeisen Capital & Investment, part of Raiffeisen GroupFebruary 2000 - June 2000

Project: Equities Management Software System

Responsibilities: Database structure designing, elaboration of the specifications for the developers, supervising of the testing activity, installation on the client servers.

Technical environment: Client-Server Application with Oracle Server 7.3 and 8 and Oracle Developer 4.5 and 6


More

EXPANDIA FINANCEJuly 1997 - October 1998

Responsibilities/tasks: Coordination of all back-office activities and main responsible of data consistency reported to the official authorities.

Technical environment: DBMS Oracle, Oracle Forms, Oracle Reports

My stack

Analysis methods and tools

Merise, SSADM, Kanban, JIRA, Agile Methodology, OMT, Scrum

Environment of Development

Oracle Developer, Oracle Designer, Oracle 10g Developer Suite, Oracle Developer 2000, Oracle Developer 6.0

Technologies

Oracle Applications

Languages

C#, HTML, JavaScript, PRO*C, Shell Scripting, ASP.NET, PL/SQL, CSS, C/C++, SQL, UML, Java, VBScript, PHP, Oracle PL/SQL, Pascal

Frameworks

.NET, WPF, Oracle Forms, Silverlight

Application servers

Oracle Application Server, WebSphere MQ (MQSeries), Oracle 9i Application Server

IT Infrastructure

Windows Server, Sun Solaris

Software testing

Test Driven Development (TDD), NUnit, Unit testing

Business Intelligence

OLAP, SQL Server Integration Services, SSRS, SQL Server Reporting Services, Business Objects, ETL, Oracle Reports, SSIS

Others

Spanish, Continuous Integration, Peregrine Service Center

Databases

Oracle Forms 6i, Oracle Reports 6i, Oracle Forms 10g, SQL Server, Oracle 8, Oracle 11g, Oracle, Oracle 9i, Microsoft SQL Server, TOAD, Oracle 10g, Oracle 8i, Oracle 10g Reports, MySQL

Middleware

Jenkins

My education and trainings

Certified Scrum Master - Scrum Alliance

MSc – Computer Science for Management - Academy of Economic Studies1997 - 1998

BSc – Department of Computer Science - Academy of Economic Studies1992 - 1997