HENONG “ANDY” PAN

[ ] Address: FAIRFAX, VA ***** [ ] Email: adjv42@r.postjobfree.com [ ] Tel: 703-***-****

OBJECTIVE:

To seek a SAP BI Engineer, Analytics Developer or a SAP BO System Administrator position.

SUMMARY:

For 10+ years, have been working as a SAP BI Solution Architect/Designer/Tech. Lead, Administrator, designing, enhancing, and maintaining BI applications on the top of Data Warehouses and/or Databases as well as SAP Business Warehouse (including 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 to SAP BI4.2, such as, SIA, CCM, CMS, CMC, Query Builder, BODS Management Console & Designer, Universe Designer, UDT, IDT, QaaWS, LiveOffice, Xcelsius, Lumira, DS, Web Intelligence\Rich Client, Import Wizard, Dashboard Builder, LCMBIAR and Launch Pad etc.

Immigration Status: US Citizen.

Security Clearances: DoD Secret Clearance (Active) with CompTIA Security+ CE Certification.

SAP BI Certificates: SAP BOXI Dashboard Builder; SAP BOXI Performance Manager; Universe Designer and IDT; Enterprise Reporter.

EXPERIENCE:

== 06/2019 ~ Present Business Objects SME General Dynamic IT – US Navy NCIS. Quantico, VA

Responsible for the everyday administration of Navy NCIS’s SIPR, NIPR Business Objects systems, which was included following:

BOBIP Platform Administration: Administered security settings, server configuration & maintenance and trouble shooting. Assisted business users in the use of reporting toolset

BODS administration: Created BODS Local Repositories, linking to CMS and attaching Job Servers; code promotion, content migration and other management routines; monitored and troubleshot BODS Batch Jobs.

Created new BODS ETL Mappings for new requested objects and tables, such as, analyzing data; providing architecture blue print; creating Batch Jobs, Datastores, Work Flows and Data Flows; defining Transforms; setting up source and target schemas.

Modified query metadata BO Universes for new inquired fields and tables with IDT, UDT, such as, improving universe parameters; populating universe Data Foundations; updating contexts and set up new alias; reorganizing data item into multi-dimension view; created Aggregated Awareness based on summarized tables; setting up object properties; designing Water-Fall Prompts; creating Derived Tables and customized hierarchies for drilling to facilitating queries by BO utilities, such as List of values and @Functions etc.

Designed various Web Intelligence reports with different techniques, such as, analyzing data with Slice and Dice Pattern and Drilling Mode; customizing returned data according into end user’s business rules, using data manipulating/presenting functionalities (Filtering, Break, complex conditions etc.); creating customized calculations by formulas, local variables and extended syntax etc.

Technical Environment: SAP Business Objects Data Services 4.2 (and XI r3.1)+ Oracle 11.

== 07/2017 ~ 06/2019 Business Objects Administrator CITI - US DoS. Arlington, VA

Conducted SAP BI systems administration, including server configuration, performance tuning, data connection management, etc.

Monitored environment to ensure user needs and responded to ongoing business needs.

Created\improved Business Objects new BI requests, using IDT, UDT, Web Intelligence, Dashboard Builder and BODS Designer.

Defined the data governance and SOPs, best practices and processes.

Technical environment: SAP Business Objects XI4.1 + Oracle 11g (hosted CMS database, ADS and SAP BODS repositories, etc.).

== 03/2015 ~ 06/2017 BI Analyst\Developer, Principle CACI - US Navy SPAWAR and NAVSEA, Washington, DC

Created three Dashboard reporting systems - The Cyber Security Scorecard, The Certification and Accreditation and The Unaccredited System And Network for the NAVSEA HQ OOI.

Initiated the Xcelsius dashboard architecture design by weekly meeting with clients.

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 Xcelsius components to the models by defining Xcelsius 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.

== 06/2013 ~ 03/2015 Senior SAP BOBJ Consultant Savantage Solution LLC - OUSD, Alexandria, VA

Created Momentum Funding Distribution Reporting Module for DoD OUSD.

Initiated the OUSD Fund Authorization Document (FAD) universe and report design and incrementally improved it (3 releases).

Created Oracle views (or BO Derived tables) based on Momentum processing (such as, MF and AA tables, MF_SBE, MF_SBE_DOC_LN, MF_AJ, MF_TJ, MF_RP, MF_BE_FORM, MF_BE_FRM_LN and MF_RP_LN etc.) to shape data into the aggregated information.

Designed and enhanced the DD 1414 series and the DD 1416 series (Congress Reporting Code#) universe and reports with the BO Guidance Navigations technology (with 20 Drill-To child reports).

Built and enhanced Status of Funds universe and report for the OUSD (with about 25 Drill-To child reports).

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

== 01/2011 ~ 05/2013 Senior Principle SAP BI Developer Pragmatics - FDIC, Arlington, VA

BI reporting in FDIC BI Support Center to support FDIC’s efforts to fulfill the Dodd–Frank Wall Street Reform and Consumer Protection.

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 for following FDIC projects:

Chairman Dashboard;

RADR (Receivership Assets Data Repository) Dashboard;

LLCDM (Limited Liability Company Data Mart);

RSAM (Risk Assets Management);

LMDM (Liquidity Monitoring Data Mart); and many more agile development projects.

Technical environment: SAP Business Objects XI 3.1, UNV Designer, Infoview, Xcelsius and WebI etc. + Oracle 11.

==05/2010 ~ 12/2010 SR. BI Reporting System Analyst/Designer Twin-Soft - DoS, Washington, DC

Worked in the Bureau of HR’s Knowledge Center in the US Department of State.

Initiated the conceptual design of the Foreign Service Assignment (FSA) Dashboard Reporting System and defined facts and matrix.

Created major Xcelsius/Dashboard and Web Intelligence reports connected by Business Objects Guided Navigation technique.

==07/2009~ 05/2010 BOXI Developer III TEK Systems - Fannie Mae, Herndon, VA

As a Data Solution architect, participated in Fannie Mae\HAMP\IR2 in a few functional teams

As a universe designer, provided incremental enhancement design to two IR2 universes, HAMP Datamart.UNV (for Department of Treasury) and IR2 Reporting – TTS Copy.UNV (TXDB universe).

Designed ten BOXI WebI reports, which had been heavily involved in the FANNIE MAE and HAMP analytical patterns(the value analysis between present values and future values).

In the IR2 Business Certification Team, tested upgraded BOXI R3 Enterprise security models.

==10/2008~07/2009 Sr. BO XI Architect/Developer Interimage LLC - FDIC, Washington, DC

Provided development support services to the US Federal Trade Commission (FTC). 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 (ACL) for the migration target system 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.

==01/2008~10/2008 SR. BOXI Architect\Developer SAIC - SEC, Alexandria, VA

Led reports development with Business Objects XI r2 Designer and Web Intelligence with back end Sybase Adaptive Server 12

Created Executive universe and 16 WebI reports for the Director Office of the SEC Enforcement Division.

Improved 18 WebI reports for the SEC Regional Offices to adopt their additional enhancement requirements.

Worked for the performance:

In Database, proposed appropriate indexes, portioning, summarized tables;

In Designer, applied Index awareness, Aggregated Awareness, Short cut joins and objects definition improvements;

==01/2007~12/2007 BI Tech. Lead\Architect, Freeborders - Expedia Inc. Bellevue, WA

As the Outsourcing Tech Lead, managed 14 BI and database developers to manage both on-site and offshore team in projects.

Built and managed the China offshore team.

Created the client’s first Enterprise Dashboarding system with Dashboard Manager and Performance Manager.

Created the Best Practice development criteria for Universe Designer, WebI Reporter and Dashboard Manager Modules.

Led team members to define, design and implement BO XI R2 Enterprise system and led migration and conversion.

EDUCATION:

[] MBA

Shenandoah University, VA, USA (GPA: 3.7/4.0)

[] Applied Computer Science

University of Maryland, MD, USA (GPA 3.8/4.0)

[] Bachelor of Engineering

Jilin Technological University, Changchun, China

MISCELLANEOUS:

[] CompTIA Security+ CE Certification.

[] Certified Professional Engineer (PE)

(Professional Engineer – PE-5 – 1993)

[] Native Chinese/Mandarin speaker.

Contact this candidate