Client: British American Tobacco• As a data modeler, design Source to Target (STM) mapping documents in accordance with business requirements. Working on different use cases, for instance, Waste Management System, Cost Maintenance Report and Spare Parts Automation.• The BAT legacy system initially utilized a manual process for manufacturing data reporting across 40+ factories. Each factory downloaded, formatted, and uploaded data to SharePoint monthly, causing delays in data access. We automated the entire process, including data collection, key metric calculations, and Power BI dashboard connectivity, eliminating delays and enhancing efficiency.• Working in the process of manufacturing unit, where we calculated the waste % for different countries like Hungary, Italy, Sweden & Pakistan, using calculation and the logic as per business requirements.• Validating data for different objects in the Dev environment and then deploy into the higher environment (Dev -> Stage -> Test -> Prod) using Azure DevOps CI/CD deployment.• As per STM document create different views and tables on STM different layers in the snowflake environment.• From a performance perspective, certain intricate views in the integration layer are experiencing prolonged execution times, causing performance delays. To address this, we devised a DAG in Power Apps, scheduled the job using crontab, and ultimately triggered the job on Apache Airflow.• Developing Dashboards and reports on power bi for different use casesClient: Sciensus Health Care – UK• Translating Qlik view Script into spark SQL using Databricks and led the migration of dashboards from QlikView to Power BI.• Writing SQL queries on Azure Databricks using python notebook.• Data Reconciliation for data integrity on Power BI Dashboard. Involvement in Project Planning Phase and tracking Project Progress.• Developing Dashboards for business users in Power BI

OBIA and OBIEE:• Reporting to the Deputy manager to co-ordinate the project status and communicate with client to gather the requirements and provide the solution.• Setup of complete Oracle BI environment on Linux and Windows platforms.• Implementation of Oracle BI Applications (BIApps) with customization.• Design and development of custom warehouse on OBIEE using ODI.o Gather business requirements from business users and functional consultants.o Preparing the design documentso Implementation of data warehouse.o Performance tuning of Analytics/Reports.• ETL Architecture and Designo Defining ETL strategy – keeping in consideration the architecture of data warehouse and volume of datao Data migration through SQL routines and ETL tools.o Data validation through test scripts.o Performance tuning of ETL through modification in SQL scripts, hints, indexes, table partitioning, optimized database parameters etc.• Assign tasks to team and technically help them in execution of tasks.• Provide technical help to our other BI teams especially in setup of BI environments, execution of ETL and performance tuning.Power BI:•Installed and upgrade of Power BI Desktop.•Create Interactive Report and Dashboard for Mobile App.•Develop reports in power bi desktop and publish it into the power bi service.•Worked on import and direct Query data into power BI•Knowledge on Power BI gateway to schedule daily job to refresh data.•Involved in designing of data modelling using Star and Snow Flake schemas.•Created various measures and columns using DAX Queries.•Use Power Query to get data, clean, shape and transform your data•Use Power Pivot to Model Data (Relationship),calculate new columns and create measures.•Content packs or Workspace to share Power BI objects, such as reports, datasets, or dashboards with individuals within organization to reuse them.•Row level security through Manage Roles in Power BI desktop.•Get Data from Excel, Oracle and MySql data sorces.

