Angayarkanni Balamurugan

Senior Business Objects Developer-Reporter

adjkac@r.postjobfree.com

adjkac@r.postjobfree.com

MOB:201-***-****

Professional Summary

7+ years of experience in Information Technology with strong work experience as Business Objects Developer.

Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.

Expertise in Business Objects enterprise Products (Universe Designer, Web Intelligence, Info View, CMS) and its deployment.

Experience in creating Ad-hoc reporting using Business Objects Universe Designer.

Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.

Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.

Hands-on experience in developing Analytical Dashboards using Xcelsius.

Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.

Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts including OLAP data and complete lifecycle of project from design to development and implementation.

Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.

Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).

Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result-oriented dedication towards goals.

Experienced in Training & Supporting end-user reporting needs using Business Objects.

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Skills

BO Tools

Business Objects XI 4.1/R3/R2/6.5, Web Intelligence XI 4.1/R3/R2, Information Design Tool, Universe Design Tool, Webi, InfoView, CMC, Import wizard.

Data warehousing

Star-Schema Modeling, Snowflakes Modeling

Databases

Oracle 9i/8i, MS SQL Server 2008/2005

Operating Systems

Windows Server

Dimensional Data Modeling Tools

Multidimensional data modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques

Query Tools

TOAD

Employment History

Jan 2019 - Dec 2019 Senior Business Objects Developer / Data Analyst -USAA, Texas

June 2014 - July 2017 Business Object Developer- Cognizant Technologies Ltd, Chennai, India

Feb 2012 - May 2014 Business Object Developer- HCL Technologies Ltd, Chennai, India

May 2011 - Jan 2012 Consultant, Tata Consultancy Service (TCS), Chennai, India

Project Details

Project 1 :Property and Casualty (P & C) International Project

Period: January 2019 – Dec 2019

Role: Senior BO Developer/ Data Analyst

Domain: Insurance

Client: United State Automobile Association (USAA)

Tools: Business Objects XI 4.1 (IDT/UDT), WebI, Oracle 8i/9i, SAS Enterprise Guide

Responsibilities

Interacted with Business Users to get their Business requirements in developing and modifying Universes and Reports accordingly.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

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 to make the sensitive data secure.

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

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.

Created Xcelsius dashboard reports for the business function.

Troubleshoot errors for Webi 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 Monthly Scheduling of the reports.

Develop new or modify existing SAS programs to extract data from the data store and shared specific datasets to business users depends upon their request.

Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE

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

Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Project 2 : Pfizer ORC Phase 1 Accommodation

Period : December 2015 – July 2017

Role: Business Objects Developer / Reporter

Domain: Healthcare

Team Size: 7

Tools: Business Objects XI 4.1(IDT/UDT), Webi, Oracle 8i/9i.

Responsibilities

Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.

Designed Universes, incorporating all the business requirements.

Implemented object level security universe to incorporate security for sensitive information.

Worked in migration of the universe and reports between environments.

Designed universes, solved loops by creating aliases, contexts and resolved traps.

Created complex variables, breaks, sorts, filters and conditions for various reports.

Created complex reports involving master/detail and crosstab and Combined queries and subqueries

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

Coordinated with DBA and Business objects designer group in solving various technical issues.

Created multiple contexts for catering different functional areas in a single user query.

Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.

Used prompts in the reporter as well as in the universe to create more interactive reports for running different kinds of campaigns.

Generated various report templates for standardizing the reports throughout the organization.

Involved in end user training and documenting the procedures.

Project 3: Pfizer –APAC Sustain Support

Period : July 2014 – November 2015

Role: Business Objects Developer / Reporter

Domain: Healthcare

Team Size: 7

Tools: Business Objects XI R2/R3, Web Intelligence, Universe Design Tool (UDT), Oracle 8i/9i.

Responsibilities:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

Designed several universes and used various methods to optimize queries on database, universe and reporting level.

Worked towards optimal development of universes by removing loops using aliases and contexts.

Creating a Universe with number of Classes, many objects, Derived Tables using inner/outer and equal joins as per requirement.

Created and tested classes and objects to organize the universe.

Exported the universes to the Repository to make resources available to the users.

Created the reports using Business Objects functionality like Queries, Cross Tab, Master Detail and Formulas etc.

Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.

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

Published and scheduled Business Objects Reports to users using Scheduler.

Project 4: PGM-BI/Web Applications

Period : February 2012 – May 2014

Role: Business Objects Developer / Reporter

Domain: Healthcare

Team Size: 5

Tools: Business Objects XI R2/R3, Web Intelligence, Universe Designer Tool (UDT), Oracle 8i/9i.

Responsibilities:

Information gathering - interacted with the end user to understand the requirement and business logic.

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies

Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically.

Customized the list of values (LOV’s) which helps the end users to select the values.

Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance

Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.

Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.

Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.

Scheduling reports from the Broadcast Agent Server to only requested users.

Worked extensively on Web Intelligence for any new requests and performance issues.

Generated reports for web users using Web Intelligence and InfoView.

Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.

Created reports using Desktop Intelligence and Web Intelligence in BO XI R2 environment.

Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.

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

Project 5: Strategic Communications Solution

Period : May 2011 – February 2012

Role: Business Objects Developer / Reporter

Domain: Banking

Team Size: 6

Tools: BO XI R2, Web Intelligence, Universe Designer Tool (UDT), Oracle 9i

Responsibilities:-

Analysis of Business Objects environment, Universes, Reports.

Developed Universe using Designer module in Business Objects.

Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.

Specified the Joins and checked the cardinalities.

Implemented User Objects in Reports and Created Condition in the Universe.

Resolved loops by creating Aliases and Context.

Organized data in reports by using filters, sorting, ranking and highlighted data with alerts

Education

Bachelor in Computer Science

VCE Engineering College (Affiliated to Anna University), Tamilnadu, India

2002 – 2006

Personal Details

Date of Birth

June 16 1985

Gender

Female

Marital Status

Married

Nationality

Indian

Passport

N7519327

Visa

H4 EAD

References

[References are available upon request.]

I hereby declare that above said information is true to the best of my knowledge.

Place: San Antonio, Texas Angayarkanni Balamurugan

Signature

Contact this candidate