Deepak Rastogi Email & Phone Number

Anchorage, Alaska Area

• Lead the project as a technical expert in SAP BusinessObjects upgrade from BO XI R3 to SAP BusinessObjects 4.2 SP3 Patch Level 4• Prepared the entire set of documentation for Project Execution Plan, Project Plan, Costing and Resource Estimation, Disaster Recovery Plan, etc.• Pivotal in collecting the requirements, understanding the users issues related to BO Governance and provided a BusinessObjects Governance Plan• Installed, configured and BO on Dev, QA and Prod environment• Installed and configures Apache Tomcat WAS, Configured cluster for another node for scheduling• Migrated BO content from old landscape to new landscape. Performed Rationalization and promoted BI content from Dev to QA by using Promotion Management tool• Suggested the back methods and used LCMBIAR to backup BI content• Configured Single Sign-On and also configured SAP Authentication• Prepared test scripts for end users for UAT • Provided training to BO team for a smooth transition for support

Southfield Mi

• Lead the project as a technical expert in SAP BI / HANA solution architect with an offshore/onshore team• Prepared the project plan, projected estimations and highlighted resource requirement for the entire project• Pivotal in collecting the requirements, understanding the complex architecture and providing a viable solution• Architected the POSDM BW solution are the USI acquisition from legacy system to HANA system by applying reverse engineering concepts• Enabled LSA++ concepts when implementing POSDM, Inventory Discrepancy and POS Reconciliation and Error solutions • Used the new features including Advanced DSO, Composite Providers, HANA views, etc• Arranged meetings with customer for requirements gathering, BI workshops and within BI team on daily, weekly basis and on need basis• Prepared high-level and detailed logical, physical database and process level designs using MS Visio• Converted BEx queries into SAP BusinessObjects reports using Analysis for Excel and WebI and published them on BI Launchpad• Created new data visualizations and dashboards stories using Tableau and SAP Lumira/SAP Design Studio• Used extensively the CSS templates, modified them, Scripting using local and global scripts, Processing groups and variables in the Design Studio• Used SAP HANA XS in order to consume data from Calculation view and convert that into a Heat map• Advised on creating row-level, application level and functional level security for users and where it will be more affective • Well-versed in FI, MM, Logistics, Sales and Distribution data model in BW and HANA

Louisville, Kentucky Area

• Corrected hierarchies ZEXP_SUM, ZCOAGR_ALL, ZALL_HOSP and then extracted from R/3 and then placed them in process chain for daily update.• Enhanced DataSource ZEMPLOYEE_ATTR to add fields and Key figure and populated it with function module ABAP code in CMOD.• Developed a code in BAdI for InfoSpoke by following OSS note 856619 to put the negative sign in the front.• Used and created Structures (local and reusable), Restricted Key Figures, Calculated Key Figures to show• Annual Budget, MTD and YTD Actuals, Encumbrances, Available Balance.• Installed variable from Business Content and had it transported to production environment as needed by the user.• Developed hierarchy to incorporate different ranges of GL accounts in each commitment item for every Funded Program.• Designed and Modeled in InfoCube and ODS data model changes to incorporate certain fields in the reports they were not originally in those data targets.• Prepared documentations for Data models that were developed for FM, SL, HR, GM, and GASB.• Prepared documentations on maintenance of GASB data model.

Lexington, Kentucky Area

• Worked extensively on BEx Analyzer (RRMX) and created queries using BW-Reporting Variables, Navigational attributes and Filters.• Developed workbooks, InfoSet Queries and used RRI jump queries to drill down to other queries using RSBBS.• Extensively used calculated and restricted key figures, restricted characteristics, structures (local and reusable), variables and conditions for the queries.• Developed queries on Internal Order and Funds Management cubes, ODS's as per the client's requirement.• Worked on Internal Order OPA_C11, OPA_O01, O06, O07 and O08 and Funds Management/Budget Control Systems ZPU_C02, ZPU_O31, O32, O33 and O43 (to get Budget and Actual) incorporated in these reports.• Enhanced DataSource with fields that were needed for these reports like REFBN and REFB were added to the cube and mapped appropriately to each of the update rules.• Customized workbooks to the needs of clients. Used all the formatting functions to incorporate company logo, real-time refreshing of the header details, etc.• Transported reports from BWD to BWP after QA performed by creating requests and published to roles folder.• Trained 9 power users on how to design queries using BEx.• Trained about 15 end-users to logon and run reports from web.