SUMMARY:

• 17+ years of IT experience including 14+years expertise in SAP BW and SAP ECC design and development of LO, MM, FI, CO, BPC, PP, HR, HCM, AFS, FMS and SD modules.
• 14 years of extensive experience in SAP BW/BI this includes Data Modeling, Extraction, Transformation, loading (ETL) and Report Development.
• Implemented 4 full life cycle SAP BW projects.
• Working knowledge of SAP ASAP methodology in Software Development life cycle (SDLC).
• Lead and manage teams responsible for designing, developing and supporting the SAP RICEFW (Reports/Interfaces/Conversions/Extensions/Forms/Workflow) objects
• Expertise in SAP BW 7.4 on HANA, 7.3, 7.1 & 3.5 configurations, Reporting and OLTP Extraction.
• 1 year Native HANA experience sourcing data from both ECC and Legacy systems
• 1 year BW on HANA experience
• Experience in Business content activation, Data Extraction, Generic Extraction, Data Load Scheduling, Monitoring, Info cubes, Info Source, LIS and LO Cockpit
• Proficient in 3 - Tier SAP BW Architecture including Extractors, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, Open Hub and Hierarchies
• Technical experience using OLAP tool Business Objects (Universe Designer, Reports, Infoview, Web Intelligence)
• Participated in all phases of life cycle including Requirement Gathering, Development, Testing, Deployment solutions, Post production Support, Documentation, User training in SAP BW (Front-End)
• Extensively worked on transporting objects between BW system environments and corresponding SAP ECC systems.
• Experience in design and development of Queries, Reports, Workbooks and Web reports publishing BEx Query Designer, BEx Analyzer and Web application designer (WAD).
• Excellent communication skills and ability to work effectively in fast paced environments
• Ability to manage all facets of the System Development Life Cycle

TECHNICAL SKILLS:

Operating Systems: Windows 8/2000/NT/98/XP

ERPs: SAP R/3 4.7, 4.6B, 4.6C, ECC 5.O, 6.0, APO, BPC

Data Warehouse Tools: SAP BW 3.50, BI 7.0, 7.3, 7.4, BW on HANA, BODS, HANA

Languages: SAP ABAP/4, Java

Databases: Oracle 8i/9i,11,12c

Tracking Systems: Service now, Remedy

Reporting Tools: Business Explorer (BEx), Web Application Designer (WAD), BOBJ, Analysis for office

Testing Tools: WinRunner, TestDirector, QTP, HP QC, ALM

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SAP BI Refresh Architect

Responsibilities:

• Created a blue print to move the BW landscape from Oracle DB using BWA to Oracle 12c DB without the BWA appliance
• Coordinated the refresh activities with various teams with ECC/BW bolt-ons
• Involved in beta testing for various critical Month End Close reports (on BW and BO) that heavily relied on the BWA appliance to make sure the timings were comparable
• Delegated a team of 12 developers and testers both onshore and offshore
• Involved in hands on development for objects and code that needed remediation
• Scheduled update and status meetings with C- Level executives, Business process owners and team leads
• Responsible for opening SAP Messages, OSS Note updates, patch and kernel requirements for new DB as recommended by both Oracle and SAP
• Involved in writing a white paper detailing the process of implementing a similar landscape for Accenture

Sr. SAP BI Architect

Responsibilities:

• Responsible for creating and maintaining BW objects
• Involved in data staging, loading, refresh for Logistics, Finance, COPA and flat file datasources
• Gathered user requirements from business and created a blue print for the solutions
• Resposible for creating Functional & Technical specs documents and maintaining them in sharepoint
• Created various BEx reports and workbooks for business reporting
• Created generic datasources and also installed standard content datasources
• Created and maintained hierachies for reporting
• Created start, end and expert routines using ABAP to meet user requirements
• Interacted with other SAP teams, business owners, legacy system owners to coordinate development activities between various teams

Sr. SAP BI/HANA Architect

Responsibilities:

• Created a Global solution for their End Use reporting by harmonizing data from different continents
• Involved in requirement gathering with stakeholders, understanding their demands and architecturing the design
• Created POC dashboards on Native HANA, BW on HANA, BOBJ and held presentations for C-level executives
• Created views from various DSO tables creating a harmonized master data solution for UA
• Responsible for leading a team of 35 offshore developers in the development and design of various reports and maintenance activities
• Created project schedules to drive teams to meet dates and communicate progress to PMO and stakeholders on regular intervals
• Responsible for updating senior management of current developments and impacts on environment including outage and down times
• Coach and mentor team members with regards to current performance and future development
• Cordinate development with various leads from legacy and other source systems
• Worked exclusively with SAP America in defining a model for the implementation of SAP FMS module for UA

