Shyamsundar Selvam

727-***-****

acxd4n@r.postjobfree.com

TOOLS/METHODS

SAP BI 4.1, XI 3.1, R1/R2 6.5.x,Crystal Report 2008, UDT/IDT, DS 1.5, Info view, CMC, CCM, CMS, BEx Query Designer, BEx Analyzer, DeskI, WebI, WRC, Business View Manager, SAP BI/BW 7.0,Live Office, SAP Business Objects Analysis Office, SAP Lumira 1.x, Workday, Tableau, Informatica, Scheduler, SQL*Plus.ORACLE 8i/9i/10g/11g, SQL Server 2000/2005,DB2.

CLIENTS

Thermo Fisher Scientific

PSCU Incorporated

IMF-World Bank

Morgan Stanley

Best Buy

Nokia

USAA

AT&T

EDUCATION

Bachelor of Computer Engineering

Annamalai University, India

RESPONSIBILITY

BUSINESS OBJECTS XI 3.1 / BI 4.0 / 4.1

Expertise in UDT / IDT

Report creation in WebI, Crystal Report, Analysis for MS office,Info View, Working with CMS / CMC

XCELSIUS 2008 / DESIGN STUDIO 1.5

Conncted Visualiztion With Qaaws, Web Services

SAP LUMIRA 1X

Creating and Publishing stories in Lumira server

INFORMATICA 8X

Creating Mappings, Work Flow, Session and Monitoring Jobs

RELEVANT EXPERIENCE

A Senior SAP Business Objects Administrator and Developer with extensive experience in Business Objects and mid-level experience in Informatica.

INVENTORY

Expertise with gathering and analyzing business requirements interacting with the end users, Client resources and converting the requirments to a Business Requirement Document and Technical Design Document.

Indepth Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.

Very good knowledge on Installation & Configuring the SAP BO XI 3.1 and BI 4.1 and Lumira 1.25 on windows platform.

Hands on experience SAP BO Implementations, upgradation, Support & Configuration, and Rollout of SAP projects

Experience in Upgrading/Migrating from Business Objects version 6.5.2 to XIR2 and XIR2 to XIR3 and XIR2 to BI 4.1 SP5 P4.

Developed WEBI Report/Dashboards/Universes (using IDT) in BI 4.1 Environment.

Expertise in working with new tools in BO 4.1 Design Studio 1.5 and Lumira 1.25.

Expertise in building mobile Apps using Design Studio 1.5 and Dashboard 4.1 for IPAD.

Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.

Worked exclusively on IDT, Creating Multi source Relational Universes and OLAP Dimensional Universes,BICS Connection

Reporting and universe development in an environment integrated with SAP, involving BEx queries.

Migration of report and universes from one environment to another (development to system test and system test to production). Includes use of Import Wizard and BRIAR files.

Using Prompts to Restrict Data, Using complex Filters, Applying Condition & Filters, Displaying Data in Tables and Charts, Using Breaks and Sections, Making Crosstab and Master Detail Reports, Formatting of Reports, Using Default and Custom Sorts, Ranking Data to see Top or Bottom Values, Using Alerter to Highlight Information, Input and Output Contexts, Extended Contexts(For All &For Each)

Creating Formulas and Variables to calculate Data,Creating Complex Reports by Linking Data from Multiple Data Providers, Synchronizing Data with Merged Dimensions, Force Merge,Setting Web Intelligence Drill Options, Levels of Scope of Analysis, Scheduling a Web Intelligence document, Using combined Queries, Using Sub-Queries, Using Combine Queries, Delegate Measures, Common Errors in BO, Optional Prompt, Data Tracking, Hyperlink in Reports, Input Controls.

Extensive knowledge in SQL programming and trouble shooting.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

ThermoFisher Scientific, Fredrick Maryland. July 2015 to Sep 2016

Sr SAP Business Objects Consulatant

Thermo Fisher Scientific Inc is the world leader in serving science. Its kind of customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics and increase laboratory productivity.

Responsibilities

Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.

Understanding the existing the landscape and providing solution for new landscape.

Responsible for installation, configuration and maintenance of Business Objects BI 4.1 SP05 P4.

Deploy applications in single and clustered environments, maintaining data security across multiple applications in a shared environment.

