SUMMARY

• Having around 10 Years of professional experience in SAP engaging with the business stake holders to understand business requirements and provide solutions.
• Excellent Team Player and Team handling Capabilities.
• Good interpersonal relations, strong communication skills, hard working and high level of motivation.
• Implemented 3 end to end full - life cycles using ASAP methodology across various modules in SAP BI/BW projects.
• Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
• Strong experience in BW 3.x and BI 7.x version Reporting.
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities (data loading & monitoring and troubleshooting the failures).
• Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation)
• BW load/job automation through process chain and Control-M.
• Worked extensively in SD, MM, PP, and FI Modules.
• Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.
• Working knowledge and proficiency with Business Objects Reporting tools (BI 4.0, BI 4.1) BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Analysis for Office, Crystal Reports.
• Working knowledge on Business Planning and Consolidation (BPC 10).
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP Methodology.
• Worked on Data Modeling, Data Provisioning, Reporting aspects of SAP HANA 1.0
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting.
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
• Experience in Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer & MS Excel.
• Knowledge on SAP Predictive Analytics with SAP Infinite Insight.
• Preparing Data for predictions using Infinite Insight Explorer.
• Developing Classification, Regression and Time series models with Infinite Insight Modeler.
• Exporting the predictive models to different formats using Infinite Insight Scorer.

TECHNICAL SKILLS

SAP HANA: HANA 1.X (SP3-SP9).

BW Versions: 3.0B, 3.1, 3.5 & BI 7.0, BW 7.3, BW 7.4.

SAP R3 Versions: 4.0B, 4.6B, 4.6C, 4.7 & SAP ERP (ECC 6.0).

ETL: INFORMATICA 9.1, BODS.

BI: DW Workbench, DTP, DSO, Transformation.

Reporting: Business Objects Enterprise BO XI R2/R3,BO 4.0,4.1,BI launch Pad, Web Intelligence (Web I 4.1), Information Design Tool, Design Studio, Dashboard Design, BO Explorer, Desktop Intelligence (Desk I), WAD, BEX Analyzer, BEX Query Designer, SAP Lumira, Spotfire,Tableau.

Database: SQL Server 2000, Oracle 8i/9i/10g.

Applications: Microsoft Office - Word, Excel, PowerPoint.

Project Management Tools: Solution Manager, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP BW/BOBJ Consultant

Responsibilities:

• Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall design to meet and satisfy the Business Reporting Requirements.
• Perform Reconciliation for Wholesale and Retail business Reports in order to support smooth Month end activities.
• Fixing the issues in daily/weekly/monthly jobs through Process chain monitoring.
• Regular monitoring of POSDM (Point of Sale Data Management) data flow and take necessary action to resolve errors occurred.
• Creating Open Hub Destination settings to further process data from one BW system to another.
• Creating APD (Analysis Process Designer) based on the Reporting requirements.
• Perform enhancements to the existing data flow based on the User request.
• Create and Repair BW Accelerator (BWA) Indexes.
• Handling User Service request and Resolution tickets.
• Involved in design and development of PTC Windchill integration with SAP.
• Upon integration with Windchill, there was need of converting traditional PDM Reports to SAP BOBJ capabilities along with many more new Webi report development needs.
• Application support for BO webi reports and Dashboards (BI 4.1 SP2)
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence (WEBI).
• Designed Webi Reports Using Bex Queries (BICS Connection).
• Designed & developed cross tab reports, reports with sub reports and charts using webi.
• Involved in developing and conducting extensive Unit testing, Integration testing, User Acceptance Testing (UAT) and documentation.
• Provided Training to BOBJ - BI Business Users, team members and created end-user training material and documentation.

Confidential, MI

SAP BI/BW HANA Architect

Responsibilities:

• Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Poof of Concept (POC).
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, business rules for sales and marketing domains.
• Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server (SLT).
• Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views), selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA STUDIO
• Used Information Design Tool (IDT) to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository.
• Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer (BEx), Tibco Spot fire and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Accessed HANA data as Pivot tables in Microsoft Excel through MDX provider.
• As part of regular BW system activities, monitoring of data loading jobs in BW system and Fixing the issues in daily/weekly/monthly jobs through Process chain monitoring
• Created new BW Bex Reports based on the user primary/adhoc requirements.
• Worked extensively on enhancing the existing reports and workbooks according to the user specifications.
• Worked extensively on creating Information Broadcasting settings and automated to broadcast reports through daily/weekly/monthly emails to the Users.
• Scheduled the BO webi reports and Dashboards according to the User requirements.
• Developed webi reports and Dashboards aligning to user requirements and provided application support to BO reports.
• Handled Critical Resolution and Request type incidents maintaining within accepted SLA.
• Fixed the errors in the existing queries and helped the business users in understanding and developing the local queries.
• Controlled the database size by regularly monitoring the size and tuning accordingly to maintain the db size.
• Designed and developed the new data flow for Local Confidential business models understanding User specs and developing Functional/Technical specifications accordingly.
• Enhanced the existing data models with new business specifications and reported using Bex/BO reports accordingly.
• Involved in developing and conducting extensive Unit testing, Integration testing, User Acceptance Testing (UAT) and documentation.
• Worked with HPQC for data model design and development detail testing for each task to automate testing to enable Developers, Architects and Users to leverage easy testing.
• Extensively worked on Transport management to import transports across BW system landscape.

Confidential, MI

SAP BW Consultant

Responsibilities:

• Discussed with business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.
• Installed Business Content for SAP HR specific data flow in BW system.
• Developed the data flow for Personnel Development, Organization Management and Payroll specific according to the business needs.
• Automated Master data and transaction data loads for PD, OM and PY in SAP BW from SAP ECC building required Process chains.
• Involved in Unit testing, Regression testing and coordinated with Customer for User Acceptance testing.
• Built HR specific Reports like Employee Headcount, Personnel actions, Payroll reports.
• Provided Post Go-live support with detailed User documentation and Knowledge transfer.

Confidential, CA

SAP BW Consultant

Responsibilities:

• Handling a Team of Size 7 as a Production Support Offshore Lead.
• Working on Critical incidents without crossing SLA limits.
• Extensively working on developing minor Enhancements (Requests) and Functional Change Requests (FCR).
• Fixing the issues in daily/weekly/monthly jobs through Process chain monitoring.
• Information Broadcasting and creating iViews in Portal.
• Scheduling the Dashboards according to the Client Specifications monthly.
• Maintaining Software Configuration documents as per the Quality Standards of the Company.
• Monitoring and Supporting the Team to meet the Project deliverables without any Effort/Schedule Deviation.

Confidential, CA

SAP BW Consultant

Responsibilities:

• Handled the Complete ownership of Rollout for Russia and delivered to the Client Satisfaction.
• Involved in Rollout for Germany.
• Extensively worked on preparing the Test scripts to enable users to perform UAT successfully.
• Performed Reconciliation of BI Reports with Source System.
• Developed Accounts Receivable and Accounts Payable Ageing Reports for Russia and which is later rolled out to other countries too.
• Worked extensively on building Workbooks according to User specifications.
• Expertise in preparing report specifications, designs to support the reporting requirements and documenting in different stages of developments of reports.
• Handled issues in Post implementation Support.
• Provided Knowledge transfer to the team for easy transition further.

Confidential, CA 

SAP BW Consultant

Responsibilities:

• Involved in full life cycle implementation from design to production support.
• Extensively worked on extracting data from XI to BI using Webservices and third party data using Flat files.
• Built several Staging and Data warehouse layer DSOs, five different custom infocubes and three Multiproviders according to reporting requirements.
• Worked Extensively on building Authorization Roles according to the User specifications segregating Read and Write access to different set of Users.
• Built Custom queries for both BW and IP Reports.
• Generated custom reports using BEx Query Designer. Extensively used calculated and restricted key figures, structures, Characteristic, Text and Exit variables.
• Created single value, multiple single value, interval, selection variables extensively according to the user requirements.
• Designed Reports using Web Application Designer (WAD).
• Developed new Custom reports for further drilldown and Dashboard reporting using Web Templates.
• Developed Custom reports like Trend Report, Projection Report, Growth Percentage Report for both Apparel and Raw material along with Shipped to Volume, Costing Report etc.
• Used calculated and restricted key figures, formulae, variables with complex customer exits, text variables, exceptions and conditions for the queries.
• Designed Process Chains to automate loading of all master and transaction data.
• Extensively worked on Custom Transport Management system to transport the requests from Development to Quality Systems.
• Provided Knowledge transfer to the team for easy transition further.

Confidential, OH 

SAP BW Consultant

Responsibilities:

• Involved in collecting requirements and mapping to Business content, Gap analysis, identifying source data.
• Defining data model (Generic/Key figure), designed documentation, Extract methods.
• Modeling and building Info cubes, DSO, Info sets and MultiProviders according to reporting requirements.
• Built Custom infocube ZGC C01 for Guitar Center related data.
• Worked Extensively on Sales Overview (0SD C03) and Inventory Cubes (0IC C03).
• Developed LO customization, extract structures and data sources in Sales Order management to facilitate the data extraction to BW. Enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD.
• Generated standard and custom reports using BEx Query Designer. Extensively used calculated and restricted key figures, structures, variables and conditions for the queries.
• Extensive use of Process Chains to automate loading of all master and transaction data.
• Designed Reports using Web Application Designer (WAD).
• Worked extensively on the transaction data and master data user exits on R/3 by using Enhancements.
• Developed new Custom reports for further drilldown and Dashboard reporting using Web Templates.
• Developed Customer Classification and Material Classification according to the User Specifications.
• Developed Product Hierarchy for 0Material.
• Developed Custom reports like Customer Profile Report, Top Customer and Item list, Inventory Control Report etc.
• Collected and transported developed objects from development system to Quality and production systems.
• Enhanced the Business Content datasources and also developed Generic datasources.
• Expertise in preparing report specifications, database designs to support the reporting requirements and documenting in different stages of developments of reports.
• Published the reports under specified Roles to provide access for Super users.
• Created single value, multiple single value, interval, selection, Hierarchy and Hierarchy node variables extensively according to the user requirements.
• Used calculated and restricted key figures, formulae, variables with complex customer exits, text variables, exceptions and conditions for the queries.
• Installed OSS Notes in ECC Objects to enable the Customer Classification Characteristics to accept Multiple Values.
• Provided end-user training to enable the Power Users to build their own queries.
• Provided end-user training and Knowledge transfer to the Core Team.