We provide IT Staff Augmentation Services!

Sr. Sap Bi Lead/architect Resume

San Jose, CA

SUMMARY

  • Professional experience of 18+yrsyears IT experience which includes 15 years in various roles as SAPBI HANA Performance Lead/Project Manager, BW Architect, Native HANA Architect and BW Analyst involved with Leading the project, design solution, data modeling Worked in different Industries usingCISCO Networks, AFS Retailmodules, Healthcareand different other companies.
  • SAP XSA ( Advanced ) Platform was used cloud foundry for various different types of application development as XSC ( Classic version ) becoming obsolete going forward.
  • Hands on in SQL Scripts, Procedures and SQL calculation views in HANABW 7.4 on HANA: Open ODS view using Hana tables and SAP Hana Live.
  • SAP Analytics on Cloud was primary used for any reporting and as planning tool.
  • Worked on SAP Analytics on Cloud as planning tool.
  • Applications using Integrated planning modules would use SAP Aanalytics On Cloud.
  • Worked as SAP Modeler for designing and developingAttribute/Analytic/Calcualtion views for BI Analytics using Agilemethodology.
  • Used SAP Cloud Platform as an open platform - as-a-service, including in-memorySAP HANAdatabase management system which was used to connectto bothon premisesand cloud-based systems running SAPwith any other third-party softwares withopen standards like Java,JavaScript,Node.jsandCloud Foundry for integration.
  • Successful 04 Full Life Cycle Implementations with Upgrade experience that includes 2 full lifecycle in SAP BW/BI implementations and 02 HANA implementations with HANA and S4/HANA and 01 BW HANAMigration.
  • Optimizing, performance tuning Native HANA, S4 HANA, BW on HANA based on SAPs proven best practices and standard design principles.
  • Expert in Integrating SAP, Non-SAP data to SAP BI, SAP Hana by designing best data provisioning ETL techniques, data flow and reporting solutions with Fine-tuned BW/HANA with ABAP and recommended corrective action.
  • Used SAP PA 2.0( Predictive Analytics 2.0 ) to execute Algorithms like Classification and Regression after verifying the Model correctness and its predictive strength before generating the graphs.
  • Extracted data from New GL functionality for reporting purposes like Parallel Accounting, Online Document Splitting, Real time Integration from CO to FI helps in faster month end/year end activities as it helps saves cost and time.
  • Responsible for refreshed from production, perform tuning the slow running loads and trouble shoot the failed process chains etc ..
  • Worked on HR Payroll modules using standard datasources 0HR PY REC51,0HR PP REC51 and cubes like 0PY C01.
  • BW operations - Data load management, ETL, experience in Scheduling Start Process and Process Chains of Events, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, BW Transports, Aggregates, and Performance Tuning.
  • Worked on reportingfor theAFS modules of PP ( Production Planning ), PM ( Plant Maintenance), MM ( Material Management ) and. QM ( Quanlity Management ), CRM ( Customer Relationship Management ), SD ( Sales Distribution ) modules etc...
  • Customizations - Data Source Enhancements for user specific requirements; Generic Extractors; enhancing the standard extract structures in Logistics Cockpit, User Exists.Data Extractions from Flat Filesfor Master data and Transactional data; transfer/update rules creation; Business Content Activation; Direct and Flexible Staging of Master data.
  • Used tools like VISIO and ERWIN for data modeling purposesand ER diagramsfor demonstrating the finance reporting flow and modelsacross different landscapes.
  • Report Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks. Created Custom Queries using Conditions, Exceptions, Variables and Structures, RRI - Jump queries.
  • Integrate spend data to improve the timeliness and accuracy of the client information,
  • Optimize strategy by performing sourcing and spend what-if simulations
  • Experience building BW interfaces using Informatica and other ETL tools.
  • Experience in activating standard Business Content, extending/enhancing Info Cubes according to the requirements.
  • Running and monitoring processchains for refresh of data loads refresh and perform tuning the data loads..
  • Using ABAP for writing routines like start routines, end routines, expert routines etc.
  • Writing fucntions using ABAP in fucntion builder or ABAP editor.
  • Exceptional ability to quickly master new concepts and technologies. Capable of working in a group as well as independently with excellent communication skills.
  • Used ETL methodologies Oracle Streams and Replication for building BI environments.

