SUMMARY

• 8 Years of SAP BW Consultant experience in Consumer Goods, High Tech & telecommunications, Retail, Chemical, Energy &Resources and Manufacturing Sector.
• Comprehensive knowledge using SAP ASAP methodology in Business Information warehouse database design, development, configuration and performance, Experienced in teh analysis of business needs to build single best practice solution.
• Extensive experience in SAP BW - Data Modeling, Report development and expertise in Performance tuning.
• Experience in Implementation, Upgrade, Maintenance and Support in SAP BI/BW.
• Experience in Upgrade from BW 3.5 to BI 7.0
• Experience in Datacenter migration from Unix to Windows
• Experienced in deployment activities, creating cut over plans, involved in cutover activities, co coordinating with different process team to make successful deployment
• Experience on SAP Business Objects Reporting tools hosted on Business Objects XI 3.1.
• Worked extensively on BEX Analyzer and created various Queries and workbooks.
• Understanding of standard SAP modules (FI/CO,REFX,IM,SD, MM, APO,SCM, SRM)
• Experienced in OLTP extractions of SAP LO-Cockpit, FI Asset Accounting, ECCS - Consolidation, CO-OM, CO-PA, FI-REFX, FI-GL (New), FI-AP, FI-AR, PCA, CCA, SD, MM, APO, Generic extractions and non-SAP data. Experience in Extraction from Flat files, SAP Data marts, SAP, Non SAP.
• Broadcasted reports with exceptions/pre calculations using Information Broadcasting functions.
• Handling of teh production support tickets and resolving them as per teh ticket priority and transporting them into Quality and Production environments.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

ERP: SAP ECC (6.0, 4.7, 4.6C).

SAP: SAP BW 3.0, 3.5, 7.0, 7.02

SAP BO: Business Objects 5.1, v6.5 and Business Objects XI 3.1.

SAP BI Tools: Webi, Xcelcius, and Crystal.

SAP-Modules: FI/CO, REFX, ECCS, SCM, SD, IM, APO, SRM

BW - Reports: Query Designer, BEx Analyzer, BEx Browser and Web reporting, WADInformation Broadcasting, Visual Composer & Portals.

BI Data Mining: Analysis Process Designer

ETL: Ascential Data Stage 6.1

Operating Systems: Windows 95/98/NT/2000, UNIX

Databases: MS SQL Server, Oracle8i/9i/10g, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SAP BI Solution Consultant

Responsibilities:

• Lead for teh FI Technical Designs & implementation - FI-GL (New), AP, AR, CCA, PCA, Asset Accounting, CO - OM Controlling and ECCS - Consolidation modules for SAP BW/BO implementation.
• Actively involved in gatheird business requirements from teh client and teh report users to facilitate robust warehouse model for teh successful implementation.
• Responsible for creating high level technical designs for all teh finance flow into BW
• Created high level tech designs for teh ECC extraction including complex enhancement in teh data sources.
• Created complex data models based on teh business requirement which satisfy teh reporting needs done by various BI Tools like Webi, Xcelcius and Crystal reports.
• Responsible for creating technical designs for teh BEx Queries, Universes, Webi Reports and Xcelcius dashboards.
• Worked closely with business users on teh consolidation of financial data for teh consolidation reports/dashboards based on teh companies.
• Working on teh finance extracts to feed to BPC for planning teh budgets.
• Responsible for delivering Webi reports and XCelsius Dashboards in teh financial accounting areas which we are implementing.
• Review of teh work done by teh developers per design standards.
• Prepared unit test and assembly test plans for teh phase 2 execution for teh implementation.

Confidential, San Ramon, CA

SAP BI Solution Consultant

Responsibilities:

• Prepared estimates for new delivery projects or a new release in an existing delivery projects.
• Involvement in RFP (Request for Proposal) in Project.
• As a lead, delegated tasks to teh offshore team depending upon teh priority of teh tasks and availability of resources.
• Worked primarily in teh SAP modules FI REFX, SCM, Reverse logistics, SRM.
• Responsible for creating high level Designs according to teh functional requirements for teh above modules.
• Conducted reviews to verify teh design reflected teh business needs
• Created complex reports in Real estate management like lease & budgeting, contracts, real estate portfolio etc.
• Created complex reports in SRM, me.e. shopping cart reports, shopping cart approvals report.
• Worked in reverse logistics reports OEM turnaround time reports, aging reports etc.
• Worked in APO demand planning, developed forecasting reports, demand plan and actual reports.
• Worked in a high visibility dashboard for teh inventory management, inventory viewer created in VC.
• Created Unit Test Plans for all objects created in dev, Assembly test plan creation and execution in QC environment.
• Created complex Reports, Backend Objects like Cubes, ODS, Info Cube with its Update Rules, and Info Sources, Process Chains.
• Worked in APD to get teh daily snap shots of teh inventory which feeds to teh inventory viewer dashboard.
• Worked on security roles, authorizations& authorization objects, giving access and assigning roles to teh end users based on their authorization levels.
• Involved in teh Sync- Up activities after teh deployment to teh N+1 environment.
• Involved in Pre Production and Post Production UAT's with teh Users and BA.
• In charge for all teh transport to different systems for testing and also to production.
• Responsible for training teh end users on utilizing, developing and administering queries.
• Involved in cut over activities as a transport manager taken care of teh issues during deployment.

Confidential, Kansas City

