SUMMARY

• 15 years of professional experience and over 13+ years of experience working in SAP BI/BW, BOBJ, SAP Crystal Report Enterprise, HANA and BPC, involved in four (4) life cycle implementations involving design and development of BW Objects, Transformations, Business Content configuration, Capacity Planning and Sizing using SAP ASAP methodologies.
• Provided in - depth business and IT consultation to clients, peers, management, and external partners to gather information about program needs, objectives, functions, features, and input and output requirements.
• As a BW /BI Senior Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Preparation of cutover activities, System configuration checks, Quality Assurance to improve performance of the system, New solution handovers in COPA, FIGL, SL, AP, AR, SRM, SCM, SD, QM, MM, PP and HRM modules.
• Experienced in Business Objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, and Business Objects Enterprise.
• Experience in developing BI Reporting solution on relational and multidimensional data sources, SAP BI BO Integration leveraging SAP Datasouces.
• Involved in gathering, analyzing, and documenting requirements, functional and technical specifications for Business Objects Universes and Reports.
• Extensively worked in designing Business Objects Universes, creating complex reports using Web Intelligence and Deski.
• Experience in creating BEx Queries using calculated and restricted key figures, variables, structures, Exceptions and conditions.
• Hands on Experience in designing Info Objects, Data Sources, DSO, Infocube, Multi Provider and familiar with creating Info package and loading data from PSA to Data Targets.

TECHNICAL SKILLS

Reporting: Performed unit testing, system integration testing and user acceptance testing of Business Object and BEx Reports. Experienced in using BEx Analyzer, WAD, BEx Browser, work books, Info Set Query, Web Reports, Enhanced reports applying Filters, Conditions, User Exits, Customer modifications, style sheets, graphs and parameter validation. Experience in Using WEBI, CMC and BI launch Pad and Upgrade of SAP Business Intelligence 4.0.

Data Modeling: Design Data Warehouse (Dataflow), Development (Info Cube, ODS, InfoSets), Configuration of Info Cubes, extractors, Business Content, SAP ASAP methodologies, GAP Analysis.

Extraction: Integration of SAP BW with FI/CO, SD,QM, Extracted Master Data, Transactional Data, Text, Hierarchy using different type of extraction including Generic Extraction and LO extraction from both SAP R/3 and Non-SAP Systems. SEM - Settings for SAP SEM-BPS, Planning Environment and Modeling Planning Area, Planning Level, Planning Package, Planning Profile.

Performance: Fine Tuning (BW Production Go live) Load Management and reporting optimization taking into account various factors like Initialization, then deltas, Avoid Sid’s, indexing, maximum number of parallel processes, minimum number of data records for each data package. Maintaining Aggregates, Compression, partition, and use of BW statistics for the same.

BW/BOBJ Security: Analysis Authorizations, Reporting Authorizations, user profile maintenance.

BPC: Experience with BPS design, development, support, maintenance and interfaces.

Business Areas: BO 4.0, SD, MM, SCM, FI/CO, BPS, APO, BPC

PROFESSIONAL EXPERIENCE

Sr SAP BI/BOBJ Consultant

Confidential

Environment: SAP BI 7.3, HANA, BOBJ 4.0, SAP Crystal Reports for Enterprise 4.0 and SAP ECC.

Responsibilities:

• Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
• Participating and finalizing the functional requirements from the business users.
• Responsible in converting the functional requirements to technical designs.
• Successfully implemented CRM, SD, MM and FI/CO modules Developed custom function module extractors, used ABAP routines in transformations.
• Providing project work load and timelines to the business users.
• Responsible for defining technical strategy and tactical plan for implementing data and information delivery solutions.
• Worked on Global and regional reports.
• Participated in design reviews, spec reviews, code reviews, test plan reviews.
• Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.
• Worked on customization and enhanced the extract structure to support business needs.
• Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1).
• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements.
• Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA).
• Debugging the Extractor checker, Start routines and End routines.
• Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Worked with Datamarts, Myself source, Generate export Datasource and Replication.
• Created DTPs, Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data.
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems.
• Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer.
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures.
• Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.
• Experience and knowledge of the various methods to access and extract master data and fact data (including consolidated data) from BPC (Business Planning and Consolidation).
• Collecting and Releasing transports (BW and BEx). Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production,.
• Reconciliation of BI reports with the ECC & legacy data as wells as the reports.
• Developed BI Reporting solution on relational and multidimensional data sources, SAP BI BO Integration leveraging SAP Datasouces and upgrade of SAP Business Intelligence 4.0.
• Worked in designing Business Objects Universes, creating complex reports using Web Intelligence and Deski.
• Expertise in creating, organizing, publishing and scheduling reports using Center Management Console.
• Involved in solving UAT issues and change requests.
• Created technical specification documents for report requirements.
• Worked with team members to communicate and ensure understanding of requirements and tasks.

