SUMMARY:

• Over 9 years’ experience in IT industry with SAP Business Warehousing/Business Objects and ABAP 4.x experience. Proficient with planning, design implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse Reporting and BOBJ Reporting.
• Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI and Informatica.
• Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects and Crystal reports.
• Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system. Created WEB Intelligence Reports, Formatting reports (BOBJ), as per user requirements.
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.
• BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.
• Experienced in Cognos 8 tools (Query studio, Report studio, Analysis studio, Metric studio, Event studio), Impromptu/PowerPlay. Designed customized and formatted reports using Reportnet. Expertise in implementing BEx Reporting.
• Activating delta extractors for funds management, working with delta queues and analyzing impact of delta process on R/3 transactions. Enhancement of standard BW extractors in the areas of Accounts Receivable, Accounts Payable) to get the fund information from BSEG.
• Performance tuning of Queries (SAP BW BEX and Cognos) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.
• Strong experience in reporting with SAP BW info providers such as Info objects, Cubes, Queries. Expertise in reporting with Cognos 8 tools on different SAP R/3 functional areas combining data from different R/3 function modules (SD, FICO, MM) in BW.
• Implemented SAP BW core business rules (Security (roles), Calculated Key figures, Restricted Key figures, Query variables) in Cognos tools. Integrated Cognos Reporting with BW functional areas for detailed reporting.
• Configured Cognos Connection (portal) and performed Metadata modeling in Framework Manager. Created models and published packages with Framework Manager and combined data from SAP BW and Non SAP BW data sources for reporting. Exceptional ability to quickly master new concepts and technologies.
• Currently working in SAP BI 7.3 and knowledge of HANA modeling. Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.
• BEx Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
• Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
• Experience in the technical and functional system upgrade from BW 3.1C to BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.
• BI operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.
• ABAP - Reporting, User Exits, Customer modifications. Specifications for Documented functional and technical production support and project enhancements.
• Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
• Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.

TECHNICAL SKILLS:

ERP: SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0.

ETL Tools: SAP BW 7.3, Informatica 7.x, Datastage.

Reporting Tool: BOBJ WEB Intelligence, Cognos 8.x/7.x, TM 1 (Impromptu, PowerPlay), Business Objects XI 3.1(Web Intelligence, Xcelsius) BEx Reporting, Web Reporting & BW 3.5/3.x/2.x,, Crystal Report 7.X/8.X.

Data Modeling Tool: ERWIN, HANA Studio.

SAP Modules: HR, SD, MM and FI/CO.

Operating System: Windows 7, 2000, NT, 98, XP, MS-DOS, Sun Solaris.

GUI: Visual Basic, Developer 2000, and SAP GUI.

Programming Language: SAP ABAP/4, JAVA and Visual Basic.

Databases: Oracle 9i/8i, SQL Server and MS-Access.

Presentation Tools: MS-Office & MS-Project.

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

SAP BW/BO Consultant

Responsibilities:

• Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments.
• Used RealTech Transport Manager to perform transports. Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads.
• Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BW 7.3, Design Studio 1.1&1.2, Business Objects 4.0 Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Confidential, Southlake, TX

Sr. SAP BI Consultant

Responsibilities:

• Supporting users for their reporting needs in the different business areas of Confidential (Agri Business, Finance, and Petroleum). Enhanced master (Customer, Material) data extractors to meet the new report requirements.
• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.
• Designed simple to complex data flows as per the requirement using most of the BI objects (Infoobjects) and infoproviders (Multiprovider, Infocube, DSO etc.). Used ABAP for transforming some of the HR data to support report level calculations.
• Designed BEx queries for HR Headcount and Turnover reporting. Reviewing the existing HR reports and calculations to work on re-designing them. Created cubes and DSO’s objects for petroleum business. Performed a system wide BEx query clean-up.
• Created generic data source for custom requirement and enhanced data sources as required.
• Built a strong data foundation for finance reporting which involved integration of goods movement and billing conditions data. Defined rules in the logic provided to support tax reporting. Worked on fixing process chains issues while transporting them from one system to other.
• Solving MS-excel export issues from the BI portal. Monitored Process Chain on a Daily basis.

Environment: SAP BW 7.2, Windows XP, SQL Server 2005.

Confidential

SAP BI-BO Architect/Lead

Responsibilities:

• Assessed business requirements and defined technical specification documents for Personnel Actions, Benefits & Payroll for Human Resources. Leading the BW Implementation and BOBJ (BI 4.) Reporting integration.
• Worked closely with the end users on a day-to-day basis for their reporting needs. Created Architecture documents for the BW implementations with the naming standards.
• Recently implemented Bookings, Backlog & Billing reporting using SAP and legacy data. This involved the integration of Sales, Billing, Profitability Analysis and Project Systems data integration.
• Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX & WEB Intelligence reports. Activated BI content heavily for the first ever BW implementation for the company. Define configuration for the implementation.
• Created Universe and Web Intelligence reports using BEx queries. Defined best practices to use BEx queries in Business Objects. Helped Basis in setting up the BW landscape for transports management and configuration. Performing testing for BI 4.0 toolset.
• Involved in setting up special security for HR. Worked with security for defining different roles for developers and end-users. Monitored Process Chain on a Daily basis. Created generic data source/extractor for Profitability Analysis (ECC) data to combine R/3 data into BW.
• Architected the dataflow in Business Warehouse. Defined cubes and DSO’s using the standard Data sources from HR. Defined BEx queries as per the report requirement. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BW 7.1, Business Objects 4.0 Web Intelligence, Xcelsius, Data Services, Windows NT.

Confidential

SAP BI/BW/BO Consultant

Responsibilities:

• Implemented Technical design and Development for Production & Prices functional area. Created BEx queries to simulate/validate results achieved from Web Intelligence reports. Architected the Re-org of BW objects to maintain standards.
• Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports. Created Infoobjects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.
• Assisted in configuring BO Data Integrator as a Source system and also used it to send transformed data from Oracle to BW. Created generic extractor to combine R/3 data into BW. Enhanced the extractor for Inventory Management and Purchasing under SCM project.
• Interacted with the SCM Business Users on a daily basis for their KPI & report requirements. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services. Managed, Configured and Performed Transports between multiple BW environments.
• Used Real Tech Transport Manager to perform transports. Leveraging existing function modules (Time (UTC) conversion, Master Data lookup etc.) for various transformations.
• Designed technical implementation of Timezone implementation for reporting over different timezones (MST, PST, EST, and CST). Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis.
• Created and scheduled Process chain for daily Delta loads. Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BI 7, Business Objects Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Confidential, Seattle, WA

SAP HANA Developer

Responsibilities:

• Integrated data from different data sources into Sap HANA using ETL replication.
• Created visually impact dashboards and analyze data to identify key metrics
• Designed, developed and implemented new functionality.
• Written SQL scripts to manipulate data for data loads and extracts.

Confidential

SAP BI Developer

Responsibilities:

• Conducted reports for implementation of marketing strategies leading to 34% of growth in customer acquisition.
• Developed strategy and road maps including tactics, project plans, milestones and KPIs.
• Built database cubes and designed star schemas using ER/Studio and Visio.
• Worked with customers to design and implement effective business intelligence tools.
• Analyzed data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, optimizing and certifying database designs to satisfy client needs.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations) using SAP Business Objects.