SAP Consultant at Shell

Shell Canada
SAP Consultant
08.2008 - today
• Extensively worked on requirement analysis and preparation of High-level specification document, Functional Specification document
• Created Info Objects, Info Packages, Info Providers (InfoCubes, Multiproviders , Virtual Providers), Process Chains & Data Store Objects (DSO)
• Fix errors occurred in BI (e.g. SID errors, Referential Integrity errors, Dead Lock errors etc).
• Monitor BI System periodically to check the performance of the BI and ECC Systems
• Created Data Source (Master Data Attributes, Transaction Data and Text) based on flat Files, ECC Tables and Views.
• Created Open Hub to transfer the data to Non SAP Systems.
• Developed and Modified Start and End routines in ABAP
• Used Modularization techniques in ABAP routines development like Functions, Macros, Include and sub routines to meet the business requirements
• Created Bex Queries and worked on Bex Analyzer to build Reports using different functions
• Created and Monitor batch jobs in ECC using TCodes (SM36 and SM37) and BI (Process Chains)
• Created Aggregates and used Roll-ups to populate the Aggregates
• Used Rollups, Collapse, Reconstruction options in InfoCubes
• Worked on the partitioning of the BI
• Modified the Dimensions using Re-modelling.
• Created and Maintained Indexes in SAP BI 7
• Worked with SAP Business Objects Team.
• Created Universe using joins, resolved loops, functions, derived tables, LOVs, Objects and Classes in Oracle and SAP BW environment.
• Created links between Universe
• Used Desktop Intelligence to test the queries
• Created Webi Reports using queries, tables and charts, breaks and cross-tabs, complex filters (Report level and global level), calculations & report filters etc
• Created Crystal reports, Organizing the data, Summarizing the data with Cross tab tables
• Created templates using XCelsius
• Build query templates in XCelsius.
• Created Scoreboard and Dashboard using XCelsius.
Computer Software


Edmonton Power Corporation (EPCOR), Edmonton, Alberta
Sr. SAP BI Consultant
04.2009 - 07.2011
• Extensively worked on requirement analysis and preparation of High-level specification document, Functional Specification document
• Worked on transformationa and conversion files for data management process
• Extracting the source Data from R/3 system using LO, CO/PA extractors
• Created and configured info object catalog, DSO, customized Info cubes, Infosets, Multiproviders based on the specification requirements.
• Modified Update rules, Transfer rules, Update routine, and Transfer routine as per client requirement.
• Scheduled data loads in BW both for delta and full uploads
• Checked for data consistency and modified the data in PSA before loading them to data target.
• Uploaded master and transactional data from flat files and SAP as the OLTP source.
• Monitor data loading into the Data Targets with respect to BW Data.
• Worked in Bex suite, to create queries using Filters, Free characteristics, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and Variables.
• Monitor data loading into the Info cubes with respect to BW Data.
• Designed Universe which incorporates all the business requirements
• Defined user level security in Universe
• Involved in creating Web Intelligence reports using Universe and SAP BW (Query/Multi Provider) as the source Data Provider
• Developed Hierarchies to support drill down reports
Computer Software


