SUMMARY:

• 11 years of total professional experience in design, development and implementation of business applications. This includes 7 years in SAP BW BI Netweaver 7.0/ BW 3.5 as Techno Functional consultant along with 4 years as a Business Analyst.
• Experience with SAP NW BI 7.0 along with the capabilities like new Data source, DTP, Transformations, Real - Time Data Acquisition (RDA), BEX Analyzer, Web application designer and Integrated Planning.
• Experience in Production Support which include Process Chains maintenance and build InfoPackage to schedule full/ delta loads. Data load monitoring and fixing the failed loads.
• Work experience on Data Cleansing, Data Modeling, and Performance tuning and building aggregates.
• Involvedin Upgrading 3.5 to BI 7.0 Netweaver 2004s Pre Upgrade and Post Upgrade tasks (collecting system objects, Security). Successfully executed the BI Upgrade Strategy. Capable of Architecting and designing end to end implementation of BW projects, right from requirement gathering, Business Blue print, preparing technical and functional specifications and development. Implemented Full life cycle projects.
• Knowledge of ABAP coding in BW, Start Routines, Update Rules, Transfer Rules and Customer Exit variables coding. Also Start Routine and End routine in BI 7.0.
• Implementation of 2 Full Life Cycle implementation on SAP BI/BW following ASAP Methodologies which involves Blue printing, Realization, Data Modeling, Data Loading, Production Support, Testing, Documentation, Requirement Analysis, End User Documentation and Reporting.
• Worked extensively on BEx Analyzer, Query Designer, Report Designer, Web Application Designer, Crystal reports, Web Intelligence and Xcelsius.
• Extensive experience in business processes across the following modules: FI/CO, MM, HR and SD.
• Expertise in OLTP extractions of SAP LO-Cockpit, CO-PA, CO-CCA, FI-GL, FI-SL, Generic extractions and non-SAP data and flat files.
• Design and created custom Multiprovider, Infocube, DSO, Infoset, Enhance extractors, transformation, DTP and Infopackage.
• Extensively worked with General ledger, Accounts payable and Account Receivable data sources for extraction and loading of data from FI to BW.
• Hands on experience with Front-end Business Warehouse Components which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures, Cell editors.
• Extensive experience in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, WebI and Crystal.
• Created Complex, Ad-hoc, and Drill Down, cross tab, multiple data-providers, multiple table/section and master detail type reports.
• Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and DataMarts.
• Enhanced standard data sources by adding new fields to the data source with the help of ABAP program called as user Exit.
• Familiarity with BI concepts like BI accelerators, BEx broad caster, ETL interface, InfoCube remodeling and information broadcasting.
• Performed extractions from SAP R/3 system to BW system using extraction queues and delta queue’s with the help of V3 serialized and un serialized updates.
• Performed performance tuning by creating Aggregates, Indexes, Compression and data partitioning within the Infocubes.
• Created WEBI reports and crystal reports and deployed them through InfoView with BW universe as source and created Inventory accuracy dash boards using Xcelsius.
• Implemented Query Stripping for the Performance efficiency in WEBI Reports.
• Created hierarchical reports using Cascading LOV Tool of Crystal Reports.
• Excellent leadership qualities and inter-personal communication skills.

TECHNICAL SKILLS:

ERP Applications: SAP ECC 6.0, ECC 5.0, 4.7, 4.6c, R/3, SAP BW 7.03.5/3.1c/3.0b, SAP BO XI 3.0/3.1/3.2

SAP Modules: FI/CO, Logistics (SD, MM, PP) CRM, SRM, QM, HCM,SCM and SEM.

Data Warehousing: BI 7.0, BW 3.5, 3.1c

Reporting Tools: Business Explorer, BEx Analyzer, Web IntelligenceDesktop Intelligence, Universe Designer, Xcelsius, CrystalReports 2008.

Database: SQL Server 2000/2005/2008, Oracle 10g/9i/8i,MS Access.

Operating systems: Unix, Microsoft Windows 2000/2003/XP/Vista/07, DOS

Programming Languages: ABAP/4, Java and PL/SQL, C, C++, HTML and Java Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. SAP BI/BO Consultant

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, SAP BO XI 3.1, FICO, SD, and MM, ABAP/4, NW2004S BEx, WAD, BO XI R3, SD, MM, FI (AP/AR/ New GL), PS, HCM, Crystal Reports 2008 and Xcelsius 2008 SP 3.

