We provide IT Staff Augmentation Services!

Sap Bid Resume

New Jersey, NJ

Profile Summary

  • Over 7 years ofIT experiencein areas of Design, Development, Implementation and Testing ofSAP BWsystems up to releases 7.0,SAP R/3experience in design and development inSD,MM & FImodules andBEx Reporting
  • Involved in all phases of life cycle including Blue Printing, Realization, Design, Development, Testing, Go-Live, Production Support & Trouble shooting the issues, support in multiple engagements
  • Excellent in SAP ASAP methodology,BWModeling(InfoCubes, Info Objects, Info Sources, DSO, MultiProviders, Transformations, Extraction Process, transportation of business objects using CTS tool,DeltaandFullupdates, Process chains, Open Hub Destination and Performance Tuning)
  • Extensive Knowledge inBWReporting(BEx Query Designer, Web ApplicationDesigner); Performance Tuning, Authorizations/Profiles
  • Experience with Front-end Business Warehouse Components, which involved constructing custom queries usingVariables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures
  • Expertise in publishing queries to web portals throughWeb Analyzer
  • Worked on various kinds of Performance Tuning techniques such asAggregates, Rollups, Indexes, PartitionsandInfo-Cube Compression techniques
  • Combination of Technical and Business skills as applied to information systems which includes translation of business requirements into technical specifications, extensive data analysis, research and reporting
  • Proven experience in ability to adapt quickly and work in teams with ability to work independently and ability to take charge when necessary and drive the work to completion
  • Excellent communication skills, strong analytical and reporting skills, personal organization and interpersonal skills.

Technical Skills/Tools:

SAP R/3 Versions :ECC 6, 4.6C
Functional Skills:SD, AR, FI
Reporting Tools:BEx Query Designer, Web Application Designer
Data Warehouse:SAP BI 7.0, 7.3
Operating Systems:Windows NT/2000/98/95/XP
Utilities:MS-Office

Experience

Client:Confidential
Period:May’2011 – Present
Industry:Telecommunications
Location:New Jersey
Role:SAP BIDeveloper

As BW developer forFinanceandSalesareas, my responsibilities include:

  • Interaction with users and stakeholders to identifyBusiness Requirementsand drivers for Template change
  • PerformedGAPanalysis comparing the Business Content & reporting/modeling requirements
  • ConvertedFunctional Requirementsinto Technical Specifications
  • ActivateBusiness contentwhere applicable and created necessary custom Objects likeInfoObjects, DSO, InfoCubes, MultiProviders, Transformations, DTP, Info Packagesetc
  • Created custom cubes like ZSD_C03 (Sales Cube), ZSD_C01 (Customer Cube) etc and loaded the data from flat files in BW to facilitate the reporting requirements
  • Created aMultiProviderto integrate the Sales, Customer, Purchasing Cubes, Plan and Projection cubes
  • Identified theStandard Business Contentfor the BW Reports and activated them from the BW Business Content
  • Created BEx Reports Decrease in Sales, Daily Sales, Customer Analysis Report, Top 50 Customers, Top 50 Products, Aging Reports etc
  • Created severalRestricted & Calculated Key figures, Structures, Variables, Conditions, Exceptions
  • Developing flexible queries usingFilters, Free Characteristics, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
  • Broadcasting the queries to different users
  • Developed web templates usingWeb Application Designer(WAD)
  • Review system statistics and other measures to identify the need for aggregates, indexes, compression etc
  • CreatedAggregates, Partitioning and Compression on InfoCubesto improve Query performance
  • Balance load schedule to minimize load on BW & R/3 Systems, manage master data loads to minimize duplication
  • Responsible for managing unscheduled data loads and co-ordinate with functional support teams to avoid conflict with application schedules
  • Project went live smoothly and currently we are dealing with minor Post go-live issues

Client:Confidential
Period:Feb’2009 – April’2011
Industry:Telecommunications
Location:New Jersey
Role:SAP BIReportDeveloper

