We provide IT Staff Augmentation Services!

Sr. Sap-bi/bo/hana Architect Resume

3.00 Rating

Chicago, Il

SUMMARY:

  • Over 13 years of professional experience in IT industry, of which 12 years in SAP with emphasis on SAP BI, BPC, ABAP, SAP CRM, ERP and Integrated Planning projects 
  • 10 years of SAP BI experience .
  • Over 6 years of SAP BI Lead Architect experience in managing cross - functional team of functional consultants, developers and testers in development and deployment of modeling and analytics product to facilitate organization integration of mergers and acquisitions.
  • 3 years of experience in planning models - BPS and IP.
  • Collaborated with Integration management team and Business Partners to implement analytical solutions.
  • Developed and Maintained standards regarding methodologies, definitions, processes, tools and technologies required to implement BI.
  • Delivered $9M global BI implementation program and developed roadmap for data and business intelligence program.
  • Led transformation of financial close process using BPC and reduced time close to 30%.
  • Recognized as an expert in defining ETL process and data management for Budgeting and Forecasting models.
  • In-depth knowledge in implementing ECC and BW on HANA.
  • SAP-BI upgrade experience on multiple projects which includes both Technical and Functional upgrade.
  • Experience in conducting gap analysis between business requirements and software.
  • Conducted programs for users and managed client expectations by communicating project status, resolving concerns and issues.
  • Involved in requirements analysis and prepared High-Level design documents, data model diagrams, technical and functional specifications.

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL.

Sr. SAP-BI/BO/HANA Architect

Responsibilities:

  • Performed Blueprint design workshop sessions with high level organization and created functional and technical specifications.
  • Responsible for OTC and ICM end to end BI implementation (From data acquisition to Report deliverables).
  • Led offshore team and functional consultants at onsite in delivering initial end to end SAP implementation and handed over to support team.
  • Configured LSA Architecture and optimized BI process for better solution.
  • Led BI database space reduction by adopting to relevant storage methods (Near line storage, …)
  • Extensively worked on analyzing table relationships in ERP to design data modeling in HANA.
  • Extensively worked on migrating data from Non-SAP and SAP systems to HANA system using Data Services 4.0.
  • Proficient in writing SQL code for calculation views. Developed complex code to determine sales compensation, cross selling in sales activity, …
  • Designed and Developed Data foundation and semantic layer in IDT.
  • Worked on stabilizing of applications using SAP best practice optimization techniques.
  • Upgraded the system to BW 7.3 version.
  • Configured business rules for sales order processing and sales rep compensation.
  • Involved in Business object upgrade 4.0.
  • Involved in importing extractors into the database, identifying the type of

Confidential - Draper, UT.

SAP-BI Solution Architect

Responsibilities:

  • Designed Data modeling and work flow for extracting data from CRM and SAP R/3.
  • Design and Implemented Customer Surveys.
  • Managed data storage standards and implemented best practices for the creation and delivery of required information to end user to enrich the business.
  • Reviewed technical design by team members before it get implemented .
  • Design and Implemented Sales Activities, Opportunities, Price Configuration and Asset Management.
  • Prepared High-Level design document, Tech specification and Gap documents.
  • Involved in Code review and User acceptance testing.
  • Performed end-user s for multiple rollouts.
  • SAP-BI/BO Lead Architect - Business Objects Implementation Project
  • Created and modified Universes as per requirements.
  • Extensively worked on Universes Optimization.
  • Created various Web intelligence documents with queries.
  • Developed schema with tables and joins.
  • Extensively worked on creating and formatting reports.
  • Created WEBI reports using multiple data sources.
  • Project Lead - Forklift Project
  • Design and Implemented Open Hub concepts to extract data from BI system to EDW system.
  • Created Project Plan and assigned tasks to the team members.
  • Prepared High level design documents and delivered the project on time.
  • Designed file structure to fulfill EDW system requirements.
  • Provided solutions for the development issues and guided file transfer process from SAP BI system to EDW system.
  • Project Lead - SAP BI Production Support
  • Maintained 24/7 on call rotation in the team.
  • Performed system performance improvement including Re-modeling, Re-partitioning, Extractor enhancement, Events Handling and Process Chains.
  • Maintained system health using Early watch report.
  • Involved in Query Optimization.
  • Extensively worked on overall data load reduction time.
  • Performed enhancements to existing objects.
  • Assigned tasks to team members and maintained work load across the team.
  • SAP-BI Solution Architect - BI Upgrade Project
  • Created project plan and worked closely with Basis team to perform the upgrade BI 7.0.
  • Performed pre and post upgrade activities.
  • Replaced transfer and update rules by Transformation.
  • Involved in creating DTP, TRFC and data sources replication.
  • Performance optimization by partitioning and Clustering.

Confidential, Santa Ana, CA.

Senior SAP BI-BPS Consultant

Responsibilities:

  • Designed and Implemented BI-Inventory Management.
  • Extensively worked onSAP-BPS Performance improvement.
  • Created multiple Fox programs for planning functions.
  • BEx Reporting - Created various reports in BI-Finance and BI-MM.
  • Involved in BI and BPS Production Support.

Confidential

SAP BI-IP Solution Architect

