PROFESSIONAL SUMMARY:

• Certified as SAP Business Information Warehouse (BW 7.0) Consultant with around 12 Years of professional experience.
• 10 years of experience as a SAP BI/BO techno - functional consultant that include Business Objects architecture, software deployment, Universe/Report(webi)/Dashboard development, documentation, Production Support and user training and SAP BW using Bex reporting tools like BEx Query Designer, BEx Analyzer and Web Application Designer
• Expertise in the technical capabilities of BI 7.3/7.0/3.5 like modeling using Info Objects, Info Sources, Data Sources, PSA, Info Cubes, Multi Providers, InfoSets, Data Store Objects (DSO)/ODS objects, Info Packages, Transformations, Update rules and Transfer rules upto BW 3.5, Data Transfer Process, Aggregates, Open Hub Destination, APD, RRI
• Extensively worked with ABAP on Transformations (with complex start/end/expert routines), Update Rules, Transfer Rules and User Exits.
• Over 1+ Years of experience in creating dashboards using SAP BO Dashboards and Xcelsisus (Version 2008)
• 2 + Years of experience in SAP ABAP: Different types of reports( Classical, Interactive, ALV), Data Dictionary, Dialog Programming, Smart Forms, SAP script, BDC Programming, IDOC processing, LSMW, ALV Grid Control, BAPI, Debugging, Performance enhancement, SQL Trace, function modules
• Around 6 months of experience in Oracle apps, worked on queries in SQL and PL/SQL and created queries for reports.
• Extensively involved in BI Production Support in handling daily batch jobs, load failures, delta failures, Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck issues.
• Experience in various industry sectors such as Retail, Pharmaceutical, Networking and Automobile
• Excellent communicational skills, Project management, Time management Skills.

PROFESSIONAL EXPERTISE:

• SAP:
• BI
• BW
• ABAP
• BUSINESS OBJECTS:
• Universe Designer
• Report Development(WEBI)
• Dashboard / Xcelsius

TECHNICAL SKILLS:

Reporting Tools: Business Objects, Dashboard(Xcelsius), Bex Query designer, Bex Analyzer,WAD

ETL Tools: SAP BI, SAP BW

Business Objects Modules: InfoView, Webi Rich client, Designer, Import Wizard, CMC, Xcelsius, Crystal Reports

ERP: SAP ECC 6.0, SAP R/3 4.7

Databases: Microsoft Access, MYSQL, Oracle 11g/10g/9i

Programming: ABAP, C, C++, SQL, PL/SQL

Operating System: Windows 95/98/2000/XP, Unix

Application Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, Microsoft Visual safe

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

SAP BI Report Developer

Responsibilities:

• Developed Webi report/dashboards/Universes in BI4 Environment based on EPIC Tapestry
• Designed and Developed Webi Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data, variable calculation, merged dimension, section, Input Control, Ranking, Query filter as well as Table filters functionality.
• Worked on KPCC Dashboard development and maintenance
• Created BI components like Info Objects, Data Store objects, Info Cubes, Transformations, DTP, Info Packages and scheduled the data requests all the way till reporting layer.
• Universe upgrades and master data objects maintained ER relationships

Environment: SAP BO 4.1/4/2, Webi, SAP Bex, Oracle 11g, CDW, EPIC 2014/15 Tapestry Claims.

Confidential, CA

SAP BI Onshore/Offshore coordinator

Responsibilities:

• Coordination between client and offshore team regarding requirements and daily status.
• Developed Webi report/dashboards/Universes (using IDT) in BI4 Environment.
• Designed and Developed Webi Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data, variable calculation, merged dimension, section, Input Control, Ranking, Query filter as well as Table filters functionality.
• Worked on Corporate Dashboard development and maintenance & ABAP Transformations Start and End routines.
• Created BI components like Info Objects, Data Store objects, Info Cubes, Transformations, DTP, Info Packages and scheduled the data requests all the way till reporting layer.
• Universe created on Info cubes and master data objects maintained ER relationships

Environment: SAP BO 4.1, Webi, ABAP, SAP Bex, SAP BI 7.3

Confidential, SFO, CA

