SUMMARY:

Self - motivated, highly skilled professional seeks to leverage extensive background in ERP, SAP, SFDC, and RDBMS. Highly organized and dedicated, thorough, and detail-oriented. Creative yet analytical professional who thrives on a variety and challenges complemented by exceptional research, decision-making, and communication skills.

TECHNICAL SKILLS:

SAP Trained: SAP MM, SAP APO,SAP PP, SAP PM, Confidential, SAP IS OIL, SAP S4 HANA, ALE IDOC, LSMW, ABAP, SAP SUCCESS FACTORS, SAP HYBRIS, SAP BODS

SAP MM: Purchasing Organization - Enterprise Structure,Company, Company Code, Plant, Storage Location,Purchasing Group, Assign plant to Company code,Assign purchasing/ standard organization to plant,Material Types, Material Groups, Material Range,Vendor Master Data,Purchasing Data,Vendor Account Group, Purchasing Info Record, Source List, Purchasing Order, Posting Goods Receipt, Posting Invoice, Purchase Requisition, Purchase Order from Purchase Requisition, RFQ, Outline Agreement, Scheduling Agreement, Quota Agreement, Inventory Management.

SAP PP: Confidential, Work center, Routings,MRP List, Planning scenarios, production orders.

SAP CRM: Account management, Organization management, Product Master, Transaction processing, Activity Management, Partner Processing, Pricing Fundamentals, CRM Billing, CRM Middleware, CRM Web Client UI.

SAP HYBRIS: Commerce Accelerator, Personalization for smart edit, SAP Hybris Product Content Management, SAP Hybris Service Engagement Center.Hybris Commerce, Hybris Marketing Cloud, Hybris Loyalty, Hybris showcase, Hybris Billing.

SAP FICO: General Ledger, AR, AP, Fixed Assets, Travel Management, Banks, Treasury and cash management. ABAP, ABAP WEBDYNPRO, LSMW, ALE IDOC, EDI

SAP SUCCESS FACTORS: Recruitment, Timeoff, HR Transactions, Payroll Timesheets, HR Transactions, Payroll Timesheets, Position Management, Scale based pay, onboarding, employee central - configure employee fieles - recruiting email templates, integration of successfactors using SAP PI/ SAP HCI

Cloud applications: Cloud applications Data loading using XML

Informatica: ETL SQL Server 2008 - SSIS, SSAS, SSRS, T-SQL JAVA, HTML, WEB SERVICES CES, JSCRIPT

INFORMATION TECHNOLOGY EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Defined requirements, design and UAT testing with business team, senior business analyst and senior application support manager.
• Defined data flow, data conversion strategies.Analyzed source data, defined data structure and data conversion rules.Analyzed data in spreadsheets and loaded data into tables in staging area.
• Converted data from source system to the staging area to Amber Road/ Global Trade management. The scope of the project involved requirements gathering, technical design, ETL data maps to load data into the staging area and generate XMLS to be sent to target system.
• Data auditing and reporting: Generated spreadsheets to validate data quality and worked with business to resolve the data issues.
• Created the ETL maps to load Product and Confidential data into the staging.
• Created the ETL maps to generate partner xml, product xml and Confidential xml and loaded the data into Amber Road/Global Trade management (target system).
• Worked with project managers, business users to define requirements and project plan, schedule,issues list and deadlines.Worked with offshore team to develop, unit test and triaged the defects.
• Tested interfaces and conversions.
• Performance tuning of ETL maps and pl/sql code.

SAP analyst

Confidential

Responsibilities:

• Gathered requirements, created technical design document, Data maps, data conversion process associated with Confidential .
• Configured new pricing procedures, condition types, access sequences, condition tables and pricing fields.Also created new master data such as incoterms, pricelist types etc.
• Modified ABAP reports and interface programs.
• Created masterlist for open sales order data from legacy system and mapped them to IDOC.
• Analyzed and tested IDOCS from and to SAP ECC.
• Lead the conversions of data between Apparel Product Structure for Confidential . The data conversion process involved converting the data from source into a staging area and then to LSMW tables. Loaded the data into SAP using LSMW.
• The staging area tables involved are AFS Confidential ADL SIZEGRID, MATERIAL TO Confidential LINK, Confidential HEADER, Confidential ITEM.
• Worked on the material master, purchasing info records, RICEF object testing, data cleansing, data analysis and data upload with LSMW tool.

