We provide IT Staff Augmentation Services!

Sap Bi Bpc Hana Solution Architect Resume

5.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY:

  • Seasoned SAP professional with eighteen years of SAP experience which include thirteen years of SAP Business Intelligence and five years of SAP ECC programming experience in Modules like SD, MM, FI, Confidential - PA, PS, HR, PM, PP. Three years of Operational Experience.
  • SAP Certified Consultant, certified by SAP Americas in BW and ABAP Programming.
  • Worked on several full life cycle implementations of SAP projects
  • Worked in SAP BW powered by SAP HANA project that includes HANA migration and upgrades, SLT 2.0, NLS integration through SDA(Smart Data Access) and reporting
  • Architect for several HANA solutions. Lead projects involving onsite, offshore and SAP members.
  • HANA Modeling experience with HANA Artifacts such as Attribute Views, Analytical Views, Calculation Views, HANA SQL scripts, HANA Stored procedures, Table User Defined Functions, AMDP (ABAP Managed Database procedure), ADBC coding, ADSOs, Composite providers and reporting objects, DXC Extractors
  • Strong knowledge in Logistic cockpit extractors, LIS, FI-GL, FI-AR, FI-AP Confidential -PA extractors, generic extractors, InfoObjects, InfoCubes, ODS objects, Authorization objects, Queries, reports using Business explorer browser. Worked with BODS, InfoSpokes and open Hubs
  • Worked extensively on creating reports using BEx Reporting, Web Application Designer, Business object 4.0, WEBI, IDT, Crystal Reports 9.0, MDx queries, business objects webi reports, Tableau
  • Strong ABAP skills in the areas of Interactive reporting, Dialog programming, Sap script, API Function modules, BAPIs, BADIs, workflow, ALE, EDI & IDOC programming and configuration, LSMW.
  • Worked on creation of applications using SAP Web Application Server 6.2, Business Server Page (BSP) JavaScript and HTML. Created Web Dynpro applications.
  • Knowledge in Sap’s new dimension products like SEM-BPS, APO, CRM, SRM. Worked with SCM SNP and DP data. Attended in-house training in SEM, NetWeaver 2004S and Project Management course given by Cadence Management Inc.
  • Trained users in BW and reporting. Trained many new developers in the area of ABAP and BW.
  • Possessing strong interpersonal, communication and presentation skills. Dedicated, challenge facing, time bound, result oriented, team player
  • Enthusiastic participant in several open.sap.com training courses and reader of online SAP materials to keep up to date on SAP roadmap and offerings

TECHNICAL SKILLS:

ERP Package: SAP R/3 Release 3.1H, 3.1I, 4.0B, 4.6B, 4.6C

New Dimension Products: BW 30B, 3.1C, Netweaver 2004S, BW on HANA

Reporting tool: BEx, Web Application Designer, WAS6.2, Crystal Report 9.0, MDx Queries, BOE-XI3.0, Business objects 4.0, Information design tool IDT, Interactive Analysis Desktop IAD, Tableau

Batch Job Scheduling: AutoSys, Tidal Scheduler ver 2.5.1, Veritas/Seagate AshWin Scheduler 3.7

Middleware: Tuxedo, SAP Business Connector

Languages: ABAP/4, Visual Basic, JAVA, C, C++, SQL, PL/SQL, HANA SQL Script

Database: ORACLE, DB2, MaxDB, HAHA

Platform: Windows NT, UnixTesting and SDLC tools: HP QC, Solution Manager charm

Other applications: Microsoft office, Microsoft Outlook, Microsoft projects and Lotus Notes.

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

SAP BI BPC HANA Solution Architect

Environment: BI7.3 SP9/BI7.4 SP13, BPC10.1, DB6-10.05, HANA SPS11, BEX, EPM 10.0 SP25, Tableau, FI, ABAP, HANA SQL Script, SLT 2.0(DMIS 2011 1 731) on NW7.4 SP8, SAP Sybase IQ

