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 Blue Cross Blue Shield 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:

Confidential

• Care stream Health is a leader in medical film and digital imaging solutions, with healthcare IT and workflow solutions to support specialty and general radiography and non-destructive testing x-ray systems and advanced materials for precision film. Being a BW developer, I was exposed to COPA LO cockpit data extractions reporting.
• Environment: SAP BW 7.4, BEx Analyzer, SAP ECC6, SD, ABAP/4 HANA.
• 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.

Confidential

• Eastman Kodak Company commonly known as Kodak, is an American technology company. And is focused on imaging for business and provide innovative hardware, software, consumables and services. I was exposed to performance tuning, reporting, BI content data extraction.
• Environment: SAP BW 7.4, BEx Analyzer, SAP ECC6, FI-CO, SD HANA.
• 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.

Confidential

• Thomson makes cycling products and is viewed as an industry leader in the production of high-end bicycle components and its maximum revenue is through making parts for aviation companies. I was exposed to data extraction, performance tuning, process chains reporting.
• Environment: SAP BW 7.3, SAP ECC6, ABAP/4 Oracle 10.2.0.2.0
• 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.

Confidential

• Domtar is the largest producer of uncoated paper in North America and the second largest in the world based on production capacity and it also manufacturer of paper grade pulp. Developed BW objects and loaded data created reports.
• Environment: SAP BW 7.3, BEx Analyzer, SAP ECC6, FI-CO, SD, MM Oracle 10.2.0.2.0
• 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

• Environment: WTX/Mercator 8.1/8.2/8.3 on UNIX Sun Solaris and Windows 7 Enterprise.
• Worked as WTX/Mercator Sr. analyst/developer for HIPAA Implementation project at Highmark. Developed maps for the 5010 version 837 claim process Remittance process 835 transactions. Developed maps for transactions also developed for EIL CMS project flat file, XML source Target formats fixed bugs.
• Developed 5010 maps for processing claims Dental, Professional and Institutional 837, Remittance Advice 835 and Enquiry process for various trading partners.
• Developed maps for Highmark partners.
• Developed for file duplicate check map for UCCI claims.
• Deployed, Tested and put the transactions on UNIX Sun Solaris operating system for versions 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.

Confidential

Environment: Mercator 8.1 on UNIX AIX and Windows 2000

• Worked as Mercator Analyst/Lead for the Transportation management system and Warehouse management system projects. Designed maps for 110 which processed data and loaded data to the DB2 database and output XML format for another application like MQSI to load to DB2 tables and used IBM MQ extensively for message integration between various applications.
• 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

• Environment: Mercator 6.7 on Windows.
• Worked as Mercator Developer for the HIPAA implementation. Developed and modified maps for NSF UB-92 837 claim process.
• 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.

Analyst/Developer

Confidential

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

• Worked as Mercator Analyst/Developer through the HIPAA Automotive transaction implementation. Designed generic canned responses maps for and, Developed maps for 837D to 719 Flat File and TA1 generation and Developed maps for Supplier connection EDIFACT messages and XML in/out puts.
• 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 response for, when inbound / 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 / 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 General motors. 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 General motors. 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.

Mercator Analyst

Confidential

Environment: Mercator 6.7 on UNIX AIX and Windows XP

• Worked as Mercator Analyst and led the team of employees and Developers through the SAP-Mercator implementation. Designed generic maps for Sales History 867, Outbound Invoices 810 for Wide area network, Designed maps for using ALE adapter for outbound Idocs for manufacturing engineering services project MES and also designed common error handling using SNMP agent.
• 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 ALE adapter for Manufacturing order maintenance ZLIVPO01 . The Order IDoc was pulled from SAP Gateway using ALE adapter and was transformed into XML and used FTP adapter to transport the other application Insite .
• Designed and developed Mercator map for using Mercator ALE adapter for Product Maintenance ZMATMAS05 . The Order IDoc was pulled from SAP Gateway using ALE 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

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

• Worked as Mercator analyst / developer for HIPAA Implementation project at Highmark. Developed maps for the 837 claim process flow Eligibility and designed the and 278 transactions.
• Developed maps for processing claims Dental and Institutional 837, Remittance Advice 835, Eligibility Inquiry 270, Eligibility Response 271, Claim status 276, and Claim status response 277 .
• 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 A1 and Technical resource for Production support team.
• Developed maps for UCCI United Concordia Insurance, which is a subsidiary to Highmark Blue Shield. The transactions worked were Dental 837 Institutional for both A1 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 Highmark 4010 maps.
• Fixed Production problems in Claim Process for Highmark 4010 maps.
• Worked in Highmark Blue Exchange project for A1 versions and developed Routers for Responses and translated the copybooks to X12 270, 271 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 CA transactions.
• Fixed production problems as being the Technical resource for the, 837 Dental, 837 Institutional and Blue Exchange transactions.

Sr. Developer

• Environment: Mercator 5.0/6.0, IBM Mainframe MVS, COBOL, and Windows NT.
• Worked as lead/senior developer for HIPAA Implementation project at Empire. Designed and developed maps for processing claims, Professional and Institutional 837, Remittance Advice 835, Eligibility Inquiry 270 and Eligibility Response 271 . Deployed and tested the transactions on Mainframe MVS Platform.
• Designed 837 professional Institutional claims for electronic and paper claim processes for private systems.
• Developed map for 837 professional COB for MED-B inbound. The input format used is ANSI X12 version 4010 and the output structure is HCFA flat file.
• Developed map for 837 Institutional COB for MED-B outbound. The input format used is flat file and the output structure is HCFA flat file.
• Developed map for 835 MED-A outbound. The input structure is flat file and the output structure is HIPAA format IG .
• Developed map for 270 inbound which transforms to an XML output file.
• Developed map for 271 outbound, which reads XML, input file and transform it into a HIPAA compliant output file.
• Modified map for creating Acknowledgment 997 for 837 professional COB for MED-B.

Responsibilities Include:

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

Confidential

• Worked in various projects like Enterprise Ware Housing, Profitable market optimization, EMIX, International data transfer and DPROP data movements. Developed number of maps and integrated the maps for platforms like AIX UNIX, NT and Sun Solaris using Mercator version 2.1.1 5.0 and also tested put the applications to production.
• Handled the following adapters:
• 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.

Confidential

Miracle SoftWare Systems

Worked as team member for Interfaces Implementation in SAP R/3. Was involved in Mercator mapping, EDI / ALE / Idocs, reports BDC for one time periodic data migration. Used Mercator as the mapping tool.

Interfaces:

• Worked extensively with the IDoc importer for creating type trees.
• Developed Mercator map for loading Vendor master records using Idoc type CREMAS01. 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 ALE CREMAS01 .
• Developed Mercator map for loading Customer master data using Idoc type DEBMAS03. 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 ALE DEBMAS03 .
• Developed Mercator map for loading Goods receipts data using Idoc type WMMBID01. 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 ALE WMMBID01 .

Confidential

Team member in Interfaces implementation for one time periodic data migration in area of MM FI/CO. Used Mercator as the mapping tool.

Interfaces:

• 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.

Miracle SoftWare Systems

Involved from the initial phases of Implementation as an ABAP/4 programmer. Developed BDC programs to transfer legacy data to SAP R/3 system. Involved in data mapping using Mercator.

EDI / Mercator

• 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 CREMAS01. 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 ALE CREMAS01 .
• 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 ALE 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.

Programmer

Confidential

Worked on reports, batch data communications in areas of SD,MM PP-PI