freiberufler DWH/ETL/BI Tech Lead auf freelance.de

DWH/ETL/BI Tech Lead

zuletzt online vor 1 Tagen
  • 100€/Stunde
  • 65760 Eschborn
  • auf Anfrage
  • hi  |  en
  • 20.10.2024

Kurzvorstellung

Currently, I am working as an DWH/ETL/BI Reporting Project/Tech Lead with around 15+ years of work experience and over 12+ years in ETL (Integration/Data transformation) and Oracle technologies (Oracle database and OBIEE).

Qualifikationen

  • 4 J.
  • Business Intelligence (BI)6 J.
  • Data Warehousing6 J.
  • Informatica6 J.
  • Microsoft SQL-Server (MS SQL)3 J.
  • Oracle Business Intelligence Enterprise Edition2 J.
  • Oracle Database3 J.
  • RSLogix (Rockwell Automation)1 J.
  • Systemmigration4 J.
  • UC43 J.

Projekt‐ & Berufserfahrung

Data Consultant
Kundenname anonymisiert, Franfkurt
7/2022 – 10/2024 (2 Jahre, 4 Monate)
Banken
Tätigkeitszeitraum

7/2022 – 10/2024

Tätigkeitsbeschreibung

Collaborated with Subject Matter Experts (SMEs) and project teams to gather comprehensive Data Migration and Data Mapping requirements for multiple compliance use cases.
Worked closely with the Global Risk, Intelligence and Threat Analytics (GRITA) team to analyze and validate Anti-Money Laundering (AML) models, ensuring appropriate scenarios were covered with effective test data.
Collaborated with internal architects in the development of current and target state data architectures, ensuring alignment with corporate standards.
Created scripts for extensive data validation, ensuring the team met business expectations through clear coding, requirement explanations, and rigorous testing to deploy bug-free code into production.
Managed the end-to-end software development life cycle (SDLC), from gathering business requirements to project deployment.
Responsible for the design, development, implementation, documentation, and assistance while creating test cases, defect resolution, testing, packaging delivering code drops and patches to clients for Actimize' SAM.
Worked with internal architects in the development of current and target state data architectures Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

Eingesetzte Qualifikationen

Informatik

Business and Data Analysis Lead
Kundenname anonymisiert, Frankfurt
2/2019 – 6/2022 (3 Jahre, 5 Monate)
Banken
Tätigkeitszeitraum

2/2019 – 6/2022

Tätigkeitsbeschreibung

- Responsible for working closely with various stakeholders groups to build business requirements and functional design documents.
- Supporting and writing the SIT and UAT (along with QA) test scripts and coordinating the end-to-end system testing, mapping the business processes, designing the databases, building training and knowledge management documentation.
- Conducted business requirements elicitation, created detailed functional requirements, worked on the RFP questions and selection.
- Managed the daily scrum meetings, defined the user scripts, and managed the product backlog using the agile methodology.
- Worked with the in-house ETL tool to implement and test all the Business requirements.
- Facilitated the communication between various functional teams and the vendor to determine the application problems, remediation approaches, and the implementation path.

Eingesetzte Qualifikationen

Microsoft SQL-Server (MS SQL), Oracle Database, UC4

IT Consultant
Kundenname anonymisiert, 65760
1/2013 – 1/2017 (4 Jahre, 1 Monat)
Banken
Tätigkeitszeitraum

1/2013 – 1/2017

Tätigkeitsbeschreibung

Project Lead, Deutsche Bank, Frankfurt, Germany:

- Presently working as an BI and ETL Project/Tech Lead with around 10+ years of total work experience and over 8+ years in BI and ETL (Integration/Data transformation) and Oracle technologies.
- Main area of experience has been Requirement Gathering, Analysis, Design, Development, Debugging, Deployments and Testing Support for Datawarehouse, Integration and Migration projects.

Eingesetzte Qualifikationen

, Business Intelligence (BI), Data Warehousing, Informatica, Systemmigration

IT Consultant
Several Bank across Asia, 110075
2/2008 – 10/2010 (2 Jahre, 9 Monate)
Banken
Tätigkeitszeitraum

2/2008 – 10/2010

Tätigkeitsbeschreibung

RMPS MIS System - Module lead:

-Participated in development of new POCs for different clients with their subset of live data.
- Responsible for all activities related to the development, implementation, administration and support of different ETL processes for large scale data warehouses using Informatica Power Center.
- Had experience to automise the LDAP directory to add/delete/update users with high frequency (specially to access some reports/portals)
- involved in data modeling using Sybase Power Designer, Star Schema modeling and snowflake modeling, Fact and Dimensions tables, physical and logical modeling.
- Involved in UNIX Shell scripting

Eingesetzte Qualifikationen

Business Intelligence (BI), Data Warehousing, Informatica, Oracle Business Intelligence Enterprise Edition

Engineer
Rockwell Automation, 110075
8/2006 – 1/2008 (1 Jahr, 6 Monate)
Metall-, Holz- und Papierindustrie
Tätigkeitszeitraum

8/2006 – 1/2008

Tätigkeitsbeschreibung

Involved in System Specification development, Software Engineering & Development of Logic and System Test Coordination.

Eingesetzte Qualifikationen

Rockwell Automation (allg.), RSLogix (Rockwell Automation)

Ausbildung

B. Tech
Electronics and Communication
2006
I.E.T. Lucknow, India (UPTU university)

Über mich

I am working as an DWH/ETL/BI Reporting Project/Tech Lead with around 10+ years of work experience and over 8+ years in ETL (Integration/Data transformation) and Oracle technologies (Oracle database and OBIEE). I was involved in several data warehouse, data integration, data reconciliation, data migration projects. I have experienced on end to end development for a data warehouse (including reporting part).

Thank you for your consideration.

Weitere Kenntnisse

DWH/ETL/BI Reporting Project/Tech Lead

Persönliche Daten

Sprache
  • Hindi (Muttersprache)
  • Englisch (Fließend)
Reisebereitschaft
auf Anfrage
Home-Office
bevorzugt
Profilaufrufe
2105
Alter
42
Berufserfahrung
18 Jahre und 3 Monate (seit 08/2006)
Projektleitung
2 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden