We provide IT Staff Augmentation Services!

Sr. Sap Bi/bw/hana Consultant Resume

Fairfax, VA

SUMMARY:

  • Over 16+ years of full life cycle implementations experience in SAP BW, BO, HANA.
  • Over 24 years of Information Technology experience in requirements gathering, analysis, design, development, testing, documenting and implementation of business applications
  • Extensively involved in Public Sector, Manufacturing, Bio - tech, Health Insurance and Banking applications
  • Strong analytical, communication, interpersonal skills and able to adapt quickly to new technologies.
  • Highly successful in managing multiple projects simultaneously.
  • HANA modeling using Attribute View, Analytic View, Calculation View and SQL Scripting
  • InfoProviders design, Datasources, Transformations, DTP’s, InfoSources, Creating Update rules, Transfer rules, InfoSets, Aggregates and Process Chains.
  • Extensively worked on the SAP upgrades from BI 7.0 to BI 7.3 and also from 3.5 to 7.0
  • Extensive experience in activating and customizing LO Cockpit extraction (SD, MM (IM, Purchasing), PP, QM), Timestamp extractors FI AP, FI AR, FI GL, COPA and also Custom Extraction. Also extracted data from non-SAP systems using DB Connect, UD Connect.
  • Used ABAP/4 extensively in Start routine, end routine, transfer, update routines, transformations and also for enhancing the BI Extractors.
  • BEx Analyzer, BEx Query Designer, Web Application Designer (WAD), Web analyzer, RKFs, CKFs, Variables, created custom queries using Conditions, Exceptions, Workbooks, Query views, Customer exits and RRI’s.
  • Worked on SAP BusinessObjects (SAP BOBJ), Data Federator, Universe designer, IDT, UDT, Webi, Crystal Reports, dashboards using Xcelsius, Design Studio, Lumira, SDK Custom Components
  • Experienced in distributing queries using Information Broadcasting
  • BW operations - Data load management, event processing, experience in automating dataloads using Process Chains, monitoring the process chains, data loads (Full/Delta), Aggregates and BW Transports.
  • Experienced in Data Load Performance Tuning and Query Performance Tuning by using Partitioning, Indexing, DB Statistics, Number range Buffering, SQL TRACE and RSRT.
  • Played major role in transforming business requirements into technical/architecture design and working with diversified teams
  • Implemented ASAP Methodology.
  • Extensive hands-on experience in project proposals and project preparation, blueprinting, Proof of Concept, designing, developing, testing, user training and supporting BI system.
  • Executing design reviews, establish standards for the designs and naming conventions etc.

TECHNICAL SKILLS:

SAP: SAP HANA, BI 7.3, SAP BI 7.x, BW 3.5/3.X, ECC 6.0, R/3 4.6C

Reporting Tools: BO 4.1 tools - Lumira 2.1, Design Studio 1.6, IDT, UDT, Webi, Crystal Reports, BEx Query Designer, BEx Analyzer, Web Application Designer WAD

Languages: ABAP, C, SQL, VS COBOL II, JCL, EZTrieve Plus

Databases: HANA, Oracle, HDB, DB2, SQL Server 2014

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Sr. SAP BI/BW/HANA Consultant

Responsibilities:

  • Lead efforts with internal customers to analyze and translate business requirements and functional specifications into technical specifications, created data flow diagrams and organized the design review meetings with Confidential sustainment team.
  • Created Attribute Views, Analytic Views, Calculation Views and SQL Scripting in HANA
  • Created HANA Calculation Views to access data stored in Hadoop using SDA.
  • Used SAP VORA to archive cold data to Hadoop(HDFS), created data models in VORA
  • Worked on SAP BusinessObjects (SAP BOBJ) reporting using UDT, IDT, Webi, Crystal Reports and dashborads in Xcelsius, Design Studio 1.6 and Lumira Designer and Discovery
  • Created Custom Components in JAVA SDK needed for the Design Studio dashboards
  • Created BO relational universes using Data Federator to report SAP and Non-SAP data in Webi
  • Developed OLAP connection to SAP BW and BusinessObjects to generate OLAP Universe
  • Created SAP BEx queries and configured them to BO universe.
  • Implemented the data extraction process on BI 7. 4 and BI 7.x that includes enhancing Extractors, user exits using ABAP in ECC.
  • Created Multoproviders, InfoCubes, DSOs, Transformations, Start routines, End routines, InfoPackages, DTPs and Process chains.
  • Transforming data to consolidate, cleanse and integrate data in Rules, Routines and Customer Exits
  • Developed complex query definitions involving variables with replacement path, exception aggregations, conditions and custom exits using ABAP, CKF’s, RKF’s using the query designer.
  • Extensively worked in handling ECC isolation activities for LO cockpit - cleaning up Delta loads, executing setup jobs to fill the cluster tables, make sure the data loads to BI, compress InfoCubes if needed (Inventory cube) and resume Process Chains to normal schedule.
  • Involved in incidents regarding extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
  • Extensive experience in ETL process with SAP and non-SAP source systems.
  • Extensively worked on Performance Optimization of ETL, Cubes and Queries
  • Transport Organizer - maintained transport throughout BI landscape, coordinated Cutover activities and transport backfills.
  • Installed Business Content in SAP BI and ECC Systems

Confidential, WI

Sr. SAP BI/BW Consultant/Lead Developer

Responsibilities:

  • Defined the scope for FI, MM, IM, PP, SD, QM modules and activated the Business Content Datasources in ECC and BI Infrastructure, Reports.
  • Performed requirements gathering, GAP analysis, developed functional and technical specifications for various custom report including Daily Metrics, On time delivery and Goods movement reports
  • Implemented the data extraction process on BI 7.0 that includes activating business content, enhancing Extractors, user exits using ABAP in ECC.
  • Created InfoCubes, DSOs, transformations, Start routines, End routines (in ABAP), InfoPackages, DTPs and Process chains.
  • Extensively worked on LO Cockpit data initialization activities.
  • Developed complex query definitions involving variables with replacement path and custom exits using ABAP, CKF’s, RKF’s using the query designer.
  • Participated in Architecture design and design review sessions
  • Distributed data from BI system to Database tables and File systems using Open Hub Destinations (Infospokes)
  • Worked on SAP BusinessObjects (SAP BOBJ) reporting using Universe designer, Webi, dashboards using Xcelsius.

Confidential, St. Louis, MO

Sr. SAP BI/BW Consultant/Lead Developer

Responsibilities:

  • Defined the scope for FI, MM, IM, PP, SD, TM, QM and BPM modules and activated the Business Content Datasources in ECC and BI Infrastructure, Reports.
  • Lead efforts with internal customers to analyze and translate business requirements and functional specifications into technical specifications, data flow diagrams and data models for Daily Sales Analysis, Risky Inventory, Transportation, Workflow, Customer Service reports
  • Implemented the data extraction process on BI 7.0 that includes enhancing Extractors, user exits using ABAP in ECC.
  • Created InfoCubes, DSOs, transformations, Start routines, End routines, InfoPackages, DTPs and Process chains.
  • Worked on SAP BusinessObjects (SAP BOBJ) reporting using Universe designer, Webi reports, dashboards using Xcelsius.
  • Created SAP BEx queries and configured them to BOBJ universe
  • Developed OLAP connection to SAP BI and BusinessObjects to generate OLAP Universe
  • Created DSO to handle UOM conversions utilizing the new BI 7.0 features.
  • Created roles, assigning users to access the data on various levels of detail using SAP BI Security
  • Developed complex query definitions involving variables with replacement path, exception aggregations, conditions and custom exits using ABAP, CKF’s, RKF’s using the query designer. Created the RRI reports (jump queries/ drill-downs) by setting up the sender/receiver parameters.
  • Maintained Aggregates, Rollup and Compressed InfoCubes as part of the InfoCube Management.
  • Extensively worked in handling ECC isolation activities for LO cockpit - cleaning up Delta loads, executing setup jobs to fill the cluster tables, make sure the data loads to BI, compress InfoCubes if needed (Inventory cube) and resume Process Chains to normal schedule.
  • Resolved Query Performance issues using transactions such as RSRT and RSRTRACE.
  • Involved in incidents regarding extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages, Maintaining Work History for all the incidents in Footprints.
  • Extensively worked on new Inventory Management Cubes in BI 7.0, communicated with SAP to resolve issues with IM cubes.
  • Extensive experience in ETL process with SAP and non-SAP source systems
  • Extensively worked on Performance Optimization of ETL, Cubes and Queries
  • Transport Organizer - maintained transport throughout BI landscape.
  • Conducted training for end users and developed business process documentation
  • Experience in extracting data from multiple source systems to BI
  • Visualized the project beyond scope, proposed the best possible BI solution for now and the future phases to stake holders and higher management

Confidential, St. Louis, MO

Sr.SAP BW/BI Consultant/Lead Developer

Responsibilities:

  • Performed requirements gathering, GAP analysis, developed functional and technical specifications for LAS Seed Allocation, DSR Migration to BI, Seminis Integration
  • Implemented the data extraction process on BI 7.0 that includes activating Business content, enhancing data sources and creating Infopackages and DTPs to load data.
  • Extensively worked on LO Cockpit data initialization activities.
  • Developed complex query definitions involving variables with replacement path and custom exits, CKF’s, RKF’s using the query designer.
  • Involved in upgrading BW 3.5 landscape to BI 7.0.
  • Participated in Architecture design and design review sessions
  • Distributed data from BI system to Database tables and File systems using Open Hub Destinations (Infospokes) with XI/PI integration
  • Extensively worked on creating prototypes/PoCs (Proof of Concept) for various projects
  • Reviewed the existing architecture and proposed feasible solution where data loads were failing frequently.

Confidential, Boston

Sr.SAP BW Consultant

Responsibilities:

  • Worked on Sales Pricing, Sales Statistics and Inventory Management Info Providers.
  • Writing ABAP code for user exits, transfer rules, update rules, and start routines
  • Created Generic Extractor using customer defined tables and subsequently loaded data into BW
  • Scheduled and monitored periodic data loads from R/3 to BW and fixed failed loads.
  • Performing tuning activities, including memory handling issues for bulk loads
  • Configured the use of RKF, variables, exceptions and CKF in BEx queries.

Confidential

SAP BW Consultant

Resposiblities:

  • Data modelling activities in designing and creating InfoCubes, Infosets, MultiProviders
  • OLTP data extraction from SAP R/3 using LO Cockpit, Generic Extractors and Flat file systems
  • Transforming data to consolidate, cleanse, and integrate in Rules, Routines and Customer Exits
  • Extensively used BEx Analyzer to create complex queries
  • Coordinated with off-shore team and guided them in developing and testing the objects.

Confidential

SAP BW Consultant

Responsibilities:

  • Designed and created custom InfoCubes, activated the Standard Business Content objects to extract the data from R/3.
  • Created Info Sources, defined Transfer rules, Update rules.
  • Scheduled Info Packages for loading data and monitored the loads.
  • Created queries using BEx Query Designer

Confidential

Sr.Programmer/Analyst

Responsibilities:

  • Worked on Customer Interface Daily Processing System, Electronic Bill Payment Process ( Confidential ), Under Writing Reporting Database (UWDB).
  • Responsible for crating project Vision and Scope document, use cases. Participated in user meetings and prepared project time estimates.
  • Also, designed subscriber forecast analysis.
  • Coordinated with offshore team in several projects.
  • Created play scripts, restore and recovery procedures for Disaster Recovery.

Confidential

Sr. Programmer/ Analyst

Responsibilities:

  • Confidential System provides complete audit information on cash amounts, policy billing, premium details, service charges accessed, interest rates etc.
  • Responsible for analysis, design, development and testing of Confidential System.
  • Also, created system flow documents and involved in production support.

Hire Now