SUMMARY

• Around 10 years of experience in SAP - HANA, SAP-BI/BW, SAP-ABAP, SAP-BOBJ and ETL tool BODS.
• Having very good and excellent working experience in SAP ABAP programming and code optimization and performance improvement techniques in SAP ABAP.
• Excellent hands on project experience in SAP BW upgradation projects from version SAP BW 3.x, 7.0 to SAP BW 7.4 version and SAP HANA integration.
• Having hands on experience in development and get teh data from SAP CRM and SAP SRM systems by using standard and custom extractors.
• Having good integrated knowledge in CRM and SRM systems.
• Configuration and customization of business Role, work center groups. Customizing of Navigation Bar Profile & Personalization of CRM Web Client UI,Design Layer and AET.
• Excellent knowledge in CRM systems in utilities.
• Excellent knowledge in SAP BI/BW enhance objects such as infoobjects, Infocubes, infosource/Data source, Master data, Transformations, DSO’s, Infosets, Aggregates, Process chains and User Exits.
• Very good hands on experience in data extraction using LO cockpit, flat files and generic data sources using FM’s.
• Excellent working knowledge in extraction of data from BW to external systems using Open hub and Infospoke destinations.
• Excellent hands on experience on LSA/LSA++ architecture implementation in SAP BI/BW.
• Excellent working knowledge in SAP BW reporting tool Bex designer and Bex Analyzer.
• Very good knowledge in Bex variables and variable me-step’s coding techniques using user exits as well as BADI’s.
• Extensive 3 years of experience in SAP HR and HR-ABAP in modules PA, Payroll, Organizational Management and travel management.
• Expertise in start routines, end routines and expert routines
• Expertise in implement teh custom function modules.
• Expertise in implement teh ABAP logic in DTP and info packages as per teh requirement
• Experience to implement teh custom FM for virtual info providers
• Expertise to implement teh me-Step logics for query variables as per teh requirement.
• Excellent knowledge to optimize teh code wifout disturbing teh existing logic.
• Excellent skill to improve teh ABAP coding performance.
• Excellent ABAP debugging skills.
• Excellent hands on experience in HANA modeling using attribute vies, Analytical and Calculation vies.
• Excellent knowledge in HANA Encoding, Decoding and merge techniques.
• Excellent knowledge in HANA Applications SLT, SDA, SDI, BODS and DCX implementation techniques.
• Very good knowledge in HANA data foundation join types and attribute view subtypes.
• Excellent knowledge in HANA variables, calculated columns and restricted columns in analytical vies.
• Excellent knowledge in creating hierarchies in HANA flat form.
• Having very good knowledge in filling time variables sys BI package.
• Data Extraction, Transforming and Loading (ETL) usingBusiness Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Worked in multiple responsibilities includingETL architecture,ETL design,analysis and development, writing technical specifications.
• Strong Exposure toSQL,PL/SQL,RDBMS,Oracle8i/9i/10gandMSSQL Server 2005
• Created projects, batch jobs, Real time jobs, work flows and data flows
• Worked on teh DI scripting for different functionalities, including FTP teh files to teh exchange servers etc.
• Tested data flows and scripts against sample data and real data
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart and Power Center and Data Integrator.
• Developing highly complex reports using reporter used various techniques like Master-details sectioning, filters, slice and dice; generating sub reports, standard, mailing labels, cross tab reports and graph reports by using chart expert of crystal reports. strong knowledge in developing BO-WEBI reports using Bex query designer and Bex analyzer.
• Experience in building BO Universes, stored procedures, free hand SQL methods and creating complex and AD-HOC reports using BO reporting tools like WEBI/Desktop Intelligent/crystal reports and interactive dashboard wif visual TEMPeffect using Xcelsius.
• Crystal reports expertise in creating business views (creation of connections, dynamic data connection, data foundation, business elements and business views) and reports using business views.
• Design and development of BI solution and preparation of POC and documentation.
• Designing and development of methodology of programming in ABAP. Developing and interpreting functional & technical design for Interfaces, Enhancements and Conversions.
• Experience in performance tuning, Testing and Optimization of reports. Analyzing, developing and completing assigned break/fix requests.
• Participated in System Unit, Performance and User Acceptance Testing.
• Ability to design documents and suggest solutions as and when needed.
• Well versed wif complete Life Cycle Development process which includes Designing, Developing Testing and Implementation.

TECHNICAL SKILLS

Operating System: Window 2007, Windows XP

Languages: ABAP, HR-ABAP, C, Pascal,.NET

DBMS/RDBMS: Oracle 8i, SQL, PL/SQL

Reporting tools: Bex, WEBI, Excel, HANA Studio

ERP: SAP R/3.1, 4.6c, 4.7, ECC6.0, SAP BI, SAP BO

