freiberufler Banking and payment domain | online transactions | e-commerce| Data Migration & integration | Informatica ETL Tools | Data warehouse support projects | Business intelligence. auf freelance.de

Banking and payment domain | online transactions | e-commerce| Data Migration & integration | Informatica ETL Tools | Data...

offline
  • 30€/Stunde
  • 60598 frankfurt am main
  • Europa
  • hi  |  en  |  de
  • 14.04.2019

Kurzvorstellung

I have worked as Business intelligence engineer, data warehouse , ETL , database developer , integration and data migration expert for multiple clients like Barclaycards ,Standard bank Entercard As and other payment service providers.

Qualifikationen

  • Business Intelligence and Reporting Tools (BIRT)
  • Datawarehouse / DWH
  • Design (allg.)
  • ETL
  • IT-Support (allg.)
  • migration
  • Oracle Database
  • PL/SQL
  • Produktdesign
  • Projektassistenz (IT)
  • Reporting
  • teamlead

Projekt‐ & Berufserfahrung

Business intelligence and DWH engineer (Festanstellung)
Inatec payment solution GmbH, frankfurt am main
12/2016 – offen (7 Jahre, 4 Monate)
Payment solution provider
Tätigkeitszeitraum

12/2016 – offen

Tätigkeitsbeschreibung

➢ Interact with clients and internal team to gather requirements and translate into technical requirements.
➢ Prepare interface design between new merchant , payment providers and financial database.
➢ Design and develop new dashboard and automate new process for better monitoring and analysis purpose.
➢ Follow standard payment and data exchange format and customize it according to new requirements.
➢ Bug fixing and writing scripts to restore data in case of any issue.

Eingesetzte Qualifikationen

Produktdesign, Business Intelligence and Reporting Tools (BIRT), Reporting, ETL, Oracle Database, Projektassistenz (IT)

Senior cosultant
Capgemini / Entercard AS Norway, oslo
9/2011 – 12/2016 (5 Jahre, 4 Monate)
Banken
Tätigkeitszeitraum

9/2011 – 12/2016

Tätigkeitsbeschreibung

Brief: This is data migration for all Sparebank1 products from EnterCard (processing partner) to sparebank1’s new credit card support system.
Responsibilities →
➢ Participated in design sessions where decisions are made involving the transformation from source to target.
➢ Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl and sql), packages, triggers, UNIX, and SAS.
➢ Managed and compile documentation for all ETL processes.
➢ Created detailed process flow designs ,drafts and high-level Standard Operation Procedures.
➢ Implemented various Transformations: Joiner, sorter, Aggregate, Expression, Lookup, Filter, Update Strategy and Router.
➢ Performed tuning for PL and SQL procedures, Views, and Informatica objects.
➢ Designed and implements the error handling strategy for ETL team.
➢ Monitored data warehouse month-end/daily loads to ensure successful completion.
Other daily responsibilities.
➢ Member of the data warehouse architecture team that and responsible to create the Business Intelligence reference architecture.
➢ Created standards and design patterns on data movement, data access, data integration, and other areas in the data warehouse.
➢ Connect with different business units and gather requirements
➢ Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
➢ Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
➢ Data cleansing, data quality tracking and process balancing checkpoints.
➢ Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.

Eingesetzte Qualifikationen

Business Intelligence and Reporting Tools (BIRT), Oracle Database, Migration, Kooperationen, Technischer Support

Senior software engineer
AWC software pvt ltd, Delhi
10/2010 – 9/2011 (1 Jahr)
Telekommunikation
Tätigkeitszeitraum

10/2010 – 9/2011

Tätigkeitsbeschreibung

Brief: Sapient is a marketing and consulting company that provides business, marketing, and technology services to clients. It acquired a company Nitro(UK) and the data-warehouse had to be
enhanced in order to merge data from Nitro to existing system. I was part of development and support team
Responsbilities →
➢ Pl /sql code development for datawarehouse project/module for Client Sapient.
➢ Design development for integration of new applications with existing applications.
➢ Customization in OBIEE reports as per business requirement.
➢ Prepare test cases and complete unit testing steps and then process for UAT.
➢ Take care of data warehouse related work for project development including data feed to database from different application.
➢ Report development to monitor data feed process and performance of different servers.
➢ Application setup for different applications on different database.

Eingesetzte Qualifikationen

Data Mining, Datawarehouse / DWH, Oracle Business Intelligence (BI), Oracle Business Intelligence Enterprise Edition Plus (OBIEE+), ETL, Testing (IT)

Analyst
TSYS, Delhi
3/2009 – 10/2010 (1 Jahr, 8 Monate)
Banken
Tätigkeitszeitraum

3/2009 – 10/2010

Tätigkeitsbeschreibung

Project name: Support service desk for leading multinational banks.
Brief: Total System Services, Inc. (commonly referred to as TSYS) is the largest processor of merchant acquirers and card issuers (#1 for credit card issuers and #2 for merchant processing in the United States and around the world). TSYS processes over $1 trillion a year in credit and debit card transactions. I was working as a Analyst in CSD (Central Service Desk) department and taking care of multiple client’s card processing unit
Responsbilities →
➢ Provide live data base support to data center of leading banks (Barclays, Standard Bank, SONY ,FTIL, Union bank etc).
➢ prepare scripts to add new reports, report argument functions/procedures to generate new reports and then associate these reports to any thread/module to automate the process.
➢ Bug fixing related to customer services, transaction management.
➢ Provide 24/7 support to clients and address the EOD problems.
➢ Prepare scripts for data recovery in case of any miss happenings.
➢ Co-ordination with all teams to gather all requirements and to provide all support and testing data.
➢ Prepare scripts to add new parameters, templates and associate this to any products

Eingesetzte Qualifikationen

Banking One, Online Analytical Processing (OLAP), Oracle Business Intelligence Publisher, IT-Support (allg.), Online Banking, Transformation Management

Ausbildung

Bachelor's degree in Information technology
uttar pradesh technical university
2006
india

Über mich

NA

Weitere Kenntnisse

Dear, Hiring Manager
Greetings for the day.
I have around 11 years of IT experience in Banking, card payment domain, issuer, Acquirer
and software development sector .
During this period I have worked as Business intelligence engineer, data warehouse , ETL , database developer , integration and data migration expert for multiple clients like Barclaycards ,Standard bank Entercard As and other payment service provides at different international locations .
I am looking for a challenging job profile in similar or relevant domain.
Other Information:
Availability : Immediately available.
Salary expectation: 55000 Euro.
Language: English (Excellent), German (Basic A2).
Please find my attached resume and kindly let me know if this is suitable for this open position.
Best Regards
[...] [...] www.linkedin.com/in/[...]

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Deutsch (Grundkenntnisse)
  • Hindi (Muttersprache)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
1756
Alter
40
Berufserfahrung
17 Jahre (seit 03/2007)
Projektleitung
5 Jahre

Kontaktdaten

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

Jetzt Mitglied werden