We provide IT Staff Augmentation Services!

Sr It Consultant Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • Seasoned SAP Professional with ability to lead large and complex global / domestic projects and work closely with business and IT.
  • Successful communication skills.
  • Strong analytical & problem solving skills. Expert Excel & MS ACCESS analytic skills (pivots, macro, consolidation, quantitative analysis etc ).
  • Proven architect in designing POC & high value, cost effective & efficient IT solutions enjoying business buy - in.
  • 3+ Full life cycle implementation experience based ASAP / Agile / DMAICC-DMADV approaches ( phases) complementing PMBOK guidelines
  • SAP implementations based on ASAP - Project Preparation, Blueprint, Realization, Final Preparation, Go Live followed by Production support and process improvements ( 3.1h->4.6C, APO 3.1 DP /SNP, Globalization & Canada roll out, ECC5.0-->6.0)
  • Post go-live Process improvements based on DMAICC / SDLC approaches. Mini projects post go-live based on Waterfall / Agile ( scrum) methodology
  • Core strengths - Communication, Risk management, documentation & reporting
  • (Prototyped a PMBOK based WBS, network and activities in SAP project systems to capture IT projects, Created UDFs to capture organization assets and time sheets)
  • Production support experience:
  • Over 10 years of production support experience focused on successful communication, high customer service standards and maximum up time of ERP system and its processes. Resolve user support issues relating to system functionality, efficiency, performance, and availability of production systems
  • Configuration Experience:
  • Enterprise structure and consistency check . created sales area, storage locations & rules, shipping point, storage section, storage area, storage bin. Number ranges for different objects
  • Master data (customer) - Layouts, Account groups, default partners, additional data, reconciliation account, selection rules for AR, etc. utput control set up for order, delivery and billing VV11/21/31, account determination, credit control configuration, VOFM to modify or create new routines in pricing and standard routines as needed,
  • Payment card processing. Rebates processing, Contract set up. batch management, Serialized materials management BOM for sales order process, Revenue account determination based on reason codes. Product allocation in .1h setting up s140, and custom structure and material master. Reconciliation account determination through condition technique.
  • Delivery, Transportation & PGI: delivery types, delivery item categories & auto determination (0184), pack control, storage control rule, o/p determination, text determination, partner determination, picking control at shipping point, HU and packing, route creation and automatic determination, setting up Delivery, PGI and Incoicing batch jobs
  • Special processes: Intercompany Sales order, Drop ship, STO.
  • Legal Control and Foreign trade control: Extensive know on legal control in the pharma industry to control processing based on material and license control ( DEA / State license / REMs etc) .High level knowledge of foreign trade functionality to set up sales documents based on key export document and creating proforma invoice for exports channel.
  • B2B & B2C integration:
  • Author to many B2B interfaces to transfer master data and sales data (with VBUK and VBUP stages) . Worked with Infrastructure to create ftp servers and transfer data across the DMZ. Worked with PO (PI) as middle ware for xml integration with Model N suite

PROFESSIONAL EXPERIENCE

Confidential

Sr IT consultant

Responsibilities:

  • Characteristics for AFS coverage or dimension group and their relevance, Coverage structure and characteristics assignment like origin, quality, customer type etc, matching Requirement strategy (coverage strategy configurations ) and their assignment to the material master at the grid and MRP level.
  • Seasons creations and assignment in master data, customizing in sales order type and sales org, UPC assignments to grid values, Additional data customer master, VAS set up, customer groups etc.
  • Ordering cycles like Pre book, late prebook, contract based and call offs, standard order, seasons.
  • Pricing condition type and maintenance like J3AP (base), Factor price J3AF (percentage), manual gross J3AX etc, standard pricing procedure J 3A01. Basic knowledge of AFS MRP and allocation run.

Confidential

Senior Business Systems Analyst and Lead

