BO
Murali

Professional Summary

  • BI Lead and Consultant with Over Sixteen years of IT experience in developing end to end Data Warehouse systems as an Architect, Data Modeler, BI Administration, ETL Developer, Business Object and Tableau Developer
  • BI and Solution Architect supporting all the phases of Data warehouse Data Modeling, ETL and Reporting
  • More than 13 years of Business Objects experience and 5 years of Informatica experience.
  • Architected and Modeled Business Objects, HANA and Tableau Environment.
  • Tableau Developer and Administrator, Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various version of Tableau 9.2.
  • BO Administrator and Project Lead for the Infrastructure Support project. Installation, Configuration of BI Environments, Data Migration, Support, SSO, Enhancement and Performance Tuning projects.
  • Architected and Modeled HANA and Integrated with BODS and SAP BO, Created Attribute, Analytical and Calculation views.
  • Experience and Hands on in OLAP/OLTP Reporting using different Business Intelligence tools like Business Objects, OBIEE, Cognos, Report net, Crystal Reports XI .
  • Expertise covering end to end business analysis for Clients, Gathering Requirements and working with Business.
  • Experience and Hands-on in Data Analytics using Dash board Visualization tools Tableau, Xcelsius, SAP Lumira.
  • Hands on Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various version of Tableu 8 and 8.1.
  • Experience and Hands-on in ETL tools like Informatica, BODS, SSIS and OWB
  • Experience in Data Quality, Profiling, Cleansing, and Metadata Management using Information Steward.
  • Experience with BIG DATA, Hadoop, HIVE, Data Science with R

Technical Skills

ETL
Informatica, BODS, SSIS, Datastage, OWB
OLAP/Reporting/Dashobard
SAP Business Objects, Tableau8.1(Tableau Desktop,Tableau Server and Tableu Reader),OBIEE, Crystal Reports, Cognos,SAP Lumira, Xcelsius
Tools
BMC Remedy, Quality Center, Cherwell, M.S. Project, Clarity, Clear case, Version One, SharePoint, and Service Now
Database
HANA, Oracle, SQL Server,DB2,Teradata
OS
UNIX, Windows
Softwares
PLSQL, BIG DATA, Hadoop, HIVE, Data Science with R

Education

  • Bachelor of Engineering from Osmania University

Certification

  • ITIL V3 Foundation Certified
  • Scrum Fundamental Certified
  • Scrum Master Certified
  • Banking Journal Certification – Accenture
  • White Papers on Best Practices on Business Objects and Configuration- Accenture
  • PMP Principles (Strong Knowledge)

Professional Experience

Bank of the West (BNP Paribas)
Duration
May 2015 – Current
Role
Informatica / Report developer
Responsibilities
Bank of the West is creating an Enterprise Data Ware House which will be used across the Bank of the West, First Hawaiian Bank and CIB for the Regulatory Reporting at international Holding company level.

  • Senior Developer for ETL and Reporting team.
  • Developed and Maintained using Business Objects WebI and crystal reports for RBG group
  • Developed Multiple Mapping to Load data into the EDW
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
  • Created incremental refreshes for data sources on Tableau server.
  • Creating calculated fields, groups, sets and hierarchies etc.
  • Creating data blending in case of merging two different datasets.
QBE NA
Duration
Oct 2014 – Apr2015
Role
Business Objects /Tableau Lead developer
Responsibilities
QBE provides insurance services mainly to Australia, America, Europe and Asia Pacific region .In NA region, QBE provides insurance for various types of Hazard like Flood, thunderstorm etc., It provides both General insurance and the lender placed insurance The Data stored in Mainframe about Hazard is extracted using SSIS jobs and are loaded into business oriented datamarts and used for information delivery. Our team handles all data platform (data Modelling /database design, data profiling, data scrubbing) and information delivery (support of BOE, design and implementation of BOE security, Universe development, Crystal and Web-I report development) support and activities

  • Lead Developer for Business Objects and Tableau Application for both Development and Production Support team
  • BOE Administrator for all BOE environment across the QBE NA
  • Architected and Modelled the SAP Business Objects environment with multiple clusters.
  • Modeling HANA tables, Creating Attribute, Analytic and Calculation Views in HANA
  • Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Experience in migrating client’s reports from excel(static) based solution to an interactive service.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
  • Installed Tableau Server 9.2 in Dev, QA, UAT and Prod environments.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.
  • Created incremental refreshes for data sources on Tableau server.
  • Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
  • Involved in license management SLA's with Tableau support.
  • Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
  • Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository
Shell(Accenture)
Duration
Aug2013 – Jan 2014
Role
HANA/Business Objects/Tableau Lead Developer
Responsibilities
  • Lead Developer and Architect Business Objects and HANA team
  • Architected and Modeled the HANA environment to integrate with BODS and Business Objects
  • Installing and Configuring HANA and Integrating SAP ECC system with BODS to load data into the HANA Database
  • Modelling the data model in SAP HANA Studio
  • Create Reports using WebI from HANA DB and Dash boards in the SAP HANA Studio
  • Architect UI Interface to Download and Upload files into the HANA tables.
  • Working on different perspectives (Admin, Modelling and Development)
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
Nordea(Accenture) Stockholm Sweden
Duration
Jul 2011 – Oct 2013
Role
Business Objects
Responsibilities
Nordea is a financial services group in the Nordic and Baltic region. Nordea offers online banking and insurance as well as information to investors. Treasury is one of the major part of any bank, Part of Treasury I was leading two applications Liquidity Premium Engine.

  • Lead Developer for both the Development and Production Support team.
  • Created Reports using Business Objects WebI and Admin supporting the existing BOE environment
  • Installing, configuring and administering the Business Objects 4.1 SP1/4.0 SP6 environments and configuring Development, Test and Production cluster environments.
  • Configured and integrated LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).
  • Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.
  • Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).
  • Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
  • Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.
CARGILL(Accenture)
Duration
Nov 2010 – July 2011
Role
Business Objects Lead Developer
Responsibilities
Cargill Is a retail company which produces food items and is spread all over the world, We as a part of Common Application team support the project by monitoring the Incidents through Remedy tool and assign the then to appropriate teams and also work on Installing, Configuring the environments w.r.t to Business Objects XIR3,BODS, Line of Business, Middleware application. Cargill has implemented SAP and we Common Apps team support all the Non SAP Applications associated with the SAP systems

  • Lead Developer for both Development and Production Support teams
  • Sr Developer Lead for Business Objects reports
  • Sr Developer Lead for Business Objects Data Services
  • Integration of SAP system with BOE and creating reports using the Bex queries
  • Installation and Configuration of BOE,BODI and Information Steward environment
  • Created Reports using the Bex queries
  • Configured and integrated LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).
  • Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.
  • Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).
  • Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.
  • Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
  • Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.
  • Admin for No SAP environments supporting( BOE, BODS, Web services, Middleware and many miscellaneous applications)
Edison Mission Market Trading(Accenture)
Duration
Oct 2009 – Nov 2010
Role
Informatica / Business Objects Lead developer
Responsibilities
  • Team Lead for team of 6 resources for Application Development
  • Sr Lead Developer for Informatica Data Loading
  • Sr Lead Developer for Business Objects reports
  • Installed and tested the BI4.0 application on sandbox before moving to live systems and resolved issues accordingly.
  • Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).
  • Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.
  • Created/Administered users/user groups/Security in Supervisor/CMC.
  • Created Profiles in CMC to support to report bursting feature.
  • Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence and Crystal reports in BI 4.0 Launch Pad.
  • Performed the User Training Sessions with Lab sessions on the Data marts, Universes and Reports in respective to the users Business Area.
  • Installed configured the BI4.0 in clustered environment and done sizing according to SAP standards.
  • Expert in creating web intelligence documents using level input controls, merged dimensions, data tracking, open doc and complex filters (query and report level).
  • Developed complex universes by using advanced features like aggregate aware, Derived SQL, LOVs and hierarchies.
  • Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
  • Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.
AT&T (Accenture)
Duration
Sep 2008 – Oct 2009
Role
Business Objects / SSIS Lead Developer
Responsibilities
ATT is one of the Leading Telecom companies in USA, We were leading three major applications IDW Loading, IDW Reporting and Miscellaneous

  • 1. IDW Loading - SSIS
  • 2. IDW Reporting -Unix, SAS, BO XIR3, DB2, Teradata
  • 3. Leading Miscellaneous application for ATT

  • Sr Lead Developer for Business Objects reports and ETL using SSIS
  • Created Mulitple Business Objects Reports
  • Lead Developer to load data into SQL Server using SAS scripts.
Environments
SAS (Scripting), Business Objects 6.5, BOXI Oracle 8i, SQL Server, Teradata, and UNIX
MHRA London UK(Accenture)
Duration
Aug 2007 – Sep 2008
Role
Business Objects Lead Developer
Responsibilities
MEDICINES AND HEALTHCARE PRODUCTS REGULATORY AGENCIES (MHRA) is a Regulatory System in UK . This is Government organization which gives license to any type of The project was performed at the client site from Onsite in UK (London) as most of the work involved more of interaction to understand the client requirement and develop reports for them.

  • Sr Lead Developer on Business Objects
  • Creating of Reports in Business objects (Desktop and Web Intelligence) using universe as a Data source and oracle and lotus notes as databases
  • Creating Universe Classes and Objects, Filters, Prompts and Derived tables
  • Assigning security to Groups ,Folders, Reports
  • Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
  • Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects) that support critical business operations
  • Worked on creating dashboard for multiple reports into a consolidated report for the complete analyzing the customers overall performances in a graphical representations using Desktop Intelligence Reports
  • Testing of Reports ,creating test cases Tracking Defects using Mercury Quality Center
  • Creating Detail Design Document, Documents for Application, Integration and Unit Testing
  • Involved Application, Integration and Unit Testing, Helping with client to perform the UAT
  • Daily interactions with client.
