SUMMARY:

• 7 years of experience in IT industry, with extensive experience in SAP BW, playing various key roles in Design, Development and Implementation of Business Applications and experience in ABAP programming.
• Implemented three full life cycle implementations in SAP BW/BI projects which include project preparation, gap analysis, business blueprint, design specification, realization, testing, Production support and end user documentation using ASAP methodology.
• Upgrade experience in SAP BW from 3.5 to BI 7.0 and in depth knowledge of migrating data sources from BW3.5 to BI7.0 and maintaining transformations and DTP’s.
• Interaction with various business modules namely CRM, HCM, SD, MM, PP, HR, SRM, SCM, APO, SEM BPS and FI /CO.
• Possess good understanding of SAP life cycle manager and SAP Integration kit.
• Extensive knowledge in creating BW objects like Info Objects, Extractors, Info Cubes, DSO, Multiproviders, InfoSet, Info Sources, Transformation, DTP, Transfer Structures, Update Rules, Transfer Rules, Info Packages, Start and End routines.
• Expertise in OLTP extractions of SAP LO - Cockpit, CO-PA, CO-CA, FI-GL, FI-SL, Generic extractions and non-SAP data and flat files.
• Expertise in creating and maintaining Process Chains and build infopackage to schedule full/init/delta loads.
• Worked extensively on BEx Analyzer, Query Designer, Report Designer, Web Application Designer, Crystal reports, Web Intelligence, Live Office and Xcelcius.
• Hands on experience with Front-end Business Warehouse Components which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures, Cell editors.
• Extensive experience in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Webi and Crystal.
• Experience in providing the security using Authorizations and providing roles and role groups.
• Highly skilled in building static and live dashboards using Xcelsius.
• Expertise in User Exits and enhancements like routines and rules.
• Proficient in performance tuning includes creation of Indices, Aggregates, Rollups, Compression techniques and Partitions. Evaluated statistical performance using BW statistics.
• Involved in BW transports from Dev to quality and also to production.
• Excellent skills in dealing with production support issues, which involved debugging of data loads, scheduling and monitoring loads.
• Proactive, Team player, Excellent Communication skills, oral and written skills.
• Fine presentation and technical writing skills.

TECHNICAL SKILLS:

Datawarehouse: SAP Netweaver 2004s BI 7.0, BW 3.5

ERP: SAP R/3 ECC 6.0,5.0,4.7E/4.6C/3.1C/3.1i

Reporting tools: BEx Analyzer, WAD, BO XI, Web I XI, Crystal Reports, Xcelsius, Cognos, Microstrategy

Programming: ABAP/4, PL/SQL, Java, XML, HTML, ASP.NET

Database: MS SQL 2000/2005/2008, Oracle 10g/9i/8i, DB2, MS Access

Platforms: Windows NT/2000/2003, UNIX, Linux

PROFESSIONAL EXPERIENCE:

SAP BI Consultant

Confidential, Jackson, MI

Responsibilities:

• Involved in complete full life cycle implementation of SAP BI, which includes requirement gathering, realization, testing and go live phases.
• Extensively worked on Data design and Data modeling using Schemas using ER models, star schema and extended star schema.
• Activated standard business content like Sales Overview cube, CRM activity items cube, GL and SL cubes, Contract Condition DSO.
• Developed custom Info cube to analyze the transfer order data and enhanced the data source 2LIS 03 S091.
• Extracted Sales data using Logistics Cockpit while maintaining V3 update.
• Customized the standard extractor and created generic extractors to meet the reporting requirement of defining relationship between demand and supply.
• Developed ABAP programs to populate user exit variables.
• Used Open Hub and exported BW data to flat files on Application Server.
• Worked with the SAP integration Kit by importing transport files and setting up authorizations in SAP.
• Extensively worked in Business objects for creating and maintaining reports.
• Developed custom queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.
• Worked on the SAP Integration kit for the BO environment.
• Developed universes over BEx queries in universe designer to create Webi reports .
• Identified the Key Performance indicators (KPI’s) and the business requirements.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Selection Criteria and grouping such as order to cash, AR, AP reports.
• Created series of dynamic Dashboards using Xcelsius as per client requirement.
• Coded in ABAP for Start Routines, End Routines, Update rules, Transfer Rules and Transformations to update Characteristics and Key Figures in the Info Cubes.
• Maintained Process Chains to automate and schedule the dataloads.
• Setup BW security for user roles like query users, administrative users and data extraction users.
• Created Custom Reporting Authorization Objects using transaction RSSM.
• Setup security at the Info Object level like field-level security.
• Created roles restricting access to Info cubes, ODS objects, specific queries and workbooks.
• Worked on performance tuning includes creation of Indices, Aggregates, Compression techniques and Partitions.

