Sap Data Archiving Consultant Resume
Indianapolis, IN
SUMMARY:
Information Technology professional with extensive experience dedicated to Analysis, Planning, Design and Implementation of end - to-end SAP Data Archiving and Information Lifecycle Management (ILM) solutions. A team player with proven ability to deliver projects on time is looking for an opportunity to leverage my knowledge to help an organization achieve the best results in business; which would increase its productivity in the market. Willingness to contribute, continue learning, and build relationships.
STRENGTHS:
- Experience in design and development of archiving solutions in SAP (ECC, BWSolution Manager and Bank Analyzer) systems.
- Strong experience with SAP Archive Development Kit (ADK).
- Experienced in SAP Information Lifecycle Management (SAP ILM). Work with the legal team and business partners to develop solutions that meet the legal and functional requirements of archiving and eventually dispositioning of data.
- Strong experience configuring, implementing and supporting SAP Data Archiving /
- SAP ILM solutions with functional / technical archiving objects.
- Experience with archiving functionalities such as Infostructures, Partitioning and Indexing.
- Strong experience with SAP Data Retention Tool (DART): SAP DART configuration and implementation, SAP DART audit data retrieval, SAP DART Extracts/Views.
- Excellent communication skills and a professional demeanor gained through extensive interaction with business partners.
- Recognized for reliability and getting the job done through persistence and a strong work ethic.
- Willingness to learn new technologies.
- Skilled in project coordination.
TECHNICAL KNOWLEDGE:
SAP ECC (FI/CO), SAP BW, SAP Solution Manager, SAP Bank Analyzer
ABAP/4, UNIX Shell Scripting, AWK Programing Language, PERL, SQL, SQL*Plus, CJava
Solaris, AIX, Linux, Windows Servers
Veritas NetBackup, NDM/Connect Direct, Autosys, Redwood Cronacle
TCP/IP, SSH, RSH
Oracle, Sybase, DB2
MS: (Word, Access, Excel, PowerPoint, Outlook, Visio)
WORK EXPERIENCE:
Confidential, Indianapolis, IN
SAP Data Archiving Consultant
Responsibilities:
- Designed and implemented an SAP Data Archiving Framework that reduces Application Lifecycle costs through a sustainable archiving approach which also ensure compliance of legal & regulatory requirements for data retention and records management.
- Worked closely with the business to gather requirements and created test scenarios based on the requirements.
- Played a key role in the implementation/maintenance of SAP ILM solution.
- Played a key role in the data archiving effort to reduce the data footprint in creating a lean system for the migration to S/4HANA. Estimated reduction of half the database size.
- Implemented and maintained Retention Policies and Rules within the Retention Management system.
- Performed data analysis using DB02, DB15, and TAANA.
- Performed archive object configuration using AOBJ, SARA, SARI, and FILE.
- Performed Retention Management configuration using ILMARA, IRM CUST and IRMPOL.
- Implemented data archiving strategy of more than 40 archiving objects which included Financial (FI/CO), Sales & Distribution (SD) and Material Management (MM).
- Performed data destruction on data that has reached its retention period.
- Coordinated the implementation/maintenance of SAP Add - Ons such as PBS and TJC-AEC Tool.
- Work closely with the Legal Team to manage and execute Legal Hold requests through the e-Discovery process.
- Work closely with the Tax Team to handle and execute Tax Audit requests utilizing the TJC-AEC Tool.
- Led decommissioning effort of SAP Legacy System using the SAP Landscape
- Transformation Replication Server (SLT) strategy. Decommissioning effort allowed
- Confidential and Company to save on support and licensing cost.
- Implemented Retention Warehouse: configured Audit Area, Retention Policies and Rules as well as ILM Store.
- Configured SAP Landscape Transformation Replication Server (SLT) system for system decommissioning which replicated tables from SAP legacy system.
- Executed archiving of replicated tables using ILM LTCONFIG and ILM LTRUN.
- Opentext (IXOS) Archive Server 16.2: defined Content Repositories and updated Enterprise Library to implemented ILM Store.
- Work closely with the ABAP Development Team to develop custom code to enhance SAP ILM functionalities.
- Performed in-depth system analysis to identify areas of opportunity to reduce the data volume, create data archiving strategies and presented archiving solutions to upper management with the plan of implementation.
Confidential, Charlotte, NC
SAP Data Archiving Solution Architect
Responsibilities:
- Contributed to the Bank s global zero growth initiative of not increasing the infrastructure footprint.
- Designed and implemented effective Information Lifecycle
- Led data archiving effort to reduce the data footprint in creating a lean system for the migration to S/4HANA.
- Drove SAP archiving projects from analysis to proof of concept (PoC) to implementation.
- Performed in - depth system analysis to identify areas of opportunity to reduce the data volume, created data archiving strategies and presented archiving solutions to upper management with the plan of implementation.
- Worked closely with the legal team and business partners to create and document archiving, retention and deletion policies that satisfied legal, regulatory and business functional requirements.
- Utilized SAP standard delivered technology Archive Development Kit (ADK) as the foundation to manage and control the archiving solution process across SAP (ECCBW, Solution Manager and Bank Analyzer) systems.
- Configured, implemented and supported SAP archiving objects: FI DOCUMNTFI TF GLF, IDOC, BC SBAL, BC DBLOGS and BWREQARCH.
- Possess the technical and functional knowledge of the SAP Archiving Administrative functions which include configuring, testing and implementing archiving infostructurespartitioning and indexing.
- Designed and developed custom ABAP programs to automate and control the number of work processes for over 3000 Company Codes for the monthly Archive Write process.
- Worked with the Global Record Management team to setup retention periods based on legal, regulatory and internal guidelines to implement Information Lifecycle
- Management (ILM) policies for SAP data.
- Conducted workshops with data stake holders on the archiving process and the retrieval of archived data.
- In-depth knowledge of enhanced data lifecycle management in S/4HANA which includes Data Aging and SAP ILM.
- Configured, tested and implemented SAP Data Retention Tool (DART).
- Designed and developed custom ABAP programs to automate and control the number of work processes for over 3000 Company Codes across three ledgers for the monthly DART Extract processing.
- Worked closely with the Tax team and internal auditors to design, configure and implement SAP DART View layouts.
- Reduced turnaround time by 75% by automating the SAP DART audit requests Deliverables process.
- Generated and delivered SAP DART Views for ad-hoc audit requests from international, local and federal tax agencies in a timely manner so that the Bank did not incur fines.
- Delivered SAP DART Views of all line items for each of the 3000+ Company Codes to the IRS yearly to support the Bank s tax filing.
- Worked closely with the Tax team and internal auditors to provide SAP DART Views as supporting data for tax refunds.
- Conceptualized and developed an Archiving Solutions which saved the Bank ver $5M (Cost of: Software, Licensing and Support). With GNU utilities, Unix scripts were developed to process files from legacy systems that needed to be retained for integration into SAP at a later date.
- Worked in the Agile Framework using methodologies such as Scrum and Kanban.
- Utilized JIRA as Agile Lifecycle Management tool.
Confidential, Charlotte, NC
Sr. System Analyst
Responsibilities:
- Provided support for Front Office, Middle Office and Back Office which are the main users of the Fixed Income Trading System.
- Troubleshoot then resolved/escalated any problem(s) within the system that was reported.
- Worked with the Market Data group to troubleshoot then resolved/escalated issues such as data integrity, user entitlements or network communications.
- Communicated with Sungard (PHASE 3) to rectify any data discrepancies between their systems (FIRM12, FIRM51, FIRM53, FIRM54 and FIRM55) and the Trading System.
- This entailed troubleshooting, then resolve and/or escalate problem(s) which includes but not limited to network connectivity, missing tradesincorrect/incomplete trades issue.
- Unix Shell Scripting: Wrote shell scripts which utilized ssh and scp to somewhat mimic NFS among the application servers. Created shell scripts to automate frequently used and long tedious processes. Designed shell scripts that incorporated
- SQL that retrieved data from the database.
- Created, managed and maintained AutoSys jobs. This included creating and updating JILS. Troubleshoot, then resolved/escalated any Autosys job that either ‘Fail’ or ‘Terminate’ within the production environment.
Confidential, Charlotte, NC
Sr. Application Administrator
Responsibilities:
- Installed and upgraded Weblogic.
- Configured clusters within the AdminServer.
- Administered MQ Series between the Supply Chain System and Crossworlds. Created
- Queue Managers, as well as defined, altered and displayed channels and queues within the UNIX environment.
- Administered Java Messaging Service. Defined, altered and displayed Queue
- Connection Factories and Queues.
- Wrote PERL scripts to enhance processes within the systems; that included but not limited to, PERL scripts that manipulated data files that were generated by the application, which were then sent to external clients.