We provide IT Staff Augmentation Services!

Sr. Consultant Bi Resume

0/5 (Submit Your Rating)

San, FranciscO

SUMMARY:

  • Primary expertise is implementation of DW and Analytics solutions for large enterprise clients. Played an instrumental role in deciding DW road map, strategy and have excellent hands on expertise with various DW and analytics tools such as SAP BW, HANA, Business Objects, Tableau, and Teradata.
  • More than 15 years of professional experience in Design, Development and Implementation of Business Applications including 12 years of DW/BI experience.
  • Expertise in Product Analysis, Requirement Analysis, GAP Analysis and excellent technical documentation skills.
  • Excellent business understanding skills with deep technical expertise in DW implementation and has worked on all major functional areas of ERP, CRM, Retail, Finance as source systems like SAP (SD, MM, Purchasing, SCM, HR, RE - FX, PBF, APO), SAS, ESSBASE, RAYMARK, ARHICBUS.
  • Has an excellent experience in columnar DW, in memory database and ETL tools.
  • Has good hands on experience in enterprise web strategies, web applications integrations and defining end to end test methodologies
  • Working knowledge of oData Services, Fiori, Core Data Services.
  • Other PM/QA/Process tools like HPQC, Service Now, MS Project and SharePoint.DW/BI responsibilities / expertise
  • Gathering Business Requirements, Gap analysis, Functional Specifications, Technical Specifications, Business Blueprint finalization and sign off.
  • Architected and designed Hybrid BI Solutions to meet business needs with SAP, Teradata & Oracle.
  • Excellent technical skills in columnar and in memory database technologies and has worked at architect capacity on SAP HANA, Teradata & Oracle.
  • Excellent ABAP & SQL expertise and utilized in multiple DW project solutions.
  • Programming/Scripting skills in ABAP, JavaScript, Python, HTML5, SQL, Open SQL
  • Excellent data model skills, especially considering large DW implementations needs, scalability considerations while design implementations.
  • Excellent in ETL design implementation, performance considerations for data load activities for tools like SAP BW & Data Services.
  • Excellent knowledge in reporting & analytical tools like SAP Business Objects, Tableau for implementation of reporting needs at various levels in an organization. Has worked on multiple reporting needs such as tabular reports, Dashboards, interactive reports and report publications on enterprise portals & Adhoc reporting skills for executive management.
  • Excellent Data Blending skills from multiple sources like SAP, Oracle, Teradata, and Social Media using Data blending tools like Alteryx.
  • Has excellent skills in analytics integrations with web technologies and mobile applications
  • Has worked on data extraction needs and design implementations such as near real time and real time data acquisitions using various data replications tools

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Sr. Consultant BI

Environment: ECC, BW 7.3, 7.4(BW on Hana), Business Objects, BODS, Teradata, Alteryx, Tableau

Responsibilities:

  • Lead BW/HANA 7.4 to 7.5 upgrade. Creating project plan, co-ordination between Basis, DBA, SAP & Non-SAP application teams, Users, Integration & Regression testing strategy.
  • Designed end-to-end DW solution to migrate legacy systems into SAP BW for Demand & Supply Planning. Integration of SAP & Legacy Planning data into SAP HANA.
  • Designed & developed Calculation Views, Scripted Calculation views in Hana. Designed & developed Advance DSO’s, Composite providers. Designed data models based on existing Teradata views & tables. Extracted data using BODS. Generated TDE extracts for Tableau.
  • Designed & Developed Semantic Teradata views on existing base tables & views to extract data for demand planning into SAP HANA using BODS
  • Worked on globalization of planning & master data for Demand, Shipment, POS & Open Orders data from multiple non-sap systems into SAP BW/HANA
  • Analysis, design implementation of end to end data flows using ETL, including data load strategies, time window analysis and system parallel processing
  • Has played key role in deciding hybrid system model design and implementation
  • Bex & AO reports on top of Composite providers, Hana views.Worked extensively on developing & publishing Analysis for Office reports & was involved end user .

Confidential

Lead SAP BW/BI Consultant

Environment: ECC 6.0, BW 7.3

Responsibilities:

  • Worked as Lead SAP BW consultant for assessment project for BW COPA, OTC implementation & overall BW optimization
  • Review technical configuration & Reporting pain points and approach recommendation
  • Review end-to-end ETL and performance issues classification
  • Review DW Data Model, Business Content and document proposal
  • Review Report Security, data security model and suggest simplifications
  • Review Overall BW Archiving Strategy
  • Review Batch jobs scheduling and decide extraction strategy.

We'd love your feedback!