PROFESSIONAL SUMMARY:

• Over 7 years IT experience as SAP BI/BW consultant within the SAP based moderate to complex data warehouse solutions for multiple industries with back end and front end techno functional experience including Healthcare, Banking & Financials, Manufacturing, telecommunications sectors.
• Proficiency of SAP BW/BI components and ETL process like creating Info Object, Info Cubes, Info Sets, Multiproviders, ODS(DSO), Update rules, routines, Transfer rules, Transformations, creation and scheduling of Process Chains for automation process with star schema and extended star schema modeling techniques for BI/BW implementation.
• Extensive experience in analyzing the requirements, streamlining the dataflow from various source systems to BW thereby identify suitable business content for MDM- install and activate relevant objects.
• Experience in extracting data from SAP R/3 (SD, MM, PP, FICO, HR) new dimension products like CRM, SCM, SEM, & BW using different data extraction structures such as LIS, LO Cockpit, CO-PA, EC-CS.
• Strong work experience on setting up the procedure for extractors, load monitoring, data refreshes on cubes and ODSs as required.
• Posses knowledge on extracting data from flat files, Non SAP systems, and Generic data sources and loaded into BI system.
• Hands on experience on extractions: CO-PA, LO, FI, CRM, Master data extraction, Generic Extraction, Delta management, Business Content- installation & enhancement using DB connect.
• Good knowledge on customizing existing data model to reinitialize Data Sources from SAP R/3 and standard extractors by adding new Characteristics, Key figures, info cubes, DSO in-order to meet end user reporting requirements.
• Experience in creating ODS objects for data staging, info packages, Generic data sources on R/3 tables by building views on these tables.
• Extensive work experience on BI/BW business content based on client requirements using UserExits.
• Hands-on experience on BW reporting objects such as queries, workbooks, web templates, calculated key figures, restricted key figures, structures, and variables.
• Extensively worked on performance tuning concepts like create Aggregates on Info Cubes, Indexing, Rollups, Compression, Partitioning, Line item dimensions etc.
• Expertise in debugging data load errors, Extractor Checker, Delta Queue monitoring, used DTP for Transformations.
• Good understanding of SAP Enterprise Portal, ASAP implementation methodology.
• Expertise in BEx components- Query Designer, Web Application Designer, Broadcaster, Analyzer and Crystal Xcelcius and Business Object Live Office to provide flexible reporting and analysis functions.
• Experience in ABAP start routines, scheduling data loads- Full/delta upload with various data targets(ODS/ Info Cube),
• Hands on experience in Production support- strong experience in monitoring the data loads, fixing any data load errors, Handling change requests and support requests, working with ticketing tool like Remedy, Magic etc.
• Thorough knowledge of master data processes, data standards and how they relate to the business, particularly in the areas of materials, sales, vendors and finance.
• Experience in up gradation from BW 3.5 to BI 7.0 encompassing several projects.
• Adept in the integration of SAP within a business and in the integration of the SAP modules with each other.
• Experience in all phases of project realization and serve as the team/project lead for BI/BW projects.
• Excellent communication skills with the ability to articulate highly technical content in simple terms to the business users.
• Ability to think proactively with collaborative working style.

TECHNICAL SKILLS:

SAP BW- 3.5/3.1C/3.0B; SAP BI 7.0

ERP:

SAP R/3 4.7E/4.6C/4.6B/4.0B; SAP ECC 6.0, 5.0.

Language/OS:

ABAP/4, SQL, PL/SQL, Solaris, XML, UNIX shell scripting, C, C++, HTML, JAVA.

Databases:

Oracle, MS Access, SQL server

Reporting :

BEx , ABAP reports, Crystal reports, Business Objects, iviews

Modeling:

ERWIN, Oracle Designer, ER/Studio

Project Tools:

MS Projects, Visio, Web-Ex, Go2Meeting, Citrix.

PROFESSIONAL EXPERIENCE:

Client: Confidential,Chicago, IL. Oct 10 - till date
Confidential,is the nation’s largest publicly held personal lines insurer. Allstate benefits provide the right voluntary insurance products- health, life, disability, vision and dental- that can be customized with various levels of coverage.
Role: SAP BI Consultant.
Responsibilities:

• Coordinated with project teams to define data analysis requirements for projects, identified relevant data tables, extracted data from SAP systems for data analysis.
• Worked closely with the corporate consultants in providing Functional specifications to enhance the current model and develop new ODS and Info Cubes. Defines custom cubes and Multiproviders for the business scenarios along with aggregates. Defined guidelines to Basis team for Aggregates and data loading.
• Designed Info Sources, activated transfer and update rules, scripted extraction routines for master data Texts and Hierarchies.
• 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).
• Maintained Data Sources such as billing (2LIS_13_VDHDR), Sales Order (2LIS_11_VAHDR) and Delivery Order (2LIS_12_VCHDR) for the SD module and Purchasing Order Item (2LIS_02_ITM) for MM.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• Worked extensively on the Open Hub Service, created Info Spokes to distribute the data to other EDW systems.
• Created Info Packages to do Full, Initial and Delta extraction for both Master and Transaction data with dynamic selection criteria as per the requirement.
• Used Process Chains to schedule the Info Packages and data transfer processes.
• Worked with users for defining reporting needs and pre-calculated reports.
• Used BEx and Web Application Designer, Web templates extensively for publishing, broadcasting of web reports.
• Handled Performance tuning at data loading, reporting before Go-Live, post- production support.

