SUMMARY

• SAP Implementations: 10+ years hands on experience, 4 full life cycle implementation projects in BW with 7 upgrades in BI / BODS projects
• A total of 18 years of Information Technology experience with over 12 years in BI/BODS
• Proven record of 6 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 moving Shelf to Cash (STC) into Order to Cash (OTC) system.
• Designed, built, and implemented Interfaces to process coexistence Legacy-Financial data
• Vast experience in integrating non-SAP legacy data into SAP BI applications and how these objects can be integrated with BODS and HANA
• Experience in creating Gap Sheets based on the business requirements derived from working with business Owners and Subject Matter Experts (SME)
• Ability to develop and deliver Solution Options transform them into Functional and Technical Specifications based on the requirements gathered
• Planned, developed and Executed BI solutions during data migration into SAP systems.
• Complete understanding of BODS architecture, data processing, distribution, Data flow and how datasets are integrated into other non-SAP applications across the IT landscapes
• Expert in data migration using SAP Best Practices including: LSMW, IDOCs, and BAPI
• BODS ETL experience of financial, material, and customer datasets 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 the deliverable on-time
• 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
• Used SAP Information Steward to profile non SAP data before transformation and validation
• Experience in SAP Best Practices for data migration using LSMW, IDOCs, and BAPI
• Experience in building datastores for connecting to ext. sources from SQL Server to target
• 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 solution in data migration and as an ETL Tool
• Designed, developed, and implemented BW on HANA solutions on the OTC project

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 ServerSoftware 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, and 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 BW

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, Secaucus, NJ

SAP Sr. BODS DM 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, as part of SAP data migration
• Design and built complex transformations to process data for both Inbound and Outbound Interfaces processing of financial information - Time and expenses in data migration
• 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.
• Developed Data flows to Transfer Data from the silo systems into the targeted systems
• Expert in SAP BP in data migration to extract, profile, enrich, and validate source data
• 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
• Used SAP Information Steward to profile non SAP data before transformation and validation
• Experience in SAP Best Practices for data migration using LSMW, IDOCs, and BAPI
• Worked with LSMW, IDOCs, and BAPI to extract, transform, validate, and load to target system
• 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
• Administration of BODS objects using the Management Console

Confidential, NY

SAP Sr. BODS / BW on HANA Consultant

Responsibilities:

• Collaborated with the offshore team to leverage and engage with on-time deliverable
• Liaison between business and the offshore team on the project status and issues
• Provided BODS expertise during system downtimes, cutover, and housekeeping activities
• Designed, built, tested, and deployed SQL database tables to extract and load to and from Server
• Used BODS in data migration, i.e. legacy system and as an ETL tool into third party applications
• Extracted datasets from different file sources (flat files, xml, csv) and databases tables
• Developed sql jobs to extract financial and material related datasets into database tables
• Loading financial, customer and material related datasets to database tables and flat files
• Designed, built, and deployed BODS Jobs using different transforms (Platform, Integrator & Quality) in the work and data flows with conditions to meet business requirements
• Efficient and effective troubleshooting and data analysis techniques to meet business goals
• BODS performance tuning techniques to align source and target systems in data migration
• Designed, built, and implemented HANA information models for BW on HANA and SLT
• Built Open Hub to extract datasets from BW into third party applications
• Built efficient data flows to extract, transformed, and transfer dataset into HANA
• Migrated legacy systems (traditional BW on RDBMS) and reports into BW on HANA
• Administration of job scheduling, performance monitoring, error fixing, and use of autosys
• Used SAP Information Steward to profile non SAP data before transformation and validation
• Experience in SAP Best Practices for data migration using LSMW, IDOCs, and BAPI
• Designed, built, and implement database tables within MS SQL Server Management Studio
• Debugging, monitoring, tracing, and troubleshooting BODS Jobs to optimize performance
• Designed and deployed real-time jobs to implement address and data cleansing transforms
• Implemented SCD and CDC technology based on the business requirement
• Profiled data, created simple and complex rules in the Information Steward for data quality
• Implemented BODS performance tuning solutions to optimize query performance

Confidential, Houston, TX

SAP Sr. BW on HANA / BODS Consultant

Responsibilities:

• Communicated with the business owners and SMEs during report requirement gathering
• Developed functional specifications for RDC and SCM reports based on business requirements
• Developed BI solutions to include data flow, interfaces to be used, and select reporting tools
• Collaborated with offshore team on meetings, tasks, and other activities to meet the development and deployment of on-time deliverable of BODS solutions
• The design, built, and implement BODS solutions in data migration and as an ETL tool
• Worked with the SMEs of the source systems by mapping source fields to target characteristics
• Converted business and IT requirements into a functional specification and built TS
• Developed documentations and presented solutions to the business for approvals
• Experienced in extracting and profiling non SAP data using Information Steward
• Worked in team driven environment to collaborate and deliver BODS design solutions
• Highly motivated to work independently on specific tasks using BODS as an ETL tool
• Designed, built, and tested BODS solutions to achieve and meet the client business requirements
• Developed Jobs, efficient data flows, and effective transforms for performance optimizations
• Multitasking abilities while working in a fast paced environment to deliver solutions
• Implemented BW on HANA solutions from the traditional BW on RDBMS legacy system
• Designed, developed, and implemented BW on HANA solutions on the OTC project
• Worked with IDOCs (Debmas06, Cremas06, and Matmas06) and BAPI (Bapi acc doc post)
• Used SAP Information Steward to profile non SAP data before transformation and validation
• Experience in SAP Best Practices for data migration using LSMW, IDOCs, and BAPI
• Administrated job scheduling, monitoring, batch job configuration, and export jobs into autosys
• Developed both Batch and Real Time jobs with the conversion of XML data into target systems
• Prioritized tasks and managed time efficiently to meet deadlines and client business goals
• Designed, developed, and implemented Match and Address cleansing quality transforms
• Designed, developed, and implemented BODS solutions using CDC and SCD technologies

