We provide IT Staff Augmentation Services!

Sap Bi Consultant Resume

4.00/5 (Submit Your Rating)

Princeton, NJ

Overview of Experience:

  • Around 11 years of IT experience and 6+ years of experience in SAP Business Warehouse, SAP Business Intelligence, SAP ECC 6.0.
  • 2+ years of experience in Business Objects XI 3.0/2.0, Crystal Reports 8/8.5/9/11/2008 and Xcelsius 2008.
  • Completed 3 full life cycle Implementations in SAP BW/BI including Requirements gathering, GAP analysis, Business Requirement documentation & Business Blueprint, getting client approvals, Go-Live and Production support.
  • Expertise in:
  • R/3 and Non R/3 Extractions
  • Modeling
  • Reporting
  • Specialized and adept knowledge in:
  • SAP R/3, ECC 6.0/5.0.
  • BI 7.0, BW 3.5.
  • BEx Analyzer, BEx Browser, Web Application Designer.
  • ABAP/4 Development Workbench
  • Business Objects XI 3.0/XI 2.0, Crystal Reports 2008, Xcelsius 2008.
  • Strong background and experience in Dimensional and Relational Data Modeling: Star Schemas, Extended Star Schemas, Normalization, Denormalization, Physical Database Design, Relational Models, Key Performance Indicators (KPI) and other OLAP considerations.
  • Installation, activation and enhancements of Business Contents of FI/CO, PS, SD, MM, PP, FS-RI and FS-CD modules.
  • Extensive Knowledge in COPA, LIS/LO data extractions.
  • Understanding of BPS, BI-Integrated Planning (IP), and BPC 7.0 NW/MS.
  • Expertise in ABAP Development.
  • Worked extensively on BEx Query Reporting, Report-to-Report Interface (RIR) and Web Reports and experienced in Report Automation.
  • Experience in SAP BO XI Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, Desktop Intelligence, Web Intelligence (WebI), BO Dashboards, Crystal Reports, Java/.Net InfoView,Xcelsius dashboards, Web Intelligence Rich Client, Desktop Intelligence (DeskI), Voyager workspace, Web Analyzer and Broadcast agent
  • Working knowledge of Visual Composer to create, check and deploy the model to Portal
  • Expertise in ETL Analysis, Design and Development.
  • Excellent experience in ETL tools like Informatica, SSIS.
  • Expertise in Databases - SQL Server 2000/2005, Oracle 8i/9i/10g.
  • Excellent leadership skills with strong analytical and technical abilities.

Education:

Bachelors of Degree in Computer Science (B.Sc.Comp)
Masters in Computer Applications (MCA)

Status: Green Card.

Skills:
ERP : BW 3.5, BI 7.0, SAP R/3, ECC 6.0.
Operating System : Windows 2000/2003, Windows NT/XP, UNIX.
Cross Applications : Knowledge in ALE and BAPI.
Database : Oracle 8i/9i/10g, SQL Server 6.5/2000/2005, MS Access.
ETL Tool : DataStage, Informatica, SSIS.
Data Modeling Tools : Erwin.
Reporting : BEx Analyzer, BEx Query Designer, Business Objects and Crystal Reports, Xcelsius, BPC 7.0 NW/MS.
GUI Tools : Web Application Designer.
Languages : ABAP/4, XML, VB, Java, HTML, DHTML.

Professional Experience:

Confidential, Princeton, NJ 09/08 to Till Date
SAP BI Consultant

Confidential, a member of the Munich Re Group has a pre-eminent position in the global reinsurance industry and one of the leading providers of reinsurance in the United States. Munich Re America, one of the largest providers of property/casualty reinsurance and related services in the U.S., offers clients the financial strength they can depend on. Our group is rated A+ (Superior) by A.M. Best Company, and has $3.6 billion in statutory surplus.

Description: Extract and Consolidate data from Reinsurance Business and Direct Insurance Business. Designed ODS, Cubes for Consolidated Premium and Loss Data from various Source Systems. Implemented various BI solutions for production related issues. Performance Tuning on InfoProviders and MultiProviders. Migrated from SAP BI to Business Objects XI 3.0. Developed reports framework using Business Objects XI 3.0.

