PROFESSIONAL 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.
• Worked on SAP BW/BI security- work authorizations.
• 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 I-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 i-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) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
• Strong Exposure to SQL, PL/SQL, RDBMS, Oracle 8i/9i/10g and MS SQL 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, San Jose, 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.
• Modified and created standard and right optimized DSO’s and CUBES.
• Creating of the attribute, Analytic and calculation views as per the existing flow.
• Worked in HANA Encoding, Decoding and merge techniques.
• Worked in HANA Applications SLT, SDA, SDI, BODS and DCX implementation techniques.
• Created HANA data foundation join types and attribute view subtypes.
• Created HANA variables, calculated columns and restricted columns in analytical views.
• Excellent knowledge in creating hierarchies in HANA flat form.
• Having very good knowledge in filling time variables sys BI package.
• Worked on WEBi reports on top of Bex queries using OLAP connection to SAP BW using BICS.
• Create Universe using IDT (Information design tool) and UDS (Universe design Tool) for single data sources on
• Create the IDT tool for creating the universe
• Using relational and OLAP connections and published the connections to secured repository by creating the connection shortcuts.
• Create the relational connections using JDBC and ODBC connections on SAP HANA.
• Create the data foundation based on SAP HANA tables
• Create the OLAP connections to SAP BW using BICS connection
• Create the business layer for data foundation on a SAP HANA
• Worked on SQL in IDT data foundation measures calculations.
• 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.
• SAP BI/BW,SAP-HANA, SAP BI-ABAP, SAP BOBJ, BODS
• Functional Areas SAP SD

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 with onshore team for functional requirement gathering
• Creation of dataflow diagrams using LSA / LSA++, technical design
• Design of BW semantics for consumption into BO reporting’s B) Migration of SAP BW 7.0 to SAP BW 7.4
• 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 i.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.
• Worked on authorizations
• Infoobject Authorization(RSD1) and Analysis Authorization(RSECADMIN)
• Authorize Characteristic Values
• Authorize Attribute Values
• Authorize Hierarchies
• Add Special Authorization Characteristics
• Add Key Figure Authorizations
• Add Variables in Authorizations
• Authorizing Navigational Attributes
• SAP BW business content authorization
• Data store object(DSO) authorizations
• Assigning authorization to user roles
• Individual
• Group
• Role maintenance
• Migrate authorization( Confidential MIGRATION)
• Understanding of the requirement and existing flow in order to develop the existing reports in HANA model.
• Creating of the attribute, Analytic and calculation views as per the existing flow.
• 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 views.
• Excellent knowledge in creating hierarchies in HANA flat form.
• Having very good knowledge in filling time variables sys BI package.
• Create Universe using IDT (Information design tool) and UDS (Universe design Tool) for single data sources on
• Create the IDT tool for creating the universe
• Using relational and OLAP connections and published the connections to secured repository by creating the connection shortcuts.
• Create the relational connections using JDBC and ODBC connections on SAP HANA.
• Create the data foundation based on SAP HANA tables
• Create the OLAP connections to SAP BW using BICS connection
• Create the business layer for data foundation on a SAP HANA
• 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
• SAP BI/BW/HANA/ABAP/BOBJ/BODS
• SAP BW/BI Security
• Functional Areas: SAP Finance, PM

Confidential, San Jose, 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.
• Creating of the attribute, Analytic and calculation views as per the existing flow.
• 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 views.
• Excellent knowledge in creating hierarchies in HANA flat form.
• Having very good knowledge in filling time variables sys BI package.
• Create Universe using IDT (Information design tool) and UDS (Universe design Tool) for single data sources on
• Create the IDT tool for creating the universe
• Using relational and OLAP connections and published the connections to secured repository by creating the connection shortcuts.
• Create the relational connections using JDBC and ODBC connections on SAP HANA.
• Create the data foundation based on SAP HANA tables
• Create the OLAP connections to SAP BW using BICS connection
• Create the business layer for data foundation on a SAP HANA
• Creation of PSA deletion process chains.
• Implement the no of Bex queries as per client requirement.
• Worked on SAP BW/BI security and provided authorization on different levels of user roles
• Participated in functional testing and UAT.
• Prepare the functional and technical specs.
• SAP BI/BW/HANA/ABAP/BOBJ/BODS
• SAP BW/BI Security
• Functional Areas: SAP Finance, PM, PS, SD.

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.
• Create OLAP connections to SAP BW using BICS connections.
• Create WEBI reports on SAP BW Bex queries.
• 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.
• SAP BI/BW/ABAP/BOBJ

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 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
• SAP BI/BW/ABAP/BOBJ

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 (Data Store Object) to load data into BI system.
• SAP BW/ABAP

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 Confidential ’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
• SAP ABAP-HR
• Functional Areas: SAP HCM.

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 Confidential programs to upload customer master data.
• Developed reports to list Sold-To party and Ship-To party based on sales area Data Conversions & Confidential
• Developed Confidential 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 that displays all the 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 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
• SAP ABAP

Confidential

Software Engineer

Responsibilities:

• 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