PROFESSIONAL SUMMARY:

• Having 10.6 years of experience in IT industry, with 8+ years of in SAP Business Warehouse & Business Objects, HANA, BODS and 2 years in Microsoft .NET and Software Testing
• Experience in Implementation, Support, Maintenance & Development
• Involved in Analysis, Design, Development, Testing, Implementation and Support phases of the Projects for both SAP BW,BO,HANA, BODS and Microsoft .NET
• Extensively worked on BW Composite Provider, ADSO, Info Cubes, DSO Objects, Info Objects, Info Sources, Data Sources, Transformations, DTP’s, Multiproviders, Transfer rules and Update rules
• Good Knowledge in Generic extraction and LO Extraction
• Extensively worked on Web Analyzer and BEx Query Development for Reports creation.
• Experience in CO - PA extraction process and have reports built on it
• Proficient in handling errors error’s occurred during Profitability Analysis (CO-PA) data loads
• Familiar loading data to CO-PA data targets COPAo01B and COPA T02A
• Good knowledge in Creating Analytical, Calculation and attribute Views and generate reports in Business objects with to Native HANA.
• Exporting and Importing meta data in Native HANA and expertise in managing Native Hana modeling concepts
• Good knowledge with all the Data Provisioning techniques (SLT, DXC, and SAP BODS), Modeling constructs (Attribute, Analytic, and Calculation) and Reporting solutions (BOBJ Suite of tools) with SAP HANA information models as a source.
• Good Knowledge in handling the Business Objects modules Designer, Web Intelligence, Crystal Reports, Central Management Console and InfoView.
• Experience in handling the Business Objects modules Designer, Web Intelligence, Central Management Console and InfoView, Crystal Reports, Lumira and Design Studio
• Good knowledge in Universe designing, developing and generating complex, Adhoc Reports, Business views, List of values, reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. SME in Dashboards, Best Practices in Dashboard Design, KPI Formulation & Web Reporting, developing information spaces and exploration sets in BOBJ
• Involved in Business Objects Administration creating users and groups, scheduling reports, publishing reports, planning security, authentication and single sign-on in for the reports developed using Business Objects 4.2/4.0.
• Used Open Hub Services to push data out of SAP BI using BODS
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality in BODS.
• Used Data Integrator and Platform Transforms extensively in BODS
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP using BODS
• Exposure in Oil & Gas, Pharmaceutical, Retail, Telecommunication, Production and Sales Data Warehouses.
• Good analytical, problem solving, communication skills.
• Proficient in Data Analysis in BI
• Involved in Business continuity planning activities during unplanned shutdown
• Good knowledge in Eclipse based BW/4HANA & S/4 HANA

TECHNICAL SKILLS:

ERP Packages: SAP BW 7.0, 7.3, 7.4, ECC 6.0

Business Intelligence Tools: SAP Business Objects (WebI, Crystal reports Enterprise)

Data Visualization: BO Explorer, Lumira 1.31, Design Studio 1.6, Tableau 10

ETL Tools: BODS 4.1, 4.2, Business Objects Data Integrator

Data Replication Technique: SLT, DXC

Databases: SAP HANA 2.0, Native HANA Oracle 9i, SQL Server 2005

Microsoft Technologies: .NET 2005, C#

Programming Languages: ABAP/4-BW (Beginner)

PROFESSIONAL EXPERIENCE:

Confidential, Thousand Oaks, Ca

Environment: SAP BW7.4, BI 4.1, HANA, BODS 4.2

Responsibilities:

• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• Building Business Objects reports on HANA modeling constructs(analytic, Attribute & Calculation views)
• Enhancing the required objective in Native HANA
• Functional verification activities of Development, Quality and Integration systems
• Enhancing reports in LUMIRA and Webi
• Worked on linking Datasets and Building and Publishing Lumira Stories to BI Platform
• Created reports including formatting options such as Chart, Grouping, Sorting, Alerter, Ranking, Breaks, Sections, parameterized prompts.
• Involved in Unit and Integration Testing on reports and then exported them to Schedule Manager for Scheduling and Refreshing.
• Modified existing universes and WEBI reports as per Business requirements.
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible.
• Worked on Data integration transforms History preserving, Table comparision, XML pipeline
• Extensively used BODS Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Created BODS Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired Confidential
• Extracted larger volumes of data using ABAP data flow transform into HANA DB in BODS

Confidential

Environment: SAP BI7.0, BO 4.0,Native HANA, IP, BPC 10.0,BODS

Responsibilities:

• Involved in Confidential BW transition from IBM to CapGemini
• Handling priority/problem tickets/incidents/ housekeeping activities
• Monitoring and Scheduling process chains.
• Handling RFC’s through Service now tool
• SAP process area’s involved SD,CRM,HR, Treasury & Payments, Accounting & Controlling, Plant O&M
• Business Objects reports on HANA modeling constructs(analytic, Attribute & Calculation views)
• Created Data Visualization dashboards using embedded Excel sheet integrated with BEX Queries.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab and conditional display of groups, fields, and messages.
• Created, managed & formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Created various dashboard reports.

