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.
