IT-70 - Senryo Inc. - GS35F0195Y

U.S General Services Administration

Federal Supply Service

Authorized Federal Supply Schedule Price List

On-line access to contract ordering information, terms and conditions, up-to-date pricing, and the option to create an electronic delivery order are available through GSA Advantage! ®, a menu-driven database system. The INTERNET address GSA Advantage! ® is: GSAAdvantage.gov.

GENERAL PURPOSE COMMERCIAL INFORMATION TECHNOLOGY,

SOFTWARE AND SERVICES

Specific Scope of Contract

Special Item No. 13251 Information Technology Professional Services

Senryo, Inc.

387 Shuman Blvd, Suite 208E Naperville, IL 60563 Contracts Department (630) 355-7429 www.senryo.com

Contract Number: GS35F0195Y Contract period: 02/08/2017 – 02/07/2022 GSA Contract Administrator:

Dinkar Karumuri dinkar.karumuri@senryo.com 630-355-7429 Pricelist current through modification 0007, dated 09/01/2016

Table of Contents

3I.

Customer Information

7II. Labor Category Descriptions

21III. Terms and Conditions Applicable to Information Technology (IT) Professional Services (Special Item Number 132-51)

29IV. GSA Pricing

30V.

Senryo Background

I. Customer Information 1a.

Table of awarded special item number(s) with appropriate cross-reference to item descriptions and awarded price(s).

SIN 132-51 - INFORMATION TECHNOLOGY (IT) PROFESSIONAL SERVICES

FPDS Code D302 IT Systems Development Services

FPDS Code D306 IT Systems Analysis Services

FPDS Code D307 Automated Information Systems Design and Integration Services

FPDS Code D308 Programming Services

FPDS Code D310 IT Backup & Security Services FPDS Code D311 IT Data Conversion Services FPDS Code D316 IT Network Management Services 1b.

Identification of the lowest priced model number and lowest unit price for that model for each special item number awarded in the contract. This price is the Government price based on a unit of one, exclusive of any quantity/dollar volume, prompt payment, or any other concession affecting price. Those contracts that have unit prices based on the geographic location of the customer, should show the range of the lowest price, and cite the areas to which the prices apply.

Prices shown in the pricelist (Section IV) are net.

1c.

If the Contractor is proposing hourly rates, a description of all corresponding commercial job titles, experience, functional responsibility and education for those types of employees or subcontractors who will perform services shall be provided. If hourly rates are not applicable, indicate “Not applicable” for this item.

Please see Section II.

2.

Maximum order. $500,000

3.

Minimum order. $100 4.

Geographic coverage (delivery area). Geographic coverage is within 48 contiguous states, Alaska, Hawaii, Puerto Rico, Washington, DC, and U.S. Territories.

5.

Point(s) of production (city, county, and State or foreign country). Naperville, Illinois 6.

Discount from list prices or statement of net price. Prices shown are NET prices 7.

Discounts.

a) Quantity: None

b) Dollar Volume: None 8.

Prompt payment terms. None

9a.

Notification that Government purchase cards are accepted at or below the micro-purchase threshold. Government Credit Cards are not accepted for orders at or below the micro-purchase threshold.

9b.

Notification whether Government purchase cards are accepted or not accepted above the micro-purchase threshold. Government Credit Cards are not accepted for orders above the micro-purchase threshold.

10.

Foreign items. None

11a.

Time of delivery. The Contractor shall deliver to destination within the number of calendar days after receipt of order (ARO), as set forth below:

11b.

Expedited Delivery. Items available for expedited delivery are noted in this price list.

11c.

Overnight and 2-day delivery. Not applicable.

11d.

Urgent Requirements. When the Federal Supply Schedule contract delivery period does not meet the bona fide urgent delivery requirements of an ordering activity, ordering activities are encouraged, if time permits, to contact the Contractor for the purpose of obtaining accelerated delivery. The Contractor shall reply to the inquiry within 3 workdays after receipt. (Telephonic replies shall be confirmed by the Contractor in writing.) If the Contractor offers an accelerated delivery time acceptable to the ordering activity, any order(s) placed pursuant to the agreed upon accelerated delivery time frame shall be delivered within this shorter delivery time and in accordance with all other terms and conditions of the contract.

12.

F.O.B. point. Destination.

13a. Ordering address.

Senryo, Inc.

387 Shuman Blvd., Ste. 208E Naperville, IL 60563 630-355-7429 dinkar.karumuri@senryo.com 13b.

Ordering procedures: For supplies and services, the ordering procedures, information on Blanket Purchase Agreements (BPA’s) are found in Federal Acquisition Regulation (FAR) 8.405-3.

14. Payment address.

Senryo, Inc.

Attn: Accounts Payables 387 Shuman Blvd., Ste. 208E Naperville, IL 60563

630-355-7429 15.

Warranty provision.

a.

Unless specified otherwise in this contract, Contractor’s standard commercial guarantee/warranty as stated in the contract’s commercial pricelist will apply to this contract.

b.

Limitation of Liability. Except as otherwise provided by an express or implied warranty, Contractor will not be liable to the ordering activity for consequential damages resulting from any defect or deficiencies in accepted items.

