HIGHLIGHTS
A highly analytical and productive professional with over 8 years of experience in IT. Over 5 years of experience in SAP BW/BI, more than 3 years in ABAP. Excellent in developing an engagement plan that identifies the gaps between the baseline and the target goals, and taking specific action required to achieve the project objectives. Involved in migration process from BW 3.5 to BI 7.0

Technical Strengths.

Business Areas: MM, SD, FICO, HR, SRM, PP and ASAP/Solution Manager Methodology.
Extraction: Extraction of data from MM, SD, FI/CO, HR, SCM, LO Cockpit, Generic data sources and Flat File data loading (Full/Initialization/delta upload).
Modeling: Extended Star Schema models, Entity Relation ship modeling (ERM) and Multidimensional Modeling (MDM), Universes.
Gap Analysis: For business to find the requirements and suggest for the best possible solution for the Enterprise.
Business Content: Analyzing, installing and using business content objects based on the project requirements.
Process chain: Event management for Automation process.
Performance tuning: Well versed with Partitioning, Setup Statistics and activation, Index Creation, Cube Compression, Reconstruction, and Creating Aggregates. Resolved performance issues with the help of BW Statistics cubes and queries.
Reporting: Expertise in front-end Business Warehouse Components like Queries, Workbook, Calculated key figures, Restricted key figures, Variables, Exceptions, Conditions, RRI and Jump queries, Web intelligence, Xcelsius, Crystal report.
BEx: Extensive experience in BEx Analyzer, BEx Query Designer, BEx Browser and BEx Web Application Designer (WAD) in building Queries.
Web Reporting: Developed web reports, web items, customized web templates using web application designer.
Customization: Hands on experience in design and development of Info objects, ODS, Info Cubes, Multi Providers, DSO, DTP, Transformation, Info Sources, Info Package, Transfer/Update rules, Communication Structure, Hierarchies and Business Contents.
ABAP: User exits, Routines.
Theoretical knowledge: IP and MDM.
DB: Extensively used MS Excel skills including PIVOT tables and VLOOKUPs.

Education:

Masters in Computer Information Systems

Professional Experience:

Confidential,Greenwich, CT June 08 Present

Environment: SAP BI 7.0, ECC 6.0, Oracle, HR/FICO/MM/SD/P2P, e- sourcing 6.0, PS modules

Role: Responsible for develop and implement SAP BI Project.

Sr. SAP BI Analyst/Architect

Responsibilities:

• Interact with business representatives to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BI Reporting and applications
• Work directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions.
• Understand SAP standard content to satisfy Business requirements, but also possess the capability to enhance/customize where necessary.
• Responsible for designing, coding, configuring and testing SAP cubes, reports and dashboard solutions to support the user requirements.
• Responsible for the design and development of the data acquisition process, data mapping, SAP extractors, DSO, InfoCubes, InfoObjects, etc. in an SAP BI Netweaver 7.0 environment and will estimate, schedule, design and execute the various reporting projects.
  
• Perform requirements gathering, analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Involved in checking BW authorization objects for granting access to InfoProviders for reporting.
• Involved in security analysis by checking profiles for end users and reporting users.
• Design complex, custom BI solutions or component objects translating complex requirements into an optimal BI design.
• Competent in BW authorization in roles, and authorization-relevant characteristics.
• Improved error handling and integration troubleshooting via synchronous interfaces
• Develop and drive the implementation of BI best practices and standards for the team.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Prepare project related documentation (object designs, business rules, technical information etc) during the different stages of the project.
• Developed Pending Order Status Report to display pending Purchase Orders (PO) with drilldowns for material and vendor
• Customized cubes such as Sales Order(0SD_C03), Sales Delivery (0SD_C05)and Sales Over view(0SD_C03)
• Created Custom Multi Cube to support FIAR Users, which is a two-cube structure joining one custom FI (company info) Cube with one Business Content AR Cube, allowing users to drill down the customer details and ledger accounts
• Create data models and data flows (extended star schema, ODS, data marts & external data).
• Involved in providing Authorizations by creating Roles and Profiles.
• Highly motivated team player with Strong organizational, Presentation and Analytical skills.
• Extensively used MS Excel skills including PIVOT tables and VLOOKUPs.
• Supports the design and delivery of KPI (Key Performance Indicator) reports, management dashboards, and visual analytics for distribution to analysts as well as executive management.

Confidential, White Plains, NY. Nov 06 April 08

Environment: SAP 3.5, BI 7.0, HR/FI/CO, SD, MM, Oracle 9.2, and ECC 5.0.