Environment: SAP BI 7.0, ECC 6.0, ECC 5.0, Enterprise Portal (reports), Integrated Planning, and BEx.

Client: Confidential,Wilton, CT. Jun 09- Sep 10
Confidential, is one of the largest American-based company in insurance business.AIG implemented SAP ECC and SAP Business Information Warehouse (SAP BW) to support financial reporting solutions.
Role: BI & BW Consultant.
Responsibilities:

• Analyzed, designed and configured delivered, generic and custom BW data sources. Resolved issues of BW data extraction, data loading and reporting when integrating new development into a production environment.
• Designed and developed BW reporting architecture for an organization on an enterprise level, creation of functional requirements documents, design documents, tech and functional specs, pseudo code for ABAP development, test scripts and interfacing requirements with business users as required.
• In charge of Support & Maintenance of BI systems. Responsible for international technical architecture developments.
• Meet project deadlines, accept responsibilities, report progress and ensure that all project goals are accomplished according to specifications and reporting requirements. Effectively prioritized and managed multiple projects assigned. Determined time estimates and schedules, resolve issues in a timely manner.
• Implemented the action items to resolve the issues. Provided input and recommendations on design to senior management.
• Maintained and monitor process chains. Migration of data sources from BW 3.5 to BI 7, WAD, roles, exit variables, user exits in BW and ECC.
• Developed custom info objects, Info Providers, transformations etc in BI 7.0 based on technical designs.
• Developed and maintained BPS layouts as needed for R& D application, implemented SAP OSS notes to improve any BW extractor load performances.
• Managed BI upgrade project, SAP GUI upgrade project and SAP user name Recodification project; Transported management, user access management, role assignment for NA users.
• Developed detailed documentation for BW architecture designs and support procedures, issue and resolution logs in ISEdoc and Eroom internet document storage.
• Conducted class room and on-line training sessions to Super users (30) effectively provided knowledge transfer (KT) to required staff.

Environment: BI 7.0, BW 3.5, ECC 6.0, FI/CO, HR, SD, MM, SCM, CRM, R&D.

Client: Confidential,, Murrysville, PA. Sep 08 - May 09
With focus on health and well-being Philips serves professional and consumer markets through Health Care sector where customer insights are translated into meaningful technology and applications that improve the quality of people’s lives.
Role: SAP BI Lead Architect.
Responsibilities:

• Worked with Philips business executives to understand flow of information as per their daily and periodically reporting need that includes documenting Functional requirements, Fit Gap Analysis as per functionally provided enhancements, approvals and data flow diagrams.
• Worked on multiple SAP BI projects including Fiscal year changes, Product Hierarchies, COA & GL changes, BI 3.x to BI 7.0 upgrade and CO-PA changes. Landscape strategy for SAP BI upgrades rollout.
• Associated with stakeholders and executives to get detailed business requirements on SAP sub-modules FI (GL, Customers/ Vendors Analysis, Customer Invoice Aging), SD (Sales Orders) and MM (Materials, Purchase Orders).
• Involved in Design, Gap, Build, Test (Unit, Regression and UAT), Documentation and Go- Live activities.
• Led Fiscal Year changes efforts to bring Respironics on Philips Calendar reporting. Directly worked with Philips PMO on setting best practice for ongoing SAP Net weaver (BI, Portals, CPM) implementations.
• Responsible for requirements, Scope and activity definition, Sequencing, WBS, schedule planning, Risk Assessment & mitigation plans, upgrade approach etc.
• Managed and monitored 7.0 Upgrade project plan that covers Checklist, Upgrade strategy, resources usage, Authorization and security.
• Designed and developed BO Universes on top of SAP BW queries, Web rolled this functionality in management dashboards.
• Worked with SAP/BO Basis, systems, DBA, IT teams for BO roll out and also with User community, Basis and security teams.
• Helped customer understanding the BPC(M) product (MS SQL server based) concepts and functionality on P & L, Planning(sales Forecasting) & consolidations and inter-comp eliminations
• Designed and executed user training (documentation & in person) sessions with power users, end users and IT team.
• Conducted SAP BPC(Outlook) feasibility analysis and product review workshop with key stake holders and business champions on SAP BPC 5.1.
• Leading, managing and mentoring SAP BI-FI Integration efforts as per corporate guidelines and requirements.

Environment: SAP ECC 6.0, BI 7.0, BO XI 3.1, BPC 5.1, Quality Center, Oracle 10g, HP-Unix Solution Manager 4.1.