Sr. SAP BI/BOBJ Consultant

Confidential

Environment: SAP BI 7.0, BOBJ 4.1, SAP Crystal Reports for Enterprise 4.0 and SAP ECC

Responsibilities:

• Created Crystal Reports for different teams and groups in the organization to fulfill their business needs.
• UsedSQLextensively in command objects of Crystal reports.
• Created Custom functions,formulae,cross tabs, graphs and charts.
• Develop an understanding of the business and data requirements to ensure a successful project.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc.
• Created reports withdrill downoption,Parameter fields, formulae, and heavy formatting.
• Created number of formulae,running totals conditional display of fieldsfor complex calculations and used them insub reports.
• Performed unit testing, system testing and user acceptance testing (UAT) for reports
• Created Crystal reports on BEx queries.
• Scheduled reportsin Business Objects 4.0 to run on daily/weekly/monthly basis and to distribute the output in different formats to various users.

Sr. SAP BI/BOBJ Consultant

Confidential

Environment: SAP BI 7.0, BOBJ 4.0 and SAP ECC

Responsibilities:

• Gathered and documented requirements from end-users, perform analysis, and assist in the design, testing and implementation of new/changed functionality for SAP Business Warehouse (BW) and Business Objects (BO) reporting across SAP functional areas.
• Facilitated requirements gathering with key business stakeholders by using excellent inquiry and communication skills.
• Evaluated current system capabilities to identify changes that need to be made and determines the impact to the business. Ensures that the proposed solution fulfills the business need.
• Worked as a team member within IT to implement defined solutions.
• Developed technical specifications from which applications will be written to support the business
• Worked with team members to communicate and ensure understanding of requirements and tasks.
• Developed programs and solutions using appropriate technologies and provides ongoing support in responsible areas.
• Provided test plans and executes technical and functional tests of solutions to verify desired results. Evaluates results and coordinates modifications necessary to meet the requirements.
• Developed and maintain all system related documentation.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and Financial areas. Created SAP BOBJ reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Modifying BI reports as per the need of the user.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and BEx reports.

SAP BI/BOBJ/BPC Consultant

Confidential

Environment: SAP BI 7.0, BOBJ 4.0 SAP BPC, Crystal reports 2012 and SAP ECC

Responsibilities:

• Gathered and documented requirements from end-users, perform analysis, and assist in the design, testing and implementation of new/changed functionality for SAP Business Warehouse (BW) and Business Objects (BO) reporting across SAP functional areas.
• Facilitate requirements gathering with key business stakeholders by using excellent inquiry and communication skills.
• Identified key issues, develops action plans, maintains project schedules, coordinates in-depth analysis, and delivers quality solutions on time and within budget.
• Responsible for identifying and leading required architecture disciplines on the project.
• Participated in established on-call schedule.
• Established and maintained communication channels to keep Business Applications Manager informed of project status, accomplishments, issues and challenges.
• Influence and propose approaches and methodologies to properly align work with process.
• Analyzed data and processes in order to recommend and implement reporting solutions that support the functions.
• Facilitate analysis of issues or enhancements by querying SAP data using SAP BW queries.
• Create tickets, development requests and other documents required by the WCS Globe Center to request work from the Regional Business Solutions group.
• Provide end-user support for all reporting activities using SAP BW and Business Objects
• Installed and activated Data sources for Cost Center, GL/Account, WBS Element, funds and Grants master data from ECC.
• Installed and activated data source for Cost Center hierarchies in SAP and BW.
• Building BI Info Cubes, ODS, extractor and update programs. Create and maintain ODS's, InfoCubes & Multi-providers.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and Bex reports.
• Assists WCS organization with SAP BI with Crystal Reports 2012 knowledge at a level of understanding appropriate to their job function, including:
• End-user documentation
• Creations of functional and Technical documents to create Crystal Report
• Deliver training
• Technical documentation
• Knowledge transfer and meet deadlines for the assigned projects and tasks
• BPC -
• Gather the requirements for blue print, build, the Budgeting and Forecasting functionalities.
• Configure data manager extraction from ECC and BI system for the actual data.
• Configure data manager extraction from ECC and BI system for the actual data.
• BPC process chain development to the financial data to staging DSO and to the cube.
• Process chain development to support master data loads from BW to BPC.
• Loading the historical data, opening balances current year data to BPC application from legacy source system.
• Defining and Creating Input Templates.
• Creating and Developing Budgeting Business Process Flows.

