AJAYKANTH HARNOOR CHANDRAKANTH

Designation: Application Development Senior Analyst

SAP BO, SAP HANA Consultant

Projects: 1. Leading US Confectionery Company, Oct-2016 to Aug-2017

2. Finland Based Pharma Company Aug-2017 to Jun-2018

3. Leading Bank in Belgium Jul-2018 till date

Database: Microsoft SQL Server 2012, SAP HANA, Oracle

Tools: SAP BO, SAP Hana Studio, Microsoft SQL Server 2012

Contribution:

• Created and Configured Calculation Views (SAP HANA Studios)
• Managed SAP HANA Data modeling and data replication, including analyzing and developing Attribute, Analytic and calculation views for Retail and Life Sciences domain respectively.
• Corrected data in tables by executing SQL commands.
• Worked on HANA Transport Request Management and User Administration whenever required (Including Export & Import of Packages)
• Designed and published the reports based on the client requirements in the release cycle.
• Created Web Intelligence Documents by writing SQL Queries for Derived tables in the universe as per the Functional Specifications.
• Created Technical Design Documents with all the Design Specifications and Estimations for New Webi Reports and changes.
• Generated and Maintained Aggregates and Roll up activities.

Rectified load failure errors like Master Data loads and Transaction data loads (SAP BODS, Data Services).

• Created & designed Universe for reporting from Information model Using IDT, UDT.
• Worked as a Lead for SAP BO BI Projects
• Had been to Onsite Location- Brussels, Belgium for 6 Months for SAP BI Migration Project

Designation: Senior Software Engineer

SAP BI Consultant

Project: Leading Telecom Client, Netherlands,

Database: Microsoft SQL server 2000/2008, ORACLE 11g

Tools: SAP HANA, SAP BO, SAP BODS, Oracle 11g, Data Transformation Services, MS Excel.

Contribution:

• Worked in this project as SAP BI Consultant, Webi Based Reporting Analyst and Oracle DBA.
• Worked on SAP HANA studio created data models for analytical, attribute and calculation views.
• Created, Maintained and Executed SAP BODS ETL Batch Jobs
• Configured Security & Authorization of objects (Analytic privilege, System privilege, SQL privilege & Package privilege)
• Successfully migrated 2 Oracle Servers, as per the requirement of the Project.
• Created many Design Documents with all the Design Specifications and Estimations for New Webi Reports or significant Change in existing ones.
• Received Best Team Award in May 2016
• Handled and Efficiently Managed to Work on Various Skills like SAP BI, BO and Oracle DBA whenever required

Designation: Data Analyst (Service Delivery Analyst 2)

Worked as a Reporting (Data) Analyst

Project: BOA, Reporting

Database: Microsoft SQL server 2000/2008, ORACLE 11g

Tools: SAP Business Objects BOXI R3, Crystal Reports, SQL, MSBI (, SSIS, SSMS) MS Excel, MS Outlook.

Contribution:

• Designed, created, executed and delivered the reports based on the client requirements, Reports based on SAP BO, MSBI.
• Interacted with the management and business Decision-makers to identify business report requirements.
• Worked on the Administration of Reports, including scheduling reports, configuring security.
• Fine tuning of stored procedures to improve the performance.
• Used DTS packages to implement Extraction, Transformation and Load (ETL).

Designation: Client Technical Support Associate

Client: TUI UK, IT Service Desk

Environment: MS Windows, Citrix Framework

Tools: MS Excel, MS Outlook, Active Directory, BMC Remedy (Ticketing), VNC Viewer (Remote Assistance), SAP BO, MSBI (Visual Studio 2008, SSIS, SSMS, Data Transformation Services).

Contribution:

• Worked as a Client Technical Support Associate (L1, Non-Voice) for the TUI UK, IT Service Desk
• Resolved/Processed the client queries/issues within the specified SLA
• Made outbound calls to the client employees and assist them remotely on various application, MS Outlook issues.
• Worked on SAP Business Objects User Accounts administration (Login creation/issues, password reset).
• Created Daily, Weekly, Monthly reports for the management team and field operation managers using Business Objects Web Intelligence, DTS (SQL 2000).
• Awarded Tech of the Month, Tech of the Quarter in Oct 2012 in Dell International Services Pvt. Ltd.