Responsibilities:

  • Worked extensively on Core processes like OTC (SD/MM/LE), Pricing, FICO Integration, S&OP, Enhancements, Reports and Interfaces.
  • Continually liaise with Business stakeholders through professional communication and keep highest standards of customer (Internal) service and satisfaction. Applied Six sigma based approaches to either create new processes (DMAIDC) or improve existing processes (DMADV). Strong focus on VOC.
  • Created substantial enhancements to the VMI process by customizing PO number range consumption, using product proposals to create blanket order.
  • Well versed and experienced on documentation protocols like FS, UR, Tech specs, Interface design documents, Business process maps, design notes, Change control assessment and analysis document for Business buy-in. Service now ticketing system for production support and projects. Sharepoint usage for Project progress, artifact and defect logs repository. Good knowledge of SOX, GXP, IQ, OQ, PQ compliance.
  • Lead for driving forecasting efforts within SAP S&OP domain. Configured product hierarchy structures, procurement keys, classification specific to S&OP, MRP controllers, A,B,C indicators in material master for forecasting functionality & reports. Designed planning types, characteristics & key figures combination, macros, Forecast uploads process to create decision reports for collaborative planning.
  • Improved Forecast accuracy to over 90% through variety of process improvement like ABC indicator. Created Report at Sku level on Forecast v/s actual orders based on original RDD.
  • Designed key reports for collaborative forecast and production planning highlighting projected inventory, ending inventory, weeks on hand, short dated inventory. Designed month end batch jobs to update S700 table for other SIS and LIS structures, required for S&OP reporting and forecast / planning firming.
  • Designed processes to update planning table from LIS structures like shipments, open order, Closing inventory and deriving rolling plans and information on projected Monthly Ending InventoryWeeks on hand and forecast accuracy performance. Transfer to production plan. Oversee MRP process.
  • Worked on Production Enhancements and Support in SD, MM and LE. Strong configuration expertize for enterprise structure, sales and delivery document types, item categories and their assignments, incompletion procedures, material exclusion and determination, text determination, partner determination, copy control, credit control settings, setting up payment terms, reason cods, rejection reasons, Legal Control etc.
  • Customized logistic process to upgrade orders to expedited shipping for backorders exceeding a week
  • Knowledge & experience of ALE & EDI processes for master data & transactional data distribution and interfaces to non R/3 - Distribution customer model, change pointer activation, port definition, partner profile, defining output determination. Worked on message types DEBMAS, MATMAS EDI 850 Order (ORDERS),860 (ORDCHG), 852 product activity(PROACT), 855 Sales order ack (ORDERSP), 856 ASN (DESADV), 810 Invoice ( INVOIC).
  • Experienced in ABAP development, debugging, creating / modifying custom tables or extending standard SAP tables, function groups, maintenance generator, fields & domains & function modules. Creating custom Z programs ( executable), creating custom tcodes and assigning them to z programs like reports and interfaces, Custom authorization check functionality partnering with Basis, BDC, Smartforms, user exits, custom screen modification, BDC, etc. Designed & implemented many RICEF objects.
  • Extensively involved in trouble shooting on day to day basis for SAP SD, MM and S&OP processes.
  • Worked extensively on Order-to-Cash Process (OTC) from order entry and management, credit limit / license check, availability check, exclusions, pricing through condition technique, delivery creation and route determination, pick- pack to invoicing. Worked on Customer Master, Sales Orders (Stock Order, Direct Ship and Drop Ship), Credit Management, ATP, Inventory, Shipping, Transportation, Rebates, Contracts, Billing, and FICO Integration. Inter company Billing and STO. Batch Job scheduling / maintenance in Production.
  • Lead for the Contract management and Revenue management vertical integration with SAP, overseeing master data flows and transactional data processing to streamline chargeback, pricing and incentives- the lifeblood of Competitive Generic industry.
  • SAP LEAD for MODEL N integration project with SAP leveraging PO (PI) - MODEL N Replacing REVITAS IMANY CARS/IS, CARS MEDICAID & CARS GP.
  • Lead for integrating legacy contract reporting system AND its replacement by a Modern avatar (MODEL N).
  • Architect for entire integration effort, supervising two ABAP resources on / offshore .
  • Wore multiple hats to fastrack the project - from ABAP to legacy data conversion handling over 100 mn lines using access and Excel.
  • Participated in HANA team workshop to design content, attributes, analytic and calculation views primarily for accruals and payout planning in the HANA studio. Created basic reports using joins (much like pivots in excel and access). Cross validated data through parallel runs of historical data (over 100 GB) in MS ACCESS to underscore accuracy.
  • Led efforts and development of application to DE-DUPLICATE customer master records from disparate sources and licenses like DEA / HIN / 340B in SAP and BODS, as part of master data governance (MDG) strategy critical to the new implementation.
  • Led ABAP and PO (java stack) efforts to design master data outbound flow and inbound transactional data as xml and implementing business rules in the messages. Oversaw Scenario (Integration logic) for outbound master data from SAP and inbound Credit requests from Model N for processing in SAP and sending back acknowledgments. Have good knowledge of ESR - defining sender system, interface objects like message type and data type, graphical message mapping . Integration builder - defining business system and communication channel ( sender and receiver) and assign it to service ( business system), SLD - information on technical and business system, Configuration & Monitoring - message monitoring, asynchronous communication.
  • Designated cut over manager. Completed documentation of processes and guided training team in development of training materials; also participated in knowledge transfer to superusers and facilitated the smooth transition of deliverable and system products to production after Q & V approval and sign off.
  • Lead for Integration implementation between SAP and SALESFORCE Service Now Vertical application with AGILE METHODOLOGY for master and transactional data. Created SAP periodic batch jobs for data transfer.
  • Provide quality Production Support. Process Support tickets through the Service now ticketing system.
  • Involved in Technical Upgrade implementation to ECC 6.0. Co-ordinate with offshore team to run regression tests in HPQC. Report / resolve resolve defect logs. Store results in the Test lab.
  • Implemented performance tuning of certain programs in sales order processing mainly focusing on function modules and standard SAP views.
  • Expert in extensive Unit, Integration and Regression Testing and Documentation.
  • Created template in SAP PS to manage Team IT projects & time management based on PMBOK framework.
  • Support cash application in FICO for BAI2 lock box processing. Designed selection rules to apply additional fields from BKPF and BSEG to allow legacy open AR from acquisitions.
  • Extensively used CATT, LSMW /MASS and proprietary mail merge utility to upload and change Master Data / load conversion of master and transactional data.
  • Responsible for desired configuration changes and frequent production Support issues as the majority is custom made for chargeback process, Medicaid, Rebates, Medicaid and GP.
  • Authored Inventory ageing report based on batch master data. Created a custom report as email notification list to the Business for sales orders without expected EDI prices.
  • Created multiple ABAP Queries based on business requests.
  • Oversaw & implemented a critical project to globalize over 55 custom objects ( reports & interfaces), partnering with overseas resources . The scope included documentation and testing. Completed before time and concurrent to Service cloud Project thereby bringing substantial savings of over USD100k.

