We provide IT Staff Augmentation Services!

Bobj Report And Tableau Developer Resume

Washington, DC

SUMMARY:

  • Over 10 years of professional IT experience with 8+ years of SAP BW experience in planning, analyzing, designing, developing and implementing the state - of the-art Business Intelligence (BI) and custom distributed applications.
  • Involved in end-to-end implementations of SAP BI projects from requirement gathering, solution design, architecture and customization and project experience spans across Manufacturing, Pharmaceutical, Retail and Government sectors
  • Extensive knowledge of SAP BI 7.0 integration with BusinessObjects Enterprise XI 3.1 and BO OLAP Analysis tools - Web Intelligence, Tableau, Xcelsius 2008 (Dashboard), Live Office, Universe Designer, InfoView.
  • Expertise in designing and building OLAP Universes on Netweaver BI
  • Expertise in creating Web Intelligence Reports on Multiple Data Providers.
  • Expertise in creation of interactive Xcelsius 2008 dashboards defining KPIs.
  • SAP BI Reporting - BEx Analyzer, Query Designer (Cell Definitions, Constant selections, Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures), Report Designer, Web Application Designer.
  • Experience in BEx Analyzer 3.5/7.0, Web Application Designer (WAD) 3.5/7.0, Report Designer 7.0, Broadcasters, workbooks
  • Experience in enhancing the Performance/Tuning of BI Solutions.
  • Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated. Exceptional ability to quickly master new concepts and applications.
  • Experience in conducting Training for End-users and Project Team Members.
  • Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated fast learner and good listener.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

BOBJ Report and Tableau Developer

Responsibilities:

  • Working as Business Analyst/BOBJ Report developer/Tableau Dashboard developer/UAT for Director of Operations
  • Interact with the stakeholders to gather requirements and create business objects reports/dashboards
  • Designed, developed, tested and delivered the Confidential Reports for Operations using Business Objects Web Intelligence tool
  • Created Tableau Dashboards, POCS, by extracting the web intelligence reports in Excel and connecting to Tableau
  • Created UAT test scripts for stake holders
  • Created QC tickets in HP quality center and worked with IT team to resolve the issues.

Confidential, Fairfax, VA

SAP BI Business Analyst

Responsibilities:

  • Working with the BOBJ AO project management team to design, develop, test and deliver the Analysis for office workbooks for EMRE (Research and Development team)
  • Also working with training advisors to create AO training materials for business users
  • Worked for Finance (BCoE), EMRE teams, gathered reporting requirements, did the gap analysis, interacted with IT team, provided solutions
  • Converted queries/workbooks from 3x to 7x BEx Analyzer and later to Analysis for office (BOBJ AO) and created training materials and provided training to end users
  • Modified existing 7.0 BEx reports and fine-tuned them for high performance for business tableau dashboards.
  • Modified existing dashboard graphs to use the BEx workbooks data
  • Developed, Designed and supported interactive Tableau Dashboard reports
  • Worked with IT team to resolve production issues during month end close
  • Responsible for the Production Support, on-call support for escalated problems
  • Developed Xcelsius interactive dashboards that enable end users to envision the equity goal by adjusting data using sliders, create different business scenarios
  • Used swtich circuit design to enable components turn on and off dynamically, used sliders for end users to adjust data (envision goals) and created comparison drop downs to differentiate the actual and envision goals data.
  • Used dynamic visibility feature to show/hide components at run time
  • Followed best practices to organize the data
  • Worked very closely with IT/Basis team related to SAP BI production issues. Also created SAP Notes and worked with SAP/IT/Basis team for the issues related to BEx 7x Analyzer

Environment: SAP BI 7.0, BEx Analyzer 7.0, business objects AO, universe designer, web intelligence, Infoview, Xcelsius 2008, and Tableau

Confidential, Ridgefield, CT

SAP BI Consultant