Responsibilities:

  • Was part of Architect team working on SFR project system architecture design
  • Was member of BW Core team and involved in designing several new project solutions, addressed several performance and production operation issues
  • Worked in HANA modeling using HANA Artifacts such as Attribute Views, Analytical Views, Calculation Views, HANA SQL scripts, HANA Stored procedures, Table User Defined Functions, AMDP (ABAP Managed Database procedure), ADBC coding, ADSOs, Composite providers and reporting objects, DXC Extraction
  • Worked on establishing HANA development standards
  • Worked on establishing Performance turning techniques in HANA Views
  • Creation of complex HANA SQL script based HANA views to flatten hierarchies to meet project needs
  • Worked on SLT project to configure and replicate ECC tables into BW HANA database
  • Worked on Archiving HANA data into SAP Sybase IQ database
  • Integration of cold data from Sybase IQ data through SDA(Smart Data Access) and hot data from HANA into data modeling for reporting
  • Worked on DXC Extractors
  • Worked on several performance improvement projects. Performance tuning of Hot and cold data.
  • Liaison between SAP and Confidential for project initiatives and issue resolution
  • Liaison to performance testing team for all BW/BPC projects to address any performance concerns arises during integration testing phase
  • Involved in many system upgrades such as NW 7.4SP7 to NW7.4SP13 upgrade, DB6 to HANA, BWA hardware swap between OBW to ABW, HANA SPS8 (85.05) to SPS11 (112.03) upgrades
  • Worked on many performance optimizations and issue resolutions
  • Worked on APFA extractors to extract cross-company expense items in third party AP invoices and AP credit memos flattened to their corresponding liability/payment items
  • Worked on conversion of BPC audit data BW based reporting solution to HANA based solution
  • Development of iGL reporting solution in BEX and UI5
  • Supported BEX and EPM reports tools and addressed several performance improvements working directly with SAP. Worked on EPM drill through reports including across the systems. Used Tableau for query performance dashboard.
  • Part of Dev tooling team that worked to harmonize development tools and reducing operational cost. Worked to establish maturity index and established 2017 goals for BI to improve operational excellence and reduce operational cost

Confidential,San Francisco,CA

Lead BW consultant

Environment: BW7.3/Business Objects 4.0, IDT, IAD, MM, IM, SD, FI, COPA, APO, Teradata SQL Assistant, Teradata 13, BODS, BO WEBI

Responsibilities:
  • Confidential -ordination with EMEA OTC super users for weekly production support prioritization process and providing production support in OTC space
  • Worked on Self-billing file extract that used open hub destination and BODS(Business object data services) to provide monthly product delivery information to EMEA downstream system
  • Worked on supporting projected inventory report that utilizes non-cumulative key figures cubes and APDs(Analysis process designer). Projected inventory cube consumed data from SNP/DP data from APO, IM data and PO data from MM and Order/Delivery data from OTC.
  • Performance tuning of all the Logistic extractors through revamping of user exit codes.
  • Worked on development and support of new GDSP universe. GDSP universe provided capacity to the users to develop reports on material master data combined with DP, SNP, SO and Delivery data.
  • Developed technical solution to overcome issues of long running BW transport migrations when BW objects are adjusted.
  • OTC Universe project was taken up with two objectives. One to address performance issues with some of the existing universes and reports and two to serve as one stop shop for OTC users to build all their reports.
  • Worked with EMEA super-users from the requirement gathering through implementation and go live.
  • Designed OTC universe that connected Order, Delivery, Billing, COPA, Allocation and planning data to provide OTC users business visibility and enable them to build their reports with ease.
  • Developed objects in BW/Teradata/IDT/IAD, to build the complex OTC universe with contexts/alias/derived tables using relational fred connection.
  • Also worked on developing WOR(Weekly operational report) and OFR(Order fill rate) Business object WEBI reports.

Confidential,South San Francisco,CA

Lead BW Consultant

Environment: NetWeaver 2004S, BW 7.0, SAP R/3 46C, BEx, WAD, FI, LO cockpit, MM, PP, PM, QM, IM, APO

