Sap Hana Lead Solution Consultant Resume
Charlotte, NC
SUMMARY
- Having 11yrs of extensive experience in SAP with 3.6yrs in SAP HANA SPS 11 Enterprise Platform, BusinessObjects, Data Provisioning with total of 13yrs IT industry experience having 3 full life cycle implementation experience in ASAP/Agile projects in Implementation, Deployment, Migration, Up gradation of various SAP systems
- Have functional understanding of FI, SD, MM & CRM across verticals like BFSI, FMCG, Manufacturing, Life sciences and Healthcare(LSHC), Product development, Energy Sector and Consulting Service sectors
- Experience with Enterprise HANA Platform 1.0 SPS11 and in HANA Studio & Hana Live with perspectives like HANA Modeler, Administration in Design, Development, Maintenance of various HANA database Objects like Catalogs, Content, Packages, Information models (Attribute views, Analytical views, Calculation views), Analytic Privileges, Procedures, Decision Tables, Import/Export/Migrate, Setup(Delivery Units, Schema mapping, Configure import server) and various Data Provisioning techniques using various Data Stores from SD - Sales Order, Sales Delivery, Billing also from Financial Accounting - Accounts Payable, Accounts Receivable and from Material Management Data Sources for Master & Transactional data
- Worked on Data Provisioning techniques like SAP SLT, Business Objects Data Services Designer(BODS) 4.2 with SAP, Non-SAP Data sources in Design, Development Extraction/Migrate/Import of new projects and their related data as identified into SAP HANA, maintain ETL jobs for loading real-time data replication from various Data Sources into SAP HANA Database
- Worked on BODS Management Console, ABAP Workbench for configuration and Administration/Maintenance/Scheduling of data transfer from SAP ECC source system to HANA Database
- Provide Business Intelligence and Analytics support as it relates to applying for SAP HANA 1.0/ SAP S/4 Hana to exisiting softwares, used to carry out data processing and analytics with various tools like Hana Studio, BO 4.1,Information Design Tool(IDT) 4.1 SP3, Business Objects CMS, BODS 4.2, SLT, DXC, Web Intelligence, SAP Crystal Reports 4.2 SP3 and Smart Data Access
- Experience in Migration with BW on Hana and optimizing HANA Information models in Hana Studio, worked extensively in SAP BI specific to ECC - SD, MM and FI modules
- Hands on experience in SAP NetWeaver Portal System management, Content management, User mgt in Implementation, Support, Development, Maintenance, Migration, Upgradation across various projects also by greatly improving portal efficiency through sizing and performance tuning
- Hands on experience in SAP Netweaver EP stack with EP 6.0 & 7.x, KM with TREX, Collaboration, NWDI, SAP ECC, SAP ESS & MSS, SAP EP Business packages Implementation, SAP HANA along with all B2B & B2C portals and hands on working experience in SAP CE - Workflow, Solution Manager and BPM
- Have experience in EP7.3 Content Administration (iViews, Pages, Worksets, Roles, Groups, Role Merge, User Assignment, Group Assignment, Theme setup assignment), User Administration (Custom Role Creation, Merging Roles, Role assignment, Role Filters), System Admin(System creation, LDAP configuration, Properties, Permissions, URL Alias, SSO, UWL, ADS, FPN)
- Having experience in Project Management walk through in Scope management Scheduling, involved in various knowledge areas in Initiating, Planning, Executing, Monitoring & Controlling projects, defining and executing high level business scope and compliance requirements with widely accepted ITIL approach in IT Service management in order to meet the customer’s project expectations, involved in Scope Management & Client interactions to understand Business requirements and solution design, considerable knowledge & detailed understanding of current SAP system landscape to design integration approach
TECHNICAL SKILLS
SAP ERP IDE/Tools: Hana Studio, SAP BODS 4.2, SLT, BO IDT, SAP BI 7.4, BEx, SAP NetWeaver EP 7.3, SAP R/3, SAP ECC 6, ABAP
Database: SAP HANA, Oracle, SQL, PL/SQL, MS SQL
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
SAP HANA Lead solution consultant
Environment: HANA1.0 SPS9, HANAStudio, SAP BW 7.4, SAP ECC 6.0, SAP SLT, BODS4.2, WEBI, IDT, ABAP/4
Responsibilities:
- Worked in development of various Information Models/Views like Tables, Views along with SQL/Graphic based Calculation views, Attribute views, Analytical views, Calculated Columns, Restricted Measures, Calculated Measures, Input Paramaters, Currency conversions, Date functions, procedures to address complex business requirements, also migrated HANA content from Development systems, Testing/QA systems to Production systems using Delivery Units option in Hana Studio
- Modeled views on Customer Balances report using Bsid, Bsad ECC FI tables with Script Editor, CDC(Change Data Captures) for target system and applied a Merge Transform and History Preserving functions in BODS and generated calculation views and its necessary functions for the same to generate the report
- Worked in modeling views called Customer day sales outstanding report, which tells the number of days it takes a company to collect cash for its product to its credit sales and transforming the ECC tables data from Knc1(customer g/l balances) in BODS and applied Pivot and Reverse pivot transforms to be available in Hana studio using calculation views and its function like calculated columns and applying the formula/query
- Worked on Procurement Data Model views with sales order, purchase order as primary entities with employees, partners, addresses, texts and products as supporting entities along with currency rates and unit of measures.
- Modeled various Attribute Views/Analytical views based on Master/Transaction Data Tables in the SAP ECC for SD, FI modules
- Created Graphical & SQL script based Calculation Views by including the Analytic views using Unions, Projections and Joins conditions based on the business logic
- Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to be available for modeling in HANA studio
- Worked in designing SAP HANA optimised DSO, InfoCube, Data flows(DSOs, Transformation, DTPs) in HANA Database and imported the DSO, Infocubes to SAP HANA Studio
- Performed Data Modeling and developed Analytical Views for the transactional data, Attribute Views for the master data and the Calculation Views as final model in HANA Studio.
- Experience in tuning the performance of SQL queries and ETL processess, proven abilities in creating complex reports In Business Objects BO 4.1 by linking data from multiple Data sources, Universes
- Have experience in translating business KPIs into Hana and define the Reporting Layout &functional specifications into Technical specifications and also conducting UAT sessions by validating data in reports vs ECC for business
- Worked on ETL tools like SAP Business Objects DS(BODS) 4.0 with SAP, Non-SAP Data sources in Extraction/Import of Data Objects, Design, Development of their related data as identified into SAP HANA, maintain ETL jobs for loading real-time data replication from various Data Sources into SAP HANA Database
- Experience in server products like Web Intelligence, Central Management Console, Developed webi reports on top of Bex queries in SAP BO 4.1, scheduling the webi reports, using filters, report filters, alerts, and conditions.
- Worked with Business Objects Report for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports.
- Interacted with the Business in gathering their requirement Study, for further assisting them to use the data extracted from SAP BW system for generating Report using BEx Analyzer.
- Have pragmatic understanding of existing SAP BW Models and documenting the business flows in SAP HANA.
- Created various Universes connecting the IDT system to Sap ECC system by configuring Relational Connections, Data Foundation and Business Layer Data Foundation publishing by providing JDBC middleware database driver to Hana Database so that Hana Information Models are available for reporting in SAP BI Information Design Tool and made them available to WebI reporting tool
- Also worked on various other Universes in IDT over BW models by publishing them through IDT Business Layer foundation and made them available to WebI reporting
Confidential, Madison, WI
SAP HANA Consultant
Environment: SAP HANA 1.0 SP5, SAP BOBJ, SAP BW 7.3, ECC
Responsibilities:
- Created Attribute, Analytic view on sales, delivery and billing entities as part of customer portal project and provided reports where user can analyze open orders, Backlog quantity and other business analysis in SAP HANA.
- Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
- Have good understanding of Business Intelligence InfoProviders, Info cubes, Info objects, Info objects Catalogs, DSO, Multi providers, Transformations, DTP, DataSources, Info packages, Data Extraction, Business Content and Process Chains, various BEx Components - Building Queries and saving in Workbooks, BEx Analyzer, Filters, Calculated and Restricted Key Figures.
- Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing Experienced in loading data from tables in HANA Database to BW data marts.
- Have experience in Configuration/Administration of Trigger based SLT based real-time replication of SAP ECC, BW systems into Hana systems
- Involved in providing solutions to the complex requirements using BW Info providers (Transient Info provider, Virtual Master Data Info Objects, Composite Providers, Multiprovider) for HANA Models.
- Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
- Created Security for the BOBJ reports for the business users, Reconciled the data with the existing BW Reports with the new HANA Models.
- Called various Calculation Views to BOBJ 4.1 IDT Tool to create Universes.
Confidential, NJ
SAP Hana Consultant / Sr.SAP Portal Architect
Environment: SAPHana1.0, SAP BW 3.5, BW 7.0, SAP ERP 5.0, SD, HR, FICO, BEx Query Designer, Web Application Designer.
Responsibilities:
- Performed Hana data modeling, application development, and technical product assistance and tuning to meet customer performance and functional requirements.
- Worked on ETL tools like SAP Business Objects DS(BODS) 4.0 with SAP, Non-SAP Data sources in Extraction/Migrate/Import of Data Objects, Design, Development of their related data as identified into SAP HANA, maintain ETL jobs for loading real-time data replication from various Data Sources into SAP HANA Database
- Created the Visualization Reports in SAP BOBJ Explorer 4.0 based on the Analytic Views, Calculation views from Hana and Universes using measures and Facets on the Information Spaces.
- Analyze the current high visibility reports and redesign the data flow to make them available faster accurate and with better user experience to business.
- Worked on Business objects OLAP Reporting systems based on BEx Reports, worked on SAP BW administration workbench, customized info-objects, info sources and infocubes, created and maintained data sources at R/3 source system and extracted data in to infocubes after creating transfer rules, info packages and update rules, Installed relevant Business Content Objects and worked with Info Cubes like Customer, Deliveries, Sales Overview, Delivery Services and Info Sources like Customer, Sales Order, Delivery, Billing, and Sales Order/Delivery.
- Responsible for Lead Portal Architect support of various Administration, configuration, development Up gradation and support of Confidential & Confidential Health Care services client for various regions of China, Korea, Hong Kong, Australia and India
- Presently manages & owns the SAP EP environment strategy across all SAP instances and their related sandboxes. Involves in defining operational support processes for SAP system instances, disaster recovery and business continuity planning showing technical leadership and oversight in planning, evaluation, design, development, implementation, Upgradation, Migration, operation & control for enterprise-level applications and confront to system architecture standards and practices by working with stakeholders using ITIL approach as required to keep up to date with enabling technologies by identifying and analyzing project and technical risks & impacts and define alternatives to minimize the risks, also by applying project management & quality methodologies to ensure the completion of tasks
- Worked for Streamlining Workflow processes using technologies like UWL, Workflow, NWBC 3, Sol Man 7, integrated with Portals and CRM systems
- Presently involved in various Project Management activities like Monitoring, Reporting, SLA management, Allocations etc.
- High level client interaction and resolution for availability of applications through their ITSM support tool
- Coordinating with responsible teams to realize the requirements, involved in requirement gathering for Portal support and development, defining Scope scheduling activities for project teams involved.
- Interacted with Business consultants & key business users to capture various portal requirements for support.
Confidential
SAP Lead Portal Consultant
Responsibilities:
- Responsible for development and support of various automation and integration tools, with their internal CSS (Customer Support Service) in EP.
- Actively involved in defining application lifecycle processes for SAP systems, showing technical leadership in planning, development, implementation, operation & control for enterprise-level applications and confront to system architecture standards and practices by working with stakeholders
- Building new assets that showcase new solutions and competitiveness by developing, maintaining and supporting new content development
- Evaluating requirements and providing solution to their CRM Presales automation process.
- Designing the interfaces to achieve integration as per business processes.
- Enhancing & coordinating their product tools with concerned Sales and Pre Sales teams as required.
- Interacted with integration consultant & key business users to capture integration points.
- Involved in requirement gathering for Portal integration and development.
Confidential
Sr.Technical Consultant
Responsibilities:
- Analyzing and Designing as a Technical Lead in various Shell Portal solutions for given requirements.
- Offshore support in SAP NetWeaver EP 6.0 in Development, Deployment and support of various Shell Group Portal Services.
- Have challenging but achievable team targets to match business metrics, performance standards, SLAs and manage individual and team performance
- High level client interaction and quick response for availability of production servers through their Service Center tool
- Development and deployment of various portal content objects to support numerous applications and infrastructure for their IT4Shell GPH portal services
- Designing and implementing the solution in SAP using NWDS, Service Center, Abap Workbench, WebDynpro ABAP.
- Worked on Function Modules, BAPIs, Workbench for Interface development and deployment.
Confidential
Technical Consultant
Responsibilities:
- Analysing and Designing technical solutions and applications for given requirements.
- Development of various portal objects in their corporate Employee Self Service(ESS) HR portal in Netweaver EP
- Development and enhancement of various BSP applications related to their Enterprise Portal services.
- Analysing, Designing, Development and Testing of various Portal applications as per requirements
- Pragmatic Knowledge usage of Data dictionary objects, SQL database and Logical Databases
- Providing documentation solutions to relevant portal applications for also all development objects for understanding by end users and clients
Confidential
Project Assistant
Responsibilities:
- Obtained good technical knowledge transition from senior technical members for analysis and development of various SAP ABAP applications and also worked on Java development of various applications for their inhouse projects.
- Exposure to various necessary SAP modules like Sales & Distribution and Materials Management.
- Development of various SAP applications using workbench smartforms, scripts, LSMWand data dictionary objects.
