SUMMARY

• Having 10+ years of IT experience in design, development, implementation and testing using SAP BI/BW On HANA, SAP ABAP,SAP BO, SAP FSCM, SAP FICO
• Extensive project experience using SAP HANA, SAP BW on HANA, SAP BI 7.0/7.3/7.4, SAP ABAP,
• Experience in delivery of numerous support and Implementation projects consisting of Multi - disciplinary terms and cross-functional responsibilities.
• Mastery level of knowledge with BW configuration of BW data objects including Info Object, Info source, t ransfer/Update Rules, ODS, Info Providers, Multiproviders, Master Data, Open Hub Service, Data Mart, BW Transports, and BI content. Advanced DSO, Composite provider.
• Excellent Experience working on SAP HANA 1.0, Data Modelling (Attribute Views, Analytic Views and Calculation Views ), Data Perspectives (SLT, BODS, DXC and Flat files ), SQL Script - CE Functions and Stored Procedures.
• Extensive knowledge on Development, roll out and support of SAP BW on Hana and SAP ABAP Applications.
• Customizations: - Business Contents enhancements, Data Source enhancements, Generic extractors, user Exits and customized delta built up for the Data Sources, update/transfer rules creation
• Strong background in multiple database technologies to design data models and analytical apps Experience with SAP ECC table data model and analysis.
• Strong experience in Transportation Management and good Functional and domain knowledge on Production Planning, Sales and Distribution, Finance, Inventory Management, Insurance, Claims Management.
• Experience in migrating 3.X objects to 7.X Objects in SAP BW 7.4.
• Worked on SAP BW Testing while migrating from Oracle data base to HANA Data Base.
• Good Hands on Experience Using HPQC Testing and automation Tool.
• Experienced in SAP Business warehousing concepts, Designing effective client specific BW systems, Data Modelling, Performance Tuning, Data Extraction and Data loading for both application specific as well as generic from R/3, ECC, CRM, and Non SAP systems
• Experience in designing comprehensive BI solutions, translating complex requirements into an optimal BI solutions.
• Implemented SAP ABAP programs to roll out the DTP selections automatically without any manual interventions.
• Designed and developed SAP ABAP Programs to compare two remote cubes/Multiproviders/DSO without any manual intervention.
• Created Transport utility program to check the Transports order and system implemented date and Time.
• Implemented file comparison utility program in SAP BW.
• Design Experience with SAP BW development life cycle from design through implementation and production support.
• Created InfoCube, Multi provider comparison program across the systems.
• Good knowledge on SAP BPC10.0.
• BW reporting: BEx business explorer, analyzer, business browser, restricted key figures, calculated key figures, structure, variables, Exceptions, conditions, RRI, info set query, and (WAD), web reporting
• Experience in Creating Adhoc Reports using Web Intelligence Rich Client and schedule the reports as per the business needs and supporting.
• Created Analysis for office reports on top of BW BEx Query and HANA Views & did testing for data validation.
• Designed and developed Webi reports on top of HANA views
• Modifying existing WEBI reports and supporting the UAT process.
• Developed Webi Reports in BI 4.0/4.1 on top of BEx Queries
• Created OLEDB Reports based on BEx Queries.
• BW security: reporting authorization, user profile maintenance (PFCG) Customization data source
• Enhancement, Generic extractors, and user exits and customized delta built up for the data source update/transfer rules creation.
• BW administration: use process chain extensively to administrator background process in BW.
• BW operations: Data load management, event processing and reporting optimization.

TECHNICAL SKILLS

• Business Intelligence: SAP BW 7.4, SAP BI 7.3, SAP BI 7.0, BEx Query Designer, BEx Analyzer, Webi Reporting, SAP Hana Studio 1.0, SSP 8, 9, 10, 11, SAP BO.
• Databases: SAP HANA, Oracle 11g/10g, SQL Server, DB2, Teradata.
• Environment: s: Win XP/ 2000/2003/2007, Windows server 2008/2012.
• Programming Language: SAP ABAP/4,SQL, SAP FICO, SAP FS - CM, Knowledge on SAP BPC

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAP BW on HANA with ABAP, SAP BO

Responsibilities:

• Worked with business process owners, stakeholders to understand and document the requirements. Interacted with the managers to understand the business requirements and implemented the business rules to redesign and enhance the existing data flows.
• Creation of HANA Optimized cubes Composite Providers, Advanced DSO, and Open ODS Views for BW-on-HANA using Eclipse.
• Expertise on SAP BW on HANA Implementation Project and performed duties related to SAP BW/BO
• Expertise knowledge in SLT (System Landscape Transformation).
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• As Part of Production Support and Development Lead worked on Production system monitoring and Good Working Experience in Solving Level1 Incidents.
• Via SM37, SM66, TRFC IDOCS execution in SM58 and SM50 and working with development team on Daily Project status.
• Expertise in Project plan creation and requirement analysis.
• Solving the Incidents based on the priority as a first point of Contact
• Built, tested and deployed salable, highly available and modular software products.
• Streamlined deployment process by developing continuous integration tools.
• Strengthened developmental methodologies by introducing a code quality document.
• Expertise in all major and minor releases for all the development tasks.
• Involved in Client coordination meetings on whole production systems which is not limited to SAP BW on HANA but also the upstream and downstream systems.
• Actively working on the problem tickets which were assigned to SAP BW Production systems and completing them on time with in the SLA.
• Coordinating the SAP BW Production support with the offshore and distributing the work accordingly.
• Expertise in SAP BPC 10.0 Implementation and form SAP BW side has involved in coding logic to push the desired data to SAP BPC10.0
• Development of SAP BI objects, creation of process chains as per client requirement to schedule to Load master data, transaction data loads.
• Designing of Info spokes/Open Hub Destinations to extract data from SAP BI objects to upload third Party systems.
• Scheduling of Master, transaction loads periodically and monitored them. If failed error data packet were analyzed, scheduled manually and completed successfully.

