SUMMARY:

• Over 6 years of experience in Software applications with strong technical skills in ABAP, ETL, HP QC Developing, Enhancing, Reporting and Analysis of Commercial and Enterprise applications. Testing on Web based and Client/Server Environments.
• Solution Manager Charm, Process Chains, CIF Post processing, Live Cache consistency checks and fixes, CIF integration models, SCM Master data transfers via CIF and QUEUES processing and release orders from APO to ECC
• Extensively worked on inventory Management stock adjustment, pricing and price scales, purchasing decisions with quota and Scheduling agreement with lead time to procure
• Supply chain integration with suppliers to optimize parts ordering to meet customer demand and avoid inventory storage costs. Created scheduling agreements, and purchase order documents to meet Integrated model in ECC created on unit of measure and stock transfer orders, Transportation management and package distribution
• Updated packaging specifications for unit of measure when required
• Managed multiple six sigma projects and saved analyst time and money by reducing manual intervention in Idoc processing and queue monitoring.
• Setup forecast strategy, and configure with different models as per the part type
• Configured PSMs jobs in SPRO for all DFIP jobs by creating planning profile, process profile trigger configuration, trigger groups and parts setup.
• Access supply resources and plan Inventory and distribution of requirements through BOD with search sequence and configure supply chain for product life cycle
• Demand Forecasting and Inventory Planning (DFIP) (Demand Planning) DP Management and Distribution of requirements(DRPr) throughout network and visibility to suppliers through SNC (supply Network Confirmation)
• Supported Deployment engine and GATP rule based checks and check limits for back orders and future dated orders with ODL
• Involved in tracking advanced shipment notification and track containers until it is goods receipted.
• Interaction with EWM, CRM, BI, XI, BW and Legacy teams for Issue resolution.
• Access BW tables and process chains using List cube and demand tables access to process demand planning and realignments. Through planning service manager(PSM)
• Good understanding of ABAP work bench/3 Repository - Have good exposure on data dictionary objects, domain, data elements & Z-tables, Views, Search Helps, Debugging
• Utilized code inspector, performance trace, UAT testing
• Over 6 years of experience developing and testing ETL jobs in SAP environment
• Support, enhance, debug ETL audits and extractors in DATASTAGE 11.3 version Working with SAP and Ztables and extracting data to Teradata
• Build and test inventory audits to each location to optimize quantity updates at its best
• Verify data is loaded successfully into Teradata for Bob J reports
• Verify Teradata views updated correctly and data is loaded into system without duplicates execute sqls in Teradata to validate data as per requirements extensively tested and debugged ETL work flows and design documents at each stage
• Utilized code inspector, performance trace, UAT testing
• Involved intensive testing on every month releases in agile performed version upgrade testing from 8.5 to 11.3 Data stage for all priority audits and extractors executed jobs through designer and director and monitored data flows into output files debugged transformer stages, joins, filters, sequence files, and performance monitor in designer tested all connectors from data stage to legacy, sap, Teradata and input file path viewed logs from director and designer to find out root cause for parallel job failure and fix issues.
• Efficient in all phases of development lifecycle, data cleansing, data conversion, performance tuning and system testing.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills
• Automated job scheduling for all data stage jobs using auto sys
• Quick and Self-learner, understands company standards properly and executes them.
• Created extractors using Db2 Sqls using DB2 connector in designer
• Used PlSql for data warehousing
• Knowledge of Quality Assurance methodologies and strategies with better understanding of Software Development Life Cycle (SDLC).
• HPQC coordinator for all quarterly and monthly releases, creating folders for all test scripts based on release name and monitor them and interact with integration team for all issues ALMHP
• Complete knowledge of Test Automation life cycle and the effective role it plays in quality of the product delivered.
• Tested federal projects and data related to Banking and Insurance
• Creating Test Plans and Test Cases for Integration, Functionality, Performance, Stress and Regression Testing.
• Creating Requirement Tractability Matrix and Test Execution Matrix for both Automated and Manual Test cases.
• Worked as TAT and TAB for the deliverables done on time.
• Mainframe based applications where implemented with Rumba as front end
• Expertise in Functional, Regression, User Acceptance and Performance testing.
• Worked with Test Requirement Management Tool such as Test Director and Quality Center with Business Process Testing.
• Worked with Bug reporting Tools like Test Director, Lotus Notes and Clear Quest.
• Resolved Incidents, problem tickets for support issues. Onsite off shore coordination.
• Parts inventory collaboration with optimization of inventory costs by access to dealer inventory and recommend optimum inventory to dealer through supplier files through IBM Sterling Integrator using Data stage and send to Dealers through Syncron as, Point of Use files to dealer pick.
• A collaborative inventory solution for all dealers, leveraging Cat Parts Inventory Management expertise to improve Customer fills rates
• Monitoring file transfers in Hadoop Impala query ui and validate dealer data for upper and lower boundaries
• Rerun publisher and interface jobs per dealer when stuck or fail after validating the cause of error.
• Dealer Hierarchy, Dealer Inventory, Part Sales (POU) files will be loaded into Hadoop. and data stage jobs that are looking for the domains to be updated between certain times. When they are updated, the “dealer schedule” runs and generates the following “interface files”: POU (Transactional Demand), Item, Supplier Data, Stock, Replacement