As BW functional analyst forFinanceandSalesareas, my responsibilities include:

  • Involved in creating theFunctional and Technicalspecification documents and developed the objects as per the design
  • Performed Analysis, Design, Development and implementation of standard/customized InfoCubes and ODS Objects forFIandSDmodules
  • Extracted (ETL) data from ECC & Flat files. Validated Data for quality.
  • Created the customInfoObjects, DataStore Objects, InfoCubes, MultiCubes, and Transformations, Data Transfer Process with Full and Delta loads.
  • Monitored ETL process for master data (texts and attributes)
  • Involved in configuring theOrder to Cash module
  • Created custom cubes like ZSD_C15 (Discount for Customers Cube), ZFIAR_C01 (A/R Invoices Cube) etc and loaded the data from flat files in BW to facilitate the reporting requirements
  • Created MultiProviders on ZSD_MC01 (Billing & Invoices MultiCube), ZFIAR_M01 (Invoices MultiCube) etcon which all the planning reports were based on.
  • Created Performance tuning using performance improvement techniques by partitioning the InfoCube,Compression, Partitioning, creating indices and maintainingAggregates.
  • Created process chains to automate the scheduling of data load into InfoCube and MultiCubes.
  • Developed reporting solutions forOrder to Cash
  • Created multipleBEx Reportsbased on user requirements in Sales, Delivery, Billing & Customer Analysis reports.
  • Implemented Daily Sales Outstanding (DSO)Business Content- The DSO analyses the outstanding debts of a customer for a certain period in relation to the average daily business volume of the customer in question.
  • Developing flexible queries usingFilters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
  • Created Web templates for queries usingWeb Application Designer
  • Worked on Help Desk tickets to resolve Data Inconsistency between SAP BI and Non –SAP Source Systems
  • All the reports were developed using Web Application Designer as there were no mandatory fields in the selection screen. This posed a problem that the selection screen was not being popped-up when the queries were published under the menu role. In order to solve that, the ‘force all screens’ option was used in the web template and published on the menu role

Client:Confidential
Period:Nov’2007-Dec’2009
Industry:Apparel
Location:Maryland
Role:SAP BI Developer

As BW functional analyst forFinanceandSalesareas, my responsibilities include:

  • Interaction with users and stakeholders to identifyBusiness Requirements
  • PerformedGAPanalysis comparing the Business Content & reporting with Modeling requirements
  • Installation ofBusiness ContentforSales and Distributionand Finance areas
  • Activation of standard Info Cubes, Enhancement of Business Content
  • Extracted data from flat files to load into customized InfoCubes and DSO’s
  • DevelopedTransformations, Data Transfer ProcessandInfo Packageswhile loading the data from custom DataSources to InfoCubes
  • Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and uploaded Data from PSA to DSO, DSO to InfoCube and enabled Data for Reporting and Analysis.
  • Improved data load and query performance by doing Compression, Rollup and creating Aggregates, Indexes and Partitioning
  • Created MultipleBEx Reportson Sales Overview, Open Sales Orders, Top N Reports, Overdue Analysis
  • CreatedRestrictedandCalculated key figuresto calculate average, min, max etc
  • Created flexible queries usingFree Characteristics, Filters,Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
  • Worked on functions of new BEx Query Designer in the state-of-the-art BEx Web Application Designer (WAD), excel-based application design with the new BEx Analyzer
  • Created new queries withVariables, Calculated Key figuresin Query Designer
  • Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx
  • Created necessary documentation like functional & technical specifications, Data Flow diagrams, Modeling diagrams etc… Coordinated with the Basis & Security team from time to time during the project.
  • Provided Production support after go-live and Performance Tuning
  • Responsible for managing unscheduled data loads and co-ordinate with functional support teams to avoid conflict with application schedules

Client:Confidential
Period:May’2005-Oct’2007
Industry:Tax
Location:India
Role:Senior Analyst

As BW junior functional analyst forFinanceandTaxareas, my responsibilities include:

  • Understands the purpose, roles and activities of the clients
  • Performed Analysis, Design, Development and implementation of standard/customized InfoCubes and ODS Objects forFImodules
  • Created the customInfoObjects, DataStore Objects, InfoCubes, MultiCubes, and Transformations, Data Transfer Process with Full and Delta loads.
  • Identified theStandard Business Contentfor the BW Reports and activated them from the BW Business Content
  • Designed queries on Tax Reports like Year-End Tax Depreciation Report for Assets depending on their age (5yr, 10yr, 15yr and 20yr)
  • Created billing and history, credits raised, general refund reports
  • Created Web templates for queries usingWeb Application Designer
  • CreatedRestrictedandCalculated key figuresto calculate average, min, max etc
  • Created flexible queries usingFree Characteristics and Filtersin BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
  • CreatedStructuresfor a query and customized it for several queries using the same structure
  • CreatedAggregates, Partitioning and Compression on InfoCubesto improve Query performance
  • Data loads (daily, weekly and monthly) using dedicated Process chains
  • Analyzed loading performance issues like Extraction, Staging, Loading Master Data, ODS and Info cube and other tuning aspects like Partitioning and Archiving.
  • Performed Aggregates review for Queries using transaction RSRT
  • Worked on Help Desk tickets to resolve Data Inconsistency between SAP BI and Non –SAP Source Systems

Education:

Diploma in Business Administration

BS in Commerce – Accounting.

Hire Now