Responsibilities:
  • Confidential is a biotech company which has its corporate office and manufacturing facility in south san francisco CA. Confidential uses BI to support its P2P, OTC, FI and PROP reporting needs through Portal.
  • Confidential was bought by Roche holdings a Swiss based pharmaceutical giant in Mar 2009.
  • Worked on Roche core project in finance in which accounts numbers of Confidential were replaced with new account numbers of Roche both in R3 as well as in BW at the table level by SAP.
  • Worked from BW technical side, in terms of impact analysis both to backend and front end, lead the development effort in changing them with offshore resources.
  • Developed validation strategy for before and after account no changes, developed mass validation tools.
  • Leading the Roche core cutover activities and 1st batch support after cutover.
  • Pharma core project was SAP level effort to have common definitions among master data, organizational elements, business rules and technical settings to enable global supply chain planning & execution between Roche and Confidential .
  • Did impact analysis of material nos, material group, material type, vendor account group based on old to new mapping info in Confidential system. Did development from BW side in the backend and front end were needed to take care of adding new master data/org element nos
  • Confidential production operation (PROP) has major tool called class A metrics to measure the performance of various manufacturing functions such as Master data readiness, production schedules, production planning, quality, maintenance operations.
  • Involved in the support of existing class A metrics and other PROP reports
  • Developed many new class A reports such as PDM master data readiness, long term maintenance projection report, excess and obsolete inventory, OTIF (On time in full), supplier schedule report, plan vs actual based on PO, PR and GR.
  • Worked on GPA and MDMS project, enabling to supply master data information to global Roche BW system.
  • Developed adhoc query publishing web dynpro application that enables deploying user queries in portal on adhoc basis.

Confidential,Atlanta,GA

Lead BW Consultant

Environment: NetWeaver 2004S, BW 7.0, ECC 5.0, BEx, WAD, BOE-XI 3.0, LO cockpit, FI, SD, MM, PP, IM, SCM 5.10

Responsibilities:
  • In Feb 09, Confidential upgraded BI from 3.5 to 7.0. Worked in upgrade project.
  • Confidential had H&F (Home and Family) and SNF (Sanford) products in SAP and on July 09 it rolled out TH (Tools and Hardware) products to SAP. Part of this go-live, supported BI developments.
  • Was part of CoE team, responsibility include architecting reporting solutions for TH go-live, reviewing development done by other developers and Confidential -coordinating migration of transports to production, supporting production support and development landscape system
  • Drafted and published Development standards, naming standards, ABAP coding standards and architectural standards document to help guide development team with their development effort.
  • OTC batch was talking long time and hence Newell was running twice OTC batch once at 7.00pm and once at 12.30pm, in order to ensure 7.00am data availability. Revamped OTC architecture, made improvements to code, redeveloped bad performing objects and made OTC as one single batch.
  • Part of OTC re-design built a new President report environment that reports sales order, open order and service level metrics information (metrics that measure the effectiveness of fulfillment process).
  • Redesigned and developed new APO sales order feed environment.
  • Worked in SNOP project. This project was extracting and loading data from EMEA, Asia legacy systems through flat file and integrate with SAP US data and create global environment for reporting.

Confidential, South San Francisco,CA

Lead BW Consultant

Environment: NetWeaver 2004S, BW 3.5, SAP R/3 46C, BEx, WAD, LO cockpit, MM, PP, PM, QM, IM, APO

Responsibilities:
  • Architected and developed various class A metrics solutions.
  • Supplier delivery performance, PO within lead time are metrics to measure vendor performance on adhering to quantity, quality and delivery schedule and procurement team adhering to provide established lead time to vendors between PO creation and delivery.
  • In PP metrics like Production Plan Performance, Production Plan stability, Master production schedule, Production Plan Firm, Production Plan current, BOM accuracy are developed to measure the planning and production efficiency. On demand planning side Forecast accuracy and Forecast stability are created using APO demand planning data.
  • In PM Maintenance schedule performance, Adherence to due date metrics is created to measure plant maintenance efficiency. On QM side, quality release performance metrics was developed to measure efficiency in releasing lots in inspection for purchased materials.
  • Worked on various logistic extractors, custom extractors including function module based delta extractors. Enabled few business content extractors, where available.
  • Created various web templates to publish these reports in portal. Worked with security/portal team to have security role assigned to access class A metrics.
  • Other functions involve, creation of process chains to load these metrics, working with batch team to transition them to monitor batch process, working with basis in migration across landscapes, QM team in documenting TFS and capturing test results executing test scripts in Quality center, working with project management team on plan and timely delivery of these metrics

