Vikesh Kumar Email & Phone Number

Dubai, United Arab Emirates

Project Data Lineage and Metadata Repository Client Dubai Islamic BankClient Domain BankingTechnologies used Talend Data CatalogueRoles and Responsibilities1 Data and Model Owner for data warehouse across different business banking functions2 Build and maintain Enterprise Data Dictionary3 Document data lineage for current-state Risk and Finance data landscape (both, detailed and… Show more Project Data Lineage and Metadata Repository Client Dubai Islamic BankClient Domain BankingTechnologies used Talend Data CatalogueRoles and Responsibilities1 Data and Model Owner for data warehouse across different business banking functions2 Build and maintain Enterprise Data Dictionary3 Document data lineage for current-state Risk and Finance data landscape (both, detailed and high level views)4 Drive the development and management of an inventory of the enterprise-critical information maps, including authoritative systems, process owners, data protection standards, data quality standards, and adoption requirements across the enterprise5 Identify best version of data sources6 Document all data quality controls and data transformations applied between source and destination 7 Execute against an enterprise data governance framework, with a focus on improvement of data quality and the protection of the organizations data 8 Ensure a data-centric approach is taken in projects and issues resolution ensuring that data governance best practices are incorporated into each and every effort Show less

Dubai, United Arab Emirates

Project Banking Data model implementationRoles and Responsibilities1 Source system study and understanding customer business2 Converting business requirements in BDW models3 Identifying data elements for Data warehouse Data Modelling4 BDW data modeling for SOA, AML, Finnone, HF LMS, CARDS5 Creating logical data models using Erwin6 Deploying logical data models in Netezza BDW7 Performance tuning in Neteza and ETL jobs… Show more Project Banking Data model implementationRoles and Responsibilities1 Source system study and understanding customer business2 Converting business requirements in BDW models3 Identifying data elements for Data warehouse Data Modelling4 BDW data modeling for SOA, AML, Finnone, HF LMS, CARDS5 Creating logical data models using Erwin6 Deploying logical data models in Netezza BDW7 Performance tuning in Neteza and ETL jobs 8 Real-time DR data replication strategy using replication pipeline9 Automating the daily and monthly MIS reports for Risk and Finance department10 Designing the logical layer on top of BDW for different departments across the banks11 Creating a single source of truth for the reporting across departments, sourcing data from BDW12 ETL development using Datastage 10.513 Creating projects, parallel jobs, sequences, parameter in Datastage14 Reading data from and creating sequential files 15 Customer engagement for UAT signoff16 Knowledge transfer to customer L1 support team 17 Monthly project update to customer (in steering committee) Show less

Dubai, United Arab Emirates

Project Big Data AnalyticsRoles and Responsibilities1 Vendor selection for BIG Data2 Data modelling for predictive analytics3 Data discovery for predictive analytics .

Dubai, United Arab Emirates

Project NBQ Enterprise DatawarehouseRoles and Responsibilities1 Source system study and understanding customer business2 Identifying data elements for Data warehouse Data Modelling3 BDW data modeling for Finacle Core, Finacle Treasury, HPS4 ETL development using Datastage 10.55 Creating projects, parallel jobs, sequences, parameter in Datastage6 Reading data from and creating sequential files 7 Customer engagement for UAT… Show more Project NBQ Enterprise DatawarehouseRoles and Responsibilities1 Source system study and understanding customer business2 Identifying data elements for Data warehouse Data Modelling3 BDW data modeling for Finacle Core, Finacle Treasury, HPS4 ETL development using Datastage 10.55 Creating projects, parallel jobs, sequences, parameter in Datastage6 Reading data from and creating sequential files 7 Customer engagement for UAT signoff8 Production roll out 9 Knowledge transfer to customer L1 support team 10 Monthly project update to customer (in steering committee) Show less

Dubai , Uae

Project DIB – Enterprise DatawarehouseRoles and Responsibilities1 Source system study and understanding customer business2 Identifying data elements for Data warehouse Data Modelling3 Creating enterprise data model using ERWIN4 Designing of dim and facts for warehouse5 ETL development of the designed data model using Datastage 9.1 and Unix Scripting6 Creating projects, parallel jobs, sequences, parameter in Datastage7 Reading data… Show more Project DIB – Enterprise DatawarehouseRoles and Responsibilities1 Source system study and understanding customer business2 Identifying data elements for Data warehouse Data Modelling3 Creating enterprise data model using ERWIN4 Designing of dim and facts for warehouse5 ETL development of the designed data model using Datastage 9.1 and Unix Scripting6 Creating projects, parallel jobs, sequences, parameter in Datastage7 Reading data from and creating sequential files 8 Data modeling of I-Flex, LMS, CRM, FRS, MIS, LOS etc.9 Design and implementation of data models for TAT, Central Bank, P&L, FINMIS & Enterprise Balance Sheet10 Defining distribution keys, generating stats and grooming tables in Netezza11 Creating databases, users and giving access on objects to users in Netezza12 Customer engagement for UAT signoff13 Production roll out 14 Knowledge transfer to customer L1 support team Show less

Delhi

Project PEX DatawarehouseRoles and Responsibilities1 Requirement gathering (SRS creation)2 Converting SRS into technical design/solution3 Data warehouse designing4 Installation of OBIEE 11g on Windows/Linux/AIX environment5 Upgrading OBIEE from 11.1.1.5.0 to 11.1.1.6.06 Applying patches on OBIEE7 Security implementation (LDAP, SSO, data level and object level) in OBIEE8 RPD designing (physical layer, BMM layer star schema… Show more Project PEX DatawarehouseRoles and Responsibilities1 Requirement gathering (SRS creation)2 Converting SRS into technical design/solution3 Data warehouse designing4 Installation of OBIEE 11g on Windows/Linux/AIX environment5 Upgrading OBIEE from 11.1.1.5.0 to 11.1.1.6.06 Applying patches on OBIEE7 Security implementation (LDAP, SSO, data level and object level) in OBIEE8 RPD designing (physical layer, BMM layer star schema creation, hierarchy creation, presentation layer, RPD variables, cache purging) 9 Dashboard designing (filters, dashboard prompts, drill down, drill through, ad hoc reporting)10 RPD and web catalog merging and migration from one server to another11 Creating data models and reports in BI publisher 11g (drill through reports using RTF templates)12 Creating physical architecture, logical architecture, models, projects, mappings and interfaces in ODI (ETL Development)13 Provide training to customer14 UAT closures15 Helping Pre Sales team for customer demo Show less

Kolkata Area, India

1 Converting SRS into technical design2 OBIEE RPD designing (joining different data sources, script calling in connection pool, physical layer, BMM, presentation layer, repository variables, setting execution precedence, implicit fact columns)3 Creating dashboards4 Cache seeding and purging5 Implementing security in OBIEE (object level, data level, LDAP)6 RPD and web catalog migration from one environment to another7 Guiding and helping other team members

Gurgaon, India

1 Requirement gathering, system study & impact analysis2 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)3 Modifying RPD (adding new tables, BMM layer designing)4 Dashboard creation5 Code migration from one server to another6 UAT closures7 Guiding and helping other team members

Gurgaon, India

1 Converting SRS into technical design 2 Database installation (oracle 10g) 3 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers) 4 Creation and deployment of database patches to improve the performance of the live system 5 Guiding and helping other team members in solving database related problems

Gurgaon, India

1 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers) 2 Providing Patches for the fixing of bugs in Oracle ERP 3 Production Support4 Customizing existing forms and reports 5 Writing Unix shell scripts6 Interacting with customer for requirement analysis

Advanced Data Science For Managers, Data Science

Bachelor Of Engineering (B.E.), Information Technology

Education record