16.

Export packing charges, if applicable. Not applicable.

17.

Terms and conditions of Government purchase card acceptance (any thresholds above the micro-purchase level). Not applicable.

18.

Terms and conditions of rental, maintenance, and repair. Not applicable.

19.

Terms and conditions of installation (if applicable). Not applicable.

20.

Terms and conditions of repair parts indicating date of parts price lists and any discounts from list prices (if applicable). Not applicable.

20a.

Terms and conditions for any other services (if applicable). Not applicable.

21.

List of service and distribution points (if applicable). Not applicable.

22.

List of participating dealers (if applicable). Not applicable.

23.

Preventive maintenance (if applicable). Not applicable.

24a.

Special attributes such as environmental attributes (e.g., recycled content, energy efficiency, and/or reduced pollutants). Not applicable.

24b.

If applicable, indicate that Section 508 compliance information is available on Electronic and Information Technology (EIT) supplies and services and show where full details can be found (e.g. contractor’s website or other location.) The EIT standards can be found at: www.Section508.gov/. Senryo, Inc. certifies that it is in accordance with 508 of the Rehabilitation Act of 1973, as amended (29 U.S.C. 794d), FAR 39.2, and the Architectural and Transportation Barriers Compliance Board Electronic and Information Technology (EIT) Accessibility Standards (36 CFR 1194) General Services Administration (GSA), that all IT hardware/software/services are 508 compliant.

25.

Data Universal Number System (DUNS) number. 124747390 26.

Notification regarding registration in Central Contractor Registration (CCR) database. Senryo, Inc. is registered with the System for Award Management (SAM).

II. Labor Category Descriptions

GSA APPROVED LABOR CATEGORY DESCRIPTIONS

Commercial Job Title: Program Manager Minimum/General Experience

· Minimum 5-10 years of program management or IT Management.

· Minimum 3 years experience coordinating and/supporting IT business processes.

· Experience in scheduling and budgeting

Duties/Responsibilities

· Defines requirements and plan project lifecycle deployment.

· Defines resources and schedule for project/program implementation.

· Create strategies for risk mitigation and contingency planning.

· Plans and schedule project deliverables, goals and milestones.

· Directs and oversees project engineering team and manages conflicts within group.

· Performs team assessments and evaluations.

· Efficiently identifies and solves project issues.

· Demonstrates leadership to define requirements for project risk.

· Develop Requests for Proposals (RFP) for external services.

· Designs and maintain technical and project documentation.

· Strong organizational, presentation, and customer service skills.

Minimum Education

Bachelors Degree, Technology or related field preferred.

Commercial Job Title:

Project Manager Minimum/General Experience

Experience with managing an enterprise-wide implementation. Responsibilities include managing to a project plan and budget as well working with and handling customers need & addressing issues. Must have extensive experience with providing project reporting to both customer and internal Resource. Interact with customer senior executive team.

Duties/Responsibilities:

Executing successful enterprise-level project management

Introducing and implementing Project Management processes and standards

Implement Formal Project/Program Management methodology (PMI, PRINCE II, proprietary, etc.)

Understand proficient use of industry standard project management tools - Microsoft

Project, Project Server, Primavera, all Microsoft Office applications etc.

Work within both a project-centric and project matrix environments

Minimum Education

Bachelor’s Degree, Technology or related field; PMP Certification required

Commercial Job Title:

Project Coordinator Minimum/General Experience

Have clerical and/or administrative experience. Have intermediate level knowledge with Microsoft Office. Good written and verbal communication skills. Excellent proof reading skills. Must have ability to participate and work in a team environment.

Duties/Responsibilities:

· Assist with the administrative aspects of implementations (creating documentation, PowerPoint presentations, maintaining project plans).

· Assist with updating documentation.

· Extensive experience in Excel, PowerPoint and Word.

· Must have basic project management experience.

· Provide assistance to Project Managers.

· Have online, phone, email, Webex communication with clients.

· Tracking time line and resource details for multiple projects

· Directing web developers and graphic designers to project specs

Minimum Education:

High school degree

Commercial Job Title:

Senior Business Analyst Minimum/General Experience

· 8-10 years Business Analysis experience with some project management

· Analyze a project that is underway and assist with the developing requirements.

· Assist with the project plan for the IT/business side of the project. This will be a cross functional role with five business groups.

Duties/Responsibilities

· ERP and integration experience (from business perspective)

· Must have done large-scale projects.

· Multi-vendor, multi-function project management

· Excellent Communications skills and ability to work with minimal direction

· A plus would be if they have backend experience dealing with data transfer coming in from the ERP

Minimum Education:

Bachelor’s Degree, Technology or related field preferred Commercial Job Title:

Business Analyst Minimum/General Experience:

Have extensive Business Analysis experience with excellent leadership, initiative, resilience, problem solving, & results orientation. Comfort and experience liaising with senior managers with the ability to quickly create partnerships across subject matter experts. Strong written and verbal communication skills

Duties/Responsibilities

· Must be proficient in Microsoft Project, Office suite: Excel, PowerPoint, Word, Project, and Access (a plus)

