We provide IT Staff Augmentation Services!

Sap Bi Architect Resume

2.00/5 (Submit Your Rating)

ChicagO

SUMMARY

  • Have 15 years of IT Industry experience and 12 plus years in SAP BW/BI, BO, HANA and BPC Delivery, Consulting, Managing, and executing multiple projects.
  • Experienced in providing effective Implementation solutions, Support, Developing Prototypes, POC’s and Pilot Presentations.
  • Direct and manage project development from beginning to end
  • Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
  • Develop full scale project plans and associated communication documents
  • Ensure that project meets it’s deliverables in the agreed schedule, as per the scope, within stipulated budget and as per the quality standards
  • Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion
  • Liaise with project stakeholders regularly
  • Estimate the resources and participants needed to achieve project goals
  • Draft and submit budget proposals and recommend subsequent budget changes where necessary
  • Ensure project or service scope and deliverables are defined and agreed with by all the relevant parties
  • Ensure all project commitments are met and monitor and report the progress to Senior Project Manager, sponsor, client as well as the PMO in accordance with the reporting standards while ensuring that the project remains within scope
  • Diagnose and evaluate potential risks and issues throughout the project. Report regularly to the PMO and Senior Project Manager with regard to risks, and execute appropriate plans to contain them
  • Act as an escalation point for problems and complaints and manage compliance, contingency and risk situations within area of control
  • Monitor and manage resources (staff, suppliers and hardware and software) in a cost effective manner
  • Identify opportunities for cost reduction and action them
  • Responsible for managing the work of consultants, allocating and utilizing resources in an efficient manner and maintaining a co - operative, motivated and successful team.
  • Managing and leading the project team, deliverables in line with the project plan.
  • Managing co-ordination of the partners and working groups engaged in project work.
  • Detailed project planning and control including: Developing and maintaining a detailed project plan.
  • Experienced in handling Competency activities
  • Experience in Pre-Sales, Business Development and Delivery Management in the Current Organization
  • Excellent Technical/functional skills in BI
  • Experienced in Full life cycle implementations of Data warehouse (BI) projects
  • Experienced in handling Technical Upgrades
  • Hands-on support of BW including areas of Application Maintenance and Performance Tuning
  • Experience in working with various versions of SAP and BW the latest being ECC 6.0 and 7.1 respectively.
  • Has excellent communication and interpersonal skills with Problem solving abilities and effectiveness in working independently or as a team player.
  • Experience working at different geographical locations like UK and Kuwait.

TECHNICAL SKILLS

Data warehouse: SAP BW 3.0C, 3.1C, 3.5, SAP BI 7.0, 7.3. BODS and HANA

Language: C, C++, Java, SQL, PL/SQL, ABAP/4

ERP Packages: SAP ECC 5.0, ECC 6.0, R/3 4.6, R/3 4.7, SRM 7.0.

SAP Modules: SRM, SD, MM, FI/CO, HR, QM, PP, CRM, APO.

Reporting Tools: BEx Reporting, WAD, BI BO 4.0, Business Objects (XI), Crystal Reports Enterprise.

Databases: SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS Access

Operating Systems: Windows family, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SAP BI Architect

Responsibilities:

  • Working on a complex application that address client/business requirement.
  • Cost Cutting edge and performance is equals to HANA but column level storage is super faster than the existing BW existing database.
  • Mission-critical and complex applications that address unique business requirements and bring individualized process innovation to market
  • Identified standard Data Targets and changed the existing structure to Store Data in Column level.
  • Worked on HANA SLT and Analytical,
  • Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
  • Converted the Functional Specifications to Technical Specification on BO DS, BO Web I, Bex
  • Developed the Reports that includes Shopping Cart Analysis, Procurement Detailed Report, Price variance Monitoring, Supplier Receiving Analysis, AP Ageing Report and Goods Received vs Invoiced

Environment: SAP R/3 All Modules, BW/BI, HANA, BO and SQL Server

Confidential, Edison, NJ

SAP BI Consultant

