ATTACHMENT_L-2-1_Recommendation_for_Channel_3_Sample_Personnel.docx

Attachment L-2-1 Recommendation for Channel 3 - Sample Personnel

Channel 3 - Database Development and Maintenance

The Contractor shall provide all necessary personnel, administrative, development, financial, and managerial resources necessary to support the subsequent task orders.

As technology develops and the SEC transitions to the cloud environment or updates existing infrastructure or needs, it will be essential to update skillsets throughout the life of the requirement. This may include additional skillsets not listed below or the removal of skillsets listed as part of this requirement. The government will collaborate with the contractor and provide all the necessary specifications and qualifications for any desired skillsets.

The following personnel positions are good examples of personnel positions for relevant tasks placed under this IDIQ.

· Sr. Data Modeler Shall have a minimum of seven (7) years of experience and expertise with data modeling data, including Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems. Demonstrated experience in data warehousing, business intelligence on multiple databases and within the financial industry. Proficient with data warehousing principles, relational database management systems, logical and physical data models, including dimensional modeling (star schema and snowflake schema). Demonstrate outstanding programming skills and sound ability to recommend and execute scalable and flexible solutions to support analytical projects. Demonstrate strong fundamental knowledge and experience using data integration tools. Expert knowledge of Structured Query language (SQL). Bachelor’s Degree in computer science, Information Systems, Systems Engineering, Business or related fields.

· Sr. Business Analyst Shall have a minimum of seven (7) years of experience and expertise defining and capturing business needs for new and/or enhanced products, services, or ETL processes. Demonstrated experience providing and applying functional and technical expertise towards the development and/or redesign of current business processes to ensure effective and efficient use of core Business and IT competencies. Expert knowledge of Structured Query language (SQL). Demonstrated experience working independently with UNIX and Windows Operating systems. Functional knowledge of SDLC, Agile methodology, Data Modeling, Relational databases, Big Data Technologies and Software testing. Good Verbal and Written communication skills. Demonstrated ability to work independently and in a team Setting. Bachelor’s Degree in Computer Science, Information Systems, Systems Engineering, Business or related Fields.

· Sr. Developer Shall have a minimum of Seven (7) years of programming experience. Experience supporting Web Services & Web Scrapping projects including automated data downloads from HTTP, FTP/SFTP and other sites. Working knowledge, and professional experience with creating/consuming RESTful/SOAP Web Services. Working knowledge, and professional experience with technology such as JSON, XML, HTTP, WSDL, and UDDI. Working knowledge and professional experience with programming/coding experience with Python/Java/JavaScript, CSS and HTML. Familiar with Web Service frameworks, design, optimization principles and best practices. Working knowledge and experience with scraping web sites. Familiar with libraries/tools such as Beautiful Soup, urllib, Jsoup, Selenium etc. Knowledge and experience with database technologies such as ODBC/JDBC and SQL. Bachelor’s degree in computer science or related field.

· Architect shall have a minimum of ten (10) year of IT experience focused on delivering large-scale or complex IT, Data warehousing and Big data solutions. Experience Collaborating with various technical teams to define, develop, expand, and refine technical requirements and comprehensive architecture models that drive complex enterprise data management solutions. Extensive experience designing solutions for Structured, unstructured or semi structured datasets. Experience with developing and presenting workflows, process diagrams, design documents. Extensive experience working in enterprise data architecture, enterprise data warehouse, ETL/ELT processes and Big data solutions. Bachelor’s Degree in computer science or related fields. Highly preferred active certifications from a major hadoop distributors, major Database vendors and/or Big data Technical professional certification.

· Sr. Big Data Developer shall have a minimum of ten (10) years of IT experience and at least 3 years working with Hadoop tools and technology. Proficient with designing and developing big data solutions. Experience with widely-used hadoop tools such as Apache Spark, Hive, Scoop, flume and Ozzie. Extensive experience working with complex file formats include structured, unstructured and semi-structured data. Experience working with cloud based technology such as Amazon EMR, Redshift and DCOS. Proficient using python. Java experience is a plus. Experience working with databases and & appliances such as Netezza, Greenplum, Oracle, Sql Server, PostgreSQL & Sybase. A bachelor’s degree in computer science or related field. Certified Developer from a major hadoop distributer.

· Sr. ETL Developer shall have a minimum of ten (10) years of IT experience with at least 8 years working with database management systems such as Netezza, Greenplum, Oracle, Sql Server, PostgreSQL & Sybase. Proficient with data warehousing principles, relational database management systems, and data modeling (logical and physical), including dimensional modeling (star schema and snowflake schema). Experience with developing, tuning and debugging code, stored procedures, functions and packages. Experience working on Unix, Linux and windows environments. Proficient with Unix/Linux Scripting languages as well as Perl and Python programming language. Functional knowledge of SAS will be very helpful. Proficient with loading data into relational databases using tools such as Oracle’s PLSQL, SQL Loader, Data Pump, Netezza’s NZload, NZSQL, NZPLSQL, external tables etc. A bachelor’s degree in computer science or related field.

· Sr. Tester Shall have a minimum of ten (10) years of IT experience with at least 7 years of experience as a tester. Extensive experience working on Data Management Systems and Extract Transform and load processes. Experience working with popular Software Quality Assurance frameworks and tools. Demonstrated ability to work independently and in a group setting. Functional experience with testing strategies including Unit Test, Integration Test, Performance test, regression test, acceptance test etc. Experience working on Unix and windows platforms. Expert knowledge of Structured Query Language (SQL). Experience working on with SDLC, Agile methodology, Test driven Development, configuration Management and source control. Experience working with Relational database management systems and various programming languages. Experience working with databases and & appliances such as Netezza, Greenplum, Oracle, Sql Server, PostgreSQL & Sybase. Bachelor’s degree in computer science or related field.