SUMMARY:

• Over 9 years of professional experience in design, development, implementation of SAP BW application with the latest project in native HANA.
• Worked on 3 complete full life cycle Implementations.
• Extensively worked in overall design, development in SAP BW for establishing corresponding data models, usage of front - end reporting tools, ETL tools, and solutions related to technical issues.
• Hands on experience creating attribute views, analytic views and calculation views in native HANA.
• Experienced with SQL script based Calculation view in HANA for more complex requirements.
• Strong domain knowledge in Supply chain (SD, MM), FI.
• Worked extensively in BOBJ reports using new Confidential connection and developing complex WEBI reports, merging queries at the report, developing dash boards.
• Worked on business analytics tool to improve organizational performance using corporate performance management tool.
• Worked in trouble shooting and resolving BOBJ issues and performance tuning of BOBJ reports.
• Extensively worked in designing and implementing SAP BI solution from scratch that includes requirement gathering, GAP analysis, designing, developing solutions.
• Expert in working with different business groups, understanding business challenges, user requirements and converting the business requirements into functional, technical specifications accordingly.
• Exposed to all phases of a project life cycle including analysis, design, development, testing, and deployment of solutions, and post-production support/maintenance functions
• Extensively worked on developing SAP BW components like Info Cubes, Multi-Providers, Info Source, Info Objects, ODS objects, Open Hub, Process Chains, Transformations, Update rules, DTP’s Variables, Transfer rules, User Exits, Extractors, RRI.
• Expertise with designing enterprise reporting security authorization strategies by using analysis authorizations (RSECADMIN), customer exit/authorization variables and also by working with security team to restrict the reports to a small user set.
• Expertise with BW reporting using BEx Analyzer, BEx Query Designer and implementing BEx Queries using calculated and restricted Key figures, variables, cell conditions, workbooks, security roles and profiles.
• Extensively worked on BEx queries, improving performance of BEx queries and created Custom Queries using Conditions, Exceptions, Variables & Structures.
• Extensively worked in handling and migrating reports across environments using LCM jobs.
• Experience in developing Analysis for Office workbooks and WEBI reports.
• Familiar with the data modeling concepts of BW on HANA.
• Extensive experience in developing various kinds of documentation like Business process documents (BPD), Functional Specs (FS), Technical Specs (TS), Report Specs, Cut-over documentation, Production support documentation etc.
• Familiar with the new concepts of 7.3 like composite provider, hybrid provider, transient provider etc.
• Good technical and functional upgrade experience from 3.5 to BI7.0 and 7.3.
• Strong production support experience involving data load monitoring, data load fixes, improving loading performance etc.
• Excellent communication skills, leadership qualities, systematic approach and ability to work effectively in a fast paced environment.

WORK EXPERIENCE:

Confidential, Santa Clara, CA

Sr. SAP HANA Developer

• Involved in business reporting requirements for SuccessFactors (SF) project.
• Worked with BODS team to bring data from SuccessFactors to HANA enterprise using BODS tool.
• Created custom HR schema (for isolation of sensitive data), created custom tables in HR schema and populated them through BODS on a nightly basis.
• Developed attribute view, analytic and calculation views and created BO reports on these native HANA models for SF - Employee Central reporting.
• Developed SQL script based calculation views to support complex reporting requirements that were difficult to meet with graphical views.
• Extracted headcount budget information from internal SQL database into HANA through BODS and integrated it with SF data for headcount comparisons.
• Implemented row level security of the sensitive HR information through analytic privileges, SQL procedures defined in SAP HANA.
• Created workbooks using Business Objects analysis office tool using HANA EDW as data base.
• Created Spotfire dashboard for visualization of HR information along with the contractor details from Field glass.
• Performed a detailed tool comparison between the dashboarding capabilities of SAP Lumira and TIBCO Spotfire & provided the tool choice recommendation to the management team.
• Developed UNX universes on top of HANA models and created the corresponding WEBI reports for end user reporting through BOBJ Launchpad.

Environment: SAP HANA 1.0 (SP9), BW 7.4, SAP BO 4.0, SD, MM, FI, WEBI, Dashboards, Crystal Reports, Universe, Analysis for Office

Confidential, Houston, TX

SAP BW/BO Sr. Developer/Team Lead