Confidential,South San Francisco,CA

Senior BW Consultant

Environment: NetWeaver 2004S, BW 3.5, SAP R/3 46C, EBP, CRM 4.0, BEx, WAD, LO cockpit, MM, FI.

Responsibilities:
  • P2P optimization project involved in analyzing the data targets, remodeling them as necessary, creating supporting aggregates & indexes to improve its performances of queries using pruning and subset caching. Built PO inquiry, AP Inquiry, Open PO Balance and total spend reports on optimized targets.
  • Worked on Sales Confidential Project. Confidential implemented new company code in R3. On BW side making necessary changes to P2P objects and queries, so that new company code records are populated in the existing reports. Developed user exit codes for BEx variables for automatic population of existing company code Pos or purchase group when new company code Pos or purchase group are input by the user in query selection so that both company code information is displayed.
  • Built custom extractor ZCO OM OPA 6, based on function module to extract internal orders with batch split records from costing tables(COBK, COEP etc). Worked on 0CO OM CCA 9, 0CO OM WBS 6, 0CO OM ABC 7, 0CO OM OPA 6 extractors to populate custom fields in user exit.
  • Developed parking log and parking reason code information extractors based on function module and table for shopping carts from Enterprise buyer professional(EBP) system and loaded & reported in BW.
  • Developed lot of utility tools like query, web template, view and workbook delete program to periodically clean the system from temporary objects. Built reporting environment to report portal tab, reports in them, web templates that make those reports, LDAP role and BW role relation etc. Developed variable delete/renaming program, to cleanup/standardize query variable tech name and description.

Confidential,Portland,OR

Senior BW Consultant

Environment: NetWeaver 2004S (BI 7.0), BW 31C, BEx, SAP R/3 46C, APO-DP, LO cockpit, MM, SD, FI, Flat Files, Oracle.

Responsibilities:
  • Architected DPSO solution in Multilayer environment. Guided team members in technical development.
  • Developed regional/divisional Demand Planning SaleOrder cubes in Analytical layer in BI 2004S. Developed Apparel and non-apparel MultiProviders on top the regional/divisional DPSO cubes.
  • Connected 3.1C Integration layer DataSources to DPSO cubes in 2004S Analytical layer through transformations. Developed DTP processes and process chains to enable the load from Integration layer to Analytical layer.
  • Implemented query pruning logic to improve the performance of queries in Analytical layer. Implemented virtual characteristic on price through BADI and enabled calculation of amount fields at the front end.
  • Setup Process chain in Integration layer to load delta data from SO and Authorized futures deltas.
  • Developed currency translation key using RSCUR to convert doc currency to fixed currency at the time of reporting for DPSO project.
  • Developed Rapid view SO summary report, SO details report - regional level, SO details country level in BEx and developed web templates to publish them in Portal through iViews.
  • Interacted with SAP for issues related to 2004S through OSS and implemented appropriate fixes/notes.
  • When we do PO reload, we need quiet time in production. Due to volume growth, purchasing setup jobs were taking more than 10 hours in production. Downtime of production system to this level was not acceptable. Developed methodology by combining new Architectural design with extractor changes, necessity to downtime was eliminated.
  • Decoded SAPs logic on additive key figures in 2LIS 02 ITM and 2LIS 02 SCL logistic extractors and coded logic in EXIT SAPLRSAP 001 user exit to convert them from additive to overwrite to enable zero downtime PO reload. Modified BW update rules and transfer rules to make necessary changes to enable zero downtime.
  • Wrote code in R3 user-exit to reduce unwanted duplicate records during repair request pulls. The no of records was reduced to 3% due to this resulting in 97% record reduction. Led a team of developers in PO reload activities. Data was loaded into staging layer from R3 without any downtime in small chunks. Then loaded data from staging layer to other consumers followed by load of delta requests. This way an entire production 1120K POs were loaded without any downtime.
  • Implemented 2LIS 02 SCN extractor to get vendor confirmation information.
  • Worked on Account assignments cube to add additional characteristic and its navigational attribute to meet the business need.
  • In APO-DP Wave III countries project, demand planning data has been pulled from R3 and sent to APO and Planning data was pulled back from APO to BW for reporting purpose. LIS 789 InfoStructure and DataSource 2LIS 41 S789 acted as source data from R3. Involved and developed reporting objects in BW to report on APO-DP data. Also customer, Non-customer, SizeAnalysis cubes were built for reporting purpose.

