We provide IT Staff Augmentation Services!

Sr. Sap Business Intelligence Consultant Resume

Northbrook, IL

SUMMARY

  • Over 8 years of professional experience in design, development and implementation of business applications which includes eight years of SAP BW/BI Net weaver 7.x, BW 3.5 and 5 years of Business Objects more than 3 years of experience in ABAP/4 Programming.
  • Involved in 4 Full life cycle implementation and provided key services such as data modelling, design support, and data management as well as cross - functional technical design.
  • In depth understanding of SAP R/3 functionality (SD, GL, PP, MM, PM,HR, FI, CO-PA), Standard Business Contents and Data Modeling (like the star schema and the flat structure) in Sap BI/BW.
  • Maintained extract structures for Purchasing, Inventory and Sales & Distribution (Sales, Delivery, Pricing, and Shipping).
  • Extracted data usingBWextraction structures such as LO Cockpit, CO-PA, and Generic & Standard Extractors.
  • Analyzed user assigned reports and business needs for reporting and possible enhancement of extractors to cover Bex Reports.
  • Well experienced in Data warehousing concepts, Designing effective client specificBWsystems, Data Modeling, Performance Tuning, Data Extraction and Data loading for both application specific as well as generic from R/3, ECC, and NonSAPsystems like Oracle and other legacy systems.
  • Worked on various pre and post activities of the Upgrade project fromBW3.5 toSAPBW7.0 (SAP Net Weaver 2004s).
  • Created Secure Connection, Data foundation & Business Layers in Information Design Tool upon BEX Queries and HANA Models for designing reports using, WEBI, Crystals, and Dashboards.
  • Expertise in Business Objects 4.1, XI 3.1/XI R2, Universe Designer, Information Design Tool, Import wizard, Publishing Wizard, Business Views, Desktop Intelligence, Xcelsius/Dashboard Designs, Crystal Reports 2011/2008 and Web Intelligence, Analysis for Office tools, Explorer, SAP Lumira.
  • Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts, Input Controls, Tracking Changes, Sorting and Ranking of WEBI for creating interactive reports.
  • Experienced in creation of Authorizations, Roles/Profiles based on the Client Business Model.
  • Strong knowledge In creating connections using Data Connection manager like Live Office, Query As A Web Service (QAAWS), Flash Variables,SAPBI connectors, UD connecters, DB connectors.
  • Experience in QA Life Cycle, including preparing Test Cases and testing the developed programs (Unit testing, Integration testing, Regression testing, System testing).
  • Experience in documenting technical functional specifications, test cases and provided extensive post go-live support.
  • Experience in using SAP OSS Notes to resolve the issues and escalate the issues to the SAP.
  • Positive attitude and very open minded in Sharing and transferring the technical as well as the business knowledge to peers and other project members.

TECHNICAL SKILLS

Modeling Tools: SAP BW 3.5, 3.1C, 3.0B, 2.1C and SAP BI 7.3.

ERP: SAP ECC 7.0, 6.0, R/3 4.6C/ 4.6B/ 4.5B, FI/CO, HANA

Reporting Tools: Business Explorer, WAD, Business Objects, Cognos and Crystal Reports.

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

Programming Languages: ABAP/4, C, XML, and HTML.

Platforms: UNIX, Win 98/XP/2000/NT, DOS, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Northbrook IL

Sr. SAP Business Intelligence Consultant

Responsibilities:

  • As a SAP BW/BI Developer Lead the development of conceptual and architectural solution blueprint for Report Migration Project to meet business requirements while ensuring compliance wif established architectural principles, standards, and processes.
  • Analyzed the business requirements, did gap analysis and involved in all phases of design and development tasks of extracts and reports related to SD, MM, QM and FI/CO.
  • Involved in the SAP HANA discussions at Confidential identifying the requirements and the archival strategy to minimize the cost. Attended SAP workshops for BW migration to SAP HANA.
  • As a member of Agent Operations team at Confidential, worked on Report Migration Project delivering KPI’s such as Daily Fill Report, One touch report, Daily Forecast report and Market watch report using Dashboards (XCelsius).
  • Approximately 250 reports are being migrated to BO WEBI, Dashboards and Analysis for Office/OLAP Reports.
  • Modifying the existing Logistics and Parts queries according to client requirements.
  • Used ABAP for Field routines, End Routines, User Exits and Variables.
  • Developed 65 new BEX Queries and consolidated BEX Queries for use in BO WEBI and Explorer.
  • Used IDT to create connections and universes to the BEX Queries and HANA Calculation Views.
  • Created 70 WEBI reports and 15 Dashboards on top of BEX Queries and HANA Views.
  • Created Dashboards containing charts showing revenue and Brand Part sales by different Region, Dealer and Parts.
  • Developed Dynamic Dashboards(XCelsius) using HANA Views and worked on Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
  • In WEBI, used prompts, conditions / filters to improve the report generation. Also used rules / alerts to improve the readability of the report.
  • Extensively used variables, drilling features, cross tabs, breaks, sections, ranks, and alerts in the creation of reports.
  • Created multiple WEBI Charts using pie chart, bar chart, straight table, radar chart, and line chart.
  • Created Crystal Reports wif Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping and sub reports.
  • Created Advance Analysis reports over BW info cubes and HANA Calculation Views.
  • Migrated Web Intelligence Reports and Dashboards, Analysis for office/OLAP workbooks from one environment to other.
  • Created Analysis Process Designs (APD) wif BEX query as the source of APD.

Environment: SAP BW 7.3, SAP BO 4.1, WEBI, Explorer, Analysis for Office, SAP Lumira, SAP ECC 7.0, Enterprise Portal, Launchpad, ABAP.

Confidential, Chicago, IL

SAP BI Applications/Solution Developer

Responsibilities:

  • As SAP BI/BO Solution Developer worked wif functional users to gather the requirement for new reporting solutions and enhancements to the existing solution.
  • Hands on experience in cross-functional modules FI, SD, MM, COPA and AR.
  • Performed standard, application specific and generic extractions such as LO Cockpit, LIS, and FI/GL extractions.
  • Analyzed the requirements and identified the suitable business content for SD, FI, MM and installed the standard Infocubes, ODS's, Multi Providers and other relevant objects.
  • Worked on creating Indexes, Aggregates, Rollups, Compression, Reconstruction, Archiving, and Partitioning as part of Performance tuning activities.
  • Experience working on BIA Accelerator and creating BIA indexes and resolving issues encountered in BIA Accelerator enabling faster data retrieval by queries.
  • Extensively worked wif PSA and DTP’s in monitoring the Data Transfer from Source Systems into BW and resolving the data issues which reduced the loading time.
  • Used ABAP in transformations for Expert Routines, Master data Look up’s, DSO lookup’s to increase the data load performance resulting in faster data availability for Business users.
  • Experience in using ABAP for complex Start Routine, End Routine, Rule types and Formulas.
  • Strong knowledge In creating connections using Data Connection manager like Live Office, Query As A Web Service (QAAWS), Flash Variables,SAPBI connectors, UD connecters, DB connectors.
  • Involved in testing extractors, data loads and reports before transporting into production.
  • Involved inBW7.0 to 7.3 Post Upgrade activities, Validating the Datasources, Transformations, RFC.
  • Created test documents for the new developments and performed unit testing and worked wif the users for UAT.
  • Carried out transports from Development to Testing/QA and to Production.

Environment: SAP BW 7.3, HANA 1.0, SAP BO 4.0, SAP ECC 7.0, Enterprise Portal, Info view, ABAP, Tableau

Confidential, West palm Beach, FL

Sr. SAP BO Consultant

