SUMMARY

• A senior SAP BW/BI Consultant Total 9 + years of experience wif 8 +years of experience in IT industry, including 3 full life cycles implementations experience in SAP BW 3.5,BI7.0, BW 7.3 and production Support of SAP BW/BI
• Involved in Understanding teh Business Processes, Organization Structure, Functional Specifications and identification of relevant areas for Customization.
• Implementation in teh area of Insurance, Sales and distribution (SD), Finance and Controlling (FICO),Accounts Payable (AP), Accounts Receivable (AR),Material Management(MM).
• Good planner and organizer wif demonstrated ability to master new concepts quickly, in corporate teh latest technology and develop business solutions dat increase efficiency, productivity, and profitability.
• Proficient in creating and customizing Info Source, InfoObject, Info cubes, ODS Objects, Remote Cubes, MutiProviders, and Infoset and noledge of BI data flow, which includes creating Info Cube, Data store by using Transformations, Data Transfer Process (DTP).
• Extensively worked on Extraction using various methods LO Cockpit, Generic, CO - PA, FI/SL.
• Worked on POC, BW COE, Integrated Planning(IP)
• Worked on Integration of SAP BI and BO
• Worked on Crystal reports
• Working on migration project BI 7.0 to BW 7.3
• Expertise in BW - Analysis, Configuration, multi-dimensional modeling.
• Worked on SAP Net Weaver 2004s BI (Transformations & Data Transfer Process) and migrating 3.X data sources into BI 7.0.
• Analyzed teh GAPS in SAP provided Business content extractors and Data sources to enhance them or to create new extractors using Generic Data Extractors.
• Experience in BW Architecture, Multi Dimensional Modeling, Data flow strategy, Source System, Data Source, Data modeling (Star Schema), Info Source, Info Objects, PSA, Data Targets, ODS (DSO), Multi Providers, Info cubes, Info spokes, process chains, Lo-cockpit - Enhancements, BExQuery Designer BEx Analyzer, Info sets, Query Optimizations wif new concepts.
• Worked on LO Cockpit, FI-AR, FI-AP, CO-PA and Generic Extractions.
• Experience in web application development and web reporting, Web portal and extensive experience in Front End BW components like Workbooks, Queries, Calculated key figures, Restricted key figures, structures, variables, Formula Variables, Filters, Restrictions, Conditions, Navigational attributes, Publishing reports to portal, Authorizations, Role Maintenance, Adhoc Reports and Web Reports etc.
• Transferred data from Info Provider to Flat Files by using Open Hub (Info Spoke) and loaded data to teh data targets from different sources (R/3, Flat Files).
• Expertise in teh Performance techniques like Performance tuning, Aggregates, Compression, Indexes, Statistics and Rollups (Performance Improvement).
• Involved in documenting Functional specifications, Technical specifications, Test cases, Test results and Production support documents.
• Involved in writing ABAP programs to create (Transformations) update rules and transfer rules, start routines, End routines
• Supported all phases of a project life cycle including analysis, design, development, configuration, testing, and development of solutions, as well as documentation, and end user training.
• Worked on New concepts in SAP BW 7.3, Infospoke BADI migration to Open Hub Destination Schematic Partitioning etc.
• Good Knowledge on SAP HANA
• Working on BI 4.0

TECHNICAL SKILLS

ERP packages: SAP R/3 Release 4.6B, 4.6C, 4.7, ECC 5.0/6.0, EP 6.0/7.0, Netweaver’04, NW2004S, SRM 4.0, CRM 4.0/5.0, BW 3.5/7.0/7.3

SAP BI: SAP BI versions BW 7.3,BI 7.0, BW 3.5

Operating Systems: Windows 9x/00/XP/NT, UNIX, LINUX, IBM AIX, SUN- SOLARIS, HP-UNIX

Reporting Tools: Business Objects (XI 3.1, 4.0), Web Intelligence, Desktop Intelligence, Info View, Dashboard Manager, Crystal Reports 2008, Xcelsius 4.5/2008, SAP Integration Kit.

Databases: Oracle 9i/10g, DB2, MS SQL Server, MS Access

Languages: SQL, PL/SQL, ABAP/4, C, C++, Java, Visual Basic

Others: MS Office, MS Outlook, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, IL

SAP BW Team Lead

Responsibilities:

• Working on agency Economics Project Contributing to all aspects of SDLC, including gathering of requirements, business and technical assessments, back-end and front end designs reviews, data validation, QC support and training
• Implemented new methodology to teh agency program to pay under new variable structure wif great values of agency success factor and customer satisfaction
• Maintain, monitor and execute teh BW/BI process chains as per teh requirement.
• Analysis of teh Production issues and provides support to Business Users in a timely manner.
• Co-ordination wif teh Basis, Security and other teams as required.
• Documenting any changes, issues as required following teh SDLC practices.
• Suggesting any design changes for teh Performance improvements.
• Coordinating to offshore to work wif project deliverables.
• Involved in Portal, Query upgrade, 11g upgrade projects as part of SAP BI 7.3 Upgrade.
• Established daily, Period end (Monthly) process to balances data across upstream and downstream systems.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, BI 7.0,BW 7.3, Business Objects (XI 3.1,4.0), Windows server NT/2003

Confidential, IL

SAP BW BI Consultant

Responsibilities:

• Launching teh data loads as per client requirement on daily basis.
• Scheduling BW jobs, monitoring these Schedules on Process Chains Monitor and BW monitor.
• Responsible for Monthly Period End process loads for data coming from R/3.
• Data Extraction from R/3 and flat file, loading teh extracted data into BW data targets.
• Designed and Developed Process chains for automating teh Batch data load of Claims, Premiums, Sales and Expense data coming from Mainframes system.
• Involved in Performance Tuning and Data Maintenance by creating and maintaining Aggregates, Compression, Partitioning and Indexing of Info Cubes.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI 7.0, Windows server NT/2003

Confidential

SAP BW BI Consultant

Responsibilities:

• Worked on Agency Compensation System Re-write, Analyzed requirements and translated them into Multi-Dimensional Data Models to BW Star Schema.
• Involved in developing teh ETL documents and extracting data from SAP R/3 using Generic extraction.
• Extraction of History data from mainframe systems in flat file
• Design and develop teh data flow in BW wif respect to functional and Technical Specs.
• Worked on Reports, CR Projection Models and Report year Accident year models in Confidential as per client requirements.
• Worked on Transportation of Queries and work book and maintain all security related documents ensure dat avoid bottle necks.
• Worked on Enhancement Queries based on user requirements

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI 7.0, Windows server NT/2003

Confidential

SAP BI Consultant

Responsibilities:

• Replacement of GPSIS
• Migrate teh Current application to new architecture
• Creation of Reports Which Describes many available buyer, supplier and commodity information.
• Provide Supplier’s monthly performance data in EBSC
• Provide a global view of commodities: Value of business, which suppliers deliver a commodity and which buyers buy it
• Interface teh GPSIS system to current portals
• Participated in creating reports on annual sales comparison, gross margin %by store, monthly sales report city and brand, product wise sales analysis, Quarterly sales report and stock related reports for teh Mobile store.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI 7.0, Mainframe, Windows server NT/2003

Confidential

SAP-BI Consultant

Responsibilities:

• Continuous job monitoring using BW Monitor; Handling tickets which involve solving issues in teh area of data Extraction from R/3 and Flat File, data staging and BEx reporting
• Developed reports using Bex Analyzer,Bex Query Designer and WAD
• Schedule Daily/Weekly/Monthly - data loads schedule new jobs.
• Maintaining Reconciliations to verify teh data in SAP R/3 and SAP BW are same or not after teh data loads.
• Monitoring of info packages and analyzing teh reasons for teh frequent failures of info packages.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI 7.0, CRM, Windows server NT/2003

Confidential 

SAP BW Consultant

Responsibilities:

• Worked extensively on enterprise data warehousing (EDW)-InfoObjects, dso’s, InfoCubes
• Experience in new design concepts like remodeling and repartioning.
• Hands on experience in controlling data flow using Infopackages, transformations, various dtp's and process chains.
• Extracted teh transaction data by LO Cockpit from R/3 to BW by maintaining teh extract structures, maintaining data sources, replicating teh data Sources into BW
• Activate and extract data from LO-Cockpit, Schedule and Monitor teh load process.
• Involved wif Performance tuning of Queries by maintaining Aggregates, Compression, and Partition of InfoCubes.
• Involved in Data Extraction from CRM transaction data sources like activity, lead and opportunity.
• Involved in creation of reports on CRM transaction info cubes activity, lead, opportunity

Environment: SAP R/3 ECC 6.0, BEX Analyzer, BI 7.0, CRM, Windows server NT/2003