Mihai (Daniel) Anghel
Senior ETL Developer | Team Lead
Experience
Mar 2022 - Jul 2024
2 years 5 monthsBucharest, Romania
Senior ETL Developer | Team Lead
Unicredit Bank Austria
- Handling and managing Data warehousing system with emphasis on Business Requirements Analysis, Application Design, Development, coding, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
- Developed complex Teradata SQL code in BTEQ script using OLAP and aggregate functions, analitical functions and recursive CTE’s.
- Extensive knowledge with Teradata SQL Assistant and Teradata Viewpoint.
- Building recursive and iterative algorithms using teradata store procedures and python.
- Unix for file handling on server side.
- Host on Demand for scheduling and run processes.
- Datastage - used as wrapper for scripts triggering.
- ALM QC.
- SVN and GIT.
- Basic skills also on cloud computing:
- ADF (Azure Data Factory)
- ADLS
- Python
- Databricks (SparkSQL and PySpark)
- Azure Synapse Analitycs.
Nov 2020 - Dec 2023
3 years 2 monthsBucharest, Romania
Data Warehouse Engineer
Deutsche Bank
- Design, develop, test and support new capabilities and ongoing changes within the various application data marts using Informatica Power Center and Oracle Sql & PL/SQL (packages & procedures).
- Design and develop:
- Workflows
- Worklets
- Mappings
- Mapplets
- Sessions
- Tasks
- Transformations
- Jira, SVN, ALM QC, GitHub, TeamCity/Jenkins.
- Unix, Unix Shell.
- Perform & implement tuning processes.
- Use ControlM for simplifing application and data workflow orchestration on premises or as a service.
- Agile, Scrum methodology.
- Cognos for business reporting.
- Extracting data from Oracle, DB2, csv, flat files, JSON, etc.
- TOAD, Sql Developer.
- Assisted in the design and development of SCD type1 and type2 mappings improving the efficiency of ETL Jobs.
Oct 2019 - Nov 2020
1 year 2 monthsBucharest, Romania
Senior ETL Developer
Raiffeisen Bank
- Works closely with the business and IT application owners to understand, document and design ETL processes and needs.
- Participates in the defining, development and implementation of data warehouse and data mart databases and their content.
- Develops and maintains mapping logic to move data content from varied sources systems to the data warehouse / data marts.
- ETL and data conversion design / implementation for other data integration scenarios.
- Design, Develop, Test, Optimize and Deploy ODI packages and Oracle stored procedures / packages to perform all ETL related functions.
- Plan and coordinate ETL and database roll-outs with project team members, development and database engineers.
- Provide support, maintenance and issue investigation and resolution for ETL processes.
- Design and implement BI technical and operational architecture / frameworks.
- End-user report development, from requirement gathering to design, build, test, deploy.
Apr 2018 - Aug 2018
5 monthsVienna, Austria
Senior ETL Developer
Erste Bank
- Contribute the design and development of an overall data exchange solution, including the review of existing processes to confirm technical feasibility of ODI integration.
- Ensure standards and best practices for all current and new frameworks are followed.
- Create technical documentation and build instructions to onsite and/or offsite global teams.
- Assist with code reviews, deploying, and validating the technical solution when needed.
- Develop and maintain SQL, PL/SQL code as needed for Oracle database, maintain, monitor, and support ETL/ELT integrations using ODI.
- Working with Power Designer.
- Creating Groovy Scripts.
- Data Vault Methodology:
- Hub
- Links
- Satelitte
- Event
- History (SCD, Snapshot, Bitemporal).
Nov 2016 - Apr 2018
1 year 6 monthsBucharest, Romania
Senior DWH/BI Developer
Unicredit Business Integrated Solutions
- Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
- Created BTEQ scripts to extract data from warehouse for downstream applications.
- Develop ETL programs with an enterprise-grade tool (Datastage).
- Contributes substantially to the DataWarehouse ETL development lifecycle, including developing and testing ETL programs.
- Hands-on database development with SQL and stored procedures, such as Teradata procedures or similar ones.
- Developing data transformations involving SQL, data-type conversions, joins, filters, translations, aggregation, de-/normalization and custom database stored procedures.
- Working with Teradata Services, Teradata SQL Developer, Teradata Viewpoint.
- Involvement in database optimization.
- Implemented AGILE methodology for deliveries.
- Generated Ad-Hoc reports for the users.
Aug 2015 - Nov 2016
1 year 4 monthsPL / SQL Developer
- Experience database programming and analysis, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Forms, Oracle Supplied Packages, Collections, Partitioned Tables, Objects, Records, Views, etc.
- Experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects.
- Troubleshoot and provide both system and user support.
- Analyze, design, code, test, and implement complex applications based on elicit specifications.
- PL / SQL language specific exception handling.
- SQL Optimization.
May 2013 - Aug 2015
2 years 4 monthsBucharest, Romania
Senior QA Warehouse/Reporting (Business Inteligence)
Romanian Commercial Bank (member of Erste Group) & Play Solutions
- Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
- Extensively used SQL/PL SQL queries for data validation and backend testing.
- Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
- Develop test plans and scripts, prepare test data, reconcile data sources and execute functional tests.
- Supporting multiple code branches, building and delivering releases.
- Acting as lead of testing activities.
- Managing time and tasks to provide visibility.
- Experience working with IBM Cognos (Reporting).
- Experience working with ETL systems (Oracle Warehouse Builder, Oracle Workflow).
- Experience working with Databases (Oracle Database).
- Experience working with BugTracking systems (QualityCenter & Application Lifecycle Management).
- Multiple tasks test database administration.
- SQL tuning (working with hints).
- RDBMS Concepts.
- ETL Concepts.
- Working with database objects: Packages, Functions, Procedures, Anonymous Blocks, etc.
- Interviewing potential candidates in terms of technical database knowledge.
- Making planning and estimating various projects.
- Knowledge transfer to juniors.
- Perform ETL and data manipulation techniques.
- Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document.
- Support provided in running processes on closing banking day on test environments.
Jul 2012 - May 2013
11 monthsBucharest, Romania
QA Warehouse/Reporting (Business Intelligence)
Vodafone Romania
- Experience with ETL systems (Informatica PowerCenter).
- Datawarehouse systems analysis experience.
- Knowledge of performance measurement methodology.
- Experience working with Business Objects (Reporting).
- Strong knowledge / advanced SQL, PL / SQL and Unix (Experience with Oracle database).
- Solid knowledge of Web Services (Simple Object Access Protocol using Eclipse tools).
- Analyze impact between various patches / releases applied on the same test environments.
- Knowledge with Billing systems.
- Experience with Customer Relationship Management systems.
- Working with BI technical team to support both the operational area and the development of BI (the entire development cycle from requirements definition, ETL and creating / delivering user reports).
- Test ETL datawarehouse components (Evaluating and testing new or modified functionalities from multiple modules to verify that the application functions according to user requirements and conforms to established standards.).
- Create, design and execute test plans.
- Identify, troubleshoot and provide solutions for potential issues.
- Approve requirements and design specifications.
- Test flat file data transfers.
May 2010 - Jul 2012
2 years 3 monthsBucharest, Romania
Testing Programmer
Romanian Commercial Bank (member of Erste Group)
- Develop, improve and extend automated test frameworks and test scripts (creation numerous tasks of scripting / programming (SQL / PL SQL) via QTP Automation).
- Maintaining and managing testing environments.
- Oracle Forms.
- Tracking and managing database sessions.
- Checks regarding the successful deployment of patches / releases.
- Start / Stop the SQL environments engines.
- Maintaining automatic jobs (dbms_jobs.submit).
- Maintaining automatic execution processes (Operational Core Banking) on test environments.
- Analysis on tables, schemas and indexessss.
- Develop scripts for bringing data from production to test environment (database links).
- Populating database with test data or real data after environment rewriting.
Oct 2009 - May 2010
8 monthsFreelancer
5 – 10 Independent Projects
- Design and / or develop custom web applications or websites.
- MySql Databases.
- Oracle Databases.
- PHP (Framework - Symfony).
- HTML, CSS, XML.
- Visual Studio.
- ASP.NET.
- CSharp.
- JavaScript.
May 2008 - Oct 2009
1 year 6 monthsBucharest, Romania
Accounting Developer
S.C. Pagini Aurii S.A. (Golden Pages)
- Creating C# application to improve following requirements: Oracle Data Transfer - Wizcount.
- Export revenues to Oracle and treat computing error.
- Import customer contracts and related rates from Oracle into accounting and management program, error correction.
- Transfer promissory notes and checks to Oracle application.
- Analysis and correction of double payments, the penalties, increases or cancellations of invoiced contracts.
- Support for applications based on bank cashing statements of Banc Post, RBS Bank, Credit Europe Bank, Transylvania.
- Issuing reports (Report Viewer) such as:
- Revenues in the period ' - '
- Cashing for major clients in Oracle
- Analysis and invoicing uncollected after the publication of books, issuing invoices discounts.
- Contribution to the construction of the site redesign (CSS, XML, HTML).
Languages
Romanian
NativeEnglish
Advanced Education
Sep 2005 - Jul 2008
Faculty of Cybernetics Statistics and Economic Informatics, Bucharest Academy of Economic Studies
Graduate Degree · Economical Informatics · Bucharest, Romania
Certifications & licenses
Driving licence B
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
