We provide IT Staff Augmentation Services!

Sr. Bw/bi Consultant Resume

Iselin, NJ

PROFILE SUMMARY

Business Intelligence professional with over 12 Years experience as an Architect, Administrator and a Developer. Functional/Technical expertise in SAP BW/BO in various industries including Government , Financial, Healthcare, Retail and Technology.

BW

  • Well versed with ASAP Methodology and all the phases involved in Project implementation.
  • Experienced in Data Analytics/ Data Mining utilizing different ERP tools and techniques.
  • Experienced in working in BW Upgrade Projects from BW 3.5 to BI 7.0
  • Strong expertise in SAP BI 7.x features: Transformations, DTP, Error DTP, DSO, Start and End Routines using Data Warehouse Workbench.
  • Experienced with new BI 7.3 features Real time data Acquisition, write optimized DSO, Open Hub destination, Admin Cockpit, BI Accelerator, Analysis Process Designer and Information Broadcasting.
  • Experience with two (2) end to end implementations.
  • Expert in building SAP-BW Components like Info-cubes, Data Marts, Multi-Providers, Info Sources, Info-object, ODS Objects, Info Spokes, Update Rules, Transfer Rules and Routines.
  • Expertise in data extraction from ECC (FI/CO, HR, CRM, SD, CO-PA) and Generic Data Sources.
  • End-to-End experience: Logical & Physical Data Modeling, Extraction, Reporting, Scheduling, Performance Tuning, Basis and Security activities.
  • Solid understanding of SAP HANA and implementation with SAP BW.
  • Understanding of BPC 10.0 with SAP BW.
  • Worked with real time infocubes and BPC.
  • Design and development of Standard and Custom SAP BW components such as InfoCube, ODS/DSO, Multi-Provider, Remote Cube, Transfer Rule, Update Rule, Transformation Rule(7.x), InfoSet, InfoSource, InfoObject, DataSource, InfoPackage, DTP, Open-Hup, DataMart, Multi-Providers, Process Chains, and Business Explorer (BEx)..
  • Extensive experience with various SAP and non-SAP extractions: Flat file, BCT, SAP CRM, LO Cockpit, CO-PA, FISL, Cross-Application generic extraction from DB view, SAP Query, Function Module.
  • Enhancement of data sources as per reporting requirements using User Exits.
  • Extracted data from R/3 systems using different extract structures like COPA,LIS, LO Cockpit and generic extractors for a variety of application areas such as SD, MM and FI-CO and from non-R/3 systemssuch as Flat files.
  • Modification of transfer rules/update rules as per business/data requirements.
  • Experience in ETL process using Business Objects Data Servcies (BODS) and loading into BW from third party sources.
  • Business Content, Generic Extraction, Enhancements, Info Set Queries; DB Connect,Data Marting with BW myself, external BW systems; both master and transaction data using multiple source systems.
  • Good functional knowledge of SD, MM and general business process of SAP R/3.
  • Created user reports in BEx query designer, Analyzer, Browser, Web Application Designer.
  • Debugging and monitoring capabilities using Query Trace, BW Statistics, Monitoring etc.

ABAP Development

  • Strong experience in ABAP Programming: Conversions using BDCs, LSMW; Interfaces, Reports and Update Programs; Shared Utility Programs and Function Modules; Dialog Programming; SMARTFORMS and SAP Script.
  • Extensive experience in Interactive and Classical reportsincluding ALV using ABAP Objects.
  • Interfacing thru Business Connector using ALE; IDOCs, BAPI and RFC.

BW/BI Architect

  • Designed logical data models based on functional requirements and load strategy specifications to capture source data, data consolidation mechanisms and integration scenarios for reporting purposes
  • As an Architect, Designed the BW/BI Technical Architecture in various complex environments
  • Designed BW/BI application integration with various portals and third party applications.
  • Designed the Architecture of Business objects 4.0 platform.
  • Designed the Process chains for BW data loading.
  • Defined the BW/BI Implementation process on Unix, Windows and Linux over different network architecture
  • Designed BW/BI Application Architecture based on System requirements and provided allowance for future expansions
  • Defined the BW/BI Cluster for Failover and Load Balancing
  • Converting Micro strategy Application into Business Objects

