SUMMARY

• 17+ years’ experience (Functional & Technical ) in ERP - SAP BW - Ver. 7.1, 7.3, 7.4, 7.5 / ECC R/3 - Ver. 4.7,6.0 / BI / ABAP for BW / BW Security & Authorization / BW-IP / CPM - Ver. 1.0 (SP03 ) / S/4HANA / BW/4HANA / S/4 HANA Cloud / ABAP On HANA / Ariba, SAP NetWeaver 7.3 / BASIS (Security) / PP / MM / SD / WM / SRM / CRM / AM / PS / PM / HR / FI (AR, AP, GL) / CO / AA / FM / COPA / CATS - SFT / REFx / IM / EAM / ABAP Query Reporting / ABAP Interface Development / Portal, Data Warehouse, Enterprise Application Integration (EAI), Supply Chain, Business Intelligence, Reporting Requirements, Process Mapping and Project Management
• 6+ years in SAP BW / BI Data Modeling & MM / SD Development Solutions incorporating OLAP Methodologies; worked on all Phases of SAP Implementation such as Requirements Gathering, Analysis, Blue-Printing, Technical Design, Development, Documentation, Testing, Rollout, Support & Maintenance, Training and Performance Tuning
• Data Architecture, Data Modeling, MDM & ETL, LO Cockpit, BI Predictive Analysis . I ntegration of data at Logical / Physical, Data Warehouse Levels, development of RICEF Objects (Reports, Interfaces, Conversions, Extensions, Forms) & WorkFlow
• 21+ years in IT & 12+ years in Supply Chain Management (OTC, PTP, RTR, Forecasting, Sourcing & Procurement, Inventory Planning & Replenishment ), with knowledge in Telecommunications, Retail, Manufacturing, Machinery, Utility, Mining, Construction and Public sectors ( Provincial and Federal Governments)
• 12+ years expertise in SAP Business Objects Enterprise XI 3.1 / 4.0 / 4.1 / 4.2 (BOBJ), SAP BO CMC, Business Objects Analysis For MS Office, SAP Xcelsius, SAP Solution Manager, Report Designer; and proficiency in SAP HANA Design Studio, SAP S/4HANA Migration Cockpit (LMTC) (On-Premise & Cloud), SAP Planning Modeler, SAP BO Lumira, SAP BO Data Services, Web Application Designer, SAP ABAP Web DynPro; hence, the complete suite of SAP Business Objects BI, Web Intelligence (WEBi), Query Designer, BI Launch Pad and SAP BEx components
• Have practical working knowledge of SAP HANA Platform (BW/4HANA, S/4HANA), S/4HANA Implementations, SAP Business ByDesign (2019 Edition) ; along with knowledge of Data Science, Artificial Intelligence, Machine Learning, Build Bots with SAP Intelligent Robotic Process Automation
• Have working knowledge of SAP HANA Modeling in Cloud ( SAP Analytics Cloud, SAP S/4HANA Cloud, SAP Cloud Platform Cockpit, SAP S/4HANA Admin Cockpit, SAP S/4 HANA Cloud DataBase Explorer, SAP S/4HANA Cloud SQL Console, SAP Web IDE, SAP Data Warehouse Cloud, SAP Business Application Studio, SAP Data Intelligence (2020 Edition), SAP Leonardo AI, SAP Qualtrics, SAP Edge Services, Thing Modeler, SAP Desktop Agent, SAP Desktop Studio, Jupiter Notebook )
• Superb Query Reporting skills with competency in Non-SAP data (Microstrategy, Cognos, Tableau, Crystal Reports, Access, Excel, Bi-Query, MS Share-point, MS Power BI, etc.)

TECHNICAL SKILLS

Platforms: MS Windows 2000 / ME / NT / XP / Macintosh 10.x, Lindows OS (UNIX)

Hardware: Cisco 2500 / 7500, Motorola Vanguard, Ascend Pipeline routers