• Led the Business Intelligence team for DNOW and extensively worked on projects post spin off from NOV.
• Involved in the support of post go-live issues with Business Objects reports, MM and SD reports.
• Led the HANA POC project for evaluating the capabilities/advantages of performing development in native HANA (virtual data models).
• Led requirement gathering sessions post go-live for the newly formed company.
• Created several reports in BOBJ (WebI, Crystal reports and Dashboards) by Confidential connectivity using CMC.
• Set up Single sign-on across the board and developed few complicated WebI reports that are suitable for various branch managers to monitor daily sales and revenue.
• Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information and security authorizations post Spin off.
• Worked extensively on international sales reports which projects, the sales, discounts and the overall day to day performance at the branch level.
• Initiated and led the installation of new GL in the BW landscape.
• Conducted many workshops to gather the business requirements for the newly formed company.
• Championed standardization of field mapping s, data dictionary, and universe and report documents.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Worked on blueprint and migration efforts for the newly acquired companies by DNOW.

Environment: SAP BW 7.3, SAP BO 4.0, SD, MM, FI, WEBI, Dashboards, Crystal Reports, Universe, Analysis for Office.

Confidential, Deer Field, IL

Sr. SAP BW/BO Developer

• Extensively involved in the support of post go-live issues with FI, MM and SD reports.
• Developed new BEx queries with structures and hierarchies to meet year-end financial reporting requirements.
• Prepared the system for upgrading to BW 7.3.
• Led requirement gathering sessions and participated in workshops with the business users for HCM reporting requirements.
• Worked on business analytical tools to improve organizational performance through financial consolidation, budgeting and streamlining the reporting process.
• Installed business content in PA and OM modules to facilitate reports on Employee movements, hires, terminations, open position, time to fill etc.
• Developed Cost center based authorization object to provide data level security for the users accessing the report based on their departments.
• Worked on Financial Extractors involving extraction of General Ledger Direct Line Items & Transaction Figures.
• Created the Costing Based COPA data source, and extracted all the value fields’ data into the COPA Infoproviders.
• Created several BOBJ WEBI reports by Confidential connectivity using the CMC and InfoView.
• Created OSS messages with SAP for several issues in BOBJ4.0 and Analysis for Office.
• Developed AO 1.3 workbooks for Financial user base that requested an excel front-end and worked extensively on hierarchies.

Environment: SAP BW 7.0, SAP BO 4.0, SD, MM, FI, WEBI, Analysis for Office, CPM

Confidential, Northbrook, IL

Sr. SAP BW/BO Developer

• Conducted reporting workshops to gather BW report requirements from Confidential Canada and Mexico business teams.
• Worked extensively in performing fit-gap analysis for standard content and documented the identified customizations/enhancements.
• Designed development LSA++ based architecture strategy for BW 7.3 on HANA implementation.
• Introduced SAP BW and BO reporting tools to business audience by conducting multiple workshops and learning sessions.
• Enabled OLAP Cache for all info providers and Query’s to improve BEx Query performance.
• Worked with business teams in identifying the data security requirements and then designed a strategy for analysis authorizations in BW.
• Identified currency conversion requirements, required KPIs, language translation requirements etc. for a successful rollout of Confidential Americas implementation
• Developed Analysis for Office workbooks and WEBI reports in BO 4.0 landscape.

Environment: SAP BW 7.3, SAP BO 4.0, HANA, SD, MM, FI, FSCM, WEBI, Analysis for Office.

Confidential, Jackson, MI

Sr. SAP BW/BO Developer

• Worked on the overall design and provided technical recommendation to the Business Warehouse development team in establishing corresponding data models, usage of front-end reporting tools, tool/software alternative, ETL tools, and recommendations related to technical issues.
• Involved in requirement gathering, documenting the requirements, designing, implementing the solution for different complex Requirement and then support the application.
• Worked on upgrading the BW landscape from BW 7.0 to BW 7.3 and resolving the open issues.
• Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries, Workbooks and created Custom Queries using Conditions, Exceptions, Variables & Structures.
• Enhanced standard SAP LO cockpit extractors and developed user exits to populate the new fields.
• Experienced with Business Objects Integration with SAP BI (WEBI, Launch Pad, Dashboards).
• Created List of Values in the Universe Dimension Objects for specific report requirements.
• Created reports using @Prompt Function and defined various Formula Variables in Business Objects.
• Hands on experience on maintaining the BO Repository like managing the user a/c, groups and privileges & roles, maintaining universes etc.
• Created analysis authorizations in BW through RSECADMIN to restrict the data by controlling area.
• Created different types of reports Cross Tab, Charts, and Master Detail using multiple data sources.
• Extensively used Business Objects functionalities like Slice and Dice, Drill Down, Drill Up alters, filters and Ranking were used in reports.
• Worked extensively on standard and custom defined LIS, LO extractors. Used LO structures for extracting sales order, delivery billing information and also Generic for some complex requirements.
• Extensively worked on BEX to develop some complex reports and broadcast to users.
• Written Customer Exit Variables for calculating values with the help of the user entry variables.
• Enabled OLAP Cache for all info providers and Query’s to improve BEx Query performance.
• Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures in WAD to facilitate further data analysis.
• Developed BO Reports using BEx query as the data source using navigation attributes, display attributes, filters.
• Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts.

