SUMMARY

• 18+ years of development, architecture, configure, implement and deploy Client / Server application, Maintain Business Intelligence landscape with full lifecycle; In memory HANA / Data Warehouses experience, involving Business Objects, Web Intelligence, OLAP and Dashboard Solutions and additional four years with SAP BI developer, as well Oracle / MS SQL database / MS Exchange administrator
• Translating high - level business requirements into logical business dimensional model;
• Understanding and defining key metrics, dimensions, hierarchies and attributes.
• Translating logical business dimensional model in base physical DB design;
• Building the ETL process to meet business requirements against complex data sources;
• Establishing and implementing BI best practices and guidelines.
• Re-architect and implement new data warehouse technologies and tools.

TECHNICAL SKILLS

• SAP BW 7.5/3.5; SAP NetWeaver 2004s, SAP BW on HANA, Exposure with SAC solutions & SAP Data Intelligence 3.0 and power BI; Extensively used SAP BW BEX Query Designer, BEX Analyzer, Web BEX, WAD; SAP GRC 10; SAP Business Objects 5.1.5 /6.1b / XI R2 / XI 3.1/ 4.1.2 through 4.2.SP07/ 4.3; Universe Designer
• Information Design Tool/ WEB Intelligence/ SAP Advanced Analysis for Office 1.x thru 2.8; Solutions like MDM/ SDA/ SLT/ Near Line Storage/ VM Servers / Physical Servers for BO Suits & Report and Repository Databases with Microsoft Servers 2012 /16/19
• Informatica Power Center 4.5 through 7; Siebel CRM 6.3 thru 7.x, Oracle 8 thru 12g, SQL P/L SQL, MS Office/Project, Visio, ER-Win, Toad, Data Warehouse, Data Mart, Star Schema, ETL, MS SQL Server, Know how on using SAP BPC; Xcelsius-2008 Dashboard reporting; SAP Business Objects Data Services 4.2 SP09, SAP R3 Rapid Marts, IBM Data-Stage, Crystal Reports Suit.

PROFESSIONAL EXPERIENCE

Confidential

SAP Business Intelligence Specialist

Responsibilities:

• Mainly Administers SAP Business Objects reporting, Data Services landscape, downtime & SLA.
• Migrated BEX Queries related to classic BW to the SAP BW on Hana migration.
• Validates report data before release / patch and post release or support packs.
• Administers BO Landscape Users/ Folders / Report access during migration.
• Configures Windows AD / SAP BW for Single Sign on to Portals and SAP BW data Access.
• Also works with SAP HANA Basis Administers and HANA Security admins to enable Analytical and Calculation View Privileges and SAML access to native HANA models to be consumed thru WEBI and AAO for HANA Data.
• Performs BI folder synchronization with reports and security from production on to Dev and QA.
• As well perform LCM / Promotion management from DEV through Quality and to Production.
• Verify the BI team developed WEBI reports and validate them prior to User Acceptance Test for its operation, performance, Format, Data Exchange (Excel /CSV/TXT/PDF) and report consuming.
• Carried out many upgrades from BO 3.1/4.1/4.2 and their support packs to maintain the SAP Forward Fit Stream for SAP Suite of products.
• Assists BI developers/Consultants during the courses of dashboard projects for executives.
• Co-ordinates with Yearly SPIT on ERP and many inhouse ERP (SAP ECC) enhancement projects.
• Closely follow-up with Change Control Management for the SAP BW and other DTS changes to the reporting BW / HANA sources.
• So constantly and closely works with SAP BASIS / Systems /Storage/ Backup and Disaster Recovery teams, besides SAP BI developers and SAP BI business users.
• Trains co-employees/ Business Users/ Data Analysts/ Executives.
• Performs System Analysis on the preexisted BO reports for its complexity of the business needs
• Maintained SD, BRIM, FI GL, PPM, PLM, PCA and DTS WEB Intelligence /SAP Advanced Analysis AAO reports and help schedule them for Business Data Owners/Sr Data Analysts.
• Helps with Business users for installing the AAO clients for inhouse BW reports and CFIN (SAC users)

