SAP Security Administrator Resume

SUMMARY

Approximately 2.5 years of experience in SAP Security.
Approximately 4 years and 7 months of Experience in SQL Server 2000, 2005 and 2008 T - SQL Programming and Administrator Activities.
Good knowledge in Designing Databases, Schemas, Relations, Views Preparing Stored Procedures, User Defined Functions (UDFs) and other related database objects.
Having knowledge in Administrative activities such as Database Backup, Restoration and SQL Server Job Scheduling.
Having Knowledge in OPENXML and XPath Queries.
Knowledge in Query Optimization and Database Tuning.
Hands on experience in Using SQL Server Profiler.
Worked with Version controlling tool such as: Visual Source Safe.
Worked with “Adept SQL Difference” Tool for Database comparison.
Experience of working in the complete Software development life cycle involving development, documentation, testing and maintenance.

TECHNICAL SKILLS

Application: SAP Security

Back End: SQL Server 2005 T-SQL Programmer.

Tools: Confidential SQL Server Management Studio 2005.

O/S: Windows XP.

PROFESSIONAL EXPERIENCE

SAP Security Administrator

Confidential

Responsibilities:

Managed SAP Security systems, each system with over 10,000 production users.
Mitigated and Resolved various Segregation of Duties violations.
Managed Emergency Access Controls.
Created custom roles for over 50 batch and RFC users.
Worked closely with Siemens Security Integration Manager to resolve various issues related to audit.
Removed sensitive access to further secure roles.
Performed daily checks to review for violations of established controls. Researched and resolved any violations.
Helped Siemens Security Integration Manager create and test various custom tools including.
Create/ update specific users from Production to Test
Create process to allow OSS access into the production client and including subsequent review

Confidential

Database administrator

Database Systems: SQL SERVER- 2005

Responsibilities:

Writing queries - Providing information as form of reports by writing SQL queries and stored procedures.
Database Maintenance - Taking full and log backup of database on daily basis for plaza and host server, checking size of log files, checking space available on hard disk
Database monitoring - checking synchronization of data and images from plaza server to host server.
Daily reports - preparing daily reports
First level support - Providing data as per requirements other than daily reports
Transaction monitoring - checking toll transactions.
Designing Reports using Tools.

Database Administrator

Confidential

Technology and Software Used:

Database Systems: SQL SERVER- 2005

RAD Tools: Visual studio.NET version 2.0

Web Development: ASP.NET, ADO.NET XML Web Services

Scripting Language: JavaScript

Tools: Visual Source Safe, Third Party Tools: Ajax, Infragistics, Expert Control

Responsibilities:

Designing database objects as per requirements.
Debugging the database errors and Front end errors that conflicted in testing process.
Supported tasks to rectify errors if any that came on live scenario.
Designing reports using crystal reports.
Project: Confidential solutions Pvt Confidential, Bangalore

Database Developer

Confidential

Responsibilities:

Technology and Software Used:

Environment: Visual Basic 6.0, Crystal Reports

Database: SQL SERVER- 2000

Responsibilities:

Creation of Publications, Subscriptions to set up the database as per the requirements.
Developed some scripts to run in database for successful replication processes.
Creation of the Snapshot and Merge publication Agents.
Creation and implementation of SQL scripts in database splitting in replication to different locations and to remote or mobile users by means of local and wide area networks, dial-up connections, wireless connections, and the Internet.