+1-971-***-**** • ac33eh@r.postjobfree.com

MUTHUMALA SHANMUGASUNDARAM

Summary

Resourceful, Innovative and Self-motivated BI Developer with proven leadership skills and overall experience of 5 years. Highly reliable team player with impeccable ability to lead any project and team. Areas of expertise includes BI Reports, Application support and development, BO Administration, Project Management and Infrastructure Management (Incident, Change and Problem).

Professional Experience

Company

Position

Period

Wipro Technologies, Bangalore, India

Senior Software Engineer

Oct 2007 - May 2012

Academic Profile

Degree / Specialization

University

Year of Passing

MS in Software Engineering

Birla Institute of Technology and Science, Pilani, India

2012

BCA – Bachelor of Computer Application

Bharadidasan University, Trichy, India

2007

Technical Skill Set

Business Intelligence

Business Objects Business Intelligence 4 Platform, Business Objects XI 3.1/XI R2/XI/6.5/6.1/6.0/5.1, Supervisor, Designer, Reporter, BO Auditor, Info view, Launchpad, CMC, CCM, Desktop Intelligence, Web Intelligence, Crystal Reports, Designer, Universe Builder, Import Wizard, Publishing Wizard, Translation Manager, Report Conversion Tool, Life Cycle Manager, Query Builder, Tableau Desktop

Business Analysis

Business Requirements Gathering, Requirements Analysis & Design, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Data Modeling, Data Architecture

Dimensional Data Modeling

Dimensional Data Modeling, Star Schema, Snowflake, FACT and Dimensions Tables, Physical and Logical Data Modeling

RDBMS

Oracle 10g/9i/ 8i, SQL Server 2000/2005

Query Tools

TOAD, SQL*PLUS, SQL*Loader, SQL Navigator

Others

Datawarehousing

Achievements

Wipro Technologies Ltd.

Year

Pinnacle award for Best Performer of the year (Business Intelligence Horizontal)

2010

Feather In My Cap award for Best Performance in project

2009, 2012

Project Experience Details:

Organization: Wipro Technologies Ltd (Oct 2007 – May 2012)

1

Project Name

ASSAI

Period

Jan 2008 – May 2012

Client

Shell

Location

Bangalore, India

Description

ASSAI software is an integrated document management system for engineers, planners and managers which gives it’s users the ability to have full control and revision capabilities of their document. The project involved pulling reports based on documents and information in ASSAI and according to business requirements.

Role

Project Lead & BO Administrator/Developer

Responsibilities

Interacted with Business Users and Business Owners to gather requirements

Analyze and document requirements and data specifications which is used to develop Business Objects Universes and Reports

Created more than 500 reports for many projects inside ASSAI

Worked on SQL tuning & optimization of BO reports

Created the Web Intelligence Report and Scheduled Reports

Secured sensitive data using security features of BO (Row, Report & Object) and defined Hierarchies based on Organization charts

Diagnosed and fixed errors of reports, dashboards, and universes

Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the BO Universes

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

Administration of BO including setup of users and groups

Migration of reports & objects during version and environment upgrades

Extensively tested BO reports, dashboards & other BO Applications post migration

Developed functional and performance test cases and test scripts

Analyze performance test results and diagnose and fix performance issues

2

Project Name

Business Objects Competency Centre

Period

Jan 2010 – May 2012

Client

Shell

Location

Bangalore, India

Description

Business Objects Competency Centre is a BO center of excellence which runs shared Business Objects environment for many of the SHELL applications which have the BO as their major reporting function

Role

BO Administrator

Responsibilities

Handling Content, Server and Users/Groups management activities in different Environments including Production

Installed, configured and maintained BOXI3.1 in all environments servers

Configured Vintella Single-Sign-On on all BOCC environments

Configured BO environment settings which includes Creating Security Templates for Top Level Security, BO Servers/Services, Destinations, Timeout settings, etc.

Secured projects to their users and groups depending on Access Control List

Researched on CMS clustering of BO & installed and implemented CMS clustering in all environments including Production

Completed Functional and Performance Tests post clustering implementation

3

Project Name

Livelink Phase 2 Support

Period

Apr 2009 – Jan 2012

Client

Shell

Location

Bangalore, India

Description

Livelink is a Web-based application for storing, sharing, and distributing information. It provides a collaborative work environment that helps your organization manage documents/project information, improve business processes, and share information. The project involved pulling reports based on information in Livelink and according to business requirements.

Role

BO Developer

Responsibilities

Worked successfully on all Data warehouse development and project issues

Responsible for ETL enhancements and changes

Involved in Universe modifications

Developed and tested new BO Reports

Provided Level 2 Production Support for BO Operations

Gathered BO requirements from ETL team

Regular updates on progression to the clients and onsite team

Prepared the WebI report standard guideline document

Managed development environment to support the development activities

4

Project Name

Records Management System

Period

Aug 2009 – Sep 2010

Client

Shell

Location

Bangalore, India

Description

Records Management System (RMS) is a pilot project for the storage and management of Records. In this project, data from different record management applications like Livelink, TRIM, EPCatalog and Orchestra are stored in a centralized data warehouse. The project involved pulling reports based on information in RMS.

Role

BO Developer

Responsibilities

Maintained and managed ETL Process Scripts

Supported Universe and provided minor enhancements

Creation of the ad hoc reports and provided enhancement to reports

Regular updates on issues and resolutions to the clients

Development of new BO XI R3 Reports

5

Project Name

Enterprise Portfolio Management System

Period

Jan 2008 – Jul 2009

Client

Shell

Location

Bangalore, India

Description

E-PIMS (Enterprise Portfolio Management System) provides one central repository for the businesses to view report on and maintain data on their application portfolio and installed instances both locally and globally. The project involved pulling reports based on information in E-PIMS and according to business requirements.

Role

BO Developer

Responsibilities

Supported Universe and provided minor enhancements

Develop BO reports

BO Administration

Work Permit Status:

Green Card Holder

References:

Available on request

Contact this candidate