SUMMARY:

• Highly Motivated Business Intelligence professional with more than 12 years of experience in Report Development and & Analysis as well as Database Development.
• Demonstrated leadership abilities and team work skills as well as ability to accomplish tasks under minimal direction and supervision.
• Proven history of utilizing strong analytic skills, attention to detail, and hard work ethics to turn complex requirements into working systems.

TECHNICAL SKILLS:

• SAP Business Objects: Web Intelligence (BI4.0, XIR3, v6.5) Information Design Tool 4.0, Designer (XIR3, XIR2, v6.5, v5.1)
• Central Management Console (4.0,XIR3), Supervisor 6.5
• Dashboard 4.0, Xcelsius 2008
• Business Intelligence tools (Cognos, OBIEE, MicroStrategy, SSRS)
• Databases (Oracle 11g, 10g, 9i, 8i, SQL Server 2008, SSIS, SSRS, Toad, SQL Plus)
• Visual Basic for Applications, Macros (Excel, Access, Business Objects)
• Windows Operating Systems (Windows 8/7/Vista/XP)
• Microsoft Office 2013 (Word, Excel, Access, PowerPoint), Microsoft Project
• Certified Scrum Master, JIRA
• Epic Clarity, Hyperspace, Workbench Reporting

PROFESSIONAL EXPERIENCE

Confidential, ANTIOCH, CA

Reporting Business Analyst

Responsibilities:

• Facilitated and participated in collecting business requirements and interviewed stakeholders or Hospital Department Managers. Developed Patient and Financial reports in SQL. Extracted data from multiple data sources such as Lawson, Remedy
• And Epic Clarity. Created Hyperspace Workbench reporting for all Hospital Epic applications like Cogito, ADT, ASAP, Cupid, HIM, OpTime, Stork, and Willow. Identified and recommended changes to standard enterprise methodologies for reporting.
• Installed and tested a new SAP Business Objects platform for future Webi and Crystal reports for future administration and scheduling of reports. Created universes in IDT to test Confidential existing reports. Provided users with the highest quality service.

Environment: SQL Server 2008 R2, Crystal Reports 2011, SSIS, SSRS, SAP Business Objects 4.1

Confidential, MOUNTAIN VIEW, CA

Reporting Business Analyst

Responsibilities:

• 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 Confidential for analysis.

Environment: MicroStrategy, Oracle 11, Excel 2013, SQL

Confidential, SAN JOSE, CA

Senior Business Analyst

Responsibilities:

• Assisted Human Resources ERC Reporting & Analytics team to develop Webi Adhoc 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

Confidential, SAN JOSE, CA

Senior Business Analyst

Responsibilities:

• Worked for Supply Chain GMO group to develop Adhoc 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

Confidential, SAN MATEO, CA

Senior Business Objects Consultant

Responsibilities:

• 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

Confidential, Oakland, CA

Senior Business Objects Developer

Responsibilities:

• 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

Confidential, San Ramon, CA

Senior Business Objects Administrator/Developer

Responsibilities:

• SupportedBusiness Objectsand Crystal users withsecurity, 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 also managed enterprise accounts.

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

Confidential, Pleasanton, CA

Senior Business Objects Administrator/Developer

Responsibilities:

• Supported and maintained business objects and Crystal production environmentsand 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

Confidential, San Leandro, CA

Senior Business Objects Developer/Administrator

Responsibilities:

• 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

Confidential, San Jose, CA

Business Objects Consultant

Responsibilities:

• Provided Business Objects universe Table information to Data Architecture team working on a new Terra Data Application for IT Finance group at Confidential . 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 Taradata.

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

Confidential, Concord, CA

Sr. Reporting Analyst

Responsibilities:

• 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 timekeeping and . Analyzed contractor invoices and created 15D Consulting report, IT Sarbanes-Oxley uy to Pay, Contracts Integration, Travel and Expense Operations, 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

Confidential, South San Francisco, CA

Sr. Business Objects Developer

Responsibilities:

• 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 groupsat the object level. Modified Metrics and Reporting universes for an existingdashboard 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

Confidential, San Francisco, CA

Business Objects Consultant

Responsibilities:

• 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

Confidential, Walnut Creek, CA

Data Analyst

Responsibilities:

• 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

Confidential, Walnut Creek, CA

Data Warehouse Analyst

Responsibilities:

• 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

Confidential, Foster City, CA

Business Objects Consultant

Responsibilities:

• 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

Confidential, Concord, CA

Financial Analyst

Responsibilities:

• Provided best practice financial analysis services to Confidential 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

Confidential, San Ramon, CA

Reporter Analyst

Responsibilities:

• 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

Confidential, Los Angeles, CA

Business Objects Analyst (Consultant)

Responsibilities:

• 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.

Confidential, San Francisco, CA

MIS/Business Analyst

Responsibilities:

• 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.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

• 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.

Confidential, San Mateo, CA

Project Coordinator/Analyst

Responsibilities:

• 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 communicated problems with Regional Project Manager.

Confidential, San Francisco, CA

Project Analyst

Responsibilities:

• 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.

Confidential, Alameda, CA

Data Analyst

Responsibilities:

• 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 the web site for intranet users.

Confidential, Pleasanton, CA

Project Planner / Scheduler

Responsibilities:

• 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.