Venkatesh (M) : 757-***-****

SAP Business Objects Consultant Email: yuvv41@r.postjobfree.com

PROFESSIONAL SUMMARY

• Highly motivated IT professional with a 8+ yrs of solid background in Business intelligence, reporting systems, data modeling, ETL, software design and full life-cycle development. Past experiences span across Finance, Health, Sales, Retail, Production and Insurance industry.

• Highly motivated IT professional with a solid background in Business intelligence, reporting systems, data modeling, ETL, software design and full life-cycle development. Past experiences span across Finance, Health, Sales, Retail, Production and Insurance industry.

• Experienced in SAP Business Objects 4.0/XI 3.1/3.0/XI R2/6.x/5, Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports 2008, Xcelsius 4.5/2008, Explorer, Voyager, SAP Integration Kit.

• Solid knowledge of Data Modeling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions Tables, Physical and Logical data modeling.

• Experienced in gathering and analyzing the requirements from end-users and creating multifaceted Ad-Hoc reports using Business Objects Web Intelligence/Rich Client, Desktop Intelligence.

• Experienced in Xcelsius 4.5/ 2008 to create interactive dashboards by using Query as a Web Service (QaaWS) and Live Office.

• Expert in Designing Universes on different relational databases such as Oracle 9i/10g, SQL Server 2005/2008, Sybase Adaptive Server Enterprise (ASE), IBM DB2 on AS/400, MySQL v5.0, MS Access 2003/2007.

• Experienced in setting up SAP Integration Kit to report off SAP data such as BW Queries, SAP tables, InfoSets, Operational Data Stores (ODS), and Cubes via crystal report.

• Excellent working experience in the Extraction, Transformation & Loading (ETL) of data from multiple sources into Data Warehouse using ETL tools e.g., Informatica Power Center 8.1/8.5/8.6, BO Data Services/Data Integrator, SAP BW/BI 7.0 and SAP ECC.

• Knowledge on SAP ABAP in dealing projects .

• Knowledge of SAP Business Warehouse BW 3.0/BI 7.0, Business Explorer (BEx), SAP R/3 and ETL process.

• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries with WEBI, DESKI and Crystal Reports.

• Experienced in using Import Wizard/ Life Cycle Manager (LCM) to migrate the Universes and Reports from Business Objects 5x/6x/ XI R2/XIR3/ 4.0, Crystal Enterprise between the different environments .

• Experienced in using the Report Conversion Tool to convert Desktop Intelligence reports into Web Intelligence.

• Knowledge of new key applications in SAP Business Objects XI 4.0 such as Upgrade Management Tool, Information Design Tool, Monitoring Tool, and modified features like Administration Console, BI Launch Pad, Change Transport System (CTS)

• A Self motivated active team player with excellent interpersonal, communication, analytical and problem solving skills.

BUSINESS OBJECTS SKILLS:

BOE 4.0/XI 3.1/3.0/R2/6.x/5.x, Web Intelligence, Desktop Intelligence, Universe Designer, Query as a Web Service (QaaWS), Infoview, Crystal Reports 2008, Voyager, Xcelsius 4.5/2008

TECHNICAL SKILLS:

ETL Tools : Data integrator XI, SAP BW 7.0, 3.5

Databases : Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, MySql 5.1, IBM DB2, MS Access

Programming : C, C++, JAVA, VB.NET,SQL, PL/SQL, HTML, UML, XML, SQL*Plus

Data Modeling : Erwin, Microsoft Visio, Toad Data Modeler

Operating Systems : Windows XP/NT/2000/98/95, Windows 2003,Solaris 10,UNIX

EDUCATION:

Osmania University, India, Bachelor of Science – Information Technology

PROFESSIONAL EXPERIENCE:

Abercrombie & Flitch, Columbus, OH May 2011 – July 2012 SAP Business Objects Consultant

Environment: Business Objects 4.0/XI 3.1 SP4, SQL Server 2008, Oracle 11g R2, Crystal Reports 2008, Xcelsius 2008.

Responsibilities:

• Worked with Business managers, architects and end users in documenting requirements, providing estimates, creating High level design and Detail design specifications.

• Migrated from Business Objects 3.5/4.0 during project life cycle.

• Created and Migrated Projects with Exploration views

• Designed universes and eventually reports & executive dashboards with Oracle Financials as source system.

• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Design of the universe with Classes, Objects and Condition Objects.

• Created Aliases and Contexts to resolve the Loops and Traps.

• Creating Segments in IODC, ALE Configuration.

• Worked on ABAP, debugging programs (Break Point, Watch points etc).

• Created and formatted the reports as per the users requirements using the BO feature such as Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and formula to analyze the data.

• Developed SQL queries and stored procedure to reduce crystal report processing time and efficient performance.

• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the Info view.

• Wrote SQL conditions for Context and filtering data at various levels based on the specification.

• 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 Crystal Reports 2008.

• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to create reports which is accurate and easier for the analysis.

• Developed dashboards and data visualizations using Crystal Xcelsius and connected dashboards to live data sources using web-services.

• Developed various multi-chart models that connects to real-time enterprise data using Query as a Web Service (QaaWS)

• Created folders, users, groups and granted permissions in Central Management Console according to company requirements.

• Published Crystal Reports on to BO Info View and provided access to the end users.

GE Commercial Financial Services, CT Sept 2009 – Apr 2011 SAP BOBJ Developer

Environment: Business Objects XI 3.1 SP3, Xcelsius 2008 FP 3.2, SQL Server 2008, Oracle 10g, PL/SQL