SAP BI/BOBJ Production Support Lead

Confidential

Environment: SAP BI 7.0, SAP BOBJ and SAP ECC

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Evaluated current system capabilities to identify changes that need to be made and determines the impact to the business. Ensures that the proposed solution fulfills the business need.
• Worked as a team member within IT to implement defined solutions.
• Developed technical specifications from which applications will be written to support the business
• Worked with team members to communicate and ensure understanding of requirements and tasks.
• Developed programs and solutions using appropriate technologies and provides ongoing support in responsible areas.
• Provided test plans and executes technical and functional tests of solutions to verify desired results. Evaluates results and coordinates modifications necessary to meet the requirements.
• Developed and maintain all system related documentation.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and BEx reports.
• Designed Business objects universe, Business Objects Web Intelligence, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0.
• Modifying BI reports as per the need of the user.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.

Confidential

SAP BI/BOBJ Project Lead

Environment: SAP BI 7.0, SAP BOBJ and SAP R/3

Responsibilities:

• As a Project lead I was responsible for leading a team of technical consultants for implementing data lifecycle management, migrating 3.x objects to 7.0 and BI Unicode, i.e. Non-English for BI Translation in BI Query Designer.
• Communicate project activities and progress to the business.
• Manage business process activities to ensure that the project meets its objectives on time and on budget.
• Provide leadership to all project phases & change activities.
• Identify project risks and formulate risk mitigation plan.
• Responsible for identifying and leading required architecture disciplines on the project.
• Worked with SMEs to refine solution design alternatives in understanding the proposed business process change.
• Develop functional requirements for changes to business applications and processes.
• Demonstrated project benefits to the business.
• Building BI InfoCubes, ODS, extractor and update programs. Create and maintain ODS's, InfoCubes & Multi-providers.
• Identified and evaluated alternate technical solutions, providing recommendations in the use of new and/or existing technologies.
• Troubleshoot and resolve production problems in BW, Business Objects Universe, WebI and Bex reports.
• Assists others in the organization with SAP BI knowledge at a level of understanding appropriate to their job function, including:
• End-user documentation
• Deliver training
• Technical documentation
• Knowledge transfer and meet deadlines for the assigned projects and tasks

Confidential

SAP BI/BOBJ Technical Lead

Environment: SAP BI 7.0, BEx Analyzer, SAP R/3, SD,QM and SCM

Responsibilities:

• As a BW/BI Senior consultant responsible for identifying, planning and executing all activities in support of daily BW/BI operations.
• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe and created BOE reports by accessing real-time information from multiple data sources using data federation.
• Upgrade Coordinator for world-wide upgrade of BW 3.5 to NW 2004s involving two ECC source systems.
• Designed new IP planning functions for sales planning - delete, copy actual, file upload user interface using a web browser, planning application workbooks.
• Involved in the migration Of BW BPS to IP application.
• Developed the Planning Applications for Cost center Planning and Sales planning.
• Designed BEx Broadcaster application for distribution of sales report and tools usage summary report, configured pre - calculated web templates and work books.
• Created reports with Charts (bar chart, Pie chart, etc), Cross-tabs and Sub reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0
• Created crystal reports in combination with SAP BI Queries.
• Enabled dynamic report linking by passing Variables (prompts) between reports.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, and Info View.
• Designed and developed the Universe and updating the existing Universes, developing canned/ad hoc reports,
• Created, organized, publishing and scheduling reports using Center Management Console.
• Participated in design review session’s onsite-offshore delivery model to ensure technical designs.
• Coordinated weekly all - hands meetings, status reports and delegating BW activities to fellow team members.

SAP BI/BOBJ Technical Lead

Confidential

Environment: SAP BI 7.0, BEx Analyzer, SAP R/3, SD, and ABAP

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• Defined work packages and technical specifications for design, development, testing and roll-out.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed are Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
• Worked with functional consultant for mapping the source data (R3/non R3) to target DataSources in BI. Defined the initial sizing requirements based on source data volume estimates.
• The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and Purchasing areas. Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multi providers.
• Designed and developed the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0.
• Expertise in creating, organizing, publishing and scheduling reports using Center Management Console.
• Gathered requirements from functional users in Sales and Purchasing for cross functional analysis.