Responsibilities:

  • Involved in Requirement gathering, creating design documents, creating reports, providing live-support and created documentation.
  • Hands on experience in various cross-functional modules such as AP, AR, COPA, SCM, FI.
  • Created variousBWbackend objects which include real time cubes, Basic cubes, DSOs, Datasources, Infosources, Transformations, DTPs, Open hub spokes and Process chains.
  • Worked on Upgrade from BW 7.0 to BW 7.3 on HANA.
  • Expertise in Set up Tables Filling, running V3 jobs and extracting data to BW for LIS/LO Data Sources.
  • Extensively worked on Data Extraction Process using LIS, LO extraction cockpit and V-3 updates.
  • Activated Business Content Cubes for - Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
  • Developed DTPs and Infopackages and created various routines wif ABAP for the selections.
  • Extensively performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems and resolved data issues in the loading process.
  • Created 38 complex Bex queries on the Multiproviders for sales analytics.
  • Extensively worked on SAPBusiness Objects, Xcelsius, Crystal reports, WEBI, Analysis for OLAP.
  • Created universes using Information design tool(IDT) on top of Bex queries and HANA Views.
  • Used tables, charts and crosstabs of WEBI to develop sales by region and payment reports.
  • Created various transports, collected the required objects and migrated to the target systems.
  • Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance.
  • Used the issue log on the share point to communicate the status as well as issues to the team members and business owners.

Environment: SAP BW 7.3, SAP HANA 1.0, SAP BO 4.0, SAP ECC 7.0,FI, Crystal Reports, Web Intelligence, Xcelsius/Dashboards, IDT, Enterprise Portal, Info view, ABAP.

Confidential, Clearwater, FL

Sr. SAP BW Consultant

Responsibilities:

  • Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
  • Participated in design reviews, spec reviews, code reviews, test plan reviews.
  • Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
  • Activated the Business Content for FI-AP, FI-CO, FI-AR, SD, PP,MM& Purchasing Data sources.
  • Configured General Ledger Accounting (FI-G/L), New G/L, Accounts Payable (FI-AP), Accounts Receivable (FI-AR).
  • Designed and developed various Data targets and Infoproviders like DSO (ODS), Infocubes, Info objects, Multi-providers and Infosets using Admin workbench.
  • Populated various data targets like Infoobjects, ODS and Infocubes, wif Master data and Transactional data from ECC 6.0, legacy systems and flat file interface via Data Staging area (PSA).
  • Created Delivery and Shipment Due list variants to automate the Delivery and Shipment creation process.
  • Maintained extract structures for Purchasing, Inventory and Sales & Distribution (Sales, Delivery, Pricing, and Shipping).
  • Used LO-Cockpit extract structures (add extract structures) and data sources to extract data in SD and MM to facilitate the data to SAP BW.
  • Expertise in Customizing & Enhancing LIS/LO Standard SAP Extractors.
  • Extensively performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems.
  • Created Info Sources for uploading master data and hierarchies and also aggregates, Indexes for Info Cubes.
  • Used ABAP Routines in the Transformation to meet customer requirements.
  • Experience in writing ABAP for complex routines in Start Routine, End Routine, Rule types and Formulas.
  • Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DB stats etc.,
  • Experience in Performance Tuning by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes and also performed Data Archiving.
  • Worked on BW Accelerator to boost BW Performance and Query Performance through sophisticated in-memory data compression and horizontal and vertical data partitioning.
  • Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures.

Environment: SAPBW 7.0, BW 7.3, BWA, R/3, SAP ECC 7.0,Business Objects XI R/3 SP4, and Business Objects 4.0, Crystal Reports 2008, Dashboard / Performance Manager, Web Intelligence XI 3.1 Info view, CMC, universe designer, BI launch pad, Information Design Tool, ABAP.

Confidential, Auburn, IN

Sr. SAP BI/BO Consultant