Confidential,Portland,OR

Senior BW Consultant

Environment: SAP R/3 46C, LO cockpit, MM, Flat Files, Oracle BW 31C, BEx.

Responsibilities:
  • Worked on creating many InfoSpokes for Salesmen Sample PO Integration project. Developed process chains to schedule them for periodic runs through external scheduling tool called Autosys.
  • Worked in developing custom Process chain process types to enable extraction of data from TODSs in staging layer and utilized these process types in Process chains for SS PO Integration project.
  • Designed architectural solution for ESP (Equipment supply planning) project to fit them in Nike’s new Multilayer data warehousing architecture.
  • Developed InfoSpokes and coded BADis in ABAP to feed PO information to ESP server from BW.
  • Developed reports Capacity utilization report, Build plan to capacity type report, ESP demand plan report, ESP Supply plan report, ESP Build plan report in BEx and developed web templates to publish them in Portal.

Confidential,Portland,OR

Senior BW Consultant

Environment: SAP R/3 46C, LO cockpit, MM, Flat Files, Oracle BW 31C, BEx, Web application designer, Portal, MDx Queries.

Responsibilities:
  • Worked on GPO3 phase II to build AsiaPacific(AP) PO Item and PO Scl ODSs in US/EMEA BW box. This enabled removing remote cube which was used earlier to bring Japan/SEA data, helping in performance improvement.
  • Worked with staging team to bring R3 PO delta to bring through staging layer. Connected US/EMEA as well as Japan BW system PO Item/scl ODSs and EM ODSs to bring data from the staging layer. Created DO and TS for the changes and worked with GA CoE for approval.
  • Worked in Designing of Operational layer for PO ODSs, VAS text, EM data to accommodate GPO3 reporting needs.
  • Participated in the development/coding of PO environment in Operational layer.
  • Loaded data from R3 and Event Manager in Dev and SIT environment.
  • Worked with GPO3 team to address any issues that arise in GPO3 BW reporting environment.
  • Worked on Process chains to accommodate all the design changes for GPO3 phase II and New architecture changes to smooth loading of data.
  • Worked on rewriting the code on R3 user-exit side for PO Item and Scl extractor to improve the performance and to comply with ABAP CoE standards. Coded to bring additional fields for GPO3 requirement.
  • Worked with Business Analyst on many reporting solutions. Utilized BEx to develop many queries needed for GPO3 reporting. Used Web application designer to develop web templates to call them in Portal. Pegasus application was developed using business server page and portal. BW BEx queries and web templates were invoked through portal.
  • Also, build many MDX queries for the GPO3 requirements. These queries were utilized in Pegasus applications.

Confidential,Portland,OR

Senior BW Consultant

Environment: SAP R/3 46C, LO cockpit, MM, SD, Flat Files, Oracle BW 31C, BEx.

