SUMMARY:

• 9+ years of total professional experience, including 8+ years of SAP BI/BW.
• Expert in working with various versions of SAP and BW, the latest being ECC 6.0 and BI 7.0 respectively. The various modules include SD (Order To Cash), MM (Procure to Pay), PP, FI/CO, SEM .
• Worked with BO WEBi and Xcelsius.
• Knowledge of SRM extraction.
• Involved in 1 full lifecycles of BI/BW implementations and involved in all levels of BI/BW implementation such as Data Modeling, Extraction and Reporting.
• Extensive experience in batch scheduling with Autosys.
• Worked extensively with SAP BI/BW Modeling components like Infocubes, DSO, Info Objects, PSA, Data source, Info source, and Transformation rules.
• Comprehensive knowledge of Data Warehousing Workbench. Expertise in BI Content services consisting of Business rules, Metadata, Reference data, Extractor programs for SAP systems, Process chains, Roles and other data objects.
• Proficient in SAP and Non-SAP data extractions including BI/BW Content extraction, Data source enhancements for generic data extractions, logistics cockpit configuration and customization, CO-PA , user exits, customized delta built up for the data sources and master data extraction from SAP and flat files.
• Expert in working with loading, scheduling, monitoring.
• Good Command on Hierarchies, BI Authorizations, BI Statistics, Archiving, Process chains, Event chains and Open hub.
• Expert in Report Generation. Worked extensively in BEx Analyzer in building Queries and saving in Workbooks and created custom Queries using Conditions, Exceptions, Filters, Calculated Key figures, Variables & Structures and created aggregates for frequently used queries and RRI Jump queries, also worked with Web Application Designer and trained end users.
• Worked with BEx Web, BEx Query designer, BEx Analyzer and BEx Broadcaster.
• Worked with BI Accelerator to improve the read performance of BI Queries on Infocubes.
• Worked on various data sources of APO to extract the data from LCA to BW.
• Complete understanding of ASAP implementation methodology and good understanding of the full lifecycle of the implementation, right from the feasibility study to go-live to support activity & post go live maintenance.
• Knowledge of Data Warehousing and Business Intelligence concepts, design principles and software architecture.
• Extensive knowledge on Table Controls, Data Dictionary, BDC, BADIs, Reports, Transactions, Function Modules and SAP scripts in ABAP/4 programming language.
• Self-motivated, excellent communication skills, and good team player.
• Handled multiple projects paying attention to details, Good problem solving skill along with leadership and analytical skills.

TECHNICAL SKILLS:

Methodologies:

ASAP, RUN SAP

DataWarehousing:

SAP BI ver 7.0, SAP BW 3.5

Modules:

MM, PP, SD, FI/CO, PS , BPS, BCS

Languages:

ABAP, HTML.

Source Systems:

R/3 4.7, ECC 6.0, Flat file.

Tools:

WAD, BEx query designer, BEx-Analyzer and Bex Browser, SAP solution Manager, Bex Broadcaster, BO

Database:

Oracle 8/8i,10i/9i

PlatForm:

SAP Netweaver

WORK EXPERIENCE:

Confidential,OH. August 2012 – Current
BW Team Lead

Owens Corning is a leading global Producer of residential and commercial building materials, glass fiber reinforcements and engineered materials for composite systems. A Fortune 500 Company for 57 consecutive years.

Responsibilities:

• Prepared Project Plan, Architecture and Design for PO Sourcing Application.
• Lead an off-shore team of Four BW Developers.
• Involved in the meeting of KPI determination.
• Prepared various documents like InfoObject Mappings, Design Documents of InfoProviders and for the DataSource enhancements.
• Prepared Plan for Cutover.
• Prepared and maintained cook book to track the Transport Request for ECC as well as BW.
• Involved in Post Go-live activities like stabilization and hand over to Support.

Confidential,AZ March 2012 – August 2012
SAP BW Consultant

Confidential,is one of the largest distributors of electronic components, including connectors and semiconductors; technology solutions, computer products and embedded technology

Responsibilities:

• Enhancement of Logistics datasources and infoproviders which includes Sales order Item and Billing item.
• Upon enhancement of datasources changes in respective Transformations/Routines as well as Infoproviders.
• Modification of Sales Order Booking and Backlog programs associated with generic datasource.
• Extensively worked within MDF area of CRM.
• Enhancement of CRM datasources like Opportunity Item.
• Changing existing BEx queries and creating the workbooks.
• Created Dashboard for Opportunity Analysis and published on Enterprise Portal.
• Created BICS connections used them to Create WEBI as well as Crystal reports.
• Resolution of Data load Errors.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, BO, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,OR. October 2011 – February 2012

Confidential,together with its subsidiaries, designs, manufactures, and markets equipment, replacement and component parts, and accessories to forestry, lawn and garden, farm, ranch, agriculture, and construction sectors in the United States and internationally.

SAP BODS Consultant

