Sr. SAP Net Weaver Business Warehouse (BW) Lead with Architect

Analysis / Design / Solution

Strong Techno functional experience in Supply Chain, Sales, Finance and APO

Strong backend analytical skills in design, solution and implementation

Work experience with major industries like Pharmaceutical, Manufacturing, Telecom, Health care and
Entertainment
BW HANA Design, Solution, Migration, Implementation and Modeling with HANA Studio
Strong team leadership and multi-tasking skills with successful completion of projects within time & budget

• 13 years of IT experience which includes 10 years in various roles as SAP BW Architect, Lead and Analyst
• with Project Management and 03 years as Oracle DBA
• Strong and excellent project management with Budget estimation, Time Management and Successful
• rollouts
• Successful Full Life Cycle Implementations with Upgrade experience
• Efficient understanding and managing projects using SAP Solution Manager and Clarity Management tool
• Gap Analysis, Design and Documentation using templates and Excel
• Strong Budget Monitoring with appropriate estimation
• Strong Backend and Frontend design with In-depth understanding of ETL Process in doing extraction from
• different kinds of Source Systems to BW System
• Strong Configuration of Data targets, Data sources, Info objects, Key figures and Multiproviders
• Configuration of Transfer Structure, Transfer Rules, Start routines,
• Transfer routines and Update routines
• Construction of Info cubes, ODS, Remote Cubes, Multicube& Configuration ofTransfer and Update rules
• Blue Print, Data Modeling, Designing, Documentation, Development to till Go Live and Support
• In-depth understanding ETL Process in doing modeling from different source Systems to BW
• Strong on End-to-End BW Configurations and Customizations from Extraction,
• Staging, Loading, Performance, Transports, and Reporting using BEx Analyzer, Bex Browser, BEx Web
• Reporting and BEx Map
• Excellent communication and leadership skills and strong analytical Skills with functional and technical
• abilities

SKILLS

• ERP - ECC 6.0, 5.0, 4.7, 4.6C
• BI -7.3, 7.0, 3.5, 3.1C, 3.0B
• Functional - SD, MM and FI/CO
• Languages - SQL, PL/SQL
• Presentation and Project Mgmt - Power Point, MS Excel and Clarity Management tool
• Reporting -Bex, WAD, MS Access and Crystal reports

SELECTED PROJECT EXPERIENCE

Background
Client Profile: American National Insurance Company was founded in 1905 by William L. Moody, Jr. and is headquartered in Galveston, Texas. The Company has multiple subsidiaries, and has operations in Springfield, Missouri; Glenmont, New York; League City, Texas; and San Antonio, Texas
Responsibilities

• Requirements gathering, Analysis, Estimate and Planning
• Scope with analysis of the reporting needs of the project comparatively between existing and future
• reporting needs
• Designed solution to implement NEW GL needs and legacy data build in SAP BW
• Prototype to present the solution based on Legacy (Policy data)Vs ECC data (New GL basing on
• Ledgers) in BW
• Implemented solution to derive the complexity through BW to bring policy data from LEGACY to BW to
• ECC
• Implemented HANA for BW to load CO-PA data to show in 'Real time' for multiple LOB (Line of
• business)
• HANA Studio for data modeling to handle legacy and ECC data
• Remodeling in HANA on migrating existing Infoproviders from BW 7.0 to 7.3
• Build Transient Infoproviders and Composite providers to show the data from Legacy and ECC using
• HANA
• Team managementto help on developing with Functional and Technical specs
• Income Statement, P&L, Monthly A/c Analysis and Balance sheet reports using crystal tool
• Designed work authorizations with security according to priority of users from executive to user level
• Display reports in web areas according to the LOB's and segments
• Planning at each level of ITS with cutover and data loads with transports verification
• Monitoring and preparing the team for successful rollout as per the plan
• User training and support
• Environment: BW 7.3with HANA and ECC 6.0

