SUMMARY:

• SAP Business Intelligence Consultant with over 8+ years of experience in Design, Development, Implementation and Production support for Business Applications in SAP BI/BW (7.3, 7.0, 3.5,3.1C) SAP ECC, SAP HANA,SAP Business Objects (4.0, 4.1, XI 3.1, XI 3.0, XI R2/R1) QlikView/Tableau.
• Worked on various BOBJ tools like Web Intelligence/ Analysis, Design Studio, Experience with HP Quality Center and HP Service Center.
• Involved as a key member of project teams through all phases of realization, go - live, rollout and post implementation support of SAP BW in SD, FICO, MM, APO,SCM,OER,SRM and CRM modules.
• 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.
• Worked with Business Explorer includes BEx Query Designer, BEx Report Designer, BEx Web Application Designer (WAD), BEx Web Analyzer (Web-based tool), BEx Analyzer (Excel-based tool) for integrating reports to web, Integrated Planning - changes to existing IP application.
• Sound knowledge of various data design models - Entity Relationship(ER), Multi-Dimensional/Star Schema and Extended Star Schema models.
• Experience in automating loads using process chains and use of BW Monitor to supervise data loading.
• Excellent knowledge and experience in Object Oriented Programming and Software Development LifeCycle(SDLC).Experience in designing and development using Classic ASP, CGI, XML, XSL, COM/DCOM/COM+, DHTML, HTML, VB Script, Java Script, MS-SQL, MySQL, FTP, ODBC, Netscape, PhotoEditor, ImageReady, DreamWeaver, Flash, DreamWeaver, Windows 95/98/NT/XP, Excel, Access, Word.
• Strong database experience including administration and maintenance of SQL Server as well as Oracle. Extensively worked in writing T-SQL, SQL queries, PL/SQL, Functions, Stored Procedures, database triggers, exception handlers, DTS Export & Import.
• Developing the documentation of the Plan Documents, Design documents, Bug Fix Reports and Test Case documents.
• Excellent Communication and Interpersonal skills and a very good team player with the ability to work independently and self-starter with motivation.
• Good hands-on knowledge of developing integrated software programs.
• Capable of working with large teams, developing good relationship with personnel from diverse background and functional areas.

TECHNICAL SKILLS:

ERP: Business Intelligence with SAP Netweaver 7.0, SAP R/3 and ECC 6.0,HANA 1.0.

Operating Systems: Windows 95/98/NT/2000/XP, MS DOS, UNIX, and Linux

Databases: Oracle, Sybase, MS SQL Server 2000/7.0, and MS Access

Tools: OLAP Reporting tools SAP Business Explorer (BEx) Analyzer, BEx Browser, Web reporting, Oracle Query Builder 6.0.5, BEx Web Application Designer, Query Designer, Integrated Planning, BOBJ Tools like Web Intelligence/ Analysis,Design Studio, and MS-Office. QlikView/Tableau.

Frontends Tools: Visual Interdev and Visual Basic 6.0

Web Related: ASP, XML, XSL, DHTML, HTML.

Designing Tools: Photoshop, ImageReady, Flash, and Dreamweaver.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

SAP BI/BW Consultant

Roles and Responsibilities

• Experience in working as a developer and DBA on instances of MS SQL Server 2008, 2008R2, and 2012.
• Knowledge of Transact-SQL (TSQL), with strong proficiency in creating tables, indexes, joins, triggers, views, complex stored procedures, user-defined data types, and functions.
• Experience in sub-queries, common table expressions, table variables and physical temp tables.
• Expertise in performing and designing ETL data flow using SSIS, DTS, and bulk insert.
• Expertise in creating mappings/workflows to extract data from SQL Server, Oracle, Sybase ASE, Access, Excel, and other sources using SISS 2008/2012.
• Extensive knowledge and experience of relational database management in a multi-tiered environment where SQL Server is one of several different database technologies in use.
• Expertise in creating SSIS packages with some experience in metadata management and DTS migration.
• Experience in resolving complex issues and error and event handling with a focus on precedence constraints, break points, and logging.
• Developed and tested the new features of BI 7.0 which includes new data flow, re-modeling, Integrated Planning, Real-time Data Acquisition, enhanced features of Process Chains etc.
• Built universes on HANA tables and views using Information Design Tool (IDT)
• Created Design Studio Applications and Dashboards based on SAP NetWeaver BW, SAP HANA and Universe data sources.
• Tested Integrated Planning by creating a scenario using real-time info cubes MultiProviders and input-ready queries (for manual input).
• Worked on BO in resolving issues in standard WebI Reports and adhoc reports.
• Created thin client reports using web intelligence (WebI) in order to view the reports from intranet.
• Developed Transfer rules, Update rules and Start routines.
• Extensively worked on Transporting Objects between BW systems environments and corresponding SAP R/3.
• Created process chains for Data Loading, Delta Uploading and Periodical PSA deletion.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for Data Loading to improve performance and utilize data effectively.
• Work various departments across Johns Hopkins to develop operational measures, targets, and thresholds.
• Collect inputs and prepare weekly and monthly status reports as required. Explain any deviations from planned budgets and schedules.
• Used Reporting agent to create Batch Jobs for Report Printing and Exception Reporting.
• Involved in documentation and end-user training.
• Develop and support a Business Intelligence strategy for Finance, while working with other functional areas on a comprehensive approach to BI.
• Ability to direct the efforts of managing projects for on-time, on-budget delivery that meets goals and objectives.

