Sap Certified Hana Consultant Resume
UT
CAREER SUMMARY:
- Currently working for Infosys Ltd with 9.5 years of SAP HANA SP7, SAP Business Objects 3.x/4.0, SAP BW, ABAP, XI with two Full Life Cycle Implementation experience, Two Upgrade, One Data Migration and Three Support Projects with a mixed blend of technology and management skills, Mentored, managed and lead IT teams across countries from India, Australia and USA.
- SAP Certified Application Associate - SAP HANA C HANAIMP141: Certificate id - 0006845780.
- Involved in all phases of implementation from Business Blueprinting, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End-User Training.
- Experience in BOBI 4.0 & BI Launch pad 4.0.
- Experience in creating Xcelsius Dashboard using live office & Web service.
- Migrated 30 millions of records from Mainframe to SAP in Data Migration Project.
- Having exposure in MM, SD, PP, PM, HR and FICO modules.
- Worked extensively in Retail and Banking domains.
- Experience in HANA Information Model design: Attribute View, Analytic View and Calculation Views as per teh Business requirement.
- Experience with connecting SAP HANA Analytical Views, calculation views to BOBJ.
- Created Universes on top of HANA calculation views and developed teh Webi reports and dashboards using IDT.
- Experience in creating Analytic Privileges.
- Experience in User management in SAP HANA.
- Experience in SAP BW on HANA.
- Experience in Data Provisioning using SLT, BODS and DXC.
- Expertise in Dashboards Design/Xcelsius, Web Intelligence.
- Dashboards Design using WSDL links, and Query Browser (OLAP).
- Organizing, Publishing & Scheduling Reports from BI Launch Pad.
- Experienced in creating BICS-OLAP Connections, Data Foundation Layer, Business Foundation Layer, and Multi-Sourced Universe with IDT.
- Excellent noledge in Report Publications and Scheduling.
- Experience in BOBJ Upgrade from 3.1 to 4.0.
- Ability to work on CMC, user security, OLAP connections.
- Debug issues related to report performance.
- Extensively use of Business Objects reporting functionality such as Master Detailed, Dynamic Filter, Slice and Dice, Drilling methodology, Ranking, Sections, Input Controls, Graphs, Breaks, and highly formatted reports with cross tabs tables.
- Creating an Xcelsius dashboard using Live Office as a data source.
- Creating an Xcelsius dashboard using SAP BW direct connectivity.
- Proficient in reporting tools like SAP BO XI R3.1 - Universe & Webi.
- Deploying teh universes and reports using import wizard.
- Experience in Converting teh Deski reports to Webi using RCT.
- Experience in Creating Universe on top of SAP BEx query, Infocube, Mutliproviders.
- Exposure in installation, configuration, migration and administration of Business Objects XI R3 using CCM, CMC and Infoview.
- Good exposure in designing and building Universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
- BW Extraction - FI -AP, AR, GL, HR (LSO, ERC, PA, OM, PD, Benefits, Payroll), SD-LO-Cockpit, Extractions from ECC. Generic Extractors based on Tables, Views & Function Modules.
- Experience in building complex BEx queries and user exit variables.
- Experience in SAP Production support.
- BI Reporting & Analysis - Ad-hoc Queries, Query Designer, BEx Analyzer.
- BW Operations - Data load management, Job scheduling, Loading (Full /Delta Up-Load), Process Chain Monitoring, Data Reconciliation.
- Expertise in preparing of user manual/guides and conducting various workshops for user training
TECHNICAL SKILLS
Database(s): SAP HANA SP7, ORACLE 9i/10gETL Tools SAP BODS
BOBJ Tools/Modules: Business Objects XI R3.1/4.0 Web Intelligence, QAAWS, Live Office, Admin Tools including CMC, CMS, IDT, UDT.
Reporting Tools: Business Objects, Crystal Reports, Dashboards
Scheduling Tools: Redwood, Control M
Programming Languages: SAP ABAP
Middleware Tools: SAP XI 3.0
Operating System: UNIX, Windows 95/98/2000 /NT/XP, Sun Solaris 6.x/7.x
PROFESSIONAL EXPERIENCE:
Confidential, UT
SAP Certified HANA ConsultantResponsibilities:
- Developed multiple reports and dashboards using Webi4, BO Dashboard (Xcelsius).
- Created HANA modelling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
- Loading data into table definitions, suspending data loads, resuming data loads.
- Created attribute views, analytic views, calculation views Graphical and SQL script based.
- BO 4.0 Reporting over HANA.
- Setting up Custom access levels and security in BOBJ CMC.
- Created BO Users and assigned required access to users in CMC.
- Created new Audit reports for teh client requirement.
- Experience in BOBJ Upgrade from 3.1 to 4.0.
- Very comfortable in interacting with customers and technical teams. Strong analytical & problem solving skills.
- Vast experience in executing, leading Production support projects in SLA models.
- Building new SLA models and strategic meetings with business partners.
- Experience in working with various teams for GAP analysis of requirements and project Assessment.
- Responsible for Resource planning, estimation and pipeline projects prioritization.
- Involved in Project Kick-off, Release Management & Status meetings to discuss testing status, configuration management, deadlines and all QA related aspects.
- Experience in onsite-offshore model.
- Strong in requirements gathering from users and preparing specifications.
Technologies and Tools: SAP BOBJ 3.1/4.0, SAP HANA 1.0 SP7, CMC, RCT.
Confidential, Fort Worth, TX
Responsibilities:
- Manage client expectations, status reporting, and feasibility for new requirements.
- Interacted with various internal business users & stakeholders to implement BW/BOBJ reporting projects from initial scope definition through analysis, design, implementation and On-going support.
- Experience in working with IT teams and coordination with various business parties like other Technology team, third party vendors and offshore onsite teams.SAP BOBJ - Dashboards 4.0, Web Intelligence, Crystal reports
- Designed and developed complex Webi reports
- Building Crystal report for displaying master and transaction data, using Group headers and sub-queries in teh main report.
- Building Webi reports using Hyperlinks to detailed Charts.
- Responsible for all BOBJ scheduling for various Business depts. For Month end, quarterly and yearly activities.
- Ability to create parent /child dashboards using flash variables.
- Experience working with Dynamic visibility and Dashboards components like Canvas, Selectors and Charts.
- Building alerts in dashboards using % and value based alerts.
- Responsible for monitoring of around 200 interfaces and batch jobs of FI and HR modules through Redwood tool.
- Experience in onsite-offshore model.
- Knowledge on SAP HANA studio, creating universes on Analytic Views and using it in SAP BOBJ.
Technologies and Tools: SAP BOBJ 4.0, Solution Manager, HPQC, Redwood.
Confidential
Responsibilities:
- Migrated around 30 millions of records from Millennium Mainframe system to SAP R3 system using LSMW with IDocs approach.
- Developed several LSMWs for uploading transaction data and uploaded 36 months of historic data.
- Helped audit team in Reconciliation of GL Accounts
- Experience in Unit Testing, System Integration Testing, Performance testing, Regression Testing
- Worked on Report programming, IDOCs, Enhancements, LSMW, and Data Dictionary.SAP R3 Upgrade from 4.6C to ECC 5.0
- Worked on transaction codes: SPDD, SPAU, and UCCHECK.
- SIT and Preparation of Cutover activities in upgrade project which includes FI, HR, and MM Modules.
- Used HP Quality Centre for defect management, test cases and results upload.
- Worked as SAP technical consultant.
- Worked in removing various syntax errors from SAP standard programs and custom programs.
- Provided solutions by applying OSS notes to some functional issues, which aroused due to up gradation.SAP BW
- Experience in Modelling, Scheduling, and Monitoring in SAP BW.
- Experience in improving query performance using Query Cache, RSRT debug and defining aggregates.
- Developing Info objects, DSO, Infocube, Mutliproviders and BEx queries using Query Designer
- Extracted data for various data sources FI-GL, FI-AP, and FI-AR data from R/3 to BI.
- Worked with CKF and RKF for BEx reporting.
- Worked with CMOD code for master and transaction data.
- Experience in debugging issues on IDOCs and daily load failures.
- Worked in workflow monitoring, BW Data load monitoring, Batch jobs monitoring through Control M.
Technologies and Tools: SAP BW3.5, SAP R3 4.6C, ECC 5.0, Control M.
Confidential, CA
Responsibilities:
- Involved in development of Inbound and Outbound interfaces with XI as middleware.
- Worked on enhancing standard transactions using User-Exits, Screen Exits and Enhancement Points.
- Worked on IDOC Type HRMD A to distribute employee master data.
- Have developed a report to extract all teh qualifications completed and pending for completion by teh employees.
- Have a worked on a report to extract Employee appraisal data.
- Worked extensively on Module Pool Programming and Report programming.
- Have worked on Smart form to generate purchase order and Work order.
- Task Planning, Client interfacing and Work estimation.
- Involved in teh end-to-end implementation of On boarding and off boarding process
- Involved in preparation of Technical Design Specification Document, coding and Testing.
- Performed code and document reviews and mentored developers to understand teh development process.
- Developed and fixed defects for workflows in HR, MM, PM modules.
- Enhanced standard Business Objects and created custom business objects to meet teh requirement.
Technologies and Tools: SAP Netweaver 7.0, ECC 6.0
Confidential, NJ
Responsibilities:
- Enhanced BAPI to display/Change employee Personal data as part of ESS.
- Involved in development and testing and fixing tickets based on priority.
- Worked on user exits of IDocs like MATMAS, DESADV, ORDERS, and ORDRSP to develop business logic.
- Extended IDocs and added new segments to teh several IDocs.
- Worked on Report programming and BDC.
- Technical documentation
- Code Review
- Used Mercury Quality Center for testing and defect tracking. Uploaded test cases and screen shots.
- Was an active member of team and handled an initiative to conduct biweekly meeting.
Technologies and Tools: SAP Net weaver 7.0, ECC 6.0
Confidential
Responsibilities:
- Created & imported software component versions in XI and assigned business specific namespaces to components in Integration Repository. Assigned development software component version to Business system in SLD and also Created Business services in SLD.
- Created namespaces for IDoc to file, IDoc to Soap, SOAP-to-JDBC.
- Created source and target data structure (target Data Type) according to teh required fields.
- Created Message types and Message interfaces for target system in teh integration objects.
- Created teh message mappings, interface mappings in mapping objects.
- Created corresponding configuration objects (sender agreement & channel not needed for IDoc scenario's) for these scenario's and activated.
- Monitoring & error handling these IDocs through SM59, SM58, SXI MONITOR, IDX5.
- Done SOAP-to-RFC (SAP) Integrations for Flexware product and Certified by SAP ICC.
- Created Product name, software component name & version for teh Flexware product.
- Created client for teh technical system that is called business system. Imported following BAPI’S into teh Integration Repository:
- Created three Namespaces in teh software component version and created corresponding interface objects (data types, message types, message interfaces), mapping objects (message mapping, Interface mapping objects (message mapping, Interface mapping) and integration scenarios (application components and actions).
- Created corresponding configuration objects (sender communication channel, receiver communication channel in teh business system, sender agreement, receiver determination, and interface determination and receiver agreement) for teh above scenarios.
- Generated corresponding WSDL files for teh three scenarios.
- Using these WSDL files Flexware successfully communicates teh SAP system.
Technologies and Tools: SAP XI 3.0, ECC 5.0