SUMMARY:

• Over 14 years of experience in SAP Business Warehouse (BW) including 6 complete life cycle implementations ; Over 8 years of SAP BOBJ (4.0/4.1) experience including 4 Implementations; 5 years of experience in SAP HANA with 4 Implementations.
• Extensively worked with modeling aspects in SAP HANA Studio, Integration of SAP HANA to SAP Business Objects, SAP HANA Life Cycle management (HALM), CTS+ & CHARM.
• Experienced with SAP S/4 HANA,SAP Simple Finance,SAP HANA Live, BODS,SLT and BOBJ suite of products.
• Worked on SAP S/4 HANA that is managed on a private cloud environment - HANA Enterprise Cloud (HEC).
• In depth working experience with SAP BOBJ Web Intelligence, Explorer, Lumira,Office Analysis and Design Studio
• Extensive experience in working with SAP Design Studio Dashboards with rich User experience using SAP HANA
• Excellent understanding and hands on experience with Security - HANA & BOBJ.
• Expertise in troubleshooting Performance issues - Statement performance;
• Application Performance and worked with Query Plan Analysis - Explain Plan & Visualize Plan
• Extensively worked on Performance tuning techniques on HANA using Input parameters, Efficient joins,projection nodes etc.
• Experienced with Smart Data Integration (SDI) & Smart Data Quality (SDQ) with HANA
• Worked on SAP Vora system which is built on Hadoop ecosystem
• Accessed Hadoop (Vora) data from SAP HANA through SAP HANA Spark Controller
• Expertise in handling the Cutover tasks - Pre and post migration tasks, fixing the transport failures,working with Security and Basis teams to resolve any issues.
• Expertise in User Requirements gathering,Writing Functional & Technical Specifications.
• Worked extensively on SAP Functional Modules: FI,CO,SD,MM,SCM, HR,CRM&SRM.
• Heavily experienced in all aspects of SAP BW Modeling,Data extraction and Reporting.
• Worked with SAP to deliver BW courses - BW305, BW310,BW330,BW365 to its customers.
• Trained several Business Users on how to work with Analysis for Office and Business Objects Explorer.
• Worked on the Agile/Scrum methodology both as a Scrum master and a member of the team.

TECHNICAL SKILLS:

SKILLS: SAP ECC 6.0, SAP NETWEAVER BI 7.0, 7.3,7.4, SAP HANA

BOBJ: Web Intelligence, Design Studio, Explorer,Information Deisgn Tool (DT),Office Analysis,Lumira,Crystal Reports,Central Management Console (CMC).

BEx: Query Designer, Analyzer, Web Application Designer.

PROFESSIONAL EXPERIENCE:

Confidential

Senior SAP HANA BI Architect

Responsibilities:

• Currently working on Native SAP HANA as well as on SAP BW on HANA environment
• Evaluating existing legacy reports and see if SAP HANA or SAP BW on HANA is right fit
• Worked on migration of 1.x SAP Design Studio and SAP Lumira dashboard reports to 2.2 Lumira Studio and Lumira Discovery
• Built PO Contract closeout report and Document History summary reports using Design Studio 2.2 version and built Bidder Analysis Dashboard using Lumira Discovery 2.2
• Worked with SAP to resolve some of the migration issues from 1.x to 2.2 Lumira
• Working on improving the performance for SAP HANA models and Lumira dashboards
• Well versed in understanding the bottlenecks for the performance related issues in HANA and Business objects,applying end to end trace to analyze and improve performance of the reports

Confidential, Bedford, NH

Senior HANA BI BOBJ Architect/Developer

Responsibilities:

• Worked with BW 7.4 HANA optimized dataproviders
• Built Virtual and Composite Providers using SAP BW 7.4 dataproviders for Delivery Execution, Customer and Shipment requirements
• Built complex HANA calculation views to support all business requirements and functionalities.
• Built HANA Views to support finance Reports - Profit and Loss Statement,Balance Sheet.
• Built HANA data models to support logistics Reports - Sales Route,Delivery Route,Out of Stock reports
• Built Telematics Driver Analytics HANA view using SQLSCRIPT to support reporting requirements for business in understanding the daily routes/drivers/customer combinations
• Built reports using Analysis for Office and WEB Intelligence connecting directly on top of SAP HANA.
• Worked on performance tuning using the in built in tools Explain plan and Visualize Plan
• Worked on Tableau Dashboards using Tableau 10.3/10.4 and built Sales Analytics and Route analytics Dashboard
• Built Tableau dashboards for Custome Asset Management (CAM),Incomplete Orders dashboard,Broken Damages and Lost (BDL) dashboards
• Built several WEB Intelligence reports on Sales and logistics and scheduled them to end user community
• Trained business users on how to access the reporting tools and perform self service Analysis on the SAP HANA data models

Confidential

Senior HANA BOBJ BI Architect/Developer

Responsibilities:

• Worked with Office of Orphan Drugs and Products (OOPD) reporting requirements for Designations, Grants, Applications and PDC
• Explored the Universe that is built on the OOPD Oracle relational tables and built
• OOPD Designation Reports, Grants Reports using Web Intelligence Reporting tool.
• Involved in Post-go live support and Worked on Change requests for the OOPD reports
• Worked with Business Users from Office of Regulatory Affairs to gather requirements for ORA Dashboards
• Built HANA models required for supporting requirements for Dashboards
• Created complex calculation views to calculate various metrics like - Counts, Averages, percentages that are required for the graphs in the Dashboards
• Built a ranking mechanism to calculate the counts and other metrics only for the last 4 Wednesdays
• Worked on migrating the legacy Orphan Drugs and Products (OOPD) reports into SAP HANA
• Migrated Oracle tables required for Orphan Drugs and Products (OOPD) reports into SAP HANA
• Built SAP HANA Calculation views on top of Orphan Drugs and Products (OOPD) tables in SAP

Confidential, Birmingham, AL

Senior HANA BI BOBJ Architect/Developer

Responsibilities:

• Worked on SAP BW 7.3 to build Infocubes and load data for BPC related tasks
• Built SAP BW 7.3 Dataproviders for Sales reporting
• Built HANA Views related to FI - AP&AR, Customer Service,Delivery Performance
• Worked on fixing HANA model issues and enhancements
• Worked on improving performance of HANA models there by improved performance of the Business Objects reports
• Worked on SAP Business Objects Data Services (BODS) to integrate Sales history from SQL server to HANA System.
• Worked extensively on creating jobs using several BODS transformations and moved data from SQL to tables in HANA
• Worked with Smart Data Integration (SDI) to report on the data from SAP HANA system and Non-SAP systems
• Worked on SAP Vora system which is built on Hadoop ecosystem
• Accessed Hadoop (Vora) data from SAP HANA through SAP HANA Spark Controller
• Worked with Information Design Tool (IDT) to create universe for adhoc requirements and mase them available for reporting.
• Worked on SAP BOBJ Platform 4.2 suite

Confidential, NY

Senior HANA BI BOBJ Architect/Developer

Environment: SAP HANA SP10 REV 102; SFIN 7.0 SP3; SAP BW 7.3 SP9; SAP BOBJ 4.1 SP4

Responsibilities:

• Created SAP BW dataproviders with HANA views as input .
• Worked with SAP BW extractors for loading hierarchies/sets into SAP BW System
• Worked on Financial Transformation project with SAP Insurance Analyzer (IA), HANA,BW on HANA,S/4 HANA,HANA Live and BOBJ products.
• Worked on building an SAP Reporting (Insurance/Investments,Finance) Strategy across ECC,Simple Financials (SFIN),Insurance Analyzer (IA),SAP BW & HANA systems
• Worked with Business Leads in rationalization of the 500 plus reports and prioritizing them based on the KPIs required to meet business needs
• Architectured the reporting solution for FI GL, FI AR, FI AP, FI Fixed Assets
• Worked on SAP HANA Smart Data Access (SDA) features to access Insurance data from another HANA Instance.
• Worked on creating remote sources, Virtual tables to access tables/views from another HANA instance.
• Experienced with Smart Data Integration (SDI) & Smart Data Quality (SDQ) with HANA and several transformations related to SDQ.
• Worked with real time replication of SAP ECC data into SAP HANA with SDI
• Very good understanding on SDQ data sources,data sinks,template tables &transformations,Smart Data Integration (SDI) adapters
• Worked on SAP HANA Live for SAP Business Suite, Content View and BOBJ reports.
• Worked on SAP S/4 HANA that is managed on a private cloud environment - HANA Enterprise Cloud (HEC).
• Worked on SAP Fiori Applications for the roles - G/LAccountant;Accounts Payable and Receivables.
• Worked on Customizing the SFIN HANA live to support the finance business requirements
• Built Custom heavily customized HANA Views on FI GL FI AP Assets transactional tables For reporting purposes.
• Heavily experienced in creating Attribute,Analytic,Calculation views including script based views
• Extensively worked on HANA Studio in creating HANA views - Attribute,Analytic, Calculation views and several HANA features to implement reporting requirements
• Building SAP BOBJ Reporting solution with WEBI,Analysis for Office, including Visualization tools - Lumira,Explorer
• Worked on a Dashboard POC using BOBJ Design Studio 1.4 to evaluate the functionality.
• Responsible for collecting the all the HANA,ECC,BOBJ transports and worked with HANA CTS+ and CHARM transport mechanism using HANA Life cycle Management tool (HALM)
• Worked with SAP and built a best practice mechanism to handle ABAP and Non-ABAP transports.
• Worked with users during the Integration and UAT testing cycles by helping in writing the test scripts,resolving the defects that are logged.In the proces worked with HP ALM and Remedy tools.
• Worked on the Agile/Scrum methodology for the Release 1.1 (AP/FA) as a Scrum master and a member of the team.

Confidential, Greensboro, NC

Senior HANA BOBJ Architect/Developer

Environment: SAP HANA SP6 REV 61; SAP BW 7.3 SP5; SAP BOBJ 4.0 SP5

Responsibilities:

• Worked on HANA Side car implementation for FI module
• Architectured the strategy for implementing the SAP BOBJ tools - WEBI, Office Analysis,Design Studio
• Worked with SAP BW (on HANA) integration with Design Studio.
• Worked with Design Studio 1.2 on creating a Dashboard on Design studio to show the expenses by zone.
• Worked on SAP BODS to load data from non-SAP into SAP HANA
• Worked with several ETL features of BODS to accommodate the business requirements
• Activated the standard Technical content and maintained Process Chains for statistics
• Worked on product support for daily loads and query performance issues
• Worked extensively on fixing the issues related to SAP Business Objects 4.0 Web Intelligence and Office Analysis reports.
• Built Financial consolidated, Unconsolidated reports Interactive Analysis reports using various features like variables,formulas,Hyperlinks,Multiple datasources in WEBI.
• Extensively worked on Office Analysis, MS Edition and OLAP to built Consolidated unconsolidated and Limited Consolidated reports.
• Heavily experienced in using Information Design Tool (IDT) and built relational universes on top of SAP BW Dataproviders and used them in WEBI reports.

Confidential, Stamford, CT

Senior SAP BOBJ Solution Architect

Environment: SAP BW 7.1; SAP BOBJ 4.0 SP4

Responsibilities:

• Arhitectured the strategy for implementing the SAP BOBJ tools - WEBI, Office Analysis,Design Studio
• Solely responsible for analysing reporting requirements and recommended the appropriate tools depending upon the the requirement matrix developed.
• Worked with Users in finalizing the reporting requirements.
• Worked extensively on SAP Business Objects 4.0 Web Intelligence and Office Analysis reports and developed dashboards using Design Studio
• Built SAP Reinsurance Management (FS-RI) BOBJ Interactive Analysis reports. using various features like variables,formulas,Hyperlinks,Multiple datasources in WEBI.
• Heavily experienced in using Information Design Tool (IDT) and built relational universes on top of SAP BW Dataproviders and used them in WEBI reports.
• Worked on Design Studio 1.1 to create the Premium Volumes Dashboards where by users can see the top premium Customers and their volumes.
• Worked with all features of SAP Business Objects Design Studio.
• Worked with customizations on the Design Studio using Script editor as a work around to accommodate the requirements
• Worked extensively on the SAP Business Objects 4.0 Security:Folders,Access levels,etc and BOBJ Lifecycle Management Console (LCM).
• Created Custom access levels for Developers,End users and power users using SAP BOBJ 4.0 CMC.
• Worked on SAP BW Business content extractors for SAP Reinsurance Management (FS-RI) and their enhancements.
• Well versed with working on SAP BOBJ Integration SAP BW and BEx data.
• Experience with working on fixing performance related issues with BOBJ WEBI.
• Worked and resolved issues on SAP BOBJ 4.0 WEBI, Office Analysis.

Confidential, West Palm Beach, FL

Sr. SAP HANA BI BOBJ Developer

Environment: SAP HANA SP4 REV 46; SAP BW 7.1; SAP BOBJ 4.0 SP4

Responsibilities:

• Created Attribute Views, Analytical views and Calculation Views for Sales Analytics.
• Worked on Optimizing HANA Views - Analytical, Calculation views.
• Worked on building Dashboards, Explorer views on top of HANA views.
• Worked extensively on HANA SQL to customize and meet the requirements.
• Worked with different relational database features like Join types, Cardinalities.
• Worked on SAP BODS to load data from non-SAP into SAP HANA
• Worked with several ETL features of BODS to accommodate the business requirements
• Worked with SAP HANA SLT to bring data from ECC based on HANA Side CAR approach
• Configured advanced Replication settings like modifying target table structures, Specifying performance optimization settingsetc.
• Worked on building Transient providers on top of HANA Analytic, Calculation views and used them in composite providers for BEx reporting on BW on HANA.
• Heavily experienced in using Information Design Tool (IDT) and built relational universes on top of SAP BW Dataproviders and used them in WEBI reports.
• Worked and resolved issues on SAP BOBJ 4.0 WEBI, Office Analysis.
• Worked on Importing BW data models into SAP HANA for reporting on SAP BOBJ Explorer and Design Studio
• Worked on the HANA views (OLAP Views) as Data source in Design Studio to display the top selling products and Year over year growth.
• Worked with different features/components of Design Studio - Crosstabs, Script editor etc. in Design studio to accommodate the requirements.
• Worked with Design studio to deploy the reports on iPad via QR code option.
• Worked extensively on the SAP Business Objects 4.0 Security.
• Created Custom access levels for Developers, End users and power users using SAP BOBJ 4.0 CMC.
• Working on implementing HANA-BOBJ Security.
• Working on Upgrading BOBJ 3.1 WEBI reports to SAP BOBJ 4.0.

Confidential, San Jose, California

Sr SAP HANA BOBJ Developer (ECC on HANA side CAR)

Environment: SAP BW 7.1/7.3; SAP BOBJ 4.0 SP4

Responsibilities:

• Worked on HANA POC for Finance Treasury Project.
• Built Attributes Views with Hierarchies
• Built Analytical Views on top of Treasury tables based on HANA Side CAR approach
• Built Scripted Calculation views.
• Built Analytical privileges on the Analytical and Calculation Views to impose restrictions on User groups
• Built SAP BOBJ Explorer Information spaces and Viewsets on top of Analytical and Calculaton Views
• Built WEBI reports on top of Universes built on Analytical and Calculation Views
• Extensively worked with Variables and Input parameters.
• Experience with SAP HANA programming including SQL, SQL Script, and CEScript
• Worked with SAP HANA Administration including managing schemas, data model objects, import/export content.
• Worked with SAP HANA SLT to bring data from ECC to ECC on HANA on real time basis.
• Worked on advanced Replication settings like modifying target table structures, Specifying performance optimization settingsetc.
• Experience with SAP HANA Security including User Management, Roles, and Privileges
• Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW,HANA, BOBJ integration, etc.
• Loaded data into table definitions, suspending data loads, resuming data loads. Copying contents delivered by SAP.
• In-depth knowledge in processing information objects such as previewing data of information objects, validating models, comparing versions of information objects, generating object documentation.
• Monitoring and troubleshooting data loads in a large environment.
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins.
• Worked on BEx queries,SAP BOBJ Information Design tool, SAP BOBJ Explorer
• Built custom extractors on top of tables and used ABAP code to meet buiness requirements
• Worked on Bank Balance Prior day,Current day reports and Monthly Average Balance Reports.
• Worked with Calculated key figures, restricting key figures, filters, Structures, Variables, Conditions, Exceptions, Cell Editor, and Workbooks.
• Worked with SAP BOBJ WEBI Reports using the BEx queries
• Built a relational Universe on top of Monthly Average Balance Infocube and Customized the Universe to enable texts,Filters
• Built Information Space on top of the Relational Universe to explore Information using SAP BOBJ Explorer.
• Worked on the SAP BOBJ 4.0 Web Intelligence reports
• Built Executive Controller (P&L, Bal. Sheet,Act vs Forecast) SAP BOBJ Dashboard using WEBI reports,BEx reports.
• Extensively worked with connecting Universes,SAP BW BEx queries to Dashboards using Query Browser.
• Extensively worked with Charts and customzed them to meet requirements

Confidential, Santa Clara, California

Sr SAP BW Architect/Developer

Responsibilities:

• Worked with Inventory Management Datasources:2lis 03 bx,2lis 03 bf,2lis 03 um and Std Cube: 0IC C03.
• Working on Finance reports- FI GL and CO PA.
• Worked on generic extractors,complex transformations and ABAP code.
• Working on product support issues - PC failures /Broadcasting failures etc.
• Worked on Enahncing the HR time and Labor reports and extractors

Confidential, MN

Sr SAP BW Developer

Responsibilities:

• Working on International Finance Reports.
• Working on building Global Finance reports based on monthly currency exchange rates.
• Working on Variable exit ABAP code to derive the currency exchange rates.
• Working on building complex Financial BEx queries.
• Built SAP BO Crystal Reports using SAP BI Finance queries with Hierarchies and Structures.
• Worked with Query As Web Service on top of Universe built on SAP Datasources.
• Worked on new SAP BI implementation on FI,CO,SD,MM
• Worked alongside SAP BPC implementation and helped in feeding BPC the needed data from BI.
• Worked on enchancing the standard SAP FI GL, SAP SD extractors with ABAP code at the extractor level
• Worked with Inventory Management Datasources:2lis 03 bx,2lis 03 bf, 2lis 03 um and std Cube: 0IC C03.
• Built custom CO-PA extractors
• Worked on Product costing extractors/Infocubes and Reports.
• Worked on Profitabilty Analysis extractors (CO-PA)
• Worked on SAP FI totals extractor 3FI GL OL TT and new GL DSO 0FIGL O10.
• Created a custom DSO for FI GL totals and worked on transformations/keys of the DSO to handle data integrity which inturn is used by SAP BPC cubes.
• Enahnced satndard Sales Infocube with Delivery status/date,Marketing segment and Industry group.
• Built process chains monitored dataloads and fixed issues
• Worked with Xcelsius dashboards and displayed the summarized info and KPIs from Sales and Finance data.

Confidential, Deerfield, IL

Sr SAP BI BO Lead

Responsibilities:

• Extensively worked on SAP FI GL & CO-PA extractors.
• Worked alongside SAP BPC implementation and helped in feeding BPC the needed data from BI.
• Extracted the data from SAP BIs DSO to a file using Openhub and supplied the files to SAP BPC For further BPC uploads.
• Worked on enchancing the satndard SAP FI GL extractor,0FI GL 4.
• Built custom CO-PA extractors.
• Built Custom DSOs and Infocubes on top of SAP FI, CO-PA datasources.
• Worked on SAP CRM TPM Key Figure Planning (Trade Spends/Volumes),Baseline Sales Quantity
• Worked on the SAP CRM TPM Claims Management Reporting
• Worked with SAP CRM TPM conditions and rebates and reporting
• Extensively worked on ABAP routines.
• Interacted with the End users to understand the and implement the changes needed on the Finance and Controlling reports.
• Built process chains to load master data and transaction data and resolved data load issues.
• Soley responsible for all the transport migration to QA and production environments and fixing the issues.
• Worked on Open hub tool to push data out of SAP BI.
• Extensively worked on different features of BEx tools.
• Built Balance sheet, Profit&loss reports using BEX query designer.
• Worked with Query As Web Service on top of Universe built on SAP Datasources
• Created SAP BO Web Intelligence reports.

Confidential, Saint Louis

Sr SAP BI Lead

Responsibilities:

• Working on SAP BI Reporting requirements.
• Involved in gathering requirements from Users.
• Involved in Writing Functional and Technical specifications.
• Worked on Enhancing the standard CRM sales Contracts extractor, CRM SALES CONTR I.
• Worked with FI GL, FI AR and FI AP extractors and customized them .
• Developed custom extractors for meeting Leasing Dept. user requirements
• Heavily involved in ABAP coding while writing Start/End routines and performing lookups to populate the data for the fields related to the Leasing module.
• Worked on BEx query designer, BEx analyzer and Web Application Designer.
• Built complex BEx queries
• Built SAP BO Crystal Reports using SAP BI Finance queries with Hierarchies and Structures.
• Created SAP BO Web Intelligence reports on Companys Sales data: Sales revenue, Sales growth
• Worked with Query As Web Service on top of Universe built on SAP Datasources.
• Working with Xcelsius dashboards and displayed the summarized info and KPIs from Sales and Finance data.
• Involved in End user training on Reporting features.

Environment: SAP NETWEAVER BI 7.0, ECC 6.0; BEx, WAD

Confidential

Sr SAP BI Lead

Responsibilities:

• Working on SAP BI Sales Returns Reporting requirements.
• Involved in gathering requirements from Users.
• Involved in writing Technical design docs.
• Built Custom Infocubes and DSOs for Sales Returns tracking and Customer Tracking.
• Bulit Multicubes in an efficient manner to fulfill the reporting needs
• Heavily involved in ABAP coding while writing Start/End routines and performing lookups to populate the data for the fields.
• Built complex BEx queries using BEx Query designer features: Restricted Key figures, Calculated Keyfigures, variables.
• Extensively worked with Variable exit code inorder to provide more flexibility to the usage of BEx queries
• Worked with deploying the BEx queries to SAP BI portal
• Worked on SAP BI Roles and Authorizations and resolved Security related issues
• Worked on Product support issues.

Environment: SAP BW 3.5, SAP R/3, BEx, WAD

Confidential, NY

Sr SAP BI Lead

Responsibilities:

• Worked on Global Dashboard project on KPIS, Sales Analysis,and Cause Analysis reports.
• Loaded data from IMS files to DSO and and infocubes using complex transformations.
• Build Queries for Market Share and Underperforming Geographies using Exceptions an Cell Editor features.
• Build Web templates based on the Web Items- Tables, Charts, Dropwowns usinf WAD.
• Worked with Variable User exits for determining the Alignment period, Data set sequence and the Infocube for the reports on the Multicubes.
• Built queries and web templates for the Call Detail attainment,Calls to Target,Time off Territories.
• Implemented Security for the Global Vice presidents, Area Directors,Regional Mangagers and Divisional Managers.
• Heavily involved in preparing User training documents on reporting
• Loaded IMS data from Flat files to DSO's and Infocubes using transformations to implement Business Logic.
• Worked with CRM Call actvity extractor and enhancements
• Built Monthly/Quarterly Queries for Call Activity Summary and Call Activity Detail.
• Created Jump to Jump (RRI ) reports to jump to details on DSO.
• Built Web templates for the Call Activity reports and deployed them to portals.
• Implemented Security for the Global Vice presidents, Area Directors,Regional Mangagers and Divisional Managers
• Involved in preparing User training documents on reporting.
• Worked on Qlikview reporting tool to build flexible reports with consistent and very fast response times.
• Build Qlikview reports on Sales and Call Activity data that was fed from SAP BW DSOs.
• Extensively worked with Qlikview Charts,tables and graphs to enable graphical analysis on Call activity and Sales data.
• Build DSO's and Infocubes for NGPS weekly dats from IMS.
• Built APD Query on top of Multicube which calculates the ranks and stores in DSO which inturn populates the ranks as attributes to characteristics.
• Reports also calculates the New MD's prescribing the products.
• Worked with Analysis Process Designer (APD) to identigy classifications.
• Reports calculates the Change in Share of Products and Brands,QTD share, Baseline Share across all Area,Regions,Territories

Confidential

Sr. SAP BI Developer

Responsibilities:

• Worked with Inventory Management Datasources:2lis 03 bx,2lis 03 bf,2lis 03 um and std Cube: 0IC C03.
• Worked with Manufacturing datasources Work Center View from PP/PP-PI: 2LIS 04 ARBPL, Component View from PP/PP-PI:2LIS 04 P COMP,Material View from PP/PP-PI: 2LIS 04 P MATNR and custom ODSs. Involved in the design of SAP BW technical Design document.
• Involved in writing User exits to populate the data for Zfields added in 2LIS 04 ARBPL datasource.
• Involved in writing start routines, update rules, transfer rules to achieve the desired functionality.
• Involved in Creating Process chains for Master data and Transaction data.
• Worked with the QM Datasources 2LIS 05 Q0ACTY Quality Notifications - Activities and 2LIS 05 Q0NOTIF Quality Notifications.
• Involved in Transports, data load monitoring and resolving issues related.
• Worked with Calculated key figures, restricting key figures, filters, Structures, Variables, Conditions, Exceptions, Cell Editor, and Workbooks
• Worked on Query performance Tuning aspects.
• Involved in creating Y/Z queries for End users In production
• Involved in End user training on Reporting features.
• Involved in writing test scripts for BW Backend (data loading) and BW front end for SAP BW Upgrade project.

Environment: SAP BW 3.5, SAP R/3 4.7, BEx, WAD

Confidential, St Paul, MN

Sr. SAP BI Developer

Responsibilities:

• Involved in User requirements gathering.
• Worked with Business Analysts and SMEs to understand the Business Rules and Requirements.
• Involved in the design of SAP BW technical Design document..
• Involved in Business Content activation for CRM Master data.
• Worked with maintaining and loading multiple hierarchies from CRM to SAP BW.
• Well versed working with BEx query designer for creating queries and WAD for enabling queries to Web.
• Well versed with SAP BW Reporting Security and worked closely with Security consultant during the BW Security Proof of concept .
• Extensively involved in loading data from R/3, CRM, Flat files to ODS, Infocubes.
• Worked with designing BW Reports for drilldowns and filtering to meet the reporting requirements.
• Involved in the transports of R/3/CRM/BW objects.
• Monitoring and troubleshooting of daily/weekly/Monthly data loads.
• Worked on Non-SAP, CRM data sources into BW.
• Conducting classes for on BW 305 (SAP BW Reporting ),BW310 (SAP BW Data Modeling).

Environment: SAP NETWEAVER BI 7.0, SAP ECC 5, BEx, WAD, Information Broadcaster