AJAYKANTH HARNOOR CHANDRAKANTH

Application Development Senior Analyst
Bengaluru, India, Karnataka
|

hc.ajay@gmail.com
|

+91 9738221181
8+ years of IT experience in Data Analysis, Reporting in various Business Intelligence Tools like SAP Business Objects Web Intelligence, SAP Native HANA and ETL in SAP Business Objects Data Services and MSBI SSIS, having worked for multiple development & implementation projects.
A
H

Work Experience

Accenture Solutions Pvt. Ltd

Application Development Senior Analyst
|

Oct, 2016 - Current

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

Tech Mahindra Ltd.

Senior Software Engineer
|

Mar, 2015 - Oct, 2016

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

Unisys Global Services India Pvt. Ltd

Service Delivery Analyst 2
|

Oct, 2013 - Mar, 2015

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).

Dell International Services Pvt. Ltd.

Client Technical Support Associate
|

May, 2011 - Oct, 2013

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.

Education

Ulyanovsk State University, Russia (Correspondence)

International MBA in Information Technology Information Technology
|

Mar, 2013 - Apr, 2014

SJB Institute of Technology, Bengaluru, Affiliated to Visveswaraya Technological University, Belgaum

Bachelor of Engineering Computer Science and Engineering
|

Aug, 2006 - Jul, 2010

PES PU College, Affiliated to Karnataka PU Board

PU (10+2) Physics, Chemistry, Mathematics, Biology,
|

Apr, 2005 - May, 2006

Kendriya Vidyalaya No.1 Uppal, Hyderabad

10th, CBSE Syllabus
|

Apr, 2003 - May, 2004

Skills

  • SAP BO Suite : Web Intelligence, Data Services, Information Design Tool
  • SAP HANA Studios, Native HANA
  • MSBI Suite : MS SQL Server 2000 (DTS), MS Visual Studio 2008/2012
  • Database: HANA, SQL, Oracle