Summary

• Around 11 Plus Years of IT experience that comprises around Nine Years of SAP experience as a BW/BI NW 2004s and Two Years of experience in SAP ABAP/4 and SAP Certified Application Associate in HANA
• Successfully completed multiple implementations in SAP BI in different versions and worked on HANA prototype Project with SAP and Non SAP data.
• Three years of SAP BW BO experience in BO integration with BI/BW along with extensive experience of Web Intelligence, Crystal reports and other BO applications.
• Successfully completed three full life cycle implementations, includes three NW 04s BI 7.0 implementations and one 1 full life cycle implementations of BOBJ 4.0.
• Modeling - Strong working knowledge of modeling InfoCubes, InfoObjects, DSOs, InfoSources, Update Rules, Transfer Rules and Transformations, MultiProviders, Data Mart and Open Hub Service
• Worked with standard SAP R/3 ECC 6 in areas including SD, MM,DM, FI, CO-PA, SCM, HCM, DM, QM and SRM.
• Broad knowledge of the IT application development life cycle including initiation, requirements gathering, design, build, test, implement and operations.
• Worked from Functional/Business requirements to Design and Develop Multi Dimensional Data Model using BW concepts of Extended Star schema and Datasources Installation of standard data sources, Enhancing existing data sources and creating custom data sources .
• Developed, Configured and Customized Data Extractions from SAP R/3 and Legacy Systems. Created Transformation, DTP, Transfer and Update rules, Routines in transformations and currency translations.
• Good understanding of various components of SAP HANA. Good exposure on Schemas, table definitions, Attributes, Measures Hierarchies in HANA.
• Having strong knowledge on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views both Graphical SQL script based SAP HANA Data Provisioning using SAP LT Replication Server SLT . Good exposure on Schemas, table definitions, Attributes, Measures Hierarchies in HANA. Good Knowledge in SAP HANA security including User Management, Role and Privileges. Strong knowledge on data flows workflows using BODS.
• Extensively worked on complete life cycle implementation of BO XI 3.1 reporting with BI 7.0.
• Created complex Webi reports by linking objects from different data providers and creating local variables in the report.
• Extensively worked in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Webi and Crystal.
• Extensively worked on INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe.
• Created flexible reports using Restricted Key Figures, Calculated Key Figures, Exceptions, Variables and Conditions.
• Overall BI Technical experience in Infrastructure, Databases partitioning, Compression, Statistics, Aggregates and BWA , Sizing, Loading and Extraction specifically performance , Reporting performance,
• Experienced in integration of SAP BI system with Business Objects.
• Documented Test Plans and complete Unit Testing of Developed Objects and Reports. Worked with Quality Assurance business resources to complete System and Integration Testing.
• Troubleshoot issues and follow up with SAP OSS-Notes .
• Involved in SAP BIBO Reporting Crystal Reports, Xcelsius, and Web Intelligence .
• ABAP/4 Programming - Worked on ABAP/4 programming for enhancing standard R/3 Data sources, Created Function module data sources, creating Transformation, Transfer and Update Routines, and variable Exits in BI/BW

Technical Skills

• Operating Systems UNIX, MS-Windows XP/2000/NT/9x.
• ERP SAP R/3 4.7, 4.6C, ECC 5.0 and ECC 6.0
• Data Warehouse Tools SAP BW 3.5, 3.1c, 3.0b, BI 7.0, DataStage7.0, Cognos, BO XI 3.1
• Programming Languages ABAP/4, C, C , Java.
• Databases Oracle 10g/9i/8i/7.x, MS-SQLServer, DB2.
• Web Technologies Servlets, Applets, JavaBeans, HTML and JavaScript.
• GUI VB 6.0 Swings.

Professional Summary

Confidential

ROLE : SAP Lead BI / HANA Consultant

Roles Responsibilities:

Responsibilities:

• Involved in gathering business requirement for the back to basics project landscape and Supported, designed and developed reports
• Involved in gathering requirements for the APO reports like supply planning comparison report and pipeline reports , designed and developed the reports for the as per the business requirements.
• Analyzed current system and gathered gaps to fulfill business report requirements and designed the objects.
• Involved in designing and developing A2R monthly journal report backend objects like DSO, Info cubes and Composite providers as required for the report dataflow.
• Resolved high priority to low priority ticket raised by the business as per the SLA defined.
• Created Webi reports using BICS connection on top of Bex queries and developed composite info providers for the business report requirements.
• Created reports like cycle time report for the different work orders both at backend and front end using Webi
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View
• Involved in designing and developing data provisioning SAP SLT process from the tables SKA1, SKAT and T000 tables into SAP HANA
• Involved and successfully implemented Unit testing, UAT and cutover activities as per the schedule of the project time lines.
• Involved in performance tuning of Data Loading by pushing transformation logic to native HANA code.
• Created Universes on top of HANA information models and developed the Webi reports for different reports like cycle time data for different work orders and schedule attainment operations and developed highly graphical and interactive reports like waterfall lag reports using Design studio..
• Extensively worked on BEx Analyzer to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and Formula Variable.

