PROFESSIONAL SUMMARY:

• Over 11+ years of extensive professional experience in SAP HANA/ SAP BW/SAP BOBJ with Technical & Functional experience.
• Performed all phases of Project Life Cycle in modules like Supply Chain (SD, MM, PP, PM), Finance (AR, AP, and GL) and CO - PA in multiple projects
• Deep understanding of HANA architecture, SAP BI suite .
• Expertise in creating SAP HANA information models such as HANA views (Attribute, Analytics and Calculation views) with graphical and SQL scripting, procedures
• Experience of working with BW models such as Composite providers, Advanced DSOs and using BW objects exposed as HANA views
• Hands-on knowledge of BOBJ tools such as Universe, Webi and office for analysis
• Good experience in performance tuning of long running reports
• Strong experience with SQL - Join, Union etc.
• SAP HANA and BI/BOBJ Consultant with more than 11 years of SAP consulting experience in Oil and Gas, Manufacturing, High-Tech, Energy, Financial, Sales and Distribution industries.
• Worked on International rollouts for US clients.
• Expertise and Excellent work experience in Business Objects reporting, ETL and Data Warehouse Solutions, SAP Best Practices, ASAP Methodology, Agile methodology, Reporting using SAP tools across multiple SAP systems including SAP HANA, BODS, BOBJ, SAP BW 7.0/ 7.4
• Expertise in HANA modeling using attribute view, analytical view, calculation view, decision tables etc.
• Excellent Experience Working on Business requirements, Solution Proposals, Technical Specifications, Delivering Solutions, and Hyper care.
• Excellent Project Experience translating business challenges/complexities into business requirements, Designing, Developing and Implementing Complex Business Objects, ETL and SAP HANA Solutions.
• Rich Experience Directly Interacting with senior IT Management and Business SPOCs; working across business and technology teams to ensure alignment of Business Needs & Solution Architecture.
• Experienced in activating SAP HANA-Optimized BW content in BW 7.4 for Data modelling.
• Experienced in Working with business Sub process leads and functional consultants to figure out the gaps in functional requirement and proposing BW modeling designs.
• Experienced in Activating Material, Product and Customer Master and loading Text attributes.
• Experienced in designing solutions using BODS from different source systems into BW and HANA.
• Hands on knowledge of creating Transient providers based on Analytic index.
• Experienced in performing Code review, Technical Unit testing (TUT) with architect and client COE’s
• Experienced in creating advanced DSO, Open ODS views and Composite providers using BW modelling tools in eclipse environment.
• Experienced in defining Transport strategy for integrated environments.
• Design of custom objects like InfoObjects, DSOs, InfoCubes, DataSources, InfoSources, Multiproviders, Transformations & Update Rules Start Routines, Aggregates
• Expertise in all aspects of BI: BI data modeling, data staging and Activating & Enhancing standard Business Content, InfoObjects, Hierarchies, DSO, InfoCubes(non Cumulative), Multicubes, Datasources (3,x & 2004s), InfoSources (3.x & 2004s), Infospokes& OpenHub, Transformations and Data Transfer Processing (DTP), Master Data(Time dependent and Time independent)Features like Remodeling & Repartitioning, Administration, Scheduling, Process Chains, Performance Tuning with Aggregates, Infocube Partitioning & Compression, OLAP Cache, secondary Indices, Pre-calculations etc.
• Hands on experience in preparing Database view for source tables for the replication.
• Hands on experience of creating Advanced DSO’s in Eclipse environment.
• Experienced in SAP HANA data provisioning, data modelling using Attribute View, Analytic View, and Calculation View, Decision
• Table, Sequence, and programming including SQL and SQL Script.
• Experienced in SAP HANA administration including managing schemas, data model objects, import/export content, and SAP HANA Security.
• Experienced with data provisioning technologies for HANA such as SLT & BODS.
• Experienced with Currency conversion for user defined currency by input parameter.
• Experienced with Language dependent text to provide text according to logged in user.
• Experienced with User input methods using Input parameters and restrict data using Variables and filters.
• Experienced with different referential join, inner join, left outer join, right outer join, text join and temporal join.
• Hands on experience of creating SLT configuration.
• Experienced with Union, projection, aggregation and join calculation view.
• Experienced with security features in HANA i.e. SQL, Analytical, Package and System privileges.
• Good experience of SLT data provisioning, administration, and its monitoring.
• Hand on experience of HANA XS, ODATA services, CDS Views and web APIs development.
• Knowledge of S4/HANA Finance, Embedded Analytics and Designing Fiori applications.
• Experience with on HANA Application Lifecycle Manager to transport Code from one landscape to another.
• Hands on experience of creating ABAP CDS views and using them as source for developing reporting solutions.
• Experienced with advance replication setting for data filter, table restructuring and table partitioning to handle big data for modelling.
• Knowledge of Integrating Tableau and HANA.
• Successfully implemented 3 Business object implementation projects using BOBJ tools like Dashboards, Xcelsius, Interactive analysis, Webi, explorer, Lumira etc.
• Experienced with requirement gathering, data profiling, and documentation of business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Experienced in SAP Business Object report development using IDT, UDT, Web Intelligence, Design Studio, Dashboard Designer, Analysis, explorer, Excel, QAWS, Query browser, BICS connection and Live office.
• Experienced in SAP Business Object administration like user management, promotion, scheduling, SSO, connection creation, manage services.
• Experienced in SAP ECC table data model and analysis and integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, BODS etc.
• Experienced with web tools like BI Launch pad and CMC (Central Management Console).
• Work exposure in several industries: Healthcare, Pharmaceuticals, Consumer Electronics, High Tech, Manufacturing and Oil & Gas.
• Vast Experience working in manufacturing plants/Client Head Office which enables me with strong business knowledge and understanding of users ‘needs while translating/providing IT solutions to business requirements.
• Experience in SAP-MM,SAP-PP,SAP-SD,SAP-PM, SAP-QM,SAP-FICO,SCM- APO DP& APO-SNP, SAP-CRM and SAP-HCM, Project System and MIS job functions.
• Lead efforts for Design, Development and implementation of Custom Software development and System Integration connecting cross business applications.
• Worked in all Business Area like OTC, MTD, PTP, PTM and RTR.

PROFESSIONAL EXPERIENCE:

Confidential

HANA Analytics Lead

Responsibilities:

• Working as Subject Matter expert for Analytics reporting.
• Worked on SLT with Basis team for configuration of RFC and creating connection.
• Worked on Calculation Views, joins, Unions etc inside HANA Studio.
• Worked on IDT and publishing HANA views on Universe.
• Worked on Currency Conversion for R2R reports.
• Helped Functional team in drafting Functional spec for business requirements.
• Creating High Level design document for Reports and data model.
• Manage delivery for individual reports assigned to developers.
• Design APD/Open Hub for sending file to Non SAP systems from SAP-BW.
• Managing Hyper care for all reports delivered.
• Implemented Inventory Exposure report which gives business idea how much dollar amount is going to be in exposure for future months comparing demand against current inventory.
• Reviewing Functional Specification from different areas O2C/M2D/P2M/R2R/P2P.
• Design reports based on SAP-BOBJ tool like Analysis for OLAP, WebIntelligence Reports and Design Studio

Environment: SAP HANA, SD, QM, MM, FIAR, FIGL, SAP ECC 6.0, BODS,BO WEBI and Dashboard and Design Studio, Pharmaceutical industry.

Confidential, Texas

Lead HANA Analytics- Reporting

Responsibilities:

• Leads requirements gathering sessions with Power Users and End Users for MM and SD analytics requirement.
• Worked on Information Design Tool for creating webi reports from HANA views.
• Created new Package in Content within the Schema.
• Created Calculation views for building Models.
• Implemented Star Join for joining multiple Tables.
• Used projection for restriction of data.
• Created Inner join, Left outer join for building HANA model.
• Used input parameters, input variable, Filters for designing model.
• Implemented Webi reports for SD and MM Analytics.
• Implemented Calculation view with dimension, Calculation view with cube and Calculation view with Star join.
• Created Analysis reports on SAP HANA Analytic Views using MDX.
• Involved in testing phase with business users.

Environment: S/4HANA, HANA Studio, SAP BOBJ 4.2, Tableau

Confidential, New Jersey

SAP BI Senior Consultant

Responsibilities:

• Design reports based on SAP-BOBJ tool like Analysis for OLAP, WebIntelligence Reports and Design Studio etc.
• Involved in Reporting workshop with Business Operation Lead to identify Reporting GAP.
• Worked with
• Helped Functional team in drafting of Functional Specifications.
• Designing the data model and reviewing it with the client.
• Designing Strategy of data from different source system.
• Generated datasources for APO of planning area in APO-DP and APO-SNP.
• Plan workshop to demonstrate SAP BOBJ Reporting (after Implementation) to business users/Functional Owners.
• Designed Model in APD/Open Hub to send data for downstream system.
• Implemented Daily Sales Order which give status of Sales order status from Order to Invoice
• Planned and prepared cut over activities
• Prepared check lists for pre/post go live deployment for multiple rollouts
• Configuration of BOBJ system and setup Transport Strategy for BOBJ via Promotion Management.
• Reviewing Functional Specification from different areas O2C/M2D/P2M/R2R/P2P.
• Designing of data model for APO and build APO reports.
• BEx reports as a data source for Design Studio dashboards.
• Worked in niche Area in BW like APO-DP, APO-SNP, SAP CRM and GTS.
• Implemented Inventory Flow in MM of SAP- BW using datasources like 2LIS 03 BF.
• Creation of APO Dashboards in SAP-BOBJ using Design Studio.
• Design of Publication in BOBJ by sending Webi reports to 500+ Sales Rep.
• Automated the process fromBW to BOBJ so that once process chain finished it triggers publication job in BOBJ.