Environment: SAP BW 7.0, SAP BW 7.3, SAP BO 4.0, SAP BO 3.2, SD, MM, FI, FSCM, WEBI, Dashboard Designer.

Confidential, Portland, OR

SAP BI - BOBJ Developer

• Gathered Business Requirements, Installed required Business Content.
• Designed and developed the Data Model considering all the scenarios for PP, MM and QM extractors, Custom extractors, DSO’s, and InfoCubes.
• Developed flat-file extractors, Program and Transaction to upload flat-file’s - for the ease of user convenience.
• Proficient in loading master data and transactional data both from flat-file and ECC systems.
• Involved in setting up of customized InfoCubes with optimal star schema, Infocube partitioning for query performance.
• Extracted Production Planning, Quality Management, Material Management ‘LO’ extractors into DSO’s and then transformed into InfoCubes.
• Developed custom extractors using view/table.
• Developed programs and incorporated them in the Process Chains.
• Developed custom Factory Calendars in BI based on the report requirements.
• Extensively worked on Transformations, DTP’s, Info Packages.
• Developed Start Routines, End Routines, Expert Routines in Transformations.
• Created Process Chains for On Demand, Daily, Monthly and Quarterly loads.
• Developed BEX Queries in 7.0 Query Designer, created variables and filters to restrict the data to increase the performance.
• Worked on BEX Analyzer and WAD to generate reports.
• Transported the Objects from Dev to QA and Dev to Production.
• Developed BO Universe, connection from OLAP/BEX query and OLTP.
• Created Classes and Objects using the reference of source fields.
• Extensively worked on BOBJ WEBI reports.
• Developed complex reports using merged dimensions, multiple queries, alerts, filters and functions.
• Prepared Production cut-over with all the tasks and Transport objects list.
• Created test cases, performed unit testing, UAT testing and resolved the issues.
• Provided Production support and user training.
• Developed documentation on Data Models, Programs, Reports and Process Chains.
• Provided KT to production support team.

Environment: SAP BI 7.0, Business Objects XI R3.1, Oracle 10g, NetSuite, HP Quality Center, ECC 6.0, SCM - PP & Controlling, MM, CO-PA, SD and QM.

Confidential, Portland, OR

SAP BI - BO Consultant

• Involved in requirement analysis, arranged Gap Analysis sessions to gather user requirements.
• Installed and configured Business objects.
• Installed Business Content and Enhanced Info-Providers according to the requirement.
• Designed several Info Cubes, ODS, Multi Providers, Info Objects.
• Involved in setting up customized InfoCubes with optimal star schema, InfoCube partitioning for query performance.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Worked on the new BI 7.0 ETL process involving Transformations and DTP.
• Used ABAP Conversion Routines in Transfer Rules and Update Rules to massage data before updating data targets.
• Implemented object level security in universe to incorporate security for sensitive information.
• Implemented various levels of user profile rules, such as Folder level, scheduling Business Objects reports or view only access in CMC.
• Used Infoview to create, analyze and publish Business Objects WEBI reports to various groups or users.
• Created universes, universe objects, classes, applied filters and conditions.
• Created fully functional Business Objects Full Client reports by making most use of Business Objects functionalities.
• Generated reports with 2D, 3D and pie charts for business query results.
• Generated various reports with “prompt” functionalities both at universe and report level to enhance end-user interactivity.
• Developed Business Objects WEBI reports with filters, ranks, prompts, drill downs, variables, charts, text cells, cross-tabs.
• Managed universes, reports which are scheduled in weekly, daily, monthly bases.
• Created Dashboards using Dashboard manager and Dashboard universes with metrics.
• Generated complex Business Objects Reports involving numerous prompts, open document functions and taking data through multiple universes.
• Extensively used Business Objects Import wizard and BIAR files
• Worked on new BI 7.0 front end features BEx Query Designer, Analyzer.
• Extensively used BEx Analyzer to build Work Books.
• Used RRI (Report-Report Interface) to jump from summarized query on a cube to detailed query on ODS.
• Co-coordinated testing efforts and actively participated in all phases of testing (System, Integration, Regression and UAT)
• Customized PDF print to include company logo and dynamic column adjustment.
• Trained Business Users & End Users and Worked on Functional Specification Documents and Design Documents.
• Provided production support after go-live.