TECHNICAL SKILLS

Business Intelligence: SAP BI 7.3/7.0/2004 s, BW-BPS 3.5, 3.1C, 3.0B

OLAP Reporting Tools: SAP Business Explorer (Bex) Analyzer, Bex Browser, WAD.

ERP: SAP ECC 5.0, R/3 4.7, 4.6c (SCM, PS, MM & FI/CO),S/4 HANA, SAP CRM 5.0.

Operating Systems: Windows 98/2000/NT/XP and UNIX.

Programming Languages: ABAP/4, C, C++ and core Java.

DBMS/RDMS: Oracle 8, MS Access.

Internet Tools: HTML, Java Script.

Packages: MS office.

PROFESSIONAL EXPERIENCE

Confidential, San Jose CA

Sr. SAP BI Lead/Architect

Responsibilities:

  • Working on Supply Chain Application called Business Analysis/Analytics Optimization.
  • SAP XSA ( Advanced ) Platform was used cloud foundry for various different types of application development as XSC ( Classic version ) becoming obsolete going forward.
  • SAP XSA plaform used for XSJS application development to consume SAP Native HANA applications.
  • In SAP XSA framework, Applications used Integrate Natïve Hana with ABAP for any changes in existing applications.
  • Working for performance tuning of the slow executing Calcuation views.
  • Using hints and trace files to optimize the calculation views.
  • Reviewing the Data Models and Partitioning Strategies for big tables from performance perspective.
  • Working on Core SAP Native HANA Development procedures to extracted in XSJS frontend Application.
  • Review of Application Data Models from consistency and data scalability point of view.
  • Review of Calculation views from Performance perspective.
  • Responsible for designing the procedures and calling Calculation Views in SAP Native HANA procedures.
  • The application was loaded data on daily basis with ETL tools like Informatica.
  • The schedueling tools like Tidal, Control M were used to scheduled to run the applications.
  • Front End dashboard was build on Angular Java which called SAP Native HANA procedures through XSJS in IDE environment.
  • Tools like BODS and SLT were used to extract data from SAP ECC.
  • Various Supply Chain KPIs were build to enable dashboards for different types of External and Internal Users.
  • Landing pages were designed to extract different KPIs for both External Users like Suppliers, Contract Manufacturers etc.. and Internal users were PM, Manager, Global buyers etc.
  • Data strategies were designed in view the big data practices in Operational Data Provisioning.
  • In Supply Chain methodology, strategies like launching, uploading the rates submitted were part of the application designed.

Confidential, Wichita, KS

Sr. SAP BI Project Architect

Responsibilities:

  • Oversee the development and implementation of optimization models to determine target inventory levels.
  • Create analytical solutions to determine the root cause of holding overstocked and aged inventory and provide specific recommendations for process optimization
  • Develop an optimal resource allocation model to achieve maximum return on investment from a limited purchasing budget
  • Work as a cross-functional lead to develop software services for automated analysis and forecasting
  • Facilitate the integration of sales forecasts, member data, inventory optimization, and space optimization models
  • End to End solution design, Hands on Development, Team Management with Training for Power and End users.
  • Used SAP PA 2.0 ( Predictive Analytics 2.0 ) to execute Algorithms like Classification and Regression after verifying the Model correctness and its predictive strength before generating the graphs.
  • Solution implementation for core functionalities SD. MM, FI/CO, PP, QM, EAM, HR to meet each and every level of Key Metrics for the business need
  • KPI’s build to provide visibility of the performance for decision making such as Sr. VP’s, Directors and Managers
  • Solution build using SAP HANA live views and customized views based on customer demand to meet reporting needs
  • HANA models build with leveraging standard views with customized Calculation views to bring multiple sources of data
  • Business Case development and workshops for HANA Agile data marts and Sales applications
  • Developed advanced SQL Script procedures for integrating SAP and non-SAP data into Unified HANA Model
  • Accomplished all integration via SLT replication, including filters written in ABAP exits on SLT.
  • Performance improvement on modeling tuning the scripts, applying filters with Input Parameters
  • Build models using Consumption, Composite and Basic views
  • Copy and modify CDS views based on business facts using Associations and Annotations

