SUMMARY

• Certified Consultant with 10 Years Of Experience in Business Intelligence & Data Warehousing
• Skill - Set of SAP Business Objects 4.2/4.1/4.0/3.1/3.0/ R2/R1, SAP BW 7.5/7.4/7.3/7.2/7.1/7.0 SAP Data Services 4.2/4.1/4.0, SAP HANA 1.0 SPS 12/11/10/9/8, Oracle 11g/10g/9i SQL Server 2008/2005, Teradata 13/14/15, Tableau 8/9/10, SAP Lumira, SAP Design Studio
• Expertise in BO BI 4.2, with experience in CMC, CCM, BI Launchpad, Import Wizard, Life Cycle Management (LCM), Information Design Tool (IDT), Universe Designer/Designer (UDT), Widgets, Webi Rich/Thin Client, Deski, Report Conversion Tool, Upgrade Management Tool, Promotion Management, Publishing Wizard, QaaWS, BI Services, Live Office, Live XML.
• Expertise in SAP BW front end tools including BEx Query Designer, Web Application Designer, and BEx Analyzer.
• Expertise using Crystal Reports 2011/Ent./2008/XI, Dashboard Design 4.0/Xcelsius 2008.
• Created Universes using IDT/UDT with more than one database, Loops, Traps, Hierarchies, LOVs, Cascading LOVs, Context, Alias, @functions, ANSI 89 and 92, Star Schema, Snow flake relational, OLAP universes consuming BEx, Linking derived universes to core universe for user to have one universe to query from.
• Strong Skills using SQL, PL/SQL/T-SQL, RDBMS, complex queries, joins, grouping, stored procedures, functions, triggers, sequence, and cursor.
• Created SQL Server Integration Services Packages to load flat files into the SQL Server.
• Created Webi canned and adhoc reports using master/detail, drill down, hyperlink, alerters, ranking, sorting, sections, breaks, report/section/block level filters, crosstab, vertical, horizontal, forms, charts, variables, calculations, combined query, multiple queries, prompt, input controls, merged dimensions functionalities.
• Created Crystal Reports using universe, SQL, BW backend to create formatted reports, grouping, sorting, in excel format, using OpenDoc, etc.
• Created Dashboards and Scorecards using Dashboard Designer/Xcelsius 2008 using Live Office, QaaWS, BI Service, Live XML as a data source, displaying KPIs, summery info provided drill down reports for detail.
• Created InfoSpaces to explore and visualize data with Business Objects Explorer.
• Created dashboards using Tableau and its visualization techniques.
• Utilized SAP Lumira for data visualization, data acquisition and transformations.
• Expertise in Business Objects Administration. CMC, creating users, creating groups, access level, folder, categories, instance, authentications, SSO Windows AD, InfoView customizations.
• Expertise using UMT & Promotion Management/Import Wizard/LCM for migrations from DEV to QA and QA to PROD.
• Expertise in upgrading from Business Objects XI2 to 3.1 and 3.1 to 4.0.
• Expertise using RCT (Report Conversion Tool) to convert DeskI Reports to WebI.
• Good knowledge of BI 7.0+ configuration requirements processes and tools.
• Four full life cycle project implementations, with proven results in meeting reporting requirements, analysis, as well as design, construction and delivery of end user reports.
• Overall SAP BW Development including Data Extraction, Transformation, Staging and Reporting using BEx and Business Objects.
• Data Extraction from multiple SAP and non-SAP systems using Business Content, LO, CO-PA FI-GL, Flat File and Generic Extraction Methods.
• Expertise in creating Infopackages, Datasources, DTPs, Transformation and Process Chains.
• Expertise in performance tuning of BW using aggregates, compressions, and roll-up.
• Expertise in SAP HANA. Experience working with real-time data, creating attribute views, analytical views, Derived Attributes, Calculation Views, CE functions, working knowledge with Modeler, Administration, SLT.
• Created WEBI reports using BW back end by utilizing BICS connection.
• Created dashboard using BICS connection from BW as data source.
• Strong experience working in Business Methodologies like Agile and Waterfall.
• Strong knowledge in SDLC all phases e.g. requirement gathering, blue print, development, testing, migration, unit testing, regression testing, administrating, security management and production supports.

