SUMMARY:

• Experience in analysis, design, and development of various Data Warehousing and Business Intelligence applications.
• Worked on projects in waterfall and agile methodology
• Sound experience in business flow of Telecom and Manufacturing domain.
• Experience of working in both development and support projects.
• Experience in Application Administration of SAP BODS and SAP BI.
• Contributed in development activities of SAP BODS, SAP BI, Oracle SQL and PL - SQL, SAP HANA SP12, SQL Server scripting, Perl Scripting
• Experience in Data Modelling.
• Experience in working with multiple vendors and geographically distributed teams

KEY DOMAIN AND TECHNICAL KNOWLEDGE:

Domain: Telecom, Manufacturing and Retail

Technical Skill: SAP BI, SAP BODS, SAP HANA, ORACLE, SQL SERVER, Perl Scripting, Dimension Modelling, Data Warehousing Concepts, TOAD, Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Worked on estimation of Project proposals and with 3rd party vendor like SAP for solution implementation.
• Leading the 10 member team from onsite for SAP BODS 4.2 and SAP BI 4.2 deployment and Data Migration activities.
• Administered SAP BODS, SAP BI and Oracle database application.
• Installed SAP BODS at UNIX environment providing various level of grants to users and application layers.
• Performed data modelling activities
• Regeneration of existing Data Model
• Enhancement of existing data model to only include Memory related components
• Taking the DB backup and recreating a DB by eliminating the existing HDD related components.
• Re framing the new DB components according to new ERP modules implemented for new company dealing with only Confidential Memory related commodities.
• Validated the conceptual model with the client and produced the physical model accordingly.
• Generated scripts for Database creation using ERWIN
• Planned activities for execution of Oracle Database migration and cleansing.
• Designed ETL jobs & Oracle Database Solutions for coding and performance tuning.
• Created BODS jobs for handling complex business logic using BODS transformations (like table comparison, history preservation, pivot, custom functions map operation etc) to populate sales and order related information at detailed fact layer of Star schema.
• Designed Universe for important modules (Sales, Order Management, Post Sales, EDI, Accounting Finance) using IDT.
• Created Adhoc Webi Reports based on various business needs.
• Created various Oracle PL-SQL function and procedures for Finance modules using cursors and triggers.
• Handled Change Requests for maintenance and enhancement of existing ETL jobs on SAP BODS and reports on SAP BI.

Confidential

Responsibilities:

:

• Installed SAP BODS on Hadoop clusters on one of its node
• Worked as an administrator of SAP BODS.
• Created connection between SLT and Hadoop system using adapters.
• Designed BODS ETL jobs for transferring data from SLT to Hadoop system

Confidential

Responsibilities:

• Leading the ETL track at offshore with 5 member team.
• Worked on upgrading the BODS 4.1 to BODS 4.2 at UNIX platform.
• Created different types of connection to SAP(RFC) and non-SAP(ODBC, Adapters) environment for integrating data from different sources using BODS
• Integrated data coming from various application modules of SAP and non-SAP system.
• Planned and Designed the Aggregation Module which was core part of Confidential project whose main purpose was to aggregate the total purchase of Confidential across Globe and make it available with an interface through which customer can drill up and drill down to check the purchase across different level of Business Areas .This module was created with the help of SAP tools like SAP HANA SAP BODS SAP BW and ABAP.
• Designed Calculated and Analytical views on SAP HANA SP11 for reporting detailed purchase volume of critical division.
• Reviewed code for Source to Target mapping on SAP BODS and SAP HANA
• Designed & Implemented Generic modules & frameworks - thereby increasing code re-usability.

Confidential

Responsibilities:

• Designed SAP BODS jobs based on micros logic of MS Access.
• Re-framed the ASP and VB scripts with BODS transformation logic.
• Enhanced BODS jobs to load the data from Service Now to maintain history in SQL Server DB for better performance.
• Created multiple SAP BI reports for reporting on Service Now of Confidential .
• Handled Change Requests for maintenance and enhancement.

Confidential

Responsibilities:

• Performed data modelling activities.
• Created mapping to determine the relation between Reports to existing DB and compared it with the new source system for re-framing the Data Model.
• Analyzed the new source structure of AORTA
• Regenerated the existing data model of Confidential Upgrade Project using ERWIN tool
• Modified the existing data model based on new source system
• Validated the conceptual model produced and the physical model with the client technical team for approval or sign off.
• Generated scripts for Database building using forward engineering process of Erwin tool.
• Installed BODS on Windows platform and configured repositories for the entire team for Development, Test and Production environment.
• Designed SAP BODS jobs for BSS module to extract data from AORTA source system and storing them in ORACLE database.
• Created multiple SAP BI reports for billing module.
• Created partition and indexes on the rapidly used transaction tables for performance optimization.
• Used optimizer hints for performance tuning of procedures.
• Fixed bugs at UAT phase for modules of OSS and BSS.

Confidential

Responsibilities:

• Analyzed the ETL UNIX Scripts which was designed on early 90s.
• Performed data modelling activities
• Understood the existing data model after regenerating it using ERWIN tool
• Included additional entities for integrating the interfaces.
• Modified the relationship between entities based on addition of interfaces.
• Validated the conceptual model produced and the physical model with the client technical team for approval or sign off.
• Generated scripts for Database building using forward engineering process of Erwin tool.
• Installed BODS on Windows platform and configured it
• Created BODS repositories for the entire team for UAT and Production environment.
• Re framed the ETL logic using SAP BODS solutions.
• Developed BODS batch jobs for two critical modules (Rating and billing module).
• Wrote PL/SQL procedures for part of the billing modules where BODS batch jobs were taking longer time for better performance.
• Created schedules for all the jobs using Data Services scheduler.