KEVIN RAZI

925-***-****

adu6q1@r.postjobfree.com

Highly Motivated Business Intelligence professional with experience in Data and Reports Development, Analysis and Project Management. Demonstrated leadership abilities with building teams and teamwork skills as well as ability to accomplish tasks under minimal direction and supervision. Proven history of utilizing strong analytical skills, attention to details, and hard work ethics to turn complex requirements into working systems.

TECHNICAL SKILLS

Business Intelligence tools: SAP Business Objects XIR4, OBIEE, MicroStrategy, SSRS

Administration: SAP Business Objects Central Management Console 4.3

Dashboards: Power BI, Tableau, Xcelsius

Databases: Oracle, SQL Server, SAP

Visual Basic for Applications, Macros (Excel, Access, Business Objects)

Windows Operating Systems (Windows 11)

Microsoft Office 365 (Word, Excel, Access, PowerPoint), Microsoft Project

Certified Scrum Master, JIRA

Epic Clarity, Hyperspace, Workbench Reporting

EDUCATION

SAN FRANCISCO STATE UNIVERSITY - San Francisco, CA January 2000

Bachelor of Science / Business Administration

WORK EXPERIENCE

RESTORATION HARDWARE, Corte Madera, CA January 2022 – December 2022 Senior Business Systems Analyst

Worked for RH Accounting, Financial Reporting and Analytics division to empower them with access and ability to analyze data from various source systems. Supported their Fiscal Close Process and enabled them to identify valuable insights within their financial statements, cost reduction, and identified process improvements that increased efficiency, and better management risks. Supported implementation, maintenance and administration of Analytics and other financial systems in partnership with internal resources. Gathered and documented user requirements for new and existing processes. Supported the accounting team in defining and documenting system processes, data flow, controls, and interfaces for financial analytics. Supported solution design by helping translate requirements into workable solutions. Worked with Project Managers and various technology teams within RH to source data as needed from various systems. Communicated with accounting and offshore development teams to design and test enhancements to ensure consistency and compliance with accounting principles as needed. Drafted clear and concise functional design documentation, testing plans and scripts to carry out QA and UAT as needed. Supported the end users through diagnostic procedures to resolve issues. Provided analytical and technical support to team members and end users through Fiscal period.

Environment: Oracle Analytics OBIEE, Excel, Jira, Google Sheet

HERMOSAZ, Oakland, CA March 2020 – December 2021 Business Analyst/Project Manager

Built and maintained working relationships with team members and vendors. Created and maintained project schedule and coordinated meetings with the owner for implementation of a reporting solution for his company. Provided technical guidance for Reporting solutions. Guided the team on best practices in Reports development. Worked with business to understand their needs, gathered requirements, refined user stories, prioritized development efforts, conducted and assisted with user acceptance testing. Provided specific expertise on applications, systems in identifying and resolving reporting problems. Created dashboards and user stories for analysis and helping the company to create more traffic to their site.

Environment: Microsoft Project, Excel, Jira, Smartsheet

BIOMARIN PHARMACEUTICAL INC., SAN RAFAEL, CA August 2018 – December 2019 Data Analyst

Supported the Commercial Operations Team, and their reports to be presented into the chief sales office, CEO and high-level stakeholders of the company. Assisted in activities not limited to extraction of data, data manipulation and cleaning of data, and continuous improvement of sales data reports to meet the changing needs of the business. Loaded ETL data and checked quality of dispense data on a periodic basis, ensuring that the reports are accurate, and troubleshot any issues with appropriate contacts and external partners. Monitored and adjusted scheduled jobs in Microsoft SQL Server as needed. Ran SQL queries to get the data into the data warehouse and prepared for reporting. Created new Power BI dispensed patient reports from old Tableau based reports. Streamlined processes regarding data flow and data quality to improve data accuracy, viability, and value. Maintained and administered the existing reporting environment, including scheduling, distribution, managing permissions, and updating reports. Worked on Salesforce Data Cleansing and data Extraction.

Environment: Power BI, Salesforce, Tableau, SQL Server 18

HEFFERNAN INSURANCE, WALNUT CREEK, CA March 2018 – July 2018 Business/Data Analyst

