SUMMARY

• Having Around 8 years of experience in software industry which includes, experience in analysis, design, development, testing and implementation of Enterprise applications using SAP BW, BO, BPC, IP and HANA (Native).
• Extensive full life cycle implementation using ASAP methodology, Agile methodology and post Go - Live experience in estimation, analysis, design, development, testing, maintenance, performance tuning and deployment of SAP BI, BO and Planning applications.
• Possess very good functional knowledge of ERP modules e.g. Financials, Controlling, Logistics (SD, MM, IM etc.) And Human Resources. Developed several models as per the client requirements.
• Expert in integrating heterogeneous source systems such as ECC 6.0, SAP APO, SAP CRM, Flat Files & 3rd party Databases with SAP BW.
• Worked in End to End Implementations and Upgrade Projects in BI, BOBJ and HANA. Managed multiple application maintenance/support projects, upgrade projects from BW 3x to BI 7.0, 7.3, 7.4, 7.5 on HANA and upgrade from BOXI 3.1 to BO 4.0/4.1.
• Used LSA++ (Extended Layered Scalable Architecture) which is optimized for BW powered by HANA.Expertise in native HANA Models i.e. Attribute views, Analytical Views, Calculation Views, AMDP Procedures, HANA Optimized Transformations, SQL Scripting etc.
• Worked on User exists, ABAP Workbench Objects, Custom extractors, generated extractors, BC extractors, transformations, IP, DTPs, Bex reports, Query elements, Web templates, Portal Content development, BADI’s.
• Working experience on SAP 7.4 features i.e. Composite Provider, Open ODSviews, Bex Queries; Input ready Query, Advanced DSO, and New Composite Provider, Planning on PAK, Inter-operability of HANA Views and BW Models.
• Experience in creating custom extractors and Generic Extractors, involved in enhancing existing transactional data extractors Modified and created User Exit programs to accommodate additional fields in the extract structure of the data source.
• Expertise in Business Objects 4.0/4.1 Enterprise suite using Web Intelligence, Dashboards, Design Studio. Developed universes on single and multiple sources, OLAP Cubes, BEx queries, Merge Queries, designed the Universes with connection source as SAP and legacy systems. Expert in designing Queries using Webi Formula Editor.
• Experience in building planning layouts using Design Studio (Planning & Analytics) and Analysis for Office 1.5 (Sales Volume Planning & Indirect Planning).
• Individual Contributor with good interpersonal skills. Can integrate with the team and work within the team for the cause of the projects.
• Excellent written and verbal communication skills clubbed with good presentation skills.
• Experienced in the SAP R/3 system involving implementation of the FI, CO, PP, HR, QM, MM, PS, SM, and SD modules.
• Expert in developing custom ABAP code as per the requirement i.e. Virtual Chars / KF, Transformations/Start Routine/End Routine/Expert Routine, Data source Enhancements, Complex Functional Module extractors, ABAP Reports (SE38, LDB, Info set Query, ALV Reports), FM/RFC FM/BAPI/BADI, Module pool Programming, Subroutines, SAP Scripts, Smart forms, Variable Exits, Performance Tuning.
• Experienced in providing complete SAP BI architecture, planning and design solution with SAP ECC, SCM, SRM, SEM, BOBJ, BODS, Dashboards, and legacy systems.
• Experienced in all major tasks of BI implementation such as project definition and blueprint based on high-level business requirements, data architecting, functional design, ETL and technical build-out including data extraction, load optimization and data presentation.
• Managed and developed multiple Sales Planning projects, Cost Center Planning, DSO Planning and Trade Promotion Management (TPM) in BW-IP environments.
• Designed and developed BW-IP real time info providers, aggregation levels, data slices, Planning functions, FOX formulas, BPC Environments, Models, transformations, Conversions, currency conversions, complex business logic, data loading using data manager packages, Input forms and BPC reports using Analysis for office, EPM Add-in.
• Developed complex logic using ABAP, Fox based planning functions and AMDP SQL Script, Debugging the ABAP and Fox Code.
• Working experience on SAP 7.4 features i.e. Bex Queries, Input ready Query, Advanced DSO, New Composite Provider, Planning on PAK, Inter-operability of HANA Views and BW Models.
• Developed SAP IP planning objects on PAK powered by HANA i.e. Aggregation Levels, Standard Planning functions, Custom Planning functions (ABAP and SQL), Filters, CR Derive (ABAP and SQL), Planning Sequence, Table Types, SQL Script Planning functions, HANA SQL Procedures etc.
• Hands-on experience in BW 7.4 features such as Semantic Partitioning, Advanced DSO’s, Analytical indexes, Data Flows, Composite Provider, Cube Remodeling, UOM conversion, DTP, Info sets, BI Admin Cockpit and BW-IP.
• Experienced in SAP BW releases from 3.5 through BW 7.4, SAP R/3 releases 3.1 through ECC 6.0, SAP SEM, SAP SRM, SAP BPC 10.1, and SAP SCM
• Experienced in design and development of global supply chain metrics dashboards using BW metrics data model and Dashboard tool
• Hands-on experience in SAP BOBJ tools in versions 3.1 to 4.1 SP3
• SAP Universe Designer, Information Design Tool, Webi, Promotion Manager, CMS, QaaWS
• Experience in building Dashboards using Design Studio (Planning & Analytics)
• Experienced in creating multiple visualization views using Lumira and BO explorer
• Building Planning models using BOBJ Analysis for Office 1.4
• BOBJ reports on LSA++ Virtual Data layer in BW and on relational universe in HANA
• Proficient in inbound and outbound BODS interface with SAP BW and HANA
• Best practice on LSA++ architecture with BW 7.4 on HANA and HANA Studio using Open ODS Views, Smart Data Access, Transient, Virtual, and Composite Providers
• Data loads to HANA using SLT and ODP extractors
• Publishing HANA Information models in BW
• HANA Information Modeler to create Attribute Views, Analytical Views, Calculation Views, Analytical privileges, Procedures, Decision tables, Tables Types, Repository Objects, Materialized Views, SQL Scripting etc.
• Gather and analyze business requirements and desired features. Also, analyze and estimate feasibility, time and efforts
• Good Knowledge on SAP Fiori Apps, CBP (Customer Business Planning), DSIM, Client side and server side JAVA Programming.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SAP BW Senior Consultant

Responsibilities:

• Managing SAP HCM BW upgrade from SAP BW 7.0 to SAP BW 7.5.
• Responsible Pre upgrade and Post upgrade activities
• Responsible for Project Plan Preparation and Project tracking
• Involved in Pre upgrade activities like consistency check, Clean up activity, Temp table checks, Check/Repair Status of Info Objects, Clean/delete the messages for error logs, Checks for Master data consistency, Clean up background jobs, Repair inconsistent info packages and backup for Bex query outputs before upgrade.
• Involved in HANA migration cockpit install and check pre and post upgrade activities.
• Checked RFC’s and source system connections and replication of source system.
• Involved in Post upgrade activities like check for Delta working fine, Check data flow for master data and Process chain up to Bex query.
• Migrated older version of Bex queries to newer version. Involved in testing the master data and transaction data loads.
• Checked the routines, transformations and DTP’s.Validated Bex query and report output after upgrade.
• Involved in checks for existing and new functionality of BW 7.5. Involved in UAT for Quality and Mock testing before Production
• Responsible for monthly release and change management for SAP BW/BOBJ. Well versed with Solution manager.
• Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality, Flexible Master data staging, and debugging loads using the Data load Monitor.
• Hands on experience undertaking performance tuning activities for SAP BI and BOBJ, managing upgrades, creating technical and functional design and support, up keeping the Knowledge Management System.
• Daily Monitoring of complex Process Chains. Taking care of Daily / Weekly / Monthly Jobs as per client requirements.
• Troubleshooting the process chains and keeping track of the issues that occur and identify to find long term solutions for them.
• Extensively worked on scheduling, rescheduling, decommissioning, setting up alerts, defining dependency of SAP and Non SAP jobs using Control M agent.
• Responsible for Weekly and Monthly maintenance activity for SAP BW/BOBJ.
• Hands on working experience with SAP BO tools set like SAP Universe designer, Web Intelligence, Analysis for Business Explorer, Xcelsius (Dashboard) and SAP BI tools like Query Designer, BEx Analyzer, BEx Web analyzer and Application designer.
• Responsible for monthly release and change management for SAP BW/BOBJ. Well versed with Solution manager.
• Maintenance of documentation of the daily loads, process chain status, etc.

Confidential, Minneapolis,MN

BW - HANA/BOBJ/BPC/ IP PAK Consultant

Responsibilities:

• Design, Develop, Test and Deploy HANA Optimized Customer Pricing Models using SQL Scripting for Trade Planning project i.e. List Price, National LS and Bracket Price etc.
• Developed Several Hybrid HANA models as Attribute views, Analytical views, and Calculation views, Composite providers, Open ODSviews.
• Developed re-conciliation reports to check the data that’s been planned in BI-IP, Retracted to ECC, and brought back to BI and pushed to BPC Info providers.
• Created and Modified Data Manager Packages to load Master (Attributes, Text and Hierarchies) and Transactional Data to BPC from BW and flat files
• Created input forms, Consolidated financial statements and reports using EPM Add-in.
• Design, Develop, Test and deploy several Planning architectures which includes HANA Optimized modelling approach (PAK) for several business processes i.e.TPM etc.
• Developed SAP IP planning objects on PAK powered by HANA i.e. Aggregation Levels, Standard Planning functions, Custom Planning functions (ABAP and SQL), Filters, CR Derive (ABAP and SQL), Planning Sequence, and HANA SQL Procedures.
• Developed BW Transformations using AMDP Procedures via Expert Routine.
• Good experience on Trade Funds, Dynamic Funding, Volume Planning using Promo Planning etc. Expert in troubleshooting the issues.
• Developed Several BW Objects i.e. Info objects, Multi providers, Composite Providers, Advanced DSO’s, DSOs, DTP, Transformation, Info packages, SQL Script, ABAP Workbench Objects etc.
• Developed complex Webi / Web Intelligence reports usingcombined queries, Cross Tab, Vertical Tables, Complex Conditional Formatting, merging dimensions, Breaks, Sections, Input Controls, complex Formulas at Webi Document level andImplemented several dynamic filtersto satisfy the end user requirement.
• Should be hands on and well experienced in designing Lumira dashboards and story boards.
• Should have experience in creating Dashboards, Lumira stories from universe using IDT/UDT by understanding the design as well as using data from multiple sources as well.
• Experience in handling migration of reports from other SAP BO environment to SAP Lumira and its migration related issues.
• Should have very good analytical & visualization skills, ability to handle critical issues faced while designing and supporting Lumira reports.
• Developed several HANA SQL Script Planning functions i.e. Custom Recalc function, After Sync functions, List Price Read, Gross Margin calculations, Indirect Ship Vol rollup to wholesalers, Overlap Rate calculations etc.
• Involved in implementing best practices for HANA enterprise applications i.e. SAP Business Objects Reporting (Design Studio and Webi), Planning on HANA and Reporting.
• Activated complete Business Content statistics (Technical Content), scheduled process chains and customized some extractors and queries based on user requirement.
• Wrote BADI’s to extract and retract data from to BPC environment to BW cubes and DSO’s.
• Used ABAP Object Oriented programming concept in BW routines, like BADI’s, Classes, Methods and includes depending on requirement.
• Worked on number of change requests after Go-Live to facilitate additional requirements.

Environment: BI 7.4, 7.5, IP, HANA, BO 4.1, Design Studio, EPM Add-in, BEx Query Designer.

Confidential, NYC, NY

SAP BW/HANA/BOBJ Consultant

Responsibilities:

• Involved in designing, documenting and configuring the Information Model for the CRM Service BI Implementation.
• Extracted Data from CRM for the Service Contracts, Service Cases, Confirmations and Billing Using business content extractors and as well as generic extractors.
• Created tables, attribute views, analytical view, calculation views and stored procedures for supply chain on time shipment and order visibility analytics.
• Handled the complex business transformation logic in calculation view in HANA.
• Worked on predictive analysis algorithms on sap HANA for the supply chain.
• SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained and fine grained access control.
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
• Created a high-level and detailed HANA implementation and migration plan and develop a training plan for the current development resources
• Leveraged knowledge of data ware house, ETL and software development methodologies to contribute to the overall planning by recommending approaches, identifying resources and developing timelines
• Designed Delivery score card and localization analysis Reports in BO WEBI & Explorer on HANA IDT universes.
• Worked on Business objects explorer integration to HANA for creating BO explorer information spaces for supply chain on time shipment and order visibility analytical reports.
• Should have experience in creating Dashboards, Lumira stories from universe using IDT/UDT by understanding the design as well as using data from multiple sources as well.
• Experience in handling migration of reports from other SAP BO environment to SAP Lumira and its migration related issues.
• Should have very good analytical & visualization skills, ability to handle critical issues faced while designing and supporting Lumira reports.
• Worked on the report to report interface to jump from the aging summary report to the aging detail report extensively involved in creation of secondary indexes on the Data store objects to improve the data load performance and indexes on the Master data tables when they are being used in the navigational attributes.
• Created generic extractors for billing and contracts conditions using the functional module for the discount analysis reporting.
• Developed Reports using exceptions, conditions, offsets, calculated key figures, restricted key figures and exceptional aggregation.
• Developed Service Contract Amortization report which will give the month on month forecasting amounts, month on month actual amounts, total contract amount, total billed amount, and total back log amount with drill down for service organizations, service product hierarchy, tool hierarchy and sales hierarchy.
• Integrated all Webi documents in Net weaver Portal using Knowledge Management (KT) (Both SAP Repositories and File Repositories).
• Analyzed, Implemented and tested New Patch features and Bugs, working closely with SAP Support team to fix existing Product Bugs i.e. Webi Formatting, AAO Variants, Saving AAO Workbooks in NW System, Webi Data Quality Issues, Webi Data Integrity Issues etc.
• Developed 2 super Queries for WISER and CRO to deploy in Xcelsius dashboard reporting using QAAWS (Query as a Web Service) methodology.
• Published all these Webi Documents and Xcelsius documents in Infoview. Tested LDAP functionality for all upgrades and System Builds.
• DashboardsUsing Advanced Multiple Drills Down, Dynamic Visibility, and Alert Featureswere designed to support Complex Requirement Scenario.
• Designed dashboardusing best practicesandadvanced filtering techniquesto dynamically filterand serve as the source for the dashboard.
• Optimized dashboard performancefor speed of thought analysis even withlarge data volumes and simultaneously alloweduser customization on the fly.
• Created several new Webi reports to report on CRM Analytics (Leads, Opportunities, Activities and service Contracts) using Business Objects functionalities likeSlice and Dice, Drill Down, Cross Tab, Input Controls, Vertical Tables, Sections, Conditional Formatting, Data Tracking, Alerted, and Formulas etc. usingWeb intelligence.
• Transported all Documents including Web Services, Universes, Xcelsius and Webi documents etc. using Import Wizard. Coordinating with Admin team to manual override target system connections.
• Working knowledge of BI Accelerator and Coordinating with Client team for developing Process Chains i.e. BIA Indexes etc

Environment: BI 7.0, ECC 5.0, CRM SD, MM, FI, Oracle 9i, BEx Query Designer.

Confidential, Irwindale, CA

BW/BOBJ Developer

Responsibilities:

• Responsible for designing Business Intelligence solutions using SAP BW 3.5 and BI 7.0 to meet the Daily operational and Analytical reporting demands of the business
• Worked on HR Info types Head count to extract the data from R/3 to BW and wrote the required routines when loading data in to BW.
• Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries.
• Created/Edit queries and reports in BOBJ - Info View for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence Webi, Voyager workspace, scheduling and publishing to BO Inbox, email, FTP, .. in multiple formats html, pdf, ActiveX doc
• Worked on new DSO delta uploads into BI and good working knowledge on new BI 7.0 objects.
• Worked on Business Explorer (BEx) to creating reports like Balance Sheet, P&L, Cash, Gross Margin Monthly Sales Open Orders, Back Orders, Overdue, Daily Sales Reports, Payment, and History etc. Using structures, formulas and Cell definitions
• Experienced in new data transformation process (ETL) Extracted data from ECC 6.0 and 5.0 into the BI, According to report requirement, enhanced the existing HR Info types and used deltas where required.
• Wrote number of routines in update and transfer rules according to requirements.
• Created reports in BEx Query Designer then published them in to BOBJ Analysis for Excel for End users. Created few WEBI queries and scheduled them to run every day especially for reconciliation purpose.
• Setting up the migration of the new Authorizations concept of Net weaver 7.0 (New BI Authorizations’ Using Analysis Authorization) and the considerations/issues with migration.
• Worked on number of HR head count and personnel info types to extract data in to BW and wrote Conversion routines in update and transfer rules where required.
• Created the process chains (RSPC) and Meta chain to automate the data load process according to the load Procedures and dependencies, resolved the Process Chain issues in Data loading.
• Created number of test scripts on different objects including Info Cube, ODS, Master data, reports and data Loading and also involved in user acceptance test with the business users.
• Converting the Data Sources and the PSA to the new DTP Process, Using Transformation, process, fixing The ABAP OO codes in Start and End Routines.
• Worked till the Go Live and support. Removed number of issues in cooling off/ transition period.
• Checking Reaction of SAP BI System after Upgrading, Running RSD1 to check Info Objects.
• Resolved number of tickets with in the given time frame and used to call the business user and explain what the problem why it occurred was and how to resolve, incase if it occurs in the future.

Environment: SAP BI 7.0, BW 3.5, SAP R/3 5.0, and 6.0, FI/CO, HR and CRM.

Confidential, Charlotte, NC

BW Developer

Responsibilities:

• Understanding the requirements on various units of the Business modules.
• Created Various Open Hub Destination to load data from BW system
• Created routines in Transformation as per customer requirement.
• Working extensively with Data WarehouseWorkbench for Modeling, Monitoring, Scheduling DTP-Info package and Process chains.
• Installing and activating various Business content for Inventory. Installing Inventory standard data sources and Info cubes and info objects.
• Working on activating the standard delivered business content in the form of Info Objects, Info Sources, ODS/DSO, Info Cubes, as well created various objects as per requirement.
• Created Data Target, Info Provider, Info Cubes, Char and key Info Object Catalos and Info Objects.
• Performed Data loads for Transaction, Master Data from SAP R-3 using Process Chains.
• Performed loading Data from Data source to DSO and DSO to Info cube.

Confidential, Washington DC

BW Developer

Responsibilities:

• Involved in identification of business requirements meeting the needs of end-users in sales and distribution.
• Involved in design, development, and testing of enhancements or user requirements for implementation by Identifying the customer requirements, modeling the data, and defining the data sources at OLTP
• Used extended star schema for data modeling. Also worked with ABAP programs.
• Performed Event Scheduling and created Process Chains, and Monitor settings.
• Created Generic Data Sources for Transactional data, Master data and Texts based on Views and Function Modules
• Extracted data from R/3 using LO, CO-PA and Generic extractors.
• Handled Profit center Accounting (EC-PCA), Accounts Payable (FI-AP), Accounts Receivable (FI-AR), General Ledger (FI-GL) Info cubes as a part of cross-functional SAP BW implementation.
• Multi-Planning Areas to conduct variance analysis Plan/ actual and analyze volume / price changes.
• Responsibilities included fixing and partitioning PSA, setting-up ODS, and combining ODS from different modules, writing Transfer Rules, transfer routines, update start routines and update routines and Info Cube Partitioning
• Tailored Transfer Structures, Communication Structures and Update Rules to optimize performance.
• Uploaded master data and transactional data from SAP R/3 via Data staging to PSA, ODS and Info Cubes.
• Worked extensively on BEx Query Designer and developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Assigned queries to different User Catalog on client specification and developed Excel workbooks for publishing views on the web using Web Application Designer.
• Provided quality assurance and technical assistance during go-live.

Confidential

ABAP Developer

Responsibilities:

• Responsible for coding along with implementation team and continued for modifying the programs as per the requirement.
• Up gradation of Reports, Transaction, and BDC’s.
• Prepared test scenarios for many of the above developments and actively involved in testing all those developments in QA.
• Involved in Weekly Data upload work using BDC’s in background jobs and error corrections.
• Planning analysis & development of reports.
• Developed Reports in Material Master that outputs valued stock grouped by material type and plant. This output shows Material number, Storage location, and description.
• Developed an ALV report that gives the stock overview for a given project with Des number and the value of the stock for Manufacturing and DS Materials.
• Modified the layout set MEDRUCK, SAPFM06P in purchasing using SAP Scripts according to Confidential requirements.
• Module pool for knowing the purchase Requisition status.
• Module pool to assign Des No. value for a Sale Order.
• Implementing a BDC program to migrate Vendor master data from legacy system to SAP R/3 database. The data was uploaded using transaction code XK01 and XK02.
• Involved in Material Master Conversion Interface that transfers the legacy system material data to SAP through MM01 transaction (Basic view, Sales view, purchase view, Plant/Storage location and Warehouse views).