EXPERIENCE SUMMARY

• Multiple full life cycle implementations as SAP BOBJ/BI consultant - requirement gathering, GAP & OLAP analysis, business blue print, design & development, testing, reporting, getting client approvals, go-live & production support.
• Full life cycle implementation of Business Intelligence projects using Business Objects (universe, webi), Dashboards/ XCelsius (qaaws, live office, BI services, query browser), Crystal Reports, and SAP BW (BEX and InfoCube).
• In-depth insight into BW data modelling - design & creation of infoproviders (infocubes, ods/dso, multiproviders, infoobjects) & associated data flow structures (infosources, datasources, transfer routine, start routine & end routine), infopackage monitoring & scheduling process chains.
• Involved in HANA modelling. Created multiple schemas and table definitions, created Attribute views, Analytical views and calculation views as per the use cases.
• Extensive experience in previous SAP Business Objects products like Business Objects Designer/Reports/Supervisor/ CMC/CCM/Web Intelligence/Import Wizard/LCM/BO Explorer/Broadcast Agent/Info View/Xcelsius/Live Office/QAAWS/ BO Auditor/Application Foundation/Crystal Reports X&XI and Business Objects XI R1/R2/R3/R4 and V3 Environments.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Extensive experience in BODS Transformations like, Map Operation, Table Comparison, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Row Generation, Match transformation and Global address cleansing
• Extracted the data from ECC 6.0, loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
• Involved in Full life cycle (analysis, design, networking, design, development and deployment) of Business Objects reporting Applications with Web Intelligence (WebI) and Broadcast Agent.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Good Knowledge and Experienced in User Management and security in HANA.
• Good knowledge in Hana Architecture and Design.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Designing Universe & development using DB2, Oracle, SQL Server, Sybase, SAP BW queries & info cubes.
• Experienced in reporting agent and web reporting/publishing using SAP business objects - web intelligence, desktop intelligence, and xcelsius 2008/2011.
• Data Modeling experience from Entity Relationship Model (ERM) to Multi Dimensional Modeling (MDM) star schema-Extended star schema (InfoCube/ODS).
• Expertise in ABAP & portal; techno-functional player in integration of SAP BW with SD, MM, FI, CO.
• Involvement in testing, support & end-user training in SAP solutions.
• Solid leadership, relationship & communication skills; configuration & project management skills.
• Established technical credibility with global IT community & senior business users.

TECHNICAL SKILLS

Languages: ABAP/4, SQL, PL/SQL, C, C++, Java

SAP modules: ERP(SD, MM, PP, FI-AP,AR,GL,CO-PA, HR), BI/BW, CRM, AFS, SCM, APO

Reporting tools: Business objects XI 3.5/4.1, Crystal reports, BEx report designer, Web application designer (WAD)

SAP versions: HANA1.0 SP 05/06/07, BI 7.4/7.3/7.0/3.5, ECC 6.0, R/3 4.7/4.6 C, BODS 4.0/3.2, Net weaver 2004/2004s/ CE 7.1/CE 7.2, Portal.

Databases: SAP HANA1.0 SP5, Oracle 8i, SQL server 7.0, Teradata, MYSQL, MS-Access.

Web tools: Adobe flex builder, Photo shop, HTML, Java script

Packages: Microsoft office, Project

Production support tools: Remedy, HP quality center

PROFESSIONAL EXPERIENCE

Confidential - MEMPHIS, TN

Sr. SAP BI/BO Architect

Environment: Business Objects 4.1/4.0, UDT, IDT, CMC, Crystal, WEBI, Rich client, Xcelsius, Analysis for office, Lumira, Design Studio 1.3, Teradata 14, Teradata SQL Assistant, BO Java SDK

Responsibilities:

• Gather, document and translate client’s requirements into functional & technical specs.
• Involved with various database administrators to map the requirements and to propose new solutions.
• Built new reports and made changes to the existing reports based on user requirements using BO Webi
• Developed the new universe based on Teradata and made changes to the existing Ad-hoc Universe using IDT. Added new tables, created new objects, resolved loops and traps by creating contexts and aliases, renamed existing objects, created prompts according to the user requirements.
• Improved the performance and reduced the coding with the use of @functions like @Prompt(for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes(UDT & IDT).
• Wrote multiple complex Teradata queries using Teradata SQL Assistant to use in the reports.
• Implemented Row Level Security in the universe using CMCDeveloped data flows.
• Developed multiple reports on the new universe and implemented the report bursting feature using CMC
• Performed admin role like security management by creating/maintaining user groups, roles, access levels etc
• Participated in migrating reports from BO 3.1 to BO 4.1 using the UMT
• Hands on experiencing using Design Studio 1.3 .Created visualizations for analysis purposes.
• Created BIWS connections to provide inputs to Xcelsius dashboards from webi reports
• Involved in performance tuning of existing Dashboards and Dashboard Design alternatives
• Supported integration of Xcelcius dashboards with SharePoint portal pages
• Created complex webi reports using the multiple data providers and synchronize the data providers by merging objects to create a report
• Involved in making changes to the RESTful Web Service using Java SDK for business objects.
• Recommended standards of good practices of report development and maintenance of universes

Confidential

Sr. SAP BI/BO Architect

Environment: Business Objects 4.1/4.0, UDT, IDT, CMC, Crystal, WEBI, Rich client, Xcelsius, Analysis for office, Lumira, Design Studio 1.3, Teradata 14, Teradata SQL Assistant, BO Java SDK

Responsibilities:

• Interacted with Business community to gather and analyze the Business Requirements in developing and modifying Universes and building the reports.
• Provided recommendations in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC).
• Developed Overgoods Dashboard for detailed analysis in Dashboard (Xcelsius) using BIWS for Higher level Management to Monitor Volume by Location and Volume by OpCo.
• Wrote multiple complex Teradata queries using Teradata SQL Assistant to use in the reports.
• Developed the new universe based on Teradata in IDT. As a part of Universe development, created connection, classes, derived tables, different kinds of objects, cardinalities, strategies, resolved loops using aliases and contexts.
• Created BIWS connections to provide inputs to Xcelsius dashboards from webi reports
• Published Universes and Report documents to the Repository as part of the production deployment and made them available to the users.
• Interacted with DBA/ETL Team to implement report logics at Database/ETL Level to improve performance of the reports.

Confidential, ST. LOUIS, MO

Sr. SAP BI/BO Architect

Environment: BI 7.3, ECC 6.0, BO 4.1 (SP3), Windows 2008 R2, SQL Server, Business Objects Data Services 4.0 SP1(IPS 4.0, D.S 4.0, IS 4.0), Oracle 11g.

Responsibilities:

• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Created Webi reports on top of the OLAP based Universes built using IDT.
• Created canned Webi reports with prompts, input controls etc. that would help business users validate the data. Involved in designing, building, testing and deploying technical components required for successful BO solutions.
• Created the data stores to communicate source and target with BODS
• Created new mappings and updated old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
• Created BICS based WebI reports, Dashboards in SAP BOBI 4.1
• Provided prototypes and guided the technical team with best practices for development.
• Created relational universes on top of SAP BW Multi cubes and combined with existing SQL Server & Oracle databases for multiple sources.
• Implemented Dashboard by connecting directly to BEx Query by using Query Browser.
• Developed the FICO dashboard using Dashboard Designer. Used various drop downs, Column charts, rolling 12 months Trend Lines, Rolling 8 weeks Trend Lines, Area charts. Etc. components. Also included features like drill down, export to webi, print etc.
• Created Prototypes in IDT, UDT, Dashboards, WebI document, Business Explorer & extractions in Data Services.
• Worked extensively with the Information Design Tool in designing several Universes based on the dimensions, detail and measures to get inventory plan data from legacy system.
• Built Universes, Classes and Objects on the designed schemas, well tested and exported them to repository.
• Experience with central management console (CMC) in SAP business objects.
• Design and development of Web Intelligence (InfoView) for interactive analysis using single sign-on.
• Publish high-level reports and giving training to end users.

Confidential, MEMPHIS, TN

Sr. SAP BI/BO LEAD

Environment: BI 7.3, ECC 6.0, BO XI 3.5

Responsibilities:

• Managed and supported the business information team; carry out the IT projects in SAP BI/BO environments.
• Designed and developed universes in the designer by connecting BI to BO. Created reports for previous day sales, Cost of Sales, Month to date sales and costs and monthly margin.
• Created QAAWS connections to import the data to dashboards. Used dynamic query loading and refresh using various prompts to bring the minimum required data to dashboard and thus obtaining the optimum response time and performance for the dashboards.
• Created country dashboard for STP using Xcelsius based on current fiscal year and previous fiscal period comparison.
• Developed 3 dashboards, Managed Care Contracting dashboard, Acute Revenue Cycle Management dashboard and COE Executive dashboard. Used various drop downs, bar charts, rolling 13 months Trend Lines, progress meters etc. components. Also used OpenDoc links to other documents.
• Combined these 3 dashboards using Dashboard Builder and created Corporate Dashboard with these 3 dashboards as 3 tabs.
• Leveraged BI services instance functionality to feed data into Dashboards their by improving Dashboard loading, initialization and performance.
• Used LCM tool for Migrate the Universes, Reports and Dashboards between Development, Test and Production Environments.
• Implemented enhancements to online portal to integrate the Dashboard.
• Trained Executives, Marketing Managers, Sales Team and Analysts on how to use Dashboards, Universes, Webi, and create Ad-Hoc reports.

Confidential, ST. LOUIS, MO

Sr. SAP BI/HANA/BO Architect

Environment: BI 7.3, ECC 6.0, BO 4.1 (SP3), SAP HANA 1.0 SP5, Windows 2008 R2, SQL Server.

Responsibilities:

• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Managing multiple projects and support the business team for any issues.
• Provided hands on leadership, direction and guidance to design and develop a sustainable Enterprise wide Business Intelligence reporting framework and solutions
• Extensively working on Performance Tuning using BW Statistics, Aggregates, Compression, Partitioning and Database Statistics.
• Enhance built-in analytical capabilities forSAP NetWeaverBW Accelerator & BWA-based reporting on DSO(BWA7.2)
• Smarter data flow modeling with remarkably reduced manual effort.
• Enhance monitoring capabilities with new content for SAP NetWeaver BW Administration Cockpit and integration in SAP Solution Manager.
• Extract and enhance data sources from various SAP modules - 2LIS 11 VAHDR/VASCL/V SCL, 2LIS 12 VCSCL, 2LIS 13 VDITM/VDKON, 2LIS 02 SCL/SCN and 2LIS 03 BX/BF/UM.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Created the information spaces using SAP BO Explorer tool on top of the SAP HANA Information models as per the business cases.
• Involved in designing, building, testing and deploying technical components required for successful BO solutions.
• Created BICS based WebI reports, Dashboards in SAP BOBI 4.1
• Created relational universes on top of SAP BW Multi cubes and combined with existing SQL Server & Oracle databases for multiple sources.
• Created Prototypes in IDT, UDT, Dashboards, WebI document, Business Explorer & extractions in Data Services.
• Worked extensively with the IDT in designing several Universes based on the dimensions, detail and measures to get inventory plan data from legacy system.
• Developed more than 30 complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports 2011 and implemented report bursting for those.
• Experience with central management console (CMC) in SAP business objects.
• Monthly drilldown Dashboards with separate views for different levels of management and other relevant information seekers using Xcelsius 2011.
• Design and development of Web Intelligence (InfoView) for interactive analysis using single sign-on.

Confidential - NASHVILLE, TN

Sr. SAP BI/BO - TEAM LEAD

Environment: BI 7.3, ECC 6.0

Responsibilities:

• Programmed several Start routine, end routine and field routines in Transformations at various level to meet business requirements. Incorporated logics in routines with in DTP to get period to date and year to date data.
• Built BEX queries based on reporting needs utilizing CKFs, RKFs and variable selection functionalities and worked on Calendar and Fiscal year calculations (YTD and MTD etc) in BEX Queries
• As part of GTS project, Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.

Confidential

Sr. SAP BI/BO LEAD

Environment: BI 7.3, ECC 6.0, BO XI 3.5

Responsibilities:

• Worked on KPI Project in extracting data from standard and generic data sources and loaded them into several info providers as per the business requirements.
• Provided best practices and recommend solution for enhancing architecture between SAP BW as well as SAP ECC
• Created multiple formatted webi reports which includes several variables and developed reports using dynamic measures.

Confidential

Sr. SAP BI/BO LEAD

Environment: BI 7.3, ECC 6.0, BO XI 3.5

Responsibilities:

• Designed a multi layered visualization space to accommodate various Key Performance indicators(KPI) and very user intuitive for the CFOs and CEOs of various member firm
• Actively worked during Requirements gathering, scope analysis, and POC design with Financial Applications Strategy Teams.
• Developed Xcelsius and webi dashboards based on BW and Information Design Tool (IDT) for integrating SAP and non-SAP data source as a part of FIGR 2.0 project.
• Support, maintenance and regression testing of existing FIGR 1.0 dashboards as a part of BOBJ upgrade.
• Created dashboards like Profit Equation, 5 Year historic Trend and Balance Sheet for analyzing the KPI like Revenue per Fee Earner, Finance Costs, Overhead Costs and Dashboards like Benchmarking and P&L Projection for analysis across the following functions.
• Designed a dynamic currency conversion feature within dashboard. The default currency can be selected at the reporting portal and all dashboards can be displayed in the same currency with the option of changing.
• Published the Xcelsius and webi dashboards into SAP BI mobile client for access
• Open document URLs and parameter passing among different Xcelsius dashboards and also Webi reports.
• Worked with User Acceptance Testing (UAT) teams to fix the UAT issues and performing sanity tests in Pre-Prod environment/Validation environments.

Confidential - ST. LOUIS, MO

Sr. SAP BI/BO Architect

Environment: BI 7.3, ECC 6.0, BO 3.5, Windows 2008 R2, SQL Server.

Responsibilities:

• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Managing multiple projects and support the business team for any issues.
• Design and development of consolidated high level aggregated reporting data models using advanced data mining techniques, Analysis Process Design.
• Involved in supporting the administration team for upgrading SAP BI to BW 7.3.
• Involved in designing, building, testing and deploying technical components required for successful BO solutions.
• Created relational universes on top of SAP BW Multi cubes and combined with existing SQL Server & Oracle databases for multiple sources.
• Built Universes, Classes and Objects on the designed schemas, well tested and exported them to repository.
• Design and development of Web Intelligence (InfoView) for interactive analysis using single sign-on.

Confidential,CA

Sr. SAP BI/BO - TEAM LEAD

Environment: BI 7.3, ECC 6.0, Teradata, BO XI 3.5

Responsibilities:

• Managed and supported the business information team; carry out the IT projects in SAP BI/BO environments.
• Lead the planning, data modeling, detailed requirements analysis and deployment of a project engagement for Inventory Management, Procure-To-Pay (P2P) & Revenue
• Assigning and managing work activities, meeting deadlines and developing project management reporting
• Worked on integration of SAP business objects (XI 3.1) to SAP BW and SAP R/3 environments.
• Ensure that business requirements and technical design of the solutions meet business needs.
• Expertise utilizing webi, crystal reports, xcelsius, business explorer.
• Create web reports with complex calculations to get alerts for xcelsius dashboards.
• Developed Xcelsius 2008 dashboard for Asset Analysis based on asset performance, using Live Office interface.
• Use HP quality center for defects, reporting & tracking post go-live activities, incidents and tasks.

Confidential - SANTA ANA, CA

Sr. SAP BI/BO - PROJECT LEAD

Environment: BI 7.0, ECC 6.0, Teradata, BO XI 3.1/3.5, SQL Server

Responsibilities:

• Led the activities of the global implementations for cross-country client’s business processes & reporting needs.
• Responsible for requirements gathering, design, development & implementation of data warehouse using SAP BI for ETL with custom R/3 extractors and business objects for front-end reporting.
• Used DB connect and UD connect to communicate to 3rd party servers.
• Created universe over BEx query and infocubes using universe designer.
• Actively participated in BOBJ 3.2 tool evaluation as standard reporting tool.
• Created and demonstrated many Webi reports and Crystal reports for pilot project and tool evaluation purposes.
• Defined BO classes, objects in the universe, cardinalities, contexts, loops, joins and aliases.
• Designed various Sales and Inventory reports including Order to Cash, Inventory Management, and Procurement etc. in Webi 3.1.
• Worked on creating new BEx Queries, WebI reports and dash boards for Demand Planning and Supply planning Universes.
• Built xcelsius dashboards mainly using drilldown functionality and several other components.

Confidential, OH

SAP BW/BO LEAD

Environment: SAP BI 7.0, ECC 6.0, SAP web dynpro abap

Responsibilities:

• Team lead for the project (full life cycle implementation) that includes gap analysis, requirements gathering, blue print, development, testing, reporting, and go-live & post go-live support.
• Responsible for creation of design document and functional specifications.
• Monitored the team action items & procedures; developed weekly status reports for the project manager.
• Designed .UNX(IDT) as well as .UNV(UDT) universe. Created derived tables for some of the universes.

Confidential

SAP BW/BO & FLEX DEVELOPER

Environment: SAP BW 3.5, Adobe flex (3.0), SQL server

Responsibilities:

• Participated in the groundwork of project plans, gathered business requirements, prepared blueprint document.
• Responsible for BO reports to be used by the management for decision making.
• Created web intelligence & xcelsius reports, and BEx reports with restricted key figures, calculated key figures, exceptions, conditions, variables and filters.
• Designed front-end application in flex 3, developed flex UI components & integrated with BSP applications in SAP.
• Integrated adobe flex & SAP-BW using web services for rich user experience.

Confidential

SAP BI DEVELOPER

Environment: BW 3.5, ECC 6.0, SQL server, Enterprise portal

Responsibilities:

• Gather, document and translate client’s requirements into functional & technical specs, and wrote scope for the development.
• Involved with various database administrators to map the requirements and to propose new solutions.
• Worked on BEx query designer to create custom queries, and embedded those as iviews in the enterprise portal.
• Designed manuals, conducted workshops and training to the client.

Confidential

SAP TECHNICAL DEVELOPER

Environment: Portal EP6 WAS 6.40, guided procedures, Adobe live cycle designer8.0, SAP netweaver 7.0, xRPM

Responsibilities:

• Executed an on-site delivery model, developed product request process using adobe interactive forms, and integrated in ECC/xRPM back-end.
• Developed a guided procedure process in enterprise portal that used 4 different online interactive forms.
• Developed a portal iview to upload documents for supporting product requests using knowledge management API’s.

Confidential

ADOBE FLEX CONSULTANT

Environment: Adobe flex (3.0), SAP HR ABAP

Responsibilities:

• Developed an interactive tool for organizational chart with HCM based on AIR application in flex 3.
• Led the pilot phase to get the hierarchy from the back-end (SAP HR) and displayed it in the front-end.
• Created & filled a vacant position by drag/drop in the organizational chart, and the tree structure.

Confidential

SAP BI/BW ANALYST

Environment: SAP BI 7.0, ECC 6.0.

Responsibilities:

• Gathered requirements - user meetings, requirement consolidation, draft specifications and blueprint document.
• Proposed & implemented new idea of reporting using real-time data acquisition for forecasting materials.
• Wrote ABAP routines for the customer exit variables, and for the transfer, start & end - routines.
• Created BEx query to display KPIs - # of materials that had completed/in-process/rejected the registration process.

Confidential,OH

SAP BW & FLEX CONSULTANT

Environment: SAP BW 3.5, SAP R/3 4.7, SQL server, Adobe flex (2.0 & 3.0)

Responsibilities:

• Performed data modeling & requirement analysis by interacting with client’s functional consultants.
• Worked on the design & implementation of BEx queries & dashboards using flex, and integration with BW/BI.
• Executed BI spend analysis - ABAP data model, RFC developments, and flex implementations for rich user experience.
• Created re-usable flex components, and utilized them to reduce development.

Confidential - SAN DIEGO, CA

SAP BI SUPPORT CONSULTANT

Environment: SAP BI 3.5, ECC 6.0

Responsibilities:

• Involved in load monitoring of daily/weekly/monthly data loads using process chains, and fixing the failures to complete the loads in the given time.
• Provided support and proposed solutions to solve the business complexities.

Confidential - PHILADELPHIA, PA

SAP TECHNICAL CONSULTANT

Environment: SAP BW 3.5, SAP R/3 4.7

Responsibilities:

• Performed system analysis, identified tables, function modules and BAPI to meet business requirements.
• Involved in production support activities – perform root-cause analysis, provide corrective measures, and suggest preventive actions throughout the project.
• Enhanced existing reports and implemented email notifications (with pdf attachments) to improve business processes.
• Trained on SAP R/3, ABAP data dictionary, BDC, module pool and ALE.
• Overview of SAP functional domains (viz. PP, MM, SD, FI/CO).
• Design, configure & test enhancements for customer returns & pricing procedures.
• Customized user exits, custom development and enhancements with minimal maintenance & optimal performance.
• Case study on sales & distributions (SD), customization & configuration.