Preethi Manoharan

+1-408*******

( acn1hg@r.postjobfree.com

Professional Summary

> Over 6+ Years of experience in the areas of analysis, design and

development of Business Intelligence solution using Tableau, Business

Objects reporting tools.

> Partnered with Business stakeholders and executives with the goal of

providing them with the ability to make decisions and gain insights

through data visualization reports and operational reports.

> Experience in building prototypes for demonstration and illustration

purposes for Business partners and senior leaders

> Developed dash boards with rich Graphic visualizations, Drill Down and

Drop down menu options, Parameterized using Tableau.

> 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 reports

and dashboards using KPI'

> Provided technical and analytical expertise in responding to complex,

specialized report requests requiring complex business logics and detail-

level data analysis.

> Administered user, user groups, and scheduled instances for reports in

Tableau

> Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin,

creating users, sites and projects

> Hands-on development assisting users in creating and modifying

worksheets and data visualization dashboards in Tableau.

> Worked in Business Intelligence Reporting tools like SAP Business

Objects XI R4 (Universe Designer Tool, Information Design Tool,

Dashboards, Explorer), XI R3/XI R2 (Universe Designer, Webi, CMC).

> Extensively used various features like Joins, Alias and Contexts in

Universe designer to overcome various traps (Chasm, Fan) and Loops.

> Independently perform complex troubleshooting, root-cause analysis and

solution development

> Extensive experience in PL/SQL and SQL and in performance tuning SQL

queries in TOAD.

> Strong database experience in using Oracle 10g/Sql Server

> Ability to meet deadlines and handle multiple tasks, decisive with

strong leadership

qualities, flexible in work schedules and possess good communication

skills.

> Team player, Motivated, able to grasp things quickly with analytical and

problem solving skills

> Unique combination of personal, analytical, technical and communication

skills.

Technical Skills

Tools : Tableau 8,Business Objects 4.0/XI 3.1, Xcelsius

Databases : Oracle 10g/9i,Sql Server

Operating Systems : Windows Server 2003/2000/NT, Windows Vista/

XP

Windows Utility : MS-Word, MS-Excel and MS-PowerPoint.

Programming Languages : SQL, PL/SQL, JAVA, HTML

Query Tools : TOAD, SQL*PLUS

Work Experience

Tableau Developer GSK, NC

Jan 2013 - Dec 2014

The primary IT systems to support all experimental Product Development

effort across GSK - which includes BioPharm BioProcess Development and PTS

Chemical Development, Pharmaceutical Development, and Clinical Trial

Responsibilities

> Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications .

> Implemented Tableau BI Dashboard reporting solution for different

groups in the organizations

> Effectively used data blending feature in tableau to get data from Sql

Server & MS Excel

> Converted WEBI Reports to Tableau Dashboards for Advanced

Visualizations

> Created Tableau Scorecards, dashboards using stack bars, bar graphs,

scattered plots, geographical maps, Gantt charts using show me

functionality.

> Executed and tested required queries and data before publishing

Dashboard

> Created action filters, parameters and calculated sets for preparing

dashboards and worksheets in Tableau.

> Created complex data Views Manually using multiple measures, also used

sort, Filter, group, Create Set functionality.

> Mastered the ability to design and deploy rich Graphic visualizations

with Drill Down and Drop down menu option and Parameterized using

Tableau.

> Worked creating Aggregations, calculated Fields, Table calculations,

Totals, percentages using Key Performance Measures ( KPI) and

Measure .

> Worked in Tableau environment to create dashboards like weekly,

monthly, daily reports using tableau desktop & publish them to server.

> Working on the SQL tuning and optimization of the Business Objects

reports.

> Designed and maintained complex Universe, 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.

> 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

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.

> Extensive testing and migrating the reports from development to

Production system.

> Developed testing scripts and test cases.

Business Object Developer Cardinal Health, India

Apr 2011 - Dec 2012

Cardinal Health is a recognized leader in IV infusion delivery systems

and provides a range of disposable products for use with infusion systems

and for a wide range of IV therapy procedures. The Alaris Products (syringe

pumps, volumetric pumps, and Guardrails Suite of safety software

applications) offers the very best in safety-first infusion systems.

Responsibilities

> 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.

> Designed and maintained complex Universes, resolved loops by

creating aliases and contexts.

> Exported the ad-hoc ready universes 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.

> 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

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.

> Extensive testing and migrating the reports or objects from

development to Production system.

> Developed testing scripts and test cases.

Business Object Developer Northwestern Mutual, India Jan

2010 - Mar 2011

Northwestern Mutual is the largest direct provider of individual life

insurance in U.S.The Northwestern Mutual provides two types of Products

namely Insurance Products (Life Insurance Policy, Disability Insurance

Policy) and Investment Products (Mutual Funds, Annuities).

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.

> Designed universes, solved loops by creating aliases, contexts and

resolved traps.

> Created complex variables, breaks, sorts, filter and conditions for

various reports.

> Created complex reports involving master/detail and cross-tab and

Combined queries and sub-queries

> 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 kind of campaigns.

> Extensively used scheduler for report scheduling and deployment

> Generated various report templates for standardizing the reports

throughout the organization.

> Scheduled pre-canned reports through Scheduler for distribution and

printing.

Business Object Developer S&P,India

Apr 2008 - Nov 2009

The Major Objective of Economic Data System (EDS) is to develop a

reporting system to help the S& P Analysts, for analysis of the demographic

statistical information. The application consists of static reports of the

information, providing comparative views at State, City, County and School

district levels compared against themselves and against US Country level

data. The source data for this reporting system was provided by a 3rd party

vendor and routed through S&P's standard Feeds platform. The reports

were generated against the warehouse

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.

> Created Condition in Universe.

> Ad-hoc reports were used for Business Objects user modules for various

portfolios using the Universes as the main Data providers.

> Resolved loops by creating Aliases and Context.

> Organized data in reports by using filters, sorting, ranking and

highlighted data with alerts.

Education

Bachelor of Engineering in Computer Science

Contact this candidate