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 the 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 the custom function modules.
• Expertise in implement the ABAP logic in DTP and info packages as per the requirement
• Experience to implement the custom FM for virtual info providers
• Expertise to implement the me-Step logics for query variables as per the requirement.
• Excellent knowledge to optimize the code without disturbing the existing logic.
• Excellent skill to improve the 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 the DI scripting for different functionalities, including FTP the files to the 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 with visual effect 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 with 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 EXPERINCE

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 the modelling, extraction and reporting on SAP SD, PS flows.
• Worked on Bex designer and Bex analyzer and developed the BOBJ reports on Bex.
• Worked on ETL tool BODS in order to get the 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 the high priority tickets assigned in JIRA system and completed the tickets on SLA.
• Distribute the work among team members schedule the meetings and monitoring the team work.
• Gathering of functional inputs in co-ordination with ERP consultants
• Creating the Technical specs and uploading the approved documents into solution manager system.

Technical Skills: SAP BI/BW, SAP BI-ABAP, SAP BOBJ, BODS Functional Areas SAP SD

Confidential, Santa Barbara, CA

Team Lead

Responsibilities:

• Worked as a SAP BI/BW team lead and participated in the technical development.
• A) Migration of OTC / FIN work stream from ECC 4.3 to ECC 6.0
• Responsible for working as OTC work stream lead
• Understanding existing business reports which needs to be migrated
• Co-ordination with 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 with FM(Full and Delta).
• Back up all start, end and expert routines codes and optimized and insert the code after migration without effecting the logic.
• Creation and execution of DTP with filters and without filters.
• Checked for functioning of interactive DTP code.
• Aggregation behavior with and without 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 with replacement path
• Query execution with RRMX
• Creation and execution APD’S
• Check the open-hub and infospoke extractions and check their ABAP code.
• Run the SE38mprograms.

Confidential, Sanjose, CA

Senior Software Engineer

Responsibilities:

• Implement the SAP 7.0 to SAP 7.4 upgrade project.
• Involved in active coding in ABAP during upgradation.
• Worked on optimize the ABAP code in start routine, End routine and infoobject routine code.
• Participated in performance improve the ABAP code.
• Process chain decision making code SE38.
• Creation of PSA deletion process chains.
• Implement the no of Bex queries as per client requirement.
• Participated in functional testing and UAT.
• Prepare the 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 the 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 the resolution documents, test scripts and update the FS and TS documents.
• Worked on move the transports from development to quality and production systems without fails and check the dependent objects.
• Monitoring the daily scheduled jobs and clear the failed process chains in production.
• Prepare and update the daily status to onsite team members.

Confidential, Windsor, UK

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 the technical document for the entire solution
• Used DTP routines, filters, and OLAP variables for loading current and previous week data
• Created unit test document for the entire solution
• Involved in preparing in test data for the solution for testers
• Involved in writing start, end routines and filed level routines for fetching the data according to the requirement
• Created process chains for master data and transaction data
• Collected transports for the entire solution
• Enhanced data sources for according to the gap analysis
• Involved in the 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 the 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 the 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 the Data source using Function Modules
• Developed the Hierarchy files by using ABAP program
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Used Write-Optimized DSO (DataStore Object) to load data into BI system.

Confidential

Senior Consultant

Responsibilities:

• Implement the 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 the 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 the 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 the ordered quantity with the received quantity.
• Developed an Interactive Report dat displays all the sales orders for one particular customer, items for dat particular order, quantity ordered, goods issue date, and contact information about dat customer.
• Developed reports in SD open sales order dat covers all organization levels, delivery status Shipping details and partner function details.
• Using SMART FORMS HR F03 PPFF for the function module FB MIGRATE FORM which migrates all SAP SCRIPT forms automatically.
• Developed an interface using IDOC and ALE to pass out the goods issue data from SAP to the legacy systems
• Set up and monitored the 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
• Functional design understanding and interactions with 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 the weekly and monthly status reports

Confidential, Brisbane, CA

Computer Engineer

Responsibilities:

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