Environment: SAP BW7.4, SAP BI 7.3, WEBI, and Analysis for office, SAP Business Objects 4.1, BEx Designer and analyzer SAP FICO, SAP ABAP/4

Confidential

SAP BW on HANA

Responsibilities:

• As a Sr. Developer distributing the work and reviewing the task done by the team member.
• Involved in all major release Developments Jobs Monitoring and Acknowledging ABAP
• Incidents/Problem tickets and solving them with in SLA.
• Designing of Suedo codes for SAP BI objects to upload third party systems.
• Scheduling of Master, transaction loads periodically and monitored them. If failed error data packet
• Were analyzed, scheduled manually and completed successfully.
• Worked on Adhoc data issues. Worked on process integration related issues and solved CA7 batch
• Jobs failures with in SLA.
• Preparation test data, test conducts on developed objects.
• Creation of documentation of newly created objects, documentation of test results. Worked on
• Production support related issues.
• Ensure to deliver quality end product to the client.

Environment: SAP FS-CM (Claims management), SAP ABAP/4.

Confidential

Sr. Associate Consultant

Responsibilities:

• List of Orders (Both Depot Stock Transfer and Direct Sales Orders) for which due in delivery. This Consider both OPEN ORDERS and DELIVERY DUES. The List generated by Standard Transaction VL04 is not serving their purpose. This Report gives the output with fields Order No., Sold-To-Party, Ship-To-Party, Actual Delivery Date, Actual Order Qty, Total Delivered Qty, Due Qty, and today program, all the data is displayed in ALV format.
• Modified a report to list frequently shipped products. This report helps in demand management, based on the frequency of shipment; the company can plan the procurement of raw materials and hence meet the needs of production in time.
• Modified existing Invoice report by adding two new fields, condition type and description.
• Generated a Interactive report that displays the Customer details like name, address, company, bank, transaction, sales history and payment history details.
• Modified the SAP standard layout set RVORDER01 for Customer Quotation as per the specifications.
• Modified the layout set MEDRUCK for purchase order to add company’s address and logo and standard text
• Develop a drill/interactive report for particular sales org. List drills up to 5 levels to which basic list displays List of all sales offices. First Level displays Sales group details. Second level displays Material Group 1 details. Third level displays Material Group 2 details. Fourth level displays Sold-To Customer details. Fifth level (last) displays the corresponding Sales documents, all the data is displayed in ALV format.
• Created an Interactive report for Basic vendor’s list. The list includes details of vendor such as vendor’s number and vendor’s name, item ordered on that vendor, the P.O. number and total amount would display as drill down reports.
• Report to generate sales order details, delivery details, shipping details & billing details for the selected Sales document Number. All the details should be displayed on different lists.
• Developed a report that displays the list of accounting documents for a particular fiscal year.
• Developed a BDC program for uploading material details through recording.
• Uploading data from data set to vendor master.

Environment: SAP-R/3 V4.6C, 4.7 & 3.1i, ECC 6.0.

Confidential

SAP ABAP Consultant

Responsibilities:

• Review the functional specifications & understanding business requirements.
• Preparation of technical specifications according to the functional specifications.
• Worked on SD, MM as part of the team responsible for developing reports for the project.
• Developed the monthly manufacturing plan from SAP to carry out their monthly production.
• Developed a billing information interactive report through ALV.
• Developed a hierarchal ALV report which displays sales order header and item details.
• Created an Interactive report for Basic vendor’s list. The list includes details of vendor such as vendor’s number and vendor’s name, item ordered on that vendor, the P.O. number and total amount would display as drill down reports.
• Developed a BDC program for uploading Customer Master & Vendor Master records.
• Developed a BDC Program to migrate Purchase requisition data.
• Modified the Order layout set with slight changes in the terms and conditions, date format.
• Modified the layout set for sales order and corresponding print program modified as per the client’s requirements.
• Involved in a team comprising of 5 members which are in technical and application support functionalities
• Involved in giving support to the clients over the phone, email and in person to the client locations
• Job involves adding article in K-base for the new and critical issues faced from the clients on the applications used.

Environment: SAP-R/3 V4.6C, 4.7 & 3.1i, ECC 6.0.