· 5+ years of Project Manager/Business Analyst experience, UML / Requirements

· Elicitation

· 5 + years of Business Objects experience. Influence and negotiation skills

· Ability to adapt to a fast paced environment

· Waterfall and Agile Methodologies preferred

· Strong organizational and time management skills; ability to manage multiple and conflicting priorities, in a global organization

· Strategic Thinking

Minimum Education:

Bachelor’s degree required

Commercial Job Title:

Enterprise Architect / IT Security Minimum/General Experience

Experience with architectural principles of integration services, addressing Information Security risks, Achieve business objectives, meeting regulatory requirements, and addressing emerging threats. Experience with the principles of data management, data governance, metadata management, data design and integration.

Duties/Responsibilities

Understand advanced architectural principles of integration services (SOA)

Ability to create robust, scalable, sustainable integration / service architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources.

Understands the principles of data management, data governance, metadata management, data design and integration.

Experience in SOA data aspects including canonical modeling, canonical message modeling, Technical expertise in architectural principles and design aspects of various product family

A solid working knowledge relative to security best practices role based access controls

(RBAC), encryption, authentication/authorization, etc.

Demonstrated use of data architecture analytical frameworks. TOGAF preferred Advanced skills in developing and communicating data representations in consumable artifacts data flows, information groups, taxonomies

Ability to resolve complex issues related to enterprise wide integration architecture

Works with Security Architecture within the overall Enterprise Architecture

Enable secure communications and the appropriate protection of information resources

Support the legal information security requirements established by existing Federal and State statutes pertaining to information confidentiality, accessibility, availability and integrity.

Support secure, efficient transaction of business and delivery of services.

Leverage opportunities to obtain IT security synergies and economies of scale.

Minimum Education

B.S. in Computer Science or Management Information Systems or equivalent work experience Commercial Job Title:

Technical Architect / Data Architect Minimum/General Experience

Demonstrated experience and strong knowledge of Systems Development Life Cycle

(SDLC), Service Life Cycle and Project Management Life Cycle.

Excellent oral, written and interpersonal skills with the ability to influence and work effectively with diverse groups of peers and business partners.

Strong problem solving and decision making skills.

Critical thinker - Able to integrate company goals and objectives into department goals and activities/communications -can work with a "blank sheet" of paper.

Detailed oriented, excellent ability to multi-task: addressing critical daily issues as well as keeping focus on strategic tasks Process oriented - ability to efficiently identify root cause to establish repeatable/sustainable processes.

Pulls the right people together at the right time: Flexible - Can adapt to changing organizations, changing business needs etc

Able to lead and motivate a team of people to execute on all activities related to the development and implementation of solutions based on the established conceptual architecture.

Duties/Responsibilities:

Ability to create robust, scalable, sustainable integration / service architecture that supports requirements.

Understands the principles of data management, data governance, metadata management, data design and integration.

Experience in SOA data aspects including canonical modeling, canonical message modeling, XML, XSD preferred Technical expertise in architectural principles and design aspects of various IBM WebSphere product family (WESB, WPS, DataPower, MQ, etc.)

A solid working knowledge relative to security best practices role based access controls

(RBAC), encryption, authentication/authorization, etc.

Demonstrated use of data architecture analytical frameworks.

Advanced skills in developing and communicating data representations in consumable artifacts data flows, information groups, taxonomies

Ability to resolve complex issues related to enterprise wide integration architecture concerns

Demonstrated expert analytical skills (including interviewing) to develop appropriate models of the current state that will be used to frame future state solutions

Strong skills in Operational Data Store & Data Warehouse Modeling, Architecture, and BI Solutions Delivery Must have a good understanding of moving data as a service across the enterprise

Must have experience managing on/off-shore development team Experienced in using iterative SDLC models.

3+ years of Risk Analysis and Auditing experience.

Experience conducting Information Security reviews.

Lead Enterprise level analysis experience.

Policy creation and maintenance experience.

Strong project management skills and the ability to manage a diversified team of IS professionals

Excellent knowledge of current data security best practices, including relevant information security legal requirements (HIPAA, OIG, Sarbanes-Oxley, GLBA).

Demonstrated expertise in the entire Microsoft Office package which includes Access, Excel, Word and PowerPoint is required.

Minimum Education

A bachelor's degree in computer sciences or business administration from an accredited college or university with a minimum of three (3) years relevant work experience.

Commercial Job Title:

Technical Lead Minimum/General Experience

· Demonstrated hands-on, development, support and managing experience with Oracle R12

· Workflow, Oracle Business Event System, Oracle 10G and 11G, JavaScript, SQL, PL/SQL, communications protocols, clustering principles and architecting complex systems

· SQL, PL/SQL

· Experience on Oracle Application Sever, E-B usiness Suite, Oracle 10G and 11G Hands-on knowledge of using OBIEE, and OWB

· Strong knowledge and hands-on experience (5+ years) with PLSQL and SQL Knowledge of SDLC standard concept

· 6 to 7 years progressive experience in application design, development and system integration delivery in a heterogeneous environment

· Expert in managing a team of more than 10 members