Company: Confidential, Dallas, TX
Duration: August 2011 - December 2011
Position: Sr.SAP BI-MDM Architect

Background
Client Profile: Dr.Pepper is one of the leading manufacturers in Bevarage industry having various products. The primary objective is to remove the redundancy, cleansing and handling Customer Master Data globally for smooth and effective day to day business decisions
Responsibilities

• Analysis of Customer Master data for Beverage and Packaged business
• Understand Customer MDM requirement to leverage the solution between MDM, ECC and Legacy systems
• Design, Develop and Document Customer MDM implementation in SAP BI with in align of business data between ECC and STAARS (Legacy system) systems
• Build the prototype based on channel and account types hierarchies followed as per the MDM
• Workshops and requirements gathering based on Beverage and Packaged business model
• Designed the solutions to sync with ECC and MDM Customer Master
• Designed to take a data lookup while loading the data between MDM and ECC
• Enhanced the reports to bring in new attributes according to the Beverage and Package business
• Monitoring the team with input and resolving the issues with continuous support for client
• End user training with the changes and scope of the reports
• Documentation changes at appropriate level to reflect the updates of the development
• Developing reports using WebI and Xcelsius using Universe
• Production support and training on KT
• Environment: BI 7.0, ECC 6.0, and MDM 7.1

Company: Confidential, Boise, ID
Duration: December 2010 - July 2011
Position: Sr.SAP BI-APO Lead with Architect

Background
Client Profile: Micron is one of the world's most designing and building advanced memory and semiconductor technologies. The Micron memory that are used every day in products from computing, networking and server applications, to mobile, embedded, consumer, automotive, and industrial designs
Responsibilities

• Implementation of APO - SNP module in BI to meet the Reporting requirements for Master and Area planners
• Implementation of SNP in BI that includes Design, Data modeling, Configuration, Development and Documentation
• Design and implementation of Transaction data and Master data for SNP CTM requirement
• Effective design review according to the CTM Planning and reporting model
• Master data implementation that involved with Resources, Product, Location, Location Product, Transportation lane and PPM's
• Transaction data implementation that involved with Material - location, Material - location - Transportation lane and Material - Product - Resources
• Day to day business meetings with Supply Chain Engineers, MPS Planners and Area Planners
• In depth analysis to build and handle the APO, ECC and Legacy systems data in BI
• Effective monitoring of Budget, Team and Time line for successful delivery in every phase
• Detailed analysis, build, test and documentation with successful rollout in each and every environment
• Critical design of transaction data implementation that includes to give snap shot of current week vs. historical data based on CTM run
• Effective design and implementation of Pegging relationship to fulfill with Demand Vs. Supply process
• Coordinate and discuss with Functional and Technical team for effective design and implementation
• Build Custom data sources based on standard BAPI, Development of InfoCubes, Transformation, DTP's and Process chains
• Training, Documentation and UAT for domestic and global users
• Environment: BI 7.0, ECC 6.0, and SCM 5.0

Company: Confidential, Abbott Park, IL
Duration: July 2010 - November 2010
Position: Sr.SAP BI-APO Lead with Architect

Background
Client Profile: Abbott Laboratories is broad-based health care company operated with multiple divisions from nutritional products and laboratory diagnostics through medical devices and pharmaceutical therapies.
Abbott has sales, manufacturing, research and development, and distribution facilities around the world.
Responsibilities

