Sap Hana/bi Program Manager Resume
4.00/5 (Submit Your Rating)
Pittsburgh, PA
SUMMARY
- 15+ years of experience wif SAP Hana, SAP ECC, Sybase ASE, Replication and IQ. Worked on full life cycle projects and production support.
- Apart from SAP Hana database administration me have experience and in - depth noledge wif SAP R/3, CRM and SD. As Consultant and full time DBA.
- Have expertise in day-to-day DBA operations involving space management, user management, performance monitoring and tuning, backup and recovery. me have worked on Sybase since version 4.9 and have performed upgrades to 10.x, 11.9, 12.5, 15.x and 16.0. me have worked wif Microsoft, Oracle databases and other vendors for supporting database management systems and teams.
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh, PA
SAP HANA/BI Program Manager
Responsibilities:
- Expertise and experience in Enterprise Data Warehouse(EDW), Data Provisioning, Modeling and 24x7 on-call support and database administration,
- Data Installation, Security, Provisioning and Modeling
- Responsible for architecting solution using HANA, BODS and SLT.
- Responsible for gathering requirements and creating functional specifications
- Conduct and Facilitate Functional and User Acceptance testing
- Provide periodic updates to client on teh status of teh project.
- Responsible for teh business/technical interface required between teh Implementing partner and client team for teh execution of this project.
- Excellent communication and technical skills
- Creating attribute, analytic and calculation views.
- Develop SAP BW/BI objects including DataSources, Extract Structures, Transfer Rules, Update Rules, Communication Structures, Rules, ODS objects, InfoCubes, InfoObjects, and MultiCubes for multiple functional areas.
- Comfortable creating SQL queries and using editor tools such as Hana Studio.
- Experience wif ETL design and Data warehousing concepts (Star/Snowflake schemas, data mining, workflows, mappings, testing)
- Extensive experience delivering operational and Data Warehouse-based solutions using both Dimensional and Relational modeling
- Ability to lead and facilitate design workshops (Blueprint), assessments, planning sessions me.e. demonstrate leadership experience in upfront projects
- Installation of SAP SLT server.
- Handling onsite / offshore teams as SAP Hana Architect.
Confidential, Somers, NY
SAP HANA/BI Consultant
Responsibilities:
- Lead HANA engagement; mobilize and manage engagement teams; define HANA deliverable structure and content; facilitate buy-in of proposed HANA solutions from top management levels at teh client; direct on-time, quality delivery of work products; manage engagement economics; manage engagement risk. Manage day to day interactions wif SAP HANA clients and sponsor
- Updated wif teh latest releases by SAP in teh area of HANA (Side Car functionalities, Suite on HANA, S4 HANA, etc.)
- Lead teh team for delivering Landscape Technical activities in HANA
- Replication using Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0.
- SAP HANA Data Provisioning and using SAP LT Replication Server (SLT).
- Developing SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
- Implementation experience and noledge of SAP Hana reporting for different functional area Finance.
- Consuming SAP Hana views on IDT to deliver business layer using web intelligence and have proven experience wif reporting specially handling complex scenario's using joins and sql.
- Collect business requirements and define functional & technical specifications.
- Preparing various documents related to teh project.
- Work on multi-Terabyte SAP BW implementations, data modeling, data profiling, entity-relationship modeling and dimensional modeling.
- Data provisioning and replication via SAP’s SLT (SAP Landscape Translation).
- Working wif HANA schemas and packages
Confidential, Pittsburgh, PA
SAP HANA/Basis Consultant
Responsibilities:
- Work as part of a team dat focused on teh SAP's Database & Technology cloud solutions which includes everything from standard SAP architecture to innovative in-memory HANA Database and Sybase solutions
- Creating Analytic Privileges, Using HANA Lifecycle Manager to transport code to production.
- Work on integration between multiple systems for Reporting
- SAP Basis Technical Industry experience dat ranges from consulting, project management, product management, and development as well as technology aspects like SaaS and databases
- Responsible for architecting solution using HANA, BODS and Cognos
- Responsible for gathering requirements and creating functional specifications
- Provide periodic updates to client on teh status of teh project.
- Responsible for teh business/technical interface required between teh Implementing partner and client team for teh execution of this project.
- Excellent communication and technical skills
- Ability to travel 100% required.
- In addition, successful Senior Managers will also have teh following preferred skills:
- Ability to work independently, manage small engagements or parts of large engagements.
- Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).
- Strong problem solving and troubleshooting skills wif teh ability to exercise mature judgment.
- Willingness to mentor junior staff.
- Candidate should of about 6 years of experience in SAP HANA
- Should of 15+ years of experience in SAP
- Solution design and architecting experience in OLAP space
- Experience in handling customers, good in presentation
- Experience in offshore-onsite coordination
- Experience in understanding teh business requirements and support teh users
- Excellent communication skills
- Able to interact wif customer and taking decisions independently
- Expertise on HANA modeling for data provisioning and optimizing teh models
- Expertise wif performance tuning teh HANA environment
- Experience modeling as-is and to-be architectures based on business requirements
- Minimum 6-10 years related work experience
- Initialize teh project by establishing all non requirements as well as surfacing unnons.
- Establish anticipated growth patterns of teh database and connections to legacy data sources.
- Provide senior level perspective and experience to guide teh customer to teh proper physical and logical design of teh HANA data warehouse.
- Working wif teh SAP Data Services consultant, identify replication scenarios for teh data warehouse, including but not limited to SAP Landscape Transformation (SLT) or SAP SBOP Data Services setup for periodic replication from non-SAP Business Suite applications.
- Perform logical design of teh HANA database, taking into account teh growth in size, scope, and users this database will see as in teh longer term it connects to other data sources and adds further diverse users.
- Provide guidance for teh physical design of teh HANA database, accounting for growth in size, concurrency and performance, backup/recovery/failover and other requirements of a mission critical database system.
- Ensure teh strategy for teh HANA data warehouse aligns wif teh SAP product strategy.
- Document teh implementation steps and resources into a plan, incorporating SAP and customer resources.
- Work wif teh customer database and operations staff to ensure teh HANA database design fits into their existing operational and security schemes.
- Establish dat teh HANA database is installed and configured correctly.
- Confirm dat teh HANA appliance is configured and TEMPhas teh required growth capacity.
- Work wif teh SAP Data Services consultant and customer resources to implement and test teh agreed upon replication scheme
- SAP BW on HANA system
- ABAP
- SAP BI/BW
- Data warehouse
- Business Objects
- Participate in any required documentation of teh system.
- 10+ Years SAP implementations and / or Application Maintenance Support experience in Manufacturing, Software & Utilities Vertical Industries; in Global, multi-business line, complex large corporate IT, full SDLC’s / ERP implementations.
- 4 Full life Cycle SAP Implementation experience in a Lead role covering SAP ECC, SAP CRM, SAP BRIM, wif at least 1 full implementation involving usage based /subscription based billing.
- Extreme communication and organizational skills
- Comprehensive SAP product noledge (ECC, CRM, SCM, PI/PO, PLM, BI/BO, SAP Solution Manager, SAP
- Upgrade to teh latest stable HANA SPS versions from Version 97, on all teh HANA VM’s
- Install and configure teh DR server and synchronization between teh Prod’s and DR’s.
- Check authorizations and all teh important points as part of teh post check.
- System sync between all Dev/QA and Prod if needed.
- Run tests to make sure all teh systems upgraded are performing at their optimal levels.
- Extensive noledge of SAP HANA implementations and migrations is preferred
- Experience wif providing assessment of high level estimates based on understanding of scope
- Proficient in teh use of methodologies supported by SAP best practices for migration such as SLT
- Extensive use of SAP HANA Studio for management, troubleshooting and configuration of teh HANA appliance
- SQL Server 2005-2008 and Windows 2003-2008
- Demonstrated ability to lead and develop a world-class Basis organization to support a global, 24x7 SAP environment.
- Demonstrated architecture and design expertise wif enterprise server and storage networking projects in support of SAP in large-scale environments.
- Responsible for teh SAP BW development lifecycle from design through implementation and production support
- Proficient in SAP BI/BW Back-end development and configuration, testing and pre-production support
- Proficient in design, developing & support of custom BW objects using BW LSA (Layered Scalable Architecture)
- Proficient wif SAP BW on HANA system architecture design and performance optimization Creates transformations,
- Creates and supports Bex queries in SAP BW Data Warehouse based on reporting requirements
- Responsible for performance tuning of BW systems utilizing best practices
- Responsible for supporting Business Objects reports in production and new report development
- Responsible for root cause analysis and providing solutions for production and development issues
