SUMMARY

• Over 12 years in IT extensive experience in SAP BI BW HANA
• Technical expertise includes Extraction, Data Modeling and Reporting using Bex.
• Also TEMPhas knowledge on ABAP.
• Having good working knowledges on Business Objects and Data Services (BODS) & HANA (Admin)
• Handling teh tickets.
• Having good experience as HANA consultant.
• Playing teh role of HANA Solution Architect/Team Lead and managing a team of 4 developers
• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
• Scheduled real time data load into HANA by using SLT both initial load and continuous replication.
• Experienced in writing complex SQL Scripts, Procedure and CE Script.
• Conducted SAP HANA Overview session for teh customer & done assessment
• Landscape setup: BO4.0 & BW7.3 HANA1.0 server (wif BASIS coordination)
• Application of HANA In-Memory concepts
• Played an Active role in KT Sessions
• Doing analysis about teh tickets and informing same to SME
• Coordinating wif onsite team
• Played an active role in status meetings
• Responsible person to close teh Incidents and never missed SLA
• Involved in client meetings
• Worked on Extractions, Enhancements
• Involved in Bex reports
• Involved in creation of OHD’s
• Involved in creation of Process chains and monitoring teh PC’s
• Involved in SD, Inventory, Purchasing, FI AR AP GL and COPA
• Worked on external sources like informatica and BODS.
• Leading teh Team and assigning tickets to teh team members
• Providing training for teh new joiners
• Involved in Hierarchies

TECHNICAL SKILLS

ERP Applications: SAP BI7.0, BI 7.3, 3.5, 3.OB, R/3 4.7 & ECC 6.0

Languages: ABAP/4, C, JAVA.

Database: Oracle, HANA

Views: Attribute, Analytic & Calculation

HANA SQL: CE Functions, Procedures, DDL, DML & DCL statements

BW on HANA: Good Understanding of BW Upgrade & Migration

Operating System: Windows 9x/XP/2000, Ms-Dos, Linux

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAP BI BW HANA Developer & Lead /Solution Architect

Responsibilities:

• Evaluate OOM/Crash dumps in DEV/STG/PRD
• Migrate HANA SQL Scripts, Model objects from DEV => STG and STG => PRD
• Migrate tables to other nodes in DEV/STG/PRD
• System Performance Monitoring for PRD (checking for locks/long running threads…)
• Deleting/dropping user sessions in DEV/STG/PRD
• Opening OSS messages for issues and collecting dumps for SAP
• Starting/Stopping HANA environments in DEV/STG/PROD
• Replicate tables in SLT - Regular in DEV/STG/PRD
• Reloading tables in SLT DEV/STG/PRD
• Starting/Stopping SLT environments in DEV/STG/PROD
• Migrate DS objects from DEV => STG and STG => PRD
• Create/configure/delete user repositories in DEV environment
• Creating new data store objects in Data Services
• DS related login issues to Admin Console in DEV/STG/PRD
• Starting/stopping data services instances for hung situation in DEV/STG/PRD
• Involved in creation of Hana Objects as a Hana Modeler
• Application of HANA In-Memory concepts

Confidential, San Francisco, CA

SAP BI BW HANA Developer & Lead /Solution Architect

Responsibilities:

• Handling teh tickets.
• Played an Active role in KT Sessions
• Doing analysis about teh tickets and informing same to SME
• Coordinating wif onsite team
• Played an active role in status meetings
• Responsible person to close teh Incidents and never missed SLA
• Involved in client meetings
• Worked on Extractions, Enhancements
• Involved in Bex reports
• Involved in creation of OHD’s
• Involved in creation of Process chains and monitoring teh PC’s
• Involved in SD, Inventory, Purchasing, FI AR AP GL and COPA
• Worked on external sources like informatica and BODS.
• Leading teh Team and assigning tickets to teh team members
• Providing training for teh new joiners
• Playing teh role of HANA Solution Architect/Team Lead and managing a team of 4 developers
• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.

Confidential, Princeton, NJ

SAP BI BW HANA Developer & Lead CONSULTANT

Responsibilities:

• Handling teh tickets.
• Having good experience as HANA consultant.
• Conducted SAP HANA Overview session for teh customer
• & done assessment
• Landscape setup: BO4.0 & BW7.3 HANA1.0 server (wif
• BASIS coordination)
• Application of HANA In-Memory concepts
• Played an Active role in KT Sessions
• Doing analysis about teh tickets and informing same to SME
• Coordinating wif onsite team
• Played an active role in status meetings
• Responsible person to close teh Incidents and never missed SLA
• Involved in client meetings
• Worked on Extractions, Enhancements
• Involved in Bex reports
• Involved in creation of OHD’s
• Involved in creation of Process chains and monitoring teh PC’s
• Involved in SD, Inventory, Purchasing, FI AR AP GL and COPA
• Worked on external sources like informatica and BODS.
• Application of HANA In-Memory concepts
• Leading teh Team and assigning tickets to teh team members
• Providing training for teh new joiners
• Involved in Hierarchies
• Reports executed by using Lumira
• LANDSCAPE TRANSFORMATION (SLT) to HANA Data Base.
• As part of SAP HANA experience was involved in Implementation.
• Experience on SAP HANA data modelling using Attribute Views, Analytic View and Calculation View.
• Scheduled real time data load into HANA by using SLT both initial load and continuous replication.
• Experienced in writing complex SQL Scripts, Procedure and CE Script.

