SUMMARY:

• SAP BW/BOBJ/HANA Techno Functional Consultant with 15 years of Extensive experience in SAP BI/BW/BOBJ implementations, Design, Development & testing of software & business applications primarily servicing Telecommunications, Human Resources, Manufacturing & Insurance sectors.
• Proven ability to tackle challenges and a demonstrated ease in understanding emerging concepts combined with an excellent client satisfaction. BW/BI/BOBJ/HANA
• Excellent Hands on experience on SAP BW 7.3/7.x/3,5, SAP BOBJ XI3.x/4.x versions.
• Functional expertise in SAP HR (PA, PT, PY, E - recruitment, Learning solutions, Performance Management), SCM (MM, Purchasing), CRM, BPC, FI, SD
• Expertise in SAP ASAP methodology i.e. project preparation, business blueprint, realization, final preparation and go-live & well versed with Agile.
• Upgrade experience including proposing a detailed plan for upgrade from BW 3.5 to 7.x and post upgrade support.
• Expertise in Business Objects XI 3.x/4.x Universe designer tool, Information Designer tool Desktop Intelligence, Web Intelligence & Dashboard reporting.
• Expert in Data modelling using ERM, MDM & BBI Extended Star schema models.
• Expertise in creating functional requirements, translating business requirements into technical requirements, building test plans & procedures for performance testing, Integration testing.
• Analysis and Implementation of SAP-BI/BW for SD (Sales & Distribution), MM (Material Management) & HR (Human Resources) modules.
• Involved in SAP BW data Extraction, Modeling and Reporting using Bex.
• Extractions - Extracted data from Logistics (SD, MM), LO (Logistics) Cockpit, HR Generic data sources (RSO2) and Flat File.
• Designed and developed Info cubes, ODS, Info set, Info Sources and Master Data.
• Hands on expertise of enhancing & extending the sap delivered Data Sources from Business Content & creating generic data sources using ABAP Function modules.
• Experience in developing Bex queries/Reports using Bex Query designer and usage of Restricted Key Figures, Calculated Key Figures, Structures, Conditions, Exceptions, Variables and Processing Types.
• Extensive knowledge of Standard and Custom Info Cubes, Info Object and Info Sources, Transfer/update rules, Transformations, Web reporting using web application designer, Transfer Structures, Data store objects (DSO), and Business Explorer (Bex).Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains using Events, Data source Enhancement, OLTP data extraction, data Loading using Info packages & Data Transfer process(DTP), Monitoring, Remote Cubes, Multi Providers and Open Hub Service, Report to Report Interface (RRI). Theoretical knowledge of extraction from FI-SL & COPA.
• Well versed in using Performance Tuning Techniques like RSRT, RSRTRACE, Aggregates, and Compression Techniques, writing start & Update routines using ABAP, User Exits in Enhancements.
• BW - APO: DP, SNP Planning area integration with BW Virtual Info Cube and APO Reporting. Design and Setup Transaction data for APO.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Capable of Conducting sessions for users in BW reporting, security, business process documents.
• Good Knowledge of ABAP. Coded start Routines, end routines & update routines using ABAP/4, to meet the client requirements.
• Extensive ABAP experience related to BW in customizing/extending SAP delivered extractors, writing function modules etc.
• Good functional Knowledge of BPC 10.1 on Hana wrt Cost Center Planning, Profit and Loss Planning, Revenue, Spend, Head Count and Gross Margin Planning, Budgeting and Forecasting processes in BPC.
• BPC Legal Consolidation, FX translations.
• Extensive experience in implementation and configuration of SAP FI/CO modules- GL, AP, AR, Customer Master, Vendor Master, House Banks, Fixed Assets, Controlling Area, Cost element & groups, Internal Order, Cost Center Accounting (CO-CCA), Cost center Profit center Accounting(CO-PCA) and Profitability Analysis(CO-PA) and SEM as source systems for BI/BW. Also, have good knowledge in SD and MM.

TECHNICAL SKILLS:

ERP: SAP NetWeaver 2004s BI 7.0, SAP BW3.5/3.1c/3.0B, SCM4.0 APO DP, SAP R/3, (4.6 C /4.7), SAP ECC (5.0/6.0), SAP EP

Languages and Tools: BI 7.0, BW 3.5/3.1C/3.0B, ABAP/4, C, PL/SQL, Bex Query Designer, Bex Analyzer, Workbooks, Web application Designer, WEBI, DeskI, PL/SQL, ABAP, MS Visio, Outlook

Expertise in BW/BI: Modeling, Reporting, Extraction, Enhancements, Performance Tuning

Technologies in SAP ECC (ABAP): Reports, ABAP Objects, User Exits, Agile

SAP New Dimension: BW/BI 7.X, SCM 4.0 APO DP, EP, SAP BPC

Functional Domain: Human Resources (HR), Sales and Distribution (SD), Material Management (MM), FI

Databases: Oracle 8i/9i/10g

Operating Systems: MS-Dos, Windows 9X/2000/XP/2003 server

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

BI/BW/BOBJ/HANA Architect.

Environment: SAP ECC 6.0, SAP BI 7.x, BW 3.5, BPC 10.1 Oracle 10g, BOBJ XI 3.X, 4.X, PL/SQL

Responsibilities:

• Analyzed the AS-IS and TO-BE Models, gathered End-User requirements, developing Technical Environment/Landscape evaluations, prototyped a functional BW System.
• Writing technical specifications, development of various business critical reports using SAP BW 7.x, 3.5, development of various dashboards using BOBJ Reporting suite.
• Hands on experience working with Webi reports, creating dashboards using Design studio, Analysis for office.
• Integration of various BW/BI Bex query reports into SAP enterprise portal by creating web templates & Iviews.Devlopment of various Human resources related Bex reports, by extracting the payroll, time, data from SAP R/3 systems into BW.
• Responsible for New Application Design, Development, Testing & implementation as well as providing application support.
• Responsible for interfacing with legacy systems to upload data into SAP BW & SAP HR systems.
• Responsible for creation of various interfaces like DBConnect, UD connect to transfer the data from different data base systems into SAP BW.
• Designed & Developed the BOBJ 3.1 WEBI reporting on top of BW/BI systems for Management reporting. Utilized the BW Bex queries as a source for WEBI & Crystal Reports.
• Worked with SAP for performing various housekeeping activities as a part of database migration.
• Expertise in creating a Universe usingUniverse designer/Information design toolfrom various source systems and exporting them ontoInfo view / BI Launch pad
• Extensively usedCalculations, Variables, Prompts, andSorted inputs, Drill down, SliceandDice,Alerts, Input Controls, Tracking Changes, Sorting and Rankingfor creatingvarious Bex query interactivereports
• Build and enhance BW backend objects BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, DSO, Extractors, Info sets, Aggregates, Process Chains, User Exits, BADI.
• Performance Tuning using aggregates, Indexes, optimizing the start routines etc.
• Support the on boarding and of BW Power Users. This includes providing technical of key BW toolsets such as BEx web analyzers, Bex query designers, Business Objects.
• Developed Dashboards using WEBI.
• Active Participation in Maintenance and Support of production system under SLA.
• Process Chain run-time optimization by parallel processing and optimal usage of app. servers.
• Led (/involved) the team through SDLC life cycle (Requirement gathering, gap analysis, HLD, Detail Design, Development, Unit testing, Assembly testing, System test support, migration to Production environment and post go-live support).
• Coordinating between onsite team & offshore team to resolve issues for e- CORP System
• Coordinated closely with team in resolving various maintenance tickets.
• Involved in maintenance and support of production system under SLA.
• Coordinating between onsite team & offshore team to resolve daily issues for both e- CORP and e-LINK System.
• Initiated Job Aids for the Production Issues and their resolutions
• Actively participated in system validation during System maintenance/Bounce
• Coordinated closely with Basis team during Server Shift (Primary to Failover and vice versa)
• Primary responsible for Daily Operations SLAs with Client and Monthly SLA Metrics with Client
• Coordinated closely with team in resolving various maintenance tickets
• Coordinating between onsite team & offshore team to resolve issues for e- CORP System.
• Worked extensively in collecting the BI objects to the transport requests, released all transports to the Quality/Production system and resolved issues related to transport failures.
• Responsible for providing the estimates of the amount of the time required for development design and unit testing of the applications developed.
• Enhanced the data sources 0REQUI ATTR (Requisition), 0CANDIDATE ATTR (Candidate), & 0CDCY ATTR (Candidacy) of E-recruiting application component to meet the end user requirements as a part of Contingency Planning & project.
• Extracted the data from E-recruiting data sources like 0PA ER 1 (Requisition support team) 0PA ER 3 (Candidate Qualifications) over to BI7.0 & developed custom reports for the users as a part of project CPT (Contingency planning & ).
• Configured the data source 0HR PT 2 (Employee actual times) for BW, of personnel Time management domain for the new Time Types & wage types client introduced and made sure the data gets extracted over to BW.
• Extracted the data from data sources 0HR PA 0 (Employees), 0HR PA PA 1 (Head Count), 0HR PA 1 (Personnel actions) of Personnel Administration application component, 0HRPOSITION (position), 0ORGUNIT (Organizational unit) data sources of Organizational Movement applications components respectively to BI.
• Enhanced the masterdata data sources for 0EMPLOYEE, 0PERSON to pull the custom attributes for the client and extracted the master data over to BI.
• Extensively worked on the delivered extractors like 0HR PY 1 (Payroll data) from Payroll domain and extracted the data over to BI and loaded the data into BI Info cubes & Data store objects.
• Worked on creating a variety of BI 7.0 Bex query reports for the above modules for the client using restricted & calculated key figures, user exit variables, structures, jump queries etc.
• Developed complex BEX query reports for the project BCP (Business Continuity planning) which enabled the management to get the list of the locations with excessive employee absenteeism.
• Enabling the business content data sources to suit the client needs.
• Testing the important BW backend extractors and objects during the support package upgrades and resolving the issues.
• Transfer of the Business Content from SAP Personnel Administration(PA), Payroll(PY), personnel time management(PT) & E-recruiting (PA ER) areas of SAP HR modules to active version with all its dependent objects like update rules, Info Sources, Transfer Rules, Transformations, Info cubes, data store objects etc.
• Created detailed Technical Specification documents based on Functional & business requirements before finally developing in the Development System.
• Created the unit & system test plans for system testing, fixed the defects raised in system testing & user acceptance testing. Validated all the migrated objects in production environment, created the process chains, scheduled them to extract the necessary data for the reports.
• Set up master data and transaction data in BW & R/3 systems for unit & system testing.
• Optimized the performance of BEX Queries by changing the Cache mode and creating the Aggregates.
• Writing the ABAP code in the in the Info Package for the selection of particular data. Extensive ABAP experience related to BW in customizing standard extractors, writing function modules.
• Developed new programs, function modules using ABAP to satisfy the client’s requirements.
• Ensured that ABAP programs developed are optimized & compliant with best coding standards.
• Set up reporting agent with the ability to write exception/condition queries, which automatically notify users using e-mail alerts.
• Prepared user Manuals and conducted user before going live.
• Developed Proof of Concepts (POC) for visualizing the data using Tableau Dashboards & also built the POC for SAP BW on HANA representing the new functionalities on BW4/HANA.
• Extensively worked on ADSOs, Hana Optimized Info cubes, composite providers, Analytic/Attribute/Calculation views, Open ODS, ODS Views, SAP Hana Studio, SAP BWMT.
• Hands on experience working with LSA & LSA++ Architecture and adaptation to customer requirements. Knowledge of Native Hana & experience with PL/SQL procedures.
• Cost Center Planning, Profit and Loss Planning, Revenue, Spend, Head Count and Gross Margin Planning, Budgeting and Forecasting processes in BPC.
• Worked on BPC Elimination and driver based Planning implementations using BPC BADI development, testing, integration testing, Script Logic and DMP Packages, Package Links.
• Worked on Unit, functional and Integration testing of SAP BW, BPC Forecast data, Templates development and testing for Rolling Estimates Calculations.
• Worked on developing Reports and templates for P & L Summary and Balance Sheet Summary.
• Worked on delivering outbound interfaces to send data for SAP BPC Consolidation and third party systems after the data is eliminated out of SAP BPC Environment.

Confidential

Sap BW Consultant

Environment: SAP R/3 4.7, SAP BW 3.5, Oracle 9i and Win NT/2000.

Responsibilities:

• Identified data sources based on end-user reporting requirements, and Created Info Cubes from data extracted from different modules:
• The data sources were filled with Data from various MM, SD, tables like MARA, MAKT, KNA1, VBAK, VBAP, VBRK, VBRP etc.
• Loaded the data from the data sources like 2LIS 11 VAHDR (Sales document header data), 2LIS 11 VAITM (sales document item data) into BW.
• BW Business Content data source enhancements, generic extractors, User Exits and customized delta built up for the datasources.
• Interacted with Functional consultants for field mappings for various fields used in the reports.
• Activated the business content for the sales overview info cube 0SD C03 and customer cube 0SD C01.
• Worked on full & delta loading to the above cubes from the underlying ODS.
• Created and Scheduled Info Packages for Delta Initialization (Full Load + Selection Conditions) and Delta data loading in to Info Cubes via PSA, ODS objects.
• Extensively involved from design, development of several reports from simple to very complex BEx query Reports.
• Designed process chains to schedule daily/weekly/monthly data loading for master and transactional data.
• Experience with implementation of BW Integrated planning solutions.
• Worked with start routines & update routines according to the client requirements.
• Created aggregates on the queries for improving the query performance.
• Designed web templates with the web items, interactive charts, filters etc., using WAD and deployed them onto EP.
• Developed Queries in Bex using Calculated key figures, Restricted key figures, Virtual Key Figures, Virtual Characteristics, Structures, Variables, Conditions, Exceptions, Replacement Paths for Formulas and Characteristics.
• Resolved Query Performance issues using transactions like RSRT, RSRTRACE.

Confidential

Sap BW Developer

Environment: SAP R/3 4.7, BW 3.5, SAP SCM4.0 APO DP, Oracle 9i and Win XP.

Responsibilities:

• Extensively involved in LO Cockpit extraction by maintaining the extract structures and data sources, for SD documents and Logistics for Order, Delivery and Inventory Management.
• Used ODS to stage the data before transferring the ODS contents to the Info Cube.
• Developed customer specific reports based on the installed Business content cubes.
• Created several process chains in BW and APO systems to automate the complete system using different process types viz. scheduling IPAK, ABAP program, calling remote process chain, reporting agent.
• Developed complex start routines at Update rule and transfer rules, and ABAP routines at info package selections.
• Created transfer rules and update rules for data consolidation and cleansing.
• Uploaded data into APO Info Cubes, and validated the data against BW cubes.
• Developed multi providers using info cubes and created reports on them for comparing the actual & planned sales data.
• Worked on creating BW info sets & created Bex Reports on them.
• Worked on exceptions, conditions on various Bex reports. Used RRI interface for Jump queries
• Worked on open hub destinations for transferring the BW data to other systems.
• Got hands on experience in working on APO DP Planning object structures, planning areas, planning books, forecasting the demand using various forecast techniques, Life cycle planning, Phase-in/Phase-out profiles, Macros.
• Experience with implementation of BW Integrated planning solutions.

Confidential

BW Developer

Environment: SAP R/3 4.6, BW 3.1C, Oracle 8i and Win XP.

Responsibilities:

• Extracted SAP R/3 data from diverse data sources viz. quotations, sales orders and deliveries.
• Uploaded data for analysis into Info Cubes, ODS Objects and Master data tables by triggering initialization, delta and full update methods to implement a performance oriented, periodic data transfer strategy.
• Involved in developing complex start routines in controlling the flow of data to the data targets and update routines in transforming the data before uploading to the respective data targets.
• Extensively worked on Process chains for sequential background scheduling of Master and Transactional data and several subsequent processes.
• Developed various queries against various Info Providers in BEx Analyzer and Web-enabled several queries using SAP BW Web Application Designer.
• Designed Process Chain to load Master Data and Transaction Data.
• Transported the Objects from Development server to Testing servers.
• Extensive transformation code in transfer rules, update rules and start routines.
• Involved in Scheduling data loads and delta data loads into BW from R/3.

Confidential

BW Developer

Environment: SAP R/3 4.6, BW 3.0B, Oracle 8i and Win XP.

Responsibilities:

• Uploaded master and transactional data from files and SAP as the OLTP source.
• Worked with Start routines, Update routines according to the client requirements.
• Extensively worked on Process chains for sequential background scheduling of Master and Transactional data and several subsequent processes.
• Developed flexible queries using filters, navigational attributes, and structures. Organized business roles and functions and managed workbooks using BEx Browser.
• Created Process Chain to load Master Data and Transaction Data.
• Set up source system to load both SAP/Non-SAP transaction data to BW. Developed Info Source with enhancing Business Content, activated transfer and update rules.

Confidential

Software Engineer

Environment: SAP R/3 4.0B, SAP BW 3.0 B

Responsibilities:

• Developed a report, which lists the customer name, insurance period, payment terms & prices.
• Created report to display the customer details according to insurance & distribution channel wise. Identified and activated SAP Business Content required for Info cubes.
• Developed an Interactive Report, which displays all the policy numbers of one particular customer, their total value & respective maturity dates.
• Developed a report giving the details of all the new policies in a particular region.
• Used the technical document to design the database tables.