+1-971-***-**** • *********.********@*****.***
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