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

WORK 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 and escalated issues appropriately.

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:

• Supported Business Objects and Crystal 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 also managed enterprise accounts.

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