Jibu Simon Jacob | Australia PR

ENVIRONMENT: MS SQL SERVER 2016, SSIS, Power BI

PROJECT: OCBC BANK (SINGAPORE)

• Developed SSIS packages for integrating data using OLE DB connection from heterogenous sources
• Used multiple transformations provided by SSIS such as Data conversion, Derived column, Lookup, Conditional split, and Merge
• Developed reports using Microsoft Power BI
• Created calculated columns and measures in Power BI depending on requirement using DAX queries
• Experience in writing T-SQL for developing Stored Procedures, Index, Views, User Functions, SQL joins for Data Integrity and normalization
• Perform quality assurance testing of reports and dashboards and facilitate user acceptance testing sessions
• Ensure quality of reports prior to releasing to production
• Developed and maintained multiple Power BI dashboards and reports

ENVIRONMENT: MS SQL SERVER 2016, Power BI, SSIS, TALEND BIG DATA 7.1.1, HIVE, HDFS, AUTOSYS, UNIX SCRIPTING

PROJECT: Accountant-General's Department (Singapore)

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing Data Feed and Reporting systems
• Used SSIS to create ETL packages to extract, transform and load data to data warehouse from traditional data sources
• Used Talend to create ETL packages to extract, transform and load data to data warehouse through HDFS
• Developed Autosys jobs to schedule and automate flow of Talend jobs and SSIS jobs to load data into Data Warehouse
• Created Hive tables, partitions, Hive Queries, and implemented incremental logic to process Business logic from source tables
• Developed complex programs in T-SQL, writing Stored Procedures and queries with best execution plan
• Troubleshoot data issues and enhance database performance
• Develop SQL Queries for data validation and Test Cases
• Effectively composed technical design specifications and process flows.
• Provided UAT and Production support for Business Users

ENVIRONMENT: Cognos 10.2.2 – (Framework Manager, Report Studio), Oracle 11g, BMC Control M

PROJECT: Singapore Telecommunication (Singapore and Sydney)

• Understand and analyze business requirement of each report based on Report Template Design document
• Responsible for development of Usage, Credit Risk & Collections, Customer, Financial & Billing Operations, Credit Management, Consumer Sales & Marketing reports related to Telecom domain
• Coordinated with SIT and Functional team for comprehensive functional testing of report.
• Interacted with Users for completion of UAT testing of reports
• Assessed Framework Manager model and modify model as per Business requirement and changes requirement
• Implemented Security in Cognos Administration & Data Security in FM model
• Implemented BMC Control M map to schedule Cognos reports based on ETL completion of jobs
• Responsible for providing resolution of defects raised by Users and SIT team on Cognos reports using ALM tool
• Representing team for submitting Technical Change Requirement (TCR) to Change Advisory Board (CAB) for deployment of changes or defects raised by Users in Production environment.

ENVIRONMENT: Cognos 10.2 – (Framework Manager, Report Studio, Transformer, Active Reports using RAVE Engine, Go Office, Insight), Microsoft SQL Server 2012, Oracle 11i

PROJECT1: J.D. IRVING (CANADA)

PROJECT2: KUWAIT GULF OIL COMPANY (KUWAIT)

• Understand and analyze requirements of each reports based on Functional Design Document
• Preparing and tracking detailed activity plan
• Guiding team functionally and technically, to develop Reports and Dashboards as per Design Specifications
• Development of complex Financial Reports and Cubes
• Design and development of Management Dashboard using Active Reports with regards to Oil and Gas Industry based on Rave Engine in Cognos 10.2.1
• Provided Active Report demo to client
• Assessed Framework Manager to understand data model built for reports and making required modification as per Business user requirement
• Designed Summary table of Sales Fact table to enhance performance of reports
• Redesigned reports by redeveloping reports to use minimum number of queries in report
• Developed reports related to Operation and Capital Budget using List, Crosstabs and Charts
• Used Cognos Workspace for creating Dashboards using best practice of Visualization
• Performance Tuning of Reports and Cubes to improve execution time
• Performed Data validations, Unit testing and preparation of Unit test cases

ENVIRONMENT: Cognos 10.2 – (Framework Manager, Report Studio, Transformer), Microsoft SQL Server 2012

PROJECT: J.D. IRVING (CANADA)

• Conducted meetings with Client to understand business requirements
• Developed complex List and Crosstabs based on DMR Model in Sales and Inventory domain
• Assessed Framework Manager to understand data model built for reports and making required modification as per Business user requirement
• Performed Data validations, Unit testing and preparation of Unit test cases
• Developed Cubes in Cognos Transformer for Sales & Equipment domain which will be used by Business Users for Analysis
• Modification of existing Cubes as per User requirements
• Performance Tuning of Reports and Cubes
• Provided production support to IEQ Users and assisted IT Team in resolving issues in Cognos Reports
• Responsible for resolving Service Requests and adhering Service Level Agreement

ENVIRONMENT: Cognos 10.2 – (Framework Manager, Report Studio, Transformer), Microsoft SQL Server 2012, 2008

PROJECT1: ULTRATECH CEMENT

PROJECT2: SOLAS MARINE

• Involved in requirement gathering of Marketing module which includes Finance & Commercial, Sales & Operation, Logistics, Services and Media
• Analyzed specifications provided by clients and developing specification documents for reports (BRD) as per client requirements
• Responsible for creating Matrix for ETL Design
• Responsible for resolving Support Issues and adhering Service Level Agreement
• Participate in meeting with Clients for Support Ticket Status
• Designed ODS Schema for Logistic Module along with ETL Team
• Design and Developed Framework Manager models using Relational tables and published in to Cognos server
• Created cubes in Transformer using Framework Manager packages and Report Studio reports as source
• Used Dimensional modeling (DMR) and Snowflake Schema modeling technique to develop models
• Developed Dashboard reports using Cognos Report Studio
• Developed Reports in Report Studio using MDX Functions
• Implemented Stored procedure and Materialized view in Oracle to improve performance of Reports
• Documented Cognos Report specifications with detailed Database mapping (TSD)
• Reviewed Functional Specifications Document, Technical Specifications Document and Test Cases
• Performed Data validations, Unit testing and preparation of Unit test cases
• Responsible for conducting User Acceptance Test (UAT) of Logistics Module with Business users and resolving issues resulting in UAT
• Trained end users to effectively use Cognos Connection, Business Insight, Business Insight Advanced and Go Office tool to build and customize their ad-hoc reports

ENVIRONMENT: Cognos 8.3 – (Framework Manager, Report Studio

PROJECT: COVIDIEN

• Making changes in model as per business requirements and developing reports
• Updated existing reports as per client requirement
• Preparing and maintaining TSD for each report
• Used advanced conditional formatting in reports as per client requirement
• Responsible for demo to client and training on creating Ad-hoc reporting (Analysis Studio)

• Incident and Problem Management
• Worked on MS SQL Database for internal customers and creation of reports for higher management
• User Management and Administration of applications like PSA (Quick Arrow) and Sales Force
• Password Management, Profile creation, provided solutions to customers in PSFT HRMS 8.9
• Managed to define roles and permissions list attached in PeopleSoft HRMS 8.9
• Adhere to Service Level Agreements
• Training to new joiners