Sap Bi Analyst Resume
Professional Summary
SAP ABAP Certified Developer and SAP BI (Business Warehouse) Certified Techno Functional Analyst, with extensive experience in implementing and integrating software applications in SAP R/3 and ABAP/4. Green Card Holder. Currently in Process of doing PMP Certification.
- Business Analyst: Key competency in understanding the business process, gathering reporting requirements, documenting Impact Analysis, testing and validation resulting in concise and agreed upon requirements from the business and technical teams. Expertise in effective communication with offsite and offshore resources.
- Business Intelligence: Comprehensive experience with BW tools and techniques including data extraction, transformation and loading, data mart/data warehouse development, operational data stores (ODS / DSO), online analytical processing (OLAP), Info Structures, Info Objects, Info Sources and Info Cubes. Worked extensively in Configuration, Data Extraction and Presentation.
- Specialized in Business Warehouse, and technical expertise in MM, SD, HR, PP, FI/CO, CS and PS modules with excellent experience in data migration using batch data communication, interfaces, work bench report programming (classical, interactive and ALV reports), Dialogue Programming and SAP Scripts.
- Demonstrated capabilities in pre and post implementation production support.
- Flair and passion for training end users and junior programmers in BI, SAP ABAP. Well Versed with OOPS technologies and concepts.
- Key contributor in 5 full life cycle implementations including ABAP development.
Skills/Tools
Business Warehouse: BW 3.0B, BW 3.5, BI 7.0ERP: SAP R/3, 3.1H, 3.1I, 4.0b, 4.6C, 4.7, ECC 6.0
Databases: Oracle, MS SQL, MS Access
Technical Experience
Confidential, Buffalo Grove, IL 2007 - Till Date
SAP BI Analyst 3 / ABAP Developer 2007 - Till Date
- Understanding of the business process to facilitate reporting requirements from the business; combining knowledge of application and documenting IA, assisted in the development of the requirement, testing and validation securing the business acceptance and signoff on the delivered solution. Evaluated user needs and requests; established priorities and time frames for meeting identified needs.
- SAP Reporting Analyst and key point in deciding the tools to be used for reporting based on the requirement analysis from the SAP ABAP, BW, SAP Query, and Report Painter / Writer users.
- Provided technical first level support to the business related to reporting needs and requirements both in SAP R/3 and BW for Global IT infrastructure supporting 8000+ employees throughout U.S.
- Developed the Reports in BW in BEx (Business Explorer) based on user requirements, Created cubes and multi providers as per the requirement.
- Maintained efficient communication with the business and technical team regarding data testing and validation.
- Introduced and trained end users and power users in the functionality and usage of BW as a reporting tool and created extensive documentation and Tips and Tricks to assist in the day-to-day usage of the BW.
- Key point of contact for data migrations for new acquisitions.
- Wrote specifications for modifications and systems enhancements.
- Developed test plans and performed quality control testing to assure the functionality and integrity of system.
- Created and maintained reporting related documentation and provided Tips and Tricks and other helpful documentation to the business.
- Provided user / power user training related to reporting, BW features and functionality.
- Troubleshot production issues and system defects.
- Performed detailed analysis and design of business application systems and programs including data analysis, process flow documentation, defining inputs and outputs and assisting in project task planning.
Projects:BI Technical 3.5-7.0 Upgrade: Major contribution managing the BW upgrade; maintained deadlines, issues log, tested reports and other BW functionality pre and post upgrade; conducted validation and obtained user sign-offs. SAPGUI Upgrade: Key contact for planning and implementing the phased SAPGUI upgrade for 4,000+ remote and home office BI users.
PROJECTS continuedCustomer Focus: Developed the Strategic Reports for Customer Focus in Business Warehouse. Responsible for understanding the business process and gathering and documenting reporting requirements in IA. Assisted in the development of the requirements, testing and validation. Gained business acceptance and signoff on the delivered solution. Evaluated user needs and requests; established priorities and time frames for meeting needs. Reporting Automation: Key member of project team responsible for establishing Metadata for the SharePoint site. This process required automating the reports from R/3 Spool and sending them to the SharePoint site using COMPLIO as a tool.
SAP ABAP Data Migration / ABAP Specialist 2005 - 2007
Responsible for participating in a Siemens Business Services (SBS US) SPIRIDON project with a $74M budget, 120 sites and a 2 year project term. Project was a structured phased-in approach with go-live waves for districts and branches. Customer Service and SD modules utilized custom programs and LSMW.
- Created numerous custom programs for data manipulation and translations before loading the data in SAP.
- Migrated data for GL account balances for balance sheet accounts, GL activities (YTD balances), Assets Master and transaction data, AR open items, AP open items, goods receipts, employee vendor bank account information, FI/CO postings for open service orders, open contracts, closed service orders, adjustment costs and sales , MIRO , creating contracts and purchase orders.
Confidential, Des Plaines, IL 2004 - 2005
ABAP/4 Analyst/ BW Analyst
- Developed objects in BW as well as BW Support. Involved in creation of Info Objects, Info Cubes, Multiproviders, Queries, Workbooks, Structures, RKF's (Restricted Key Figures) and CKF's (Calculated Key Figures) as well as extraction of data from R/3 and loading and monitoring the loads on a daily basis.
- Key participant in BW End User and Super User global training to promote usage of BW as a reporting tool within various departments of the company.
- Solely responsible for a BW POS Project: This project involved getting the Point of Sale data external to SAP from different Distributors in the form of Flat Files and creating the custom Ztables and Extractors in R/3 to load this data into BW on a monthly basis and provide reporting.
- ABAP Development Team: Completed development on FI /CO modules, many BDC's and ALV reports.
Consultant 2000 - 2004
Confidential, Lombard, IL
Confidential, Northbrook, ILNov 2000 - May 2004
Senior ABAP Developer: SD Dialog Programming
Developed the SPI Project; The Product Information Synchronization and Deployment structured as a Function Group having Screens and Dialog Programming. The main purpose of this project was to assist the phone agents in getting the required information from the Customer using this search tool and creating an order using VA01.
- Created SAP as a single point of search for item data, supplier data and images.
- Reduced talk time for call center agents, increased depth of information and improved SAP efficiency.
- Created 18-20 screens using Tab Strips and Table Controls, User Defined Menu's, RFC for getting the results from Alta Vista JCO back to SAP, ZTables which were user modifiable using SM30, created the Search Helps, Function Modules to build Image URLs.
Confidential, Schaumburg, ILSept 2003 - Dec 2003
BW Developer
- Involved in designing Multi Dimensional Modeling for various business scenarios and creating custom Info Cubes supporting sales and distribution of consumer products and MM.
- Created new Info Cubes, Operational Data sources Multi cubes for the business requirements and activated transfer rules and update rule.
- Installed Business Content and activated the SAP delivered Standard Info Cubes.
- Monitored the data load into Info Cubes and completed validation.
- Updated data from several ODS objects into info Cubes. Used ODS reporting to give details of delivery items.
- Worked on Logistics Cockpit and CO-PA extractions.
- Extensive work on Generic Data Extraction tool (RSO2) to create Data Sources for transaction and master data.
- Created view in the non-SAP database systems and generated Data Source for the tables/views using the T-code RSDBC. Delta request done by time stamp.
- Created Info Packages for transaction data and master data. In Scheduler set up the data request and checked the data loading and processing in the Administrator Work Bench.
- Extensive work on BW Scheduler to load Info Cube, ODS, aggregate roll up and enhance the Business Content Info Sources.
- Significant deliverables on the BEX analyzer, BEX Browser and Web Application Designer. Developed flexible queries using filters and navigational attributes.
- Worked on BW Statistics to optimize the performance of Info Cubes and Aggregates.
Confidential, Cleveland, OH Aug 2003 - Sept 2003
Senior ABAP Developer: FI, MM SD Modules
Returned to Ferro project to resolve Global issues related to SD, MM, FI and PM.
- Changed the existing Reports, Transactions, Interfaces, and existing SAP Programs using user-exits according to client requirements.
- Converted the existing reports to ALV to solve as many Global issues pending for development as possible.
Confidential, Chicago, ILJun 2003 - Aug 2003
Senior ABAP Developer: FI and PS Modules
Assigned primarily in the areas of Project Systems (PS) and FI Asset Management modules.
- Created upload programs for CIP and SIP projects to facilitate and simplify the uploading process for projects using templates.
- Created various extracts in FI for the FATE (Fixed Asset Target Environment) project: Transfer Transaction, Retirement, Acquisition, Annual and Monthly Depreciation, Asset Class Daily, Asset Ledger Daily, Asset Master Daily and Functional Location Daily.
- Created reports: Duplicate Invoice, Annual and Monthly Depreciation Merge Program using existing SAP program and Asset History Comparison Report.
- Created a user Exit in FI to read the line item data along with the header data from existing SAP programs.
Confidential, Cleveland, OHSept 2002 - May 2003
Senior ABAP Developer: FI, MM and SD Modules and SAP Scripts
Worked in various modules including FI, MM, SD, and PP in various projects, which were very time critical mostly related to SAP Scripts, ALV Reports, BDC's, User-Exits and Interfaces.
- Worked on many layout sets: Invoice, Performa Invoice, Quotation, Order Acknowledgement, BOL, Order Confirmation, Scheduling Agreement, Contract, Purchase Order, Pick List and Transfer Order Pick List and others.
- In SAP Scripts worked extensively to create outputs which were Multi Lingual i.e. forms in various languages such as Japanese, Italian, and European. Created many New Documents required for JAPAN Project.
- NAFTA Project: Created Programs and Forms to Get the Certificate of Origin and Affidavit Document to be printed based on many criteria along with the HS Tariff Codes. Created Customized Tables and Search Helps related to fields for those tables so that they could be easily maintained by the user through SM30.
- Created interfaces for the bank accounts download and upload the data using Catt.
- Created ALV reports based on client requirements: ALV: Material Master Data Analysis, Sales Summary, Production Pick List, Non-Invoiced Deliveries, Blocked and Quality Stock, Inventory Aging and PP BOM.
- Developed an interactive report listing all Customers and their Vendors. The address of the Customer and Vendor was provided in a pop-up window by double clicking on the relevant line.
- Implemented many OSS notes.
Confidential, Little Rock, ARJun 2002 - Sept 2002
Senior ABAP Developer: FI and FM Modules
- Created reports: Appropriation Manual, Appropriation Analysis, Auditors Monthly, FI Expenditure, Fund Analysis and various other reports. Implemented OSS notes as per the requirement.
Confidential, USA, Hiram, OH Sept 2001 - Apr 2002
ABAP Developer: SD and HR Module
- Generated reports to meet user requirements: Sales Quarterly, Sales Monthly based on any three months selected, volume of products sold in a state over selected dates, Pick List to display the bill of lading, Pricing Report showing price list for customers and Open Sales Orders Report.
- Worked on various modifications in SAP Script related to Invoice, BOL, and Order.
- Involved in upgrade from 4.0 b to 4.6 C by modifying various reports, based on the changes in the Data Dictionary tables and structures, creation of role based menus, implementation of OSS notes as per the requirement. Wrote BDC's based on the changes in transaction codes and screens.
Confidential, USA, Chicago, ILNov 2000 - Jul 2001
ABAP Developer: MM, SD and FI Modules
Responsible for data analysis, design and coding; developed reports in MM, SD & FI.
- Created Monthly Stock statement for bank obligation providing information about finished stock, semi-finished goods, and raw materials.
- Validated employee input in FI, G/L data load, Load G/L monthly balances from legacy system to SAP.
- Developed BDC programs to migrate data from the legacy system to application specific tables of SAP.
Prior Professional Experience 1994 - 2000
Held various Developers well as managerial positions in India prior to moving to U. S.
CERTIFICATIONS
PMP (In Process)
SAP CRM (In Process)
Certified in Advanced Project Management - Project Estimating Techniques
SAP BW Certified Professional, SAP America
SAP ABAP Certified Professional, SAP America
Sun & Brainbench Certified Java Professional
Education
GNIIT, Graduate of National Institute of Information Technology
Bachelor of Education
B. S., Science