· Prepare specification documents

· Proven ability to estimate work efforts for complex technology implementations, deliver results, and meet deadlines by using good time management skills

· Understanding of Oracles front end application and back end in order to accurately support the business requirements

Duties/Responsibilities

· Manage team to perform developing the interface architecture

· Take full ownership of the solution design, working directly with the application development team to deliver supportable solutions, coordinating code reviews approvals, and deployments, and enforcing adherence to technical best practices and standards

· Manage team to perform integration between different legacy applications and Oracle EBS using SOA and PL/SQL component development.

· Manage team to provide support and monitoring of the Production and Quality environments to insure both optimal performance and 100% accuracy and guaranteed delivery of the transactions.

· Will be required to troubleshoot production/test issues utilizing Unix log files, PL SQL / SQL queries, java/shell scripts and Oracles exception handling framework

· Support Oracle ERP implementations

· Recommend and support Oracle database patches and upgrades

· Staff management and professional development of team including hiring, salary administration, career development, motivational and team building

· Program and Project Management including services, system health, performance metrics

Minimum Education

BS in computer science or any Engineering field.

Commercial Job Title:

Senior Oracle Technical Developer Minimum/General Experience

Proficient with Oracle or another database, including complex queries and stored procedures. Experience with report writing and .Net development preferred.

Lead and/or Senior level experience required.

Enjoys a fast-paced, high-demand team environment.

Excellent communication, organizational, and troubleshooting skills

Duties/Responsibilities

Develop and enhance new and existing software components.

Leverage past experience to present standard Oracle EBS best-practices.

Serve as experienced Oracle EBS expert

Lead design sessions, write design documentation, and present solutions.

Anticipate customer needs and proactively develops solutions to meet them.

Serve as a key resource on complex and/or critical issues.

Solve complex problems and develops innovative solutions.

Perform complex conceptual analyses.

Reviews work performed by others and provides recommendations for improvement.

May lead functional or segment teams or projects.

Able to present clear explanations and information to others on complex issues

A bachelor's degree in computer sciences or business administration from an accredited college or university with a minimum of three (3) years relevant work experience

Commercial Job Title:

Technical Developer Minimum/General Experience

1-5 years of technical development experience

Object-oriented design and development concepts; algorithms, data structures, web development technologies (JavaScript, AJAX, Oracle, .Net); database design theory and SQL

Duties/Responsibilities

· Identify technical requirements, create detailed system design, and complete appropriate code, testing, and documentation activities 60%

· Understand documented business requirements

· Create detailed technical requirements from business requirements

· Create detailed design documentation from detailed technical requirements, and validate initial and revised project estimates.

· Complete coding and unit testing for new development and enhancements

· Coordinate and complete system, regression, volume, and user acceptance testing as appropriate with Business Analysis team and business users.

· Create associated procedures and documentation using established standards for methodology and documentation.

· Provide regular status and updates to assigned tasks on new development and enhancements project plans.

· Work with appropriate IT team members to support development instance locations for development activity, and associated version controls.

· Ensure appropriate change controls are followed for new development, enhancements and maintenance incidents.

· Support user documentation and training requirements.

· Maintain business user contact through implementation to support user acceptance testing activities.

Minimum Education

A bachelor's degree in computer sciences or business administration from an accredited college.

Commercial Job Title:

Database Administrator Minimum/General Experience

Must have experience with performing Oracle install, upgrades, patching and other administrative core DBA functions

Duties/Responsibilities:

Perform database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements

Responsible for performance monitoring, database tuning, and identification and correction of problem areas

Perform backup, recovery, and daily maintenance duties and "break/fix" responses using published procedures and documentation

Maintain documentation of database schema and maintenance procedures according to program requirements

Provide on-call 24-hour support to resolve operational problems

Ensure appropriate access to data within the Enterprise database is provided to users

Formulate and monitor policies, procedures and standards relating to database management

Interface with end users and customers as required

Collaborate with software engineers, network operations, and system administrators to ensure quality and integrity of databases, application software and data

Participate in design and code reviews

Resolve defects encountered during various testing cycles

Minimum Education

B.S. in Computer Science or Management Information Systems or equivalent work experience.

Commercial Job Title:

Systems Administrator Minimum/General Experience

The System Administrator (SA) is responsible for the effective conditioning, installation, configuration, operation, monitoring, maintenance and troubleshooting of systems hardware and software and related infrastructure. The SA participates in technical research and development to enable continuing innovation within the infrastructure and ensures that system hardware, operating systems, software systems and related procedures adhere to organizational values and objectives.

Duties/Responsibilities

Assist with the deployment, monitoring, maintenance, development, upgrade and support of all IT systems, including telecommunications, servers, PCs, operating systems, hardware, software, peripherals and Office Automation equipment

Ensure all users have access to the network systems as needed based on job function. The

Director of IT will review and approve all access change requests

Routinely advise the IT Director of the quality and reliability of existing hardware, software, operating systems and network components that comprise the WAN. The IT Director will make recommendations for changes and upgrades based on input provided by the Administrator

Conduct and verify the validity of daily server backup tapes and provide monthly status reports to the IT Director

