SUMMARY

• 11+ years of total IT experience in SAP BPC, SEM, R/3, BI, BW, XI Oracle, C++ applications and main frame programming
• 3 full life cycle with BPC NW
• R/3 enterprise versions in SD, MM, FI CO modules
• SAP SEM (BW, BI, BPS, BCS, FI, CO) 4 years architect and mentor and developed projects for a prestigious company with EDW applications integrations
• SAP BI 4 + years work experience in development, reporting and lead position
• Worked on Business consolidation, using consolidation functions Interunit elimination functions and consolidation of investments.
• Worked with FICO, BW, SEM - BPS, SEM - BCS Creating & Modifying hierarchies within BCS for specific client requirements Databasis & Currency translations Extensively worked with Basic and Transactional InfoCubes, Basic Planning Areas, Multi-Planning Areas, Planning Levels, Planning Packages, Planning Layouts, Local and Global Planning sequences
• Knowledge of Data Slices, Characteristics Relationships, Variables and Functions like Formula Extensions (FOX), Copy, Revaluation, Distribution, Repost, Forecast, and Currency Translation
• Hands on experience in Performance Tuning and Data Locking
• Extracted SAP R/3 transaction data using LIS, LO Cockpit and Generic data extractions and master data using SAP BC Data sources and custom Data sources for Attributes, Text and Hierarchy
• Experience in SAP-BI Components like Info providers, Multiproviders, Info sources, transfer rules, transfer routines, Info Objects, ODS Objects, Update Rules and update routines
• Extracted data from Logistics (SD, MM, QM, and PP), SRM, FI/CO, HR, Generic Data Sources and Flat Files
• Knowledge in accounting principals, FICO, BPS, BCS
• Developed Webservices to generalize the systems
• Extensively worked in R/3 ABAP programming
• ABAP experience includes ALV, Interactive and Classical Reports, SAP Scripts, SAP Smart forms, LSMW, BDC, User exits, ALE and IDOCS
• Multiple implementations experience with BDCs, Legacy System Migration workbench (LSMW) for data upload
• Good Knowledge and implementation on SAP ALE, IDOC Interfaces
• Good Understanding of both business processes and technical development
• Skilled in programming and database maintenance
• Performed technical analysis of business requirements to identify IT Customer solutions
• Maintained the SAP environments, provide SAP technical leadership, and act as a liaison between functional, ABAP, and infrastructure staff
• Excellent communication, interpersonal and managerial skills and self motivated to work independently and as well as in a team.
• SAP XI 1 year experienced in Building interfaces and mapping technique

TECHNICAL SKILLS

ERP: BPC NW, BI, BW, SEM with MM, FI, CO, SD, WM, PM, XIWebServices, SAP-ABAPCONFIGURATION SAP ALE EDI

LANGUAGES: ABAP/4 & C++, COBOL, Natural 4GL, JAVA

RDBMS: MS Access, Oracle 7.x, Adabas

OFFICE SUITES: MS Office Lotus Notes

ETL: EDW, Informatica,Crystal Reports, Tidal

BO: BODI, BOXI

PROFESSIONAL EXPERIENCE

Confidential

SAP BPC consultant

Environment: SAP BPC 7.0 MS Version Sales Planning Implementation R/3, ECC 6.0, BW 3.5, SAP-BI FI,CO

Responsibilities:

• Developing Customer specific data model with Dimensions & Applications along with Dimension and application Parameters
• Setting up WorkStatus, Business Process Work flow. Designing the BPC Security.
• Design Data upload structure with transformation & conversion logic.
• Design the advanced script logic for allocation, for moving data from one application to another
• Developed extraction plans and worked closely with ETL to retrieve the desired data from ECC
• Developed customized Input Schedule, like Cost Centre Planning Schedule, HR Input Schedule, Capex Data input schedule with customized button
• Advisor and developer (with respect to the BPC )
• Created dynamic Rolling Forecast report with automatic lock features for different data categories.
• Working as part of this multi-disciplinary team, help to deliver high quality end to end project implementations
• Supporting and advisory
• Upgrading Extractors from BW R/3 to ECC
• Developed Customer Specific Dynamic & Static Reports
• Worked with installing SAP Integration kit
• Conversant with EV functionalities, EVDRE, EVPRO, EVCVW, EVTIM, etc

Confidential, RI

SAP BPC consultant

Environment: BPC NW 7.0 Version, BPC POC Implementation

Responsibilities:

• Translate the Sales Planning requirement into BPC Perspective by defining required applications, dimensions along with the properties.
• Define Data Flow architecture to move the master data & transactional data from SAP R3 system to BPC.
• Create Transformation file & Conversion file for uploading data.
• Create Input Schedule to upload the planned data into different application.
• Developed rolling Forecast dynamic Input Schedule.
• Run Allocation function to allocate sales dollar amount to different entities on the basis of the parameter defined.
• Use EVDRE function to create dynamic report.
• Developed Nested Report, Comparison Report with different EV Functions.
• Use web reporting Feature to publish certain reports in Web.
• Work on User Management to develop the Security matrix.
• Trained in BPC NW with sales Planning application within these areas

Confidential, RI

SAP SEM consultant

Environment: R/3,ECC 6.0, BW 3.5, SAP-BI BPS,BCS SEM 6.0, FI,CO, Crystal Reports

Responsibilities:

• Development, Support to the users with Pre-Go live support and Post Go live support and BCS and BPS applications
• GL Accounts, Cons unit hierarchies
• Architect and developer with extractions from BI, SEM, EDW and Tidal teams
• Upgrade existing R/3, SEM 3.5 projects to ECC 6.0
• BW Infocubes, DSO, extractors, process chains, deltas
• Developed extraction plans and worked closely with ETL to retrieve the desired data from ECC
• Developed Workflows so Tidal triggers the process chains
• Advisor and developer (with respect to the SEM box
• Worked with COPA extractors and FI extractors for both NewGL and R/3 applications within BW.
• Working as part of this multi-disciplinary team, help to deliver high quality end to end project implementations
• Supporting and advisory
• Upgrading Extractors from BW R/3 to ECC
• Developed time critical crystal reports using BW integration and Bex Queries
• Worked with installing SAP Integration kit

Confidential, MI

SAP BI & ABAP analyst

Environment: SAP R/3 Versions: NW04, Enterprise, ABAP, OS: Sun Solaris, Win-2003. DB: Oracle

Responsibilities:

• Performed analysis, design, development and implementation of customized Info cube
• Performed ETL from SAP R/3 both Application Specific and Generic DataSources
• Identified the custom extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems
• Created the Generic Data source using function modules
• Created various transfer rules with PSA update
• BW authorizations, BPS authorizations
• Modified Update rules, Transfer rules, Update routines and Transfer routines as per client requirements
• Extensively worked in BI Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data Sources, Data Extraction, Characteristics and Key figures, Business Content, Process Chains, specific to SD, MM, PP, PS, PM, QM, FI/CO, AR, AP, and GL.
• Performance tuning, process chains build and process.
• Developed BPS cubes specific to client requirements
• Extraction and BPS Planning on allocations
• Provide continuing assistance to less experienced team members
• Attend various meetings and provide feedback and submit status.
• Coordinate with ABAP personnel as required.
• Complete special projects as assigned.
• Requirement gathering from Business Users

Confidential, UT

ABAP (Production Support lead)

Environment: ECC 6.0

Responsibilities:

• Assisting Project deliverables
• Understand and prepare requirements for use in formal agreements for the provision of continuity services including Business requirements
• Identify specific requirements excluded from any standard agreements and proposed contracts for creating client specific deliverables
• Disaster and Faulty objects identification
• Follow standards and Procedures
• Team education of the project
• Used the ASAP Methodologies within the company standards
• Target Ensured Control mechanism for Post production Support and management
• Regulated Control and Support for the Users between countries
• Assisting in development and Support Procedures both Technical and Standards
• Good Interpersonal Communication skills with the Client, Users and the team

Confidential, IL

SAP BI- SEM-BPS Consultant, FICO

Environment: ECC 5.0, SAP-BW BPS SEM 3.5

Responsibilities:

• Requirements gathering from end-users to define business planning and reporting requirements
• Creation of BEX Planning reports / queries
• Developed Planning Areas, Multi-Planning Areas, Manual Planning Layouts, Planning Levels, Planning packages
• Developed planning levels both in Top-down and bottom up planning scenarios
• Developed Planning Functions and Parameter Groups including Copy, Revaluation, Formulas, FOX, User exits, Delete & Allocation
• Developed Characteristic Relationships in all Planning Areas
• Developed both Local and Global Planning sequences
• Creation of variables for various characteristics
• Developed Planning Profiles & Planning Folders
• Designed Balanced Score cards on Departmental wise, Management cockpit
• Designed Risk Management techniques using Measure Builder
• Generated Web based interfaces to enable end users to access the Planning folder through the Web

Confidential, MI

SAP ABAP Developer, SEM-BPS Consultant

Environment: ECC 5.0, SAP-BW 3.5, SEM 6.0, FICO

Responsibilities:

• Built a Prototype or a pilot project to analyze the basis of presentation to the steering committee, include the Interunit Elimination Process and Monitoring.
• SEM-BPS
• Complete Study of the application
• Understand the need of customization of the BPS upload functions
• Develop Customized functions to fit the requirements
• Build planning folders with appropriate requirements by the users according to the fumctional specification
• Build and design planning functions
• Create planning levels
• Functions enabling the Forecast and planning based on versions
• Design BPS Cubes based on the Functional specification
• Configuration of BCS using BW reports
• Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
• ABAP
• Designed and developed the technical specifications, getting the requirement from the Business user and the Functional
• Developed a User exit to communicate with the TaxBolt on system SABRIX for Input and Output Taxes, using BADI to to get the material data into the userexit for all the sales orders and billing invoices
• Conducting meetings to bring the possibilities and requirements for converting the Paybase systems to SAP systems
• Developed interfaces to upload Revenue accounts into SAP FI using BDC (customer credit memos)
• Developed RFC’s to send Trasactional data into SAP through Webservices accomplishing the validations for GL accounts and Internal orders
• Developed interface to upload valid Glaccounts and Internal orders, billing accounts into SAP using BDC
• Prepared Unit test plans, to determine the required tests for system test along

Confidential

SAP BW consultant and ABAP

Environment: BW 3.5

Responsibilities:

• Remodeled reports like Production actual variance with MM and WM
• Summary Reports on Picking and Packing list
• Summary reports on Internal Orders
• Developed FI Reports
• Trained and worked as a BW developer
• Created Info packages and Scheduled loading of data to BW Server using Process Chains and used the BW Monitor to monitor data loading into the Info Cube.
• Used Multiprovider and Info sets to extract data from tables and table joins.
• Loaded transactional data into PSA and updated data from PSA to ODS
• Interaction with Users to get reporting requirements and
• Development of Queries and reports using Bex analyzer.
• Generated data sources & activated the extract structures
• Defined Transfer rules & update Routines
• Used generic extraction and custom extraction to extract data from SAP R/3 to BW.
• Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/ Transaction data from R/3 Data sources and from Flat Files