We provide IT Staff Augmentation Services!

Sap Hana Developer Resume

Saint, LouiS

SUMMARY:

  • I am an SAP BIAnalytics lead, certified consultant ofSAPSolution Architect (SAP BW) andITIL Foundation (Support projects). I havebeen associated with IT Industry for around 11 years in SAP BW/ABAP/BO/HANA/BODS/POWER BI/HAC.
  • 11+Years of Experience in SAP BW/ABAP/BOBJ/HANA/BODS/POWER BI/HAC.
  • As anSAP BIAnalytics leadresponsible for successful delivery of BI projects on BOBJ, HANA, BW and Non - SAP (legacy) systems and replacing legacy reporting applications with SAP HANA.
  • Execution of successful projects on CIO and CFO deck.
  • Involved draft version of the Charter for new project proposals.
  • Build business cases and project execution plans for approved projects.
  • Review project teams proposed BI solutions and High-level designs and LLDs.
  • Review RFPs and effort estimationsalong with Directors for vendor selection process.
  • Provide best directions,solutions, tools to Business/customer engagement teams under BI platform.
  • Participate in workshops with business on identifying new projects/pain points with current designs/solutions and identify scope to improve with current BI analytical solutions.
  • Responsible for BI projects initiation, track status/health and update to Project teams& IT Director accordingly.
  • Provide/Review solutions and ensure successful delivery of approved BI Projects.
  • Manage relationship with external BI vendors and associates to ensure follow best practices/ tools in BI Analytics space.
  • Working on Cross Functional Global projects for Finance,Purchasing, SCM, Commercial and soon.
  • Create project plans and update status with project owners, PMO and Global IT.
  • Having Hands on inMicrosoft Project Management tool (MS office).
  • As a SAP BI Project Lead and BW Solution Architect responsible for requirement gathering Workshops, Provide solutions to Business needs.
  • Developed project design principles and naming standard documents.
  • Maintained all Phases of ASAP methodologies (SAP SDLC) for successful project execution.
  • Maintain teams of onsite and offshore model.
  • Define and maintain milestones for Projects to evaluate project health checks.
  • Co-ordinated with Production support teams with regards to deployment, KT, cutover and initial project care.
  • Involved inplanProject costs like effort estimates and cost saving efforts.
  • Managed technology upgrade/migration projects for SAP ECC, BW, BO and BODS.

TECHNICAL SKILLS:

Expertise in HANA Modeler, Eclipse based BW modeling.

Expertise in Building Calculation views, Joins, projections, aggregations, Input parameters.

Expertise in Building SQL based HANA views.

Expertise in validating performance of calculating views, User and role administrations.

Expertise in Interface between HANA DB vs BW application layer.

Expertise in, Composite Provider, ADSO and open DSOs.

Expertise on BODS.

Hands on SAP LT Replication Server (SLT), SAP Data Services (DS), SDI, SDA ( Smart Data Access).

Expertise on BOBJ Tools, Analysis for Office (excel version SAP), Power BI.

Knowledge on Embedded BW (CDS views and BW queries, Gateways, Fiori tiles).

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis

SAP HANA DEVELOPER

  • Involved SAP-Business Intelligence professionals design, implement and deploy SAP business intelligence solutions for end-to-end data warehousing and analytics including SAP BW, UDT/IDT and Business Objects (BO).
  • Review and approve the proposed design solution by project teams.
  • Involved in Global Supply Chain Project GSPR implementation and Enhancements.
  • Design and Manage BW data flows from ECC and APO systems as part GSPU.
  • Design and Manage data flows fromECC to Webi reports using BW, Queries, Universe connection, Universe Design and Webi reports.
  • Created Data Security Profiles and Applied to user groups in Universe design.
  • Managed various SAP components including Designer, Reports, Web Intelligence, Info View, Publisher, Import Wizard, LCM, and Central Management Console (CMC) and So on.
  • Managed GSPU Project which consolidates 5applicationsdata with common master data Dimensions.
  • Resolved the Pain points of Existing BI solutions.
  • Created Webi reports extensively using tables, Cross tabs, Sections, breaks Merge Dimensions and so on..
  • Optimized Universe performance by using aggregate awareness for summary and detailed reports.
  • Created Column level Data security profiles.
  • Worked with BO administrative and infrastructure to optimize the performance of long running report and schedules
  • Developed OLAP, Relational Connections, UDT, IDT and BICS universes.
  • Created dashboards by using Bex quires in Bo 4.0.
  • Involved in Webi reports extensively by using formulas likeFor each, For all, Running sum, Previous, Self, User response and So on.
  • Involved in FOCUS dash board report by using Gauge, Odometers Drop downs, Radio buttons and So on..

Confidential, Saint Louis

SAP HANA DEVELOPER

  • Technically managed various BI projects on CIO and CFO deck.
  • Involved with Zero based spend project by providing companywide spend to project teams.
  • Involved ZBB and ZBS reports which would track targets, budget and actuals for ZBS categories.
  • Having association with Director, Track the existing projects status and new project proposals.
  • Executed the Cost center project successfully which enabled total Overhead reporting capabilitiesas per the business need.
  • Executed the ZBS spend analytics project which enables Non-working categories spend visibility.
  • Managed the Reporting Projects (SCM, Commercial and OTIF projects) with preferredvendors which include High level design reviews and synopsis documentation and KT sessions.
  • Managed BW Upgrade project (7.3 to 7.5 SP1) and BO 4.2 Upgrade projects.
  • Involved in S4 HANA migration projects.
  • Managed HANA solutions through Eclipse Modelling, HANA Calculation Views and Administration activities.
  • Managed integration between ABAP Application layer and HANA Database.
  • Executed Global reporting models by consolidating 3 SAP Systems and 6 Iscala (local ERP)
  • Managed BW and BO production support with offshore IT partner.