TECHNICAL SKILLS

BI Tools: BO BI 4.2 (BI Launchpad, Webi, Crystal Reports, Widgets, Explorer, IDT, UDT, QaaWS, Designer, Live Office, BI Services, CMC, CCM, RCT, LCM, UMT, Advance Analysis, Promotion Management, BI workspace), Dashboard Design 4.0/Xcelsius 2008, Crystal Reports 2011/2008/XI, BO 3.1/3.0/R2/R1(All Tools), SAP BW/BI Front End Business Explorer (Query Designer, Analyzer, Web Application Designer), Tableau, Lumira, Design Studio

Databases/DW: BW 7.5/7.4/7.3, SAP HANA 1.0, Oracle 11g/10g/9i, MS SQL Server 2008/2005, Teradata, MS Access

Tech. Language: SQL, PL/SQL, T-SQL, HTML

Operating System: WIN 7/XP/2008/2003, Linux

Others: Toad, Teradata SQL Assistant, Office, Visio, Beyond Compare

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Business Objects Lead

Responsibilities:

• Designed a Data Warehouse for an integration project using Data Services 4.1
• Created a Universe based on database link, leveraging existing master data in Universe Design.
• Created Reports in Web Intelligence, including detail and summary-level reports with filters.
• Integrated the existing Lilly Universe with the new Universe created for the integration project.
• Set up universe-level security for Global Finance team according to the new requirements.
• Designed Data Services Jobs to create Fact Tables, Dimension Tables using monthly Flat Files.
• Utilized almost all transform objects and functions within Data Services for ETL purposes.
• Utilized SAP Lumira for advanced data visualizations, data acquisition, and transformations.
• Worked throughout the SDLC, engaged in requirements gathering, dev, unit testing, UAT testing, prod testing and promotions.

Environment: Win7, Oracle 11g, Business Objects 4.1, Dashboard Design 4.0, Data Services 4.1 SAP Lumira.

Confidential, Phoenix, AZ

Business Objects Lead

Responsibilities:

• Worked on large scale universes with 952 tables to integrate different areas of business for ad-hoc reporting. One of the largest in Business Objects implementations.
• Created reports in Web Intelligence, including detail and summary level reports using OpenDoc.
• Migrated the universes from Universe Design Tool to Information Design Tool.
• Created both single source universes as well as multi source universes in IDT.
• Created and modified reports in Crystal Reports 2011 depending on user requirements.
• Utilized Business Objects Explorer to create InfoSpaces for large-scale data exploration and data visualization.
• Utilized SAP Lumira for advanced data visualizations, data acquisition, and transformations.
• Created Dashboards through Tableau using different data connections.
• Created summary level dashboards in SAP BI Dashboards 4, connected through BI Web Services.
• Worked throughout the SDLC, engaged in requirements gathering, dev, unit testing UAT testing, prod testing and promotions.

Environment: Win7, Teradata 13, Oracle 11g, Business Objects 4.0, Dashboard Design 4.0 Crystal Reports 2011, Tableau 8, SAP Lumira

Confidential, Johnston, IA

Business Objects Consultant

Responsibilities:

• Created complex universes in both Information Design Tool and Universe Designer in the Business Objects 4.x environment.
• Created reports in Web Intelligence, including detail and summary level reports using OpenDoc.
• Created both single source universes as well as multi source universes in IDT.
• Created and modified reports in Crystal Reports 2011 depending on the user requirements.
• Modified several WebFOCUS reports to enhance reports functionality and converted some of them to BO Web Intelligence.
• Created BEx Queries to be consumed by Web Application Designer, as well as direct connection via BICS to Web Intelligence.
• Created summary level dashboards in SAP BI Dashboards 4/Xcelsius connected through BI Web Services.
• Created BW objects such as InfoCubes, DSOs, Master Data, Transformations, Aggregates, Infopackages, and Data Transfer Process.
• Fully utilized SAP BW as a backend for the Business Objects BI Suite.
• Created Process Chains to schedule the data loads into data targets, InfoCubes and Rollups
• Performed and set up multiple extractors in LO cockpit.
• Gathered requirements, managed teams to deliver Business Intelligence deliverables with best practices.