Performed research and analysis on underwriting, sales and operational data & metrics (i.e., pricing, territory, state analysis, production/activity drivers, etc.) Identified areas for change or improvement in the management, collection and use of data/information. Regularly monitored and analyzed loss trends by program including profitability, claims activity, and relays insights. Identified and assessed partnerships with data and BI firms to empower Company needs. Developed, updated and analyzed metrics and performed UAT used to determine production and growth. Supported L10 meetings with “Scorecard” information, updates, and recommendations. Owned all reports and pricing tools including developing, modifying, and distributing. Received and responded to all data inquiries across functional areas. Responsible for research, collection and analysis to support new program development. Participated on product development, processes, and underwriting strategies. Supported financial planning exercises for Company. Helped evaluate and execute technology strategies and development of systems for purpose of data ownership & portability, efficiency and customer experience.

Environment: Salesforce, Excel, Access, Tableau

SUTTER HEALTH, SACRAMENTO, CA April 2015 – December 2017 Business Intelligence/Applications Analyst

Worked for Clinical users and Management of Administration, Admitting, Emergency, and Cardiovascular Departments to collect and gather report specifications, develop, analyze, test and validate reports. Developed reports using SQL Server 2008, Crystal Reports, and Reporting Workbench. Extracted data from multiple data sources such as Lawson, Remedy, and Epic Clarity. Worked on patient encounters, orders, medications, procedures, flow sheets, diagnosis, and admissions, discharges, and transfers. Created Epic and Workbench reporting for Hospital staff and Physicians including Cogito, Inpatient, HIM, ADT, Cadence, ASAP, Radiant, Stork, Tapestry, and Optime modules. Supported Administration with ad hoc data loads and financial reporting from EPSI Finance Team. Identified and recommended changes to existing standard enterprise methodologies for reporting. Installed and tested new SAP Business Objects Enterprise platform for future Universe, Webi and dashboards users. Modified Workbench reports, templates, columns, and criteria to meet customer specifications.

Environment: SQL Server 2008 R2, Crystal Reports 2011, Epic Clarity, Hyperspace, SAP Business Objects 4.1

GETINSURED, MOUNTAIN VIEW, CA March 2014 – December 2014

Senior Business Analyst - Reporting

Collaborated with business process owners, product managers and external client subject matter experts to define, develop, configure, test, train and adopt a health insurance exchange. Created Business and Technical Requirement Documents and for company Health care product reporting based on Micro strategy. Created and modified reports in MicroStrategy. Conducted JAD sessions with State Exchange SMEs and clients to define future requirements and reports. Created and submitted reports and summaries of Affordable Act implementation numbers for New Mexico and Mississippi Exchange products. Worked with Management group to find unique identifiers for private insurance referrals monthly reports submitted to GetInsured for analysis.

Environment: MicroStrategy, Oracle 11, Excel 2013, SQL, Tableau

ADOBE SYSTEMS Inc., SAN JOSE, CA March 2013 – March 2014

Senior Business Analyst

Assisted Human Resources ERC Reporting & Analytics team to develop Webi Ad hoc reports and dashboards. Documented and obtained reporting and analysis needs or business requirements. Developed and presented reports or metrics extracted from SAP BW and Net weaver to support day-to-day business decisions. Analyzed and manipulated data, track trends and make recommendations on any required changes. Created and presented BMC reporting metrics for HR Executives. Evaluated, analyzed, and recommended improvements or changes to the current process. Supported the development of new data warehousing and BI solutions such as Jasper software and acted as a liaison between HR and IT to provide support services to business intelligence group.

Environment: Webi 3.1, SAP BW3.x, SAP Net Weaver, Excel 2010, SQL, Tableau

CISCO SYSTEMS INC., SAN JOSE, CA September 2012 – February 2013

Senior Business Analyst

Worked for Supply Chain GMO group to develop Ad hoc reporting, dashboards, and data validation. Managed critical data issues, defects, and action plan with Cisco Supply Chain Business and IT teams. Participated in workshops for BI Transformation project and discussed queries issues and new enhancements modifications for ORION MFG universe. Created Business Requirement Document (BRD) for new enhancement proposal from Biz Sync up with IT team to get it implemented in Universe and performed UAT testing and provided business sign off to IT teams. Developed SQL queries on Teradata during Business UAT testing. Generated, modified, and analyzed reports on Webi and OBIEE for end users. Created process flows, test scripts, functional and technical specifications. Assisted with Business UAT testing of new features in ORION bug fixes and other MFG universes.

