SUMMARY:

• Information Technology Executive with 15 years of experience with Last five years as a Solution Architect for SAP BW/BI/BO/HANA implementation. Have experience in Design Conceptual model, Data modeling, Extraction, Reporting, and Develop detailed design for the information requirements (Reporting Data Dictionary), Expertise in Functional and Technical Specifications, Test Scripts. Good Functional knowledge in Finance, SCM and Operation.
• MS in computer engineering, and demonstrated success in leading large diverse teams with integrity, proficiency and versatility.
• SAP HANA: Experience with HANA modeling (Package, Attribute view, Analytic view, Calculation view .Analytic privileges.) Worked with SLT schema and other schemas.
• HANA POC and Implementation experience.
• Worked on Data Governance, Business Intelligence, Enterprise Data Warehousing, Data Architecture, and Data Quality Improvement.
• Data Management Strong background in 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.
• 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, SAP BW, BOBJ integration

TECHNICAL SKILLS:

ERP: HANA, SAP R/3, ECC 5.0, ECC 6..0, 4.6B/4.6C

Data Warehouse: HANA Enterprise, BW on HANA, SAP-BI/BW, SAP NW 2004s, SAP BI 7.x, BPS (Business Planning and Simulation), IP (Integrated Planning)

Project Management tool: Primavera

Reporting Tools: Business Objects, Crystal Reports, Lumira,Web intelligence, design studio, Xcelsius, Analysis office, BEX, WAD

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential - Benton Harbor, MI

BI Developer/Architect

Responsibilities:

• Gather the requirement from the business and design the Business blue print accordingly.
• Leading SAP BI team.
• Analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for theSales billing, order& delivery, FI Report (Working capital, Vendor payment, and customer ageing) in HANA.
• Enhancement of Reuse views of HANA live.
• Deploying HANA live standard reports Financials (FI: General Ledger, Profit Center CO: Cost Center, Product Cost ) Logistics SD: Quote, Sales Order, Outbound Delivery, Invoice, Returns, Contracts, Credit/Debit Memo Requests
• Created Universes on top ofHANA calculation viewsand developed the Webi & Crystal reports and dashboards usingIDT(Information design tool )
• Create various reports based on business Object reporting tool directly on HANA views ( Lumira reports, analysis office)
• Migration of SAP BW 7.1 to SAP BW 7.4 which is HANA.
• Integrate SAP BW 7.4 on HANA data with HANA models using Composite & Advance DSO, Open DSO etc.
• Design and creation of SAP BW objects (Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre-migration of BW on HANA implementation. Optimized BW cubes for HANA purpose.)
• Developed BEX reports on Delivery, Billing, Inventory, Account Receivable and general ledger
• Involved in the Issues raised by the End-users.
• Transported BI Objects From Development System to Quality System and to Production.
• Developed Reports using BEX Analyzer/Browser, Workbooks to meet the business requirement.
• Performed filling up the aggregates to fill the summarized data from cubes to the aggregates, roll ups to fill the aggregates with the changed records and attribute change runs to realign the aggregates..
• Worked on BEX Analyzer, Browser and WAD (Web Application Designer) tools to generate reports related SD, and MM.

Environment: SAP BW 7.4, BI/BO, SAP ECC EHP7, HANA Enterprise, BW on HANA, HANA-Live

Confidential - Mumbai/ NY

Solution Architect

Responsibilities:

• Interacted with project stakeholders in understanding the requirements to build solution with SAP HANA models.
• Working on plant data reconciliation and validation, operational performance management and analysis & quality management.
• Develop the Design document and for the data model for the Dashboard.
• Working on POC on HANA followed by Implementation of HANA enterprise.
• Worked on Database design & architecture, Schema Design, Capacity / Sizing Review, Performance Tuning and User / Security Management preparation.
• Working on data migration from SQL server (Non-SAP data) to HANA using BODS.
• Developing Universe on HANA based table and developed the webi, Lumira, design studio reports.
• Working on HANA modeling (Package, Attribute view, Analytic view, Calculation view, Analytic privileges.)
• Migration of SAP BW 7.1 to SAP BW on HANA.
• Integrate SAP BW 7.4 on HANA data with HANA models using Composite & Advance DSO, Open DSO

Environment: Enterprise HANA, BW on HANA, HANA Live, SAP BI 7.4,BO, ECC EHP7, SQL

Confidential

BI Solution Architect

Responsibilities:

• Gather the requirement from the business and design the Business blue print accordingly.
• Lead, manage, coach, and motivate cross-functional and geographically dispersed project teams.
• Plan commitments for all project resources; maintain resource forecasts throughout the project.
• Ensure appropriate ownership and accountability is specified for all project activities and results.
• Periodically review all data content in the BI environment to identify opportunities for improvement of problem avoidance.
• Data extraction from SAP and Non SAP.
• Design and creation of SAP BW objects (Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre-migration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Creation of queries, reports and dashboards using ( BeX, Webi,WAD, and Design studio )
• Design SAP BI Solution and provide the end to end Solution of the new requirement data model.
• Working on HANA modelling (Package, Attribute view, Analytic view, Calculation view, Analytic privileges.)
• Monitor and report on schedule and budget variances.
• Perform the unit testing and created document. to end user.

Environment: SAP BI 7.3, BO 4.0, SAP ECC EHP 7, HANA Enterprise

Confidential

BI Developer/Architect

Responsibilities:

• Worked on gathering the requirements by interacting with the various Department head (Material management, Sales and Distribution, Production, Project, HR and finance) to understand their business and gather the requirement.
• Prepared the Strategy, Scope and Analyzed the Business process to be modeled. Created the Technical specifications for BI Content Modeling for PM, FICO and MM modules.
• Installed the BI Content and extended the content to add custom info objects. Modeled and created the end to end connectivity using Custom data sources, info sources and transformations.
• Custom Data source/ Infocubes / Infoobjects for accommodating the global data available across the organization. Used LO Cockpit, Generic, Flat File and DB extractions to retrieve SAP and Non-SAP data for reporting in SD, MM, PP, HR, PS, BCS modules and company's legacy systems.
• Worked on Data Load Performance Issues and Query Performance Issues.Activating and filling the Aggregates for better Performance.
• Creation of BO reports in webi and dashboard ( Sales,HR, BCS )
• Developed BEX reports on Delivery, Billing, Inventory, Account Receivable and general ledger
• Involved in the Issues raised by the End-users.
• Transported BI Objects From Development System to Quality System and to Production.
• Developed Reports using BEX Analyzer/Browser, Workbooks to meet the business requirement.
• Worked on BEX Analyzer, Browser and WAD (Web Application Designer)
• Complete implementation of SAP BI for FICO, HR, MM, PP, PS, BCS.
• Building Dashboard in SAP BO
• Support and enhancement of implemented solution.
• As per SLA, I was involved for the support as well and during that period for managing the team and deliver the solution for the issue raised.

Environment: SAP BI 7.1, BO 4.0, SAP ECC EHP 7, SAP BCS

Confidential

BI Solution 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.
• Developed the reports based on requirement for different business division based on the requirement.
• Took the lead to Understanding and the business requirement and suggesting the data model accordingly for BW.
• Took the approval of designed proposed document and started the development.
• Created the z-table to capture the information about the Z- fields required to fulfill business requirement.
• . Created Info-objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.
• Assisted in configuring BO Data Integrator as a Source system and also used it to send transformed data from Oracle to BW. Created generic extractor to combine R/3 data into BW
• Business Objects reports creation using WEBi, dashboards.
• Upgrading BO 3.1 to BO 4.0 and migration of 3.1 BO objects using lifecycle management.
• 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 BI 7.3, BO 4.0, SAP ECC EHP 7, Cognos TM1

Confidential

Solution Architect

Responsibilities:

• Requirements Gathering of various business partner ordering process
• Daily meeting with all the business partners to understand their current business process.
• Creation of a specification for data archiving within modules MM, SD, FICO, AM all phases of a data archiving project have been argued. Workshops with the respective operating department to determine Data by company code, Sales organization or Plant wise.
• Carve outing parent company data.
• Testing data result.
• Installation and configuration new ECC landscape for client.
• Support daily wise activity.

Environment: SAP ECC 6.0, MSSQL Server 2008

Confidential

BI Solution Architect

Responsibilities:

• 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.
• Design metadata solution.
• 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 and downstream division and 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: SAP 4.7 E, Business Objects /Oracle 9/LIMS/PDMS

Confidential

BI Solution Architect

Responsibilities:

• Activation of Datasources in R/3, Replicate and Activate datasource in BI
• Content Installation: Infoobjects Activation of Transfer Rules in BI, Activation of update rules Create, Transformations, Infopackages, DTP's
• Create Z-Fields for Cubes
• Migrate 3x Datasources, Dataload
• Modeling IRDA Cube, Dataload IRDA Cube, Testing Data IRDA Cube
• Query building IRDA reports, Testing IRDA Reports
• Transports Modeling to QAS, Transport Queries to QAS

Environment: SAP ECC, SAP BI, SAP EP

Confidential

BI Consultant

Responsibilities:

• Gather the Requirement for product costing for complex process production of steel. Business wanted to see their reports on BI reports.
• Prepare the Business Blueprint and functional specification document.
• Prepare the Project Plan and share within the business and IT team.
• Understanding and the business requirement and suggesting the data model accordingly for BW.
• Create the objects like Info cube, ODS, queries based on business requirement.
• Done unit testing and then created the document for unit testing results.
• Created the process chains for master data and transactional data.

Environment: SAP ECC, SAP BI/BO, SAPEP

Confidential

BI Consultant

Responsibilities:

• Gather the Requirement for product costing for complex process production of pharma products. Business wanted to see their reports on BI reports..
• Involved in the Design & Implementation Phase and Build Test Phases, Process Design Documentation.
• Prepared the transportation strategies from Development to quality and to Production system.
• Developed Update Rules, Transfer Rules and ABAP user exits for transaction & master data in start/end and update routines. Experience in creating InfoPackage to create Process chains and Scheduling of data loading with Full/Initialization/Delta upload method Expertise in Data Modelling using Entity.
• Relationship (ER), Multi-Dimensional /Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data model.
• Developed BW BPS Planning environment architecture with Planning areas, planning levels, planning packages and planning functions/sequences.
• Open Hub (Infospoke) to transfer data from Infoproviders to flat files.

Environment: SAP 4.7, SAP BI/BO, SAP BPS