Senior SAP BI consultant and Onsite/Offshore lead

Responsibilities:

• Provided Production Support includes responsibility for batch jobs like monitoring the Process Chains Daily, Weekly and Monthly. Trouble shooting the critical issues raised by offshore team.
• Monitoring the Remedy ticketing queue by addressing the unassigned tickets. Assigning the new ticket within the group based on priority and criticality or bypassing to other teams which are misrouted to our group.
• Troubleshooting issues raised by users. Interacted with users for understanding the problem and worked on providing the appropriate solutions. Has maintained work log until it is closed.
• For Enhancements, Gathered Requirements from Super users, performed GAP Analysis and Impact Analysis and created technical specifications document to get approval for the development. I have ensured that I and my team deliver the Enhancements on time.
• Consolidated various Transports created for Development, Then responsible for migrating Transport Requests into IT/QA and production. I have also validated all the Objects Once transports have successfully imported into production. Performed cutover tasks in production.
• Coordinated Finance Month end activities with the team in onsite and offshore by reconciling Finance related data between SAP R/3 and BW and also within BW reports after final postings have completed.
• ABAP Transformations Start and End routines
• Involved in ‘Order to Cash’ Month end activities by coordinating with the team in onsite and Users by reconciling Sales related data between SAP R/3 and BW and also within BW reports.
• Worked on Jump query for summary report to get detail report
• Worked on converting ageing deski reports into webi reports by analyzing underlying Universes as well as Customized SQL Queries.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and Checked the Integrity of the Universes
• Developed derived tables for complex Sql in Universe.
• Worked on enhancing R/3 data sources and enhancing BW objects by including new fields till report level.
• Enhanced Extractor program for 2LIS 02 ITM to include the logic for new fields
• Enhanced Master data extractor to include new attributes and replicated into BW with new fields
• Created new data source for extraction from EBP based on view for shopping cart data
• Created new data source for extraction from Global BW system on DSO for Ariba data.
• Worked on Procurement, Finance and sales related reports using Bex using filters, conditions, calculated key figures, formulas etc.,
• Created Web templates and coordinated with portal team for publishing onto the portal.

Environment: SAP BO 4.0, Bex, SAP BI 7.0, SAP ECC 6.0, EBP and Ariba system

Confidential, Beaverton, OR

SAP BI Consultant

Responsibilities:

• Gathered Report Requirements by interacting with Users, performed GAP Analysis and created Technical Documents as per the Requirements for Purchasing, Inventory and Sales modules
• Worked on reports in Retail areas like MM and SD -Sales, Inventory and Purchasing. POSDM is the source for all sales related information.
• As per the Model/Design, I have activated SAP BI Business Content wherever possible. Created necessary custom Infoobjects, DSOs, Infocubes, Multiproviders, Tranformations, DTPs and Infopackages etc., based on the Data Models.
• Enhanced Purchasing Datasources suitably with additional custom fields as per the Design for reporting. Created Generic Data Sources for Extracting Data from Z tables based on table/view.
• Worked on BADIs to populate the enhanced datasource fields in ECC extraction.
• Worked on Routines ( Start, End and Field) in Transformations to transform according to user requirement.
• Extracted data from ECC(Inventory and Purchasing), POSDM(Sales) and File Source Systems into BI.
• Sent BI data to outbound interfaces (Stats, MDO) through Informatica using Open hub destination.
• Worked extensively on Bex- Bex Query designer, Bex Analyzer and WAD, also created Information Broadcasting for queries to send through mail.
• Created APDs for analysis process. ABAP Transformations Start and End routines.
• Created Process Chains to Automate the Data Loads and Scheduled batch jobs to trigger the process chains daily, weekly and monthly.
• Improved the performance of the queries on Info-cube by creating BI Accelerator and rolling up the data in process chains.
• Performed The Unit Testing of the Development Work and collected transports to be moved to quality system for QA team.
• Interacted with users for User Acceptance Testing after QA team completed QA testing.
• Transported the Objects across the Systems once users did sign off. Performed Cut-over Tasks.
• Documented the Design, Development, Testing activities following the client’s requirements.
• Supported the system after Go-live and addressed issues. Resolved Help Desk Ticket

