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

12/2016 – offen

➢ 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.

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

9/2011 – 12/2016

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.

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

10/2010 – 9/2011

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.

Data Mining, Data Warehousing, Oracle Business Intelligence (BI), Oracle Business Intelligence Enterprise Edition, ETL, Testen