Summary

• Around 7 years of IT experience including 4.5 years of SAP BW and SAP R/3 experience in design and development in FI/CO, SD, & MM modules.
• Involved as a key member of project teams through all phases of realization, go-live, rollout and post implementation support of SAP BW in FI, SD, and MM modules.
• Involved in design and development of Database, Catalogs, Cubes and Business Intelligence reports.
• Working knowledge of SAP ASAP methodology in Software Development Life Cycle.
• Experience in working with standard and custom InfoCubes, InfoObjects, InfoSources, ODS, Multiproviders, Extraction Process (LO Cockpit, CO-PA, FI/SL, LIS), transportation of business objects using CTS tool and performance tuning.
• Designed data models, ODS, Info-cubes, and developed queries and workbooks in the Bex Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables
• Worked with ALVs, BAPIs and User Exits Function Modules, used IDOCs for electronic data interchange(EDI).
• Worked with SEM-BPS suite to streamline business planning process.
• Worked with Business Explorer, Web Application Designer and Business Objects XIR1 for integrating reports to web.
• Knowledge of Cognos Query Studio and Reportnet.
• Sound knowledge of various data design models- Entity Relationship(ER), Multi Dimensional/ Star Schema and Extended Star Schema models and worked with Dashboards which are based on generic data model.
• Experience in automating loads using process chains and use of BW Monitor to supervise data loading.
• Experience with SAP BI Integration and Strategic Configuration.
• Created Data marts using Cognos Decision Stream Designer. Used Cognos Scheduler to run Cognos Applications and Macros. Used I-Series Navigator to extract data from H & S Data and to run SQL Scripts.
• Created, Maintained and modified existing catalog and existing transformer models using Cognos Decision Stream. Created BI reports using Cognos. Created Data Mart from Oracle8i and Ms-Access by Cognos Decision Stream Designer 7.0.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Capable of working independently with minimum supervision as well as in a team.
• Highly motivated, eager to learn and take on greater responsibility.
• Excellent communication skills, systematic approach and ability to work effectively in fast paced environments.
  

Technical Skills

