Mohammed Ahmedullah SAP BI Certified Consultant

Email: acukid@r.postjobfree.com

Mob: +44-798*-******

Profile Summary

• Overall experience of 8 Years in SA BO Design Studio.

• Strong analytical and problem solving skills.

• Capable of understanding the business environment and translate business requirements into technical solutions.

• Capable of working as a Team Member or individually with minimum supervision.

• Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies.

• Good Communication and Interpersonal skills with the ability to interact with end-users, managers and technical personnel.

IT Experience

SAP BI Skills

• Scheduling of master data and transaction data loading on different time spans with the concept of background jobs and process chains.

• Working out different Staging scenarios with PSA and without PSA.

• Experienced on maintaining ABAP routine in PSA and DTP to load data for the current and previous month for COPA Analysis.

• Creating and adding of different InfoProviders, InfoSets, MultiProvides.

• Good knowledge on using of BEx components: - Web Application Designer (WAD).

• Deployment of the WAD on the Web Portal, Creation of roles for the web reports and assign the same to the users.

• Worked on different types of extractors like FI, HR, CO, CRM, LO Extractors, CO-PA and Generic Extractors.

• Process orient administration using Process chains and Reporting agent.

• Monitoring of Data loads and finding, rectifying the cause of the error.

• Knowledge and experience in ABAP programming.

• Modelling of different BI objects Info cube, DSO, Master data objects, Remote cubes, MultiProviders.

• Experienced in extending and activation of Business Content.

• Worked on extracting the data from APO system after the creation of CVCs and planning areas.

• Experience in OLTP and OLAP performance tuning which includes maintenance of Aggregates, Compression, filling up of OLTP Cache, PSA partition, Parallelising data upload on PSA and DSO

• Working out different Staging scenarios with PSA and without PSA.

• Experienced in Extracting Master data and transactional data both from flat files, SAP CRM 6,

ECC 6 and

SFDC via Informatica.

• Good knowledge and Experience on Integrated Planning real time InfoCubes and Input ready Queries.

• Server space maintenance by achieving the old historical data to legacy system.

• Monitoring and Scheduling the Broadcasting settings.

• Experienced in upgrading the existing Datasource of 3.5 version to 7.0.

• Process Chains monitoring, BWA indexes, Report broadcasting.

• Created Roles and Analysis Authorisations for user of different regions.

• Responsible for system housekeeping, clearing up the table space, data load and reporting performance improvement initiatives.

• Delivery of UAT test case and End user and Power user training.

• Experienced on Business Objects XI 4 Web I Reports (as a dashboard) and Design Studio.

• Knowledge on ETL tools like BODS, SLT and Informatica. SAP HANA Skills

• Knowledge of HANA and used cases.

• Strong Analytics, Data warehouse and modelling experience using SAP Business Objects Data Services and SAP HANA.

• Implemented the Analytic Views, Attribute Views and Calculation View artifacts in HANA.

• Strong experience in SAP HANA XS

• Good programming in SQL / SQL Script (HANA).

• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.

• Strong experience in using BODS as an external system for ETL between ECC and BI.

• Created various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.

• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Company : MIMI SoftwareTechnologies Limited, UK

Industry : Information Technology

Role : SAP BI/BW Technical Consultant

Environment : SAP BI 7 and Flat file & ECC 6.

Period : September ‘14 – January ‘16

• Understand the Functional Specification Document and Analyse the project requirement.

• Analyze the Report requirement, Design and Data Flow, Data sources and their dependences along with their condition and restriction in it.

• Developing a process to upload the transactional data from the respective source system.

• Developed and Scheduled a master data and transaction data loads on different time span with the concept of background jobs and process chains.

• Developed the AWB objects based on the uploading requirement.

• Creation of various levels of Authorisation Roles and assigning the same to the users.

• Prepare test document to reconcile the SAP BW data with the Source system data.

• Monitoring of Data loads and finding, rectifying the cause of the error.

• Sending out the notification to the users up on the failure of the data loads along with the estimated time of data availability.

• Creating OSS Messages and working with SAP for critical production issues.

• Production move and support.

• UAT testing, End user and power user training.

• Responsible for system housekeeping, clearing up the table space, data load and reporting performance.

Company : NTT DATA INC

Industry : Information Technology

Role : Team Lead – SAP BI

Environment : SAP BI 7 and ECC 6.

Period : September ‘10 – August ‘14

NTT DATA is a 11 billion dollar company, founded in the year 1967 and headquartered Tokyo, Japan An NTT DATA has about more than 52,000 dedicated employees across America, EMEA, China and APAC It has recently acquired about six major IT companies including INTELLIGROUP, ITELLIGENCE, KEANE, MISI, The REVERE GROUP & VERTEX and It’s now one of the top six IT companies in the world... Honeywell TurboSystems

September 2013 – August 2014

FM Divestiture

