*Dear All,If you have anyone with you for the following position, please send the suitable resume along with Contact Details, Current Location and Pay Rate as soon as possible.Kindly share suitable resumes ASAP to mayan...@idctechnologies.com <mayan...@idctechnologies.com> Your earlier reply would be highly appreciated*
*Please provide two references.* * Data Analyst / Report Specialist* *Location: Albany, NY* *Duration: 12 months* *Job Description:* *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 *Thanks & Regards* * Mayank Tripathi* *Technical Recruiter* *IDC Technologies* *1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035 Phone: 408 868 5137, Fax: 408-608-6088* *Email: mayan...@idctechnologies.com <mayan...@idctechnologies.com> Website: **www.idctechnologies.com* <http://www.idctechnologies.com/> *GTalk/YM: mtripathi.recruiter MP Please consider the environment before printing this email. * *"Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list."* -- You received this message because you are subscribed to the Google Groups "SAP-UK" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-uk+unsubscr...@googlegroups.com. To post to this group, send email to sap-uk@googlegroups.com. Visit this group at http://groups.google.com/group/sap-uk. For more options, visit https://groups.google.com/d/optout.