Environment: SAP BI 7.0, BW 3.5, HANA 1.0, ECC 6.0, SD, FICO,MM,APO,SCM,OER,SRM and CRM, Business Explorer (BEx), Analyzer, Web Application Designer, Query Designer, Integrated Planning, Web Intelligence/ Analysis, Design Studio and Oracle 10g.

SAP BI/BW Consultant-

Roles and Responsibilities

• Developed BI data models and designs, configured custom and delivered BI content, analyzed BI reporting requirements, developed detailed reporting specifications.
• Performed LO, profitability (CO-PA) and Generic extractions throughout the project.
• Created process chains for Data Loading, Delta Uploading and Periodical PSA deletion.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for Data Loading to improve performance and utilize data effectively.
• Created Generic Data source using DB View Extraction method for CRM Master Data.
• Collect inputs and prepare weekly and monthly status reports as required.
• Used Reporting agent to create Batch Jobs for Report Printing and Exception Reporting.
• Involved in documentation and end-user training.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart.
• Worked on BO in resolving issues in standard WebI Reports and adhoc reports.
• Created thin client reports using web intelligence (WebI) in order to view the reports from intranet.
• Used Design studio for viewing on mobile devices.
• Involved in WAD to design studio migration project and created drilldowns for this WAD reports.
• Enhanced new Info Objects to be attached/mapped in InfoSources/Communication structures.
• Ability to direct the efforts of managing projects for on-time, on-budget delivery that meets goals and objectives.

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, HANA 1.0, SD, FICO,MM,APO,SCM,OER,SRM and CRM, Business Explorer (BEx), Analyzer, Web Application Designer, Query Designer, Integrated Planning, Web Intelligence/ Analysis, Design Studio and Oracle 10g.

SAP BI Consultant

Roles and Responsibilities

• 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.
• 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.
• Extracted and Loaded Data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiproviders on Sales & Delivery Cubes to assist Reporting on Sales & 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.
• Used Reporting agent to create Batch Jobs for Report Printing and Exception Reporting.
• Involved in documentation and end-user training.
• Developed and tested the new features of BI 7.0 which includes new data flow, re-modeling, Integrated Planning, Real-time Data Acquisition, enhanced features of Process Chains etc.
• Tested Integrated Planning by creating a scenario using real-time info cubes MultiProviders and input-ready queries (for manual input).

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, Business Explorer (BEx), Analyzer, Web Application Designer, Query Designer, Integrated Planning and Oracle 10g

Report Developer

Roles and Responsibilities

• Created Reports on Sales of Commercial Products and chargeback’s for reimbursements.
• Evaluated reports for specific trends in service to minimize servicer cost.
• Maintained contact with servicers in order to resolve warranty claim issues.
• Experienced in working with Web Application designer to publish reports on company Intranet.
• Extensively worked on creating procedures.
• Collect inputs and prepare weekly and monthly status reports as required. Explain any deviations from planned budgets and schedules.
• Involved in documentation and end-user training.
• Ability to direct the efforts of managing projects for on-time, on-budget delivery that meets goals and objectives.

Environment: SQL Server Reporting Services ( SSRS ) is a server-based report generation software system, SQL Server 2005, DHTML, and HTML.