Confidential

Senior Business Systems Analyst and Lead

Responsibilities:

  • ASAP methodology. Greenfield implementation of SAP 3.1 H and subsequent upgrade to 4.6c
  • Oversaw Requirement gathering, blueprint, fit gap analysis, business proves engineering, SDLC, ASAP methodology to implement ERP across SD/ MM/ PP and WM.
  • SAP Order To Cash (OTC) project, new implementation. Worked with ERP & Client Team Members to define “As-Is” and design “To-Be” Sales Organization Structure. Configured Sales Document and Item types for their Service Business Unit. Configured Returns, Credit and Debit Credit Memo’s. Configured Scheduling Agreements, Orders, Deliveries and Billing Documents. Configured Pricing Condition Types and created Condition Types and Pricing Condition Techniques. Created documentation for functional designs, test scripts, etc. Provided LSMW assistance for loading Customers, Materials and Info Records.
  • Experienced in FICO configuration of chart of accounts, company code, CCA, automatic account determination, payment terms, reason codes, g/l account, assignments of reason codes to g/l account, check run etc
  • Part of core team to implement WM for the central warehouse, activating WM, configuring warehouse number, storage type, storage sections to assign storage bins, define doors, storage and removal strategies, palletization, storage unit type, good receipt area, IM GR, transfer requirement, transfer order, Goods issue, Print control, maintain working hours, define inventory type (continuous or annual) per storage type etc. Trained users for inwarding, put away, retrieval, Transport order, pick, pack, ship and EOD transactions and Invoicing.
  • Part of the core team to implement APO 3.1 (ASAP methodology): Created data marts, cubes, OD. Configured planning area with relevant characteristics and key figures, creating Planning books, planning object structures, time buckets and time series objects, characteristic combinations, forecast profiles & macros. Designed and implemented an internet based CPFR system to obtain forecasts from key markets and key customers and aggregating based on different characteristics and key figures, Release demand to SNP & R/3. Customized SNP CTM model for distribution planning and its master data, stock types, sourcing priorities and quota, transport duration,TLB, deployment and replenishment. Worked on CIF customizing.
  • Supporting all the technical development requirements by providing technical specification documents on SD area focusing on order to cash (OTC) and EDI.
  • Worked extensively on Enterprise Structure, Order Process, and Master data conversion.
  • Responsible for desired configuration changes considering the constant production Support issues.
  • Worked on extensive Unit, Integration and Regression Testing and Documentation.
  • Implemented Customer service module for spare parts division.
  • Set up and implemented many outbound and inbound interfaces between SAP and other Verticals.
  • Enhanced SAP functionality by implementing Variant configuration for Custom orders by institutions. Worked with MM resource to create configurable material for BTO (MTO ) process - material type KMAT, MRP, item categories assignment (TAC & TAE item categories), condition type VA00 & VA01, order management and pricing conditions, Strategy and MRP run, Planned orders, Production orders and stock receipt for special stock. Etc. Familiar with the end to end steps expected in Variant configuration OTC processes.
  • Part of Initial implementation team for SAP Project System in the Precision Engineering division providing automation solutions in in-house, automotive, Precision engineering components and tooling.
  • Part of the team to design and implement a serialized equipment supply & repair to authorized service center with warranty management. Created spare part supply and pricing solutions to these centers.

Confidential

Senior Business Systems Analyst and Lead

Responsibilities:

  • Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team
  • Participating and finalizing the functional requirements from the business users
  • Responsible in converting the functional requirements to technical designs
  • Providing project work load and timelines to the business users. Participated in design reviews, spec reviews, code reviews, test plan reviews. Completed documentation ADS, TS, STM ( trace matrix) UTP & UAT
  • Designed and developed various Data targets and Info providers like DSO (ODS), Infocubes, Info objects, Multiproviders and Infosets using Admn workbench
  • Populated various data targets like Info - objects, ODS and Infocubes, with Master data and Transactional data from R/3, legacy systems using flat file interface via Data Staging area
  • Developed Queries to access data from various BW Info providers like, Infocubes, Info objects, Multiproviders and Infosets using BEx query designer. Created initial training document for users
  • Developed Authorization objects partnering with ABAP resources to control access to Infocubes and worked with Basis to apply them for different roles.
  • Developed views in R/3 for generic data extraction not covered by business content
  • Collecting and Releasing transports (BW and BEx). Worked with basis team for space issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA/P.
  • Reconciliation of BI reports with the R/3 & legacy data as wells as the reports

We'd love your feedback!