Environment: BO 4.0, Webi 4.0, Information Design Tool 4.0, Oracle 10g, SQL

SUGARSYNC, SAN MATEO, CA December 2011 – August 2012

Senior Business Objects Consultant

Worked with a team to create a Data Warehouse for supporting information needs for Finance and Marketing groups. Participated in the design, development, testing, Implementation, installation, and documentation of SAP Business Objects BI Platform 4.0 and Data Services 4.0 on Development and Production servers. Created application security, users, and groups based on client’s requirements. Developed one universe from the Sugar Sync DW which was based on three data source systems. Created ten Webi reports for Marketing and Finance groups to be used for trending and metrics analysis of accounts, plans, users, referrals, subscriptions, invoices, and transactions data. Planned and performed Optimization at the report and universe level. Created and used aggregate tables for adding Cumulative data to the report.

Environment: BO 4.0, Webi 4.0, Information Design Tool 4.0, Data Services 4.0, CMC, MySQL 5.1

KAISER PERMANENTE, Oakland, CA August 2011 – November 2011

Senior Business Objects Developer

Served as a liaison between the business and the IT organization. Provided support to existing Supply Chain Management data warehouse users in the area of data analysis and universe modifications. Created Web Intelligence and Desktop Intelligence reports in the data information areas of Accounts payable, Purchase orders, Inventory, and Material Requests. Participated in user acceptance testing and final evaluation of system solution. Conducted gap analysis to document discrepancies between business requirements and system capabilities. Converted Deski documents to Webi and performed data cleansing for submission to data warehouse group.

Environment: BOXIR3, Web Intelligence, Deski, Designer, Oracle 10g

PACIFIC GAS & ELECTRIC, San Ramon, CA September 2010 - June 2011

Senior Business Objects Administrator/Developer

Supported Business Objects and Crystal Reports users with security, installation, migration and development of reports and universes. Supported universe modifications and report scheduling for users from Gas Leak, Mark & Locate, and Pole Test groups. Migrated Webi, Crystal reports, and universes between all environments (Sandbox, Training, Development, Test, QA, and Production). Installed, tested, and used Life Cycle Management to schedule repeated migrations. Implemented and ensured that security rights are correct in all environments. Coordinated and communicated planned upgrades, enhancements and server maintenance outages with Windows and Web Logic Teams. Implemented patches and upgrades to ensure BO systems are up to date. Installed Service packs and fix packs on servers and client machines. Modified security rights at the folder, universe and connection levels for all users. Worked with helpdesk to add single sign on users and managed enterprise accounts.

Environment: BOXIR3, Web Intelligence, Designer, Xcelsius, Crystal Reports, SAP BW, SQL Server, Oracle, MicroStrategy

POLYCOM INC., Pleasanton, CA March 2009 – May 2010

Senior Business Objects Administrator/Developer

Supported and maintained business objects and Crystal production environments and administered security settings for worldwide users. Assisted end users with writing Crystal, Business View, Webi and Ad hoc reports. Supported executives with daily and quarterly revenue flash reports as an insider. Defined and maintained Business Objects universes. Supported and maintained the Business Objects servers and application suite. Worked with Sales Out, Sales Comp., and HR groups to modify and develop existing or new reports. Worked with PeopleSoft DBAs to create change requests necessary for universe modification. Assisted with developing new OBIEE reports and comparing it to existing BO reports.

Environment: Business Objects XIR3, CMC, Crystal Reports 2008, OBIEE, SQL Server 2005, Toad

OTIS SPUNKMEYER, San Leandro, CA August 2008 – December 2008

Senior Business Objects Developer/Administrator

