Sign in

Data Sap

Toronto, Ontario, Canada
January 29, 2018

Contact this candidate

Saminder Singh

Mississauga, ON, L*W *G*


Mobile: +1 647 *** ****


Around 10+ years of IT experience in analysis, design, development, implementation and production support with Canadian Permanent Residence.

Responsible for the design, development, configuration and testing within the BI-BOBJ area.

Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting.

Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.

Troubleshooting issues and fixing them in source system.

Scheduling and Monitoring the Process Chains and rectifying the issues to ensure the regular data update to BI from source System.

Experience with SAP HANA data modeling using Attribute View, Analytical View and Calculation view.

Worked on full life cycle implementations in SAP BI/BW. Worked in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover and Training to Go Live.

Worked on business requirements gathering, developing functional and technical specs, and data modeling using Multidimensional Modeling and extended star schema.

Responsible for designing, developing and delivering solutions using Business Intelligence-Business Objects to meet business requirements.

Interact and engage frequently with business managers, project leaders and functional leads to discuss specific business needs and requirements. Gauge the complexities of business processes and particular functional/business area issues, prioritizes and develop customized reporting solutions that meet core business requirements, proactively supporting new business needs and delivering business benefits.

Participated in user meetings to resolve ongoing implementation issues, performance and code reviewing.

Good experience in analysis, design, development, testing, support, maintenance of applications and Team management process, coordination and monitoring deliverables from team

Having good Communications skills, being a smooth team player with excellent interpersonal Skills and ability to work independently

Working knowledge of Tableau.

Technical Skills:



Senior Systems Integrator

City of Toronto - Toronto, ON - January 2017 to Present

Provides leadership in the area of SAP Netweaver BW development at strategic,project and operations levels

Develop Workforce Dashboard using Design studio using Bex Query as Source.

Extensive use of CSS and Java Script in developing the highly formatted dashboard.

Create ADSO and Composite providers on BW on HANA application.

Develop ETL process for data load and retrieval.

Develop and/or apply complex information and business models (e.g.,

Provincial/municipal information model, departmental data marts and corporate

Data warehouse) within the context of corporate architectures and technology standards.

Lead the day-to- day SAP Netweaver BW project development in a 7x24 production environment

Co-ordinates with the business and technical users to ensure BW policies and procedures are adhered to by application users and interfacing applications.

Lead business data warehouse, DataMart and ETL design, development, testing to ensure applications meet the needs of the business and compliant to SAP SDLC best practices.

Participates in sustaining and improving corporate infrastructures, methodologies, tools, techniques and standards; ensures their conformance and adherence in daily practice among business and technical teams

Communicate effectively and in a timely manner to stakeholders, clients, project managers, supervisors and team members any business and technical decisions and actions that may impact solution delivery, staff performance, business processes, management workflow and technical support of public services

Analyzes and recommends changes to current business practices, business and information processes, data flows, performance measures, information delivery and knowledge utilization toward a more efficiently managed and coherently integrated information environment for all departments in the City

System Development Specialist

City of Toronto Aug 2016 to Dec 2016

Perform analysis and design duties as well as programming, modelling and scripting, testing, documentation and deployment preparation using Sap BW, BOBJ.

Coordinates and prepare needs analysis and detailed systems design.

Conduct user interviews to determine detailed systems requirements.

Complete preliminary analysis, system and functional design, workflow diagrams for quality systems development.

Design, code, test, implement and maintain enterprise systems.

Designs and develop systems that comply with access and privacy legislation.

Coordinate and develop program specifications and documentation.

Design and conduct all levels of testing i.e. unit, system, integration, regression, performance, security, usability, optimization/configuration and coordinates user acceptance testing.

Liaise and coordinate with internal and external consultants in detailed systems deliverables and technical problem resolution.

Implement enterprise in-house developed/custom/packaged systems and systems changes.

Test integrated systems to ensure system compatibility and proper functional integration.

Provide application maintenance and enhancement including implementation of vendor systems fixes and patches.

Conduct quality assurance on departmental and external developments.

Develop system interfaces between enterprise and departmental systems.

Perform information and application data conversions.

Provide development support to users by providing technical assistance and troubleshooting.

Provide documentation and instruction/training to users of the system.

Design and develops application security interfaces to enable clients in controlling and administering access to their systems.

Provide expertise, advice and technical skills for information and application service delivery.

Conduct research and evaluation of hardware/software/framework and makes recommendations.

Recommend, presents and demonstrates system solutions to City management and corporate business clients.

Conduct presentations, system demonstrations and system walk-throughs at project review meetings.

Direct the activities of staff, mentors, and recommends training.

Contribute to project charters, statements of work and project plans, project status reports and variance explanations, risk identification and mitigation planning.

Conduct research, investigates and recommends best practices for information and application services.

