John Zamora

John Zamora Email and Phone Number

Clarity Business Analyst @ Williams-Sonoma, Inc.
san francisco, california, united states
John Zamora's Location
San Francisco, California, United States, United States
John Zamora's Contact Details
About John Zamora

Senior Business Analysis with more than 10 years experience with the Clarity PPM system. Expert in Business Objects; providing administration, report development with WEBI and DESKI, information and reports assisting senior and middle management with operational business decisions in emerging as well as established markets. - Banking & Finance - Health Care - Energy & Petroleum - High Tech and Internet

John Zamora's Current Company Details
Williams-Sonoma, Inc.

Williams-Sonoma, Inc.

View
Clarity Business Analyst
san francisco, california, united states
Employees:
12515
John Zamora Work Experience Details
  • Williams-Sonoma, Inc.
    Senior Clarity Business Analyst
    Williams-Sonoma, Inc. Dec 2012 - Present
    San Francisco, Ca
    • Help plan and assist major upgrade of the Project & Portfolio Management system from version 12.1 to version 13.1, and version 13.1 to version 14.2 On Demand including, implementation of new functionality and features.• Managed Clarity reporting system comprised of Business Objects and Crystal Reports• Used Oracle SQL to analyze and deliver data to key business partners.• Helped support the Clarity user system, including teaching and documentation creation.• Performed key Clarity month end processes for users and IT Finance departments.• Help implement and troubleshoot new Clarity Business Analytics and EssBase data and reporting solutions.
  • Wells Fargo Bank
    Business Intelligence Consultant
    Wells Fargo Bank Apr 2006 - May 2012
    Internet Services Group - San Francisco, Ca
    • Created and modified Business Objects reports with both Business Objects WEBI and DESKI tools for ISG customers using the Clarity Project Portfolio Management System, SQL Server database. Worked closely with ISG customers as a data analyst to develop report requirements, plans, and report deployment that resulted in better and more timely project management information.• Supported Clarity Project & Portfolio Management system which insured system availability 24 by 7. • Performed monthly financial closing the Clarity PPM system providing critical project financial data to senior management.• Administered and configured the Clarity PPM system for ISG including: Created objects, sub-objects, portlets, pages, filters, security maintenance, upgrades, etc. in order to provide customized information as required by project and resource managers.• Managed and Implemented Business Objects XI Upgrade projects for 8 different server environments which provided the latest supported software required by the vendor.• Served as Business Objects Administrator for 8 different servers. Maintained users, folders, report deployment, security, and scheduling.• Scheduled and managed CRUG (Clarity Report User Group) for Business Objects which kept the Business Objects user base informed and involved.• Created and updated report Business Objects SharePoint documentation and lists for better user support.• Managed report writers for Clarity within ISG which kept projects on schedule.
  • Ucsf School Of Dentistry
    Crystal Reports Developer
    Ucsf School Of Dentistry Aug 2002 - Jun 2006
    San Francisco, Ca
    • Re-created reports from existing system using Crystal Reports and an Oracle database. Reports comprised billings and costs by office, provider (dentist), student, and procedures. Created DB views for many of the reports. Installed and implemented Crystal Enterprise. Published and scheduled Crystal Reports using Crystal Enterprise which resulted in student tracking and performance.
  • John Muir Mt. Diablo Health Network
    Crystal Reports Developer
    John Muir Mt. Diablo Health Network May 2004 - Dec 2005
    Walnut Creek, Ca
    • Worked with Crystal Reports and Crystal Enterprise to re-write 200-300 reports for Oracle 9.0 Facets Medical Claim tracking system. Used Oracle tools such as Toad to create Oracle views for reports. Worked with both Operations and ITS departments on this 12 month project. This was part of a project to convert from an old Claim tracking system to a new Claims Tracking System (Facets) providing timely reports without lost of information or billing due dates.
  • Barclays Global Investors
    Crystal Reports Developer
    Barclays Global Investors Jul 2002 - Jul 2005
    San Francisco, Ca
    • Using Crystal Reports, created numerous sales tracking and performance reports using Sybase database and stored procedures. Reports were then published to Crystal Enterprise. Assisted another department creating forms using Crystal Reports and XML database for printing and distributing various Fund Forms resulting in better and more timely marketing documents for existing and potential customers.
  • Chevron
    Crystal Reports Developer
    Chevron Apr 2002 - Dec 2004
    San Ramon, Ca
    • Worked with Health and Employee Safety (HES) Department and developed various HES reports using Crystal Reports, SQL Server database and stored procedures. Reports constituted statistical analysis by division and business units. YTD vs. PYTD, quarterly, monthly, rolling 12 months with charts and graphs. This provided risk managers the necessary information to management to mitigate accidents and rate increases.
  • Arthrocare Corporation
    Crystal Reports Developer
    Arthrocare Corporation Jul 2001 - Sep 2002
    San Jose, Ca
    • Used Crystal Reports to create territorial sales reports. Other reports consisted of product analysis, trend reports, and reports by sales rep. Installed and configured Crystal Enterprise. Assisted and trained staff on how to schedule, implement, and distribute reports using Crystal Enterprise. Helped staff convert Progress data to Hyperion system providing better and more timely sales information for regional sales teams.

John Zamora Skills

Ca Clarity Crystal Reports Oracle Microsoft Sql Server Databases Visio Sql Access Management Business Object Edit Plus Toad 9.0 Sharepoint Designer Xml Spy Stored Procedures Business Intelligence Snagit Sharepoint Project Management Business Analysis Software Documentation Sdlc Business Objects Xml Integration Sybase Toad Ms Access Sql Server Business Objects Webi Business Objects Deski Business Objects Xcelsius Planview Project Portfolio Management Altova Xmlspy Xml Editor Adobe Dreamweaver

John Zamora Education Details

Frequently Asked Questions about John Zamora

What company does John Zamora work for?

John Zamora works for Williams-Sonoma, Inc.

What is John Zamora's role at the current company?

John Zamora's current role is Clarity Business Analyst.

What is John Zamora's email address?

John Zamora's email address is jo****@****ell.net

What schools did John Zamora attend?

John Zamora attended California State University, Stanislaus, Stanislaus State University.

What skills is John Zamora known for?

John Zamora has skills like Ca Clarity, Crystal Reports, Oracle, Microsoft Sql Server, Databases, Visio, Sql, Access, Management, Business Object, Edit Plus, Toad 9.0.

Who are John Zamora's colleagues?

John Zamora's colleagues are Nathan Burchett, Rol Eelan, Roel Belleza, Katherine Digiacomo, Subbu G., Kaitlyn Bellafato, Tameka Tyler.

Not the John Zamora you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.