Environment

SAP BI 7.3, SAP HANA 1.0, ECC 6.0, SD, MM , FI, and BOBJ 4.1

Confidential

ROLE : SAP Lead BI / HANA Consultant

Roles Responsibilities:

Responsibilities:

• Involved design and development of corporate sales dashboard for the corporate sales management.
• Using BICS and created connections and Data foundation in IDT and published to CMC for generating Webi reports against SAP BW.
• Involved in performance tuning of queries, Data models, Data Loading and Webi Documents as per the best practice
• Extensively worked on BEx Analyzer to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and Formula Variable.
• Designed and Developed complex reporting requirement models like Price Override, Written sales and sales stock reports
• Involved in designing and development architecture of the BW system and improved the performance of the existing data models.
• Created Transformations to do lookups from dependent DSOs and master data to derive the key figures and characteristics to fulfill the gaps of the requirement
• Customized business content objects and designed the new data models for the new reporting requirements
• Involved in generating pricing condition data sources on top of KONV, CDPOS and CDHDR for the pricing override reports
• This project involved the complete depth understanding of the existing reports in BW and non-SAP system Simpliment, develop new reports and optimize existing report performance at backend and frontend
• Like Sales, Operations and Finance.
• Involved in gathering reporting requirements for the different users in corporation for different modules
• Maintained DSO's and Info cubes into in-memory objects and improved Data loading and query performance.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View

Environment

SAP BI 7.3, ECC 6.0, SD, MM , FI, and BOBJ 4.0

Confidential

ROLE : SAP BI/BO Architect

Roles Responsibilities:

Responsibilities:

• In the ISU worked on different modules like Billing, Device Management and Service management reporting requirements
• This project involved the complete depth understanding of the BW Billing, Device management and service management report requirements for Berkshire Gas
• Understanding the existing UIL United illumination reports and find the gap analysis of BG Berkshire Gas and develop the reports according to BG user report requirement.
• Involved in deep dives with business users and business analyst to understand report requirements and
• Developed tech specs for the reports
• Developed Data models for the DM Device Management for the business reporting requirement like Meter retirement date and Meters currently in Use reports.
• Worked and developed models for the UI retail suppliers reporting requirement and worked reports like
• Therm usage by rate code and by region.
• Responsible for designing the data model for Device Management, Billing and Service Management reports
• Activation of standard Info Cubes, DSO and definition of new Info Cubes and provide enhancement to Business Content.
• Creating Transformations to do lookups from various DSOs s to derive the key figures as per the business rules.
• Testing the data from R/3 side to BW by using some test cases on DSO, Infocube and Query level.

Environment:

SAP BI 7.3, ECC 6.0, BILLING, DM, SM BOBJ 4.0 And HANA 1.0.

Confidential

ROLE : SAP BI/BO Lead Consultant

Roles Responsibilities:

• In the DLM Device Life Cycle management Phase-1 implemented DM Device Management , SC Supply Chain integrated with QM Quality Management for the business Reporting requirements
• In Phase-2 developed MPSC Michigan Public Service Commission reports on integrated model of DLM modules DM, SC and QM
• Involved in deep dives with business users and business analyst to understand report requirements and
• Developed tech specs for the reports
• Responsible for designing the data model for Device Management, Supply Chain integrated with Quality Management which are key modules for DLM
• Activation of standard Info Cubes, DSO and definition of new Info Cubes and provide enhancement to Business Content.
• Handled Utilities Installation, Allocation, Device History 0UC DEVICE, Device Location 0UCIODS12, Utility Contract 0UCIODS05, Quality Management Inspection Results cubes 0QM C05, 0QM C04 , Notifications 0QM C02 as a part of cross-functional SAP BW implementation.
• Developed Custom data source using function module to extract ISU-Goods movement data from the table SER03 and ISU specific equipment's on table EQUI.
• Developed an expert routine to pivot different MIC's Master Inspection character values for each inspection lot, serial number at operation level to inspection lot and serial number level.
• Used Routines Expert Routines, Start Routines, and Update Routines in Update Transformations to Update Key Figures and Characteristics in the Info Cubes and DSO's.
• Designing, developing and supporting frontend enterprise reporting, query elements, user exits, Variables through Business Explorer BEx Query Designer, BEx Analyzer.