Client: Confidential,Alpharetta, GA. Oct 07 - Aug 08
Confidential, is a global program for harmonizing processes throughout the enterprise on the basis of SAP ERP standard software. The global solution runs on SAP R/3 4.6C/ECC 6.0 and uses SAP BI as the basis for management Information System. Rollout for Europe and Asia Pacific, expertise in the business consolidation add-on tools. This project also involved BW up gradation to BI-7.
Role: SAP BW consultant/ Analyst.
Responsibilities:

• Led the planning, requirements and design phases for a new BW data warehouse to centralize planning, distribution and procurement functions within a productive R/3 system.
• Created, activated and worked on Info objects, ODS, ODS structures, Info Cubes, extractors, Generic extractors, Logistics Cockpit, Info Sources, R/3 data sources and non R/3 data sources, Transfer Rules, Update Rules, Info packages, Info package groups.
• Involved in all phases of ASAP methodologies, analysis of data requirements and translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques.
• Worked on Queries, Variables, Calculated Key Figures, Workbooks, Analyzer, Browser, 3rd party reporting tools, Roles etc.
• Involved in the scheduling and monitoring of reports In Information Warehouse using SAP BW Administrator Workbench.
• Performed data loading using SAP supplied Extractors and flat files.
• Prepared up gradation and migration plan for the BW system.
• Prepared the post-upgrade action plan for BW custom and standard objects optimization.
• Remodeled the process chains for data load optimization.
• Involved in Performance tuning of Queries by maintaining Aggregates, Compression, Indexing of Info Cubes, usage of statistics.
• Used ABAP/4 Routines for data manipulation in transfer/update rules.
• Generated reports like Plan/Actual comparison, Open Sales Orders and Incoming Sales orders using Sales Planning.
• Associated with corporate SAP BW technical consultants in providing technical specifications to enhance the current objects and developed new ODS and Info Cubes (FI/CO, SD) for data warehousing.
• Created documentation and implemented necessary authorizations and securities for the end user reports.
• Supported user inquiries on SAP BW BEx Analyzer, BEx Browser and web reports for business intelligence.
• Coordinated with the team in providing effective solutions for their customers using BW tools.

Environment: SAP ECC 6.0, BW 3.5, BI 7.0, ABAP, SD, FI/CO, BW BEx suite.

Company: Confidential,India Jun 05 - Sep 07
Confidential,is engaged in providing software products and solutions mainly for the banking and manufacturing sectors. It provides custom-specific, tailor-made solutions in the areas of client server application, development and web-enabled solutions like supply chain management and distribution management.
Role: SAP BW Consultant
Responsibilities:

• Created custom Info Sources & Info Objects in BW and mapped them with R/3 fields using transfer rules and Generic extractors.
• Extracted data from SD, MM and FI module and uploaded into procurement cubes 0PUR_C01, 0PUR_C02, 0PUR_C03, 0PUR_C04, 0PUR_C05.
• Involved in complete logistics – Inventory Management and controlling activities which used 0IC_C03 cube and extractors like 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM.
• Enhancement of extractors to calculate Moving Average Price and FOB amount for In-Transit quantity cube.
• Created Process Chains to automate the transaction and master data loading from CRM server.
• Actively interacted with users in fulfilling their requirements on time and quality.
• Carried challenging tasks like triplication of quantities with marker set in compression of requests.
• Designed and optimized the queries and created reports using BEx Analyzer and Browser.
• Worked extensively with BEx Analyzer and Query Designer , developed several queries of multiple complexities, incorporated functionalities such as Navigation attributes, Hierarchies, Restricted Key Figures, Calculated Key Figures, Filters, Variables, Conditions etc and organized them into various workbooks with required authorizations.
• Transported modified/new objects from development system to consolidation system using BW transport mechanism.
• Implemented performance enhancement features such as indexing, maintaining aggregates and compression.

Environment: SAP ECC 5.0(SCM, Financials, HR-HCM), MDM, BW BEx, Oracle 9i.

Company: Confidential,Mumbai, India. Aug 04 - May 05
Customer: BSNL, India.
Confidential, is World\'s 7th largest Telecommunications Company providing comprehensive range of telecom services. The company has vast experience in Planning, Installation, network integration and Maintenance of Switching & Transmission Networks.
Role: SAP BW Consultant.
Responsibilities:

• Designed ETL documents for extractor procedures.
• Designed the data models by using performance indicators and Business Objects and by performing GAP analysis on the extractors available from the source system.
• Uploaded master and transactional data from flat files , SAP BI and SAP R/3.
• Extracted master and transaction data using Generic data sources from OLTP.
• Responsible for info Package Group Management and Triggering of Event Chains.
• Involved in Generic, LIS, LO and CO-PA extractors.
• Involved in Info Cube maintenance, debugging the Update rules and Transfer rules.
• Loaded data into the ODS object before transporting the data into the Info Cube.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global views.
• Load monitoring and validating data consistency in reporting with data target against PSA after loading them to data targets.
• Mapping of info source with data targets using update rules.
• Involved in setting up the statistical setup for the LO-Cockpit and used the V3 update for Delta management.

Environment: SAP R/3 4.7-4.6C, SAP BW 3.0B, SCM (SD, MM, PP, QM), Oracle 8i.

Education: Bachelor’s in electronics and communications