Accomplishments:

• HANA Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules.
• The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI.

• Accomplishments:
• Involved in requirement Gathering, FS, TS, Designing of Info Cubes & DSO's
• Build, Unit Testing, Defect Fixing as part of UAT, Handled Cutover activities, Hyper care Support
• Providing KT for the Support Team
• End-User Training
• Application Areas : SD (Sales Orders, Contracts, Nominations),
• MM (Inventory Management, Purchasing), FI (FI-GL, AR,AP,AA)
• Loading of master/transactional data from flat file as well as from R/3 system
• Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions
• Prepared Technical Specifications from Functional Specifications
• Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction to BI enhanced the extract structures by adding new fields.
• Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability
• Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP
• Worked on development of New queries/Cubes/DSO's and extractors
• Developing Local specific Process Chains and Meta Chains (RSRQ, RSPC, Event Collector, SM50, SM37, and RSMO) and Create new Info Packages in addition to Global.
• Used BEx Query Designer as a Front End Tool to build Queries and Reports
• Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads
• Extensive usage of administration workbench (RSA1)
• Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.

Involved in requirement Gathering, FS, TS, Designing of Info Cubes & DSO's • Build, Unit Testing, Defect Fixing as part of UAT, Handled Cutover activities, Hyper care Support • Providing KT for the Support Team • End-User Training • Application Areas: SD (Sales Orders, Contracts, Nominations), • MM (Inventory Management, Purchasing), FI (FI-GL, AR, AP, AA) • Loading of master/transactional data from flat file as well as from R/3 system • Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions • Prepared Technical Specifications from Functional Specifications • Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction to BI enhanced the extract structures by adding new fields. • Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability • Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP • Worked on development of New queries/Cubes/DSO's and extractors • Developing Local specific Process Chains and Meta Chains (RSRQ, RSPC, Event Collector, SM50, SM37, and RSMO) and Create new Info Packages in addition to Global. • Used BEx Query Designer as a Front End Tool to build Queries and Reports • Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads • Extensive usage of administration workbench (RSA1) • Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.