Apart from promoting info objects, used Life Cycle Manager to create, copy, Edit and scheduled a job.

Writing or assisting others using Web & OLAP intelligence reports and tools

Assist IT and business areas in the use of reporting tools with primary focus on Business Objects (BOBJ) BI 4.1 SP05 P4 as the web reporting engine and intelligence toolset

Designed enterprise Dashboard 4.1 using combination of Information Design Tool (IDT).

Developed Navigate the interface Creating Dynamic Dashboards. Data can be exposed different levels By Drill down functionality

Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.

Created Dashboards using Filters, Combo box, List View, List Box, List Builder, Line Chart, Column Chart, Pie Chart, and Spreadsheet Table.

Created Dashboard using Advanced features as Dynamic Visibility, Insertion Type (Position, Value, Label, Filtered Row, Status List, Row, Column), Linking of Dashboards, Alerter, Ignore End Blanks

Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data from Dashboards Designer.

Export the dashboard as .Lums files to access from Lumira.

Installing and configured SAP Lumira 1.25

Managing users and Groups account

Set up the new user rights and configured Active Directory.

Created a dataset from Excel and enabled external data sources in Lumira

Connected with multiple data sources

Applied Running, Custom & Percentage calculations in chart reports.

Created fewer future values for Forecasting reports

Created many Geographic & visualizations reports for Monthly sales and Sales by region using geographic map & Radar

Exported a Lumira story to PDF file

Emailed all Monthly sales Visualization reports to particular users

PSCU Incorporated, Saint Petersburg, FL. Sep 2014 to June 2015

Sr. SAP Business Objects Consultant

Project Description:

This project describes PSCU Production ETL Jobs and report processing to monitoring on a daily basis. Reports are 2 categories Internal / External reports. This External and Internal reports are already scheduling in BOE based on their related ETL Jobs completion time and status.

Responsibilities

Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.

Migrating Business Objects Environments including universes, reports and Database from Saint Petersburg to Phoenix location.

Deployed universes in production and non-production environments and Changed the universe parameter settings to optimize the performance of universe

Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, QA, UAT and Production.

Providing resolutions for report, universe, and server errors, including Web Intelligence Server Memory Full.

Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).

Installed, Troubleshoot, upgraded and maintained the various Business Objects.

Involved in testing the reports while migrating from St Pete to Phoenix.

Trouble shoots BO Infrastructure server hangs, crashes issue, reading thread dumps in critical Production environment to find root cause and respond timely manner to fix the issue.

Resolved loops, Chasm and FanTraps using Contexts and aliases in Universe Designer.

Developed WebI Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Cross-Tab).

Worked resolving the loops in universes using Aliases and Contexts

Created WebI reports with multiple data providers and synchronized the data using Merge Dimensions.

Updated the Universe as per the changes of the Database table structure and notified the users about changes made to the Universe.

Scheduling of the report on successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.

Evaluate and design web services access points for data access in multiple and dynamic user interfaces.

Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.

Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Used Sheet filters to produce multiple chart types in a single view.

Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.

World Bank, DC-USA. Chennai, India. Jan 2014 to Aug 2014

SAP BO Consultant

One of the Largest Banking corporations in the world, which is a vital source of financial and technical assistance to developing countries around the world. It offers support to developing countries through policy advice, research and analysis and technical assistance. Their Goal is to End extreme poverty and promote shared prosperity.

Responsibilities

Understanding Existing SAP BI/BO Landscape and experience in using Information design tool (IDT), to create universes using multiple Data Sources.

Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT

Developed WEBI BOBJ 4.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.

Created Master Detail reports using open document (Hyperlink) function to pass the prompts and open the corresponding detail information in a new window.

Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, percentage reports, Prompts using WEBI BOBJ 4.1

Extensively used BEx analyzer to create queries, variables, filters, calculated key figures, restricted key figures, charts and workbooks.

Scheduling objects and maintaining instances history

Participating in the knowledge sharing sessions to get the better understanding on the system and propose the best possible and suitable solutions.

Preparation of technical Reports, Training Documents, Status Report and Issue Log.

Morgan Stanley, NY. Chennai, India. May 2013 to Dec 2013

SAP BO Developer

