Sathya is available for hire
Hire SathyaSathya 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
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
Experience
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
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).
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
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
Environment: Cognos v10.2.1, Talend, PLSQL, Autosys, HP Asset Management, Oracle, Mongo DB, SQL Developer, SVN
Education
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
Certifications
SEPTEMBER 2018 - PRESENT
Data Science Certificate
Harvard
JANUARY 2008 - PRESENT
SQL/PLSQL Certificate
Oracle
Skills
Libraries/APIs
Social Media APIs
Tools
IBM Cognos, Tableau, Crystal Reports, TFS, Sisense, Erwin Data, 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