Supported all company users with administration, designing, and reporting issues in both 6.5 and XIR3 environments. Installed BO XIR3 Edge series, Crystal Reports, and Xcelsius on test and production environments. Developed new universes such as Trade Spend and Sales universes in XIR2. Imported and joined fact table with dimension tables and created Contexts, Aliases, and short-cut joins for resolving Loops and checked the Integrity of the Universes. Created classes, sub classes, and cascading prompts in the universe and used Numeric, Character, Logical and Aggregate Formulas to create variables used in Designer and Webi. Recreated major sales reports by distributors, operators, regions, and other hierarchies from Deski and Webi 6.5 to Webi XIR3. Created financial reports in Crystal Reports 2008 and developed sample Xcelsius 2008 reports connected to Webi through Live Office.

Environment: Business Objects XIR2, CMC, Crystal Reports 2008, Xcelsius 2008, SQL Server 2005, Toad

CISCO SYSTEMS INC., San Jose, CA January 2008 – June 2008

Business Objects Consultant

Provided Business Objects Universe Table information to Data Architecture team working on a new Terra Data Application for IT Finance group at Cisco Systems. Created performance reports from Broadcast Agent to show the amount of time it takes for users to run reports. Created reports from MARS universe and tested performance of measures. Gathered requirements from Finance users for development of future OBIEE reports. Checked reports for SQL error, drill down capabilities, graphs by following the Siebel Analytics User Interface Standard Guidelines. Translated requirements into functional specifications and data flow diagrams. Converted business requirements into ETL specs. Performed testing by using SQL against Teradata.

Environment: Business Objects 6.5, Excel, Oracle OBIEE, DW/BI, Teradata

KAISER PERMANENTE, Concord, CA March 2007 – November 2007

Sr. Reporting Analyst

Supported the Consultant or Specialist in monitoring and management of the ongoing reports and compliance metrics for IT Finance Compliance group. Created metrics and reports for root-cause analysis using variance between NIKU timekeeping and RPM. Analyzed contractor invoices and created 15D Consulting report, IT Sarbanes-Oxley (SOX), Buy to Pay, Contracts Integration, Travel and Expense Operations (TEO), Human Capital and Accounting. Improved the current reporting databases and structure. Supported ad-hoc data analysis and other reporting improvement needs of the organization.

Environment: Business Objects 5.1, Excel, VBA

GENENTECH, South San Francisco, CA October 2006 - February 2007

Sr. Business Objects Developer (BUSINESS OBJECTS AMERICA)

Migrated universes and reports from 6.5 to XI test and production environments. Migrated users and managed security on CMC. Created requirements for a new PeopleSoft universe to expand ad hoc and standard reporting capabilities of HR end users. Developed PeopleSoft universe and created Derived tables from source tables and columns. Implemented security restrictions for groups at the object level. Modified Metrics and Reporting universes for an existing dashboard development project for Clinical Operations department. Revised Webi reports and dashboard metrics based on new requirements. Created documentation for universes and reports.

Environment: Business Objects XIR2, Oracle, PeopleSoft, DW/BI

BARCLAY GLOBAL INVESTORS, San Francisco, CA September 2006 – October 2006

Business Objects Consultant (BUSINESS OBJECTS AMERICA)

Designed a universe to support the report requirements based on a new HR compensation module created by the service provider of the application. Trained manager on use of CMC and creating user groups. Reviewed and assessed the core report requirements using the current XLS reports as the basis. Worked with client staff to implement logon security using Groups and Business Objects Enterprise Security on CMC. Developed eight reports in Desktop Intelligence and Webi covering employee options, shares granted, forfeitures, and sale information for HR group. Worked with client staff to validate the accuracy of the reports and deployment of reports in production. Provided mentoring and knowledge transfer to client throughout the project.

Environment: Business Objects XIR2, SQL Server 2005, Excel

KAISER PERMANENTE, Walnut Creek, CA August 2005 - August 2006

Data Analyst

Designed, created and distributed accurate, consistent performance metric reporting at the service area, regional and enterprise levels on a daily, monthly, and an ad hoc basis. Created these metric reports on helpdesk incidents, requests, and encounters in Business Objects. Exported reports to Excel and Access for macro writing and pivot table analysis. Provided actionable trending, comparisons and identification of opportunities for improvement. Developed and maintained an automated reporting solution for clients based upon priorities defined by Senior Management. Verified accuracy of the data in Remedy by user acceptance testing during development cycle. Analyzed, configured, documented and tested Epic Clarity Reports. Validated system build reports and output with key stakeholders.