Responsibilities:

  • Designed and developed Business Objects XI 3.1 finance executive reports to using Web intelligence, infoview
  • Restructured existing BI/Webbi reports and modified universe connections to meet the requirements and optimize performance
  • Developed Xcelsius dashboards for US region using Business Objects Engage.
  • Developed new universe connections using Universe designer for SAP Reports
  • Modified existing 7.0 BEx reports and fine tuned them for high performance for these finance dashboards.
  • Created new structures/reports on 7.0 BEx to enhance performance for business objects dashboards
  • Shared best practices for universe designs and WebI tool
  • Participated in End-User Training in developing Ad-Hoc reports as part of Knowledge transfer.
  • Also worked on Financial Accounting, Purchasing and Purchase to Pay projects, modifying the reporting of Project Systems Cost Control, Purchase-to-Pay, and Fixed asset master data.
  • For Cost Control Report Enhancements, modified Purchasing line Item extraction (2LIS 02 ITM) and loaded data from R/3 and reloaded impacting datamarts. Modified existing PO detail report to reflect these changes
  • For Financial Accounting project, added new custom fields from SAP R/3 fixed asset master records into the existing BW Fixed Assets area, loaded data and modified existing report to include these attributes and tested the results.
  • For purchase-to-pay reporting enhancement, fixed invoice amount issues in purchase order cube, corrected issues in vendor master extractor and enabled additional vendor master standard content (vendor by purchasing group) and created additional queries to meet user demands
  • Created reports for General Ledger Accounting and scheduled broadcasters via process chains

Environment: SAP BI 7.0, BEx Analyzer 7.0, business objects XI 3.1, universe designer, web intelligence rich client, Infoview, Xcelsius 2008

Confidential, Portland, OR

SAP BI Consultant

Responsibilities:

  • Worked as BSA on Coverage and DIFOT (Delivered in full on time) projects that included KPIs to Confidential ’s Demand/Supply match for future months
  • Responsible for gathering efforts with the SAP functional team and business users, developing queries and reports on 7.0, workbooks, web templates, pre-calculated web templates, broadcasters, reporting agents, process chains, etc
  • Worked as backend developer to support time frame and created infocubes, aggregates, process chains and scheduled data loads
  • Fine tuned reports, enhanced report/template performance. Worked on RSRT, RSRV, Query Statistics, Aggregates, Variants and analyzed cell definitions, structures to enhance performance
  • Suggested alternatives for problems, issues, and roadblocks
  • Worked with Portal team to create iViews for the web applications
  • Created broadcasters for web templates/workbooks and scheduled and delivered them for global end users via process chains. Created dash boards using 3.x WAD and customized templates using JavaScript, HTML
  • Responsible for the Production Support, documentation and knowledge transfer, on-call support for escalated problems
  • For content Engineering Team, worked with Apparel Raw Material Planning and Staging (AMPS) System and the Demand Plan Sales Order (DPSO) System teams, developing queries using BI 7.0 BEx Analyzer and report designer and created web templates using WAD 7.0.
  • Worked with finance team to create AP, AR, GL reports
  • Experience with performance tuning analysis including indexes, aggregates, statistics, query design review, etc
  • Experienced resolving critical issues/production support across various functional teams, Researching / evaluating SAP OSS notes. Working closely with system administration resources to manage the BI environment
  • Worked with architecture team for decision making processes
  • Worked on 2004s BI statistics Cubes and queries and knowledge transfer to Business End Users
  • BSA for Confidential .NET, a non sap team, helping them retrieve data from BW using MDX queries and resolved issues related to it.
  • Documentation and knowledge transfer to team members
  • Experience in migrating BEx Reports from 3.5 to 7.0 and redesigning web templates from 3.5 to 7.0

Environment: SAP BI 7.0, 2004s SP 13, BW 3.5, Enterprise Portal 6.0, WAD, BEx, JavaScript, HTML

Confidential, Hermitage, TN

SAP BW/BEx Consultant

Responsibilities:

  • Interacted with functional team, development team and end users of Finance department to study their business process.
  • Designed and built BEx Analyzer finance reports using variables, structures, conditions, exceptions, filters and aggregates for performance tuning of queries
  • Customized web templates in Web Application Designer to add Tab Strips, Radio Buttons using JavaScript, HTML.
  • Interacted with R/3 team for creating test cases. Interacted with offshore QA team for testing data in reports.

