We provide IT Staff Augmentation Services!

Sap Bw Architect/analyst Resume

Fort Worth, TX

PROFILE:

  • Senior SAP BW/ABAP/HANA Developer & Solution Architect with over 16 years experience.
  • Worked in many End to End Global projects by contributing in various areas including Requirement gathering, Problem Definition, Analysis, Design, Configuration, Development, Testing and implementation at the right time within budget in SD, MM, FICO and PP modules.
  • Over 18 years of SAP - IT Experience
  • 16 years of SAP R/3 Architecture/Development
  • 16 years of ABAP Development experience
  • 14 years of SAP BW including BW on HANA 7.5
  • 2 years of HANA Modelling using HANA Studio & IDE
  • 4 years of Management/Lead experience
  • SAP CRM - (Trained)
  • Trained in SAP ABAP Oops, ABAP on HANA
  • Specialized in SAP R3 and SAP BW, Applications, Configuration and Technical Experience (BW 3.2/3.5/7.0, BW7.4 on HANA, HANA Modelling, HANA Studio, SEM-BCS, BPC,, Sales and Distribution, Logistics, Finance, SRM 7.0,CRM, Business Workflow and ABAP/4)

APPLICABLE NON SAP-SPECIFIC SKILLS:

Operating Systems: Unix ( Scripts, FTP ), Windows NT

Programming Languages: Java, Cobol, C and HTML

Databases: SYBASE and ORACLE

SAP Tools: ABAP, BW, LSMW, Report Writer

Other Tools: Jetform, Remedy, JIRA

RELEVANT WORK EXPERIENCE:

Confidential, Fort Worth, TX

SAP BW Architect/Analyst

Responsibilities:

  • Designed and Developed the Data extraction process from multiple info providers, that was transferred to Data Lake for further enrichment and reporting in AWS Cloud
  • Participated in the implementation of projects using AGILE Methodology regularly Communicating/updating tasks regarding release scope and deployment timelines
  • Various Functional Areas included were Sales, Cost Center Accounting and Budget Details
  • Analyzed Multi-system Comparison Reports in SAP BW and fix any mapping issues
  • Reporting tool used SAP BI analysis for EXCEL

Confidential, Minneapolis, MN

Environment: SAP ECC6.0 and BI 7.5 on HANA

Lead SAP Technical Architect/Analyst

Responsibilities:

  • Designed, Developed/enhanced and Documented for the existing ABAP and BW Objects process
  • Documentation for Queries with related Variables,Calculated and Restricted Key Figures
  • Developed Reports that were used for Data validation for many interfaces
  • Maintained Various Interfaces in FICO that the data was flowing from/to external systems

Confidential, Racine, WI

Environment: SAP ECC6.0 and BI 7.5 on HANA

Lead SAP BW Architect/Analyst

Responsibilities:

  • Reverse Engineering Project to move from SAP-BW to TeraData
  • Designed and Developed Documentation for the existing BW Objects and processes included in the transformations between Infoproviders during the data flow
  • Developed Documentation for Queries with related Variables, Calculated and Restricted Key Figures
  • Various Functional Areas included were Sales, Production Orders, Stock Transport Orders and Logistic Execution modules
  • Developed Reports to Automated documentation process to map SAP BW data to ECC Data

Confidential, Phoenix, AZ

Environment: SAP ECC6.0 and BI 7.5 on HANA

Lead SAP BW Architect/Analyst

Responsibilities:

  • Worked on business requirements for Master Data (ECC / Customer Master, Material Master) and FI Transaction Data
  • Design, Developed and Enhanced Custom Solutions in HANA Studio and HANA IDE
  • Designed and Developed advanced ADSOs, HANA Data Modelling, Calculation Views, Composite Providers and Queries

Confidential, Dallas, TX

Environment: SAP ECC6.0 and BI 7.5 on HANA

Lead SAP Analytics Architect

Responsibilities:

  • Design and Developed Custom Solutions with Pricing tools using OOPs ABAP, SAP BW and HANA Studio
  • Analyzed ad enhanced existing Hana Views like Analytical, Attribute and Calculation views for additional fields and to improve performance as well
  • Modelled Hana Views as per client requirement where the data was compared with SQL Server and Oracle data. Some of them were connected via SDA to Hana.
  • Enhanced Existing Pricing Updating and Reporting Solutions which is built over Vistex Data
  • Developed SQL Scripts for validation and comparison with ECC and SQL Server data
  • The Backend modelling was designed, developed and enhanced for optimum reporting performance using reporting tools like SAP BO, Power BI and Tableau.
  • Used HANA LifeCycle Management for transporting objects into QA and Prod System
  • Used SAFe Agile Methodology for all Development/Enhancements
  • Trained on SAFe Agile Scrum Master (Will be taking the Certifying Test soon)