Responsibilities:

• Performed the Server management and User management and ongoing monitoring of the environment, responds to incidents.

• Participated in Project Planning Sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution.

• Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing.

• Created the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.

• Developed Hierarchies to support drill down reports.

• Worked on ABAP, debugging programs (Break Point, Watch points etc).

• Creating Segments in IODC, ALE Configuration.

• Designed Universes using multiple Data Sources e.g., Oracle 9i and SQL Server 2005.

• Created metadata reports by extensively using multiple data provider’s @functions and inner query concepts to generate thin client reports.

• Created different categories in the repository and published full client reports corporate documents to their respective categories.

• Created and customized application dashboards using Application foundation to meet the requirements of higher level analysis.

• Developed dashboards and scoreboards for the detailed analysis.

• Created Backup plan for the production servers.

• Applied Open document functionality in Webi to link the Reports according to the User requirements.

• Involved in re-pointing reports from old Universe to new Universe and fixed synchronization issues.

• Created different type of Crystal reports including: Cross-tab, Conditional, Drill-down, Top N, Summary, OLAP, Sub reports, Drill-down and Parameter prompts.

• Deployed reports to different environments depending on the project phase e.g., Testing, Development and Production.

• Documented all design and development efforts in accordance with Software Development Life Cycle standards.

Intuit, Inc., Plano, TX Jun 2008 – Aug 2009 SAP Business objects Analyst

Environment: Business Objects XI 3.1 SP3, Xcelsius 2008, WebI, DeskI, Oracle 10g, TOAD, Windows 2005 Responsibilities:

• Gathered business requirements from the users and prepared functional and technical design documents.

• Designed, developed, maintained and tested universes for creation of ad-hoc queries and reports according to the business requirements.

• Extensively used Designer, Business Objects Dashboard Manger and Desktop Intelligence.

• Created and Migrated Projects with Exploration views

• Creating Segments in IODC, ALE Configuration.

• Setup aggregated objects and created summary tables to improve the query performance.

• Designed hierarchies in universe for various reports and created user objects with calculations in universe

• Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.

• Developed KPI Dashboard Reports using the Dashboard Manager in order to provide consistent, real-time snapshot of various departments.

• Extensively used Performance Manger to design Score cards and uploaded them on to the internal website.

• Scheduled and monitored reports using Broadcast Agent (BCA).

• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.

• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.

• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.

• Use Web Intelligence SDK to customized the Web Intelligence user interface to make more interactive and easy to you interface.

• Worked extensively with SQL*Plus, TOAD for writing user defined queries, stored procedures, views, tables, Indexes and constraints.

• Analyzed all the data sources and develop requirements for data conversion.

• Supported DW team on analysis and providing of data for DW purposes.

• Responsible for end-user training to work on reports.

St. Jude Medical, St.Paul, MN Sept 2006 – May 2008 SAP Business ABAP developer.

Environment: Business Objects XI 3.1, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, SQLServer 2008 SP1, Windows Server 2003, Java based Applications

Responsibilities:

• Developed Business Objects Universes for Cases, Case Activity and Case Audit.

• Developed Dashboards using Crystal Reports, Xcelsius.

• Retrieved tables from SQL server 2008 database and used LOV’s, cascading prompts utilized the Business View Manager feature of Crystal Reports to generate reports.

• Created Master/Detail, Cross Tab and Chart templates using the sub reports.

• Organized data in the Report inserting filters, sorting, ranking and highlighting data.

• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.

• Created report templates to maintain same standards across all the reports

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

• Use Web Intelligence to create, analyze and publish Business Objects reports to various user groups in Info view.

• Conducted Unit Testing and checking the Integrity for each object in the universes.

• Worked on Ad-hoc Query, Reporting, and Analysis.

• Maintained project organization structure, staffing level and roles & responsibilities.

• Managed work activities of project contributors and provide status reporting to BI/DW group.

• Interacted with Project manager and end-users in understanding the requirements and report specifications.

• Applied security features such as report level & object level security in the universe.

• Developed Stored Procedures using Oracle PL/SQL to improve the query performance.

United Technologies Corporation (UTC) – Farmington CT Jan 2004 – Aug 2006 SAP Business Objects Consultant

Environment: Business Business Objects XI R2 SP4/SP5, Crystal Reports XI R2, Tomcat 5.0, SAP R3 v640 Final Release, Oracle 10g, Data Integrator XI R2, Microsoft Share point and Windows 2003/XP

Responsibilities:

• Development of BO Universes for Cases, Case Activity and Case Audit.

• Analyzed the existing database and designed Universes using Designer module for generating reports.

• Interviewed VPs and Managers to capture corporate goals and objectives to identify dashboard metrics.

• Developed classes, objects and created Universes to retrieve data from Oracle database for reporting needs of the management and end users.

• Used various functionalities of Universe such as Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

• Defined the Xcelisus Enterprise Dashboard/Performance Management requirements for a POC.

• Worked on Corporate Analytics, Corporate Dashboards, speedometer gauge, Key Performance Indicators (KPIs), Scheduling and monitoring the jobs.

• Designed and developed dashboards using Xcelsius.

• Used Query as a Web Service (QaaWS) and LiveCycle Data Services (LCDS) etc to build the dashboards.

• Used Strategy Builder and Goal & Metric Publishing Wizard etc. to develop dashboards.

• Prepared technical documentation and basic operational document for the support team.

Contact this candidate