Sr. SAP BI Consultant

Responsibilities:

• Responsible to gather business requirements from teh business users and leading teh offshore team for teh new project enhancement.
• Worked in Technical upgrade from BW 3.0 to BI 7, Performed pre upgrade activities, Dynamic involvement handled issues while upgrading from BW 3.0B to BI 7, created technical design and validated data model post up- gradation.
• Worked in functional upgrade project Migration of all teh 3.x Data sources to BI 7 Version. Besides functional migration, me have also worked on enabling new BI 7.0 functionalities.
• Extensively involved in Data Center Migration project from UNIX to Windows, performing migration checklist pertinent to BW environment; coordinating with Oracle DBA and SAP Basis team when applying related patches to BW system
• Worked in performance tuning project to increase teh performance of our existing BW box by dong analysis on load performances, changes to design to improve performance of teh Query using OLAP Cache, Aggregates, Re-partitioning, Re-modeling and reporting agent to run queries in background. Information broadcasting to burst emails, broadcast based on exceptions, filling teh OLAP Cache &pre calculating Value Sets.
• Activation of Business Content according to Requirement and Activated Data Source Structures in R/3 for Transactional and Master Data.
• Worked in data source activation and enhancements in Non SAP, ECC and other SAP systems Flat files excluded
• Worked in developing custom (generic data sources) MD attributes texts and hierarchies.
• Enhanced several Extract Structures in teh Source System according to client requirements and replicated data source and extracted data into BW.
• Extraction of Master Data 0COSTCENTER O010 HIER, ATTR and Text from ECC for Cost Center and Business Area.
• Implemented changes to existing data models/reports in production and in data reconciliation.
• Implemented advanced performance tuning techniques like Partitioning, Compression, etc for query performance
• me have developed custom web templates in WAD
• me have led testing activities through UAT (by planning, monitoring and closure of testing phases. That is, planning test activities, ensuring completeness of test coverage, interacting with client users, getting sign off etc).
• Worked with teh basis team to authorize user's access to reports.
• Worked extensively on Business Explorer (BEx), Web Application Designer (WAD), Reporting Agent, Calculated/Restricted Key Figures, Structures & Cells, Hierarchies, User Exit Characteristic/Formula/Hierarchy/Hierarchy-Node/Text Variables, Conditions, Exceptions & Currency Translation, Web templates and pre-calculated web templates.
• Created Reports like YTD for Actual and Planned data, Manufacturing Cost Budget Variance, Manufacturing Cost across plant, Quarterly Trend for Costs by plant etc.
• Developed flexible queries using filters, navigational attributes, Calculated Key Figures and Restricted Key Figures in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Confidential 

SAP BI Consultant

Responsibilities:

• Extracted data from teh CRM using business content function Modules.
• Worked on teh CRM data sources 2LIS 17 I3HDR, 2LIS 17 I3OPER, 2LIS 18 I3HDR, 2LIS 18 I3OPER and 2LIS 17 I0NOTIF.
• Customized Generic Data source with function module to load Work Order details and from view to pull latest status of Quotations/Sales orders from CRM system.
• Created reports like WO Details, WO Creation, WO Scheduling, Emergency Response reports, Quotations acceptance to Work Orders, Deferral/Delay communication, Jobs technically completed and jobs substantially completed reports.
• Created generic Extractors for extracting data out of custom tables and views.
• Built ODS, Cubes and Multiproviders and logics to meet teh business requirements.
• Developed complex reports to track teh Open / Closed requests in Solution Manager and teh users responsible for teh same.
• Created ODS structures, Info-Cubes, custom Queries.
• Transporting teh objects from Dev to Quality and testing teh functionality before moving them to teh Production environment.
• Created process chains for regular data loads and also for BW statistics related data.
• Checking teh daily time schedule for teh run & ensuring that teh jobs are finished within teh specified time frame.
• Cross Verifying teh Daily data load as per teh checklist for ensuring teh proper data upload in BW.
• Loaded business content and custom hierarchies for CRM related Objects for reporting.
• Worked on BEx analyzer and BEx Browser. Developed flexible and configured use of Restricted Key Figures, Exceptions, hierarchies, Variables, and Queries using Filters in BEx Analyzer.
• Involved in validating data across teh systems with regard to data in Solution Manager versus teh report data by tracing out teh data flow.
• Involved in teh Rollout Process to train teh users on teh reporting environment.
• Involved in teh development of reports, which would display teh quarterly and monthly sales, and also teh variance between teh target and teh achievement figures.
• Trained teh primary support team to handle teh postproduction issues and scheduling of teh process chains/data loads.
• Created aggregates, ODS structures, Info-Cubes, custom Queries, etc
• Checking of data integrity between teh source system and BW.Rectifying teh mismatches if any during teh process.
• Imparted training to end users to familiarize them with teh reporting features and also prepared teh user manuals.
• Using Data stage designer in Developing jobs as per ETL specifications
• Developed various Jobs which involved with dimensional and fact loading
• Created FTP jobs for transferring data across various servers.
• Used Data stage director to Run Jobs and to Test teh Flow
• Debugging and identifying Causes for job abortions and rectifying them.
• Used Filters, Breaks and Created Variables and user defined Objects.
• Used different types, styles of reports like Grouped, Simple, Free-Style, Templates.
• Used different presentation styles to enhance reports and make them visually appealing a verity of presentation styles to enhance Reports.