(One of the Honeywell’s vertical “Friction Materials” is acquired by Federal Mogul. And they decided to separate the SAP ECC systems for Federal Mogul and maintain the same SAP BW system for both Honeywell and Federal Mogul users in the first phase. And later in the 2nd phase SAP BW system will carved out for Federal Mogul.)

θ Worked as a Senior BI Consultant.

• Preparing the design plan, activity plan, time line schedule and cut-over plan.

• Identifying the completed data flows of the Friction Material and preparing the inventory list from the same.

• List down the Source system dependents objects of the Friction Material to be moved to the new ECC system.

• Establishing the RFC connectivity between BW and new ECC.

• Capture and re-import the SS dep objs in the respective BW systems by maintain the conversion of SS name after import.

• Ensure the complete data flow is pointing to the new ECC SS without impacting the existing flow which was pointing to Honeywell ECC SS.

• Testing on IDoc transfer and TRFC queue clearance with the new ECC.

• Identify the commonly used master data to restrict the master data loads from the new ECC system to prevent any changes that would impact the existing data in BW.

• Creating new roles to the Federal Mogul users based on the new Org Structure and test them on both BW development and quality environment.

• Loading the new Org structure data from the new ECC to BW and test the important report metric from all the modules.

• Perform initialization to all the delta Datasources in BW for the new ECC SS and ensure the delta queue is active in the new ECC.

• Restrict the new Org Structure in BW for all the Datasources of Federal Mogul.

• Append the existing Process chains with the Infopackages of the Datasources of Federal Mogul. Honeywell TurboSystems

March’ 2013 – August 2013

SAP BW 7.3 EHP1 SP7 grade

θ Worked as a Senior BI Consultant.

• Co-ordinate with business and basis team for initialization activities for upgrade and testing.

• Performing the SPAU and SPDD activities in development and till to production.

• Prepared object inventory list for testing as part of the pre upgrade activities, interfaces list and test cases as part of the post upgrade activities.

• Testing the functionalities in the SAP BW 7.3 EHP1 environment and ensure that the new features/ functionalities are working and also ensure existing functionalities are not impacted.

• Identifying any issue after the upgrade and ensure the same is fixed.

• Tested the objects for full load, delta and performance after BI upgrade.

• Ensure that the object is delivered with quality and on time.

• Planning the Cutover activities for production and ensure smooth Go Live in production.

• Attend daily meetings with BI COE and Basis team and update the pre-upgrade & post-upgrade testing, issues and technical objects status.

Honeywell CorpGA

June’ 2011 – Feb’ 2013

SAP BI 7 Supports

θ Worked as a Senior BI Consultant.

• Monitoring daily, weekly & monthly loading and reporting activities.

• Working on high priority tickets and enhancement tickets within the SLA.

• Working with Basis team to fix the issues related to Basis.

• Fixing issues related to Authorization.

• Creating OSS Messages and working with SAP for critical production issues.

• Re-initializations in case of enhancement on standard business content data source.

• Worked on maintaining the user exit source system to extract the required value during run time for the report requirement.

Honeywell TurboSystems

Sep’ 2010 – Jan’ 2011

Honeywell Turbo Technology – Golobal Proto Profitability Analysis. θ Worked as a BW Consultant.

• Understand the Functional Specification Document and analyze the requirement.

• Developing a process to upload the transactional data from the respective ECC system.

• Developing a process to upload the Master data.

• Developed the AWB objects based on the uploading requirement.

• Creation of user defined reports and hosting them on Web Portal.

• Creation of site specific Roles and Roles assignment to users

• Data loading and Extensive testing

• Production move and support.

Honeywell TurboSystems

Sep’ 2010 – Jan’ 2011

Honeywell Turbo Technology – Global Proto Profitability Analysis. θ Worked as a BW Consultant.

• Understand the existing process setting up meetings with the users and come up with a To-Be process.

• Understand the blue-print for the project which contains the details on the existing process and the To-be process and plan for any developments for the gaps between the existing processes.

• Prepared the data flow design document for the objects that needs to be developed.

• Developed the object based on the design and deliver the same ensuring the quality of the delivered object.

• Ensured that the object is delivered with the quality and on time.

• Attended weekly meetings and update technical objects status.

• Involved in integration testing of the deliverables.

• Creation of site specific Roles and Roles assignment to users.

• Production move and support.

Company : TVS-E ServiceTec

Industry : Manufacturing & Service Industry

Role : IT Support (SAP BI)

Environment : SAP BI 7, CRM 6 and ECC 6.

Period : July ‘08 – September ‘10

TVS-E Servicetec is a part of TVS Investments Limited – belonging to the US$ 3.5 billion TVS group with a heritage of customer centricity for over 90 years. TVS-E Servicetec Limited provides Warranty & Post warranty support for the TVS Electronics range of Computer Peripheral Products. Leveraging its capability to provide consistent quality services pan-India; it made foray into installation & Support of Brand Owner warranty products as diverse as Cell phones, Point of sales Devices, Desktops/Laptops, Credit Card Terminals, ATMs, Petro-station automation projects & Telecom Base Station Projects. TVS-E ServiceTec