Responsibilities:
  • Participated in Inbound optimization Data Modeling on BW side. The solution involved in delta enabling these extractors and populating them in base layer ODSs. Subsequently, populate them in many InfoCubes that are logically partitioned based on Plant for loading and reporting efficiency. MultiProvider was developed to create reports on these InfoCubes.
  • Participated in GPO3(Global Purchase Order) Phase 1 and did many developments.
  • Coded R3 user-exit to bring custom fields needed for GPO3 reporting using ABAP.
  • Partitioned PO Item ODS and PO Scl ODS based on Region and division. Developed info sets to report both PO Item and PO scl linking with Master data Objects for GPO3. Built MultiProvider on these InfoSets to act as a single source of report.
  • For Dec 04 release, Nike had one BW system for US/EMEA which was Non-Unicode and one BW system for Japan/SEA which was a Unicode system. Challenge to GPO3 project was linking these Unicode and Non-Unicode system and creating a Global reporting PO environment. Remote cubes were built to bring information from Japan/SEA system to US/EMEA BW system. MultiProvider was developed over this remote cube which brought PO information from Japan/SEA BW system and InfoSets that pulled information from US/EMEA PO ODSs.
  • Created Merge ODS on Japan/SEA system to bring PO Item and SCL Information as a single record. Database view has been developed on this Merge ODS on which Data Source has been developed. Remote cube was extracting information from Japan/Sea system through this Data Source via remote cube.
  • Worked on Process chains to accommodate all these changes and scheduled them in Autosys.
  • Worked with Business Analyst on many reporting solutions. Utilized BEx to develop many queries needed for GPO3 reporting. Used Web application designer to develop web templates to call them in Portal. Pegasus application was developed using business server page and portal. BW BEx queries and web templates were invoked through portal.
  • Also build many MDx queries for the GPO3 requirements. These queries were utilized in Pegasus applications.

Confidential,Portland,OR

Senior BW Consultant

Environment: SAP R/3 46C, LO cockpit, MM, APO-DP, Flat Files, Oracle BW 31C, BEx.

Responsibilities:
  • Involved in building WRP (Asia Pacific BW system) system landscape by developing Master data objects adopting from existing BWP Masterdata objects.
  • Purchase Order item, schedule line ODSs, Goods Movement ODS, Goods Movement PO Item merge ODS, Batch stocks ODS, Purchase Order line Item cube, Account assignment cube, Batch stocks cube have been extended to Asia pacific users building it by adopting from US/EMEA system.
  • Involved in Data modeling like Customer reporting, Non-Customer reporting, Size Analysis, Error handler/IDoctor.
  • Developed Design Overview and Tech spec for the models and worked with COE team to get the approval.
  • Developed Non-Customer cube. The driver for this was APO Material InfoObject. The transactional data of those materials were reported in the cube. Calculations of those key figures were carried out in start routine and update routine of update rule. Ending Inventory, Balance to ship were calculated by reading planning data Infocubes in the update rule using FM RSDRI INFOPROV READ. Planning data was pulled from APO system.
  • Involved in the integrating APO-DP data feed from R3 to APO through BW and pulling planning results from APO back to BW for reporting purpose.
  • Worked on Customer cube, to fill key figures based on rejection code, Customer group, Item category etc by having a lookup to Config table entries. Customer cube had load from Schedule line ODS, Sales History ODS and Error handler ODS.
  • Built MultiProvider and 3 basic cubes for Size Analysis. One cube had sales data, the other had history sales data. The third cube had forecast data at size level. Forecast data was loaded from planning cube. Data in planning cube was not at size level. While loading the data, size was derived by applying size curve. Used return tables for this.
  • The whole Sale price InfoObject load was delta enabled and data were loaded from DPR system (Oracle based system) through DB Connect. Implemented flexible update method for two wholesale price objects load and implemented logic to adjust decimal places of wholesale price based on currency. This is due to the fact that Japanese currency had no decimal places whereas other currencies had two decimal places. So logic was to have a lookup to TCURX table and adjust the decimal.
  • Programmed routines in Info packages of wholesale price Objects to fill up material interval from a config table using ABAP programming.
  • Modified PAR (Product Availability Report) and NAR (Nonavailability report) programs to retrofit for Japan/SEA. Moved those developments to AP environment.
  • Worked on PO Extractors 2LIS 02 ITM, 2LIS 02 SCL to add custom fields to the extractor and populated those fields through user exit EXIT SAPLRSAP 001. Participated in reload of PO data.
  • Developed Generic Text Extractor for an InfoObject text load.
  • Moved Master data InfoObjects to Japan/SEA Environment. Participated in the total build activities of Japan/SEA.
  • Followed SDLC process for all these developments.
  • Built process chains to support all the above developments and scheduled them in AutoSys Job Scheduler.

Confidential

BW Consultant

Environment: SAP R/3 46C, LO cockpit, SD, FI, Flat Files, BW 3.0B, BEx, Crystal Report 9.0