TECHNICAL SKILLS:

ERP: SAP, ABAP, ETL (Data stage)

Testing Tools: HP Quality centerRDBMS: Oracle 7.x/8.x/8i/11i, PLSQL/MS SQL 7.5/2000/2005 and Access 2000

Operating Systems: Windows 7/XP/ 2008/2003/2003, UNIX

Programming Languages: Visual Basic, VB Script, C, C++ and JAVA

Data Warehouse: Data stage 11.3, Teradata

ERP: SAP NW 4.0, ABAP

Others:: Microsoft Word, Excel, Outlook, Power Point and Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Illinois

SAP Developer

Responsibilities:

• Providing post production on call support for SPM (for Demand Forecasting and Inventory Planning and Distribution Resource Planning) and Deployment using Solution Manager, Peregrine, Remedy, Hadoop querying through Impala, Data stage publisher, and Manager
• Solution Manager Charm, Process Chains, CIF Integration models, Post processing, Live Cache consistency checks and fixes, CIF integration models, SCM Master data transfers via CIF and QUEUES processing and release orders from APO to ECC
• Extensively involved in Demand planning (DP) and Supply Network planning(SNP) and worked on CIF integration models and CIF data from ECC to SPP (supply parts Planning)
• SAP APO SCM configuration in SPRO and support planning service manager in SCM
• Manage Inventory and allocating material to a location in SCM basis
• Configure planning profile, process profile, and selection for SCM basis Planning service manager
• Extensively worked on inventory pricing and price scales, purchasing decisions with quota and scheduling agreement with lead time to procure.
• Supply chain integration with suppliers to optimize parts ordering to meet customer demand and avid inventory costs.
• Created scheduling agreements and purchase order documents to meet integrated model in ECC
• Created unit of measure and stock transfer orders, transportation lanes and package distribution
• Managed multiple six sigma projects and saved analyst’s time and money by reducing manual intervention in Idoc processing and queue monitoring.
• Establish transportation lanes and means of transport.
• Worked closely with Warehouse management team on issues like allocation not dropped and ASN and in transit issues, pick pack and ship.
• Capture Demand and forecast for daily, weekly and monthly with EOQ and safety stock
• Worked with sales orders, stock transfer orders and production orders
• Resolved issues on forecasting material with BOD and individual material
• Executed Tidal jobs to manage batch cycle process to meet Demand planning and DRP cycle with deployment to complete full life cycle of parts to meet customer needs.
• Support, enhance, and debug ETL audits and extractors in DATASTAGE 11.3 version. Compare Legacy data and SPP data via ETL and send discrepancies to Business for data validity.
• Build extractors to pull SAP and ztables into Teradata so it can be used to create reports in BW
• Worked on legacy sqls to build audits and pull data to compare with SAP data and filter discrepancies to out file
• Responsible for the diagnosis of operational incidents, the analysis of functional specs, and the creation of high level detailed design specs
• Coding SAP modules and complex functions using ABAP programming language
• Configuring, coding, testing, documenting, supporting and implementing SAP enhancements.
• Consistently improve the support processes through initiatives
• Understand and translate functional specifications into SAP technical specifications.
• Coordinated DRP project implementation partially and participated in UAT testing.
• Writing and reviewing SPP support team’s functional specs and ETL purchasing document comparison FRDs.
• Demand Planning, Historical data, composite planning, and economic Order quantity usage and configuring in SPRO
• Made code changes, enhancements and upgrades for mass loads on transportation lanes and forecast stats and other technical changes such as BOD changes, Pre-req. deletion after stop of sales date, SA interface.
• Worked on jobs schedule changes in TIDAL, for abend alerts max run time changes as per customer requirements.
• Gathering requirements from business and prioritizing them and assign them to onsite and off shore teams.
• Mentoring new team members on SPP and on-going support process.
• Team coordinator for writing test scripts and executing in HPQC and responsible for providing inputs for automating DFIP, DRP and SNC support regression test scripts in HPQC.
• Worked on multiple Green Belt projects such as value props for changes, building new programs to reduce manual work and saving dollars to company, support packs, and Go-Live support project.
• Cleaning out-of-sync purchasing documents among different environments and making changes to existing interface and deleting functionality to fix the issue.
• Responsible for fixing failed Idoc and queues daily and retrofit team’s changes to lower env.
• Responsible for defining Alerts, BOD and Supersession triggers for daily and monthly batch jobs.
• Defining processing jobs of a few IDoc types, reviewing their dependent functional processing jobs and job schedules in TIDAL.
• Configured monthly and daily batch jobs, PSM application like planning and process profiles for DRP custom jobs.
• Configured Schedule agreements custom types and Stock transport orders.
• Created test plans, test scripts for all phase of DRP implementation.
• Deleting unwanted old data such as confirmations and scheduling clean up jobs for performance improvement.
• Defining unique calendars for daily and monthly jobs to improve DFIP job scheduling.
• Analyzed SAP on OSS notes for issues related to DRP, SNC, SNP, supersession, BOD changes, forecast profile deletions and reports to clear old data.

