BO
Shyam

Professional Summary

Shyam is an accomplished Senior SAP Business Objects Administrator and Developer with extensive experience in Business Objects and mid-level experience in Informatica.

  • 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 on windows and Unix 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.
  • 2+ years of experience in Data Warehousing and ETL using Informatica Power Center 8x/ 7x using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
  • Experience in converting client requirements into physical and logical data models as part of Data Analysis initiatives.
  • Experience in Dimensional Modeling using Star and Snow Flake Schema and Identifying Facts and Dimensions tables.
  • Extensively worked on the ETL mappings analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Experience in Performance tuning of targets, sources, mappings and sessions.
  • Experience in integration of various data sources like Oracle, DB2, SQL server and MS access into staging area.
  • Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
  • 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.

Tools/METHODS


SAP BI 4.1, XI 3.1, R1/R2 6.5.x,Crystal Report 2008, UDT/IDT, Dashboard Designer, 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 7x,8x, Scheduler, SQL*Plus.ORACLE 8i/9i/10g/11g, SQL Server 2008/20012,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

Professional Experience

ThermoFisher Scientific, Fredrick Maryland.
Duration
July 2015 to Aug 2016
Role
Sr SAP Business Objects Consulatant
Responsibilities
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.

  • 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.
  • Worked closely with User and management to provide reports and insight into business operations manufacturing and finance to identifying and improving access to data and information for operational efficiency.
  • BO Upgrade from XIR2 to BI 4.1 SP05 P4 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
  • Transferred CMC data between old (XIR2) to new version SAP BI 4.1 SP05 P4 either through CMC/BIAR File/Import Wizard.
  • Apart from promoting info objects, used Life Cycle Manager to create, copy, Edit and scheduled a job.
  • Validate the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
  • Create a repository and security domain with user groups and security implementation.
  • Extensively work with security issues and user maintenance in XIR2/BI4.1.
  • Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
  • Helped design processes for deployment and migration of customer reports from development to testing to production.
  • Assist with the creation of the Business Objects XI environment addressing best practices, process and tool questions and documenting the technical information
  • 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
  • Provide support to resolve client technical issues.
  • Created new universe for LSG Manufacturing Department
  • Converted DeskI to WebI reports using RCT and applied Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas.
  • Assessing and tuning performance of existing configurations.
  • Scheduling and publishing of reports.
  • Developed WEBI BOBJ 4.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions.
PSCU Incorporated, Saint Petersburg, FL
Duration
Sep 2014 to May 2015
Role
Sr. SAP Informatica and Business Objects Consultant
Responsibilities
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.

  • Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Logical and Physical data modeling was done using Erwin for data warehouse database in star schema and Snowflak Schema.
  • Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
  • Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
  • Created sessions, worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
  • Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
  • Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
  • Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL override
  • Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
  • Worked with Index cache and Data cache in transformations like Rank, Lookup, Joiner and Aggregator Transformations.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
  • Developed complex mappings in Informatica to load the data from various sources.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Parameterized the mappings and increased the re-usability.
  • Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
  • Extensively used Transformation Language functions in the mappings to produce the desired results.
  • Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
  • 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.
  • 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.
  • Created Universe from scratch and 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.
World Bank, DC-USA. Chennai, India.
Duration
Jan 2014 to Aug 2014
Role
SAP BO Consultant
Responsibilities
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.

  • 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.
Duration
May 2013 to Dec 2013
Role
SAP BO Developer
Responsibilities
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.

  • 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.
Duration
March 2012 to April 2013
Role
SAP Informatica and BO Developer
Responsibilities
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.

  • 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
  • Analyzed requirements from the users and created, reviewed the specifications for the ETL.
  • Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc. 
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values. 
  • Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
  • Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
  • Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2). 
  • Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator. 
  • Worked on existing mapping for the performance tuning to reduce the total ETL process time. 
  • Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts. 
  • 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
Duration
April 2011 to Feb 2012
Role
SAP Informatica and Business Objects Admin.
Responsibilities
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.

  • 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.
  • 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.
  • 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.
Duration
Apr 2010 to March 2011
Role
SAP BO Developer.
Responsibilities
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.

  • 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.
Duration
Nov 2007 to Mar 2010
Role
SAP Business Objects Developer.
Responsibilities
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.

  • 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
Duration
Nov 2006 to Mar 2007
Role
SAP Informatica and Business Objects Developer.
Responsibilities
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.

  • Extracted data from Oracle, Flat files, SQL Server using Informatica Power Center.
  • Implemented business Data mart with OLAP functionality.
  • Created Mapplets in Designer and used those Mapplets in the Mappings.
  • Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • 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.
  • Developing, debugging, mappings, creating sessions, batches using Informatica
  • 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.