Objective:

To obtain a challenging position that will utilize my technical skills, offer challenge, accountability and an opportunity for career advancement.

SUMMARY

• Over 10 years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing. Maintenance and Enhancement in variety of technological platforms.
• Has 5 years of SAP BW/BI, 10 years of experience in data warehouse reporting tools.
• Implemented full life cycle implementations for different modules in SAP BI/BW which involves Gap analysis, Requirement analysis, Blue Printing, Implementation, Testing, Documentation, End user documentation, Data modelling, ETL Design, Data loading and Reporting.
• Experienced in creating Intelligence Dashboards and reports based on the business requirements.
• Worked extensively in business processes across the modules MM,SD and FI-CO.
• Expertise in ETL activities like Data Extraction, Data Modeling, Loading (Full/ Delta upload), and scheduling data loads, creating process chains for data load automation, monitoring process chains for data load issues.
• Expertise in BW components like Extractors, InfoCubes , DSOs, MultiProviders, InfoObjects, InfoSources, InfoSets, Transformations, DTP, Start routines, End routines, Update rules , Transfer rules, InfoPackages.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, CO-PA, FI-GL, FI-AP, FI-AR, MM, generic extractions and extraction from flat files , non-SAP systems and DB connect .
• Strong Experience in front-end BW Components like BEx Analyser, Query Designer, BEx Workbooks, Web Application.
• Strong Experience in front-end SAP Business Objects tools like BI 4.0 tools ,Designer, Web Reports, IDT/Universe Designer, Crystal Reports, Web intelligence, Live Office, SAP Dashboards/Xcelsius, Desktop Intelligence.
• Experience in ABAP to write start/end routines, update/transfer rules and user exits .
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques
• Excellent in data loading, performance issues, data compression activities, archiving and reporting related issues.
• Highly organized with proven skills to perform several tasks and assignments within the scheduled time.
• A team player working effectively with in group in accomplishing project objectives.
• Excellent Written and Verbal Skills; Results oriented and Self-Starter looking for challenges; Ability to rapidly learn and apply new technologies and improve processes: Self-motivated and results-oriented with solid work ethic.

Technical Skills:

ERP Applications:

SAP R/3,ECC

SAP BI/BW:

SAP BW 7.x and BW 3.5

BI Reporting Tools:

BI 4.0 tools,BEx Analyser, Query Designer, BEx Workbooks, Web Application Designer, Web Reports ,Business Objects XI R2/3.0, Crystal Reports 11.5, Web Intelligence, InfoView, Live-Office, Xcelcius, Desktop Intelligence, CMC, Import Wizard, OBIEE 10.1.3.4.1(Administration, Answers, Delivers and BI Publisher), Oracle BI apps, , Hyperion.

Functional Areas:

SAP Logistics like SD, MM , FI-CO, FI-GL, FI-AP and FI-AR.

Relational Databases:

Oracle 11g/10g/9i, SQL Server , MS Access, Essbase , DB2

Languages:

ABAP/4, SQL,PL/SQL,VB Script, Java Script, .NET , COBOL

Operating Systems:

Windows 95/NT/2000/XP

Tools:

Toad, Oracle SQL developer , MS-OFFICE, Quality Center

Methodologies:

Universe/Designer, IDT, Datamodeling, Logical/Physical, Star/Snowflake Schema, Dimension Tables, ETL, OLAP, SDLC

Web Technologies:

HTML, XML,JSP,ASP

PROFESSIONAL EXPERIENCE

Confidential,Sunnyvale, CA. Dec 11 – till date

• Participated in business user meetings for requirements analysis, functional design, getting user signoff on project deliverables.
• Delivered many sales, product margin & profitability analysis reports using data from BW Info cubes, the source of data being from SAP and NON SAP sources.
• Developed multi level data model including DSOs, InfoCubes, Multi Providers to combine data from FI and SD and FI and MM to deliver business reporting requirements.
• Extraction of data from SAP R3 using extractors in FI-CO, SD, Purchasing(LO-Cockpit) areas. Installed business content extractors, enhanced business content extractors by adding additional fields and using BW user exits in R/3 to populate added fields.
• Created many generic full/delta extractors to extract master data, text and transactional data where SAP extractors are not available.
• Created Process chains to automate data loads from R/3 transactional data loads, master data /texts/hierarchy data loads. Implemented processes to notify on-call support teams for data load issues.
• Developed ABAP Code for user exits in BW for query variables, update rules, transfer rules and start routines etc.
• Involved in various kinds of Unit testing, Acceptance testing and Regression testing of the developed objects and checking the data quality and the functionality of the objects as per the requirements.
• Worked on Transportation of BW Objects from Development system across the landscape through Transport Connection.
• Generated reports on the MultiProviders and InfoCubes using Restricted key Figures, Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, Cell Editors, Exceptions and conditions .
• Used RRI interfaces, filtering, conditions, variables, currency conversions, jump queries and navigational attributes.
• Developed front-end reports using IDT(Integration Design tool)/Universe Designer ,Crystal Reports and Web intelligence reports.
• Assisted in creating dashboard pages using Dashboard Designer for users.
• Trained Super/Power Users on developed reports and enhancements.

