SUMMARY:

• 15+ years of professional experience in design, development, and implementation of business applications this includes more than 14 years of SAP BI experience.
• Having one End - to-End Implementation on SAP ‘BIW (7.0), 7.3, 7.5, SAP BW on HANA and Cloud migration projects
• Proficient in data modeling using BW extended star schema models
• Creation and maintenance of Composite providers, Advanced DSO, Info Cubes, ODS Objects, Multi-providers, Info source, Data Source, Info Set, Info Packages, Data Transfer Processes, Info object Catalogs, Info Objects, Navigational attributes, Transformation, Hierarchies, Masters Data.
• Performed extensive generic data extractions
• Configured and implemented BW reporting using BEx analyzer.
• Installation of SAP BI Statistics.
• Expertise in extractions from SAP R/3 using LO Cockpit, Generic Extractions, FI, CO-PA, CCA etc.
• Knowledge of Business Objects 4.0 reporting functionalities such as Web Intelligence, Crystal Reports etc
• Modeling Planning Applications using SAP BI Integrated Planning (IP). Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer
• Good knowledge of SAP ABAP which can used for writing ABAP code in certain areas of SAP BI like routines, transformations etc.
• Knowledge of SAP BO Reporting tools like WEBI, Crystal Reports etc.
• Knowledge of SAP BO Universe Designer, CMC.
• Knowledge of SAP HANA 1.0.
• Conducted training for end-users. Developed business process documentation.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, in corporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability
• Excellent communication, presentation, and interpersonal skills Good record for meeting timelines and expectations.
• Quick in learning, hardworking Professional, Willing to take up new challenges.
• Having one End-to-End Implementation on SAP ‘BIW (7.0), 7.3, 7.5 and SAP BW on HANA projects
• Proficient in data modeling using BW extended star schema models
• Creation and maintenance of Composite providers, Advanced DSO, Info Cubes, ODS Objects, Multi-providers, Info source, Data Source, Info Set, Info Packages, Data Transfer Processes, Info object Catalogs, Info Objects, Navigational attributes, Transformation, Hierarchies, Masters Data.
• Performed extensive generic data extractions
• Configured and implemented BW reporting using BEx analyzer.
• Installation of BI Statistics.
• Conducted training for end-users. Developed business process documentation
• Have good technical knowledge on areas like FI, SD, HR, CRM and MM

AREAS OF EXPERTISE:

Business Intelligence: SAP BW and BI 7.0, 7.3, 7.5, BW on HANA

Operating System: Windows 98, 2000, XP and UNIX

RDBMS: Oracle8i/9i/10g, SQL Server 2000/2005

SAP: ECC 6.0, SAP BW (ETL &Modeling & Reporting), BO Reporting, HANA.

Programming Languages: PL/SQL, SAP-ABAP

Web Technologies: HTML, Java Script, XML

WORK EXPERIENCE:

Confidential, Hillsboro, Oregon

Sr Software Engineer SAP BI/BW

Responsibilities:

• Coordinating and interfacing with business and cloud team
• Requirement gathering from the business stake holders
• Preparing technical analysis documents and taking approval from architects.
• Used SAP BW on HANA concepts like Hana analysis process (HAP), Advance DSO, Composite providers, Openhubs.
• Created synonyms for transferring data from BW system to Cloud.
• Validation of BW data against Snowflake data in QA environment.
• Troubleshooting user and QM team issues in test cycles and UAT.
• Creating and maintaining weekly status reports.
• As a member of COE team, responsible for reviewing design and code of any new development or any enhancements.
• Documentation for Report Design Document, Security and Technical Architecture document, Data Mapping document between source systems and reports.

Environment: SAP BW 3.5, BI 7.5, BW on HANA, SAP ABAP ECC 6.0. Bex Analyzer, Query designer and HANA STUDIO.

Confidential, Hillsboro, Oregon

Technology Architect

Responsibilities:

• Working in end to end BW implementation for Dispute management under Finance supply chain management. Identify BW standard BI content and activate as per the business requirement.
• Working with upstream system snowflake to consume FSCM, AR and Billing information at Confidential data foundation. Establishing the pipeline to extract the data from ECC à BW à Snowflake à Tableau.
• Interacting with upstream and downstream business users to understand business process flow, business logic and to assess major data objects, data volume for data migration.
• Providing the technical & functional support to the upstream systems which include field mapping, Business logic & transformation.
• Working with BI platform team and SAP security team to get the necessary objects created for the upstream system to access the required object to consume the data.
• Configure and implementBWreporting using Bex analyzer/browser& Report Designer for Dispute Management.
• Expertise in developing differentBWobjects using eclipseBWModeling Perspective such as ADSOs, Composite Providers, and Bex Queries.
• Working in managing all stages of data migration from data analysis to pre-go-live validations, user acceptance testing, user sign-off, Cut-Over plans, migrating to Dev/QA/ Prod landscapes, and post-go-live validations.
• Worked in all kinds of priorities, supported production fixes/bugs/breaks, escalated issue at right time, handled offshore resources, maintain service level agreements SLA and time estimation for the development objects, Prepare Development specifications, Design ABAP solutions, code, and test ABAP/SAPScripts programs.
• Involved in PI Planning meetings which establish face-to-face communication across all team members and stakeholders. Created user stories, coordinated with dependency teams, communicated the project timeline and deliverables.
• Excellent knowledgeon Advanced DSO, Open ODS view, Transient provider, HANAlive,HANAdatabase artifact,HANAXS, Procedure, Hana Optimized DSO’s, Composite, Hybrid Providers, and Import SAP Net WeaverBWModel toHANA.

Environment: SAP BW 3.5, BI 7.5, BW on HANA, SAP ABAP ECC 6.0. Bex Analyzer, Query designer and HANA STUDIO.

Confidential

SAP BI Consultant

Responsibilities:

• Coordinating and interfacing with clients and the technical team.
• Requirement gathering from the clients.
• Coordination and management of offshore and onsite team.
• Preparing technical specifications and taking approval from client.
• Designed work flows for Change data Capture
• Used SAP BI modeling concepts for creation of Cubes and DSOs.
• Developing InfoProviders as per design document and building reports.
• Created Transformations as per the business logic using ABAP.
• Extensively involved the creation of start routine, expert routine and end routine. Involved in the creation customer exit variables using CMOD
• Enhancing the logistics extractors and extracted data to BI
• Created Open Hub Destination Objects (InfoSpoke) to transfer data from standard Data Store Objects to Flat Files.
• Worked in the creation of several Bex reports using exceptions, conditions, cell definitions, offsets, replacement path and written user exit variables and working knowledge in creation of WEBI reports.
• Familiar with Creation of Universe and WEBI Reports
• Validation of data from various source systems.
• Troubleshooting user issues in production support.
• Creating and maintaining weekly status reports.
• Documentation for Report Design Document, Security and Administrative Settings, Technical Architecture document, Data Mapping document between source systems and reports.

Environment: SAP BI 7.3, SAP ABAP ECC 6.0. Bex Analyzer, Query designer, WEBI, Openhubs

Confidential

Application Developer

Responsibilities:

• Team lead for all SAP applications like Business Objects, Informatica and Microstation CAD.
• Coordinating with client's for other areas of business like BO, Informatica etc. in US business hours.
• Created reports using BEx Analyzer and WAD that include Plan/Actual revenue comparison, Order and sales value by sales representatives, Vendor delivery efficiency, Incoming Orders, Sales-order stock reporting, Balance sheet and Profit Loss using filters, restricted and calculated Key Figures, variables, formulas, exceptions and conditions.
• Involved in the implementation of IP enhanced sales to bw
• Responsible for the Design and Configuration of the BW and BPS for the flow of actual and Budget/Forecast data to/from R/3 and SEM/BW.
• Extensively worked on performance issue related to BI system and co-ordinate with basis team in performance tuning. Analysis and suggested the remedy to improve the performance of BI system.
• Trained BW support offshore team and provided documents related to BI system.
• Solved all Incident related to data load failure in timeline and motivated team members to complete all task in time.
• Guiding junior team members and making them technically sound.
• Preparing High level technical design and time lines of project.
• Working Designed Info Cubes, DSO, multi providers and Info sets.
• Developed reports using BEx Analyzer with restricted key figures, calculated key figures and variables.
• Developed custom datasources and custom BW objects as per requirements.
• Used the input-ready queries to create applications for manual planning and complex planning scenarios
• Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process chains.
• Developed real time Infocubes for IP Planning.
• Installing Functions on the SAP Server Connecting to SAP Applications ABAP data flow processing using Data services.
• Worked on data source enhancements as per requirements.
• Worked on transportation from Development to Quality & Production servers.
• Identified data sources based on end-user reporting requirements, and Create InfoCubes from data extracted from different modules like SD & MM using LO Cockpit
• Incident Management and Face to the client for any issues related to day to day status.
• Worked with GIS Team in fixing bug, New Developments and worked on CR's.

Environment: SAP BW 3.x, SAP BI 7.0, SAP ECC 6.0. Bex Analyzer, Query designer.