I have a very urgent DIRECT CLIENT requirement for *Data Analyst/Report Specialist* in *Albany, NY*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number.
Please send the resumes at [email protected] Job Title: Data Analyst/Report Specialist Location: Albany, NY Duration: 12 Months 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: 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 Thanks Peter Smith Direct: 224-764-8535 Email ID: [email protected] -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
