Being part of Kemet’s BI team, worked on Data Stage Jobs Migration to SSIS which loads data between Oracle sources, few of the jobs are Part Plant Report, EBARS, Unreleased MES to ASCP, KMS Part Plant Usage, Cognos Pegging & Rollout Reports. Data the stage jobs which were running through Orsyp scheduler changed to SQL Server Agent jobs. Supporting existing Oracle Datawarehouse, which runs Nightly jobs that loads data from sources like ETBF and Oracle systems. Fixing reports issues which is connected through Vertica DB, parallelly working on other enhancements like OCI migration testing.

Technologies:

Worked on Support & Development Projects like Markets Data Warehouse (MDW), BAU MI Reporting, which includes LBG’s Data Staging, Data Warehouse with Cubes & Dynamic reports used by various teams.

MDW is data warehouse which provides management information to the business instantly and in a self-service manner. It is also to be the authority and central source of MI reporting.

 Reconciliations of expected transactions will be performed after each successful MDW ETL against source systems and include reports to identify any missing records in the MDW data store, the results are used to instigate further investigation with the respective Group IT System Support teams and Markets Operations Processing teams.

BAU MI Reporting is a collection of SSIS packages and tables that contains details of LBG warehousing and reporting data. The contents are updated daily Monday-Friday from the Group Data Warehouse. Other data is extracted from CrisP(Oracle db) and MDW(Deals)

Being part of Kemet’s BI team, worked on Data Stage Jobs Migration to SSIS which loads data between Oracle sources, few of the jobs are Part Plant Report, EBARS, Unreleased MES to ASCP, KMS Part Plant Usage, Cognos Pegging & Rollout Reports. Data the stage jobs which were running through Orsyp scheduler changed to SQL Server Agent jobs. Supporting existing Oracle Datawarehouse, which runs Nightly jobs that loads data from sources like ETBF and Oracle systems. Fixing reports issues which is connected through Vertica DB, parallelly working on other enhancements like OCI migration testing.

It’s an Australian Telecom based Business Intelligence & Finance department, I had worked for transition project from internal resource to vendors along with support and maintenance of demand breakthrough server which contains ETL jobs, Tabular Cubes & SharePoint sites