Jayanth Prabhu BM

ac4eum@r.postjobfree.com Ph:732-***-****

Summary - Senior BI Lead ( Business Objects & Tableau)

I have 9+ Years of experience in implementing data warehouse solutions using SAP Business Objects (4.1, 3.1, XI R2, 5.1 and 6.5) and Tableau 8.1 BI tools for Banking and Financial Services, Retail, Health Care and Media.

Extensive experience on building dashboards in Tableau 8.1 and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.

Full life cycle implementation including Design of universe and Report Development.

Extensive experience on building dashboards in Tableau 8.1 and Involved in performance tuning of reports

And resolving issues within tableau server and reports

Full life cycle implementation including Dashboards and KPI’s in Crystal Xcelsius.

Extensively Worked on Web Intelligence, Desktop Intelligence Report and Crystal Reports

Involved in POC Dashboard by using Qlikview BI tool, Tableau and Crystal Xcelsius (Business Objects)

Experience in creating the Universe in the Information Design Tool (IDT) and Universe Design tool (UDT)

In depth Knowledge of SAP Business Intelligence 4.1 (IDT, BI Launch Pad (Webi), LCM and Import Wizard)

Experience in scheduling the Webi & Deski reports and new user creation in CMC.

Expertise in implementing, migrating and maintaining Business Objects modules both full-client modules (Business Objects XIR2/R3 and BO 4.1, Designer, Desktop intelligence, Webi reports and Central Management Console) for user Community and server-side modules (Web Intelligence).

Expertise in migrating from Business Objects 5.x/6.x to XIR2, XI 3.1and BO 4.1.

Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.

Expertise in Building Variables & Formulas in Reports. Creation of derived tables, context and resolved loops in Universe design.

Effective skills in Dynamic Xcelsius Dashboards in SAP Dashboards BI 4.0 and Xcelsius using BI services,QAAWS and Live office. Expertise in building reports with Xcelsius Dashboard Components like Charts, Selectors, Prompts, Filters, Tab sets, Canvas Containers.

Extraction, Transformation and Loading (ETL) of data by using Informatica 8.1 and Datastage 8.

Involved in high-level/Data modelling/BI Design/ETL Design/data warehouse process and Development.

Worked in Informatica 7.1,8.1 and Datastage 8 and created lot of mapping and fined tuned existing mapping

Co-ordinate for smooth implementation of the project at client location. Extend post-implementation, application maintenance and technical support to the client.

Client interaction for requirement gathering, risk assessment, finalization of technical specifications.

Implementing projects, end to end testing and technical assistance to UAT (user acceptance team).

Technical Skills

Business Intelligence (BI) Tools:

SAP Business Objects 4.1, XI R3.1,XI R2, Information Design Tool and Designer, Desktop Intelligence and Web Intelligence(Rich Client), Crystal Reports 2008/2011, Dashboard Design (Xcelsius) 2008 and Qlikview 11.2,

Tableau 8.1

ETL

Informatica 8.1, Datastage 7.5

Languages:

SQL, PL/SQL

Database/ Database Tools:

Oracle, MS SQL Server, IBM Netezza, Teradata, Faricom and TOAD

Operating Systems:

Windows9x/NT/XP/Vista/7/Unix

Professional Experience

Univision Media – Financial Reporting Optimization Teaneck, New Jersey, US

Senior Business Objects Developer Lead Sep 2014 – Till date

PROJECT DESCRIPTION:

Univision Financial Reporting Optimization we receive data from Oracle EBS (Oracle AR/GL Financials), Traffic Systems (VCI, OSI, MKT, etc.), ERP and Sales/Marketing, CRM (Salesforce.com), third party data from Kantar (TNS) and use this data to do reporting for the financial user relating to forecasting and quarter end calculation, Revenue determination etc. In the New data warehouse they integrate different source of data into Teradata by using ETL (Informatica) build the datamarts. Business intelligence take source from the Teradata ODS (Operating Data Source.

CLIENT DESCRIPTION:

Univision is an American Spanish language broadcast television network that is owned by Univision Communications. The network's programming is aimed at Hispanic Americans in the United States; its programming includes telenovelas and other drama series, sports, sitcoms, reality and variety series, news programming, and imported Spanish-language feature films. It has the largest audience of Spanish-language television viewers in the world, according to Nielsen Media Research. Univision is headquartered in New York City,[1] and has its major studios, production facilities, and operations in the Miami suburb of Doral, Florida.

ROLES AND RESPONSIBILITIES:

Interacting with Business team to gather the reporting requirements. Involved in discussion with architecture team for the reporting data mart model

Worked extensively with the Business Objects universe in IDT (information Design Tool) from the Data marts.

Design and Development of universes and reports in Business Objects 4.1 (Information Design Tool, Web Intelligence using BI Launchpad).

Work extensively in Alias and Context using new functionality Families in IDT.

Extensively worked in the Hierarchy and Navigations in the IDT.

Extensively worked in the Security Manager in IDT for User and Group level Securities.

Design and development of BI reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Created complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks etc. for a high visibility project called Viewpoint.

Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.

Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.

Migration of reports to different environments and publishing to business users daily, weekly and yearly basis. Creation of Adhoc & Canned reports on a need basis for customer. Creation of reports with key Metrics of data.

Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures

Created a solution design for new process and developing PL/SQL packages and Views to bring data from data marts to Business objects Schema in Teradata database.

Assign work and provide technical oversight to onshore and offshore developers.

Delivering and releasing the project deliverables to the customer.

Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables

Environment: Business Objects 4.1, 3.1 and Crystal report 2008, Teradata.

Univision Media – Financial Reporting Optimization Teaneck, New Jersey, US

Senior Tableau Developer - Lead Jan 2015 – March 2016

PROJECT DESCRIPTION:

Univision Financial Reporting Optimization we receive data from Oracle EBS (Oracle AR/GL Financials), Traffic Systems (VCI, OSI, MKT, etc.), ERP and Sales/Marketing, CRM (Salesforce.com), third party data from Kantar (TNS) and use this data to do reporting for the financial user relating to forecasting and quarter end calculation, Revenue determination etc. In the New data warehouse they integrate different source of data into Teradata by using ETL (Informatica) build the datamarts. Business intelligence take source from the Teradata ODS (Operating Data Source.

CLIENT DESCRIPTION:

Univision is an American Spanish language broadcast television network that is owned by Univision Communications. The network's programming is aimed at Hispanic Americans in the United States; its programming includes telenovelas and other drama series, sports, sitcoms, reality and variety series, news programming, and imported Spanish-language feature films. It has the largest audience of Spanish-language television viewers in the world, according to Nielsen Media Research. Univision is headquartered in New York City,[1] and has its major studios, production facilities, and operations in the Miami suburb of Doral, Florida.

ROLES AND RESPONSIBILITIES:

Understanding existing business model and customer’s new requirements.

Created workbooks and Dashboards using calculated metrics for different visualization requirements

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Created dashboard views from provider information data to members

Extensively created visualization dashboards for the claims

Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, Ipad)

Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance

Created extensive custom joins for blending data from several different data sources

Helped customize Tableau Server with Company Logo and Company Pop-Ups

Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users in Tableau dashboard development

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.

Assist business users in developing/ executing complex queries/ reports using Analysis studio, Query Studio

Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.

Created a proof of concept for the optimal data integration process.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.

Designed high-level view of the current state BCBSA files, leads, and website activity 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 report and Dashboard using KPI’s

Created workbooks and Dashboards using calculated metrics for different visualization requirements

Environment: Tableau Desktop 8.1, Tableau server / Administrator, Informatica Powercenter 9.1, Teradata DB

Walgreens – Business Planning and Net Margin Project Chicago, Illinois, US

Senior Business Objects Developer Lead May 2014 – Sep 2014

PROJECT DESCRIPTION:

Walgreens Retail – Net margin and Business planning projects holds all the key metrics that are contributing to net margin reporting system. Identify the impact on current Business Objects reports due to the zoning changes and the changes in the universe / reporting layer and the data source. Implementing the changes identified BO Reports compatible with zone changes. Setting up the development and production environment in BI 4.1 and its complete Re- write projects to develop the complete Business Planning and Net Margin Application built based on the Netezza database in newly setup BO 4.1 Environment.

CLIENT DESCRIPTION:

The Walgreen Company (Walgreens) is the largest drug retailing chain in the United States. Walgreens provides access to consumer goods and services, plus pharmacy, photo studio, health and wellness services in the United States through its retail drugstores, Walgreens Health Services division, and Walgreens Health and Wellness division.

ROLES AND RESPONSIBILITIES:

Interacting with Business team to gather the reporting requirements. Involved in discussion with architecture team for the reporting data mart model

Worked extensively with the Business Objects universe in IDT (information Design Tool) from the Data marts.

Design and Development of universes and reports in Business Objects 4.1 (Information Design Tool, Web Intelligence using BI Launchpad).

Work extensively in Alias and Context using new functionality Families in IDT.

Extensively worked in the Hierarchy and Navigations in the IDT.

Extensively worked in the Security Manager in IDT for User and Group level Securities.

Design and development of BI reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Created complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks etc. for a high visibility project called Viewpoint.

Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.

Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.

Migration of reports to different environments and publishing to business users daily, weekly and yearly basis. Creation of Adhoc & Canned reports on a need basis for customer. Creation of reports with key Metrics of data.

Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures

Created a solution design for new process and developing PL/SQL packages and Views to bring data from data marts to Business objects Schema in IBM Netezza database.

Assign work and provide technical oversight to onshore and offshore developers.

Delivering and releasing the project deliverables to the customer.

Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables

Environment: Business Objects 4.1, IBM Netezza and Aginity Workbench.

Bank of New York Mellon – SUMO Report Modernization King of Prussia, PA, US

Senior Business Objects Developer – Lead July 2013 – Apr 2014

PROJECT DESCRIPTION:

BNY Mellon – EIS SuRPAS Report Modernization is a shareholder accounting system used for wrap, sub-accounting and transfer agency. The application runs on VMS platform and the core of the application is in FORTRAN. Application uses file structures as data storage. SuRPAS as an application caters to multiple clients. There are separate instances of the applications for each client; each instance consists of its own SuRPAS interface, core (processing rules) and data files storage. SuRPAS data files are the source for the reporting. Reports are directly pulled out of these files UDMS; some are pulled out of UDS, which is updated with extracts from of these files. All the clients databases uses standard System File layout of SuRPAS to store data.

CLIENT DESCRIPTION:

The Bank of New York Mellon Asset Servicing offers clients world-class products, technology and service to help enhance the management, administration and oversight of their investment process by giving them the tools and information they need to make better decisions. The firm is one of the world's leading securities services, with more than $23 trillion in assets under custody and administration. They provide expertise in Accounting Services, Custody Services, Fund Services, Hedge Fund Administration, Outsourcing Services, Performance Measurement & Analytics, Plan Services, Securities Clearance & Collateral Management, Securities Lending, and Technology Solutions.

ROLES AND RESPONSIBILITIES:

Interacting with End users to gather the reporting requirements. Involved in discussion with architecture team for the reporting data mart model

Worked extensively with the Business Objects Designer in preparing Universes from the Data marts.

Design and Development of universes and reports in Business Objects XI 3.1 and 4.1 (Universe Designer and Information Design Tool, Web Intelligence).

Design and development of BI reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Created complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks etc. for a high visibility project called Viewpoint.

Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.

Worked on the environment migration using the Import Wizard.

Worked as an Administrator in creating users, folders and managed the access privileges in Central Management Console.

Extensively implemented the Manager level security in the universe layer for 58 clients groups

Involved in taking a backup on weekly basis stored in the BIAR file.

Involved and supported the Migration process for Business Objects XI 3.1 to BO 4.1.

Perform Unit testing, System Testing and User Acceptance Testing for Universe, Reports and Security Management.

Also created a lot of Xcelsius dashboards by using QaaWS (Query as a Web Service) concepts.

Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using advanced Charts of Crystal Reports 2008.

Worked extensively as BO Administrator by Creating New Users and groups and Setting up user security using Central Management Console.

Migration of reports to different environments and publishing to business users daily, weekly and yearly basis. Creation of Adhoc & Canned reports on a need basis for customer. Creation of Dashboards with Metrics data.

Created a solution design for new process and developing PL/SQL packages to bring data into warehouse.

Assign work and provide technical oversight to onshore and offshore developers.

Delivering and releasing the project deliverables to the customer

Environment: Business Objects XI 3.1 and BO 4.1, Crystal Xcelsius 2008 and Faircom.

Bank of New York Mellon – AMI London, UK /Chennai

Business Objects Senior Developer Dec 2009 – July 2013

PROJECT DESCRIPTION:

AMI D3 acts as an “Information Glue” that holds information from various sources and creates a “Single Version of Truth” across various LOB in AMI, since the required logic has been placed in the Informatica layer. Automated Integration of data from 30 flat files and 50 tables from Oracle and DB2 using Informatica and provided Interactive reports using Business Objects Enabled business users to focus more time on their productive activities rather than on routine administrative tasks by developing a warehouse holding the aggregated data. Made information available to the users in the form that is usable and actionable at the time when it is needed most by generating various BO reports from the warehouse

CLIENT DESCRIPTION:

Established in 2007 from the merger of Mellon Financial Corporation and The Bank of New York Company, Inc., The Bank of New York Mellon is a leading asset management and securities company, uniquely focused to help clients manage and move their financial assets and succeed in the rapidly changing global market place. Headquartered in New York, The Bank of New York Mellon has more than $20 trillion in assets under custody or administration and more than $1 trillion under management. Today the Bank of New York Mellon has 40,000 employees, more than one quarter of which is located outside the United States. The company serves more than 100 markets through a global presence in 34 countries establishing it as a truly global provider to a truly global clientele. For over 100 years they have been serving clients around the world, and so developed a deep understanding of how global markets ebb and flow.

ROLES AND RESPONSIBILITIES:

Coordinate with user to gather the reporting requirements.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Extraction, Transformation and Loading (ETL) of data by using Informatica.

Extracted source data from flat files, Oracle and loaded to Dimensions in Oracle.

Developed mappings in Informatica Designer to load data into Dimension.

Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, lookup and sequence generator.

Involved in performance tuning of mappings, identifying source and target bottlenecks and worked with the session’s properties to improve performance.

Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.

Fine-tuned universes and reports by creating aggregate tables and filters.

Design and development of BI Adhoc reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. Worked on Webi reports, Prompts and Report Layout and re-formatting.

Resolved loops and Traps problems in the universe, Created Hierarchies for providing drill down options for the end-user and developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.

Participated in business requirements analysis, report designing and modelling, development of technical specifications, testing and Implementation.

Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration by maintaining the Users and Groups

Worked extensively with (@select, @aggregate aware, @where and @prompt functions in the Business Objects universe layer.

Reports are made user friendly by implementing user prompts, conditions and filters.

Created various reports with functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.

Developed dynamic Crystal Xcelsius using Query as Web Services and Web Services Connector.

Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.

Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.

Environment: Business Objects XI 3.1 Crystal Xcelsius 2008, Informatica 8.1 and Oracle 11 G.

Mercator- EDI, Well Point client, USA Chennai, India

Business Objects Developer Oct 2009 – Dec 2009

PROJECT DESCRIPTION:

WellPoint, Inc. is an Indiana-domiciled, publicly traded company that, through its subsidiary companies, provides health care benefits to millions of people. WellPoint is the largest publicly traded health benefits company in the United States and an independent licensee of the Blue Cross and Blue Shield Association. Anthem, Inc. and WellPoint Health Networks Inc. completed the merger on Nov 30th 2004. Anthem, Inc., the corporate parent, has been renamed WellPoint, Inc., and WellPoint, Inc. now serves approximately 34 million medical members through its Blue Cross or Blue Cross and Blue Shield operations in 14 states and its non-Blue branded operations in other states.

ROLES AND RESPONSIBILITIES:

Design, develop and deploy OLAP reports for health care information analysis across regions. This Data mart provides comparison reports across regions / Time periods for sales channels.

Interacted with Onsite / Business Users to know their requirements in developing and modifying Universes and Reports accordingly.

Designed and Built the Universes, Classes and Objects.

Involved in translating these requirements into system Solutions and developed implementation plan and schedule.

Specified the Joins, checked the cardinalities and defined Cardinality based on the Business Requirements.

Fine-tuned the joins avoiding outer joins and implementing shortcut joins.

Improved the performance by resolving loops using Aliases or Contexts.

Created different types of reports such as Master/Detail, Cross Tab and Charts.

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

Good experience in working with Ranks, Alerts, Filters, and Prompts on reports.

Involved in the Report bursting of reports to base on the user Lobs

Extensively worked with multiple data providers and linking these data providers based on the requirements.

Published and retrieved documents in corporate repository.

Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.

Performing the unit testing of the universes after the development.

Environment: Business Objects XI R2, DataStage 7.5 and Oracle 10 G.

Sara Lee Corporations, Illinois USA Chennai, India

Business Objects Developer Oct 2008 – Oct 2009

PROJECT DESCRIPTION:

Sara Lee Corporation is a global manufacturer and marketer of high-quality, brand-name products for consumers throughout the world. Sara Lee Corporation's leading brands are household names known around the globe. Our preeminent brands are built on consumer needs and expectations, offering exceptional quality and value. Sara Lee has several products division as Coffee, Bakery, Meat and etc., and in its each division they have separate data marts built top of it to generate Business Intelligence report. In the Bakery division they had built a data mart by Datastage (ETL) tool and for its reporting they implemented Business Objects and Info view for Web interface

ROLES AND RESPONSIBILITIES:

Interacted with the End Users and Business Analysts and responsible for defining the reporting requirements.

Designing, creating, enhancing, and testing of universes and reports.

Responsible for Business Analysis and Requirements Collection.

Worked on DataStage tools- Designer, Parsed high-level design specification to simple ETL coding and mapping standards.

Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Maintained stored definitions, transformation rules and targets definitions.

Developed mapping parameters and Created container to use them in different mappings.

Developed mappings to load into staging tables and then to Dimensions and Facts.

Used existing ETL standards to develop these mappings

Design and development of BI reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. Development of Business Object Universe from the requirements provided.

Created different types of reports such as Master/Detail, Cross Tab and Charts.

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

Good experience in working with Ranks, Alerts, Filters, and Prompts on reports.

Extensively worked with multiple data providers and linking these data providers based on the requirements.

Created reports on the using Business Objects Desktop Intelligence.

Perform Unit testing, System Testing and User Acceptance Testing for Universe, Reports and Security Management. Delivering an releasing the project deliverables to the customer

Used Business Objects Designer to create universes containing complex dimensions, measures, conditions and prompt objects to be used in Business Objects and Application Foundation.

Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.

Developed standard and procedures and change control document templates for BO.

Training and motivating user’s community and IT team in BO XI basic and advanced reporting skills, universe designing and establishing BO environment.

Environment: Business Objects XI R2, DataStage 7.5.1, Windows 2000 and Oracle 9i.

St James Place, London UK Chennai, India

Business Objects Developer Mar 2008 – Sep 2008

PROJECT DESCRIPTION:

The St. James's Place Group offers a wide range of high quality wealth management services to businesses and individuals. With over 400,000 clients and £17.2 billion funds under management, we are well established as one of the UK's leading wealth management organizations. At the heart of our business is the St. James's Place Partnership, which brings together some of the most experienced, able and highly-regarded professionals working in financial services today, with an average of 17 years in the industry. We built a reporting service to the clients to get track of the investment and forecasting trends, by using the Business objects reporting application we generate the reports to track the client information in details, it helps consumers to do data comparison by years and market trends by years.

ROLES AND RESPONSIBILITIES:

Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.

Created / Modified Universes, Reports from the underlying Databases for different business modules

Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies.

Resolved loops by either creating aliases or contexts or by defining shortcut Joins.

Created Universes using @functions for specifying the query script for objects.

Created design for running multi flavor reports like – Date, Weekly and monthly as well.

Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

Imported/ Exported the Universes from/to repository to make them accessible to end-users.

Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.

Created charts using Universes as the main data provider. Reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc. were developed.

Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.

Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.

Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.

Created and Tuned complex stored procedures in SQL server for faster execution.

Scheduled the report to the user Inbox to the Enterprise client and also to the Users mails.

Assisted in the preparation and distribution of internal financial reports, including division reporting.

Involved in coordinating, Bug tracking/fixing, testing, performance tuning and migration of the production defects as a team member of the ongoing support team.

Environment: Business Objects XI R2, Windows XP and SQL Server 2005.

Credit Suisse Global Financial Services, USA Chennai, India

Business Objects Developer Aug 2005 - Mar 2008

PROJECT DESCRIPTION:

Credit Suisse Group is a leading global financial services provider with operations spanning every continent and in all of the world's major financial centers. A financial service is implementing a provisions and controls. As a part of the implementation work, involved in design and development of universe and also developed reports for the Provisions module. The reports have been developed using BO 6.5. We developed tabular reports, threshold reports and more over cross tab reports.

.

ROLES AND RESPONSIBILITIES:

Design and development of BI reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. Design and Development of Business Object Universe. Perform Unit testing, System Testing and User Acceptance Testing for Universe, Reports and Security Management. Delivering and releasing the project deliverables to the customer

Used multiple data providers such as universes and personal data files in generating reports.

Retrieving and Publishing Documents from and to Corporate Repository.

Scheduling the Documents and distributing the Documents through Broadcast Agent Server.

Created various data marts from data warehouse and generated reports using Business Objects.

Use of Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.

Creation of reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.

Architected the Web Deployment strategy for Business Objects Web Reports using Web Intelligence, ZABO, automated document Scheduling and Publishing using Broadcast Agent.

Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.

Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Scheduled the reports by using the Broadcast Agent to enterprise users.

Environment: Business Objects 6.5, Oracle 9i and Windows 2000

ORGANIZATIONAL STRENGTHS

Committed to understand organizational missions and to understand ethics and public.

Excellent in organizing information, people or things in a systematic way.

Effective in demonstrating skills in team building and in managing workflow.

Ability to understand creative processes and capable of systems thinking.

Highly motivated and a quick learner with a positive attitude and great interpersonal skills.

Dedicated well-organized team player with solid research and reporting skills.

Skilled and fostering relationship with people from diverse background.

Capability to adapt to new situations, settings and to tolerate change well.

EDUCATION QUALIFICATION

Bachelor of Engineering in Computer Science Anna University, India

2006 Passed out

Contact this candidate