• Conducted meetings to analyze the data from various legacy systems for the purpose of migrating the same to SAP
• Designed and Developed multiple jobs, workflows based on migration strategy,

Data mapping and the frequency to accomplish legacy data migration to SAP and
Automate the whole process.

• Good expertise in BODS Toolset such as Designer ,Management Console, Repository Manager ,Server Manager
• Strong experience in Design and development of BODS components such as Projects, Jobs, Workflows, Dataflows, Datastores, Transformations.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, BO, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,MI May 2011 – October 2011
SAP BI Developer.

Confidential,is an American multinational manufacturer of major home appliances headquartered in Michigan. The company is listed in Fortune 500 and has more than 70,000 employees, and more than 70 manufacturing and technology research centers around the world.

Responsibilities:

• To analyze the SAP- BI production issues and resolves them according to priority within SLA.
• Involved in end-user (of Corporate Finance) discussion in order to understand the issues.
• Fixed the warranty mix issue, which was not resolved since last 6 months.
• Extensively involved in debugging of routines.
• Modifying the existing BEx queries according to client requirements.
• Involved in unit testing, integration testing and UAT testing.
• Experience with BO Universe.
• Experienced in WebI and Xcelsius.
• Modified the Logic of Currency Effect.
• Involved in implementation of SAP notes while implementation of IFRS.
• Fixed an ABAP report of SCM which had dynamic internal tables.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, BO, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,OR August 2010 – May 2011
SAP BSA Lead

Confidential,has established strong brand portfolio with several wholly owned subsidiaries including Cole Haan, Converse, Nike Golf, and UMBRO Ltd. Nike operate in 160 countries and employee near 1 million people.

Responsibilities:

• To provide production support approvals for various cross functional activities.
• To analyze the SAP- BW production issues and resolves them according to priority within SLA.
• Responsible to govern various Nike specific processes like Freeze Calendar Update and DQI check.
• On-call support for batch delays.
• Extensively involved in authorized futures restatement which was customized BW-process of Nike.
• Modifying the existing BEx queries according to client requirements.
• Involved in unit testing, integration testing and UAT testing during SAP R/3 upgrade.
• Conducted End user training.
• Experience in ticketing tools like Relay and Clarify.
• Extraction and reporting of AFS – Sales data to SAP BW.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, BO, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,NC October 2008 – August 2010
SAP BI Consultant

Confidential,is a leading provider of advanced metering infrastructure (AMI) solutions that help utility companies improve revenue cycle services, customer service, delivery reliability, and workforce utilization. With more than 100 years of electricity metering experience (formerly as Westinghouse Electric Corporation and ABB Electricity Metering), Elster Electricity understands the unique requirements of utility customers worldwide and is part of the world\'s largest multi-utility metering company combining the leaders in electricity, water and gas metering.

Responsibilities:

• Requirement gathering for various multi dimensional queries and reports.
• Customized CO-PA to include style-numbers.
• Enhanced sales data source to upload the sales order item data along with style numbers.
• Scheduled batch data load coming from various soruce system.
• Triggered daily, weekly and monthly load (process chains) through Autosys.
• Modified FI Business content Base cube, virtual cube and function module according to client’s requirement.
• Installed Business Content for MM, QM and PP Modules.
• Created Process chains for Master and Transaction data load.
• Created Bex Queries for Warranty Report, Inventory Aging, sales representative efficiency, Vendor Delivery efficiency.
• Used various Data Integrator transforms like Date Generation, Hierarchy Flattening, and Pivot.
• Used Data Transfer Transform to improve performance in BODI.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, BO, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,NY September 2007 – September 2008

SAP BI Analyst Confidential,backed by a global network spanning over 75 countries; it is a leading provider of financial services to agencies, corporations, governments, private individuals and institutions in the Americas. This project was the US rollout for GGLCAR. It was implemented by using German system as a template. Customization was reduced in this rollout project.

Responsibilities:

• Participated in the end user discussions to get a thorough understanding of the front end reporting requirements.
• Involved in scrum meeting in order to resolve the Production issues.
• Played a Vital role in finalization of SLA.
• Created Various reports for SEM- BPS and SEM-BCS from virtual cubes.
• Worked with the BI Accelerator to improve the read performance of BEx queries on Infocubes.
• Extensively Involved in implementation of GAAP- Switch Process for NY branch.
• Extensively Involved in Standardization of ETL process of NY Branch.
• Developed different queries based on calendar day week, month and year in order to obtain any combination of reports from the info cubes.
• Used Information Broadcaster to precalculate and distribute reports to end users and also used to distribute templates created with WAD to end users.
• Provided end user support for system and process issues as they arise in the course of day-to-day business.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,Hesse (Germany) July 2006 – September 2007
SAP BI Developer

Confidential,Analysis, and Reporting is the system which is used to consolidate the data of US region and to report the Head Quarter in Germany.

Responsibilities:

• Participated in the end user discussions to get a thorough understanding of the front end reporting requirements.
• Gathered data from the functional specs to implement custom made InfoCubes to cater their requirements.
• Created Info Objects, Infocubes, Data Store Objects, DataSources and transferred data from Data sources to Data Providers by Data Transfer Process to load transaction data into Info Cubes using Transformation rules.
• Created Interactive Bex-Query for SEM-BPS
• Create Bex queries for Planned (BPS) Vs. actual Consolidation (BCS).
• Setup the Process chains for data flow control.
• Created Aggregates and Multi Cubes for performance and efficient utilization of data.
• Repartitioned Info providers for Performance optimization.
• Performed Delta Upload Management with OLTP extraction.
• Troubleshot problems and determine solutions. Implement fixes and small enhancements. Answers SAP BW questions forwarded by users.
• Monitored and optimized performance of information queries and reports.

Environment:
SAP BI Netweaver2004s, SAP ECC6.0, ABAP/4, SAP BEx Web, BEx Analyzer, BEx Query designer, BEx Broadcaster, OLTP, Oracle 10i/9i,Windows 2003.

Confidential,DE November 2004 - July 2006 SAP BW Consultant

Confidential, is a world-leading agribusiness committed to sustainable agriculture through innovative research and technology. The company is a leader in crop protection, and ranks third in the high-value commercial seeds market.
The agricultural market is highly seasonal and competitive with the potential for large changes in market demand. Syngenta built a consensus and collaborative sales and operations planning (S&OP) process to meet the needs of their business units, which not only spanned different products and regions, but foreign subsidiaries as well.

Responsibilities:

• Extensively involved in setting up of procedures for extracting data from SAP R/3 using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• ing LO Cockpit (LBWE). Scheduled and Implemented delta mechanism for periodic loads.
• Analyzed the info cubes and maintained the aggregates to improve the reporting performance for BEx reporting.
• Built formula variables and also processing variables using replacement path and customers exit.
• Created numerous BEx Reports and Info Set Queries on the developed Info Cubes, ODS Objects.
• Created, Scheduled and monitored Info Packages and creating process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, master data and ODS data activation.
• Improved and optimized query performance by Info cube maintenance involving aggregate, rollups, Compression/collapse, partitioning the info cubes.
• Checked the inconsistencies and repaired using the Transaction code RSRV & also monitored the Query performance by using Transaction code RSRT.
• Scheduled timely deletion of data from PSA to improve the performance.

Environment:
SAP BW 3.5, R/3 4.7C, SD, BEx, WAD, Windows 2003.

Confidential,CT July 2003 – November 2004 SAP BW Consultant

Confidential,Find opportunities to innovate in your industry and create a success story for your business. As the global leader in paper, packaging and wood products, International Paper can partner with you to create solutions in any industry, anywhere we\'re needed.
SAP-BW was implemented to access the data uniformly having tight coupling with R/3. System was leveraged for future DSS development.

Responsibilities:

• Responsible for data modeling of the Sales and Distribution Module, and Master data (Customer and Material Master), for the SAP Business Information Warehouse (BW)
  Participated in the end user discussions to get a through understanding of the front end reporting requirements.
• Gathered data by consulting with the functional specs and decided to implement custom made InfoCubes to cater their requirements.
• Worked extensively with Administrative Work Bench (AWB).
• Customized the InfoCubes (Basic Cube, MultiCube), Info Source and InfoObjects.
• Sound knowledge in extending the Business Content based on requirements
  Implemented data extraction and data staging using both LO Cockpit and enhanced the structures using user exits to support the business needs.
• Tailored transfer structures, communication structures and update rules based on the requirements and scheduled the Info-packages for data loads.

Environment:
SAP BW 3.5, SAP R/3 4.6c, FI/CO, SD, MM, PP, SAP BEx Analyzer and Explorer, BEx Browser, OLTP, FI, CO, SD, Oracle 10i/9i, Windows 2000.

Confidential,CA June 2002 – June 2003
SAP BW Consultant

Confidential,through its Siliconix subsidiary, leads the industry in the development of power semiconductor products that improve the efficiency of power management circuitry in end products while reducing space requirements.

Responsibilities:

• Involved in the star schema design with multiple dimensions and fact tables.
• Involved with the BASIS team in setting up connectivity between SAP BW and R/3 systems for data extraction.
• Monthly & Weekly extractions are scheduled using Info Packages on Sunday nights & End of month by using after jobs & after events.
• Set up transfer rules, wrote transfer routines, wrote update start routines, and updated routines.
• Set up statistics/aggregates rebuild and event-chains to notify end-user of report availability.
• Created ODS structures, Info-Cubes, custom Queries, etc.
• Take the requirements from Finance, Procurements Process Owners and fine tune with End Users.
• Involved in creation of Data Sources, Info Sources, & PSA for Data extraction, transformation and loading from SAP R/3 system to SAP BW.
• Installed and activated necessary Business Content.

Environment:
SAP R/3 4.6C, SAP BW 3.0B, BEx Analyzer/Browser, MM, SD.

EDUCATION: Bachelors in Science Advance Diploma in Software Engineering