SUMMARY:

• Having 10+ Years of experience in SAP BI/BW, BOBJ & SAP HANA which involves Multiple Full Life Cycle Implementations in different modules and upgrade projects.
• 16+ years of progressive IT experience, 3+ years SAP security experience.
• Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute Views, Analytical Views, Calculation Views, Analytic Privileges, Stored Procedures and CE Functions.
• Hands - on SLT, BODS & DXC configuration of solution and data migrations.
• Implementing ASAP methodology in different industries like Manufacturing, Chemical and Retail industries which includes different phases like Requirement Analysis, Blue Printing, Realization, Data modeling, Data extraction, Data Loading, Production Support, Testing, Documentation, End user documentation, Reporting and also Go-Live Check.
• Managing the Nearshore & Offshore team and ensuring the co-ordination is happening within the team for internal/external reviews for timely delivery.
• Implementation, configuration and solving module-level issues in SAP modules like FI/CO, FI-SL, FI-GL, LO Cockpit, MM, SD, QM, HR, EWM, PP COPA, AP/AR, BPC and IM.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Report Designer, Web Application Designer, Design Studio.
• Worked on BI/BW security Administration, Authorization objects, Profiles and Roles.
• Working with Global Implementation Rolls Outs, multicurrency environments and complex custom data model implementation environments.
• SAP BI/BW project development involving SAP R/3 data sources and also non-SAP data sources.
• Creating custom DSO/ODS, Info Cubes, Remote Cubes, Multi-Cubes, and Multi-Providers.
• Customized the Data sources by writing the ABAP code for functional enhancement for Master and Transactional Data.
• Creating Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Data Slice, and Characteristic Relationships using Integrated Planning.
• Expertise with BEx reporting & BW Web reporting and developed reports with replacement path, Exceptions, Conditions, Variables, Structures, Calculated & Restricted Key figures, Cell Definitions, Exceptional aggregation, RRI Jump Queries, etc.
• Maintained variables in the TVARVC table and used the same variables in the routines.
• Used Info Spoke of Open Hub Services for exporting data to External Applications viz., flat files.
• Involved in transports from Development to Acceptance using Rev-Trac.
• Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using custom extractors.
• Implemented virtual char design
• Created views in SQL server, based on that views designed cubes in SAP BW and loaded data from SQL server to SAP BW using DBCONNECT.
• Experience in creating Universes over the BEx queries & SAP BW Info Cubes using Universe Designer.
• Expertise in using Universe Designer over BEx queries and Info Cubes to migrate & model data from BW to BO for reporting. Excellent skills to develop reports using WEBI/Design Studio
• Experience in implementing BPC from BW perceptive, like data model developments in BW.
• Prepared test scripts to validate the data between BW and BPC.
• Post Production support, which involve daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team.

TECHNICAL SKILLS:

Data Warehouse: BI 7.0, BI 7.3 & 7.4 BEx 3.x & 7.x.

ERP: ECC 6.0,R/3 4.7, 4.6.

Modules: SD, MM, PP, WM, QM, FI/CO, FI/GL, FI/AR, COPA, HR, TM, BPC

Reporting Tools: BEx, Crystal reports, Live Office. SFDC, Qlikview, Webi, Design Studio, Universe Designer, WAD

Database: SAP HANA, Oracle, MS Excel, SQL, PeopleNet

Languages: ABAP/4, C, PLSQL,.net

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP BW/HANA/BI/BOBJ - Architect

Responsibilities:

• Full life cycle implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Extensively worked with FI General Ledger, Accounts payable data sources for extraction and loading to support client Consolidation Financial Report (Assets, Liability & Income Statement).
• Major reports are based on BW queries and reported in BOBJ (Webi, Design Studio & Business Analyzer).
• Extensively worked on data models in BODS and Information Design Tool.
• Designed User Roles and Authorizations to users for BW and BOBJ security.
• Converted MS SQL database tables into SAP HANA views then developed BW queries.
• Worked with Basis team to install SAP BW on HANA and Activated and enhanced of the Business Content for LO Cockpit Extraction, Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA), & Human Resource (HR) data source & data providers and customizing them as per the client requirement.

Environment: SAP BI 7.4 ECC 6.0, SD, MM, FI/CO, COPA, ABAP/4, BEx, SAP HANA, SAP BOBJ

Confidential, TX

Sr. Tech Lead - SAP

Responsibilities:

• Full life cycle implementation, which involve Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Acted as business Analyst to interact with Project Managers, Department heads and directors for project requirements.
• Analyzed and translated the client’s business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client’s process teams in identifying and documenting necessary KPI and reporting requirements to build a reporting architecture.
• Managing the Nearshore & Offshore team of 7 including onsite project resource and ensuring the co-ordination is happening within the team for internal/external reviews for timely delivery.
• Experience in SAP BPC Consolidation: BPF (Business Process Flow), Appsets, Applications and Dimensions, Defining Data Model, Data Management to Finance & Accounting related reports.
• Experience on installing & enhancing BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set, APD and Open Hub.
• Data Source Objects are created for staging for AP, AR line item data, BPC and BCS multi cubes and Infosets are created to satisfy reporting requirements.
• Activation and enhancement of the Business Content for LO Cockpit Extraction, Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA), BCS, SLC, CRM activity items cube and customizing them as per the client requirement.
• SAP BI ABAP: Created Update rules, Transfer rules, Transformations, Start Routine, End Routine, User exits and functional module code for generic data source.
• Standard extractor and generic extractors are designed to meet the reporting requirement of defining relationship between demand and supply.
• Start routines, end routines are used to cleanse the data before updating into InfoCubes.
• Schedule, performance and monitor periodic data loads from SAP R/3 to BW, delta loading and DSO Loading process.
• Automatic deletion of requests Info Packages and dynamic selection criteria, Help design system landscape.
• Maintained Process Chains to automate and schedule the data loads.
• Designing, reporting templates with BEx Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Customized queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.
• Using complex queries reports are created where universe is the main data provider for reporting.
• Worked on creating HR reports on Headcount, No of Personal actions and Change in Staffing Level.
• Using Left outer join and inner join, Infosets are created and used for reporting.
• Trouble shooting and tuning of the reports.
• Hierarchies are implemented to support drill down reports.
• Assisted end users writing reports and performing Ad hoc Queries.
• Integration of data from ECC, Qlikview & SFDC. Reports gave visibility to onsite sellers about current price for each product that company sells to customers. It is active feedback loop to get current data. based on weekly/months shipments/material movements/paid invoices both from ECC & third party data from Case (Freight Carrier).
• Developed extensive queries to support applications (Price Support, Sales View, Margin Analysis based on COPA) that were developed in third party tool, like Qlikview and SFDC. Also similar reports were developed in Design Studio.
• Driver hours reporting using PeopleNet data. New connection is established to PeopleNet with DB connect.
• Worked on Sales Order Perfect Order Index (POI) design and development of BW models and corresponding reports in Bex as well as Design Studio.
• Migration from 7.0 to 7.3 to support BPC implementation and then to 7.4.
• Revamp of 80% of data providers to accommodate master data object (customer partner function) changes.
• Upgrade Experience in SAP BW from 3.5 to BI 7.3 & 7.4 and in depth knowledge of migrating data sources from BW 3.x to BI 7.x.
• All corporate BW workbooks migrated from 3.x to 7.x version (around 1500). Business user validation before and after is completed successfully.
• Migrated Financial data models (Special Ledger, FI & COPA) into SAP HANA.
• Implemented virtual char design into multiple existing reports to accomplish business requirement without dumping existing data from multiple info providers - accomplished by using BAdi.
• Worked on Cutover Activities (TCO & ACO) on monthly and quarterly basis which involves execution of cookbooks during the cutover activity.
• Implemented Vistex Module to support business requirement of Agreement Request and Agreement types of data.
• Implemented & Integrated Transport Management Module into existing BW/HANA models to accomplish business requirements.
• Worked on SAP BW to SAP BW-on-HANA project migration with SAP America at the client site.
• Worked on SLT configuration to replicate ECC tables into HANA, also made connections for BODS & DXC for data extraction from ECC to SAP BW on HANA.
• Build and imported SAP HANA optimized info cubes and DSO’s into SAP HANA environment.
• Build HANA information models (Attribute Views, Analytical Views, Calculation Views and Column/Row based tables) in HANA design studio for efficient data integration.
• Developed Real-Time information models to support SLT replicated tables from SAP ECC.
• Created Virtual providers for consuming the data from SAP HANA views.
• Worked on Attribute, Analytic and Calculation Views in HANA to create Data Models and Created multiple schemas and table definitions.
• Created Variables, input Parameters and Calculated/Restricted columns on Calculation Views.
• Build Schemas, analytic privileges and granted permissions for BI users.
• Identified expensive statements using HANA monitoring traces for performance optimization.
• Transported objects by creating delivery units between SAP landscapes.
• Expertise in using Universe Designer over BEx queries and InfoCubes to migrate & model data from BW to BO for reporting. Excellent skills to develop reports using WEBI/Design Studio
• 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).
• Created universes, classes and objects by retrieving data from the data sources like BW queries and defining necessary connections.
• Designed universes based on SAP BW info cubes.
• Lead member to support BPC on BW integration, like data extraction from BW to BPC for consolidated all the data from various modules and data retraction from BPC to BW for planned/budgeted data.