Environment: SAP SCM 8.0

Test Analyst

Responsibilities:

• Involved in testing the web applications, developed in Java and J2EE and Web Sphere.
• Extensively worked on Creating Validation Matrix, Test Cases, with scripts running in Win Runner
• Reviewed the test cases, and executed them in Quality Center 10.0.
• Validated the tested data in Database Visualizer.
• Reviewed the integrated project test plan.
• Connected to Approver to see the logs in Unix environment for the causing in application using Secure crt..
• Logged defects in Clear Quest.
• Actively participated in test team meetings, and test planning meetings.
• Prepared the test matrix for the test lab and execution.
• Prepared the high level test cases in QC, based on Use cases.
• Performed User Acceptance Testing (UAT) testing.
• Involved in creation and verification of XML documents.
• Involved in the creation and modification of SQL and PL/SQL scripts using SQL developer. The scripts are used for verifying data in oracle DB.
• Deployed code from DEV box to IT Environment for all the builds in all Iterations in UNIX.
• Had Run Batch Jobs manually in UNIX for Payments to complete the transactions.
• Completed projects: I901(DHS) Mpayy, E pay and Currently working on EDS phase 2.

Environment: Windows, UNIX, Web, Oracle 11g, Database Visualizer 6.0, Secure CRT, Lotus Notes, Clear quest, Clear Case, Quality Center 10.0

Test Analyst Technical

Responsibilities:

• Involved with the testing of the data migration from IMS system to Db2
• Prepared and executed the jobs in system environment.
• Worked with the offshore/and other members in the team to get the deliverables done on time.
• As a Test Analyst created, reviewed and executed the test cases.
• Executed the test cases and validated the data.
• Created and reviewed the test plans and test summary reports.
• Involved in defect management.
• Reviewed the test logs and analyzed the defects.
• Actively participated and attended the meetings.
• Responsible for sending all the necessary documents to review and authorization.
• Coordinated with other TAT's and TAB’s to get the deliverables done on time.
• Created test plan, project plan for tracking and documenting tasks to meet deadlines on time. Initiated meetings with related teams to get works done