Systems Engineer Resume Profile
OBJECTIVE
A highly talented, well experienced and knowledgeable SAP BASIS ADMINISTRATOR with solid background in System Administration and Analysis. Seeking a position in a company where my skills will be utilized in the best interests of the Organization.
PROFESSIONAL EXPERIENCE
- Over 18 years of experience in IT field specialized in system administration and analysis, design, coding and testing of various Business applications in Client/Server and Mainframe environment.
- 5 years of solid hands on experience as SAP BASIS, NW AND PORTAL ADMIN.
- Have worked extensively in HP/UX, Suse Linux, UNIX and Windows Servers
- Extensively worked with Relational Databases like Oracle 8i/9i/10g/11g, MS SQL Server
- Over four years experience in Data Warehousing and Database Business Application Systems administration, analysis, design, development and implementation.
- Well experienced in Extraction/Transformation/Loading/Staging of data into Data Warehouse
- using various Informatica tools, like the Designer, Metadata Manager, Repository Manager, Data Analyzer, Administration Console and Workflow Manager.
- Working knowledge of Business Objects and Cognos.
- Capable of performing responsibilities in stressful environments with fixed deadlines and analyze multiple data sources and identify inconsistencies.
- Excellent team player having strong leadership ability, excellent communication, client interaction and problem solving skills.
TECHNICAL SKILLS
- ERP SAP R/3 4.7 Enterprise, 4.6X, , ECC 5.0 6.0, SAP WEB AS
- 6.20/6.40/7.0, SAP BW 3.X/4.X, BI 7.0, EP 7.0, XI 3.0/7.0,
- Solution Manager 3.X/4.0, NWDI and NWDS, Siebel
- Security and SAP BASIS, GRC, CUA, ORACLE ENTERPRISE MANAGER,
- System Administration SAP NW PORTAL ADMINISTRATION, UME in NWA
- Data Warehouse Informatica PowerCenter Server 8.6/7.x Informatica Repository Server, Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administration Console
- RDBMS Oracle 8i/9i/10g/11g, SQL Server 2000/2003, Access 2000/7, DB2
- Languages PL/Sql, C, C , VB.6, VB.Net, VB.Script, SQL HTML.
- Data Modeling Star Schema Modeling, Snowflake Modeling, Facts Dimensions
- Tools and services BOBJ XI, VNC, SSH, SQL Loader, SQL Developer, TOAD
- Operating Systems Windows NT4/2000-2008 Server/XP, DOS, Suse Linux 10, UNIX
EMPLOYMENT HISTORY EXPERIENCE
Confidential
SAP BASIS AND SECURITY ADMINISTRATOR
Responsibilities
- Administer, support, manage and optimization of SAP landscapes MM/PM/PP, HR, FICO, SD, WAS 620/640/710 R/3 and Solution Manager on Oracle/Win2003/UNIX environment
- Perform occasional updates and support on applications like Taxware and BSI.
- Perform SAP Security Administration Authorization including activity groups, profile generator PFCG and central user administration CUA , troubleshoot security/authorization related problems using SU53, ST01 and SUIM, perform role and user analysis to find out the existing SoD violation for users and profiles in GRC
- Administer and Manage SAP NW Portal users, manage and create users in ABAP/JAVA stack
- BASIS support including maintenance of SAP background, batch and interfaces, maintain and install Printers in SAP and Spool administration, SAP transportation, monitor and maintain DBACOCKPIT for backups, install SAP Notes to resolve user issues. Maintain OSS user ids, authorizations and developer keys. Research, monitor and post messages on OSS Marketplace.
- Setup OSS connection. Maintain SAP profile maintenance.
- Monitoring R/3 system with CCMS Monitoring short dumps, system logs, db alerts, SQL traces, lock entries and Oracle sessions. Use Wily Dashboards for J2EE system status
- Maintenance of Solution Manager 4.0 for Early Watch Alerts and using it for generating keys
- Daily monitor and maintain of SAP and Oracle backups on HP Data Protector Manager, used BRTOOLS to add data files, monitor space utilization and file systems, create/rebuild indexes.
- SAP GUI 640/710 implementation and support, Performance monitoring and support in ABAP and NetWeaver stacks.
- Manage the development, maintenance and implementation of SAP System security parameters.
- Assisted in Support Package ABAP/JAVA stack installation, system refresh, client copies and Kernel upgrades.
Environment
Oracle 10g/11g, SUSE Linux 11, SAP ECC 6.0 EHP4, BI, MDM, Portal, Solution Manager 7.01, SAP BI 7.0, SAP BO XI 3.1
Confidential
POSITION: Security Analyst and BASIS Administrator.
Responsibilities
- Perform user and Role analysis in SUIM.
- Perform SoD check at Role/activity group level as well as user level using simulation in production sustem in GRC 5.3 RAR tools.
- Manage central user administration CUA for large number of user population.
- Experience on Automatic Profile Generator PFCG .
- Helped with BASIS administration duties: analyzing short dumps, database performance analysis, troubleshooting SAP OSS Notes, corrections and transport executions, analyzed system workload and Performance tuning. Scheduled users' batch jobs and setting up output devices in SAP.
- Maintain SAP User IDs, profile, and Fire Fighter IDs.
Environment
SAP ECC EHP 3, GRC, E-Recruiting, PI EHP1, BI EHP1, Portal EHP1, SAP Web Dispatcher, Windows 2003/2008, VMWare, SAP Solution Manager EHP1, SAP SRM SRM-SUS
Confidential
POSITION: Siebel Systems Administrator.
Responsibilities
- Administer and support all TAIS Siebel users and manage daily Siebel support activities.
- Database administration and support Oracle users.
- Responsible for EIM and EAI including oversee batch data migration to Oracle database using EIM.
- Used Siebel Tools to modify applets, views, and screens to meet client requirements.
- Created and modified rules for Workflow Manager and Assignment Manager.
- Planned, administered and installed software and applications upgrades including TAIS Actuate Server migration and upgrading
- Coordinated Onsite/Offshore engagements.
Environment
Siebel 7, SQL Server 2000 2005, Oracle 9i and 10g, Excel 2007, Toad, Windows Server 2005
Confidential
POSITION: Systems Analyst and Technical Support
Responsibilities
- Administer and support all internal ERP application comcash users and sales team.
- Support and administer Comcash applications installation on various Servers.
- Administer and support all Database servers including Oracle, SQL 2000 and 2003 Servers.
- Prepared Documentation on all aspects of user issues and resolutions to support knowledge base system.
Environment
Comcash applications, Oracle 9i, SQL 2000/2003, Windows Server 2003, SQL Developer, FTP Pro.
Confidential
POSITION: ETL Developer
Responsibilities
- Worked extensively on Oracle 10g to extract data from relational source Oracle and SQL servers, transformed the data based on user requirement following ETL specification documentation and using Informatica Power Center. Loaded data into target by creating and scheduling the sessions
- Involved with data cleansing and data staging following business requirements
- Involved in installation, configuration and management decision on Informatica Power Center Client 8.1 and Administration Console.
- Worked on reporting tool Business Objects for management and reporting.
- Developed and implemented Update strategy plan for the Data Warehouse project to implement slowly growing dimension.
- Helped designed and developed Star Schema Architecture for the data warehouse project.
- Improved the Performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations
- Involved in extensive performance tuning by determining bottlenecks at various points like target, source, mapping, sessions and systems which led to better session performance
Environment
Informatica Power Center 8.1 Repository Manager, Designer, Workflow Manager and Administration Console , Oracle 10g, Business Objects, SQL Server 2003, Toad, Windows Server 2003, IIS 6.
Confidential
POSITION: Informatica Developer
Responsibilities
- Extracted data from different relational sources like Oracle, transformed the data based on user requirement using Informatica Power Center and loaded into target, by scheduling sessions.
- Worked with Business Objects implementation for business analysis and decision support.
- Involved in installation and configuration of Informatica Power Center Client 8.1.
- Developed an In House application in C language and modified it to make more users friendly.
- Wrote PL/SQL procedures to create stored procedures for removing indexes before the data is loaded, rebuilt the indexes after the load has completed. Used Source Pre Load, Source Post Load, Target Pre Load, Target Post Load functionality of Stored Procedure Transformation.
- Used Cognos to create reports based on user requirements
ENVIRONMENT
Informatica Power Center Repository Manager, Designer, Workflow Manager Monitor , Oracle 10g, PL/SQL, SQL Server 2003, Suse Linux 10, SSH, IIS 6, Windows Server 2003, BOBJ, Cognos
Confidential
POSITION: Systems Engineer
RESPONSIBILITIES
- Worked on C and C language application programs for different Unisys Systems
- Implemented and tested Disaster Recovery project in MSCS environment.
- Involved with Unisys team for performance tuning on Unisys Servers for publishing
- Designed and developed databases in MS SQL Server
- Unit and Integration Testing done for developed mapping and documented to describe program development, logic, coding, testing, changes and corrections.
- Developed MS Access databases using multiple data sources and multiple output types
- Developed User Interfaces in Visual Basic 6
- Installed, configured, tested and managed high end Unisys Servers including 4 and 8 ways
ENVIRONMENT
Windows NT, Server 2000/2003, MSCS, SQL Server 2000, Access, C, C , Visual Basic 6.