OBJECTIVE:

To seek a BI data analyst or a SAP BI Solution Engineer position.

SUMMARY:

For over 15 years, have been working as a BI Solution Architect/Designer/Tech. Lead, designing, enhancing, and maintaining BI applications on the top of Data Warehouses and/or Databases as well as SAP Business Warehouse. (DB2, Oracle 8i/9i/10g/11g, SQL Server 2000/5, SAP Business Warehouse 7.x, BEx Query Designer\Analyzer, PeopleSoft Finance and Momentum Finance etc.). Responsibilities have been included Requirement Analysis, Business Rule Study, Dimensional Data analysis, Modeling and Mapping, BI System Specification, Design, Coding, Testing, Production Supporting, and Dashboarding with various SAP Business Objects modules (version from 5.1, 6.x, XIR2, XIR3 and SAP BI4.x).

PROFESSIONAL EXPERIENCE:

BI Analyst, Principle

Confidential, Washington, DC

Responsibilities:

• Built data feeds by creating universes according to the above gradually decided subject areas and the best hierarchies.
• Created various queries to aggregate data onto the levels of the above models’ presentation patterns.
• Transferred the Confidential components to the models by defining Confidential data mappings.
• Reengineered models into the subject areas and improved them onto a “Storyboard” with over 50 models.
• Led to Infrastructure related tasks when necessary, including promotions, troubleshooting outages etc.

Technical Environment: SAP Business Objects 4.2 Dashboard and Infoview, WebI Rich Client and IDT + Oracle 11.

Senior SAP C

Confidential, Alexandria, VA

Responsibilities:

• Initiated the Confidential Fund Authorization Document ( Confidential ) universe and report design and incrementally improved it (3 releases).
• Created Oracle SQL views and/or BO Derived tables based on Momentum processing to transfer data into the aggregated information.
• Designed and enhanced the Confidential 1414 series and the Confidential 1416 series universe and reports with the BO Guidance Navigations technology.
• Built and enhanced Status of Funds universe and report for the Confidential.
• Created other reports, from Oracle views to Web Intelligence files, Such as, Outstanding Document Report, Master User Report, Security Setting by Organization, Fund Flows and Withhold Status, etc.

Technical environment: SAP Business Objects XI 3.1, 4.1 + Oracle 11 (hosted Momentum 7.02 Budgeting and GL tables).

Senior Principle SAP BI Developer

Confidential, Arlington, VA

Responsibilities:

• Planned, designed, developed, coded, tested, and debugged complex new software products and made significant enhancements to existing software.
• Researched and integrated design strategies, product specifications, development schedules, and user expectations into product capabilities.
• Troubleshot complex problems and provided customer support for software operating systems and application issues.
• Provided guidance and work leadership to less - experienced software engineers in following Confidential projects:

SR. BI Reporting System Analyst/Designer

Confidential, Washington, DC

Responsibilities:

• Initiated the conceptual design of the Foreign Service Assignment ( Confidential ) Dashboard Reporting System and defined facts and matrix.
• Created major Confidential /Dashboard and Web Intelligence reports connected by Guided Navigation technique.
• Designed various WebI reports with different techniques, such as, analyzing data with Slice and Dice Pattern and Drilling customizing data according to end user’s business rules, using data manipulating/presenting functionalities creating customized calculations by formulas, local variables and extended syntax etc.

BOXI Developer III

Confidential, Herndon, VA

Responsibilities:

• Defining universe parameters; populating universe structure; resolving loops by alias and contexts; reorganizing data item into multi-dimension view; setting up object properties; creating customized hierarchies for drilling to facilitating queries by BO utilities, such as List of values and @ Confidential etc.
• Designed ten BOXI WebI reports, which had been heavily involved in the Confidential and Confidential analytical patterns.
• In the IR2 Business Certification Team, tested upgraded BOXI R3 Enterprise security models.
• In the IR2 Infrastructure team, installed and configured SAP Business Objects XI r3 System Auditing Module into BOXI Enterprise and created non-standard auditing reports derived.

SR. BOXI Architect/Developer

Confidential, Washington, DC

Responsibilities:

• Provided development support services to the Confidential ( Confidential ).
• Migrated the BOE v6.5 contents to XI R3 and converted the Full-client reports to WebI reports as well as re-built reports that could not be migrated by the Import Wizard.
• Created Business Object XI R3 security model ( Confidential ) and connected external LDAP services for security implementation in BOE XI R3.
• Migrated and unit tested 40 universes and re-built 5 universes (to re-generate the Legacy BO Free-hand SQL reports) to XI R3 environment; Migrated and converted 380 WebI reports and implanted them.

SR. BOXI Architect\Developer

Confidential, Alexandria, VA

Responsibilities:

• Created Executive universe and 16 WebI reports for the Director Office of the Confidential Enforcement Division.
• Improved 18 WebI reports for the Confidential Regional Offices to adopt their additional enhancement requirements.
• Infrastructure tuning for the performance:

BI Tech. Lead\Architect

Confidential, Bellevue, WA

Responsibilities:

• Created the client’s first Enterprise Dashboarding system with Dashboard Manager and Performance Manager XI.
• Created the Best Practice development criteria for Confidential, WebI Reporter and Dashboard Manager Modules.
• Led team members to define, design and implement BO XI R2 Enterprise system and led migration and conversion QA team.
• Built and managed the offshore team.