Data Sap
Resume:
Saminder Singh
Email: *************@*****.***
Mobile: +1-647-***-****
Summary:
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:
Data Warehousing : SAP BI, SAP HANA, DESIGN STUDIO, WEBI, DASHBOARD
SAP Modules : SD, CRM, VISTEX, HCM.
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
Warehouse)
● 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