Catalin Ilie S.

Consultant

510 dollar
Freelancer
19 ans
Timisoara, ROUMANIE

Mon expérience

Voir plus

ContinentalJune 2017 - Présent

- Translates business requirements into SAP BW technical requirements and data models
- Interact with business to gather requirements, prioritize work, develop enhancements to the existing system
- Daily data load monitoring of the BW jobs. Ensured daily data load from R/3 to BW is successful.
- Build and Enhance BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (ADSOs, Composite Providers), Process Chains.
- Customized and managed the modeling of BW
- Generate charts and reports using R programming, based on data from SAP BW or R/3 (get data using MDX queries and SQL queries on SAP RFC connection from SAP BW)  
- Data provisioning in Redshift for reports in Power BI (create ETL for transfer data from multiple file to Redshift database using Python for cleaning, validation and preparation)  
- Design and implementation of workflows with KNIME
Voir plus

DRÄXLMAIER Group RomaniaJune 2016 - June 2017


    - Databases used: Oracle, SAP Hana, TM1
    - Develop database structures, views, triggers, functions, packages and procedures.
    - Creating various SAP Hana Information Models like Attribute, Analytic and Calculated Views.
    - Creation and maintenance of Info Objects, DSO, Cubes, Transformations, DTPs, Data Sources.
    - Mainly development tasks within SAP BW (ETL), data provisioning out of source systems
    - Database focused fields of activities, especially SAP HANA. Reflection of traditional SAP BW data flows in relating to new HANA data flows.
    - Support and Monitoring activities within TM1/Cubeware and SAP BW/BI
    - Implement  and improve ETL strategy, “best practices” and standards as they relate to ETL in the environment
    - Production support for ETL processes and Data Warehouse

- Design, develop and maintain complex database structure, triggers, functions, packages and procedures for QSYS application
- Produce and maintain program code and documentation
- Optimize existing PL/SQL database applications
- ETL using Oracle PL/SQL
- Customizing QSYS in various programming languages
- Develop, modi­fy and maintain applications that may be customized or standardized
- Creating custom reports
- Develop database applications using Oracle collections, bulking techniques, partition to increase performance
- Analyze application problems, recommend and develop solutions
- Create naming conventions and coding standards
- Test all functionality of applications based on test plan
- Assist in the setup and upgrades of production environment
- Assist in the implementation of applications into production
- Collaborate and interact with globally distributed teams
- Web-Portal Technologies
- Oracle Database (11g, 12c)
Voir plus

Waterford InstituteJanuary 2015 - April 2015

- Design and develop graphs, charts, dashboards and other BI solutions
- Developing Jasper Reports using JasperSoft Studio and ETL jobs using Talend
- ETL includes bulk loading of the data from transnational tables to master tables of ODS.
- It also includes the Change Data Capture (CDC) of the transactional data to reporting tables of ODS.
- TALEND Integration Suite (TIS) for developing the ETL jobs.
- Perform data analysis and other general business intelligence tasks
- Work with Product Management team to determine reporting and analysis requirements
- Support existing and develop new business intelligence standards that improve data quality and development efficiency
- Use Business Intelligent tools to develop Extract, Transform and Load Jobs
- Build and Maintain Reports, Dashboards and Data Discovery Domain Models (tools used Oracle, Jasper, MSSQL etc.)
- Writing SQL queries and building DDL scripts for database changes
- Creating reports using Jasper and Oracle
Voir plus

iSoftBetSeptember 2012 - December 2014

As a part of the DBA team, primary duties and responsibilities include:
- Generating custom reports from the databases
- Implementing security. Evaluate access permissions and privileges.
- Creating/Managing users, grant privileges
- Export/import databases
- Creating, Updating, Altering, Tables, Views, Functions, Stored Procedures
- MySQL updates, upgrades, patching, scripting
- Maintaining and administrating MySQL databases
- Managed and resolved design issues during development stage. Worked closely with developers.
- Creating low level database designs and solutions
- ETL for datawarehouse
Some of my main activities also include:
- Install new database software’s and upgrade them to the latest versions.
- MySQL deployment, maintenance and troubleshoot
- Database monitoring
- Database migrations
- Backup and restore
- Performance tuning
- Training new DBA in our environment
Voir plus

S.A.R. CITY INSURANCE S.A.September 2010 - September 2013

Developed e-marketing strategy for City Insurance online insurance sales website.
Developed the eCommerce website, this involves:
- Create design using Photoshop, Firework and implement the design using PHP, HTML, CSS, jQuery
- Create new websites using CMS
- Create new HTML5 and JQuerry pages

Implemented e-marketing levers.
Defined KPIs and optimizing various channels.
• Competitive analysis and positioning
• Generating targeted traffic, SEO, SEA, SMO, emailing, CRM / PRM
• Performance analysis and development of ROI
Voir plus

CertAsig Asigurare si ReasigurareNovember 2008 - August 2010

Creating company website and intranet platform using Joomla CMS.
Maintaining and administrating company websites.   
Installation and configuration of Suse Linux for disaster recovery server located in Timisoara branch with instructions and under supervision from a team from center.
Testing for Emsys platform for insurance products.
Performing data processing tasks and provides quality outputs for analysis and reports, preparation of tabular reports.

ProMatrix SRLMarch 2001 - October 2008

Mes compétences

Frameworks

jQuery

Technologies

Liquibase, Oracle Applications, Web development

Databases

PostGreSQL, MySQL, Oracle, Database Administration

IT Infrastructure

Windows 7, Windows Server, Linux

Other

Romanian, Databases, English, German

Others

Database Design

Business Intelligence

JasperReports, ETL

Environment of Development

PL/SQL Developer, Oracle SQL Developer

Languages

Perl, JavaScript, SQL, HTML, R Language, CSS, PL/SQL, PHP

Application servers

CMS, Oracle Database Server

Mes études et formations

Master's degree - Tibiscus University Timisoara2009 - 2011

Bachelor's degree - Tibiscus University Timisoara2006 - 2009