September *, ****

SAP Security Practitioner with over 15 years of SAP/ SAP IDM v7.2 experience.

I offer overall leadership for the delivery and maintenance of existing application services, problem management, meeting service level agreements (SLA’s) and product and lifecycle management for SAP Security in the SAP and SAP-integrated service areas. Through my experience I have held the responsibility of primary security architecture analyst, maintenance, and administration responsibilities for all SAP ERP Clients.

Most recently, I have been actively involved (5 yrs.) with SAP IDM v7.2 and BI Reporting. Within this role I have been charged with maintenance/creation task(s) for life cycle provisioning via IDM to connected systems. I have also taken the role of subject matter expert with my understanding of the SAP IDM DB and with the aid of tools like (SSRS, Microsoft Power BI, and Tableau), I have created End User Reporting/IDM Health Metrics/Exec Dashboards.

I am currently ramping up for a technical upgrade of the client’s v7.2 SAP IDM this summer.

Sincerely,

Brad Shanahan

PROFESSIONAL HISTORY

Nov 2013 to Current

Coca-Cola Bottler, Marietta – GA

The Coca-Cola Company, incorporated on September 5, 1919, is a beverage company. The Company owns or licenses and markets more than 500 nonalcoholic beverage brands, primarily sparkling beverages but also a variety of still beverages, such as waters, enhanced waters, juices and juice drinks, ready-to-drink teas and coffees, and energy and sports drinks. It owns and markets a range of nonalcoholic sparkling beverage brands, which includes Coca-Cola, Diet Coke, Fanta and Sprite. The Company’s segments include Eurasia and Africa, Europe, Latin America, North America, Pacific, Bottling Investments and Corporate.

Project Scope:

Through an initiative of Coke centralizing their SAP Solutions, the CONA Dept. was created. The goal of this dept. was to create, house and deploy a multitenancy solution to be used by the Coca-Cola bottlers and distributors.

Project Need:

Initial design, creation and delivery of full SAP Solutions (from Id Management through BI including HR)

Initial Role within project:

In working with off-shore and local basis personnel, as the SAP Solutions (CRM, SRM, ECC, etc.) came on-line, they needed to be validated back to the source copy. Landscape design (Sandbox/Development, Development/Quality, Quality/Prod; Development/Maintenance, Maintenance/PreProd, PreProd/Production)

oUser table level validation

oRole level validation

oUser to Role validation

oAided Basis as updated Notes needed applied

In working with PSL and Technical teams, role redesign and development for multitenancy and SOD needs.

In working with PSL and Technical teams, monitored and addressed needs to support their (threads) initial validation of SAP Solutions as each box/landscape came on-line.

Go-live mapping and creation of user account(s) with task role(s) assignment

Once the SAP solutions were stood up, although still having deliverables, I ventured over to the Identity Team side.

Aided in the initial IDM/GRC design via supplying supporting user accounts and data manipulation for testing

oUser master/profile creation(s) on target system

oHR User Master account creation

oHR Org Changes

Aided in design and testing of HR pull into IDM System

Aided in design and testing of GRC workflow, SOD checks

Aided in design/creation/testing of SAP IDM Jobs ( Housekeeping Task(s))

Aided in design/creation/testing of tuning SAP IDM Jobs (Java Functions vs stored procs and functions within the SQL DB)

In working with PSL and Technical teams, initial creation/setup of Fire Fighter ID’s via GRC and target system

3rd party application work

Rev Track

oIncident tracking/ release management

Site Minder

oAD LDS integration for portal applications

Tableau

oR&D, Possibility of porting current Microsoft SSRS reporting over

Currently multiple bottler locations are up and running on the CONA Solution. We currently are working on Phase 4 of the release. Within this release, I will be delivering:

Position based role assignments

oUpon HR pull, users to be mapped to business roles that match their position, for those that fallout a remedial process will be created to provide processing.

Revamped Reporting Services offered by CONA

oRestructuring the DB

Tuning queries, applying index(s), code review and rewrite for poor performance stored procedures

oAltering how the sourcing data is being feed to reporting Server

oCreating reusable processes that align with the way SAP IDM db data is created and stored

IDM 8 Upgrade from v7.2

Microsoft Power BI

oConversion of Microsoft SSRS Report(s)

oNew Development ( SAP Licensing Rollup for Company)

oExecutive Dash Boards

Microsoft Reporting Solutions (SSRS)

