- Software Professional having 12+ years of experience in Key IT domains. Expertise includes System Analysis, Design, development and Implementation.
- Proven experience of 4+ years in Business Intelligence and Data warehousing Using SAP BI and HANA. Extensive experience of 8 years in Oracle Application Architecture and Development.
- Experience on Business Warehouse that includes Data - Modeling, Data Extraction, Data Loading, Scheduling, Monitoring and Reporting.
- Experience on SAP HANA that includes Data Modeling including calculation Views and HANA Tables, writing complex procedures, debugging and monitoring SLT platform.
- Proven experience of performing ETL services. Developed Data flows between applications. Exposure to ODI (oracle) and SLT Platforms (SAP HANA).
- Experience of Data Migration from Legacy system to the newly developed Systems.
- Experience of Production Support to BI and Oracle Application systems.
- Worked as Oracle Application Architect. Have performed Code Review and written Technical solution writings. Resolved issue related to Performance Tuning.
- Good experience of using methodologies like Explain Plan, Impact Analysis, Best Practice guide.
- Proposed, design and developed an Email Management System named DESPoc, this application assisted Global Support Confidential in area like Roster management, defect tracking and resolution rate
- Resolving Incident Tickets and service request for BI Modules.
- Monitoring and providing daily, weekly and monthly data loads performed into BW and rectify the issues if any occurs
- Investigate issues related to data flow that is coming from source system (Finance, CRM and GRC) to the BI reporting level. Middle stage is to investigate (if issue occurs) SLT replication, HANA Calculation View & PSA, aDSO.
- Worked on Performance Enhancement of HANA Views and optimization of Process Chains
- Experience of working in different projects developed for CMA CGM. These are Profitability Estimates (related to Finance), Data extract for Eloqua Project (related to CRM and GRC).
- Development BW component like Info Objects, advance ADSO’s, HANA Tables, Procedure, Process Chains, ABAP dictionary Views, BEX and WEBI reports.
- Conducted detailed analysis and provided solution.
Reporting Tools/ Environments: Analysis for Office, WEBI, Design Studio, SAP Lumira, SAP Analytic Cloud, SAP BW, SLT.
- Analysis of Business requirement specification and writing Technical specification. Communication with business team to ensure the Technical solution is in line with business needs and an efficient solution performance wise.
- Development in Oracle Forms and Reports Keeping Best Practice guidelines. Built interfaces, procedures and the packages for the data loading (ETL) using Oracle Data Integrator.
- Performing Code Reviews of development sent. Making sure development is coherent with IBM defined standards for CMA. Suggestion of Technical fixes and improvement in Code quality.
- Providing Technical solution/ consultation for development Team in case of issues.
- Preparation of the technical specification document, which specifies in details, all the steps in the ODI flow.
- Unit testing of the packages/scenarios.
- Analyze errors to suggest Technical changes in case of emergency.
- Gathering Business requirement, DB modeling based on proposed design.
- Development in Forms 10 G, moreover performing unit testing to ensure proper solution is developed.
- Deployment of TMS, installation of oracle DB and installation of application.
- Migration of existing data into TMS. Mostly from MS SQL Server to Oracle
- User Training Session.