Mohan Bn Email & Phone Number

Bangalore, Karnataka, India

Leading Enterprise Reporting team serving data analytics needs of Landmark Group across different lines of business (Lifestyle/ Max/ Easybuy/ Homecentre/ Spar Hypermarkets/ Landmark Online India Private Limited)Environment: SQL/PLSQL with Oracle 11gR4 database, Data-modelling tool - Erwin, ETL tool - Informatica Powercenter 9.5 HF2, DB - Exadata, Appworx, Reporting tools - OBIEE 12c, Power BI, Oracle Analytics DesktopManagerial responsibilities:- Involved in regular connects… Show more Leading Enterprise Reporting team serving data analytics needs of Landmark Group across different lines of business (Lifestyle/ Max/ Easybuy/ Homecentre/ Spar Hypermarkets/ Landmark Online India Private Limited)Environment: SQL/PLSQL with Oracle 11gR4 database, Data-modelling tool - Erwin, ETL tool - Informatica Powercenter 9.5 HF2, DB - Exadata, Appworx, Reporting tools - OBIEE 12c, Power BI, Oracle Analytics DesktopManagerial responsibilities:- Involved in regular connects with senior business leaders to discuss upcoming business initiatives and be ready with analytical reports and automations to help drive new business processes and analyze respective results- Leading enterprise wide technological activities like reclassification of complete merchandise hierarchy, tool upgrades, security implementations by coordinating with cross-functional business and technological teamsTechnical responsibilities:- Implementation of data analytics projects using customized Datawarehouse solution sourcing all BI reports- Translating functional business requirements of retail & online domains into DW architecture using ETL/BI code- Developing dashboards/visualizations for senior leadership teams to help strategic long-term business decisionsBusiness partnering responsibilities:- Enabling automations to eliminate mundane manual work saving man-hours and delivering faster/better results- Serving operational data needs of all strata of stakeholders from stores/warehouses to various corporate functions (finance, planning, SCM, marketing, etc.,) to improve operational efficiency and better planning- Driving innovative initiatives to enhance business users experience, applying statistical practices to rationalize and represent raw data as meaningful business KPIs to augment better, faster and effective decision making Show less

Bangalore

- Market outreach to introduce the concept of IU clubs - public speaking clubs and leadership in different schools- Discussions and negotiations with the school management to make IU clubs an intricate part of the school curriculum- Presenting and marketing the IU clubs in front of students and their parents- SMS marketing, follow ups on calls and finally closing the sales- Planning the syllabus of the IU clubs for the academic year - Preparing the agenda of the sessions and… Show more - Market outreach to introduce the concept of IU clubs - public speaking clubs and leadership in different schools- Discussions and negotiations with the school management to make IU clubs an intricate part of the school curriculum- Presenting and marketing the IU clubs in front of students and their parents- SMS marketing, follow ups on calls and finally closing the sales- Planning the syllabus of the IU clubs for the academic year - Preparing the agenda of the sessions and the take away tasks for children which shall assist any trainer to take up the sessions- Taking up all the sessions myself barring very few exceptions in case of emergency- Conduction of competitions in each school and then hosting inter-school competition for the winners with the IU clubs convention- Provide feedback about students to parents and get the feedback of the development in the students from their parentsOther responsibilities:-- Associate editor for an online magazine - www.iuemag.com- End-to-end operations of launch of debut season of i3 - influence, inspire and impact in Hyderabad (3 months of sales and marketing followed 3 months of program of organizing conferences for students from different colleges with renowned entrepreneurs and leaders from diverse backgrounds) Show less

Bangalore

Worked in Oracle Business Intelligence Analytics (OBIA) domain contributing in product development of 2 releases of Manufacturing Analytics project.1. Manufacturing Analytics for Oracle EBS – OBIA 7964 Project detail: Oracle Manufacturing Analytics for EBS, part of the Oracle Business Intelligence Applications product line, delivers deep insight into manufacturing execution, production costing, inventory builds, and production quality.Environment: Informatica Powercenter… Show more Worked in Oracle Business Intelligence Analytics (OBIA) domain contributing in product development of 2 releases of Manufacturing Analytics project.1. Manufacturing Analytics for Oracle EBS – OBIA 7964 Project detail: Oracle Manufacturing Analytics for EBS, part of the Oracle Business Intelligence Applications product line, delivers deep insight into manufacturing execution, production costing, inventory builds, and production quality.Environment: Informatica Powercenter 9.x, DAC, OBIEE 10.x, Oracle 10g DB Roles and Responsibility: - Actively involved in development of the product starting from Requirement gathering to QA stage- Creation of star schemas using multidimensional data modelling, coding of ETL mappings on Informatica tool, usage of DAC to load the Data Warehouse- Responsible for tracking the change requests and approval process, triaging the bugs, and bug approval process.- Responsible for development of the RPD from the scratch creating the Physical, BMM and Presentation Layers for all functional areas of MFG- Responsible for delivering the Functional Areas for Resource Usage, Resource Utilization, Material usage, Production Planning (ASCP/MRP) and Performance as part of MFG Analytics Product2. Manufacturing Analytics for Oracle EBS – OBIA 11.1.1.7.1Project detail: Oracle Manufacturing Analytics for EBS, part of the Oracle Business Intelligence Applications product line, delivers deep insight into manufacturing execution, production costing, inventory builds, and production quality.Environment: ODI 11g, OBIEE 11g, Oracle 11g databaseRoles and Responsibility: - Actively involved in development of the product starting from Requirement gathering to QA stage- Responsible for uptake of the Multi currency and Multi language support for OBIA Manufacturing Analytics- Responsible for delivering the ODI design of Resource Usage, Resource utilization and material usage functional areas as part of Manufacturing Analytics Product Show less

Bachelor’S Degree, Electronics And Communications Engineering, 86.66%

Activities and Societies: -Took part in many robotics projects -Co-Founded a startup called ROBOCRAFTZ and conducted technical seminars.

High School

Activities and Societies: debate, science exhibitions, drama, dance, sports - Very good in academics and been on top of the rank charts.