• Supports in managing the Business intelligence reporting software and supporting data warehouse.
• Develops and delivers Business intelligence solutions in accordance with business reporting requirements.
• Documents reporting requirements and report specification documents.
• Documents and assists with the creation of solution design documents.
• Conducts testing of newly developed solutions and assists users in performing UAT.
• Translates business reporting requirements into technical solutions that help to support decision-making through the analysis of measures and metrics used by the business.
• Investigate, diagnose and resolve technical reporting issues to ensure the continued performance of the solutions.
• Conveys technical solutions to non-technical colleagues.
• Maintain accurate and complete technical documents
• Recommend strategies to improve the performance and capacity of BI tools
• Support Cognos upgrades in development, testing and documentation
• Perform analyses to troubleshoot data issues with BI solutions.

Skills: Business Intelligence Reporting Software Management, Solution Development and Delivery, Documentation of Reporting Requirements, User Acceptance Testing (UAT) Coordination, Technical Translation of Business Requirements, Technical Issue Investigation and Resolution, Technical Communication, Performance Optimization and Strategy Recommendations

• Responsible for managing service deliver with quality and client-mandated AMS services model from India.
• Connect with senior client stakeholders to ensure better visibility of upcoming opportunities or challenges.
• Engage Client and expectation management to ensure expectations are aligned to agreed service levels
• Working and coordinating with different vendors/infrastructure teams
• Self-driving capabilities and working with client stakeholders
• Preparation for weekly/monthly status reports
• Review the current plan and highlight any gaps relating to specifications, wireframes or data availability
• Undertake Cognos report development activities
• Working closely with the business end users and SMEs of the project to support rapid prototype of report and framework manager package design/development
• Facilitate UAT process with end users cross-checking 'current world' results to 'new world.' Documenting rationale and evidence for those that dot match
• Agree with project SMEs the necessary release plan to production, ensuring the delivery adheres to client's best practice for release
• Updating and maintaining the MIS Project MIS Report List tracker with development progress for each report
• High-level unit testing of framework manager packages and reports during the development lifecycle, UAT acceptance from business users and SME Project Leads

Skills: Client Stakeholder Management, Service Delivery Management, Vendor and Infrastructure Coordination, Report Development in Cognos, Status Reporting and Documentation, User Acceptance Testing (UAT), Project Release Planning, High-Level Testing and Quality Assurance

• Participate in the analysis, design, test and technical implementation for Cognos reports and Cognos Framework Manager Models related work.
• Create new and maintain existing Cognos reports.
• Create new and maintain existing Cognos Framework Manager Models to utilize the data sources available and satisfy the requests of the users.
• Work with data warehouse team to enhance data mart models that support the Cognos Framework models.
• Provide expertise in FM Models that promote the use of self-service reporting.
• Ensure accuracy and integrity of data through analysis and unit testing.
• Responsible for the development and maintenance of SDLC artifacts related to data integration implementation.
• Provide ongoing production support and maintenance for Corporate Reporting.
• Collaborate with Data Warehouse Implementation teams, BI Administrators, Developers and Analysts for successful development of BI reporting and analytic solutions
• Support Business Analysts (BA) in gathering and translating requirements from clients for building insightful, compelling reports and dashboards that drive decision making
• Creating framework manager packages reports and dashboards to clients' existing standards and specification

Skills: Cognos Report Development, Framework Manager Models, Data Warehouse Collaboration, Self-Service Reporting, Data Accuracy and Integrity, SDLC Artifacts, Production Support, Collaborative Development

• Consult with users, analyze requirements and recommend technical design and specifications.
• Develop, test and implement technical reporting solutions.
• Modify and maintain existing report and reporting applications.
• Prepare technical, operational and user-related documentation in support of report and report applications.
• Provide technical support and training to functional users
• Design, develop and testing of complex report Complex Drill Through, Cascading Prompts, Summary Reports, Burst Reports, multi-dimensional reports using Cognos Business Intelligence solution
• Prepare designs & code for various Cognos reporting objects & ensure compliance to the best practices and NFR criteria.
• Understand business requirement and work with the business stakeholders for the acceptance of the reports.
• Coordinate with Architect/TL, ETL team to translate design into the code
• Coordinate with the L3 and L2 teams for the resolution and support of the existing issues.
• Adherence to project schedule and quality standards.
• Build and share knowledge within the team.

Skills: Requirements Analysis and Technical Design, Report Development and Testing, Report Modification and Maintenance, Documentation, Technical Support and Training, Collaboration and Coordination, Project Management, Business Intelligence Expertise

