Senior Technical Specialist

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States. we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County. We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market. If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills. JOB DESCRIPTION Job Title: Senior Technical Specialist Project Scope: The scope of this Letter of Engagement is to provide enterprise data reporting services to Client Information Technology Services Branch. The services include research, analyse, design and implement appropriate IBM Cognos and Oracle Business Intelligence Enterprise Edition (OBIEE) reporting solutions for business users based on any outstanding and future requests; enhance and maintain myClient and Business Intelligence (BI) Production Reporting system. The project deliverables may include the following components: myClient and BI Release work:

• Meet with customers, gather requirements, do the business analysis and create Report Specification documents
• Design and develop reports using Cognos or OBIEE tool
• Design and develop SQL for reports
• Integrate external Application to Cognos/OBIEE to trigger/run reports
• Integrate Cognos to batch processes to be able to run/create and save reports using Cognos SDK

• Maintain the existing package(s) and suggest for ways of improving the performance and maintainability
• Performance tuning of Cognos and OBIEE applications - both on reports, framework side and server/infrastructure aspects
• Maintain existing Framework Manager packages and build new packages as per reporting needs
• Maintain existing Oracle Repository (RPD) metamodels and build new models as per reporting needs
• Design, develop and deliver data extracts from Client databases and data warehouses
• Update design and technical specification documents for on-going report modifications
• Maintain security of Cognos and OBIEE Objects and implement data level security on reports to restrict data visible to users
• Maintain security of Client data assets through the administration of Cognos and OBIEE features
• Maintain knowledge of Client data models and data dictionary for the purpose of maintaining Cognos and OBIEE reports and enhancing user awareness of business data

• Work with Application team to identify performance issues and suggest improvement plans
• Work with Middle-Tier team and manage software upgrades, patches and back-up as needed
• Work with product vendors to provide application support and bug fixes as needed
• Work with Database team to create and update Report Data column mapping to database tables and columns
• Work with Business Intelligence (BI) Delivery Leads/Data Warehouse/report developers to build/assist in redesigning the reports to source from warehouse
• Educate and provide knowledge transfer to report developers and business users on Cognos and OBIEE tools and best practices

• Provide weekly accomplishment/status report to management every week
• Attend project and team meetings as requested.