Environment: HANA SP 7,SAP BI 7.3, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 11g, Windows NT/2000

Confidential, Memphis, TN

SAP BW Consultant

Responsibilities:

  • Worked on extracting the Accounts Receivables and QM Source system master data as well as results data from SAP ECC based on HANA.
  • Used HANA Studio for Creating functions and executing queries to get the data.
  • Build Master data hierarchies forthe QM and AP systems on SAP Ver 7.3..
  • Running and monitoring processchains for refresh of data loads refresh and perform tuning the data loads..
  • Worked on assortments and material groups to extract various articles /merchandise hierarchies.
  • Extracted files to be sent on weekly basis to different systems.
  • Worked with functional analysts gather the requirements and worked as per deadlines to complete reports n time.
  • Worked with datasources like 2LIS 05 QE1,2LIS 05 QE2 and 2LIS 05 QE3.
  • Used datasources like 0FI AP 4andstandard ODS andcube like 0FIGL O03and0FIGL C03.
  • Extracted data from New GL functionality for reporting purposes as described next.
  • Using New GL functionality like Parallel Accounting, Online Document Splitting, Real time Integration from CO to FI helps in faster month end/year end activities as it helps saves cost and time.
  • Used CRM modules to implement Sales Orderdatasource0CRM SALES ORDER and enhanced with BADIs to populate the enhanced fields.
  • Writing functions using ABAP in function builder or ABAP editor.
  • Report was to be generated for collecting results in ODS and Cube for reporting purposes.
  • Reports would be printed for all the different tests that would be performed as per the plan associated with that lot.
  • Some reports were generated by combining data from COPA too.
  • AP module was used to track discounts that customers were taking for paying before discount due date but were not paying as promised.
  • Money was to be recovered from such customers for discounts they took even not being eligible.
  • When the results are updated based on the Inspection Lot No and Plan associated with the lot, certain tests were to be performed.
  • Created data models in VISIO and ERWIN for demonstrating and understanding of processes.
  • Writing ABAP code for performing lookups on DSOs and cubes using functions and transformations.
  • Created necessary extractors/cubes/DSO/infoobjects in BI.
  • Created necessary DTP and Transformation for DSO.
  • Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions in BEx 7.x for reporting purposes.
  • Perform Debugging of ABAP code using breakpoints for functions and routines.
  • Refresh the data loads from production to development.
  • Perform tuning the slow running loads etc.. and trouble shoot the failed process chains.
  • Data in development can be refreshed from anywhere from production or QA environments.

Environment: SAP BI 7.3, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 10.2.0.4, Windows NT/2000

Confidential, Mason, Ohio

SAP BW Consultant

Responsibilities:

  • Worked on theAFS retailSAP BWVer 7.3master data hierarchies building interfaces for the planning tools like RPAS from SAP.
  • Build Master data hierarchies for product and location, sales and inventory.
  • Worked on assortments and material groups to extract various articles /merchandise hierarchies.
  • Extracted files to be sent on weekly basis to different systems.
  • Worked with functional analysts gather the requirements and worked as per deadlines to complete reports on time.
  • Worked with datasources like 2LIS 03 BX,BF and UM for stock initialization and material movement.
  • Used ABAP for writing user exits at R3 and routines like start routines, end routines, expert routines etc.
  • Extracted planning data from APO in SAP BW for reporting purposes.
  • Used Aggregates in APO like LORE, MALORE etc.
  • Writing functions using ABAP in function builder or ABAP editor.
  • Writing ABAP code for performing lookups on DSOs and cubes using functions and transformations.
  • Implemented LO modules including extraction for PP ( Production Planning ), PM (Plant Maintenance),Purchase Order, Invoicing, TSDM, Sales Orders, Delivery, Billing, Purchasing and Inventory Management.
  • Created necessary extractors/cubes/DSO/infoobjects in BI.
  • Created necessary DTP and Transformation for DSO.
  • Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions in BEx 7.x for reporting purposes.
  • Perform Debugging of ABAP code using breakpoints for functions and routines.
  • Schedule and performance monitor periodic data loads from SAP R/3 to BI.
  • Created Process Chains to automate the data load and data target administration.
  • Responsible in creating the queries that meet the customer requirements.