Environment: Win7, SQL Server 2008, BW 7.3, Oracle 11g, Business Objects 4.0, Dashboard Design 4.0, Crystal Reports 2011, WebFOCUS, BEx Query Designer, BEx Query Analyzer, Netweaver Portal, Sharepoint

Confidential, Indianapolis, IN

Business Objects Developer

Responsibilities:

• Created and modified Universes, set up Connections, Tables, Views, Stored Procedure, Derive Tables, Joins, Cardinality, Chasm/Fan Trap Issues, Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Row/Column Level Security.
• Created Universes using data model schema like Star/Snow Flake/Relational/BEx (OLAP).
• Created Universes using IDT with multiple relational data sources.
• Created BICS connection in IDT for SAP BW.
• Created Universes for Ad-Hoc Reporting for users.
• Created Ad-Hoc, Canned, On-Demand, Standard Reports using WebI Thin/Rich Clients.
• Developed Complex Reports using WebI Rich Client, such as Master/Detail, Slice and Dice, Drilling Methodology, Merge Dimension, Sub Queries, Combined Queries, Formulas, Variables, Filters, Ranking, Sections, Graphs and Breaks.
• Created Crystal Reports using universes, direct connections to DB. Created formatted reports, billing reports.
• Migrated users, groups, universes, reports, connections, QaaWS/BI services etc. from DEV to QA, QA to PROD using LCM.
• Involved in deployment and upgrade from 3.1 to 4.0 on content bases.
• Extensively used RCT to convert DESKI reports to WEBI and fix partial converted reports.
• Managed applications, servers, security, instance limit etc. in CMC.
• Managed WEB/Applications servers using CCM.
• Created server groups according to requirement for large reports and leverage system.
• Worked on the customizations of BI Launchpad according to the requirements.
• Involved in SSO configurations and LDAP authentication configurations.
• Created OpenDoc and passing parameters, printing in pdf/html or wid format.
• Created Dashboards, Scorecard using dynamic data, using connections, Live Office, QaaWS, Flash Variables, EIC, XML, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, provide complex functionality using IF logic in excel.
• Created BICS connection for BW data source for WEBI reports.
• Created BW objects such as InfoCubes, DSOs, Multiproviders, Master Data, Transformations, Aggregates, Infopackages, and Data Transfer Process.
• Created process chains to schedule the data loads into InfoCubes and Aggregates.
• Installation of Business Content in Sales & Distribution, Material Management and Finance functional areas. Developed generic transactional and Master Data data sources to fill gaps.
• Developed queries, variables, structures, restricted key figures, calculated key figures, conditions and exceptions.
• Created Dashboard using BICS, query straight from BW BEx queries.
• Created Hyperlink for drill through and jump one report to another report.
• Created Logical Multiple value selector for Xcelsius according to user’s requirements.

Environment: Win7, Oracle 10g/11g, BW 7.2, BO XIR 3.1/4.0, Crystal Xcelsius 2008 / Dashboard Design 4.0, Crystal Reports 2008/2011, Netweaver Portal, Sharepoint

Confidential, Garland, TX

SAP BO/BW Developer

Responsibilities:

• Involved in full life cycle design and development of Business Objects reporting.
• Created mockups from the requirements and presented to users for acceptance and suggestions to any changes.
• Involved in deployment of Business Objects XI 3.1 environment.
• Involved in migration and testing of reports and instances from BO XI R2 to 3.1.
• Involved in SP and FP upgrades and rollback plan.
• Created users and user groups and maintained row level and object level security using Central Management Console.
• Created complex universes by defining classes, objects, defined joins, cardinalities, resolved loops between the tables, setup aggregate awareness for fast retrieval, defining hierarchies.
• Created ad-hoc Universes for end user WebI report generation.
• Modified complex universes, resolved universe problems like loops, chasm traps, fan traps using alias and context, @functions, security, cascading LOVS, data delegate, classes with Dimension, Detail & Measure objects, created Derived Tables, check integrity, export the universes to Repository for making available to users.
• Created Linked Universe with multiple derived universe linked to core universe.
• Optimized and enhanced reports to reduce processing time.
• Developed WEBI reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Created formatted reports using Crystal Reports.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross Tab, Master Detail and Formula.
• Creating complex reports on Webi Rich client and Webi thin client using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Developed dashboards using Crystal Xcelsius 2008 using QaaWS, Live Office BI Services.
• Developed chart, dial, dynamic visibility, dynamic dashboards, refresh QaaWS every time when end user run the report.
• Created users and groups, applied security, migrated universe, reports from DEV to QA and QA to Prod using Import Wizard.
• Involved in complete life cycle implementation of SAP BW using ASAP methodology as a team member, converting Functional Specifications into Technical Specifications and then to realization.
• Gathered and analyzed requirements to identify suitable business content and installed standard Infocubes, DSO’s, Multiproviders and various other relevant objects installed and activated.
• Tested extractors, data loads and reports before transporting into production.
• Created process chains to automate the data loads for transaction, master, text tables.
• Worked with PSA in Monitoring the Data Transfer from source system into the BW.
• Developed custom Infocubes, DSO/ODS, Multiproviders and modeled them according to the reporting requirements.
• Created BEx Queries and BEx Analyzer Reports for the upper management.
• Worked with support team to complete design and support Sustaining Team for Prod issues.

Environment: XP/Win7, Oracle 9i/10g, SQL Server 2008, Business Objects XI R2/3.1, Xcelsius 2008, Crystal Reports XI/2008, SAP BW 7.0, Sharepoint

Confidential, Plantation, FL

Business Objects Developer

Responsibilities:

• Involved in Planning, Installation, Administration and Maintaining Business Objects in Dev, QA and Production Environments.
• Installed patches & upgrades for up to date version for latest bug fixes and security.
• Execution of security requirements and user administration.
• Created Webi reports using universes, Drill Down, Graphs, complex filters, prompts, sub queries, merge dimension, variable, alerter, ranking, hyperlink.
• Created Deski reports using free hand SQL, universe, personal data file, stored procedure.
• Created Dashboards and Scorecards for graphical presentation using charts, scorecard, combo box, text, canvas, dynamic visibility for summary level information and provide user drill down reports for details.
• Analyzed user requirements. Found solutions to technical issues; extended technical assistance.
• Improved support process and procedures.
• Optimized and enhanced reports to reduce processing time.
• Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
• Creating Universes using star/snow flake, aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity check.
• Created several BW objects such as InfoCubes, DSOs, Multiproviders, Master Data, Transformations, Aggregates, Infopackages, and Data Transfer Process.
• Set up sandbox, creating test cases, test plan, rollback, and backup.
• Tuned the reports for better performance using SQL.
• Validated data using Toad and Webi-generated SQL.
• Developed Webi reports using Open Document feature.
• Developed User Training Manual and trained the users to build adhoc reports and scheduling.
• Involved in fresh BW implementation creating and configuring InfoObjects, DSOs, InfoCubes, Multiproviders and Infosets based on business requirements.
• Created Datasources, Infopackages, Transformation and DTPS to extract data from multiple sources such as Flat Files, DB, UD connect to extract data from databases.
• Worked with BW admin team to define specification for frequency and modes of data transfers and set up batch jobs.
• Activated Business Content Objects and Datasources in R/3.
• Performed performance tuning to improve data loading and query performances.

Environment: XP, SQL Server 2005/2008, Business Objects XI R1/3.0, Crystal Reports XI/2008, Xcelsius 2008, SAP BW 7.0, Sharepoint.