Responsibilities:

  • Worked as BI/BO consultant and gatheird business requirements and deliverables for report generation along wif functional end users in the business areas and analyzed business content data sources for Enterprise Data warehouse.
  • Hands on experience in various cross functional modules such as: SD, MM, PP, FI-CO, PM and HR.
  • Enhanced the business content data sources by appending structures, User Exits and customized delta.
  • Worked on customization and enhanced the extract structure to support business needs.
  • Extensively worked on Modeling, Remodeling and maintenance of InfoCubes, DSOs (Standard, Write-optimized and Direct Input), Info Objects, Data Flow 3.x (Transfer rules, Update rules), Data Flow 7.0 (Transformations, DTP), Info packages, ExtractorsInfo Sources.
  • Created WEBI reports & Crystal reports and deployed them through Info View wif Universe as source.
  • Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
  • Expertise in creating Xcelsius Dynamic Dashboards usingSAPBI data/ BEx Queries and worked on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
  • Resolved day to daysecurityissues forSAPsystems.
  • Involved in tickets logging regarding extractions, Performance Issues and also load failures.
  • Coordinated and reviewedSecurity/User Admin/Compliance deliverables.
  • Involved in Quality testing, User Acceptance Testing and post-go live support.

Environment: SAP BI 7.0, ECC 6.0, Business Objects XI 3.4, Crystal Reports XIR 3, ABAP/4.

Confidential, Portland, OR

SAP BW - Business Objects Developer

Responsibilities:

  • Held discussions wif client's business personnel and process teams to decide on scope of the project and gather requirements to convert them into techno-functional specifications.
  • Worked wif BI team in implementing QM, HRand FI modules by installing relevant business content and creating custom objects where necessary.
  • Designed new data modeling solutions by creating Info Objects, Data Sources (ECC, FLATFILE), Data targets, Transformations, DTP’s and Info Packages to maintain both Transactional and master data in BI 7.0 environment.
  • Created and activated transfer structures, transfer rules, communication structures, update rules (both DSO and Info-cube level) and conversion techniques.
  • Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates.
  • Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
  • Created workbooks and web templates wif planning functions embedded in them for enabling planning of financial data by end users.
  • Created various aggregation levels, filters and data slices to enable data planning on various levels.
  • Designed and developed Crystal Reports, the Cross Tab Reports, Top N Reports for highlighting significant data, summary reports wif drill-down capabilities.
  • Created Dashboards/Scorecards using Business Objects Xcelcius.
  • Created Transport requests and transported the newly developed backend objects like Info providers, datasources, transformations; DTP’s and Query components across the transport layer.
  • Involved in resolving Transactional RFC Errors (TRFC), Time stamp errors, errors due to short dump, caller 70 issues, table space issues, Attribute change run errors - ALEREMOTE was locked.
  • Resolved issues like SAP R/3 extraction job failure, job cancellation in R/3 source system.

Environment: SAP BW 3.5 and 7.0 SAP R/3, ECC 6.0, Business objects XI R/ 3.1

Confidential, Atlanta, GA

SAP BI/BO DEVELOPER

Responsibilities:

  • Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
  • Extracted and uploaded data into Info Cubes from Data Sources like Actual Cost through delta extractionInternal Order through delta extraction Account Receivableand Account Payable forthe FI & CO modules from the Business content.
  • Responsible for design, development and extraction from ECC Source system and flat files toBW for FI & CO, SD.
  • Extensively worked on migrating Reports from 3.X to 7.0.
  • Worked extensively on Regression Testing during the upgrade from 3.X to SAP BW 7.x.
  • Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
  • Managed and monitored data loads wif full upload and delta mechanism.
  • Created Infoset for master data to enabling querying on data.
  • Created summarized reports which includes display of Plan/Actual variance measures, analysis of fullcost by cost center, overdue analysis, and analysis of payment history.
  • Developed and Tested Web Reports for drill down functionality including update rules and transferrules & verifying queries.
  • Extensively involved in the scheduling and monitoring using process chain in AdministrativeWorkbench.

Environment: SAP BW 3.5 and BW 7.0, R/3, FI, SD, BEX Analyzer, Query Designer, Web Application Designer, Business Objects XI R2.1, Designer, WEBI.