Environment: SAP BI 7.3, Native HANA & ECC 6.0, AFS, FMS, FI, PP, SD, Business Objects, BODS, BEx, SAP B1, ERPnext, MSSQL, SSIS and EPICOR

Sr. SAP BI Architect

Responsibilities:

• Developed pricing models from A - tables and KONP/KONH tables
• Created custom extractors using ABAP to pull required data from various tables
• Created cubes, DSOs and Multi-providers to store data and reporting
• Created BEx queries for Webi and explorer reports
• Created start, end and expert routines as needed
• Developed allocation logic for adjustments data to the price waterfall based on characteristics and attributes of the adjustment
• Developed logic for calculating Chargebacks, Rebates & Agency Fees from Vistex against Billing Condition & Item datasources
• Created both Functional and Technical design documents
• Involved in Functional User testing and knowledge transfer

Environment: SAP BI 7.3, 7.4 on HANA & ECC 6.0, SD, Vistex, Vendavo, Informatica, Business Objects, BODS, BEx (WAD, Query Designer, Web Reports)

SAP BI Architect Onshore/Offshore

Responsibilities:

• Lead a team of Offshore developers in a 24x7 production support
• Involved in creating both the functional and technical design documents for enhancements and new developments
• Involved in hands-on development of extractors, infoproviders and BW objects
• Involved in ABAP code review for all developments for approval
• Involved in troubleshooting data integrity issues in BEx reports across different modules (MM,HR, HCM, SD, AFS & FI)
• Involved in the creation and publishing of BEx queries to the broadcaster and scheduling the reports
• Involved in the troubleshooting of daily incidents like process chain and APD failure, DSO activation failure, special characters and infoprovider re-design
• Involved in the delegation of duties among the BI team members
• Evaluated the criticality of each incident/ticket and assigned the level of importance accordingly
• Made sure deliverables met their SLA
• Maintain all applicable documents and procedures in Solution Manager
• Involved in user training, knowledge transfer and support manual creation & enhancement
• Maintain and managed on-call roster for both onshore and offshore developers

Environment: SAP BI 7.3, 7.0 & ECC 6.0, FI, HR, HCM, CO, SD, MM, SCM, SRM, WM, PM, IM, AFS, POSDM, BPC, Business Objects, BEx (WAD, Query Designer, Web Reports)

SAP BW Process Lead

Responsibilities:

• Involved in the Full Life Cycle implementation of SAP Finance module (0FI GL 14) and the conversion of data from Hyperion Enterprise, Essbase and Legacy systems to SAP format.
• Involved in implementation of the SAP HR module and enhancement
• Involved in the requirements gathering from both business and legacy system administrators
• Involved in the creation of the Functional Specs Document and the Technical Design Document detailing the process flow of data and objects
• Involved in the development and design of the prototype interface
• Coordinated the development with offshore developers (IDC)
• In charge of documentation and uploading of documents to sharepoint for PMO
• Heavily involved in the hands-on development of the Cubes, DSOs, Process chains, Datasources, infospokes and reports
• Created custom extractors from ECC FAGLFLEXT table using ABAP, to help in the data mapping from the legacy system
• Used ABAP coding for start, end and expert routines
• Experience in ABAP OO and BADI
• Used Open Hub & infospokes to extract data from BW to 3 rd party systems
• Involved in creating custom transactions for end users to trigger events when system goes to production
• Involved in the collection of objects in development and transporting them to Quality for testing and eventually to production
• Involved in troubleshooting failed transports and recollection
• Involved in writing scripts and unit testing using HP Quality center
• Involved in end user training and creating training material.
• Excellent experience in the star schema model
• Worked with Universe designer based on SAP Business Warehouse/ Bex data in Excel form and based on project requirements
• Created Alerts, Ranking and Drill down Reports based on Sales, Customers and Status.
• Created User prompts, Conditions and Filters to improve report generation.
• Created Webi reports
• Included personal data files like Excel worksheet to the data provider to be able to generate reports
• Created BEx Queries and universes for BOBJ reports

Environment: SAP BI 7.0 & ECC 6.0, FI, GAAP, CO, HR, SD, MM, PM, OCM, SCM, BPC, Business Objects, BEx (WAD, Query Designer, Web Reports)

SAP BW Architect

Responsibilities:

• Involved in the Full Life Cycle implementation of SAP BW, which includes data gathering, gap analysis, data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and web reporting for FI.
• Actively involved in Transports, Troubleshooting and Data Validation
• Extensive experience in 0fi gl 4 & 0fi gl 10 datasources, AA, AP and AR
• Experience creating transformations between R/3 and BW
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition of info cubes
• Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing FI by using enhancements
• Worked in FI, SD and MM modules creating and working on Data store objects and infocubes
• Created Process chains for Master data and transaction data loads.
• Loaded Transaction Data and Master Data via Flat files
• Extended Transaction data & Master data by appending new data elements using enhancement component
• Involved in creating and maintaining Info Cubes, DSO, PSA, Info Objects, Info Areas, MultiProviders, Data Sources, and Info Packages.
• Transporting the objects from Dev Server to Prod Server
• Managed user Authorization & roles (PFCG)
• Experience in ABAP programming in ECC 6.0
• Participated in GO LIVE and Production support
• Generated reports using BEx (Business Explorer) with variables, exceptions, restricted key figures, calculated key figures, conditions, formulas, RRI interfaces, filters, and drilldown methods.
• Scheduled Process Chains for full and periodic data loads
• Develop dashboard and scorecards using xcelsius 3x and business objects 3.1

Environment: SAP BI 7.0 & ECC 6.0, FI, CO, SD, MM, Business Objects, BEx (WAD, Query Designer, Web Reports)

SAP BW Team Lead

Responsibilities:

• Involved in BW configuration, modeling, design specification, performance tuning and detailed reporting worked on various modules such as HR, SD, FI/CO and MM.
• Designed and developed Custom Info Cubes and ODS objects in MM application components.
• Created Info Cubes and ODS with Delivered/Custom Info Objects & Key figures.
• BW business content installation, data modeling and designing info cubes with various aggregate levels.
• Activated Business Content as required. Created/changed transfer rules, update rules as per Clients requirement. Performed Info Cubes partitioning, indexing etc.
• Created Update rules to update data from multiple ODS objects and master data.
• Involved in writing routines using ABAP in both ECC 5.0 & 6.0
• Created Transfer rules for Info Sources to update data from multiple source systems.
• Created Multi Cubes on Info Cubes under Inventory, Sales and Purchasing Info areas.
• Created BEx Reports and Web Reports on these Info Cubes as per Users requirements.
• Involved in Analysis Authorizations (RSECADMIN)
• Involved in security & role maintenance
• Designed generic Data source for Material Pricing, Inventory valuations etc.
• Created Info packages (full, Init and Delta) and Info package groups for loading data from R/3 and Flat files.
• Extracted data and monitored the loads.
• Design, develop and test reports based on business blue prints using crystal reports, xcelsius and Business Objects
• Developed Queries using BEx Analyzer on the cubes. Created and maintained Variables, calculated and restricted key figures for BEx queries as required and saved some of them in workbooks.
• Published the report views on web for the BEx reports created.
• Created Aggregates on IM and Sales Cubes to improve the performance of Queries.
• Created and maintained Info Sets on multiple ODS and master data, with custom fields and assigned to roles/user groups.

Environment: SAP R/3 4.6C, SAP BW 3.0B, BEx (WAD, Query Designer, Web Reports),SAP BW Scheduler

SAP BW Consultant

Responsibilities:

• Involved in the upgrade of SAP BW 2.1 to BW 3.5
• Responsible for analysis of data requirements and translation of those requirements into dimensional data models using star-schema and extended star-schema data modeling techniques
• Worked on the extraction of data’s from LO Cockpit - SAP R/3 to BW
• Created and activated custom InfoCube as per the data model for SD deliveries
• Created and maintained the InfoCubes in SD for Quotations/ Orders, and Sales Order overview
• Created respective update rules with necessary update routines
• Created the InfoSources and scheduled several data uploads such as initialization with delta updates
• Created consolidated revenue InfoCubes
• Created query variants, restricted key figures, filter values, and exceptions for the effective Query Management
• Created queries using BW reporting variables, navigational attributes, and filters
• Created views of the Query for Web Reporting
• Defined exceptions and conditions
• Published different elements of the views to the web
• Developed several queries and the workbooks using BEx Analyzer according to end users requirement

Environment: SAP R/3 4.6B, SAP BW 2.1C/3.0A, BEx (Analyser, Web Reports, Query Designer)

SAP BW Consultant

Responsibilities:

• Gathered information from end-users based on their needs
• Developed BW objects such as InfoObjects, InfoCubes, DataSources, and InfoSources
• Extracted from legacy applications using DB Connect & XML
• Responsible for data loading that includes master data and transaction data
• Uploaded master and transactional data from files and SAP as the OLTP source
• Responsible for customizing and activation the business content objects and loading the data into ODS object and InfoCubes
• Created aggregates to improve query performance
• Worked extensively on BW Scheduler to load data into InfoCube and ODS
• Worked extensively on standard and custom defined LIS and LO extractors
• Worked extensively on BEx Browser, BEx Analyzer, and InfoSet queries
• Created calculated key figures, restricted key figures, variables, and exceptions
• Organized business roles/functions and managed workbooks using BEx Browser

Environment: SAP R/3, SAP BW, SAP BW Scheduler, BEx (Browser, Analyzer)