PROFESSIONAL EXPERIENCE

Confidential, Sanjose, CA

Team Lead

Responsibilities:

• Working as a SAP BI/BW developer and leading 8 consultant team
• Developed SAP SD, PS flows in SAP BW/HANA systems
• Developed teh modelling, extraction and reporting on SAP SD, PS flows.
• Worked on Bex designer and Bex analyzer and developed teh BOBJ reports on Bex.
• Worked on ETL tool BODS in order to get teh data from external system to SAP BW as well HANA systems.
• Developed BBRB (Billing, Blocking, Backlog and receiving) flows on SAP SD and PS systems
• Modified and created standard and right optimized DSO’s and CUBES.
• Worked on start routine, end routine and expert routine codes in ABAP
• Developed ABAP decision making programs in SE 38 for process chains
• Worked on DTP and infopackage static and dynamic filter programming in ABAP
• Developed generic extractors using FM (Function Modules) in source system.
• Monitoring daily process chains and take necessary action fails if any.
• Working on teh high priority tickets assigned in JIRA system and completed teh tickets on SLA.
• Distribute teh work among team members schedule teh meetings and monitoring teh team work.
• Gathering of functional inputs in co-ordination wif ERP consultants
• Creating teh Technical specs and uploading teh approved documents into solution manager system.

Confidential, Santa Barbara, CA

Team Lead

Responsibilities:

• Responsible for working as OTC work stream lead
• Understanding existing business reports which needs to be migrated
• Co-ordination wif onshore team for functional requirement gathering
• Creation of dataflow diagrams using LSA / LSA++, technical design, build, CT/AT
• Design of BW semantics for consumption into BO reporting’s
• Extraction of LO Data sources of FIN and SD modules
• Developed existing and new generic data sources wif FM(Full and Delta).
• Back up all start, end and expert routines codes and optimized and insert teh code after migration wifout TEMPeffecting teh logic.
• Creation and execution of DTP wif filters and wifout filters.
• Checked for functioning of interactive DTP code.
• Aggregation behavior wif and wifout start routine.
• Overwrite and additive functionality of transformation
• Delta functionality in DSO and change log entry creation
• DSO data load and activation of DSO data
• Delete and creation of indexes.
• Cube compression
• Roll up aggregations
• Request deletion in DSO/CUBE
• Run process chains for master data.
• Run process chain for transactional loads me.e source system extraction to aggregate roll up.
• Execution of ABAP programs using process chains.
• Deletion of PSA and changelog using process chains
• Execution of report on Bex, RSRT
• Customer exit variables
• Virtual characteristics/key figures
• Check for formula variables
• Run time unit and currency conversion
• Hierarchy variables and hierarchy
• Text variables wif replacement path
• Query execution wif RRMX
• Creation and execution APD’S
• Check teh open-hub and infospoke extractions and check their ABAP code.
• Run teh SE38mprograms.
• Understanding of teh requirement and existing flow in order to develop teh existing reports in HANA model.
• Creating of teh attribute, Analytic and calculation views as per teh existing flow.
• Understanding existing transactional flow which needs to be validated
• Design of data validation flow
• Creation of BW report for data comparison
• Understanding source for extraction of real time data
• Design of data flow in SAP BW for enabling real time environment
• Creation of BW report for real time data

Confidential, Sanjose, CA

Senior Software Engineer

Responsibilities:

• Implement teh SAP 7.0 to SAP 7.4 upgrade project.
• Involved in active coding in ABAP during upgradation.
• Worked on optimize teh ABAP code in start routine, End routine and infoobject routine code.
• Participated in performance improve teh ABAP code.
• Process chain decision making code SE38.
• Creation of PSA deletion process chains.
• Implement teh no of Bex queries as per client requirement.
• Participated in functional testing and UAT.
• Prepare teh functional and technical specs.

Confidential, Huston, TX

Senior Consultant

Responsibilities:

• Worked as a SAP BI/BW/BO consultant for utility project.
• Involved in support tickets analysis and assign tickets to relevant team member as priority.
• Worked on issues as a support team member in order to resolve teh tickets in different modules SD, PM and FI-CO
• Contribute and provide extensive support to team members where ABAP coding required.
• Worked on SAP BO report issues and provide my support in BO to my team members.
• Prepared teh resolution documents, test scripts and update teh FS and TS documents.
• Worked on move teh transports from development to quality and production systems wifout fails and check teh dependent objects.
• Monitoring teh daily scheduled jobs and clear teh failed process chains in production.
• Prepare and update teh daily status to onsite team members.

Confidential

Senior Consultant

Responsibilities:

• Involved in designing Functional specs and writing technical specs
• Requirement gathering and gap analysis
• Implemented LSA (layered scalable architecture) for data historical data retention
• Designed teh technical document for teh entire solution
• Used DTP routines, filters, and OLAP variables for loading current and previous week data
• Created unit test document for teh entire solution
• Involved in preparing in test data for teh solution for testers
• Involved in writing start, end routines and filed level routines for fetching teh data according to teh requirement
• Created process chains for master data and transaction data
• Collected transports for teh entire solution
• Enhanced data sources for according to teh gap analysis
• Involved in teh cut-over activities for loading data in quality
• Maintained manual configuration of master data
• Used DSO look-ups at start routine and end routine
• Created Bex Reports for Business objects universe
• Created structures and variables for teh reports
• Used BADI’s for data source enhancement and front end variables

Confidential

Senior Consultant

Responsibilities:

• Implemented in newer SAP version 7.4
• Involved in modeling teh standard DSO’s, Direct update DSO, Basic info cube.
• Designed Reports in query designer using CKF, RKF, Formula, variables.
• Extracted transaction and Master Data from ECC and Flat files.
• Retraction data from BPC to BW for various modules like SD, Finance and project systems by using APD tool
• Create teh Data source using Function Modules
• Developed teh Hierarchy files by using ABAP program
• Created Data Transfer Process (DTP) to transfer data wifin BI from one persistent object to another object.
• Used Direct Update DSO in teh process of APD (Analysis Process Designer).
• Used Write-Optimized DSO (DataStore Object) to load data into BI system.

Confidential

Senior Consultant

Responsibilities:

• Implement teh SAP HR modules personal administration(PA), Organizational Management(OM), Payroll(PY), Time management and Travel management.
• Payroll programming using Logical Database
• Worked on Indirect evaluation and Dynamic Actions
• Uploading of data using HR function modules
• Implement teh HR ABAP code in PA, OM, and TM Modules using LDB’s
• Creation of custom Infotypes and Enhancements to standard Infotypes
• Developed Classical, Interactive report and ALV reports.
• Developed HR master and cluster Developments Interactive ALV Reports
• Developed few mass data upload programs usi,ng BDC’s Session, Call Transaction, and LSMW and
• Developed an Inbound Interface to upload HR Master Data to infotypes like recurring payments/deductions, date specification of employees using transaction code ‘PA30’.
• Worked on different wage types and generate employee tax reports for different countries
• Payroll Calculations,Payroll Schemas, Payroll Areas
• Off-cycle Workbench.
• US Benefits, Enrollment, Plan Categories, Plan Types.
• Wage types, wage type controls

Confidential, Richmond, VA

Analyst Programmer

Responsibilities:

• Involved in writing Batch Data Communication programs for transferring teh vendor master legacy data to SAP R/3 system using Batch Input method.
• Designed BDC programs to upload customer master data.
• Developed reports to list Sold-To party and Ship-To party based on sales area Data Conversions & BDC
• Developed BDC Programs to update and change Customer Master Data by Call transaction for transactions XD02 and FD32 to update KNA1 and KNKK tables retrieving from MS Excel Sheet
• Developed ALV reports for purchase orders to compare teh ordered quantity wif teh received quantity.
• Developed an Interactive Report that displays all teh sales orders for one particular customer, items for that particular order, quantity ordered, goods issue date, and contact information about that customer.
• Developed reports in SD open sales order that covers all organization levels, delivery status Shipping details and partner function details.
• Using SMART FORMS HR F03 PPFF for teh function module FB MIGRATE FORM which migrates all SAP SCRIPT forms automatically.
• Developed an interface using IDOC and ALE to pass out teh goods issue data from SAP to teh legacy systems
• Set up and monitored teh communication links between SAP and other systems using IDOC/ALE for Master Data maintenance and EDI Transactions.
• Worked on up gradation project and upgraded ABAP objects from enterprise 4.7 version to ECC 5.0 version

Confidential

Software Engineer

Responsibilities:

• Functional design understanding and interactions wif onsite on phone calls as well as mails in functional design walk-through.
• Technical Document design.
• Coding, unit testing & test script preparations.
• Participating in UAT.
• Preparing status reports and presenting to upper management.
• Preparing teh weekly and monthly status reports

Confidential, Brisbane, CA

Computer Engineer

Responsibilities:

• Implement teh Payroll reports for US employees
• Developed teh tax reports for employees working location as well resident locations.
• Developed different Wage type reports in ALV grid display.
• Developed mass upload teh data in BDC session, transaction and LSMW methods using PA30 transaction code.
• Developed teh technical specifications after functional specs signed off.
• Prepared teh test cases and test scripts for technical developments across teh team.
• Developed employee reports using LDB’s PNP, PNC, PAP.
• Created new custom infotypes and enhance teh standard infotypes as per teh requirement.