Confidential, Florham Park, NJ

SAP BI BW Developer & Lead CONSULTANT

Responsibilities:

• Handling teh tickets posted by teh customer
• Created and monitored teh Process Chains
• Involved in SD,MM,FI and HR modules
• Handled typical issues which is posted by teh customer
• Handled Data Load Issues analysis and resolved in teh Process Chains
• Involved in CO-PA Extraction.
• Involved in Data source Enhancements.
• Handle teh Team.
• Involved in Testing
• Played an Active role in KT Sessions
• Doing analysis about teh tickets and informing same to SME
• Played an active role in status meetings
• Responsible person to close teh Incidents and never missed SLA
• Involved in client meetings
• Worked on Extractions, Enhancements
• Involved in Bex reports
• Involved in creation of OHD’s
• Involved in creation of Process chains and monitoring teh PC’s
• Involved in SD, Inventory, Purchasing, FI AR AP GL and COPA
• Leading teh Team and assigning tickets to teh team members

Confidential, Detroit, MI

SAP BI BW Developer & Lead CONSULTANT

Responsibilities:

• Handling teh tickets posted by teh customer
• Created and monitored teh Process Chains
• Involved in SD,MM,FI and HR modules
• Handled typical issues which is posted by teh customer
• Handled Data Load Issues analysis and resolved in teh Process Chains
• Involved in CO-PA Extraction.
• Involved in Data source Enhancements.
• Handle teh Team.
• Involved in Bex Reports and Macros
• Loaded Transaction and Master data when required
• Awarded as TCS GEM
• Assigning work to offshore team
• Involved in client meetings who posted ticket by teh customer
• Involved in requirement gathering
• Involved in loading Flat file data.

Confidential

SAP BI BW Developer CONSULTANT

Responsibilities:

• Standard Business content activation
• Custom reports design and development using BEx Components
• Involved in BIA Indexes
• Involved in Technical Documents
• Involved LO Extraction and Enhancements
• Involved in creation Generic Data Sources
• Loading Transaction and Master Data
• Involved in Migration from 3.x to 7.0
• Created and monitoring teh process chains
• Handling teh tickets posted by teh customer.
• Involved in Security authorization tickets
• Involved in finding and assigning teh roles to teh users.
• Involved in user meeting who posted ticket by teh customer.

Confidential

SAP BI BW Developer CONSULTANT

Responsibilities:

• Extensively worked in Business Information Warehouse Info Cubes, DSO Objects, Info objects, Transfer rules and update rules.
• Installed Business Content as and when required.
• Handled Data Loading Errors at various stages of data Load.
• Involved in Initializing teh LO Data sources by Activating teh Business Content Data Sources, Maintaining teh Extract Structure, Generating teh Data Source.
• Enhanced teh Data Source by using enhancement RSAP0001 to fill teh data into teh Fields newly enhanced.
• Involved in Migration of Data Sources from BW 3.5 to BI 7.0
• Involved in creation of BEx reports.
• Involved in creation of Calculated Key figures, Restricted Key figures and Variables.
• Loading Transaction and Master Data.
• Identifying teh Unit Test Cases
• Involved in Info source Enhancements as and when required.
• To make recommendation for BI Performance tuning to improve teh performance of existing design and also make consideration from BI performance point of view in new design and developments.
• Extensively worked in Process chain
• Design teh process chain or modify existing process chain as per instructions given.
• Administer Process chain activities like monitoring process chain, restarting failed process chain, process chain logs, scheduling teh process chain etc.
• Involved in frequent client meetings to discuss Project status
• Involved in CO-PA Extraction.
• Involved in Data source Enhancements.

Confidential

SAP BW Developer CONSULTANT

Responsibilities:

• Scheduled & monitored daily/weekly/monthly loads.
• Responsible for teh resolution of functional tickets in teh areas of SD, FI and MM.
• To inform teh onsite team if there any deadlocks.
• To communicate wif teh customer who posted teh Ticket.
• Handled teh tickets of priority 1, 2, 3 and 4 by following (SOP) Standard Operating Procedures and never missed teh SLA.
• Involved in both monitoring and Production Support.
• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
• Involved in submitting teh Ticket Status (Open/Close) report.
• Involved in Validated data consistency in reporting wif Data Target against PSA after loading them to data targets.
• Data load issues and Process Chain maintenance.
• Major role done in supporting is to stabilize system wifout getting errors in Process Chains.
• Issue analysis and Resolve.