Sap Hana And Bw-bobj Security Solutions Architect Resume
Pittsburgh, PA
SUMMARY
- Confidential has over thirteen years SAP application including four years of Basis and nine years of SAP Security design & implementation. His specialization is in providing Basis Security in SAP ECC, BW, BOBJ, SCM - APO and BPC (EPM 10), Portal security design, implementation, and support services.
- Confidential has been praised for being an excellent communicator of key project information such as risks, dependencies and design issues, and being instrumental to successful project completions.
- Confidential has extensive Sap Security Experience in Business Intelligence (BW, BOBJ, BPC and Portal) including HR/BW Reporting (For HR Structural Authorization and HR Context Authorization) security design in SAP BW.
PROFESSIONAL EXPERIENCE
Confidential - Pittsburgh, PA
SAP HANA and BW-BOBJ Security Solutions Architect
Responsibilities:
- BW 7.0 - 7.4 Upgrade and BOBJ 3.1 to 4.1 security upgrade solution
- Re-Configure Windows AD SSO (with Kerberos) Authentication with SAP Business Objects
- Defined SAP HANA Security Architecture and solution for Native HANA Modeling and reporting
- Design SAP HANA Package Hierarchy strategy and build Package Hierarchy.
- Developed HANA Delivery Unit Strategy.
- Designed HANA Security Roles by mapping Privilege types to HANA Security Roles
- Designed HANA Security Roles for Developers, Basis Support (Administrator), Security and End Users
- Developed Analytical Privileges for Company Code Restriction in HANA as Data Mart Implementation
- Develop New BW - BOBJ Security Strategy for Newly implemented Functional Area.
Confidential, Madison, NC
SAP BW-BOBJ Security Solutions Architect
Responsibilities:
- Configure Windows AD SSO (with Kerberos) Authentication with SAP Business Objects
- Configure Windows AD SSO with Business Objects Explorer (web.xml file scripts)
- BOBJ Security Token Service (STS) for SSO with SAP BW back-end
- End-to-End SSO for BOBJ (from Windows AD BOBJ SAP BW)
- Develop BW - BOBJ Security Strategy.
- Develop BOBJ Folder Hierarchy Structure in CMC
- Configure Custom Access Rights for End User, Developer and Super User permissions in BOBJ.
- Assigned uploaded BW Roles (BOBJ Group) to folders and Assign Specific Access Rights to it.
Confidential, FAIRLAWN, OH
SAP BW 7.3 Security Upgrade and Design Security Architect
Responsibilities:
- Developed Security Work Plan and Strategy for BW 7.31 Roadmap and development.
- Led team through BW 7.31 security process requirement, redesign and implementation.
- Developed New BW 7.31 Security models based on OMNOVA’s BW Security requirements
- Determined Authorization Relevant InfoObjects (Company Codes, Sales Org, Division, Sales Rep ID and Nav. ATTR)
- Developed BW 7.31 Business Roles (InfoProvider Roles) and Data Access Roles (InfoObject Restriction Roles)
- Designed Unit Test Plans to test OMNOVA’s New BW 7.3 security Model
- Working with OMNOVA Business Analyst in Conducting UAT and plan Deployment..
Confidential, Portland, OR
SAP BW 7.3 Security Upgrade and BW-BOBJ Security Architect
Responsibilities:
- Configure Windows AD SSO (with Kerberos) Authentication for BusinessObjects
- Configure SNC and Security Token Service (STS) for SSO with SAP BW back-end
- Configure Aliases Mapping between Windows AD user and BW User names
- Configure End-to-End SSO for BOBJ (from Windows AD BOBJ SAP BW)
- Develop BW - BOBJ Security Strategy.
- Develop BOBJ Folder Hierarchy Structure in CMC
- Configure Custom Access Rights for End User, Developer and Super User permissions in BOBJ.
- Assigned uploaded BW Roles (BOBJ Group) to folders and Assign Specific Access Rights to it.
Confidential, New York, NY
SAP BW/BPC Security Architect
Responsibilities:
- Developed BW 7.3 Security conversion Roadmap and Strategy
- Converted/Migrated ALL BW 7.0 Business Roles to BW 7.3 version
- Developed BW 7.3 Role testing Strategy
- Planned role roll-out of New BW 7.3 Roles to end users in Production
- Gather requirements for BW 7.3 and BPC 10 (EMP 10) implementation
- Developed BW 7.3 and BPC 10 security strategy
- Developed InfoCude/Query Restriction and Company Code/Profit Centre hierarchy Restriction via Analysis Auth.
- Developed plan for BPC 10 Security on Tasks, Team and Data Access Profiles (On Company Code)
- Design build for Company Code Restriction on CONSOLIDATION, MANAGEMENT and IC MATCHING App Sets in BPC
Confidential, Richardson, TX
SAP BW Security Architect
Responsibilities:
- Analysis of current BW 3.5 Security roles.
- Developed BW 7.3 Security conversion Roadmap and Strategy
- Developed BW 7.3 Security role testing strategy
- Converted/Migrated ALL BW 3.5 Business Roles to BW 7.3 version
- Planned role roll-out of New BW 7.3 to end users in Production
Confidential, NY
SAP BI Security Architect
Responsibilities:
- Developed BI 7.3 Security Roles Roadmap.
- Developed EP Roles for BW reports
- Developed KM content for BW static reports
- Planned role roll-out to end users support in Production
Confidential, Tempe, AZ
SAP BI Security Architect
Responsibilities:
- Analyzed Confidential ’s current BW 3.5 Security roles.
- Developed BI 7.2 Security conversion Roadmap and Business Objects 4.0 folder hierarchy permissions
- Converted/Migrated ALL BW 3.5 Business Roles to BI 7.2 version
- Developed Business Objects folder hierarchy structure and permissions
- Upload BW roles into Business Objects and granted folder rights to groups.
- Planned role roll-out to end users in Production
Confidential, Miami, FL
SAP HR-BI Security Architect
Responsibilities:
- Analyzed HR-BI Security Requirement for FPL
- Developed HR-BI Security Model and Roles
- Designed HR-BI Security for HR User access based on their Personnel Area and Sub-Area and Employee Subgroup.
- Assisted in developing Customer User Exit to Meet FPL HR-BI security requirements.
- Designed and lead Unit test plans and UAT and deployed HR-Security roles.
- Completed and submitted FPL HR-BI Security Blueprint Document.
Confidential, Annapolis, MD
SAP Basis Security Architect
Responsibilities:
- Analyzed client’s existing BW 3.5 Security Roles.
- Developed BI 7.0 Security conversion Roadmap.
- Worked on BI 7.0 Security Roadmap for BI Landscape.
- Worked on the roadmap and development of BI - Portal publishing Strategy.
- Designed and built Portal Roles -BI - Portal Navigation for BI Reports.
- Integration - Publishing strategy of all BEx Web tools to EP 7.0.
- Designed and developed ECC, SCM-APO (Demand Planning) security roles.
- ECC Security maintenance and defect fixes.
- Designed, Tested and executed BI security Upgrade test plan.
- Attended weekly role triage/Defect meeting.
Confidential, Atlanta, GA
SAP BI 7.0 and EP 7.0 Security Architect
Responsibilities:
- Developed BI 7.0 Security Upgrade Roadmap from BW 3.5.
- Developed BI 7.0 and Crystal Report Security for Sales and Revenue business areas.
- Established an EP 7.0 Security Strategy for BEx Web Functionality.
- Integration - Published strategy of all BEx Web tools to EP 7.0.
- Built EP Roles, Groups, Query iViews, and folder structure.
- Integrated all BI BEx queries, Web Templates and formatted Reports onto EP 7.0.
- Established BEx Broadcasting Strategy for Queries and Workbooks onto EP 7.0 and KM.
- Designed, tested, and executed BI security test plan.
- Worked on: BI integrated Planning security Design and build, and SCM/APO integrated Planning security design and build.
- Responsible for establishing Request Access Manager (RAM) procedures on the Portal.
- Led Design of BI-Portal integration.
- Worked on BI and SCM Planning Report publishing to the Portal.
- Worked on BI and SCM - Portal 1st and 2nd level Portal-Navigation
- Established User Mapping to groups on the portal using the UME Config tool.
- Developed iViews, Portal/KM Roles, Bex Reports, SAP Business Applications/transactions, etc.
- Provided portal integration with non-SAP applications based on business requirement.
- Used BEx tools to establish enterprise reporting standards and templates.
Confidential, Arlington, TX
SAP BI 7.0 and EP 7.0 Security Architect
Responsibilities:
- Established BI 7.0 Security Upgrade (Conversion) strategy from BW 3.5.
- Established BI 7.0 Security Redesign Strategy for MM, QM, PM, PP, SD and FI/CO modules.
- Established an extensive BI Development Naming Standard for all BI Custom built Objects.
- Established an EP 7.0 Security Strategy for BEx Web Functionality.
- Integration - Publishing strategy of all BEx Web Application tools to EP 7.0
- Integration - ECC 6.0 reports, t-codes and .Net Applications to EP 7.0
- Built EP Roles, Groups, Query iViews, and folder structure
- Integrated all BI BEx queries, Web Templates and formatted Reports onto EP 7.0
- Established BEx Broadcasting Strategy for Queries and Workbooks onto EP 7.0 and KM.
- Designed, test and executed BI security test plan.
- Accomplished Integration of BI Admin Cockpit CCMS to Enterprise Portal 7.0.
- GRC - SOX Compliance tools: Virsa: Firefighter, Compliance Calibrator, Role Enforcer.
- Responsible for the SAP Enterprise Portal Global build team and Architecture integration.
- Led the design, development and implementation of the SAP Portals environment and KM repository and taxonomies.
- Developed iViews, Portal/KM Roles, Bex Reports, SAP Business Applications/transactions, etc.
- Provided portal integration with non-SAP applications based on business requirement.
- Used BEx tools to establish enterprise reporting standards and templates.
- Led and supported the full development life cycle of SAP Enterprise Portal including documentation of functional and technical specifications, coding, unit testing, thread testing, system integration testing, and implementation.
- Established Portal/KM and reporting vision and strategies.
Confidential, Akron, OH
SAP Security Consultant
Responsibilities:
- Gathered BI 7.0 security requirements for HR and FI/CO Reporting modules.
- Completed an approved BI Security Blue Print.
- Coordinated HR Structural Authorization upload and generation in BI landscape.
- Mapped Structural Authorization DataSources to BI Authorization DataStore Objects.
- Created Transformation Rules, InfoPackages to Load HR Structural Auth from SAP HR.
- Mapped all authorization Relevant InfoObjects to BI Analysis Authorizations.
- Mapped all Display Navigations Attributes BI authorizations.
- Designed NW2004s BI analysis authorizations for HR and FI/CO reporting.
- Built all NW2004s BI analysis authorizations and Roles.
- Unit tested all BI authorizations on corresponding Validate HR and FI/CO reports.
- Analyzed new tcodes and Authorization Objects in ECC 6.0.
- Analyzed and updated USOBT C and USOBT CD tables for new values.
Confidential, San Jose, CA
SAP EP / BI 7.0 Analysis Authorizations Architect
Responsibilities:
- Designed NW2004s BI Security Strategy /Approach for SD, SM, QM, MM, PP and FI/CO modules
- Designed ECC 6.0 Security approach for SD, SM, QM, MM, PP and FI/CO modules.
- Gathered BI Reporting Requirements for all the modules as mentioned above.
- Integrated BI Security (roles, web templates and queries) with Enterprise Portal.
- Designed and built EP 7.0 roles, worksets and folder structure and integration with BI 7.0 roles.
- Designed and Built Web Templates for queries to be published on the SAP EP 7.0.
- Built BI Analysis Authorization all each module and Mapped to respective BI Role.
- Established BI 7.0 Security testing Strategy for Unit and integration testing.
- Tested and validated all BI authorizations - for each validated report built in Dev.
- Met SOX compliance based on Novellus Business Reporting processes using GRC and Versa tools.
- Executed knowledge transfer to Novellus SAP Security team.
Confidential, Morgantown, WV
SAP BI 7.0 Analysis Authorizations Architect
Responsibilities:
- Established a NW2004s Security Strategy and Approach for FI/CO and SD modules.
- Gathered BI Reporting Requirements for FI/CO and SD modules.
- Established a BI security Design with BI Analysis Authorizations.
- Designed BI Analysis Authorization Mappings to BI Role Concept.
- Established BI 7.0 Security testing Strategy for Unit and integration testing.
- Tested and validated all BI authorizations - for each validated report built in Dev.
- Met SOX compliance based on Confidential Business Reporting processes using GRC and Versa tools
- Executed Knowledge transfer with Confidential SAP Security team.
- Reviewed and helped troubleshoot security issues and made appropriate Updates to BI authorizations.
Confidential, Lincoln, NE
Technical Consultant
Responsibilities:
- Developed Security Work Plan and Strategy for UNL’s NW2004s BI Upgrade project.
- Led team through BI 7.0 security upgrade process requirement gathering, design, and implementation.
- Developed appropriate BI 7.0 security models based on UNL’s BW 3.5 Structural Security Infrastructure.
- Developed an ongoing upgrade and enhancement NW2004s BI Security Strategy approach.
Confidential, Billerica, MA
Technical Consultant
Responsibilities:
- Responsible for designing and converting the existing structural authorizations into NetWeaver 2004s (BI 7.0) analysis authorizations.
- Developed a Security Work Plan and Strategy for Confidential ’s NW2004s BI Upgrade project.
- Led team through BI 7.0 security Upgrade process requirement gathering, design and implementation.
- Developed appropriate BI 7.0 Security models based on Confidential ’s BW 3.5 Structural Security Infrastructure.
- Developing an ongoing upgrade and enhancement NW2004s BI Security Strategy and Approach.
- Designed and built all BI 7.0 Analysis Authorizations based on current BW 3.5 Reporting Authorization.
- Designed Test Plan for newly developed Structural BI Analysis Authorizations.
- Performed authorization error log analysis and modified authorizations during the testing phase
- Made recommendations for changes to be made on BW 3.5 queries to use hierarchy node variables instead of flat values.
- Redesigned BPS authorizations based on Variables in Planning Levels.
- Validated all BW 3.x query changes with successful execution on new NW2004s BI Security Concept.
Confidential
SAP Security Consultant
Responsibilities:
- Gathered Reporting requirement for HR, FI/CO and Logistics (SRM and MM).
- Completed an approved BI Security Blue Print.
- Coordinated HR Structural Authorization upload and generation in BI landscape.
- Mapped all authorization Relevant InfoObjects to Bi Analysis Authorizations.
- Mapped all Display Navigations Attributes BI authorizations.
- Determined all Restricted Key Figure Characteristic Values validate queries.
- Use Extrapolated Restricted Key figure Characteristic values to build BI authorizations.
- Designed NW2004s BI analysis authorizations for HR and FI/CO reporting.
- Built all NW2004s BI analysis authorizations and Roles.
- Performed unit testing of all BI authorizations on corresponding Validate HR and FI/CO reports.
Confidential, Libertyville, IL
SAP Technical Consultant
Responsibilities:
- Established NW2004s Security Strategy and Approach for FI/CO, Logistics, CRM 5.0 and HR Modules.
- Gathered BI Reporting Requirements for the respective modules listed above.
- Put together a BI security Design with BI Analysis Authorizations Mappings to BI Roles.
- Worked on CRM Authorizations Objects for Business Partners, Products, Marketing Campaign, Internet Sales, All Orders and Opportunity Mapping to roles.
- Built all BI Analysis authorization and roles.
- Set up testing Strategy - Unit and UAT.
- Tested and validated all BI authorizations - for each validated report built in Dev.
- Reviewed and helped troubleshoot security issues and made appropriate Updates to BI authorizations.
Confidential, Springfield, MA
SAP BI 7.0 Analysis Authorizations Architect
Responsibilities:
- Developed Security Work Plan and Strategy for NetWeaver 2004s Ramp-up project.
- Led team through BI 7.0 security process requirement, design and implementation.
- Developed appropriate BI 7.0 Security models based on current BW 3.1 Structural Security Infrastructure.
- Developed an ongoing upgrade and enhancement NW2004s BI Security Strategy and Approach.
- Designed and built all BI 7.0 Analysis Authorizations based on current BW 3.1 Reporting Authorization.
- Designed and built BI hierarchy Analysis Authorizations for Cost, Profit, Salary Cost Centers and HR.
- Designed Test Plan for newly developed Structural BI Analysis Authorizations.
- Performed authorization error log analysis and modified authorizations during the testing phase
- Recommended changes be made on BW 3.x queries to use hierarchy node variables instead of flat values
- Recommended changes be made on BW 3.x queries to use hierarchy node variables instead Exclusion nodes or Value Ranges
Confidential, Waltham, MA
SAP Basis Administrator
Responsibilities:
- Upgraded BW 3.1 to 3.5 and Installed IGS 6.40 after Upgrade.
- Performed Solution Manager 3.2 and R/3 4.6C system Migration.
- Worked on most of the SAP Daily activities in resolving issues.
- Configured VERTEX Tax Q Series Database with SAP R/3 4.6C.
- Provided on-site Basis Administration activities. Duties included: OSS note application, support package installation, system maintenance, DB and performance monitoring, security profile maintenance, problem diagnosis and user administration.
Confidential, St. Louis, MO
SAP Security Architect
Responsibilities:
- Analyzed customer’s current security setup vs. standard SAP delivered roles. Recommended that they redesign their current model to job position base security.
- Developed a Security Approach with effective authorization concepts and methodology.
- Created a Security Strategy and Standard Operating Procedure (SOP) for SAP Security Control for this organization.
- Designed Security roles for ongoing Development Project in SD, PP and PM modules BW 3.5 and CRM 4.0.
Confidential, Detroit, MI
SAP Security Architect - Lead/SAP Basis Administration
Responsibilities:
- Authored the Complete SAP R/3 and BW Security Approach, Design and Build Documents.
- Assisted in designing and building Enterprise Portal 6.20 Security infrastructure; building Portal Worksets and Roles as well as iviews.
- Designed and built all R/3 Single, Derived and Composite Roles for the entire FSI Project.
- Gathered security requirement from GMAC Business Champion Team for Security Matrix build.
- Set up Security Matrix in facilitating tcodes to Role(s) Mappings.
- Worked with the Enterprise Portal team to in designing EP Worksets and EP Roles.
- Created and designed integrated documentation - Standard Operating Procedure for SAP authorization Change Request.
- Designed and implement Central User Administration (CUA) with LDAP integration within GMAC multi-vendor SAP Environment.
- Created test scenarios for Single, Derived and Composite Roles for Unit, System and UAT testing.
- Assisted in Developing Installation Plan for Pre-prod and Production environment.
- Provided requirements in developing and testing SAPGUI deployment script.
- Completed System Deployment Plan and Develop System Deployment Schedule.
- Conducted System Testing Readiness Review, Built Test System, Revised client strategy for testing phase and Presented revised strategy to team leads
- Installed Second Set of Development Systems (EP, ITS, IGS, Crystal) at GMAC Insurance in Winston-Salem, NC.
Confidential, Danvers, MA
SAP Basis Administration/SAP Security
Responsibilities:
- Tasks performed include system configuration and maintenance, SAP Installation and upgrade, performance tuning and monitoring, security authorizations, SAP printer installation and configuration and problem resolution.
- Administered SAP performance monitoring on all print jobs resolve all SAP printer issues.
Confidential, Westwood, MA
SAP Basis Administration/Database Administration
Responsibilities:
- Installed and maintained over 3 SAP R/3 systems version 4.0B and ITS for online grocery shopping. Database platform supported was MSSQL 7.0 under Windows NT. Also supported BW 1.2 for warehouse reporting and planning.
- Designed the client instance strategy for the entire SAP landscape, planned and executed System Refreshes - client copies, client exports and imports.
- Performed General Daily Housekeeping tasks and jobs.