Environment: SAP R/3 4.7, BW 3.5, Enterprise Portal 6.0, (WAD), and Business Explorer, JavaScript, HTML

Confidential, CA

SAP BW Consultant

Responsibilities:

  • Interacted with functional team, development team and end users of Finance, Order to Cash, and Procure to Pay departments, to study their business process.
  • Designed and built BEx Analyzer finance reports using variables, structures, conditions, exceptions, filters and aggregates for performance tuning of queries
  • Created and modified standard web templates using web application designer and saved web templates to the portal as iViews and iView files.
  • Created Users and Roles under User Administration in Enterprise Portal. Created worksets, pages, iViews under content administration in Portal.
  • Provided pilot training to finance functional team and performed unit testing
  • Created training materials with topics including using BEx web and analyzer reports and their data analysis tools such as OLAP functions, filters, variables, how to create reports using structures etc
  • Created help documents, work instructions for web templates, web items, iViews etc

Environment: SAP R/3 4.7, BW 3.5, Enterprise Portal 6.0, WAD, and Business Explorer.

Confidential, CA

SAP BW Consultant

Responsibilities:

  • Created Process Chains to automate the loading process for master data (attributes, texts, hierarchies) and transactional data (Initial and Delta loads).
  • Coordinated the BW transport collection using the BW Transport connection on BW side. Managed the transports between Dev, QAS and PRD systems. Validated the transported objects upon transport.
  • Coordinated with Users on the BEX queries, maintained Jump targets, variables; assigned workbooks to roles, Configured Bex Browser.
  • Validated the BW design/data model, development, and data at every stage.
  • Prepared necessary documentation on Blue Print, Data Model, Technical design and specifications, Data validation, Testing Procedures, Sizing, Data load procedures, Cutover Plan etc.

Environment: SAP R/3 4.6c, SAP BW 3.0, Oracle 9.2, AIX, WIN NT, WAD, and BEX Analyzer

Confidential

BW Technical Consultant

Responsibilities:

  • Analysis of data requirements and 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 BW.
  • Extracted data from SD and MM modules of SAP R/3 and from flat files (Originating from Visual Basic/Lotus Notes) into SAP BW system using data sources created through Generic extraction, CO-PA, FI-SL and LO data extraction techniques.
  • Created InfoObjects, DataSources, InfoSources, Data targets, InfoPackages and InfoCubes to load Master and Transactional data from SAP R/3 system and flat files into BW system.
  • Installed and extended standard Business Content based on client requirements for enhancing dataSources for transaction data, master data and texts.
  • Created, maintained and modified existing queries on different InfoCubes related to SD, MM and FI/CO modules. Extensively worked on Query building, filtering data, Structures, Variables and conditions
  • Worked on exceptions to alert users based Sales Orders schedule dates and to alert users when production work centers efficiency is decreasing month-to-month. Also created reporting agents for background printing of huge reports.
  • Created and maintained Aggregates and Hierarchies that are time dependent and time independent.
  • Developed modeling and naming standards, created modeling guidelines, developed power-user-training materials and trained power-users on utilizing, developing, and administering BW queries.

Environment: SAP R/3 4.6c, ABAP/4 programming, SAP BW 3.0, BEX Analyzer, Lotus Notes Domino 5.0

Confidential, NY

Database Developer

Responsibilities:

  • Responsible for creating and maintaining the Lotus Notes databases for clients and for the internal applications using Forms, Views, Pages and Navigators.
  • Web master - Developed and maintained website Confidential .
  • Designed clients' facilities and sample locations in AutoCAD 2002 LT.
  • Designed and developed flash user-interface homepages for clients' websites.
  • System/Network Administrator - Setting up network computers, printers and fax machines. Setting up and troubleshooting new laptops and computers for integreyted employees.
  • Designed and developed a Web-based bar chart reports using Flash 5.0. Integrated Flash with Lotus noted to develop these reports on web.

Environment: Lotus Domino R5, AutoCAD LT 2002, Flash 5.0, JavaScript, HTML

Hire Now