PROFESSIONAL SUMMARY:

• More than fourteen years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including ten years of BI experience and more thanfour yearsof programming experiencein Application development.
• Good functional knowledge of SCM, SD, MM and FI modules.
• Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Use Case development, and Analysis & Organizational skills.
• Excellent analytical and logical skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the Software Development Life cycle.
• Good communication skills, interpersonal skills, self-motivated, quick learner.
• Very good experience of SAP BW Components like Info Cubes, DSO, Multiprovider, Info Source, Info Objects, & Transformation.
• Expertise in Data Modeling, Activity Diagrams, ETL, Business Objects, Data warehousing, SQL, Extended Star Schema, Data slice, Requirements Gathering.
• Expertise in performance tuning of BW systems. Evaluated statistical performance and improved data load performance, query performance by compression of InfoCubes, creating aggregates etc.
• Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created Aggregates for frequently used Queries.
• Excellent production support skills including data loads, reporting related Issues.
• Extensively involved in production support, expertise in process chains monitoring and resolving the support tickets.
• Good understanding of OLAP concepts and OLAP database environments.
• Unit, integration, performance testing and Participated in design reviews.
• Experience in connecting legacy system/Non-SAP System via DB connect, and pulling data in SAP-BI system.
• Experience in Stored procedures and writing SQL scripting in SQL server 2014.
• Experience of BOBJ tools like Crystal Report, Dashboard, Web Intelligence, Information design tool, Explorer, Design studio.
• Good understanding of creating BW on Hana database.

TECHNICAL SKILLS:

Business Intelligence: SAP BW 7.0, 7.3, 7.4 BO 4.0

ERP: SAP R/3 and SAP ECC 6.0

Reporting: BEx Report Designer, Web Application Designer (WAD), BEx Web Analyzer, BEx Analyzer, Dashboard, Crystal Report, Webi, MS Excel

Modeling tools: SAP HANA, SAP NetWeaver BW

Languages: ABAP, SQL

Database: SQL Server 2012/2014, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, NY

SAP BW Consultant

Responsibilities:

• Monitored, troubleshoot and resolve system issues, determine root cause analysis.
• Involved in architecture level support for existing and new reports.
• Implemented SCM BW reports for Delivery Assurance, Supplier category and Material Performance.
• Created technical specification documents.
• Created financial report for the variance on GL detail and GL summary.
• Implemented new monthly Budget & Plan reports in Investment Management (IM).
• Provided support to end users after go-live.
• Written Badi methods in ABAP to move the data for newly included field in the extractor in ECC.
• Debugged, tested data models for unit and integration testing.
• Maintained all support documentation in accordance with Brion standards requirements.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and load failures.
• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Analyze and coordinate efforts in transforming business requirements into cost-effective solutions.
• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Developed WEBI reports on Webi Rich client.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Implemented on data staging process for BPC 10.0 project.
• Involved in creating architecture for GL cube.
• Implemented process chain to upload the delta to staging cube
• Worked with client to give more summarized data on the staging cube.
• Written transformations and Badi methods in ABAP.

Confidential

SAP BI Analyst

Responsibilities:

• Monitored data loads (Flat file, R/3) on daily basis and effectively handled many extraction errors during data load.
• Effectively handled Flat file and master data loading to the DSO's and Cubes.
• Handled effectively the change requests for the DSO's and Cubes and queries.
• Worked on creating transport requests and Releasing to the test and production servers.
• Resolved many issues that came in production support.
• Extensively used BEx Analyzer and Query Designer for building Queries.
• Created the process Chains and automated the load process based on the business needs.
• Review of Functional Requirements, identify gaps and recommend/suggest changes.
• Involved in developing the DSO, Cubes, Web Templates, Bex Reports and other BI objects.
• Worked on job schedules for loading data and monitoring Process Chains to run periodic loads and other processes.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
• Involved in fixing Delta load failure while extracting data from R/3 to BW.
• Performed periodic cleanup in PSA. Extracted and loaded data from SAP R/3 into Sales Order InfoCube using Data Sources.

Confidential

Engineer -Software Development

Responsibilities:

• Supported and monitor data warehouse batch schedule, information access, reporting and analytics service performance
• Analysis, writing Functional and Technical specification, Visio flow diagrams.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
• Involved in fixing data load failure while extracting data from R/3 to BW.
• Involved in ETL process, process chain.

Confidential

Programmer

Responsibilities:

• Involved in gathering the requirements and creation of functional specifications and solution design document.
• Build objects in BW Administrative Workbench adhering to the naming conventions and guide-lines set for the project.
• Worked in data extraction - enhanced COPA Data source to extract additional fields required for reporting.
• Wrote ABAP Code for transformation routines and Customer Exit variables in BI.
• Enhanced Sales analysis report with new logic for analysis on different variances. It also included data model change to populate the new fields.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.
• Developed a new consolidated Profit & Loss report at group and country level to analyze Measure hierarchy based on reportable and non-reportable materials. It also has an impact analysis of different currencies on different levels of profitability.
• Involved in transportation of objects, data validation, User acceptance testing and documentation.

Confidential

Trainee Software Engineer

Responsibilities:

• Involved in Analysis of the functional modules.
• Involved in Data Modeling, Extraction and loading.
• Created Data modeling flow on Visio.
• Analyzed Production Support Calls.
• Development of Sales Summary Report and Inventory balances Report.
• Data Reconciliation between EIS report output.
• Prepared reports, manuals and other documentations on the status, operation and maintenance of software.