Business Intelligence and Reporting Tools (BIRT)
Datawarehouse / DWH
Projekt‐ & Berufserfahrung
Inatec payment solution GmbH, frankfurt am main
Payment solution provider
12/2016 – offenTä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.
Produktdesign, Business Intelligence and Reporting Tools (BIRT), Reporting, ETL, Oracle Database, Projektassistenz (IT)
Capgemini / Entercard AS Norway, oslo
9/2011 – 12/2016Tätigkeitsbeschreibung
Brief: This is data migration for all Sparebank1 products from EnterCard (processing partner) to sparebank1’s new credit card support system.
➢ 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, Migration, Kooperationen, Technischer Support
AWC software pvt ltd, Delhi
10/2010 – 9/2011Tä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
➢ 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, Datawarehouse / DWH, Oracle Business Intelligence (BI), Oracle Business Intelligence Enterprise Edition Plus (OBIEE+), ETL, Testing (IT)
3/2009 – 10/2010Tä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
➢ 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
Banking One, Online Analytical Processing (OLAP), Oracle Business Intelligence Publisher, IT-Support (allg.), Online Banking, Transformation Management
(uttar pradesh technical university)
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.
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.
[...] [...] www.linkedin.com/in/[...]