|
| TECHNICAL SKILLS |
| ERP: | SAP R/3 Ver. 3.1B to 5.0 ECC. ABAP/4 Reports, SAP Scripts, Batch Data Communication and Dialog Programming, Smart forms, LSMW, BDC, BADI, IDOC,BAPI, User Exits, ALV Reporting, CATT, ALE and EDI, SCM 4.1 |
| Languages: | ABAP/4, C and C++, JAVA, My SAP. |
| Database: | Oracle 8i/9/10g, DB2, SQL Server, MS-Access and MS-Excel |
| Operating Systems: | UNIX (HP & Solaris), Windows 2000/NT, Windows 95/98/XP Professional |
| Web Technologies: | HTML, XML, Microsoft FrontPage, Visual Inter Dev 6 |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| Senior SAP ABAP Consultant | |
Modules: FICO, PM, PP, MM, SD, HR, BI
Responsibilities:
| Developed a BI report to change the object directory of a selected object and also added an option to change the object directory of all the objects in a specified package using the Function module ‘TR_TADIR_INTERFACE’.
| | Developed a BDC program to read the file in the Unix Directory and upload that file into Time Confirmation IW44 transaction. The program will submit the BDC automatically and even emails the BDC Count Log if it has any errors.
| | Developed a Report to extract a Work Order File for the Payroll Time Entry Validation based on the selection criteria and save the file onto the Unix Directory.
| | Developed a Report to generate a positive pay file which is required by the cash department to cut checks and ftp this file to the Bank on a daily basis. Also created an option to archive the file in the UNIX directory.
| | Developed a Vendor Master Update program to populate the Vendor Master Banking Reference Detail with ‘CTX’ when blank. From the F110 ACH payment proposal. This Vendor master Update program emails the Users with the report attached and also archives the file in the Archive Directory.
| | Developed a program to process and reformat the AP file which comes from Concur Software FTP site to a up-loadable layout format and place the file in the Unix Directory to process the file and also email the errors with description if the input file has errors.
| | Developed a program to download all the Work Orders and WBS Elements created on a particular single/range of dates and place the file in the Unix Directory for the FTP script to run and send the file to Concur Software FTP site for processing.
| | Developed a Filenet-Sharepoint Conversion program to create URL attachments links to all LFA1, BKPF and BUS2054 objects in the TOA03 cross-reference table. Also changed the pointers of all the File net objects into Microsoft-Share point Portal where we have the corresponding scanned document(Invoices, Po’s )
| | Worked on LSMW for updating the User master data and roles from the legacy system to SAP R/3 system using transaction code SU01 from a MS Excel sheet.
| | Performed the Runtime Analysis and SQL trace and analyzed the performance of Programs, Screens and Function modules created in ABAP/4 Workbench
| | Worked on designing ALE/IDOC interfaces for various systems to facilitate data transfer. Testing of inbound and outbound process while dispatching IDOC'S from one system to another system.
| | Created sales order using standard IDOC (orders05) and Distributed customer master and material master data pertaining to particular plant/company code across multiple R/3 systems using filter object type.
| | Developed User Exits, Which will automatically assign the Order type with Purchase Order Number while making a PO using Customer Functions.
| | Developed User Exits While Making Release Strategy, After Release the Purchase Order if any lower level changes the PO gives Information message and exit the screen.
| | Applied the SAP OSS note for DST (New Bush directive for early Daylight Savings Time).Applied the notes 1022730 sap note Time Zones DST rule for NA and another note 198411 for current data and info about Time Zones and another note 919538 SAP OSS Note DST start end in USA and Canada 2007.These notes were applied for early daylight savings time in USA and Canada on March 10th to be applicable from March 11th 2007..
| | Configuring Communication Settings for 2 ALE systems, maintaining the Local System, allocating the logical system to the clients, setting up the RFC destinations, Port Definitions.
| | Developed a real time interface to bring out Purchase orders from SAP to different external systems. Developed a custom IDOC type and function modules for this purpose.
| | Details of Purchase requisition, Contracts & Purchase orders were pulled into this system for Validation & further processing by calling BAPI’s. |
Environment: SAP R/3 4.6c
| Client Name |
From Date - To Date |
| Senior SAP ABAP Consultant | |
Modules: SD, PM, PP, MM, FICO, WM
Responsibilities:
| Worked on up gradation project and upgraded ABAP objects from enterprise 4.7 version to ECC 5.0 version.
| | Developed Shipment details report which displays material code, material description, stock and transaction as per the client requirement.
| | Developed PP Reports for Calculating Component Consumption in different Stages.
| | Developed PP Screens & Logic for Production Order Confirmation for Liquid metal, Billet and Rolling Stage (CO11N). This is a total Z development for Order Confirmation.
| | Worked on to Add Fields in Production Order Information System (COHV).
| | Developed a custom report for running FTP UNIX shell script in SAP and also access the SAP Database .
| | Developed a report to define a command for each operating system like UNIX , MSDOS using SM69 and test using SM49 transactions..
| | Developed Interactive reports for stock value list, stock quantity available and material document list.
| | Worked on LSMW for updating the customer master data from the legacy system to SAP R/3 system using transaction code XD02 onto a MS Excel sheet.
| | Developed BDC program to load material master data from a Flat file into SAP from legacy system using call transaction.
| | Developed BDC program for transferring the vendor master data to SAP R/3 system using batch input method retrieving from MS Excel sheet.
| | Developed an interface using IDOC and ALE to pass out the goods issue data from SAP to the legacy systems.
| | Set up and monitored the communication links between SAP and other systems using IDOC/ALE for Master Data maintenance and EDI Transactions.
| | Modified the layout set MEDRUCK for purchase order information to add company address and the logo. Included standard text according to the user requirements.
| | Implemented BAPI_SALESORDER_GETLIST to get list of orders and details for a customer.
| | Modified the SAP Smartform HRF02_PRINT_TREE which is used to HR Forms:Print Trees
| | Using SMART FORMS HR_F03_PPFF for the function module FB_MIGRATE_FORM which migrates all SAP SCRIPT forms automatically.
| | Used the Standard SAP Script form F110_US_AVIS for Payment Advice not and modifies to the buisiness requirements
| | Used the Standard SAP Script form FI_FAX_COVER_A4 and called the FI_MIGRATE_FORM and Copied modified extensively the Standard SAP script layout sets and their corresponding print programs.
| | Used BAPI’s for fetching the material description information of a material and fetching the material category to the ESS
| | Customized Screens for Vendor master and Customer master were created using Screen Painter and Menu Painter. |
Environment: SAP R/3 5.0 ECC
| Client Name |
From Date - To Date |
| Senior SAP ABAP Consultant | |
Modules: MM, PM, PP, FICO, SD
Responsibilities:
| Developed reports in SD open sales order that covers all organization levels, delivery status Shipping details and partner function details.
| | Developed reports for stock transfer orders, bill of material reports, general postings and sales order adjustments.
| | Developed an Interactive Report that displays all the sales orders for one particular customer, items for that particular order, quantity ordered, goods issue date, and contact information about that customer.
| | Developed ALV reports for purchase orders to compare the ordered quantity with the received quantity.
| | Developed User Exit to calculate discount rate based on customer type.
| | Developed a BDC Program to upload Material Master from a Flat File to an SAP System.
| | Developed an outbound IDOC to extract the material category results.
| | Developed BDC Programs to update and change Customer Master Data by Call transaction for transactions XD02 and FD32 to update KNA1 and KNKK tables retrieving from MS Excel Sheet
| | Designed and implemented data migration from legacy system to SAP R/3 using BDC from a MS Access and Flat File. This includes studying the source data in external system and subsequently identifying and mapping the corresponding Transaction, Screens, and fields in the SAP system.
| | Created a Smart Form to generate benefits enrollment/confirmation letters.
| | Used the SAP Smartform Standard FT_COM_FETR which is used to generate a New Form.
| | Used the Standard SAP Script form LVSTOSOLO to print an individual from the material inventory
| | Created the SAP Scripts PO_Invent and saved the made changes to the purchase order layout
| | Involved in the designing the layout for the material description.
| | Configured and tested the ALE interface to support distributed processing. Carried out Material Master reduction and distributed the same among different destinations using EDI, ALE and IDOC |
Environment: SAP R/3 4.7ee
| Client Name |
From Date - To Date |
| SAP R/3 ABAP/4 Consultant | |
Modules: PM, MM, FI/CO, SD
Responsibilities:
| Developed a report to check current moving average standard price and purchasing frequency of purchased material and to revise the ordering frequency of materials.
| | Developed a report to display the stock status of the materials including the stock on order.
| | Developed a Shipping performance report.
| | Created a Report, which prints the entire PO and the PO amounts for vendor/vendors for a specified date range. It states Rebate settlement report.
| | Developed reports to list Sold-To party and Ship-To party based on sales area Data Conversions & BDC
| | Written ABAP/4 function modules to convert vendor and customer data fetched from legacy systems to the format readable by standard BDC programs, RMBIKR00 (vendors), RFBIDE00 (customers).
| | Designed BDC programs to upload customer master data.
| | Developed a BDC call transaction program in MM to load Material Master Data into SAP system from legacy system.
| | Involved in writing Batch Data Communication programs for transferring the vendor master legacy data to SAP R/3 system using Batch Input method.
| | Performance grading and testing of reports under ABAP/4 Using features such as SQL Trace and Runtime analysis.
|
Environment: SAP R/3 4.7ee,Unix, Oracle 9i
| Client Name |
From Date - To Date |
| SAP ABAP/4 Developer | |
Modules: SD, MM, PP
Responsibilities:
| Developed a Batch Input Program to upload Vendor Master Data from legacy system to SAP R/3 database
| | Created a SD-PP - Order Progress Report for Configurable Products -- This report will help to track the Customer Purchase Order from the Sales Order creation upto the delivery stage. It will show how much time it has taken in every stage.
| | Created a BDC program to change vendor address, to create project plan data using flat files from legacy system.
| | Program to check the Co-product indicator in Material master
| | Program to change the Price control indicator in Material master.
| | Program to create BOM’s
| | Program to create Production versions to all materials and assigning Apportionment structure to Production versions in Material master
| | To reverse the Goods receipts done to a process order, the settlements that are done on the process order have to be reversed. To reverse the multiple settlements a program is developed to do the settlement reversals.
| | Report on List of Purchasing Document and Delivery Schedule Report
| | Developed a report to display the list of Purchase Organization, Document Type and Account Group according to the Purchase Order Creation Date. |
Environment: SAP R/3 4.7ee, Unix, Oracle 8
| Client Name |
From Date - To Date |
| SAP R/3 Developer | |
Modules: SD, MM, FI/CO
Responsibilities:
| Developed forecast report in raw materials. This report gives the detail materials and opening and closing stock and consumption on a monthly basis.
| | Developed reports in project systems, which summarized the costs related to purchase orders, purchase requisitions, and reservations in detail for every project.
| | Sales Order Authorization Design: This program releases every item on a sales order for processing only after it has been approved by a desired level of approvers and also gives the user a list of all approvals due at his/her end.
| | Prepayment Campaign Backup Summary: This report provides details regarding the Billing Summary information for various items on the document. The report uses the sales document as the input parameter and prints the Escalation backup summary for every item on the sales document.
|
Environment: SAP R/3 3.1,UNIX, Oracle 8
EDUCATION/CERTIFICATION
Bachelor of Mechanical Engineering, Bangalore University, India - 1998
PLEASE LEAVE YOUR COMMENTS BELOW
CONSULTANT NAME
(SQL DBA)
SUMMARY
| Over Six years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
| | Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2000.
| | Experience in upgrading SQL Server from version 2000 to 2005.
| | Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005.
| | Good experience with SQL Server 2005 online Indexing and Recoveries features.
| | Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
| | Experience in Data Migration Management.
| | Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
| | Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
| | Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
| | Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
| | Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
| | Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
| | Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
| | Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
| | Experience in applying patches and service packs to keep the database at current patch level.
| | Experience in migrating packages from DTS to SSIS.
| | Good experience with Analysis Services, Reporting Services, and SQL Server Clustering. |
| TECHNICAL SKILLS |
| Operating Systems: | Windows 2000/2003 Server, Windows 95/98/XP/NT |
| Databases: | MS SQL Server 7.0/2000/2005, Oracle8/9i |
| Languages: | T-SQL, PL/SQL, C, C++, and Core Java JDK 1.1 |
| SQL Server Tools: | Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS) |
| Report Tools: | MS Reporting Services, SAS |
| Data Migration: | MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard |
| Database Modeling & Other Tools: | ERWIN 4.x, Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare, SQL Trace |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2000 in upgrade project to SQL 2005.
| | Monitoring of database size and disk space in Production, Staging & Development environments
| | Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
| | Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
| | Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
| | Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
| | Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
| | Configured Database mail, linked servers in SQL server 2005.
| | Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
| | Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
| | Good Knowledge of using SSRS (SQL Server Reporting Services).
| | Installed and configured SQL Server Cluster server in SQL Server 2005 using HP servers for HP Customers.
| | Performed Production support and on Call duties.
| | Executed Change management scripts on weekly basis.
| | Documented upgradation procedures from MySQL to SQL Server and Oracle to SQL Server.
| | Created monitoring scripts to alert for production issues.
| | Migrated Databases from MySQL, Oracle, IBM Informix, to SQL Server 2005. |
Environment: SQL Server 2000, SQL Server 2005, HP Data Protector, Windows 2000/2003 Servers, T-SQL, Oracle PL/SQL, MySQL, Oracle 9i, PL/SQL Developer Tool, Informix 7.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Performed server installation and configurations for SQL Server 2005 and SQL Server 2000.
| | Performed installation of SQL Server Service Packs.
| | Upgraded databases from SQL Server 2000 to SQL Server 2005.
| | Involved in capacity planning, sizing and database growth projections.
| | Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
| | Setup backup and restoration jobs for development and QA environments
| | Created transactional replication for the reporting applications.
| | Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
| | Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
| | Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
| | Used SQL Server Profiler to monitor and record database activities of particular users and applications.
| | Used DBCC commands to troubleshoot issues related to database consistency.
| | Used Index tuning wizard to redesign and created the indexes for better performance.
| | Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
| | Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
| | Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
| | Worked on upgrading DTS packages to SSIS packages.
| | Implemented trigger and stored procedures and enforced business rules via checks and constraints.
| | Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
| | Reviewed DB Scripts from the development team before releasing them into the Production. |
Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Oracle8i.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Management of SQL Servers, databases, storage management for databases sizing from 25GB to 40GB.
| | Responsible for General Database Administration and Performance.
| | Data Migration from legacy to master tables using DTS-import and Export wizard.
| | Trouble shooting Problems by using SQL server profiler.
| | Updating with latest service packs and security patches.
| | Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
| | Created indexed views in T-SQL to increase the query performance.
| | Develop Backup & Restore scripts for SQL Server as needed.
| | Created reports using SQL Server Reporting services.
| | Has done DBCC checks to ensure the physical consistency of the database and objects.
| | Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby. |
Environment: Windows 2000 server, VB6.0, XML, SQL Server 2000, Erwin 4.0, T-SQL, SQL Server Reporting services.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Creating and maintaining various databases for Production, Development and Testing using SQL Server 2000.
| | Installing SQL Server 2000 on the server and client machines, providing connections and managing databases.
| | Planning and scheduling backups and developing recovery procedures.
| | Migration of data across different databases and different servers.
| | Creating procedures, functions, and triggers, handling database performance and tuning.
| | SQL Server Installation, patch application, migration of databases.
| | Creation of new databases, planning the location of data, index, and Transaction log files on disks.
| | Setting up backups for the databases.
| | Providing support to the Application developers on the application databases.
| | Handled 24/7 Production Issues.
|
Environment: MS SQL Server 2000, Windows 2000 Advance Server, MS Office.
| Client Name |
From Date - To Date |
| SQL Server DBA/Developer | |
Responsibilities:
| Installation, configuration and maintenance of the MS SQL Server 2000.
| | Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
| | Performance and tuning of SQL servers and application issues related to migration.
| | Testing of applications for performance, data integrity and validation issues.
| | Data Transfers between various servers using BCP and Managing Disk space on NT systems.
| | Migrated oracle8i data into SQL Server 2000.
| | Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
| | Complete automating on NT so that the tasks are run with out user monitoring.
| | Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
| | Administrative and Production support for various applications in all environments.
| | Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures. |
Environment: SQL Server 2000, SQL server 7, SQL server 6.5, T-SQL, Oracle PL/SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data, Oracle8i, TOAD.
EDUCATION/CERTIFICATIONS
Bachelor of Science in Computer Science from Bharathi Dasan University, India - 2002
Pursuing Microsoft Certification MCPD.
PLEASE LEAVE YOUR COMMENTS BELOW
CONSULTANT NAME
(SAP Tester)
SUMMARY
| Over 9 Years of total IT experience within that 8 years of experience as Software Tester, QA Analyst and ERP tester.
| | Extensive experience on Testing of ERP and Web application under validated (GXP (GMP, GLP, GCP) and SOX) environment.
| | Experience in analyzing business specification documents, developing test plans, defining test cases, developing and automating test scripts.
| | Extensively Tested SAP R/3 MM, SD, FI, APO, ICH, SCM, PP, HR, BW and Portal.
| | Proficient in manual and automated Mercury Testing Tools such as QUICK TEST PROFESSIONAL, WINRUNNER, LOADRUNNER, SITE SCOPE and QUALITY CENTER for testing SAP ECC, Portal, ICH, APO and BW.
| | Involved in TSL (WinRunner) and VB script (QTP and QC) coding to develop the Automation test scripts.
| | Involved in GUI, STRING, INTEGRATION, SECURITY, REGRESSION, BUSINESS COMPONENT, DATA, INTERFACE Testing, PERFORMANCE, VOLUME and UAT TESTING.
| | Experience on Preparation of TEST PLAN, TEST PROCEDURES, Manual and Automation TEST SCENARIOS, TEST SCRIPTS, Report DEFECTS.
| | Execution of Manual and Automation Business Components, Test Scripts through Test Management Mercury tool like QUALITY CENTER.
| | Experience on Defect tracking tools like Quality Center, Bugzilla, eRoom and Internal tools.
| | Created Automated Test Scripts to test the functionality of the application using SAP TAO and QTP.
| | Extensive Experience on Quick Test Professional of object repository, Data sheets, parameterization of data and user defined functions.
| | Extensively involved in Performance and Load testing using Load Runner.
| | Involved in monitoring the SAP servers, OS, Network drives and application components by Site Scope CCMS (computer center Management system).
| | Experience on all Quality Center modules like Requirements, Test for Defect Tracking, organizing, managing, planning and executing the Test scripts.
| | Experience in Quality Center, Quick Test Professional Installation and Upgrades.
| | Extensive knowledge of Oracle and SQL Server systems, including the ability to prepare and execute the queries required for reporting.
| | Extensive knowledge of Software Development Life Cycle (SDLC), methodologies and test processes and Software Testing Life Cycle (STLC).
| | Experience in conducting User Trainings on Quality Center.
| | Extensive Post Go Live implementation support.
| | Experience on process like Change Management, RICEF Management, Document Change Control, Scope Management and Mercury Issue Tracking database. |
| TECHNICAL SKILLS |
| Applications: | SAP R/3 ECC 6.0, 4.7, 4.6B, 4.6C in SD, MM, PP, FI, HR, ABAP/4, ICH, APO and SAP BW |
| Automation Tools: | SAP TAO, Quick Test Professional, Win Runner, Load Runner and SILK Test. |
| Management Tools: | eRoom, Bugzilla and Quality Center, Site Scope |
| Testing: | String, Integration, Security, Functional,Regression, Performance and Load Testing. |
| RDBMS: | Oracle, MS SQL Server and MS–Access
|
| Scripting Languages: | VB script and TSL
|
| Trainings: | SAP SD Configuration and RWD Info Pak
|
| Tools: | MS Word, Excel, Project, Visio, Power Point and Acrobat, VSS, CVS |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| Sr. SAP Test Facilitator | |
Responsibilities:
| Working closely with SAP Configuration Team to create manual test scripts, scenarios, test data and test conditions in Quality Center.
| | Involved in interface testing with legacy systems like pathfinder, e-Pay. | | Involved in preparation and execution of test scripts for Customer Master, Order Management, Logistics Execution, Collections and Account receivables under CTC (SD) module.
| | Involved in preparation and execution of test scripts for Master Data, Vendor Metrics, Direct Procurement, Indirect Procurement, AP-ePay, AP-SAP and Reports under RTP (MM) module. |
| Involved in BPT testing by using the SAP TAO, QTP and Quality Center.
| | Co-ordinate with functional team members to identify the automation test script for validated string, UAT and Regression test cycles.
| | Convert the manual test scripts into Automation test scripts by Inspect tool Or UI Scanner.
| | Involved in creating components, consolidate the components to build the business process tests and execution of the test scripts.
| | Used Quality Center to create and execute the automation test scripts.
| | Uploading the automation test results to Quality Center for PTTL and validation reviews. |
| Trained Power Users, Functional Teams, Process Team Test Leads, Fix Team and Validation on Quality Center.
| | Involved in administration and customization of the QC as per the validation requirements to implement the SOX, GxP and Legal process.
| | Provide assistance to testers and PTTLs on Preparing test conditions, Test scripts, Executing test scripts and Process flow.
| | Prepared Testing SOPs, Training and Testing Strategy documents.
| | Extensively involved in reviewing the pre and post execution of the test script all over the modules SAP CTC, RTR, RTP, QM, FTS and BW modules to ensure designers and tester are following the validation standards.
| | Implemented the flow diagrams for Pre-Execution Review, Post-Execution Review and Defect Life Cycle.
| | Involved in generating MS SQL Queries to prepare reports as requested by the functional teams, validation team and management. |
Testing and Load Runner
| Involved in String, Integration, Security, Technical, Performance, Load and UAT Testing.
| | Co-ordinate with functional team members to identify the transactions for performance and load testing.
| | Involved in Creation and Execution of Load Test scripts, Scenarios for modules like CTC, RTR, RTP, QM, FTS, BW Queries and Portal by using Load Runner VuGen and Controller.
| | Worked with Basis team, Functional teams with the issues of load testing.
| | Executed the Automated Load Test Scripts from the Quality Center.
| | Actively involved with Power Users to support User Acceptance Testing.
| | Involved in preparation of Daily, Weekly test status reports. |
Environment: SAP ECC 6.0, SD, MM, FI, APO (Demand Planning, Deployment planning, Supply Planning), SCM, ICH, PP (Plant Logistics, Manufacturing), BW, Quality Center, Load Runner, SAP TAO, QTP, Oracle and Windows 2000
| Client Name |
From Date - To Date |
| Sr. SAP QA Consultant | |
Responsibilities
| Worked closely with business analysts and developers to create test cases/scenarios, test steps, expected results and test data in Quality Center.
| | Reviewed the system requirement specification documents, developed the test strategy, test plan documents and also developed the traceability matrix between test requirements and test cases.
| | Extensively worked on testing of SAP SD Sales, Shipping, transportation, Billing and Credit Management modules.
| | Extensively worked on testing of SAP MM Inventory Management, Purchasing and Material Master Modules.
| | Involved in Testing of SAP HR modules like Personal Management, Personal Time management, Master Data, Time Management, Payroll, Employee self services (ESS) and Manager Self services (MSS) and Payroll.
| | Involved in HR interface testing with Legacy systems like CHEMP and CHPAY.
| | Developed Test Scripts for various processes in FI like Cost Estimate for Material, Internal order, Cost center settlement etc.
| | Created test plans & test cases in Quality Center from the business requirement document and technical specifications.
| | Presented the test script alternatives to managers and getting sign off.
| | Developing the QTP Framework and implemented it to automate the Application.
| | Developing the Automation Test Scripts for Functional Testing by using QTP.
| | Uploading the Automated Functional Test Cases into Test Plan in the Quality Center.
| | Mapping the Test Cases from Test Plan to Test Lab under Quality Center for Execution.
| | Executing the Automated Test Cases through Quality Center.
| | Reviewing the defects and Reporting the Defects through Quality Center.
| | Developed automated scripts for Web version of the Application using Quick Test Professional and executed the Quick Test Professional scripts for Regression testing.
| | Preparing Test Strategy, Test Plans and conducting consolidation acceptance test.
| | Worked extensively in Performance testing and Production support.
| | Expertise in Performance, Stress and Load Testing using Load Runner.
| | Actively participated with User groups to perform extensive User Acceptance Test.
| | Performed Record, report, and track defects to accurately depict the status of the system, daily testing status reports and acting as a single point of contact for defect tracking issues and updates.
| | Post go-live support. |
Environment: SAP R/3 4.7, BW 3.1C, FI, SD, MM, HR, QTP, Quality Center, Oracle, eCATT, Windows NT/2000.
| Client Name |
From Date - To Date |
| Sr. SAP QA Consultant | |
Responsibilities:
| Involved in AP SD, MM and HR Modules.
| | Involved in the development and implementation of a complete testing life cycle for different components in SAP SD, MM and HR modules.
| | Closely worked with end users and development team to understand the process.
| | Developed test design documents, integration test documents, status reports, traceability requirements, risk analysis, scheduling estimates, timelines and milestones, setting priorities and also determining scope and limitations of tests.
| | Extensively involved in testing of SAP HR Personal Management, Time Management, Payroll, Training and Event management modules.
| | Worked closely with Software Design Engineers and Program Managers to understand product requirements, functionality and design.
| | Used the Toad, SQL+ tools to test the Oracle database.
| | Used Quick Test Professional to test the functional testing of the application.
| | Developed the scripts in Standard and Low level recording and used Object Repository to store all the test objects and implemented synchronization points, and check points.
| | Responsible for writing the load test plan document for load test and designed the load test environment.
| | Created Load Runner scenarios by utilizing Load Runner controller and Vugen to create a Vuser script and parameterized the scripts and enhanced them according to the test cases.
| | Used performance monitors and Load Runner graphs to analyze the results.
| | Generated Data Driven scripts that access the backend database.
| | Used Test Director to invoke the scripts and initially performed the baseline testing and organized all the scripts systemically and generated reports.
| | The Average CPU Usage, Response Time, Network Delay are analyzed for each scenario.
| | The scripts designed to be used for testing on future releases of the application. |
Environment: SAP 4.6C, SD, MM, HR, Java, Oracle, CATT, Quick Test Professional and Test Director.
| Client Name |
From Date - To Date |
| SAP QA Consultant | |
Responsibilities:
| Testing of Client/Server environment in SAP FI, MM, SD modules using manual as well as automated tools.
| | Involved in documenting Test Plan, Test Cases and Test Procedure using Business requirements document and Functional requirements document of the system.
| | Conducted entry validation tests on all the online Applications - both positive and negative Tests.
| | Identification of Test data and validation of Test environment.
| | Involved in Integration testing (end-to-end Cross-Functional process chain).
| | Recording of various tests and stored in the database for reusability.
| | Reporting of bugs using Test Director.
| | Monitored the status of bugs until they were sorted out. Made summarized and detailed test reports.
| | As QA Analyst involved in Documentation of Integration, Regression and Security testing.
| | Involved in creation of Virtual Users using Load Runner.
| | Involved in creation of low, medium, and Peak load scenarios.
| | Involved in generating scripts for the load tests as per the requirements.
| | Involved in creating the Scenarios for single and Multi-Vuser test.
| | Performed User Acceptance Testing (UAT), Validation Testing, Smoke Testing, Unit testing, Functionality Testing and Integration Testing.
| | Automated testing using QTP with the help of manual test cases.
| | Involved in Data Migration testing i.e. used old data and checked the validity of the data.
| | Prepared training documents for end users of application. |
Environment: SAP 4.6B, CATT, QTP, Load runner, Test Director, SD, MM and FI/CO.
| Client Name |
From Date - To Date |
| SAP QA Tester | |
Responsibilities:
| Developed various Reports, Interfaces, Forms/Layouts using ABAP/4 in SD and
| | MM modules.
| | Performed data migration from legacy systems to SAP R/3 using session and call
| | Transaction techniques.
| | Tested Sales and Distribution module configuration settings.
| | Prepared test documentation for configuration settings.
| | Test planning for the requirements given & the required functionality.
| | Created Test plans & Test Cases in Test Director.
| | Executed Test cases using Test Director.
| | Tested and transferred legacy data into SAP system.
| | Involved in Black Box Testing and Unit Testing.
| | Involved in performing different types of Testing Unit, Integration, Regression, Data Driven and Validation Testing.
| | Involved in Modification of the existed test scripts.
| | Tracking, analyzing, review and comparison of defects using Test Director.
| | Testing & verifying the custom development & system changes which the ABAP programmers developed.
| | Post Go Live support by addressing project specific calls. |
Environment: SAP R/3 4.6B, MM, SD, FI/CO, Windows NT, Manual Testing and Test Director.
| Client Name |
From Date - To Date |
| Software Engineer | |
Responsibilities:
| Created Detailed Test Plan and Test Cases through understanding of the Business Requirement Documentation and technical specifications.
| | Analyzing the user specification / Client requirement documentation and system design.
| | Involved in setting up the Test Environment and using SQL queries for the test data.
| | Performed Cross Browser Testing to ensure compatibility of the application on IE and Netscape.
| | Executing the Test Cases through Test Director.
| | Involved in Functional Testing, Regression Testing and Compatibility Testing.
| | Reporting Defects through Test Director and Bugzilla.
| | Performed Regression testing against each new build.
| | Coordinated with development team for bug fixes and Preparation of Test Execution Report. |
Environment: Java, J2EE, Oracle, Winrunner and Test Director
EDUCATION/CERTIFICATION
Bachelor of Engineering in Computer Science & Engineering from Bharathi Dasan University, India - 2002
PLEASE LEAVE YOUR COMMENTS BELOW
CONSULTANT NAME
(Oracle Apps Developer)
SUMMARY
| About 6 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications 11.5.x/11.0.3 spread across Implementations, Version upgrades, Data conversions and Customizations. | | Experience in three full lifecycle implementations. Strong knowledge of Order to Cash and Procure to Pay Cycles.
| | Extensive experience in Oracle Application Modules which include General Ledger(GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing(PO), iReceivables, iProcurement, iStore, Fixed Assets(FA), Inventory (INV), Bills of Material (BOM) & Order Management (OM) modules.
| | Extensive Programming experience in Oracle 10g/9i/8i, SQL, PL/SQL and XML.
| | Expertise in Forms 9i/6i and Reports 9i/6i. | | Experience in Application Object Library (AOL) Framework for forms based applications as well as Oracle Applications Framework (OAF) for Self Service Frame Work 5.6E.
| | Expertise in Data Conversion and Interface development | | Experience in Oracle Discoverer and XML Publisher
| | Experience in Workflow Customization according to business needs. | | Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment. | | Experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases. |
| TECHNICAL SKILLS |
| Oracle Applications: | Oracle Applications 11.5.x/11.0.3/10.7. (Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Fixed Assets (FA), Order Management (OM), Inventory (INV), Purchasing (PO) Bills of Material (BOM), iProcurement, iReceivables, iStore and Application Object Library (AOL)). |
| Languages: | Java, SQL, PL/SQL, HTML, PHP, C, C++ UNIX Shell Scripting |
| RDBMS: | Oracle 10g/9i/8i, MS SQL Server 6.5/7.0, MySQL 4.1, MS Access |
| Oracle Tools: | Forms 6i/9i, Reports 6i/9i, Oracle 8i/9i, Discoverer 4i/9i, JDeveloper, Work Flow Builder and XML Publisher. |
| Database Tools and Utilities: | SQL*Plus, SQL* Loader, Toad |
| Operating Systems: | UNIX, LINUX, Windows 98/NT/2000, MS DOS, Solaris 8.0 |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
This Project involved implementing of Oracle Applications 11i. Responsibilities included writing conversions and interfaces, customization and development of reports using Reports 6i, Discoverer 4i and XML Publisher and customizing forms using Forms 6i in GL, AP, AR, OM, PO, INV.
Responsibilities:
| Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
| | Worked extensively on Customer Conversion using interface tables to import customer data from Legacy AS/400 system. Was involved in data mapping, and interaction with functional consultant and business users.
| | Developed a custom item interface program for loading legacy items information into Inventory Item Interface tables, by validating items according to their predefined item categories and category sets.
| | Designed and developed Order Import Interface for daily and weekly feeds of orders.
| | Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations.
| | Customized AR account status Report, and AP Trial Balance report using Report 6i tool.
| | Designed and developed reports using combination of Report 6i and XML publisher for modules like Purchasing and Order management.
| | Developed reports in Discoverer 4i and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
| | Involved in Workflow customization for approval hierarchy level in Purchasing.
| | Developed interfaces integrating Vertex O-series with Oracle Modules OM and AR.
| | Created several Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
|
Environment: Oracle Applications 11.5.10.2 (AR, AP, GL, PO, OM, INV), Solaris, Oracle 9i, Forms6i, Reports 6i, Discoverer 4i, Workflow 2.6, PL/SQL, SQL*Loader, Toad 8.5
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Assigned as Oracle Applications Technical consultant to design, customize, implement and support Oracle Application. Involved in full implementation life cycle of GL, AP, AR, PO and FA. Responsible for implementation of 11.5.10.2.
Responsibilities:
| Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
| | Worked on Purchase Orders conversion. Responsibilities involved configurations, data mapping using SQL*Loader to import legacy Suppliers into Oracle.
| | Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
| | Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
| | Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
| | Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables.
| | Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
| | Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
| | Customized the following workflows:
o PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow
o PO Account Generator Workflow
| | Worked closely with the team responsible for Setups and Customization of self service modules like iProcurements, iExpenses, iPayment, iReceivables, Modified XSL, JSP, XML files for additional functionality and GUI enhancement.
| | Created and modified PL/SQL API for creation of assets retirement and Mass additions in interface table in FA module.
| | Involved in the process of splitting the bank file to feed Auto lockbox.
|
Environment: Oracle Applications R11.5.10.2 (AR, AP, GL, PO, FA, iProcurement), Solaris, Oracle 9i, Forms6i, Reports 6i, Discoverer 4i, PL/SQL, SQL*Loader, Toad 8.5, Workflow, Jdeveloper.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Provided technical support in terms of design, analysis, development and testing of customization and extensions for Oracle Applications 11i (GL, AP, AR, PO, iProcurement).
Responsibilities:
| Developed an interface to upload the legacy GL Journal data into the Oracle Application System, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations
| | Developed various custom reports and customized standard Oracle reports like Account Status Report and Bank Account Listing as per the business requirements.
| | Used Payables Open Interface to import payables information from legacy system to Oracle Applications.
| | Designed and Developed AR Auto-invoice interface from different front-end systems
| | Customized Invoice printing Report for selected invoices and new invoices as per user requirements.
| | Modified PO Requisition workflow as per user requirements.
| | Customized iProcurements pages as per client requirements added additional functionality in it by customizing .jsp, .jspx files using JDeveloper.
| | Developed new reports for Oracle Payables as per Business requirement.
| | Customized PO Account Generator Workflow and Requisition Account Generator Workflow for Generating Project Charge Account.
| | Prepared categorized iProcurements catalog for different kind of items used in the company.
| | Provided support to create iStore hierarchy and associate item to iStore hierarchy.
|
Environment: Oracle Applications 11i (11.5.10) (AR, AP, PO, GL, iProcurement, iStore), Oracle 9i, PL/SQL, TOAD, SQL*PLUS, Reports 6i, UNIX, Workflow 2.6.
| Client Name |
From Date - To Date |
| Oracle Apps Technical Consultant | |
It was an upgrade project where the client upgraded from Oracle Applications 11.0.3 to 11i. Responsibilities included customization of components, review of functional and technical design documents and coding.
Responsibilities:
| Customized Reports in OM and inventory.
| | Upgraded shell scripts, which calls reports, control files and sql files which are in the production.
| | Worked on forms personalization, which is a new feature in 11.5.10
| | Developed custom Reports in INV and BOM modules using Reports 6i
| | Customized workflows in PO according to the requirements.
| | Customized BOM reports like Bill of Material Listing, Bill of Material Loop Report, Department Report and Item Report.
| | Developed custom Requisitions and Purchasing Documents Interface to import requisitions information from legacy system. Used SQL* Loader, PL/SQL packages to validate the data before inserting into base tables.
| | Customized the COGS Account Generator workflow in OM.
| | Developed some adhoc reports using discoverer according to the client requirement.
| | Implemented Oracle Workflow for activating Quality Sample Notifications, Testing Notifications, and Sample Disposition Notifications etc.
|
Environment: Oracle applications 11.0.3/11i (AR, BOM, INV, PO, OM), TOAD, Discoverer 10g, forms 6i, Reports 6i, windows 2000, Unix (Solaris 5.9), shell scripting, Workflow.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
This project involved implementation of Oracle financial modules (Oracle General Ledger, Account Payables, Account receivables and Oracle purchasing).
Responsibilities:
| Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable and Oracle Purchasing and General Ledger.
| | Gathered requirements for various RICE elements from the Business Users and created technical design documents.
| | Imported data from legacy system to Oracle Payables tables using SQL*Loader and validate them using PL/SQL procedures.
| | Generated weekly/monthly/yearly Reports using Discoverer 4i for Department wise Payments to vendors.
| | Developed SQL*Loader Program to migrate the Customer information captured from the text files to staging tables.
| | Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
| | Developed an interface to upload the journal data into the Oracle Application’s General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations
| | Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.
| | Developed Custom Reports for Billing History by Client, Invoices and Projects.
| | Worked with workflow builder on order management and account receivables to backup the notifications
|
Environment: Oracle Application 11.5.9, SQL*Loader, TOAD, Windows XP, UNIX. Discoverer 4i. Modules: (GL, AP, AR, PO, OM), Forms 6i and Reports 6i.
| Client Name |
From Date - To Date |
| Oracle Applications Techno-Functional Consultant | |
Worked as a Technical Consultant for new Oracle Applications Implementation at Spectrum Chemicals. Responsibilities included Oracle reports, Discoverer reports, packages, procedures, functions and custom tables
Responsibilities:
| Interacted with the functional team to understand the business and user requirements
| | Interface Designing and Applications development.
| | Designed the Product Transaction Listing by Customer report in AR
| | Designed and developed migration scripts for all activities and GL migration.
| | Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
| | Developed PL/SQL program to perform validations and to relate customers with addresses, contacts, banks and profiles and move the data from staging table to interface tables
| | Loaded existing Purchase Orders of the legacy system through SQL* Loader, validated (in AP) whether those PO’s are paid and finally valid entries are recorded in GL. Also, an exception report was created
| | Developed custom reports for Billing history by client and Invoices by client report using Discoverer 4i.
| | Designed and customized the following reports using Oracle Reports Builder 6i in OM and Service Contracts:
o Sales Order Report with Contract Details
o Holds Release Report
o Product Transaction Listing by Product
|
Environment: Oracle Applications 11.0.3 (GL, AP, OM, PO, AR), Oracle 9i, UNIX, Reports 6i, PL/SQL, SQL*Loader and Toad
EDUCATION/CERTIFICATIONS/AWARDS
Bachelor of Engineering in Computer Science & Engineering, Bharathi Dasan University, India - 2002
OCP Oracle Functional Certification, PMI Project Management Certification
PLEASE LEAVE YOUR COMMENTS BELOW
|