Responsibilities:

• Gathering Business Requirements from Users & Business Analysts for data modeling.
• Identified the gaps and suggested necessary enhancements for Transaction data and Master data extractors.
• Performed migration of emulated data source using with Export and without Export.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Extensively worked on performance, flexibility and Evaluate refresh timing, partition data, compress data cubes, leverage the use of DSOs, remodel large dimensional tables, clean up entries not used in Infocube dimensions and convert full loads into deltas.
• Performed performance tuning by creating Aggregates, Indexes, Compression and data partitioning within the Infocubes
• A Custom solution ZFIBKGDAT (Orders and Backlog) based Reports are converted to Standard COPA Transition, infocube like Costs and Allocations (0OPA C11) and CO-PA: Published Key Figures (0COPA C01).
• Involved in Modification to BW Parts Cap report by function module based on ZCSR RMA (ECC side) - Parts cap report does not show repair orders created for service contracts.
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Created WEBI reports and crystal reports and deployed them through InfoView with BW universe as source and created BI Quality dash boards using Xcelsius.
• Performed Up gradation from BW3.5 to SAP Netweaver2004s.
• Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and modeling data.
• Created Data Transfer Process (DTP) to transfer data within BI from PSA (Persistence staging area).
• Performed migration of emulated data source using with Export and without Export.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Implemented Start and End routines within Transformations.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Involved in BI implementation include BI configuration, requirement gathering, configuration, extraction setup, functional and technical design, data modeling, extractor setup and developing BI objects.
• Designed and created custom Multiprovider, InfoCube, DSO, Infoset, enhance extractors, transformation, DTP and Info package.
• Extensively Work with SAP Portal team to link reports to Firm Information Portal as required
• Analyze SAP Business Content components when delivered for relevance to Client and its subsidiaries projects including initiation of new projects. Document test plans and complete Unit Testing of developed reports.
• Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BW.
• Installed Business Content for Financial and Profit Center Accounting InfoCubes and customized the FI-GL, FI-AR, FI-AP and PCA business content cubes for meeting the business requirements.
• Handled accounts payable cubes (0FIAP C03), accounts receivable cubes (0FIAR C03) as a part of SAP BW implementation.
• Created complex reports and dashboards using BEx and BO XI (WebI & DeskI) and publish in Netweaver portal and also use information broadcasting.
• Extensively worked on front end reporting by using BEx, WAD and publish report in portal, configure information broadcasting involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Creating new reports after gathering the requirements from business users and modifying the existing ones using Web intelligence and Desktop Intelligence which are built on top of Universes.
• Designing, gathering and analyzing user report requirements, meeting business heads for gathering user requirements.
• Involved in the designing and building of classes, objects and universes and exported them to CMS (Central Management Server).
• Created Complex Ad-hoc reports using Slice and Dice, Drill Down, CrossTab, multiple data-providers, multiple table/section and master detail type reports on both in Business Objects XI R2 and Business Objects XI 3.2.
• Developed various Rich Client and Thin Client Reports using Business Objects and Web Intelligence.
• Created Reports with several Types of Graphical Representations such as Pie, Bar charts, and Graphs involving complex calculations.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Created hierarchies, complex objects using various @functions and aggregate aware objects in the universe.
• Worked closely with the Architects to address the performance issues from the server side
• Created new Views and Aggregate tables for enhanced report performance.
• Responsible for Administration of Business Objects servers that involved Improving Performance and Installed Hot fixes across Development, UAT, and Production environments.
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Developed dashboards using Business Objects Xcelsius.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.

Confidential, TX

SAP BI/BO Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, BEx, WAD, BO XI R2, ABAP/4 and NW2004S, CMS, CMCCrystal Reports 2008 Xcelsius 2008 SP 2.

Responsibilities:

• Extensive Experience in Production Support, Data loads, Validation and Trouble-Shooting of Transaction Data, Master Data, Transport Management, Performance Tuning and Process Chains.
• Worked extensively on FI-CO, SD, HR, CO-PA. Loaded the data from ECC to BI and used initialization with delta update and full update methods.
• Activated BI Content for Personal Administration (0PA C01, C02 Cubes) to analyze Personal data such as Head Count based on nationality, gender, Language, Personnel area employee group and organizational unit.
• Extracted the data from HR modules and uploaded the data into HR Info Cubes for 0PY C02 Payroll data, 0PABN C01 Benefits, Staffing Assignments 0HR PA OS 1, 0HR PA CM 1, and 0PT C01 Time and Labor Data and worked on transformations.
• Created reports Finance “Days Overdue analysis” “Payment History by Document Type”, “DSO Analysis by Period” reports.
• Created Report using BEx Query for “Day Overdue Analysis”, “Payment History by Document Type”.
• Activated profit center accounting cubes (0PCA C01, 0PCA C02), accounts payable cubes (0FIAP C02, 0FIAP C03), accounts receivable cubes (0FIAR C02, 0FIAR C03), Sale cubes (0SD C01, 0SD C02, 0SD C03, 0SD C05) from Business Content.
• Created Generic Extraction from user defined tables and created transformations using ABAP routines.
• Creating new reports after gathering the requirements from business user and modifying the existing ones using Business Objects XI 3.1.
• Worked on installation and configuration of Business Objects XI 3.1 Enterprise Suite (Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console, Auditor, and Dashboard Manager), Conversion of ZABO users to BOXI 3.1 Enterprise Suite.
• Export the query from BW using the MDX driverconnectivity and BICS
• Developed complex report in BI by using BEx Analyzer, Dashboard, Jump Query, WAD, Variables, formula variables, Calculated key figures, Restricted key figures, Formula, cell editor, custom exit using ABAP and publish in net weaver portal.
• Extensively work on Inventory related issues resolve some of major issues related to inventory start routine and reload the data.
• Developed InfoCubes, DSO, Transformation, Datamart, custom extractors, and start routine.
• Designing, gathering and analyzing user report requirements, meeting business heads for gathering user requirements.
• Worked on five universes (Billing, Provider, Experience Reporting, Claims, and Customer Care Management) and various reports related to them.

Confidential

SAP BI/BO Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, BEx Query Designer, WAD, BO XI, SRM, CRM, HCM, BO, ABAP/4 and NW2004S

Responsibilities:

• Gathering Business Requirements from Users & Business Analysts for data modeling.
• Identified the gaps and suggested necessary enhancements for transaction data and master data extractors.
• Performed extractions from multiple source systems including SAP ECC (using LO, Generic extractors), flat files, CRM etc.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Involved in customizing extract structures for MM and SD data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 BF.
• Worked extensively with payroll results from cluster, headcount and Personnel actions Extractors and enhanced respective cubes & DSOs. Installed Time Sheet Datacubes & Multiproviders 0CATS C01, 0CATS C02, 0CATS MC1.
• Installed Payroll and Personnel Time Management cubes 0PT C01, PY C02 & 0PY MC02. Extracted Payroll data using the Payroll Data sources.
• Created Info packages for scheduling data load process with Full and Delta update mode. Created transformations and DTPs for the necessary objects in development.
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a Drill down or summarized way to give detailed levels of information.
• Expertise in Reports Generation using BEx Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
• Used RRI feature to jump between the Queries to analyze the data efficiently.
• Worked extensively on Data warehousing workbench and managed and monitored data loads with Full update and Delta mechanism.
• Handled performance tuning of queries using aggregates, table partitioning, indexing of InfoCubes.
• Performed data integrity testing by executing Bex Queries validating against the backend ECC System.
• Created Drill through queries from summarized InfoCube to detail DSO data.
• Worked on BOBJ-BW Integration. (Created Universes, reports through WEB Intelligence, Xcelsius Dash Boards).

Confidential

SAP BW Consultant

Environment: BW 3.5, SAP R/3 4.6c, SD, FICO, MM, BEx, WAD.

Responsibilities:

• Required to interact with the management, identify Business requirements, and analyze reports in the SAP FI-CO and SD Functional areas.
• Extracted data from FI-GL, AR and AP Transaction Figures and Line Item Data Sources.
• Extensively worked on COPA extractors and External Database using DB connect.
• Developed process chains for DBConnect data loads.
• Monitored system load using ‘sm66’ transaction code.
• Performed System maintenance activities like aggregate roll up, cube compression.
• Repeated process chain steps in case of process chain failure.
• Executed and maintained process chains for PSA data deletion.
• Solved production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Used ABAP for Data Source enhancements EXIT SAPLRSAP 001, and extensively used ABAP Routines in Transfer Rules and Update rules to load and update data into Data Targets.
• Created process chains for daily data loads.
• Created and monitored process chains for data publishing using Infospoke.
• Involved in Performance tuning for various loading issues from source systems, Maximum size of a data packet, no of processors.
• Involved in Developing front-end queries using Query Designer and Web Application Designer and publishing results on the web.
• Built formula variables and also processing variables using replacement path and customers exit.
• Worked on the extraction of FI-SL (SAP R/3), SD, MM, data using LO into BW.
• Handled Query performance issues using appropriate objects while construction of Query.
• Developed different types of queries like Jump Query, Pre query. The results from the Created, Scheduled and monitored Info Packages and creating process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, and Master data and ODS data activation.