Languages: HTML, Java, MS SQL, XML, SAP ABAP

Databases: MS SQL, Oracle, MS Excel, MS Access

Applications: SAP (ECC), SAP BW / BI 7.0 (2004s), SAP BEx Analyzer, SAP Web AnalyzerSAP Web Application Designer, SAP BEx Query Designer, SAP Report Designer, SAP ABAP

PROFESSIONAL EXPERIENCE

Confidential

SAP Data Warehouse Cloud Developer

Responsibilities:

• Created/Edited/Managed/Monitored/Hibernated Space Management & DataSource Connections to Spaces (Local/Remote - S/4HANA). Space Allocations/Table Storage Consumption of Red, Green & Blue Spaces (under-utilized & Over-utilized Spaces); for Used Disk-Space / Used In-Memory Space
• Performed Admin tasks like Add/Delete/Manage: Users, Roles, Licenses (Users/Concurrent Session). Assigned System Owners. Import/Export Bulk Users from csv files, etc.
• Created Entity Relationship Models after joining Tables/Nodes, maintaining Associations. Deployed/Created Data Models after Data Preparation. Worked with different Sources/Repositories
• Managed Alerts after converting Attributes to Measures, for performing Calculations for Graphs/Charts, in Data Story Builder. Worked with Input Filters / Linked Analysis, in Story Creation
• Built Semantic Layer on top of Data Model using Data Builder

Confidential

SAP Consultant

Responsibilities:

• 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
• Helped Translate SAP BI Objects in SAP BW from English to French ( T-Codes: RSA1/SLWB/SP01/SE63)
• 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.
• Import/Export, Master/Transactional Data from several sources, maintained API Dependencies between Import Data, Ad-hoc / Scheduled Execution, Map Versions & Data, and defined Transformation Rules for Import Jobs
• Working knowledge of Predictive Analytics, Digital Boardroom, Project Smart Insight, Search to Insights, Smart Discovery, Smart Predictive, Natural Language Processing and Value Driver Trees (VDT) ; for Stories, in SAP Analytics Cloud
• Proficient in various Predictive Scenarios: Classification / Time Series / Regression
• Have working knowledge of Data Actions, Triggers, Allocations and implementing / re-using Allocation Rules in Stories
• Have working knowledge of Business Content for Integrated Financial Planning ( FP&A: P/L, B/S, CashFlow Planning, Revenue Planning, Cost & Activity Planning, Product Cost Planning) ; Installation, use and connectivity of SAP Analytics Cloud with other Systems like SAP S/4HANA, etc. (Import Jobs, OData Services, Relevant Field Selection, Filters, etc.)
• Have working knowledge of Planning & Scheduling: Processes/Activities/Tasks/Data Prompts/Gantt View Charts/Attachments, within SAC Planning Calendar, and Publishing them for users
• Have working knowledge of SAP Analytics Cloud, Analytics Designer
• 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
• 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-CompiledPlans), SQL Trace, SQLScript Optimizer - InLining, Memory Consumption, SQL HINTS, Out-Of-Memory Dumps, HANA SQL Query Performance & Optimization, ROW & COLUMN-BASEDData Stores, etc.
• 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
• 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
• 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
• Worked on EDI / IDOCs, from time to time
• 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
• 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
• 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 knowledge of Warehouse, Storage Type, Storage Section / Picking Area, Storage Bin, Storage Unit, Quant; & Special Stock Assignment, Batch #s, Transfer Orders, Pick, Put-Away. Have understanding 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, and finally to WM (T-Codes: LT01/LT21/LT23/LT26/MB1C/LX01). Have good working knowledge of SPRO, as well. Investigated IDOC errors (through T-Code: WE02 / MM90)
• 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
• 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 knowledge around Customer Data (FD03) / Sold-To-Party (VD03) / Billing Status / Payment History / Credit Ratings, Overview (FD33) / Account Balance Account Analysis (FD11) of Customers
• Have working knowledge of MS Power BI, as well . Created reports for Management, for detailed analysis
• 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 Material Serial Numbers Profile within MM, and generated reports, based on different Profiles, for analysis
• Practical working knowledge around SAP Cloud Platform Cockpit and its different Environments: Neo, Cloud Foundry & ABAP; MS Azure DataLake. SAP Cloud Platform Cockpit, SAP S/4HANA Admin Cockpit, SAP S/4HANA Cloud DataBase Explorer, SAP S/4HANA Cloud SQL Console, ABAP RESTful Application Programming Model (RAP), In-App Extensibility, Business Services, Core Data Services, Behavior Definition & Implementation, CDS Projection Views, Service Definition & Bindings, ADT, ABAP Based Side-By-Side Extensions on SAP Cloud Platform consuming Data from Core Business Applications via APIs, Concurrency Handling (Lock, eTag, Authorization, Feature Control, Draft), Web APIs (Features like: Release, Versioning, Depreciation), RAP APIs, CDS Abstract Entities, Code PushDown, Code BreakOuts, Service Instance & Subscription to Service, Service Plans, Schemas, Views, HDI (HANA Deployment Infrastructure), Containers, API Endpoints, Technical Keys, XSUAA (Extended Services for UAA), XSUAA, XSAPP, IdP (Identity Provider), SAML Assertion, JWT, CRUD Actions (Creating, Updating, Deleting), OAuth2, REST APIs, IAAS, SAAS, Private / Public / Hybrid Cloud, API Integration, Access, Security, DCL, DML, etc.
• Sound knowledge of “ Type of Accounts (Global/Trial) ” and its Configuration (Region, Global Account, Sub-Account, Space, Org. / Sub-Domain, Application, Service), etc.
• Ability to Setup/Manage inside Recipes: Global Accounts/Sub-Accounts/Entitlements/Services/Service Plans/Provider/Region/Org Name/Space Name/Sub-Domain
• Managed: Sub-Accounts/Directories/Resources/Boosters/Recipes/Systems/Entitlements (Sub-Account, Service Assignments) /Members/Administrators/Roles/Role Collection/Service Key/Destination Service/Connectivity/Security/Quota Subscriptions/Environment Variables/Binding Service to Applications; in SAP Cloud Platform Cockpit
• Used HyperScaler (AWS, Google, MS Azure, SAP, and Alibaba) as Infrastructure / DataCenter. Managed Accounts, Bandwidths, Rate, Plan, Required/Available Quota, etc. on HyperScaler’s Domain settings.
• Have working familiarity with SAP Business Application Studio . Thorough understanding of CLI (Command Line Interface), setting up Destination Targets (created connections b/w SAP Cloud Foundry & SAP Business Application Studio ), BuildPacks / Plugins for Full-Stack / Multi-TargetApplications in CF-Community, Created / Managed Workspaces, Projects; Cloned Repositories from Git-Hub, Start / Stop / Install / Delete / Expose & Open Port, for Service within BAS, Deployed Applications to Cloud Foundry from BAS
• Have working knowledge of Service: SAP Web IDE Full-Stack . Configured Trust Management, assigned Roles, managed Extensions, Preferences & other aspects of Service
• Built Projects from Templates, remote deployment of SAP HANA DB Application, DB Artifacts, created Tables & populated them with Data, created DataBase HDI-Containers, Schemas, from within SAP Web IDE ; in SAP HANA App., in SAP Cloud Platform Cockpit (Cloud Foundry), using Database Explorer
• Created Functions, Procedures, Virtual Tables, Analytic Privilege and Calculation Views, in SAP Web IDE. Performed Source to Target Mappings, and took care of all Semantics (Columns, Hierarchies, Parameters)
• Ability to deploy complete Project to different Spaces, after constructing all Artifacts / Services
• Comfortable at all aspects of SAP On-Premise to SAP Cloud ; and SAP Cloud to Cloud Integrations
• Have working knowledge of SAP Ariba Sourcing . Source Projects, Events, Add New / Pre-defined Content ( Standard Sourcing Documents / Content Documents) from Library for Events, Publish Projects, etc.
• Copy / Delete / Set Rules for Events. Add / Edit Lines for Events
• Perform Admin Tasks like: Create Suppliers, Users, Team Members, Groups, Assign different Roles & Permissions
• SAP Ariba Sourcing - Add Suppliers from DB and / or Discovery Posts / Supplier Research Posting; for Events based on Event Commodity & Location; Manage Supplier Profile Questionnaire, other related Documents, etc.;& Publish Posting. Register new Suppliers after satisfying requirements based on Questions asked / other Documents
• Monitor Events (RFP, RFI, Bid, etc.); and Quantity, Lot, Extended, Initial, Historic, Reserve Prices, Savings. Exported information to Excel & performed Comparison of Suppliers Responses
• Event Reporting: Reports - Bid Report, Bid Summary, Item Rank, Full Bid Data, Bid History, Bid Comparison, Questions & Terms, Event Summary, Supplier Response
• Create Scenarios, e.g. Lowest Bid, Splitting by Line Item for each Supplier (by % / By Quantity), exported to Excel for analysis, filled details; and then imported back to SAP Ariba
• Pause / Stop / Cancel / Award Event; Extend / Reduce Timing. Customized / Sent Emails to awarded / Rejected Suppliers
• Have working knowledge around Configuration of Tabs, and adding RSS / News Feed; configure Widgets, Notifications, User / System Logs, etc.
• Have working Configuration knowledge of AWS Data Solutions: Amazon Elastic Compute (EC2), Amazon Data Pipeline, S3, SSM, Storage Classes, Security & Encryption, Cross-Region Replication, Versioning, LifeCycle Management, Policies & Rules, CLI, VPC/VPC Endpoints (Interface/Gateway) & Components, FlowLogs, Route Tables, Bastions/JumpBox, NACL setup, Security Groups, NAT Instance/Gateway, SnowBall/SnowBall Edge, SnowMobil), Configure Subnets, IAM Role, Route53, DynamoDB, Relational Service (RDS), Elastic Map Reduce (EMR), Elastic Load Balancing (ELB) and Amazon Redshift; MySQL and PostgreSQL Databases, Hadoop/Hbase Cluster, Integration of Services for On-Premise technologies from Microsoft, IBM, Oracle, HP, SAP etc.; OLAP/OLTP
• Have understanding with setting up High-Availability Cluster (HP ServiceGuard, SIOS, RedHat, SUSE, Windows) setup from Start to Finish

