We provide IT Staff Augmentation Services!

Business Warehousing Lead Architect Resume

0/5 (Submit Your Rating)

SUMMARY

  • An innovative, performance driven IT professional with overall 8+ years of experience specializing in SAP tools which includes more than 7 years in BI/BW, 3 years in Business Objects (BO), more than 4 years in SAP R/3,ABAP/4.
  • Experience in Project management and worked extensively on full life cycle implementation including requirement analysis, prototyping, design, implementation, testing and maintenance.
  • Extensive experience in understanding business/ process requirements and translating them to technical requirements.
  • Multiple full life cycle SAP BI implementations from source system extractor to report delivery for FI(AP,AR,GL), COPA, MM, SD, PP Modules.
  • Design & development of custom/generic extractors in R/3 ECC 6.0 using different delta mechanisms.
  • Extensively worked on Info Cubes, ODS Objects, Info sources, Info objects, Transformations, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains.
  • Strong in designing and building reports using Business Explorer and Web Application Designer.
  • Well expertise inSAP ABAP technical areas includes design, development and debugging ofABAP Programs, Reports(Classical, Interactive Reports & ALV Reports),ABAP Objects, Dialog Programming, Forms, ABAP Query, OSS Notes & upgrade activities.
  • Involved in migration process from BW 3.5 to BI 7.0
  • Comprehensive knowledge of business data modeling, configuration & customization in SAP BI
  • Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
  • Experience to recommend and implement SAP BI solutions
  • Integrating SAP BI to SAP Business Objects to build BO Universes on BEx Queries and configuration of BO Mobile application.
  • Design interactive dashboards using Business Objects XI 3.1/4.0 tools like Web Intelligence, Live Office, XCelsius 2008,Dashboard designer 4.0
  • Experience in migrating business object reports and universes from Business Objects XI 3.1 to 4.0
  • Building custom BO mobile dashboard applications for access from Blackberry & IPAD.
  • Conducted training for end - users. Developed business process documentation

TECHNICAL SKILLS

  • SAP BW 7.0/3.5
  • SAP R/3 4.6C/ECC
  • FI/CO
  • SD
  • MM
  • PP
  • Business Explorer (BEx)
  • ABAP/4
  • Business Objects XI 3.1/4.0
  • Universe Designer
  • IDT
  • Web Intelligence
  • Live Office
  • XCelsius 2008
  • Dashboard designer
  • BO Mobile.

PROFESSIONAL EXPERIENCE

Confidential

Business Warehousing Lead Architect

Responsibilities:

  • Gathered Business Requirements from client to design reports for Sales Variation Analysis, Purchases Variation Analysis, Production Variation Analysis & material resource planning KPI’s.
  • Designed the full life cycle implementation flow from source extractor(ECC 6.0) to report delivery in BW.
  • Lead the team to develop custom Datasource, Info Source, Extractor, Info Cube and ODS to fulfill user requirements.
  • Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
  • Maintained reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
  • Designed Bex reports using restricted/calculated key figures, RRI, conditions and exceptions.
  • Work allocation among the team & monitoring progress at each milestone.
  • Conducted training for users and developed business process documentation.
  • Monitoring the team in production support activities.
  • Received great appreciation from the client for quality of work and timely delivery of the requirements.
  • Project: Migration from Business Objects XI 3.1 to 4.0

Confidential

Business Objects Architect & Lead Developer

Responsibilities:

  • Coordinated an Off-Shore team for migration from Business Objects XI 3.1 to 4.0
  • Mapping of reporting requirements from business terms into SAP objects.
  • Guided and played key role in creation and maintenance of OLAP universes sourced from BEx queries.
  • Led report development effort, including creation of many Web Intelligence reports & dashboards using dashboard designer.
  • Provided the security access management by creating users/groups and folders.
  • Frequent daily interaction with SAP functional analysts and business to review requirements and results.
  • Project: Integration with Business Objects Mobile

Confidential

Business Objects Technical Lead

Responsibilities:

  • Installation and configuration of Business Objects Mobile on the BO XI3 server.
  • Configuring Business Objects Mobile client application.
  • Configuring the device with necessary parameters to access Business Objects Enterprise Server
  • Customizing parameters in Business Objects Mobile to access local and server documents.
  • Designing custom BO mobile dashboards for access from Blackberry device
  • Project: Management KPI Dashboards

Confidential

