Bw/hana Architect Resume
IL
EXECUTIVE SUMMARY:
- SAP Certified Consultant with 19 years of SAP Industrial experience and 10 years of Management experience.
- 16 years of SAP BW implementation experience.
- 6 plus years of SAP Business Objects implementation experience.
- 4 plus years of SAP Hana implementation experience.
- Experience in Tableau integration with BW &SQL and its limitations (Extract/Live).
- Experience in Qlik Sense integration with BW &ECC.
- Experience in creating Reporting and Data governance strategies.
- 5 full life cycle implementations in BW, 3 in Business Objects and 2 in Hana.
- Managed Revenue upto $2.5 Million.
- Did multiple Sales presentation, RFP’s, PoC’s for various clients in various industries for BW, Hana and Business Objects.
- Hands on experience in SAP BW4Hana/BWonHana, SAP BI, SAP SD, SAP FI, SAP SuccessFactors, Workday and SAP BPC.
- In SAP Hana core skills lie in Hana Side Car Implementation, AMDP, SLT, SDA/SDI, FlowGraphs, SQL scripted views and Optimization of architecture
- In SAP BW core skills lie in LO extraction, New G/L extraction, Integrated Planning and CO - PA.
- In SAP Business Objects core skills lie in IDT, Crystal, WEBI and Lumira Designer/Discovery. Also well versed in upgrades from 3.1 to 4.1/4.2
- Experience in SAP Anlaytics Cloud (SAC) and SAP Dataservices.
- Worked with Top Management in setting up expectations and getting the SoW/CR’s signed.
- Worked on identifying Gap’s between AS-IS and TO-BE business processes.
- Has experience in designing Universes in IDT from relational databases like Oracle/SQL and Cloud sources (PlanView Odata).
- Experience in Mercury Test Director, MS VISIO, MS Project.
- Developed Test plans, Test cases for Unit, Integrated and Regression Testing.
- Experience with Agile, Waterfall and ASAP methodologies.
- A flexible team player with excellent reporting skills.
- No Sponsorship Needed - US Citizen.
KEY PROJECT/SAP SKILLS:
- Architected SAP BI Solutions and Managed Teams in Onshore/Offshore model
- Working knowledge of Project planning, Blueprinting, Configuration, Testing, and Support
- SAP BW Upgrades from 3.x to 7.x to Hana 1.0, 2.0 and Business Objects 3.1 to 4.1
- Greenfield Implementation in SAP BI 7.x, SAP Hana 1.0, 2.0 and SAP Business Objects XI 3.1, 4.1
- SAP ERP versions 4.6B, 4.6C, 4.7, ECC 6.0
- Working knowledge of SAP modules SD, MM, FI/CO, PP & Inventory Management
- Working knowledge of Business Objects tools UDT/IDT, Web Intelligence, Design Studio, Lumira, and Crystal Reports
FUNCTIONAL/ INDUSTRY EXPERIENCE:
- Packaging
- Media
- Pharmacuticals
- Oil & Gas
- Retail Services
- Specialty Foods
- Consumer Goods
- Software & Programming Technology
COMPUTER PROFICIENCY:
Software: DAPTiv, Change point, Citrix
Testing Tool: Mercury QTP Test Director
Office Tools: MS Office, MS Project, MS VISIO, MS Outlook
Adobe Tools: Acrobat, Photoshop
Operating Systems: Dos, WIN 9X/NT/2000/XP/2003/7
Languages: ABAP, C++, HTML
Database: Hana, SQL, ORACLE, MS ACCESS
PROFESSIONAL EXPERIENCE:
Confidential, IL
BW/Hana Architect
Responsibilities:
- Integrate Transport Management Analytic Solutions with SAP BW.
- Integrate Enterprise Warehouse Management Analytic Solutions with SAP BW.
- Developed Standardization documents for BWonHana modelling and upgrade.
- Currently consolidating all enterprise dataflows and mapping of all legacy report data elements for Hana Upgrade.
Confidential, NC
Enterprise Architect/Associate Director
Responsibilities:
- Liaison Architect between different Business Stakeholders and IT and helped in setting proper expectations in steering committee meetings.
- Created guidelines for modelling of BW4Hana to help developer decide if it needs to be developed by persisting data (BW) or virtually (Native Hana)
- Created reporting standards and strategy for self-servicing tools (Universes/WEBI/Lumira Discovery), broadcast/bursting.
- Architected Hana Security with respect to end user (SSO/Analysis Authorizations/Analytical Privileges) and Business Objects (Connection/Universe/Folders/tools).
- Optimized the scope with respect to Agile methodology (# of Stories with weightage per sprint).
- Architected and build SuccessFactors integration into BW4Hana for headcount reporting.
- Architected and build Production Planning/Stats datamarts. Also Architected AR and Inventory Management datamarts.
- Created SDI connections in Hana to consume ‘Planned’ data from Hyperion and then using Flowgraphs writing back (sink) homogenized data to Oracle.
- Created Odata 3.0 connection to PlanView Cloud to consume enterprise projects information and to marry data from SAP Controlling tables (Plan/Actual/Budget) through SLT.
- Created Lumira Discovery Dashboards for PlanView Projects and published them in LaunchPad.
- Created Dashboard using SAC to help Business with predictive modeling of Customer Churn.
Confidential, CO
SAP Architect/ Analytics Program Manager
Responsibilities:
- Collected Reporting Requirements for SAP Business Objects and SAP Business Warehouse 7.x for Financials, Sales, Procurement and Management Reporting.
- Architected end to end data model in Business Warehouse and built reports in Web Intelligence and Crystal.
- Architected the security model for SAP BI (Analysis Authorization) and SAP Business Objects (Folder Level Security) and prepared security documents to aid the development.
- Developed Sales, Procurement, Financials (G/L, AP & AR) Datamarts in SAP BW. Also created generic datasources to extract data from HCM (employee details), Customer/Business Partner classification with respect to Verticals/Sectors and Super Regions.
- Upgraded Business Objects 3.1 to 4.1
- Upgraded BW 7.0 to 7.4
- Optimized datamarts for faster performance of Business Intelligence tools
- Created Unit/Integration Test Scripts.
- Till Date all milestones have been completed on time and on budget.
- Have received Multiple s from client for my work.
Confidential, AZ
SAP Architect/ Project Manager
Responsibilities:
- Managed a team of 3 to 9 people and a budget of $1 million.
- Collected Business Requirements for BO XI 3.1 and BI 7.0 for Sales and Marketing area.
- Created Reporting Prototypes for retrieval of reports from CRM, BO and BI.
- Created Portal Roles and iVews to display reports from CRM and BI.
- Analyzed ‘As Is” scenario and Business requirements and created ‘To Be’ activities.
- Created Functional and Technical Specifications as per business requirements.
- Created Project plans and RICEF scorecards to track the progress of the overall project.
- Created detailed schemas in BI and Universe Designer (BOBJ) to import data from CRM and SAP
- Architected different reporting layers like data acquisition, corporate memory, data propagation layer etc in SAP BI.
- Created InfoObjects, Cubes, DSO’s to support both Master and Transactional Data.
- Created queries using query designer and embedded those queries to produce complex workbooks in BEx Analyser where VB code and macros were also used.
- Created security roles for BI developer, end user and administrator.
- Created different Access levels in “Central Management Console” in Business objects for Business Users regarding Report access.
- Created BIAR files to import objects into QA and Production environments.
- Helped the Basis team in installing Business Object Repositories (System Database and Audit Database).
- Created reports in Web Intelligence Rich Client on Desktop and later transferred these reports to “Infoview”.
- Created management and operational Dashboards using Xcelsius
- Created necessary data flows and BI Objects for CO-PA and Integrated Planning in SAP BI.
- Scoped and delegated Basis tasks to the Basis team for BI integration into CRM.
Confidential, CA
SAP Architect/ Team Lead
Responsibilities:
- Managed and lead a team of 3 to 7 people
- Created Project Plan for both BW upgrade from 3.5 to 7.0 and EP 7.0 implementation.
- Collected Business Requirements for BI 7.0 upgrade and EP for the following Reporting areas - Finance (FI), Human Resources (HR), and Procurement (MM)
- Migrated data from earlier version of Business Object i.e. 6.0 into XI R2 using Import wizard.
- Created Crystal reports in business objects which were geared towards Management.
- Created Voyager Connections to SQL Analysis services to map Microsoft schema (cubes).
- Scheduled Reports in business objects and in BI Broadcaster.
- Completed some technical and functional specs.
- Produced detailed BI, BO and EP project plans and got approval from Steering Committee.
- Created BI and EP Testing plan and testing scripts
- Delegated BI testing plan to the offshore team
- Trained freshmen - 2 individuals in BI and 3 individuals in EP throughout the project
- Conducted UAT/UCT as part of the project scope
- Provided Project Support after Go live as part of the cut over activities
Confidential, TX
SAP Architect/ Team Lead
Responsibilities:
- Managed a Global team of 10 to 40 functional/technical people and a budget of $3 million.
- Gathered Global Business Requirements for BI 7.0 reporting in areas of FI - AP, AR, GL, Sales (SD), and Project Systems including Time Writing.
- Validated Reports on the candidate list in RICEF as well as working with the SDD (ABAP Technical) team to identify correct classification of process related reports (BI or ABAP) that are requested by stakeholders
- Completed functional specs, and technical specs.
- Produced detailed BI testing project plan and defined tasks, allocated resources and hours.
- Produced BI Testing approach.
- Produced high level BI testing scenarios for the business.
- Produced sample test cases with screen shots to aid the offshore team in preparing other test cases for BI testing.
- Trained 3 individuals and lead a team of 9 individuals for BI testing
- Did BI testing using Mercury Quality Center and gave demos to BI functional and technical teams
- Handled Complex BI Testing related issues with Client and gained their confidence in establishing himself as lead authority for BI testing. Responsible for analysis, design, testing and implementation of SD & FI functionality.
- Enhanced datasources for LO extraction and New G/L extraction.
- Created Real Time InfoCubes for Integrated Planning which fed data into standard cubes for reporting.
- Created Accounting based Co-PA datasources in ECC6 and respective Objects in BI.
- Used Cell definition in query designer to meet the business requirement.
- Created Jump Targets to jump to detail queries for summarized ones.
Confidential, TX
SD Team Lead
Responsibilities:
- Managed a team of 5 people
- Simplified complex solution to define what is in scope with respect to resources, budget and realistic timelines.
- Effectively placed a change control process in place through which project scope changes were handled via PMO approvals
- Responsible for analysis, design, testing and implementation of SD functionality.
- Understanding local and global business processes, preparing the design specification covering business requirements, and developing AS-IS and To-Be concepts for SD implementation.
- Mapping of plants, sales organizations, distribution channels, divisions, and sales offices on SAP R/3 business model.
- Creation of account groups for defining partner functions for customers, vendors, and other business partners.
- Field selections and designing screen layout for various partner functions
- Defining various order types and item categories for defining business processes/transactions based on different pricing strategies.
- Contribution included successful customization for various SD related business transactions picking different pricing procedures depending upon various order types base on ATP logic and scheduling agreements.
- Configured account determination, shipping and route determination, and output determination.
- Up loaded the SD test data using LSMW.
Confidential, ON
SAP SD Consultant
Responsibilities:
- Master Data in Sales and Distribution.
- Document flow and copy control.
- Shipping and Billing processes.
- Customizing Pricing Procedure according to condition technique, creation of Condition Exclusion, working with rebates.
- Customizing special business processes like Consignment Stock Processing, Promotion and Sales Deal.
- Creation of cross-functional condition techniques like Material Determination, Listing and Exclusion, and Free goods.
Confidential
SAP BW Consultant
Responsibilities:
- Worked with users to define reporting requirements.
- Designed and Developed Reporting Packages using BEX Analyzer.
- Assisted in the design and implementation of ODS, Info cubes, Info objects, Transfer Rules, Extract Structures, Update Rules, and Info Packages.
- Assisted in the activation of Standard Business Content and creation of new Generic Datasources.
- Experience in loading data from the following sources: R3 and flat files.
Confidential, NY
SD Functional Consultant
Responsibilities:
- Streamlined OTC (Order-to-Cash) utilizing SAP Sales & Distribution and Material Management functionalities to manage customer orders and order fulfillment requirements.
- Defined functional specifications and authored business process procedure documents to fulfill stated requirements.
- Developed guide for the “Post Goods Issue” process (PGI), a key functionality affecting Revenue Recognition procedure.