Environment: SAP Netweaver 04s BI 7.0, ECC 6.0, Business Objects, BO Xi 3, BEx Analyzer, Query Designer, SD, MM, FI /CO, APO modules, Windows 2003.

SAP BI Consultant

Confidential, Washington, DC

Responsibilities:

• Analyzed business reporting requirements that could be satisfied by Business content Info Cubes for Cost and Allocations.
• Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BW.
• Created custom InfoCubes and worked on line item dimensions and standard DSOs.
• Created transformations, DTPs and infopackages for loading master data and transaction data from R/3, Non-SAP systems and flat files, also coded Start Routine, End Routines in ABAP.
• Extensively involved in data extraction from SAP R/3 using Generic Extractors, Logical Information Structures (LIS), and Customized LO cockpit.
• Performed Remodeling on existing cubes to accommodate new keyfigures and characteristics.
• Extensively worked on automation of BW processes through process chains and metachains with full and delta mechanisms.
• Worked on creating aggregates and BI accelerators, applied compression and partioning techniques to tune the query performance.
• Involved in creation of different types of reports such as month to date (MTD) reports, year to date (YTD) reports, monthly reports, quarterly reports and annual reports for a facility analysis.
• Created and maintained queries containing restricted and calculated key figures, filters, and conditions and structures in BEx and presented in Workbooks.
• Developed several ABAP programs to populate reporting customer exit variables.
• Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing complex custom reports and dashboards.
• Created iViews, pages to display BEx/web reports in Enterprise portal 7.0.
• Involved in assignment and maintenance of Roles and Authorizations to users for BI security
• Employed Web Application Designer (WAD) to facilitate the analysis in a drill down or summarized way to give detailed levels of data.
• Recreated Existing BEx reports using Web Intelligence Reports.
• Conducted on BEx usage for Business Users and Web and new features to power users.

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0, FI, PCA, ABAP/4, Oracle 10g, Bex Analyzer, Query Designer, Report Designer, and Web Application Designer, BO XI

SAP BI Consultant

Confidential, Woodbridge, NJ

Responsibilities:

• Involved in the installation of Business content, Data Extraction from Source systems.
• Worked with the upgrade process of systems from BW 3.5 to BI 7.0 which includes datasources migration.
• Created BPS Planning Areas, Planning Levels, Planning Packages, Planning Layouts, Planning Functions, Parameter Groups, Local/Global Planning Sequences and Planning Folders.
• Activated and replicated Data Source from CRM Source System.
• Created/configured BW objects (Infosources, ODS, Infocubes, MultiProviders, Infosets, Transfer Rules, Update Rules and Infopackages) in HR module.
• Dealt with CRM business content cubes for Activities, Leads and Complaints.
• Created Transactional and Master Process Chains for periodic upload of data.
• Extracted from ECC (LO cockpit), CRM, SCM, flat files and also enhanced the transactional extractors.
• Modified exist queries on various Info Cubes related to SD and HR-Payroll.
• Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Query variants using BEx Analyzer.
• Created and published reports based on Home Delivery, Marketing, Customer Service, Headcount & Personnel Actions and Sales using report designer, query designer and WAD.
• Performance tuning of queries using aggregates, table partitioning, indexing of InfoCubes.
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes.
• Performed extensive unit testing in the development environment for all the objects created.
• Worked with the security team in designing the security strategies for global front end reports and workbooks.
• Participated in End-User as part of Knowledge transfer.

