Michael Friessnig

Application Expertise: Oracle Applications,Peoplesoft,SAP,Epic-Clarity

Business Objects Expertise: XI R2-R4, DeskI, Crystal Reports,WebIntelligence,

Database Expertise: Oracle,SQL Server

Experience

Experience

Sep 2014 to April 2021

Momentum for Mental Health

San Jose, CA

Datawarehouse Analyst

Developed Cycle Time reporting application. Obtained requirements, designed table structure, developed large SQL batch program, and created reports. Reports depicted average number of days between admission and first bill and admission last bill.

Developed provider productivity reporting systems. Obtained requirements, designed table structure, developed large SQL batch program, and created reports.

Integrated external General Ledeger data with Avatar Accountrs receivable data for reconciliation purposes.

Integrated county billing data with in house billing data for reconciliation purposes.

Developed numerous queries and reports across all functional areas.

Worked with data warehouse team to design high performance data structures to facilitate fast query performance against large data volumes

Ensured data loaded into the data warehouse was accurate and timely.

Provided Organization wide support for Crystal Server, Support included maintenance of security, security configuration, performance trouble-shooting, and feature resolution.

Jul 2008 to August 2014

Sutter Health

Sunnyvale, CA

Senior Datawarehouse Analyst

Lead upgrade to Business Objects 4. Installed Software, configured server, migrated content, provided training.

Responsible for integrating SRC budget system with Lawson general ledger.

Responsible for Inegrating IDX billing data with Epic Billing data for migration puposes/

Provided Organization wide support for BusinessObjects’ XI Administration,WebIntelligence, and Designer. Support included maintenance of security, security configuration, performance trouble-shooting, and feature resolution.

Created Universe and Report development standards.

Project Manager for regional reporting consolidation project. Responsibilities included obtaining specifications, scheduling tasks, and allocating resources. Delivered standard Profit and Loss statements across the organization.

Designed and developed numerous reports using Crystal reports.

Developed numerous Universes against Lawson GL,AP,PO, HR. Also developed Universes against Epic-Clarity.

Participated on Epic-Clarity datawarehouse project.

Worked with data warehouse team to design high performance data structures to facilitate fast query performance against large data volumes

Feb 2006 to Jul 2008

Cisco Systems

San Jose, CA

Senior Data Warehouse Analyst

Business Intelligence Lead for Service Analytics. Worked closely with business on analysis and dashboard development using Siebel Analytics for Service business intelligence solutions. Partnered with BI architecture team and data team very closely

Provided Oracle Applications expertise in the design and development of numerous data marts for Oracle Applications.

Lead QA Team in testing and validating large Dashboard application.

Guided the Service organization in matching business requirements with BI technology.

Generated numerous reports against Oracle Applications using BusinessObjects.

Aug 2003 to Jan 2006

Hitachi Data Systems

Aug 1996 to Jul 2002

SAP BusinessObjects

San Jose, CA

Technical Analyst

Primary responsibility was to develop BusinessObjects’ Universes and Reports against packaged OLTP Applications: Oracle Applications, SAP, Peoplesoft, Siebel and Clarify. Designed and developed Universes and Reports for all major applications (AP,GL,Inventory, Order Entry,MRP, Projects,Support, Marketing) for each of these vendors. The development of such solutions required extensive knowledge of business processes, applications software, and relational databases.

In addition to building solutions for Packaged OLTP systems, I also built solutions for all major ERP and CRM data warehouse systems: Peoplesoft EPM, SAP BW, and Siebel DW.

Worked with technical writer to create documentation for Universe and Reports. The finalized documentation was then published and shipped along with the Universes and Reports to customers worldwide.

Performed consulting function. Had numerous consulting assignments to customize Universe and Reports per customer specifications.

Made numerous sales presentations to prospective customers.

Obtained through understanding of all BusinessObjects products.

Education:

Bachelors Business Administration

Specialization in Accounting and Computer Science

Richard Stockton College

Pomona, New Jersey

Military Experience: United States Navy

Contact this candidate