BO Reporting:

• For tracking activities of testers.
• Worked on SAP BO 4.0 and configured with existing SAP BW 7.0 environment.
• Extensively worked on INFOVIEW to create Web Intelligence Reports over the Universe.
• Designed functional and technical specifications for implementation and development over SAP BI 7.0 and implemented BO 4.0.
• Designed, developed and managed Universes in Business Objects Designer and IDT for generating reports against SAP BW.
• Responsible for Creating/Enhancing BOBJ Universes using BW Bex Query's, retrieving data from Universes and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client's requirements using, Web Intelligence WEBI .
• Developed MPSC Michigan Public Service commission Highly formatted reports using Crystal reports
• Developed Webi reports for monthly meter activity, monthly and daily activity of both electric and gas
• Involved in performance tuning of queries, Data models, Data Loading and Webi Documents as per the best practice.

Environment:

SAP BI 7.0, ECC 6.0, SC, DM and QM and BOBJ 3.1.

Confidential

ROLE : SAP BW/BO Lead Consultant

Roles Responsibilities:

• Involved in conducting requirement gathering workshops and then rationalized, Prioritize and standardize reporting layout for business
• Translated reporting layouts into functional specifications and technical design documents
• Prepared BW project plan, Risk assessment, security design documents
• Involved in Gap analysis in R/3 and BW systems and created design data flows and conducted design reviews
• Involved in impact of year end P L changes added extra value fields to operating concern AMOC in R/3 and BW
• Regenerated the COPA data source to accommodate new Value fields in R/3 data source.
• Analyzed the impact in BW objects and enhanced the objects in BW to meet the business Requirement.
• Analyzed impacts of outbound interfaces like IRM modified info spokes to accommodate these changes
• Modified outbound interface programs which generates outbound interface extract files using function module
• Modified start routine and update routines according to the business requirement and migrated the changes.
• Involved in analyzing the impacts of newly implemented vistex functionality in R/3.
• Modified sales allocation program which is a source for sales reporting according to business requirement
• Involved in supporting production data loads which happens daily and weekly.
• Worked on reports like gross margin by material and modified existing COPA reports to accommodate these P L year end changes.

Environment:

SAP BI 7.0, ECC 6.0, CO-PA, SD And, BO XI 3.1.

Confidential

ROLE : SAP BW/BO Consultant

Roles Responsibilities:

• Transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi dimensional design.
• Involved in the design and design reviews of different reports requirements for ORI Operations reporting initiative
• Extracted data from FAS Field automated service oracle data mart from FAS Main order and Tech Workday hist tables into BW using DB Connect
• Worked on Flat file data sources like QAS Reviews and QAS Payouts for the people section of the Webi monthly dashboards.
• Worked on 0CO OM OPA 6 Orders Actual Costs0 data source to pull data into BW and integrated data with FAS data mart for the reporting requirements.
• Designed and created FAS Main Order Multiprovider, Infocube, DSO and Warehouse layer DSO.
• Created start routine, End routine and field routine as per business and design requirements
• Extensively worked on BEx Analyzer and designer to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, Formula Variable
• Created reports like IRs Immediate response for orders, Hours charged from SAP FAS, Main Activity Type for DD major work category
• Created BO universe for SAP FAS Order Current Year, Previous Year and weekly universes for BO reports and Adhoc reporting requirements.
• Worked on reports like payroll administration reports.
• Created CFS Customer field service Monthly, weekly dashboard using Webi
• Created reports emergency Monthly and weekly dashboards using web intelligence
• Involved in performance tuning Loading and query performance activities after post live activities.

Environment: SAP BI 7.0, ECC 5.0, CO, HCM Oracle 10g and BO XI 3.1

Confidential

ROLE : SAP BW/BI Consultant

Roles Responsibilities:

• Transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi dimensional design.
• Involved in the design and design reviews of different reports like Income Statement and Balance Sheet
• Involved design and developing the DSO, Info Cube and Multi Provider for Special purpose General ledger FI- SPL
• Worked on pulling the data Billing, Booking data from Sales Data Mart TSR using DB Connect and worked on reports like Sales by Weekly and sales by monthly
• Designed Write optimized DSO's for pulling the data from RMCA module iTunes and Published the data to EDW
• Enhanced the data sources and created the generic data sources as per the requirement.
• Involved currency translations at transformation level for global sales reporting requirements.
• Customizing the business content objects or design the Info Cubes, DSO and Multi Providers depends on the requirement.
• Creating Transformations to do lookups from various DSOs s to derive the key figures as per the business rules.
• Testing the data from R/3 side to BW by using some test cases on DSO, Infocube and Query level.
• Extensively worked on BEx Analyzer to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and Formula Variable.
• Worked on developing Global sales reports using Webi and Crystal reports.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to InfoCubes and DSO.
• Conducted end user training on running various queries and reports in BEx and WAD on InfoCubes and DSO Info Providers.
• Loaded data and monitored and the failed data packets were analyzed for Quality in PSA before sending into Data targets.
• Scheduling and Monitoring of DTPs and analyzing the reasons for frequent failures of DTPS.

Environment: SAP BI 7.0, ECC 5.0, SD, MM, FI CO, and BO XI 3.1

Confidential

ROLE : SAP BW/BI Consultant

Roles Responsibilities:

• Transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi dimensional design.
• Involved in the design and design reviews of different reports like Ship Mode Analysis, in transit status, Replenishment.
• Involved in the gap analysis in the existing data sources and business content objects
• Enhancing the data sources and creating the generic data sources as per the requirement.
• Customizing the business content objects or design the Info Cubes, DSO and Multi Providers depends on the requirement.
• Creating Transformations to do lookups from various DSOs s to derive the key figures as per the business rules.
• Testing the data from R/3 side to BW by using some test cases on DSO, Infocube and Query level.
• Extensively worked on BEx Analyzer and WAD to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and Formula Variable.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to InfoCubes and DSO.
• Conducted end user training on running various queries and reports in BEx and WAD on InfoCubes and DSO Info Providers.
• Loaded data and monitored and the failed data packets were analyzed for Quality in PSA before sending into Data targets.
• Scheduling and Monitoring of DTPs and analyzing the reasons for frequent failures of DTPS.

Environment: SAP BW 3.5, ECC 5.0 SD, MM, FI CO

Confidential

ROLE : SAP BW Consultant

Roles Responsibilities:

• Involved in the analysis, development, and support of reporting initiatives within the firm, primarily using the firm's SAP Business Warehouse BW application.
• Developed SAP BW queries using SAP BW tools such as Business Explorer BEx and Web Application Designer.
• Consulted with users and project team members to gather, interpret, and document reporting requirements work with the SAP BW Development Team in creation of data model and data access methods to support reporting projects.
• Created Aggregates for the Info Cubes to increase the performance of Queries
• Building Multi Providers for reporting purpose.
• Used BEx Analyzer to create Queries and post them on the web. Customized web templates and created web based reports.
• Setup periodic Data loads from a legacy system flat files .
• Created Info Spoke to transfer data from Info Cube into 'CSV' files.
• Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures and calculated key figures.

Environment: SAP BW 3.1c, SAP R/3 4.6C, SD and MM

Confidential

ROLE : SAP ABAP/4 Programmer

Roles Responsibilities:

As a member of the ABAP/4 Team, involved in developing Reports, BDC, Layout Set as per client's requirement

Contributions: Reports in SD and MM modules.

• Sales general printing program. This report will show what is the turnover for the given period, for a plant, for distribution channel and division invoice number wise and finally it will show the abstract values, i.e., split up for the sales, Split-up in inter sales, intra state sales, customer supplies components value etc.
• Created a vendor performance Report, which lists the vendor name, material supplied planned and actual delivery times, payment terms and prices. This also includes material number, storage location, and unit of measure and description in addition to group totals.

BDC

• Written data upload Program for Vendors.
• Written data load program for material master.

SAP Scripts

• Modified standard Layouts set for Delivery Note.
• Modified standard Layouts set for Goods Return Slip.

Environment: SAP R/3 4.6C, SD and MM

Confidential

ROLE : SAP ABAP/4 Programmer

Roles Responsibilities:

• Involved in writing the data load programs to upload the data from legacy system to SAP.
• Modified reports in financial accounting and controlling.
• Performed preparation of business script for the SD implementation, which included master production scheduling, material requirements planning, sales and operations planning.
• Involved in the printing process of purchase orders, purchase order change, request for quotation, contract, evaluation, transfer orders etc.
• Design, development and testing of reports, user exits, SAP scripts and print programs.
• Created a Report to display a list of Purchase Requisitions with details like MRP Controller, Release Date and Unit of Measure along with standard details.

Environment: SAP R/3 4.6C, SD and MM