OBIA and OBIEE:• Reporting to the Deputy manager to co-ordinate the project status and communicate with client to gather the requirements and provide the solution.• Setup of complete Oracle BI environment on Linux and Windows platforms.• Implementation of Oracle BI Applications (BIApps) with customization.• Design and development of custom warehouse on OBIEE using ODI.o Gather business requirements from business users and functional consultants.o Preparing the design documentso Implementation of data warehouse.o Performance tuning of Analytics/Reports.• ETL Architecture and Designo Defining ETL strategy – keeping in consideration the architecture of data warehouse and volume of datao Data migration through SQL routines and ETL tools.o Data validation through test scripts.o Performance tuning of ETL through modification in SQL scripts, hints, indexes, table partitioning, optimized database parameters etc.• Assign tasks to team and technically help them in execution of tasks.• Provide technical help to our other BI teams especially in setup of BI environments, execution of ETL and performance tuning.Power BI:•Installed and upgrade of Power BI Desktop.•Create Interactive Report and Dashboard for Mobile App.•Develop reports in power bi desktop and publish it into the power bi service.•Worked on import and direct Query data into power BI•Knowledge on Power BI gateway to schedule daily job to refresh data.•Involved in designing of data modelling using Star and Snow Flake schemas.•Created various measures and columns using DAX Queries.•Use Power Query to get data, clean, shape and transform your data•Use Power Pivot to Model Data (Relationship),calculate new columns and create measures.•Content packs or Workspace to share Power BI objects, such as reports, datasets, or dashboards with individuals within organization to reuse them.•Row level security through Manage Roles in Power BI desktop.•Get Data from Excel, Oracle and MySql data sorces.

• Creating Analysis, KPI’s and Dashboards using Oracle B.I Answers• Design and develop solution regarding ETL using Oracle Data Integrator• Creation of ODI objects like Interfaces, Scenarios, Variables, Procedures, Packages• Working with Load Plans• Monitor and maintain hourly, daily and weekly ETL jobs• Troubleshooting and fixing of existing ETL job issues• Created Oracle Tables, Views, Constraints and Procedures• Data warehousing Development and Implementation• Segregate data in form of Fact and Dimensions• Creating logical and Physical model• Data Mart logical and physical schemas• Data Modeling and Stars schema• Dashboard and analysis security and system management• Multi User Development Environment (MUD) administration tool• Using Oracle BI Administration tool for Data Modeling e.g. Creating Star and Snow flake schemes• Backup and restore Repository (rpd.) • Backup and restore BI catalog using Oracle Catalog Manager• Creating users, groups and roles in web logic• Creating Users, Groups and Rules through weblogic Enterprise Manager and ConsoleTools:• Oracle Business Intelligence Enterprise Edition 10g/11g• BI Administration tool• Oracle 10/11g Database• Oracle Data Inegrator (ODI)• PLSQL Developer• Weblogic

• Creating Analysis, KPI’s and Dashboards using Oracle B.I Answers• Design and develop solution regarding ETL using Oracle Data Integrator• Creation of ODI objects like Interfaces, Scenarios, Variables, Procedures, Packages• Working with Load Plans• Monitor and maintain hourly, daily and weekly ETL jobs• Troubleshooting and fixing of existing ETL job issues• Created Oracle Tables, Views, Constraints and Procedures• Data warehousing Development and Implementation• Segregate data in form of Fact and Dimensions• Creating logical and Physical model• Data Mart logical and physical schemas• Data Modeling and Stars schema• Dashboard and analysis security and system management• Multi User Development Environment (MUD) administration tool• Using Oracle BI Administration tool for Data Modeling e.g. Creating Star and Snow flake schemes• Backup and restore Repository (rpd.) • Backup and restore BI catalog using Oracle Catalog Manager• Creating users, groups and roles in web logic• Creating Users, Groups and Rules through weblogic Enterprise Manager and ConsoleTools:• Oracle Business Intelligence Enterprise Edition 10g/11g• BI Administration tool• Oracle 10/11g Database• Oracle Data Inegrator (ODI)• PLSQL Developer• Weblogic

Responsibilities:• Experience in content management system, i.e, Wordpress.• Using bootstrap (css framework) creating static website.• Creating blank theme of WordPress.• Creating static website with HTML & CSS.• Web pages is designed in a Photoshop Document (PSD) and then converted to code (using HTML, CSS, and JavaScript)• Creating Responsive site for mobile and tablet users.• Using PHP creating dynamic website.• Using PHP with MYSQL.• Debugging.• XAMPP/WAMP server.