BW/BI Administration

  • Basis experience includes SAP security design (auth. object, authorization, profile, role) and administration
  • Business content installation, Gap analysis.
  • Migrate objects for transportation between developments to production phase.
  • Installation of BOBJ software - 4.0/XI 3.1/ R2/R1/6.5/5i/4i on Windows and UNIX platforms
  • Installation of BW software - 3.5/7.0/7.3 on Windows and UNIX platforms
  • Installed and configured BI Mobile 4.0.
  • Installed and configured DR systems.
  • Installed and configured SAP Business Objects Data Servcies 4.0 and information Steward 4.0.
  • Installation of third party web servers including Web logic, Web sphere and Tomcat
  • Configuration of BOBJ with Web logic, Web sphere and Tomcat
  • Deploying the WAR files into Web Servers
  • Portal Integration using BOBJ SDK on both .NET and JAVA
  • Defined Deployment process between the environments
  • Defined the SSO using both LDAP and Windows AD
  • Defined Security - Users/Groups/Folders based on Business Model
  • Participated full life cycle of the project from Implementation to Post- Production
  • Migrated BOBJ Environments from 6.5 to R1/R2/3.1
  • Migrated BW Content from 3.x to 7.x
  • Implemented both Single Pass Method and Incremental Method for Migrations
  • Defined the BOBJ Application Back-up and Recovery method at each level- Web services, BOBJ Apps
  • Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system

BW/BI Development

  • Gathered the requirements and developed the specification documents
  • Created Universes using complex and advanced features from various Database sources including Oracle, SQL Server, DB2, Teradata, Sybase and SAS
  • Developed Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards

Reports / Dashboards

  • Experienced in Report Generation - Worked extensively in BEx Analyzer and Web Application Designer. Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures.
  • Report Performance Tuning using Data Compression, Logical and Physical Partitioning, Archiving, OLAP cache, Aggregate, Dimension Sizing.
  • Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
  • Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
  • Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
  • Tuning the queries to improve the performance of the report refresh time.
  • Over 3 plus years of experience in Building Dashboards for Visual Representation of Data using Crystal Xcelsius 2008 using Qaaws, Live Office, XML, Flash variables and SAP BW Net weaver as Source connections.
  • Developed Xcelsius 2008 Dashboards on top of Qaaws and Live Office connections.
  • Created Universe for Ad-hoc and canned Reporting purpose based on DDL.
  • Used dynamic visibility and Excel functions to control and manipulate the data.
  • Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
  • Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.

EDUCATION

  • Bachelor's in Engineering

TECHNICAL SKILL SET

Report/ETL Tools
OLAP/DSS Tools : BW Versions: 3.1, 3.3,3.5, BI 7.0 and 7.3. BO Data Servicesversion: 3.1 and 4.0. Business Objects 4.0/ XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, SDK, SAP ABAP,Crystal Reports XI, SIA, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Translation Manager, Crystal Xcelsius 2008/4.5/2011, Information Deign Tool, Business Explorer, Metadata Manager, Life Cycle Manager, Information Steward, Performance Manager, Deployment Tool , Auditor, Crystal Report Explorer, Dashboard manager, Scorecards, Tomcat 4/5/6, Apache 1.3.x/2.2.x, WebLogic.

R/3 Versions : 4.6C, ECC 5.0 / 6.0 Data Modeling/

Oracle Utilities : Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader
Databases : ORACLE 10g/9i/8i, DB2, Informix, MS Access, MS SQL Server, Teradata.
Languages : SQL, PL/SQL, C, C++, COBOL, .Net and Visual Basic 6.0.
Web Technologies : VBScript, HTML 3.2/4.0, IIS 4.0/5.0/6.0/7.0, Web logic, Web sphere
Operating Systems : UNIX, Windows 2003 / 2008, Windows XP

Confidential, July' 10 - Present
Technical Lead

Responsibilities:

  • Working as a Technical Lead in a very high visibility role, overviewing all the BOBJ platform issues, issue resolutions and dealing with offshore and onsite support teams.
  • End to End implementation of Business Objects XI3.1 and 4.0
  • Installed and configured Business Objects XI 3.1 on Windows with IIS, Tomcat and Jakarta Redirector.
  • Installed and configured Business Objects 4.0, with WebLogic and Apache as Application and web server, respectively
  • Installed and configured SAP BODS 4.0, BI Mobile 4.0 and Information Steward 4.0.
  • Configured and tested LCM 4.0.
  • Designed the Architecture of Business Objects 4.0 platform and the End to end implementation plan.
  • Setup and completed DR system for BO Platform
  • Decommissioned R2 environment and configured Business Objects XI 3.1 environment.
  • Interact with the offshore team for the project performance.
  • Configure and implement Single Sign On using Windows AD.
  • Use HP Service Manager for Change Management.
  • Leading implementation of Business ObjectsLife Cycle Manager 3.1.
  • Implemented Metadata Manager on XI3.1 and Information Steward on 4.0 platform.
  • Leading the Platform expansion activities to meet the current growth.
  • Involved in Tuning and server configurations for different environments.
  • Applied Service Packs and Fix packs to stabilize Server environments.
  • Designed the schema and ETL process for Audit database.
  • Developed Reports based on Datamart for customer self servicing.
  • Review and monitor loading process for the operational reporting.
  • Design reviews of Universe, WebI, Crystal and dashboards for fine tuning and troubleshooting for issue resolution.
  • Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
  • Taking the lead in reviewing platform issues, finding possible solutions and implementing in production environments.
  • Interact with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Work on Monthly Business Review reports for the monthly platform reporting.