Responsibilities:

  • Involved in Requirements gathering for the in Design and Development of Direct and Re-Insurance Consolidated ODS and Cubes.
  • Extracted Data from different Source System like FS-RI for Reinsurance data, Oracle and other Legacy systems for Direct Insurance data.
  • Enhanced the Extract structures as per the requirements.
  • Extensively involved in resolving performance problems in BW with ETL process and Reporting.
  • Written complex ABAP Codes for Transfer Rules and Update Rules for custom designed ODS and Info cubes.
  • Designed process chains for master data loading, delta loading and for weekly PSA deletion.
  • Assisted in developing web reports, web items, customized web templates using web application designer (WAD) and query designer.
  • Involved in SAP Integration with BO XI 3.0 and designed Universes with SAP BW Data Sources and BEX Queries in Business Objects XI 3.0.
  • Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
  • Created Crystal Reports from SAP BW Queries and worked on Xcelsius Dashboards.
  • Involved with Performance Tuning and Optimization of Queries by maintaining Aggregates, Compression the cubes, setting the cache modes for queries wherever required.
  • Worked on Planning and Consolidation Reports using BPC 7.0 NW.
  • Used Open Hub destination to create extracts based on the user requirement and loaded data into Oracle and other Legacy systems.
  • Implemented BADIs in Info spokes for further transformation into downstream systems.
  • Implemented logic in ABAP to automatically delete previous week's loads in info providers through process chains and Balancing programs to balance the BW data with various source systems
  • Knowledge in RealTek Transport Manager a tool for transport requests processing.
  • Implemented Virtual Key Figures in the InfoProviders as per the report requirements and RRI as part of the performance tuning in reports.
  • Implemented Conversion Routine for the Characteristic Info Object level which converts character value to the number and displays commas in Report and Variable Screen.
  • Implemented Info Package ABAP variables to exclude data in the data selection and Logics in Transformation for invalid characters.

Environment: SAP BI 7.0, SAP BW 3.5, BEx Browser, BEx Query Analyzer, SAP R/3, Business Objects XI 3.0 (CMS, CCM, CMC, Dashboards, Crystal Reports 2008, Web Intelligence XI),Xcelsius 2008, Oracle 10g, SQL Server 2005, Windows 2000/2003, APD, BPS, BAPI, APO, ABAP, BPC 7.0 NW, FS-RI, FS-CD.

Confidential, New York, NY 01/07 to 08/08
SAP BI Consultant

Description:The main objective of the Sourcing Dashboard Integration Project is integrating Universal data with existing NBC Sourcing Dashboard which is used for spend analysis. The various spend systems include Accounts Payable systems, Purchase Order systems and Credit Card systems. Different systems have been integrated. This project is executed for Finance department of General Electric.

Responsibilities:

  • Analyzed business requirements and translated them into Dimensional Data Models using extended star schema technique.
  • Extensively involved in gathering user requirements and GAP analysis between BW 3.5 and BI 7.0.
  • Gathered requirements with the users and participated in the technical & functional specifications preparations.
  • Worked as a business analyst evaluating user requirements, coming up with appropriate design, converting the Business requirement documents (BRD) to Application Design Document (ADD) and then developing the required application.
  • Sourced data from various data sources including R/3 & legacy data system, transformed and loaded data into data targets using ETL tool.
  • Worked in BI 7.0 on DW Workbench, DTP, DSO, Transformations, PSA, BI Accelerator and remodeling InfoProviders.
  • Data Flow modeling in BI/BW with Administrator workbench InfoObjects, InfoSource, InfoCubes, Multi-Providers, Aggregates, ODS/DSO's, Transfer Structure, Transfer / Update Rules, Data Transfer Processes, InfoSets and Data Sources.
  • Created batch processes & coded ABAP programs as required for using in routines and start routines in the DTP, Transfer Rules and Update Rules.
  • Set up statistics/aggregates rebuild and event-chains to notify end-user of report availability.
  • Developed reports using BEx Query Designer and BEx Browser. Used Restricted Key Figures & calculated key figures for filtering and formula as per the requirement of query.
  • Worked on Business Objects Universe Designer and extensively used Central Management Console (CMC).
  • Created reports using Desktop Intelligence and Web Intelligence in BO XIR2 environment.
  • Analyzed the info cubes and maintained the aggregates to improve the reporting performance for BEx Reporting.
  • Created Open Hub extracts for a daily and monthly loads of finance extracts from InfoCubes and ODS.
  • Performed Delta upload management with OLTP extraction.
  • Extensive work done on process chains as well as performance enhancing aggregate tables and system settings and parameters to speed up loading as well as reading of data.
  • Worked on Table Controls, Data Dictionary, BDC, BADIs, Reports, Transactions, Function Modules and SAP scripts in ABAP/4 programming language.