Environment: Business Objects XIR3, Crystal Reports, Webi, Bex, WAD, SAP BI 7.0, SAP ECC 6.0

Confidential, Princeton, New Jersey

Senior BI Developer

Responsibilities:

• I was involved at the end of Blue print Phase. Based on the Functional Specifications, I have created the Technical Specifications for all the Reports and Backend Development (Data Model).
• The reports are based on the FI-GL, AR, AP and CO. Accordingly, I have activated Business Content appropriately. Modified the DSO, Infocubes and MultiProviders as per the reporting requirements. Modified Transformations with Currency conversion logic to populate the custom key figures based on Budget, Management, Reporting Currencies, using complex ABAP code.
• Extracted data and Performed Unit Testing.
• Created Bex queries for the DPE reports. Unit Tested, Transported the Objects to Test Systems, Coordinated with Users for Integration Testing, Performed Go-live tasks, resolved any issues after Go-live.
• Created necessary Documentation like Technical Specs, Test Scripts etc.

Environment: SAP BI, SAP ECC, Bex, WAD, report designer.

Confidential, Richardson, Texas

SAP BW Developer

Responsibilities:

• Prepared Documents for the Functional Specifications according to user requirements.
• Analyzed and Activated Business Content for Infoobjects as available.
• Created & Maintained Custom Info objects, Info cubes, ODS, Data sources, Info sources and Info packages.
• Created Infospoke for Infocubes to distribute data from BW into flat files. ABAP Transformations Start and End routines.
• Extracted data using transformations for BADI to transfer into Target Structure and included Infospoke in Process Chains.
• Tested the Outbound Files that has been created in application server and Analyzed the Data.
• Performed Unit Testing for the Development and Documented the Results.

Environment: SAP BW 3.5, SAP R/3 4.7

Confidential, Germantown, Maryland

SAP Senior BI consultant

Responsibilities:

• Performed GAP Analysis, Designed the Data Model. Prepared Technical specifications.
• Analyzed and Activated Business Content with all its Dependent Objects like Info objects etc. based on the requirement.
• Designed and developed Custom Info Objects, Infocubes, DSOs, Multiproviders, Datasources, Infopackages, DTP and Transformations.
• Created Process Chains to Automate the Data Loads.
• Created multiple Bex Queries using Filters, Structures, Restricted key figures, Calculated key figures

Environment: SAP BI, SAP ECC

Confidential, Plano, TX

SAP BI lead / Onsite coordinator

Responsibilities:

• Provided Post Implementation Production Support includes Monitoring the Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting the Data Load Errors
• Resolved Tickets Raised by Users.
• Enhanced the Existing Reports based on User Requirements to include New Functionality.
• Extracted data from both SAP and Non SAP source systems like Teradata.
• Worked on DB connect to extract data from Teradata.
• Created Generic extractors for custom table and loaded data into BI.

Environment: SAP BI 7.0, SAP ECC

Confidential, Holland, MI

SAP BW developer / Onsite coordinator

Responsibilities:

• Provided Production Support activities like monitoring the Process Chains for Data Loads.
• Requirement Analysis and Understanding of Technical Specifications for Development of New or Enhanced Queries
• Checked for the Inbound Files Received and uploaded those files into BW.
• Analyzed the Bex reports for the Correctness and Accuracy of the data and send those reports to users.

Environment: SAP BW 3.5, SAP R/3 4.7

Confidential

SAP Consultant

Responsibilities:

• Requirement Analysis and understanding High Level design and preparation of Technical Specifications.
• Worked extensively on action related programs (Includes coding in User-exits of customized program).

Environment: SAP R/3 4.7

Confidential

SQL/PL-SQL Developer

Responsibilities:

• Requirement Analysis and Understanding High Level and Detail Level design
• Coding and Testing
• Analysis of the reports and send reports to higher authorities.
• Worked on coding to display oracle reports and forms using SQL and PL/SQL.

Environment: Oracle 8i, Developer 2000, Forms 4.5, Reports 2.5, SQL, PL/SQL