Confidential

Responsibilities:

• Gathered requirements, presented solutions to the users, worked with the developers for requirements associated with Siebel Account, Contact, Opportunity, Opportunity systems, quotes, pricing, leads and Opportunity management, Confidential (Configuration and Pricing)
• Created use cases, test plans, test labs and performed testing associated with goals.
• Conducted data workshops,data conversion design sessions. Defined data maps to convert data from data warehouse into Siebel sales system.
• Developed using Pl/sql to convert data. This involved data archiving,data cleansing and data formatting.
• Lead data conversions and interfaces between the CRM and the Data warehouse. This involved requirements gathering, design, development, testing.
• Lead the Lead management module in terms of design, development and its integration with the data warehouse. Prepared the Project plan, schedule and timelines. Communicated the issues & progress with other senior managers.

Confidential

Responsibilities:

• Customization of master data, various SD functions and processes in sales, pricing, shipping, transportation, credit management, availability check, ATP, transfer of requirement, picking, billing plan, account determination, rebate testing, promotions, sales deals, agreements.
• Modified ABAP reports and interface programs.
• Analyzed and tested IDOCS from and to SAP ECC.
• Customization of master data, various SD functions and processes in Sales, pricing, shipping, transportation, credit management, availability check, ATP, transfer of requirement, picking,billing plan, account determination, rebate testing, promotions, sales deals and agreements.
• Classical and interactive reports with Confidential .
• SAP Scripts: Worked on SAP standard scripts and customizing scripts.
• Worked on BDC and module pool programming.
• Interfaces: Inbound and Outbound
• Data Dictionary: Database tables, data element, domain search help and lock object.
• Modularization techniques: subroutines, functions, standard program modifications

Confidential

Technical Lead

Responsibilities:

• Gathered requirements, performed functional design, communicated requirements to the developers, performed testing for Siebel marketing and Siebel analytics
• Redesigned the busi Worness process from a Home Delivery model to a digital model. Mapped the process to Siebel analytics subject areas,
• Performed segmentation using the subject areas and loaded and launched the Campaigns using the segments.
• Created use cases, test plans, test labs and performed testing associated with goals.
• Conducted data workshops,data conversion design sessions. Defined data maps to convert data to Siebel market system.
• Convert data from source system into the target system using pl/sql. This involved data archiving,data cleansing and data formatting. Data involved accounts, contacts, campaigns.

Confidential, Danbury, CT

Responsibilities:

• Created Confidential report for displaying vendor information.
• Developed a report to get list of purchase order create during a month.
• Extended the SAP tables with attributes of the projects and displayed these fields in standard SAP Confidential report.
• Used BAPI to create exchange records in SAP table.Developed and maintained several Confidential report and standard reports for Treasury module.
• Performed tuned ABAP objects.

Confidential

Senior analyst, Collegeville, PA

Responsibilities:

• Created a project plan associated with Confidential implementation. This involved requirements gathering associated with creating a clinical program, added a protocol to the program, setting up regions, defining subject visit template, creating a personal lists, creating target lists, defining a route plan & defining sales territories and set up assignment process
• Managed a Team of 5 developers and testers to test the Confidential . This is involved User Acceptance testing, System integration testing, performance testing and component integration testing.
• Created a testing process that involved creating testing process and recording defects in HP quality Center. Audited team members for testing scripts, defects and discrepancies between testing scripts and defects.
• Application testing - This included testing requirements against the application for different object types i.e. Screens, Views, Applets, Business Objects, scripts, State model & workflow. This testing was categorized into entities i.e. Accounts, Contacts, Partners, Opportunities, Activities & Documents.
• Data Conversion Testing - This involved testing data quality is as per requirements, renders the application, MVG testing and error records processing which included modifications to the staging records for successful load.
• Interface Testing - This involved testing the interface to the data warehouse, multiple systems and website.
• Performed system analysis associated with Confidential system. This involved documenting the business processes, entities and relationships, roles and responsibilities associated with different users in the organization, security rules with application access, application configuration, workflow rules, data conversion and interfaces strategy.
• Performed As-Is process, To- Be process with respect to Siebel 8.0.This was required for the Siebel upgrade. Produced a data mapping document for Siebel 8.0.This screen, views, business objects, business components, fields, tables and columns
• Gathered requirements associated with the Account Merge process. Conducted user sessions with users, business analyst and project managers.
• Performed analysis, design and development of the Account Merge process. This involved 3 categories of merges -Vertical merge between Accounts and Departments, Horizontal merge and Duplicate names related merge. The entities involved in the merge were accounts, professionals, activities, agreements, attachments, notes, Best times to call and account affiliations. This involved extensive use of EIM and oracle PL/SQL creating procedures, functions, staging tables. Business rules were created to decide between columns for survivors and victims.
• Created functional design documents for smart call templates and associated with an account call and contact call. Create process for a clinical program and clinical protocol. Setup document tracking at protocol, region and site levels for accounts and contacts. Setup revises subject templates for a protocol. Review payments made to the protocol, associated payments with a site, Rollup payments from sites to protocol level.
• Communicated, presented the functional design documents to the Business, project manager and Technical developer.
• Translated the functional design documents into data mapping documents involving Screen, View, Applet, Business component and table level mapping.
• Designed user acceptance scripts to test the requirements and process flows.
• Participated in Siebel 7.8 to Siebel 8.0 upgrade.
• Designed business rules using business rules developer. Invoked these rules through the run time events, workflows and escript.

Confidential

Senior analyst, Schaumburg, Illinois

Responsibilities:

• Lead a Siebel 7.8 Marketing implementation involving loading data associated with Accounts, Contacts, Assets, Products, Campaigns, Surveys, Orders and Order items using PL/SQL and EIM.
• Installed and configured Siebel Marketing and OBIEE. Worked with Offshore team to install the software for QA and Production environment.
• Performed Sizing analysis for Siebel and OBIEE applications respectively.
• Worked with Siebel Architects to create performance metrics associated with Siebel Marketing.
• Loaded and launched Marketing Campaigns Planning & Budgeting. Created Lists and attached offers associated with the Campaigns
• Configured screens, views, applets, business objects, business components, tables.
• Gathered requirements, designed business process, performed functional and technical design.

Confidential, Cherry Hill, NJ

Senior Analyst

Responsibilities:

• Conducted Sessions with the business users to gather requirements and identify As Is Business Process. Build the To-Be Business process along with the business analyst and user team. Mapped the To - Be business process to Siebel Screen, Views, Business objects, Business components and Siebel Tables. Performed data mapping between the legacy application tables and Siebel Tables. Communicated the requirements to the data conversion team, Configuration team and interfaces team.
• Performed technical design for the Siebel Application and mapping the design to the functional design and business process.
• Configured the Screens, Views, Business Objects, Business components and fields, State Models, Audit Trail, business component user properties as per specifications. Performed unit testing, functional testing and system testing for Siebel Application.
• Implemented background processes using escript and Siebel Workflow.Implemented Siebel Reports using Actuate.
• Gathered requirement associated with email response. Designed, configured and tested out of box email response workflows. These workflows were implemented with the Service Request module.
• Gathered requirements for the design of OBIEE dashboards. Configured new subject areas, business layer objects and physical layer using OBIEE Admin tool. These subject areas were designed to measure the marketing campaign effectiveness (% of responses) across different channels like web, email and direct offer. Converted data from Siebel Sales and Siebel Marketing into OBIEE using ETL and DAC client. Create ibots that send emails to a group based on certain effectiveness criteria of a campaign. Created dimension and fact tables for the Campaign related metrics.
• EAI - Created a workflow process using Siebel EAI Adapter and Data mapper to integrate Siebel business objects to Integration objects. The workflow was configured to accept XML/XSD data.
• Integrated Siebel Call Center, Siebel Marketing application with LDAP. This was used to implement single sign on from the company website.
• Performed normalized, dimensional and hybrid modeling techniques within OBIEE ADMIN tool.
• Installed email marketing server on the windows platform. Installed and configured Email Sending Daemon, Bounce Handler Daemon, Click through Daemon
• Configured Email Marketing Daemons to Communicate with the marketing component group.
• Tested the email marketing components by sending emails to contacts and launching the Campaigns.
• Gathered requirements associated with Field Service for service request and orders. This involved creating service request, verifying service agreements and entitlements, solutions, creating activities for a service request using Siebel scheduler, assigning and dispatching service engineers, provide parts inventories, provide detailed customer configuration, track parts consumption and logistics, manager inventory replenishment, integrated return materials authorizations and service orders, provided field service engineers with complete service details including the required skills, tools and parts, managed repair of defective parts, set up and manages preventive maintenance plans, track and analyzes service costs, prepare invoices for service and tracks payments.
• Mapped requirements to different basic field service modules - Call management, Account/Contact management, field activities management, warranty management, asset management, service order management, on-site services management, knowledge management, dispatch board and service inventory.
• Integrated Call center with the Siebel Order Management module. The process involved was setting up Accounts and Contacts, creating salespeople and assigning salespeople to access groups, creating catalogs, categories, assigning products to categories, assigning catalogs to access groups, creating quote and order, adding items and setting price lists, checking for product availability, setting up shipping information, tax calculations, payment information, payment terms, checking credit card information through accounts receivable, submitting order and order statuses and setting up tax calculator business service to integrate with a taxware application.
• Participated in a Siebel 7.8 implementation. The module involved was Siebel Loyalty. Performed Analysis, Design and developed conversions and interfaces involving systems different systems Legacy application, Siebel Loyalty, Siebel UCM and Siebel Marketing applications.
• Designed, implemented the Siebel Loyalty Engine for processing loyalty transactions, tiers and member tiers. Extensively used EIM, PL/SQL and VB for interfaces between systems. Created business services to implement logic within the Siebel Loyalty Application.
• Lead interfaces and conversion teams to perform data loads using PL/SQL, EIM and IFB files and Siebel VB. Wrote Oracle procedures, functions, triggers for interfaces and conversion moving data between systems. Performed data loads using Siebel EIM and execute the EIM job on the server using an IFB file. Performed production support for interfaces and conversions. Optimized SQL for interfaces and conversions.