Environment: SAP BI 7.0, SAP BW 3.5, BEx Browser, BEx Query Analyzer, SAP R/3, Business Objects 6.5.1/ XI R2 (CMS, CCM, CMC, Dashboards, Crystal Reports 11, Web Intelligence XI R2), Oracle 10g, SQL Server 2005, Windows 2000/2003, APD, BPS, BAPI, APO, ABAP, FI-CO, SD, MM, HR.

Confidential, New York 02/06 to 12/06
SAP BI Consultant

Description: Confidential, is a leading global financial services firm with assets of $1.6 trillion and operations in more than 60 countries. The firm is leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

Responsibilities:

  • Involved in the full cycle of development and implementation of SAP BI 7.0.
  • Did Gap Analysis between BW 3.5 and BI 7.0. Participated in the migration process of BW 3.5 to BI 7.0.
  • Involved in the star schema and extended star schema design with multiple dimensions and fact tables.
  • Loading SAP R/3 and non-SAP R/3 loading into BW InfoCubes.
  • Involved in the implementation of FI InfoCubes to extract the data from R/3 system and transporting into BW using LIS/LO data extraction, data extraction from flat files, standard R/3 tables or non-R/3 systems and monitoring them.
  • Created Data Sources, InfoSources and Info Packages to extract Master and Transactional data from SAP R/3 system into SAP BW.
  • Loaded Master and Transactional data from SAP R/3 via data staging to PSA, ODS and InfoCubes.
  • Configuring standard or customer specific InfoCubes for all areas, incorporated transfer rules and update rules to manipulate the data using ABAP/4 in routines.
  • Created Partitions on Cubes to improve the performance.
  • Responsible for activating the Business Content Objects and loading the data into ODS objects.
  • Efficiently used ABAP in modifying the structure.
  • Generated reports for Finance, Human Resources with Business Explorer.
  • Created Technical Specifications and Design documents for the given Business Requirements for the Reports and Cubes.
  • Defining query in the BEx Analyzer and presenting the result in workbooks and integrating the workbooks with BEx Browser.
  • Configured use of restricted key figures, variables, exceptions and calculated key figures in queries and created custom interactive reports with drill-down features as per user requirements and worked on Crystal reports as well.
  • Created and scheduled Process Chains to upload data into InfoCubes and ODS from Flat files and other Data Sources.
  • As part of Performance Tuning optimized the load performance by adjusting the packet sizes, data selections and number of Info Packages.

Environment: SAP BI 7.0, SAP BW 3.5, BEx Browser, BEx Query Analyzer, APD, BPS, BAPI, APO, ABAP, FI, HR, SAP R/3, Oracle 9i, SQL Server 2005, Windows 2000/2003.

Confidential, Omaha, NE 01/05 to 01/06
SAP BW Consultant

Description: Worked as a BW consultant on the development of a Trade Promotion Management (TPM) system. The TPM project includes headquarter planning, field planning, customer sell-in and negotiation, execution and validation, and evaluation.

