Skill Reporter



Request for ProposalForSelection of Solution Provider for Design, Development and Implementation of IT Solutions Powered by Artificial Intelligence (AI) including Analytics & Real Time Dashboard for Andhra Pradesh State Skill Development Corporation (APSSDC)RFP Ref No: APSSDC/MIS- (AI) IT Platform/01/2018, Dated: 02/4/2018Issued on – 3rdPP April 2018(Techno-Commercial Bid)1393190544830-6388101597025G&J Infra building, 3rd Floor, D No.-78/2, Near NH-5, 12th Block, Near Prathuru Road, Tadepalli, Guntur District, Andhra Pradesh – 522501ContentsI.Important Instructions to the bidders3II.Inviting Proposals6III.Background6IV.Eligibility Criteria7V.Submission of Bids8VI.Evaluation of the bids9VII. Scope of Work10VIII. General Instructions17Annexure – I: (Marks Allocation Matrix)20Annexure – II: (APSSDC Skilling/Training activities synopsis)22Annexure – III (Applicant’s details)24Annexure – IV (Self-declaration for not being blacklisted)26Annexure – V (Turnover Details)27Annexure – VI: (Commercial Proposal Submission Form)28Page 2 of 28Important Instructions to the biddersProcedure for Bid SubmissionThe Bidder shall submit their response through Bid submission process on e-Procurement platform at www42TU..inU42T by following the procedure given below:The bidder would be required to register on the e-procurement platform www42T..in42Tor ..in42T and submit their bids online. Offline bids shall not be entertained by the RFP Inviting Authority for the RFPs published in e-Procurement platform. The RFP document can be downloaded from e-Procurement platform at .in or on the website of the APSSDC i.e. bidders shall submit their Pre-Qualification Bid, Technical bid and Price bid online in e-Procurement web site. The bidders shall upload the scanned copies of all the relevant certificates, documents etc., in support of their Pre-Qualification, Technical bids and other certificates/documents with clear readability, in the e-Procurement web site. The bidder should sign on all the statements, documents, certificates uploaded in the e-Procurement website, owning responsibility for their correctness/authenticity.IV.Amendments/ Corrigendum if any shall be published in the APSSDC website. The bidder has to keep track of any such changes by viewing the Addendum/Corrigenda issued by the APSSDC from time-to-time. APSSDC shall not be responsible for any claims/issues arising out of this.Pre-Qualification, Technical and Financial bids must be prepared in the prescribed formats and submitted online in e-Procurement web site and a hard copy of the same to the MD & CEO, AndhraPradesh State Skill Development Corporation (APSSDC), G&J Infra building, 3rd Floor, D No.-78/2, Near NH-5, 12th Block, Near Prathuru Road, Tadepalli, Guntur district, Andhra Pradesh- 522501 on or before 16/04/2018 up to 3:00 PM by hand/ through courier/ speed post.VI.Incomplete proposals or those received after the specified time and date or not fulfilling the specified requirement shall not be considered.B. Registration with e-Procurement platform:For registration and online bid submission bidders may contact HELP DESK on www42T..in42Tor ..inC. Digital Certificate authentication:The bidder shall authenticate the bid with the agency’s Digital Certificate for submitting the bid electronically on e-Procurement platform and the bids not authenticated by digital certificate of the bidder will not be accepted on the e-Procurement platform.For obtaining Digital Signature Certificate, you may please contact:Andhra Pradesh Technology Services Limited, Hyderabad / Vijayawada www42T..in/(OR)You may please contact any Registration Authorities of Certifying Authorities in India. The list of CAs is available in the link provided below.Page 3 of 28 ..in/DigitalCertificate/signature.htmlD. Hard copies:All the bidders shall submit the hardcopy of the DD towards the bid processing fee and EMD as applicable in APSSDC office at Vijayawada before proposal due date. All the bidders shall invariably upload the scanned copies of DD/BG in e-Procurement system and this will be the primary requirement to consider the bid responsive.APSSDC shall carry out the technical evaluation solely based on the uploaded certificates/documents, DD/BG towards EMD in the e-Procurement system and open the price bids of the responsive and technically qualified bidders only.Pre-Qualification, Technical and Financial bids must be prepared in the prescribed formats and a hard copy of the same to be submitted to MD & CEO, Andhra Pradesh State Skill Development Corporation (APSSDC), G&J Infra building, III Floor, D No.-78/2, Near NH-5, 12th Block, Near Prathuru Road, Tadepalli, Guntur district, Andhra Pradesh- 522501, on or before 16/04/2018 up to 3:00 PM by hand/ through courier/ speed post.IV.The successful bidder shall invariably furnish the original DD/BG towards EMD; Certificates/Documents of the uploaded scanned copies to the RFP Inviting Authority before entering into agreement, either personally or through courier or post and the receipt of the same within the stipulated date shall be the responsibility of the successful bidder. APSSDC will not take any responsibility for any delay in receipt/non-receipt of original DD/BG towards EMD, Certificates/Documents from the successful bidder before the stipulated time.On receipt of documents, APSSDC shall ensure the Genuinity of the DD/BG towards EMD and all other certificates/documents uploaded by the bidder in e-Procurement system in support of the qualification criteria before concluding the agreement.Deactivation of BiddersVide Ref GO Ms. No.174 – I&CAD dated 1-9-2008, if any successful bidder fails to submit the original hard copies of uploaded certificates/documents, DD/BG towards EMD within stipulated time or if any variation is noticed between the uploaded documents and the hardcopies submitted by the bidder, the successful bidder will be suspended from participating in the RFPs on e-Procurement platform for a period of 3 years. The e-Procurement system would deactivate the user ID of such defaulting bidder based on the trigger/recommendation by the RFP Inviting Authority in the system. Besides this, APSSDC shall invoke all processes of law including criminal prosecution of such defaulting bidder as an act of extreme deterrence to avoid delays in the RFP process for execution of the development schemes taken up by the government. Other conditions as per RFP document are applicable.The bidder is requested to get a confirmed acknowledgement from the RFP Inviting Authority a proof of Hardcopies submission to avoid any discrepancy.Payment of Transaction Fee:It is mandatory for all the participant bidders from 1st January 2006 to electronically pay a prescribed non-refundable Transaction fee to M/s. APTS, the service provider through "Payment Gateway Service on E-Procurement platform". The Electronic Payment Gateway accepts all Master and Visa Credit Cards issued by any bank and Direct Debit facility/Net Banking to facilitate the transaction. This is in compliance as per G.O.Ms. 13 dated 07.05.2006.Corpus Fund:Page 4 of 28As per GO MS No.4,user departments shall collect 0.04% of ECV (estimated project cost) with a cap of Rs.10,000 (Rupees ten thousand only) for all works with ECV upto Rs.50 Crores, and Rs.25,000/- (Rupees twenty five thousand only) for works with ECV above Rs.50 Crores, from successful bidders on e-Procurement platform before entering into agreement / issue of purchase orders, towards e-procurement fund in favour of Managing Director, APTS. There shall not be any charge towards e-Procurement fund in case of works, goods and services with ECV less than and upto Rs. 10 lakhsRFP Document:The bidder is requested to download the RFP document and read all the terms and conditions mentioned in the RFP Document and seek clarification if any from the RFP Inviting Authority. Any offline bid submission clause in the RFP document could be neglected.The bidder has to keep track of any changes by viewing the Addendum/Corrigenda issued by the RFP Inviting Authority from time-to-time in the e-Procurement platform. The Department calling for RFPs shall not be responsible for any claims/issues arising out of this.Bid Submission Acknowledgement:The bidder shall complete all the processes and steps required for Bid submission. The system will generate an acknowledgement with a unique bid submission number after completing all the prescribed steps and processes by the bidder. Users may also note that the bids for which an acknowledgement is not generated by the e-procurement system are treated as invalid or not saved in the system. Such invalid bids are not made available to the RFP Inviting Authority for processing the bids. The Government of AP is not responsible for incomplete bid submission by users.The bidders need to register on the electronic procurement market place of Government of Andhra Pradesh i.e., .in. On registration in the e-procurement market place they will be provided with a user ID and password by the system using which they can submit their bids on line.While registering on the e-procurement market place, the bidders need to scan and upload the required documents as per the RFP requirements on to their profile. The e-procurement market place provides an online self-service registration facility to all such Contractors who are already registered with respective participating departments for supply of specified goods and services.All the bidders shall invariably upload the scanned copies of DD/BG in e-Procurement system and this will be the primary requirement to consider the bid as responsive. The Department shall carry out the Technical bid evaluation solely based on the uploaded certificates/documents, DD/BG towards EMD in the e-procurement system and open the price bids of the eligible and responsive bidders. The Department will notify the successful bidder for submission of original hard copies of all uploaded documents and DD/BG towards EMD prior to entering into agreement.The bidders shall furnish a declaration in online stating that the soft copies uploaded by them are genuine. Any incorrectness/deviation noticed will be viewed seriously and apart from cancelling the work duly forfeiting the EMD, criminal action will be initiated including suspension of business.Page 5 of 28II.Inviting ProposalsAndhra Pradesh State Skill Development Corporation (APSSDC) invites proposals through this RFP from interested and eligible organizations for Selection of Solution Provider for Design, Development and Implementation of IT Solutions Powered by Artificial Intelligence (AI) including Analytics & Real Time Dashboard for Andhra Pradesh State Skill Development Corporation. Key Information is as under:Table -I-1: Key InformationItemReferenceRFP Issuing Date03/04/2018Reference NumberAPSSDC/MIS- (AI) IT Platform/01/2018Selection of Solution Provider for Design, Development andTitleImplementation of IT Solutions Powered by ArtificialIntelligence (AI) including Analytics & Real Time Dashboard forAndhra Pradesh State Skill Development Corporation (APSSDC).inWebsiteapssdc.inPre-bid Meeting09/04/2018, 3 PM onwards at APSSDC OfficeLast date of Submissionof RFP16/04/2018, 3 PM1. Dr. Ravi K Gujjula (CGM Technical)Email address: cgm42T.t@apssdc.in42TContact Person DetailsPhone no.: 98852547872. Mr. Debraj DattaEmail address: debrajdatta@42TPhone no.: 8349963608MD & CEO,Andhra Pradesh State Skill Development CorporationAddress of Submissionof RFP(APSSDC), G&J Infra building, III Floor, D No.-78/2, Near NH-5,12th Block, Near Prathuru Road, Tadepalli, Guntur district,Andhra Pradesh – 522501III.BackgroundAndhra Pradesh State Skill Development Corporation (APSSDC) is a unique organization formed as a public private partnership (PPP) corporation to promote skill-development & entrepreneurship in the state of Andhra Pradesh. The corporation now serves as the ‘Executive Agency’ for the newly formed Department of Skill Development, Entrepreneurship and Innovation. APSSDC will also serve the important tasks of providing high quality skilled manpower as part of the ‘Knowledge and Skills Mission’ of GoAP, which is one of the cross-cutting missions among the seven missions formed by the Govt. to facilitate double digit growth of the state.Under its long term vision, APSSDC is proposed to train 2 crores candidates, ranging from school going students, engineering and non-engineering students, in-trade services, unemployed, agricultural & allied,Page 6 of 28crafts, SHGs & entrepreneurship development.To achieve this target, APSSDC has taken up many skill development initiatives/training programs for the candidates starting from school students to graduates and post graduates including un-employed youth in the State. Apart from these initiatives, APSSDC is also implementing centrally sponsored schemes like DDUGKY, PMKVY and etc.APSSDC originally designed/developed different portals to capture the data, manage and monitor the training programs. The data is currently being captured through three different existing portals. There is about 7.5 Lakh beneficiary legacy data available as of now with APSSDC which is distributed among the various skilling/ Training initiatives.About 4.7 lakhs data pertaining to the schemes which are being implemented in the Academic stream. Under Non- Academic stream there is about 1.3 Lakh data pertaining to Job facilitations and Entrepreneurship. Rest of the data is being distributed among the various schemes like Youth Training Centres, RPL etc., refer Annexure- II for scheme wise synopsis, Progress/Legacy data and Indicative Projection of data.Since APSSDC is scaling up its activities by implementing new schemes and programs with a target to reach out a Million youth in the next financial year, it is further envisioned to work with Candidate-Level information and a strong emphasis on assessment and certification for the training imparted.Mitigating these challenges keeping the requirement of a robust analytic and real time Dashboard and MIS to make the growing skill ecosystem more efficient and transparent will require a complete redesign of the system with redefined business requirements with integration of existing portals. This requires a scalable, efficient, and effective transaction processing system that would manage high volumes of short-term and long-term skill development training data. The system further demands an analytical dashboard which can be used to analyze the large volumes of data to investigate the trends, predict outcomes and discover insights. These analytical dashboards should be encrypted with business intelligence tools with accuracy as a key factor. It should further consist of advanced BI features like drill-down and ad-hoc querying.IV.Eligibility CriteriaThe process will comprise of screening and selection based on the supporting documents submitted as mentioned below. Accordingly, marks will be assigned and evaluation to be done based on marking criteria defined in Annexure-I;Table -2: Eligibility criteriaS.CriteriaSupporting Document/sNo1Profile of the applicantAThe Bidder shall be incorporated under Companies ActCertificate of IncorporationBThe Bidder should have been in operation for a period of atCertificate ofleast 3 years as on 31/03/2017Incorporation/RegistrationThe Bidder should have implemented IT solution/Dashboard,Relevant copy of the work order orhave development and implementation experience of at leastCcompletion certificates to be providedfor three years and have done;by the bidder? One IT Project/Dashboard of not less than the amount ofPage 7 of 28S.CriteriaSupporting Document/sNo10 Crores Or;? Two IT Projects/ Dashboard of not less than the amount 5Crores Or;? Three IT Projects/ Dashboard of not less than the amount3 Crores.2Financial CapabilitiesThe Bidder should have minimum annual turnover of ?50Certified copies of Financial StatementsACrores in each of the last three consecutive years (FY 2014-duly certified by Chartered Accountant15, 2015-16, 2016-2017).(Please refer Annexure V).Bidder/Software service provider should not have beenSelf – Certificate3black listed at any time by the Central /any of the State(Please refer Annexure IV).Governments/ PSUs4The Bidder should have at least 100 people on its rolls in theCertificate from HR/Company secretaryarea of IT solution operation and maintenance.5The Bidder should have valid ISO 9001:2015 certificate orCopy of ISO Certificatelatest.V.Submission of BidsAs mentioned in ‘Important Instruction to Bidders’ section, a hard copy of the proposal is also needs to be submitted at APSSDC office. The Bid prepared by the Bidder should comprise the following components:Technical Bid – Part I: Separate sealed cover comprising of prescribed formats at Annexure –III onwards with superscriptions as “Technical Bid– Selection of Solution Provider for Design, Development and Implementation of IT Solutions including Real Time Dashboard for Andhra PradeshState Skill Development Corporation”.Commercial Bid – Part II: Separate sealed cover comprising of prescribed format at Annexure --VI onwards with superscriptions as “Commercial Bid – for Request for Proposal (RFP) for Selection of Solution Provider for Design, Development and Implementation of IT Solutions including Real Time Dashboard for Andhra Pradesh State Skill Development Corporation.”Bidder to keep both Technical Bid and Commercial Bid in a single separate sealed cover with superscriptions as “Bid for Selection of Solution Provider for Design, Development andImplementation of IT Solutions including Real Time Dashboard for Andhra Pradesh State SkillDevelopment Corporation” and RFP No. APSSDC/MIS- (AI) IT Platform/01/2018.Any bid document not conforming to any one of the above terms will be rejected.Bidder is required to deposit a non-refundable processing fee of Rs. 25,000/- (Rupees Twenty Five Thousand only) and Earnest Money Deposit (EMD) of INR 10 Lakhs along with the bid. The Processing Fee and EMD must be in the form of a crossed demand draft Payable to ‘Andhra PradeshState Skill Development Corporation’ payable at Vijayawada, drawn on any scheduled commercial bank and must accompany with Covering Letter in cover of the Proposal Document. Proposals that are not accompanied by the Proposal Processing Fee and EMD shall be rejected by APSSDC.Page 8 of 28If work is sanctioned, the bidder would be required to furnish a Performance Bank Guarantee i.e. an amount of 5% of the work order with validity of post three month of the project duration, within 15 days of the issuance of work order/before signing the Agreement.VI.Evaluation of the bidsEvaluation of Technical BidsA Committee constituted by the APSSDC will carry out evaluation of the proposals received by it in order to determine whether they are substantially responsive to the requirements set forth in the proposal. In order to reach such a determination, committee will examine the information supplied by the bidders, and shall evaluate the same as per the evaluation criteria specified in this proposal.The Technical evaluation shall involve:Document based evaluation of the proposal (Desk Appraisal) as per the Mark Allocation Matrix given at Annexure – I.Presentation by Applicants.Presentations: The committee will invite each applicant to make a presentation. The purpose of such presentations would be to allow the bidders to present their proposed approach to the evaluation committee and the key points in their proposals.The Committee members will assess the presentations of the bidders on specific parameters related to their capacity to deliver.Final score will be assigned to the bidders after assessing document based and presentation scores as per Marks Allocation Matrix given at Annexure –I . Bidders obtaining minimum 70 marks will be eligible for next round of evaluation i.e. commercial bid evaluation.The Committee reserves the right to reject any or all proposals on the basis of any deviations. Selection of bidder will be done solely at the discretion of the Committee /APSSDC.APSSDC reserves the right to accept or reject any proposal, and to annul the evaluation processand reject all proposals at any time prior or post award of contract, without thereby incurring any liability to the affected proposal or bidders or any.When deemed necessary, during the Bid Evaluation process, Committee/ APSSDC may seek any clarifications from the bidders.Conditional Bids will be rejected.Evaluation of Commercial BidThe commercial evaluation would be based on the Quality and Cost Based Selection Method (QCBS). The weights given to Technical and Financial proposals are:Technical = 70% and Financial = 30%The normalized Financial score of the technically qualified bidders will be calculated, while considering the Total cost of Bid given by each of the Bidders in the Financial Bid as follows:Normalized Financial Score of a Bidder = {Lowest TCB/Bidders TCB} X 1000 (adjusted to 2 decimals)Page 9 of 28The final score will be calculated through Quality and Cost selection method based with the following weight-age:Technical: 70% Financial:30%Final Score: (0.70*Technical Score) +(0.30*Normalized Financial Score)The bidder with the highest Final score shall be treated as the Successful bidder.In the event the final scores are ‘tied’, the bidders whose score is tied securing the lowest (among all the tied bidders) financial score will be adjudicated as the Best Value Bidder for award of the Project.VII.Scope of WorkThe scope of work for the bidder is Requirement Study, Design, Development, Testing, Deployment, and further Operations and Maintenance of the following solutions for a period of next 1 year. APSSDC reserves the right to extend the O&M for further 1 year subject to satisfactory performance, without any changes to the original O&M terms.Development & Integration of Portal/s.APSSDC has developed a website and portals to carry out the implementation and monitoring of the various schemes and training programs by enrolling candidates for academic, non-academic domain and Job Melas. Some of the processes are automated and semi- automated. Bidder is required to study these portals and accordingly provide a solution by integrating them as a single Portal. It is expected that there would be a single portal for APSSDC through which these application would be redirected. The details of the available portals and website is given in below table for reference:Table 3: Details of Existing Portals and WebsiteSNPortal We blinkTypeActivities coveredSchemes/Programs Covered1 publishingContent/Notification publishing?Student registration?Employability Skill Center (ESC-?Training Partner?Degree College)registrationYouth Training Centers (YTC)?Creation of?SchoolVocationalizationSchemes andPrograms (ASPIRE)?Courses?SC, ST TrainingsStudent Attendance?SIEMENS Training Programs2 Assessment?Job Melas?tracking, etc.?Entrepreneurship DevelopmentEmployerprograms and etc.registration?Job Mela calendarpublishing(for non-engineeringprograms)?Student registration?3DS Max Workshop?Training Partner?Advanced Python Workshop?registration? Amazon Web Services Technical3 ofEssentials WorkshopSchemes and?AutoCAD Workshop and Fusion?Courses360 WorkshopStudent AttendancePage 10 of 28SNPortal We blinkTypeActivities coveredSchemes/Programs Covered? Student Assessment?CATIA Designer and experttracking, etc.Workshop(for engineering?Embedded System (IoT)programs)Fundamentals?Google Android DeveloperFundamentals Workshop?Mechanical Techno zoneWorkshop (Catia V5-Designer)? MIT App Inventor Workshop?PLC Fundamentals Workshop? PLC Phase - 2 (Advanced)?Progressive WebApplications(PWAs)? Revit Architecture and StructureWorkshop?Electronics Innovation Zone -Scilab 2017? Internet of Things (IoT)Workshop – 2017?PLC Workshop – 2017And many other programs arecovered.Table 4: Technical specifications of the existing portalswww42T.apssdc.in42Tjobskills.apssdc.inengineering.apssdc.inTypeStaticDynamicDynamicTechnologyWord Press 4.7.9 with PHPJava, J2EE, OAuth,SpringAndromedaFramework(Different modules), Hibernate,(Angular)usedJasper Reports and BiometricDatabaseMy SQLMy SQLPostgreSQLGUIJava Swings, HTML, Java Script,Angular, HTML5Bootstrap & JQueryAPIs availableNoAll the services aredependent on APIsThis is an CMS website and thereAvailableSchematic/is no dataflow fordifferentmodules, we are not includingData mapschematicdiagramof thewebsiteServer/SpaceCloudCloud- AWS Cloud (2 M1 LargeInstances)1438275-2856865Skill Development Management System (SDMS)The Skill Development Management System (SDMS) is envisaged to have the following broad features but not limited to pertaining to the skill life cycle. Portal will act as a single entry point and connects the entire Skills Ecosystem and helps Youth, Training Providers, Employers, Govt., Funding/ Sponsoring Organizations etc. The bidder is to develop the work flow management software and automate the processes and also to customize the processes available with the existing portals. A list of schemes andPage 11 of 28programs (along with its indicative data size) being running under APSSDC is provided at Annexure – II for reference.Table 5: Automation RequirementsSL.Feature/ ModuleAdditional InformationNo.Functional Requirementa.Candidate registration and onboarding?Aadhaar e-KYC for registration of candidatesprocess? Workflow based approval process?Enrolment of candidatesb.Candidate dashboard and feedback processSummary information of all activities, Pending activitiesqueue, Message inbox and links tocommonly usedfunctionsc.Training Partner due-diligence, registration?Workflow based approval process.and onboarding process?Mechanism to capture due diligence of TP’s Centreinfrastructure for proposed Job Rolesd.Learning Management System (LMS)? Integration of existing LMS with scalabilitye.Batch &Training Management by TrainingBatch creation, Assessment etc. Applicable to all schemes runPartnerby APSSDC?Batch training schedule? SSC certified Trainer Assignmentf.Biometric Attendance management systemAADHAR based Biometric Attendance management system. Itshould be integrated and synchronized with the appropriateportals/API.g.Photo and video gallery of trainingMechanism to capture photos and videos to be uploaded bystakeholders in the portalh.Assessment and certification?Assessment and certification processes for Academicschemes to be automated? Mechanism to capture relevant assessment data? Mechanism to automate request for Assessment ofcandidates to APSSDC by the TPsi.Placement?Mechanism to capture data for self-employment/placement details for all candidates in theportal? Storage of salary slips for each candidatej.Onboarding of Industries and other? Industries and placement agencies to access thestakeholderrequirement and place the job opportunities in theportal.k.Post-placement tracking? Mechanism to capture, track and report data of trained?candidates post placementAlumni databasel.Campaign Management for conducting JobEstablish communication channel with potentialMelaparticipants, delivery of promotional messages, queryhandlingmTraining Partner DashboardSummary information of all activities, Pending activitiesqueue, Message inbox and links tocommonly usedfunctionsn.MonitoringMeant for APSSDC and Inspection agencies for ensuringadherence to guidelines and fraud prevention.o.ReportingDynamic and static reports generation.Page 12 of 28SL.Feature/ ModuleAdditional InformationNo.p.Bid ManagementPublishing of tenders and evaluation process.q.NotificationPromotional & Transaction based Push notifications, SMSand Email notifications to all the concerned stakeholdersr.Chat bots for simple queriesAutomated answers to commonly asked queries for betteruser experiences.Migration of data from existing system toTransactional and Analytical data includednew SDMSt.Database access for call centreProcess for availability of database access with APSSDC callcentresu.The solution has to meet at least theNo. of concurrent departmental users – 50following concurrency access requirementsNo. of concurrent Training partner users – 100No. of concurrent candidates using dashboard – 100000No. of concurrent candidates using mobile application –500000v.System administration & Maintenance ofAll master data to be accessed by SDMS and peripheralmaster data of SSCs, Skills, Qualifications,applicationsuser roles etc.Non-Functional RequirementwLeverage of open source languages andVendor dependency is not desirable in respect of proprietaryframeworkstools/ frameworksx.Highest level of data securityData both in transit and at rest should be absolutely secure bymeans of data encryption or equivalent meansDashboard design and developmentThe primary objective of this project is to design, develop and implement a real time comprehensive analytics based interactive solution with capability to analyze and provide insights from the data which will help APSSDC to see the performance & Monitor of the various schemes and training programs.The overall scope consisting of the following:All kinds of technical support involving prescriptive and predictive insights of data through BI analysis process by collating, joining and analyze the scheme wise data.Provide user licenses for BI/ Analytics Engine on cloud for the contract period. The cost for the same is to be borne by the bidding firm.Provide infrastructure on cloud for the contract period. The cost for the same is to be borne by the bidding firm.Operations & Maintenance of the application for periods specified in the RFP.Hosting of generated reports in a portal, accessible to important stakeholders. Modify the BI application / reports as per the day to day need.Key Characteristics of Proposed BI based Solution:It is proposed that BI & Analytics dashboard be enhanced with additional functionality for visualization and instant data driven decision making.Enable data driven decision making through a series of dashboards / services that provide holistic understanding of district wise scheme functionality.Page 13 of 28Should display the Scheme-wise key performance indicators that can be monitored and is measurable in terms of, its value, its target, visual indication of the status, relevant scales and ratios, progress over time and geographic mapping where applicable.Tools such as filtering and drill-down can be used in dashboard; department’s key performance indicators, actions which also include lag & lead performances district wise etc.The portal can be accessed by the Departmental HODs/Officials concurrently to monitor effectively & take necessary actions if needed.The data gets automatically updated without any assistance from the user. The frequency of the data updating will vary with the schemes. Dashboard data gets updated on real time basis.APSSDC will feed the criteria and the portal will generate reports on prescribed models.Implement “filter” in the reports and customize search results to find exactly what the various departments want for “predicative analytics to enable decision making + prescriptive analytics to streamline and improve efficiencies and effectiveness”.Connecting to Data & APIs:Connecting to multiple data sources such as MSSQL, MYSQL, Any Web Services, Web Links and Excel spreadsheets, etc.Functional ability to connect various source level data (Training Partner, Beneficiary, District, Mandal, etc) across multiple databases and transaction typesConnecting with other data sets such as Industries, Labour and socio-economic data to augment and contextualize data.Triangulation of data from multiple sources for data validation, verification and enrichment.Tools to enable user defined/managed data such as definition of KPIs, goals/targets, privacy settings, alerts, permissions.BI Analytics Dashboard Design:Creating Summary, Department, District and Geographic real time Dashboard.The numbers & visualizations shall indicate the situation on Skill Development Initiatives and shall be easy to read and intuitive to understand. This may include:Analytics: bar/3-D bar with multiple lines, pie/3-D pie, line, scatter, time series.Mapping: heat, bubble, animated bubble, choropleth, tile, multi-layered, etc.Color coding to be used for high priority / flagship projects, welfare, central or external supported projects and to showcase important data.Filtering and selection capabilities can be easily added to reports with common action elements such as drop-down/combination boxes, check boxes and slidersApplication of data manipulation tools such as ranking, calculations, formulas and display rules.Drill down functionality to source level data.Dynamic Search and to find data instantly.Geo-clustering and geo-querying capability to identify focus areas & areas that requirePage 14 of 28improvement instantaneously.Optimizing for printing and exporting to a digital document format such as Word, Excel or PDF.Auto generation of real time PPT on the progress of APSSDC.Source to capture the call centre statistics.Build an automated system by which data are retrieved from back-end data stores and visualized in user-friendly web reports.Build an extensible architecture that allows for the addition of new reports and new levels of granularity over time to the Dashboard over time.Enabling dynamic generation of reports based on user specifications (e.g., set a time frame and report adjusts graph for that timeframe).Cloud infrastructure is to be used for deployment of the solutions. Deployment Model shall be complied with Normal standards of security and privacy.Strategic planning features:Visualization for monitoring the various KPIs across the Skill Development Schemes with presentation of variations.Visualization techniques and framework to empower users/ decision makers to appreciate the reports quickly and take educated decisions.Support decision making for allocation or re-allocation of resource to achieve the goals.A GIS / map based view to compare between districts / Mandals for various indicators.Provision to create custom queries to represent the data on a state /district / Mandal map.Provision to have a Timeline view to see progress after every month / year.Deployment ModelCloud infrastructure is to be used for deployment of the solution and it is to be quoted in the bid as cloud license for contract period only.Normal standards of security and privacy as proposed by Government of India shall be complied with.Strict prohibition of sharing the data with any other department.The entire application comply with all laws and statutes of Government of Andhra PradeshData sharing from the participant departments shall be through Web services only.IS & Web Services SecurityTo facilitate secured transactions, reliable data availability 24x7x365, confidentiality and authentication, the following security controls are proposed for the solution.All aspects of Web services including routing, management, publication, and discovery should be performed in a secure manner. Web services implementers must be able to utilize security services such as authentication, authorization, encryption and auditing. Encryption of data shall take place at client level itself. Application server shall provide SSL security.Page 15 of 28Artificial Intelligence (AI) based Chat-bot solutionThe Bot must be capable of handling all relevant queries as raised by prospective candidateson nearby training centres, relevant skill courses, job prospects etc. in English, Telegu, Hindi and Hinglish capabilities to identify user’s query/request/complaints and respond accordingly.ChatBot solution should be updated with all the latest information related to APSSDC’s existing as well as newly introduced schemes and services at any point of time.The firm should enable suitable information security / cyber security and secure configurationin respect of the components, and utilities in the system, as per requirement of the APSSDC from time to time.The Solution should focus on operational efficiency, quality and cost efficiency with continuous improvement by learning from regular sessions.The solution should adhere to the security policies set up by APSSDC and Government of India.Development of Mobile ApplicationThe widespread adoption and use of mobile technologies have the potential to provide new and innovative ways to improve training delivery and the skilling needs of individuals by providing access to need based training. Mobile apps for people are being developed to create awareness and to enhance access to skilling programs for all people of the state of Andhra Pradesh and support employability.APSSDC intends to have a fully developed mobile application available on widely accepted smart phones. As part of the IT enablement of the various schemes run under the aegis of APSSDC, and it is envisioned to get a mobile app developed to cater to the masses. It would enable the public to have information about the schemes, skill development institutions in their vicinity, availability of courses, locating jobs and many more.A complementing set of mobile apps to help and manage the skilling portal and its stake holder on small devices like phones, pads and tabs. Also, taking into consideration of remote locations the apps should work offline. Broadly, the following features, but not limited to, are expected in the Mobile App:It is expected that app shall be available for iOS, Android and windows mobile operating systems.Access be based on unique login identity and permission.App shall be integrated with the portal solution as mentioned in this RFP.App shall support multi-lingual interface (minimum Telegu, Hindi and English).App shall be modular, and capable of progressively upgrading to cater to future needs.The app shall have dedicated modules to handle Skilling centres’ location, course list, scheme comparison and information about the various jobs available in the vicinity of the candidate.App shall provide the placements connects.App shall register the user after downloading the mobile application;Push notifications – Through this feature, the users shall notify one time about any new version/feature of the app which may be added later on.Page 16 of 28Testing and SecurityThe IT solutions developed are proposed to be tested by Standardization Testing and Quality Certification (STQC) or its authorized personnel prior to its deployment. The security framework for all the applications should be compliant with latest guidelines issued by Government of India.Operation and Maintenance Phase (O&M)Bidder is expected to provide support including maintenance and troubleshooting of codes and cloud hosting during O&M phase for one year.Handholding supportBidder is expected to support handholding support post completion of the project in view of cloud management other relevant aspects of the project.VIII.General InstructionsPeriod of Validity of BidsBids should remain valid for the period of at least 180 days from the last date for submission of bid prescribed by the APSSDC. A bid valid for a shorter period shall be rejected by the APSSDC as non‐ responsive. In case the last date of submission of bids is extended, the Bidder shall ensure that validity of bid is reckoned from modified date for submission. Further extension of the validity of the bid will be decided by the APSSDC in case of need.Amendment of Bidding DocumentsPrior to the last date for bid‐submission, the APSSDC may, for any reason, whether at its own initiative or in response to clarification(s) sought from the prospective Bidders, modify the RFP contents/ covenants by amendment. Clarification /amendment, if any, will be notified on APSSDC’s website (apssdc.in). No individual communication would be made in this respect.Authorization to BidThe proposal/ bid being submitted would be binding on the Bidder. As such, it is necessary that authorized personnel of the firm sign the bid documents. The designated personnel should be authorized by a senior official of the organization having authority.Payment Terms and ConditionsThe payment will be released subject to satisfaction of the performance and deliverables according to the following milestones:SNMilestonePayment (% of remaining contractvalue excluding O&M for 1 year1Submission of Functional Requirements Specification5%(FRS) report2Integration of existing portals10%3Automation of SDMS Skill development Process15%Page 17 of 28SNMilestonePayment (% of remaining contractvalue excluding O&M for 1 year4Development, integration and deployment of15%dashboard solution5Development, integration and deployment of Chat30%bot solution and Mobile application7Soft launch of portal, dashboard, chatbot, mobile15%application and testing + certification8Operations and Maintenance10%Execution of SLAThe successful bidder shall execute a Service Level Agreement (SLA), which would include all the services and terms and conditions of the services to be extended as detailed herein and any other conditions as may be prescribed by the APSSDC. The bidder shall execute the SLA within one month from the date of acceptance of letter of Appointment/work order. The contract shall be executed by the authorized signatory of the bidder.TimelinesThe following timelines have been given for each of the deliverables:Table 8: TimelinesSNActivitiesTimelines (T= Date ofissuance of work order)1System Study and requirement gathering of existing portalsT+15 daysand training programs2Integration of existing portalsT + 1 Month3Automation of SDMS Skill development ProcessT + 2 Months4Development, integration and deployment of dashboardT + 3 Monthssolution5Development, integration and deployment of Chat botT + 4 Monthssolution6Development, integration and deployment of MobileT + 4 Monthsapplication7Soft launch of portal, dashboard, chatbot and mobileT + 5 Monthsapplication.8Testing and CertificationT + 6 Months9Go-live of portal, dashboard, chat bot and mobile applicationT + 6 MonthsPage 18 of 28AnnexuresPage 19 of 28Annexure – I: (Marks Allocation Matrix)A) Marking Criteria for document based technical evaluation will include the following parameters:Marking DimensionsMarking CriteriaMaxMarksPast Experience45st?More than 5 years – Marks 55Number of years in operations of firm as on 31P PMarch 2017?Between 4-5 years – Marks 3?Less than 4 years - Marks 2Past experience in providing IT solutions/?No of Projects more than 5 - (15 Marks)15Integrations/application development/IT for?No of Projects > 3 and <= 5 - (10 Marks)Government Organizations/PSU/Public sector Banks?No of Projects > 1 and <= 3 - (5 Marks)?No of Project = 1 - (2 Marks)Past experience in providing IT platform for?No. of Candidates more than 50 Lakhs – (1515candidate Onboarding and registration for a largemarks)volume of candidates?No. of Candidates > 30 lakh and <= 50 Lakhs - (10marks)?No. of Candidates > 20 Lakh and <= 30 Lakhs - (5marks)?No. of Candidates >5 Lakh <= 20 lakh - ( 2 marks)Past Experience with AI/BI representation in?Yes – 5 marks5projects?No – 0 marksPast Experience in development of dashboards in?Yes – 5 marks5previous projects?No – 0 marksTechnical Capabilities20Developed IT solutions/Dashboards for projects?Yes – 10 Marks10related to Skill Development or Training or Digital?No – 0 MarksAssessment/ candidate onboarding and registrationplatforms for Government/PSUPast Experience in providing support in Operation?No. of Projects more than 5 - (10 Marks)10and Maintenance phase under IT solution provider?No. of Projects > 3 and <= 5 - (7 Marks)?No. of Projects > 1 and <= 3 - (5 Marks)?No. of Project = 1 - (2 Marks)Average Turnover of last three Financial Years10Average Turnover in last three Financial Years in IT?More than 70 Crore - 15 Marks10projects related to Skill Development or Training or?> 60 Crores and <= 70 Crores - 10 MarksDigital assessment or candidate Onboarding and?registration for Government/PSUBetween 50 Crores to 60 Crores – 5 MarksCertification & Standards5CMMI?CMMI level 5 – 5 Marks5?CMMI level 4 – 4 Marks?CMMI level 3 – 3 Marks?CMMI level 2 – 2 Marks?CMMI level 1 – 1 MarkTotal80Page 20 of 28B) Marking Criteria for proposal presentation evaluation will include the following parameters:S. NoCriteriaMarks1Proposed Approach and Methodology42Project Plan43Technical Solution proposed54Innovative services proposed in the technical proposal35Showcase an existing project related to Skill development or Training or Digital assessment for4Government/PSUTotal20Page 21 of 28Annexure – II: (APSSDC Skilling/Training activities synopsis)The training/Skilling activities which are being implemented under APSSDC have been classified into two main streams as follows:AcademicNon-AcademicAcademic Scheme:Academic schemes mainly caters to the students starting from 8thP P to Post Graduation and are being implemented in Schools, colleges of technical and non-technical etc.. Below are the main schemes being implemented under Academic Stream:Scheme nameStakeholdersCoverageCurrent Progress/ProjectionLegacy data (Inon Datalakhs)(In Lakhs)Schools Program?APSSDC316 schools across AP?Schools(180 Social Welfare and?Students (8thto 12th136 Tribal Welfare)1.321.35PPPP)?Training partnerEngineering?APSSDC290 CollegesProgram?Engineering &?Polytechnic CollegesTrainees (Faculty,12?Students)EmployersDegree colleges?APSSDC390 Colleges(Employability Skill?Degree Colleges/Centres)?Universities23Students (3 years)?EmployersSIEMENS Training?APSSDC40 Colleges (6 CentreCentres?SIEMENS authoritiesof Excellences 34 t-(Polytechnic/ ITI)?Polytechnic/ITISDIs)0.231colleges?StudentsTotal4.557.35Non-Academic Scheme: Programs which mainly focuses on the non-academic stream aspirants and are placement oriented.Job Facilitations: The programs specially designed to cater to the immediate requirement of aspirant and Employer within a short duration. The salient features includes the following:Spot registrationsJob orientationsInterviewsSelection/ShortlistingResultsPage 22 of 28Table 0-1 : List and Progress of Programs under Job FacilitationsScheme NameStakeholdersCoverageCurrentProjection onProgress/ LegacyDatadataJob Fairs?APSSDC? Per month 4 Job melas?Unemployedacross the4734480,000YouthConstituencies of AP.?EmployersUdyogaratham?APSSDC?Target of 25 for each?UnemployedRatham. 175 Per?YouthMonth10162000Training Partner?EmployersModel Career?APSSDC?Employment office atCentre?UnemployedTirupati?YouthTraining Partner21293600?Employment?OfficeEmployersEmployment?-Do-?Employment office at27833600ExchangeGunturTotal5327289200Page 23 of 28Annexure – III (Applicant’s details)Important instructions:It is advised that Information sought Annexure-III onwards is filled completely and signed for proposal evaluation and marking purposeApplicant to provide soft copy of the unsigned editable (scanned copy when editable copy is not available) proposal, Annexure-II onwards in the Word Document format shall be submitted in an encrypted pen-drive which shall be enclosed in the sealed envelope along with the ORIGINAL proposalApplicant’s details21590165100Details of the Applicant1.Name of the Company/Firm2.Registered Office Address in India3.Legal status of the firm(Whether Proprietorship / Partnership Firm / PrivateLimited Company / Section-8 Company / Section-25Company (old companies Act - Companies Act,1956) /Public Limited Company / Society / Trust / Association)4.Details of Incorporation/Registration of the firmDate:Ref. #5.Details of Commencement of BusinessDate:Ref. #6.GST registration no.7.Permanent Account Number (PAN)8.Name & Designation of the contact person to whomall references shall be made regarding this EOI9.Telephone No. (with STD Code)10.Email of the contact person:11.Website12.Awards13.Past experience in providing services similar to therequirements described in this document (Nature ofwork and No. of years) (Work orders/MoUs to beattached)14.Processing Fee detailsDD No. and Date:Name of the Bank:Valid upto:15.EMD detailsDD No. and Date:Name of the Bank:Valid upto:Page 24 of 28Financial Details (as per Balance Sheets) (Amount in Crores)FYFY 2014-15FY 2015-16FY 2016-17Documentary Proof Required: (As Applicable)Registration Certificate / Certificate of incorporationCertificate of commencement of Business issued by the Registrar of Companies.GST Registration CertificatePAN NumberMemorandum and Articles of Association.Annual Reports for the last 3 years.Financial reports for the past three consecutive FYs certified by authorized CAStatement of experience and competence428625213995Name of projectsName of theProject DurationValue ofBrief ProjectS.NClientStartCompletionProject insuccessfully completeddescriptiondatedateINR1.2.3.Note: Please submit the relevant documents as proof in view of projects being highlighted in above table, Mark Allocation Sheet and eligibility Criteria.2. Understanding of the project & Solution:A Brief technical proposal by the bidder on Project Scope, Understanding of the project, technologies proposed covering the activities highlighted in this RFP and other issues related to project.Page 25 of 28Annexure – IV (Self-declaration for not being blacklisted)(The Declaration Letter is to be submitted by Company Secretary/ Authorized Representative and Signatory on Company’s Letterhead with his/her dated Sign and Seal)To,The MD & Chief Executive OfficerAndhra Pradesh State Skill Development Corporation,2nd floor, Above Arrival Terminal,Pandit Nehru Bus Stand, Vijayawada, Andhra Pradesh.In reference to the EOI No. APSSDC/ITSD/001/RFP/2018 dated……….., as a representative(s) of…………………………… (name of the applicant’s organization), I/We hereby declare that our organizat ion……………………………………………. is having unblemished past record and was not declared blacklisted or ineligibleto participate for bidding till the time of submission of response to this EOI by any State/Central Govt. or PSUdue to unsatisfactory performance, beach of general or specific instructions, corrupt/fraudulent or any otherunethical business practices.For and on behalf of:Signature:Name:Designation:(Company Seal)(Authorized Representative and Signatory)Page 26 of 28Annexure – V (Turnover Details)(Declaration by Chartered Accountant on Letterhead with his/her dated Sign and Seal)To whomsoever it may concernOn the basis of audited financial statements, we hereby certify that (Name of Agency) having registered office at (Office address) has an average annual turnover of ……………………………… in the past three consecutivefinancial years (2014-15, 2015-2016, 2016-17). The details of annual turnover are mentioned below:S. No.Financial YearOverall AnnualSoftware/Profit after TaxNet Worth ofTurnover of theApplicationCompanyfirm (INR)Development12014-201522015-201632016-2017(Chartered Accountant):SignatureNameRegistration NoContact No.SealDatePage 27 of 28Annexure – VI: (Commercial Proposal Submission Form)Location:Date:ToThe Managing Director and Chief Executive Officer,Andhra Pradesh State Skill Development Corporation,2nd floor, Above Arrival Terminal,Pandit Nehru Bus Stand, Vijayawada, Andhra Pradesh.Dear Sir,We, the undersigned, offer to provide the for [Insert title of Assignment] in accordance with your Request for Proposal dated [Insert Date], and our Technical Proposal. Our attached Financial Proposal including applicable taxes is for the sum of [Insert amount(s) in words and figures].We hereby confirm that the financial proposal is unconditional and we acknowledge that any condition attached to financial proposal shall result in reject of our financial proposal.Our Financial Proposal shall be binding upon us subject to the modifications resulting from Contract negotiations, up to expiration of the validity period of the Proposal.We understand you are not bound to accept any proposal you receive.We remain,Yours sincerely,{Signature}{Stamp}Page 28 of 28 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download