Confidential

Senior Analyst, Blue Bell, PA

Responsibilities:

• Implemented Siebel Marketing system that plans and tracks the Marketing expenditures throughout program lifecycle. The system enables analysis of forecasted spend vs. actual spend. Benefits can be measured by being able to plan for marketing expenditures downstream more effectively while allowing worldwide collaboration in the creation of marketing programs and campaigns.
• Implemented 7 releases as a Siebel Configurator - 1 implementation and 4 functional releases of Siebel 6.0 (Siebel 2000 - sales, marketing and call center), 1 release of Siebel 7.5.3 (Email Marketing) and 1 upgrade implementation release of Siebel 7.7. Involved in configuration of Applets, Applet web templates, controls, list columns, pick lists, business components, joins, fields, views, and view templates, list of values, multi-value applets and multi-value groups. Created a process to track the defects during testing - program unit testing, functional unit testing and system integration testing.
• Performed requirements gathering, analysis, design, development, documentation, program unit testing, functional testing, system integration testing and maintenance of interfaces, workflow and business services. Performed production support for Siebel 6.0, Siebel 7.5.3 and Siebel 77 involving workflow, business services, interfaces, oracle objects and data integrity. Implemented Conversions of data between legacy system and Siebel using Oracle procedures, functions and Siebel Enterprise Integration Manager.
• Created a software development lifecycle process to standardize Siebel development - define requirements, categorize the requirements into a service request, assess the impact on different systems, develop the service request, test and implement in production. Created a process to standardize installation of Siebel and oracle software for the Siebel developer role.
• Lead a team involved in offshoring of Siebel (77) esales and emarketing application. Responsibilities included facilitating sessions with team member and management to identify critical tasks associated with developing and supporting the application, mapped it to Confidential domains, created metrics for tasks, created deliverables that were used in the vendor service level agreements.
• Educated a team members on the auditing concepts of Sarbanes Oxley, lead a team to make Siebel SOX complaint, involved setting production system standard, performed an analysis of the data mapping and data analysis between the Siebel and Data warehouse system to avoid reporting of redundant data.
• Lead a team promoted by CIO of to promote knowledge sharing all across the global information technology department, created a deliverable that involved creating awareness for information sharing amongst different stakeholders of organization, emphasized on cross training and document sharing.