Company DescriptionVTS3 is a Veteran-owned and operated company which provides full-service Recruiting, Talent Search, Staffing, and IT Professional Services. For more information visit www.vts3.com.Job DescriptionThis is an hourly position with opportunity for overtime. **All Candidates Must be Authorized to Legally Work in the US Without Sponsorship**We have a great opportunity for a Business Objects Developer Consultant with the New York City Department of Environmental Protection (DEP) in Queens, NY. The DEP, with the City's most diverse and unique fixed asset inventory, one of the largest capital budgets in the City and the responsibility for close coordination on financial reporting with the Water Finance Authority, has a substantial need for FMS data related to budget, financial and accounting matters. This function will enable DEP to provide detailed reports and other technical information from FMS to tits oversight agencies (i.e. OMB, the COmptroller's Office, the Water Board, the Water Finance Authority, the Law Department, etc.) in a timely manner. This position will be adequately empowered to access FMS for implementing on-demand reporting, data generation and other related services required by DEP. This function will augment FISA's existing resources to reduce the processing time required for reviewing, designing, implementing, and approving DEP requests for data related to fixed assets and capital primarily and, as needed, expense, revenue, procurement, accounts payable reports and other special mandate-driven and time sensitive requests. In addition, this function will provide technical assistance and support in enhancing the Department's understanding and access to other existing resources that may be useful (i.e. Crystal, RMDS, modules, etc.).Responsibilities:• Develop and maintain reporting structures including data structures, Business Objects Universes and related structures, SQL queries and reports to support the needs of the FMS project as well as on-going needs of business owners. • Work closely with vendor’s query and reporting team as well as FISA’s internal reporting organization to ensure a compliant and consistent reporting strategy and environment.• Provide guidance and leadership to business staff and other FISA staff members in the use of query and reporting tools. • Assist in the establishment and maintenance of query and reporting environments. • Responsible for participating in the design, development, testing, implementation and support of required reporting structures, queries and reports to support needs of the FMS project, FISA organization and other involved city agencies. • Maintain detailed documentation for query and reporting design and development for the FMS project. • Strong competence in the Business Analysis area is required, should be able to perform extensive business requirements analysis/ reviews, should be capable of capturing business requirements and write detailed Technical design documents from a reporting and business intelligence perspective.• Review reports and supporting SQL and other code, test scenarios, test scripts and proactively address any gaps and identify any potential pitfalls – A must have skill. • Work with the FISA FMS reporting staff to provide detailed insight into improvising processes and build efficiencies as applicable.• Excellent communication and interpersonal skills and ability to work well in a team environment. • Strong reporting development background, in a large data warehouse environment. • Extensive command in Business Objects Architecture.• Must have excellent business analysis skills, able to interact with senior business staff to derive and interpret business needs.• Proven proficiency and understanding of end to end Business Intelligence systems architecture from the perspective of data extraction and Reporting.• Hands-on proficiency with Oracle SQL, SQL Server, PL/SQL ( DB2 a plus).• Proven experience in balancing multiple tasks with critical timelines. High level flexibility is required to be able to quickly adapt to management directions, to address any ongoing or changing business needs.This is an hourly position with opportunity for overtime. **All Candidates Must be Authorized to Legally Work in the US Without Sponsorship**Qualifications• Minimum 7 years hands-on development experience working with Business Object XI (R3.1- R4.1 a Must – R4.2 a Plus)• Strong background in relational database technologies – Oracle, SQL Server, DB2 and writing SQL, PL/SQL.• Good understanding of SDLC having worked through at least one full iteration of a complete SDLC on a major large-scale project including reporting, ETL and data warehousing.• Quick learner with ability to understand and become an SME in the business data definitions and requirements in order to understand reporting requirements. • Candidate should be experienced in working with senior business managers.• Candidate should be a self-starter, willing to work on directives given thereof, with very little supervision. Candidate should be a mature individual and be willing to multi-task, wear multiple hats and be quick to adapt to management directives or as the project demands.• BO Java SDK Development experience a Plus• Strong understanding of ETL processes, tools and Data Warehousing Architecture & Design.• Experienced person that can assume responsibility and work with little direction. Additional Information$500 Referral Fee ProgramEarn extra cash while helping your friends!VTS3 will pay you up to $500.00 for each person you refer to us and we place into a contract or full-time position. If you know someone who's a good candidate for any of our openings, use the "Refer a friend" button on this page and earn extra cash.The rules are simple:The referral must be made by using the "Refer a friend" button on this pageThe person you refer must be placed within 90 days of being referredThe person you refer must complete 480 billable hoursCannot be someone we already have on our team or are currently working withVTS3 ONLY works directly with candidates.All candidates registered must be able to legally work in the United States.