We provide IT Staff Augmentation Services!

Senior Sap Bi/bw Consultant Resume

NC

SUMMARY :

  • Successful Information Technology professional with around 9 years of diverse and extensive experience focusing on systems analysis and design, training documentation and systems migration. Proven achievements in providing hands-on guidance with SAP BW/BI and other software applications deployment to end-users. Global industry experience includes Service oriented and consumer products manufacturing
  • Around 9 years experience in SAP BI/BW & SAP ABAP, Worked on many projects like Implementation, Development, Maintenance, Migration/upgradation and support projects SAP BW implementations following ASAP methodology- Developing the project plan, blueprinting the requirements document, statement of works for the different sources, info provider manual, data modeling and design, realizing the BW configuration, extracting data and transporting ,preparation various test scripts to various environments and final prep of performing go-live check.
  • Extensive knowledge of SAP R/3, SD, MM, CS, QM, IM, FI, PM and SCM with respect to BW from project planning to go-live support.
  • Expertise in extractions from SAP R/3 using LO Cockpit, Generic Extractions,CO-PA and non-SAP R/3.
  • Experience with SAP R/3, BI7.0, ETL. Data modeling, Meta data and Reporting and performance tuning
  • Expert in Data Modeling, data extraction, designing, creating, maintaining and analyzing Info-Cubes, DSO, DTP,ODS objects,WODSO,Open Hub, Remote Cubes, Real time cubes Multi Providers, and Info-Sources, Extract Structures, Update rules and Transfer rules.
  • Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries. Using calculated and restricted key fig Created Custom Queries using Conditions, Exception aggregates, Variables & Structures, Information Broadcasting, RRI - Jump queries and created aggregates for frequently used queries, and Trained End-users.
  • Familiar in creating the planning applications using BI Integrated Planning in creating the Planning models, Aggregation levels, Variables, Data Slices, Characteristic Relationships, Planning functions and Planning Sequences and Input enabled Queries
  • Familiar With Business Objects, Universe creation,Adhoc reporting,Webi
  • Highly motivated, and eager to develop rapidly and take on greater responsibility
  • Highest level of professionalism, solid work ethics, committed to excellence and willing to learn

TECHNICAL SKILS :

ERP

SAP BI7.0/ 3.5/3.1/3.0B/2.1C SAPR/3 Version 4.6B, 4.6 C 4.7 ,ECC6.0

New dimension

BW IP

OS

WINDOWS 95/ 98/2000/NT/XP.

RDBMS

ORACLE 8x, Oracle 9x, MS-Access.

Languages

ABAP/4, C, C++, SQL, PL/SQL.

Reporting tool

Business explorer,WAD,WEBI

WORK EXPERIENCE:

Confidential,Andover, MA Nov10 -Till Date
Senior SAP BI/BW Consultant

  • Responsibilities:
  • Involved in the analysis phase to collect the key requirements (KPI’s), met top tier business stake holders credit department VP’s, finance department directors for North America
  • Prepared functional design (FD) documents and technical design (TD) preparation for Back end and Front End objects based on the requirements from key business stake holders.
  • Working Q2C projects to deliver Supply Chain data and involved in data modeling and preparation Architectural Blue Print Documents, POC.
  • Extensively worked on building custom infocubes, standard and direct update DSO’s.
  • Created Transformations as per the business logic using ABAP.
  • Extensively involved the creation of start routine, expert routine and end routine. Involved in the creation customer exit variables using CMOD
  • Enhancing the logistics extractors and extracted data to BI
  • Familiar with Creation of Universe and WEBI Reports
  • Worked on creation of Generic Extractors and Enhancements of various extractors based on Business requirements
  • Developed Inventory Reports, Aging WIP report & Unscheduled Order book reports
  • Developed Backlog reports for upsides, risks and Govt Orders
  • Developed reports for CAD Accuracy and SDQ KPI
  • Extensively tested the developed objects and prepared testing scripts. Participated in change control team for defect prevention/correction and approving changed/additional requirements
  • Worked in the creation of several Bex reports using exceptions, conditions, cell definitions, offsets, replacement path and written user exit variables and working knowledge in creation of WEBI reports.

Environment SAP BW 3.5, SAP BI 7.0, and SAP ECC 5.0/6.0.

Confidential,NC Mar10 - Oct 10
Senior SAP BI/BW Consultant

Responsibilities:
As part of GBT projects Team lead involved in the implementation, enhancements of various BI Projects

  • Involved in requirements gathering, preparation of Functional and Technical documents
  • Design and Development of Lucy integration project
  • Developed Reports to find Open allocated Qty
  • Developed the report for the salesemply determination
  • Involved in the implementation of Outdoor reconciliation project
  • Involved in the implementation of IP enhanced sales to bw
  • Extensively involved in the Extractor enhancements, development of infocubes, DSO, start routines, expert routines & end routines
  • Data extraction from SAP and Non SAP

Environment: SAP BW 3.5, SAP BI 7.0, and SAP ECC 5.0/6.0.


Confidential,Andover, MA Apr 07 - Dec 09
Senior SAP BI/BW Consultant