Ensure that electronic mail capabilities of the server are operational at peak performance at all times and report any problems to the IT Director for resolution

Monitor and report unsuccessful login attempts, intruder detection lockouts and compromised passwords to the IT Director

Ensure all patches are tested and implemented and provide monthly status reports to the IT

Director

Ensure all systems are protected with up-to-date virus and malware protection

Adhere to the Information Security Policies and Procedures

A bachelor's degree in computer sciences or business administration from an accredited college.

Commercial Job Title:

ERP Functional Analyst Minimum/General Experience

ERP Functional Lead candidate will be a Functional leader / Subject Matter Expert experience in a ERP implementation project. ERP Functional Lead candidate will be responsible for functional maintenance and on-going support of ERP systems

Duties/Responsibilities

Support the university users in the utilization of ERP system

Support the university users in the utilization of ERP system

Liaise between business process owners, users and consultants

Assist and document change management with regard to business requirement

Assist and document change management with regard to technical requirement

Assist the key users in testing new functionality (new system and future functionalities)

Assist the key users in documenting and retaining ERP knowledge

Minimum Education

A bachelor's degree in computer sciences or business administration from an accredited college.

Commercial Job Title:

ERP Technical Lead Minimum/General Experience

Works with multiple IT teams and university departments to develop, maintain, and enhance the ERP application. Responsible for gathering business requirements and designing, developing, and supporting the ERP application and serving as a hands-on ERP analyst and developer.

Duties/Responsibilities

Responsible for systems analysis, design, and software programming in a combination of analysis, design, and development utilizing ERP Tools (Application Designer, App Engine, SQR, PS Query, Crystal Reports)

Understand all phases of the application development lifecycle; specifically related to ERP application development.

Understands application of project management disciplines.

Experience with integrating ERP with Non ERP Applications.

Work with relational database concepts and client-server concepts.

Minimum Education

A bachelor's degree in computer sciences or business administration from an accredited college. Certifications in supported technologies.

Commercial Job Title:

ERP Technical Developer Minimum/General Experience

Technical Developer is responsible for delivering effective project solutions to the business, and maintains a strong working relationship with other IT areas to ensure that projects are meetings their intended purpose and business need within the budgets and timeframes specified, during implementation and post-implementation phases.

Duties/Responsibilities

Develop Oracle software life cycle methodology, Oracle Forms 11i

Develop Oracle Reports 11i

Work with PL/SQL language, procedures, packages

Perform SQL query tuning

Work with MS-Access, Visual Basic

Work with Oracle applications technical architecture; Oracle applications table structure/indices (Order Management, Shipping, Inventory, WMS, PO, Financials);

Develop Oracle applications concurrent program registration, triggers/alerts, value-sets, key flexfields, profile values, resolving TAR files, and security features.

Minimum Education:

A bachelor's degree in computer sciences or business administration from an accredited college.

Commercial Job Title:

Quality Analyst Lead Minimum/General Experience

The SQA Analyst conducts software quality assurance tests by performing requiring planning, scheduling, testing and reporting tasks to ensure that design specifications requirements of the developed and client-provided software products are met and that the quality is within total quality management limits and standards. The SQA Analyst is also responsible to review requirements and designs and to create, edit, and clarify test plans and test cases with software project team

Duties/Responsibilities

Implementing of software testing, QA methodologies, QA processes and software lifecycle

Document test plans and test cases.

Work with relational databases and create and update database queries

Work with client server environments and/or network administration

Willing to effectively multi-tasks and prioritizing skills

Work with MS Office applications

Minimum Education:

Bachelor's Degree in Computer Science or Business or equivalent education experience preferred

Commercial Job Title:

Senior Trainer Minimum/General Experience

Senior Trainer must be an expert who supports the transition from current state to target state through transition planning and implementation; documentation of operating procedures and processes; preparation of training courses and materials; and preparation of Agency training staff to deliver end-user training.

Duties/Responsibilities Coordinating training programs with Software Vendors and Conducting group training at finance lender and dealership gatherings

Developing training materials such as manuals, videos, brochures, and reference cards

Managing training programs within dealership organizations to promote PEN features, conducting regular group training sessions via web meetings

Coordinating programs to promote awareness and utilization

Bachelor’s Degree, Technology or related field preferred Commercial Job Title:

Trainer Minimum/General Experience The Trainer must have experience coordinating training programs with Software Vendors.

Experience developing and executing training plans, tracking and reporting progress of implementation to internal and external customers and developing a detailed knowledge of the application/product suite.

Duties/Responsibilities Design, develop, and deliver instructor-led training programs to customers and Partner organizations to ensure client knowledge retention and understanding

Design and development of training programs and materials using established guidelines.

Delivers instructor-led training using Adult Learning principles/techniques to facilitate learning and application of content to participants' job role.

Collects content from internal Subject Matter Experts (SMEs) and external resources to create training content and overall learning objectives.

Conducts evaluation of courses based on interviews, surveys, and tests and modifies programs based on results.

Communicates effectively using visual, oral, and written forms with individuals, small groups, and large audiences.

