Unit Head Data Architecture and Integration
Allied Bank Limited
Total years of experience :18 years, 6 Months
Responsible for overseeing the day-to-day operations of the team, conducting scrum meeting, distributing the workload evenly amongst staff, meeting and dealing with multiple vendors for the completion of project implementation and making sure motivation and performance levels are maintained. Worked as IT Senior Manager for more than 8 years
• Working as Lead Data Engineer and Managing 6-person team, organizing scrum meetings, planning time lines and allocating workloads to individual staff members based on their ability
• Completing business requirements in coordination with multiple teams/branches of Bank
• Coordinated with IBM(vendor) in Big Data Hadoop Implementation and administration using Cloudera Release 4.13 using Oracle Big Data Appliance Starter Rack x7-2.
• Involved in Designing Big Data architecture where Data from multiple Banking sources like Iris, Internet Banking, CRM, ESB, Temenos 24, Siebel and HCM residing at Data Lake and loading in Target database in shape of Data Warehouse using Big Data Hadoop Components i:e; MapReducer, HDFS, YARN, spark, Hive, Sqoop, and Zookeeper.
• Oracle Data Integrator 12c used for loading data to data warehouse pipelines
• Involved in ongoing development, integrations, optimization and Batch monitoring tasks for Centralize Database and Big Data Platform
• Integrated multiple sources i:e; T24, IB, CRM, IRIS, EBS, CAMS, CREDIT CARD, ESB in a centralized data warehouse to meet BI reporting requirements and perform visualizations.
As Technical Consultant:
• Oracle HCM (HR, Payroll, OTL, OLM, SSHR, UPK, iRec) API’s, Fast Formula, Custom Procedures and Reports.
• Development and customization of Oracle Workflows
• Development of customized XML Publisher, BI Publisher Reports
• Oracle Application Framework (OAF) Personalization, Customization
• Strong Knowledge of SQL, PL/SQL Procedures, functions and all DB Objects
• Installation and Configuration of Oracle Business Intelligence Application 11g and Oracle Business Intelligence Enterprise Edition 12c.
• Build Customized BI Dashboards, Analytics, BI Publisher, datawarehousing and developed Metadata repository in OBIEE 11g & 12c.
• Customized Aggregate Creation using Oracle Database In-Memory 12.1.2.0, for OBIEE 12c.
• Configuring OBIEE on Mobile App and performed system administration tasks.
• Development of ETL’s in Oracle Data Integrator 11g tool for Oracle Business Intelligence Application.
• Installation of Oracle E-Business Suite R12, Oracle Business Intelligence Application 11g,
• Installed and configured Oracle Business Intelligence Application 7.9.6.4. with Informatica and Datawarehouse Administration Console on Windows server 2008 standard edition and developed ETLS in integration with DAC
• Oracle Business Intelligence Enterprise Edition 11g & 12c. Configuration of DMZ with EBS R12.2.7, Oracle Linux and Administrative activities like backups, Linux shell scripts, cloning, patching, Application DBA (AD) utilities.
• Customized Reports Development for different Oracle E-Business Modules.
• Data Loading of various modules through Oracle Standard Interface Tables and API’s using SQL Loader.
• Creation of Oracle Application Users, Responsibilities, Profile Administration, Concurrent Manager Administration.
• Development of procedures and functions for implementing business logic.
• Experience of making Test cases, troubleshooting, analyzing business requirements and providing solution.
• Involved in complete project implementation life cycle of various assignments.
• Preparing technical documents, conducting technical trainings and support to users.
As Functional Consultant - HRMS:
• Involved in implementation of core HRMS, Payroll, OTL, IREc, OLM.
• Creating Elements, Input Values and Balances.
• Efficient in writing complex Fast formulas.
• Efficient in using HRMS Formula Functions, Table Values and Lookups.
• Understanding of complete Oracle Payroll functionalities from preparation of payroll
