PROFESSIONAL SUMMARY:

• SAP BI/HANA Developer with over 8+ years of experience in Design and Development involved in planning, design, implementation, troubleshooting and performance tuning support using the ASAP methodology.
• Experience in Requirement gathering, Gap analysis, Design, Development, Testing, Documentation, Maintenance, Troubleshooting and Performance tuning.
• BI Design - Infocube design, Infosources, InfoObject maintenance, ODS objects, Infosets, Hierarchies, Multiproviders, Update rules, Transfer rule, Info packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
• Expertise in ETL - Data Extraction, Data Loading (Full/Delta Up-Load), and Transformations such as SAP BI and Informatica.
• Modeling & Customizations - Extensive experience in data modeling using BW extended star schema and entity relationship model. Involved actively in enterprise data warehousing (EDW) strategies. Worked on activating standard Business Content, extending the delivered structures and enhancing data sources according to business requirement.
• BEx Reporting - Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Business Objects - Excellent experience in designing Business Objects universes, Xcelsius/Dashboard, Complex Web Intelligence Reports and Crystal reports.
• SAP HANA 1.0 Certified with extensive knowledge of Modeling in SAP HANA studio, Data Provisioning, and User Management. Created Attribute, Analytic, Calculation Views, and CDS views.
• SAP HANA SQL SCRIPTS - Strong experience on Creating SQL, Stored Procedures with SQL Script and with Calculation Engine (CE) functions and Debugging SQL Script.
• Experienced in SAP HANA 2.0 native Design and Developments, Cloud Analytics, HANA 2.0/ BW mixed scenarios as Data Modeling, ECC HANA Live views provision with detailed systems design.
• Data Provisioning using SLT, DXC, SDI, SDA, and Data Services into SAP HANA.
• Worked on BW 7.3 platform, designing technical specification documents using the new info providers like SPO, Hybrid provider, Analytical Index, Transient provider & BWA.
• Extensive Experience in testing Extraction, Transformation and Loading (ETL) mechanism-using Informatica.

TECHNICAL SKILLS:

ERP: SAP R/3, ECC 6.0. 4.7.

Data Warehousing: SAP BI 7.3, 7.0 & 3.x, SAP HANA 1.0, SAP BO, SAP BODS, IP.

SAP Modules: FI, CO, HR, SD, MM & SCM.

Reporting Tools: BEx, Query Designer, BEx Analyzer, Business Objects XI 3.x, 4 .0.

Operating System: RHL, Windows NT/XP.

Databases: DB2, Oracle, & SQL.

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Consultant

• Involved in collaborating with Client managers, DBA’s, reporting team, Business users and other stakeholders to understand SAP HANA 2.0 and the existing landscape.
• Experienced in SAP HANA 2.0 native Design and Developments, Cloud Analytics, HANA 2.0 / BW mixed scenarios as Data Modeling, ECC HANA Live views provision with detailed systems design.
• Imported Selective Metadata for SAP BODS 4.1 imported Metadata in the ETL process prior to on boarding data into SAP HANA, created schemas and data provisioned using SAP LT Replication Server SLT.
• Developed Business Object Data Services BODS 4.1 jobs to pull external data from Flat files and Oracle into HANA 2.0 database.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the Calculation views as final model in HANA 2.0 studio.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical specifications.
• Created master data objects as Attribute views, joined multiple master data table depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support, multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created Calculation views using database tables, attribute views and analytic views, to address complex business requirements created SQL Script based Calculation views.
• Experience in ETL i.e. Data Extraction, Data Transferring, Mapping, Data Loading such as SAP BI and Informatica.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA 2.0 studio.
• Involved in creating story boards using SAP Lumira and publishing stories in Lumira server.
• Created Database for Supply chain and Inventory executive dashboards using Design Studio.
• Created reports in Lumira to handle huge volume of data in real time for analysis. Developed dashboard reports using SAP Lumira to include all the required KPI's.
• Integrating HANA 2.0 views with Reporting tools like SAP Lumira, Web Intelligence, IDT and Crystal Reports, Design Studio for BOBJ.

