SAP Business Intelligence Consultant

OneSource Consulting, Belgium

JUL 2018 – Till date

·         Perform the tasks of running scripts, identifying and troubleshooting scripts and defects. Handle responsibilities of writing test plans and executing test specifications.

·         Worked on Change Data Capture on both SOURCE and TARGET level and implemented the SCD Slowly changing Dimension Type 1, Type 2 and Type 3.

·         Design, Develop and Debug complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.

·         Involved to define the validation rules and bind those rules to against the specific columns.

·         Worked on Defects and CR's during the data loads.

·         Preparation Technical Design documents based on Functional documents.

·         Involved to define the validation rules and bind those rules to against the specific columns.

·         Involved to setup the scorecards and associate the Data Quality dimensions.

·         Develop Information Steward Exception Reports for project.

·         Scheduling reports and notifying 'End Users' when there are exceptions.

SAP Business Intelligence Consultant

Affluent technology , United Kingdom

Client: Penguin Random House

JUL 2016 – MAY 2018

·         Participated in project planning sessions with project managers, business analysts to analyze business requirements and outline the proposed solution.

·         Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

·         Designed and created data extracts for creating BO reports and dashboards.

·         Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

·         Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows.

·         Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.

·         Involved in meetings with functional users, to determine the flat file, Excel layouts, data types and naming conventions of the column and table names.

·         Prepared mapping documents capturing all the rules from the business.

·         Modified existing Store Procedures to accommodate the report changes.

·         Provided technical solutions and fine-tuned long running queries to improve query performance.

SAP Business Intelligence Consultant

ITCAN Pte Ltd, Singapore

Client: Monetary Authority Of Singapore

MAY 2015 – JUNE 2016

·         Worked extensively with the Business Objects Designer in preparing Universes from Information design tool.

·         Resolved loops and Traps problems in the universe, Created Hierarchies for providing drill down.

·         Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.

·         Worked with several features like Query Stripping, Input Controls, Subquery, Scope of Analysis and Drill functionality.

·         Provide transaction oriented accounting and reporting assistance for mergers and acquisitions. Develop and maintain productive working relationships with client personnel.

·         Assisted/guided end users to efficiently use the universes in building the simple and complex reports.

·         Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.

·         Analyzed Mapping sheet and raised Issues in the Issue log if any.

·         Created delta Jobs to load data from legacy source to SAP system based on the business rules provided.

·         Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.

·         Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.

·         Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.

·         Participated in the complete development lifecycle: analysis, design, build and test reports.

·         Interacted with Functional team to fix the load errors at ETL end.

·         Supported in all the phases Dev, QA and Production of Project.

·         Extensively used ETL to load data from flat file and also from the relation database.

·         Ensuring proper Dependencies and Proper running of loads Incremental and Complete loads

·         Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Project Associate

Cognizant Technology Solutions Asia Pacific Pte Ltd, Singapore

Client: Global Foundries Semiconductor

MAY 2013 – APRIL 2014

·         Developed universe user documentation guide for the end users reference and provided training for end users for generating their own report including complicated report.

·         Created reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerters, Ranking and multiple data providers

·         Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.

·         Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.

·         Configured Email notification to Business users when rules refresh happened.

·         Created multiple data store configurations in Data services local object library with different databases to create unified data store.

·         Extensively work on Installations and configure the repositories and establish the data source connections.

·         Participating in all Technical discussions, meetings and mounting the discussion points.

·         Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Table Comparison, case, Validation, Merge, lookup etc. in Data flows

·         Interacted with users to know their business views while gathering the report requirements and provided several report mock-ups and outline the proposed solution by creating proof of content to finalize the requirements.

·         Leading design workshops with Business users in gathering complex reporting requirements in designing BI solutions.

·         Scheduled the jobs, managed users and repositories in Management Console.

·         Drill down the Analytics to the detail level data.

SAP Business Intelligence Consultant

Nityo Infotech Pte Ltd, Singapore

Client: Global Foundries Semiconductor

JUN 2011 – MAY 2013

·         Profound knowledge of Business Objects XI 3.1, solid database query and SQL

·         Extensive knowledge of Universe and Report design and development

·         Thorough knowledge of Data Warehousing methods and technologies

·         Proficient at creating complex Web Intelligence reports

·         Wrote detailed level documentation for reports and universe design.

