Ø Have working knowledge of SAP Qualtrics – Source To Pay / Sources To Order.  Have good understanding of creating Projects (Surveys, Distributions, Data & Analysis, Reports), Portal and its functionalities
Ø Have good knowledge of Set up/Organize Surveys, create Questions, Question Types, Label Questions & Responses, Validations Options & Types, Graphics, Skip/Display/Branch Logic, Experimental Conditions & Randomize Participants to Conditions, Piped Text, etc. 
Ø Worked thoroughly on Operational & Experience Data in Qualtrics Dashboard, and have good understanding of Metrics, Graphs, KPIs, Scorecards, Keywords, Surveys.  Drilled down into issues, customers received
Helped develop key drivers of Customer/Brand/Employee Product experience which helped improve business revenue, and generate more leads.  Assisted with Modeling the improvements to find out the exact impact on business
Ø Have working knowledge of Business Technology Platform (BTP); Integration, Data-To-Value & Extensibility.  And BTP Workflow Management

SAP PM / EAM
Ø Assigned and tracked daily Works Orders for SAP Plant Maintenance
Ø Responsible for the creation of Preventive and Predictive Maintenance Plans
Ø Evaluated Min / Max requirements on Stock Items based on Usage Reports and Consumption
Ø End of year Cycle Counts for Inventory Management
Ø Created Work Orders based on weekly meeting production input
Ø Maintained and Managed Work Order List to accomplishing production schedules
Ø Located / helped purchased parts to maintain an optimal inventory.  Continually monitored all purchases, researched any alternatives
Ø Discontinued outdated spare parts; Updated Inventory System accordingly
Ø Created / Managed Serializing Procedure and Serial Number Profile for Material Masters (IQ01/IQ02/IQ03/IQ08).  Created / Maintained Equipment, Sub-Equipment, Location, Plant, Category, Measuring Points / Counters, Serial Number, Classification, Partners, Permits, Texts, Action Logs, Changes, Orders, Notifications, Maintenance Items, Task Lists, Serial Number Lists, Deletion Flags; for Equipment.  Managed, analyzed Equipment List / Service Notifications for Repairs (IQS3), Equipment (IE03), Material Document & Movement Types (MB03), & related data
Ø Managed the Material Serial Numbers Profile within MM, and generated reports, based on different Profiles, for analysis
SAP MM
Ø Performed SAP Configuration / Processes for Materials Management (Procure-To-Pay, Order-To-Cash, Record-To-Report, Inventory Management, Sub-Contracting, Condition Contracting, Returnable Transport Packaging – RTP, BOM), Sales & Distribution, Warehouse Management, Production Planning, Quality Management Modules
Ø Teamed up with Architects / Software Engineering people in helping them design / implement Integrated, Enterprise Solutions
Ø Expert in Functional and Technical areas with superb understanding of Business Requirements / System Processes, Inter Relationship / Dependencies / Interactions among System mechanisms.  Proficient knowledge in Integration Points between Systems; and between different SAP Modules (MM, SD, PM, PS & FI/CO; PM & QM)
Ø Performed User Acceptance Testing (UAT) / Regression Testing; created System Requirements Documents (SRD), Technical Documents / Specifications / Documentation, to satisfy Business need
Ø SAP Material Master Data Management (over 27K+ Materials) through refining Business Process Design for Item Material Master including Tactical MDM process.  Identified MDM Classifications of Data and assisted with identifying Local Data Attributes.  Setup / managed & Customization of Material Masters, Material Views, Material Types, Field Function Groups, Consumption Based Planning – MRP like: Reorder Point Planning, MRP Controller, Product Hierarchies, Slow Moving Materials, Source List, PIR, Cross-sell / Up-sell Alternative Products, Material Reservations, Material Substitutes / Conditions, Product Hierarchies, Mass Maintenance (Material, PIR, ROP, MRP, Warehouse Storage Location Setup, etc.), Product Costing (Product Cost Planning: BOM, Routing, Activity Type, Work Center, Cost Center), Deletion Flags, Material Reservations, Transfer Postings; and extracted reports out of ECC / BW / BEx, based on various parameters
Ø Configuration of New Site, PO Types, STO Types, Inbound / Outbound Delivery, Physical Inventory Movements between sites and different Inventory Movement Types for Receiving, Issuing and Adjustments
Ø Managed issues around WHSEs, Storage Locations, etc. not being setup properly by Material, & fixed them (OVL3, MMSC)
Ø Produced reports for Materials with MRPs on Plant / MRP Area Levels, for further analysis
Ø Maintained SAP Master Data for Customer, Vendor, Finance (Cost Center, Profit Center, GL, etc.)
Ø Performed Vendor Management including selection of Vendor Relationships, Onboarding new Vendor Initiatives, Overseeing and facilitating on-going Vendor Governance, Effective Relationships with Internal Client Business / Control partners / External vendors, Evaluated Vendor Performance for Service Levels, Technical/Business Features of Vendor Services in order to classify collaborations, Managed / Tracked Contractual Modifications
Ø Investigated IDOCS / EDI (Purchase Order, ASN, Vendor Invoices / other Transactions with Third party Logistics Systems)
SAP SD
Ø Involved in Testing of MMs from Sales Order / PO creation, through to different processes, for SCM.  Checked inter-dependencies between Modules to ensure accuracy, and took proactive measures to eradicate discrepancies.  Provided Production Support for SAP MM / SD / WM, on a daily basis
Ø Created / Managed Explosion in SAP SD – BOM (CS01/02/03).  Configured Usage of Configuration Profile in Variant Configuration
Ø Created / managed Substitutes, Alternative Materials, and issues around them
Ø Resolved issues around Materials not taking up proper Plant/Storage Locations/etc.  Cancel Accounting (VF11), Reverse Goods Issue (VL09), cancel Delivery (VL02N), and fixed Sales Order (VA02).  Performed MIGO, to delete Goods Receipt, from time to time
Ø Fixed SAP SD Production issues around Default Item Cat. (Table: T184) [Sales Doc. Type + Item Cat. Grp. + Usage + Higher Level Item Cat.]; and other SD related issues (Sales Org, Distribution Channel, Shipping Point for new Plant not setup properly, etc.).  Worked on other minor Enhancements, from time to time
Ø Sound knowledge in areas like: Sales Document Output Control, Copy Control, Shipping Functions
Ø Drilled down SD Data related to Pricing/Pricing Conditions (Doc. Condition #, Condition Record #, Condition Type, Condition Pricing Date, Condition Value, Condition Base Value, Condition Rate, Condition Origin, Condition Control, Tax, etc.) by Customer & Material
Ø Have knowledge around Customer Data (FD03) / Sold-To-Party (VD03) / Billing Status / Overview (FD33) / Account Balance Account Analysis (FD11), of Customers
SAP WM
Ø Managed Warehouse Management activities including (and not limited to), setting up Structure, Storage Assignment to Materials, investigate issues, etc.  Maintained Data Integrity and Data Governance
Ø Have good understanding of WHSE Org. Structure: Company Code, Plant, Storage Location, WHSE #, Storage Type, Storage Section / Picking Area, Storage Bin, Quant; & Special Stock Assignment, Batch #s, Transfer Requirements, Transfer Orders, Pick, Put-Away, etc.
Ø Have thorough working knowledge of WM Inbound Process: PO (ME21N), Good Receipt (MIGO), Stock in Interim Storage - Movement Type (902), Stock (MMBE, LS26), Create / Confirm Transfer Order (LB10, LT12).  WM Outbound Process: Sales Order (VA01), Good Issue (MIGO), Outbound Delivery (VL01N), Stock (MMBE, LS26), Create Transfer Order (LB10), Stock in Interim Storage - Movement Type (916), Confirm Transfer Order (LT12), Confirm Stock Update
Ø Excellent awareness of different Movement Types: GR without PO (501) (MB1C/LT06, LB12, LT04/LT12/LS26), GR without PO into Q.I.Stock (503) (MB1C/LT06, LB12, LT04/LT12/LS26), GR without PO into Blocked Stock (505) (MB1C/LT06, LB12, LT04/LT12/LS26), GI to Cost Center (201) (MB1A/ LT06, LB12, LT04/LT12/LS26), Transfer Posting from Blocked to Q.I.Stock (349) (MB1B, MB03, LT05, LT12, LS26), Transfer Posting from Blocked to Available Stock (343) (MB1B, MB03, LT05, LT12, LS26)
Ø Awareness of SUM (Storage Unit Management).  Defined Storage Types, Sections, Picking Areas; and Strategies (Storage Type Search, Storage Section Search, Storage Bin Type Search).  Activated Storage Unit Management Per WHSE # & activated proper Flags.  Configured Storage Type Control.  Created Material Masters, accordingly
Ø Have an understating of 2-Step Picking Process & Configuration Steps (VA01/VL01N/VL06P/LT72/LT73/LT0E/LT12/ LS26/LX39/LS26/VL02N)        
Ø Followed up on SAP WM activities: Open Sales Orders / Open Outbound, Inbound Deliveries in Document Flow / Status Overview / Sales Summary (Outbound Delivery/Shipment/WMS Transfer #/Handling Unit/GD Goods Issue Delivery #); and resolved any hiccups that came from time to time
Ø Have awareness of seamless Integration of SAP WM with MM, SD, QM, PP; and effects of posting of Goods in MM-IM, leading to postings in Interim Storage (LX20), and finally to WM (T-Codes: LT01/LT21/LT23/LT26/MB1C/LX01/LS01N/LS10/LS32).  Have good working knowledge of SPRO, as well.  Investigated IDOC errors (through T-Code: WE02 / MM90)
SAP FSCM
Ø Checked Payment History / Credit Ratings, from time to time
Ø Have working knowledge of MS Power BI & Query Designer, as well.  Created reports for Management, for detailed Analysis
SAP S/4HANA On-Premise
Ø Experience with Information Modelling, Database Design, Data Provisioning, Data Replication Techniques; in SAP HANA Studio.  Performed Data Modeling in HANA Studio using Attribute, Analytical, Calculation & Hierarchical Views
Ø Understanding of different Perspectives & Hierarchies (Level Hierarchy and Parent-Child Hierarchy), in HANA Developer Studio.  Excellent understanding of Relational and Dimensional Data Modeling
Ø Interacted with Business stake holders in order to understand their structured and ad-hoc Reporting Requirements, Business Rules for Finance, Sales and Marketing Domains.  Reviewed, Refined and Validated Data; Generated Reports in Excel and SAP Business Objects
Ø Competency in SAP S/4 and its Data Models.  Developed SAP S/4HANA Information Models such as Procedures and HANA Views (Attribute, Analytics and Calculation views)
Ø Created MM / SD / WM / PS, Inventory & Projects reports, with complex criteria.  Competency in SAP SD Configurations, Integration with other Modules (MM, FI, CO, PP, PS), writing detail specifications for development of custom programs
Ø Sound experience in Areas / Processes like Purchase / Sales Orders, Deliveries & Goods Issue, Transportation Management & Shipment, Invoicing / Billing / Pricing / Discounts / Refunds, Return Delivery & Credit Memo, Integration with Third Party System, Inter-Company Billing, Scheduling Agreements; along with knowledge of Sales and Operations Planning, Processes Optimization and Automation, Record-To-Report (R2R) & IFRS 15
Ø SAP S/4HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained, and fine grained Access Control
Ø Also, have working knowledge of Data Vault 2.0, SAP HANA PlanViz & SQL ExplainPlan, APL, PAL, PAI 
Have thorough understanding around PushDown Blocker, Single Column Search Vs. Stacked Column Search, Data Materialization, Columnar Operators, Query Optimizer Plan for Literal / Parameterized Queries (Pre-Complied / Re-Compiled Plans), SQL Trace, SQLScript Optimizer – InLining, Memory Consumption, SQL HINTS, Out-Of-Memory Dumps, HANA SQL Query Performance & Optimization, ROW & COLUMN-BASED Data Stores, etc.
SAP ECC/BW/BEx/BO/Analytics Cloud
Ø Responsible for successful delivery of Functional and Technical components of Business Intelligence (BI) reporting Cost Effective and Sustainable Solutions, using SAP Query Designer, BEx, BW, BO and SAP Analytics Cloud
Ø Performed Collaborative Enterprise Planning by tracking Organizational KPIs in Real-Time, Key Business Drivers and Insights, Streamline End-To-End Workflows for Business Intelligence and Planning, Forecasting, Spot Trends with enhanced Data Accuracy, combined Data from Multiple Sources, in Real-Time; for Purchasing, Inventory & Fulfillment, with SAP Analytics Cloud.  Created Embedded Analytics Reports
Ø Supported Data Extraction, Data Cleansing and Loading.  Acted as Cross-Functional Team member and added value by providing a Technical perspective.  Ran Interactive reports by SKUs, by DC, by Plant, for Forecasting; and reports regarding Product Hierarchies / Parent-Child Relationships, among Products
Ø Have solid understanding of Core / Advanced / Predictive Planning capabilities (Prepare/Schedule/Predict/Plan/Visualize/Finalize Data); and Base Members / Base Accounts / Calculated Measures
Ø Created Private / Public Models from Scratch/DataSource/File Upload, maintained Pre-defined Dimension Types (Account, Time, Version, Organization), added/maintained Dimensions, Measures, Accounts, established Relationships, maintained Model Settings, performed Data Wrangling, Mass Data Entry, Linked Analysis, Table Thresholds / Conditions defined on Model / Story Level for re-use, Formatting, define/re-use Styling Rules for various Uses Cases, Cross Calculations bound to Input Controls for users, add Dimension Members for new Plan Master Data, upheld Security/Data-Locks, sustained Custom Properties, Hierarchies (Parent-Child, Level-Based), Model Versions, System Properties (Unit/Currency Conversions.  Currency Rate Table – Time/Version Dependent), Version Management, History, Logs; defined Member Validation Rules to allow specific Combination of Dimension Members, etc.
Ø Performed Administration work in SAP Analytics Cloud – Add / Delete / Edit Users, Profiles, etc.  Created Custom Roles / Permissions, and assigned them to Users / Groups / Teams.  Managed SSOs & SAML Attributes.  Created Folders with appropriate Permissions.  Created Connections to DataSources and setup their Security; and tested them
Ø Dimension-Based Data Access Control & Role-Based Data Access Control
Ø Have knowledge around Building Shared Models, setup Model / Version Security, and / or Security on the Data within Model (Read / Write Access)
Efficient in Import / Export Roles, Connections, Content.  Setup Production Environment to receive Imports from Content Network & Point Models to Production Data

Ø Extracted data for Inventory, Finance and SD from SAP ECC R/3 System.  Created / modified SAP BO Web intelligence Reports (offline using WEBi Rich client and online using BI Launch pad), and exported them to the portal
Ø Configured / Created and Maintenance of materials using SAP MM module.  SAP Order Management, Procurement Data, Pricing, Billing, Safety Days, Lead-time, ROP, etc.  Created and Maintained Pricing Condition (SAP SD) at Customer / Material level for Customers and Vendors.  Provided monthly reports on different KPI Statistics / Visualizations, for various Departments (Finance, Procurement, Legal, etc.)
Performed Testing / Task Performance of Modules, Tables, Functions, Fields, etc. by running SAP Transaction: ST05.  Tested Database Access, Locking Activities, and Remote Calls of Reports and Transactions in a Trace File; and display Performance Log (SQL Trace, Enqueue Trace, RFC Trace, Table Buffer Trace)

Ø Extracted SAP BW data, mixed / matched in order to produce different reporting requirements for Ministry of Finance, on a project led by Ministry of Climate Change, for Budget / GL Expenses.  Broke down various reports by Function (General Public Services, Social Protection, Economic Affairs, Environment Protection, Education Affairs and Services, etc.); Cost Center – Ministry Wise & Classification Wise
Ø Used SAP ECC / BW / QD / BEx Functions like: Aggregation / Conversions / Planning / Calculations, to satisfy Business Requirements.  For Unit Conversions (stored in SAP ECC Table: T006), replicated Conversion Type in SAP BW through T-Code: RSUOM (for Source to Target mapping); which later reflected in Query Designer.  Performed Currency Translations (stored in SAP ECC Table: TCURR), replicated Conversion Type in SAP BW through T-Code: RSCUR (for Source to Target mapping), to be reflected in SAP Query Designer;  which populated in SAP BEx reports.  Used “KeyFigure / Characteristics Structure” & Cell Editor, extensively.  Also, used SAP BW Business Content & OffSet Variables, in SAP Query Designer 

SAP PM  / EAM
Ø Experience in all phases of SAP PM projects which involves Configuration, Unit testing, Integration Testing, and Production Support
Ø Design, Configuration, & Implementation of SAP Plant Maintenance Module, which included:
Cost Centers, Work Centers, Asset Data, Equipment, Function Locations and structure, Bill of Materials, Predictive Maintenance Plans, Preventive Maintenance Plans, Single Cycle Based Maintenance Plans, Corrective Maintenance, Strategy Based Maintenance Plans, Counter Based Maintenance Plans, Calibration Plans, Maintenance Planning Schedule Board, Table Queries, Material Master Creation, Refurbish Work Orders, Breakdown Maintenance, Creation of types of Notifications based on Company reporting requirements, Activity Report, etc.
Ø  Configured / Customized: Org. Levels, Technical Objects, Breakdown Maintenance (Functional Locations, Equipment, Work Centers, Task List, Maintenance / Maintenance Planning Plants, Notifications, BOMs, Maintenance Order, Maintenance Activity Types, etc.), in SAP Plant Maintenance.  Provided Production Support, from time to time
Ø Participation in End-To-End System Implementation Project (Analysis, Design, Configuration/Development Build, Test, Deployment including Training and Data Conversion)
Ø Ability to write Technical Specification, user Training Materials and provided User Training
Reports / Dashboards
Ø Built Reports and Dashboards in SAP Business Objects for Asset Accounting, Project Systems, Finance, and other.  Performed enhancement / correction to various Functional Docs for AP / AR, G/L, Financial Management reports, reports for the Receiver General (RG) for Public Accounts (PLATE I-4, I-5 & I-6), SAP CATS, SFT, CO, FM (Actuals / Commitments, Forecasting, Budgeting, etc.), PS (OTOBOS – Projects tracked by “On Scope / On Budget / On time), PS - AUC (Projects for Asset Under Construction), Project Settlements, MM – Proactive Disclosure of Contracts, List of Material Masters by Sales Org. / Distribution Channel; Capital / Operative Budget Type Reports, verified / reconciled information on payment of Leases.  Generated Reports for internal and external stakeholders; along with Technical Specifications / Integration Testing in Quality, and Functional Testing of those reports to find discrepancies, if any 
Ø Worked on query creation / modification / elimination in SAP Query Designer (Calculated / Restricted KFs, Variables – Formula, Text, Characteristic Value, Replacement Path, Authorization, Hierarchies, etc.), and produced proper results in SAP BEx for the client.  Checked data integrity from end-to-end, and brought forward any related concerns.  Also verified information in SAP BW back end after integrating through BICS connection, for the development of Reports in SAP Business Objects.  Advised proper modification to Cubes, after creating / testing Transaction Test Data in SAP ECC, against Cube data in SAP BW.  Used SAP BEx Scheduler
SAP MM
Ø Helped with Key Figure Calculations for MM, within SAP BW (Net Price, Net PO Value, Effective PO Value, etc.).  Applied / edited Filters on DTP Level, reconciled data between ECC and BW; and indicated errors for CO / MM type reporting.  Reconciled data between Source & DataMart, with Logic
SAP REFx Project
Ø Integrated / Mapped fields from old Real Estate Legacy System, “WinFS” to SAP ECC, and then to SAP BW.  Type of data included Asset Accounting / REFx / SD / PS / CATS.  Worked on SAP PS Mile-Stone / Time Management type reports, and advised proper mapping of SAP ECC to SAP BW fields / InfoProviders; and made appropriate changes in the queries, in SAP Query Designer.  Performed all Data Migration / Governance activities.  Created SAP Custom DataSources.  Helped SAP BW back-end team with Functional Testing, for SAP BW upgrade 7.4
Ø Worked on SAP MM-SD-FI Project from scratch for “The National Trade Contractors Coalition of Canada (NTCCC)”, to increase Efficiency / Cash Flow on Federal Construction Projects by publicly disclosing payments made to Prime Contractors.  Prompt Payments - Payments to Construction Contractors
https://www.tpsgc-pwgsc.gc.ca/biens-property/divulgation-disclosure/psdic-ppci-eng.html
SAP ECC (REFx)
Ø Have working knowledge of SAP ECC (REFx): Create / Update REFx Contracts, Periodic Posting Simulation / Execution, Periodic Posting Reversal, Create Invoices & Reverse Invoices, Contracts / Contract Offers / RE Search Request, Specify Adjustments, Index, Classes, Series & Points, Sales-Based Rent & Settlement       
SAP Finance
Ø Performed BI Content Activation of Finance InfoCube (0FIGL_C10) & necessary components
SAP AA
Ø Sustained Support and Enhancement in SAP BW.  Coordinated efforts of adding Test Data in SAP ECC, for newly added fields for SAP Asset Accounting.  Performed Transformation (ETL) from Source to Target in SAP BW.  Verified accuracy of data, from ECC to BW; produced desired results in SAP BEx / BO
Ø Converted Display Attributes to Navigational Attributes, and maintained Transitive Attributes, in SAP BW for SAP Asset Accounting.  Verified all dependencies
SAP HANA, S/4HANA, Design Studio
Ø Competence in SAP S/4HANA Modeler Perspective 1809 to extract data, build Reports, on different Levels by constructing Information Models.  Used Joins (Inner / Outer / Referential), and Filters, Cardinality, Key Attributes, Calculated Column, assigned Semantics to Measures, etc.  Created, managed, and transported Information Models (Packages / Views).  Defined / executed Data Provisioning; defined Schema Mappings, etc. 
Ø Have good know-how and working knowledge of SAP HANA Design Studio, its Perspectives (Modeler, Administration, Resources, Other), Folders, Schemas, Packages, Flowgraph, Stored Procedures and Views (Attribute / Analytic / Calculation), SAP HANA Table Functions; and Functions like: Start / Stop (Soft & Hard) / Re-Start, Configure, Monitor, B/up & Restore, Add / Delete / Edit, SAP HANA Systems, DBs (System & Tenant), Services & Users; assign Roles / Privileges to Users
Ø Have thorough knowledge of SAP HANA Implementation Processes and SAP S/4HANA Migration Cockpit (LMTC), including SAP S/4 HANA Fiori Configuration
Ø Developed SAP HANA Information Models such as Procedures and Hana Views (Attribute, Analytics and Calculation views)
Ø Created MM / SD / WM / PS, Inventory & Projects reports, with complex criteria
Have an working knowledge of SAP Smart Data Access, SLT, Virtual Data Modeling, HANA Live
SAP BW Security
Ø Maintained SAP BW Security & Authorization – Analysis Authorization, Roles & Authorization on Hierarchy & Reporting Authorization, User Maintenance, etc.  Secured data presented in Queries by Hierarchy Node
SAP BW-IP
Ø Expertise in BW-IP (Integrated Planning) using Planning Modeler (T-Code: RSPLAN), Development of Real Time InfoCubes, Multiproviders; Planning Functions, (Copy, Distribution By Reference Data / Keys, Repost, Re-Evaluation, Formula, Delete, Forecast, Consolidation, Write Back, Generate Combinations, Currency Translation, etc.), Planning Sequences, Aggregation Levels, Filters, Input Ready Queries and Variables, Characteristics Relationships, etc.; along with Control Data settings used for Target Characteristics
Ø  Designed / managed BW-IP WorkBooks and related content, both in front / back end, for Finance (Budget Planning, etc.)
Ø  Integrated BW (including BW-IP) with SAP BOBJ / Lumira   
Ø Documented / edited documents in SAP Solution Manager (MS2) and GCDOCS, and validated information in SAP NetWeaver, for various streams of business.  Used SAP Solution Manager to investigate issues
Ø Have worked in SAP Business Objects Data Services; and have thorough knowledge of Query as a WebService (QaaWS), HPQC; and SAP LSA / SAP LSA++ (Purpose of every Layer in the LSA Reference Architecture), & ASAP Implementation Methodology
SAP S/4HANA Cloud
Ø Have good understanding of SAP HANA Cloud Platform; Global / Sub-Accounts, Org, Space; and deployment of Apps / Service Instances, Bind Service Instance with App; & Service Keys.  Have working knowledge of “Neo & Cloud Foundry” Cloud Services; and differences / capabilities of: On-Premise, IaaS, PaaS, SaaS
Ø Hands-on experience with complex SAP HANA Design, Deployment, Data Modeling & Analytics.  Created various Tiles in Fiori LaunchPad in Extensibility, assigned to Catalogs, Published and Pinned to a specific Group; for different Applications to store their URLs
Have knowledge of custom Analytics Modeling & Reporting in SAP S/4HANA Cloud (for SAP MM / SD / PS), DataSource(s) in View Browser, Custom DataSources – Core Data Service (CDS), construction of Customized Analytical Queries (after applying Filters / Calculations); leverage OData Service to Publish KPIs to Catalogue(s), in Fiori LaunchPad

SAP PM / EAM
Ø Set-up and Administration of Maintenance Activities in SAP PM to ensure timely Maintenance and Calibration of Equipment across OPG, Product Development
Ø Developed and provided KPI reports from SAP PM for maintenance and reliability, such as Backlog, Schedule Attainment, PM Compliance, Overtime, Expenses, etc.
Ø Participated in the SAP PM Functional Design activities.  Created Functional requirements as an input to Application Design
BI Refinement Project
Ø Worked on a project with OPG (Ontario Power Generation) streamlining documents / artifacts for Nuclear Refurbishment for Reactors.  Acted as an interface between project team and client to provide project coordination, as required.  Collaborated with Integration Team for designing and deploying Data Interfaces, with Source Systems
Ø Design and Development for SAP Data Models - Info Objects, Data source, Info package, DTP, Transformations, DSO, Info cubes, Multi providers etc.  Have solid understanding of Data Modeling and Databases 
Ø Performed Application Development Assessments, conducted Planning Sessions, defined Technical Roadmaps, created Application Architecture Design Guidelines
Ø Contributed to Company, Project Standards and Guidelines; and company Knowledge Base.  Facilitated effective team interaction while subsidizing to implementation of new BI solution; taking into account software like Primavera P6, & others
Performed User Administration in Business Objects Central Management Console (CMC), along with Reports / Publications / Users & Group Hierarchies, etc.  

SAP PM / EAM
Ø Set-up and Administration of Maintenance Activities in SAP PM to ensure timely Maintenance and Calibration of Equipment across OPG, Product Development
Ø Developed and provided KPI reports from SAP PM for maintenance and reliability, such as Backlog, Schedule Attainment, PM Compliance, Overtime, Expenses, etc.
Ø Participated in the SAP PM Functional Design activities.  Created Functional requirements as an input to Application Design
BI Refinement Project
Ø Worked on a project with OPG (Ontario Power Generation) streamlining documents / artifacts for Nuclear Refurbishment for Reactors.  Acted as an interface between project team and client to provide project coordination, as required.  Collaborated with Integration Team for designing and deploying Data Interfaces, with Source Systems
Ø Design and Development for SAP Data Models - Info Objects, Data source, Info package, DTP, Transformations, DSO, Info cubes, Multi providers etc.  Have solid understanding of Data Modeling and Databases 
Ø Performed Application Development Assessments, conducted Planning Sessions, defined Technical Roadmaps, created Application Architecture Design Guidelines
Ø Contributed to Company, Project Standards and Guidelines; and company Knowledge Base.  Facilitated effective team interaction while subsidizing to implementation of new BI solution; taking into account software like Primavera P6, & others
Performed User Administration in Business Objects Central Management Console (CMC), along with Reports / Publications / Users & Group Hierarchies, etc.  

SAP Finance
Ø Created Data Models (InfoObjects, etc.) for Master Data & loaded / maintained Master Data.  Performed “ETL” monthly in SAP BW for Sales type reports to update the Target Numbers for the Finance, Sales & Marketing, for their “Financial Data Management / Analysis” & “Profitability Analysis”; by Customer, by Product, by Region, etc.  Updated SAP BW Master Data Records for Cost Centers through Error Stack into the Target, after performing all sorts of Error Handling; and provided proper Test Documents.  Worked on (AR/AP/G/L, Financial) Reports, eventually fed into SAP Business Objects, for various LOBs
SAP SD
Ø Performed LO Extraction in Logistics Cockpit (LO) for Sales & Distribution (SD) Extractor, (2LIS_11_VAHDR)
SAP BW
Ø Worked on customization, and enhanced Standard (Generic) / Customized Extractors to support business needs for Material / Vendor Analytics (T-Code: RSA6 – Append Structure).  Reconciled data between BW & Source Sys.
Ø Have solid working knowledge of building Database Views / Generic DataSources.  Created Customized DataSources using Database Views, Tables, InfoSet queries.  Analyzed DataSources / Extractors (T-Code: RSA2 / SE37), based on Function modules.  Have working knowledge of Update Rules, Transfer Rules, Attributes (Display, Exclusive, Navigational, Time Dependent, Time Dependent – Navigational Attributes, Compounding, Transitive).  Experience in Performance Tuning techniques involving evaluation of Statistical Performance Data Load Improvisation and Query Performance, using Compression, Aggregates and Partitioning techniques
Ø Created various Data-Targets and Info-providers like InfoObjects, InfoCubes, DSOs (ODS), InfoSets, Multiproviders, Semantically Partitioned Objects, InfoPackages, DataSource creation & replication; and Transformations, DTPs to load Master / Transactional data from ECC 6.0 / Flat-File Interface to target
SAP BEx / Query Designer
Ø Created, revised and maintained SAP BEx queries in Query Designer.  Performed data mapping from InfoProvider (in SAP BW) to BEx Query Designer to Universe; and from there to SAP Business Objects.  Created, amended and maintained several BO reports for different business
Ø Performed SAP BW Data Loads manually from Source SAP ECC / Flat File to SAP BW.  Created data models (InfoObjects, InfoCubes, DSO, Multiproviders, etc.), and investigated errors 
SAP BO BOBJ / Admin
Ø Performed User Administration in Business Objects Central Management Console (CMC), including Reports / Publications / Users & Group Hierarchies, etc.  Have strong knowledge of OLAP Universes.  Responsible for User / Group Management (Add, Delete, Disable), Assign Users to a Group / Assign multiple Groups to User(s), Assign User / Group (Security & Rights) to Report / Folder, Add Sub-Groups, Guest Account, Manage Profiles / Values, User Password & DB Credentials, Configure BI LaunchPad Preferences / Properties for the Users, License Keys & Metrics, Track Objects
Ø Managed Authentication Types (Enterprise, LDAP, SAP, Windows AD), Server / Services: Admin & Monitor, Local & Remote Servers, Nodes, DataSources & Connections, Network Parameters (SSL, FTP, SFTP, etc.), Refreshed Universes; Schedule Jobs & hence, complete Administration including Auditing of Servers & Applications, Backup / Restore Server Configuration
Ø Promotion Management Tool to move BI Resources from one Repository to another through Promotion Jobs (worked w/ BIAR / LCMBIAR files), Version Management (Copy, History, Deleted Resources, Lock / Unlock Objects), Server Management – Add, Clone, Delete, Start, Stop, Restart, Enable, Disable, Add Multiple Instances of Server  w/ proper Service Category / Node / Port #, Clone Server Instances to new Node, etc. (e.g. Disable, Monitor for completing Requests / Jobs, Stop & then Start)
Ø Have working knowledge around SAP BO CCM (Central Configuration Management Tool) & BO UMTL (Upgrade Management Tool)

Ø Assisted in building Business Cases / Work Plans by Designing, selecting Medium to High Complexity Solutions, Assessing Risk, Analyzing Impact and providing Estimates for work, as requested.  Reviewed Requirements; ensured Design meets Functional / Non-Functional Requirements
Ø Worked around implementation phase of front & backend Cross Application Component - SAP Commercial Project Management (CPM).  Expertise in BW-IP (Integrated Planning) using Planning Modeler (T-Code: RSPLAN), Development of Real Time InfoCubes, Multiproviders, Aggregation Levels, Filters, Planning Functions, Planning Sequences, Input Ready Queries and Variables, Characteristics Relationships, etc.; along with Control Data settings used for Target Characteristics
Ø Checked for ABAP Class: ZCL_RSPLF_FILE_UPLOAD (T-Code: SE24), Planning Function Type : ZRSPL_FILE_UPLOAD (T-Code: RSPLF1), InfoObject: 0TCTIOBJNM, creation of InfoObjects / Master Data, Imported Transport files (T-Code: SE24, STMS), installed & activated Key Components from Transported Files, Uploaded data into Transactional Cubes, performed changes in ABAP Class for BEx utilization; and configured SAP BEx functionality for the purpose
Ø Helped activate BI Contents for SAP PS (SAP BW 7.4), confirmed in T-Code: RSA5 / RSA6, managed Transformations, performed Data Loads; monitored / investigated issues around Real Time Access (RDA) InfoPackages using Daemons.  Mapped Data, investigated / fixed errors between SAP BEx and BW; CPM Workbooks and BW.  Installed patches in BW back-end (SM30), and coordinated with SAP Germany for investigating / fixing errors.  Investigated IDOCs 
Ø Experienced in DSO / InfoCube design as per business requirements.  Skilled in loading Data (Full / Delta), Monitoring of data; hence experienced in all facets of SAP BW including Data Modeling, Data Acquisition, Transformation, Loading and Performance Tuning.  Skilled in creation of ABAP Data Dictionaries, defining Metadata Management approaches and Governance processes; OLAP Variables (Global & Local)
Ø Produced (AR/AP/G/L, Financial) Reports, from time to time

SAP Xcelsius – Dashboards / Visualizations
Ø Core data related activities from acquisition to integration, and persistence of Data / Meta data using SAP Xcelsius.  Architected Performance Indicators / Analytics by creating various customized reporting Dashboards / Score-Cards / Real-Time Analytics Solutions / Visualizations; for Finance & other LOBs.  Developed performance measures for Business Analysis Evaluation (e.g. What-If-Analysis, Dynamic Visibility, Interactive Charts, narratives, etc.)
SAP BW
Experienced in SAP BW 2004s BI 7.0.  Worked with BI Objects: Basic InfoCubes, ODS, Real-Time / Write Optimized DSOs, Multi-Providers, InfoSets (Info-Providers), DataSources, InfoPackages, InfoSources, Transformations, Data Transfer Processes (DTPs), Re-Partitioning of InfoCubes

SAP BI Reporting Lead  (Supply Chain Management)                                                                                                                                                           
SAP Implementation Project (OTC / P2P)
Ø Developed Solution Architecture which reflected Integration of Business Logic, Processes, and Data; mapped to defined Business Requirements.  Guided Solution Delivery Team in implementation of Solution Architecture, for Global SAP Implementation Project.  Contributed in Design, Development and Support of SAP BI /BW Solutions
Ø Vale IT SME for BW / BI on SAP Implementation program, mainly working on “Order-to-Cash” and “Procure-to-Pay” streams; coordinated, administered and supported activities related to Data Design, Governance, Planning and Development.  Worked on (AR/AP/G/L, Financial) Reports, as well
Ø Instituted an Integrated Data Governance Model for ERP Data, after Data Migration / Data Governance Undertakings, to upkeep the Implementation of an Integrated, Strong SAP Data Solution
SAP BW
Ø Extraction of data from SAP R/3 for various Info-Cubes including Sales Center performance data, Statistical Key Figures, Regional Sales, Sales Overview, Customer Data, Material Data, Corporate Information View; and others.  Have working knowledge of FOX Formulae  
 

SAP EAM / PM
Ø Configured / Customized: Org. Levels, Technical Objects, Breakdown Maintenance (Functional Locations, Equipment, Work Centers, Task List, Maintenance / Maintenance Planning Plants, Notifications, BOMs, Maintenance Order, Maintenance Activity Types, etc.), in SAP Plant Maintenance.  Provided Production Support, from time to time
Ø Responsible for publishing and scheduling Business Intelligence Documents to large number of end users.  Deployed Business Objects Reports to SAP Enterprise Portal.  Assisted in designing / organizing, Training Material / Documentation, for educating Internal Customers on BI tools
Expertise in debugging / troubleshooting Business Objects Reports against SAP ECC / SAP BW / BEx / Query Designer.  Used SAP Solution Manager to document / investigate issues
SAP BOBJ Project(s)
Ø Designed, analyzed and implemented relational and multi-dimensional databases.  Involved in building
Semantic Layer and Reporting Solution using SAP Business Objects 3.x / 4.x, collaborating with client SMEs and Project Team to develop / implement Cost Effective and Sustainable Solutions; assisted with Deployment activities.  Developed Report Prototypes and reviewed / fine-tuned Report Deliverables
Ø Extensive experience in Business Objects (XI 3.1 / 4.0), SAP Query Designer, SAP BEx (WEBi) (7.30– SP3), Xcelsius (2008 - SP6), SAP Business Objects Analysis For MS Office (1.4 – SP6), Microstrategy (8.x), Cognos (10.x), Crystal Reports, Bi-Query, Actuate, Passport & SQL
Ø Designed, Developed and Implemented 75 plus complex reports for Supply Chain Management, Finance, Project Systems, Plant Maintenance, and others; that included BO functionalities like getting data from Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab, Master Detail and Merged Dimensions, Multiple Queries, Combination of Chart and Tables, Query within Query, Report-To-Report Interface (RRI), etc., to name a few.  Maintained Report Specifications for changes to existing Production Reports, to be fully Compliant with Government Regulations
Ø Created Business Objects 4.0 reports on top of BEx queries, using BICS connection.  Worked in BEx Query Designer for designing Queries using Filters, Variables, Conditions, Exceptions, Navigational Attributes, Global Structures, Calculated and Restricted Key Figures
Ø Adhered to all Ad-hoc Report requests by extracting / compiling data in SAP, Excel and Access.  Have expert level query
analysis skills in SAP by using SAP ECC R/3, Query Designer, BEx Analyzer, ABAP Query Reporting Tool (Quick  Viewer SQVI);  and Portal (SCM, SRM, Procurement, BI Supply Chain), along with (AR/AP/G/L, Financial) reports.  Tuned Queries for optimal performance
Ø Involved in all end to end Sourcing & Procurement  Process (Contract Management, MRP, PR, PO, Goods Receipt, Invoice Management); and Supplier Management

SAP Implementation Project   
Ø Ensured consistent standardized solutions to align with and collaborated in refinement of Data Architecture.  Helped with Enterprise-Wide BI / Data Warehouse projects (e.g. across multiple LOBs requiring integration of BI Data from multiple Source Systems).  Scope Definition, Business Re-Engineering, Configuration, Customizations, End-User Training, Go-Live Operations and Support, Data Conversions, Data Validation, Design & Maintenance of Interfaces, Extensions and Reports
Ø Expertise in SAP BW; OLTP Extractions from SAP R/3 / Generic Extractions / Flat Files
Ø Developed Queries to access data from various SAP BW InfoProviders like DSO (ODS), InfoCubes, InfoObjects, Multiproviders and InfoSets using BEx Query Designer.  Reconciled BI reports with ECC & Legacy data.  Performed analysis for Loading and Query performance.  Worked with Navigational Attributes, both Time Dependent and Independent.  Worked on Financial reports as well
Ø Monitored Service Credits &/or Penalties against Vendor Performance in accordance with Contract Commitments, and reviewed negotiated Rates and Volume Thresholds against aggregated Spend, Invoice Charges, and Financial Commitments

Ø Planned, expedited and tracked shipments (including EDI orders) by communicating with internal / external customers / planners / warehouse / retailers using SAP (R/3) and IMOS (In-House Software).
Maintained orders’ statuses and achieved satisfaction with respect to SAP Materials Management for North American order fulfillment.  Ran reports in SAP R/3 to track POs, inventory, etc.
Ø Worked closely with Procure-to-Pay Business functions (Purchasing, R&D, Supply Chain Planning)