SUMMARY

• Seasoned IT professional with years of experience in Managing and developing Business intelligence solutions, helping clients to embark right BI solutions strategy aligned with client’s business goals.
• Co - Founder season manager of day to day operations of IT services company.
• Having both technical and functional background in R3 gives ability to completely exploit BI/BW functionalities and address some of the challenging issues with BW effectively.
• Good exposure to SAP HANA and Business Objects tools. Worked on project that interfaces BO and SAP BW. Experience in Web Intelligence, Crystal reports, Universe designer and Xcelsius tools with SAP BW.
• Worked on SAP HANA Studio.
• Worked with various clients in diversified environment and infrastructure.
• Worked with users to analyze the specifications, designed ODS, Cubes, transformations, Update rules, reports, process chains, and mentored junior developers. Developed and tested data flow and reports with the end users and published reports on the portal
• Developed numerous BW/BI objects for various business scenarios with different SAP modules to support reporting needs
• Good knowledge of SAP BPC 10 embedded system and SAP BW/4HANA BPC 11
• Data modeling of SD, MM, PM/PS, FICO, SPL, CO-PA, PCA.
• Extensively used LIS structures ad LO cockpit
• Customization of extractors, transformations, End routine, Start Routine
• Queries building with Bex analyzer, web application designer
• Using BO for enhancing queries for dash board using Webi, xcelcius, crystal reports
• Highly experienced in using advance technology BI functionalities like open hub, infospokes, infosets and user exits.
• Excellent knowledge of ABAP
• Good Knowledge of SAP FI data and integration
• Worked on SEM, APO (DP, SNP).
• Developed project plans, white papers, and blueprints for the project. Part of the ETL process, developed/enhanced extractors in R3, Logistic cockpits, User exits for BW, Data modeling and performance tuning.
• Worked on ECC 6.0 Upgrade and Impact analysis on SAP BW system with unicode/non-unicode scenario

TECHNICAL SKILLS

E-Commerce Utilities: Mass Import, Cleanup and Staging server utilities.

Programming Languages: C++, Java 2

Internet Programming: Net Data Macros, HTML, Java Script, and JSP

Database Programming: ODBC, JDBC

Server-Side Programming: Servlets, EJB

Middle ware: RMI, IBM MQ Series

Editors: Visual Age for JAVA

RDBMS: DB2, Oracle.x, MS-Access

Front End Tools: D2K, Visual Basic.x

Operating Systems: UNIX (AIX), MS-Dos and Windows 95/98, NT

PROFESSIONAL EXPERIENCE

Confidential

Project Lead SAP Data warehousing practice.

Responsibilities:

• Defined the scope for FI, MM, IM, PP, SD, QM modules and activated the Business Content Datasources in ECC and BI Infrastructure, Reports.
• Helped clients to understand different BPC environment for planning. SAP BW/4HANA BPC 7,SAP 4HANA BW embedded BPC.
• Designed SAP BPC 10.1 NW Embedded Planning for multiple models.
• Activating BPC standard content for Cost center planning.
• Performed requirements gathering, GAP analysis, developed functional and technical specifications for various custom report including Daily Metrics, On time delivery and Goods movement reports
• Implemented the data extraction process on BI 7.0 that includes activating business content, enhancing Extractors, user exits using ABAP in ECC.
• Created InfoCubes, DSOs, transformations, Start routines, End routines (in ABAP), InfoPackages, DTPs and Process chains.
• Extensively worked on LO Cockpit data initialization activities.
• Developed complex query definitions involving variables with replacement path and custom exits using ABAP, CKF’s, RKF’s using the query designer.
• Participated in Architecture design and design review sessions
• Distributed data from BI system to Database tables and File systems using Open Hub Destinations (Infospokes)
• Worked on SAP BusinessObjects (SAP BOBJ) reporting using Universe designer, Webi, dashboards using Xcelsius.
• Worked on SAP Hana implementation strategies.

Confidential

SAP BI Architect

Responsibilities:

• Designed and developed COPA/Sales/FICO extractors
• Initiated BPC on BW implementation strategies.
• Designed Master data maintenance in BI
• Involved in ECC 6 upgrade and managed its impact on BI
• Designed new strategy for daily load and automated the process.
• Extensive training to all Users
• Designed reports using BO and designed new universe for SAP BI.
• Enhanced Profit center, cost center, Account hierarchy for specialized reporting

Confidential

Data ware housing Architect

Responsibilities:

• Managed and successful executed BI upgrade project, team of 6 people performing various tasks
• Migrate SAP BI solutions for Sales, Inventory and Finance information from BW3.5 to BI7 in global environment.
• Designing and implementing interface between third party systems like Data stage and in-house database
• Designed solutions for the business FICO and SPL
• Implemented multiple SAP BPC 10.0 Standard-, Financial-type Models: Expenses, GeneralLedger, Management Reporting, Analytics, Rates for the client on the SAP NW platform
• Working on BW and Business object interface project that enables to deliver web intelligence, crystal reports and xcelcius dashboards. Designed Universe from SAP BI OLAP data source and dispatched reports via info view.

Confidential

SAP BI Architect

Responsibilities:

• Design and develop data model in BW for CRM data. Designing staging area in BW for CRM data which helps in analyzing the opportunity information of dealers and sales person. This design will also help track the progress of sales using KPI to increase efficiency and achieve required sales target.
• Used Multilayer Operational data store and infocubes in BW with custom enhancements for capturing CRM and SAP ECC5 information.