BELLSOUTH(Accenture)
Duration
Jul 2006 – Aug 2007
Role
Business Objects / Crystal Reports Developer
Responsibilities
BellSouth Corporation is a Fortune 100 communications Services Company headquartered in Atlanta, GA, serving more than 45-million customers in the United States and 14 other countries, Bellsouth is now merged with AT&T. We were responsible for all application management ranging from maintenance to development serving all major business areas including: Billing, Wholesale Customer Operations, Network, Shared Services (Enterprise applications), eStore, Technology Enablement and Delivery Excellence.
BBOT is a tool for Bellsouth which handles Reports for Billing and Ordering. We have used BOXI environment to create this tool but generated the reports using Crystal XI R2 . So the reports use universe as a data source. We schedule the reports for the client on their requirement in different formats.

  • Sr Developer creating reports in Business Objects and Crystal XI R2
  • Creating Universe Classes and Objects, Filters, Prompts and Derived tables
  • Creating and Handling Groups, Users and Folders in CMC. Scheduling Reports in CMC and Info view in different formats
  • Assigning security to Groups ,Folders, Reports
  • Importing from one environment to other (Migration of whole environment)
  • Testing of Reports ,creating test cases Tracking Defects using Mercury Quality Center
  • Creating Detail Design Document, Documents for Application, Integration and Unit Testing
  • Involved Application, Integration and Unit Testing
  • Daily interactions with client.

BNPP Paribas(Saama Technologies)
Duration
Business Objects developer
Role
Jan 2006 – July 2006
Responsibilities
Created through the acquisition of the highly respected Greater China equity team of the Peregrine group in 1998, BNP Paribas Peregrine is one of the leading investment banks in the region. The innovative combination of specialized Asian talent, backed by BNP Paribas’ financial strength and global network, provides clients with an integrated range of investment banking services, in-depth knowledge and access to the Asia capital markets.

  • Installation and configuration of Business Objects in Windows 2000 Server (BO Client, Supervisor, Designer, Info view, Web Intelligence, BO Broad casting Agent, WebI SDK)
  • Worked in the applications Report Publishing System and Report Conversion system
  • Desktop and WebI report Development
  • Daily Interactions with Client and gathering requirements
Datamatics Ltd
Duration
Apr 2004 – Jan 2006
Role
Business Objects Developer
Responsibilities
AstraZeneca is a major international healthcare business engaged in the research, development, manufacture and marketing of prescription pharmaceuticals and the supply of healthcare services. Astra Zeneca has implemented Oracle Apps in all there Depots and now are using Business Objects to create Reports. The Project was carried out at the Clients Place in the Bangalore Depot. We have started with two modules of Oracle Apps ie Order Management and Accounts Receivables.

  • Installation and configuration of Business Objects in Windows 2003 Server (BO Client, Supervisor, Designer, Info view, Web Intelligence, BO Broad casting Agent, BO Broad casting Publisher)
  • Tweaking and Deployment of the Rapid Deployment Templates (RDT’s) which come free for the Oracle Apps which are not compatible with the latest version of Oracle Apps 9.5.9 by creating synonyms etc
  • Configuration of IIS server and other BO files for better performance
  • Creating of users and giving them privileges and giving them access rights to their reports w.r.t their Profiles using Supervisor
  • Creating Objects, there aliases, prompts, joins and putting them into contexts using Designer
  • Creating Reports in Business Objects Client and publishing it to view in the Web using info view
  • Publishing of reports to their personal mail ids using publisher I different formats
  • Daily interaction with the users, taking their requirements and adding them to the reports
MANUGISTIC (Datamatics Ltd)
Role
Senior Cognos Developer
Responsibilities
RMS (Revenue Management System) is being developed for CBC, Toronto and Montreal by Manugistics. Manugistics leads other software companies in providing supply chain and pricing solutions to Consumer Goods companies. Reports to be developed using Report Net. RMS needs to support English and French languages, as it will be used by Radio-Canada, Montreal as well.

  • Using Framework Manager for creating Metadata layer
  • Using Cognos IA, Various types of simple reports like Simple List, Grouped List, Drill Down Report, Grouped Cross Tab are created for better analysis.
  • Power Cubes for SHP & GHP were created using Power Play Transformer
  • Reports were published using Power Play for Windows, as per the requirement of Top Management
  • Analyzing the Requirements.
  • Analyzing the models and packages using the Framework Manager
  • Using Report Net Report studio to develop advanced reports.
  • Attending client conference calls on daily basis Leading both AM and AD with a team size of 9 members
  • Working on Estimation, Staffing and Project planning
  • Involved in creation of Functional, Technical Design Document
SPECK SYSTEMS LTD
Duration
June 1999 – March 2004
Role
GIS / Database Developer
Responsibilities
  • GIS and Photogrammetry Engineer
  • Programming in Arc Info
  • Creation of reusable and automated tools
  • Developer for Arc Database in ArcInfo