Morgan Stanley is a global company with investment banking and brokerage operations worldwide.

The Project involved moving the Historical data from PeopleFluent to Taleo Application.

Responsibilities

HRIT BI group mainly focuses on streamlining the HR Data.

Team is involved in capturing the entire set of data from the older PeopleFluent Application to be moved into the Taleo application.

Team has created the Web I Reports from the PeopleFluent Database and then exporting the Web I Reports to excel sheet.

Excel sheet output has converted to text file and then created the Sybase BCP commands for data loading into the Sybase tables using Unix environment.

Existing of the SAP R/3 Web-I Reports to be newly built in the SAP R/4 platform from Taleo environment.

Communicating with onsite for requirement and design understanding.

Impact analysis to study the existing process.

Understanding the various environments available in Morgan Stanley-HRIT EDW process(DEV,QUAL,PROD)

Move the data from PeopleFluent to Taleo staging table in sybase using sybase BCP scripts.

Understanding the Customer subject area and the tables.

Unit testing, UAT migration and support, defect fixing, deployment setup including implementation plan, UAT document and for the above work streams.

Creation of the UAT support document for hand off to the support team.

Expertise in designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R3 & R4.

Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.

Involved in joining the tables by creating aliases to resolve the loop

Performed unit testing and user acceptances test (UAT) support for universe and reports.

Best Buy, Minnesota Minneapolis, Chennai, India. March 2012 to April 2013

SAP BO Developer

There is a business initiative in Best Buy to simplify the budget processing in EDW (Enterprise Data Warehouse). It is planned that TM1 will be the only source that will provide the daily class level budgets for all channels (Store, Dotcom, BBfB, MDC) except PAC. Currently the monthly budget data is sent to EDW by TM1 and manually prepared files by PAC (Pacific Sales) and MDC (Magnolia Design Centre) team. Additionally, the main frame sends the daily budget weight percentage file to EDW. EDW then calculates the forward looking class level and store level budget by day.

Responsibilities

Communicating with onsite for requirement and design understanding.

Impact analysis to study the existing process

Understanding the various environments available in BestBuy EDW process(DEV,QUAL,PROD)

Identification of table issues between the databases and rectify them through the DBA.

Understanding the Customer subject area and the tables.

Verifying whether the existing tables or not affected because of the new scripts developed

Running the scripts through MAESTRO Scheduler tool for DEV and QA environments

Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Creation of the production support document for hand off to the support team.

Expertise in designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R3.

Ensuring high-level of customer satisfaction by timely resolution of problems reported by the business users

Build the new universes as per the user requirements by identifying the required views from different Data bases and by defining the universe connections.

Used Derived tables & Views to create the universe for best performance, and alias tables to solve the loops in Universe.

Provided the security access management by creating users/groups and folders.

Developed universe user documentation guide for the end users reference

Created Groups, Universe, Classes, Objects, Table Mapping and prepared standard Reports.

Involved in joining the tables by creating aliases to resolve the loop

Performed unit testing and user acceptances test (UAT) support for universe and reports.

Nokia, Finland, Chennai, India. April 2011 to Feb 2012

SAP Business Objects Admin.

Common Business Objects (CBO) is a common reporting platform. CBO platform is based on Business Objects products which, provides a single channel for quality and error metrics as well as project management and resource management reporting etc. CBO Platform, the reporting service platform, CBO is a multi-tier system to provide flexibility, reliability, and scalability the components that make up each of these tiers can be installed on one machine, or spread across many. The "servers" run as services on Windows machines.

Responsibilities

Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.

Configured Input/output FRS, BOXI logs on SAN to support clustered architecture and enabled E-Mail and FTP on BOXI 3.1 Servers successfully

Design and implement BO system security including details security groups and access control list to meet business requirements.

Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers.

Involved tuning the web/application server configurations for better performance of Business Objects Applications.

Trouble shoots BO Infrastructure server hangs, crashes issue, reading thread dumps in critical Production environment to find root cause and respond timely manner to fix the issue. Initiative to address root cause in problem resolution.

Deployed Kernel universes in production and non-production environments and Changed the universe parameter settings to optimize the performance of universe

Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, IST, QA, Perf Test, UAT and Production.

Modified existing universes and created new universes as per the business requirements using @Aggregate Awareness and @prompt functions.

