BI/ETL Specialist & Technical Solution Designer/Architect
Rabobank
Total years of experience :13 years, 10 Months
Rabobank-Utrecht, NL
Projects: Finance - Corporate banking (flexcube system)
Domain/Area: Global finance and risk system
Daily Activities:
•Currently busy with AI innovation idea which we won in the Rabobank DragonsDen initiative out of 50 ideas.
•Understanding the business requirements and developing the solution using Informatica, Oracle, Unix, Peoplesoft, Scheduling tool, Azure applications, Lineage tools, Open Sources etc.
•Test the solution (Unit testing/Functional testing).
•Prepare release note/document and deploy code to Production.
•Providing production support during go lives.
Salesforce, Service Now, Sales Activity, IFRS, Avaya
Domain/Area: Telecommunication
Daily Activities:
•Understand the business requirements and creating a refinement pages(specification)/mapping document.
•Design Datamart solution using Erwin tool.
•Develop/Build the solution using ETL-Informatica 9.6.1 and 10.2.0, Teradata, Oracle, Power BI, Shell scripting, Python, CI/CD tool and Open Sources.
•Test the solution (Unit/Functional/Regression testing using Robot Framework).
•Prepare release note/document and deploy code to DTAP.
•Create sample reports provide the demo to stakeholders.
•Ops activities (Environment setup, weekend monitoring, create an incident, solving production issues etc.…)
Den Haag, Netherlands
Projects: WORKDAY, CREDO, GPA, ART
Domain/Area: Insurance & Asset Management
Responsibilities:
•One of my major responsibilities was to identify the areas where repetitive tasks are being performed, reduce manual effort, improve the performance, and increase the business values.
•I have used to validate the source data against business rules and process the same into DWH.
•I have used to do data analysis and gap analysis for various source systems w.r.t. targets model.
•I have designed the technical ETL processes (Informatica power center) and high-level architecture.
•I have analyzed the existing code which was built in SAS and needs to build the new optimal solution in Informatica PowerCenter.
•I used to develop/build Informatica mapping, testing also monitoring and resolving production issues (L3 support).
•Code walk-through/sign off with the client/business.
Projects: FIN TAX, CRS, Generic Tariffing, Bethmann Bank DWH.
Domain/Area: Banking - Finance
Responsibilities:
•To build/develop Informatica power center mapping (SCD-1, 2, 3, lookup, inert, update mapping to load and update data into Teradata tables).
•Data insights (data analysis and data quality).
•Validating source data and load to DWH.
•I was also taking care of Business Analyst activities in some areas.
•Working on IBM’s Industry wide Data Warehouse Models (BDWM) & Information Framework (IFW).
•Gap analysis for various source systems w.r.t. target DWH model.
Integrated Consumer Data Warehouse (ICDW).
Domain/Area: Banking - Finance
Responsibilities:
•Managing the reverse engineering team.
•Analyzed and developed the Abinitio graph and created Informatica power center mapping document and high-level design documents.
•Code walkthrough with the client.
•Identify the areas where repetitive tasks are being performed. Reduce manual effort, increase efficiency and accuracy by automating the process.
Genesis-NextGen Solution, I2A (Informatica to Abinitio) Migration.
Domain/Area: Banking - Finance
Responsibilities:
•Developed ETL mappings, Unix scripts, SQL/Teradata complex queries, unit testing, system testing, FAT/BAT, and production implementation.
•Developed OPC (Tivoli) and Autosys schedule to automate the batch and run process.
•Collected and reviewed the new requirement and change request.
•Analyzed the Informatica mapping and created design and mapping documents.
•Developed and tested Abinitio graphs.
•Interacted with different teams to perform UAT and PROD installation manually and carried out UAT/PROD Support and fixed UAT related issue.
Projects: To Bring the Business/Clients and Increase the company revenue.
Domain/Area: Networking
Responsibilities:
•My responsibilities ware to understand the Technologies and behaviour of the product and explain/present to the client.
•Represented the technical aspects of how the product solves specific customer problems.
•My Major responsibility was to give pre and post presentation for the product to the client.
Domain and Line of Business
•Banking & Finance (Cards, Credit & Mortgages, Financial Report, Common Reporting Standard)
•Telecom & Insurance
: