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