Environment: Business Objects XIR3.1 and 4.0 (Designer, WEBI, Web Rich Client, BI Mobile, Crystal Xcelsius 2008/4.0, QAAWS and Live Office), Oracle 10g/11g, SQL Server 2005/2008, DB2, Terradata, IIS, Tomcat, WebLogic, Apache, Linux and Windows Server 2003/2008.

Confidential, Dec' 08 - Jun' 10
Iselin, NJ
Sr. BW/BI Consultant

Confidential, provides the Stylish Women\'s apparel with a flair for individuality. Designed to fit and flatter. Clothes for the sophisticated woman featuring a full line of private label apparel and accessories, with a focus on comfort. Intimate apparel maker MFB Inc Brands has built a business with the company, being established to make Women Apparel as shapewear and sleepwear of its Customer such as Macy's Walmart Kohl's. MFB Inc sells its products worldwide; primarily through US discount chain stores and department stores. The company also sells its well-known brands (such as MFB Brands, Flexes', and Lilyette) through about 80 company-owned outlets and its Web sites.
Responsibilities:

  • Activation & Installation of Business Content Objects for FI, MM, SD, IM and Business content Enhancement.
  • Worked on the standard extractors for FI and CO. Enhanced business content extractors using LBWE & CMOD transactions. Deleting & installing data from setup tables for specific application components.
  • Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW and to report using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user exits.
  • Activated profit center accounting, accounts payable, accounts receivable cubes as a part of cross-functional SAP BW implementation.
  • Enhanced the standard extractors, by adding fields and User Exits to handle customer specific business requirements.
  • Worked with process-chains to automate the Data Loads, Rollups into Aggregates.
  • Worked extensively on Extraction from multiple Source Systems - SAP R/3, Non SAP Systems (DB Connect, Flat Files).
  • Created Info package, Routine and DTP's. Scheduling the jobs to run using Scheduler and handling Process Chains.
  • Gathered Security Requirements, Assisted in Security model design with Security Team. Implemented BW Authorization and Security for the BW System.
  • Worked on InfoSet queries for reporting on master data and ODS objects.
  • Experience in troubleshooting DataLoads.
  • Created a Generic extractor with data capability from a database view.
  • Analyzed business reporting requirements against standard Business Content and installed the necessary object.
  • Designed Queries, Reports, Workbooks and assigning them to Roles. Used calculated key figures and restricted key figures Conditions, Exceptions reporting and Customer Exits for calculating the YTD and JTD Values.
  • Created an Aggregate-schema to improve the Query Performance drastically.
  • Actively involved in Financial data providers, COPA cubes and financial Info cubes, DSO, multi providers according business needs in SAP BI.
  • Extracted and uploaded data into infocubes from data sources 0FIAP_CO2-transaction data, 0FIAP_C03-line items, 0FIAR_C05, 0FIAR_AR_4- payment history, 0FIAR_AP_4- Account Payable, and 0C0_OM_CCA_X, 0CCA_11- cost and allocation, 0C0_OM_OPA_X- Internal Order, and customized those using Update Rules. Created ODS, InfoCubes and MultiProvider for queries. Created Balance Sheet, Profit & Loss Reports, Trial Balance, and Cash Flow Statement on GL Info Cube.
  • Loading of transaction data to the business content Info Cube from Info Sources like 2LIS_11_VASCL, 2LIS_11VAHDR for sales, 2LIS_13_VDHDR, 2LIS_13_VDITM for billing, 2LIS_12_VCHDR for order
  • Worked extensively on Query Monitor and tracing the SQL Query.
  • Provided Process documentation, which includes data flow and how to guides to end users for post production support.
  • Installed and configured Business Objects XI 3.1
  • Involved in Tuning and server configurations for different environments.
  • Applied Service Packs and Fix packs to stabilize Server environments.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Created live reports in a drill down mode to facilitate usability and enhance user interaction.
  • Developed Dashboards using Crystal-Xcelsius with data source as Live Office.
  • Developed customized Webi reports.

