SUMMARY

• Highly analytical and a productive professional with over 14+ years of experience in IT.
• 12 years of experience in SAP BW/BI/BO (4.1), and ABAP in relation to BW (3.0, 3.5)/BI (7.2/7.3) with SEM BPS/IP.
• SAP Techno/Functional NetWeaver (v. 2004, 2004s, EP6.0, ECC 6.0) consulting experience. Worked with Webi based Business Objects reporting.
• Excellent in developing an engagement plan that identifies the gaps between the baseline and the target goals, and taking specific action required to achieve the project objectives.
• Was involved in the migration process from BW 3.5 to BI 7.3. Involved in workshops, Data Modeling, Customizations, Business Content and Blueprint Documentation. Support Projects in SAP BI 7.3, BW 3.5, BPS, BPC, Integrated Planning and BOXI 3.0/4.1

TECHNICAL SKILLS

Business Areas: FICO, MM, SD, HR, P2P, PO, PS, IP, T&E, SEM, BPC, BO and ASAP/Solution Manager Methodology.

Extraction: Extraction of data from FI/CO, MM, SD, SEM, LO Cockpit,Generic data sources, SQL Server and Flat File data loading (Full/Initialization/delta upload).

Modeling: Extended Star Schema models, Entity Relation ship modeling (ERM) and Multidimensional Modeling (MDM), Universes.

Gap Analysis: For business to find the requirements and suggest for the best possible solution for the Enterprise.

Business Content: Analyzing, installing and using business content objects based on the project requirements.

Process chain: Event management for Automation process.

Performance tuning: Well versed with Partitioning, Setup Statistics and activation, Index Creation, Cube Compression, Reconstruction, and Creating Aggregates. Resolved performance issues with the help of BW Statistics cubes and queries.

Reporting: Expertise in front - end Business Warehouse Components like Queries, Workbook, Calculated key figures, Restricted key figures, Variables, Exceptions, Conditions, RRI and Jump queries, Web intelligence, Business Objects.

BEx: Extensive experience in BEx Analyzer, BEx Query Designer, BEx Browser and BEx Web Application Designer (WAD) in building Queries.

Web Reporting: Developed web reports, web items, customized web templates using web application designer.

BO: 4.1 webi reporting using BICS connectivity

HANA modeling: Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.

BODS: Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.

Customization: Hands on experience in design and development of Info objects, ODS, Info Cubes, Multi Providers, DSO, DTP, Transformation, Info Sources, Info Package, Transfer/Update rules, Communication Structure, Hierarchies and Business Contents.

ABAP: User exits, Routines, Extractor enhancement.

Planning: IP - Experience in the planning and simulation modules (SEM) PS and IP

DB: Extensively used MS Excel skills including PIVOT tables and VLOOKUPs.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Environment: SAP BI 7.3, BO (4.1), HANA, ECC 6.0, BPC, Oracle, FICO, PUR, SD, Logistics (Extraction) modules, Fox Formulas, Sql Server, BEx Query Designer, WAD and BEx Analyzer

Responsibilities:

• Configured Central Repository, Profiler Repository and added User roles
• Implemented SCD Type 2 Concept for Large Volume Data
• Configured SAP Application Data Stores and SAP BW Source Data stores
• Worked on Management Console for Job Scheduling, Tracing, Monitoring, Editing Repositories, Job Servers
• Performed Elementary Job analysis from Operational Dashboards and generate documents from Auto Documentation in Management Console
• Good knowledge on Transforms & Custom function.
• Worked on Data quality(data cleansing, standardization, duplicate entries) with larger Data volume
• Performed Validation, Enrichment, Data staging
• Used almost all the transforms from Data integrator, Platforms, Data quality
• Wrote Scripts, Custom Functions with Global Variables
• Used most of the String functions, lookup functions, Aggregate functions Mathematical functions
• Performed Loading through BAPI/IDOC/LSMW.
• Data Modeling: Creating and managing the Info Areas, Info Object catalogs, InfoObjects, Info Cubes, ODS objects, Info sets, Multi providers, Application components, data sources, DSO Objects, Transformations, Info package, Transformations, Migration, Re - Modeling, Object Transportation, DTPs, Open Hub Services, Process chains and managing PSA.
• Data Extraction: LO Cockpit Extraction, CO-PA, Flat File Extraction, Activating and transporting Data sources, Deleting contents of setup tables, Customizing and Enhancement of Extract structure and Master Data extractions from R3 to BW.
• Extensively worked on FI-GL, LO Cockpit, CO-PA, Generic Data Source, DB Connect customization and extraction.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits, BADI.
• Involved in review for various objects and created test case and test plans in different environments.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with ABAP programmers in creating ABAP codes for Transformation routines.
• Performed Master data and Transaction data extractions (SAP, Non-SAP) and automated the data loads using Process Chains.
• Created Process chains for parallel data loads, and scheduled them at off-peak hours to reduce the system load.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Developed various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical and Calculation Views.
• Development of an overall design, development and implementation of SQL scripts, stored procedures, cursors and triggers.
• Experience utilizing SAP Landscape Transformation (SLT) for real-time (and non-real time) data replication from SAP ERP or non-SAP systems
• Analyzing the all the releases of SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, and system integration.
• Involved in tickets logging regarding extractions, Performance Issues and also load failures.