Responsibilities:

  • Identified data sources based on end-user reporting requirements, and Create InfoCubes from data extracted from different modules like SD & MM using LO Cockpit
  • Involved in Data Modeling, data extraction, designing, creating, maintaining and analyzing Info-Cubes, DSO,DTP,ODS objects, Remote Cubes, Multi Providers, and Info-Sources, Extract Structures, Update rules and Transfer rules
  • Installed BW Statistics and wrote queries on it, to find out the frequency of usage of each info object and hierarchy.
  • Involved the CS Restructure design ,creating EODS layer and transformation layer and worked on CS,QM & PM extractors
  • Worked on improving the cube and query performance by building suitable aggregates and other tuning techniques.
  • Design, Customization & development of InfoCubes, ODS,DSO,DTP, Multi-Cubes, Remote Cubes, InfoObjects, InfoSpokes, Hierarchies, User Exits, Data sources, update rules, transfer rules and start routines
  • Worked with BEx Analyzer, BEx Browser and BEx Query Designer for developing reports and worked on Web Reporting using BEx Web Publisher and created Web Templates for various scenarios using Web Application Designer , RRI report, creation of variants, replacement path variables, conditions, exception aggregates and variable offsets, customer exit variables
  • Experience in Data Modeling, R/3 and Non R/3 Data Extraction, BEX Reporting (including Web Reporting), Functional Analysis, Design, Implementation, Troubleshooting and Performance Tuning
  • Worked on Sales order ,service order and Equipment user and system status to provide latest status of the documents for business community
  • Worked on Ideal P & L Project to provide the low level profit and loss values to the business community
  • Developed various start routines, update rules and transfer rules
  • Optimized the performance of data targets (Info cube, ODS, Multicubes) by loading the data through proper selection criteria and maintained the request for each data load to compress it in the future and maintaining proper aggregates
  • Worked on Go TOP Supply Chain project to provide the data to third party database through informatica and worked on interfacing 3rd party systems and deploy BW data through Info Spokes

Environment :SAP BW 3.5, SAP BI 7.0, and SAP ECC 5.0/ 6.0.

Confidential, Nov 06 – Jan 07
SAP BI/BW Consultant

Responsibilities:

  • Used BW Content extractors to extract data from EDW to BW.
  • Generic R/3 Data Extraction.
  • Experienced in Data Modeling, data extraction, designing, creating, maintaining and analyzing InfoCubes,ODS objects, Remote Cubes, Multi Providers, and Info-Sources, Extract Structures, Update rules , Transfer rules & start routines
  • Created/Modified InfoSources for Master Data (Attribute and text) and Transaction Data.
  • Modified the user exits to populate the custom fields added to the Data Sources.
  • Involved in the designing various ODS as per the client requirements.
  • Created/Modified and activated Transfer Rules and maintained Communication Structures.
  • Set the Update Rules for InfoCube and uploaded data into the InfoCube.
  • Developed ODS object to load transaction data from InfoSource and defined update rules.
  • Loaded transactional data into PSA and updated data from PSA to ODS and activated ODS for reporting.
  • Created InfoPackage group to schedule InfoPackages to load regularly and also automatically triggering the attribute change run. And created several Process Chains

Environment: SAP BW 3.5, SAP R/3 4.7

Confidential,Sydney, AUS Apr 05 - Nov 06
SAP BW Consultant

Responsibilities:

  • Involved in the Re-initialization of Various Business areas like DP, GD, PP, and TP.
  • Analyze the errors in the data loads and guide the corresponding team
  • Mange the data targets by having the correct and up to the date data to the markets
  • Monitor the data loads from various source systems like R/3, CRM, and SEM &APO by means of process chains.
  • Manage master data, text and hierarchies
  • Responsible for the root cause of various problems and directed the offshore team with correct resolution.
  • Involved as on call support person for various problems
  • Roll up data from info cubes to aggregates and maintain the aggregates...
  • Maintain jobs in BW, SEM, CRM, and APO and Developed Load packages and Process Chains
  • Importing transports from the development systems to the production system.
  • Perform manual actions before and after the importing the transports

Environment SAP BW 3.0/3.5, and SAP R/3 4.7,SAP SEM,CRM,APO

Confidential,India Feb 04 – Feb 05
BW Developer

Responsibilities:

  • Created/Modified InfoSources for Master Data (Attribute and text) and Transaction Data.
  • Modified the user exits to populate the custom fields added to the Data Sources.
  • Involved in the designing various ODS and Infocube as per the Business requirements.
  • Created/Modified and activated Transfer Rules and maintained Communication Structures.
  • Set the Update Rules for InfoCube and uploaded data into the InfoCube.
  • Developed ODS object to load transaction data from InfoSource and defined update rules.
  • Loaded transactional data into PSA and updated data from PSA to ODS and activated ODS for reporting.
  • Created InfoPackage group to schedule InfoPackages to load regularly and also automatically triggering the attribute change run.


Environment :SAP BW 3.0/3.5, SAP R/3 4.6C

Confidential,India Jun 02 – Jan 04
SAP BW/ABAP Developer

Responsibilities:

  • Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization; Alpha Conversions, Tracing problem to R/3 and resolution.
  • Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, V3 Updates, controlled by pull/push principle from OLAP system.
  • Extensive experience in data design, data modeling, star schema and extended star schema, ASAP methodology, Info Cube partitioning, Setting customized Info Cube. Data extraction from R/3 and Flat file; SAP BW delta load, Info package creation, IPG.
  • Resolve and implement BW Query faults (Day to Day) and change requests.
  • Involved in Bex Query Design to produce the reports for the analysis purpose and formatting.
  • Coding and Preparation of test plan, Documentation for the Work requests.
  • User Acceptance test and Performance test for the Objects to be delivered.
  • Developed a Report for to display consignment and stock position details.
  • Developed a Report for open sales orders.

Environment: SAP BW 3.0/3.5, and SAP 4.6C

Hire Now