Conducts needs assessment on the fly to determine audience requirements and adjusts curriculum plans to support audiences on-going knowledge requirements.

Minimum Education

Experience equivalent to 4-year University educational with an emphasis in Education

Commercial Job Title:

Oracle DBA Minimum/General Experience

· 10 years of demonstrable analysis and development experience in data modeling and architecture

· 5+ years of experience in OWB, OBIEE 10/11g

· Expertise in relational/multidimensional databases a must

· Strong SQL skills, PL/SQL

· Strong skills in a strategic ETL tool, such as OWB, ODI Excellent and proven communication skills

· Degree in Computer Science or related field

· Excellent communication skills and the ability to work in a team environment

· Self-starter, self-motivated, able to work with minimal supervision

Duties/Responsibilities

· Serves as technical lead / consultant to development teams in efficient data access methods.

· Participates in development initiatives to develop logical and physical data models and to capture application specific Metadata.

· Document data content, relationships, structure, and flow, processes that manage, transform, or touch data, business rules that govern data and durations for which data is required.

· Create / maintain an enterprise Metadata repository.

· Responsible for overall DW architecture design, which includes logical and physical design of the DW, data marts, and staging areas and ODS, ensuring that the design will support data availability, SLA and response time commitments.

· Provide expert knowledge regarding Data Warehousing, OLAP technology and data management including data extraction, transformation and loading (ETL) processes.

· Prepare ETL specifications for Data Warehousing projects, including data distribution and replication where appropriate.

· Works with various levels of management to plan, develop and implement data warehouse strategies to provide for the integration of data from many source systems.

· Establish and enhance a data management framework

· Establish, enhance and enforce data standards

· Ensure appropriate data security, privacy and access considerations are addressed

· Reviews SQL code to ensure scalability and efficiency.

· Manages and maintains all production and non-production Databases (includes backup/recovery, configuration, performance tuning)

· Implements and/or integrates databases and/or client requirements related to database requirements

Minimum Education

BS in Computer Science or any Engineering field III. Terms and Conditions Applicable to Information Technology (IT) Professional Services (Special Item Number 132-51) ****NOTE: All non-professional labor categories must be incidental to, and used solely to support professional services, and cannot be purchased separately.

1.

SCOPE

a. The prices, terms and conditions stated under Special Item Number 132-51 Information Technology Professional Services apply exclusively to Information Technology (“IT”) Professional Services within the scope of this Information Technology Schedule.

b. The Contractor shall provide services at the Contractor’s facility and/or at the ordering activity location, as agreed to by the Contractor and the ordering activity.

2.

PERFORMANCE INCENTIVES I-FSS-60 Performance Incentives (April 2000)

a. Performance incentives may be agreed upon between the Contractor and the ordering activity on individual fixed price orders or Blanket Purchase Agreements under this contract.

b. The ordering activity must establish a maximum performance incentive price for these services and/or total solutions on individual orders or Blanket Purchase Agreements.

c. Incentives should be designed to relate results achieved by the contractor to specified targets. To the maximum extent practicable, ordering activities shall consider establishing incentives where performance is critical to the ordering activity’s mission and incentives are likely to motivate the contractor. Incentives shall be based on objectively measurable tasks.

3.

ORDER

a. Agencies may use written orders, EDI orders, blanket purchase agreements, individual purchase orders, or task orders for ordering services under this contract. Blanket Purchase Agreements shall not extend beyond the end of the contract period; all services and delivery shall be made and the contract terms and conditions shall continue in effect until the completion of the order. Orders for tasks which extend beyond the fiscal year for which funds are available shall include FAR 52.232-19 (Deviation – May 2003) Availability of Funds for the Next Fiscal Year. The purchase order shall specify the availability of funds and the period for which funds are available.

b. All task orders are subject to the terms and conditions of the contract. In the event of conflict between a task order and the contract, the contract will take precedence.

4.

PERFORMANCE OF SERVICES

a. The Contractor shall commence performance of services on the date agreed to by the Contractor and the ordering activity.

b. The Contractor agrees to render services only during normal working hours, unless otherwise agreed to by the Contractor and the ordering activity.

c. The ordering activity should include the criteria for satisfactory completion for each task in the Statement of Work or Delivery Order. Services shall be completed in a good and workmanlike manner.

d. Any Contractor travel required in the performance of IT Services must comply with the Federal Travel Regulation or Joint Travel Regulations, as applicable, in effect on the date(s) the travel is performed. Established Federal Government per diem rates will apply to all Contractor travel. Contractors cannot use GSA city pair contracts.

5.

STOP-WORK ORDER (FAR 52.242-15) (AUG 1989)

(a) The Contracting Officer may, at any time, by written order to the Contractor, require the Contractor to stop all, or any part, of the work called for by this contract for a period of 90 days after the order is delivered to the Contractor, and for any further period to which the parties may agree. The order shall be specifically identified as a stop-work order issued under this clause. Upon receipt of the order, the Contractor shall immediately comply with its terms and take all reasonable steps to minimize the incurrence of costs allocable to the work covered by the order during the period of work stoppage. Within a period of 90 days after a stop-work is delivered to the Contractor, or within any extension of that period to which the parties shall have agreed, the Contracting Officer shall either-

