Sap Bw/bobj Developer/support Resume
Philadelphia, PA
SUMMARY
- Over 8+ years of IT experience in SAP Business information warehousing which includes implementation, support and testing experience.
- Involved in 3 full life cycles SAP BW implementations and experienced in design and development in Sales and Distribution SD, Material Management MM, Financial Accounting & Controlling FI/CO, Production planning PP modules.
- Dynamic SAP R/3 Techno - functional Consultant with extensive experience on SAP R/3 with emphasis on BW.
- Involved in installing the objects from the Business Content and responsible for Data Modeling.
- Proficient in OLTP extractions of SAP SD, FI, MM,CO-PA, LO-Cockpit, generic extraction, flat files & using DB Connect for legacy data.
- Experience in working back end objects with standard and custom Info Cubes, DSO’s (Data Store objects), Info Sources, Transfer rules, Update rules, Transformations, DTP’s, Multi-providers and Info-sets.
- Experience in building front end reports using Business query designer (BEx).
- Worked extensively on Aggregates , Compression , Partitioning to improve data load and query performance.
- Experience in automating loads using Process Chains and monitored as part of production support.
- Extensively worked on custom /generic data sources and Enhancements to suite the end user requirements.
- Extensively worked on both SAP BI 7.x & BW 3.x versions with experience in analysis, design and development using Administrator Workbench, Business Content, Data Modeling and Extraction from different source systems and flat files.
- Involved in extracting the Data from various Source Systems like R/3, Non-R/3 Systems, Legacy Systems (using DB Connect) and from flat files.
- Proficient in writing ABAP User exits for transaction data and along with start routine, end routine and update routines.
- Involved as a key member of project team through all phases of realization, go-live, rollout and post implementation support of SAP BW in FI/CO, SD and MM modules.
- Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.
- Evaluated statistical performance from the technical content cubes and improved data load times and query performance using Compression , Aggregates and Partitioning techniques.
- Involved in Archiving Project which includes p ost processing of archiving works such as managing archiving jobs, building indexes for accessing archived data, cleaning up the database, and deleting archived data.
- Knowledge in designing reports by using different report components like desktop intelligence , Web intelligence rich client.
- Highly motivated, eager to learn and take on greater responsibility.
- Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training of end users.
TECHNICAL SKILLS
ERP: SAP ECC 6.0, SAP R/3 4.6C, SAP BI 7.3, SAP BI 7.0 and SAP BW 3.5.
Databases: Oracle 9i/10g, SQL Server, MySQL and DB2.
Languages: C, C++, Java, SQL, PL/SQL, Basic, ABAP/4 and ASP.
Web Technologies: J2EE, HTML, CSS, XML, and PHP
Reporting Tool : BEx Reporting tools, BOBJ 4.0 - Xcelsius, WEBI and Crystal reports, Business objects XI R 3.1
Packages: MS Office (PowerPoint, Excel, Word), Adobe, MatLab, MultiSim, Net Beans, Eclipse.
Operating Systems: Windows-2003/2008/XP/VISTA/7, UNIX, Linux, MS-DOS.
PROFESSIONAL EXPERIENCE
Confidential, Philadelphia, PA
SAP BW/BOBj Developer/Support
Environment: SAP ECC 6.0, SAP BW 7.3, SAP BI/BW7.0, BOBJ3.1(WEBI reporting) BOBJ 4.0(WEBI reporting).
Responsibilities:
- Mainly dealt with Reporting requirements in the areas of Chargebacks, Account Receivables, Sales & Distribution and Inventory etc as part of their ERP implementation.
- Understanding the user requirements and translating it in BW design and provide estimation to implement the proposed solution with impact analysis.
- Worked on Solution design for most of the projects mainly in chargeback area and also provided assistance to offshore counterpart in completing the development.
- Involved in BW/HANA migration and review the business requirements and provide options/recommendations.
- Proficient in handling User Exits and modified extractors using FM and BADI in order to populate for custom data fields/data structures.
- Worked extensively in extracting data from SAP R/3 using LO Cockpit, FI, CO-PA and generic extractors. OLTP Extraction (Transaction Data, Master Data Attributes, Text, Hierarchies).
- Working on post deployment bugs and providing Production Support for the deployed applications.
- Design and development of BW objects - Data source in ECC, DSO, Infocubes, Multiproviders, Transformations, DTP’s, Open Hubs, BEx queries etc.
- Worked on ABAP code in the Start routines and End routines to perform look up from DSO’s in order to fetch data required for the report.
- Knowledge on different update modes like Direct delta, Queued delta, Unserialized v3 update.
- Worked extensively on APD (Analysis process Designer).
- Designed and created several Queries using BEx Analyzer, with drilldown functions, Calculated key figures, Restricted key figures, Structures, Exceptions, Conditions, Variables and WAD.
- Checking data consistency, aggregates and hierarchies through RSRV.
- Creating and Managing Transport Requests and Releasing to the Test and Production servers through CHARM Process.
- Worked on Business Objects (WEBI Reports) by fixing the cosmetic changes that were related to the reports and fixing it on the report side rather in the backend.
- Performing and monitoring dataloads over the weekends and resolved many issues that occurred during Production support.
- Worked on Performance Tuning Concepts like Compression, Aggregates, Partitioning, Indices and Line item Dimension and optimized load performance and query performance.
- Extensively worked on creating and maintaining Process Chains & Meta Chains for automating data loads.
- Worked with the CPS team on scheduling the Batch jobs and monitoring them on daily basis.
- Worked on Manage Now and Maximo ticketing tool to provide analysis and resolution to user issues.
- Involved in BW Cutover activities, this includes migration of transports, Data loads, Clearing the queues, Deleting setup tables, Initialization of Delta and coordinated with the Basis team for the actual production cutover.
- Creating documents (Technical specs-TUT’s) for the reports and the objects which were designed.
- Working with the Process teams in development of test scenarios/test cases and resolving the defects at unit testing and integration.
- Documentation on various issues faced, maintaining project related design documents in Solution Manager.
Confidential, Dallas, TX
SAP BW/BO Consultant
Environment: SAP ECC 6.0, SAP BI/BW 7.X, BOBJ 4.0(Xcelsius and WEBI reporting), Oracle Datamarts, UNIX.
Responsibilities:
- Involved in full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
- Gathered user requirements, mapping against delivered SAP content, and translating into a coherent design document.
- Designed & developed custom Data Sources and enhanced the existing the transactional data sources/extractors in finance (FI/CO, AP, AR and costing) and LO cockpit extractors in logistics (SD, MM, PP and QM) application modules.
- Reviewed & analyzed sap archiving for multiple sap technical objects.
- Implemented BI content SD cubes for customer and deliveries for order schedule, delivery schedule line and rebates.
- Extracted SD data using LO Cockpit tool and customized the data extractors for sales order and deliveries.
- Configured FI-GL data flow and tables in ECC to enable the extraction of GL data multiple times in a day to help finance team to during period closing times.
- Worked on Business Objects by Building Universes, WEBI Reports, Crystal Reports, Xcelsius dashboards using BI services Live Office , QAAWS and BICS connectivity.
- Worked on dashboards on different kinds of charts and reports.
- Activated business content cubes and data sources for FI i.e 0FIAP, 0FIAR, for reporting requirements of cost of goods sold, financial statement, payment history, transaction data, travel expenses, planning, overdue payment analysis and invoices.
- Used Start routines and End routines in transformations to update key figures and characteristics in the info cubes.
- As a part of performance tuning, created and built BIA indexes for the Cubes so that the report fetches data much faster.
- Enhanced several master data sources like 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
- Worked on the enhancement of the business content data sources by using ABAP in append structures and user exits from transactions CMOD.
- Responsible by collecting the BW objects like Info Cubes , DSO (Data Store object), Info objects , Transformations , DTP’s , Process Chains and Reports to transport them across the landscape.
- Responsible for Performance Tuning by building Aggregates, Partitions, Indexes, Tracing the Query outputs, and redesigned the cubes based on Dimensional Table sizes.
- Created several Open Hubs to send data from SAP BW t o external systems.
- Partitioned data targets for query performance and archiving requirements.
- Build the EDW layer(build the DSO layer) to achieve the zero down time .
- Extensively worked on BEx Query Designer and Web application designer and created several summary and detailed level reports to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
- Developed several Web Intelligence detailed level (WEBI) reports and Xcelsius summary level reports.
- Responsible for the monitor the nightly loads as part of the production support.
- Created supporting documentation and conducted end-user training.
- Worked in coordination with the basis team to Transport (DEV to PROD) the objects.
Confidential, Morrisville, NC
SAP BW/BI Consultant
Environment: SAP ECC 6.0, SAP BI 7.0, Business Explorer, Business Objects XI 3.1, Web Intelligence .
Responsibilities:
- Involved in full life cycle implementation, which includes Requirements gathering, Gap Analysis, Blue printing, and Development, Testing, Reporting, Go-live and Post Go-live support.
- Worked with different users to gather business requirements and transformed them into a data model using extended star schema model.
- Worked extensively on Data Warehouse Work Bench. Customized Info Objects, DSO, and Info Cubes.
- Initialization of opening stock data source ( 2LIS 03 BX ), Initialization of statistical set up of material movements ( 2LIS 03 BF), and revaluations ( 2LIS 03 UM ) and loading into BW into stock movements cube ( 0IC C03 ).
- Setting update mode and loading deltas into cube .
- Compressing requests and setting suitable marker updates.
- Created ABAP code in Start routines and End routines for the look up process.
- Performed Data Extraction from SAP R/3 to BW using extraction structures such as LO Cockpit and Generic Data Extractions .
- Created generic data sources with ability of delta functionality.
- Configured, Migrated and maintaining the data sources for transaction and master data sources.
- Analyzed the errors occurred while loading Master and Transaction data and resolved the same.
- Created BEX reports using conditions, Filters, Free Characteristics, Calculated Key figures, Restricted Key Figures and Variables.
- Created Process chains in order to automate the process of loading and created Meta chains respectively.
- Collected and transported BW objects like cubes, ODS, Info objects, update rules, Transformations, process chains etc.
- Enhancements of Transformation mappings, configuration of Info packages and DTPs .
- Creation of Multi providers to enhance the reporting base.
- Query development using the BEx Analyzer/Browser.Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
- Excellent Production Support Skills including Data loads, Reporting related Issues, Archiving, Performance Issues , and Data Compression Activities .
- Worked on Web Application Designer and published reports on web.
- Extensively used calculations, variables, drill down, slice and dice in the creation of reports.
- Monitoring of Data Loads and analyzing the reasons for frequent data load failures using RSPC, RSPCM, RSMO, SM37, ST22, SM21, SM58 etc.,
- Coordinating with the users for their UAT phase and report bugs to the development team.
- Coordinated with the basis team if there is any RFC connection issues and releasing the transport request from Dev server into the QA box and then to production server.
- Creation of custom variants that allow users to choose report type based on variant conditions like sales division, sold-to-party and sales representatives.
- Developed reports on Key performance Indicators.
- Responsible for weekly transport deployments to Quality Box.
- Worked on installation and configuration of Business Objects XI 3.1 Enterprise Suite (Designer, Reporting, Web Intelligence, Info View).
Confidential, Dallas, TX
SAP BW Developer
Environment: SAP ECC 6.0, SAP BI/BW 7.0 / NetWeaver 2004s, SAP BW 3.x, BEx Analyzer.
Responsibilities:
- Involved in complete full life cycle implementation, from the beginning of the project requ irements gathering, business blue print, Design & Development, Testing, GAP analysis, Business requirement documentation & reporting, getting client approvals, Go-Live and production support.
- Gathering requirements, user interaction, converting the business requirements into functional and technical specifications.
- Installed BI Business content and customized GL, AR, AP and AA applications including Cubes, DSO, DTP, Transfer rules, Update rules, Transformations and Datasources.
- Customized data flows and routines in ECC 6.0 to implement business logic for FI applications.
- Worked on Business Content InfoCubes for Logistics (Sales, delivery, Billing, Procurement), FI (GL, AP, AR), CO and enhanced User exits to meet the end user requirements.
- Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the InfoCubes to facilitate various reporting requirements.
- Developed many complex ABAP enhancement like User Exit Functions, Generic Extractions and also in BI data modelling like Start Routines.
- Extensively worked in front-end BW Components Queries, Calculated key figures, Restricted key figures, Structures, Variables, Workbooks, Alert monitor, Job schedule monitor, Exceptions handling and publishing BW reports on Web.
- Analyzed, designed and created several Extract structures, InfoSources in Logistics. Utilized existing LO Cockpit structures for sales and purchase order details.
- Used LO Customizing cockpit to extract from R/3 extract structures.
- Provided support for production jobs, integration testing, dry-run and batch jobs.
- Developed Multiproviders, Infosets for different user requirements.
- Created ODS, Cubes, ODS for Sales, Purchase and finance transactional data .
- Created Process chains for DTPs, infopackages, PSA deletion, Attribute Change run, Compression process.
- Developed data flows using DB Connect(Oracle Datamart),
- Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures, exceptions, conditions in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
- Compressed the Info Cube data for better performance.
- Worked extensively on Performance tuning in improving the load and read performance by maintaining indexes, partitioning, aggregates, query properties etc.
- Conducted Training for End-users and Project Team members. Developed different BW training documentations for different users based on their roles.
Confidential, Cedar Rapids, IA
SAP BW Consultant
Environment: SAP BW 3.5, SAP ECC 6.0, ABAP/4, Oracle 9i and Windows XP
Responsibilities:
- Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to GoLive. Involved in pre and post go live activities and responsible for production support.
- Customized Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines, Business Content, Generic data extraction, Data Loading (Full/Delta Load), Scheduling, Monitoring Performance tuning and extracting.
- Worked on Data Modelling, Data Extraction, Loading, Scheduling jobs, Monitoring data loads and Reporting .
- Created generic extractors, Transfer rules and Update Rules for loading data into Business Warehouse from SAP and non-SAP systems.
- Enhanced existing Data sources to meet the end user requirements.
- Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates, Compression/Roll up, Archiving and Involved in Production Support.
- Involved in Day to day activities like process chains monitoring /production support and performance tuning etc.
- Created Multi-Providers and aggregates to improve query performance.
- Created BW reports using BEx query designer on Multi-providers and Info-Cubes, also created and Published Web Reports using Web Application Designer (WAD).
- Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion.
- Developed reports on Info Cubes/ODS objects using BEx Analyzer/Explorer to facilitate summarization of data.
- Used WAD (Web Application Designer) to develop a statistical report which shows loading status report.
- Created a statistical report, which shows when last data is loaded to cubes.
- Performance Tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of Info Cubes and use of Statistics for the same.
- Gathered Security Requirements, Assisted in Security model design with Security Team. Implemented BW Authorization and Security for the BW System.