DEPARTMENT OF LEARNING, GOVERNMENT OF SASKATCHWAN, Regina, Saskwatchan Duration: February 2007 to Ma
SAP BI Consultant
02.2007 - 03.2009
? Created, designed and implemented Universes, Webi, Info view and Desktop intelligence using BO
? Created Charts and Dashboard for Flash Reports, report on SD, and A/R A/P Aging Reports
? Involved in complete life cycle implementation of SAP BI / BO
? Publishing and Publications on Business Object Server
? Involved in WEBI and DESKI reports Development
? Involved in translating business process into business and technical requirements
? Created custom Datasource/Infocubes/Infobjects for accommodating the global data available across the organization. Used LO Cockpit, Generic, Flat File and DB extractions to retrieve SAP and Non-SAP data for reporting in SD , MM ,PP and FI-CO modules and company's legacy systems.
? Involved in BW user roles and security design and customized role menus for different User levels.
? Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled
? Created Functional and Technical specification for BI Content Modeling for FI-GL, PCA, CCA, GL, AR, AP, SD,PP and MM modules
? Installed the BI Content and extended the content to add custom info objects. Modeled and created the end to end connectivity using custom data sources, info sources and transformations.
? Created Source systems for various SAP R/3 and CRM instances. Created logical source systems and remote users to connect between the systems.
? Worked extensively on BEx Query designer. Used Navigational attributes, Filters, Exceptions, Conditions, Variables, Hierarchies, etc.
? Developed Bex reports on Delivery , Billing, Inventory, Account receivable and general ledger.
? Developed the ETL procedure to extract the past years worth of data into BW from heterogeneous sources using generic, cockpit extraction of Sap and Data Stage and XML data sources
? Developed and designed formatted, company-wide reporting (Enterprise Reporting) using the BEx Report Designer.
Computer Software


IMEX SYSTEMS, Mississauga, Ontario
SAP BI Consultant
09.2005 - 01.2007
? Created, activated and worked on a daily basis with Extractors, Generic Extractors, Generic Data Sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package Groups, Info objects, ODS, Info cubes, ODS Structures, Queries, Variables, Calculated & Restricted Key Figures.
? Developed Global info cubes, Multi cubes, Transactional Info cubes, ODS objects and extracted Master data and Transaction Based Data in SD and FI/CO Info areas
? Created & maintained Start routine to filter out prior unwanted data while loading for functional enhancement during data update in update rules & transfer rules.
? Created and maintained Transfer rules and Updates rules to map the fields of Data Source to Info Source and InfoSource to Infocube Respectively.
? Created and maintained Data implementation transformation routine to eliminate the technical and semantic difference between data from desperate source system.
? Designed and activated process chain at various levels with varied processes which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating ODS data from data load, Deleting / Generating Indexes, Deleting requests.
? Optimized the performance of the Data targets (Infocube, ODS, Multiuse…) by Loading the Data through proper selection criteria and maintained the request for each data load.
Computer Software


CENTRAL BOARD OF REVENUE
Oracle Developer/Analyst
11.2000 - 08.2005
• Analyzed, Developed and Implemented Tax Return and Tax Receipts Management System using Oracle Developer Suite(10g), Oracle Discoverer, Forms, Reports, PL/SQL, Procedures, Functions, Packages & Triggers
• Written quality PL/SQL codes in order to meet Business Requirements and Incorporated Tax Procedures
• Provided optimum performance by writing quality and indented Sql as well as used proper index type like
B-tree Indexes, Reverse Key Indexes and Bitmap Indexes
• Designed Data Flow Diagram (DFD) and Entity Relationship Diagram (ERD) using Erwin
• Developed complicated Matrix, Group Matrix, Tabular and Group Reports using Developer Suite (10g) Reports including extensively used SRWs to achieve the required objective
• Implemented very strong user security system module to provide limited/required access to the users
• Prepared Technical documentation following the standard rules of documentation
• Generated Ad-hoc queries, reports and analyzed data using Oracle Discoverer
• Implemented strong Backup strategy to secure confidential data using RMAN & Standby database
• Loaded Data from DB2 into ORACLE database through SQL Loader utility
• Extensively used Oracle Enterprise Manager (OEM) to monitor Primary database.
• Adopted Rapid Application Development (RAD) Life Cycle
• Analyzed, Developed and Implemented web based Payroll System for LTU using JSP, HTML, Oracle Forms (9i), Reports (9i), PL/SQL, Database Procedures, Functions, Packages and Triggers
• Used TOAD to run & create Sql Scripts, managed schemas and certain database & development operations
• Added client side scripting code to JSP pages to provide more interactive user interface
• Built Matrix, Group Matrix and Group Reports using Reports (9i) to print Pay Slips, Bank Reconciliation Statements, Allowances and Deductions Record of Staff along with other functionalities
• Written Database Packages, Procedures and Functions to meet the Business Requirements
Computer Software