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.
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.
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.
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
oIncident tracking/ release management
oAD LDS integration for portal applications
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
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)