PAWAN SINGH
Cell No: 09958035478
SOFTWARE : SAP BW/HANA (7.0,7.3 AND 7.4)
REPORTING TOOL : BO(4.0.4.1)
LANGUAGE : SAP ABAP
EXPERTISE : BW Implementation and Support.
EDUCATION Completed MCA From IGNOU (IndraGandhi National Open University, India).
B.A from BheerVadhurSinghPurvanchalUniversity,India.
PROFESSIONAL SUMMARY: A professional with a combination of technical skills, customer services skills, business acumen, user/technical training, and strong interpersonal skills. These skills are supported by a strong work ethic, customer focus and a “can do” attitude.
More than 3.4 years of IT experience in SAP BW, ABAP custom development involving all phases of the package development life cycle to meet the business needs.
EMPLOYMENT HISTORY:
Worked in FirstChoiceSolutions as A Sap Bi Consultant.
Duration: November 2014 to Till Date
Key Projects handled:------
Company : FirstChoiceSolutions
Client : Rolta
Projects : Implementation And Support
Environment :HANA 7.4
Role :BW Consultant
Client Details:
Rolta is an Indian company for CAD, CAM, business intelligence and big data solutions, geographic information system solutions, EBusiness and related services headquartered in Mumbai. Rolta has executed projects in over 40 countries
Responsibilities/Deliverables:
· Interacting with IT managers and Users for gathering Reporting requirements.
· Provisioning And Replicating data From Source System to Hana Database Using SLT And
Business Objects Data Services.
· Replication of Selected Tables of SD From ECC to Sap HANA Performed Transformation During The Replication Process.
· Knowledge of Advanced DSO And Open DSO Using hana.
· Knowledge of Sap In memory Computing Architecture, Column Store,Row Store Tables in Hana Studio.
· Extensively worked on LO cockpit for activating data sources and scheduling jobs for them.
· Business content installation for Finance, SD.
· Enhancement of data sources according to business requirement.
· Designed Multi providers for reporting purposes.
· Prepared End User training documents.
· Automation of transaction data load.
· Created Process chain for loading data from SAP R3 to BW.
· Created Transformation, Info packages and DTP’s for master data info objects.
· Created Transformations, Info Packages and DTP’s for Transaction data info providers.
· Created Custom queries on the basis of user requirement.
· Created Process chains for loading data from ECC to BW .
· Created Linked Data Manager Packages for data loading.
· Created Transformation files In BW.
Company : FirstChoiceSolutions
Client : Delta
Projects : SAP BW 7.3 Support
Environment : BW7.3
Role : BI Consultant
Client Details:
Delta Air Lines, Inc. is a major American airline, with its headquarters and largest hub at Hartsfield–Jackson Atlanta International Airport in Atlanta.
Responsibilities/Deliverables:
· Design and developed the whole data flow from ECC to BW.
· Business content installation for Finance, Controlling and Project system.
· Enhancement of data sources according to business requirement.
· Extracted data from DataSourcE 2LIS_11_VASCL, 2LIS_12_VCITM, 2LIS_08TRTLP& 2LIS_11_V_SSL DataSources
· Enhanced the extractors to meet the reporting needs for users.
· Designed MultiProviders for reporting purposes..
· Prepared End User training document.
· Installation of standard Business Content in BW.
· Created Process chain for loading data from SAP R3 to BW.
· Created Transformation, Info packages and DTP’s for master data info objects.
· Created Transformations, Info Packages and DTP’s for Transaction data info providers.
· Created Process Chains for master data and transaction data load to BW.
· Trained Client’s people in SAP BW.
· Wrote ABAP routines for different client needs.
Company : FirstChoiceSoutions
Client : Singapore Post
Projects : BI Support
Environment : BI 7.0
Role : BI Consultant
Client Details:
Singapore Post Limited, commonly abbreviated as SingPost, is an associate company of Singapore Telecommunications Limited and Singapore's designated Public Postal Licensee which provides domestic and international postal services.
Responsibilities/Deliverables:
· Developed EDW layer for all the Modules except Inventory.
· Installed 30 queries according to business needs.
· Created flat file data sources for uploading attributes of info objects and transaction data to different cubes.
· Developed Customer exit variables for reporting needs.
· Enhanced the extractors to meet the reporting needs for users.
· Created DSOs and cubes.
· Enhanced the existing cubes and changed the logic for characteristics in transformations of the existing cubes.
· Developed around 6 Multiproviders on new cubes.
· Modified Process Chains and developed new Process Chains.
· Created & maintained info Objects, custom data sources, transformations and DTP’s.
· Developed APDs (Analysis Process Designer).
· Developed mapping tables in BI which were used in routines.
· Involved in day to day production support.
· Unit testing for different tasks executed with in team for delivering Quality work.
· Wrote Routines in Transformations.
· Created Process Chains to Automate Data Load, Created Meta chain to connect different chain and automated the daily and weekly loads.
· Activation of BIW contents from Business Content and Metadata repository and generation of Z cubes & DSO.
· Data modeling in BW (Info Objects, Info Sources, DSO, Info Cubes, Info sets, Transfer/Update rules, Transformation).
· Extraction of data from R/3, flat files. Creating Info Packages, DTP etc.
· Created Report level Condition to Restrict data, Based on Report Requirements.