Responsibilities:

  • Contract to Cash (CTC)
  • Finance to Manage (FTM)
  • Procure to Pay (PTP)
  • Project Systems (PS)
  • Utilize standard functionality Business Content of the systems
  • Build a global platform enabled through SAP BI functionality
  • Legacy system database source and fields identify with SAP Data Source
  • Functional Specification for CTC, FTM, PTP and PS
  • Developed Business Process Flows to guide end-users through pre-defined sequential tasks that span across the different departments within the organization.
  • Created Dimension, Models, Hierarchy and security objects
  • Created Application Sets HEMAS for process Fixed Forecast Planning, Budgeting, Rolling Forecast, IFRS and Consolidation
  • Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
  • Developed custom Process chains to support master data and transaction data loads from BI to BPC.
  • Created Package links to bundle more than one packages and to run sequentially.
  • Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.
  • Worked on setting up Security and Audit settings to ensure user entitlements and access rights.
  • Worked exclusively on Work Status and integrating the Work States with Business Process Flows.
  • Configured drill-through functionality in Reports to see the underlying data from external databases.
  • Involved in SAP BPC implementation, configuration, and upgrade and environment management.
  • Maintained Document Types and Sub Types from Web Admin Tasks Action pane.
  • Cost Cutting edge and performance is equals to HANA but column level storage is super faster than the existing BW existing database.
  • Gather requirements and design infocubes, ODS Objects and Multi cubes.
  • Design Process Chains for daily extraction of data and maintenance for day-to-day schedule.
  • Involved in master data loading and transaction loading.
  • Design and develop master data for further analysis
  • Mapping data from source to target, create transformation,PSA and DTP
  • Export data to SAP R/3 to publish the reports for Bex Query design.
  • Map loads and integration with SAP ERP data.
  • BI error analysis and skills to debug.
  • Worked with SAP BW components including BW Administrator Workbench
  • Data extraction from flat files, DataSource, InfoObjects, DTP, PSA, InfoProvider, Multi Providers and Process chains.
  • Performed Business data modeling and analysis and have thorough understanding of relational data structures, Extended Star Schema and OLAP concepts.

Environment: SAP R/3 All Modules, HANA and BPC

Confidential, California

SAP BI Architect

Responsibilities:

  • Freeze the requirement on CR’s and New Project Developments.
  • Developed various reports on Demand Planning and Supply Network
  • Have ability to work with cross-functional teams and individuals at various levels in global delivery model.
  • Leverage client satisfaction and client relationship to grow existing account
  • Monthly Manual Process Chain automated by creating BADI and Master Data Object
  • Develop and deliver performance plans and development plan.
  • Worked on APD, Open Hub and BEx Exits

Environment: SAP R/3 All Modules, APO and BO

Confidential, Atlanta

SAP BI Sr. Consultant

Responsibilities:

  • Cutover country releases for Global reporting templates design.
  • Estimation of Change requests and completing changes as per requirements.
  • Worked on WAD and BEx reporting.
  • Attending Weekly calls and updating the status on the tickets.
  • User support tickets handling and resolving tickets before SLA breach.
  • Analysis of issue related to reports in BW and doing changes as per requirement of client.

Environment: SAP R/3 All Modules, CRM and BO

Confidential

SAP BI Sr. Consultant

Responsibilities:

  • Lead a team of 15 BI/BW Consultants which involves:
  • Assigning tickets (with help of Service Now) to BW Consultants.
  • Monitoring of existing work load.
  • Handling complex Changes and critical issues.
  • Providing checks to improve SLAs etc.
  • Presentations to clients to create more business.
  • Maintaining Known error data base to reduce known errors.
  • As part CR’s created Universe on BEx and Cube and Developed Web I reports.
  • Worked on APD to extract Sales forecast data for Inventory Analysis.
  • Performance tuning for various report using Multiprovider partitioning.
  • Worked on Snapshot scenario for Inventory Module.
  • Automation of various processes like Unit replication from R/3, Process chain email alerts, alert through information broadcasting etc.
  • Involved in Client issues and escalations

Environment: SAP R/3 All Modules, BODS and BO

Confidential

Lead Consultant

Responsibilities:

  • Estimation of Change requests (CHR) and doing changes as per requirement.
  • Attending Weekly calls and updating the status on the tickets.
  • Governance call with other Service Provider (wipro), on CHR deliverables on support.
  • Resolution of issues by client related to the developed objects and make necessary changes to fix the bug if any.
  • Analysis of issue related to reports in BW and doing changes as per requirement of client.
  • Various tickets handled, issues raised by users.
  • Technical work on tickets are in Modeling changes in Multiprovider by identifying

Environment: SAP R/3 All Modules and CRM

Confidential

Sr. Consultant

Responsibilities:

  • SAP BI Implementation Approach
  • Decided the landscape for SAP BI with Legacy Systems
  • Resource and Time Estimation
  • Business Blue Print on Requirement Gathering Template.
  • Functional Requirement Gathering Templates.

Environment: SAP R/3 All Modules

Confidential

Manager - Upgradation

Responsibilities:

  • Proposal, Project Plan and Time Estimation.
  • New Source system to Sand box connectivity.
  • Setup table for LO modules and Initialization in BI.
  • Gap analysis between existing and future versions
  • Find out the existing roles (Mainly in Prod) and analyze the impact of new security roles
  • Communicate to Business and User Group the impact of new security regime
  • Clean Change Log
  • Delete PSA data
  • PSA Inconsistency Directory Clean up
  • SAP NW BI: Checking Inconsistent InfoObjects
  • Check DB statistics are up to date
  • Validity of BW object
  • All ODS data loads must be activated
  • All Transfer and Update rules should be active
  • All InfoCubes should be active
  • Multiproviders with Compounding issue or inconsistent compounding
  • Test plan for authorization relevant security (Pick up main roles)
  • Find out the authorization required to do PDF Output Creation
  • Investigate usage of auth object BI All authorization

Environment: SAP R/3 All Module

We'd love your feedback!