JANE M. MWAMBU

Experience

• 

  Sisters of Charity of New York

  Nov 2007 - Dec 2011

  OBIEE Business Analyst

  Participated in the preparation of quarterly investment performance Reports and Dashboards required by the Pension Advisory CommitteeCreated Capital Expenditure analysis reports as part of the yearend audit activitiesCreated trial balances for all fully reconciled fundsPerformed reconciliation of operating and cash management bank accounts on a daily basis Prepared monthly expense budget reports for the General FundPerformed analyses of budget line itemsPrepared monthly and quarterly trial balances, journal entries and disbursement journalsMonitored Investment Account by posting dividend and interest schedules for the General Fund and Charitable Trust InvestmentsCreated monthly statements for House Account for over 100 sisters’ residencesIn charge of handling check requests from various departments and individual sistersPerformed variance analyses of budget line itemsPrepared monthly and quarterly trial balances, journal entries and disbursement journalsEnsured that the fair market value for each investment account was recorded in the Peachtree Accounting System at the end of each quarterMaintained correspondence as well as investment activity for the alternative investment accounts Show less

• 

  Medical Center of McKinney

  Dec 2011 - Sept 2012

  OBIEE Developer

  Created and customized Oracle BI metadata in the analytics repository with OBIEE Administration ToolBuilt the Physical Layer, Business Model and Mapping Layer, Presentation Layer of a Repository by using Star Schemas. Experience in migrating the repository and web catalog from development to production environment.Developed and maintain BI Reports, Dashboards, Web catalog, Answers Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group. Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.Participates in weekly meetings with the business users to figure out what was working and what needed changes to be done. Show less

• 

  Bank of America

  Sept 2012 - Dec 2013

  OBIEE Developer

  Interacting with business analysts and end users to gather requirements and prepare functional and technical documents.Created and customized Oracle BI metadata in the analytics repository designing star schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool with OBIEE Administration Tool. Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group. Creates various analytic reports using Global and Local filters Participates in weekly meetings with the business users to figure out what was working and what needed changes to be done.Training of end users and analyst, helping them to understand the reports, how to navigate the reports, and understand the report requirements.Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables.Experience in creating executive reports with BI Publisher integrated with OBIEE.Created and granted privileges for the users using Analytics Catalog Manager Show less

• 

  St. Jude Medical

  Jan 2014 - Dec 2014

  Certified OBIEE Developer

  Meet with business representatives, business analysts and end users to understand the business models and functionality. Strong understanding of data modeling, dimensional modeling and designing Star schemas, Snowflake schemas and Physical and Logical data modeling. Expertise in OBIEE Repository development, Creating Dashboards, Reports and BI Publisher in OBIEE projects. Work extensively on OBIEE Administration Tool, Oracle BI Server, Answers, Dashboards, BI Publisher and Delivers. Expertise in Building Metadata Model (RPD), Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards and BI Publisher. BI answers- develop many reports, dashboards and BI Publisher in different subject areas with different analytical views (narrative, chart view, graphs, pivot table, column selector, view selector with drill down capacity) Development include creation of connection pools, setting alias tables, BMM, applying business logic, dimensional hierarch modeling, time series modeling, aggregation, creating logical column, and calculation wizards Experience in configuring Interactive Dashboards and BI Publisher with drill-down capabilities using global and local Filters, Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports, Publisher). Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data. Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions. Show less

• 

  Legacy At Home

  Jan 2015 - now

  Certified Scrum Master

  Facilitate daily scrums, sprint reviews, sprint planning, and sprint retrospective meetings.Support the Product Owner and maintaining product backlog and working with the team.Identify and remove team impediments to enhance productivity and efficiency.Effectively track team’s progress, including burn down, velocity and release forecasting in Jira.Work with other Scrum Masters to prepare for and facilitate potentially shippable increment planning sessions.Expertly promote continuous improvement and help teams increase productivity and foster innovation.Maintained task board and produced daily burndown charts. Show less