Environment: SAP BI 7.0, BW 3.5, CRM 4.0, SRM, HR, APO, SAP BPS 3.5, SAP ECC 5.0, BEx Reporting, Web application Designer and COGNOS.

SAP BW Consultant

Confidential, Eloise, FL

Responsibilities:

• Involved in designing the data flow from R/3 to BW and responsible for deployment.
• Interacted with the end users to understand their reporting requirements and creating document of understanding.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and ODS Objects for MM and SD modules.
• Loading the master data and transactional data from the flat files & SAP R/3 to BW using LO-Cockpit, COPA, FISLandGeneric extraction methods.
• Involved in mapping of data source to InfoSource with transfer rules in SAP BW and also in mapping of InfoSource with data targets using update rules.
• Created virtual key figures and calculated key figures to satisfy the reporting requirements.
• AnalyzedInfoCubes (RSRV)and maintainedaggregates (RSDDV)to improve performance.
• Developing Security Roles in SAP BW systems for queries restricting them to company codes and product Hierarchies Using PFCG
• Created and maintained authorization objects and security roles for custom master data info objects like ZCOMPCODE and ZREGION.
• Worked extensively on currency conversion techniques at transfer rules, update rules and query level
• Developed flexible reports using flat files and navigational attributes in BEx analyzer and Web Application Designer (WAD) to facilitate the analysis in a drill down mode.
• Monitoring, Debugging / troubleshooting, identifying the cause of various errors and resolving known problems occurring during the extraction, transformation and loading.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping details and partner function details.

Environment: BW 3.5, SAP R3 4.6C,SCM,SEM, SD, MM, PP, MS-SQL, BEx, MS Excel, Windows 2003.

SAP BW Consultant

Confidential, Boca raton, FL

Responsibilities:

• Involved in complete life cycle Implementation of SAP BW that includes Data Extraction, Data Modeling and Reporting.
• Worked with different users to gather business requirements and transformed them into a data model using extended star schema model.
• Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content Cubes.
• Designed ODS objects for Forecasting, vendor/material source list, sales order line items and purchase order line items relevant for APO Demand planning.
• Designed custom infosources, data sources and extract programs for APO related ODS objects.
• Designed custom sales order and purchase order infocubes and designed loading scenarios for full load and delta loading.
• Extensively worked on setting up of historical data in SAP R/3 and involved in extraction and loading into data targets in BW.
• Extensively designed delta loading strategies and designed infopackage groups and scheduled infopackage groups in batch jobs.
• Created Data Extraction programs for generating reports using ABAP/4. Created ABAP routines for Transfer Rules and Update Rules.
• Extensively used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
• Incorporated Charts and Graphs into the web templates.
• Defined and modeled queries to satisfy business analysis.
• Created source systems and remote users and created RFC connections.
• Created Analysis Authorizations, Roles and Users and assigned roles.

Environment: SAP R/3 4.6C (FI, CO (CCA, PCA), SD), BW 3.5, Oracle 9i, Windows 2000.

SAP ABAP Consultant

Confidential

Responsibilities:

• DevelopedBDC programsfor loading transactions data from legacy systems to SAP R/3.
• Created custom InfoObject catalogues for characteristics and key figures for InfoArea.
• Created update rules for the keyfigures of InfoObjects that is updated in the InfoCubes from the communication structure of infosource.
• Extended the standard IDOCs with additional segments for Creating and changing Sales order, post goods issue for deliveries and posting Material documents.
• Created Analysis module for project profitability analysis and payback/IRR calculations.
• Creating projects via CMOD to invoke custom user exits (SMOD).
• Built various validations for user inputs and business rules.
• Developed SmartForms for Invoice and purchasing document output.
• Completed documentation of the system and trained users.

Environment: SAP R/3 4.6C (MM, PP, SD, SO), ABAP/4, Windows 2000