SUMMARY:

• Specialized in SAP HANA, BODS, SDI, and SDA& BI with around 8 years of IT Experience, Worked closely in Installations& upgrades, Support and Development of SAP Business objects.
• Experience in SAP HANA Information Modeling using objects Attribute Views, Analytical Views, Graphical and Scripted Calculation Views, Analytical Privileges and Hierarchies, Restricted & calculated measures, Filter operations and variables, Calculation views, Currency conversion, Introduction to SQL script and script based calculation views and Full text search on SAP HANA Studio.
• Implemented Fuzzy Logic in Information Model Views.
• Implemented the SAP HANA Rule Framework for Business Users.
• Created the schedules using XS Engine for the Jobs/Flow graphs /Stored Procedures.
• Experience in creating HDB views and SAP HANA EIM (SDI) flow graphs for business requirements.
• Experience in SAP HANA Data provisioning using SAP Data Services, SAP Landscape Transformation, and Flat File upload.
• Experience in creating the flow graphs, Virtual tables, able to access the provisioning data & Real - time Replication in HANA SYSTEM using SDI.
• Heavy ETL (Extract, Transform, and Load), Data Quality and Data Profiling experience from source systems including Flat Files, XML,RDBMS (SAP HANA, Oracle, Db2,SQL Server, Informix and etc..),Legacy systems and SAP Applications/SAP BW using SAP Data Services (BODI/SAP BODS 3.x/SAP BODS 4.x)/SAP Information Steward/ SAP HANA EIM.
• Since 5 years working on SAP BODS Architect responsibilities includes as below
• Expertise in Installing SAP Data services 11.x/3.x/4.x and worked on different Transport methods RFC, Direct download, Shared directory, ftp and custom transfer to import the data from SAP R3/BW System.
• Solid Experience in Data warehousing projects and deep understanding of Data Warehousing life cycle and strong working experience on Data Warehousing applications and concepts of Dimensional data modeling concepts- Star Schema, Snow flake Schema methodologies, Fact table, Dimensional table, Slowly Changing Dimensions and Change Data Capture.
• Worked on Data Migration from Legacy system to SAP using SAP BODS and LSM.
• Experienced in Data Migration and involved in Data Extraction, Data Profiling, Data Validation, Data Cleansing, Data Enrichment and Loading into Staging area using AIO templates.
• Directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Provided the estimates for building ETL Jobs and developing ETL Job and schedule plans.
• Enabled the Multiuser Environment for ETL projects using “Central Repository”
• Experienced in developing Real Time Jobs and generated WSDL link using web services and tested using SOAP UI.
• Established the DB Connections and used Integrator Sources to connect the SAP BODS/SAPHANA.
• Experience of SAP BODS Rapid Marts installation and configuration.
• Handled SAP BODS 4.1/4.2 up gradation from SAP BODS 3.2, installation, Administration and environment setup for multiple projects.
• Created users and groups and assigned the roles to users on SAP BODS 4.1/4.2 through Central Management Console and Enabled the security features using CMS
• Created the SRS, BRS, DDS, ETL Mapping documents and Best Practices to follow in development for multiple projects. Expert to set up design guidelines for ETL Project and suggested the Performance Improvement Techniques.
• Created the ETL Design/Development/Unit Test /Code Review /Integration /Migration Templates.
• Created the ETL job template based on the client requirements for managing the matrix, auditing and exception handlings.
• Extensively worked on SAP BODS Admin roles.
• Experience in working with Information Steward (Data Insight, Metadata Management, Matapedia and Cleansing Package Builder).
• Established the DB Connections and used Integrator Sources to connect the SAP BODS/SAP HANA.
• Very good experience of Source System Analysis using SAP Information Steward - Data Insight
• Profiling and reconciliation was done to keep track of the different source data and involved in data movement by generating Data Quality Metrics like Completeness, Consistency, Conformity and Duplicates using SAP Business Objects Information Steward

TECHNICAL SKILLS SUMMARY:

• Windows 2012,Windows NT, Windows 2000 server
• SAP HANA SP09,SQL 2000/2005/2008
• Business objects data integrator, Business Objects Data services and SAP HANA EIM
• SAP HANA SP09
• Information steward 4.2, Agile data Preparation 1.2
• SAP HANA, SDI, SDA, SAP Bods, information steward

WORK EXPERIENCE:

Confidential

EIM Consultant

Environment: SAP Information steward, ADP, BOC or Lumira

Responsibilities:

• Created the SAP HANA information model views ( calculation views, Attribute views )
• Created the virtual tables to do Real time Replication
• Analyze the model in BOC storyboard.
• Created the flow graphs.
• Implemented the hierarchies in SAP HANA information Model.
• Involved in data load estimations from source system for business requirements.

Confidential

EIM consultant

Environment: Twitter, Smart Data integration, Data provisioning, BW/4HANA

Responsibilities:

• Configured the data provisioning remote source connections from existing data base.
• Configured the twitter adapter.
• Performed the data provisioning activities using SDI and BW4 HANA.
• Created the SAP HANA information Model views like Calculation views, Analytic views, Attribute views.
• Created the Calculated columns & Restricted columns.

Confidential

BODS Consultant

Environment: ECC, SLT, ODP/ODQ Data Services, Hadoop

Responsibilities:

• Work Allocation & tracking the offshore work with the presales. Participate in Weekly Conference Calls.
• Coordination &communication with the presales on a Daily basis.
• Provide the requisite support to the monitoring team to resolve the data loads issues from various source systems by means of process chains.
• Provide support for presales to resolve the issues while demoing.

Confidential

EIM consultant

Environment: HANA EIM, ADP

Responsibilities:

• Work Allocation & tracking the offshore work of the team members located in various cities countries. Participate in Weekly Conference Calls.
• Coordination &communication with the onsite team on a Daily basis.
• Provide the requisite support to the monitoring team to resolve the data loads issues from various source systems by means of process chains.
• Provide support to the Incident Management team to resolve the tickets
• Maintain the status of the Reports in the Portal & provide the reasons for the delay or unavailability of Reports.
• Creation of Info Packages for scheduling the data load process with Full and Delta update mode.
• Provide the requisite support to the monitoring team to resolve the data loads issues from various source systems by means of process chains.
• Provide support to the Incident Management team to resolve the tickets
• Maintain the status of the Reports in the Portal & provide the reasons for the delay or unavailability of Reports.