Professional Summary

• Having 10 years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including 6 years in SAP SAP BI 7.0, SAP BW 7.0 SAP R/3 4.7 ECC 6.0 .
• Good functional knowledge of SD, MM, HR, FI, COPA, CRM modules.
• Implemented 2 life cycles in BW and having BI 7.0 ECC 6.0.
• As an Analyst Prepared Technical Design, reviewed Functional design preparing Blue print design.
• Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Functional specifications writing, Use Case development, Analysis Organizational skills.
• Proactive team player with excellent interactive communication and Interpersonal skills.
• Focused, goal oriented and ability to work as a good team member.
• Good communication skills, interpersonal skills, self-motivated, quick learner

SAP-BW Expertise

• SAP-BW Functional Consultant experience involves system study, analysis, design development, integration, testing and implementation.
• Very good experience of SAP BW Components like Info Cubes, DSO, Multiprovider, Info Source, Info Objects, DSO Objects, Transformation.
• Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
• Worked extensively with Sales Order, Billing, Delivery Schedule Line and Document Condition HDR and ITM objects.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks Excel work sheets and created Custom Queries using Conditions, Exceptions, Variables Structures and created Aggregates for frequently used Queries.
• Expertise in BW Accelerator to improve the query performance.
• Experience in send data from SAP-BW system to other systems Via Open hub Services.
• Unit, integration, performance testing and Participated in design reviews.
• Experience in connecting legacy system/Non SAP System via DB connect, and pulling data in SAP-BI system.
• SAP Business Object and BI integration. Exposure in BO Query Support, Crystal Report, Dashboard, Web Intelligence, Universe, java info views.

Technical Skills

• Business Intelligence : SAP BW 7.0 and BI 7.3,
• ERP : SAP R/3 and SAP ECC 6.0
• Reporting : BEx Report Designer, Web Application Designer WAD , BEx Web Analyzer, BEx Analyzer, Dashboard
• Functional Module : SD, MM, CRM
• Programming Languages: XML, JAVA, J2EE, JSP, ILERPG, SQL

Professional Experience

Confidential

SAP BW Consultant

Responsibilities:

• Analyzed the requirements, performed a gap analysis with respect to the data model needs and available business content.
• Created technical specifications verified business content and created Data model.
• Activated available Business Content per BW data model infocubes, ODS objects etc. , Created the custom ODS objects for item confirmations Created custom infocubes, Mutliprovider, update rules and transfer rules, necessary infopackages, info objects, infosources etc.
• Created Process Chains to automate the loading process for master data attributes, texts, hierarchies and transactional data Initial and Delta loads .
• Coordinated the BW transport collection using the BW Transport connection on BW side. Managed the transports between Dev, QAS and PRD systems. Validated the transported objects upon transport.
• Involved in fixing Delta load failure while extracting data from R/3 to BW.
• Generated reports using BEx Business Explorer with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, drilldown methods.
• Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.
• Effectively handled Flat file and master data loading to the DSO's and Cubes.
• Handled effectively the change requests for the DSO's and Cubes and queries.
• Worked on creating transport requests and Releasing to the test and production servers.
• Customized InfoObjects, DSO's and Infocubes.
• Resolved many issues that came in production support.
• Coordinated with Users on the BEX queries, maintained Jump targets, variables assigned workbooks to roles, Configured Bex Browser.
• Validated the BW design/data model, development, and data at every stage.
• Prepared necessary documentation on Blue Print, Data Model, Technical design and specifications, Data validation, Testing Procedures, Sizing, Data load procedures, Cutover Plan etc.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.

Confidential

SAP BW Consultant

Responsibilities:

• Worked extensively with Administrative Work Bench AWB for creating InfoObjects, InfoCubes, DSO, MultiProviders, InfoSources, Transformation and Data Transfer Process DTP
• Created Functional specifications based on the business requirements in SD module.
• Involved in setting up procedure to extract R/3 data for SD using LO, Generic Extraction and customizing to the requirement using Business Content.
• Worked on activating the standard business content infocubes 0SD C01 Customer and 0SD-C03 Sales overview .
• Enhanced Sales Infocube with a custom field and a standard database field to meet the user requirements.
• Involved with performance tuning of queries by maintaining Aggregates, compression, partition of info cubes.
• Created a Dashboard with the Net Sales value report by Calendar years and drilled down further by Quarter, Sales Organization, Sales Offices and Sales Reps using Bex tools Analyzer, Query Designer and Web Application Designer .
• Developed a proof of concept for Business Planning with BPS and IP.
• Created a Sales Report, designed it in Visual Composer Model and published it into the SAP Enterprise Portal in the form of iViews.
• Delivered Documentation for all new objects and enhancements.
• Interacted with Power users for report generation.

