We provide IT Staff Augmentation Services!

Sap Bi/bw/hana/bods Senior Consultant Resume

New Jersey, UsA

SUMMARY

  • IT Industry experience of 10+ years with 8 years of experience in SAP BI/BW, BW on HANA, Business Objects, Hana Studio, SAP BODS and Project Management.
  • Worked at different geographies with Global clients like Bose, Mitsubishi, Shell Petroleum and Air Canada.
  • Having strong Global experience after working in various parts of teh world like China, Netherlands, USA, Thailand, India and Japan .
  • Experience on various kind of Projects like Production Solution support and Implementation.
  • Project management and Pre - sales exposure while working with Global clients from Shanghai, China.
  • Results oriented and able to integrate TEMPeffectively into a cross functional team, with full accountability for achieving fixed delivery dates and adhering to strict scope control.
  • Strong experience in teh integration of BODS with SAP modules and Non-SAP data sources .
  • Experience in SAP HANA Data Modeling .
  • Experience in working on Analysis for Office.
  • Having hands-on experience in BPC related activities in BI side like Retraction, SPL data loads.
  • Experience in loading data received in Files from Zyme Solutions into BI side.
  • Experience in extracting data from SAP R/3 using LO Cockpit, FI Extraction, Generic Extraction, data loading using process chains and also extracting data from teh flat files.
  • Involved in creation of Infocubes, DSO’s, InfoSets, MultiProviders, InfoObjects, Hierarchies, Data Sources, DTP’s, Transformations, APD, Start routines, End routines, Expert routines and Function Modules.
  • Experience in various performance tuning techniques like compression, aggregation and partitioning etc.
  • Process Chain Monitoring as well as resolving teh Monitoring issues promptly and analyzing further to get to teh root cause and suggest solutions to eradicate teh issues completely.
  • Extensive experience in utilizing BEx Analyzer, Query Designer.
  • Having experience in working on Crystal Reports, WEBi Reports .
  • Expertise in performing UAT’s and creating Test Scripts.
  • Hands-on expertise in developing reports using Restricted Key Figures,Calculated Key figures, Variables, Filters, Exceptions, conditions using BEx Query Designer.
  • Understanding and practical implementation of Data Modeling concepts of Star Schema, Fact and Dimension Table.
  • Ability to interact with end users, quick learner, proactive and team player with excellent communication, analytical, troubleshooting and interpersonal skills.
  • Ability to work well with Global teams.

TECHNICAL SKILLS

Data Warehousing Tools: SAP BI 7.4;BW on HANA

ERP Packages: ECC 6.0

BI Reporting: BEX Query Designer, BEx Analyzer, Analysis For Office, WEBi

ETL Tool: SAP BODS 4.2, Informatica V8.6

Incident Management Tool: BMC Remedy Mid-Tier 7.6

Change Request Mgmt: CHARM, BMC Remedy Action Request System

Languages/Tools: ABAP,SQL

Environments: Windows (98, NT, 2000, 2003,Vista, Windows 7)

Microsoft Office: Word, Excel, Power-point, Outlook

PROFESSIONAL EXPERIENCE

Confidential, New Jersey,USA

SAP BI/BW/HANA/BODS Senior Consultant

Responsibilities:

  • Interacted with Business Users and Managers in gatheringbusiness/product requirements.
  • Involved in meetings with functional users, to determine teh flat file layouts, data types and naming conventions of teh column and table names.
  • Working as Offshore Lead managing teh Team.
  • Involved in Data mapping for subsequent Reporting.
  • Creating complexJobs, Work Flows, Data Flows, and Scriptsusing variousTransforms to successfully load data from multiple sources into a desired target.
  • Used various Transforms andFunctions in SAP BODS.
  • Developing and modifying changes in data flows according to teh business logic.
  • Analyze teh types of business tools and transforms to be applied.
  • Tuned performance for large data files.
  • Involved in creating views using HANA Studio.
  • Involved in writing teh Unit Test Cases.
  • Scheduling and executing Jobs .
  • Working on creation of Test Scripts and documentation .
  • Responsible for designing, building, testing, and deployingDashboards andWEBi Reports .

