SUMMARY:

• Delivery focused and Process oriented Application Development professional with extensive technical experience and strong leadership skills. Over 14 Full SAP life cycle implementations.
• Over 19+ years of SAP Development Lead, SAP Technology Architecture and SAP Data Management experience.
• Over 5 years of SAP Business Objects Data Services (BODS) and over 5 years of SAP BW/BI,
• SAP NetWeaver Certified, with global project experience in the US, Australia and Europe.
• Champion in various SDLC stages and global delivery in multi country SAP rollouts.
• Experience in managing and developing technical resources in various organizations.
• Demonstrated ability to effectively influence peers and management across the organization.
• Highly skilled in collaborating with Business, Functional and technical SME’s.
• Experience in development lifecycle governance and process methodologies in multiple clients.
• Proven track record in coordinating, scheduling and measuring Project deliverables.
• Worked with major consulting firms such as Pricewaterhouse, CapGemini, IBM and Accentureglobally as a Technical Lead and Architect.
• Experience in Business Objects Data Services BODS development, integrating flat files and Legacy data sources to SAP ECC from third party applications.
• Experience in BODS Data Quality, Data Cleanse and Address Cleanse transforms for SAP CRM.
• Experience in Information Steward - Data Quality, Data Scores, Validation Rules, Metapedia, Cleanse Package.
• Expertise in ETL activities like Data Extraction, Data Modeling, Loading (Full/ Delta upload), and scheduling data loads, creating process chains for data load automation, monitoring process chains for data load issues.
• Expertise in BW components like Extractors, InfoCubes, DSOs, MultiProviders, InfoObjects, InfoSources, InfoSets, Transformations, DTP, Start routines, End routines, Update rules, Transfer rules, InfoPackages.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, FI-GL, FI-AP, FI-AR, MM, generic extractions and extraction from flat files, non-SAP systems and DB connect .
• Over 12 years of ABAP/4 development experience in MM, SD, FI-CO, CRM and SCM, which included ABAP/4 Editor, data dictionary, reporting, transactions, BADI’s, User Exits & Enhancement Spots.
• Mentored & coached Technical staff as a Manager and Team Lead on SAP Developments and ALE/EDI best practices.
• Performance Tuned SD and FI interfaces and report programs with long runtimes at PepsiCo, and brought very significant s in the runtimes.

TECHNICAL SKILLS:

SAP HANA Modeling: Attribute Views, Analytic Views and Calculation Views. SQL Scripts and SQL Procedures, ABAP Procedures and CDS Views in HANA

BOBJ Analytics: SAP Lumira, SAP Design Studio, SAP Dashboards, Xcelsius, WEBI, Crystal Reports.Business Objects Data Services (BODS):Batch Job, Data Flow & Workflow creation and Management, Validation Transforms, Case Transforms, SQL Transforms, Management Console, Troubleshooting ETL, Functions and Scripts in Data Services, Address Cleansing, Data Cleansing in Data Quality, Match Data consolidation.

Information Steward: Metadata Integration, Basic and Complex Data Profiling,Data Quality Scores, Building Simple and Complex Validation Rules, Rule Binding, Metapedia Terms, Creating Custom Cleanse Packages.

