bo developer

  • running schedule jobs on Data Services management console.
  • interacted with client on daily status calls                
  • using SQL queries like inner joins,outer joins,DDL,DML commands to test at the database level
  • Involved in client meetings to understand the requirements
  • loading data using Sql Queries in interactive SQL

bo developer

  • Involved in Expense analytics  project regarding extract-transform-load & data migration.
  • developing workflows,Data flows based on specification using various stages in BODS
  • knowledge of data warehouse concepts 
  • knowledge of various transformations such as Table Comparision,History Preserving ,row generation ,pivot ,merge,case etc
  • extracting data from various sources such as CSV,tables from different database & server.
  • Implemented SCD Type-2 to preserve the history of data
  • scheduling of jobs through management console

bo developer/administrator

  • Environment:SAP BODS 4.2 sp11, IPS 4.2 sp6, LINUX, Sqlanywhere,Sybase ASE.
  • Role:BODS Developer/Administrator
  • Installing informaton Platform Services,Data Services.
  • knowledge of installing & configuring Sql anywhere,Sybase Ase datbase.
  • knowledge of Post-Installation Configuration such as                               1)creating user database.                                                                             2)Creating Local repositories in repository manager/Repoman(Linux)  3)configuring job server and associating repositories   4)registring repositories,creating users & assigning permissions in CMC.
  • extracting data from excel format and loading into tables
  • Data migration between different server & database