SUMMARY

• 8 years of IT experience with 7+ years of implementation and support experience in SAP BOBJ/BI, Business Warehouse, Enterprise Applications, ETL, and Supply Chain business domainsand 1 year of experience in SAP HR and ABAP/4.
• And also experience on SAP HANA working on POC's(Proof of concept), leveraging businesses to take competitive advantage with real - time reporting and interactive analysis across desktop and mobile platforms.
• Successfully completed Six implementations in SAP BI/BW in multiple versions
• Well Versed with Documenting and Identifying Business, Functional and Technical Requirements.
• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer.
• Experience with SAP HANA Administration including Monitoring SAP HANA systems and services with system monitor, performance tuning, adding systems, setting modeler preferences, import/export delivery units etc.
• Modeling - Strong working knowledge of modeling Info Cubes, Info Objects, DSOs, Info Sources, Update Rules, Transfer Rules and Transformations, Multi Providers, 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 Data sources (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.
• Extracted from Flat Files and R/3 using extraction methods like LO-Cockpit, FI, CO-PA, and Generic Extractions using function modules and enhancing the Extract structures based on the user requirement as needed.
• 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.
• Designed and developed BW Reports primarily using BEx. Integrated SAP BW queries developed using BEx with WAD and converted Bex Reports into Web Reports. Created Queries, Reports and Workbooks extensively using BEx Analyzer (Business Explorer analyzer).
• 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, 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

Business Intelligence: SAP Business Objects 4.0/3.1, SAP BI, Xcelsius, Business objects QueryFor Excel.

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT & Dimensions.

Operating Systems: UNIX, MS-Windows XP/2000/NT/9x, VM Ware

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

Project Management: MS Project, Oracle ADI 11.2, MS Access, MS Visio, MS Excel.

ETL Tools: Informatics, Business Objects Data Integrator/Data services.

Programming Languages: ABAP/4, C, C++, Java.

Databases: Oracle 10g/9i/8i/7.x, MS-SQL Server, DB2.

Web Technologies: Servlets, Applets, JavaBeans, HTML and JavaScript.

GUI: VB 6.0 Swings.

PROFESSIONAL EXPERIENCE

Confidential, WI

SAP HANA/BOBJ Consultant

Responsibilities:

• Collaborated closely with Client Managers, Product owners, Architects, 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 POC.
• Interviewed business stakeholders to determine structured and ad-hoc reporting requirements, User stories and business rules for finance, sales and marketing domains.
• Gathered and analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Assisted SAP Basis team in installing HANA 1.0 revision 58 and solely integrated it with Business Objects 4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA.
• Integrated BOBJ 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID's for developers, super users, and end users.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designers.
• SAP SLT configuration for real time reporting from ECC system.
• Developed WEBI reports and dashboards for different operations and finance KPI'S likeProject planning, quality management, warehouse management, Material management.

Environment: SAP HANA 1.0, SAP Business Objects 4.0, SAP Business Objects Explorer, SLT(System Landscape Transformation).

Confidential, Dallas TX

SAP BI/BOBJ Consultant

Responsibilities:

• In the DLM ( Device Life Cycle management ) Phase-1 implemented successfully DM (Device Management ), SC ( Supply Chain ) integrated with QM (Quality Management)for the business Reporting requirements
• 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 a 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.
• 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).
• Involved in performance tuning of queries, Data models, Data Loading and Webi Documents as per the best practice.
• Used ABAP for enhancing Data Sources for User Exits

Environment: SAP BI 7.0, ECC 6.0, SC, DM and QM and BO XI 3.1.

Confidential, MN

SAP BW/BI Consultant

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 InfoProviders.
• 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,BI 7.0, ECC 5.0 6.0,SD, MM, FI\CO

Confidential, Juno Beach, FL

SAP BW/BI Consultant

Responsibilities:

• Performed analysis, design, development and Implementation of standard / customized info cubes and ODS objects for business end-users in the application areas of SD and COPA.
• Customized basic cubes like COPA Summary, Statically key figures cubes and created data sources and extracted data from COPA.
• Designed cubes to accept multiple Info Sources, Extracted Master data and Transaction data.
• And worked with cubes customer, delivery and Billing cubes as per the client Requirement.
• And enhanced the billing document header data source and extracted the data in to billing cube according to client requirement.
• Worked with Business Content as well as custom Info objects, Info cubes, ODS Objects, Transfer/update rules
• Created aggregates to improve the query performance.
• Involved in performance tuning of queries by maintaining Aggregates.
• Created Bex queries for incoming orders per Month and open sales order reports according to client requirement
• Created variables restricted, calculated Key Figures, Query Jump Targets (RRI) for the Queries.
• Scheduling and Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Worked extensively on BEx Reporting by creating various queries based on user requirement using Variables, Exceptions, Conditions, Calculated and Restricted key figures.
• Worked on performance tuning by maintaining aggregates and partitioning in Info Cubes.

Environment: SAP BW 3.5, SAP R/3 4.7

Confidential

SAP BW Consultant

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

SAP BW Consultant

Responsibilities:

• Customizing of extract structures for SD sales Data Source like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL.
• Worked on LO - Cockpit for maintenance of extract structures, maintaining Data sources, activating the update
• Used PSA to stage the data before transferring the PSA contents into the Info Cube.
• Used ODS to stage data before transferring the ODS contents to the Info Cube.
• Created, maintained and configured Info Cubes to load data as per the Technical Specifications.
• Worked on the partitioning and configuration of Info Cubes as per the client requirements and also for better performance at runtime
• Created indexes and aggregates for better performance
• Extensively used BEx Query Designer to create queries using variables, filters, calculated key figures, restricted key figures.
• Used ABAP for enhancing Data Sources for User Exits.

Environment: SAP BW 3.0B, SAP R/3 3.1C, SD, MM

Confidential

Team Member

Responsibilities:

• Configuration of Various objects and actions
• Understanding the business process enhancements of the client and gathering the information about business demands.
• Requirement Gathering
• Configuring the data as per Client requirement and Supporting Project manager in documentations
• Working on Tickets assigned
• Involved in end user training and preparation of end user manuals
• Involved in unit tests
• Attending meetings

Confidential

HR Executive

Responsibilities:

• Handling recruitment & selection through job portal,
• Training for new employees, maintaining roaster, documentation, candidate placement
• Salary calculation
• Induction & orientation, joining formalities
• Exit formalities, leave records
• Full & final settlement, reference checking, etc.