We provide IT Staff Augmentation Services!

Sr. Lead Bw/hana Consultant Resume

Naperville, IL

SUMMARY

  • Performance driven professional with over 12 years of experience in SAP HANA/BW/BI with more than three full life cycle implementations.
  • Experienced in the entire Software Development Life Cycle (SDLC) from Requirements Gathering through Implementation and Post Production Maintenance using (ASAP Methodology).
  • Served as SAP HANA SME for HANA implementations and BW on HANA projects.
  • Over 11 years of SAP experience in deploying business analytical solutions in the areas of Order - To-Cash, Forecast to deploy, Procure to pay. Worked with multiple SAP modules like FI, SD, CRM etc.
  • Expert in analysis, design and delivery of complex business requirements to support BI analytics for both batch and real-time data using SAP HANA Studio.
  • Experienced in designing and developing HANA views using graphical, SQL scripts.
  • Data provisioning using ETL Batch loading through BODS and flat files into HANA.
  • Extensive knowledge in Importing BW Models and SAP Landscape Transformation (SLT) into HANA Studio.
  • Primary areas of expertise were focused in the development of BI Modeling, Extraction Transformations, loading, reporting solutions from various modules such as FI/CO, SD, MM and CRM.
  • Experienced in activation of Business Content and enhancements after installing Business Content as per business requirements.
  • Expert on all areas of BI which includes ETL, creating Info packages, Scheduling, Monitoring, Process Chains, BEx- Analyzer, BEx Query and Web Application Designer.
  • Created Generic datasources, table views, and replicating them to BW system.
  • Experienced in BW Performance Tuning: Tuning of Queries by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
  • Extensively used variety of techniques to boost the performance of BEx Query.
  • Extensive knowledge in front-end Business Warehouse, BEx Queries (Calculated key figures, restricted key figures, Structures, free characteristics, formulas, variables, exceptions and conditions).
  • Moderate exposure to routines and Analysis Process Design (APD) and Ad-hoc reports.
  • Experienced in Business Objects - Universe creation, BICS Connections, Information Design Tool (IDT), WEB Intelligence, Crystal Reports, Dashboards, Design Studio and Lumira.
  • Experienced in creating different blocks, prompts, new rules, sections, breaks, filters (global and block level), sorting, ranking, hyperlinks, charts (Pie, Bar etc) and merging reports within WebI.
  • Moderate exposure on Center Management Console and its functionalities such as role level restrictions, columns and rows restrictions.
  • Good exposure on BODS (ETL process), batch loading, importing from different sources into BODS and importing into HANA
  • Strong Production Support experience including Functional Analysis and Technical Troubleshooting at excellent Customer Satisfaction Level.
  • Excellent communication and interpersonal skills, committed to deliver quality work on time and within budget, trusted advisor on technology and business solutions, and a strong believer of customer satisfaction and relationship building.

TECHNICAL SKILLS

SAP HANA: HANA Studio SP10, BW on HANA.

Business Warehouse/Intelligence: SAP BW 3.5, BI 7.0, BI 7.3, 7.4

ERP: SAP R/3 4.6C, 4.7, ECC 6.0DatabaseSQL Server, Oracle, Teradata

SAP Modules: SAP CRM 4.0, FI-CO, SD, SCM, MM and MDM.

Programming Language: ABAP/4 and SQL

Reporting/ETL Tools: Business Explorer (Query DesignerAnalyzer), Web Application Designer (WAD)

SAP: Business Objects - 4.0, 4.1 - WEBIInformation Design Tool (IDT), Crystal ReportsDashboards, Analysis for Office, Design StudioLumina, Business Objects Data Services (BODS)

PROFESSIONAL EXPERIENCE

Confidential, Naperville. IL

Sr. Lead BW/HANA Consultant

Responsibilities:

  • Gathering requirement and GAPS from the stakeholders
  • Creating functional/technical documents based on requirements/GAPS
  • BW on HANA environment
  • Recommend BI Direction, Architecture, and Roadmap to implement Agile EDW on HANA in a Mixed BW/Native scenario
  • Assisting the business with data validations and reports
  • Full end to end enhancement/implementation from non-SAP source systems (JD Edwards, Syspro, Zues, XCalibur) to BW landscape - Phase 1
  • Development of DSO’s and Composite Providers
  • Development of custom extractors in ECC
  • Transporting/migrating developed objects between landscapes
  • Full End to end implementation from Non-SAP source systems to system to BW Landscape
  • Development of DSO’s and Composite Providers
  • Prepared both Functional and Technical documents for development.
  • Full end to end unit testing
  • Publishing reports to Analysis for Office
  • Support activities - monitoring data loads, reports etc.

Environment: SAP BI 7.4, NATIVE HANA SP10, ECC 6.0, SQL server, JDE, Mainframe, Analysis for Office.

Confidential, San Francisco, CA

Sr. Lead BW/HANA Consultant

Responsibilities:

  • Gathering requirement from the business analyst and stakeholders
  • Creating technical specification based on functional design.
  • BW on HANA Environment.
  • Solely responsible for Size Op’s Sales/Inventory developments in HANA.
  • Three regions (LSE/LSA/AMA - each has 2 reports)
  • Base dso’s were built by OTC team
  • Developed SQL Scripts calculation view using legacy system information (Teradata)
  • Data Validation with back end (BW) and developed views before transporting to the QA environment
  • Assisted the business for validation using Analysis for Office
  • Architected and modeled Native Hana Solutions for inventory by exposing HANA tables/views as OData services which are further consumed by the web.
  • Developed Native HANA (New DB) Reports and Views (Attribute Views, Calculation Views, and Analytic Views) on MM, SD, FI, CO, SCM, SRM and CRM.
  • Assisted the PM with meeting minutes and proposed new enhancements to better meet the business needs with relevance to Size Op’s.
  • Virtual Inventory Reservation (VIR) - Full End to end implementation from Source ECC system (SD) to BW modeling to Bex Query to Analysis for Office.
  • Prepared both Functional and Technical documents for development.
  • Development of Custom extractors in ECC - (SD Extractors using views)
  • Transporting of developed objects from ECC - SD to BW
  • Created Master Data and Transaction Dso’s joined with other master data objects such as product master, data master using Composite Provider
  • Usage of end routines, field routines and formulas for certain fields
  • Bex Query was built on top of Composite Provider
  • User Exit variables for certain mandatory fields (which has to be pre-populated)
  • Full end to end unit testing
  • Publishing reports to Analysis for Office

Environment: SAP BI 7.4, Native HANA SP10, ECC 6.0, BO 4.1, BODS, SQL server 2008, Teradata, Tableau, Analysis for Office.

Confidential, Plano, TX

Sr.BI Lead/Production Support

Responsibilities:

  • Conducted and scheduled meetings with business leads and IT team to identify the gaps and assigning them to the appropriate team members.
  • Gathering new business requirement from the stakeholders and put them in proper format to be presented to management and business.
  • Updates/issues on current project are reported on a weekly basis toProject Manager.
  • Organizing all training documents in share point in order for others to easily access the documents.
  • Complete BW support (MDM, FI, OTC), along with monitoring of daily reports and address any known issues to meet the SLA.
  • Developed Ad-hoc reports for higher management through business objects 4.1 in relation to master data management.
  • Provided best practices for HANA Modeling, HANA Native Development, HANA Security, HANA Administration etc.
  • Daily monitoring of the HP Service Manager for tickets and assigning them to the appropriate members along with prioritizing them.

Environment: SAP BI 7.3, HANA SP8, ECC 6.0, BO 4.1, SQL server 2008, Master files and Credit to Collections

Confidential, Pawtucket, RI

SR. HANA/BW/BI Lead Consultant

Responsibilities:

  • Performed functional feasibility analysis and translated the specifications to the offshore team.
  • Assisted the team in terms of training/mentoring and delivery management of status reports.
  • Supervised the assignment of tasks to team members and reported weekly progress to PM/Client.
  • Performed root-cause analysis to determine problems; provided solutions and documented the solutions.
  • Standardized and streamed lined the existing processes for optimal performance with HANA and by working with Data Services to fine tune the work flows and re-design the universes that support WebI and design studio reports.
  • Understand the AS-IS reporting solution in SQL and assisted in architecting an end-to-end solution on HANA modeling.
  • Designed and developed HANA Views (analytic and calculation views) and stored procedures to support the business needs
  • Created reporting and functional users and assigned authorization roles.
  • Demonstrated the value of HANA over the existing infrastructure.
  • Good exposure on Lumira, extracting from HANA studio.
  • Enabled the customer with necessary skills and knowledge to support the HANA platform and models in the production environment.

Environment: SAP HANA, Data Services 4.0, ECC 6.0, BW 7.3 and BO 4.0.

Confidential, Montgomery, AL

Sr. BW/BI Consultant

Responsibilities:

  • Assisted in importing BW models into HANA and mapping the appropriate fields and building reports from HANA.
  • Got exposed to basic BODS extraction and pushing data into HANA.
  • Implementation and maintenance of FI and SD modules.
  • Analyzed requirements and identified the suitable SAP business content objects for SD, FI/CO
  • Installed SAP-delivered infocubes, ODS’s, Multiproviders and other relevant objects to implement the proposed business solution.
  • Implemented ETL with standard defined LO and FI Extractors such as sales order, schedule line delivery, Accounts Payable and Accounts Receivable.
  • Resolution of performance related issues using BW statistics, aggregate/rollup, attribute change run and process chain monitoring.
  • Designed flexible reports using web application designer, query designer and BEx Analyzer, incorporated interactive features such as drill-down, sort and filter, variables, and link to other reports to facilitate data analysis.
  • Developed reports using Query Designer and Business Objects (WebI/Dashboards).
  • Resolved Post-production issues and conducted end user training materials.

Environment: SAP BI 7.0, ECC 6.0 and BO 4,0, HANA

Confidential, Boise, ID

BW/BI Consultant

Responsibilities:

  • Activated standard extractors for the required Application components.
  • Maintenance of the Infocubes, DSO’s, Info objects.
  • Dealt with issues such as DTP failures, Info package failures, and time stamp verifications.
  • DSO activation failures.
  • Roll-ups failure, transformation in-active.
  • Monitored process chains and fixed issue if there was a failure to load.
  • Failure in Drop Index/Compression step.
  • Dealt with transformations failure.
  • Enhancements of fields to extractor (append structure) if needed.

Environment: SAP BI 7.0 & ECC 6.0

Hire Now