Environment: SAP BI 7.0, 7.3 & 7.4 ECC 6.0, SD, MM, FI/CO, COPA, ABAP/4, BEx, SAP HANA, SAP BO, Qlikview, SFDC

Confidential, Ohio

SAP BI/BW Developer

Responsibilities:

• Full life cycle implementation, which involve design, development, extraction and reporting of the data from R/3 system and flat files in to BW system using LO Cockpit Extraction methods for SD, MM, PP modules.
• Analyzed Info Cubes and DSO to meet the reporting needs of the client.
• Observing all periodic schedules like daily/weekly and monthly is successful.
• Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.
• Data modeling techniques like Transformations, DTP’S, Data migration, DSO and structuring the info cubes as per the requirements.
• Activation of SAP Business Content for LO Data like SD, MM, PP, SPM InfoCubes and Data Sources for Master and Transactional data.
• Created MultiCubes such as Demand cube, Supply Cube and Inventory Cube.
• Setup Tables for the LO Cockpit extraction.
• Used T.code 0LI7BW to create setup tables based on the document range for the LO-Cockpit extraction.
• Performed V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BI system.
• Extracted data from MM inventory (2LIS 03 BF data sources), and PP (Production Planning and controlling) modules and compared with POS-DM data.
• Extracted Production (PP) and Process Orders (PP-PI) to analyze manufacturing orders.
• Process Chains for periodic upload of the master data as well as the transactional data are created.
• Formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures are created for developing complex custom reports.
• Integrating SAP Business Objects with SAP BI data sources.
• Responsible for designing new BEx queries and also performed modifications to existing queries using BEx Query Designer as part of query analysis and performance tuning.
• Reports like “confirmed quantity”, “item purchase orders”, ” quantities delivered” and” purchase order values “are created up on clients request.
• Developed reports on the MM cubes to check the price variance for materials from different vendors.
• Conducted Testing - Unit, and participated in Functional, Integration, and User Acceptance.
• Reports developed on SD cubes for displaying sales figures and incoming orders.

Environment: SAP BI 7.0, ECC 6.0, FI/CO, COPA, SPM, MM, BEx Analyser/Browser.

Confidential, Dulles, VA

SAP BI/BW Consultant

Responsibilities:

• Involved in the development of the user requirements, testing, initial phase of production and thereby possessed a good understanding of complete life cycle implementation.
• Involved in upgrading the BW 3.5 to BI 7.0.
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support.
• Implemented SAP BI 7.0 for SD, MM, FI, and CRM modules and expert in designing data flow from R/3 to BI system.
• Designing and Development of the Business Information Warehouse and enhancing the Business Content Info Cubes and R/3 extractors using ABAP/4.
• Identifying the customer needs, modeling the data and defining the Data Sources at OLTP for the SD, FI and MM module.
• Activated Business Content for standard SD, MM Info Cubes, Info Sources and Info Objects and enhanced standard Business Content based on client requirements for Transaction, master and texts data
• Expert in Data modeling techniques like Transformations, DTP’S, Data migration, DSO and structuring the info cubes as per the requirements.
• Analyzed the PP info cube and DSO objects to meet the reporting needs of the end user.
• Data is extracted from Production orders and Process orders to analyze manufacturing orders.
• Extensively involved in performance tuning of the info cubes by using Aggregates, Indexes, Partitions and Compression techniques.
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW/BI system.
• Extracted data from FI, SD and MM modules of SAP R/3 and from flat files into SAP BI System.
• Used multiple layers of DSO to stage the data before transferring the DSO contents to the Info Cube and worked extensively on Data Marts.
• Transported the objects from Development to QA for testing.
• Wrote Business Logic at Transfer Rules and Update Rules levels in BW and worked on Data Cleansing, Data Mapping, Data Formatting and Data Conversions.
• Used both initializations with Delta Update and Full Update methods depending on the business requirement.
• Generated and maintained aggregates and rollup activities on SD Info cubes as part of the Info Cube Management.
• Created and monitored various Process Chains, Managed and monitored data loads, job scheduling and updating DB Statistics regularly and rebuilding missing indexes for increasing the Query Response.
• Report development on manufacturing modules like MM, PP, QM and integration experience with FICO.
• Used RRI (Report-Report Interface) in order to get detailed information about Sales orders.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Reports like Confined Quantity and Item Purchase orders, Purchase Order quantities delivered, Purchase order Values are created.
• Created Conditions, Exceptions, Structures, and Variables to use them in BEx Reporting.
• Extensively involved in the Performance Tuning of Info Cubes and Query reporting.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Query variants using BEx Analyzer.

Environment: SAP BI 7.0, SAP BW 3.5, ECC 6.0, BEx Analyzer, SD, MM, PP and SCM.

Confidential, Cupertino, CA

SAP BI Consultant

Responsibilities:

• Analyzed business reporting requirements that could be satisfied by Business content Info Cubes for Cost and allocations.
• Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BI system.
• Created custom InfoCubes and worked on line item dimensions and standard DSOs.
• Transformations, DTPs and InfoPackages are created for loading master data and transaction data from R/3 and extensively involved in data extraction from SAP R/3 using Generic Extractors.
• Worked on creating aggregates and BI accelerators, applied compression and portioning techniques to tune the query performance.
• Developed programs to populate reporting customer exit variables.
• Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing complex custom reports and dashboards.
• Web Application Designer (WAD) is used to facilitate the analysis in a drill down or summarized way to give detailed levels of data.
• Extensively worked on automation of BW processes through process chains and Meta chains with full and delta mechanisms.
• Conducted training on BEx usage for Business Users and Web training and new features to power users.
• Involved in creation of different types of reports such as month to date (MTD) reports, year to date (YTD) reports, monthly reports, quarterly reports and annual reports for a facility analysis.
• Created and maintained queries containing restricted and calculated key figures, filters, and conditions and structures in BEx and presented in Workbooks.
• Involved in assignment and maintenance of Roles and Authorizations to users for BI security.
• Participated in End-User Training as part of Knowledge transfer.

Environment: SAP BI 7.0, SAP ECC 6.0, BEx Analyzer, Query Designer, Report Designer.

Confidential, Detroit

SAP R/3 Security Consultant

Responsibilities:

• Adding and removing T Codes to the existing roles as per client requirements.
• Analyzed root cause of security failures to resolve help desk tickets: support unit and integration testing of roles/profiles.
• Used Central User Administration (CUA) to handle & distribute users & profiles.
• Other functions included like password resets, and un/locking user IDs.
• Set up derived roles for regional service provider roles for Asia-Pacific, Europe and US.
• Performed Unit testing & Quality testing.
• Performed both transport and mass transports.
• Troubleshoot security/authorization related problems using SU53, ST01 & SUIM
• Organized and maintained audit trails for changes made to user accounts, roles & security profiles.
• Periodically Modify, View Security Audit Log with SM19, SM18 & SM20
• Documented the work done on profiles, design, user access, profile maintenance, and security procedures.
• Mass User Creation by using CATT script.
• Administered ID information for over 8000 users.
• Provided 24/7 support as part of the QA & Production Support Team.

Environnent: SAP 4.6C, ECC 5.0, Oracle 9.2