Confidential, Houston, Texas

SAP BW/BI Analyst

Environment: SAP ECC 6.0, SAP NW BW 7.3, SAP BOBJ, SAP HANA 1.0, ABAP and Big Data- Hadoop

• Implemented 3 full lifecycle including Gap Analysis, Blue-Printing, Reporting and integration to BO reporting tools like WEBI, Dashboards, and Analysis for Office/Analysis edition for OLAP.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created a custom complex Procurement Procure to Pay (P2P) and epayables report key metrics like Vendor evaluation, Invoice paid late, Average PO Processing time, Spend Captured in MM, System created PO, Invoice Processing time and Rate Validation to increase process efficiency and maintain compliance.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information Design tool).
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based).
• Defined technical structures to facilitate SAP BI metrics project for Procure to Pay (P2P) reporting and dashboard to meet customers analysis requirements.
• Developed and conducted manual and automated tests in HP Quality Center; coordinated user acceptance testing-created the test scripts in excel, consulted with the users and captured results; worked within project scope and met milestones; conducted functional testing in production client for go-live.
• Handled tickets related to production system issues.

Confidential

SAP BW/BI Developer

Environment: SAP ECC 6.0, SAP BI 7.0- Xcelsius, Crystal Reports & WEBI, FI, ABAP and BEx Suite.

• Designed and Developed write optimized DSO's for EDW layers and standard DSO for the consolidation layers and created a direct update DSO's by activating Business content for Accounts Payable (AP), Account Receivable (AR).
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement and enhanced the business content data sources by appending structures, User Exits and customized delta.
• Created Transformation mappings, DTPs, Info packages for all above DSOs and performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and Cube compression.
• Worked on Accounts payable and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
• Design, code, and test various ABAP user exits in BW for extraction, jump queries, variables, and OLAP virtual characteristics and key figures.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Transformation Routines, Start Routines, and End Routines as per the requirement and for the lookups from one DSO to other data targets. Testing and Debugging of routines.
• Involved in Query performance analysis and tuning through data model, query definition, Aggregates, OLAP Cache, and Database Statistics.
• Created BEx queries for reporting on InfoCube, ODS, and Multiproviders.
• Published the reports on the web using Web Application Designer using the wizard as well as drag and drop web items like ad-hoc, table, and filter for creating customized web templates according to the user requirements.

Confidential

SAP BW/BI Developer

Environment: SAP BW (3.5), SAP Netweaver 2004s (BI 7.0), SAP R/3 ECC 6.0, BEx Analyzer, WAD, FI/CO, ABAP Enterprise Portals.

• Involved in 3 full life cycles of the project in Technical design. Carried out the requirement analysis with users.
• Implemented SAP BI 7.0 for SD, PP, MM modules.
• Involved in analyzing and designing the data from ECC to BI and responsible for deployment.
• Responsible for design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO Cockpit extraction methods.
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 02 HDR and populated into the Infocubes 0PUR C07, 0PUR C08, and 0PUR C09 to evaluate service levels.
• Performed LO-Cockpit on Header and Line item data from the Sales and Distribution(SD) modules (Sales Order "2LIS 11 VAHDR/VAITM", Shipping/Delivery "2LIS 12 VCHDR/VCITM") and (Billing "2LIS 13 VDHDR/VDITM").
• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded these files to BPC for Planning, Budgeting, Forecasting and Consolidation.
• Developed and maintained the objects necessary for loading Master and Transactional data staging to PSA, DSO and Info Cubes.
• Worked in ABAP routines - Start routine, End routine and Expert Routines in transformations - written codes for master data look-up, filtering data from source package, used function module for various conversions, etc.
• Created reports like confirmed quantity, item purchase orders and purchase order values.
• Published reports on the web using Web Application Designer using the wizard and web items like ad-hoc, table and filter for creating customized web templates according to the user requirements.
• Extensively created Variables, Conditions, Exceptions, Exception Aggregation, Customer Exit Variables and Structures for developing complex BOBJ reports.
• Created Dashboards in Xcelsius reports on purchasing data and periodic plant stock and published on Infoview and provided access to the end users.