Confidential

SAP BI/BW/HANA/BODS Senior Consultant

Responsibilities

  • Involved in Enhancements as well as Support work.
  • Worked extensively in all teh three areas of Extraction, Modeling and Reporting.
  • Worked on various complex issues which required extensive analysis & received Appreciation from Customer.
  • Worked extensively on LO Cockpit extractions and loaded teh data from ECC to BW.
  • Developed Reports using Variables, Filters, calculated key figures, Restricted Key figures, and using Conditions in BEX Query Designer and analyzed in teh BEX analyzer.
  • Performed various Performance tuning techniques (aggregates and Compression) to optimize teh query performance.
  • Worked on Analysis Process Design (APD’s) for correcting teh Inventory Data.
  • Experienced in BPC related activities like taking care of SPL data loads and Retraction.
  • Experienced in process followed to load data from Zyme Solutions into BW using files uploaded on Application Server in BI side.
  • SME(Subject Matter Expert) for Inventory related Problems .
  • Monitoring teh Process chains. Maintenance of Monitoring Tracker.
  • Involved in quickly resolving any issues pertaining to Process Chains Critical to Business and analyzing in detail to determine teh root cause.
  • Creating Flat file as per teh requirement and loading Master Data using teh same.
  • Worked extensively on issues pertaining Inventory data loads where in Snapshot design was implemented.
  • Creating Test Scripts, Documentations.
  • Conducted Portal Training for Bose China Users in Bose Shanghai.
  • Worked on Analysis For Office.
  • Created Attribute view, Analytical view and calculated view using HANA Studio.
  • Developed data flows and work flows using BODS.
  • Integrated data from different data sources into SAP HANA using ETL Application .
  • Using Remedy for Incident Management & CHARM for Change Request Management.
  • Working in a Global Team which supports geographies across teh Globe.
  • Working in close communication with Client. Received various Appreciations from Customer.
  • Received “On teh Spot” Award during dis tenure post Appreciations from Customer for outstanding contribution to teh Organization.
  • Received “Star Award” from Customer for resolving a highly complex Inventory issue before it became Business Critical.
  • Received “Star of teh Month” award for leading a Global BI Project which involved all teh changes relating new Fiscal Year. Implementation went very smooth without any issues irrespective of teh barrier of people working in different time zones.
  • Worked as Offshore Lead for all teh implementations performed for Fiscal Year changes in BI which involved creation of new Info providers, queries, Process Chains etc.
  • Received multiple Appreciations from Bose BI Team for efficient delivery of work as well as coordination with various Teams spread across teh Globe.

Confidential

Team Member

Responsibilities:

  • Involved in implementation of SD module
  • Worked on activating teh standard delivered business content in teh form of Info objects, DSO and Info cubes for SD module as per client’s requirement.
  • Worked extensively on LO Cockpit extractions and loaded teh data from ECC to BW.
  • Developed reports using Variables, Filters, calculated key figures, Restricted Key figures, and using Conditions in BEX Query Designer and analyzed in teh BEX analyzer.
  • Performed various Performance tuning techniques (aggregates and Compression) to optimize teh query performance.
  • Scheduling teh process chains in background which makes data loads automatically which included Daily and Monthly.
  • Monitoring teh Process chains

Confidential

Team Member

Environment: Mainframes Z/0S

Languages/Tools: COBOL, JCL, DB2, COOL:GEN, SCLM

Responsibilities:

  • Status reporting
  • Analyzing UER’s
  • Solution design
  • Implementing teh business logic
  • Coordinating with client
  • Coding
  • Unit testing
  • Work Product Inspection of teh work done by Peers
  • Technical Documentation (GTD, UTR etc.)

IBM Canada

Team Member

Responsibilities:

  • Status reporting
  • Analyzing SRs/TRs
  • Solution design
  • Implementing teh business logic
  • Coordinating with client
  • Coding
  • Unit testing and Integration Testing
  • Work Product Inspection of teh work done by Peers
  • Technical Documentation (Maintenance Impact Analysis, Test Case Specification Result etc )

Hire Now