Environment: SAP BI 7.3, SAP 6.0, ABAP/4, BO XI3.1, Oracle 9, DB2, Windows 2003 and Windows XP

Confidential, Oct' 07 - Nov' 08
SAP BI Consultant

Responsibilities:

  • Conducted workshops with business users towards requirements gathering to deliver a functional design document.
  • Analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques, with an emphasis on actual implementation in BI.
  • Created data objects for the reporting areas, which includes building all structures within BW that supports the reporting, such as Extractors, Generic Extractors, Data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info Package groups, Info Objects, ODS, Info Cubes, Queries, Variables, Calculated key figures, Info Set Queries, Workbooks, Analyzer, Browser, ITS, 3rd party reporting tools (Business Objects, Crystal), Roles, Transports, etc.
  • Apart from creating an end to end blueprint document, involved in BI build specific to ECC HR (PA, OM, Time, Benefits) and IS-U CCS. Worked with both Business content and Non-SAP sources, enhanced content to adhere to business requirements.
  • Validated the BI data extracts from the IS-U data sources related to Device Management, FI-CA, Billing and Invoicing to various data targets related to IS-U
  • Worked on enhancing the standard extractors and built custom extractors to meet the ISU - CCS reporting requirements
  • Enhanced the standard HR extractors and cubes for PA, OM, Time and Benefits as part of the reporting requirements.
  • Validated the BI data extracts from the HR data sources related to OM, PA, PD, Time and Benefits, FI-CO, MM, Purchasing data sources to various data targets in BW.

Environment: SAP BW 7.0, SAP 6.0, ABAP/4, Oracle 9, SQL Server 2005 and Windows Server 2003

Confidential, Sept' 05 - Oct' 07 Wilmington, DE

SAP BW Consultant

Responsibilities:

Involved in the design, development, testing and implementation of Business Warehouse using extended star schema and configuring the system and users. Created ODS objects for InfoCubes. Designing data model and InfoCubes for SD Sales, Customer and FI-AR Modules. Data Extraction from R/3 and flat files. Setting up LIS Environment for the structures using RMCSBIWC and replicated data sources on BW. Worked with real time infocubes and BPC. Extensively worked on activating the standard delivered business content of LIS in the form of Info Objects, Info Sources, Info Cubes, ODS and customizing it by creating new business content. Expertise also includes flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW through data staging to PSA and Info Cube or ODS. Worked on creating data targets i.e. Info Cubes and ODS by creating interfaces at BW and SAP R/3 level. Data extraction using LIS extraction (MC21) Customization, LO Cockpit (LBWE) and OLTP/generic data extraction (RSO2). Analyzed Info Cubes (via RSRV) created and maintained aggregates (RSDDV) to improve the performance. Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals. Created Info Sources, Info Cubes, Aggregates, ODS for sales orders according to sales organization, distribution channels, ship-to-party customers, material, vendor line items and creating ledgers. Extracted data using CO-PA (KEB0) (cost or account based) for analyzing the data on various criteria/partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs. Created customizing LIS and LO Cockpit extract structures and data sources in sales and distribution, inventory management and material management to facilitate the data extraction to BW and to reporting using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user/function exits. Depending on the requirement or frequency, with which data has to be extracted to BW, based on that jobs are scheduled one time or recurrent or batch, by using events or time triggers. Extensive reporting on Info Cubes/ODS objects using BEx Analyzer/Explorer (RRMX) to facilitate summarization of data. Created local and global workbooks, Info set queries and template workbooks. Created roles (PFCG) and maintained roles for reports. Used R/RI interfaces, filtering, conditions, variables, currency conversions, drilling, jump queries and navigational attributes

Environment: SAP R/3 4.6C, BW 3.0 B, 3.1 C/7.0 ABAP, oracle 8i, BPC.

Confidential, Dec '03 - Aug '05 Sunnyvale, California

SAP BW Consultant

AMD is the customer-centric innovation company, a processing powerhouse that offers smarter choices for its customers and makes technology more accessible to the world. AMD is focused on best meeting the needs of leading computing, wireless and consumer electronics companies to help them deliver high-performance, energy-efficient and visually realistic solutions Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content Sales Cube, Purchase cube Vendor Evaluation and Customer cube.

