Business Explorer Analyzer Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Top Notch SAP BI BOBJ Lead Architect with more than eight successful end to end BW Implementations
- Ability to learn and adapt new & varied business processes in various verticals has been a key factor for my knowledge
- Complete and thorough understanding of Pharma, Consumer Products, Retail, Utilities and Manufacturing domains
- Results - focused and effective consultant with proven ability to successfully work in large-scale implementations covering a wide range of industries
- Self-starter with ability to multitasking, exceptional organizational and management skills.
- Proven Successful in environments with minimal teams with efficient usage of knowledge transfer and team building skills
- More than Decade of SAP experience Decade in SAP BI BOBJ, Net weaver BW 7.0, BPC, BI - IP, SEM, Enterprise Portal, SD, MM, Finance, CRM, HR, APO, and 1+ year in ABAP
TECHNICAL SKILLS
- SAP BI BOBJ / Net weaver BW 7.0,
- SAP R/3 4.0B /4.5B/ 4.6B/ 4.6C/Enterprise 2005 / ECC 5.0, ECC 6.0
- SAP BW 2.0b/2.1C/3.0A/3.0B/3.1C /3.5 & MDM/ BI 7.0 (Net weaver 2004s)
- SAP SEM-BW 3.5, IP
- SAP Finance, SD, MM, PM, HR, PP, EHS
- SAP CRM Analytics
- SAP APO-BW
- SAP Web Portal EP 5.0/EP 6.0
- SAP XPD, XRPM, Cprojects
- SAP SRM - BW
- Worked on multiple implementation of BI 7.0, Net weaver BW 7.0
- Designed & Implemented New Data Models based on Multiproviders, DSO, DTP, Transformations and developed multiple custom extractors to meet the needs of customer
- Enhanced the Load Performance using the Selective DTP’s
- Successfully implemented usage of Master Data Modeling which would improve TCO
- Improved the Reporting performance by proper Data Modeling
- Automated the Data Load status tracking management using process chains with Display of proper information to user as a Dash board / Yahoo Widget
- Used SAP Bex Broadcast service & APD for various Customer requirements
- Execute and control process chains from SAP Business Objects Data Services to extract data via Open Hub Service
- SAP Business Objects Data Services to schedule loading processes of SAP Net Weaver BW
- Worked on developing and implementing the proof of concept with BPC to comply with IFRS requirements last year Oct 2010
- Good knowledge of the SAP End to End Processes, issues, Best Practices with Net weaver BW 7.0
- Good knowledge SAP Functional Module Finance, SD, MM, CRM & Config
- Thorough Hands on Knowledge of all SAP BI Development & Coding
PROFESSIONAL EXPERIENCE
Confidential
Business Explorer Analyzer, Query Designer and Web Application Designer
Responsibilities:
- Created Web templates
- Published Queries to Web Application Designer
- Customized the HTML as per the requirements
- Used various options to improve look and feel of all the iviews
- Created roles and assigning
- Designed Formulas, user exits, virtual characteristics, structures
- Created specific info sets to automate the exception alert processing on Master data.
- Enhanced the visibility and the ease of the navigation by adding scroll functions, buttons, and lists etc., as per the specific requirements.
- Extensively used the various different formats of graphs and charts to meet the needs of end user
- Created Multiple Customer exits to get information specific to reports
- Created restricted and calculated key figures and used them optimally to improve the performance of the reports
- Integrated scheduling of canned and precalculated Web templates with the load sequences using process chains
- Improved the performance of the reports using aggregates and Query caching, Book marking techinques
- Extensively used RRI
- Integration of the SAP BW with the Third party OLAP tools like Brio, Cognos, Business Objects
- Exported data into other formats
- Drag and relate functionality using content Server (portal)
- Extensively worked on ABAP/4 Reporting for MM and SD Modules across Various implementations
- Worked Extensively on CATT for testing
- Good Exposure on IDOC, ALE, and EDI Technologies
- Worked on BAPI’s
- Created and Scheduled Multiple Jobs, Process Chains, and BDC’s
- Created Custom User Exits
Confidential
SAP BW 7.0 Remodel Architect, SAP BI Upgrade Lead
Responsibilities:
- Confidential is the largest Fortune 500 Company headquartered in San Diego. San Diego Gas & Electric and Southern California Gas Co., together serve the largest customer base of any energy utility in the United States. Our other businesses operating under the Sempra Global umbrella build and operate infrastructure, sell energy commodities and provide asset risk management.
- Confidential has huge & varied groups of internal customers, Internal BI Production Support team which had to meet changing needs of these customers while supporting day to day activities.
- My first Job at SEMPRA SAP BI Best Practice Liaison started by working with Customers from various teams some of which include Finance, CRM, DBE, Safety, Supply Management to understand & document their reporting requirements while working with them hands on explaining them what is already available in the existing system .
- Thorough & systematic study was conducted on the existing data models for any short falls and impact on them due to BI 7.0 Technical upgrade.
- New set of development standards and guidelines for BI Developers and Users were documented & implemented
- Conducted several meetings with Power users to help them better understand features of BI which can avoid the additional IT requests and also help them better organize their new requirements for future enhancement with the help of user friendly documentation of BI/ BW Data Model .
- As part of same development I have helped BI production support team to come to speed with the latest and greatest features of BI 7.0 and Worked on some of their pending development issues.
- Help the users to come up with easy training material which can aid them personal turnover
- My Second Job was almost transition from the First Job with Safety department which was in process of Implementing BOBJ solution as Pilot Project
- Existing Data Model Documentation revealed some incompatibilities with BOBJ requirements along with Future enhancements requested by safety.
- Based on their requirements new DSO’s and Multiproviders, Hierarchies were accommodated into existing data model and lot of development has been done to modify the existing master data lookup and cleansing issues.
- Later on worked with BOBJ resources to help them work on query & universe design and also helped with few frontend issues and resolving the some issues linked with Share point, SNC, Xcelsius issues.
- Worked with CRM Team explaining them the issues with the existing Data Model and have been able to come up with the new Remodeling Project which is going to help manage their TCO on long term.
- Later on Moved to third role of Upgrade Lead taking over the BI frontend upgrade project
- Developed Project Plan for Rollout and worked with various teams to coordinate the effort
- Worked on developing testing strategy and worked with the various team to complete the testing effort
- Worked on developing training documentation and conducted various training and helped internal team with the change management
- Worked with various operational support teams to test the BI front rollout
Confidential
BI Project Manager & Lead
Responsibilities:
- Smilesys Confidential team which has been part of company’s visionary pilot goal started working on gathering issues from various different industries since a decade and has evolved with changing needs of customer and time.
- As a part of this initiative team of our in-house experts along with some industry leaders and key people from various reputed firms as part of advisory council has identified few key solutions for development.
- As member of key team we have successfully budgeted and completed blue printing two of the key solutions which are currently on their way for steering committee’s approval to be developed as solutions.
- Secondly we have been helping our sister concern Sumukha Group of Export and Imports on developing SAP BI reports in are of wholesale.
- Worked on Designing the Solutions for Ready to Use BI Bobj Reporting & Integration Solutions which can save customers significant amount of money & time.
Confidential
BI Techno Functional Architect & Project Manager
Responsibilities:
- HD Supply FM was part of Home Depot Wholesale when I have started in Dec 2006 and they have acquired another big wholesale company Hughes based in Orlando so project unite was considered to roadmap of getting the wholesale units streamlined using the rollout approach with Home Depot retail (Atlanta) but due to some key changes in strategy and management this did change as it got sold to private owners got to be known as
- HD Supply.
- BI Project unite team has so far been able to successfully complete FI AP, FI AR, FI GL, Asset Management part of planning and completed successfully blueprinting and documenting the requirements for MM, IM, WM, SD and CRM reporting requirements from various departments.
- One of the Major accomplishments of this implementation is easy rollout by already accommodating the required data elements for any future mergers and acquisitions in the financial model. Which helps them produce one Companywide P&L and Balance sheet at the same time also allows them to drill down cost element level based on the FM or Orlando etc.Accounts Payable Reports in BI are designed to help the processor to be able to see their own workload of parked documents but also help them clear discounted inventory vendors based on discounted due date instead of the regular due dates which has been created significant savings.
- Accounts receivable currently uses BI reports for sending out the statements automatically based on the credit limits of customers and also they use various custom developed aging, DSO reports to meet their requirements.
- BI has built a snapshot for tracking their Aging and Net Acct Bal every week. This department just like AP extensively uses RRI to ECC and to track transaction on invoices, statements, Write off and Adjustments.
- Another Significant accomplishment of BI during this implementation has been legacy data selection, migration cleanup and conversion from various systems some of which include Cognos, Oracle and bunch Access data bases and Oracle Data warehouse DBW.
- Worked on Prototype of implementing IP for Financial Planning (Asset Planning, Internal Order planning) and helped on preparing training materials for the first phase on end user and power user training.
- Conducted several training sessions for end user and power user communities in classroom and one on one.
- Conducted multiple initial meeting with different business teams
- Worked on developing SAP BI/BW Naming standards & Documentation standards
- Worked with SAP Basis team in SAP Landscape setup and sizing
- Worked on setting up templates for FDS and TDS with BI Manager
- Worked on Gathering requirements and consolidation of reports from various teams
- Worked on multiple POC’s with the existing data from Oracle data warehouse and Microsoft Access to build customer confidence and explain advantages of new platform
- Worked with HD’s SAP Management team to consolidate the definitions Key Business Metrics
- Worked on consolidated Design of SAP BI Design for Finance AP, GL and Asset Management Modules
- Worked on Financial GL reporting model which can sustain the Mergers and acquisitions without down time
- Worked on Implementation of model
- Worked with Finance teams for Data Conversions from legacy COGNOS systems
- Worked with testing team and functional teams on setting up test scripts
- Worked with SAP BI Lead on conducting training and developing training material
- Worked on developing, training and maintenance of Master data hierarchy for financial P&L and Balance sheet.
- Worked on enhancing the extractor to bring the opening balances due to the partial conversion
- Worked on development of go live strategy and plan
- Helped on setting up support team for post go live and maintenance activities
- Worked on meeting with new phase of financial implementation for AR
- Worked on modeling solutions in a innovative way to be able to support short and long term objectives of reporting