oReal time reporting of users/business roles/SAP Task roles and the roll up of those items as to how they affect the individual bottler.

Sept 2003 to August 2013

Rockwell Collins, Cedar Rapids – IA

Company Profile: Rockwell Collins is a pioneer in the design, production and support of innovative solutions for our customers in aerospace and defense. Our expertise in flight-deck avionics, cabin electronics, mission communications, information management and simulation and training is strengthened by our global service and support network spanning 27 countries. Working together, our global team of nearly 20,000 employees shares a vision to create the most trusted source of communication and aviation electronics solutions. Our aviation electronics systems and products are installed in the flight decks of nearly every air transport aircraft in the world. Our airborne and ground-based communication systems transmit nearly 70 percent of all U.S. and allied military communication. Whether developing new technology to enable network-centric operations for the military, delivering integrated electronic solutions for new commercial aircraft or providing a level of service and support that increases reliability and lowers operational costs for our customers throughout the world, we deliver on our commitments.

Design, create and maintain new security roles as required by business for R/3 BI, HR and CRM

Provide guidance to business regarding impact of segregation of duties concerns for security changes

Address and rectify all audit issues related to SAP security

Provide training and supervision to the user administrator

Maintain documentation for all processes related to user assignment and change management related to SAP Access

Technical team lead for SAP Security role review and redesign following RC acquisitions

Technical team lead for SAP MM Thread following RC acquisitions (MM, BOM, ECO, ROUTE Data migration into SAP)

Technical lead for SAP Upgrade

Developed and implemented new processes related to user administration and security role change

Provided guidance to business team with the security review, compliance and new development

Using SAP Profile Generator created single, derived, and composite roles with complex restrictions criteria's

Ensured completed testing by business users, provided go-live support, maintained documentation

Provided support and design expertise for SAP Master Data, MM/PP, IM/WM, QM, SM, SD, PS, HR module(s) and 3rd party bolt-ons

Liaison for business departments to ensure that SAP changes reflected business processes while still compliant with regulations

Proactively monitored segregation of duties (SOD) promoting a strong controls environment and implemented detailed processes or internal and external audits

Proactively monitored Sarbanes/Oxley (SoX) precepts, promoting a strong controls environment and implemented detailed processes or internal and external audits

Implemented a new security strategy to address changing requirements. Developed small and functionality focused single roles and composite roles that reflected the “role based concept”

Monitored, troubleshoot and processed SAP security access requests

1997 to 2003 Independent Consultant

Project Location: On site

Role: Principal Business Analyst/Developer

Project(s): Mobile Workflow Applications on Symbol/Intermec Devices

Project Location: City of Iowa City

Role: Principal Project Manager/Business Analyst/Developer

Project(s): Wireless applications in patrol cars, legacy applications (Delphi/Access) revamped into .Net UI w/ SQL back end. DB migration and tuning

Project Location: Broadlawns Medical Hospital

Role: Principal Project Manager/Business Analyst/Developer

Project(s): Designed, managed and delivered multiple applications using MS Access, VB 6 (utilizing 3rd party controls), DTS Packaging (SQL 2000), VB Scripting, developed database architectures in MS Access/SQL 2000 and Crystal 8.5, interfaced with hospitals legacy systems designed by Cerner and Siemens.

Project Location: State of Iowa

Role: Senior Project Manager/Business Analyst/Developer

Project(s): Aided and mentored the states’ Project Managers in methodology, software design lifecycles and quality assurance. Assisted with creating processes in software design and requirement gathering to create quality software designs to meet the states’ needs in the new age of technology. These applications consisted of Java based web applications (front end) and used MQ Series to communicate to the states’ Legacy data storage units (mainframe). Enforced “change control” and identified “scope creep” of projects to void off any unsuspecting derogation of the project lifecycle or added cost to a project.

1993 to 1997 System Analyst/ Programmer - Progress (UNIX platform), PMX, Cedar Rapids, IA

1990 to 1993 - US Army, Stationed in Balmholder Germany

TRAINING

Kirkwood Community College – Cedar Rapids, IA AIB (American Institute of Business) – Des Moines, IA

Attended and completed the advanced Mainframe Course Attended and completed the MCSE/MCDBA Degree program

Certificate of completion: Mainframe Computer Programming Completed and passed advanced placement exam

Drake University – Des Moines, IA PMI Certification

Computer Science Major SAP Security Cert Courses (ADM940, ADM950, ADM960)

Contact this candidate