We provide IT Staff Augmentation Services!

K12 Manager, Data Warehouse And Enterprise Reporting Resume

0/5 (Submit Your Rating)

SUMMARY:

  • Over 22 years of experience in in the areas of Data Analytics, Business Intelligence, Enterprise Reporting, Data Warehouse, Business Process Improvement and Operations Management.
  • Extensive management experience in leading diverse global (onsite, onshore, offshore and remote) development and operations teams.
  • Experienced in managing cross - functional teams, performing in-depth data analysis, generating complex reports, and completing technical projects.
  • Highly adept in maintaining positive communications and rapport with business stakeholders, customers, co-workers and vendors
  • Experience in multiple areas of Enterprise Data Management, including business requirements gathering, analysis, design, development, testing,, implementation and documentation.
  • Extensive experience in managing full life cycle implementation across multiple enterprise reporting platforms (Power BI, OBIEE, SQL Server Reports, Hyperion, Tableau and ProCube) and Customer Experience (CX) applications including Siebel, Salesforce and Oracle Enterprise Business Applications.
  • Demonstrated attention to detail and possess strong problem solving and analytical skills.
  • Demonstrated ability to define and map project scope and provide direction to developers and production support analysts to align technology solutions with business requirements.

PROFESSIONAL EXPERIENCE:

Confidential

K12 Manager, Data Warehouse and Enterprise Reporting

Responsibilities:

  • Led global developments teams to develop key business dashboards for Business Management and Operations to help with daily operations and funding to Schools.
  • Revamped and redesigned Financial Metrics dashboard for SEC filings of Quarterly and Annual Enrollment Reporting across three key business lines for K12.
  • Led the implementation efforts of School Staff Data Management (SSDM) data mart to capture all School Staff from 12 HR sources (UltiPro, Insperity, Randstad, Board School excel files) to support data science needs.
  • Multiple dashboards were built to serve Human Resources, Accounting, School Ops and Exception reports to display discrepancies between HR and SIS systems.
  • Led the redesign of Billing dashboards and migration from legacy sources to ODI and OBIEE platforms. The dashboards are used for bi- weekly billing and invoicing cycles by multiple business lines within billing team.
  • Implemented various enterprise data feeds to Vendor systems such as Naviance, Renaissance, AGORA, Blackboard connect systems to support funding to schools.
  • Implemented Network Operations dashboards for daily tracking of JIRA tickets, Service Connect requests by Corporate users, Teachers and Student views.

Confidential

K12Sr. BI Analyst, Enterprise Reporting

Responsibilities:

  • Implemented Hyperion EPM for Financial Planning and Analysis (FP&A) and Accounting teams for Actual, forecasting and budgeting purposes.
  • Supported ProCube application for Financial Planning and Analysis team for forecasting and budgeting needs
  • Redesigned marketing dashboards to analyze accurate enrollment numbers of active schools for School years.
  • Designed and implemented Public Enrollment Metrics dashboard for Finance and Marketing departments to report school enrollments across various business lines of K12.
  • Implemented custom Executive Headcount dashboard by leveraging GL salary data for employees and contractor data from external source systems.
  • Implemented OBIEE 10g and BI Apps - Finance, Procurement and Spend Modules with Oracle EBS as source system, and created P&L Dashboards and reports including Department Expenses and Vendor Inquiry.

Confidential

Lead OBIEE Developer

Responsibilities:

  • Developed Confidential t outcome metrics - dashboards and reports to review Confidential t’s progress during time of staying and after discharge from the facility.
  • Implemented Oracle Business Intelligence Public Sector module including application configuration, design, data modeling, development of prototypes and implementation.
  • ETL implementation in Informatica PowerCenter 9.x - Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Star Schema modeling.
  • Implemented Oracle Business Intelligence Case Management Applications to support NICoE’s dashboard and reporting requirements.
  • Development in Siebel 8.1 version - Public Sector Case Management CRM system to support NICoE’s day to day Confidential t centric systems.

Confidential

Sr. Oracle Business Intelligence Developer

Responsibilities:

  • Led the development and operations teams in day to day tasks and helped in resolving conflicts in a team leadership role.
  • Developed Analytics dashboards for Procurement, Service and Logistics business units.
  • Full Life Cycle Implementation of OBIEE 10x and Siebel Analytics 7.8 and hands on experience with Relationship Management Warehouse (RMW) and Informatica Power Center.
  • Performed Siebel Analytics server and Data Warehouse administration tasks, including ETL tasks and Email notifications. Managed OLAP databases in development, test, staging and Production Environments
  • Expertise in developing the OBIEE repository with configuration using Administration tool - Physical, BMM and Presentation layers; Created logical and physical designs and star schemas for Analytics reporting.
  • Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers and custom Siebel Answers applications for the business units.

Confidential

WebMethods Senior Siebel Developer

Responsibilities:

  • Worked with VP of Corporate Marketing to define and implement Lead Generation process using Siebel Marketing and trained NA, AP and EMEA marketing teams.
  • Developed analytics dashboards on Prospects and Sales and Marketing campaigns.
  • Enhanced and re-vamped Opportunities module and implemented Forecasting module for Sales group.
  • Developed custom "Production Events" screens in Siebel for Professional Services group, migrated data from legacy Oracle databases, and trained end user groups and production support teams.
  • Implemented Field Service module for System Engineering group to dispatch activities based on service region.
  • Implemented Crystal Enterprise 8.5 with good understanding of architecture, resources.

Confidential

Siebel Developer

Responsibilities:

  • Involved in several point releases, minor enhancements, major functional enhancements and migration of release code from Development, Test and Production environments.
  • Involved in definition and implementation of application integration requirements between Siebel, Micromuse Netcool and custom flow through provisioning systems using Vitria connector and automator models.
  • Developed custom reports and enhanced Siebel vanilla reports using Actuate Reporting Suite 4.0

Confidential

Programmer Analyst

Responsibilities:

  • Worked with Siebel tools to implement functional enhancements for Package revenue and Room block details.
  • Designed reports using Actuate Developer Workbench, Siebel reports and Microsoft Access.
  • Performed Server and Application Administration tasks such as adding new views and responsibilities.
  • Worked as a Tier 3 production support analyst and provided documentation to Tier 2 support.

We'd love your feedback!