Environment: s: SAP BO 5.1.0/ BO 3.1/BI 4.0 /4.1 /4.2 SP7 / Xcelsius-2008/ WEBI. AAO 1.x / 2.1 SP8/ Lumira / Design Studio/ Tableau/ SAP BW 7.5 on HANA 1.0

Confidential

SAP BO Consultant

Responsibilities:

• Migrated and help apply service packs in the Business Objects Environment.
• Validated report data before release / patch and post release or support packs.
• Validated Users/ Folders / Report access during migration.
• Performed System Analysis on the preexisted BO reports for its complexity of the business needs.
• Used to meet with Business Managers and brain-stormed for a Business Objects reporting solution for their CRM operations at the initial state and gained User confidence for promotion the implementation project.

Environment: s: SAP BO XI R2/ BI 4.1 / Xcelsius-2008/ WEBI. Talent ETL / OBIEE/ ORACLE 11g. Siebel CRM

Confidential, Milpitas, CA

SAP BI/BO Consultant

Responsibilities:

• Migrated Legacy XI R2 BO reports off of the relational database to the SAP BW and with SAP BO 4.2, mostly keeping the feel and look as they were in the practice.
• Architected a solution for the SAP BW environment to keep the custom time dimension and variables like today / previous day and other date derivatives to cater the BO reports to use the aging reports.
• Performed System Analysis on the preexisted BO reports for its complexity of the business needs.
• Designed complex SAP BW multi providers and Info Sets for the reporting needs, based on the ERP (SAP ECC) customization
• Designed Most of the SAP Bex Queries and Modeled BEX reports for the report migration and repointing to SAP BW.
• Designed SAP BW Based Universes and changed the data sources for the legacy universe based WEBI reports and performed data validations before SAP and with SAP BW
• Trained inhouse IT folks and bridge them with SAP BW and Business Objects Technologies.
• Once Project gone live, extended hyper care to help with most Business Analysts for concerns related using the SAP BW based universes and WEBI reports than that of relational DB time.
• Worked with SAP BusinessObjects Product Engineers for Hot fixes based on new implementation.

Environment: s: SAP 3.5; NW 2004S; BI7 AWB; SAP ECC5; SAP GUI 7.x, Excel 2003/2007; SAP PORTAL BEX; WEB BEX; WAD; SAP MDM XI; BO XI R2/ BI 4.1 / Xcelsius-2008/ WEBI. ORACLE 10g. SOLARIS 10.

Confidential, San Jose, CA

SAP BI Architect

Responsibilities:

• Knowledgeable in Data warehousing concepts and able to understand performance implications of a design options and propose optimal solutions to reporting needs and be able to configure and support delta extraction processes.
• Identified and activated SAP BW Business Contents, particularly those financially related.
• Enhanced R/3 Data Sources; develop generic Data Sources; create custom reporting variables and custom cubes with update/transfer rule processing.
• Fully validated BI (SD/PS) development per business needs and accuracy. Customized 35 BEx, Business Objects, Ad-hoc BEx reports & Work Books.
• Administered Production BI Portals, Business Objects Environments and WEBI.
• Created, maintained BI Accelerator Index, Multi-provider Hints to improve BEx performance up to 60%.
• Performed day to day production support and load monitoring and involved in more than six months of post-production support.
• Included process chain alerts and assisted to diagnose data issues, accepted full ownership of incidents from origin to final solution and performed hot fixes.
• Assisted maintaining the BOE 405 environments and crystal reporting solutions.

Environment: s: SAP 3.5; NW 2004S; BI7 AWB; SAP ECC5; SAP GUI 7.x, Excel 2003/2007; SAP PORTAL BEX; WEB BEX; WAD; SAP MDM XI; BO61b / BO XI R2 / Xcelsius-2008/ WEBI. ORACLE 10g. SOLARIS 10.