We provide IT Staff Augmentation Services!

Sap Bw Consultant Resume

Rochester, NY

PROFESSIONAL SUMMARY:

  • Over 15 years of IT experience which includes developing enterprise applications using SAP - BW, SAP R/3 and ABAP/4, design, development and deployment, and implementations using SAP-BW on HANA, SAP-ECC, WTX/Mercator.
  • Worked on SAP-BW on HANA and BW for 4 years.
  • Strong expertise in SAP BI 7.4, Transformations, DTP, Error DTP, DSO, Start, End Routines using Data Warehouse Workbench and Process chain, Open hub destination, using User Exits, BEx Query Analyzer.
  • Extensive experience in SAP-BW components like Info Objects, Info Cube, DSOs, Info Providers, Data sources, Multi providers, Info sets, Info package.
  • Used Flat File, BO-DS (ETL) data services, SLT Data Provisioning pull data into HANA DB, Attribute views, Analytical views & calculated views.
  • Working knowledge of LO COCKPIT, CO -PA Extractions from SAP ECC6 & Deltas ABR, ADD, AIE.
  • Data extractions from FI-CO, Logistics (SD, MM), Generic data sources, Classic info sets and Flat File.
  • Extensive experience in BI, analyzing and activating appropriate Business Content for requirement.
  • Used Rule group & Return Table concepts in mapping.
  • Migrated BW 7.3 info cube, DSO into SAP 7.4 BW-HANA SP7 optimized objects & Composite provider from SAP-HANA to SAP-BW 7.4 and Transient provider.
  • Worked Extensively in BEx Analyzer in building Queries, Sound knowledge of R to R reports, exceptions, conditions, structures and filtering of data.
  • Performance tune Info cube using NRIV buffering.
  • Worked extensively in modules FI-CO, SD, MM, PP & HR.
  • Extensive knowledge of HIPAA standards, EDI ANSI X12, EDIFACT, XML and IDOCs.
  • Specialized in EDI Mapping - HIPAA compliancy and SAP R/3 integration implementations using Mercator product suite.
  • Extensive experience in HIPAA/Mercator based implementations at two Confidential Organizations (High mark and Empire).
  • Working knowledge of RDBMS such as Oracle, SQL Server.
  • Good interpersonal skills and a motivated technical lead and a team player.
  • Seven years of experience in manufacturing industries in the field of Re-engineering, production, projects and maintenance.

TECHNICAL SKILLS:

Languages: ABAP/4, SQL, PL/SQL, VB 5.0, HTML

SAP, BW: SAP-BW 7.4 on HANA, 7.3, SAP-ECC6, SAP-R/3 V4.0

Data Bases: SAP-HANA, Oracle, SQL Server, Tera, DB2.

GUI: SAP GUI, Oracle Developer 2000 & Visual Basic

EAI/EDI Tools: WTX/Mercator 1.4.2, 2.1.1, 5.0, 6.x, 7.5, 8.x

Operating Systems: Various UNIX flavors AIX, Sun Solaris, SUSE Linux 11.2, Windows NT, 2000, Windows Prof.

Others: MS Office, Visio, XML, EDISIM, IBM MQ

WORK EXPERIENCE:

SAP BW Consultant

Confidential, Rochester, NY

Environment: SAP BW 7.4, BEx Analyzer, SAP ECC6, SD, ABAP/4 & HANA.

Responsibilities:

  • Created Info Objects, Info Sources, and Data targets, Info Packages, Info Cubes and Data Sources to load Master and Transactional data from SAP ECC6 into BW system.
  • Experienced in new Extract structures using Logistics Cockpit- (LO Cockpit), which includes the functionality as Maintaining the extract structures, Maintaining data sources, Activating updates.
  • Worked on the extraction of CO-PA (SAP EEC6) Data into BW.
  • Worked extensively on administration workbench and Managed and Monitored data loads with full update and Delta mechanism.
  • Activated Sales cubes (0SD C01, 0SD C02, 0SD C03, 0SD C05) from business content.
  • Created the info packages and scheduled data uploads such as Full and Delta updates.
  • Create R to R report (Jump report) on sales data to show drill down of details customer & material.
  • Created a Generic extractor with data capability from a database view (Purchase order).
  • Created Attribute views, Analytical views & calculated views in HANA.
  • Developed return table concept to load data into DSO.

SAP BW Consultant

Confidential, Rochester, NY

Environment: SAP BW 7.4, BEx Analyzer, SAP ECC6, FI-CO, SD & HANA.