Contribute to post-implementation project reviews.

Recommend improvements to current methodologies, processes, standards, policies and guidelines.

Contribute in planning of future system growth and provides detailed work plans.

Participate in enterprise projects.

Conduct feasibility studies, business cases, RFI/P/Q’s, technical reports by researching and participating in evaluations and recommending solutions.

Determine user training needs.

Participate as a team member in the execution of project plans providing technical expertise and advice re: architecture, development tools, work effort estimates.

Senior Consultant

ECOLABS Mississauga, ON Nov 2015 to May 2016

Responsible for requirement gathering, Development of Reports for modules Inventory, FI, OTC solutions for ECOLABS Canada Rollout.

Onsite coordinator for SAP HANA migration of the existing solutions.

Create Universe, calculated views, attribute Views, analytical views on HANA and create Webi reports, Dashboards.

Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.

Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.

Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.

Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.

Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with Bex as source.

Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0

Improving and optimizing DataSources, InfoSources, DSOs, Master Data and InfoCubes and automating the scheduling of jobs with process chains and monitoring data loads.

Client: Costco Wholesale, CANADA, USA Oct 2014 – Nov 2015

SAP BI/BW Lead Consultant

BW Lead for COSTCO wholesale support and implementation.

Responsible for designing, developing and delivering solutions using Business Intelligence-Business Objects to meet business requirements.

Responsible for Lead development and delivery of SAP BW. for upgrades, on-going maintenance, development of processes

Created and Enhanced SAP HR BI/BW reports for Payroll, Time Management and Personal Administration

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 HR 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 ( HR), VISTEX and CRM reports.

Client: ABInBev, USA. Feb 2014 – Oct 2014

SAP BI/BI/BW Senior Consultant

● Gathered requirements, analyzed feasibility, mapped the Gaps, designed HLD and DLDs.

● Migration of Global KPI Tool with using Webi (Reporting) with SAP HANA (Datawarehouse).

● Designed new application for Logistic Cost using Webi (Reporting) with SAP HANA (Data


● Designed developed both Master Data & Transactional data flows in SAP HANA.

Client: Nike, Oregon, US. March 2013 – DEC -2013

SAP BI/BI/BW Senior Consultant

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.

Client: P&G Cincinnati, USA. April 2012 – March 2013

SAP BI/BW Consultant

Resolving assigned tickets as per SLA

Worked on migration Finance Reporting with Data Model from Cognos(reporting) with DB2(Database) to BOBJ(Reporting) with SAP BW on HANA(Datawarehouse) and BODS(ETL).

Analyzing and fixing issues related to BI/BW data load failures

Monitoring of the BI/BW process chains and analyzing the reasons for frequent failures of the processes.

Informing the clients about the success or failure of the loads as soon as the activity is finished.

Involved in Reconciliation of data between PSA and Data targets & Source system and the BI/BW System.

Involved in Month-end, Quarter-end and Year-end activities

As part of load monitoring team lead, responsible for migrating transfer rules, update rules, data sources and Info sources troubleshooting the issues.

Gathered requirements, analyzed feasibility, mapped the Gaps, designed HLD and DLDs.

Coordinating with ECC team for creation of test data for possible test scenarios.

Scheduling test with business users and arranging for signoff.

Communicating to users about the risks involved along with the down time and report availability.

Client: Pepsi Food & Beverages, Chandigarh, India. Dec 2010 – March 2012

SAP BI/BW Consultant

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 BI/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.

Client: Novartis March 2009 - Dec 2010

SAP BI/BW Consultant.

Responsible for working with business users to generate functional requirements Specifications and Conducted GAP analysis

Designing BI/BW Data Modeling, LO - Extraction, Data Loading (Full/Delta Up-Load) and Reporting.

Creating transfer structure, transfer rules, communication structure, update rules & info sources (for both ODS and Info cube).

Enhancements to standard Extract Structures according to client’s requirements.

Creating Info cubes, ODS’s and Multi providers as per the technical spec.

Designing and developing reports using BI/BW BEx Query Designer.

Transported the requests from Development to the Quality and moved to Production Server.

Loading data (Master data & Transaction data) from SAP R/3 to SAP BI/BW.

Used aggregates, changed the design to increase the performance of data loading into the cube.

Created Process Chain to Automate the Data loading for Transactional Data and Master Data.

Client: Mercedes Benz, Moscow Dec 2007 – March 2009

SAP BI/BW Associate Consultant

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

Client: Tata Technologies Ltd, Pune, India. July 2006 - Nov 2007

SAP Consultant.

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 BI/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 BI/BW 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

Academic Profile:

●MBA in Information Technology, NMIMS, MUMBAI (INDIA)

●Bachelor of Technology,Information Technology, Punjab Technical University, India

Contact this candidate