Confidential

SAP Consultant

Responsibilities:

• 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 D atabase 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)
• Have working knowledge of TeamViewer

Confidential

SAP BW / BI Consultant

Responsibilities:

• Extracted SAP BW data, mixed / matched in order to produce different reporting requirements for Confidential, 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 / CharacteristicsStructure ” & Cell Editor, extensively. Also, used SAP BW Business Content & OffSet Variables, in SAP Query Designer
• Tailored Reports (AR/AP/G/L, Financial), Dashboards, KPIs, in SAP Analytics Cloud . Worked with creation / enhancement of SAC Models along with Stories / Dimensions / Measures, after extracting data both from Live & Import Data Connections (Flat-Files / On-Premise / Cloud) for Stories; for Reporting, Analysis & Financial Planning. Added Dimension Associations (with Attributes), Filters (Report / Page / Story) Level, Input Controls (Measure / Dimension) Level, Linked Analysis (for Reports / Charts), Calculations on Measures (along w/ incorporating Input Controls), etc.
• Proficient in Programming Languages like CSS, HTML, SQL and Python
• Have working knowledge of SAP Analytics Cloud, Authentication Options, SSO (Single Sign-On) of SAP Analytics Cloud with NetWeaver SAML 2.0 Custom IDP (Identity Provider) Authentication; and Administration functions (creating / adding Users, Roles, etc.); along with APIs
• Have knowledge of SAP BI Predictive Analysis through using SAP Lumira (Version 2.1) (Desktop / Cloud) . Mainly worked on A cquisition, Cleansing, Profiling and Manipulation of Data; Mapping Connections, Extracting Data (from SAP BW, non-SAP), Append, Merge, Ad-Hoc Data Comparison, TrendLine for BI Predictive Analysis
• Have working awareness of End-To-End Business Processes of SAP Business ByDesign - Customer Relationship Management (Target Group Management, Campaign Management, Lead Management, Opportunity Management, Sales Quote & Order Management), Supply Chain Management, Project Management, Financial Management, Information Management; and Activate Methodology

