SUMMARY:

• 18 years in IT to include almost 14 years of SAP BI/BW/HANA and ten years with Business Objects suite Designer, Information Design Tool, Desktop Intelligence, Web Intelligence, Crystal Reports, Crystal its deployment Xcelsius, InfoView and CMC and administration.
• Experience in implementing Analytics in S/4 HANA Landscape and integration with different system. i.e. Power BI, Matlab, B4HANA and BO.
• Experience in designing and implementing Enterprise Reporting Architectures for large - scale deployments across shared services platforms for Business Objects.
• Translate business requirements into technical requirements in terms of BO Universe and report design.
• Expertise in generating various types of Business Objects reports including Desktop Intelligence reports, Crystal reports and Web Intelligence reports .
• Four years of working experience with HANA modeling Package, Attribute view, Analytic view, Calculation view .Analytic privileges including SLT schema and other schemas.
• Experience with S/4HANA and HANA Cloud Platform .
• Both HANA POC and Implementation experience.
• Knowledge in HANA - Vora.
• Experience with SAP HANA Security including User Management, Roles, and Privileges.
• Experience in HANA Performance Tuning .
• Developed and use HANA Live and accessed standard solution provided for ECC -
• HANA Live for SAP ERP.
• HANA Virtual Model for the HANA Live .Query and Reusable view.
• HANA Live browser to locate and use the standard view for GR/IR.
• HANA Live browser to locate and use the standard BillingDocumentQuery.
• Ability to design Universes from Star Schema (with slowly changing dimensions) and Snow Flake Schema databases/data warehouses.
• Experienced in BI implementation lifecycle i ncludingextraction of SAP LO, FI-SL and non-SAP data into BI server.
• Strong background in Data Management with multiple database technologies to design data models and analytical apps. Experience with SAP ECC table data model and analysis. Definition, design and implementation of SAP SLT replication schemas in SAP HANA.
• Do have experience in SAP HANA enterprise information management (EIM).Do have experience SAP HANA SDI and SAP HANA SDQ.
• Data Administration including managing schemas, data model objects, import/export content o Implementation experience and knowledge of SAP reporting for different functional areas such as Finance, Supply Chain, and Sales.
• Experience handling integration between multiple systems for reporting - SAP ECC, BW, and BOBJ integration.
• Do have experience with BPC.
• Three years’ experience in SAP Business Objects Data Services as well as experience with Information Steward .
• Experience as ABAP/4 Consultant for more than two years with ability to write complex logic in transformation Start routine/End routine using ABAP/4 and Program in ECC.
• Involved in more than 12 End to End Life Cycle implementations of BW 3.x and NW 2004’S BI 7.x including fit/gap analysis.
• BPML, Functional Specifications, Test Case preparation, UAT, and conducting the End User Training .
• 11 Support Projects that include Data modeling, Technical Designing and Development of Custom built BI reporting objects using Extended Star Schema.
• Ability to plan for implementation including sizing and scoping as well as High Availability and Disaster Recovery strategies .
• Six years’ experience in Project Management as a Team Lead, Project Lead, Project Manager, and Lead Solution Architect, within different verticals such as Confidential, Pharmaceuticals, Textile, Telecommunications and Home Appliances.
• Responsibilities also included managing Scope and Budget
• Use of Business Content based on requirements Involved in providing authorizations by creating Roles, Profiles and objects.
• Experienced implementing Business Objects in various domains such as Utilities, Confidential, and Telecom.

TECHNICAL SKILLS:

ERP: HANA,SAP R/3, ECC 5.0, ECC 6..0, 4.6B/4.6C, SAP IS-Telecom, SAP-CRM 5.2, NOW(Textile)

SAP BI/BW/HANA: SAP-BW, SAP NW 2004s BI 7.0, 7.4,BW on HANA,3.5/3.1C/3.0B,BPS(Business Planning and Simulation), IP(Integrated Planning), BW on HANA

Reporting Tools: BEX and Web Reporting, Crystal Reports, Business Objects, Web intelligence, Xcelsius, Lumira, Qlikview

Languages: ABAP/4, C, SQL, PL/SQL

RDBMS: Oracle 10g,9i, 8i, MS-SQL Server, MS Access, HANA

Operating Systems: Windows NT 4.0, 2000, XP, UNIX, LINUX

Other ERP: NOW( used for Textile industry)

EXPERIENCE/PROJECT WORK

Confidential

Lead Solution S/4 HANA Analytics Architect

Responsibilities:

• Working with the Commodity Management/Rick Management team SAP S/4 HANA and Leading CDS development Team.
• Design the Layered Architecture of CDS views and HANA modeling for the different tools.
• Working and leading the CDS view development team on S/4 HANA.
• Design the Data Model for BW on HANA using CDS Views.
• Integrate the Power BI with S/4 HANA.
• Integrate the Metlab system with S/4 HANA.
• Integrate the BOE with S/4 HANA.
• Presenting the demo to developing the CDS views/Real time Analytics.
• Study the already existing reports and transfer/development strategies to the new system.
• Analyze and built the security strategies for the Business/risk team.
• Schedule the job with the redwood and trigger some ad hoc jobs for the go-live support over the weekend.
• Schedule and train ETL development resources including managing and coordinating the activities associated with the future development of the overall strategy of the application area.
• Manage, lead and validate work related to efforts profiling various information systems
• Capture source/target mappings and transformations based on project requirements inclusive of end to end data retention.
• Ensure accuracy & integrity of data through analysis of application coding deliverables, insuring adequate documentation & problem resolution.
• Review and approval of analysis & translation of functional specifications and change requests into technical specifications
• Oversight of project document management of ETL technical system specifications, processes flows, unit tests and results.
• Ensures staff’s support of all ETL jobs for schedules and maintain compliance in development for effective project life cycle.
• Validate and ensure processes are followed for test procedures and coordinated with business analysts and users to resolve all requirement issues and maintain quality.

Confidential

LeadBI / BO / HANA Solution Architect

Responsibilities/Deliverables:

• Worked with Stakeholders and BI Stream to develop the roadmap for the BI 2017-2020.
• Prepare proposal for the different BI products i.e.(HANA Enterprise and HANA-Vora) based on the requirement for the Global BI system.
• Provide the proposal for the Cloud solution (HANA Cloud) HEC based solution.
• Prepare the Plan how Hadoop system used and HANA-Vora will be used for the memory analytics.
• Prepare the proposal for different Visualization tools i.e. Lumira, Qlikview etc.
• Prepare the plan for the Nearline storage in BW 7.4 and how to use the archiving data and used for reporting.
• Prepare the Plan for usages of ODP utilization in SAP BW 7.4.
• Develop the plan for authorization at different level to access the BI data and reporting.
• Defined strategy for multi-source HANA modeling and reporting across SAP and legacy systems.
• Identified reporting requirements and created a blueprint for BI-HANA implementations
• Defined a strategy for multi-source HANA modeling and reporting across SAP and legacy systems.
• Worked on SAP suite on HANA implementation, layout BI / Reporting Strategy and approach on implementing BI solution including combination of standard ECC reports and using various tools provided by HANA Live.
• Evaluated the modeling, integration and additional implementation factors from a HANA perspective.
• Developed reporting using Lumira and Webi and Analysis office.

Environment: HANA - Live, Business Object 4.1, Lumira, ECC on HANA, HANA Enterprise, BODS

Confidential

LeadBI / BO / HANA Solution Architect

Responsibilities/Deliverables:

• Worked with Stakeholders and BI Stream to identify reporting requirements and create a blueprint for BI Solution implementation using a feasibility approach.
• Defined strategy for multi-source HANA modeling and reporting across SAP and legacy systems.
• Laid out BI-HANA Reporting Strategy and Feasibility Approach at Confidential
• Identified reporting requirements and created a blueprint for BI-HANA implementations at Confidential
• Defined a strategy for multi-source HANA modeling and reporting across SAP and legacy systems at Confidential
• Worked on SAP suite on HANA implementation, layout BI / Reporting Strategy and approach on implementing BI solution including combination of standard ECC reports and using various tools provided by HANA Live.
• Evaluated the modeling, integration and additional implementation factors from a HANA perspective.
• Developed reporting using Lumira and WebI and Analysis office.
• Developed complex data model for ECC GTM ( Global Trade Management )

Environment: HANA - Live, HANA Enterprise, Business Object 4.1, ECC on HANA, HANA Enterprise, BODS

Confidential, NJ

Lead SAP BI / BO / HANA Lead Solution Architect

Responsibilities/Deliverables:

• Lead team (Offshore and onsite) team and allocate the work as per the team member skill and Scope.
• Design the Forest Government Restatement Data model and queries in HANA.
• Design the Aptalis Government Restatement Data model and queries in HANA.
• Develop the procedure to calculate the Calculated Measure at run time and insert the result in the staging table to develop the queries on the top of it.
• Develop the procedure in HANA to cover the requirement.
• Develop the SQL Based Calculation view/Procedure and script in HANA.
• Develop the SQL queries to validate the data in the HANA tables and queries.
• Develop the Legal/statutory requirements HANA reporting requirement.
• Extract the data from SAP ECC, SAP CRM using SLT .Enhance the extraction in the SLT.
• Develop the HANA information Model based on the business requirement.
• Develop the BO universe for the HANA information model based objects to reporting with
• Run the procedure to populate the tables.
• Use the data provisioning (SLT) to populate the data in the SAP tables in respective schemas.
• Load the data in using SLT from ECC system (Aptalis/Forest System).
• Load the data using BODS from the MODELN and Contractsphere system into HANA (Aptalis / Forest system).
• Assist the team security architecture requirements for HANA and Business Objects Integration.
• Worked for Configuring SAML with SAP HANA and SAP Business Objects.
• Worked on the HANA Live and access the standard solution provided for the ECC in HANA.
• Use the HANA Live for SAP ERP.
• Use the HANA Virtual Model for the HANA Live. Query and Reusable view.
• Use the HANA Live browser to locate and use the standard view for GR/IR.
• Use the HANA Live browser to locate and use the standard BillingDocumentQuery.
• Technical name of developer role: sap.hba.explorer.roles::Developer.
• Technical name of business user role: sap.hba.explorer.roles::Business.
• Assignment of different queries to different roles for the user access.
• Training to Business users for Using HANA Queries.

Environment: SAP BI 7.4, Business Object 4.1, ECC 6.0, HANA Enterprise, HANA - Live, MODELN, CONTRACT SPHERE, CRM, BODS

Confidential, CT

LeadSAP BI / BO / HANA Lead Solution Architect

Responsibilities/Deliverables:

• Lead the BI/BO team and set the scope and deadline for the team.
• Develop the staging layer for SAP BI/BO in SQL server 2008 by loading the data from Salesforce system to using BODS.
• Worked on Designing and Building of Universes, creation of Classes and Objects using Universe Design Tool
• Also used the Information Design Tool (IDT) to create Universe by creating Connection, Data Foundation and Business Layer
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables, resolving Loops, Chasm Traps, Fan Traps by creating Contexts and Alias tables
• Applied security features of Business Objects like object level security in the universe so as to make the sensitive data secure
• Created WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas
• Used complex formulas, subreports, sorting, parameters, grouping, filters, highlighting to build reports using Crystal Reports 2011
• Used the Business View Manager and created business views for creating Dynamic Cascading prompts to be used in the reports
• Created Web Intelligence reports and linked them with Dashboards using the OpenDocument functionality
• Created Test Shipment Tracking Report using the WebI tool using Charts, Sectioning, Drill down capability, etc.
• Used the Life Cycle Management (LCM) or Promotion Management tool to create backups and recovery and also for transporting the BO Objects from DEV to QA to PROD.
• Involved in creating and managing user, user groups, controlled user access, scheduled and published reports, monitoring servers using Central Management Console
• Involved in Code and Unit Testing, Integration Testing and also worked on resolving the defects reported by the testing team.
• Perform the validation (BI and Salesforce) of history data since the history data is coming from different sources.
• (Flat Files/Sales force etc.).
• Release the report to business once validation is successfully done.
• Develop the reports for commercial for the sales and Marketing team on sale.
• Develop the Design document and for the data model for the Dashboard.
• Working on POC on HANA followedby Implementation of HANA.
• Worked on Database design and architecture, Schema Design, Capacity / Sizing Review, Performance Tuning and User / Security Management preparation.
• Working on data migration from SQL server to HANA/Sales force to HANA using BODS.
• Developing Universe on HANA based table and developed the WebI reports on Salesforce data.
• Working on HANA modeling (Package, Attribute view, Analytic view, Calculation view, Analytic privileges.)
• Integrate SAP BW on HANA data with HANA models using Composite and Transient providers.

Environment: SAP BI 7.4, Business Object 4.1, ECC 6.0, HANA Enterprise, HANA - Live, MODELN, CONTRACT SPHERE, CRM, BODS

Confidential, New York, NY

Lead SAP BI / BO / HANA Lead Solution Architect

Responsibilities/Deliverables:

• Develop the design for the whole project and share with the team and management.
• Business Objects universe designer and report developer
• Met with the Business Analyst, Users and Business leads to understand their needs Modified universes and created reports for them accordingly
• Created WebI reports with more than 6 data providers and synchronized the data using the merge dimensions option
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle data sources
• Created reports for Accounts Payable Metrics (days payable outstanding, average payable period), Budget vs. Actual Performance Metrics.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Participated in Mapping of data as well as creating Data Flows and Workflows.
• Responsible for solving the Complex and Major issues in Web Intelligence.
• Worked and prepare the plan on the upgrade project of for NetWeaver 7.2 to 7.3 version.
• Worked and prepare the plan on the upgrade project of for Business Objects 3.1 to 4.0 versions.
• Developed finance reports on Revenue /Payouts/Project/WBS Element/PandL/Balance sheet.
• Developed the report for cost center, internal Order, WBS element, RandD report.
• Developed the sales/Payout/Money manager report in BEx and web intelligence (BO) and Crystal and publish the report to the portal.
• Prepare the presentation for the best practice on Migration BW on HANA.
• Worked on HANA Migration project. Perform and Involved with the HANA migration team.
• Worked on Preparation on HANA for the POC.
• Worked on Implementation of HANA.
• HANA modeling (Package, Attribute view, Analytic view, Calculation view .Analytic privileges.) Worked with SLT schema and other schemas.
• Experience with SAP HANA Security including User Management, Roles, and Privileges.Experience in performance tuning.
• Worked on other project running simultaneously and providing the team the solution for the daily issue they are facing while upgrading.
• Gathering and analyzing the requirements for Bo Reports.
• Business Objects universe designer and report developer
• Met with the Business Analyst, Users and Business leads to understand their needs Modified universes and created reports for them accordingly
• Created WebI reports with more than 6 data providers and synchronized the data using the merge dimensions option
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle data sources
• Created reports for Accounts Payable Metrics (days payable outstanding, average payable period), Budget vs. Actual Performance Metrics
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Participated in Mapping of data as well as creating Data Flows and Workflows.
• Responsible for solving the Complex and Major issues in Web Intelligence.

Environment: SAP BI 7.3, Business Object 4.0, ECC 6.0

Confidential

SAP BI / BO Architect

Responsibilities/Deliverables:

• Worked and prepared the plan on the upgrade project of for NetWeaver 7.0 to 7.3 versions.
• Worked and prepare the plan on the upgrade project of for Business Objects 3.1 to 4.0 versions.
• Prepare the Business Blueprint and functional specification document.
• Handling the finance report requirement for the Canada roll out.
• Developed the report for cost center, internal Order, WBS element, RandD report.
• Developed the report in BEx and then web intelligence (BO) and attached the report to the portal.
• Created Reports and WebI Reporting and Xcelsius dashboard design
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions
• Applied security features of Business Objects like row level and object level security in the universe so as to make the sensitive data secure.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Used Info View for scheduled and batch processing of Business Objects and Web Intelligence documents
• Exported the reports and dashboards into centralized database to access them for daily business analysis
• Prepared the following - business/technical writing of requirements, design templates, development standards document and detailed design documents
• Documenting of all processes like program specification, bugs fixing logs and change requests for future reference
• Built Executive and Operational Xcelsius Dashboards using Live Office
• Created users and user groups, restricted access of the users as needed using Central Management Console

Environment: SAP BI 7.3 Business Object 4.0, ECC 6.0

Confidential

SAP BI/BO Architect

Responsibilities/Deliverables:

• Gather the Requirement for banking. Business wanted to see their reports on BI and BO reports on Enterprise portal.
• Prepare the Business Blueprint and functional specification document.
• Prepare the Project Plan and share within the business and IT team.
• Build the BI and BO team by conducting the interview for a period of time.
• Managing the BI and BO team and set the task for consultants as per scope.
• Participation in Project status review meeting and steering committee meeting.
• Connect the BI system and EP for publishing the reports to portal
• Maintain the single Sign on.
• System configuration.
• Create a BW System in the Portal.
• Procedure Set ITS, WAS, CONNECTOR and USER MAPPING Properties.
• Defining System Aliases.
• Test Connections.
• Creation of Role, Workset and IView.
• Creation of Role and Workset.
• Creation of I View and adding I view to Workset.
• Add work set to Role and assigning the specific Role to the user.

Environnent: SAP BI/BO, ECC 6.0

Confidential

Business Objects Architect