• Master data Analysis design, Data modeling, Configuration, Development and Documentation
• Design and implementation of SNP Master data in BI and to send the daily snap shot to third party data warehouse system
• Effective design in using the standard BAPI's according to the custom need
• Successful Project and Resource Plan with Budget estimate
• Master data design and implementation for Abbott Nutrition division
• Efficient understanding in process flows and proper suggestions in implementing Master data in BI based on APO Versions
• Implemented APO Master data for Resource, Location, Product, Location Product, Transportation lane and PPM in BI system
• Implemented Master data for Transportation lane based on Means of transport and Product based Means of transport using BAPI's
• Design and Construction of Info cubes, DSO's, Infoobjects and Open Hubs
• Extraction, Staging, Transformation, DTP's and Data loading
• Design of Open hub to process daily master data loads for Abbott nutrition division using Process chains and FTP's
• Start routines and formulas to handle post period data and conversions for UOM
• Generic extractors build using Tables/Views/Function modules
• Coordination with functional teams with presentation using data flows and process diagrams
• On-site and off shore team management with optimized plan and successful roll out
• Effective coordination with QA and change management to meet standards of FDA and DEA regulations
• UAT with KT, End user training and documentation
• Environment: BI 7.0, ECC 6.0, SCM 5.0 and Solution Manager

Company: Confidential, Lake forest, IL
Duration: June 2008 - June 2010
Position: Sr.SAP BI Lead

Background
Client Profile: Hospira is a global specialty pharmaceutical and medication delivery company driven by its vision of Advancing Wellness™.
Responsibilities

• Blue Print, Data Modeling, Designing, Documentation and Development to till Go Live and Support
• End-to-End BW Configurations and Customizations
• Worked on Budgeting and Estimation from Small, Mid-size and Large Projects
• Worked on monitoring effectively on Cost & Time based planning for each phase with successful rollouts
• Efficient understanding in process flows and proper suggestions in implementing changes w.r.t version changes
• Monitored Resources, Budget and Timelines using Clarity management tool
• Extraction, Staging, Loading, Performance, Transports, and Reporting
• Hands on Multiple Projects with Project estimation, Budget Planning, Task handling, Issue resolving with successful rollouts
• ETL, Data Consolidation and Data Handling with Multiple sources
• Designing according to the committee standards as per the regulatory approvals
• Designing InfoCubes, DSO Objects, Data marts, Logical Models, Process Models, and Enterprise Models.
• Configuration and design of Transfer Structure, Transfer Rules & Update Rules and Process chains.
• Performance based routine design and modification
• Construction of Info cubes, DSO's, Remote Cubes and Multiproviders
• Configuration and extension of Generic Extraction and LO Cockpit
• Functionalities
• Data design and extraction between APO BW with Live cache reporting
• Documentation creation and handling with Solution Manager according to the functional area wise with each phase of deployment
• Handled data loads on loading data from multiple source systems to BW system
• Handled data loads by creating and scheduling the loads through process chains
• Handled Flat file loads on loading data from .CSV files into BW system
• Worked on handling Load errors on doing load balances by changing packet size
• Handled data loads by resolving errors and by following the proper delta loads between each source and target
• Handling 24/7 support with weekend loads
• Emergency fixes with Immediate Problem solving based on prioritized Incidents and Requests
• Environment: BW 7.0/3.5, ECC 5.0/6.0, SD, MM, FI/CO, SCM 5.0 and Solution Manager

Company: Confidential, Paramus, NJ
Duration: October 2007 - May 2008
Position: Sr.SAP BI Consultant

Background
Project Description: Movado Group, Inc. designs, manufactures and distributes watches from nine of the most recognized and respected names in Movado, Ebel, Concord, ESQ SWISS, Coach, HUGO BOSS, Juicy Couture, Lacoste and Tommy Hilfiger licensed watch brands
Responsibilities

