SUMMARY:

• SAP BI ABAP architect with over 18 years of SAP experience. 15 years of experience on SAP BI end - to-end implementations, upgrades and production support .
• Experienced with all phases of the development cycle from blue printing to go-live .

• Designed and implemented a Migration strategy to BI 7.0
• Upgraded BI from 7.0 to BI 7.4
• Experienced in data modeling, extraction and transformation of data loads
• Experienced in Production support, monitoring of data loads and identifying data load failures and resolving them
• Experienced in Extraction, Transformation and Loading of data from various source systems into BI
• Experienced in Performance tuning: Number range buffering, Compression, Building Aggregates, data modeling, optimizing ABAP for loading
• Experienced in using BEx for creating queries and satisfying user requirements .
• Experienced in currency translations at the infoprovider and the query level
• Extensively worked with ABAP on Update Rules, Transfer Rules and User Exits and Transformations, start, end and expert routines in BI 7.0
• Created many custom extractors and modified standard business content extractors to suit business needs
• Activated Business Content and extractors from R/3 source systems
• Extensively used process chains to automate loads into BI and for error notification
• Created open hubs to extract data out of BI and for the purpose of QA after each load
• Mentor junior team members on the team
• Participated and led successful completion of 4 full life cycle BW implementations
• Experienced in extraction, data conversion, report design, interactive reporting, dialog programming, user exit and BADI enhancements, interfaces ( inbound and outbound), smart forms, SAP script, HR forms, used logical databases for programs, function modules, BAPIs
• Migration of data from legacy to SAP using BDC, Function modules
• Extraction of SAP data for interfaces to third party and legacy systems
• SAP upgrade from 3.1h to 4.6C and 4.6C to ECC 6.0
• User exits and BADIs to customize SAP extraction for SAP BI
• Developed various SAP ABAP queries
• Familiar with the various payroll and time cluster tables data structures and the ABAP macros used in SAP HCM for reporting and data extraction
• Developed reports and interfaces for SD, MM, FI and HCM modules

PROGRAMMING SKILLS:

SAP Environment: ABAP SD, MM, FI, HCM ABAP, SAP R/3 ECC 6.0, SAP BI 7.0, BEx Analyzer/Browser, ABAP/4, Workbench, Sybase SQL and stored procs Modules SD, MM, HCM, Portal

Languages: C, Fortran, Pascal, ABAP.UNIX Programming Shell Programming. ( C, Korn, Bourne )

Soft Skills: Excellent Communication and Coordination skills with users and other teams. Independent, excellent team work

WORK EXPERIENCE:

Technical Consultant

Confidential, Columbus, Ohio

Responsibilities:

• Working on BW on HANA upgrade, testing
• Production Support for Data loads and reporting
• Gathering and Implementing requirements for Dashboard reporting
• Performance tuning of Existing reports
• Troubleshooting and identifying various OSS notes related to HANA upgrade
• Optimization of Basic Infocubes into HANA optiomized cubes
• Automating Housekeeping jobs for HANA migration

Sr Application Analyst/Developer

Confidential, Columbus, Ohio

Environment: SAP ECC 6.0, SAP BW 7.4

Responsibilities:

• Install and modify Business content, create custom infoproviders, extractors and transformations for Logistics
• Migrate Datasources from 3.x -> 7.0
• Implement reporting requirements for SD, Inventory and MM
• Transport ECC and BI objects to QA
• Activation and installation of BI Admin Cockpit
• Implement master data and transaction data process chains and integration with Redwood for scheduling
• Data modeling and customizing for BW RMA module ( Retail Method of Accounting) and BW POSDM (Point of Sale Data management)
• Implementation of SAP OSS notes and resolution of issues and testing with SAP AGS
• Implementation of Reporting requirements for BW using BEx Analyzer
• Modification of standard extractors and building custom extracts for RMA and POSDM .
• Implement various BADI requirements and data models within BW RMA
• Automation of initial stock extraction into BW
• Production support for wholesale implementation - work with end users to fix issues, design new reports and enhancements
• Participated in the successful implementation of SAP BW Wholesale and retail implementations
• Customization of SAP standard data model to company requirements by changing business content and implementing new info providers
• Collaborate with SAP AG to troubleshoot various functional and performance issues
• Successfully upgraded BI 7.0 to BI 7.4 - SPAU and SPDD familiarity with merging objects, etc
• Performance tuning of BW data loads and reports
• Implementing data models (using infocubes, DSO, multiproviders, process chains, infosources, APD, data sources) by gathering requirements and mapping ECC and legacy fields to BW

Sr Business Consultant

Confidential

Responsibilities:

• Created ABAP programming standards - created report template, model programs to handle different scenarios, ALV Grids, Interactive reporting and events, etc
• Involved in response to RFP (request for proposal) for different clients
• Upgrade BI from 3.x to 7.0, migrate data sources, convert update rules and transfer rules to transformations, application of suitable SAP notes to resolve issues
• Analyze Business content extractors, transformations and infoproviders
• BI presentation on data modeling and reporting capabilities

Technical Lead Consultant

Confidential, Jacksonville, Florida

Environment: SAP Netweaver 2004s, Enterprise Portal, SAP BW 7.0

Responsibilities:

• Functional Design specs, conversion mapping, program for new implementation for SAP HCM module
• Data modeling lead and architect for HCM reporting satisfying over 50 reporting requirements
• Query design, development of new extractors and modifying standard extractors to meet reporting requirements
• Activation and documentation of Business content in BW
• Creating transformations, automating loads using process chains
• Troubleshooting data loads, training end users on BI query execution and functionality.
• Working with client to consolidate, finalize reporting requirements
• Conversion programs for loading legacy data into SAP
• Loading BW Business content data from SAP
• Requirement gathering for BW reports
• Mentoring team members on BW performance tuning, data modeling, data loading, extraction, etc
• Migration of BW 3.x objects to NW2004s
• Working with the BASIS team to resolve issues in the BI environment
• Working with Functional Analysts and client to translate reporting requirements into technical design
• Built a Data model for to satisfy around fifty reporting requirements
• Activating and transporting business content between different environments
• Defining navigational, time dependent attributes for characteristics
• Modifying business content and creating infoproviders to suit the reporting needsQA of queries developed offshore and coordinating with the offshore team to resolve issues .

SAP ABAP/4, BW Senior Programmer/Analyst

Confidential, Florida

Business Area: BW, SD, MM, HCM/Payroll

Responsibilities:

• Data modeling - Defining the characteristics, key figures and dimensions for various info providers ( infocubes, ODS, etc)
• Creating infobjects, keyfigures, attributes of the info objects, defining time-dependent,
• Time independent Navigational attributes of infoobjects
• Extraction of data from SAP and other legacy systems into BW using standard business content extractors and custom extractors.
• Modifying the SAP user Exit for BW data extraction.
• Creating transfer rules, update rules for infocubes, ODS and master data to meet complex business requirements
• Debugging of transfer rules, update rules and determining load failure issues and problems
• Automating BW load using process chains for master data and transactional data
• Monitoring data loads and data extraction
• Created infopackages, process chains to load data
• Extract hierarchy data into BW
• Created infospokes to extract data from BW cubes for the purpose of QA.
• Created Generic data sources for BW extraction
• Created RFC function modules to validate data in BW
• Created various multiproviders, infosets in BW for query reporting
• Created various SAP Queries in BW to meet user requirements .
• Used crystal reporting to link with BW Queries to provide formatted reports .
• Building aggregates to speed up query execution .
• Created Query Variable user exits for BW queries
• Set up source systems to load both SAP/R3 and non-SAP transaction data to BW
• Uploaded hierarchies to a master data characteristic using a flat file to drill down in BEx Analyzer.
• Worked in Production support and handled batch jobs, load failures, delta failures and system issues.
• Enhanced extract structures using User exits in ABAP.
• Transported InfoObjects, InfoCubes, Queries, update rules, Multi providers from Development to QA to PRD.
• Created custom extractors for loading data into BI
• Developed Data Conversion & BDC Data load program for Vendor Master data, Material Master data.
• Generated classical and interactive drill-down reports for sales analysis.Created custom tables, messages, and selection-screens.
• Developed custom transactions using Dialog programming tools - Screen Painter, Menu Painter. Developed flow logic with PAI, PBO modules.
• Maintained various Data Dictionary objects such as Tables, Views, Match codes, Lock objects, Logical Databases, Messages.
• Modified layout sets using SAPScript for SD module invoicing document.
• Created test master data on development client SAP instance for Customer, Pricing, Material related to MM module.
• Used the Correction and Transport System.
• Knowledge of data Extracts and User Exits
• Extensively used ABAP Debugging tool, SQL Trace, Runtime Analysis and optimized ABAP SQL code.
• Data Extracts for Master data and Payroll data from SAP to ADP.
• Created a report showing the Organizational assignment, shift, EEO, etc for all the employees
• Developed a report to calculate the Payroll Accrual
• Developed interface to upload data from Tandem to SAP
• Developed a report to read the cluster B2 for employees and calculate the hours worked for different payroll periods
• Created an Audit report for Payroll
• Developed a report showing employee compensation for different employee positions
• Developed a BDC program to set the appropriate dates on Infotype 3
• Modified the program to load HCM Master data from ADP into SAP
• Created a report to show the Job, Worker’s Comp. Code,etc for each employee
• Developed a report for an across the board pay increase for a particular org. Unit
• Interface to pass on the award points to American Express from SAP
• Report to extract Payroll results from the RU cluster by different Wage types
• Report to Analyse Pay Changes for a specified period
• Report to verify the entitlements upload to SAP
• Project: Upgraded the SAP HCM system from 3.1h to 4.6b
• Material Creation/Change interface
• Servicing the RFS for Production support
• Created HCM forms to print the pay stub accompanying the pay check
• Created Garnishment report by vendor
• Benefits interface to Vanguard
• User exit for leave entitlements
• Used ALE to export master data between different SAP clients
• Developed CATTs to load/change infotypes
• Developed a report to verify leave entitlements in SAP
• Modified various SAP programs by applying OSS notes
• Developed programs to extract basic pay details, wage types, HCM data for reporting purposes
• Created various SAP queries to report data using logical database, tables,etc

Environment: SAP ECC 5.0, BW 3.0B

Confidential, Houston, TX

Senior Systems Analyst

Responsibilities:

• Developed Network Applications Management (NAM) module in Visual Basic/SQL Server and MS Access. Developed QA testing procedures in production system. Provided technical support to QA for maintaining NAM module.
• Programmatically configured routers for Private - Management Information Base (MIB) in 'C' using SNMP mid-level routines (Set, Get, and Validate).
• Developed several Graphical User Interfaces to extract and dynamically define MIB router parameters.
• Programmed SNMP-Agent to decode Protocol Data Unit (PDU) and extract the MIB object values for communication with mid-level and BIOS routines.
• Integrating crystal reports with VB
• Interfaces to other systems

Senior Developer

Confidential

Responsibilities:

• Converted various protocols like ISUP and TUP to a normalized protocol called "PRISM" (Protocol Independent Set of Messages) which the Nortel DMS switch understands.
• Fixed compile and runtime errors in the DMS 100 switch software.
• Programmed parameter converters, message mappers and parsers.