• Development of information system (setting up of new functional blocks, changing the business logic in existing functional blocks at the request of the functional customer)
• Development of complex business logic in Cognos TM1
• Development integration tasks with external systems
• Communication with the business customer and development of requirements
• Collaboration with support and testing teams
• Presentation of the functionality of the budgeting system
• Train for users of the budgeting system
• Consult users on support issues (3d level support)
• Analysis and resolving incidents with information system
• Write technical documentation
• Maintain system documentation up to date.

Skills: Complex Business Logic Development, Integration with External Systems, Requirement Gathering and Communication, Collaboration with Support and Testing Teams, System Presentation and Training, Third-Level Support, Incident Analysis and Resolution, Technical Documentation and Maintenance

• Good understanding of relational databases and reporting tools (Cognos Report Studio or Business objects)
• Experience with Oracle SQL 
• Experience in Pharma  especially working with Research and Development/R&D/Development Operations functions (Drug Safety, Biometrics, Clinical Operations, Clinical Data Management)
• Experience working with validated/qualified applications is preferred
• Be organized and analytical, adept at working in a team environment.
• Proficient in written and verbal communication.
• Excellent facilitation and negotiation skills and drive to successful outcome
• Experience in troubleshooting/ problem solving.
• Works as an independent contributor as well as a team player
• Experience with computer systems, databases, and end user community support.
• Good working knowledge skills with Microsoft Office Products, Microsoft Visio, and Microsoft Project.
• Knowledge of Pharmacovigilance Databases (e.g. Argus, ARISg).

• Knowledge of database concepts and SQL.
• Experience working with Cognos reporting environment is a requirement (Report Studio/Analysis Studio/Framework Manager/Transformer).
• Experience administering a Cognos reporting environment is a requirement
• Experience in the use of various business systems to extract meaningful data and perform appropriate analysis to provide business insights
• Familiar with terminologies used in a manufacturing/ production environment
• Familiarity with continuous improvement strategies (Lean, Six Sigma, QRM, and the like)
• Experience using Cognos 8 and/ or 10 (Report Studio, Metric Studio, Framework Manager, Data Manager and PowerPlay)
• Proficient in ing framework models, catalogs, and creating list reports, freestyle reports, cross-tab reports, sub reports and dashboard reports
• Experience in performance tuning of reports
• Experience of Sybase IQ database experience, with a focus on performance tuning
• Experience of Unix scripting

Qualifications: BS in Information Technology with 5 years of Experience

• Experience in performing development, testing, implementation, and documentation related to Cognos 10/11.
• Understand business processes, data requirements, and data flows.
• Ability to recommend alternative solution choices and impact.
• Proficient with reading/writing Oracle SQL.
• Good understanding of logical and physical models of data warehouse.
• Experience in developing Medium to Complex Cognos 10/11 Relational and MDX Reports Independently.
• Experience in developing/changing Cognos 10/11 Framework, Dynamic Cube and Transformer models for reporting.
• Experience in troubleshooting of report and performance issues of Cognos 10/11.
• Customized Cognos 10/11 reports using JavaScript.
• Experience in Cognos development, Report studio, Framework manager
• Knowledge of SQL concepts and DB like MS SQL other databases

Qualifications: BA in Software Engineering with 4 years of Experience

• Strong in developing complex Cognos Framework Manager models, Transformer models, MDX, Reports and Cubes
• Knowledge of SQL Queries, Performance Tuning of SQL Queries
• Ability to communicate effectively to multiple levels in the customer organization
• Ability to effectively deal with multiple deadline-driven, customer-sensitive projects and tasks
• Strong time management and task prioritization skills
• Ability to communicate clearly and concisely verbally and in writing
• Experience in team leadership/management
• Experience in working in a global technology development model
• Ability to provide end-to-end leadership on the software development life cycle (requirements through implementation)
• Ability to work with Senior management & executives both on the Technology as well as Business
• Experience with complex Data Architecture/Data lineage methodologies

Qualifications: BS in Business Analytics with 3 years of Experience

• Understand current Pharmacovigilance regulations
• Experience working with Ticketing Systems like Service Now.
• Independently establishes work priorities and direction with minimal input from the manager.
• Experience in demonstrating attention to detail, teamwork, and initiative.
• Experience in participating in cross-functional discussions and presentations
• Experience in collaborating with members in Systems, Data Analytics, Project Management, IT, QA, etc
• Experience in  reviewing functional specifications creating technical design and technical specifications and overseeing code development and unit testing activities
• Experience in developing code creating test transactions and running tests to find errors and revising programs
• Experience in  performing defect analysis and debugging computer programs
• Experience with compliance/Operational Risk 
• Experience with Framework and transformer model implementation
• Strong SQL programming experience
• Strong Data analysis skills

Qualifications: BA in Data Science with 4 years of Experience