Confidential

SAP ABAP

Responsibilities:

• Have working knowledge and thorough concepts clarity regarding: SAP ABAP different Data Types (Character, Integer, Decimal, Time, Text, Date, etc.); and their application, Break-Points, Variables (Scalar, Structure, Internal Table), Arithmetic, Relational, Logical, String Operators, OverFlow Values, Library Functions (SQRT, STRLEN, LINES), ABAP Dictionary Structure - SYST (ABAP Reserved Words - SY-XXXX), String Operations (SPLIT, CONCATENATE, TRANSLATE, LOWERCASE, UPPERCASE, CONDENSE, etc.), Control Statements - Branching Control Statements (If-Else-Endif, Case-When-EndCase); Looping Control Statements (Do-While-EndDo, While-EndWhile), Top-Down Methodology, Off-Set Concepts, ABAP Programming Flow (Variable Declaration, Assignment, Control, OPEN SQL, Internal Table Commands, Function Module Statements). Read / pinout errors of ABAP. Have working knowledge of ABAP Web DynPro, as well

Confidential

SAP BW/BI Developer

Responsibilities:

• 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
• Competence in SAP S/4HANA Modeler Perspective 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, F lowgraph, 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
• Have sound knowledge of SAP BW/4HANA Modeling (Integrated Time Dependency, Slow Changing Dimensions, Complex Hierarchies, Analysis Authorizations, Geo-Spatial, Non-Cumulative Measures, etc.). Created MM / SD / WM / PS, Inventory & Projects reports, with complex criteria / Embedded BW; analyzed data in Analysis for MS Office
• Worked with aDSOs (Partitioning / Data Tiering / DB Activities), created Composite Providers – Virtual DataMarts (Navigation Attributes, etc.); and Analytical Queries (Drill-Down Capabilities, Calculations on KeyFigures, Filters, Unit & Currency Conversions, Exception Aggregations & Conditions, Restricted / Calculated KeyFigures, etc.)
• 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
• 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
• 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
• 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
• Performed BI Content Activation of Finance InfoCube (0FIGL C10) & necessary components
• 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
• 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
• 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
• Maintained SAP BW Security & Authorization – Analysis Authorization, Roles & Authorization on Hierarchy & Reporting Authorization,User Maintenance, etc. Secured data presented in Queries by Hierarchy Node
• 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++ (P urpose of every Layer in the LSA Reference Architecture), & ASAP Implementation Methodology

Confidential

SAP Senior Business Analyst

Responsibilities:

• 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.

Confidential

SAP BW / BO Developer

Responsibilities:

• 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
• Performed LO Extraction in Logistics Cockpit (LO) for Sales & Distribution (SD) Extractor, (2LIS 11 VAHDR)
• 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-FileInterface to target
• 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
• 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)

Confidential

SAP BW-IP Developer

Responsibilities:

• 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 BO Data Services - Designed and Debugged ETL process to extract data from disparate Technologies / Source Systems (DB2, Flat files), transformed as per Business Requirements and Loaded Data into Dimensional Data Models to support BI Reports, Dashboards, Scorecards, etc.

Confidential

SAP BW Developer / BI Analyst

Responsibilities:

• 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