SUMMARY

15 Years experience with SAP Hana, SAP ECC, Sybase ASE, Replication and IQ. Worked on full life cycle projects and production support. Apart from SAP Hana/BASIS database administration I have experience and in - depth knowledge with SAP R/3, ECC, SAP Security, BW, CRM and SD. As Consultant and full time DBA, I have expertise in day-to-day DBA operations involving space management, user management, performance monitoring and tuning, backup and recovery. I have worked on Sybase since version 4.9 and have performed upgrades to 10.x, 11.9, 12.5, 15.x and 16.0. I have worked with Microsoft, Oracle databases and other vendors for supporting basis admin, database management systems and teams.SAP Project Experience - Detail

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

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 the status of the project.
• Responsible for the business/technical interface required between the Implementing partner and client team for the 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 with 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 i.e. demonstrate leadership experience in upfront projects
• Installation, Setup and Support of SAP SLT server.
• Handling onsite / offshore teams as SAP ECC Admin and Hana Architect.

Confidential, Somers, NY

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 the client; direct on-time, quality delivery of work products; manage engagement economics; manage engagement risk. Manage day to day interactions with SAP HANA clients and sponsor
• Updated with the latest releases by SAP in the area of HANA (Side Car functionalities, Suite on HANA, S4 HANA, etc.)
• Lead the 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 knowledge 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 with reporting specially handling complex scenario's using joins and sql.
• Collect business requirements and define functional & technical specifications.
• Preparing various documents related to the 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 with HANA schemas and packages

Confidential Metal, Pittsburgh

Responsibilities:

• Perform R/3 and ECC-Netweaver Installations, User administration, GRC, Security, Transport Management System (TMS), Client Administration including client copy and remote client copy. Work as part of a team that focused on the SAP's ECC 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 that ranges from consulting, project management, product management, and development as well as technology aspects like ABAP and BW.
• Responsible for architecting solution using HANA, BODS and BEx
• Responsible for gathering requirements and creating functional specifications
• Provide periodic updates to client on the status of the project.
• Responsible for the business/technical interface required between the Implementing partner and client team for the execution of this project.
• Excellent communication and technical skills
• Ability to travel 100%
• 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 with the ability to exercise mature judgment.
• Willingness to mentor junior staff.
• Candidate should have about 6 years of experience in SAP HANA
• Having more than 15+ years of experience in SAP Basis/DB administration
• Solution design and architecting experience in OLAP space
• Experience in handling customers, good in presentation
• Experience in offshore-onsite coordination
• Experience in understanding the business requirements and support the users
• Able to interact with customer and taking decisions independently
• Expertise on HANA modeling for data provisioning and optimizing the models
• Expertise with performance tuning the HANA environment
• Experience modeling as-is and to-be architectures based on business requirements
• Initialize the project by establishing all known requirements as well as surfacing unknowns.
• Establish anticipated growth patterns of the database and connections to legacy data sources.
• Provide senior level perspective and experience to guide the customer to the proper physical and logical design of the HANA data warehouse.
• Working with the SAP Data Services consultant, identify replication scenarios for the data warehouse, including but not limited to SAP Landscape Transformation (SLT) or SAP BO Data Services setup for periodic replication from non-SAP Business Suite applications.
• Perform logical design of the HANA database, taking into account the growth in size, scope, and users this database will see as in the longer term it connects to other data sources and adds further diverse users.
• Provided guidance for the physical design of the HANA database, accounting for growth in size, concurrency and performance, backup/recovery/failover and other requirements of a mission critical database system.
• Ensure the strategy for the HANA data warehouse aligns with the SAP product strategy.
• Document the implementation steps and resources into a plan, incorporating SAP and customer resources.
• Work with the customer database and operations staff to ensure the HANA database design fits into their existing operational and security schemes.
• Establish that the HANA database is installed and configured correctly.
• Confirm that the HANA appliance is configured and has the required growth capacity.
• Work with the SAP Data Services consultant and customer resources to implement and test the agreed upon replication scheme
• Extreme communication and organizational skills
• Comprehensive SAP product knowledge (ECC, SD, FICO, CRM, SCM, PI/PO, PLM, BI/BO, SAP Solution Manager, SAP BW on HANA)
• Upgrade to the latest stable HANA SPS versions from Version 97, on all the HANA VM’s
• Install and configure the DR server and synchronization between the Prod’s and DR’s.
• Check authorizations and all the important points as part of the post check.
• System sync between all Dev/QA and Prod if needed.
• Run tests to make sure all the systems upgraded are performing at their optimal levels.
• Extensive knowledge of SAP HANA implementations and migrations is preferred
• Experience with providing assessment of high level estimates based on understanding of scope
• Proficient in the 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 the 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 with enterprise server and storage networking projects in support of SAP in large-scale environments.
• Candidate should have 8-10 years of experience in SAP Security with strong knowledge on SAP BI, SAP BOBJ and HANA Security.
• Responsible for the 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 with 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
• SAP BW on HANA system
• ABAP
• SAP BI/BW
• Data warehouse
• Business Objects

Senior Database Administrator

• I have worked for several clients and employers over the years as Sybase/SQL Server/Oracle DBA
• These include Confidential (Pittsburgh), Confidential (Raleigh), Confidential (Virginia). I have thorough and in-depth knowledge of Sybase ASE, Replication Server. I have expertise in automating day to day monitoring, performance tuning, production moves, user management, security management, space management and upgrades using unix shell scripting.