Responsibilities:
  • Worked with Business Requirement Document(BRD) to Capture Business reporting requirements, data Matrix to map all BW Objects with legacy and SAP data fields. Reviewed data Mapping and BRD documents to check Business Content.
  • Created Generic extractors using Function modules, table and views to extract data from R3 into BW systems.
  • Extended the Data source 0MATERIAL ATTR, 0PLANT ATTR, 0MAT PLANT ATTR for Master Data load from R/3 to BW. Edited User exit EXIT SAPLRSAP 002 to populate Master Data for extended fields and EXIT SAPLRSAP 001 for transaction data to extract from R/3 to BW using ABAP.
  • Worked extensively on Logistics Cockpit configuration Business Content data sources and to setup extraction of data from R3. Extracted data for profitability analysis, FI-GL, AR and AP, logistics and generic data sources.
  • Developed Confidential -PA extractor for EMEA extraction, loaded to EMEA Actuals cube. Activated Business content Costs and allocations InfoCubes in CCA and Payment History InfoCube in FI scheduled periodic uploading of data.
  • Customized business content InfoSources, ODS Objects and InfoCubes for SD, MM, Confidential, FI and PP modules
  • Created North Americas Sales Summary cube to Sales, Delivery and billed items information. Used LO extractors to pull the data from SAP R3 production system.
  • Setup flat file extraction for legacy data. Extracted Data related to Service returns from legacy systems like DNS and SPCP for EMEA Sales Return Analysis Cube and loaded data to Sales Return Analysis Cube. Required transfer structure and ODS was created to enable the staging flat file of data.
  • Scheduled Data feeds from SAP BW to legacy systems through Open Hub.
  • Used Ad-hoc query designer to built Ad-hoc queries for day to day reports
  • Created reports like Delivery Delays per Sales Area, Sales Volume, Sales year to Date and Date Validation for Sales using BEx and published them on Web using WAS. Using these Queries as data source many reports have been developed using Crystal reports 9.0.
  • Followed SDLC processes for these developments.

Confidential

Senior Technical Consultant

Environment: SAP 46C, MM, SD, FI, IM

Responsibilities:
  • Scrutiny on Functional design, time estimation and execution of technical specs. Allocating work to 3 other developers and meeting the deliverables in time.
  • Developed interface for processing Warehouse inventory Audit information sent by BOB Vendor. Based on the information, creating Physical inventory document, Count and Posting of document. Involves extension of Business object BUS2028 and developing processing function modules through BDBG and RFC function module to be called by business connector to create Inbound Idocs.
  • Developed Mailing program to monitor the PID that are counted but not yet been posted using ABAP.
  • Developed a Reservation Order interface which would create Outbound Idols and sends to BoB Vendor based on Sending and receiving plant. It involves extension of Basic IDoc type MRESCR01, other EDI settings to make use of extended Idoc type and Program to create Outbound Idocs.
  • Customizing workflow environment for the implementation of workflow
  • Workflow implementation for Release process in Purchase Order (BUS2012) and Purchase Requisition (BUS2009) through standard role resolution function.
  • Done Automation of stock transfer from Consignment to stock, when ZSKA order is created through workflow programming (BUS2032). Extended standard Business object and created ZBUS2032 to have stock transfer method, delegated system-wide. Activated Event linkage for BUS2032 object, “Created” event, for the newly created workflow.
  • Many other developments to support iGSO requirements.
  • Developed Inventory upload project in LSMW to upload data through BDC
  • Worked on FI document upload using program RFBIBL00 to upload legacy FI documents into SAP
  • Created Purchaser Requisition change Interface to change Purchase requisition quantity based on incoming data. Interface developed through ALE interface developing tool.

Confidential

SAP Techno functional consultant.

Environment: SAP 31I, SD and FI