Environment: Business Objects 5.1, VBA, Remedy, Excel, Access

NEXTEL COMMUNICATIONS, Walnut Creek, CA February 2005 – August 2005

Data Warehouse Analyst

Managed a large database migration project from different databases into one proprietary data warehouse for Western Region cell sites. Searched for databases and defined sources of data, based on existing requirements, documentations, and interviewing database administrators across the company. Extracted data from Informix, BO, and Web based applications for HVAC, Generator, Power, Antenna, Tower, Shelter, and other site details. Used macros to integrate and transfer cleaned data files into Access. Scheduled BO reports to run, refresh, and save daily by using a macro replacement instead of Broadcast Agent. Trained users in basic and advanced reporting skills. Submitted data for upload into SQL Server and performed user acceptance testing.

Environment: Business Objects 6.5, Oracle 9i, SQL Server 2000, Informix, VBA, Excel, Access

APPLIED BIO SYSTEMS, Foster City, CA January 2004 - January 2005

Business Objects Consultant

Developed complex full client and Webi reports on company's experimental equipment, service calls, warranty contracts, and all related customer service data. Provided support in the area of monthly reporting automation, specifically writing several macros to aide in the automation of running reports. Maintained a consistent level of service to provide reports to the business during SAP upgrade project. Developed security set up for end users with Supervisor. Designed, enhanced and tested SMART universe and developed hierarchies to support drill down reports. Upgraded full client reports to Webi from one domain to another by Gradual Method. Translated all complex functions and formulas from full client to Webi, and created hierarchies for new reports. Scheduled and maintained reports on Publisher and BCA. Automated Business Objects files to be imported into Excel.

Environment: Business Objects 6.5 (Webi 6.5, Supervisor, Designer 6.5, BCA), Oracle 9i, SAP, VBA, Excel

KAISER PERMANENTE, Concord, CA June 2003 - January 2004

Financial Analyst

Provided best practice financial analysis services to Kaiser Permanente Information Technology internal clients, while continuously improving quality and reducing cost. Generated financial reports and assisted clients in using Business Objects functionalities. Provided overall mechanization project support for Project Accounting team at KPIT. Developed custom query General Ledger reports in Business Objects by project, by Business Area Partners, by region and by National and Local Investment projects from Performance Measurement Data Warehouse. Developed custom analysis reporting tool for Project Accounting Team to track monthly operating and capital activities. Created several VBA macros to automate interface with Excel and provide drill down capabilities for project managers.

Environment: Business Objects 5.1, SQL, VBA, Excel, Access

AMERICAN FINANCIAL LENDING, San Ramon, CA November 2002 - May 2003

Reporter Analyst

Created ad-hoc queries, reporting, segmentation, and analysis using Business Objects. Created user documentation as required. Planned, coordinated and managed database development processes. Responsible for tracking, supporting, analysis, and reporting customer database and marketing efforts and activities. Performed moderate to complex projects involving the analysis of financial, accounting, performance and loan servicing data. Moved sales reporting from current platform (Access/ Excel combination) to repository. Verified that Business Objects universe models are properly implemented in test and production environments and that it adheres to all standards. Assisted in the automation of manual reporting functions and scheduled reports to run on broadcast agent based on a pre-determined schedule. Maintained and created reports from loan database.

Environment: Business Objects 6.1, SQL, Excel

TWENTIETH CENTURY FOX, Los Angeles, CA September 2001 - March 2002

Business Objects Analyst (Consultant)

Collected information and report specifications from Executive management of Fox Home Entertainment. Created reports in Business Objects 5.1 for corporate key driver and weekly tracking information. Reports included summarized information about revenues, unit sales and contributions of titles released on DVD and VHS internationally. Worked with Oracle DBA to coordinate data extraction for universe design. Assisted Data Warehousing specialist with design and changes to existing universes. Translated old BO reports to new ones and wrote new SQL statements to modify queries and speed up the running time for each report. Verified report accuracy on Oracle and depository. Created documentation and charts for all reports. Monitored report outputs to Web Intelligence using ASP and Java.