Responsibilities:

  • Worked on Customer (0SD C01), Quotations (0SD C05), Revenue (0MSA C03) extraction from SAP ECC6 and created info cubes as per requirement.
  • Design, development and extraction of data from ECC source system into BI for SD and MM.
  • Used LO cockpit extraction method for SD & MM data extraction from SAP ECC6.
  • Worked extensively on BEx analyzer, Developed queries using filters, Calculated Key Figure, Restricted Key figures, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down way to give detailed levels of information.
  • Compressed Info Cubes, updating DB statistics regularly and rebuilding missing indexes for reduction in the Query Response time.
  • Enhanced extract structures for data sources pertaining to FI-CO Accounts Payable 0FI AP 4 & Accounts Receivable 0FI GL 4.
  • Activated profit center accounting, accounts payable, accounts receivable cubes as a part of cross-functional SAP BW implementation.
  • Created sales Info cubes for sales data based on company code, sales area, and sales division.
  • Created Data Sources through RSO2 in SAP ECC6 using Database Views and Info Set queries for transactional data.
  • Migrated BW 7.3 info cube, DSO into SAP 7.4 BW-HANA optimized objects
  • Created Composite provider from SAP-HANA to SAP-BW 7.4 and Transient provider.
  • Used Flat File to load tables, BO-DS (ETL) data services to pull SAP transactional table data, SLT (Data Provisioning) pull data into HANA.
  • Used Rule group concept for loading data into Info cube.

SAP BW Developer

Confidential, Macon, GA

Environment: SAP BW 7.3, SAP ECC6, ABAP/4 & Oracle 10.2.0.2.0

Responsibilities:

  • Data extraction from 2LIS 04 P ARBPL and 2LIS 04 P MATNR into Custom-build cube using LO Cockpit.
  • Extended standard extract structures and user exit on SAP EEC6.
  • Worked on the extraction of CO-PA (SAP ECC6) Data into BW.
  • Configured and Created a Custom Info Cube on Billing and Delivery Details.
  • Monitoring the Data loads and correcting the Failed Data Requests and Resubmitting the data.
  • Developed report on Proof of Shipment Report with tracking ID and shipment unit numbers, Returns Order.
  • Developed a report for list of incomplete sales orders, open orders, display contracts, customer-material information records, billing due lists in a sales area, rebate agreements, open deliveries.
  • Worked with BEx reporting to create reports.
  • Used Rule group concept for loading data into Info cube & DSO for sales planned & actual revenue.
  • Developed return table concept to load data into DSO.
  • Performance tune Info cube using NRIV number buffering.
  • Created a Multi Provider on Financial cubes to meet the reporting requirements.
  • Worked on loads and scheduling with Process Chains.

SAP BW Developer

Confidential, Fort Mill, South Carolina

Environment: SAP BW 7.3, BEx Analyzer, SAP ECC6, FI-CO, SD, MM & Oracle 10.2.0.2.0

Responsibilities:

  • Created Info object, Info cubes & DSO’s as per requirements and loaded data.
  • Loaded data into Master data Info objects for attributes, text and Hierarchy.
  • Modified existing reports according to user requirement.
  • Created an DSO for Billing Historical Data and loaded data from the Flat File.
  • Performed analysis, design, development and implementation of standard / customized Info Cubes and ODS Objects for FI, MM and SD modules.
  • Used BEX Analyzer for BEx Query Designer.

Sr. Analyst/Developer

Confidential, PA

Environment: WTX/Mercator 8.1/8.2/8.3 on UNIX Sun Solaris and Windows 7 Enterprise.

Responsibilities:

  • Developed 5010 maps for processing claims (Dental, Professional and Institutional 837), Remittance Advice (835) and Enquiry process for various trading partners.
  • Developed maps for Confidential partners.
  • Developed for file duplicate check map for UCCI claims.
  • Deployed, Tested and put the transactions on UNIX Sun Solaris operating system for versions 4010 & 5010 versions.
  • Bug fixes to 4010 Real time maps 270,271,276,277.
  • Developed 5010 maps (8 no.) for processing IBC claims (Professional and Institutional 837).
  • Debugging couple of IBC Message Broker Flows to find the root cause of problem.
  • Prepared technical doc for developed maps & Bug fixes.
  • Developed maps (7 no.) for EIL re-design process, with source as Flat, XML and translated to flat file and XML formats.
  • Developed maps (5 no.) for CMS process, with source as Flat, XML and translated to Copybook and XML formats. Created Medical, Pharmacy & Enrollment maps for outbound XML formats & Created Pharmacy & Enrollment error report copybook formats for outbound process.

Mercator Analyst/Lead/Sr Developer

Confidential, GA

Environment: Mercator 8.1 on UNIX AIX and Windows 2000

Responsibilities:

  • Designed and developed Mercator map for 110 FedEx(small package) Invoice flat file format and transform data into XML output. This XML output was sent to MQSI for loading into DB2 tables for use by Manhattan transportation package.
  • Designed and developed Mercator map for 210 UPS(small package) Invoice flat file format and transform data into XML output. This XML output was sent to MQSI for loading into DB2 tables for use by Manhattan transportation package.
  • Designed and developed Mercator map for 210 Others Invoice flat file format and transform data into XML output and load the DB2 stageing table when required. This XML output was sent to MQSI for loading into DB2 tables for use by Manhattan transportation package. This map had a critical mapping requirement.
  • Designed and developed Mercator map for 850 flat file purchase order, to transform the data and load the PO data into DB2 PO repository. The transformation had critical requirement.
  • Handled high volume transformation and performance tuned the maps.
  • Developed Mercator map for Inbound PO from store to Distribution center. Transformed the flat file to XML format.
  • Designed and developed Mercator map for Inbound PO and ASN from SOM for Lumber Implementation. Transformed the flat file to XML format.
  • Developed Mercator map for outbound PO from DC to DC. Transformed the flat file to XML format.
  • Developed router maps for distribution across various servers using IBM MQ.
  • Developed maps for error handling and also created UNIX scripts.
  • Designed and developed Mercator map for Inbound ASN from SOM for Rapid development code Implementation. Transformed the flat file to XML format. The critical part beening to consolidate the ASN & check the Staging tables for sequence numbers for the sku.
  • Production support for Lumber Implementation done from Feb’07.
  • Designed and Created Error handling maps Re-Start rerun and Re-Start Reject for the WMS implementation.

Mercator Developer

Confidential, MI

Environment: Mercator 6.7 on Windows.

Responsibilities:

  • Fixed bugs for 837 map for NSF formatted claim process.
  • Modified maps of NSF format for the new requirements and change in design.
  • Fixed bugs for 837 map for UB-92 formatted claim process.
  • Modified maps of UB-92 format for the new requirements and change in design.

Mercator Analyst/Developer

Confidential, MI

Environment: Mercator 7.5 & 6.7 on UNIX Sun Solaris and Windows XP

Responsibilities:

  • Developed map for canned 271 response for, when inbound 270/271 failed validation or 271 response timed out and also send custom error message based on payer.
  • Developed map for canned 277 response for, when inbound 276/277 failed validation or 277 response timed out and also send custom error message based on payer.
  • Developed map for canned 278(11) response for 278(13)-278(11), when inbound 278(13)/278(11) failed validation or 278 response timed out and also send custom error message based on payer.
  • Developed Custom TA1 map when Inbound 270/271, 276/277 or 278(13)/278(11) failed Compliance checker.
  • Developed map for Dental 837D to 719 Flat File. The critical part of the map was to generate an Document no which is an combination of Sequence number & Batch number.
  • Developed X12 maps for supplier connection for Confidential . The transactions were inbound 830(Planning Schedule) & 862(Planning Schedule) and the output is an XML format. And outbound 856(ASN) was developed for XML format to X12.
  • Developed EDIFACT maps for supplier connection for Confidential . The messages were inbound DELFOR & DELJIT and the output is an XML format. And outbound DESADV(ASN) was developed for XML format to EDIFACT DESADV.
  • Developed map for GM-Saturn EDIFACT DESADV to Flat file. Also developed custom DESADV validation map to suit the requirements.
  • Developed map for GM X12 214(Transportation Carrier Shipment Status Message) & 213(Motor Carrier Shipment Status Inquiry) to Flat file. Also developed custom DESADV validation map to suit the requirements.
  • Tested some the transactions based on the EDS given outputs.

Aug Mercator Analyst

Confidential, IN

Environment: Mercator 6.7 on UNIX AIX and Windows XP

Responsibilities:

  • Designed and developed Mercator map for data listing from SAP using BAPI calls for Customer details.
  • Helped in Installation of the Mercator SNMP agent, trouble shoot problems while installation and designed the use of the SNMP adapter in Error handling and notification errors in the Mercator maps.
  • Installed the Mercator Resource registry and made use of the registry in the developed maps and set standards for usage in maps.
  • Modified Mercator Event Server Scripts for running multi Event Servers.
  • Designed and developed Mercator map for using Mercator Confidential adapter for Manufacturing order maintenance (ZLIVPO01)). The Order IDoc was pulled from SAP Gateway using Confidential adapter and was transformed into XML and used FTP adapter to transport the other application (Insite).
  • Designed and developed Mercator map for using Mercator Confidential adapter for Product Maintenance (ZMATMAS05). The Order IDoc was pulled from SAP Gateway using Confidential adapter and was transformed into XML and used FTP adapter to transport the other application (Insite).
  • Helped the Client in Designing 997 Reconciliation project for balancing in and out going X12 & 997s by storing data in database.
  • Designed Generic map for Sales History (867) to accommodate multi-trading partners. The X12 from multi partners was transformed into SAP Idoc for posting into SAP for charge backs.
  • Designed Generic map for Outbound Invoice (810) to accommodate multi-trading partners. The IDoc from SAP was transformed into X12 810. This Generic map was used by Government and Commercial partners.
  • Documented all Map flow in VISIO for the Production support and Mercator users.

Mercator Analyst

Confidential, PA

Environment: Mercator 6.0/6.5/6.7 on UNIX Sun Solaris and Windows 2000

Responsibilities:

  • Worked on the Blue Exchange project on the transactions and and Worked on Fast Real Time Project for .
  • Deployed, Tested and put the transactions to production on UNIX Sun Solaris operating system for versions 4010 & 4010A1 and Technical resource for Production support team.
  • Developed maps for UCCI (United Concordia Insurance), which is a subsidiary to Confidential Blue Shield. The transactions worked were, 835 & 837 Dental & 837 Institutional for both 4010 & 4010A1(Addendum) versions of IG.
  • Developed maps for real time & Batch mode Processing of the Eligibility process and Claim Status process.
  • Created an Orphan email map to alert if any Claim is left as Orphan. (No response was sent for the claim)
  • Fixed Production problems in Eligibility process for Confidential 4010 maps.
  • Fixed Production problems in Claim Process for Confidential 4010 maps.
  • Worked in Confidential Blue Exchange project for 4010 & 4010A1 versions and developed Routers for 271 & 277 Responses and translated the copybooks to X12 270, 271, 276 & 277 transactions.
  • Worked on the XML Meta data for 4010A1 Version, Which is a feed for B2B Process (Web application) for inbound & outbound transactions 270,276,835,837, 271,277.
  • Worked on the error status data feed (AAA & STC) for B2B process for 271,277 & 277CA transactions.
  • Fixed production problems as being the Technical resource for the, 837 Dental, 837 Institutional and Blue Exchange transactions.

Lead / Sr. Developer

Confidential, NY

Environment: Mercator 5.0/6.0, IBM Mainframe (MVS), COBOL, and Windows NT.

Responsibilities:

  • Design the generic process flows for trading partner validation, handling acknowledgments and for handling errors.
  • Document technical specs/mapping rules for developers.

Mercator Consultant

Confidential, IL

Responsibilities:

  • Database adapters for data movement from DB2 to Oracle, Oracle to oracle, Oracle to DB2, SQL Server to oracle databases and also calling Oracle stored procedures.
  • File adapter for read/write to file/Database.
  • IBM MQ Series server adapter to read/write data from queues to database.
  • E-mail adapter for notifications.
  • Shell script adapter for calling scripts.

SAP Consultant

Confidential, MI

Responsibilities:

  • Worked extensively with the IDoc importer for creating type trees.
  • Developed Mercator map for loading Vendor master records using Idoc type Confidential .
  • Used Mercator for mapping the data from legacy to IDoc structure.
  • The output file from the Mercator is used to load data to SAP through Confidential .
  • Developed Mercator map for loading Customer master data using Idoc type DEBMAS03. Used Mercator for mapping the data from legacy to IDoc structure.
  • Developed Mercator map for loading Goods receipts data using Idoc type WMMBID01. Used Mercator for mapping the data from legacy to IDoc structure.

SAP Consultant

Confidential

Responsibilities:

  • Created an interface that extracts the tax data from SAP. Used mapping tool Mercator to map the source file from SAP to the required legacy format.
  • Modification the system program RFKQSE10 (With Holding Tax) to extract data from SAP.
  • Created an interface that extracts the data from SAP for Tax Identification number. And used mapping tool Mercator to map the source file from SAP to the required legacy format.

SAP Consultant

Confidential, MI

Responsibilities:

  • Worked on Type Editor to create Input and Output Type Trees.
  • Worked on Map Editor and generated Input and Output Cards.
  • Worked on IDoc Importer of Mercator and generates Inbound IDoc Structures.
  • Developed Mercator map for loading Vendor master data using Idoc type Confidential .
  • Used Mercator for mapping the data from legacy to IDoc structure.
  • The output file from the Mercator is used to load data to SAP through Confidential .
  • Developed Mercator map for loading Material master data using Idoc type MATMAS01.
  • Used Mercator for mapping the data from legacy to IDoc structure. The output file from the Mercator is used to load data to SAP through Confidential (MATMAS01).
  • Generated Input Type Trees, Output type tress, Input Maps and Output Maps for inbound IDoc INVOIC01.
  • Worked on DB Utility of Mercator and generated Input Type Trees, Ouput Type Trees, Input Maps and Output Maps for output in ASC format.
  • Worked in reports, batch data communications / data transfers and in areas of FI, CO, SD, MM & PP.
  • Worked in reports and scripts in areas of FI, CO, SD, MM and PP modules.

Hire Now