Reports Specialist Agency


[PDF]Title: Data Analyst/Reports Specialist Agency - Rackcdn.com10ba4283a7fbcc3461c6-31fb5188b09660555a4c2fcc1bea63d9.r13.cf1.rackcdn.com...

3 downloads 135 Views 274KB Size

         

Title: Data Analyst/Reports Specialist Agency: State Comptroller, Office of the Contract Number: C000961 CR Number: 2007942 Date of Issue: 10/10/2014 Due Date/Time: 11/03/2014 4:00 PM Questions are due by October 16; responses will be posted October 23. County(ies): Albany Location: 110 State Street, Albany, NY 12236 Classification(s): Information Technology - Consulting & Other Services Miscellaneous - Consulting & Other Services Opportunity Type: Discretionary procurements between $50,000 and $200,000

    

Description Contact Info Documents Updates Bid Results

The Office of the State Comptroller intends to procure services for a Data Analyst/Reports Specialist for the Bureau of Contracts pursuant to its discretionary purchasing authority under State Finance Law §163(6). This procurement opportunity is limited to New York State small businesses, and businesses certified pursuant to Article 15-A of the New York State Executive Law. The New York State Office of the State Comptroller’s Bureau of Contracts (the “Bureau”) is seeking a Data Analyst/Reports Specialist. The goal of this engagement is engage a specialist knowledgeable in the use of database tools such as TOAD and SQL Plus to create advanced queries to extract data from multiple systems and in building new database tables for advanced data analysis. BACKGROUND New York State is making significant changes to the Statewide Financial System (“SFS”) which includes an upgrade of the application to PeopleSoft 9.2 and the reengineering of customizations to the Procurement Module. Existing databases and software applications used to track and record activities within the Bureau will require significant updates to restructure interfaces with the new SFS and other relevant internal and external systems. These changes will also require the Bureau to make extensive modifications to all reports. The Data Analyst/Report Specialist will assist with the changes. SERVICES The Candidate will be responsible for working with the Business Analysis and Reporting Team (BAR Team) in the Bureau to create reports and use advanced SQL for data extraction and data conversion activities. The Candidate must become intimately familiar with the multiple applications that are currently being used in the Bureau. REQUIREMENTS The Candidate must:

    

Be available to begin work in Albany, New York on December 1, 2014 Have at least five years of experience in complex data analysis across multiple systems and applications Have at least three years of experience with database applications and use of database tools. (e.g.: TOAD, SQL Plus) Have at least three years of experience using advanced Structure Query Language (SQL) to update or retrieve data from database sources Have at least three years of experience with Open Database Connectivity (ODBC) to interface with multiple databases

 Have at least three years of experience using Microsoft ActiveX Data Objects(ADO) to manipulate data within a database  Have at least three years of experience using Microsoft Data Access Objects (DAO) to manipulate data within a database  Have at least three years of experience using advanced Visual Basic Applications (VBA) to automate repetitive processes required to manipulate data and create complex financial reports SCOPE OF WORK

 Applications and databases within the Bureau which will require analysis and structural change in the following ways:  Modification to databases, applications and downstream systems to accommodate new fields and system logic  Application, system, electronic file transfer and database interfaces updated based on new interface rules, including both inbound and outbound extracts  Modification to all existing queries to extract, organize and structure necessary data elements due to such changes noted above  Existing data conversion in order to sync with all systems, databases and applications QUESTIONS All questions must be received by October 16, 2014. The comprehensive list of questions and responses will be distributed on or about October 23, 2014 to all Candidates known to OSC to have an interest in the solicitation. This listing will not include the identities of the vendors submitting the questions; those vendors will remain anonymous to the extent allowed by law. PLEASE NOTE:

 Hours will be completed on-site. The address is 110 State Street, Albany, NY 12236.  The term of the agreement will be for a period of 12 months. The Candidate is responsible for all travel related costs that these services will incur.  The response to this request should include a resume and a completed and signed Attachment A that describes how the candidate meets or exceeds the requirements listed above, including references, and an hourly rate that is inclusive of travel and any other miscellaneous expenses.  The Proposer, if selected, agrees to enter into an Agreement substantially in accord with the terms of Attachment C (Draft Contract Agreement), should the Proposer be selected for the contract award. The Draft Contract Agreement will be posted to OSC’s website as soon as it is available. BACKGROUND INVESTIGATIONS OSC policy requires that background investigations be conducted on Contractor staff who will have access to OSC’s IT systems, access to OSC confidential information/data, or routine access to any OSC facility. For purposes of this policy, “routine access” is defined as access to an OSC facility for five consecutive business days or ten business days over the annual term of the engagement. Accordingly, the Contractor must certify that it has conducted a background investigation, or will conduct a background investigation prior to services being provided to OSC, of such staff members who provide Services under the Agreement entered into as a result of this solicitation. At a minimum, background investigations shall include a review/evaluation of the following: Social Security Number search and verification of U.S. citizenship or legal immigration status (if appropriate); criminal history check/court records (Federal, State and local for the past five years); work experience/history (for the past five years); and pertinent education/professional credentials. Based on that background investigation, OSC has the right to review the results of the Contractor’s background investigation and its supporting documentation upon request. OSC reserves the right to conduct its own background investigation of the Contractors staff. The Contractor must undertake a background investigation of any new/replacement staff during the term of the Agreement entered into as a result of this solicitation. The Contractor will need to certify that staff provided to perform Services possesses the necessary integrity and professional capacity to meet OSC’s reasonable expectations. Subsequent to the commencement of Services, whenever the Contractor becomes aware, or reasonably should have become aware, that any staff member(s) providing Services to OSC no longer possesses the necessary integrity or professional capacity, the Contractor shall immediately discontinue the use of such staff and notify OSC. OSC has final approval of any staff furnished to provide Services and may refuse to approve any staff member(s) based on its review of the staff member’s responsibility to perform the required Services. OSC reserves the right to bar anyone from access to OSC’s premises and/or access to OSC’s information resources. The Contractor will be required to maintain records related to the background investigations performed for the term of the Agreement entered into as a result of this solicitation. For the purposes of this Section, “staff” includes employees, owners, officers, directors, or agents of the Contractor and of any of the Contractor’s subcontractors.