Responsibilities:

  • Involved in development of Base Volume Planning, Promotional Planning, Price and Margin Planning.
  • Created real time Info providers for sales forecasting which includes draft and published cubes.
  • Developed various Planning layouts and Workbooks in BEx Analyzer.
  • Initialized material and customer planning combinations.
  • BEx Reporting - Created various sales forecasting reports including Moving Average Trend.
  • Created multiple Fox programs for planning functions to calculate Standard Price, Standard Margin, Export Price, Account Bonus, Rebate and Commission.
  • Involved in creation of Aggregation levels, Filters, Layouts, Character relationship, Planning functions and Planning Sequences.
  • Created Extractors, DTP, Transformations, DSO, Info Cubes and Multiproviders in FI-COPA and SD modules.
  • Developed Process Chains and multiple expert routines in Transformations.

Confidential, Fremont, CA.

SAP BI-IP Solution Architect

Responsibilities:

  • Designed and Implemented FI-CCA, FI - PCA and HR modules.
  • Created real time Info providers for Budget planning and forecasting.
  • Extensively worked on Version Management for Planning.
  • BEx Reporting - Created various planning budget and forecasting reports.
  • Involved in creation of Aggregation levels, Filters, Layouts, Character relationship, Planning functions and Planning Sequences.
  • Created Extractors, DTP, Transformations, DSO, Info Cubes and Multiproviders in -CCA, FI - PCA and HR modules.
  • Created Retractors for primary cost and Internal Order planning.
  • Created multiple Fox programs for planning functions.
  • Developed BEx Analyzer workbooks for planning.
  • Created User exist variables for BEx Reports.
  • Involved in BI Transports, Security and Authorization.
  • Enhanced Master and Transaction data Extractors.
  • Developed Process Chains, start and end routines in Transformations.
  • Created Flat File structure to upload Plan data and involved in writing routines to get desired format.
  • Involved in power user, end user and troubleshooting of data quality issues.

Confidential, Federal Way, WA.

SAP BI Consultant

Responsibilities:

  • Involved in Technical and Functional Upgrade
  • Performed post upgrade activities.
  • Created write optimized DSO and performed optimization for DSO.
  • Replaced transfer and update rules by Transformation.
  • Created DTP and modified Info packages.
  • Involved in Remodeling Info providers.
  • Performance optimization by partitioning and Clustering.

Confidential, Federal Way, WA

SAP BI Consultant

Responsibilities:

  • Provided On call production support across all functional areas including PM, MM, FI-AP, COPA, FI-AR, PCA and CCA.
  • Involved in enhancements to the Extractors, Info Sources, Info Objects, Transfer Rules and Update Rules, ODS and Info Cubes.
  • Worked on Data Quality Management, Cube Statistics and NumberRange Buffering.
  • Exposure to RSRV and RSRTRACE for BEx security trace.
  • Scheduled the Process Chains by Tivoli.
  • Query Optimization.
  • Modified the ABAP Routines in Update rules and Transfer Rules to improve the load performance.
  • Analyzed and corrected production problems as they occur in the SAP BW system.
  • Extensively worked on improving load performance.
  • Performed changes in the Hierarchies and Reports. Created user exits variables.

Confidential, Federal Way, WA.

SAP BW Consultant

Responsibilities:

  • Extensively involved in creating Info Cubes, ODS and Multi provider in the areas of PM and MM.
  • Designed and Implemented PM - Maintenance Order Headers, Cost and Allocations, Notifications and Operations.
  • Designed and Implemented MM - Inventory, BOM and Purchasing.
  • Business presentation to the client.
  • Involved in BW 3.5 Upgrade.
  • Had direct interaction with the clients and analyzed the business requirements.
  • Created ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to update Key Figures in the Info Cubes.
  • Developed Local specific Process Chains and Info Packages.
  • Prepared High-Level design document and data model diagrams.
  • Provided knowledge transfer during and end of the project.
  • Performed Unit Testing and data validation between SAP R/3 and BW systems.
  • Created custom extractors using function modules.
  • Have worked on data selection via User Exits.
  • BEx Reporting.
  • Reviewed design documents to identify improvement opportunities.

Confidential, Federal Way, WA.

SAP BW Analyst

Responsibilities:

  • Designed and Implemented FI-AP and FI-AR.
  • Involved in data modeling for AP Line items, Spend Analysis and Supplier Diversity.
  • Monitored data loads with full update and delta mechanisms for both master and transaction data.
  • Written ABAP Program for BW to identify master data records that have attributes with no data on certain, specified master data attributes.
  • Configured restricted key figures, variables, exceptions and calculated key figures in queries.
  • Used SAP provided extractors.
  • Provided knowledge transfer during and end of the project.
  • Created and activated transfer rules and maintained communication structure.
  • Written ABAP Program to identify all master data records that have no corresponding text records.
  • Activated standard Business Content for Cubes, ODS, Info Sources, Data Sources and customized them to meet business requirements.
  • Scheduled and monitored periodic data loads from SAP R/3 to BW.
  • Used BEx query designer to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures. Worked on currency conversion as per the user requirements.
  • Developed Local specific Process Chains and Info Packages.
  • Created variables for BW Queries.

Confidential

SAP BW Analyst

Responsibilities:

  • Developed data modeling objects in FI-PCA and FI- CCA Modules.
  • Involved in workshop and design session between business and project team.
  • Extensively worked on ABAP Routines in Transfer rules and Update rules.
  • Enhancements to Master data and Transaction data Extractors.
  • BEx Reporting and Web Templates.
  • Installed Business Content.

Confidential

SAP ABAP Consultant

Responsibilities:

  • Developed BDC programs and smart scripts.
  • Created several customized ABAP Programs and reports for Sales and Distribution.
  • Involved in production support.

We'd love your feedback!