Software Technical Consultant
Optimum Solutions (Singapore) Pte. Ltd
Total years of experience :20 years, 2 Months
Deployment: Boehringer Ingelheim - Singapore
Job Responsibilities:
• Develop Cognos reports using Report Studio based on business specification document provided by the Systems Analyst.
• Create Dashboard for selected reports
• Convert selected existing SSRS Reports to Cognos Report 10.2.1
• Create/modify Framework models based on Business Requirement
• Administer/handle Cognos Folders/Reports security
• Adding/modifying of LDAP groups and users for DEV and Production.
• Deploy reports and packages from Development to Production Environment
• Design/create tables in Datamart for reports assigned
• Develop/create Oracle Stored Procedures which Extracts, Transform and Load data from Data warehouse to Datamart.
• Resolve any Cognos issues and risks that could affect the development team.
• Perform data issue investigation.
• Perform application testing when needed.
Additional Responsibilities:
• Create and modify Informatica mappings, workflows to load data into Data warehouse.
• Support and maintain Informatica jobs.
• Create SSRS reports including T-SQL.
• Create xml codes to extract data from Veeva CRM Cloud (Salesforce.com)
• Support and maintain APEX Dataloader jobs.
Job Responsibilities:
• Develop Cognos reports using Report Studio based on design specifications; create test cases, & perform work product inspection and unit testing as well.
• Convert selected existing Hyperion report to Cognos 8.4 and Cognos 10.1.1
• Modify and enhance existing Cognos reports base report specifications provided.
• Create/modify QAIW Framework models.
• Evaluate accuracy of reports against reporting benchmarks/standards.
• Publish and monitor scheduled report based on QAIW production support calendar.
• Resolve any Cognos issues and risks that could affect the development team.
• Provide second level of support to QAIW Report users’ world-wide via phone, instant messaging, and email communication in the ongoing environments in production which includes incident resolution.
• Perform data issue investigation.
• Perform application adopter testing when needed.
Job Responsibilities:
• Convert Hyperion reports to Cognos reports 8.4 using Report Studio.
• Develop Cognos reports base on requirements gathered.
• Update and maintain existing reports/programs when needed.
• Write and modify JavaScript codes embedded in the reports to normalize and minimize running time.
• Design/Create ART Framework models base on standard layout.
• Deploys ART reports including scheduled reports.
• Performs Unit Testing of reports done by other developers as well as work product inspections (WPI)
• Create test cases once reports have been completed.
• Administer Hyperion Performance Suite Server, grant access to users, assigning group codes and manage existing scheduled jobs.
• Restarts Hyperion Services via UNIX when needed.
• Involves in systems upgrade for DB2, OS and Hyperion.
• Performs application testing after upgrade.
Job Responsibilities:
• Provide second level of support to application users for Asia pacific operations via phone, instant messaging, and email communication in the ongoing environments in production which includes incident resolution.
• Maintain Request Register database and log issues raised by users.
• Provide reference document report for the weekly status meeting for Australia and the Philippine team
• Notify Asia pacific regional helpdesks for any outages, updates and availability of reports.
• Generate and run weekly, monthly and YTD report as requested
• Install web-client plug-ins, application software and perform browser upgrade.
• Monitor scheduled reports based on AP Reporting Tool production support calendar.
• Develop Hyperion reports based on requirements gathered by the Business Analyst.
• Update and maintain existing reports/programs when needed.
• Write and modify JavaScript codes embedded in the reports to normalize and minimize running time.
Job Responsibilities:
• Perform data extraction tasks, as needed, including audience creation and sizing, code creation and analysis files using SQL Tool (BRIO v6.)
• Develop and maintain Report Templates using BRIO software which is used by Market Data Strategists.
• Generate and run queries based on a data brief which was sent by the requestors from Canada and the United States.
• Customize SQL statements to minimize the number of queries used on a report.
• Cast audience created which was pulled out from American Analytic Database (AADB) into CRM Siebel 7.
• Create and load audience (pulled data from the database) via CRM Siebel segment.
• Carry out visual quality checks, which will need a degree of local understanding of the US market.
• Liaise with client on points of clarity of the data brief or reported results
• Highlight any potential data quality issues to the Team Leader, ideally with a recommended solution.
• Identify production/ data quality issues and implement corrective action (in cooperation with Center Manager and/or Operations Director as necessary)
• Ensure all necessary metrics are reported in a timely and accurate manner.
• Assist Business Unit Coordinator in gathering and documenting user’s requirements in developing Adhoc and SMB template report programs by using BRIO and Hyperion Business Intelligence Tool.
• Participate in building of SMB template help files, report manuals and assist BUC in preparing of weekly meeting reference guide.
Job Responsibilities:
• Implement and perform quality testing the development of BOS/e PeopleWare HR, Timekeeping, Payroll and BOS/e Finest Restaurant POS components for Infostructure's clients.
• Check and evaluate client PC’s hardware and software which will be used as BOS/e server and clients.
• Perform MS SQL installation/configuration and product installation to the client site.
• Set-up client’s company database for Human Capital Management based on pre-defined scripts.
• Execute product updates on all BOS/e modules at the client site.
• Create test cases and test plans for payroll module.
• Support and troubleshoot product issues and determine resolution for customer via telephone and email transactions.
• Participate in the development of BOS/e Finest Restaurant (Fine Dining Point of Sale) using Delphi programming language.
• Modify and update programs codes to meet on the client requirement.
• Performs system walkthrough for client’s end-users including product demos to prospect clients.
• Alert software developers to major quality issues.
• Maintains and document Project Issues/Concerns of assigned clients.
• Recommend improvements on testing practices or software engineering practices.
• May oversee application end-users and technical provide assistance.
• Replicate application and database issues encountered by end-users and document solutions for future reference.