CURRICULAM VITAE

Name : PHANI.N SAP BI CONSULTANT

E-Mail : sbkq83@r.postjobfree.com

Mobile : +91-846*******

---------------------------------------------------------------------------------------------------------------------------------

OBJECTIVE:

To obtain a position as a SAP BI Consultant, where there will be opportunities to utilize my technical skills and experience in the development and implementation of cost-effective and customer-friendly solutions in building an enterprise data warehouse.

PROFESSIONAL SUMMARY:

• Having 3+ years of experience in SAP BI.

• Extensively worked in Business Information Warehouse Info Cubes, DSO Objects, Info sources, Info objects, Extractors, Info packages, Info objects Catalogs, Data Sources, Data Extraction, Characteristics, Key figures and Process Chains.

• Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues, Compression of Info Cube and Rolling up the data to the Aggregates.

• Good knowledge on BEx Analyzer Queries, Workbooks, Web templates and Web Reports, structures, variables, calculated key figures, restricted key figures, reporting, extracting data from SAP R/3 using Generic extraction, LO and FI.

• Involved in creation of SAP BW objects as per user requirements.

• Involved in maintenance of Info Objects, Info Cubes, DSO, PSA, Info Source, Data Source & Info packages.

• Knowledge on loading the Flat files from Application server.

• Transportation of objects to different systems.

EMPLOYMENT HISTORY:

• Working as a SAP BI Consultant in ADEQUARE INFO Pvt Ltd. Hyderabad from Feb 2011 to tilldate.

• Worked as a BI Consultant in ICICI Prudential Amc ltd. Mumbai from June 2009 to Feb 2011.

• Worked with WIPRO, Bangalore as a BI consultant since Nov 2008 to June 2009

TECHNICAL SKILLS:

Data Warehouse : SAP BI 7.0

ERP Packages : SAP R/3 4.7, SAP NetWeaver ECC 6.0.

Reporting Tools : SAP-Bex

Operating system : Windows 98/2000.Windows NT, DOS.

Database : Oracle 9i

EDUCATION:

• B.E. in Electronics & Instrumentation Engg from MADRAS University, Dharmapuri.

PROJECT EXPERIENCE:

Project # 1:

Client : TRIA BEAUTY

Duration : Feb 2011 to tilldate.

Environment : BI 7.0

Team Size : 6

RESPONSIBILITIES:

Organizing MEC (Month End Closure) Calendar review meeting and involved in MEC activities.

Involved in two activities Monitoring and Production support.

Involved in submitting the Ticket Status (Open/Close) report.

Involved in tickets related to extractions, Performance Issues and also load failures like monitoring of Info packages.

Maintaining Work History for all the tickets until is closed down.

Interacting with the clients to discuss about the open issues.

Actively and Regularly involved in Load Monitoring of Daily, Weekly, and Monthly, Data Loads using Process Chain

Solved tickets Extensively Worked in building Queries using Calculated and Restricted key figures, Structures, Variables with User Entry/Default Value.

Involved In Development of BW Objects as per CRs.

Used generic extraction (RSO2) to extract the custom data from SAP R/3 to BI.

Developed the Process Chain to atomize the data loads.

Uploaded master and transactional data from files and SAP as the OLTP source Customized InfoObjects, InfoSources and InfoCubes.

Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets

Project # 2:

Client : ICICI Prudential Mutual Fund

Duration : June 2009 to Feb 2011.

Environment : BI 7.0

Team Size : 8

MODELLING:

Modelling and creating BI objects like InfoObjects, InfoCubes, Multiproviders.

Creating and managing data flow using DTPs, Transformations and InfoPackages

Build multiple DSO objects, transformations, DTP’s and loaded the data to PSA and then to DSO

In Logistics Extraction Cockpit: Maintained extract structures. Generated data sources & activated the extract structures. Scheduled data uploads in cockpit.

Established the data extraction process with necessary transformations and conversions in the transfer rules & update routines.

Installed Business Content Sales Overview Cube. Designed and activated customer service cubes to meet user needs. Created several DSO Objects which act as data staging.

Created different data sources for ATTR and TEXT using generic extractor and replicated all the data sources to BW

Created Aggregates to improve the query performance.

Transported the developed objects from development system into consolidated system

Developed front-end reports using Business Explorer and WAD.

Followed different ways for unit testing to produce high quality testing.

TESTING:

Done the unit testing on all data targets in BW. Run the different queries on cube and DSO and Checked the Master data (Text).

Done the unit testing on Multi providers. Run the different queries on M.P checked each and every Query Characteristics and key figures and compared with the data targets.

Project # 3:

Client : CHEP PORTFOLIO (S.A)

Duration : Nov 2008 to June 2009

Environment : BI 7.0

Team Size : 8

RESPONSIBILITIES:

Scheduling and Monitoring the Data loads by means of Process Chains.

Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

Involved in extracting data from R/3 and Flat files etc.

Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

Preparing reports on weekly basis.

( PHANI. N )

Contact this candidate