SUMMARY:

• Having 12 + Years of Software Experience (In which 18 months of Experience in Malaysia, Singapore)in IT field primarily in SAP - BI/BW as BI Consultant. Have Work experience in different kinds of projects likeImplementation and Production Support Projects inSAP BI
• Good understanding of all the phases of system development life cycle and implemented in various projects.
• Having knowledge of integrating SAP HANA with SAP BI and BO.
• Hands-on Experience in Implementation Life cycle as a BI consultant using ASAP methodology for ETL that includes gathering business requirements, analyzing the business process, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Data migration, Go-live and Post-go-live support along with other Post-Implementation and Post Maintenance projects in SD, MM and FICO functional areas.
• Good Experience in BW Extractions, BW Modeling and BEX Reporting.
• Knowledge of SAP ABAP programming and ALV reporting .
• Created Views and Tables in R/3, also involved in complex ALV reporting.
• Worked on interfaces to integrate Non SAP system with SAP using remote function modules.
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Info Package, Data Source, Info Objects, ODS (DSO), Update rules, routines, Transfer rules, Process Chains and Event management for Automation process.
• Strong experience with OLAP reporting in BW and implementation of BEX Analyzer. Worked extensively with BEX Query Designer, BEX Analyzer for developing reports, analysis, and Web reporting.
• Debugging Data load errors, Delta Queue Monitoring, and Extractor Checker by simulating BW asking for data and Customer Exits. Master/Transaction data testing
• Hands-on experience on Queries, Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions.
• Experience in extracting data from SAP R3/ECC, non-SAP systems, and flat files
• Developed and maintained batch applications using the software COBOL, VSAM, DB2 and JCL.
• In depth experience in IBM-Mainframes, Development, Migration, Maintenance, Testing, Production support Projects.
• Having very good knowledge on Production Support and SLA (Service Level Agreement).
• Having experience in handling High severity problem tickets.
• Actively involved in the life cycle of the project, which includes implementing the Systems Design, Development, Testing and Documentation.
• Experience managing Teams, having experience as Application Leader at MPHASIS which involves total responsibility on the deliverables.
• Good project management & people management skills with 4-way communication as, Client-Team-Management-Quality.
• Having rich experience in implementing the quality objectives.
• Versatile team player with good communication and interpersonal skills.

TECHNICAL PROFILE:

OPERATING SYSTEMS: MVS, UNIX, WINDOWS 98/NT/2000, DOS

PROGRAMMING LANGUAGES: COBOL, JCL, CICS, C,C++,Java,VB,SAS

DBMS: DB2, ORACLE 8i,IMS-DB

APPLICATION SOFTWARE: TSO/ISPF, FILE-AID, WORK BENCH, RTLSOMCS, Quality center, BMC REMEDY ITAM

JOB SCHEDULERS: CONTROL-M, CA7,CA11

VERSION CONTROLLER: ENDEVOUR, Changeman

FILE ACCESS METHOD SERVICES: VSAM

DATABASE TOOLS: SPUFI, QMF

SAP: HANA,Bi/BW,BEX

PROFESSIONAL EXPERIENCE:

Confidential

SAP BI Consultant

Responsibilities:

• Developed Custom Aggregation Levels, Filters, Planning Functions and Planning Sequences required for various applications like Trail Balance, Consolidation of Cost Center Actual, Profit Center Actual and Balance Sheet Actual applications.
• Developed Virtual Cube to fetch exchange rates stored in TCURR table at runtime
• Developed Consolidated P&L, Balance Sheet trend reports, monthly, Yearly and Year to date showing with Actual vs Budget, Actual vs. Forecast data and integrated them into several financial reporting workbooks
• Extensively used 0FIGL C10 cube for ‘Profit Center Variance Analysis’ Annual reporting.
• Worked in BEX Analyzer in building queries and saving workbooks and created custom queries using Conditions, Exceptions, Variables and Structure and created aggregates for frequently used queries.
• Worked on new data flow capabilities like DTP (Data Transfer process), RDA (Real Time Data Acquisition) and enhanced & graphical transformation capabilities.

Confidential

SAP BI consultant

Responsibilities:

• Worked on calculated and Restricted Key Figures, restricted characteristics, structures, variables and conditions for the queries.
• Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the logistics data.
• Involved in Info Cube maintenance i.e., Compression, Roll - up for Aggregates.
• Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain.
• Created tables and Views to exchange Custom data between R/3 and BW systems.
• Created ALV reports to display production life cycle and costing.
• Working on FI related ALV reports analyze AR & AP and Expenses.
• Worked on Remote function modules to exchange data between SAP and non SAP systems.

Confidential

Technology: COBOL, JCL, DB2, VSAM,IMS-DB

Tools: SPUFI, QMF, Control-M, FILE-AID

Application Leader

Responsibilities:

• Providing 24x7 support and fixing the problems.
• Regularly conducting call analysis to identify and fix the re-occurring problems.
• Resolving customer queries and Incidents.
• Participate in project transaction activities.
• Coding, Review and Testing.
• Participating in the weekly and monthly service review with the client.
• Responsible for providing SLA bound service to client.
• Primary responsibilities includes as an architect and Project lead for mainframe module.
• Gathering requirements, Analysis, Design, Coding and Testing.
• Allocate the Tasks for the Team.
• Ensuring that all the work meets the quality requirements according to standards.
• Reviewing of work at all stages (Analysis, Coding and Testing).
• Planning and executing the project for addressing the client issues, solutions and suggestions.
• Preparing weekly and monthly status reports for Senior Management/Client
• Mainly involved in writing IA, SESS, Technical documents, preparing test data from production environment.

Confidential

Technology: COBOL, JCL, DB2, CA7

Tools: SPUFI

Team Member

Responsibilities:

• Providing 24x7 support and fixing the problems.
• Production Monitoring
• Resolving customer queries.
• Clarifies & SPR Solving.

Confidential

Team Member

Technology: COBOL, JCL, DB2,CA7

Responsibilities:

• Providing 24x7 support and fixing the problems.
• Defect analysis, Ticket solving on Existing modules
• Resolving customer queries.