·         Managed the resources, WEBI users, connections, and the Universe repository.

·         Participated in understanding of source fields and dashboards.

·         Created multiple reports using various complex courses and linked these reports with Combined Queries, Slice and Master Detail.

·         Experience in Training & Supporting Business User reporting needs using BusinessObjects

·         Participated in detailed report design and created design specifications documents at report level.

·         Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.

·         Sound understanding of end to end Data Migration process including Extraction, Data Profiling, and Transformation and Generation of Load ready data files in LSMW format.

·         Ability to interpret, configure and implement data mapping / transformation business rules into Data Services

·         Analysed Mapping sheet and raised Issues in the Issue log if any.

·         Worked on Defects and CR's during the data loads.

·         Created delta Jobs to load data from legacy source to SAP system based on the business rules provided.

·         Analysed the error log for trouble shooting batch jobs.

·         Interacted with Functional team to fix the load errors at ETL end.

·         Supported in all the phases Dev, QA and Production of Project.

SAP Business Intelligence Consultant

Goldtech Resources Pte Ltd, Singapore

Client: Eli Lilly

JAN 2010 – FEB 2011 

·         Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.

·         Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.

·         Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.

·         Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.

·         Providing support for the users on application usage and conducting training walk through of salient features of the application.

·         Built customized Mobile reports for sales representatives to access their key sales and marketing data, and to meet the needs of their business role, see how well they are tracking against a predefined set of KPIs, and perform the advanced analytics they need in order to facilitate better business decisions.

·         Involved in all phases of Software Development Life Cycle SDLC including requirements gathering, preparation of technical specifications, designing and developing universes/reports, unit testing and UAT.

 SAP Business Objects Consultant

ITCAN Pte Ltd, Singapore

Client: Network for Electronic Transfer(NETS)

AUG 2008 – DEC 2009

 ·         Working on the SQL tuning and optimization of the Business Objects reports.

·         Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

·         Designed and maintained complex Universes, resolved loops by creating aliases and contexts.

·         Exported the ad-hoc ready universes to the for making semantic layer available to the users.

·         Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.

·         Created and defined the Hierarchies for various reports based on the Business rule of the Organization.

·         Interacted with the Business Users to analyze the business process and gathered the requirements.

·         Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

·         Responsible for creating Query as a Web Service objects to connect data to the dashboard model.

·         Involved in Universe and Report enhancements, Performance Tuning.

 SAP Business Objects Consultant

Solderfield Pte Ltd, Singapore

Client: OCBC Bank

MAR 2008 – JULY 2008

 ·         Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.

·         Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.

·         Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.

·         Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.

·         Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.

·         Extensive testing and migrating the reports or objects from development to Production system.

·         Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.

SAP Business Objects Consultant

ISoftTek, India

Client: Roche Chemicals

MAR 2007 – FEB 2008

·         Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries

·         Linked multiple data-providers and Used calculation contexts/extended contexts

·         Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.

·         Scheduled pre-canned reports through Scheduler for distribution and printing.

·         Created reports for various Portfolios using the Universes as the main data Providers.

·         Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.

Software Developer

GSS, India

Client: Gems Sugars

MAY 2005 – FEB 2007

·         Generated reports for web users using Web Intelligence and Info View.

·         Created Web Intelligence documents and published them to corporate documents.

·         Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.

·         Migrating Business Objects 6.5.1 version reports to new version XIR2.

·         Converted the existing full client reports to WebI reports using Report Conversion Tool.

EDUCATION

Master of Computer Applications Administration – 2002-2005

Bachelor of Business Administration 1998-2001

EXPERTISE

Reporting Tools                                       

SAP Business Objects 4.1, Crystal Report XI, Info view, CMC, Bex Query, Desktop Intelligence, Web Intelligence.

BI Dashboards

SAP Lumira, SAP Business Objects Dashboards, Design Studio, QlikView, Qlik

Sense..

Database & Data Modelling Tools

Oracle Sql, Pl/Sal, MySQL, SQL Server, Transact SQL, Netezza. Oracle SQL Developer Data Modeler, Toad , Netezza.

ETL Tools

DataStage

SAP BusinessObjects Data Services

Project Methodologies

Agile Software Development

Waterfall

Software Development Life Cycle (SDLC)

Services

Change Management

Root-Case Analysis

Defect Management

KPI Reporting