Jan’ 2010 – Sep’ 2010

CRM – Telecom Sales & Services Reports

Users: HTC, Huawei, Haier, Sony Eriksson, Kinpo, and TATA brand owners and 150 TVS-E ServiceTec ASPs all over India.

θ Worked as a BW Consultant.

• Modelling of InfoCubes, DSO as per client reporting requirements which are related to CRM -Call Handling work stream

• Creation of Transformation and routines for source DSO to reporting InfoCubes

• Creation of user defined reports in Call Handling work stream.

• Creation of Process Chain and checking the load performance.

• Created Calculated Key Figures and Restricted Key Figures, Formulas, Variables for Selection screen and Replacement Path.

• Assigned authorization to various users.

• Maintained Customer Exits at CMOD for various logics.

• Designed BEx reports as per the user requirement. TVS-E ServiceTec

Mar’ 2009 – Dec’ 2009

ECC – Nokia Telecom Sales, Services and Consumption Details Users: Nokia L4 Plant (Delhi) and ASPs

θ Worked as a BW Consultant.

• Identified and analyzed the requirement.

• Modelled the entire architecture based on the requirements gathered.

• Created the DataSources, Transformations, Data Transfer Processes.

• Created Data Store Objects and InfoObjects.

• InfoSet using inner and outer join with the DSOs.

• Creation of Process Chain and Checking the load performance.

• Daily monitoring the data load on RSPC.

• Created Calculated Key Figures and Restricted Key Figures, Formulas, Variables for Selection screen and Customer Exit.

• Designed BEx Qureirs and reports Analyzer and Web Application Designer.

• UAT testing and End user and power user training. TVS-E ServiceTec

July’ 2008 – Mar’ 2009

CRM - Dell Call Management Details using BI 7

Users: TVS-E Head Office & ASPs

θ Worked as a BW Consultant.

• Activated and Replicated the Standard DataSource of Service Header, Item and Status from Services & Activity DataSource from Sales.

• Appended the Extraction Structure for the customized fields.

• Customised the Business Content according to the user requirement.

• Involved in Designing & Creation of DSOs and extracted the data form CRM system, stage the data at PSA before loaded to the target.

• Report to report interface from summarized InfoCubes to detailed DSO objects.

• Creation of Process Chain and Checking the load performance.

• Have designed detail reports on Calls along with the Business Activity on BEx Analyzer and BEx WAD.

• Also have published a DashBoard using function modules in Customer Exit.

• UAT testing and End user and power user training. Functional Experience

Company : SMH Marketing (UK)

Industry : Marketing International Whole sale / Retail marketing company Role : Accounts Assistant (Part time)

Environment : Sage 50 Professional, MS Excel Reports. Period : July ’06 to June ‘08

SMH Marketing is one of the leading media based marketing companies of UK based in London. The company aims always at low rice and high volume of sale. Their major clients are one.tel, Orange, 3 mobile, iBitStore, Auction World and Dell.

Role and Responsibilities:

• Responsible for Planning, forecasting and budgeting process of the business.

• Providing reports on detail analysis of every product (like the fast and slow moving products, dead and active stock, percentage of net profit from individual product etc.).

• Involved deeply in making business strategies with the higher authorities.

• Worked extensively on SAGE Instant Accounts and SAGE 50 Professional.

• Maintained the purchase and sales accounts.

• Experienced in reconciliation nominal ledger and balance sheet.

• Regular exercise on Bank Reconciliation Statement.

• Preparing the financial report of the business every quarterly, half yearly and annual.

• Regular interaction with the directors and discuss the business activities.

• Have provided Ideas and Suggestions for the business growth.

• Have managed the overall business with utmost dedication, sincerity and consisting to time management. Technical Capabilities

ERP Packages : SAP ECC 6, SAP CRM 6, SAP BI 7

Languages : C++ and Java

Databases : MS-Access and SQL

Operating Systems: Windows 2000, XP, Vista and 7.

Packages : MS-Office, Open Office, SAGE Instant Accounts, SAGE 50 Professional and Sisense Prism Cubed.

Certification

SAP Certified Solution Consultant in NW2004 – Business Intelligence (UK) TBW10 mySAP BI – BW Data Warehousing

TBW20 mySAP BI – BW Reporting & Analysis

TBW30 mySAP BI – BW Data Staging & Extraction

TBW40 mySAP BI – BW Modelling Authorization

Advance Diploma in Network Centered Computing,

NIIT (National Institute of Information Technology) Chennai, India. Training

• BOXI 4 Dashboard, Web I Reports

• SFDC / Informatica

• HANA

Education

• Master of Business Administration – Charles Stuart University - London, UK.

• Bachelor of Commerce University of Madras

Achievements

• University Centum Scorer

• School Topper Award Winner

• Accounts Topper in School and University

• Outstanding Performance Award for contributing towards the growth of the company’s revenue – NTTDATA References available on request.

Contact this candidate