Sathya Palani, Developer in Bengaluru, Karnataka, India
Sathya is available for hire
Hire Sathya

Sathya Palani

Verified Expert  in Engineering

SAP BusinessObjects (BO) Developer

Bengaluru, Karnataka, India

Toptal member since June 18, 2020

Bio

With 15 years of experience serving as a principal data science and BI architect/consultant, Sathya has acquired complete working knowledge in data modeling, business intelligence, data warehousing, data science, prediction, and automation. He has worked on various applications ranging from simple to complex and believes there's a solution to every problem.

Portfolio

Health Insurance
Tableau, Sisense, IBM Cognos, Microsoft Power BI...
Citi Bank
TFS, Jira, Autosys, Oracle, Talend ETL
Intercontinental Hotel Group
SAP BusinessObjects (BO), Oracle, Teradata

Experience

  • SAP BusinessObjects (BO) - 12 years
  • SQL - 12 years
  • Business Intelligence (BI) - 12 years
  • ETL - 12 years
  • Data Warehouse Design - 10 years
  • Data Modeling - 10 years
  • R - 2 years
  • Data Science - 2 years

Availability

Part-time

Preferred Environment

Business Intelligence (BI), Data Science, SQL, Data Warehousing, Python, Machine Learning, SAP BusinessObjects (BO), Microsoft Power BI, DevOps, Talend ETL

The most amazing...

...thing I created is a data model to predict voluntary disenrollment for Fallon Health.

Work Experience

Consultant/Architect

2015 - PRESENT
Health Insurance
  • Generated a business object dashboard and modeled EDW Universe and ODS system.
  • Created a self-service reporting architecture.
  • Analyzed social media with data science and R.
  • Automated integration data through an external API using TIBCO.
  • Involved in a data science project to predict unenrollment reason and correlation.
  • Involved in text analytics of social media comments.
Technologies: Tableau, Sisense, IBM Cognos, Microsoft Power BI, SQL Server Integration Services (SSIS), TIBCO, SAP BusinessObjects (BO), R, Data Science, Microsoft SQL Server

Architect/Consultant

2014 - 2015
Citi Bank
  • Contributed to the design and maintenance of data warehouse for asset management.
  • Involved in ETL for data extraction transformation and loading for HP asset management through Talend ETL tool.
  • Managed BI reporting for asset management.
  • Automated the self-service marketplace for asset procurement within Citi.
Technologies: TFS, Jira, Autosys, Oracle, Talend ETL

Senior Developer/Consultant

2011 - 2014
Intercontinental Hotel Group
  • Contributed to data modeling and data warehouse design.
  • Designed the architecture of Reporting Universe FMDS, SBRP.
  • Automated the reporting solution to deliver reports on a scheduled basis for the business need.
  • Created ERA (enterprise reporting application).
  • Contributed to the ETL development and data movement using Informatica.
Technologies: SAP BusinessObjects (BO), Oracle, Teradata

Administrator

2010 - 2011
GE Health
  • Worked as the administrator for Business Object reporting, and maintained the server.
  • Configured the BO Server. Migrated and maintained FRS. Backed up and scheduled server maintenance.
  • Installed software, set up Tomcat and Apache, migrated the reporting tool, and upgraded the system.
Technologies: TFS, Unix, Business Objectives

Developer

2007 - 2010
IBM
  • Developed and maintained an enterprise data warehouse SQL, PL/SQL, Unix, and Informatica.
  • Generated a Business Intelligence report using Business Objects Tool XIR2 and Crystal Report.
  • Worked on timesheet application, billing, and CRM using .Net and Java.
Technologies: Java, .NET, Unix, Business Objectives, Oracle, PL/SQL, SQL

BRAINS

BRAINS is a central data warehouse collecting priceable CDR.

Personal information data is aggregated, stored for 14 months, and made available to users for multidimensional analysis through OLAP tool and SAP Business Objects.

Environment: SAP Business Objects (BOXIR 2, BOXIR 3.1), PLSQL, Oracle, Informatica, Java, Unix

SAP Business Objects Administration and Development

Projects Involve managing SAP Business Objects and migration from BOXIR2 to BOXIR3, software set up, maintenance, and upgrade.

ERA

Enterprise Reporting for Airlines: A complete BI box solution for airlines, reporting solution cover’s major KPIs related to airlines under different categories like commercial, operation, loyalty, revenue, and technology used (SSRS, SSAS, SSIS, SQL Server, Sharepoint, or Erwin).

HOLA

Hotel Loyalty Analytics was created to provide a hotel loyalty solution. It covers major KPIs involved in hotel loyalty. The technology used was Qlikview, SQL Server, and Erwin.

FMDS

The purpose of the FMDS project is to offload all the existing legacy applications from the mainframe system and place that functionality on other more open platform systems and database technologies. This involves analyzing existing system data flows and processes at a high level, then design a new architecture for systems and data flow processes and a reporting strategy that will accommodate the business interests of IHG in a more up to date and cost-effective technology. The project involved the development of huge number of new BO reports from the mainframe DB2 reports

Environment: PLSQL, Teradata, SVN, SAP Business Objects (BOXIR 3.1).

SBRP

Strategic Business and Revenue Planning consolidates seven hotel revenue management systems into one application to enable business planning activities. These activities include forecasting, budgeting, market assessment, competition analysis, and expense tracking

Environment: SAP Business Objects (BOXIR 3.1), PLSQL, Oracle, Toad, SVN

GHSM

Global Hardware and Software Asset management for CITI which includes integrating HW and SW data for desktop, server, CAP, and VDI from multiple source system, reconciliation, and updating asset manager and data warehouse, creating BI reports for business users, and feeds for other systems.

Environment: Cognos v10.2.1, Talend, PLSQL, Autosys, HP Asset Management, Oracle, Mongo DB, SQL Developer, SVN
2018 - 2020

Data Science Graduate Certificate in Data Science and Machine Learning

Harvard Extension School - Boston

2002 - 2007

Bachelor of Engineering Degree in Computer Science

BMSCE - Bangalore, India

SEPTEMBER 2018 - PRESENT

Data Science Certificate

Harvard

JANUARY 2008 - PRESENT

SQL/PLSQL Certificate

Oracle

Libraries/APIs

Social Media APIs

Tools

IBM Cognos, Tableau, Crystal Reports, TFS, Sisense, Erwin, Microsoft Power BI, Informatica ETL, GitHub, Talend ETL, Autosys, Jira

Languages

SQL, R, Python, Java

Paradigms

Business Intelligence (BI), ETL, DevOps

Platforms

Talend, Oracle, Azure, Windows, Unix

Storage

SQL Server Reporting Services (SSRS), SQL Server DBA, PostgreSQL, Teradata, MongoDB, JSON, PL/SQL, Microsoft SQL Server, SQL Server Integration Services (SSIS)

Frameworks

.NET

Other

Data Modeling, Data Warehouse Design, SAP BusinessObjects (BO), Data Science, Informatica, Cognos 10, APIs, Business Objectives, TIBCO, SAP BusinessObjects Data Service (BODS), Machine Learning, Data Warehousing

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring