SUMMARY

• A dynamic IT professional with 15+ years of Software Industry experience (services and product development) in Business Intelligence and data warehousing solutions using SAP BI/BW, BW on HANA AND SAP ABAP.
• Extensively involved in SDLC projects with multiple Go - Live implementations, Development, Upgrades, Migrations and Production Support, which leveraged the business intelligence that resides in transactions to drive executive reports, decision making, what if analysis, high end Dash boards and Metrics presentation
• 15+ years of professional experience in design, development and implementation of business applications this includes more than 12 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.

TECHNICAL SKILLS

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, XMLEducation: Bachelor of Technology from National Institute of Technology, Rourkela ( ).

PROFESSIONAL EXPERIENCE

Confidential

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

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 Nike 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

Programmer Analyst

Responsibilities:

• Coordinating and interfacing with clients and the technical team.
• Requirement gathering from the clients.
• Coordination and management of offshore team members.
• Preparing technical analysis documents and taking approval from client.
• Creating required documents and taking approval from CAB.
• Used SAP BI modeling concepts for collecting backend and front objects.
• Created export datasources for performing historical data loads.
• Optimized the performance of data targets (Info cube, ODS, Multicubes) by loading the data through proper selection criteria and maintained the request for each data load to compress it in the future and maintaining proper aggregates
• Validation of data from various source systems in QA environment.
• Troubleshooting user and QM team issues in test cycles and UAT.
• Creating and maintaining weekly status reports.
• 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.3, SAP ABAP ECC 6.0. Bex Analyzer, Query designer, WAD.

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.