Environment: SAP BI 7.3, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 10.2.0.4, Windows NT/2000

Confidential, LakeForest, CA

SAP BW Consultant

Responsibilities:

  • Worked with functional analysts gather the requirements and worked as per deadlines to complete reports on time.
  • Configured and Installed Business Content extractors in various functional areas likeAFS modules of Production planning using different kinds of standard extractors ( 2LIS 04* ) to meet the user requirements.
  • Modified the standard extractors
  • Used ABAP for writing user exits at R3 and routines like start routines, end routines, expert routines etc.
  • Writing functions using ABAP in function builder or ABAP editor.
  • Writing ABAP code for performing lookups on DSOs and cubes using functions and transformations.
  • Implemented LO modules including extraction for PP ( Production Planning ), PM (Plant Maintenance),Purchase Order, Invoicing, TSDM, Sales Orders, Delivery, Billing, Purchasing and Inventory Management.
  • Used PP datasources( like 2LIS 04 PCOMP / MATNR etc ) .. for pulling reports based on the production order ( aufnr ) reports from RESB and Sales orders ( VBAK ) tables, customer group based reports.
  • Used PM ( Plant Maintenance )datasources like 2LIS 17 I03OPER / HDR for extracting workcenter and production orders status(Completed / Planned / Unscheduled / ….) types of reports.
  • Created necessary extractors/cubes/DSO/infoobjects in BI.
  • Created generic extractors for datasources created with views for customizing purposes.
  • Loaded Master data and transaction data through the Process Chains.
  • Created necessary DTP and Transformation for DSO.
  • Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions in BEx 7.x for reporting purposes.
  • Perform Debugging of ABAP code using breakpoints for functions and routines.
  • Developed different Management reports and end-user reports based on the specifications.
  • Schedule and performance monitor periodic data loads from SAP R/3 to BI.
  • Created Process Chains to automate the data load and data target administration.
  • Responsible in creating the queries that meet the customer requirements.

Environment: SAP BI 7.3, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 10.2.0.4, Windows NT/2000

Confidential, Plano Plano,TX

SAP BW Consultant

Responsibilities:

  • Interacted with management and end-users to gather the requirements and conducted GAP analysis.
  • Configured and Installed Business Content extractors in various functional areas like SCMMM and FI/CO to meet the user requirements.
  • Using ABAP for writing routines like start routines, end routines, expert routines etc.
  • Writing fucntions using ABAP in fucntion builder or ABAP editor.
  • Writing ABAP code for performing lookups on DSOs and cubes.
  • Extended Extract Structures/Info Sources based on client requirements using Function Modules & User Exits.
  • Implemented LO Cockpit extraction for Sales Orders, Delivery, Billing, Purchasing and Inventory Management.
  • Used datasources from QM ( Quality Management ) like 2LIS 05*.
  • QM ( Quality Management) module covers quality management tasks, such as quality planning (setup of data for QM tasks), quality inspection, and quality control.
  • Generating reports from datasources for Quality Planning, Inspection, Certificates, Notification and Quality Control which is the combination of specification from inspection planning, results from quality inspections, and quality notifications form the basis for quality control.
  • Writing ABAP code to write user exists to populate the data sources at ECC R/3.
  • Extracted data for various data sources from Purchasing, Material Management, Sales and Distribution from R/3 to BI.
  • Extracted data from different sources systems like flat files and Oracle used DBCONNECT for Oracle Database.
  • Created necessary extractors/cubes/DSO/infoobjects in BI
  • Created Process Chain to load Master Data & Transaction Data from R/3 system to Data Targets
  • Created necessary DTP and Transformation for DSO
  • Extensively Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions.
  • Debugging or toublehshooting ABAP code for functions and routines.
  • Developed different Management reports and end-user reports based on the specifications.
  • Built the Master and transactional process chains and scheduled accordingly to upload the data into Infoproviders with appropriate dependencies.
  • Schedule and performance monitor periodic data loads from SAP R/3 to BI.
  • Created Process Chains to automate the data load and data target administration.
  • Responsible in creating the queries that meet the customer requirements.

