Objective

A rewarding career where I can utilize my talent and experience to satisfy clientele information needs and add value to the organization.

Summary

• Over 2+ years of IT experience, 2+ years query designing and reporting experience and 2+ Years of SAP BW experience.
• Received extensive training in BI / BO architecture and transition from BW 3.5 to BI 7.0.
• Involved as a team member in full life cycle Implementation of BW
• Thorough understanding of BW Star Schema & Multi-dimensional modeling
• Experienced in Data-Modeling, Data Extraction, InfoCubes, InfoSource, MultiCubes, Infosets and ODS
• Worked extensively on creating Transfer Rules, Update Rules, Update Routines and User Exits
• Experienced in activating standard Business Content and extending & enhancing Info objects, InfoSources, ODS and InfoCubes according to the user requirements
• Experienced in extracting data from SAP R/3 (FI/CO, MM, SD) and BW using different extraction structures such as FI-GL, COPA, LO Cockpit, LIS and generic extractor
• Worked extensively on Queries and created custom queries using Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, InfoSet Queries and WAD
• Expertise in Performance tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of info cubes and use of statistics
• Worked extensively with BEx Analyzer, BEx Browser, and BEx Query Designer for developing reports and performing detailed analysis
• Experienced in Web reporting using BEx Web Publisher, Web publishing wizard and BEx Web Application designer
• Process Chain and event management for Automation Process
• Excellent debugging and monitoring capabilities using Query Trace, BW Statistics, Monitoring etc.
• Involved in Production Support issues like monitoring data loads for optimization and checking the Query Performance
• Managing User Security Profiles, User Authorization and Performance tuning
• Excellent written/verbal communication and presentation skills

Skills

SAP BI 7.0, SAP-BW 3.5

ERP

SAP R/3

Operating Systems

Windows 2000 / 2003 Server, windows vista/seven

Applications

MS Project, Office XP, Symantec Antivirus, PC Anywhere, VERITAS Backup Software, FrontPage, Ghost, Visio

Hardware

RS/6000, Dell, Compaq and IBM desktop systems and 
Portables

Reporting / ETL

BEx, Crystal Reports, Access, Business object

Education:

• Masters in Computer Science
• Bachelor in Computer Science

Certifications and Trainings:

• SAP BW, 2004
• ASP. Net, March, 2006
• SAP BI/BO Training, 2009

Work Experience:

Confidential
Resource Center Aide July 2009 – Present

• Assist with Resource center printing and scanning production, supplies and mail room activities.
• Knowledge of all equipment to include scanners, copiers, printers, drillers, electric staplers, shrink wrap, binding, finishing, cutting, scales, folding, inserting, postage equipment and other machines for completion of various jobs .
• Responsible for programming and setting up equipment for specific production jobs
• Prepare meeting and document binders following specific instructions and examples
• Maintain daily and weekly production reports as instructed by supervisor.
• Assist with all aspects of daily incoming mail and outgoing mail, open, date stamp, sort, count, distribute place in appropriate departmental bin on schedule and throughout the day.
• Run high volume copy machines and perform all production requests.
• Assist all other resource center staff and perform other duties as requested.
• Cross train with resource center staff and fill in as directed.
• Dependable, reliable, responsible, with excellent organization and customer service skill.

ConfidentialMay 2005 - May 2006

• Gathered and analyzed requirements from Business Groups and senior executives
• Analyzed data requirements and translated these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques
• Used Operational Data Store (ODS) to stage the data before transferring the ODS contents to the Info Cubes
• Created custom info cubes for Cost Center, Profitability analysis, AR, AP and extracted data into BW
• Developed Transfer rules, Update rules and Start routines to incorporate Business logic for data manipulation
• Modified and enhanced standard DataSources, created generic DataSources on tables and views and enhanced function module to populate fields on extract structures
• Performed extraction from multiple source systems like LO Cockpit, CO-PA and flat files
• Used and modified business content for Sales and Financial Info Cubes to meet the End-User Requirements
• Managed and Monitored data loads with Full update and Delta mechanism
• Created Process Chains for the data loads and to automate the process and optimized the process chains by dividing processes chains into level1 and level2 process chains to optimize the scheduling and loads in BW
• Liaise with SAP Basis Technical Team regarding BW Transport requests and Data Loads
• Designed and developed reports utilizing both BEx and Web Application Designer
• Developed queries to include the restricted key figures, calculated key figures, hierarchy level displays, attribute inclusions, filters and free characteristic options, formula variables, text variables as part of query building in BEX Analyzer
• Created queries on various Info providers and for different scenario

ConfidentialApril 2004 - April 2005

• Involved in data design, data modeling, data extraction, data loading, reporting and production support
• Created custom info objects, info cubes, and ODS, multi providers, transfer, update and start routines to map the R/3 fields in to BW
• Installed and customized relevant business content in SD (order fulfillment) and FI (general ledger, accounts payable)
• Used Tables /Views, Info sets to extract the data from R/3 source system
• Worked on standard and custom LO extractors
• Used LO structures for extracting sales order, billings, shipments and enhanced the data sources to get the pricing details
• Loaded master data and transactional data in to the data targets from R/3 and flat files using full/delta loads
• Performed detailed analysis to improve the data load performance, data extraction performance using BW Statistics
• Worked extensively with BEx analyzer and Query designer; developed several queries of varying complexities using Navigation attributes, Hierarchies, Filters, Restricted key figures, Calculated key figures, Exceptions, Conditions, Variables and Structures
• Organized the queries into various workbooks and incorporated necessary authorizations
• Analyzed collective performance of various queries that are based on same InfoCube and improved the overall performance by creating suitable aggregates. Automated these aggregates’ rollups and change runs using process chains
• Created Info package groups and Event chains to completely automate the loading schedules