Confidential, San Francisco, CA

SAP Developer

  • Working as SAP BI Projectlead consultant and Solution Architect for the Clara Clinical HOARSE Phase II
  • As a project lead involved in requirements gathering and provides solutions to business needs. And dealt with ODC for development and support activities.
  • Experience working in multiple SAP applications especially BW,APO, ABAP and BO.
  • Involved User requirements gatherings related to the performance management of business processes in Clinical trials supply chain.
  • Understand requirements related to forecast accuracy, forecast stability, inventory accuracy, OTIF metrics, SPR metrics and ATS.
  • Involved Gap analysis by comparing standard Business content objects Vs. customer requirements.
  • Designed Function specifications and SDS-D documents for Clara R/3 developments.
  • Designed data flows and started implementing same in BW side.
  • Worked as Offshore/Onsite team lead for both Development and Support teams.
  • Involving the Business Requirement Analysis, Updating the FS and TFS, Development and test, Migration and test, UAT, Deployment and Cut Over tasks as well.
  • Developed Inventory coverage, production plan performance, current production schedules and other Performance metric reports
  • Developing the Test Scripts for UAT in Test Directory.
  • Re design data flows per data load optimization
  • Working on SCM (PP, PM, and QM)) Enhancements.
  • Worked on OLAP connections through Business Intelligence Consumer Service (BICS)
  • Working on tickets through gRemedy on both HD and CR.
  • Involving Tracker update meetings to prioritize the CHGs.
  • Guiding team members on technical issues
  • Requirement analysis, Creation of Architectural design documents.
  • Migrating the existing EDW system into BI system
  • Activating the LO Cockpit Datasources from R/3 side, Deletion of setup tables, Initialization of setup tables.
  • Created the EDW layer, Integration layer, Reporting layer DSOS in the Item level and produced the report based on the requirement.
  • Creation of Datasources, Infoobjects, and DSOobjects, DTPs, Multiprovider.
  • Worked on PROP module. Created Write-optimized DSOS, Integration Layer DSOS for Order, Operations and Components and produced reports on those cubes.
  • Worked on Start Routines, Update rules, Transfer rules and User Exits.
  • Worked on Collective updates, various delta update modes based on ROOSOURCE, RODELTAM tables.
  • Worked as an onsite coordinator and Developer(USA - California)
  • Handling Issues during the Quires Conversion- BI 3.5 to BI 7.0.
  • Doing Thorough Unit Testing and CIT Testing.
  • Working on Open Issues in Remedy.
  • Checking the Queries performance in CIT Server.
  • Checking Same in G2G- Gen portal.
  • Maintain Query Cleanup Activities along with CIT Track leads.
  • Identifying Workbooks, Y-queries etc.
  • Developed the Test Scripts for UAT in Test Directory.
  • Working on PROP EDW Project ( New enhancement for PROP)
  • Worked as an onsite coordinator for 3 months(USA - California)
  • Working on tickets through gRemedy on both HD and CR
  • Finance reconciliation on weekly basis
  • Call monitoring activities and assign tickets
  • Guiding team members on technical issues
  • Checking the system performance
  • Involved in Up gradation activities
  • Re design data flows per data load optimization
  • Worked on P2P Enhancements.

Confidential, Waltham, MA

SAP BI Developer

  • Monitor process chains (daily, weekly and monthly)
  • Working on Notifications like RQ, IN and PR
  • Sales reconciliation with G/L on weekly basis
  • Call monitoring activities and assign notifications
  • Guiding team members on technical issues
  • Assign roles to end users and 1st line support by checking approvals from controllers
  • Coordination with development team for import transport requests to BWP.
  • Checking synopsis documents which are handover by development teams
  • Maintain BW-Support Documents as per organizational changes
  • Checking the system performance
  • Maintain RCA documents for data load failures
  • Involved in Up gradation activities
  • Creating daily error reports and So on.
  • Understanding Functional documents
  • Involved in impact analysis.
  • Preparing Functional and Technical documents.
  • Attended weekly status update meetings
  • Changed and created objects in BWD.
  • Developed Currency translations routines
  • Conduct unit test after preparing test scenarios
  • Transported developments to BWQ environment
  • Test the Developments in BWQ and generate reports for UAT
  • Finally coordinate with BW-support to move those developments into BWP.
  • Test in BWP and inform to user about the changes

Confidential, Parsippany, NJ

SAP Developer

  • Collect all info
  • Impact analysis
  • Design of the BW data model and R/3 Extraction
  • FD Updating
  • TD Updating
  • Development
  • Unit Test BWD
  • Corrections
  • CR test in BWQ
  • UAT in BWQ
  • UAT issues fix
  • Deployment
  • Sanity checks and cutover
  • Production support

Confidential, New York

SAP Developer

  • Design, development and implementation of Customized Info Cubes and ODS objects.
  • Redesigned the data flows and reports as per M2MR (Move to Monthly reporting) compliance.
  • Analyze existing Data modeling using extended star schema concepts.
  • Source system compounding for strong characteristics as per the new design principle. Uploaded Master and Transactional data from flat files and SAP R/3.
  • Involved in high level partitioning of the data target.
  • Involved in installing Business Content for standard Info objects, Info sources, and Data sources.

Hire Now