Confidential,Lancaster, PA. Feb \'11 – Oct \'11

• Involved in overall implementation of SAP BW for Sales and Distribution and Inventory Reporting.
• Interacted extensively with end users in gathering reporting requirements for Sales, Shipping and Finished goods Inventory data.
• Involved in Development: Activated the standard DataSources for Sales and Distribution data. The DataSources activated are 2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_13_VDHDR and 2LIS_13_VDITM for Orders, Delivery and Billing Data.
• Developed custom ODS Objects and InfoCubes for Delivery and Billing DataSources.
• Created and activated transfer structure, transfer rules, communication structure and update rules (both ODS and InfoCube level).
• Enhanced the BW data source for movements 2LIS_03_BF to accommodate the additional reporting requirements of Armstrong and coded user-exit to populate the enhanced fields.
• Did the stock Initialization using data source 2LIS_03_BX, Taken year 2003 as base year.
• Created custom InfoObjects in BW to meet the additional client’s requirements.
• Designed and developed custom ODS objects, InfoCubes for Inventory data and activated Update rules for these data targets.
• Developed the Material Classification data sources for extracting classification data in R/3 system. Enhanced InfoObject 0MATERIAL to keep material classification data and developed transfer rules.
• Involved in identifying critical value drivers, Key Performance Indicators (KPI) within business units and developing strategies to maximize value drivers and performance measures for decision support.
• Used delta update mechanism for uploading data to BW from R/3 in specific intervals.
• Extensively worked with job scheduling, Process Chains to load data into data targets.
• Worked with Aggregates, Statistics, Partitioning to optimize the query performance.
• Involved in analyzing the reporting requirements,
• Worked extensively in BEx Analyzer in defining queries, Templates, workbooks and worked on jump queries.
• Defined queries in the BEx Analyzer and presented the results in workbook and integrating the workbook with BEx Browser.
• Created Analysis of Open Orders and Shipment Analysis reports on ODS Objects.
• Queries developed based on calendar day, week, month and year to obtain multiple combinations of reports from InfoCubes.
• Published queries on the web to facilitate web reporting.

Confidential,NY Jan 10 – Nov ‘10

• Participated in business user meetings for requirements analysis, functional design, getting user signoff on project deliverables.
• Worked extensively in Logistics area to extract data using LO-Cockpit. Implemented/enhanced R/3 Extractors in SD area (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) MM area (2LIS_02_SCL ,2LIS_02_ITM, 2LIS_02_ACC) Invoice Verification (2LIS_06_INV).
• Enhanced data sources with additional fields and enhanced R/3 user exits to populate data for additional fields.
• Created process chains (RSPC) and added email notifications to process variants to automate data loads and inform support team when loads fail.
• Created project documentation for functional design, technical design, data load process.
• Participated in unit test, integration test, user acceptance test process, resolving issues arising from testing process.
• Improved load and report performance using aggregates, rollups, cube Partition, Compression, and Indexes.
• Checking the inconsistencies and repaired using the Transaction code RSRV & also monitored the Query performance by using Transaction code RSRT.
• Reviewed and handled production support tickets (Trouble Tickets) in production systems on priority basis within schedules to set expected results.
• Developed drill through Queries for detailed Reporting using replacement path variables.
• Used Cell-Definitions, Structures, Exceptions, Conditions.
• Used Restricted (RKF) and Calculated Key Figures(CKF), Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer to develop reports.
• Developed front-end queries using Query Designer and Web Application Designer (WAD) and publishing results on the web.
• Defined BEx broadcaster settings for the pre-calculation and distribution of workbooks, publishing queries and workbooks by e-mail.
• Created documentation for Functional and Technical Specifications for the Reports developed.
• Created knowledge transfer documents for super users and end users.

Confidential,Franklin Park, IL Jan 09 – Nov 09

