Senior SAP BW/*HANA/ BI / BO Consultant

Business Intelligence Development w Data Warehousing / Modeling w Infrastructure Design w Internal Applications Development / Solutions Integration w Web Application Development w

Technical Writing / Presentation w User Training

CAREER PERFORMANCE QUALIFICATIONS & ACHIEVEMENTS

Over 12+ years of experience in SAP Business Warehousing (BW/4HANA, BW 7.5/7.4/7.3/ BI 7.0/BW 3.5) and SAP Business Objects 4.2/4.0/XI 3.1 and SAP Data Services 4.0/4.2.

Strong hands on experience in full life cycle implementation of BW 7.4/7.3, BI 7.0, and BW 3.5 which includes Data modeling, Data Extraction, Data Loading (Full/Delta Up-Loads), scheduling, monitoring, BEx Analyzer, Query Designer, Application Designer, Testing, Go-live and Production support.

Strong experience in Business Objects 4.2/4.0/XI 3.1

Extensively worked in Business Objects Data Services (BODS 4.0/4.2).

Extensive experience in developing data models in SAP HANA 1.0.

Knowledge in creating SAP Native HANA information models such as packages, Attribute Views, Analytic Views, and Calculation Views.

Knowledge in creating Advanced DSO’s and Composite Providers on BW on HANA.

Comprehensive knowledge on data extraction from SAP R/3(FI-CO, MM, SD, CRM, SRM, HR, HCM) using different Extractors such as LO Cockpit and CO-PA.

Good knowledge of complete Software Development Life Cycle as worked in a CMM level-5, PCMM level2 companies.

Good experience in onsite and offshore model.

Experienced in writing Start routines, End routines, Field routines and Expert routines using ABAP.

Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.

Experience in transporting the Business Warehousing Objects from Development to Quality and Productions. Knowledge of Transport Connection to collect objects for transport.

Experience and good knowledge in the migration of data sources and content from SAP BW 3.5 to SAP BW 7.3 maintaining the Transformations and DTP’s.

Experience in the configuration and implementation of the Process Chains for the regular data loads and scheduling and monitoring the data loads.

Strong Experience in transporting the BW objects from Development system to Quality system by using STMS.

Experienced in SAP BW front end tools BEX Analyzer, Query Designer and Web Application Designer (WAD).

Experience with Calculated Key Figures, Restricted Key figures, Structures, Characteristic Variables, Text variables, Exceptions and Conditions.

Strong experience in Business Objects and Proficient in Business Objects tools: Universe Designer, Desktop Intelligence tool, Information Design Tool, Web Intelligence Rich Client, Info View, BI Launch Pad, Crystal Reports, Dashboards/Xcelsius, Query As A Web Service, Report Conversion tool, Import Wizard and Live Office.

Experience in Design, Development and Deployment of Business Objects Solutions for corporate reporting requirements and experienced in building Universes, running queries and developing reports.

Proficient in generating Xcelsius Dashboards using the components like Charts, Selectors, Maps.

Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Intelligence and Business Objects Suite.

Compile and analyze detailed, user requirements with teams of primary business users, and technically trained personnel within IT department.

TECHNICAL ENVIRONMENTS

Install, Upgrade, Migrate, Configure, Modeling & Reporting

Business Intelligence Tools: SAP BW/4HANA, BI 7.5/7.4/7.3/7.0, BW 3.x

Reporting Tools: SAP Business Objects 4.1 / 4.0, BOXI 3.1, Xcelsius, Business objects Query for Excel, Crystal Reports, Universe Designer, Information Designer, Business Explorer, Web Application Designer, Reporting Agent, Report Designer.

Performance Management Tools: BW Accelerator, HANA Studio

ETL/ERP Tools: SAP R/3 3.0/4.0B/4.6C/4.7, ECC 5.0/6.0/7.0

Data Migration Tools: Business Objects Data services (BODS), SAP Landscape Transformation (SLT)

Database Experience: MS SQL Server/Access w Sybase IQ w Oracle w DB2

Programming: ABAP w HTML/DHTML w SQL/PLSQLw C/C++ w UNIX w

Software: MS: Excel / PowerPoint / Project / Word w Outlook

Operating Systems: Windows w UNIX w Linux w Citrix

Monitoring Tools: Clarify (CRM Tool) w HP Quality Center w Solution Manager w Share Point

Scheduling Tools: Tivoli w Control-M w Redwood w UC4

PROFESSIONAL EXPERIENCE

Client Name: Bobs Discount Furniture, Manchester, CT Feb 2019 to till date

Role: Sr. SAP BI Consultant

Environment: SAP BW/4HANA, SAP BW 7.5 on SQL Server, SAP ECC 6.0 (EWM, SD, MM), SAP BO WEBI, Analysis Office

Key Contributions:

Highly involved in BW/4HANA migration and worked closely with SAP team on migration approach.

Created ADSO, Composite providers, Open ODS view and Calculation views as per the data model to meet business requirements.

Highly experienced in Data modeling, Development, ABAP coding, Calc views, Debugging, Data Extraction, Reporting, Performance tuning, Open Hub Services, Analysis Process Designer (APD), Process Chains, applying OSS Notes and Production Support.

Created multiple Sales and Finance datasets thru Open hub for non-SAP systems to meeting business reporting requirements.

Involved in conversion of BEx to Analysis for Office workbooks.

Exposed ADSO’s as calculation views to HANA DB and used it in Webi written sales reporting.

Developed and implemented the data approach, manage the detailed work and data load plan, coordinate and assist in unit testing, Integration Test, Acceptance Test and Production data load activities including overall cutover plan.

Involved in various project cutovers (Outdoor Goof, Versatile, Mpos and CCA).

Worked on development of new reports in BOBJ as per the business requirement.

Involved in resolving the various tickets related to Stores/Store Managers and Business users by using Manage Engine ticketing tool.

Good Knowledge in SQL-BI reporting and Power BI.

Responsible for collection and documentation of the end user requirements and created technical specifications.

Involved in Analysis Office End-user training.

Client Name: Briggs & Stratton, Wauwatosa, WI Nov 2018 to Jan 2019

Role: Sr. SAP BI Consultant

Environment: SAP BW/4HANA, SAP ECC 6.0 (EWM, SD, MM), SAP BO WEBI, Analysis Office

Key Contributions:

Analyzed functional specification, converted into technical specification and provided estimation to complete the development to the client.

Prepared Conceptual data modeling flows and presented it to the client.

Involved in Granite enhancement project.

Created Generic datasources on top of views V_EQUI and ITOB.

Created Generic datasources on top of tables SER01, SER03, SER06, SER08 and OBJK.

Worked on WEBI reports Serial Number History and Serial Crate.

Created Attribute views, Analytic views, and calculation views as a part of SAP Native HANA Modelling using HANA Studio.

Client Name: Zekelman Industries, Chicago, IL Apr 2018 to Oct 2018

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.4 (BW on HANA), SAP ECC 6.0 (FI, SD, MM), SAP BO WEBI, Analysis Office

Key Contributions:

Involved in ATC enhancement project.

Worked on Corporate Holding hierarchies for the customer.

Worked with data source 0CO_OM_CCA_9 – Cost Centers actual costs using delta extraction.

Created Attribute views, Analytic views, and calculation views as a part of SAP Native HANA Modelling using HANA Studio.

Created Rebate and Freight cost, Ready vs Rolling, ATC ALL KPI reports as per the business requirement.

Worked on Material Standard cost reports.

Involved in resolving the tickets (Incident & Change Request) by using Service Now.

Client Name: Axiall, a Westlake Company, Pittsburgh, PA Nov 2015 to Mar 2018

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.4 (BW on HANA), SAP ECC 6.0 (FI, SD, MM, PP), VISTEX (Incentive and Payback module), Solution Manager, SAP BO 4.2, SAP HANA

Key Contributions:

Worked extensively on Data Modeling design like creating Info Objects, DSO’s (write-optimized), Info Cubes, MultiProviders, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc. in the new Axiall One BW system.

Created open hub services for Master and Transactional objects to export data from Legacy BW system (running on HP server) to Axiall One BW system (running on IBM server).

Created Master and Transactional datasources for the Legacy BW system objects in the Axiall One BW system and loaded data through the application server to the new system.

Installed necessary objects from the business content in the new Axiall One BW system.

Created write-optimized DSO’s (corporate memory ‘A’ layer) for the standard ‘B’ layer DSO’s.

Extensively worked on Vistex price request data sources /IRM/LIS_RM_GPRKON, /IRM/PQHDR_ATTR and /IRM/PQHDR_TEXT.

Extensively worked on vistex price request data sources /IRM/GPPHDR_ATTR, /IRM/LIS_RM_GPPKON and /IRM/GPPHDR_TEXT.

Worked with data sources 0CO_OM_WBS_2 (WBS Elements: Budget) and 0CO_OM_WBS_8 (WBS Elements: Budget Line Items).

Re-Initialized datasource 2LIS_06_INV after the system copy from production to quality.

Created a generic extractor for the table NAST (Message Details) to meet the reporting requirement.

Developed an Open hub to send the monthly G/L Balance file from Axiall One BW system to Westlake BPC system for the month end closing in Khalix_Migration project.

Worked on Repetitive manufacturing extractors 2LIS_04_PEMATNR and 2LIS_04_PECOMP in Westlake Integration project.

Involved in BW upgradation from 7.0 to 7.4.

Worked on creating Advanced DSO’s and Composite providers in BW HANA modeling.

Created Attribute views, Analytic views, and calculation views as a part of SAP Native HANA Modelling using HANA Studio. Implemented the business models using SAP Tables.

Created Process Chains for the month end closing and scheduled it for every 4 hours data refresh during the month end closing as per the business requirement.

Created alerts for the daily process chain to send failure notifications to the BI team.

Monitored daily and monthly closing process chains and opened incident tickets for the data load issues.

Transported the BW objects upon the approval from the manager by using solution manager.

Involved in resolving the tickets (Incident & Change Request) by using Service Now.

Customized queries using navigational attributes and filters in BEX analyzer as per client requirements.

Created WebI reports by using BICS connection on top of BEX queries.

Created documentation to the archived objects for the audit purpose.

Client Name: Dealertrack, New Hyde Park, NY Jan 2015 to Oct 2015

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.4 (BW on HANA), SAP ECC 6.0, SAP BODS 4.2, DB 2.0, Oracle 11g, SAP HANA

Key Contributions:

Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.

Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.

Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.

Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, MultiProviders, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc.

Worked on generic extractors to meet the reporting requirement.

Created Data stores to connect different databases from DS (Oracle, DB2 and ECC).

Created different objects in Data Services (Project, Batch Jobs, Work Flows, Abap Flows, Data Flows, Global Variables and scripts).

Created Script logic in Data Services Batch Job, to fetch the previous month data if you run the job in current month.

Loaded data from Data Services to SAP ECC custom tables by using custom IDOCS (ZUSTRB_IDOC).

Scheduling the jobs by using Business Objects Data Services Management Console.

Export the project from one environment to another environment.

Validation, Tracing and debugging Batch job; Capturing changes in data (Initial/Delta load) using Table Comparison, Map-operation, Key Generation Transforms.

Extensively worked with Different Transformations like Table comparisons, Date generation, Key generation, Query, Merge, Map operations, Validations, Pivot etc.

Maintained Process Chains to automate and schedule the data loads.

Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.

Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.

Debugging the jobs for data flow testing on each level.

Created local and global variables and scripts for initializing the jobs, work flows, Data flows.

Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.

Client Name: Hewlett-Packard, Houston, TX Jan 2014 to Dec 2014

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.3 (BW on HANA), SAP ECC 6.0 (FI), SAP BPC 10.0, SAP HANA 1.0

Key Contributions:

Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.

Involved in implementation for SAP BW/BI back-end and front-end which included Data modeling, Generic/Custom Extraction, Data Loading, Scheduling, Monitoring.

Involved in gathering user requirements, functional requirements, analyze, design, implementation, testing, and training with Clients.

Managing the Offshore team and ensuring the co-ordination is happening within the team for internal/external reviews for timely delivery.

Generated export data sources on Business Area (0BUS_AREA), Functional Area (0FUNCARE), Profit Center (0PROFTCTR) and loaded hierarchies from LHBW to VPS BW.

Generated export data sources on BCS (ZBCS_CD2C, ZBCS_CD2P, ZBCS_CD2O) Info Cubes and loaded the data from LHBW to VPS BW.

Created start routines, end routines and field routines in the system using ABAP.

Maintained variables in the TVARVC table and used the same variables in the routines.

Loaded data from external systems to BW using data services.

Triggered DM Packages to load data from BW to BPC.

Monitor the data loads (daily/weekly/monthly) from source systems by means of process chains.

Involved in performance enhancement features such as cube partitioning, aggregates and compression.

Prepared test scripts to validate the data between BW and BPC.

Actively involved in PSA and change log deletions for reducing the table space issues.

Created documents for the developed objects according to the user requirement specifications for support testing and for further guidance.

Client Name: DTE Energy, Detroit, MI Aug 2012 to Dec 2013

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.3, SAP ECC 6.0 (SD, FI, MM), SAP BO 4.0

Key Contributions:

Involved in full life cycle implementation, which includes Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

Worked on Data modeling, Data extraction, Generic/Custom Extraction, Data Loading, Scheduling and Monitoring.

Worked on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, time-dependent master data and also worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules and Data Transfer Process (DTP).

Worked on MM, SD, FI modules and loaded the data from ECC to BW and used initialization with delta update and full update methods.

Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS_02_HDR, 2LIS_02_ITM and 2LIS_02_SCL and activated the appropriate Business Content cube.

Extensively worked on data sources 2LIS_11_VAITM, 2LIS_11_VAHDR, for sales orders, and 2LIS_11_VASTI for order item status.

Created start routines, end routines, field routines and expert routines by using ABAP as per the business requirement.

Created and activated transformations (both DSO and InfoCube level) and wrote start routine and end routines.

Involved in scheduling the data loads, debugging and monitoring load failures, process chains, solving the tickets like delta loads.

Worked on performance tuning and trouble shooting of BW issues, connector issues and reporting errors.

Participated in transporting the BW objects from development server to testing server for unit testing.

Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.

Worked on query development and formatting techniques in BEX Query Designer.

Directly used SAP BEX queries to build a WebI documents by using BICS connection.

Experience in using IDT (Information Design Tool) used to design the Universe on more than one relational database. Also created queries using IDT.

Extensive experience with WebI in creating queries and reports that further used in the Dashboard Designer.

Developed Interactive reports and dashboards using Xcelcius and WebI reports.

Sound knowledge over Dashboard Designer components.

Client Name: Olin Corporation, Clayton, MO Nov 2011 to Jul 2012

Role: Sr. SAP BI Consultant

Environment: SAP BW 7.0, SAP ECC 6.0 (FI, SD, MM), SAP BO 4.0

Key Contributions:

Installed BI Content and enhancements based on business needs.

Identified the needs for data staging layers in BI.

Loaded data from external system CAS to BW using DBCONNECT.

Extensively worked on data sources 0FI_GL_4, 0FI_AP_4 and 0FI_AR_4to load financial transactions to the BW system.

Created expert routines in BW to load data from propagation layer to transformation layer.

Responsible for job schedules for loading Master Data (Texts, Attributes and Hierarchies) for Materials and Transaction Data into the corresponding DSO Objects and InfoCubes.

Monitored Process chains and fixed the issues daily.

Participated in transporting the BW objects from development server to testing server for unit testing.

Worked on BW Production support issues based on severity, Analyzing the issue and providing solutions accordingly.

Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using custom extractors.

Developed BO Web Intelligence reports (Ex-Brew and Ex-Dealer) by using BICS.

Technically involved in the responsibilities of security/authentication on the folder level for the Web Intelligence reports.

Scheduled Web Intelligence reports using Central Management Console (CMC) for the management team daily.

Validated the source to target data by using the sql test scripts.

Have worked on doing testing during BO 3.1 to BO 4.0 Migration.

Created BICS connection using IDT tool to broadcast Bex query for reporting purpose.

Worked on Performance tuning of Webi reports and BW backend design.

Conducted End User training on BO Web Intelligence upon request from HR.

Client Name: Purcell Systems, WA Mar 2011 to Oct 2011

Role: Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0 (SD, MM, FI, PP), SAP BO 3.X

Key Contributions:

Involved in the design, development and implementation of the Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load Master and Transactional data from SAP R/3 system into BW system.

Performed analysis, design, development and implementation of standard/customized InfoCubes and DSO objects.

Loaded data into Maintenance Orders costs and allocation and operations into cubes (0PM_C01 and 0PM_C04) using standard data sources 2LIS_17_ORDER, 0PM_OM_OPA_1 and 2LIS_17_OPERATION respectively.

Loaded Equipment master data into info object 0Equipment using data source 0EQUIPMENT_ATTR and using standard hierarchy 0EQUIPMENT_HIER.

Created Transformation, Data Transfer Process, Update rules, and Transfer rules.

Created and scheduled Process Chain for loading Master Data and Transaction Data and monitored the loads.

Developed reports using Bex Query Designer, using restricted key figures, calculated key figures, filter and formula as per the requirement of the query.

Worked on Cutover Activities (TCO & ACO) on monthly and quarterly basis which involves execution of cookbooks during the cutover activity.

Worked on front end level, created Web Templates according to the user requirements.

Worked on SIR (System Investigation Request), CR (Change Request) tickets.

Involved in extraction of full, delta loads and resolved data load related issues.

BIA Monitoring and BIA Index Maintenance for necessary cube.

Prepared Technical Specification documents as per the functional specification.

Monitoring process chains and fixing data load issues.

Prepared Unit test script documents for the UAT.

Created Incident tickets, Interaction tickets and change tickets in SM7.

Good experience in creating Universes over the Bex queries using Universe Designer.

Created many Variables and Prompts in BOBJ according to the user requirement.

Extensive experience in working with Infoview in creating and maintaining the WEBI reports.

Client Name: Bose Corporation, Framingham, MA Jan 2010 to Feb 2011

Role: Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0 (SD, FI, MM), SQL SERVER 2008, QLIK VIEW

Key Contributions:

Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.

Activating the business content according to the functional requirements.

Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.

Converted all Sql server tables and fields names from lower case to upper case and also reduced the length of fields to 16.

Created views in Sql server, based on that views designed cubes in SAP BW and loaded data from Sql server to SAP BW using DBCONNECT.

Worked with infopackages, transformations and DTP to load the data.

Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, and 2LIS_03_S194 and populated into the procurement info cubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.

Created setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.

Write ABAP routines to convert Sql server date format (Char) to BW date format (YYYYMMDD).

Created generic datasource by using table (TCURR) and loaded exchange rates data from SAP R/3 to BW.

Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.

Created Process chains to load last month and current month data daily.

Monitoring process chains and fixing data load issues.

Prepared Unit test script documents for the UAT.

Participated in transporting the BW objects from development server to testing server for unit testing and regression testing.

Maintained Reconciliation’s to verify the data in SAP BW and QLIK VIEW are same or not after the data loads.

Client Name: Guinness Anchor Berhad, Malaysia Apr 2008 to Dec 2009

Role: SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7, SAP BO 3.X

Key Contributions:

Involved in gathering business requirements, GAP Analysis, design and development of technical specifications.

Activated and utilized the business content according to the functional requirements.

Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.

Created generic extraction by using View and functional module to extract data from SAP R/3 to BW.

Extensively worked on enhancing the standard data sources as per client requirement.

Created custom InfoCube, ODS, Multiprovider, Infoset and InfoObjects.

Involved in solving performance-related issues and also involved in Creation of Aggregates to optimize.

Monitoring process chains and fixing data load issues.

Involved in resolving the Tickets (Incident & Change request).

Maintained Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.

Maintained Aggregates, Rollup and compressed Infocubes to improve the query performance.

Developed front-end queries and reports using BExAnalyzer, BEx Browser, and Info set Query, BEx Web Reporting tool and Web Application Designer.

Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.

Worked extensively on Web application designer to set up the template to test the web printing options.

Extensively worked in SAP Live Office to create connections between WEBI and Xcelsius Dashboards.

Sound Knowledge over Xcelsius Dashboard Components.

Client Name: Averis Sdn. Bhd, Malaysia May 2007 to Mar 2008

Role: SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7, SAP BO 3.X

Key Contributions:

Involved in gathering the requirements from users and Data Modeling.

Interfaced with Business Analysts and performed Gap Analysis.

Configuration of BW by identifying the Info Objects, Info Sources, Info Cubes, ODS from Business Contents.

Developed ODS objects to support Delta Upload.

Extracted data from Flat files to InfoCubes.

Scheduled InfoPackage for loading Master Data and Transaction Data and Monitoring.

Defined Process Chains for the data loads and scheduled accordingly.

Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded.

Enhance standard data source for master data attribute and transaction data.

Participated in transporting the BW objects from development server to testing server for unit testing.

Involved in resolving the Tickets like SR, MR&CR.

Prepared Unit test scripts documents.

Involved in System checks whenever required.

Maintained Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.

Scheduling and Monitoring background jobs.

Analyzing short dumps using ST22.

Coordinating with on-site team lead and updating day to day activities.

EDUCATION

Master of Computer Applications from Andhra University, India.

References: Available upon request.

Contact this candidate