SUMMARY

• SAP Implementations: 15+ years hands on experience, 8 full life cycle implementation projects in BW and BODS with 12 upgrades in BODS projects
• A total of 22 years of Information Technology experience with over 12 years in BODS
• Proven record of 12 years hands - on ETL and Data migration implementations using BODS
• Complete understanding of POS systems and how it is used in Retail industry
• Provided solutions in Manufacturing and Quality determination of varied products.
• Vast experience in integrating non-SAP legacy data with BODS into S4/HANA database
• Ability to develop and deliver Solution Options, transform them into Functional and Technical Specifications based on the requirements gathered
• Planned, developed and Executed solutions during data migration into SAP systems.
• Extensive work on Generic, Business Content installation, building Info Cubes, and DSOs, Info Objects, BEx and BOE reporting.
• Complete understanding of BODS architecture, data processing, distribution, Data flow and how datasets are integrated into other non-SAP applications across the IT landscapes
• Proven records in BODS integration with both SAP and non-SAP applications
• Used BODS to connect to Cloud Based databases or applications to extract and transfer datasets
• Experience in BODS in designing, building, and deployment of BODS solutions
• BODS ETL experience on financial, material, and customer data into targeted applications
• Used BODS Transforms (Platform, Integrator, & Quality) to develop and build applications
• Extensive experience in Production support, housekeeping, downtime, PtQ, & PtP activities
• A focused problem solver with strong organizational and analytical skills yet able to work independently or collaborate with team members in a proactive manner
• Capability in managing and leading team members in producing on-time deliverables
• Ability to perform end-to-end developing, modeling and transforming datasets using BODS
• Expertise in BODS with skills on databases, data warehousing, mining, and analyses
• Experience in building datastores for source and targeted systems connectivity
• Focused in development and maintenance of databases and applications across landscapes
• Experience in database and application performance tuning to achieve optimal performance
• Experience in design, built, and deploy BODS solutions in data migration and as an ETL Tool
• Consistent administration of the BODS Server and management of user accesses
• High proficiency in BODS Add-on applications - DQM, Information Steward, and Microservices

TECHNICAL SKILLS

BODS: Jobs, Work and Data flows, Scripts, Platform, Integrator, Quality Transforms, and DSMC

SAP BI Client Tools: Webi, CR4E, IDT, UDT, AOLAP, AOFFICE, Lumira 1.17

SAP BODS: Designer, CMC, DSMC, Repository, Job Server, Access Server, Address Server

SAP BODS Add-on Applications: DQM, Microservices, and Information Steward

Software: MS Office, Visio and Project 2003, MS Project Servers, BEx Query Designer and AnalyzerR/3 Enterprise 4.6c & 4.7, mySAP ERP, SAP NetWeaver 2004s, BODI/BODS 4.xThird Party tools DocNav, Qlikview, Lotus Notes & My Test Tool

Programming and Applications: SQL statements, ABAP, SLT

Servers: Apache Tomcat, SQLServers, Oracle 8i, Windows 2003 server, R/2, R/3 Development

Databases: Oracle 8i, MS SQL Server, DB2, Sybase, and S/4 HANA

Operating Systems: Windows (2000 Pro, XP, Vista, 7, and Servers), Unix, Linux and SLES11SP1

Architecture: Pentiums, Core, Inter-core, Multicore, Nehalem, and Westmere editions

SAP Project Implementation: Methodology -- ASAP Roadmap; Phases Project Preparation, Business Blueprint, Realization, Final Preparation, Go live and Support, and FLC Implementation in SAP BODS

Software Development Landscape: Developmental, Quality Assurance and Production Environments

ERP Package: SAP R/3, 4.0, 4.7, BW3.5, BI 7.x, APO and OSS; FI, AR, AP, SL, CO, MM, PP, COPA

System Landscape: Eclipse Environment - AWS via SAP CLOUD Appliance Library (SAP CAL), SLT

PROFESSIONAL EXPERIENCE

Confidential

SAP Sr. BODS Lead

Responsibilities:

• Designed, built, and implemented Interfaces to migrate data from Oracle database into HANA
• Provisioned user Accesses and managed other BODS Server Administration
• Managed the documentations and resources for all the BODS employees and Consultants
• Delivered BODS Architectural solutions during data migration and in new projects
• Engaged in resource selections, interviewing, and placement on specific expedited projects
• The Installation of DQM and Microservices on BODS Server for MDG for Customer address validations
• Integration of DQM Components for the MDG Customer address
• Designed, built, and implemented Interfaces to manage Manufacturing and Quality paint products
• Designed, built, and implemented Interfaces to process POS Data
• Production Support engagement and management for daily data refresh for reporting
• Resolutions and management of all ticket levels production support issues
• Used ETL, Data Warehousing, database concept, and Data Quality experiences on varieties of projects
• Established connectivity into the Cloud Based databases for data
• Migrating on-premise objects, databases, and applications onto Cloud Data Center
• Provided consistent production support, all cut over, and deployment activities
• Lead the team both onsite and offshore in the development and the deployments of objects

Confidential, Atlanta, GA

SAP Sr. BODS Consultant

Responsibilities:

• Designed, developed, built, and implemented interfaces to bring data into SQL Server database
• Managed onsite and offshore team in the design, built, and the deployment of objects
• Managed the BODS Server administration and DQM Component configuration
• Handled DQM installation and implementation for MDG customer address validation
• Provided architectural solutions and object development to the project
• Worked with the functional team for all requirement gathering and generating documentation
• Used my experience in ETL, Data Warehousing, Database Concepts, and Data Quality
• Handled all production support issues and object deployment role for all bods related projects

Confidential

SAP Sr. BODS Consultant

Responsibilities:

• Design, built, and implemented Interfaces to process financial coexistence-legacy data
• Design and developed BODS objects: jobs, workflows, dataflows, datastores, and file formats - XML, XSD
• Design and built complex transformations to process data for both Inbound and Outbound Interfaces processing of financial information - Time and expenses
• Inbound interfaces to extract dataset (Engagement, Time & Expense) from the legacy system (financial systems on the Unix Server) into SAP staging tables and updated both systems with error handling mechanisms
• The Outbound interfaces extract (Eng., Time and Expense) from the SAP systems, generated XML files using specific schemas, and ftp the files into the legacy system.
• Developed error handling mechanisms as an interface, processed error records from the legacy system into SAP for reprocessing, and moving the files into archival folders.
• Provided performance tuning to all the interfaces to reduce the processing times
• Developed Scripts of sftp get and sftp put to receive and send XML files to the legacy system
• End-to-end testing of the objects as part of the testing life cycles including: FUT, TUT, SIT, UAT, MOCKS, Performance Testing, UCT, Dry run, and go-live activities
• Developed materials as part of the Workshop activities in both testing, Cutover, and pre-prod.
• Administration of BODS objects using the Management Console
• Provision of solutions to BODS related issues as part of performance tuning and support
• Providing Production support to the co-existence interfaces for both up and downstream data.
• Liaison between business and the offshore team on the project status and testing issues
• Provided BODS expertise during system downtimes, cutover, and housekeeping activities