Saminder Singh Email & Phone Number

Mississauga, On, Ca

Toronto, Canada Area

Solid Waste Management System (SWMS):• ● Designed and developed end to end solution for City of Toronto Solid Waste Management Services (SWMS).● Created ADSO and Composite providers on BW on HANA application.● Create SAC models for SWMS using Live and import connections.● Design interactive Dashboards using SAC.● Used Java scripts and script variables in SAC Analytic Applications.● Created SWMS stories for end users in SAC.● Consolidated data from Toronto Maintenance Management System (TMMS), Solid Waste Application Portal (SWAP) into BW to create data mart.● Developed and maintain the strategy for consolidating data for analytical applications and create conceptual and logical data models ensuring that uniformly recognized and accepted data definitions are developed and applied throughout the BW Solution Architecture.● Analyzed business and functional requirements to define target SAP BI/BW solution architecture● Design and develop BW data models & data flow objects like DTP, Extractors, and Info-packages.● Develop and trouble shoot ABAP programs including user exits, function modules and start/end/expert routines

Mississuaga, Ontario

Client:ECOLABSImplementation project for Canada ECOLABS

Issaquah ,Wa

Client: Costco Wholesale (USA,CANADA)• BW Lead for COSTCO wholesale support and implementation.• Work with various stakeholders, to understand business drivers, goals and actionable outcomes using analytics• Responsible for designing, developing and delivering solutions using Business Intelligence-Business Objects to meet business requirements. • Created and Enhanced HR BI/BW reports for Payroll, Time Management ,Personal Administration and Organizational management.• Developed and implemented VISTEX Webi Reports related to Charge Backs and Purchase Rebates.• Developed BI/BW Trend reports for CRM Loyalty Management showing membership trend and Renewal rates. • Change the BEx report to suit to the COGNOS, preferable created the variables at the BEx end• Participated in BI/BW system readiness for FUT and SIT• Improving and optimizing DataSources, InfoSources, DSOs, Master Data and InfoCubes and automating the scheduling of jobs with process chains and monitoring data loads• Participated in pre go-live and Hypercare activities • Prepared functional and technical design documents.• Day to Day support activities for HCM, VISTEX and CRM reports.

Usa ,Oregon

Client: Nike, Oregon, US. • Support day to day SAP OFS (Order Fulfillment System) activities to ensure smooth operation of production system.• Worked on complex reporting issues related to Coverage, Booking & Tracking.• Resolving issues faced by users, support monthly and yearly activities and coordinate with offshore team on daily basis.• Minor enhancement which includes design and development, code reviews, unit testing and deploys changes to BI/BW production system• Pro-active communication of batch delay / outage to business users.• Training & Change Management to ensure the users are properly trained to use the new functionality and given full support till they handle it independently.• Ensure the deliverables meet the client expectations and at the same time provide technical & functional knowledge to required resources to ensure smooth transition.

Chandigarh Area, India

Client: P&GKey Responsibilities:•Worked on BI 7.0, ABAP, front end components: Query Designer & Analyzer.•Detailed analysis and documentation of Existing model and available infrastructure.•Interaction with business users on impact of redesigning data model.•Coordinated with functional teams to get clarification during designing and development phase.•Identified the info providers, InfoCubes, DSOs that would be affected by the change.•Impact analysis on existing transformation and identifying the fix.•Indentify opportunities for ABAP code optimization in transformations.•Analysis of reports and changes involved as a result of redesign.•Estimating development time along with time required for unit testing, UAT & system testing.•Changed backend objects such as infoobjects, key figures, cubes, dsos and multiproviders.•Created and modified ABAP routines in transformations for lookups, delta cases, key figure calculation.•Changed queries and components such as filters, RKFs, CKFs and exception aggregations.•Creating test scripts and maintaining issue log for Bug fixing and tracking.•Coordinating with ECC team for creation of test data for possible test scenarios.•Scheduling test with business users and arranging for signoff.•Planning for cutover activities including data drop, reload strategy and BIA rebuild timing.•Communicating to users about the risks involved along with the down time and report availability. •Liaising with release management team to find proper transport window and possible backout options available.•Tracking and resolving post go-live issues and Closure of project.

Chandigarh Area, India

Client: Pepsi Food & Beverages• Participated in teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.• Worked with Business Process Owner and Project teams to develop new and evolve existing data warehouse subject areas by designing/modeling, developing, testing and implementing the appropriate data architecture (including InfoCubes, InfoObjects, ODSs, InfoProviders, etc.) needed to meet business requirements and establish the Enterprise Data Warehouse.• Applied Data modeling best practice to existing BW environment to get better query performance. • Understood the Performance Improvements in areas like Change Run, Aggregate analysis, Compression techniques, Query Parallel processing.• Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with exceptions, restricted key figures and calculated key figures.• Extensively used BEx analyzer, created queries with variables, filters. • Used RRI feature to jump between the queries to analyze the data.• Interacted with business users to analyze the requirements of reports

Chandigarh Area, India

Client: NovartisKey Responsibilities: •Assigned user authorizations and profiles to user ids, setup security for the developers according to the business requirements.•Technical implementation of role-based authorization concept with PFCG•Created corresponding BI 7.0 Roles from BW roles and Analysis Authorizations•Analyzed SU53 error checks during testing and to find missing authorizations and transaction codes•Manage SAP security for development, quality assurance, sandbox, training, and production systems•Development of custom security solutions when necessary to meet business requirements •Development of solutions for securing custom transactions, tables, and programs •Periodic review and revision of application security roles • Adding/removal of queries, reports, BSP, Info types, Info cubes, and related authorization objects and queries URL’s.•Created CATT/SeCAT scripts for mass user maintenance and assigning roles

Moscow, Russian Federation

Client: Mercedes Benz, Moscow • Implementing effective application security solutions • Facilitation of security requirement /specification gathering process for SAP Security • Development of custom security solutions when necessary to meet business requirements • Development of solutions for securing custom transactions, tables, and programs • Periodic review and revision of application security roles to accommodate the changing needs of the business• Involved in the performance tuning of Info cubes by partitioning, rollup and compression.• Involved In writing Routines in transfer rules and update rules and Routines at info package level and field level• Debugging programs and code as and when required

Pune Area, India

• Worked extensively on Administration Workbench.• Creating transformations, DTPs (for both ODS and Info cube).• Enhancements to standard Extract Structures according to client’s requirements.• Creating Info cubes, DSO’s and Multi providers as per the technical spec.• Worked extensively on BW BEx Analyzer in building Queries and saving as Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables, Structures and cell definitions.• Monitoring of the process chains and analyzing the reasons for frequent failures of the processes. • Communicating with the customer who posted the Ticket.• Create users and authorizations • Creation and implementation of security methodology for SAP ERP• Periodic review and revision of application security roles to accommodate the changing needs of the business • Development of solutions for securing custom transactions, tables, and programs

Mba, It

Bachelor Of Technology (B.Tech.), Information Technology