Environment: SAP BI 7.0, Business Objects XI R3.1, Crystal Reports XI R2, ECC 6.0, Click Software, FI-CO, PM, QM, Oracle 10g.

Confidential, Anchorage, Alaska

SAP BW Consultant

• Involved in requirement analysis, arranged Gap Analysis sessions to gather user requirements.
• Designed and developed backend data models to support various BI dashboards for Upper Management to track KPIs. Conducted workshops to gather reporting requirements. Role included design of Cubes, DSOs, Update Rules, queries and Web Templates.
• Used BIA monitor for technical administration and maintenance of BI accelerator and troubleshooting issues with BIA servers.
• Vendor Spend Report - Designed and developed a comprehensive Vendor Spend analysis report by extracting data from EKPO, EKBE, EKKN, BSEG and REGUH.
• Audited the current security setup in BI and worked closely with senior managers and Basis teams to propose new solutions. Met with Finance controllers to get the requirements to secure finance data.
• Created and activated transformations, DTPs, transfer rules, communication structure and update rules.
• Migrated 3.x Data sources to B.I 7.0 Data Sources with Transformations and DTP'S to take advantage of the new data modelling features provided by SAP.
• Enhanced the BI data sources to accommodate additional reporting requirements and coded user-exits to populate the enhanced fields.
• Created complex reports by linking data using multiple data providers, free hand SQL, stored procedures, flat files and excel files and also used functionalities like combine queries, aggregate awareness.
• Performed Initial Study on the Current Reporting application, to finalize the data elements required for reporting.
• Involved in scheduling the documents for monthly, weekly and daily.
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer(WAD) of key BW reports and created Web Templates
• Developed workbooks, info set Queries and used RRI jump queries to drill down to other queries and R/3 transactions.
• Extensively involved in Unit Testing, Integration Testing and Batch stabilization during Go-Live.

Environment: SAP BI 7.0, SAP ECC (IS-R) 6.0, SAP EP 6.0, SAP SD, MM, Query Designer, BEx Analyzer, Web Application Designer and Windows 7.0

Confidential, Portland, OR

SAP BW Consultant

• Identified the necessary Business Content using content browser and content analyzer, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for master data and transactional data.
• Implemented standard Business Content FI-GL and FI-AP cubes for transaction figures reports.
• Prepared Technical specifications for the Functional Specifications.
• Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating data transfer processes (DTP) using the new BI 7.0 features.
• Worked on ABAP Routines, User exits & Customer exits.
• Written ABAP User exit for customizing the standard BI 0FI GL 1 0 datasource.
• Designed and implemented a custom extractor to extract FI tables from R/3 into BW.
• Using BEx Query Designer (new layout, Exception Aggregation) to define complex queries, defining Exceptions, Conditions which are later deployed in variety of scenarios like Excel workbooks and web applications.
• Expertise with BI reporting for Data Analysis with BEx Analyzer, BI Accelerator, Web Application Designer and implementing BEx Queries, Variables and Workbooks.
• Involved to an extent with concepts of Aggregation Levels, Filters, BEx Query, Workbooks, BI variables, WAD and Characteristic Relationships
• Provided input, recommendations, and resolutions for technical issues.
• Transport Organizer - maintained transport throughout BI landscape.
• Created Queries for both FIGL and BCS cubes.
• Written the User exit for populating the data for the fields, which have been appended to the extract structure.
• Created Different Rule Groups for the Transformations.
• Written ABAP Program for the Customer Exit Variable for calculating “Year To Date” value with the help of the user entry variables.
• Loaded data for Master Data objects (Attributes, Texts and Hierarchies).
• Created Process chains and Meta Chains for loading Master data and also for loading Transactional Data.
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes.
• Created queries in the BEx and also created variables, text variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.
• Designed the Workbooks for all the queries as per the USER requirement.
• Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI7.0 BEx Analyzer.
• Created Open Hubs and performed the process of retraction to get the data back.
• Extracted Hyperion data through the Open Hubs for the reconciliation.
• Worked extensively on the Copy Transports.

Environment: SAP BI 7.0, BW 3.5, SAP R/3 4.7, SAP SD, MM, F&R, BO XI 3.1, Query Designer, BEx Analyzer, Web Application Designer and Windows XP