ERP: SAP BI 7.0, BW 3.1C/3.0B/3.5, SAP R/3 4.6C/4.7, ECC 6.0, mySAP ERP 2005
Programming Languages: C, C++, VB 6.0, Java, Java Script, HTML
OLAP Reporting tools: SAP Business Explorer (BEx) Analyzer, BEx Browser, Business Objects XIR1/R2, Web reporting, Web Application Designer, Oracle Query Builder 6.0.5, Cognos, Cognos Decision Stream,
RDBMS: DB2, ORACLE ((PL/SQL, SQL*Plus) MS SQL Server 2000, Enterprise Manager.
Operating Systems: Microsoft Windows 9X/ NT/2000/XP, MVS, Sun Solaris
Applications: AS/400 Server, I-series Navigator
Testing Tools: Test Director, Win Runner
Other Tools: Cognos Query Studio, Visio, MS-Office, Matlab
Hardware: SUN SPARC, SUN Ultra E-Series, IBM NetVista 3000/3500

Work Experience

SAP BI Specialist Sep 08 - Present
Confidential,NY

Responsibilities: Designed, developed, tested and implemented BW Objects for Maines in Conklin, NY in FI, COand HR. Also responsible for performance tuning; resolving loading issues and Query performance issues, creating reports to analyze Serivce Cost and Finance(AP, AR, GL) data using SAP Business Explorer (BEx)

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Extracted and loaded data from SAP R/3 into Finance Management & Controlling InfoCubes using DataSources.
• Created Multiprovider on Cost Center Accounting and Over Head Cost Controlling cubes to assist reporting on Controlling.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion. Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer, Bex Analyser and Web application designer to create Queries to forecast Fianance & Controlling, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Analyzed status and fixing FI/CO tables, Involved in SAP BI solutions integration and strategic configuration.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
• Worked extensively on creating Info Objects, Info Sources and Extraction. Involved in Design, Development and Implementation of BW using Extended Star schema.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using
Web Reporting tools. Created Calculated, Restricted KeyFigures and Structures (selections, formulas) to create CO reports for comparing Periodically, Quarterly Statistical reports and HR reports.
• Analyzing ERM, MDM and translated into BW design. Identifying the Key Figures, Strong Entities and attributes involved in star schema design with multiple dimensions and fact tables.
• Performed LO extraction to load Sales & Distribution data into BI.
• Data Extraction and Uploaded Master and Transactional data from flat files and SAP R/3.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
. Worked on Cognos and Cognos Decision Stream to generate reports on H & S Data by SQL Server.
. Worked on I- Series AS/400 Server to extract data from Customer, Item Master, Purchase Orders data.
• Created Multi providers to enhance the reporting base.
• Involved in documentation and end-user training.
• Testing and Quality assurance of the data present in PSA as well as in Data targets.

Environment: SAP R/3 4.6c/ ECC 6.0, BI 7.0, BW 3.5, ABAP/4, NetWeaver 2004s, User Exits, ALVs, BAPIs, IDOCs, ALE, BPs, WAD, HTML, Portal, BEX Report, WinNT, Bex Analyzer, Query Designer, My ERP, Oracle, UNIX, SQL Server, AS/400, I-series navigator, Cognos Decision stream.
Business Areas: CO, FI(AP, AR, GL), HR, SD & MM



SAP BW Consultant Sep 07-Sep 08
Confidential,Piscataway, NJ

Responsibilities: Designed, developed, tested and implemented BW Objects for American Standard in Piscataway, NJ in FI, SD and MM. Responsible for creating reports to facilitate demand planning and Shop Floor Planning. Also responsible for performance tuning; resolving loading issues and Query performance issues.

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Enhanced master data sources 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
. Develop the configuration of Inventory Management and Warehouse Management module.
• Extracted and loaded data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Analyzed status and fixing FI/CO tables, Involved in SAP BI solutions integration and strategic configuration..
• Profitability Analysis Reports changed depending on requirements using COPA.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
. Scheduled many reports using InfoScheduler and Proficient in full life cycle design and development of Business Objects XIR1 reporting Applications.
. Deployed Business Objects Reports in a Secure Environment from One Server to Other Servers.
• Involved in documentation and end-user training.
• Testing and Quality assurance of the data present in PSA as well as in Data targets.

Environment: SAP R/3 4.6c/ ECC 6.0, BI 7.0, BW 3.5, ABAP/4, NetWeaver 2004s, SEM, APO,
User Exits, ALVs, BAPIs, IDOCs, ALE, EDI, BPs, WAD, HTML, Portal, BEX Report, WinNT, Bex Analyzer, My ERP, Oracle, UNIX
Business Areas: FI/CO, SD & MM

SAP BW Consultant Mar 06- Sep 07
Confidential,Westminster, CO

Responsibilities: Responsible for data loading from SAP R/3 and Flat Files to SAP BW. Created custom Info Object, Info Sources and custom reports using Business Explorer (BEx) to give detailed level of information from queries based on ODS and Info cube.

• Worked extensively on creating Info Objects, Info Sources and Extraction.
Involved in Design, Development and Implementation of BW using Extended Star schema
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using
Web Reporting tools.
• Analyzing ERM, MDM and translated into BW design. Identifying the Key Figures, Strong Entities and attributes involved in star schema design with multiple dimensions and fact tables.
• Uploaded Master and Transactional data from flat files and SAP R/3.
• Extracted data using flat files for raw materials in order to track inventory.
. Develop the configuration of Inventory Management and Warehouse Management module.
• Used Business content Extractor for MM master data sources 0MATPLANT, 0MATSALES.
• Performed Data extraction from R/3 (LO Extraction) and Flat files.
• Documenting and support for the finance work stream that is, FI/ CO module
• Corrections to Profitability and Financial Reports - Form and selection criteria.
• Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
• Created Multi providers to enhance the reporting base.
• Used BEx analyzer to develop Sales Analysis and ABC Classification reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.

Environment: SAP R/3 4.6C and 3.1H, BW 3.5, DB2, AIX ,User Exits, BAPIs, ALE, ALVs, IDOCs, EDI
Business Areas: FI/CO, SD & MM

SAP Reporting Developer/ Analyst Nov 04- Mar 06
Confidential,Secaucus, NJ

Responsibilities: Responsible for creating reports to analyze Serivce Cost and Sales data using SAP Business Explorer (BEx). Also responsible for setting up the data using MS Excel tools for presentation and periodical evaluation.

• Activated and used SAP delivered BEx reports.
• Scheduled data loads to BW from SAP R/ 3, Monitored data loads which are running hourly, daily, weekly & monthly basis.
• Worked on performance related issues by Creating Aggregates, Partitioning, and Compression etc.
• Generated data into Excel spreadsheets for reports using BEx Query Designer.
• Experienced in working with Web Application designer to publish reports on company Intranet.
• Created Reports on Sales of Commercial Products and chargeback’s for reimbursements.
• Created Aggregates on InfoCubes to improve Query performance.
• Evaluated reports for specific trends in service to minimize servicer cost.
• Maintained MapPoint database for service locations to effectively provide coverage to commercial clients.
• Corrections to Profitability and Financial Reports - Form and selection criteria.
• Created Drill through Queries from Summarized InfoCubes report to detail ODS data. Included Restricted Key Figures & Calculated Key Figures for filtering and formula requirement of query
• Defined percentage functions, Mathematical functions for new calculated key figures at both Query and Info cube levels using Formula.
• Verified and Approved/Rejected warranty claims utilizing SARA database.
• Maintained contact with servicers in order to resolve warranty claim issues.

Environment: SAP BW 3.0B, SAP R/3 4.6C, Bex Analyzer /Web Application Designer, ABAP/4, SD/MM Modules, HTML, Windows 2000/NT
Business Areas: SD, MM


SAP Reporting Analyst/ Developer Nov 03- Oct 04
Confidential,Bangalore, India

Responsibilities:
• Customized Infocube and ODS to store transactional data for Reporting.
• Customized/ configured Transfer structure for the Source system and Infosource, and activated the relevant Business Content.
• Customized/ configured Infoobjects, Data source, Infosource, Transfer Rules, Communication Structure, Update Rules, ODS object, Infocube, Infopackages.
• Periodic extractions are scheduled using Infopackage.
• Worked on BEx Analyzer and BEx Browser.
• Used Enhancement component RSR00001 to validate user input.
• Developed custom Bex queries and workbooks using Bex Analyzer. Developed custom templates in Web Application Designer and published queries on the web.
• Configured the use of Exceptions, Filters, and conditions, Structure, Variables, Restricted and
• Calculated Key Figure, Query Jump Target.

Environment: SAP BW 3. 0, SAP R/ 3 4. 6, ABAP/4, HTML, JavaScript, MM Module, Oracle 8i, Windows 2000

Reporting Analyst/ Developer Nov 01- Nov 03
Confidential,Bangalore, India

Responsibilities:

• Generated and manipulated data into Excel spreadsheets for reports using Oracle Query Builder.
• Created Reports on Sales of Products and chargeback’s for reimbursements.
• Assessed reports to get detailed trends in company transactions.
• Created reports pertaining to Sales i.e. depot sales, reports on stock movement form company warehouse to depots, dealers and retailers.
• Maintained contact with vendors in order to resolve delivery issues.

Environment: Oracle Query Builder, M.S Office Tools, Windows NT


Education:

B.S in Computer Science Engineering.