Responsibilities:

  • Create Requirement documents (BRD) for the reports to be built on the MultiProviders, InfoCubes and ODS.
  • Gathered requirements on the development of Info Spoke from the FI users.
  • Created Info Cubes for Sales Data with Custom Field Catalogues with specified Dimensions for Characteristics and Navigational Attributes.
  • Involved in creation of Info Objects, InfoSources, ODS, InfoCubes, PSA for Data extraction, transformation and loading from SAP R/3 and not SAP R/3 system to SAP BW.
  • Created Aggregates and MultiCubes for performance and efficient utilization of data.
  • Installed and activated necessary Business Content.
  • Used ABAP code in writing transfer rules and update rules.
  • Used BEx Reporting and Web Application Design for developing and designing queries
  • Developed reports using BEx Query Designer and BEx Browser. Used Restricted Key Figures & calculated key figures for filtering and formula as per the requirement of query.
  • Extensive work done on process chains as well as performance enhancing aggregate tables and system settings and parameters to speed up loading as well as reading of data.
  • Created and scheduled Process Chains to upload data into InfoCubes.
  • Performance tuning to improve data loading on InfoCubes by creating particions.
  • Information Broadcasting via Email, Portals, Bursting (email) with various formats (pdf, HTML. MHTML)
  • Worked on Analysis Process Designer (APD) to identify complex relationships between data in a simple way using transformations like statistical and mathematical calculations, data cleansing and structuring processes.
  • Worked on gap analysis and upgrade of SAP BW 3.1 to SAP BW 3.5.

Environment: SAP BW 3.5/3.1, BEx Browser, BEx Analyzer, APD, BPS, BAPI, APO, ABAP, FI, SD, MM, SAP R/3, Oracle 9i, SQL Server 2000, Windows 2000.

Confidential, New Jersey 11/03 to 12/04
SAP BW Consultant

Description: Lexington Insurance, a member of American International Group's (AIG) Domestic Brokerage Group (DBG) is an excess and surplus lines insurer, chartered in Delaware and domiciled in Massachusetts. Lexington'sexcess product coverage's include: property, casualty, programs, special accident, captives, international, ocean marine and space. Lexington is a leader in many specialty classes of business, including directors and officers, healthcare, professional and management liability, personal lines, as well as risk management services.

Responsibilities:

  • Worked extensively on evaluating user requirements in the areas like Finance, Human Resources and Reinsurance coming up with appropriate design, which sometimes involved mixing data from SAP and non-SAP sources.
  • Dealt with InfoCubes, Data Sources, Info Sources for Finance data, HR data, Payroll data extracted.
  • Designed and developed several BEx Queries and Workbooks.
  • Developed BEX queries involving structures, cell definitions, user exits, exceptions and conditions.
  • Used extensively ABAP/4 in user exits for variables in BEx.
  • Developed charts and graphs based on the historical data available in queries for HR.
  • Developed reports named Total controllable absenteeism, Historical chart, Monthly absenteeism, Percent available hours report, Monthly absence report, Weekly absence report by department, Daily absence report.
  • Used RSRT and BEX Analyzer (RRMX), BEX query designer and analyzer.
  • Created variables and used in user exits to populate the data and year for various user requirements.
  • Used ABAP/4 code in transfer rules extensively to convert the company code to clients naming conventions. Experienced in loading data from flat file, other RDBMS Databases, SAP R/3 to Info Cubes and ODS.
  • Created process chains for scorecard processing various applications to monitor the productivity..
  • Developed reports for COPA in profitability analysis.
  • Worked extensively on delta load to ODS.
  • Created and maintained Aggregates on InfoCubes to improve performance of the Reports.
  • Scheduled Process Chains to load daily and monthly data. To improve the performance of loads dropped indexes before load process and created indexes after the load process is completed.

Environment: SAP BW 3.1, BEx Browser, BEx Analyzer, Oracle 8i, SQL Server 2000, APD, BPS, BAPI, APO, ABAP, FI, HR, FS-RI, FS-CD, SAP R/3, Windows 2000.

Confidential, Chicago, IL 09/02 to 10/03
SAP BW Developer

  • Project Overview: Wrigley providing the world\'s highest-quality chewing gum and confectionery products like Double mint , Big Red , Winter fresh , Extra , Eclipse , Freedent , Hubba Bubba , Orbit and Excel. The Wrigley Company employed nearly 15000 associates around the World and its corporate head quarters are located in Chicago's World famous Wrigley building.

