Experience

Alyeska Pipeline Service Company

• United States
• Oil and Gas
• 500 - 600 Employee

• Senior SAP BI Solution Architect

  • Mar 2015 - Present

  • 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 Show less



Federal-Mogul Powertrain

• United States
• Motor Vehicle Manufacturing
• 700 & Above Employee

• SAP BI/HANA Solution Architect

  • Feb 2012 - Jan 2015

  • 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 Show less



Office of the Controller and Treasury

• Louisville, Kentucky Area

• Senior SAP BW Consultant

  • Jan 2011 - Jan 2012

  • 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. Show less



Kentucky Medical Services Foundation, Inc.

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• SAP BW Consultant

  • Jul 2007 - Aug 2010

  • 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. Show less