OBJECTIVE:

Seeking the position of SAPBI/BW Consultant that offers professional growth to utilize my skills and abilities in SAP Business warehouse.

SUMMARY:

• PMP Certified IT Consultant with over 17 years of work experience in ERP and S/W development; of which 10 years of work experience on SAP.
• Over 10 years of experience as SAP - BI consultant involving active participation in analysis, design and development of full life cycle implementations coupled with Production support and upgrade experience.
• Hands on Experience on SAP-BODS, HANA-SDI, SAP-BOBJ, HANA.
• Experienced on Confidential ( Confidential ) ERP Package and developed various business applications on AS400 platform using ILE RPG, RPG/400, CL/400 and SQL400.
• Functional experience in the areas of Production and Marketing.
• Experience with systems development life cycle (SDLC) and ASAP methodologies
• Excellent communication/interpersonal/analytical/ presentation skills with problem solving abilities.

TECHNICAL SKILLS:

Data warehouse: BI7.4, SAP-BODS 4.x, HANA-SDI, SAP-BOBJ (XI 4.0), and HANA.

ERP: SAP-CRM, SAP R/3 (SD), Confidential (World Soft)

Languages: ABAP/4, RPG/400, CL/400, SQL/400, ILE RPG

Markup Languages: HTML 4.0 and DHTML.

RDBMS: Oracle 8 and SQL Server, DB2-400

Operating Systems: Windows NT 4.0, OS/400

Reporting tools: Business Explorer (BEx) Query Designer, Web Application Designer, BEx Analyzer and BEx Browser, SAP-BOBJ

PROFESSIONAL EXPERIENCE:

SAP BI Consulting Contractor

Confidential

Environment: SAP BI 7.5, SAP BaS, SAP ECC, SAP-CRM, HANA

Responsibilities:

• Rescheduled the Bex reports as part of the BW migration to HANA
• Replicated tables from Source systems like SAP-Rm, SAP Banking, SAP Bank analyzer through HANA-SDI replication tasks and Flow Graphs.
• Experience developing end to end data flows for all the data models and BW models in HANA eclipse environment
• Created Composite Providers, ODS View, Advanced DSOs as a part of development.
• Optimized the existing Data models to Hana optimized objects
• Modelling of ADSO, Composite Provider and Views in HANA Studio.
• Creation of Functional specifications from business requirements to design and develop BW/HANA objects
• Created Advanced DSO’s (ADSO) in place of Cube for better performance and replaced Multi-providers with Composite providers for reporting.
• Eliminating Infosets by creating unions and joins with Composite Providers to combine data from 2 info providers.
• Performed reporting for Data visualization on Analysis for office and Crystal reports by connecting with Bex queries
• Analyzed the existing queries for real time reporting requirements.
• Replicated and tested the ECC, BaS tables to SAP HANA.
• Worked as a member in a 12 member team, Involved in Development, and Support activities
• Conducted the workshop for requirement gathering and designed the SAP BI data flow
• Worked on the fit gap and designed the data flow from BAS & CRM into SAP BW
• Extensively Used SAP ABAP in Start, End & DTP Routines and followed the SAP standard
• Extensively used Characteristic, Text and Formula Variables using default, replacement path and customer exit processing types
• Created 4 BOBJ WEBI report using BICS on top of Bex queries.
• Handled the operational tickets and maintained the work History for all until it is closed down
• Also worked as on-call support team member.
• Create and execute cutover plan for successful deployment.
• Prepared estimates for the work assigned and submitting detailed resource plan with milestones for the work to be carried forward.
• Handle calls with the stake holders and gather the pain areas and accordingly assess the probable solutions.

SAP BI Consultant

Confidential

Environment: SAP BI 7.3, SAP ECC, FI/CO, SRM, SD, MM, Oracle, Windows NT

Responsibilities:

• Extracted Supply Network Planning data from SAP SCM into SAP BI
• Created generic extractors based on table and view in SAP SCM system
• Created Open Hub Destinations to Application Server in Flat structure
• Conducted the workshop for requirement gathering and designed the SAP APO BI data flow
• Developed the ABAP Code in Info Package, Start Routines, Field Routines and End Routines
• Created Master Data Info Objects, Info Cubes, and DSO’s as per the requirement
• Created Queries on business requirements.
• Extensively used Characteristic, Text and Formula Variables using default, replacement path and customer exit processing types
• Collected and transported all the developments from DEV->TST->PRD of SCM & BW without issues
• Maintained Functional Specification, Design and Technical Specification Documents for future reference.
• Helped business users in creation of test plans with respect to changed functionality and imparted training to support team on the changed functionality

SAP BODS Developer

Confidential

Environment: SAP BO Data Integration Designer XI 3.2, Oracle, Flat File System, Windows NT

Responsibilities:

• Created BODS-Interfaces to fetch data from Flat files and load Oracle tables.
• Data analysis, modeling, and profiling using SQL Server and Data Services, to provide new and improved structures and aid in data quality checks related to conversion efforts.
• Created transforms, used built-in functions, and written scripts to map source data to target tables.
• Performed source data assessment using Data quality & data profiler transforms and validate data by validation transform.
• Set up datastores to connect the source system: database, flat file and excel file.
• Used validation rules to populate messages for mandatory columns.
• Configured SAP BW/Application datastore to connect SAP BW/ECC data
• Set up RFC server in both BODS and BW sides, created infosource and open Hub in BW side.
• Created Fact & Dimension tables and written scripts and using functions for transforms.
• Used interactive debugger, setting up of error handling and audit to ensure correct data transformation.
• Completed the transforming and loading of Fact & Dimension tables to the target.

SAP BI Systems Analyst

Confidential

Environment: SAP BI 7.1, SAP ECC, FI/CO, PCA, SD, MM, Oracle, Windows NT

Responsibilities:

• Responsible for requirements analysis, process flows, functional configuration and implementation of new requirements.
• Designed and developed Web Intelligence reports using best practices.
• Created complex BEX reports as source for the BO reporting tools
• Modified and developed new dataflow for the backend development
• Combining data from sales and planning info provider with business logic for analytic cube
• Worked extensively in fixing the UAT issues and closely coordinated with business users to solve the issues.
• Provided customer support on the functional/technical issues encountered in the production system.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5, SAP R/3 4.6B, FI/CO, PCA, SD, MM, Oracle, Windows NT

Responsibilities:

• Understanding in existing ABAP logic’s for issue resolution and able to perform the customer exit ABAP
• Designed the Process Chains for job scheduling for all the new developments and adjusted the existing one where necessary
• Created Customer exits, Formula variables, Characteristic variables, Text variables, Hierarchy and Hierarchy Node variables as part of the deliverables
• Created Hierarchies and managed them by direct input & by flat files
• Created customized data sources and designed the flow and Involved in developing the tools to check all the query properties, Query Usage, Variables used
• Created data loading steps, estimates and DB size estimations documents and also estimated effort sheets for the created Change requests
• Extensively involved in enhancing the Data sources, DSO and Cubes
• Participated in Fit- Gap analysis, workshops and KT sessions to users and support team
• Involved in user training for the new reports

SAP BW Consultant

Confidential, Nashville

Environment: SAP BW 7.0, SAP R/3 4.6B, FI/CO, SD Oracle, Windows NT

Responsibilities:

• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Monitoring of Process chains and analyzing the reasons for failures of Extractions.
• Maintaining Reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Dealt with custom extracts, DSO, custom data sources, user exits, BEX queries, hierarchies, workbook macros, Web Application Designer and Bex analyzer.
• Involved in extracting non-sap data by creating Generic Extractors using Function Module and view
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data. Used jump queries, Restricted Key Figures, Calculated Key Figures, Conditions, Variables, Structures, exceptions and navigational attributes in BEx to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

SAP BW Consultant

Confidential

Environment: SAP Netweaver 2004S BI-7.0, SAP R/3 4.6B, FI/CO, SD, Windows NT

Responsibilities:

• Enhancement of SD data sources 2LIS 13 VDITM, 2LIS 12 VCITM and 2LIS 11 VASTI.
• Broadcasting the SD reports to the customer
• Out bound Billing Item data to other environment.
• Month end and yearend Financial closing support
• Implemented strategy to Migrate 3.x Data Sources to 7.x Data Sources.
• Involved in Migration of all 3.0B Queries to BI 7.0.
• Testing of Front end and backend functionalities in the new environment.
• Did extensive stability and regression testing of the 3.x front end of BI7.0 (Excel analyzer and Query Designer)
• Did regression testing of the Enterprise portal interface to BI
• Enhanced query performance using BW Statistics, query read modes and aggregates
• Activation of Standard Business Content, Customizing and creating Custom Cubes according to the Functional Requirements.
• Created and Modified Multiproviders, Infocubes, DSOs, InfoObjects and Infosets in order to meet the end user reporting requirements

SAP BW Consultant

Confidential

Environment: SAP Netweaver 2004S BI-7.0, FI/CO, SD Windows NT

Responsibilities:

• Extracted data from SD Module like Order, Delivery and Billing Data sources using LO Cockpit.
• Developed ODS objects to load delivery item Data from the Info source 2LIS 12 VCITM, defined the update rules.
• Scheduled data loads from R/3 to BW and optimized the load performance by adjusting the packet size, data selections and number of Info Packages.
• Extensively used calculated and restricted key figures, structures, variables and conditions for the queries.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
• Working extensively on the development of Process Chains for Master and Transaction Data and invoking various follow up actions.
• Develop BEx Queries using Free Characteristics, Filters, Calculated Key Figures, Restricted Key Figures, and Variables in BEx Query Designer.
• Create Transports to Transport BI Objects to Quality and Production environments
• Written conversion programs to convert the data in the Existing Confidential application.
• Converting AS400 tables in to PC Files and Uploading data into R3 server using LSMW.
• Mapping of Confidential objects like Production type and Customers with SAP objects.
• Creation of interactive ABAP query reports and storing in user defined transaction code.
• Migration of Master data from Legacy System to SAP using LSMW.
• Instrumental in seamless switching of their Finance application from Confidential to SAP.