Responsibilities:
  • Lead and Guided two developers in the project development efforts and complete technical developments as per project plan.
  • Developed signal processing Interface for billing Service Advance exchange issue (ZSKE) sales order for billing, ZSRA order for crediting, delivery and PGI. Signals will be received from SPCP/CSN.
  • Developed function modules to process file received from DNS system and create inbound Idocs
  • To make reservation, Delivery and PGI of Ad. Ex. Order. Made required EDI configurations and settings to achieve the functionality.
  • Developed reports to monitor age of Ad ex-order that is not yet billed.
  • Made changes to inter-company billing programs, extracts programs, Sales Order User-exits to implement Advance exchange order.
  • Set up schedules to periodically run signal processing programs in Sys-Admiral scheduling tool.
  • Created Authorization objects and authorizations to attach to user profile to control running of custom programs like Signal processing programs, extract program.

Confidential

SAP Techno functional Consultant

Environment: SAP 31I - SD and MM

Responsibilities:
  • Setup RFC destination to Business Connector, Port definition, Partner profile definition (For shipment Order and Shipment confirmation Idoc type: ZDESADV1 Message type: DESADV, For PO Notification IDoc type: Orders01, Message type: Orders and For Shipment receipt notification IDoc type: WMMBID01 Message type: WMMBXY) and condition record.
  • Developed custom IDoc type ZDESADV1 and made required EDI configurations to enable new IDoc type.
  • Developed Inbound function module to process IDoc to process inbound Shipment confirmation to do PGI, Shipment receipt notification to do GR in SAP. Developed requirement routine in case of outbound IDoc for PO Notification to restrict message type, only if receiving plant is 3PL Plant.
  • Made required EDI configurations to make use of newly developed function modules and corresponding process codes.
  • Worked with SAP Basis team to configure CPIC user and worked with Business Connector team to make BC to talk to SAP.
  • Guided Business connector team and 3PL technical team throughout all phases of project.

Confidential

SAP Techno-functional consultant

Environment: SAP 31I - SD MM and FI

Responsibilities:
  • Focal for Latin America and Canada for SAP Services related issues.
  • Lead two more developers to in the development efforts pertaining to GSO support.
  • SAP Development and production support for the service function of global operation of HP Services, USA. Developments include creation of reports and custom transaction modules, coupling of non-SAP systems with SAP systems through EDI and IDOCS, schedule setups, Modifications of layout changes, enhancements of existing functionalities to meet the current needs, Carrying out performance improvements to the existing programs.
  • Creation of Authorizations to restrict users handling custom programs and incorporating program to have authorization checks.
  • Developed RFC functional Modules to create Sales order through web for enabling service providers to create return orders as well as regular orders (ZSKB, ZSOR). Module pool programs and assigned transactions to support entering Authorizations to the users of SAP. The connectivity between Web and SAP was through Middleware Tuxedo.
  • Developed Module pool programs to update custom tables used in return process in case of any errors.
  • Debugging and fixing of day to day technical issues
  • Supporting MM, SD and FI Functional Consultants from Technical point of view
  • Scheduling using scheduling tools like Ashwin Scheduler and Sys-Admiral

Confidential

Sr. ABAP Programmer

Environment: SAP 4.0B, FI, HR and PS

Responsibilities:
  • SAP Production Support and development. Developments include creation of reports and custom transaction modules, Modifications of layout sets through Sap script, enhancements of existing functionalities to meet the current needs, carrying out performance improvements to the existing programs.
  • Training up new programmers on ABAP in SAP 4.0B environment. It was One and half month training program and programmers have been given a scheduled training on SAP Architecture, Basics of programming, Basics of Database design, SAP Dictionary, Advanced ABAP programming, Module pool programming, SAP script, API and function modules, ALE,EDI & IDoc technology and BAPI.

Confidential

Sr. ABAP Programmer

Environment: SAP 3.1H (CIN version 2.1B) - MM, CIN, QM and PM

Responsibilities:
  • Attended training given by PWC on R3 SD, MM, FI, Confidential -PA, PM Modules
  • Attended ABAP training by Titan system team
  • In-house Development and Version Management. Developments include creation of reports and custom transaction modules, Modifications of layout sets through Sap script and enhancements of existing functionalities to meet the current needs.
  • Confidential -ordination and development of Excise department for all custom development in CIN Module.
  • Documentation after User Sign-Off
  • Performance Tuning
  • Involved in Rollout Project of PM Module and carried out many developments

We'd love your feedback!