Environment: SAP BW 3.5 BI 7, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 9i, Windows NT/2000

Confidential, Orland Park, IL

SAP BW Techno-Functional Consultant

Responsibilities:

  • Involved in the BI implementation for SCM and FI modules
  • Implemented SAP BW for operational and managerial reporting purposes. All global data is collected and consolidated within the BW environment for selected regions.
  • Involved in extraction of Sales data from interface files and SAP R/3 data sources, retrieval of actual R/3 data by creating InfoSources with transfer rules, creating update rules through formula/routines, Infocube, ODS objects, creating InfoPackages, scheduling and monitoring of transaction data upload
  • The Data loads for master data as well as transaction data, is been done extensively with standard and custom defined extractor.
  • Genrated PP DSO and PP cubes, multicubes, multiDSOs for reporting purposes from the datasources like 2LIS 04 * for extracting reports based on the MATNR aggregation/breakage Code and UPCs for the parts.
  • Parrallel loading of data through different infopackages and to the same Data target using process chains to improve the load performance
  • Used Oracle Data Mining ( ODM ) tools for data mining to solve a wide range of business problems..
  • The tool was also used for predictive analytics and data mining (PA/DM).
  • Created necessary extractors/cubes/DSO/infoobjects in BI
  • Created Process Chain to load Master Data & Transaction Data from R/3 system to Data Targets
  • Created necessary DTP and Transformation for DSO
  • Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance
  • Scheduled InfoPackages to load data from DSO Objects (InfoSources), to InfoCubes
  • Worked with Transport organizer to migrate the newly developed queries, process chains to Test client for testing and then migrated to production
  • Extensively used BEX Analyzer to build queries, queries with charts and worksheets to access data from BW data targets to generate reports
  • Extensively used the other reporting functionalities like reporting agent for doing automatic background scheduling of various reports
  • Activation of Standard Business content and its enhancement
  • Develop end user training document as per the design document
  • Provide BW administration functionality in ensuring that the system is efficiently performing and shared across various applications.
  • Used PM ( Plant maintenance ) datsources for reporting on planning / scheduled / unscheduled or unplanned orders etc..
  • Used Business Objects to generate different types of reports from SAP and non SAP data sources.

Environment: SAP BW 3.5 BI 7, SAP R/3 4.7, BEx Query Designer, Web Application Designer, Oracle 9i, Windows NT/2000

Confidential, CA

Senior SAP BI Consultant.

Responsibilities:

  • Extracted data from ECC using standard and custom data sources as per the requirements.
  • Interacted with management and end-users to gather the requirements and conducted GAP analysis.
  • Changed existing 3.x Dataflow to BI 7.0 Data flow by Migrating the Objects.
  • Created Infocubes and DSOs to load data from R/3 and SRM source systems.
  • Extended Extract Structures/Info Sources based on client requirements using Function Modules & User Exits.
  • Created different transformation routines to look up from different tables as per the requirements.
  • Created Transformations and DTPs for data consolidation and cleansing.
  • Developed data loading strategies for master data, transactional data and delta uploads.
  • Created different Finance Reports using Bex Analyzer.
  • Extensively worked in BEx Analyzer for Query designing.
  • Extensively Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions.
  • Built the Master and transactional process chains and scheduled accordingly to upload the data into Infoproviders with appropriate dependencies