• Business analysis, Requirements gathering, Power users Meeting, Design andDevelopment
• Modeling and Remodeling based on the business requirement and to get approval from the business based on functional changes
• In depth analysis on Sales, Delivery, Billing Extractors and Sales Historical dataTransformation, DTP's and mappings on SD, MM and FI/CO requirements
• Start Routine, End Routine and Formulas using Boolean logic calculations
• Identified and worked on Material Master data to extract the Material master datarecords from R/3 to BW
• Worked and analyzed business processes for both buyers and suppliers allowing increased focus on value-added activities
• Worked on Vendor Purchase data in building cubes and developing the reports
• Worked on Procure-To-Pay to provide information of PO\'s, invoices and payments including vendor balances and line items into BW as part of the project.
• Monitored data loads from ECC and legacy system into BW based on Sales history
• Worked on Extraction, Transformation, Loading on working with R/3, legacy and Flat file Systems
• Project Management with Resource handling, Budget Monitoring and Time based successful rollouts
• Excel based planning with Power point presentation on each and every level of team meetings
• Migrated objects from 3.X to 7.0 and resolved issues during migration on identifying code logic and programs
• Tested queries on pulling the high end data involving more hierarchies and maximum records
• Power users training and developed presentation on E-2-E process
• Environment: BI 7.0, ECC 6.0, SD, MM and FI/CO

Company: Confidential, Bellevue, WA
Duration: June 2006 - September 2007
Position: Sr.SAP BI Consultant

Background
Project Description: T-Mobile USA is a national provider of wireless voice, messaging, and data services capable of reaching over 268 million Americans where they live, work, and play.
Responsibilities

• Understanding the business and interacting with the end users to collect therequirement
• Involved in designing the Tech Spec Based on the Functional Spec supplied by the business users
• Strong knowledge in building Architecture, Designing, Documenting and inunderstanding the BI Applications
• Review existing application for potential performance and make adjustments where possible as needed
• Data extraction from AR, AP, GL, Asset Accounting and Cost Center Accounting
• Developed reports on Balance Sheet, Income Sheet and P&L Statement
• Worked on Working Capital report to examine trends in working capital components of the Balance sheet such as A/R, A/P and GL
• Worked on Stock Revaluations to get an day-to-day stock positions to measure the Inventory level
• Worked on Procure-To-Pay to give an outstanding orders and payment information on Engineering and EPO departments
• Worked on POS Workbench to provide the details on daily shop wise transactions based on sales and returns
• Worked and Compared with the R/3 systems in process of daily retail transaction
• and postings successfully in BW
• Worked on production system to compare and update the system for every 04 hours transaction based on transaction number in BW
• ABAP coding during data process in Start Routine, Transfer rules and Update rules
• Written ABAP code with data source enhancements using User Exits to the Extract Structure
• Worked on Data Loads and resolved the data load issues in monitoring the errorsClosely during data loads
• Worked on Loading Terabytes of data loads with performance management
• Improved the performance of the queries by implementing the partitioning and Dataloads and on analyzing the data loads, Volume, periods and queries
• Worked on transport requests and released the request and exporting them fromdevelopment System to QA system
• Worked on calculated and Restricted Key Figures, structures, variables andConditions
• Environment: BI 7.0, ECC 5.0, MM (Purchase, Inv), FI/CO (AR, AP & GL)

EMPLOYMENT HISTORY

Aug 11 - Dec 11
Confidential, Dallas, TX
Sr.SAP BI-MDM Architect

Dec 10 - Jul 11
Confidential, Boise, ID
Sr.SAP BI-APO Lead with Architect

Jul 10 - Nov 10
Confidential, Abbott Park, IL
Sr.SAP BI-APO Lead with Architect

Jun 08 - Jun 10
Confidential, Lake forest, IL
Sr.SAP BI Lead

Oct 07 - May 0
Confidential, Paramus, NJ
Sr.SAP BI Consultant

Jun 06 - Sep 07
Confidential, Bellevue, WA
Sr.SAP BI Consultant

Jan 06 - May 06
Confidential- Burbank, CA
Sr.SAP BI Consultant

Jun 05 - Dec 05
Confidential- Irvine, CA
SAP BW Consultant

Jun 03 - May 05
Confidential - Neenah, WI
SAP BW Consultant

Jan 01 - May 03
Confidential- Atlanta, GA
SAP BW Consultant

Jan 98 - Dec 00
Confidential
Oracle Database Administrator

QUALIFICATIONS

• Masters / MBA-Masters in Computer Science