BI/BW: ETL Process, Info-objects, DSO, Infocube, Multiproviders, Infosets, Transfer Rules, Update Rules, Start Routines, End Routines, Transformations, Generic Extractors, BOBJ Data Services, BOBJ DQMSAP ABAPOO ABAP, CRM BDOCs, BAPI s, BADIs, User Exits, Enhancement Spots and Points, ALE/EDI/Idocs, XI/PI Integration, ABAP Proxy, CIF, LSMW, BDC, RFC, ITS, Webdynpro for ABAP,SAP Script, Smartforms and Bar-coding, Dialog Programs, Function Modules, and BSP s.SAP ERP:ECC 6.0, ECC 5.0, Modules (SAP Supply Chain Management, SAP Warehouse Management, Radio Frequency RF Device Programming, SAP CRM, CRM Middleware Integration and Development, ISA, Sales & Marketing, CIC including IC Webclient/Winclient, SAP HCM-Personnel Administration PA, Organizational Management OM, Employee Self Service (ESS) & Manager Self Service (MSS), Enterprise Portals 6.0, IS Media, IS Retail, IS Auto, IS Real Estate, MM, PP, SD and FI-CO, ALE-EDI-IDOC Integration Architect.

Industry Solutions: IS Retail, SAP AFS, IS Auto, IS Media, IS Real Estate

Industries: FMCG. Chemical, Retail, Aerospace, Manufacturing, Government, Banking

Business Process: Order to Cash, Procure-to-Pay, Plan-to-Produce.

PROFESSIONAL EXPERIENCE:

Confidential, Montvale NJ

SAP HANA/BI Analytics Architect

Responsibilities:

• Developed an Opportunities HANA Model using Attribute Views, Analytics Views and Calculation Views to be consumed by SAP Lumira for advanced data analytics and visualizations.
• Data provisioning into HANA CRM Leads and Opportunities tables using SAP Data Services.
• Developed BI Universe on HANA tables for RESTful Webservice API calls from the external Angular.js based web application.
• Developed Lumira based analysis application for Mobile Phone and IPAD integration
• Integrated Predictive Analytics and Machine Learning using HANA Predictive Libraries and R Functions for advanced predictive analytical models.

Confidential, Lake Forest, IL

SAP Data Migration Architect - SAP CRM to Salesforce

Responsibilities:

• Involved in technology selection of Data migration ETL tool. Presented options between SAP BODS and IBM IIS Datastage.
• Analyzed the SAP CRM system and came up with extraction maps for CRM Accounts and Contacts.
• Mapped and translated data between SAP and Salesforce and intermediate MDM system.
• Solution architected and built Data Services ETL Jobs for Accounts, Contacts, Opportunities, Activities and Notes and Attachments..
• Extensively used SAP Lumira for analyzing and visualizing SAP Accounts and Contacts and prepared storyboards.
• Designed and built the end to end solution to load high volume SAP CRM data into Salesforce via MDM.
• Designed and built over 30 IIS jobs to load SAP CRM Master and Transactional data and Key values into Stage tables to be consumed by Salesforce Bulk data loader and Jitterbit loader.

Confidential, Milwaukee. WI

SAP Data Management Architect - BODS/Information Steward

Responsibilities:

• Involved in a large Data migration project using BODS to merge 2 SAP systems into a new Greenfield SAP system.
• Developed Data profiling and cleansing strategy and DQA architecture to integrate with BODS.
• Advanced Data profiling legacy data using Information Steward 4.2. Address profiling and cleansing of US and Canadian Addresses for Customers and Vendors.
• Built Scorecards and Validation rules for Customer, Material and Vendor Data.
• Used SAP Design studio to build visualization dashboards for Vendor and Customer data.
• Used components and scripts in SAP Design studio and analyzed data from multiple data sources.
• Defined Data cleansing rules using Cleansing Package and Data cleanse wizard.
• Configured postal validation and de-duplication of Vendors/Suppliers in SAP MDG.
• Loaded Material Master ( 7 material types- including Raw Materials, Finished and packaging goods) and Customer Master including Classes and Characteristics data, using Rapid Deployment Services (RDS) for BODS 4.2.
• Configured ALE/IDOC’s message types and partner profiles for RDS IDOC backend ECC Loads.

Confidential, Saginaw, MI

SAP Application SME and Technical Audit Lead

Responsibilities:

• Auditing WRICEF objects that are being developed by over 120 developers globally, in one of the largest SAP implementations in the world.
• Setup ABAP development best practices, governance methodology and compliance and ensuring RICEF development throughput.
• ABAP Code review of over 600 technical WRICEF objects using code inspector, manual code spot audits.
• Performance Tuning using Runtime Analysis and SQL trace of long running WRICEF’s and recommendations for improving runtimes

Confidential, Libertyville

SAP Technology Manager, Global Applications Development

Responsibilities:

• BO Data Services - Architected and Designed complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system into SAP ECC for Sales Price History analytics.
• Built Data Scores and Redundancy and uniqueness advanced data profiles for customer master and addresses using Information Steward.
• Developed accuracy, completeness and conformity quality dimension validation rules using Information Steward and analyzing Data Quality Scores.
• Advanced Table and Columnar Validation Rules Data, Quality Score Card dimension analysis for Product Master and Sales History using Information Steward.
• Led a Data Migration project of customer and material data into SAP ECC for Southern Europe SAP implementation, using Data Services and MATMAS IDOC’s and Custom RFC’s & wrapper Function BAPI’s for end to end Legacy PRMS-BODS-SAP integration.
• Managed Data conversions for SAP Nordics Project uploading Data cleansed via BODS and loaded into SAP via LSMW’s and Custom Batch input programs
• Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Led sessions explaining usage of templates and gathering ideas for improvement.
• Architected a Global Pricing Database by loading cleansed data from disparate flat files and merging and consolidating using Data flows and Query and Validation transforms.
• Managed a 1.7 Million dollar cost center for Global Application Development at Confidential in SAP BPC,
• Managed a Global team of 12 SAP ABAP/BW, E-Commerce and EDI Application developers in US, Germany and India.
• Architected interfaces for integrating SAP ECC Sales data with Sales Force.com and HR data to SAP Success Factors using Web Services based E-SOA architecture.
• Introduced best practices for Data Services, Xcelsius and Crystal Reports development.
• Worked on improving Data Quality and Defining Data Cleansing methodologies i.e. Matching and Merging of Duplicate records in SAP CRM, Data Completeness, Data Enrichment.
• Designed Postal Address Validation and data de-duplication transforms for SAP CRM 7.0 using advanced match wizard and data match rule based consolidation.

Confidential, Chicago

SAP Technology Lead

Responsibilities:

• Led the project team in setting up BO Data Services (BODS) Development, Test and Production environment by setting up a local and central repository and migration of reusable of objects such as Jobs, Workflow, and Dataflow both by Import/Export directly and Checking In/Out in Central Repository.
• SAP Information Steward, Metadata analysis and Metapedia on Product Master data.
• Information Steward: Developed custom Data Cleanse Package for data transforms for use in Data Quality. Worked with Flat files for parsing and tokenizing the raw data.
• Creating table based and rule based data quality dashboards using Information Steward for Product, Customer and GL Accounts data.
• Developed different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions like ifthenelse(), substr, lookup, lookup ext etc.
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Designed an ALE/EDI solution to transmit Classification and GL Accounts Data to over 90 different environments across the Confidential Landscape in 4 continents.
• Architected a complex solution for integrating a TPM-BI-APO model for Trade promotion Management.
• Led a global team of ABAP developers and implemented RICEF governance and procedures and ABAP standards and best practices.
• Liaised with Offshore Factory (Infosys) and did extensive QA reviews for Radio Frequency device developments.
• Completed integration of quality assurance process that has reduced delays in construct, SIT defects, scalable solutions, and performance optimization.
• Managed staffing plans and work task assignments within Pepsi Center of Excellence.

Confidential, Latrobe, PA

SAP CRM Middleware Lead

Responsibilities:

• Performed Web UI enhancements to Opportunities, Leads and activity management, business partners and products in the BOL Layer including UI configuration and BSP enhancements
• Performed custom field enhancements in Opportunities using AET tool.
• Performed BADI implementation for Leads and Opportunity Management.
• Perform Data Replication from ECC to CRM, which includes configuration, Master Data (Business Partner, Products), Customizing and Conditions Data(Pricing), Transactional Data (Sales Documents, Quotations, bi-directional replication).
• Replicated Pricing Conditions tables from ECC to CRM with ZFIELDS on conditions.
• Configured Tax Classification for pricing replication.
• Enhancement of Material Master with Custom Kennametal Grade and ISO.ANSI Code fields that replicate to CRM. Enhanced BADI PRODUCT CUSTOMER and BTE event routines in ECC, and configured Product Set Types and Attributes in CRM.
• Implemented BADI’s and Enhancement spots for enhancing Product Catalog functionalities

Confidential, Akron, OH

SAP ALE IDOC & EDI Lead/BI Architect

Responsibilities:

• Extracted logistics data using data sources 2LIS 03 BX, 2LIS 03 BF, 2LIS 02 SCL. This data sources are used to extract data related to Inventory Management, Plant Stock Movement and PO Extraction.
• Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
• Developed BI Infrastructure to extract, consolidate and aggregate Plant Production, Inventory and Shipping information, along withmany complex supporting management BEX queries.
• Complex custom End Routine created to propagate missing Material Valuation records during DSO updates for Purchase Price Variation Calculations (PPV). Created End routine to calculate PPVbetween the Standard Material cost and Actual Material Purchase Price.
• Involved in Performance enhancement features such as Cube Repartitioning, Indexing, Remodeling, maintaining Aggregates, Rollups and Cube Compression

Confidential

SAP Technical Architect R/3/Lead

Responsibilities:

• Developed a Webdynpro for Java based Web Application called “Sellingtool”. The tool allows users to create and change Sales and Purchase Orders in AFS and Retail systems, and access product master and products images from MDM.
• Developed a Webdypro for ABAP application to simulate Business Partner Creation BPC1 and Order Entry VA01 Transaction on the Web. Project involved extensive use of ALV component such as SALV WD TABLE and Select-option components WDR SELECT OPTIONS and developing Component Controller BAPI classes
• Key role involved developing adaptive RFC’s and BAPI’s for Purchase orders, sales orders, and Pricing functions for the Sellingtool.
• Extensive development and enhancements done on IC WinClient for Account Management, Opportunities, Lead Management, Activity Management and Contact Management
• Managed Offshore Development teams for Webdynpro Java Development

Confidential

SAP Technical Architect

Responsibilities:

• Extraction of HR Payroll Data and Benefit Administration Data into BW by activating Info Cubes 0PY CO1, 0PABN CO1, Data Sources and Info Sources 0HR PY1, 0HR PA BN 1.
• Extracted and loaded data for Compensation analysis from the HR Cubes - 0PACM C01, 0PACM C02.
• Activated Business Content Cubes and extracted data for 0PUR C01 Purchasing Data, 0PUR C02 Vendor evaluation, 0IC C03, Material movements, 0IC C01, and Goods movements.
• Worked extensively on BEX Query Designer. Developed flexible queries using filters, navigational attributes in BEX Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Confidential

Technical Team Leader - SAP ABAP

Responsibilities:

• Architected and Developed a Portal(EP6/ITS) based online credit card (Customer Not Present) authorization system. System was real time, and involved interfacing with Mercator, Retail Logic(Brokerage) and Merchant banks. Project involved sending Oubound IDOCS to Mercator, translating data to XML and receiving XML Data from the banks and converting it to Inbound IDOCS and Custom BAPI’s. OLA response time was 5 seconds.
• Developed numerous Outbound and Inbound IDOCS for ARTMAS, WMMBXY, ORDERS05 message types and also built various custom IDOCs to send Article Pricing and Prompt Messages to Point-of-Sale Till Systems.
• Developed bespoke transactions and dialog screens for SAP Console, RF for Goods Issue, Bar codes, Picking and Putaway etc.

Confidential

Technical Architect

Responsibilities:

• Architected a complex high volume custom MEF(Model Explosion File) interface for exploding the BOM’s and all vehicle parts in the system, to interface with Assembly Line Control Programs.
• Developed Shuttle cards, Vehicle Travel cards and Vehicle Delivery Schedules using Smartforms in APO, for Vehicle Sequencing and vehicle scheduling. Process involved using BAPI’s and implementing BADI’s.
• Uploaded BOM and Vehicle Master Data in the IPPE (Integrated Products and Parts Engineering workbench) using LSMW.
• Developed RFC based interfaces to Synchronize Planned Orders in APO & R/3.

Confidential

Technical Architect/Team Leader

Responsibilities:

• Web enabled SAP-R/3 using Java, XML and Business Connector for Property Listings.
• Developed interfaces for the HR system.
• Developed Ageing Analysis Reports.
• Developed Bank transfer interface programs.
• Developed complex Payroll Analysis Reports, linking HR postings to FI, based on Cost Center Groups. Strict Authorizations were implemented.
• Developed Leave Balance and Superannuation Reports using interactive ALV.
• Developed User Exits for Payslips in HR.
• Break fixes, Performance Tuning & Support.

Confidential

Senior SAP Technical Consultant

Responsibilities:

• Developed new (BPR) module for Grain Purchasing. System handled complex pricing procedures and calculated levies and royalties on the grain. Interfaced with standard SAP functions of Purchase Orders, Goods Issue, Goods Receipt and Invoices.
• Responsible for system design and creating new tables, search helps, Lock objects and developing front-end screens and table controls (using Screen and Menu Painter).
• Utilized object oriented features of Version 4.0B to complete Module Pool Programming.
• Developed batch input programs in FI for AR and GL data migration from the Legacy TIMS system into SAP-R/3.
• Wrote programs to extend the materials in MRP, Costing, Accounting and Work Scheduling Views for various Material Types.
• Developed numerous Interactive and List Reports for MM, PP and SD Modules using ABAP/4.
• Developed batch input programs for Controlling and Profitability Analysis reports.