Confidential

Senior SAP BI Consultant.

Responsibilities:

  • Interacted with management and end-users to gather the requirements and conducted GAP analysis.
  • Configured and Installed Business Content extractors in various functional areas like SCMMM and FI/CO to meet the user requirements.
  • Extended Extract Structures/Info Sources based on client requirements using Function Modules & User Exits.
  • Implemented LO Cockpit extraction for Sales Orders, Delivery, Billing, Purchasing and Inventory Management
  • Extracted data for various data sources from Purchasing, Material Management, Sales and Distribution, FI-AR, FI-AP and CO-PA data from R/3 to BI.
  • Extracted data from different sources systems like flat files and Oracle used DBCONNECT for Oracle Database.
  • Enhanced new Info Objects to be mapped into InfoSources/Communication structures. Created transfer rules and update rules for data consolidation and cleansing.
  • Extensively worked on Transformations and DTPs.
  • Created DSO objects to stage the data from different data sources and transferred the ODS contents into various data targets and Info Cubes based on the requirement
  • Checked for data consistency and modified the data in PSA before loading them to data targets
  • Built the Master and transactional process chains and scheduled accordingly to upload the data into Infoproviders with appropriate dependencies.
  • Schedule and performance monitor periodic data loads from SAP R/3 to BI.
  • Created Process Chains to automate the data load and data target administration.
  • Responsible in creating the queries that meet the customer requirements.
  • Extensively worked in BEx Analyzer for Query designing.
  • Extensively Used Restricted and Calculated Key Figures, Structures, Variables, Exceptions, and Conditions.
  • Developed different Management reports and end-user reports based on the specifications.
  • Worked with BEx Broadcaster to schedule monthly revenue reports as e-mail to the users
  • Designed Web templates with the web items, Interactive charts, navigational blocks etc. using WAD.

Confidential

Sr. IT Consultant

Responsibilities:

  • Evaluated ERPs like Oracle Applications, BAAN, and MFG-PRO for a manufacturing enterprise.
  • Worked as IT Consultant along with business consultants for evaluating ERPs.
  • Requirement analysis and preparation of system specifications.
  • Creating the ER diagram, logical design for the warehousing database for modules other than Oracle Applications.
  • Creating the Oracle Applications 11i form and non-form functions.
  • Creating the non-multiform, multisession button for the Oracle Sales and Marketing and Oracle HRMS.
  • Managing day to day activities in Oracle Apps 11i monitoring and generating the auditing and statistics reports, backup of the applications etc.
  • Creating the reports for user wise, responsibility wise.
  • Generating the auditing reports for the active users and active responsibilities.
  • Controlling the security of the applications through managing the menu exclusion options.
  • Developed a Customer Relationhip Module (CRM) for keeping the record of the regular customer queries and keep customer updated with regular follow-ups after the material dispatch and its status after till it reaches the destination or warehouse.
  • Separate Replication database was created for the Sales and Forecasting department and MD of the company that was a small database at head office and was always updated regularly with latest data from the plants where production use to be in progress.
  • Replication was done by using the database links to databases at remote sites and established the snapshots on the production database.
  • Designed Data Marts for different departments such as Engineering, Sales, Purchases, Dispatches and MRP and then integrated them together to give complete view of the system to top management which enabled them to take decisions.
  • Established Data Warehouse for management and plant decision support. Developed automated scripts for updating data warehouse every night and to keep inventory, sales and order updates on daily basis.
  • User Administration for the Data Warehouse - User Creation, assigning privileges and monitoring.
  • Used Veritas Net Backup and Recovery modules.
  • Application tuning, Performance Tuning and Optimization.
  • Used SQL Loader to load the data and FTP to transfer the data files.
  • Partitioning disks, creating file systems and recovery of file systems.

Hire Now