SUMMARY:

• Overall 6+ years’ experience, includes three full Life Cycle Implementations and production bug fixes in various domains like Automotive, Telecommunication, healthcare, Retail and Manufacturing.
• Excellent professional experience in Software Development Life Cycle with different project management approaches like Waterfall, Agile and Hybrid. Worked on all phases of project includes requirement gathering, design, project implementation, system test and implementation, user support and training.
• Experienced with HANA development using HANA studio and SAP Web IDE (HANA 1.0 and 2.0).
• Experienced in SAP Analytics Cloud as it introduces storytelling pattern. Learned and utilize new tools within SaaS to unveil productive options.
• Experienced in developing Self - Service, Fixed format and Smart Dashboards using SAP Business Objects tools (Web Intelligence, Analysis for Office, Lumira) and Tableau.
• Experienced in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views (Data Category: Dimension, Cube and Star Join) with graphical and script-based methods, using SQL, SQL Script, and CE Functions as needed.
• Extensively worked on creating Table functions and CDS artifacts.
• Created transformation views, analytical Privileges, Column store views and performed SQL coding to push data into data base intensively.
• Experienced in creating a logical Data model using Power Designer for the Architecture and reporting needs.
• Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
• Created different types of reports such as Standard, Crosstab, Drilldown, Sub Reports, and Hyperlink reports, Dashboards, Label Reports and Chart Reports for the end users.
• Created complex reports using Web Intelligence tool and distributed reports to various levels of users.
• Experienced in Enhancements of existing BO reports and delivering the changes to business on time.
• Processed to add new table to the existing views in universe based on user requirements.
• Involved in the production support and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements.
• Experienced with understanding of the end to end Architecture (Data loading, Data modeling & Reporting); Working Knowledge on SDI (Smart Data Integration) and SDQ (Smart Data Quality).
• Created Remote connection from HANA Database to Hadoop system using SDA (Smart Data Access).
• Worked on SAP HANA Data provisioning technology including SAP LT, Data Services-BODS, replicated Data from multiple modules- FICO, MM, SD.
• Configured SAP HANA data provisioning for replication with SAP source systems and non- SAP source systems.
• Experienced in Importing meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio.
• Involved in Development, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
• Worked on various phases including Prepare, Blueprinting, Realize and Deploy -In the Prepare Phase- Created the Business Blueprint in consultation with the Business process owners and end users undertaking workshops with superusers.
• Helped with requirement gathering, functional specs and technical specs.
• Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), HR, PP, Materials Management (MM), Inventory Management (IM) and have in-depth business process knowledge.
• Coordinated with business and offshore / onshore technical teams for development.
• Responsible for peer review for design and regression changes before moving the change from a development system to another development system.
• Coordinated and resolved Data Quality issues for smooth migration to production.
• Established project documents and cut-over plan for Go Live and Support. Troubleshooting and support on post-go live and retraining Super Users.
• Motivated self-starter with excellent communication, presentation and interpersonal skills, and work in challenging and cross-platform environments.
• Team player with demonstrated collaborative working relationship.

PROFESSIONAL EXPERIENCE:

Confidential, Marysville, OH

SAP HANA Modeler / SAC Developer

• Participated in Development, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Reporting and Production Support.
• Created stories and Dashboard on SAP Analytics Cloud using HANA views.
• Created Technical specifications and standard modeling documents for Native HANA.
• Worked with the CDC team in preparing, cleansing and loading data into the Native HANA environment and to define the Blueprint for Data Integration
• Delivered solution using both the Onshore & Offshore model; streamline the delivery model to deliver value to the customer; managed work load, priorities, schedules, etc. based on the team capacity.
• Ensured delivered designs are scalable to meet future business development.
• Performed data modeling and developed Analytic views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Configured and Tested the Attribute view, Analytic views, Calculation views with proper joins for project.
• Interacted with the business users/Business Analysts to gather requirements. Documented the meeting in meeting minutes template.
• Resolved issues on issue log and centralized repository of project documents.
• Reviewed performance issues and provided enhancement recommendations for HANA views that incorporated inventory, sales order, purchasing, and AR data.
• Conducted workshop for the blueprint and end-user approvals.
• Designed and utilized SAP-BODS solution that satisfies the business performance, functional, and technical requirements in support of client needs, including: Design and configure an SAP-based advanced reporting/analytics solution that satisfies the business performance, functional, and technical requirements in support of client advanced reporting and analytic needs.
• Worked on design and modeling sessions using power designer.
• Involved in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data at offshore location
• Created Global and local variables and built parameterized data flows.
• Wrote scripts to call functions and pass values to parameters.
• Conducted user Management and Authorization for Business user and Modeler. Assigned needed System Privileges, Object Privileges, Analytical Privileges, Package Privileges etc.
• Prepared test-case scenarios and developed test plans and performed user acceptance testing.
• Proactively identified project risks and created feasible solutions. Escalated cross-functional issues and identified SMEs required for resolution.
• Created Universes on top of Native HANA Analytic views and developed the WEBI reports and dashboards using SAP Analytics on cloud and Tableau.

Confidential

SAP Hana Modeler / BO Developer February

• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and various activities.
• Worked on SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.
• Migrated HANASQL Scripts, Model objects from DEV to STG and STG to PRD
• Migrated tables to other nodes in DEV/STG/PRD and monitored system performance for PRD (checking for locks/long running threads etc.)
• Gathered and analyzed the requirements to replicate the ECC content in HANA using the Real-time SLT Process.
• Created the Visualization Reports in SAP BOBJ based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.
• Monitored and conducted troubleshooting during data loads in HANA environment.
• Created BOBJ Universes based on HANA views using IDT and created WEBI reports.
• Provided L3, and L4 support to the end users and business partners.
• Enabled client tools to access HANA directly- Business Objects, to write the reports.
• Scheduled real time data load into HANA by using SLT both initial load and continuous replication.
• Collaborated with BASIS team in planning and orchestrating system copies during system upgrades, system integration testing (SIT) and User acceptance testing (UAT)
• Monitored the consumption of data into Webi to increase performance and stability.

Confidential, Baltimore, MD

BO Developer

• Worked with CDC team in preparing, cleansing, and loading data into the Native HANA environment and to define the Blueprint for Data Integration into Native HANA.
• Performed data modeling and developed Analytic views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Configured and tested the Attribute views, Analytic views and Calculation views with proper joins for project.
• Worked closely with the power users to capture the requirements and incorporated the same in report.
• Involved in creation of universes using Information Design Tool (IDT) by retrieving the data from various data sources and connections.
• Created Classes, objects, cardinalities and strategies and published the Universe to Repository.
• Created Aliases and Contexts for resolving Loop Join problems in the Universe.
• Created Derived tables as per the requirement in the Universe.
• Worked on design, development and maintenance of Universes, and generated Web Intelligence Reports.
• Created Alert, Filters, Ranking, Breaks, charts, tables, sections, Query Panel, Report Panel and Formatted while designing reports.
• Created Daily, Weekly, Quarterly reports for the management team and field operation managers.
• Tuned the reports to improve the performance of the report refresh time.
• Fixed issues like reports opening in PDF view by default to report view.

Confidential, Hartford, CT

SAP Hana Modeler / BO Developer

• Designed and implemented SAP HANA info models using Attribute Views, Analytic Views, Calculation Views Restricted and Calculated Measures, Input Parameters, Variables, Stored Procedures, CE Functions and SQL script.
• Loaded data into table definitions, suspended data loads, resumed data loads using SLT.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Involved working with content models, attributes, measures, hierarchies, currency conversions and schema Mapping. Experience in Text Search with different options via SQL and created Decision Tables in SAP HANA Studio.
• Extensively involved in User Acceptance Testing (UAT), Pre-Production testing & Post Production Support. Trained multiple Business groups across the various Departments to fulfill complex reporting requirement needs.
• Migrated info models developed in HANA from DEV to UAT to PROD using Export/Import and Life Cycle mgmt.
• Performed data transformation and load into SAP HANA database from ECC, SQL Server sources using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT)
• Performed Error Analysis, Debugging SQL Scripts, and in using SAP HANA Plan Visualizer. Optimized existing application which migrated on HANA.
• Translated business and functional requirements into development objects in SAP HANA Studio.
• Participated in requirements elaboration work-shops for Accounting and Finance business processes for users in the different corporate and business units including Accounting, Tax, General Ledger, Asset Management, Treasury, Consolidation, Planning & Budgeting, Incentives & Commission Management and Regulatory/Compliance.
• Worked with various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical Views and Calculation Views.

Confidential

SAP Hana Modeler

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Worked on deliveries related to configuration.
• Translated business requirements into a technical design document.
• Worked on Incidents, Change Order and Service Requests.
• Configured for Daily, Monthly and Yearly loading activities.
• Worked on the reporting requirements related to Water Consumption Report, Open Record requests, Security Alarm requests, Sales Statistics Report etc.
• Worked extensively on BI related ABAP work e.g. Start routine, End routine and enhancing the extractor to achieve the business logic.
• Performed Unit Testing and System integration testing for the deliverables.
• Maintained business intelligence products such as reports, dash boards, Lumira, universes, explorer views, HANA, ETL, portal linkage day-to-day to ensure availability.
• Developed some Web reports with SAP BO Design Studio on the Customer Receivables and open order requests on disconnection objects.
• Monitored and tuned business intelligence product performance - report, plan, schedule, coordinate, communicate, execute, signify, attest, and test adjustments accordingly.
• Worked on transporting deliverables to quality and later to production system.
• Worked on building financial reports and generated the reports useful for company's financial audit (GL/AR/AP).
• Coordinated with end-users for their work support and work on component testing.
• Worked on EHP 6 upgrade for SAP system landscape and performed the testing of the reports and BI configuration during the post upgraded period.
• Worked on Datawarehouse, ETL and software development methodologies.
• Was an active contributor in the Proof of concept on SAP HANA.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Worked on integration with backend SAP SoH for data extraction and process chain design.
• Loaded Data into the SAP HANA Database using SLT Replication and BODS. Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.