SUMMARY

• I have more than 12 years of experience in design, development and implementation of all Data Warehouse and Business Intelligence phases. I have work experience in different kinds of projects like Implementation and Production Support Projects in SAP BI 7.0, BW 3.5, BPS, Integrated Planning and Business Objects 5.1/6.2/6.5/ XI/ XI R2, 3.1,4.0 Crystal Reports 2008,Xcelsius 2008, Dashboard 4.0, Data Integrator/Data Services 3.2, 4.0
• Implemented 5 Full Life cycles as a SAP BW/BI Developer consultant using ASAP methodology for ETL that includes gathering business requirements, analyzing the business process, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Data migration, Go-live and Post-go-live support along with other Post-Implementation and Post Maintenance projects in SD, PS,HR,MM and FICO functional areas.
• Good experience in SAP new generation products like BPC7.0NW,BOBJ Enterprise Tool set(Universe Designer, Information Design Tool, Web Intelligence, BI Launch Pad, Live office, Xcelsius, Dashboard 4.0, SAP Crystal Reports 2008, 2011 and QAWS
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update rules, routines, Transfer rules, Process Chains and Event management for Automation process, Transformations in BI 2004s.
• Created Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Data Slices, Characteristic Relationships using Integrated Planning
• Created Multi Planning Area and Modeling of Planning Structures using Planning Area, Planning levels ,Planning functions, Planning packages, Parameter groups and planning sequences using SEM-BPS
• Experience with implementation, configuration and solving of module-level issues in FICO, FI-SL, CO-PA, FI-GL, LIS, LO, MM, SD, QM, and IM.
• Strong experience with OLAP reporting in BW and implementation of BEx Analyzer. Worked extensively with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting.
• Debugging Data load errors, Delta Queue Monitoring, and Extractor Checker by simulating BW asking for data and Customer Exits. Master/Transaction data testing
• Hands-on experience on Queries, Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Crystal reports, Authorizations, User profile maintenance, BEx Analyzer, Info set query, RRI, Web reporting and Workbooks.
• Experience in extracting data from SAP R3/ECC, non-SAP systems, and flat files
• Good Knowledge in SAPR/3 ABAP/4 Data Dictionary, Editor, BDC, Reports and Scripts
• Good Knowledge in SAP HANA
• Good Knowledge in SAP EP (Enterprise Portal)
• Good team player, Strong team orientation & leadership qualities, hard working and enthusiastic.
• Very good logical skills suitable for process design, development & implementation.
• Excellent communication and presentation skills and Customer Oriented attitude.

SAP BW Certified Professional 3.0

Cognos 8 BI Author v2

EDUCATION:

MIS (Management Information Systems)
Bachelor of Science in Computer Science
PACS Administrator Program

SKILLS SUMMARY:

SAP Applications: BI 7.x, BW (3.x), SAP Business Objects
Databases: Oracle 10 g, 9i, 8.x, MS Access ‘98
Software Languages: ABAP/4, PL/SQL
Platforms: Windows 9x/NT/2000, UNIX [Sun Solaris 5.7], Linux
Scripting: HTML, CGI, Perl
Networking: TCP/IP, HTTP, LAN, WAN

EXPERIENCE SUMMARY:

Confidential, Canada Dec 2010- till date
Job Title: Sr. BI/BOBJ Architect/Developer

Confidential, selected SAP BI 7.2 for ETL. Business Objects edge XI 3.1 and SAP BusinessObjects Business Intelligence 4.0 for development of Web Intelligence reports and Crystal reports. I build and maintained around 25 Cubes and 10 Multiproviders using SAP BW (ETL)

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Analyzed and mapped Business Process to BW and created blueprints using ASAP methodology.
• Installed and activated Business Content Cubes, ODS, Info Sources and Data Sources
• Designed FI/CO, Revenue recognition, Head count personal actions, Sales Overview, COPA cubes for reporting purposes
• Loaded sales data into Cube (0SD_C03) using the following extractors: 2LIS_13_VDITM, 2LIS_13_VDHDR, 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_11_VAHDR, 2LIS_11_VAITM
• Installed and activated Business Content Cubes, ODS, Info Sources and Data Sources
• Involved in complete Logistics - Inventory Management and controlling activities which used 0IC_C03 cube and extractors such as 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM
• Designed, developed and deployed SAP BI Objects (Data sources, Transformations,

Data transfer process and Open Hub)

• Scored high reputation with users in interaction and fulfilling their requirements on time and quality.
• Created custom InfoSources & Info Objects in BW and mapped them with R/3 fields using transfer rules and Generic Extractors
• Designed, developed, tested and deployed Info cubes, Multi-Cubes, DSO and BW data marts.
• Developed Architectural guidelines, development standards and naming standards for SAP BI Applications
• Designed and developed Business solutions in SD, MM, and PS FICO.
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Worked extensively on BEx Analyzer. Used Navigational Attributes, Filters, Exceptions, Conditions, Variables, Hierarchies, etc. Created Templates for WEB Reports
• Designed and developed and deployed process chains for scheduling data loads.
• Installed and configured Business Object 4.0 sp4 fix pack 3 environments for development, quality and production servers
• Designed and Developed Webi reports and Xcelsius Dashboards using SAP BusinessObjects enterprise XI 3.1 and SAP BusinessObjects Business Intelligence 4.0
• Designed and Developed universes using Information Design Tool and Universe Designer.
• Installed and Configured Live Office to Integrate SAP BusinessObjects Enterprise XI 3.1 and Xcelsius 2008.
• Web Intelligence reports were created and deployed through Info View and BI Launch pad.
• Provided training for super users and end users on Info view and BI Launch pad portal
• Working on Technical Documentation

Environment: SAP BW 7.2, SAP Business Objects Business Intelligence 4.0 SAP BusinessObjects Enterprise XI 3.1,Web Intelligence XI 3.1,4.0 Universe Design XI 3.1,Crystal report 2008,Information Design Tool 4.0, Oracle, MS SQL Server

Confidential,Canada May 2010 to Dec 2010
Job Title: Sr. BI/BOBJ Developer/Consultant

Confidential,selected SAP BI 7.x and Business Objects XI 3.1 for Migration and Conversion Project. I created 15 Info cubes. I also designed and developed 35 complex reports using Web intelligence and Crystal Reports using OLAP Cubes I also created 10 dashboards using Xcelsius 2008 Dashboard Tool.

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Installed and activated Business Content Cubes, ODS, Info Sources and Data Sources
• Involved in Data Modeling, Data Extraction, Data Loading (Full/Delta Upload), Scheduling, Monitoring.
• Used Write-Optimized DSO (Data Store Object) to load data into BI system.
• Installed the necessary objects for Business Content Sales Cube.
• Extracted data from SD, MM and FI/CO modules of SAP R/3 and from flat files into SAP BI system using Generic Business Content and LO Extractors.
• Used Delta Update process for loading the data to BI from R/3 in specific intervals.
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Created Process Chains to automate the transaction / master data loading
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers
• Modified BO Web intelligence reports and Universes
• Redesigned and created new Universe(s) to support reporting requirements
• Designed and developed complex reports using Web Intelligence and Crystal Reports 2008
• Installed and configured Live Office to Integrate SAP BO XI 3.1 and Xcelsius 2008
• Worked on CMC(Central Management Console) Security, Users and Groups
• Provided Training for Super users and End users
• Provided Technical documentation

Environment: SAP BW 7.x, SAP Business Objects Enterprise XI 3.1, Web Intelligence XI 3.1, Crystal Reports 2008, Xcelsius 2008, Universe Design XI 3.1

Confidential,March 2010 to May 2010
Job Title: Sr. BOBJ Developer/Consultant

Confidential, selected Business Objects XI 3.1 and SAP Xcelsius 2008 for Foreign Exchange Conversion Project. I designed and developed Web Intelligence reports and also developed and converted Cognos reports to web Intelligence reports. I also designed and developed complex reports using Web intelligence, Crystal Reports and Xcelsius.

Responsibilities:

• Designed and developed Web Intelligence reports while establishing a refined standard with IT and Business community.
• Extensive experience of BOBJ implementations both at architecture level and as a developer
• Consistently reviewed with developers and multiple user groups to establish optimal development technique; delivered a multitude of Web Intelligence reports, new and revisions to older ineffective reports.
• Solely redesigned and created new Universe(s) to support reporting requirements
• Designed and developed complex reports using Web Intelligence and Crystal Reports 2008
• Designed and developed Xcelsius dashboards using Xcelsius 2008
• Recommended and applied end-user centric and performance oriented designs following SDI methodology and SAP BOBJ best practices.
• Established a widely accepted standard in Web Intelligence reporting that was absent across many previous projects and helped define development processes progressing internal controls and development team skills.

Environment: SAP Business Objects Enterprise XI 3.1, Web Intelligence XI 3.1,, Business Objects Xcelsius 2008, Desktop Intelligence XI 3.1, Cognos 8.3(Framework Manager, Query Studio, Report Studio, Analysis Studio)Universe Design XI 3.1 Crystal report 2008,Oracle, MS SQL Server

Confidential,Job Title: Sr. BOBJ Developer/Consultant December2009 to March 2010

Confidential,selected Business Objects XI 3.1 and SAP Xcelsius 2008 for Pathfinder Executive Xcelsius dashboards (Finance Epicor (General Ledger), Asset Servicing, Issuer Services, Total Trade Settlements, Sales Analysis Dashboard, KPI Dashboard, Human Resource Dashboard. I designed and developed existing Dashboards using SAP Xcelsius 2008 and also Designed and Developed Universes and Web Intelligence Reports.

Responsibilities:

• Installed desktop component of Xcelsius onto CIBC Mellon designated computers
• Created connectivity with Live Office and Qaaws
• Tested dashboards against webi report and Universes Queries
• Tested dashboards in development BOXI environment
• Documentation, troubleshooting and plan updated
• Reviewed dashboard storyboard - ensured that deliverable expectation does not exceed functional abilities of products
• Demo of basic capabilities to development team –“ show and tell” to the project team to solidly understanding of dashboards delivery
• Reviewed of high-level work breakdown structure with emphasis on high level activities and dependencies - WBS analysis.
• Statement of Work and Proposal consolidation - resource breakdown
• Developed and designed Xcelsius Dashboards for the quadrants as per the requirements.
• Designed and developed reports using Web Intelligence reporting tool
• Installed and configured Business Objects Data services XI 3.2.
• Worked on BODS Job Schedulers
• Worked on Business objects Data Services for developing jobs
• Designed, developed and maintained ETL script using SAP Data Services
• Worked with BODS to automate jobs through Management console and also Created Batch jobs
• Developed and enhanced SQL stored procedures and business views for reporting.
• Advanced Data Warehouse Concepts and Strategies
• Worked with Business Objects XI 3.1 Info View
• Worked with Business Objects XI 3.1 Web Intelligence

Environment: SAP Business Objects Enterprise XI 3.1, Data Services (BODS) 3.2 Web Intelligence XI 3.1, Business Objects Xcelsius 2008, Universe Design XI 3.1, Oracle, MS SQL Server

Confidential,Canada June 2009 to November 2009

The PWGS selected Business Objects xi 3.1, SAP BW 3.5 and SAP Enterprise Portal for complete Enterprise Reporting to replace Bex, Web and current existing Portal (Reloweb). I designed and developed existing reports such as Employee Spend Report, Storage Report, Financial Payment tracker Report, Employee Status, Employee financial detail spend report, Nobody’s perfect feedback Report, Employee financial summary spend report using Crystal Reports 2008, and Web Intelligence.

Responsibilities:

• Customized Sales Overview (0SD_C03), Purchasing Data (0PUR_C01) as per the client\'s requirement and enhanced the data sources and loaded into the data targets.
• Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains were scheduled for periodic loads.
• Configured and extracted Inventory management data from LO Cockpit extractors by making use of the SAP defined data sources like 2LIS_03_BF, 2LIS_03_BX, 2LIS_03_UM.
• Experience in SAP BW Integration Planning and SEM BPS using Transactional Infocubes
• Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow.
• Creation and maintenance of BI objects (InfoCubes, DSO objects, Infoset, Multi Providers).
• Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
• Worked extensively on BEx Analyzer. Used Navigational Attributes, Filters, Exceptions, Conditions, Variables, Hierarchies, etc. Created Templates for WEB Reports
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Involved in documentation for the mapping, technical specifications, data validations and Test cases
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Business Intelligence Reporting and Analytics Tool Implementation (Business Objects)
• Involved in migration and deployment of the universes and reports
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and Info View) to perform various tasks specific to every component.
• Preparation of Project plan and HDD, LDD of Universe and reports.

Environment: SAP BW 3.X,SAP Business Objects Enterprise XI 3.1, Web Intelligence XI 3.1, Business Objects Xcelsius 2008, Desktop Intelligence XI 3.1, Universe Design XI 3.1, Crystal Reports 2008, SAP Enterprise Portal, SAP R/3, SQL Server 2005,SAP BW, SAP CRM

Confidential,Canada September 2008 to April 2009

Confidential,selected Business ObjectsXIR2, SAP BI 7.0 and Business Objects Xcelsius Enterprise for complete Enterprise Data Warehouse solution to replace IBI and BTO Portal and establish Business Intelligence system. I built 10 Info cubes. I migrated around 150 reports and 16 universes from Version 6.5 to Business Objects XI R2. I designed four Universes (SAP Master, SAPLAND Interface, Surface Rental and Business Land). I also designed 6 Existing Reports (PNG LAND Info report, Net ACRES Variance Summary Report, Property ID, Mars-Land Report, BP Cost center Report, SAP Master detail report, Facilities Report) and 2 Complicated Reports (Fit Gap Analysis Report, Well Insurance). My expertise includes; Business Objects with SAP BI 7.0, Web Intelligence (WebI), Desktop intelligence (DeskI), Business Objects Xcelsius enterprise,Central Management Console (CMC) Import Wizard, Administrative Tool, Enterprise Performance Management (EPM), DI Web Administrator, Meta Data Reports and Repository Manager.

Responsibilities:

• Review reporting requirements as given in the business requirements analysis guide, Review and develop the resulting data model in BW
• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team.
• Maintaining Reconciliation’s for FI/CO and Inventory data to verify the data in SAP R/3 and SAP BW are same or not after the month end data loads as a part of month end activities.
• Actively involved in transition Phase to take Knowledge transfer and prepared SMTD document for SAP-BW system.
• Designed and developed BI objects for FI/CO, SD,MM,PS (Data sources, Transformations,

Data transfer process, Data Store Objects, Info Cubes)

• Creation and maintenance of BI objects for FI/CO, SD, PS (Info Cubes, DSO objects, Info set, Multi Providers)
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Worked extensively on BEx Analyzer. Used Navigational Attributes, Filters, Exceptions, Conditions, Variables, Hierarchies, etc. Created Templates for WEB Reports
• Business Intelligence Reporting and Analytics Tool Implementation (Business Objects)
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Preparation of Project plan and HDD, LDD of Universe and reports
• Provided training for end users and super users

Environment: SAP BW 3.5 SAP Business Objects Enterprise XI R2, Web Intelligence XI R2, Desktop Intelligence XI R2, Universe Design XI R2, XIR2 Info View, Business Objects Xcelsius 2008, SAP R/3, SAP CRM, ,DB2,Teradata, Oracle 10 g. SQL Server 2005, PL/SQL, Toad, ER Win, Microsoft Visio, Microsoft Project.

Confidential,Columbus, GA, USA October 2006 to July 2008

Confidential,selected Business ObjectsXIR2 and SAP BW 3.5 for complete Enterprise Data Warehouse solution to establish Business Intelligence system. I designed five Info Providers in the business areas like: Policy Service Tracking System (PSTS), Web Interface Transaction Tracking System (WITTS), Policy Service Workflow (PSW), Business Process Management (BPM), Business Activity Management (BAM) and Agent Control Force (ACF). I designed five Universes and updated many existing universes.

Responsibilities:

• Developed Custom Aggregation Levels, Filters, Planning Functions and Planning Sequences required for various applications like Trail Balance, Consolidation of Cost Center Actual, Profit Center Actual and Balance Sheet Actual applications.
• Developed Virtual Cube to fetch exchange rates stored in TCURR table at runtime
• Developed Consolidated P&L , Balance Sheet trend reports, monthly, Yearly and Year to date showing with Actual vs. Budget, Actual vs. Forecast data and integrated them into several financial reporting workbooks
• Remodeled Cost center Planning, Profit Center Planning, Balance Sheet Planning cubes developed in prior phase in order to maintain company code and group currency Key figure to support consolidation data.
• Maintained Characteristic relationship to derive company code, profit center while planning in planning applications by planners
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Developed Currency Translation function by using Formula type planning function to transfer currency from different local currencies to group currency as per exchange rates (PLN, MTD and YTD) maintained in TCURR table in all planning applications developed in prior phase.
• Developed transactional cubes for Consolidation of Cost center actual, Profit Center Actual and G/L Actual and involved in loading of actual data from 0CCA_C11, 0PCA_C01, 0FIGL_C01 to the Cost center Actual, Profit Center Actual and Balance Sheet Actual cubes.
• Developed Balance Sheet transaction Cube to maintain Balance sheet plan data.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Designed and Developed Webi reports and Xcelsius Dashboards using SAP Business Objects enterprise XI R2

Environment: SAP BW 3.5 Business Objects; Business Objects Enterprise XI R2, Web Intelligence XI R2, Desktop Intelligence XI R2, Universe Design XI R2, XIR2 Info View.

Confidential, Canada May 2005 to October 2006

Responsibilities:

• Analyzed and mapped Business Process to BW and created blueprints using ASAP methodology
• Developed Bex reports using Query Designer and set as data providers in WAD by using Broadcasting features.
• Worked in functional areas FICO (FI-AR, FI-AP, FI-GL, CO) and Logistics (SD&MM) for backend development and front end reports.
• Validated all the variables, formulas, text variables, restricted and calculated key figures, custom exits
• Good working knowledge in Structures, Cells, and Global & Local definition of the queries
• Designed complex queries for Account Ledger using variables, calculated key figures, filters and conditions, Exceptional Aggregations.
• Understanding the client requirements and project functionality
• Created Customer exit variables as per requirements in Reports
• Used Report Designer tool for formatting queries
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Involved in designing, developing Info Cubes, ODS objects, and loading data into them.
• Involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service.
• Documented the business process by identifying the requirements and was involved in finding the system requirements.
• End-User Training / Defined and configured end-user roles and profile generation.
• Designed and developed existing reports using bex and Crystal Reports

Environment: SAP BW 3.5, SAP ABAP, Crystal Reports

Job Title: SAP BW Developer

Confidential,
Responsibilities:

• Day to day Management of more than 25 info cubes related to FI/CO,SD,MM,QM,PS and HR cubes.
• SAP BW delta load, Info package creation, IPG Creation, Updating Update rules, Modify communication structures and Day to day transport support.
• Resolve and implement BW Query faults ( Day to Day ) and change requests
• Prepared technical documentation as per deliverables and Interacted with users for gathering information on reporting requirements.
• Extracted logistics data using data sources 2LIS_03_BX, 2LIS_03_BF, 2LIS_02_SCL this data sources are used to extract data related to Inventory Management, Plant Stock Movement and PO Extraction.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• Used Report Designer to format the Reports
• Involved in Creation of DSO Objects and also worked with various options, which involves activating data in DSO and also updating the data in DSO to subsequent data targets.
• Designed, developed and tested ABAP routines and transformations to accomplish complex

Business rules

• Created generic Data Sources using ABAP function modules for data extraction
• Enhanced Data Sources for transaction data, master data attributes, and texts using ABAP
• Creating SD, MM and FICO Bex reports and run in Bex Analyser saving as work books by using excel formulas.

Environment: SAP BW 3.0

Job Title: SAP BW Developer

Responsibilities:

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content
• Designed & Developed custom FICO, SD, PS DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation
• 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
• Analyzed and mapped Business Process to BW and create blueprints using ASAP methodology.
• Legacy to SAP and SAP BW Migration (Application and data Migration)
• Created process chains for data loading, delta uploading and periodical PSA deletion
• Physical Deployment Architecting for installing sap BW instance.
• Dimensional modeling and extended star schema modeling
• Extracted and loaded data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Provided training for End Users and Super Users.

Environment: SAP BW 3.0

Confidential,Canada February 2000 – November 2000
Job Title: SAP BW Developer
OBJECT SOLUTIONS INC

Responsibilities:

• Analyzed business requirements and required BW business content for Financial and SD Modules.
• Worked extensively with Informatica (ETL)
• Designed Multi providers from the existing basic GL and Vendor cubes for reporting purposes.
• Designed basic GL (FI) and Vendor (AP, AR) cubes for reporting purposes.
• Modified and activated transfer rules and maintained communication structure.
• Modified the user exits to populate the custom fields added to the data sources.
• Data load management, event processing and reporting optimizations
• Set up periodic jobs for delta-data uploads, created aggregates, indices for a better query performance and used event-chains to notify end-user of report availability.
• Created queries for BEx reporting for sales lead report (sales prospect monitoring), and daily-billed reports (revenue monitor).
• Created reporting authorizations and user profile maintenance.
• Performance tuning in BW.

Job Title: SAP Basis /BW Developer
Exhaust Systems

Responsibilities:

• BW Data warehousing physical and logical Modeling and Implementation and preparing customer specifications and documentation.
• BW installation and Set up.
• BW Database and applications and Apply patch application.
• BW Database performance design, monitoring and tuning BW to sap r/3 and r/3 to BW Database migration experience. (Sybase SQL anywhere to Oracle, IBM db2 to oracle, MS SQL server to Oracle.)
• R/3 systems: sap r/3 installation, user administration, performance tuning, printing administration, management of batch, backup and recovery, archive (BR) back up, definition of r/3 related alerts, bug correction, patches and upgrades, support of functional teams with data loads and interfaces. Assistance in upgrading projects, data base security, preventive maintenance, sap data recovery planning, planning for enterprise wide back up for sap r/3.