Responsibilities/Deliverables:

• Develop ETL technical architecture.
• Evaluate and select ETL tool.
• Develop access/analysis tool technical architecture.
• Evaluate and select access/analysis tools.
• Interface with DBA staff.
• Interface with systems operations staff.
• Work with data designer and the ETL architect to determine space requirements.
• Monitor BI usage capture and maintenance of metrics.
• Develop and manage the BI dependency plan, job scheduling and cycle management.
• Develop disaster recovery strategy.
• Determine and ensure execution of backup and recovery strategy.
• Ensure execution of archival strategy.
• Continue to investigate and evaluate emerging BI technologies.
• Maintain inventory of data content (structure, level of detail and amount of history).
• Periodically review all data content in the BI environment to identify opportunities for improvement of problem avoidance.
• Design metadata solution.
• Ensure exploration environment is up and running at appropriate times.
• Ensure production environment is up and running at appropriate times.
• Ensure training environment is up and running at appropriate times.
• Environment maintenance. Develop information architecture.
• Manage current and future needs in data design and content.
• Resolve semantic discrepancies in data definitions that arise among multiple sources and projects.
• Gain consensus among users on common business data definitions.
• Gather requirement for upstream anddownstream divisionand developed the reports in Business Object.
• Gather the requirement for DPR (Daily production Reports) for the 18 wells as Gadimoga Plant.
• Provide the complete architect/design for the DPR reports and Dashboard.
• Setup the universe and maintain the connectivity with the source system.
• Reports were developed in web intelligence / Desktop intelligence and crystal reports tool (Business Objects).
• Developed the data flow for the Xcelsius Dashboard with data source oracle and PDMS system. Live office and Web intelligence reports are used.
• The daily / Monthly reports for the utilities for the consumption of water/chemicals /steam and Coal at Plant.
• Publish the report to the portal for the user access.

Environment: Business Objects /Oracle 9/LIMS/PDMS

Confidential

SAP BI Architect

Responsibilities/Deliverables:

• Develop ETL technical architecture.
• Evaluate and select ETL tool.
• Prepared the transportation strategies from Development to quality and to Production system.
• Develop access/analysis tool technical architecture.
• Evaluate and select access/analysis tools.
• Work with data designer and the ETL architect to determine space requirements.
• Monitor BI usage capture and maintenance of metrics.
• Develop and manage the BI dependency plan, job scheduling and cycle management.
• Ensure execution of archival strategy.
• Continue to investigate and evaluate emerging BI technologies.
• Define and get agreement with support and IT operations personnel on service level agreements.
• Maintain inventory of data content (structure, level of detail and amount of history).
• Periodically review all data content in the BI environment to identify opportunities for improvement of problem avoidance.
• Design BI Solution and provide the end to end Solution of the new requirement data model.

Environment: SAP BW 3.5(APO System), BI 7.0 ECC 6.0.

Confidential

SAP BI Architect

Responsibilities/Deliverables:

• Worked on gathering the requirements by interacting with the various Department head (Material management, Sales and Distribution, Production and finance) to understand their business and gather the requirement.
• Based on their business, I have proposed the analysis they can have on all Business areas.
• The AS-is and To-be has been done. Since requirement has been frizzed.
• Developed the reports based on requirement for different business division based on the requirement.
• Create the operational reports on Crystal reports.
• Provide Business Objects administrative support to application team members, help groups understand the Business Objects architecture and support existing Business Object solutions as needed.
• Apply deep understanding of a Business Objects toolset to troubleshoot various report performance issues both on the Business Objects side and database side to maintain satisfactory report generation performance

Environment: SAP BW 3.5, SAP R/3 4.7, NOW ERP for Textile

Confidential

BO Architect

Responsibilities:

• Worked on gathering the requirements by interacting with the various Department head (Material management, Sales and Distribution, Production and finance) to understand their business and gather the requirement.
• Based on their business, I have proposed the analysis they can have on all Business areas.
• The AS-is and to- be has been done. Since requirement has been frizzed.
• Developed the reports based on requirement for different business division based on the requirement.
• Create the operational reports on Crystal reports.
• Provide Business Objects administrative support to application team members, help groups understand the Business Objects architecture and support existing Business Object solutions as needed.
• Apply deep understanding of a Business Objects toolset to troubleshoot various report performance issues both on the Business Objects side and database side to maintain satisfactory report generation performance

Environment: Business Objects /Oracle 9/LIMS/PDMS