Created Joins, Contexts, and Aliases for resolving Loops, Chasm & Fan traps and checked the Integrity of the Universes.

Created Standard Web I reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.

Created the canned Web I reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail, Charts, Formula's, multiple data providers and synchronized the data using Merge Dimensions option in BO XI 3.1.

Scheduling of the report on successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.

Train/Mentor a team member and Business User on Business Objects XI 3.1.

Perform report tuning and administration activities.

Monitor and trouble shoot ETL process by reading log files, ASCII files to resolve the ETL issue.

USAA, Chennai, India. Apr 2010 to March 2011

SAP BO Developer.

USAA, one of the largest Insurers in USA started to facilitate the financial security of its members, associates and their families through provision of a full range of highly competitive financial products and services. Currently, USAA is in the process of developing an integrated/aggregated way to support Enterprise Analytic capabilities associated with measuring MSR performance and member satisfaction as it relates to a call handled by an MSR.

Responsibilities

Build the new universes as per the user requirements by identifying the required views from different Data bases and by defining the universe connections.

Used Derived tables & Views to create the universe for best performance, and alias tables to solve the loops in Universe.

Provided the security access management by creating users/groups and folders.

Created Groups, Universe, Classes, Objects, Table Mapping and created USAA Standard Reports.

Designed New Universe for OPAT & Funnel Marketing system.

Involved in joining the tables by creating aliases to resolve the loop

Created many reports according to the call details, schedule details, referral metrics and MSR details.

Created different reports containing charts showing revenue and operating income by different divisions.

Extensively worked with Business Users on regression testing the Monthly/Quarterly

Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.

Developed universe user documentation guide for the end users reference.

AT&T, Chennai, India. Nov 2007 to Mar 2010

SAP Business Objects Developer.

ASKME is a homegrown, data warehousing system that provides TA96 compliancy reports. Its sole purpose is to provide the metrics & measurement to the regulatory agencies to demonstrate AT&T’s compliance with the laws and regulations of the TA96. Essentially, the ASKME receives Installations & Repair data from multiple source systems throughout AT&T’s operating region. It processes this data on a daily basis and the processed data is used on a monthly basis for generating summary and detail reports that are posted on the Internet (https://clec.sbc.com/clec/) for review by relevant government agencies and CLECs. To summarize, the ASKME provides reports that demonstrate whether AT&T is providing the same level of service and support to its competitors and its competitors’ customers as it does to its own customers.

Responsibilities

Directly coordinating with user to gather the new requirements and working with existing issues.

Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.

Expertise in designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R3.

Involved in all phases of migration from BO 6.5 to XI R3.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Regularly synchronized the TEST, DEV environments with Production reports

Build the new universes as per the user requirements by identifying the required views from different Data bases and by defining the universe connections.

Used Derived tables & Views to create the universe for best performance, and alias tables to solve the loops in Universe.

Created Groups, Universe, Classes, Objects, Table Mapping and prepared standard Reports.

Migrated & upgraded Business Objects from 6.5.2 to XI R3.1 Universe designing and establishing BO environment.

Designed New Universe for Light speed system.

Involved in joining the tables by creating aliases to resolve the loop

Created many reports according to the inventory details, Repair details, Installation details by Region wise

Performed unit testing, system testing and user acceptances test (UAT) for universe and reports.

Preparing System Test Plan and Executing test cases.

Seller-Corp. USA, Chennai, India. Nov 2006 to Mar 2007

Informatica & BO Developer

This project is to track the consultant requirement’s for various Job opening in US market. The source data for the DW is the mails which are sent to the company and they are downloaded to a flat file using a component developed in JAVA report.

Responsibilities

Extracted data from Oracle, Flat files, SQL Server using Informatica Power Center.

Implemented business Data mart with OLAP functionality.

Implemented Aggregate, Filter, Rank, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalizer, Sequence generator transformations.

Fine-tuned Transformations and mappings for better performance.

Created Standard Web I reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.

Created the canned Web I reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail, Charts, Formula's, multiple data providers and synchronized the data using Merge Dimensions option in BO 6.5.2

Involved in Unit Testing and Integration Testing.

Developed code according to the TDD.

Contact this candidate