SUMMARY

• Strong project planning and managing experience
• Designing & architecting Data Warehouses in Oracle, MS SQL Server, SAP HANA, SAP BW.
• Implementing BI reporting solution in SAP Business Objects and SAP BW.
• Extensive experience in exposing HANA views into BW like transient provider, virtual provider, ADSO and composite provider as well as exposing BW objects into HANA.
• Hand on SAP provisioning tools that include LT Replication Server (SLT), DXC, BODS, and Smart Data Access.
• Strong experience in SAP HANA modeling, security and infrastructure.
• Strong experience in SAP BODS integration with SAP ECC, SAP BW, SAP HANA and non - SAP systems.
• Experience in ETL and data cleansing applications using SSIS and SAP Data Services (BODS) Information Steward
• Extensive experience in PL/SQL and T-SQL
• Quality assurance including User Acceptance Testing (UAT), data profiling and data cleansing
• Strong Big Data knowledge and their integration with SAP HANA directly and/or through BODS
• Experienced in using Upgrade Manager and Lifecycle Management Console (LCM).
• Extensive use of Business Objects reporting functionalities, i.e. Master Detail, Slice and Dice, Drilling, Filters, Sections, Graphs and Breaks. Expert in Universe design, development and generation of complex dashboard and Adhoc reports.
• Working knowledge of S/4HANA and Simple Finance.

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP HANA Architect SAP HANA, PowerDesigner

Responsibilities:

• Gathering requirements, scope finalizing, designing technical solutions and preparing the relevant technical specification.
• Responsible for effective communication between the project team and the customer.
• Migration of application from Legacy Database (MSSQL) to SAP HANA.
• Worked with PowerDesigner and Information Steward
• Installing PowerDesigner and PowerDesigner Portal Server
• Building Conceptual and Logical Data Models.
• Generated PDM from CDM.
• Implementing data integrity checks.
• Administering PowerDesigner.
• Adding PowerDesigner to Information Steward Metadata management.
• Creating Metapedia, configuring match, validation Rules.
• Data Quality Scorecard & Monitoring.
• Worked with BODS
• Gap analysis, package evaluation and implementation.
• Deliver ETL and Data Quality Solutions Architecture and Design.
• Provide best practice advice to customers.
• Migration project which involved DQM, Data Transformation, Validation, Reconciliation etc.
• Worked extensively on Smart Data Access (SDA) POC which included following test cases
• Creating Batch Dataflow.
• Creating Realtime Replication.
• Creating Realtime Sources with Transformations.
• Creating Source with History Preserving.
• Giving an overview of AFM Editor, Palette, Virtual Tables, Scripting and Modeling with Virtual tables.
• Developing HANA Artifacts (models) like Attribute View, Analytic View, Calculation View (graphical/scripted), Analytic Privileges, star join (fact view) and database procedure in the SAP HANA Studio platform.
• Experience with database procedures and script based calculation views using HANA programming languages like SQL Script and CE functions or native SQL.
• Worked on BOBJ tools like IDT, Webi, Lumira etc.

Confidential

Senior SAP HANA Architect

Responsibilities:

• Prepared replication blueprint for DB2 to HANA Migration with BODS replication.
• Development, tested and implemented ETL flow in BODS batch jobs for subsequent loads
• Migration of application from Legacy Database (DB2) to SAP HANA.
• Replicated ECC tables into SAP HANA using SLT Replication.
• Scheduled initial load and continuous Replication of data into SAP HANA using SLT Replication.
• Created initial load and continuous Replication of data into SAP HANA by using SLT Replication.
• Defined real-time XS engine architecture for franchise (dealers) and employees of Confidential .
• Designed high level HANA data model for the OLTP solution (XS engine).
• Used XS engine and created oDATA services.
• Created schema objects (tables, index, functions, sequences, stored procedures etc).
• Modelling with Attribute views, Analytical views, Calculation view and scripted Calculation views (using SQL Scripts/CE function Scripts) in SAP HANA for web APIs.
• Worked on SAP BODS for DB2-HANA integration and delivered complete e2e real time ETL data migration.
• Worked on spatial data and showed how it works with google maps as well as esri maps.
• Designed and laid down rules for data fencing and security including user management, roles and privileges.
• Set up monitor to analyze which will help to resolve any technical problems.
• Worked with end users for UAT.
• Explored multi-language search support and limitations.
• Developed search facility using HANA search engine to include

Confidential

SAP BODS/BOBJ Architect

Responsibilities:

• Worked as SAP BODS Architect for full life cycle implementation: Design, development, deployment and support in SAP Rapid Marts
• Created high-level DWH migration strategy and solution design to upgrade and handling Inventory migration as well as sales implementation
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism
• Mapping to the pre-delivered content in the Rapid Marts
• Enhancements & upgrading universe design using IDT, WebI reports, and BO Data Services Jobs
• Monitoring, production support and application maintenance for SAP BO Rapid Marts deployment

Confidential

SAP HANA

Responsibilities:

• Built SAP HANA prototypes for client solutions.
• Defined and documented business cases with detailed informative documents, power points etc. regarding company’s IT goals and roadmaps.
• Advised internal team on choosing the right hardware partners, high availability and disaster recovery strategy.
• Worked on Software Update Manager (SUM), Database Migration Option (DMO), Post Copy Automation (PCA).
• Created and documented archiving strategy and sizing, housekeeping.
• Worked on transient provider, virtual provider, virtual master data and composite provider.
• Advised internal team in choosing the right provisioning tools.
• Designed, developed and implemented SAP BOBJ, including dashboards and KPI reporting.
• Coordinated activities with various business and technical leads on other teams such as Basis Admin, CRM, and SAP Financials teams.
• Coordinated and delegated technical activities, tasks, milestones and deliverables to assigned project resources or performed activities where necessary.
• Implemented SAP HANA Security including User Management, Roles, and Privileges.
• Conducted workshop and training to improve SAP HANA knowledge including cloud, security, modelling, provisioning tools, reporting and analytics.

Confidential

BI Consultant (Tech Lead)

Responsibilities:

• Implemented SAP BO 4.0 - HANA integration and delivered complete end-to-end, real-time sales reporting.
• Designed a high level HANA sales data model for the reporting solution by creating analytical, attribute and calculation views as well as analytic privileges and where ever necessary scripted calculation view.
• Replicated scenarios on SAP landscape transformation (SLT) with operational reporting or data mart scenario - HANA Modeling, optimization, partitioning, archiving.
• SAP HANA programming including SQL, SQL Script, and CE Script.
• Enhanced Purchasing Header (2LIS 02 HDR), Purchasing Item (2LIS 02 ITM), Schedule Line (2LIS 02 SCL) with custom Fields such as Over delivery limit, under deliver limit, business Line etc using ABAP based on EKKO, EKPO, EKET etc to meet the end user reporting needs. Create custom data sources using Views and Functional modules extractors for Account Assignment for PO (EKKN), Purchase Requisitions Account Assignment (EBKN) and PO Services Account Assignment (ESKN), Service Entry sheet etc.
• Designed and created MultiProviders on Accounts Payables Cube, Accounts Assignment Cubes etc.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA.
• Prepared mapping documents to capture all business rules.
• Built and supported interfaces from non-SAP to SAP systems and from SAP to non-SAP systems.
• Used BODS DQM to clean addresses
• Developed the security model, naming conventions and established the recommended SAP best practices for developing universes, reports and dashboards from HANA data sources
• Designed WEBi reports and KPI Real time Dashboard in Dashboard Design for global and regional users
• Involved in analysis, design, development, testing, and deployment of the system
• Performed unit testing and integration testing.
• Delivered zero defect solution for user acceptance testing.

Confidential, Irving, TX

BI Consultant (Tech Lead)

Responsibilities:

• Worked as Migration lead and managed project deliverable.
• Developed of logical & physical dimensional models via Erwin using Kimball methodologies.
• Developed mappings/sessions/workflows as a part of Data/Object Migration.

Confidential

BI Consultant SAP

Responsibilities:

• Worked as SPOC between client and development team.
• Analyzed the business logic and developed BO universes, BODS packages and Webi reports to serve the reporting and ETL requirement.
• Worked SAP BW consultant for the first successful IBM SAP Implementation in mid-market sector (was reported in Huston Chronical newspaper).
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, ODS, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Activation of the Business Content for Plant Maintenance (PM), Purchasing (MM), Quality maintenance(QM), CO-PA and customizing them as per the client requirement.
• Worked on BEX Analyzer, Browser and WAD (Web Application Designer) tools to generate reports related SD, and MM.