(1) Cancel the stop-work order; or

(2) Terminate the work covered by the order as provided in the Default, or the Termination for Convenience of the Government, clause of this contract.

(b) If a stop-work order issued under this clause is canceled or the period of the order or any extension thereof expires, the Contractor shall resume work. The Contracting Officer shall make an equitable adjustment in the delivery schedule or contract price, or both, and the contract shall be modified, in writing, accordingly, if-

(1) The stop-work order results in an increase in the time required for, or in the Contractor's cost properly allocable to, the performance of any part of this contract; and

(2) The Contractor asserts its right to the adjustment within 30 days after the end of the period of work stoppage; provided, that, if the Contracting Officer decides the facts justify the action, the Contracting Officer may receive and act upon the claim submitted at any time before final payment under this contract.

(c) If a stop-work order is not canceled and the work covered by the order is terminated for the convenience of the Government, the Contracting Officer shall allow reasonable costs resulting from the stop-work order in arriving at the termination settlement.

(d) If a stop-work order is not canceled and the work covered by the order is terminated for default, the Contracting Officer shall allow, by equitable adjustment or otherwise, reasonable costs resulting from the stop-work order.

6. INSPECTION OF SERVICES

In accordance with FAR 52.212-4 CONTRACT TERMS AND CONDITIONS--COMMERCIAL ITEMS (MAR 2009) (DEVIATION I - FEB 2007) for Firm-Fixed Price orders and FAR 52.212-4 CONTRACT TERMS AND CONDITIONS - COMMERCIAL ITEMS (MAR 2009) (ALTERNATE I - OCT 2008) (DEVIATION I – FEB 2007) applies to Time-and-Materials and Labor-Hour Contracts orders placed under this contract.

7. RESPONSIBILITIES OF THE CONTRACTOR

The Contractor shall comply with all laws, ordinances, and regulations (Federal, State, City, or otherwise) covering work of this character. If the end product of a task order is software, then FAR 52.227-14 (Dec 2007) Rights in Data – General, may apply.

8. RESPONSIBILITIES OF THE ORDERING ACTIVITY

Subject to security regulations, the ordering activity shall permit Contractor access to all facilities necessary to perform the requisite IT Professional Services.

9. INDEPENDENT CONTRACTOR

All IT Professional Services performed by the Contractor under the terms of this contract shall be as an independent Contractor, and not as an agent or employee of the ordering activity.

10. ORGANIZATIONAL CONFLICTS OF INTEREST

a. Definitions.

“Contractor” means the person, firm, unincorporated association, joint venture, partnership, or corporation that is a party to this contract.

“Contractor and its affiliates” and “Contractor or its affiliates” refers to the Contractor, its chief executives, directors, officers, subsidiaries, affiliates, subcontractors at any tier, and consultants and any joint venture involving the Contractor, any entity into or with which the Contractor subsequently merges or affiliates, or any other successor or assignee of the Contractor.

An “Organizational conflict of interest” exists when the nature of the work to be performed under a proposed ordering activity contract, without some restriction on ordering activities by the Contractor and its affiliates, may either (i) result in an unfair competitive advantage to the Contractor or its affiliates or (ii) impair the Contractor’s or its affiliates’ objectivity in performing contract work.

b. To avoid an organizational or financial conflict of interest and to avoid prejudicing the best interests of the ordering activity, ordering activities may place restrictions on the Contractors, its affiliates, chief executives, directors, subsidiaries and subcontractors at any tier when placing orders against schedule contracts. Such restrictions shall be consistent with FAR 9.505 and shall be designed to avoid, neutralize, or mitigate organizational conflicts of interest that might otherwise exist in situations related to individual orders placed against the schedule contract. Examples of situations, which may require restrictions, are provided at FAR 9.508.

11.

INVOICES

The Contractor, upon completion of the work ordered, shall submit invoices for IT Professional services. Progress payments may be authorized by the ordering activity on individual orders if appropriate. Progress payments shall be based upon completion of defined milestones or interim products. Invoices shall be submitted monthly for recurring services performed during the preceding month.

12. PAYMENTS

For firm-fixed price orders the ordering activity shall pay the Contractor, upon submission of proper invoices or vouchers, the prices stipulated in this contract for service rendered and accepted. Progress payments shall be made only when authorized by the order. For time-and-materials orders, the Payments under Time-and-Materials and Labor-Hour Contracts at FAR 52.212-4 (MAR 2009) (ALTERNATE I – OCT 2008) (DEVIATION I – FEB 2007) applies to time-and-materials orders placed under this contract. For labor-hour orders, the Payment under Time-and-Materials and Labor-Hour Contracts at FAR 52.212-4 (MAR 2009) (ALTERNATE I – OCT 2008) (DEVIATION I – FEB 2007) applies to labor-hour orders placed under this contract. 52.216-31(Feb 2007) Time-and-Materials/Labor-Hour Proposal Requirements—Commercial Item Acquisition As prescribed in 16.601(e)(3), insert the following provision:

(a) The Government contemplates award of a Time-and-Materials or Labor-Hour type of contract resulting from this solicitation.

(b) The offeror must specify fixed hourly rates in its offer that include wages, overhead, general and administrative expenses, and profit. The offeror must specify whether the fixed hourly rate for each labor category applies to labor performed by—

(1) The offeror;

(2) Subcontractors; and/or

(3) Divisions, subsidiaries, or affiliates of the offeror under a common control.

13. RESUMES

Resumes shall be provided to the GSA Contracting Officer or the user ordering activity upon request.

14.

INCIDENTAL SUPPORT COSTS

Incidental support costs are available outside the scope of this contract. The costs will be negotiated separately with the ordering activity in accordance with the guidelines set forth in the FAR.

15.

APPROVAL OF SUBCONTRACTS

The ordering activity may require that the Contractor receive, from the ordering activity's Contracting Officer, written consent before placing any subcontract for furnishing any of the work called for in a task order.

16.

DESCRIPTION OF IT PROFESSIONAL SERVICES AND PRICING

a. The Contractor shall provide a description of each type of IT Service offered under Special Item Numbers 132-51 IT Professional Services should be presented in the same manner as the Contractor sells to its commercial and other ordering activity customers. If the Contractor is proposing hourly rates, a description of all corresponding commercial job titles (labor categories) for those individuals who will perform the service should be provided.

b. Pricing for all IT Professional Services shall be in accordance with the Contractor’s customary commercial practices; e.g., hourly rates, monthly rates, term rates, and/or fixed prices, minimum general experience and minimum education.

SIN: 132-51 Information Technology Professional Services FPDS Code D302 IT Systems Development Services Senryo offers IT Systems Development services that involve Systems Development Life Cycle methodology that drives development initiatives. These services in detail provide an iterative process of planning, construction and maintenance of IT Systems. Senryo emphasizes on streamlining the development processes via different SDLC methodologies.

FPDS Code D306 IT Systems Analysis Services Senryo provides IT Systems Analysis services to complement the IT Systems Development services that involves understanding the current state of the client and building a migration plan to reach the future state via systems analysis phase and services to carve a roadmap. These services involve understanding the technology, operations and business processes.

Systems Analysis Services include:

Web/Internet Applications

Hardware and software Architecture

Functional Systems Design

Database Design

Security

Performance Assessment

Problem Mitigation

Quality Assurance

Configuration Management

Documentation

Cost-Benefit Analysis

Risk Assessment and Mitigation

Requirements Documentation FPDS Code D307 Automated Information Systems Design and Integration Services Senryo provides Information Systems Design automation besides integrated services to streamline the business process so that IT systems can talk to each other in a defined architecture and flow. Most of these services are provided post-merger of the department, domains, and organizations to provide one-stop shopping to the customer.

Full lifecycle methodology with multiple approaches using industry or homegrown methodologies is provided.

FPDS Code D308 Programming Services Senryo provides programming services as part of the systems building process that involves best-of-breed tools from different vendors. These programming services also provided to clients on- demand basis where Senryo routes its expertise in specialized verticles through its domain knowledge.

Programming Services includes: Languages

C#

MS Visual C++

Java

Visual Basic 6.0

BPML

T-SQL, PL/SQL

HTML

XPath

XML

UNIX Shell Scripting

Cold Fusion

Environments

MS Windows 98, NT, 2000, XP.Net

UNIX /LINUX/BSD/Mainframe/ISeries Databases

SQL Server

Progress

Oracle

MS Access

Tools

Net Studio

IBM Websphere Developer Studio

Symantec Visual Café

MS Visual Developer Studio 6.0

Cold Fusion Studio 5.0

Internet & Intranet

Cold Fusion Studio 5.

ASP.Net

ASP 3.0

Cold Fusion

JSP

HTTP and Proxy Server

IIS 4/5/6

Apache

IBM Websphere

MS IAS

Security /Firewalls FPDS Code D310 IT Backup and Security Services Senryo provides Disaster Recovery and Business Continuity Planning as a part of the IT backup with IT Security services being a part and parcel of the whole package using encryption and compression during backups to disks or tapes and periodic recovery and restoration of the data to validate backups. IT Security services from Senryo specializes in building security architecture around the IT systems besides following the process of authentication, authorization and access to the various applications via security handshakes.

FPDS Code D311 IT Data Conversion Services Senryo specializes in IT Conversion services as part of their AIA (Application Integration Architecture) to incorporate business rules and logic, thus providing information from the data that can be used by business users to enhance their business processes. Senryo uses various ETL (Extraction, Transformation and Loading) tools to complement the process besides maintaining business definitions for the business users via dashboards.

FPDS Code D316 IT Network Management Services Senryo provides IT Network services via building network backbones for the Application and database infrastructure. Senryo assists its clients in building network architectures that involves database servers, application servers and web server domains besides what needs to be in DMZ and what needs to be secured. These services are provided to complement IT security services and D/R services.

IV. GSA Pricing

184.73

155.60

102.11

Senior Business Analyst 136.15

131.29

272.30

141.01

150.74

Senior Oracle Technical Developer…