• Conducted workshop training for the end users on BEx tools and various reports execution.
• Enhanced Business Content, Data Sources with delivered/custom InfoObjects Key figures. Activated Business Content as required.

Confidential

SAP BI Analyst

Responsibilities:

• Monitored data loads Flat file and R/3 on daily basis and effectively handled many extraction errors during data load.
• Monitored SCORE on SQL Server reporting tool.
• Effectively handled Flat file and master data loading to the DSO's and Cubes.
• Handled effectively the change requests for the DSO's and Cubes and queries.
• Worked on creating transport requests and Releasing to the test and production servers.
• Resolved many issues that came in production support.
• Worked extensively on administration workbench RSA1 .
• Customized InfoObjects, DSO's and Infocubes.
• Extensively used BEx Analyzer and Query Designer for building Queries.
• Created the process Chains and automated the load process based on the business needs.
• Involved in developing the User exits for the Bex Reports and developing the complex Calculated Keyfigures.
• Involved in developing the DSO, Cubes, Web Templates, Bex Reports and other BI objects.
• Monitor and control project work. Identifying the scope verification process for the project deliverables and responsibility for formalizing acceptance from end-users for the completed project deliverables.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
• Involved in fixing Delta load failure while extracting data from R/3 to BW.
• Extensively worked on Administrator workbench for configuration, scheduling and monitoring functionality.
• Involved in Transporting the BW objects from development server to Quality server for Integration testing and Unit testing.
• Generated reports using BEx Business Explorer with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, drilldown methods.
• Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.
• Involved on setting up user notification upon process failure.
• Created many universes to integrate with BW infocubes and Non-SAP data from Oracle database
• Worked on many reports using BO components like Web Intelligence, Xcelcius and Crystal reports.
• Extremely worked on BW integration with Business Objects.
• Created Dashboards and visualization with BI data using BO components.

Engineer -Software Development

Confidential

Responsibilities:

• Provide software application analysis, development, testing, documentation, maintenance and implementation of IT solutions, in the mid-range environment and Java application.
• Analysis, writing Functional and Technical specification, Visio flow diagrams.
• Migrated AS/400 display files to web-enabled using Webshpere WDSc5.1.2 Adv Edition 111704 .
• Wrote, modified, integrated and tested RPG/400, CL/400 codes.
• Converted AS/400 display files to web related pages and maintained functionality of both the technologies AS/400 Websphere.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
• Maintained existing RPG, ILERPG and CLP programs by making modifications as required.
• Provide software application analysis, development, testing, documentation, maintenance and implementation of IT solutions, in the mid-range environment and Java application.
• Analysis, writing Functional and Technical specification, Visio flow diagrams.
• Formulate and devise technical solutions for problems through the use of automated systems.
• Maintain existing J2EE application and created new Java applications.

Programmer

Confidential

Responsibilities:

• Wrote, modified, integrated and tested RPG/400, CL/400 codes.
• Maintained existing RPG and CLP programs by making modifications as required optimizing performance.
• Analyzed Product Support Calls, coded, debugged and tested.
• Implemented and maintained application on AS/400 Server as well as on Websphere.
• Converted AS/400 display files to web related pages and maintained functionality of both the technologies AS/400 Websphere.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
• Provide software application analysis, development, testing, documentation, maintenance and implementation of IT solutions, in the mid-range environment and Java application.
• Analysis, writing Functional and Technical specification, Visio flow diagrams.
• Formulate and devise technical solutions for problems through the use of automated systems.
• Maintain existing J2EE application and created new Java applications.

Trainee Software Engineer

Confidential

Responsibilities:

• Wrote, modified, integrated and tested RPG/400, CL/400 codes.
• Maintained existing RPG and CLP programs by making modifications as required optimizing performance.
• Learned the concepts of AS/400 technology.
• Analyzed Product Support Calls, coded, debugged and tested.
• Implemented and maintained application on AS/400 Server as well as on Websphere.
• Converted AS/400 display files to web related pages and maintained functionality of both the technologies AS/400 Websphere.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.