PROVIDIAN FINANCIAL CORP., San Francisco, CA March 2000 - July 2001

MIS/Business Analyst

Reviewed and analyzed business and technical specifications required for implementation of web projects for the E-Commerce and Getsmart.com Departments at Providian Financial. Generated mortgage reports on web site browsers who viewed loan origination, application, processing, and referral pages by using Business Objects 5.1. Interviewed end-users to collect information for their requests and Created reports showing customer’s credit scores, loan to value, asset to income ratio, and other calculations. Generated Credit Card, Marketing, and financial reports for end users. Extracted data from repository and a large Oracle database. Created queries and data providers using free hand SQL. Updated and submitted these reports to Broadcast Agent and Intranet on monthly basis. Developed new Universes using Business Objects Designer and worked with Data Warehousing team to create new data models and tables. Transferred old reports to new ones based on the new design. Submitted reports on Web Intelligence for future access by end users. Worked with Java Developers and Oracle Data Base Administrators to resolve issues related to web site development, page ids and tables.

LUCENT TECHNOLOGIES, Milpitas, CA November 1999 - February 2000

Data Analyst

Delivered Telecommunications Reliability and Quality Measurements report for products used by Service Provider Messaging Group. Collected data reported by customers for use, installation and upgrades of voicemail products. Extracted information from Lotus Notes, Business Objects, Crystal Reports, and Orbit. Converted and inputted this information into Excel workbooks separated for each product release. Linked and combined workbooks to one main word report for presentation. Recommended new ways of analyzing data to analysts. Generated two quarterly reports for third and fourth quarter of 1999.

FRANKLIN TEMPLETON, San Mateo, CA July 1999 - October 1999

Project Coordinator/Analyst

Managed and monitored a daily schedule for deployment of Y2K fixes in all Franklin sites for about 3000 users, by using Microsoft Project and Excel. Conducted kick off meetings with business unit leads to schedule deployment of projects. Scheduled technicians for implementation of machine upgrades and replacements. Collected, recorded, and maintained an asset management report including compliance, non-compliance machines and user information. Scheduled technicians for troubleshooting after the initial deployment. Verified final validation of upgraded machines. Conducted closure meetings with business units and Regional Project Team.

CHARLES SCHWAB, San Francisco, CA April 1999 - June 1999

Project Analyst

Maintained a queue of 30-35 service requests and their sub-tickets in Remedy for retail implementation group of Information Technology Department. Conducted walk-through with customers to define the scope of the request and the specific requirements. Communicated requirements to technical resource groups such as voice, network, desktop support, and Facilities through SSR sub-tickets. Set customers’ expectations appropriately regarding completion timeframe, negotiated completion dates when necessary and provided status of each request.

ASCEND COMMUNICATIONS, Alameda, CA November 1998 - April 1999

Data Analyst

Extracted and analyzed data related to Ascend switching products using Business Objects from Oracle, Minx, and Scopus databases. Created a universe on Business Objects to include fields related to reliability and manufacturing data. Developed and generated reports such as performance metrics, sales credit returns, warranty returns, and monthly product failure results for quality assurance and manufacturing departments. Generated data on software trouble reports and performances on monthly basis. Updated documents on web site for users.

VANSTAR/INACOM, Pleasanton, CA December 1997 - October 1998

Project Planner / Scheduler

Worked as a lead scheduler and coordinator for 15 Vanstar teams for the deployment of 25,000 desktops, laptops, and network printers in 150 Chevron facilities throughout Unites States. Initiated site survey for Chevron sites in Western region and resolved business unit issues related to delivery, installation, and disposal of equipment. Instructed Vanstar team leads on Chevron facility codes and safety guidelines. Created a daily schedule to analyze and compare forecasted and real deployment metrics along with labor cost analysis factors. Managed and monitored Vanstar team leads on their installation and escalated problems to the Deployment manager. Worked with Hewlett Packard project managers in updating and coordinating the asset management reports.

ACTIVITIES/HOBBIES

Student Organization President at DVC, SFSU

Soccer Coach

Music Keyboard

Contact this candidate