The URL can be used to link to this page

Home My WebLink AboutRADgov Inc; 2014-06-18;AMENDMENT NO. ONE TO EXTEND THE AGREEMENT FOR IT STAFFING SERVICES RADGOV, INC. (~ -This Amendment No. One is entered into and effective as of the ) day of L0v extending the agreement dated June 18th, 2014 (the "Agreement") by and between t Ci of O Carlsbad, a municipal corporation, ("City"), and Radgov, Inc., ("Contractor") (collec ·ve , the "Parties") for information technology staffing services. RECITALS A. On June 18th, 2014, the Parties executed an IT Staffing Services Agreement in an amount not to exceed $90,000; and B. The Parties desire to extend the Agreement for a period of one (1) year. NOW, THEREFORE, in consideration of these recitals and the mutual covenants contained herein, City and Contractor agree as follows: 1. The Agreement, as may have been amended from time to time, is hereby extended for a period of one year ending on June 18th, 2016. 2. All other provisions of the Agreement, as may have been amended from time to time, shall remain in full force and effect. 3. All requisite insurance policies to be maintained by the Contractor pursuant to the Agreement, as may have been amended from time to time, shall include coverage for this Amendment. /II /II /II /II Ill City Attorney Approved Version 1/30/13 . . 4. The individuals executing this Amendment and the instruments referenced on behalf of Contractor each represent and warrant that they have the legal power, right and actual authority to bind Contractor to the terms and conditions hereof of this Amendment. CONTRACTOR By: (s(gf'lhere) Jyothi Myneni, President (print name/title) By: ~· (print name/title) CITY OF CARLSBAD, a municipal corporation of the State of California ATTEST: If required by City, proper notarial acknowledgment of execution by Contractor must be attached. If a corporation, Agreement must be signed by one corporate officer from each of the following two groups: Group A Chairman, President, or Vice-President Group B Secretary, Assistant Secretary, CFO or Assistant Treasurer Otherwise, the corporation must attach a resolution certified by the secretary or assistant secretary under corporate seal empowering the officer(s) signing to bind the corporation. APPROVED AS TO FORM: City Attorney Approved Version 1/30/13 2 AGREEMENT FOR IT STAFFING SERVICES RADGOV, INC. THIS AGREEMENT is made and entered into as of the ~~~ day of JVI'\v , 20 1'+, by and between the CITY OF CARLSBAD, a municipal corporation, ("City"), and RADgov, Inc. a Florida Corporation, ("Contractor"). RECITALS A. City requires the professional services of an IT staffing firm that is experienced in IT staffing services. B. The professional services are required on a non-exclusive, project-by-project basis. C. Contractor has the necessary experience in providing professional services and advice related to IT Staffing Services D. Contractor has submitted a proposal to City and has affirmed its willingness and ability to perform such work. NOW, THEREFORE, in consideration of these recitals and the mutual covenants contained herein, City and Contractor agree as follows: 1. SCOPE OF WORK City retains Contractor to perform, and Contractor agrees to render, those services (the "Services") that are defined in attached Exhibit "A", which is incorporated by this reference in accordance with this Agreement's terms and conditions. 2. STANDARD OF PERFORMANCE While performing the Services, Contractor will exercise the reasonable professional care and skill customarily exercised by reputable members of Contractor's profession practicing in the Metropolitan Southern California Area, and will use reasonable diligence and best judgment while exercising its professional skill and expertise. 3. TERM The term of this Agreement will be effective for a period of one (1) year from the date first above written. The City Manager may amend the Agreement to extend it for one (1) additional one (1) year periods or parts thereof in an amount not to exceed ninety thousand dollars ($90,000) per Agreement year. Extensions will be based upon a satisfactory review of Contractor's performance, City needs, and appropriation of funds by the City Council. The parties will prepare a written amendment indicating the effective date and length of the extended Agreement. 4. TIME IS OF THE ESSENCE Time is of the essence for each and every provision of this Agreement. 5. COMPENSATION The total fee payable for the Services to be performed during the initial Agreement term will not exceed ninety thousand dollars ($90,000). No other compensation for the Services will be allowed except for items covered by subsequent amendments to this Agreement. The City reserves the right to withhold a ten percent (1 0%) retention until City has accepted the work and/or Services specified in Exhibit "A". Incremental payments, if applicable, should be made as outlined in attached Exhibit "A". City Attorney Approved Version 1/30/13 6. STATUS OF CONTRACTOR/HIRING OF CONTRACTOR PERSONNEL Contractor will perform the Services in Contractor's own way as an independent contractor and in pursuit of Contractor's independent calling, and not as an employee of City. Contractor will be under control of City only as to the result to be accomplished, but will consult with City as necessary. The persons used by Contractor to provide services under this Agreement will not be considered employees of City for any purposes. The payment made to Contractor pursuant to the Agreement will be the full and complete compensation to which Contractor is entitled. City will not make any federal or state tax withholdings on behalf of Contractor or its agents, employees or subcontractors. City will not be required to pay any workers' compensation insurance or unemployment contributions on behalf of Contractor or its employees or subcontractors. Contractor agrees to indemnify City within thirty (30) days for any tax, retirement contribution, social security, overtime payment, unemployment payment or workers' compensation payment which City may be required to make on behalf of Contractor or any agent, employee, or subcontractor of Contractor for work done under this Agreement. At the City's election, City may deduct the indemnification amount from any balance owing to Contractor. If City chooses to hire Contractor personnel within the first year of Contractor personnel providing services under this Agreement, City agrees to pay a conversion fee of no more than 20% of the Contractor personnel's incoming annual salary. If City chooses to hire Contractor personnel after the completion of Contractor personnel's first year of providing services under this Agreement, there will be no conversion fee. 7. SUBCONTRACTING Contractor will not subcontract any portion of the Services without prior written approval of City. If Contractor subcontracts any of the Services, Contractor will be fully responsible to City for the acts and omissions of Contractor's subcontractor and of the persons either directly or indirectly employed by the subcontractor, as Contractor is for the acts and omissions of persons directly employed by Contractor. Nothing contained in this Agreement will create any contractual relationship between any subcontractor of Contractor and City. Contractor will be responsible for payment of subcontractors. Contractor will bind every subcontractor and every subcontractor of a subcontractor by the terms of this Agreement applicable to Contractor's work unless specifically noted to the contrary in the subcontract and approved in writing by City. 8. OTHER CONTRACTORS The City reserves the right to employ other Contractors in connection with the Services. 9. INDEMNIFICATION Contractor agrees to indemnify and hold harmless the City and its officers, officials, employees and volunteers from and against all claims, damages, losses and expenses including attorneys fees arising out of the performance of the work described herein caused by any negligence, recklessness, or willful misconduct of the Contractor, any subcontractor, anyone directly or indirectly employed by any of them or anyone for whose acts any of them may be liable. The parties expressly agree that any payment, attorney's fee, costs or expense City incurs or makes to or on behalf of an injured employee under the City's self-administered workers' compensation is included as a loss, expense or cost for the purposes of this section, and that this section will survive the expiration or early termination of this Agreement. City Attorney Approved Version 1/30/13 2 10. INSURANCE Contractor will obtain and maintain for the duration of the Agreement and any and all amendments, insurance against claims for injuries to persons or damage to property which may arise out of or in connection with performance of the services by Contractor or Contractor's agents, representatives, employees or subcontractors. The insurance will be obtained from an insurance carrier admitted and authorized to do business in the State of California. The insurance carrier is required to have a current Best's Key Rating of not less than "A-:VII". OR with a surplus line insurer on the State of California's List of Eligible Surplus Line Insurers {LESLI) with a rating in the latest Best's Key Rating Guide of at least "A:X". 10.1 Coverages and Limits. Contractor will maintain the types of coverages and minimum limits indicated below, unless Risk Manager or City Manager approves a lower amount. These minimum amounts of coverage will not constitute any limitations or cap on Contractor's indemnification obligations under this Agreement. City, its officers, agents and employees make no representation that the limits of the insurance specified to be carried by Contractor pursuant to this Agreement are adequate to protect Contractor. If Contractor believes that any required insurance coverage is inadequate, Contractor will obtain such additional insurance coverage, as Contractor deems adequate, at Contractor's sole expense. 1 0.1.1 Commercial General Liability Insurance. $1,000,000 combined single-limit per occurrence for bodily injury, personal injury and property damage. If the submitted policies contain aggregate limits, general aggregate limits will apply separately to the work under this Agreement or the general aggregate will be twice the required per occurrence limit. 1 0.1.2 Automobile Liability. {if the use of an automobile is involved for Contractor's work for City). $1,000,000 combined single-limit per accident for bodily injury and property damage. 1 0.1.3 Workers' Compensation and Employer's Liability. Workers' Compensation limits as required by the California Labor Code. Workers' Compensation will not be required if Contractor has no employees and provides, to City's satisfaction, a declaration stating this. 1 0.1.4 Professional Liabilitv. Errors and omissions liability appropriate to Contractor's profession with limits of not less than $1 ,000,000 per claim. Coverage must be maintained for a period of five years following the date of completion of the work. D If box is checked, Professional Liability City's Initials Contractor's Initials Insurance requirement is waived. 1 0.2. Additional Provisions. Contractor will ensure that the policies of insurance required under this Agreement contain, or are endorsed to contain, the following provisions: 1 0.2.1 The City will be named as an additional insured on Commercial General Liability which shall provide primary coverage to the City. 1 0.2.2 Contractor will obtain occurrence coverage, excluding Professional Liability, which will be written as claims-made coverage. 1 0.2.3 This insurance will be in force during the life of the Agreement and any extensions of it and will not be canceled without thirty {30) days prior written notice to City sent by certified mail pursuant to the Notice provisions of this Agreement. City Attorney Approved Version 1/30/13 3 10.3 Providing Certificates of Insurance and Endorsements. Prior to City's execution of this Agreement, Contractor will furnish certificates of insurance and endorsements to City. 10.4 Failure to Maintain Coverage. If Contractor fails to maintain any of these insurance coverages, then City will have the option to declare Contractor in breach, or may purchase replacement insurance or pay the premiums that are due on existing policies in order to maintain the required coverages. Contractor is responsible for any payments made by City to obtain or maintain insurance and City may collect these payments from Contractor or deduct the amount paid from any sums due Contractor under this Agreement. 10.5 Submission of Insurance Policies. City reserves the right to require, at anytime, complete and certified copies of any or all required insurance policies and endorsements. 11. BUSINESS LICENSE Contractor will obtain and maintain a City of Carlsbad Business License for the term of the Agreement, as may be amended from time-to-time. 12. ACCOUNTING RECORDS Contractor will maintain complete and accurate records with respect to costs incurred under this Agreement. All records will be clearly identifiable. Contractor will allow a representative of City during normal business hours to examine, audit, and make transcripts or copies of records and any other documents created pursuant to this Agreement. Contractor will allow inspection of all work, data, documents, proceedings, and activities related to the Agreement for a period of three (3) years from the date of final payment under this Agreement. 13. OWNERSHIP OF DOCUMENTS All work product produced by Contractor or its agents, employees, and subcontractors pursuant to this Agreement is the property of City. In the event this Agreement is terminated, all work product produced by Contractor or its agents, employees and subcontractors pursuant to this Agreement will be delivered at once to City. Contractor will have the right to make one (1) copy of the work product for Contractor's records. 14. COPYRIGHTS Contractor agrees that all copyrights that arise from the services will be vested in City and Contractor relinquishes all claims to the copyrights in favor of City. 15. NOTICES The name of the persons who are authorized to give written notices or to receive written notice on behalf of City and on behalf of Contractor under this Agreement. For City Name Tina Steffan Title Chief Technology Officer Department Information Technology City of Carlsbad Address 1635 Faraday Avenue Carlsbad, CA 92008 Phone No. 760-602-2454 4 For Contractor Name Ajay Kapoor Title Director Address 1 07 B-1 Corporate Blvd South Plainfield, N.J 07080 Phone No. (954) 938-2800 Email aj@radgov.com City Attorney Approved Version 1/30/13 Each party will notify the other immediately of any changes of address that would require any notice or delivery to be directed to another address. 16. CONFLICT OF INTEREST Contractor shall file a Conflict of Interest Statement with the City Clerk in accordance with the requirements of the City of Carlsbad Conflict of Interest Code. The Contractor shall report investments or interests in all four categories. 17. GENERAL COMPLIANCE WITH LAWS Contractor will keep fully informed of federal, state and local laws and ordinances and regulations which in any manner affect those employed by Contractor, or in any way affect the performance of the Services by Contractor. Contractor will at all times observe and comply with these laws, ordinances, and regulations and will be responsible for the compliance of Contractor's services with all applicable laws, ordinances and regulations. Contractor will be aware of the requirements of the Immigration Reform and Control Act of 1986 and will comply with those requirements, including, but not limited to, verifying the eligibility for employment of all agents, employees, subcontractors and consultants whose services are required by this Agreement. 18. DISCRIMINATION AND HARASSMENT PROHIBITED Contractor will comply with all applicable local, state and federal laws and regulations prohibiting discrimination and harassment. 19. DISPUTE RESOLUTION If a dispute should arise regarding the performance of the Services the following procedure will be used to resolve any questions of fact or interpretation not otherwise settled by agreement between the parties. Representatives of Contractor or City will reduce such questions, and their respective views, to writing. A copy of such documented dispute will be forwarded to both parties involved along with recommended methods of resolution, which would be of benefit to both parties. The representative receiving the letter will reply to the letter along with a recommended method of resolution within ten ( 1 0) business days. If the resolution thus obtained is unsatisfactory to the aggrieved party, a letter outlining the disputes will be forwarded to the City Manager. The City Manager will consider the facts and solutions recommended by each party and may then opt to direct a solution to the problem. In such cases, the action of the City Manager will be binding upon the parties involved, although nothing in this procedure will prohibit the parties from seeking remedies available to them at law. 20. TERMINATION In the event of the Contractor's failure to prosecute, deliver, or perform the Services, City may terminate this Agreement for nonperformance by notifying Contractor by certified mail of the termination. If City decides to abandon or indefinitely postpone the work or services contemplated by this Agreement, City may terminate this Agreement upon written notice to Contractor. Upon notification of termination, Contractor has five (5) business days to deliver any documents owned by City and all work in progress to City address contained in this Agreement. City will make a determination of fact based upon the work product delivered to City and of the percentage of work that Contractor has performed which is usable and of worth to City in having the Agreement completed. Based upon that finding City will determine the final payment of the Agreement. City Attorney Approved Version 1/30/13 5 Either party upon tendering thirty (30) days written notice to the other party may terminate this Agreement. In this event and upon request of City, Contractor will assemble the work product and put it in order for proper filing and closing and deliver it to City. Contractor will be paid for work performed to the termination date; however, the total will not exceed the lump sum fee payable under this Agreement. City will make the final determination as to the portions of tasks completed and the compensation to be made. 21. COVENANTS AGAINST CONTINGENT FEES Contractor warrants that Contractor has not employed or retained any company or person, other than a bona fide employee working for Contractor, to solicit or secure this Agreement, and that Contractor has not paid or agreed to pay any company or person, other than a bona fide employee, any fee, commission, percentage, brokerage fee, gift, or any other consideration contingent upon, or resulting from, the award or making of this Agreement. For breach or violation of this warranty, City will have the right to annul this Agreement without liability, or, in its discretion, to deduct from the Agreement price or consideration, or otherwise recover, the full amount of the fee, commission, percentage, brokerage fees, gift, or contingent fee. 22. CLAIMS AND LAWSUITS By signing this Agreement, Contractor agrees that any Agreement claim submitted to City must be asserted as part of the Agreement process as set forth in this Agreement and not in anticipation of litigation or in conjunction with litigation. Contractor acknowledges that if a false claim is submitted to City, it may be considered fraud and Contractor may be subject to criminal prosecution. Contractor acknowledges that California Government Code sections 12650 et seq., the False Claims Act applies to this Agreement and, provides for civil penalties where a person knowingly submits a false claim to a public entity. These provisions include false claims made with deliberate ignorance of the false information or in reckless disregard of the truth or falsity of information. If City seeks to recover penalties pursuant to the False Claims Act, it is entitled to recover its litigation costs, including attorney's fees. Contractor acknowledges that the filing of a false claim may subject Contractor to an administrative debarment proceeding as the result of which Contractor may be prevented to act as a Contractor on any public work or improvement for a period of up to five (5) years. Contractor acknowledges debarment by another jurisdiction is grounds for City to terminate this Agreement. 23. JURISDICTIONS AND VENUE Any action at law or in equity brought by either of the parties for the purpose of enforcing a right or rights provided for by this Agreement will be tried in a court of competent jurisdiction in the County of San Diego, State of California, and the parties waive all provisions of law providing for a change of venue in these proceedings to any other county. 24. SUCCESSORS AND ASSIGNS It is mutually understood and agreed that this Agreement will be binding upon City and Contractor and their respective successors. Neither this Agreement or any part of it nor any monies due or to become due under it may be assigned by Contractor without the prior consent of City, which shall not be unreasonably withheld. 25. ENTIRE AGREEMENT This Agreement, together with any other written document referred to or contemplated by it, along with the purchase order for this Agreement and its provisions, embody the entire Agreement and understanding between the parties relating to the subject matter of it. In case of conflict, the terms of the Agreement supersede the purchase order. Neither this Agreement nor any of its provisions may be amended, modified, waived or discharged except in a writing signed by both parties. City Attorney Approved Version 1/30/13 6 26. AUTHORITY The individuals executing this Agreement and the instruments referenced in it on behalf of Contractor each represent and warrant that they have the legal power, right and actual authority to bind Contractor to the terms and conditions of this Agreement. CONTRACTOR By: ~ere) Jyothi Myneni -President (print name/title) By: (print name/title) CITY OF CARLSBAD, a municipal corporation of the State of California City Manager Kathryn B. Dodson ATTEST: City Clerk If required by City, proper notarial acknowledgment of execution by contractor must be attached. If a corporation, Agreement must be signed by one corporate officer from each of the following two groups. Group A Chairman, President, or Vice-President Group B Secretary, Assistant Secretary, CFO or Assistant Treasurer Otherwise, the corporation must attach a resolution certified by the secretary or assistant secretary under corporate seal empowering the officer(s) signing to bind the corporation. APPROVED AS TO FORM: City Attorney Approved Version 1/30/13 7 EXHIBIT "A" SCOPE OF SERVICES 1. Contractor shall provide a qualified and experienced person who is capable of fulfilling the following Information Technology skills 2. Contractor will provide both remote and on-site business information technology consulting services. Duties to be performed, by position, will include: IT Project Manager The primary purpose of this position is to drive technology projects from initiation through delivery, organizing cross-functional activities, ensuring project completes on schedule and within budget. The position serves as an in-house project manager and evaluating needs, vendors and Request for Proposals for tool/application builds for City of Carlsbad's internal use, to planning and directing implementation efforts. The Project Manager manages other resources indirectly as part of cross-functional team delegation and project assignments. The Project Manager is an individual contributor reporting to the Project Portfolio Manager. The Project Manager collaborates with the application team, network engineering and business intelligence services. The project manager leads, manages and drives forward technology and infrastructure projects. Duties and Responsibilities • Identify project objectives, define scope and requirements, create project schedules and plans, manage resources, measure progress and make course corrections to ensure projects are completed on time. • Contribute to establishing methods and metrics for tracking performance and making decisions within project management teams. • Collaborate with staff and management across the organization and with outside third parties to clearly identify, explain and communicate their project involvement, project goals, expectations and tasks. • Work with cross-functional groups across divisions as part of a team. • Build a project plan to meet business requirements and expectations. • Prepare and manage project budgets, and coordinates with financial staff. • Lead project teams through initiation, planning, execution, controlling and close phases. • Facilitate communication and negotiation of commitments within the team and with functional management, and sustain coordination among all affected stakeholders. • Comply with and enforce policies, processes and agreements, and employ standard methods and tools. • Make decisions about critical tradeoffs among project dimensions of costs, resources, schedule, and requirements. • Develop and maintain project documentation including requirements definition, architecture diagrams and test plans. • Communicate project status to project sponsors and stakeholders. • Manage multiple projects simultaneously. City Attorney Approved Version 1/30/13 8 Knowledge and Abilities Knowledge of: • System development lifecycle • Project management methodologies • Principles of management pertaining specifically to human capital • Managing project and organizational dependencies related to project delivery • Time management, financial management and overall resource management • Industry standards or models to guide improvement activities • Best practices for defining and deploying processes and measurements and other improvement activities • Portfolio and project management best practices, process improvement methods and tools • Organizational change management • Business Process Management, administration and operations Ability to: • Manage and resolve conflict and other barriers to project success negotiation and people management skills • Negotiate contracts, pricing and service delivery • Work closely and build relationships with people in many roles, including information technology staff, end users, business units, technologists • Enforce standards/process as required and to apply flexibility as appropriate • Make presentations and to communicate orally and in writing with technical and non- technical staff at all levels of the organization • Lead diverse teams • Manage information technology projects including hardware, software and networking interactions • Provide guidance and mentoring to project team personnel Education • Bachelor's degree or equivalent combination of education and experience is required. • PMP certification is a plus. Senior Network Engineer The Senior Network Engineer will be an analytical, proactive individual with strong interpersonal communication, project management skills and expertise in the design, installation, configuration and maintenance of large network and server infrastructure, virtualization and LAN/WAN technologies. The candidate must be able to work on complex problems where analysis of a situation requires in-depth evaluation of various factors. The primary role of this Senior Network Engineer is to support technical operations and access to the enterprise system and networks and may also manage project operations, network and voice implementations. This position will also work closely with colleagues in other City departments on exciting enterprise-wide projects. City Attorney Approved Version 1/30/13 9 Knowledge and Abilities • Plan and integrate technology to meet milestones and timelines and management of highly visible and complex projects. • Manage new services, business solutions, service delivery and or migration to new systems. • Enforce Information Technology standards across the organization while managing multiple enterprise projects of a complex nature with significant impact to the organization. • Review Information Technology Department policies and deliver recommendations based on current and future needs, Industry best practices and national cyber security alerts. • Supervise and/or resolve escalated types of complex network, system limitation and access problems for all enterprise systems. • Manage secure local and remote access to enterprise computing systems and information. • Monitor and manage network(s), LAN, WAN, devices, device logs, utilization and availability. • Monitor and manage firewall availability and utilization. • Design and implement scalable solutions with security, manageability and reliability as the cornerstone to every project. • Analyze information collected from monitoring system and network security risks in current posture, as well as network stability and usage and develops appropriate action plans as required. • Ensure the health and reliability of City's computer networks, system access, operation and security. • Resolve customer issues that are escalated for all enterprise systems and support all other Information Technology staff, projects, issues and systems as challenges arise. Education and Qualifications • Bachelor's Degree in Management Information Systems, Computer Science, Information Technology or a related discipline. • 7+ years of professional experience or equivalent. Three years of supervisory experience or demonstrated ability to lead complex projects with important impacts Database Administrator The Database Administrator is responsible to design, develop and maintain the City's databases hosted on database servers that serve applications across the enterprise. Essential Duties and Responsibilities • Participate in the Information Technology Department's strategic planning processes. • Design, develop and maintain City databases hosted on various database servers that serve applications across all departments. • Troubleshoot database performance problems and provides solutions based on analysis and research using knowledge of operating systems, relational databases and database technologies. • Design, develop and maintain a data warehouse that serves as a central repository of data from disparate data sources across the City. • Design and develop reporting and data analysis solutions based on the data warehouse using industry standards and methodologies. City Attorney Approved Version 1/30/13 10 • Provide technical input to management regarding proposed applications that would utilize the database • Perform, maintain and ensure database backups, restores, security, and data corruption/correction. • Monitor performance and database connectivity issues. • Stay abreast of current and emerging technologies related to areas of expertise. • Apply latest service packs and patches. • Monitor space issues and perform housekeeping of database. • Determine database specific configurations and architecture. • Create, analyze and troubleshoot complex queries. • Lead and participate in project management including scheduling and prioritizing resources. Knowledge and Abilities • Knowledge of database administration using MS SQL Server • Strong database development skills using MS SQL Server • Knowledge of database warehousing and business intelligence • Knowledge of trends and developments in database technologies, operating systems and application development • Knowledge of project management practices • Knowledge of programming or shell scripting • Knowledge of production support experience utilizing effective communication, troubleshooting skills • Knowledge of business intelligence services for analytics, reporting and data transformation • Ability to develop applications using .NET • Ability to establish relational data modeling • Ability to manage multiple projects simultaneously • Ability to write reports • Ability to work well in teams Experience and Education Education: Bachelor's degree in Information Technology, Management Information Systems, Computer Science or related field from an accredited college or university. Experience: Minimum of five to seven years with database administration and three years in database warehousing; minimum of three years' experience with SQL. Business Intelligence Analyst The Business Intelligence Analyst position provides data warehouse architectural design, development and support in multi-platform environments, works on multiple projects as a team member and may lead projects of moderate complexity. Duties and Responsibilities • Lead business analysis tasks and coordinate with IT (project manager, business analysts) and stakeholders for the full business cycle of related projects. • Gather and assess business information needs and prepares system requirements. City Attorney Approved Version 1/30/13 11 • Perform analysis, develop and evaluate the process of data mining in a data warehouse environment to include data design, database architecture, metadata and repository creation. • Use data mining and data analysis tools. • Review and validate data loaded into the data warehouse for accuracy. • Interact with user community to produce reporting requirements. • Provide technical consulting to users of the various data warehouses and advise users on conflicts and inappropriate data usage. • Provide prototyping solutions, prepares test scripts, and conducts tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses. • Maintain knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments. • Possess working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools. • Must have an extensive knowledge of data warehouse and data mart concepts. • Sets and conducts requirements sessions,. • Manages requirements specifications. • Drives solution options analysis along with technical team. • Reviews test cases, develops user acceptance testing test scripts. • Provides status updates to project manager. Knowledge and Abilities • Data integration and tools • Complex data analysis • Database warehousing and business intelligence • Application development using .NET • Trends and developments in business intelligence practices and related technologies, operating systems and application development • Project management practices and the ability to manage multiple projects simultaneously • Programming or shell scripting • Production support experience utilizing effective communication, troubleshooting skills • Business intelligence services for analytics, reporting and data transformation Education and Experience Education: Bachelor's Degree in Computer Science, Information Systems, or other related field or equivalent work experience. Experience: Have 5 to 7 years of business analyst work experience, business intelligence tools and systems. Business Intelligence Architect The Business Intelligence (BI) Architect will be responsible for providing Business Intelligence data modeling and data integration solutions related to complex Bl projects. The Bl Architect will partner and collaborate with business owners to translate requirements into complete data warehouse and business intelligence solutions. In addition, the Bl Architect will develop logical/physical data models, data integrations, data transformations, data loads, and assists with long-term data warehouse strategy development. City Attorney Approved Version 1/30/13 12 Potential Duties and Responsibilities • Design and develop overall data architecture, data model, database design, data integration, transformations, and load processes. • Perform data analysis to design and develop appropriate design models for warehouse and analytics. • Collaborate with team to establish data architecture design. • Develop logical and physical data models to support design and development of data warehouse and data marts. • Develop and implement OLAP cubes. • Work in partnership with database administrators to implement physical data model in to high performing databases. • Translate client user requirements into data flows and data mappings. • Architect, develop and implement data integration process (ETL) using Informatica or other data integration tools to load data warehouse and data marts. • Troubleshoot and provide technical assistance in the use and understanding of existing data warehouse applications. • Miscellaneous activities and responsibilities as assigned by the Information Technology Manager. Knowledge and Abilities • Ability to perform data analysis and data profiling to help in data architecture. • Experience in developing dimensional models with conformed dimensions. • Experience with OLAP development. • Working knowledge of Oracle DBMS & MS SQL Server DBMS. • Knowledge of Agile data warehouse delivery methodologies. • Skilled in developing requirements and technical specifications documentation. • Ability to design, develop, and deploy new solutions while supporting and enhancing existing enterprise solutions. • Preferred tools experience to include Informatica PowerCenter 8.x/9.x, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE). • Knowledge of Cog nos 8.4 /Cog nos 1 0 is a plus. • Excellent oral and written communication skills are expected of the successful candidate. Education: Bachelor's degree in Information Systems/Technology, Computer Science, or Computer Engineering Experience: 5 or more years of Data Warehouse/Architecture or Business Intelligence experience required. 5 plus years of logical and physical data model development. 4 plus years of ETL development. Client Services Analyst The Client Services Analyst works independently with occasional instruction or assistance as new or unusual problems arise, and is expected to be fully aware of standard operating procedures to resolve end user problems. The Client Services Analyst is responsible to research unique solutions to client computer problems and performs custom installation packaging to deploy software applications and system configurations. City Attorney Approved Version 1/30/13 13 Essential Duties and Responsibilities • Provide support to end users to resolve problems and maintain proper utility for personal computer, laptop and mobile device operations. • Provide proper working operations and quality support for peripheral devices including local network printers, plotters, faxes, scanners, all in ones, etc. • Ensure client software operate effectively. • Install and test personal computers, printers, and other peripheral devices. • Perform basic contract management on desktop hardware and maintenance contracts. • Provide user training on new products, applications and devices. • Set up mobile devices for customer use and provides technical support for related issues. • Configure operating systems, shrink-wrap programs, and applications software programs. • Perform password resets; may use tools to assign passwords, create user accounts, and assign access rights. • Support policies for laptops and peripheral device utilization and enforces desktop standards. • Utilize imaging tools to deploy client devices. • Ensure operating structures for small network functions related to client device operations. • Manage projectors and other multi-media devices located in staff meeting rooms. • Perform station network cabling. • Perform system support for small and niche applications. • Troubleshoot small network based switches, routers and wireless access points as directed. • Assist with system security to avoid violating firewalls and other system security i.e. Internet access. • Make decisions regarding replacement of equipment; use of specialty software; changes to desktop support procedures; planning the deployment of new personal computer assets; laptop and desktop standards. • Assume responsibility for vendor communications when vendor is unable to resolve problems. • Document and track support activity and records of equipment and software as necessary. • Consult with; acts as liaison and coordinate meetings with vendors and IT staff as needed. • Provide guidance to those with less experience. • Create complex application packaging for automated deployment. • Ensure hardware and software assets are tracked throughout their useful life. • Assist in management of organization wide Active Directory. • Collaborate with the Network Group to establish and maintain user group policies consistent with operating standards. • Manage processes for appropriate citywide application upgrades. • Manage wireless device configuration. Knowledge and Abilities • Knowledge of Microsoft Windows Operating Systems • Knowledge of PC hardware • Installation and maintenance of personal computer hardware • Basic Information Technology terminology such as IP addresses City Attorney Approved Version 1/30/13 14 • Knowledge of network connectivity and VPN support are preferred • Knowledge of technology life cycles • Knowledge of modern practices for application deployment • Knowledge of computer network operations of limited to moderate scope • Ability to provide customer service in person, via remote control technologies and over the telephone • Ability to troubleshoot personal computer hardware and software and provide repair • Ability to troubleshoot local/network printers • Ability to troubleshoot end user network access • Ability to perform basic purchasing • Ability to work independently with occasional supervision • Knowledge of basic supervisory practices • Knowledge of basic forecasting and budget processes • Knowledge of computer network operations of moderate to advanced scope • Knowledge of Windows Server Operating Systems, and the TCP/IP protocol • Knowledge of network management protocols and related tools • Knowledge of network-based application software such as Email and other collaboration applications • Ability to perform unique application deployment • Ability to analyze and diagnose problems effectively • Ability to establish best practices for purchasing of personal computers, printers and other devices and equipment • Ability to assist in the planning and designing of personal computer support systems Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, and securing a City-wide help desk operation (mid-size network). Experience in PC/LAN technologies and computer system applications and 3 year serving in the capacity as a technical lead or supervisor are preferred. Advanced Technical Services Positions Cisco Network Engineer Duties: The Cisco Network Engineer will assist IT staff and project teams with technical support, configuration and implementation of the City's networking infrastructure. Activities include but are not limited to supporting and upgrading the City's BGP implementation, GLBP implementation, GRE Tunnels, and other networking services as needed. Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, and securing an enterprise class routing and switching environment, 10 GB fiber, firewalls and wireless networks . ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• City Attorney Approved Version 1/30/13 15 Systems Engineer Duties: The Systems Engineer will assist IT staff and project teams with technical support in working with our various HP servers and HP blade chassis systems, blade servers in managing hardware, firmware, and configuration. Activities include, but are not limited to patching and upgrading the chassis, blade, all mezzanine cards, blade servers, configuration and supporting of 1 OGigE, Fiber Channel, NAS and SAN storage. Assist with the assessment and upgrade of replace components as needed for reliability, capability, and performance Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, upgrading and securing all hardware, firmware and systems software of the enterprise computing environment. VMware Engineer Duties: The VMware Engineer will assist IT staff and project teams with technical support in tuning, configuring, development and scaling of the City's virtualized environment. Activities include but are not limited to ESXi server and networking upgrades, Vcenter configuration and upgrade, integration of tools as well as configuring and tuning the appropriate policies and HA levels and distributed switches for the VMware clusters and Server failover priorities. Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, upgrading and securing an enterprise class server virtualized environment. Citrix Engineer Duties: The Citrix Engineer will assist IT staff and project teams with ongoing technical support of the City's upcoming Citrix VOl implementation. Citrix server farms will include desktop servers, application servers, and SQL server. Activities include but are not limited to supporting Citrix on Vmware, thin application build and delivery, user profile and v-disk issues, secure remote access (F5) and multi-factor integration components. Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, upgrading and securing an enterprise class server virtualized desktop environment. Storage Engineer Duties: The Storage Engineer will assist IT staff and project teams with technical support for the City's storage platforms which include Compellent, NetApp and IBM StorWize. Activities include but are not limited to configuring and tuning of NetApp, Compellent and IBM StorWize storage systems, fiber channel controllers, DRIBC configuration and tuning for NAS-NAS and SAN-SAN replication and tuning of storage and related systems to work with physical and virtualization technologies, including VMware and Citrix. Education and Experience Bachelors in Management Information Systems, Computer Science or Information Technology is preferred. 7 years experience administering, deploying, maintaining, upgrading and securing an enterprise class storage environment. ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• City Attorney Approved Version 1/30/13 16 3. Fees will be billed as follows: The set hourly fees for positions for this engagement are listed below. The agreed upon fee shall be the maximum fee paid per hour for the services performed. Project Manager: Network Engineer: Database Administrator: Business Intelligence Architect: Business Intelligence Analyst: Cisco Network Engineer: Client Services Analyst: HP System Engineer: VmWare Engineer: Citrix Engineer: Storage Engineer: $81.12/hour. $70.26/hour $33.06/hour-$80.22/hour $57 .65/hour -$85.58/hour $37 .36/hour -$88.60/hour $76.16/hour $32.27/hour $72.14/hour $76.32/hour $76.32/hour $76.32/hour 4. For work billed on an hourly basis, City shall designate a manager or other employee to review for approval each week the time records of Contractor personnel on a form provided by Contractor and submitted to the designate City approver. City's approval of such time records shall be evidenced by an authorized signature thereon and such approval shall constitute acceptance of the work performed by Contractor's technical personnel and City's agreement to pay Contractor as stated herein. Acceptance by City shall not be unreasonably withheld and any refusal to accept shall be noted on the time record for the relevant week, with a written explanation of the reasons that the work was not acceptable. Nothing herein shall eliminate City's obligation to pay Contractor for any services provided by technical personnel, which City has approved. 5. Contractor shall present weekly Invoices for all work performed during the preceding week. Payment shall be made within thirty (30) days upon receiving the invoices, providing that all work performed by the Contractor has been accepted by the City. 6. Contractor will bill for all expenses at cost and without any mark-ups; reimbursable expenses include charges incurred for out-of-pocket items such as travel, parking, and photocopying. Contractor will not incur any expense exceeding $100 without first obtaining City approval in writing. 7. If one or more of the technical personnel provided by the Contractor does not meet the City's satisfaction, the City will notify the Contractor in writing, requesting a replacement. 8. The City reserves the right to review and pre-select candidates provided by the Contractor prior to the candidate being formally engaged by the City. City Attorney Approved Version 1/30/13 17 RADGOV, INC. June 3, 2014 City of Carlsbad, CA 1635 Faraday Ave Carlsbad, CA 92008 Attention: Terie Rowley Information Technology Phone: (954) 938-2800 Fax: (954) 938-2004 6750 N. Andrews Ave, Suite 200 Fort Lauderdale, FL. 33309 Subject: Agreement for IT Staffing Services with the City of Carlsbad, CA Dear Terie: Please be advised that both Jyothi Myneni and Deepa Koduru are authorized and empowered to bind the corporation of RADgov, Inc. to the Agreement for IT Staffing Services with the City of Carlsbad, CA. ,,,,IIIII tti,,. ,,,, 0Gav 1 ''·· ,,'a_~ .... , ........ !. /Jo ~ '~'o~POft.1~'·• •. ... • v ~ •• ~ / SEAL \ ~ i 2005 J . -~ : "';::.. -:. . .., .... .. ~. ·-.,~LOR 1'0 f.'-.... .. ,..~~~ ............ . ,,, * ,. " / I 7 ! ~ ; ~ ~ \ \ \ ·. ·,