Confidential, Harrisburg, Pennsylvania

Environment: SAP ECC6.0 and BI 7.4

Lead SAP BW Architect/Analyst

Responsibilities:

  • Enhanced current Data Modelling to enhance the loading and reporting performance
  • Worked in Plant Maintenance enhancing extractors and completely reloaded Order/Plant related InfoProviders
  • Fixed and Enhanced current Data Providers and the loading objects like Transformations, Data Sources, InfoObjects, InfoSources to efficiently and correctly update the Data Providers
  • Created, Maintained and Fixed BeX Queries and Web Templates as needed
  • Designed, Created, Maintained and Supported Process Chains for loading data into Info Providers. Various Process Types Options was used to optimize and efficiently use the available system resources.
  • Created and Scheduled Batch Jobs for the different Process Chains.

Confidential, Harrisburg, Pennsylvania

Environment: SAP ECC6.0 and BI 7.5 on HANALead SAP BW Developer/Architect/Analyst

Responsibilities:

  • Prepared the standard procedures for design, development, documentation, testing documentation and steps to move to production
  • Estimate Development Efforts for Changes and new developments
  • Debug issues or performance problems and provide appropriate fixes
  • Prepared the Specification Documents for Development and Reporting
  • Developed/Enhanced HANA Models for Data Analysis, better performance and Reporting
  • Used new ABAP techniques to improve the loading performance
  • User-Exits (CMOD), Start Routines, End Routines and Info Object Routines
  • Planned and executed both Technical and Functional Tests on new developments
  • Involved in different stages of Projects that include define/prepare requirements document, Estimate and prepare proposal
  • Developed Programs/Process to Document the existing data flow and process flow that could also contribute to adopt better development process for future
  • Identified and Suggested many ideas to document and improve the project development and document process
  • Provided efficient and appropriate solutions by analyzing and categorizing the issues
  • Provided the Estimates for all enhancements or fixes and follow-up until the completion of the task
  • Collected requirements from users, Enhanced the existing models for fixing issues, performance and improving coding according to the reporting and data loading requirements. Worked with teams to discuss/Review technical specifications and functional requirements and get the right approval.
  • Created Data Source, Transformations, DTP, Different type DSOs, Infocubes, Multi-providers, Queries, Open Hub, and managed data loads into InfoProviders via Process Chains.
  • Worked Logistic Cockpit - enhancements and data extraction
  • Solutions provided are being used by more than 1000 users worldwide
  • Employed user exits to achieve the enhanced functionality.
  • Managed, maintained and monitored the data load processes
  • Created Reports in BeX Analyser and Business Objects
  • The modelling was developed to be efficiently Integrated with Reports/Dashboard in BO (Business objects) and Lumira
  • Used JIRA and Service now to track tasks and log/monitor issues respectively

Confidential, Irving, Texas

Environment: SAP ECC6.0 and BI 7.0 on Oracle/Unix

Lead SAP Developer/Analyst/Configurator/Solution Architect

Responsibilities:

  • Developed Solns Financial Planning and Forecasting project using SAP BW/IP
  • Developed/enhanced extractors as per the requirement
  • Prepared the necessary COST Benefit Analysis Document to get the Management Approval for all Change Requests/Enhancements requested
  • Visualized and developed many reporting solutions as per the customer requirement
  • Presented the solutions to the business users and the management explain in details the benefits and strategy to implement the changes
  • Developed the necessary SOWs as per the solutions for new funding
  • Worked on multiple tasks/projects at any point in time
  • Lead Architect for Various Interfaces …including the data flow out of SAP and posting/updating various transactions for incoming data into SAP
  • Devised and maintained Coding, Documentation and Change Control Standards
  • Working/Negotiating a solution to the Gaps created by the Business Requirement and Standard SAP Features available
  • Planned, Designed, Estimated, Developed, Prepared Test/QA Scripts, Helped Test them with Users and prepared them to be moved to production.
  • Designed, Developed and Maintained various interfaces including updating the different programs, scheduling jobs, monitoring, EDI Solutions and trouble shooting
  • Collected requirements from users and Modeled data targets according to the reporting and Interface requirements. Worked with teams to discuss/review technical specifications and functional requirements and get the right approval.
  • Employed user exits to achieve the enhanced functionality.
  • Using different Reporting tools like SQL Tool and Report writer to develop Reports as per the user requirements.
  • Worked on Material BOM, Maintaining the material master and working on Costing Sheet for Manufacturing items
  • Analyzed the requirements, Designed and Developed COST VARIANCE Report for all manufactured parts to identify cost/process improvements
  • Developed lots of OOPs ABAP, ALV Reports and many Dialog Program changes

Hire Now