Confidential, Chicago, IL

SAP BODS /BI Consultant

Responsibilities:

• Collaborated with the team both on-shore and off-shore to deliver the BODS solutions on time
• Communicated with the business owners and SME to capture and gather business requirements
• Derived processes and data flows to be used during designing and developing of BODS objects
• Translated business requirements into Functional and Technical specification documents
• Strong data analysis, troubleshooting, and problem solving skills to deliver solutions
• Highly motivated to work independently as well as in a team driven environment
• Designed, built, tested, and deployed BODS solutions using CDC, and SCD Technologies
• Extracted, transformed, and loaded datasets from database tables into targeted applications
• Extracted, transformed, and loaded data from BI data mart into third party applications
• Migrated dataset from the legacy system into the SQL Server using BODS
• Experience in data migration using SAP Best Practices to extract, transform and load to target
• Worked with LSMW, IDOCs, and BAPI to extract, transform, and load to target environment
• Used SAP Information Steward to profile non SAP data before transformation and validation
• Worked with IDOCs (Debmas06, Cremas06, and Matmas06) and BAPI (Bapi acc doc post)
• Administration of job schedules and assigning uses to groups in DS Management Console
• SAP ECC and BODS integration to enhance extraction, transformation and loading activities
• Collaborated with basis team to upgrade BODS system to meet the client demand
• Used BODS in data migration, i.e. legacy system and as an ETL tool into third party applications
• Experienced in extracting and profiling non SAP data using Information Steward
• Documented all work related tasks and coordinated status activities to the management
• Managed and processed data for effective and efficient documentation purposes
• Worked to integrate BI datasets into other solutions - WFD, Kronos, Chesapeake using BODS
• Multitasking abilities while working in a fast paced environment to deliver solutions
• Prioritized tasks and managed time efficiently to meet deadlines and client business goals

Confidential, NY

SAP BW on HANA /BODS Consultant

Responsibilities:

• Defined gaps in business requirements, provide descriptions and Solution Options.
• Developing all objects of BI based on design of the data model and flow of the TS
• Working with the business and SME to capture all the KPIs and relevant fields for mapping
• Ability to transform the solution option into functional and technical specifications
• Designed, built, and tested BODS solutions to meet the client business requirement
• Integrated BI dataset into third party applications using BODS and in data migration process
• Multitasking abilities while working in a fast paced environment to deliver solutions
• Administrated job schedules, monitoring, and fixing errors in DS Management Console
• Associated databases with Repositories and registered them in CMC
• Performance tuning of the systems to align execution of source and target objects
• Worked with LSMW, IDOCs, and BAPI in data migration to transform and load data to target
• Built and deployed HANA information models on BW on HANA after legacy system migration
• Prioritized tasks and managed time efficiently to meet deadlines and client business goals
• Worked in team driven environment to collaborate and deliver BODS design solutions
• Highly motivated to work independently on specific tasks using BODS as an ETL tool

Confidential

SAP BODI BODS / BW Consultant

Responsibilities:

• Worked with users to resolve Remedy Tickets stemming from BODS data extraction issues
• Provided Development work, Operational, and Support to break-fix user ticket issues
• Involved in BI Releases and cutover activities making sure objects released are operational
• Extracted dataset from different sources systems, applied transformations and load into targets
• Used different transforms (Platform and Integrator) to build efficient data flows
• Worked with IDOCs and BAPI in migrating SAP data into other SAP target environments
• Documentation activities including: functional, technical and component test designs
• Ability to review peers TDs and CTPs of other developers and provide guidance for BA approval
• Worked with the BA, Army Functional Team and Service Management team for approval
• Efficient data management and processing techniques for consistency and governance
• Worked in team driven environment to collaborate and deliver BODI/BODS design solutions
• Experience in using data Insight application in profiling non SAP data prior to loading to target
• Scheduled, monitoring, and tracing of jobs using the Management Console
• Highly motivated to work independently on specific tasks using BODS as an ETL tool
• Ability to work in a team driven environment to apply skills set to get the job done
• Strong data analysis and performance tuning skills to maximize query performance

Confidential, Indianapolis, IN

SAP BODI/BI/Data Load Consultant

Responsibilities:

• Ability to administer definitions, configurations, updates and database objects for data integrity
• Knows how to add process server and a queue for the process automation.
• Collaboration with the team to satisfy customer requirements
• Ability to work in a team driven environment to apply skills set to get the job done
• Translated business and functional specifications into technical specification
• Experience in FDA regulated industries especially in pharmaceutical sector
• Efficient data management and processing techniques for consistency and governance
• Experience in data migration using LSMW and IDOCs to transform and load data to target
• Worked in team driven environment to collaborate and deliver BODI/BODS design solutions
• Highly motivated to work independently on specific tasks using BODS as an ETL tool
• Efficient used of Data Insight to profile non SAP data before transforming and loading to target
• Ability to perform end-to-end developing, extracting and transforming datasets using flat files
• Extracting datasets from the Oracle databases into sql Server application
• Extraction of datasets from heterogeneous file sources into SQL Server