Business Warehousing Technical Lead

Responsibilities:

  • Worked with business managers, architects & end users in documenting requirements to build user friendly interactive dashboards using Business Objects X3.1 tools with data from SAP BW Info Cube & Bex query.
  • Responsible for creating the universeson Bex Query and maintaining them in the repository.
  • Worked extensively onDesigner,Web Intelligence (webi),Desktop Intelligence (Deski),Crystal reports andCentral Management Console (CMC).
  • DevelopedComplex Reports(Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
  • Developed interactive dashboards usingBusiness Objects Xcelsius 2008
  • Extensively usedCalculations,Break points, Drill down,Slice and Dice, FunctionsandFormulas,Filters & Alertsfor creating Complex reports.
  • PublishedBusiness Objects dashboards on SharePoint Portaland provided access to the end users.
  • Project: Key Performance Indicator(KPI) Reporting

Confidential

Sr Business Warehousing developer

Responsibilities:

  • Gathered business requirements from client to build reports to analyze key performance indicators like
  • Slow Moving materials
  • ABC Analysis based on material forecast/consumption
  • Customer Demand
  • Production Service Level
  • Inventory Stock Adjustments
  • Production Planning
  • Designed the complete workflow of data extraction using custom datasources, ETL process and reporting using Bex and WAD
  • Work allocation among the team & monitoring progress at each milestone.
  • Initial data load and implementation of daily update process chains
  • Implement authorizations for the end-users
  • Provided end-users training plus Go-live & post production support
  • Project: BW Server Configuration & Implementation

Confidential

Design Analyst & Technical Lead

Responsibilities:

  • Worked on BW initial server setup settings to connect 6 R/3 source systems to BW.
  • Created communication users and remote function call destinations on BW and R/3 servers.
  • Configured source systems, replicating standard datasources, transferred application component hierarchy, created source system ID’s etc,
  • Installing and activating Business content objects According to the Requirement.
  • Implemented master data extraction standard dataflow for MM, COPA, SD, PP modules.
  • Involved in creation of Data Sources and InfoSources, for Data extraction, transformation and loading for transaction data from SAP R/3 system & Flat File to SAP BI.
  • Activated from Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc.
  • Created and Developed BW Queries Using BEx Analyzer and BEx Report Designer.
  • Worked on enhancements of the Extract structures using user exits.
  • Worked on Creation of Process chains.
  • Scheduling and monitoring of Data loads.
  • Testing the reports with data and Rectified the issues occurred
  • Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression
  • Project: SAP R/3 4.6B Technical Maintenance North America & SAP Upgrade 4.6B to ECC 6.0

Confidential

Onsite Coordinator & Technical Analyst

Responsibilities:

  • Enhancements and modifications of variousSAPstandard applications through User Exits, BADIs and Enhancement Points.
  • Creating and modifyingSAPScript and Smart Forms.
  • Worked extensively on data dictionary objects such as Tables, Structures, Views, Data Elements, Domains, search Helps etc.
  • Developed user manuals and detailed knowledge transfer documents for Post Implementation Support.
  • Created number of custom reports, function modules & BDC programs.
  • Developed programs using Mobysis software compatible with Barcode Scanners used in the warehouse to perform activities like warehouse movements, inventory adjustments, shipments etc,
  • Responsible for all technical activities involved in the upgrade project.
  • Worked on compatibility checks for the custom reports, function modules, forms, and dictionary objects existing in current system.
  • Involved in the adjustments of customer specific applications, interfaces and forms.
  • Identification of all BDC programs in each module affected by the upgrade and make required adjustments.
  • Necessary modifications to user exits to make them compatible with the new sap release.
  • Provided post upgrade support.
  • Designed custom barcodes using Barone Software.
  • Project: SAP R/3 4.6C Technical Maintenance Europe

Confidential

Programmer

Responsibilities:

  • Worked on ABAP Reporting, Dialog Programming,SAPScripts, User-Exits, and report programming using ALV
  • Involved in enhancement and bug fixing of existing reports, and development of new programs.
  • Worked extensively on data dictionary objects such as Tables, Structures, Views, Data Elements, Domains, search Helps etc.
  • ReviewingABAPprograms to ensure efficiency and fine-tuning where necessary.
  • Created number of custom BDC programs using both Session and Call Transaction for data migration.
  • Analysis, coding and unit testing for various tasks as per the technical specification.

We'd love your feedback!