SUMMARY:

• An innovative, forward - thinking, proactive professional having 12 Years of experience working in the Information Technology field with strong emphasis in SAP BW/BI, SAP Business Objects(Analytics), Business Object Data Services(ETL), Business Warehousing and SAP HANA 2.0, SAP ECC.
• Experience in SAP BW/BI (7.5, 7.4, 7.3, 7.0, 3.5,3.0b), SAP HANA 2.0, SAP Data Services 4.x Business Objects 4.x(4.0, 4.1), XI3.1 reporting applications Analysis, design, development & implementation of Computer.
• Proficient in HANA Modeling, Data Provisioning using SLT and BODS, DXC. Worked on creating Attribute Views, Analytical Views, Calculated Views and built reports using Analysis for Office, Webi Reports, Crystal, Dashboards, Lumira, and Tableau.
• Good in BW on HANA Modeling and Native HANA Modeling.
• Expertise in supporting high-end enterprise applications for various modules of SD, MM, PP, FI, PP, ISU, HR, QM.
• Hands on experience: Business Content Installation, AWB, InfoObjects, InfoSources, DataSources, InfoCubes, Hierarchies, Remote Cubes, Standard & Transactional DSO, Multi-Providers, InfoSets, Openhub, Transformations, DTP, Transfer Structures, Extract Structures, Transfer Rules, Update Rules & Routines, BI Accelerator, Open ODS view, Composite Providers, Advanced DSOs.
• Experience in OLTP extraction from SAP R/3 to BW using different extraction structures such as LO-Cockpit, Generic Extractors, Open Hub service, Flat file extractions of data
• Experience in identifying Performance bottlenecks in data loading, warehouse management & reporting.
• Implement and develop the SAP BW/ BI best practices and methodologies.
• Finance (Master Data, Accounting/General Ledger, Accounts Payable, Accounts Receivable, Billing, Revenue Recognition/ Deferred Rev, Time and Expense, Financial Planning & Reporting (Financial Management), Related BI reporting)
• Expertise in BW Reporting using BEx Suite, Web Application Designer, Ad-hoc queries, InfoSet queries, Jump analysis using RRI, Information Broadcaster, Conditions, Exceptions, Variables, Structures, RKF & CKF, Virtual KF’s, Workbooks, Ad-hoc Queries and Web application designer.
• SAP BI environment-BW on HANA and Native HANA, S/4 HANA along with BOBJ and BODS ETL Tools
• Hands-on experience in ABAP in building Routines, also Enhanced Data Source using advanced ABAP Technique BADI
• Evaluated statistical performance using BW Statistics. Experience in Performance tuning of queries using Aggregates, Rollups, Compression, Indexes & Partitioning.
• Acquainted with modeling and maintenance of Process Chains. Created and executed process chains to load the data into the InfoCubes and DSO objects and monitored the process chains on daily, weekly and monthly schedule of loads.
• Excellent experience in activating & enhancing the standard Datasources with structural changes & User Exits with ABAP coding, Extracted Data from Flat files & DB Connect source systems for legacy data.
• Expertise in Data extraction, Data modeling, Data loading, Reporting(SAP Bex, .
• Implemented SAP CRM Data Migration using SAP Business Objects Data Services and SAP AIO Best Practices templates.
• Experience in SAP Netweaver Visual Composer, SAP BO Reporting (Webi, Design Studio, Lumira and Crystal Reports, Tableau)
• Played key role in designing and implementing Data Quality, Conversion and Migration solutions using SAP BODS.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/7.0, UNIX, Sun Solaris 8, Red Hat Linux, HP-UX

Databases: Oracle 10g/9i/8i, SQL Server 2005/2000, SAP HANA 2.0,Tera Data 13.0

BI Tools: SAP Business Objects X I 4.1, 4.0/XI 3.1/ R2/6.5, SAP BI Launch Pad,Web Intelligence, Info View, Xcelsius 2008, Design Studio, QaaWS, Live Office, Crystal Reports, Dashboards, SAP Lumira, SAP HANA Studio. Oracle Reports 2.5/6i/9i/10G,, Hummingbird BI Query, Oracle Designer

ETL Tools: SAP BW 7.x, 3.5x, SAP BODS/DS 3.x/4.0/4.1

Case Tools: Erwin, ER Studio, Oracle Designer2000

ERP: SAP R/3, SAP CRM

SQl Editing Tools: MS Project, TOAD 6.5 and SQL Navigator 4.1, Lotus Notes PL/SQL Developer

Other Tools: Shell Scripting, Microsoft Visio, EDI, SharePoint, MS Project, TOAD 6.5 and SQL Navigator 4.1, Lotus Notes PL/SQL Developer, HP QC, SharePoint

Knowledgeable: Data Stage, Informatica

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW/BI Architect

Responsibilities:

• Proficient in HANA Modeling, Data Provisioning using SLT and BODS, DXC. Worked on creating Attribute Views, Analytical Views, Calculated Views and built reports using Analysis for Office, Webi Reports, Crystal, Dashboards, Lumira, and Tableau.
• Good in BW on HANA Modeling and Native HANA Modeling.
• Expertise in supporting high-end enterprise applications for various modules of SD, MM, PP, FI, PP, ISU, HR, QM.
• Hands on experience: Business Content Installation, AWB, InfoObjects, InfoSources, DataSources, InfoCubes, Hierarchies, Remote Cubes, Standard & Transactional DSO, Multi-Providers, InfoSets, Openhub, Transformations, DTP, Transfer Structures, Extract Structures, Transfer Rules, Update Rules & Routines, BI Accelerator, Open ODS view, Composite Providers, Advanced DSOs.
• Experience in OLTP extraction from SAP R/3 to BW using different extraction structures such as LO-Cockpit, Generic Extractors, Open Hub service, Flat file extractions of data
• Experience in identifying Performance bottlenecks in data loading, warehouse management & reporting.
• Implement and develop the SAP BW/ BI best practices and methodologies.
• Finance (Master Data, Accounting/General Ledger, Accounts Payable, Accounts Receivable, Billing, Revenue Recognition/ Deferred Rev, Time and Expense, Financial Planning & Reporting (Financial Management), Related BI reporting)
• Expertise in BW Reporting using BEx Suite, Web Application Designer, Ad-hoc queries, InfoSet queries, Jump analysis using RRI, Information Broadcaster, Conditions, Exceptions, Variables, Structures, RKF & CKF, Virtual KF’s, Workbooks, Ad-hoc Queries and Web application designer.
• SAP BI environment-BW on HANA and Native HANA, S/4 HANA along with BOBJ and BODS ETL Tools
• Hands-on experience in ABAP in building Routines, also Enhanced Data Source using advanced ABAP Technique BADI
• Evaluated statistical performance using BW Statistics. Experience in Performance tuning of queries using Aggregates, Rollups, Compression, Indexes & Partitioning.
• Acquainted with modeling and maintenance of Process Chains. Created and executed process chains to load the data into the InfoCubes and DSO objects and monitored the process chains on daily, weekly and monthly schedule of loads.