SAP BI/BOBJ Technical Lead

Confidential, Rochester, NY

Environment: SAP BW 3.5, BEx Analyzer, SAP R/3 FI/CO and SD

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• As a BW/BI Consultant responsible for identifying, planning and executing all activities in support of daily BW/BI operations.
• Analyzed and mapped Business Process to BW and create blueprints using ASAP methodology. SAP BW Modeling/Architecture/Reporting.
• Responsible for develop logical data models, ETL Specifications, Source to staging.
• Responsible for Data conversion from TM1 to SAP BW.
• Configured and customized applications for FI/GL, HCM, COPA, SD and MM modules.
• Functioned as a SAP BW Planning team lead of three consultants.
• Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
• Depending on department and project needs, support functional and technical design efforts, including data flow diagrams and multi-dimensional data models.
• Review design documents to identify improvement opportunities.
• Applied technical skills and functional experience to keep project ahead of schedule, under budget and to the fullest satisfaction of the customer.
• Source system analysis, business content check, generic extractor on custom tables for automatic master data scheduling for employee.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0 and Worked on Xcelsius dashboard with Crystal reports,
• Created Xcelsius dashboards with Crystal reports, Web intelligence and Web services.
• Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration.
• Created reports with Charts (bar chart, Pie chart, etc), Cross-tabs and Sub reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

SAP BW/BOBJ Developer

Confidential

Environment: SAP BW 3.5, BEx Analyzer, SAP R/3, SD and MM, EP

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Initiating extract process in BW at regular intervals of time.
• Loading Data from Flat File (as the Source System.) in to BW.
• Resolving urgent user issues - helpline activities.
• Designed Business objects universe, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view and Business Objects Enterprise, scheduling the processes and administering the BO activities using Business Objects XIR2/ BOXI 3.0 and Worked on Xcelsius dashboard with Crystal reports
• Modifying BW reports as per the need of the user.
• Developed Multi cubes which interacts with basic cubes with identification.
• Developed Update rules to update Info Cube and applied aggregates.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5, SAP R/3, ABAP

Responsibilities:

• Experienced in bringing Master Data and Transactional data from both Flat Files and R/3 to BW.
• Designed and developed Basic InfoCubes to extract data from ODS Objects for BEx reporting.
• Performed data extraction using LO COCKPIT (LBWE)
• Designed Generic data extractors to extract and transform the data to suit the Business Warehouse model.
• Data loading was monitored and the failed data packets are analyzed and manually edited in PSA (mostly for invalid characters) and re-loaded into ODS.
• Maintaining Work History for all the tickets until it is closed down.
• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Monitoring of Info packages and process chains.
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Resolving urgent user issues - helpline activities
• Modifying BW reports as per the need of the user.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Created info sources, info packages and schedulers to extract data from R/3.
• Created transfer rules and update rules for info cubes and custom master objects.
• Experienced in Creating and Customizing Info Cubes, Multi-Cubes, ODS.

SAP BW Developer

Confidential

Environment: SAP BW 3.0, BEx Analyzer, SAP R/3, SD and MM, EP

Responsibilities:

• Gathered business requirements and defined deliverables along with functional analysis and worked with SAP R/3 technical and SMEs in the business areas.
• Implemented Standard Business Content InfoCubes like Line Item (0FIAR C03), Payment History (0FIAR C05), and Cost and Allocation (0CCA 11) and customized those using Update Rules. Created ODS, InfoCubes and MultiProvider for queries.
• Extracted and uploaded data into InfoCubes from DataSources like Cost and Allocation (0C0 OM CCA X), Internal Order (0C0 OM OPA X), Account Receivable (0FIAR AR 4) and Account Payable (0FIAR AP 4) for the FI & CO modules from the Business content.
• Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Worked with functional consultant for mapping the source data (R3/non R3) to target DataSources in BW.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx. Worked with users to understand their reporting needs. Generated Export DataSources to transform data from one InfoCube to other InfoCube.
• Scheduled Daily/Weekly/Monthly data loads.
• Managed and monitored data loads with full upload and delta mechanism.
• Created Infoset for master data to enabling querying on data.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Create and extensively used Info spoke to feed data to data marts.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Monitoring and implementing the solutions to the errors in the Production System.
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and MultiProviders.

Confidential

SAP BW Consultant

Responsibilities:

• Actively Involved in Monitoring and Extraction of the Data from PSA into Data targets.
• As a member in the Support team, involved in completing tickets from client.
• Daily monitoring of Info cubes and ODS objects requests.
• Extracted Data from Shipping LO Extract structures 2LIS 12 VCHDR and 2LIS 12 VCITM. Created Info package for both Initialization and delta and loaded in to 0SD C02 Deliveries and 0SD C04 delivery services.
• Extracted data from Sales Billing Extract Structures 2LIS 13 VDHDR and 2LIS 13 VDITM and created InfoPackages for initialization and Delta to feed 0SD C05 sales Offers/Orders InfoCube
• Monitoring of Info packages and process chains.
• Created info packages by populating info cubes by executing Info packages using both the update methods (Full update method and Initialization of Delta update).
• Developed Customized Info Objects and applied transfer rules and compounding.
• Developed Info Sources which uses flat files from app server and applied constants, subroutines in transfer structures.
• Initiating extract process in BW at regular intervals of time.
• Loading Data from Flat File (as the Source System.) in to BW.
• Developed Multi cubes which interacts with basic cubes with identification.
• Developed Update rules to update Info Cube and applied aggregates.
• Monitoring Data load failures through RSMO t.code, if load fails, we can get details from details tab of Monitor, then solving failures using different t.code like ST22, SM37, SM12 basing on type of error message we got.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5, SAP R/3

Responsibilities:

• Designed custom InfoCubes incorporating hierarchical levels.
• Configured Info Sources and Update rules for data extraction from non-SAP sources using flat files and from R/3 using LO-Cockpit extractors from various data sources. Uploaded master and transactional data from flat files and R/3 Source System.
• Extracting R/3 data for Customers, Sales Order, Delivery, Shipping, Billing Document in Sales and Distribution using LO-Cockpit.
• Extracted data from R/3 using LO execution cock pit and created Info Packages for initialization and Delta to load data in to respective InfoProviders.
• Developed the Technical Designs from Functional Designs.
• Developed the Customization Info Providers for FI-GL Requirement.
• Developed the custom cubes for vendor analysis in SD
• Developed a customized invoice cube linked with modules SD, MM and FI.
• Installed Business Content and loaded the data from ECC system to Info Providers with Success.
• Extracted Data from Shipping LO Extract structures 2LIS 12 VCHDR and 2LIS 12 VCITM. Created Info package for both Initialization and delta and loaded in to 0SD C02 Deliveries and 0SD C04 delivery services.
• Extracted data from Sales Billing Extract Structures 2LIS 13 VDHDR and 2LIS 13 VDITM and created InfoPackages for initialization and Delta to feed 0SD C05 sales Offers/Orders InfoCube
• Extracted 2LIS 02 S011 (Purchasing Groups), 2LIS 02 S013 (Vendor Evaluation) DataSource for purchasing activities of a single purchasing group and vendor evaluation consistently to a BW system.
• Install and Transportation of Business Content Info Cubes, Info Sources from R/3 and BI Side.
• Involved in mapping of Data source to info source using Transformations in SAP BI
• Loaded Data into the ODS Object before transporting the data into the IC.
• Examining performance-critical business processes of BW, R/3 and Workload analysis (ST03) and analyzing the database growth (DB02) and Extensive SQL (ST04) database performance analysis like using RSRV transactions.
• Development of specific Queries based on user requirements as well as utilization of Business content related queries and work Book.
• Involved with performance tuning of Queries by maintaining Aggregates.

Confidential

System Administrator

Responsibilities:

• Windows NT / 2000 & 2003, UNIX / Linux Server Installation, Desktop Administration, Configuring. Trouble shooting Windows / Linux Networking services.
• Day-to-Day maintenance and support activities of AS/400 Server.
• Maintenance of Desktops, Network Printers, Backups, Internet connectivity, Remote office connectivity, e-mailing, Dialup, Switches & Hubs
• Creating users, groups and managing the user privileges networking.
• Oracle 8i / 9i & SQL 2000 Server installation and configure the clients
• Database recovered up to the crash point after media failure.
• Configuring and maintain Active Directory Services on windows 2000 user management on windows 2000 server domain controller.

Confidential

Software Engineer

Responsibilities:

• Provided stock brokerages service for Confidential ’s Bank USA. The main objective is to provide the real time stock quotes and trading services through speech, WAP and SMS.
• Modules developed in this project are:
• Trigger setting for notification.
• Generating notification and notification is sent through the alert mechanism like SMS, Pager and Email.
• Place orders (to buy and sell)
• Check status of funds and shares held in portfolio