Responsibilities:

  • Developed code, tested and delivered for the Transaction data extractors and Master data extractors.
  • Enhanced Business content extractors data sources and Generic Extractors.
  • Maintained different SAP R/3 / BW landscapes for Development, Quality Assurance, Training and Production Worked with SAP BW Administrator workbench for Customizing, Scheduling and Monitoring
  • Customized ODS, and Info Cubes in the application areas of FI/SD Created Info Objects (Characteristic & Key figures), Info Source, ODS and Activated Communication Structures, Transfer Structures, Transfer rules, Routines and Update Rules (ODS and Info Cube) Enhanced Extractors and worked with standard Extractors for data Extraction from SAP R/3 OLTP instance Schedule Data Loads of Master (Attributes/Text/Hierarchies) and Transactional data from SAP R/3 OLTP and Flat files into BW Developed many BW reports based on the info cubes and ODS objects using BEX Maintained and created Aggregates for Query performance Created Generic Data Sources for Transactional data, Master data and Texts based on Views and Function Modules Configured the connectivity by setting up logical system name, ALE Remote user and RFC destination to connect BW and SAP R/3
  • Designed functional specifications to meet the business requirements
  • Extensively worked on Performance Tuning at the Cube level & Query level.

Environment: SAP BW 3.1, BEx Browser, BEx Analyzer, Oracle 8i, SQL Server 7.0/2000, APD, BPS, BAPI, APO, ABAP, FI, SD, MM, SAP R/3, Windows 2000.

Confidential, Minneapolis, MN 05/01 to 08/02
ETL Developer

Description: The purpose of the conversion project was to convert PMC ETL capability to Informatica from Abnitio tool. The reason for the change was to mitigate the cost of environment support, increase productivity with the help of friendlier development interface, use of Power Exchange CDC feature for capturing data changes and reduce cost of unit development.

Responsibilities:

  • Interacted with business users, Data Architects converted requirements into actionable specifications and designs.
  • Discussion with other teams to maintain standardization across projects.
  • Creating mappings to load source data into target tables using transformations like the Joiner, Expression, Filter, Lookup and Update Strategy, Rank, Sorter.
  • Creating workflow/mapping parameters and variables to be used globally.
  • Used the debugger to validate the transformations by creating break-points and analyzing the debug monitor
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
  • Utilized a lookup and update strategy to lookup values from different tables and to update slowly changing dimensions.
  • Used persistent caches whenever data from workflows were to be retained.
  • Used connected and unconnected lookups whenever appropriate, along with the use of static and dynamic caches
  • Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
  • Performed SQL tuning using EXPLAIN PLAN and facilitate the access of the Data with better performance.
  • Performed administration activities including; backup & recovery of Informatica repositories, installation & configuration of Informatica server & clients, manage users, user locks and folder privileges.

Environment: Informatica 5.3/6.2, Oracle 8i, SQL Server 6.5/7/0, Sybase, TOAD, Windows NT/2000/XP, Data Warehouse.

Confidential, Mechanicsburg, PA 05/99 to 04/01
Developer

Description: Administrative Support Application Project - ASAP is a computerized solution to the Administrative Office of Pennsylvania courts of the Supreme Court of Pennsylvania (AOPC), here in known as the Commonwealth.

Responsibilities:

  • Responsible for full life cycle of development including analysis, design, coding and testing for all the modules.
  • Developed GUI's of all modules using VB 5.0.
  • Developed the model layer of the application and implemented business logic using Java scripts and ASP.
  • Tools developing for easy accessing and migrating the existing data using stored procedures and.
  • Handling Project Change Requests (PCR).
  • Generating reports, form letters and notices using Crystal Reports 8.0.
  • Used PVCS as version control system for deployment in various environments.
  • Performed SQL tuning using EXPLAIN PLAN and facilitate the access of the Data with better performance.
  • Developed complex stored procedure for Payroll, Finance and HR modules.
Environment: SQL Server 6.5/7.0, VB 5.0, Java, ASP, XML, XSL, Windows APIs, Crystal Reports 8.0, ActiveX Controls, Microsoft Transaction Server 2.0, PVCS.

References: All References will be provided upon request.

We'd love your feedback!