Confidential, New York, NY

Environment: SAP BI 7.3, BO (4.1), HANA, ECC 6.0, SRM, SEM (IP), Oracle, FICO, PUR, SD, Project Systems, T&E (Travel and Expenses), Logistics (Extraction) modules, Fox Formulas, Sql Server, BEx Query Designer, WAD and BEx Analyzer

Responsibilities:

• Designed and developed custom DataSources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• Designed the data flow for Service Level - Purchase Order Quantities and Purchase Orders.
• As part of the performance tuning created aggregates for info cubes.
• Extensively worked on FI-GL, LO Cockpit, CO-PA, Generic Data Source, DB Connect customization and extraction.
• Involved in review for various objects and created test case and test plans in different environments.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with ABAP programmers in creating ABAP codes for Transformation routines.
• Performed Master data and Transaction data extractions (SAP, Non-SAP) and automated the data loads using Process Chains.
• Created Process chains for parallel data loads, and scheduled them at off-peak hours to reduce the system load.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Developed various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical and Calculation Views.
• Development of an overall design, development and implementation of SQL scripts, stored procedures, cursors and triggers.
• Experience utilizing SAP Landscape Transformation (SLT) for real-time (and non-real time) data replication from SAP ERP or non-SAP systems
• Analyzing the all the releases of SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, and system integration.
• Developed real time Infocubes for IP Planning such as Sales Planning, Cost Center
• Planning, and Forecasting and Balance Scorecard with integration of SEM with BW
• Resolution of BW problems relating to data load and mismatch of data.
• BICS connectivity BEx and BO: Worked with Web I for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts, Connecting BOBJ using SAP and Oracle for reporting, and involved in Webi connectivity with BICS connection.
• Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.1 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.Created Technical specifications and standard modeling documents for HANA.
• Involved in SAP BI security.
• Xcelsius: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Crystal Reports: Planned, created formatted reports, multiple groups, Integration with SAP Data Source, manipulation formulas, applying conditions and exporting reports to Excel and Word.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used Structures, Calculated key figures, restricted key figures, selection, Formula, exception and conditions.
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE.
• Developed prototype and presented the demo session and involved in training business users for user acceptance.
• Involved in tickets logging regarding extractions, Performance Issues and also load failures.

Confidential, Woodcliff Lake, NJ

Environment: SAP BI 7.2, ECC 6.0, Oracle, HR/FICO/SD modules

Responsibilities:

• Understanding the As-Is business process (based on the business case and role plays)
• Preparation of Business Process Master List, To-Be documents.
• Experience with Gap analysis, development, customizations and implementation of SAP HR application with complete life cycle implementation for 1.5 versions.
• Analyze and understand HR - BI related business requirements, perform impact assessments & write functional specifications
• Monitor the SAP HCM, SAP BI roadmap, and industry trends to enhance HR/Payroll capabilities.
• Recommend SAP HCM global application solution architecture, providing options, costs and pro/cons.
• Develop the HR reporting and analytics architecture.
• Co-ordination with technical team for objects development and worked on HR workflows with workflow consultant.
• Support configuration of Infocubes, Multicubes, and DSO for Personnel Administration, CATT, Time Management, Payroll, Travel Management, Benefits and Staff Performance.
• Authorization design and coordinating with Security team for role build.
• Working in HR Master Data like Employee, Person Enhancements. Worked on Employee Performance Managements, Employee Headcount and Actions, Concurrent Payroll and Compensation modules, Benefits.
• Data Migration and Master Data upload in Cut Over phase through CRM and ECC systems.
• Understand business requirement through KT, helped in supporting the development of functional specifications, User Training manual and Technical documents.
• Functional testing of all web reports and closing all issued tickets.
• Backend Support for end-user clients in France.