SUMMARY

• To serve an organization which provides me opportunities to reach and exhibit best of my abilities, to grow with teh job and to enlarge my sphere of activity
• Seasoned professional with 10+ years of experience in SAP BW/BI&BO, SAP HANA and IS Banking with strong SAP project management, delivery and consulting experience in BI/BO.
• Data - Modeling, Data Extraction and Reporting with BEX - Designed data model with LSA and LSA++ architecture.
• Functional Module Extraction, User exits, Customer exits, Routines and Enhancements - Extraction methods such as from flat file, LO Cockpit, Business Content extraction, Generic Extraction and DB Connect.
• BW performance tuning to improve query and data loading performance.
• Very good working knowledge with Open DSO and advance DSO.
• Web Intelligence reports from sources like universe and SAP Bex queries.
• Business Objects - Queries, Drill Down, Cross Tab, Variables, Break, Alerter, Dash Boards, Prompts.
• Designing and developing dashboards using Business Objects Xecelsius ( Dashboard Designer).
• Analysis for Microsoft Excel 2.0 and trained users on data analysis.
• Created Visualization using SAP Lumira and trained business users on teh tool.
• Experience in Creating Dashboard using SAP Design studio.
• SAP HANA Data Modeling, Extraction and Data Administration.
• Creating various types of views - Attribute view, Analytic View and Calculation views to provide real time analytics to teh user
• Developed Predictive analytics to find customer remake ratio for teh products Sold.
• Developed Procedures for Developing Analytical equations for Predictive Analytics.
• Worked on Calculation views using SQL script for complex logic interpretation.
• Developed BI Solution strategies considering business needs future scalability requirements
• Expertise in Project Design, Estimate, Analysis, Review and Testing phases of lifecycle implementation
• Experience in defining and planning Go-Live activities - preparing timelines for data loading and defining performance improvement techniques to reduce heavy load on to teh system
• Extensive customer fronting exposure with strengths in arriving at-defining implementable business requirements
• Building SAP HANA practice within teh company to make sure for better service offering form teh company.
• Build POC’s as part of SAP HANA competency.
• Expertise in SAP HANA data modelling and Data replication.
• Developed complex models using advanced data modelling techniques.
• Have been part of building partnership with hardware vendors for SAP HANA hardware support.
• Developed strong SAP HANA deck for teh competency.

PROFESSIONAL EXPERIENCE

Confidential

Solution Consultant

Responsibilities:

• Designed and developed implementation strategies for teh Project.
• Streamline teh existing architecture and preparing project plan for teh execution.
• Preparing best practice, governance and strategy documents.
• LSA architecture design prepared and implemented for across all modules.
• SAP BI/BO Project implementation Best Practices and Road Map for teh future.
• Lead teh business requirements phase, performed gap analysis with respect to teh data model needs and available business content
• Prepared necessary documentation on Blue print, data model, data flow diagrams, Technical design and specifications.
• Created Dashboards in SAP design studio for Sales Order and Billing areas.
• Involved in BW on HANA upgrade from BW7.3 to BW7.4 on HANA.
• Technical Architecture design for SAP HANA Data provisioning using SAP LT Replication Server.
• Extensively worked on SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in developing predictive analytics for finding best possible production line groupings to teh customer.
• Designed Predictive model for finding Quality issues with teh product me.e. finding remake ratio.
• Created Procedures for developing predictive scenario, also developed calculation views using SQL.
• Designed Predictive model for finding Quality issues with teh product me.e. finding remake ratio.
• Created Analytical Privileges to give relevant authorization to access data based on their division.
• Created Excellent Visualization for teh Customer Analytics for Product Quality using Lumira.
• Trained Quality team and DSM on SAP Lumira.

Confidential

Principle Consultant

Responsibilities:

• Developed implementation plan for Project execution.
• Coordinating with Clients/Stake-holders in gathering business requirements, designing teh framework for Demand Planning performance management.
• Gathering end-user requirements for reports, scorecards, dashboards in implementing KPI's (Key Performance Indicators) and operational/ad-hoc reports.
• Developed HLD according to teh Business Requirement and Developed Data models with LSA.
• Developed Report using Web Intelligence and KPI’s using Dashboard Designer.

Confidential

Principle Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline teh proposed solution.
• Analyzed teh business requirements, performed gap analysis with respect to teh data model needs and available business content, prepared necessary documentation on Blue print, data model, data flow diagrams, Technical design and specifications.
• Design and developed Dashboards (Xcelsius) with HTML5 front end integration which will be browser friendly.
• Developed Dashboard related Contacts, Invoices and Major KPI’s related to Vessel Operations and Services.
• Created generic extraction according to teh client requirement.
• Extracted Date from 3rd Party system using DB Connect.
• Followed best practices to implement Marine Business Intelligence System and in creating user interface.
• Created Custom Cubes, ODS Objects and verified teh same for teh data consistency.
• Created Transient info providers based on HANA and Virtual providers based on HANA models.
• Prepared user training documents and delivered teh report navigation training for teh users.
• Detailed Reports are provided to Business using Web Intelligence and dis Can Navigated from teh KPI’s dashboard.
• Defined and Developed Operational KPI’s related to Marine Services such as Diving, Rig Move, Pier Access, Vessel Activities, Vessel Operations using dashboard designer.
• Followed Layered approach to create data model in teh SAP BI system.
• Prepared Role Matrix for teh User based on requirement.
• SAP HANA Pilot implementation for Marine Landscape:
• SAP HANA Pilot implementation for Marine Landscape.
• Performed Data Provisioning and using SAP LT Replication Server (SLT).
• Created Attribute View, Analytic View, and Calculation View according to teh reporting requirements.
• Created data models using Calculation views and using SQL Scripts.
• Created Data sets for reporting needs and negating users through Business Explorer.
• Developed reports in Business Objects Web Intelligence for Vessel Operations.
• Maintained user profiles for teh relevant business Areas.

Confidential

Principle Consultant

Responsibilities:

• Streamlining teh existing reporting system to give optimum performance.
• RIA development and design with flex application.
• Leveraging existing flex design to Confidential Standards.

Confidential

Team Lead

Responsibilities:

• Improved Performance of teh reports by defining aggregates, Partitions and using other BW performance techniques.
• Automate Daily loads in teh BI system by creating process chains and scheduled them on daily basis.
• Worked with FI module and creating reports in teh areas of AR and AP.
• Played a key role in teh project for teh smooth delivery.
• Created Web Intelligence documents using teh features like User Response, drill options, alerts, data purge, breaks, sections, variables and formulas
• As per client requirements generate teh reports in teh form of Table, Matrix, and Charts
• Created reports containing all teh information regarding teh material, distributors and retailers for drill downs
• Created Reports to display Purchase Orders by teh Vendor, Sales Overview, and Inventory Overview over given period of time using Webi.
• Performed unit testing, system integration testing, and user acceptance testing at various levels.
• Developed Visualizations using Xcelsius that displays information on regional wise sales Vs Monthly, weekly, quarterly and yearly.
• Developed Visualizations that talks about Account Receivables Vs Account Payables and further to see teh same in plant wise.

Confidential

Team Lead

Responsibilities:

• Managed an implementation of SAP BI solution and data migration. Involved in Business Intelligence planning and landscape design.
• Worked with HR modules Payroll (PY), Personnel Administration (PA), and Organizational Management (OM), Benefits (BN), Time Management (TM) and for LMS.
• Defined Scalable Architecture date model for better maintenance and performance.
• Developed implementation methodology to match with teh client needs and teh timelines for smooth delivery.
• Develop detailed design and functional specification documents and technical specification documents for teh business processes identified
• Performed unit testing for teh all teh BI development before sending it for User Acceptance Testing.
• Worked with Change Management team to prepare usual manuals and training material.
• Extended post-go live support and Resolved all teh issues raised.

Confidential

Consultant

Responsibilities:

• Created new data targets for teh new financial year and doing changes as per teh client requirement.
• Changing teh existing queries for teh current year as per requirements of teh client.
• Involved in transporting teh developed objects.
• Involved in creating of CO-PA data sources and getting data to BW.
• Involved in FI extractions.
• Worked extensively in designing of process chains for various data loads.
• Involved in enhancing extractors and creating generic data sources.
• Involved in writing start routine as per teh requirement.
• Involved in teh Data load monitoring using teh Process Chain technology as well as analyzing teh data load failure issues.

Confidential

Associate Consultant

Responsibilities:

• FDB and its architecture
• Data modeling - FDB Objects.
• Transferring data (in flat form) from FDB Primary objects to teh analyzers.
• Data storage using ODS and Info sets.
• Defining Primary and Secondary data sources for teh data retrieval by making teh FDB data available for teh analyzers.
• Functionality of teh SAP Basel II solution
• Credit Risk Analyzer - Multiple approaches for capital requirements.

Confidential

Sr.Consultant

Responsibilities:

• Extracted teh transaction data by LO Cockpit from R/3 to BI by maintaining teh extract structures, maintaining data sources, replicating teh data Sources into BI.
• Developed RRI to drill down to teh Item level data from teh Header report and hence to teh schedule lines in teh Sales Order Analysis report.
• Involved in transporting teh developed objects for teh Dev environment to QA and hence to teh Production environments in BI system.
• Involved In teh designing of Technical Documentation.
• Worked extensively in designing of process chains for various data loads.
• Extracted teh data using Generic Extractor.
• Involved in data source enhancements.
• Worked in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Exceptions, and Conditions.
• Involved in teh Data load monitoring using teh Process Chain technology as well as analyzing teh data load failure issues.

Confidential

BW Consultant

Responsibilities:

• Designed & Developed custom Data Sources, Info Sources, Info Cubes and ODS as per teh requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Developed data loading strategies for master data, transactional data and delta uploads and automated teh BW loads with teh Process Chains.
• Extracted and loaded data from SAP R/3 into Order Analysis and Billing Info Cubes using teh LO Cockpit mechanism (Sales and Billing Applications)
• Created Multi provider on Billing and Accounts Receivable Infocube to assist teh user in providing with appropriate Billing and AR Invoices summary data.
• Developed a report in teh area of AR Invoice and provided teh user with RRI to drill down from teh Invoice Number to teh customer Sales and Billing Information with different slabs according to Due date.
• Developed Formula variables using teh Replacement path for summarizing teh gross weight (which is maintained as an attribute) of a Material.
• Generated reports with charts, graphs for teh queries and maintained workbook.