Responsibilities:

  • Analyzing The SAPBW Business Content Required, Activating The Business Content Components.
  • Worked on activating the standard business content Info Cube 0SD_C01 Customer, 0SD_C03 Sales Overview, 0PUR_C01 Purchasing Data and 0PUR_C05 Vendor Evaluation.
  • WorkedExtensivelyonStandardandCustomDefinedLIS,LOExtractorsInstalled Relevant SAP Business Content.
  • Extraction the Data from R/3.Activation of Data Source, Enhancement in Data Source. Creation of Generic Data Source and Delta Management for Extraction
  • Involved in Modification and Activation of Info cubes/ODS ,Info source for Master Data and Transactional data Transfer Rules ,Update Rules ,Info package and Variables.
  • Configured the Use of Restricted Key figures Variables Exceptions and calculated key figures in Queries
  • Transported the objects from Development to QA for testing
  • Scheduling Info packages for loading Master Data and Transaction Data & Monitoring
  • Monitor data loading into the Info cubes with respect to BW Data.
  • Worked on Reporting for MM and SD Module
  • Installation of BOBJ software XI R2
  • Configure, Web Server, CMS and Audit DB
  • User setup and code promotions.
  • Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
  • Created hierarchies for drilldown paths.
  • Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
  • Written SQL Queries and created Views for Operational and Analytical reports.
  • Tuned Universes for Report level performance.
  • Created Reports using Webi Intelligence, used multiple sources to create reports, Combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.

Environment: SAP BW Ver 3.1c, SAP R/3 4.6b/4.6c, BO R2 & Oracle8i

Confidential, Nov' 02 - Nov' 03
Providence, RI
SAP BW/BO Consultant

Responsibilities:

  • Created Master Data Infosources for Attributes, Texts and Hierarchies. Created Custom Info object Catalogues for Characteristics and Key Figures for the Sales Info area. Created several Periodic and Annual Reports for various Planning Functions/roles.
  • Designed and created several Sales Queries using BEx Analyzer, with drilldown functions, calculated key figures using functions and R/3 interfacing for additional drilldown reports.
  • Flexible Data Staging: Update into any data targets using Communication Structure and Update Rules. Direct Data Staging: Update from Master Data into an Information Object without using Update Rules. Lookup of Master Data Attributes in BW Update Rules during ODS Updates. Multiple Data Sources per File-Source system. Start Routine in BW Transfer Rules. Check referential Integrity.
  • Integration of Formula Builder in BW Transfer Rules. Lookup of Master Data Attributes in Update Rules, lookup for ODS key fields, lookup for ODS data fields. Multiple Data Sources per File-Source System. Start Routine in BW Transfer Rules; Time Split in BW Update Rules.
  • Activation of Standard Business Content, customizing and creating custom cubes.
  • Enhanced new InfoObjects to be attached/mapped in InfoSources/Communication structures. Created/changed Transfer rules and Update rules as per customer requirements (ABAP routines).
  • BW Performance: Partitioning, BW Delta Updates, Aggregates, BW Archiving and Data reloading.
  • Direct Master Data Staging: Update from Master Data into an Info Object without using Update rules.
  • Info Package Management for data loads via IDoc or PSA, Flat file creation/load PSA (used to source data from legacy system into BW). Created custom and modified standard Info Objects based on Master and Transactional data from SAP and flat files into BW.

Environment: Oracle 8i, Solaris, Window 2000, SAP R/3 4.6D, SAP BW 3.0A,ITS

Confidential, Oct'99 - Oct' 02
SAP BO Consultant

Responsibilities:

  • Gathering system requirements from Business Owners and Business Users.
  • Interacted with Business Users to understand their specific Business needs for reporting for their daily business.
  • Organized and conducted meetings with users both one to one and in groups are Risk Management, Loan Admin and Accounting.
  • Worked on Analyzing, Implementation and administration of security models in Unix environment.
  • Understanding the banking domain with capital market.
  • Understanding existing system and documented all the reports and Universes.
  • Defined Business Views for crystal reports development.
  • Created reports for different departments like Risk Management, Loan Admin and Accounting.
  • Designed crystal reports with dynamic content & Custom UI.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Scheduled crystal reports and Implemented dynamic cascading prompts.
  • Installed and configured BCA for publishing the reports through emails and worked on BCA console.
  • Created Analytics on top of Metrics for the Performance Manager.
  • Involved in creating dashboards for management and able to perform drill down action to view more details on the report.
  • Maintained Supervisor for administrative privileges with user accounts and access.
  • Worked with team closely with Functional Architect, DBA and Analysts.
  • Understanding Investors of all types have the opportunity to participate in financial strategies that can strengthen the general economy as well create financial security.
  • Provided guidelines of Job scheduling process integrating Web Administrator and job scheduling process with job dependencies.
  • Worked and maintained three systems: Development, UAT (QA) and Mock (Production).

Environment: Business Objects 6.5.1/ XI,Crystal Report, Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Toad, SQL Server2000, Oracle 8i, SQL, PL/SQL, UNIX, Windows 2000/XP

Hire Now