Experience

CAMP SYSTEMS PRIVATE LIMITED

• Software Application Developer



Cognizant

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Associate

  • Oct 2016 - Aug 2018

  Business Problem::The OmniPay platform is a merchant processing platform specializing in processing transactions from both domestic and international merchants on behalf of acquiring banks. It offers a robust acquirer-processing environment that provides 24 x 7 mission critical secure payment transaction processing. The platform currently supports acquiring banks across Europe, Asia Pacific, and North America and provides a range of services to these banks and their merchants including Authorization, Scheme Clearing and settlement, Merchant funding, exception item handling and reporting. It is therefore of paramount importance that the platform provides continuous availability, which necessitates a flexible, resilient and robust platform architecture. • Database Development including analysis the requirement story and develop PL/SQL Code • Data Modeling for Cubes and Dimension • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse • Gathering requirements from users/business to develop interfaces, packages, Load plans. • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces. • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost. • Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G. • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database. • Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents. • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios. • Extensively used ODI to load data from Oracle, XML files and flat files • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables. Show less



NTT DATA

• Japan
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Consultant

  • Mar 2015 - Sep 2016

  Business Problem::Se2 is platform interface product managed by multiple insurance institution to operate insurance product such as Life insurance, Annuity etc.,. Core system is a data management and middle of all up to downstream .Main business logic is applied by ETL process and data drown down to end system • Database Development including analysis the requirement story and develop PL/SQL Code • Data Modeling for Cubes and Dimension • Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse • Gathering requirements from users/business to develop interfaces, packages, Load plans. • Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces. • Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost. • Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G. • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database. • Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents. • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios. • Extensively used ODI to load data from Oracle, XML files and flat files • Worked closely with the end users/business and designing the documents to the track changes. • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables • Monitoring the PL/SQL jobs • Create Catalog , Physical ,Logical, Presentation Table in OBIEE Layer • Create an Oracle BI Repository using data sourced from a relational data mart • Exposure knowledge in Oracle answer, Publisher, Dashboard • Admin work in Oracle BI Server • Create and maintain views, materialized view • Performance Tuning by PROFILER, AWR report. Show less



Discovery Holding Company

• 1 - 100 Employee

• Database Team Lead

  • Sep 2012 - Sep 2013

  • Worked with on-site analyst to understand their requirements • Data Modeling for Cubes and Dimension • Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database. • Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios. • Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios. • Extensively used Synchronous and Asynchronous Change Data Capture CDC techniques. • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it. • Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse • Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository. • Used Oracle Data Integrator ODI to extract relevant data from Oracle EBS and map it to Siebel interface tables. • Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database • Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions. • Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration. • Configured ODI Agents on UNIX server and creating new agents and test them in ODI 11G. • Worked on setting up crontabs on UNIX servers for scheduling the cron jobs • Extensive work inPackages, stored procedures, Stored Function and Trigger • Create Table, Partitioned Table, Indexes, Views, materialized view, Synonyms • Create Catalog , Physical ,Logical, Presentation Table in OBIEE Layer • Performance Tuning Show less