PROFESSIONAL SUMMARY:

• Over 8+ years of professional experience as a Techno - Functional consultant in the development and implementation of the business applications which includes SAP BI/BW with releases up to SAP Net Weaver BW7.4, SAP Integrated Planning with Portal, BW ABAP Programming and experience in SAP BO 4.1 tools, With HANA and BODS Knowledge.
• Involved in Full Life Cycle implementations for different modules like SD, MM, CRM in SAP BI/BW following ASAP Methodologies which involves Gap analysis, Blue Printing, Realization, Data extraction, Data modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
• Expertise in Back-end BW Components like Standard and Custom Extractors, Info Objects, Info Sources, Update rules, Transfer rules, Info Cubes, Multi Providers, Info Sets, ODS(DSO) objects, Info Packages, DTP Loads, OLTP Data Extraction, User Exits, Real Time InfoCube/ODS, Interpreting and writing complex ABAP routines along with Code Debugging Skills, Creating Custom T Codes.
• Expertise in ETL activities like Data Extraction from SAP R/3, CRM, SCM flat files and BW using extraction structures such as LO Cockpit, Non LIS and Generic Extractors using customer exits and BADIs, Data Modeling, Loading (Full/Delta upload), Custom ABAP Programs, Using Custom / Standard Function modules and Scheduling & Monitoring Process Chains for automated data loads from different Source systems, troubleshooting the failed data loads, Data Marts and Open Hub Services, Broadcasting the reports/ workbooks to the end users.
• Upgrade Experience in SAP BW from 3.5 to BI 7.0 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0 and maintaining Transformations and DTPs, followed by BI 7.0 to BI 7.4 Upgrade project.
• Supported BW and EDIX teams in pulling data from different source systems/Loading flat files from Application Server to BW Data Targets and sending file layouts to downstream systems using APD Logical File, Physical Path and Logical path Application Server setup with help of Basis Team.
• Excellent Production support skills in data loading, performance issues, data issues, data compression activities, archiving and reporting related issues.
• Experience in setting up Analysis Authorizations based on custom table, User Profile Maintenance etc.
• Expertise in the front end business warehouse components like Query Designer / BEx analyzer Queries, Calculated key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, workbooks, InfoSet Query, Jump Analysis using RRI and Web Reporting, Creating WEB Templates using Web Application Designer Components, WEBI, Xcelsius and Dash Boards.
• Experience in Front End Integrated Planning - Input Enabled Queries on Aggregation Levels, Real Time InfoCubes, Characteristic Relationships, Data Slice, Filters, Planning Functions, Planning Sequences and Creating Custom Functions using FOX Code.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Worked on pre-calculated web templates and used control queries to increase the performance of the query and also worked on OLAP cache.
• Good Working Knowledge on reports in Business objects universe designing, Desktop Intelligence, Web Intelligence, Info view, Qwaas, Live Office and CMC.
• Experience in designing and developing ad hoc reports, scheduling the reports using CMC, Creating reports with Charts (Bar chart, Pie chart…etc), cross tabs and administering the BO activities using BO 4.0.
• Extensively used Calculations, Variables, Prompts, Sorted inputs, Drill down, slice and Dice, Alerts for Creating Business objects reports, Generating Open Doc URLs for these reports and linking the developed reports.
• Coordinated with Basis team in implementing the OSS SAP NOTE, pre-upgrade and post-upgrade tasks like preparation, Go-Live tasks, clearing delta queues, mass migration of BW transports and Objects transports from Development system to Quality and Production Systems.
• Working knowledge of MS excels concepts like VBA Macros, V-Look UP, H-Look UP, Name Ranges, Pivot table, Cell Referencing.
• Excellent team player with good logical reasoning ability, coordination and interpersonal skills.
• Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills.

TECHNICAL SKILLS:

ERP Packages: SAP ECC 6.0

SAP Products: SAP BI 7.4 SP-10, BW BEx Reporting, BW WAD, SAP ABAP

SAP Integrated Planning with Porta lSAP BO 4.1 Tools, Crystal Reports SAP Solman:

Knowledge in SAP Native HANA SPS12, BW4 HANA BW - 7.5Knowledge in SAP BODS (with SAP BW and Non SAP):

Business Areas SD, MM, CRM, SCM.:

Knowledge in FI/CO (AR, AA, AP, GL):

Languages: C, SAP BI ABAP/4, SQL - SAP ABAP CODING for ETL

Databases: SAP HANA, MS SQL Server, DB2, Oracle

Testing Tools: Quick Test Professional (QTP), HP ALM Quality Center (QC), Clear Quest.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

BW Developer

• Model, design, develop, test and implement appropriate back end structures (including extractors, DataSources, DSOs, and InfoProviders needed to meet business reporting requirements
• Coordinate with Onshore team (US), Offshore team (China, India - Mumbai) and Vendor team ( Incident Management/Project Enhancements and with Confidential for Process Chain Monitoring) (India - Pune, Bangalore and Hyderabad) on different development activities, applying development guidelines and standards to design and development, highlighting best practices
• Work on Interaction Center project developing new BI Reports on First contact resolution, Volume of Interactions etc
• Create/Enhance CRM Service - Ibase, Quote, Opportunity, Contract, Orders and confirmations data extractions from CRM to BI
• Incident management - Working with Users on resolving application, process, data load issues and process chain monitoring based on the Schedule.
• Work on BOBJ Project - Creating WEBI Reports to track the metrics on User and report usage Statistics, using Merge dimensions, Context based formulas based on Audit Universe.
• Build Universes based on relational data sources such as SQL Server, Oracle using IDT.
• Work on creating backend Data Model in BW, Bex Queries (Sales Force Management Reports for Broadcasting to the managers with sales data of all sales rep under each manager, inside sales WEBI reports) for Front end WEBI and Dashboard development coordinating with Visual BI
• Work on different projects like Upgrade to BI 7.3, SQL Server Columnar Indexing, Vendavo Extracts, Full to Delta extractor conversions, process chain data load performance improvements in the code, Broadcasting, NLS etc
• Worked with Business users on regression testing the Monthly and Quarterly reports and fixing the issues occurred with a team of developers. Write SQL statements in ABAP coding to execute custom logic for report metrics and validate the same metrics with backend ECC CRM systems data.
• Use Quality Center for defect tracking.
• Planned the cut over activities before go live during monthly release and performed the downtime/cutover activities for all the enhancements/changes from multiple developers.
• Worked on ABAP programming in the transformation routine using standard / custom function modules
• Worked on BW performance, Tuning project (Query) Extractor performance, data load performance. Improved loading performance by carrying out number range buffering, deleting secondary index, run Stats on Cubes/ODS using transaction DB20 and Database level. Improved query performance by creating Aggregates, secondary Index. Improved extractor performance by modifying the code as per best practices.
• Support post-production maintenance functions, documentation on Cutover, Checklist, fitgap, TD update and User training.

Confidential, Richardson, TX

BOBJ /BI Developer

Responsibilities:

• Being part of BI wholesale Team, Responsible for the development and extraction of data from ECC source system into BI from Finance COPA Data. Compare the data At GL and Profit Center Level, with the Navision COPA Data extracted from Non Sap Navision System through XI Interface in the XML file, Coordinated with the XI team to add BW Proxy Changes.
• Coordinated with the Security team and Users to implement Authorization Security at Company Code, Global Region, Business Area, Planning Group, Sales Org level for respective roles.
• Worked on enhancements and extracting Global Claims, Sales Incentives data using Vistex Data Sources like - /IRM/LIS RM GCRITM and /IRM/LIS RM IPSIITM
• Worked on Creating Brand report, Operational report using Cell referencing, Calculated, restricted Key figures and broadcasted the reports to specific user list.

Confidential

BOBJ /BI Developer

Responsibilities:

• Involved in analyzing and designing the data flow from ECC 6.0 to BI 7.3 and responsible for the deployment solutions for Integrated Planning Reports, FI-AP, GL, HR Data Extraction, IT Capital Projects Budget Analysis Reports, Version Comparison Reports and IT Capital dashboard.
• Responsible for the design, development and extraction of data from ECC source system into BI from FIAP, GL tables COSS, COEP, AFPO, AUFK using standard/Custom extraction methods.
• Enhanced standard data sources like 0FI GL 4, 0FI AP 4,, Created Function Module based custom Extractors, Created Flat File Data Sources, Customized start routines and end routines, and used user exits to populate data& customized delta built up for the data sources.
• Created Custom Info Objects, DSO, Standard and Real Time Info Cubes, Multi providers, Info Packages, DTP and APD for extracting data in to Flat files and in to Direct update DSO.
• Worked on Hierarchy changes to one of the Cost center, Cost Element Hierarchy.
• Created Custom T Codes in SE93 and assign them to Authorization Groups in SE54.
• Created Real Time Input Based Enabled Queries for Planning using Real Time Info cubes, Aggregation Levels, DSO based Characteristic Relationship, Data Slice locking previous month’s data, Filters, Standard Planning Functions, Planning Sequences, and Custom Planning Functions Using FOX Code.
• Designed and developed standard BEx reports on reportable Multi providers, Info Cubes, DSO's and Input Enabled queries on Aggregation Levels.
• Used Calculated Key Figures, Restricted Key Figures, Conditions, Exceptions, Filters and Variables etc. to get the required Functionality along with Analysis Authorizations using Custom Table.
• Created WAD Template with Tab Pages, Design Items like Radio Button with command sequences/data binding, Drop Down with ‘save’, ‘save as’, ‘save final’ functionality, Input enabled queries with comments update and published the same template to the portal as an IView for user update.
• Created URL Based IView, Transaction Based IView to integrate with Portal.
• With help of basis team created pages, worksets, roles in portal and assigned the IViews to the respective pages, worksets, and roles.
• Created RRI on the reports to jump from one BEx report to another BEx report.
• Worked extensively on SAP Business Objects by developing Multidimensional Universe on top of Bex Reports using Universe Designer and created WEBI reports.
• Generated Open Doc URLs for these WEBI Reports to Create URL Iview which is further integrated into Portal for end users.

Environment: SAP BW BI 7.3, SAP R/3 ECC 6.0, FI, BEx Explorer 7.X/3.X, Business Object 4.0, Universe Designer, WAD, Portal.

Confidential

BOBJ /BI Developer

Responsibilities:

• Involved in analyzing, designing and developing the data flow and data Extraction from SAP CRM to BI 7 using standard extraction methods and responsible for the deployment solutions for BW Reporting.
• Created generic extraction by using Standard / Function Module Custom Extractors with delta enabled to extract Service Contract Header and Service Contract Item level data from SAP CRM to BW.
• Enhanced Standard Service Contract Item Extractor Using BADI (ZIM RSU5 BADI SM) with custom Method - M 0CRM SALES CONTR I.
• Created Master Data Extractions for 0BPartner, 0CRM MKTELM etc using standard extractors.
• Enhanced standard data sources, customized start routines and end routines.
• Worked on writing the look-up routines for the fields coming from different Info providers.
• Actively involved in creating Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Worked on Hierarchy changes to one of the Cost center Hierarchy.
• Installed BW Statistics to monitor the daily loads and query performance on cubes and enhanced the performance by building aggregates on required objects.
• Implemented Performance tuning techniques like Compression, Partitions for improving the query response time and proposed archiving strategy for future based on the Time characteristics.
• Designed and developed BEx reports for CRM Data Service contract, Subscriptions and Notifications, Campaign and Target Group etc on reportable Multiproviders, Info Cubes and DSO's.
• Used Calculated Key Figures, Restricted Key Figures, Conditions, Exceptions, Filters and Variables etc to get the required Functionality.
• Created RRI on the reports to jump from one BEx report to another BEx report.
• Data Load and Testing reports for Master data like Z METER(Meter), ZSERVICE (Service point) and ZPREM (Premise Location)
• Worked on creating APD for extracting data in to Flat files and in to Direct update DSO.
• Worked extensively on SAP Business Objects by developing Multidimensional Universe using Universe Designer and created reports using Web Intelligence XIR2 Rich Client.
• Created Financial Webi reports based on the Universe created on the top of Finance BEx reports.
• Worked on creating new WEBI Reports for the Confidential Customer Program reporting for the new cycle 2013-14.
• Worked with Production Support team to solve issues like failure due to invalid characters, data inconsistency, and job failures.
• Actively generated Documents and involved in training and workshops for the end users.

Environment: SAP BW BI 7.3, SAP R/3 ECC 6.0, CRM 7.0, FI, MM, BEx Explorer 7.X/3.X, Business Object XIR2 3.1, Universe Designer

BOBJ /BI Developer

Confidential

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, testing to Go Live production support.
• Involved in analyzing and designing the data flow from ECC 6.0 and CRM to BI 7 and responsible for the deployment solutions for BW Reporting.
• Responsible for the design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO Cockpit extraction methods.
• Created generic extraction by using View to extract data from SAP R/3 to BW.
• Enhanced standard data sources, customized start routines and end routines.
• Extensively worked on custom data source enhancement, and used user exits to populate data& customized delta built up for the data sources.
• Worked on Extracting Data from FI sources like Accounts Payable(AP), Accounts Receivable(AR), General Ledger(GL) and enhanced standard data sources like 0FI GL 4, 0FI AP 4, 0FI AR 4 to meet the client's requirement.
• Performed setup table runs for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.
• Used the Business Content Data Extractors such as 2LIS 11 VAHDR (Header), 2LIS 11 VAITM (Item) and 2LIS 11 VASCL for Sales Orders for extracting data to BI system.
• Worked on extracting data from Inventory(Material Management) sources like 2LIS 03 BF and 2LIS 03 UM and 2LIS 01 s507 and 2LIS 01 S813.
• Created custom InfoObjects, DSO, InfoCubes, Multiproviders, InfoPackages and DTP.
• Used DTP's and loaded data to the InfoProvider through InfoPackages.
• Actively involved in creating Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Installed BW Statistics to monitor the daily loads and query performance on cubes and enhanced the performance by building aggregates on required objects.
• Implemented Performance tuning techniques like Compression, Partitions for improving the query response time and proposed archiving strategy for future based on the Time characteristics.
• Designed and developed BEx reports on reportable Multiproviders, Info Cubes and DSO's.
• Used Calculated Key Figures, Restricted Key Figures, Conditions, Exceptions, Filters and Variables etc to get the required Functionality.
• Migrated Business Objects XIR3 to Business Objects XI4.0.
• Worked extensively on SAP Business Objects by developing Multidimensional Universe using Universe Designer and created reports using Web Intelligence, Xcelsius, and Crystal Reports.
• Created dashboards using Xcelsius 2008 with Combo box, List box, Selectors, Alerts, Drill Down, What-if presentation, Filtered Rows and Dynamic visibility.
• Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, Cross tab, Multi Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV, Formulas, Variables, Sub Queries, Combined Queries (Union, Intersection, Minus).
• Created Static and Dynamic dashboards using Live Office to meet the client's requirements.
• Worked on developing reports using Xcelsius and Crystal Reports by implementing various options like sections, charts, and formula variables, Cascading Parameters, Grouping, and Summaries etc.
• Worked on a 2nd level escalation with off shore Production Support team to solve issues like failure due to invalid characters, data inconsistency, job failures.
• Actively generated Documents and involved in training and workshops for the end users.

Environment: SAP BW BI 7.2, SAP R/3 ECC 6.0, FI, SD, MM, PP, BEx Explorer 7.X/3.X, Business Object 4.0, Universe Designer, Xcelsius, Crystal Reports, ABAP.

Confidential

SAP BI/BO Developer

Responsibilities:

• Created generic extraction by using View to extract data from SAP R/3 to BW.
• Involved in Requirements gathering for reports in Sales SD, COPA and MM.
• Extensively worked on enhancing the standard data sources as per client requirement.
• Activated and utilized the business content according to the functional requirements.
• Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.
• Enhanced standard data sources, customized start routines and end routines.
• Extensively worked on custom data source enhancement, and used user exits to populate data& customized delta built up for the data sources.
• Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.
• Enhanced the data sources 2LIS 02 HDR and 2LIS 02 ITM.
• Involved in creation of reports using BEX Analyzer by using free characteristics, Restricted Key Figures, filters, Calculated Key Figures, Variables, and Exceptions.
• Enhanced standard data sources, customized start routines and end routines.
• Monitoring process chains and fixing data load issues.
• Involved in resolving the Tickets (Incident & change request).
• Maintained Reconciliation's to verify the data in SAP R3 and SAP BW.
• Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.
• Analyze the failed data loads and fixed the data loads.
• Enhanced process chains for master data attribute, text and hierarchies.
• Enhanced data source 2LIS 03 BF (Inventory: Material Movements)
• Enhanced standard data source for master data attribute and transaction data.
• Involved in configuration of Order to Cash (SD) i.e. from Enquiry to cash receipt from customers.
• Worked on analyzing BIA indexes to improve the performance of the Bex queries.
• Created reports using BusinessObjects Webi, Crystal Reports and other web development tools like Infoview to provide Web-enabled data analysis solutions to business users.
• Worked on the Universe Designer, Web Intelligence (Webi), Web Intelligence Rich Client and Crystal Reports.
• Created business reports using Crystal Reports functionalities like Charts, Cross-Tabs, Formulas, Parameters, Running Totals, Add Queries, Sub-reports and Drill down.
• Widely used Filters, Sections, Breaks, Variables, Sorts, Ranks, Alerter and Prompts to create reports on Webi and Crystal Reports that meet business user requirements.
• Applied Filters, Ranks and Alerter to restrict unwanted data, expose best and poor performers and highlight the data as required by users.
• Developed Business Objects reports using multiple Queries and combination of Charts and Tables.
• Created Crystal Reports based on existing Universes from Business Objects.
• Designed and organized Classes and Subclasses according to the various Business requirements.
• Involved in resolving the Tickets like SR, MR and CR.
• Scheduling and Monitoring background jobs and coordinating with on-site team lead and updating day-today activities.
• Involved in Production Support stages of the Full lifecycle Project implementation from Blue print to go-live.
• Involved in UAT and coordinated with the Development team to fast resolution of issues and closing the tickets.

Environment: SAP BW BI 7.0, SAP R/3 ECC 6.0, SD, MM, CO-PA, BEx Query Designer 7.X/3.X, BEx Analyzer, Business Object XI R2, Universe Designer, Xcelsius, Crystal Reports, ABAP.

Confidential

SAP BW Technical consultant

Responsibilities :

• Involved in all phases of ASAP methodologies, project planning, Business Blue printing, Realization, Final Preparations, Go-Live and Support.
• Analysis of data requirements and translation of these requirements into dimensional data models using starschema and extended star-schema data modeling techniques, with an emphasis on actual implementation in BW.
• Created InfoObjects, DataSources, InfoSources, Data targets, InfoPackages and InfoCubes to load Master and Transactional data from SAP R/3 system into BW system.
• Developed Transfer Rules to extract data from various DataSources into transfer Structures.
• Created, Maintained and modified existing queries on different InfoCubes related to SD, MM and FI/CO modules. Extensively worked on Query building, filtering data, variables.
• Extensive use of process chain to automate loading all master and transaction data
• Generated reports like Plan/Actual comparison, Open Sales Orders and Incoming Sales orders using Sales Planning.
• Developed a custom Infocubes for material movement (quantity and value) like Goods receipts, returns and consignment stocks (vendor managed inventories and customer managed inventories) based on plant, storage location, material, material group, vendor and customer.
• Designed and implemented a reporting solution for web reporting, information broadcasting, pre-calculated web templates and background scheduling.
• Redesigned and indexed existing info cubes and ODS for better performance of the data loads and reporting.
• Created Aggregates on the info cubes and compressed them to improve the report execution time.
• Created documentation and implemented necessary authorizations and securities for the end user reports.
• Worked on the creation of roles, Custom authorization objects on hierarchies.
• Error Debugging and rectification, solving issues, problems faced during data uploads.
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.

Environment: SAP R/3, SD, FI/CO, MM, BW 3.X

Confidential, NJ

SAP BW Consultant

Responsibilities:

• Worked for Evaluation Phase - To- Processes the Business Requirements with high-level process flows and process descriptions for the Roll Out, from requirement analysis, blue print, realization to post go live support
• Requirement Analysis for key operational reports and management reporting, identification of potential gap information
• Involved in creating the Business Blueprint documentation.
• Created Process chains to automate the load schedule. Extracted data from ECC & Flat files.
• Designed queries on Sales and Distribution, Finance, Material Management.
• Created billing and history, credits raised, general refund, bad dept, customer invoices Split by material, state level pick and delivery reports, quote to cash.
• Created Web templates for queries using Web Application Designer
• Data loads (daily, weekly and monthly) using dedicated Process chains
• Created authorization objects for reporting.

Environment: SAP BW 3.X, SD, FI-CO, SAP R/3 4.7, Business explorer, Web Application Designer.