Confidential

SAP BW Consultant

Environment: BW 3.1C, SAP R/3 4.6C, SD, FI-CO, BEx Analyzer, Query Designer

Responsibilities:

• Involved in the Business Process study and identifying the reporting requirements.
• Worked on Front end, Queries, BEx Analyzer and presenting the result in workbook for Reports based on InfoCubes, ODS Objects and published the Web with Drill down features.
• Query development using BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
• Analyzed, Enhanced InfoCubes, ODS in standard delivered Business Content in SD, MM and FI/CO with specific requirement to the client’s business process.
• Created custom cubes, MultiCube for customer and vendor cycle core returns, sales order item/quantity Sales order header for fill rates, custom ODS, Custom InfoSources.
• Worked on standard InfoSources from the Business Content for MM - Purchasing for Transactional data.
• Created Aggregates, worked on Performance Tuning and Production Support.
• Worked on data extraction, LO-Cockpit, CO-PA.
• Worked on R/3 Data Extraction Enhancements.

Confidential

SAP BA Consultant

Environment: SAP BW 3.1C, SAP R/3 4.6C, SD, FI, MM, COPA

Responsibilities:

• Gathering requirements from business users, and convert them into technical specifications.
• To conduct Business and IT engagement workshops by by proto types and/or reviewing process flows. Should have demonstrated capabilities in identifying, owning and resolving issues.
• Involved in full life cycle implementation projects with a focus on design, development, deployment, go-live, and post-go-live support activities.
• Document both Functional Design Specification and Technical Design Specifications
• Involved in the Extended Star schema design support with multiple dimensions and fact tables. Enhanced Business Content as per the user requirements.
• Actively involved in the monitoring the data transfers from source systems into BW with the help of PSA.
• Involved in the development of Non-Cumulative Info cube for Inventory.
• Involved in the development of Query using Virtual characteristics and key figures.
• Development with Business Content as well as Creating Info sources, Info objects, Info cubes, DSO Objects, Transfer/update rule, uploaded master and transactional data from files and SAP as the OLTP source, monitoring, reporting. Worked extensively on administration workbench.
• All technical / design issues were directed for resolution.
• Installation Business Content and activated the SAP delivered Standard Info Cubes.
• SAP BW delta load, Updating Update rules, Modify communication structures and Day to day transport support.
• Monitor data loads with full update and delta mechanism and optimized the performance by adjusting packet size and data selections.
• Configuration of restricted key figures, variables, exceptions and calculated key figures in queries.
• Configuring standard and custom defined LIS, LO extractors. Used LO structures for extracting sales order, delivery information. Tracing problem to R/3 and resolution.
• Exception reporting, Condition reporting are designed to pinpoint the bottlenecks of the organization.

Confidential

SAP Business Analyst / SAP ABAP Consultant

Responsibilities:

• Gather the requirements for IT service catalogue and prepare the scope, vision and the Business Requirements Specification for the process flow.
• Involved in gathering requirements and documentation of business requirements
• Involved in development of Use Case from Business Requirements
• Define and Develop Use Case and the Test Case
• Attended JAD sessions and Test meetings to discuss and resolve issues and change requests.
• Created lists of providers for test database and loaded it into mass load environment in database. Also tested and validated the databases.
• Modeled the detailed design of the system using Use Case Diagrams
• Participated in periodical Joint Application Development (JAD) sessions with the management and IT teams; technical design walk-through to gauge extent of compliance with Trading Partner’s expectations.
• Involved in life-cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components
• Submitted change requests and worked with change request records in Clear quest.
• Participated in entering, tracking system defects in Rational Clear quest
• Involved in configuration management, requirement management and analysis
• Provide technical and procedural support for User Acceptance Testing (UAT)
• Worked with quality notification processing to help optimize company’s business processes through continuous process improvement