• Worked closely with Basis during BI upgrade from 3.5 to BI 7.0, helping with setup as well as in configuration of the system based on the new BI architecture.
• Worked extensively on the upgrading to BI 7.0 which included technical upgrade and multiple cycles of application upgrade by functional area. Also involved in deployment of reports using EP and standard web templates.
• Built new BW functionality for FI-AR and FI-AP data extraction, building financial reports in new BI 7.0 version using transformations, DTPs.
• Extraction the Data from R/3, Activation of Data Source, Enhancement in Data Source, Creation of Generic Data Source and Delta Management for Extraction.
• WorkedExtensivelyonStandardandCustomDefinedLO,Extractors Installed Relevant SAP Business Content.
• Worked Extensively on Open Hub services & Info Spokes.
• ExtractedfromMM,andSDmodulesofSAPdatausingLOExecution Cockpit and V3 updates.
• Extracted Data from Oracle Data base to BW Using DB Connect Interface.
• Responsible for customizing and activating the Business Content Objects and Loading the data into ODS Object and Info Cubes.
• Installed business content cubes for SAP Technical content in Business Warehouse to enable support team to monitor load/query performances and data base growth based on Cube/DSO sizes.
• Created technical detail design Specification & the Approach & Process Document.
• Created work book templates for embedding BW queries to suit company standards by inserting logos, formatting etc..
• ExtractingtheDatafromOracleDatabasetoBWUsingDBConnectInterface and Implement Remote cubes
• Worked extensively in BEx (Query designer, Analyzer, Browser) Reporting.
• Developed front-end reports using Universe Designer ,Crystal Reports and Web intelligence Reports.
• Conducted support team with BW development to make them aware of new functionality.
• Participated in Super User training to educate them on the new reports going live.

• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• Installed Business Content as and when required.
• Involved in development of Reports to print Purchase Orders with drilldown for vendor.
• Developed Pending Order Status Report to display pending Purchase Orders (PO) with drilldowns for material and vendor.
• Involved in generating interactive report programs to give details on sales orders, vendors, customers and stock available in each type for a particular material
• BW user-exit was coded to populate the enhanced fields in the DataSources.
• Involved in database tuning and performance to suggest optimizations as per theoretical and practical observations using BEX Analyzer
• Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi-Providers, Info Sources, Data Sources, and Info Packages.
• Uploaded master and transactional data from flat files and SAP R/3 sources.
• Extensively worked with Transports for migrating development up the landscape.
• Worked extensively on administration workbench (RSA1).

Confidential,Rosemont, IL Aug 06 – Feb 08

• Responsible for analyzing, development and implementation, documentation of detail design code review, updating and modification accordingly.
• Provide solution for complex requirements.
• Developed multiple Web-Intelligence, Desktop-Intelligence, Crystal Reports using multiple data providers.
• Publish reports to user community through Business Objects Central Management Console (CMC) and Building security from the scratch after migrating all objects from 6.5 to XI R2.
• Migrated and Imported data from Business Objects 6.5 & Crystal Enterprise to Business Objects Enterprise XI2.
• Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and
• Special Formatting for Web-Intelligence reports to avoid merge cell issue in EXCEL especially in cross-tab report.
• Use of Designer Module to implement Universes, linkages between tables, creating cascading prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Review design documents and code review of SQL generated by reports
• Involved in Physical, Business Model & Mapping and Presentation Layer development
• Created Dimensional Hierarchy and Level Based Measures in BMM layer
• Created Repository variables , system and non-system session variable and initialization blocks for various reporting needs.
• Implemented Aggregate navigation, Fragmentation content to meet the business requirements
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and report prompts.
• Responsibility included the full SDLC management for designing, analyzing, developing, testing, Implementation and application support
• Assisted Production Support team in debugging and fixing production incidents

Confidential,Deerfield ,IL Mar 06 -- Aug 06

Worked on Specialty Pharmacy project which enabled Walgreens to provide the resources and support that can help patients achieve the best results from their prescribed therapy. The data comes from different operational sources and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports. I have gathered the requirements from the business users to develop the reports.

• Worked on Data mappings and involved in design of the Data model for the ETL process.
• I was actively involved in developing Universe and reports using Business Objects.

Confidential,IL Oct 2000 -- Oct 2005

• Study of the workflow implemented through Optika, build new reports to evaluate various aspects of retirement benefits for the employees.
• Migrated Business Objects reports and upgraded Universes in line with upgrade of work flow from Accorde 1.5 to Accorde 2.1
• Built a metric reporting environment encompassing various Business Processes, requirements gathering from the Analysts, data mapping though co-ordination with database management teams, creation of data providers and data analysis
• Business Objects security administration, which includes repository maintenance, creation and maintenance of user profiles and scheduling and distribution of canned reports through Broadcast Agent console and WebIntelligence.
• Migrated Business Objects Reports, upgraded Universes and migrated Repository to a different database in line with moving of Client Oracle databases to Sun environment.
• Supported end-users for report related issues with users, enhancements to reports and or Universes apart from training for advanced report building.
• Trained Client employees in Universe design and helped Help Desk in streamlining the deployment of Business Objects Products.

VAL.COM is online retailer of software and hardware products, they have clients like Quaker Oats and also develops software for third parties. I am involving in developing Screens for accepting orders and processing and shipping products to the clients.

Involved in developing and creating reports for an application known as LTR (Labor Tracking and reporting) system on Intranet. I was involved in

• Created web pages using active server pages using ADO objects to access database.
• Developed reports using VB Script , Java Script, Stored Procedure & SQL queries
• Created ActiveX DLL for the password protection.

EDUCATION:
Bachelor of Engineering from INDIA.