Role: Responsible for design, develop, implement and manage SAP-BW projects from ground-up for this full life cycle. Did the upgrading, development, implementation, go live project support, maintenance, enhancement and trouble shooting of BI implementation
Sr. SAP BW Consultant.

Responsibilities:

• Involved in complete Product Development of SAP 3.5 and (SAP Netweaver 2004S)
• Involved in upgradation from BW 3.5 to BI 7.0.
• Performed migration of emulated data source.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Used Write-Optimized DSO (DataStore Object) to load data into BI system.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used the lock concept to lock tables, characteristics and manage these locks.
• Developed backend work by creating InfoCubes, DSO, InfoObjects as InfoProviders, InfoSets, Open Hub destination, Multiproviders and Process Chains.
• Created complex Start routine in Transformations of DSO and mapped with 3 tables in Data Dictionary and populated data dynamically into the data target.
• Created Hierarchies for all Master Data InfoObjects.
• Developed IMG activities in BI to point the Maintenance Views of tables further created tables and views based on the requirement.
• Created Generic Extractors using Views and Function Modules.
• Created Info Cube for Inventory Management using business content data sources in BW Eq. For Stock balance used 2LIS_03_BX, Movement 2LIS_03_BF, and for Revaluation purpose used 2LIS_03_UM data sources
• Enhanced Master Data sources for 0MATERIAL and 0CUSTOMER
• Used transfer routines for key figure calculations, update routines in the update rules.
• Actively involved in the Front end development using WAD (2004s), BEx Analyzer.
• Developed Workbooks and Web Templates for Web Application Designer (WAD) and posted them in portals as Iview.
• Created Exceptions and send alerts to the users in the format of Email using Broadcasting. Configured Reporting Agent to mail precalculated reports to a variety of targets.
• Created Calculated KF and Formulas to report on Multiproviders.
• Involved in Performance tuning of queries and fixed them by creating aggregates and checking the performance in the query trace.
• Performed BW security and authorizations and created reporting roles and maintained security at InfoObject levels for different dealers.
• Involved in creation of User Exists, Variables, Exceptions and conditions in Reports.
• Designed Technical Specs for back end and Front end development.
• Creation of Data Sources, data extraction and retractions.
• Extensively worked on COPA extractions and retractions.
• Enhanced datasources on r/3 side.
• Worked on Profitability Analysis reports, etc.
• Used generic extractors in BW for datasources from other than R/3.
• Deletion of PSA data and Compression of data content in the InfoCube. Monitored the data loading.
• Providing 24/7-On call support.

Confidential,Boston, MA. July 05 Nov 06

Environment: SAP BW 3.5, SAP ECC 5.0, FI/CO, SD, MM, PP, Oracle 8i/8x.
Role: Have been involved in support and development of BW application to address user needs, and responding to issues and concerns on a day-to-day basis.

SAP BW Consultant.

Responsibilities:

• SAP BW Consultant involved in Requirements Gathering to Go-Live operations for current SAP BW Global Implementation.
• Designed BW Functional and Technical Design Documents and coding standards for the Global roll-out and documented these on SAP Solution Manager.
• Worked on Sales, Material Management, Production Planning and HR (Payroll & Benefits).
• Designed and developed queries such as Purchasing activities and Fulfillment Rate of Deliveries.
• Sole responsible for designing & developing Inventory Management reports such as Stock Overview, Inventory Overview and demand supply match reports.
• Collected the Payroll Transaction data and created Queries on Annual/Quarterly Overview of Wage types and Overtime Hours and Costs on Payroll.
• Created complex ODS objects (Staged 3 different layers) and loaded data into ODS for data staging in BW.
• Created and activated Communication Structure, Transfer Structure, Transfer Routine, Update Rules (both at ODS and InfoCube level).
• Actively involved in Data extraction from ECC DataSources and through Flat Files.
• Developed Generic extractors and provided specifications for custom extractors.
• Designed and build Custom InfoCubes and analyzed different loading scenarios for Full load and Delta loading.
• Developed strategies for nightly/weekly/monthly production data loads using Process Chains.
• Worked extensively on BEx Analyzer and BEx Browser. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Developed Workbooks and Web Templates for Web Application Designer (WAD) and posted them in portals as Iview. Worked with Information Broadcasting and developed Dashboards.
• Performed user Security profiles, authorizations. Built security authorization objects for Info Objects, Info Cubes, and Hierarchy.
• Conducted weekly status update from Off-shore teams located at Singapore and India.
• Created EndUser documentation.