Confidential, Philadelphia, PA

Environment: SAP BI7.3, BO 4.0, BODS

Responsibilities:

• Involved in designing technical specification document for PES BW
• Involved in build phase of the project
• Developed BI data flows using FLAT file extraction
• Responsible for creation of test scripts and documentation
• Involved in Data Loading & Process chain Monitoring
• Involved in unit testing, test case reviews and documentation
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible
• Create various Reports by pulling the OLAP data from Data Warehouse like Sales of Products, by Region wise, Reports Based on time like Year, Quarter, Month, Week, Geographic reports and Comparative reports

Confidential

Environment: SAP BI7.3,BOXI R3,BODS

Responsibilities:

• Involved in requirements gathering, designing technical specification document for Project Systems Module
• Involved in BUILD phase and UAT phase of Project Systems Module(Master Data and Transaction Data)
• Responsible for creation test scripts and documentation
• Involved in planning and co-ordination of tasks
• Involved in Report testing, test case reviews and documentation
• Involved in unit testing, test case reviews and documentation

Confidential

Environment: SAP BI7.3,BO, BODS

Responsibilities:

• Involved in designing technical specification document for Confidential and Dataware House
• Involved in build phase of BGDW (Master Data and Transaction Data)
• Developed BI data flows using LSA methodology
• Involved in enhancing CRM & ISU datasources
• Responsible for creation test scripts and documentation
• Involved in Data Loading &Process chain Monitoring test case reviews and documentation
• Involved in unit testing, test case reviews and documentation
• Developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies.
• Most of the BODS transforms used Source Lookup, Case, Merge, and Sequence Generator, Query Transform, Map Operations, Table Comparison, SQL, and Validation Transforms
• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing.

Confidential

Environment: SAP BI7.3

Responsibilities:

• Involved in requirements gathering technical pre-upgrade and technical post-upgrade activities
• Responsible technical pre-upgrade and post-upgrade activities
• Responsible for creation test scripts and documentation
• Involved in planning and co-ordination of tasks
• Co-ordination in India with respect to testing
• Involved in unit testing, test case reviews and documentation

Confidential

Environment: SAP BI7.0, ECC 6.0

Responsibilities:

• Interacting with Business Analysts for Requirements Gathering and clarifications. Provided the weekly status update on Project Progress.
• Created Cubes, DSOs, Multiproviders, Infoset, Transformations, InfoPackages and DTPs.
• Involved in implementing logic at Start Routine level
• Created Process Chains for automating data load process
• Created Open hub for extracting data from info cube into Flatfile/table.
• Involved in developing Interaction Analysis Queries using Restricted Key figures, Calculated Key figures, Filters, Free Characteristics, and Variables.
• Worked on Report to report interfaces(RRI) to drilldown to detailed Report
• Involved in Transportation of all Objects like: InfoObjects, Query’s and DSO objects, Routines, Programs, etc. into BI test system after validation and testing the same in development.
• Prepared Project documents like Transport Checklist, Go-Live check list, Support document and Provided the Support to the Support Teams
• Created Unit Test Cases and Performed Unit testing
• Extensively Involved in System Testing and User Acceptance Testing

Confidential

SAP Consultant

Environment: SAP ECC 6.0

Responsibilities:

• Managed and created parameterization for KMAT material type and Points and contract type based on Sales organization/Distribution channels for below transaction conditions

Confidentia

Application Developer

Environment: C#, WINDOWS APPLICATION, SQL SERVER 2005

Responsibilities:

• Creation of (HLD) High Level Document from the Feasibility document
• Involved in preparing Detailed Design Document(LLD)
• Preparing Unit Test Plan and Unit Test Result document
• Decision making on UI design of new applications; Suggesting changes to customer
• Coding of the functionality from the Detailed Design Documents(LLD) document
• Database related activities and implementation
• Preparing Release Notes using open source software Wiki
• Writing scripts for database related changes
• Developing Windows Services, Web Services

Confidential

Developer

Environment: C#, ASP.NET, SQLSERVER 2000, JAVA SCRIPT

Responsibilities:

• Safekeeping is banking project to generate fee file for specific range of Canadian regions. Ontario, International and Quebec
• Developed on OPS Tools framework and modules are Excluded Accounts,Feefile Generation,TaxMaster,Confirmation Page, Fee file Generation Report.
• OPS Tools framework is designed with XML and WEB SERVICES using YDO0 DEV (sqlserver) as Database.
• Work flow of project: UI interface is user controls
• Excluded Accounts screen will display the previously excluded accounts, at the same time we can include these accounts for fee file generation.
• From Account Filtration page/Fee file generation page list of accounts are checked/unchecked with available checkboxes.Feefile will be displayed on Confirmation Screen as well as you can generate PDF report.TaxMaster which updates tax details GST,QST,HST for Ontario, International and Quebec regions