SUBMISSION REQUIREMENTS Proposers must submit all documentation as listed. Documents received after the due date may be rejected.

 Attachment A – Proposer’s Certified Statements, completed and signed by an Authorized Representative of the Proposer who is authorized to bind the Proposer contractually.  Attachment B – Candidate Qualifications, Experience, and References, completed and signed by an Authorized Representative of the Proposer. Contact information submitted on Attachment B for experience will be used as references to verify experience.  Resumes for Candidates proposed demonstrating that the Candidate meets or exceeds the requirements listed. Submissions may be delivered via courier or by email (preferred) by the due date. Interested vendors must submit resumes, Attachment A including hourly rates for proposed candidates, and Attachment B to [email protected]. Vendors cannot submit more than ONE (1) candidate. The subject line of the email should reference contract number C000961. Submissions via email must reference C000961 in the subject line. OSC will not be responsible for email submissions that are misdirected due to error. It is the Proposer’s responsibility to ensure that emailed submissions have been received. All proposals must be received by NOVEMBER 3, 2014 at 4:00 p.m. ET. Proposals received after this Deadline may be rejected. To be considered eligible, the Proposer must submit a complete response to this solicitation in conformance with the content requirements listed above. A proposal that does not provide all the information requested may be subject to rejection. The proposal must contain sufficient information to assure the State of its accuracy. No information beyond that specifically requested is required and Proposers are requested to keep their submissions to the shortest length consistent with making a complete presentation of qualifications. Proposals must be clearly labeled and submitted, by email to [email protected] (preferred), by U.S. Mail, by courier/delivery service (e.g., FedEx, UPS, etc.) or by hand as noted below, in a sealed package to: Office of the State Comptroller (C000961) Attention: Brian Matthews, Director of Financial Administration 110 State Street – Stop 13-2 Albany, NY 12236-0001 Due to security procedures at 110 State Street, proposals that will be hand-delivered must be taken to the Receiving Area on Howard Street during OSC’s normal receiving hours, which are Monday through Friday, from 8:00 a.m. to 4:00 p.m. ET. Proposals will not be accepted at any other location in 110 State Street other than the receiving area (i.e. proposals will not be accepted in the lobby, at the Security Desk, etc.). The phone number for the Receiving desk is (518) 474-3438. There is 15 minute parking available across from the Receiving entrance. Handdeliveries to 110 State Street outside of the stated hours and location will not be accepted. NOTE: Proposers should request a receipt containing the time and date received and the initials of the receiver for all hand-deliveries and ask that this information also be written on the package(s). Receipts may not be available between 11:45 a.m. and 2:00 p.m. All Documents are posted on the OSC website at http://osc.state.ny.us/procurement/index.htm. NOTE: Procurement documents may, from time to time, be amended or addenda issued. It is the Proposer’s responsibility to become aware of any such amendments and/or addenda prior to submission of a proposal. All amendments and/or addenda to procurements will be posted to the OSC website. Proposers should review the OSC website prior to submission of a response to ensure that they have all information required to submit a complete and responsive proposal. This procurement is subject to, and shall be conducted in accordance with, the OSC Executive Order on Procurement Integrity and OSC’s Procurement Integrity Procedures, both of which are available on the OSC website noted above, or upon email request. All inquiries concerning this procurement must be addressed to Mr. Brian Matthews as Contracting Officer, Director of Financial Administration, or his designee(s) at OSC, via email (preferred) to [email protected] or via hard copy mail to: Mr. Brian C. Matthews Director of Financial Administration Questions for C000896 Data Analyst/Reports Specialist Office of the State Comptroller

110 State Street, Stop 13-2 Albany, NY 12236-0001 Due date: 11/03/2014 4:00 PM Questions are due by October 16; responses will be posted October 23. Contract term: Contract term shall run from date of approval for a period of up to 12 months County(ies): Albany Location: 110 State Street, Albany, NY 12236