Environment: SAP BI-7.X, SD, IM, MM, PM, FIAR, FIGL, SAP R/3 ECC 6.0, Business explorer, SAP BOBJ Webi, Analysis for OLAP, Analysis for Office

Confidential, New Jersey

SAP BI Lead

Responsibilities:

• Requirement gathering with business user.
• Design new changes/enhancements and implement it through Confidential Business Process.
• To lead offshore team member and assign work on daily basis.
• Manage cut over activity.
• Implemented Change Request as per Business Requirement such as new queries and Modelling.
• Design outbound interfaces from BW using APD/ Open Hub.
• Design test Cases for SAP-BW reports.
• Design Process chain for reports delivered.
• Worked on MM datasources for inventory and build report on it.
• Activated and Enhanced New GL data sources 0FI GL 10 (Balances) and 0FI GL 14 (Line Items).
• Written DTP Routine to implement Pseudo delta.
• Worked in datasources like 2LIS 04* for SAP-PP.
• Working experience on WAD
• Created Calculated Key figures and Restricted Key figures, Formulas, Variables Etc...

Environment: SAP BI-7.0, SD, IM, MM, FIAR, FIAP, FIGL, SAP R/3 ECC 6.0, Business explorer, WAD.

Confidential, Mounds View, MN

SAP BW Onsite Co-ordinator

Responsibilities:

• Reviewing the Functional Specification and understand the business requirement.
• Implemented Start Routine, Field Routine, End Routine, Expert Routine in transformation
• Created Generic Extraction based on View/Function Module.
• Enhancing data Source by using Exit Program in ABAP.
• Lead the junior team -members in the progressive manner.
• Design Test Cases for all BI deliverables.
• Used User Exit variables in Bex Queries.
• Managed Cutover Activity.
• Worked on datasource like 2LIS 02 ITM and 2LIS 02 SCL etc in SAP- Procurement.
• Worked in SCM APO-Demand Planning and APO-SNP.
• Worked on all kind of SD datasource like 2LIS 11*, 2LIS 12*, 2LIS 13* .
• Created Process chains for all Master data and transaction data loading from acquisition layer to Business Transformation layer and finally to Reporting layer.
• Optimize system by means of compression, aggregation, partitioning, line-item dimension.
• Created new Open Hub for interfaces and used File configuration for setting path in AL11.

Environment: SAP BI 7.0, SD, MM, FI-CO, SAP ECC, Business Explorer, WAD, SAP Business Object

Confidential

SAP BI/BOBJ Senior Consultant

Responsibilities:

• Given training to the BW Core team members and process owners to understand BW Concepts.
• Interact with the senior management and Power Users of Business to understand the business needs.
• SAP Developments in accordance with the Confidential and Client Standard.
• To Mentor core team and lead them in a progressive manner.
• To train the Confidential team members in SAP - BOBJ
• Created Universe design for Power User reporting for Non SAP data.
• Implemented LO Extraction for all LO related datasources.
• Creation of RFC s in SAP-BI source system and ECC Source System in SAP-BI.
• Creation of UD Connect System.
• Installation of Standard data Sources in SAP-ECC and creation of Generic Data Source.
• Modeling of non SAP Source System like Flat File and DB Connect,UD Connect Systems.
• Transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi dimensional design after assessing against the usage of standard SAP delivered Business Content.
• Created Test Case Scenarios.
• Managed Cut Over Activities.
• Design and Implemented6 Xcelsius dashboards end to end from extraction, modelling and Bex Reports.
• Handled SAP-SD, SAP-MM, SAP-PP, SAP-FI, SAP-QMand SAP-COPA module of business reporting/dashboard independently.
• Handled SAP-BI Security of Dashboards by using Analysis Authorization.
• Design of Process Chains for the daily updating of data in Dashboards.
• End user training manual.

Environment: SAP BI 7.0, SD, MM, FI-CO, SAP ECC, Business Explorer, WAD, SAP Business Object