VENKATARAMANA YELLA

acsbdd@r.postjobfree.com

678-***-****

CAREER OVERVIEW

Extensive experience of over 18 years in information technology as a technical oracle Applications developer(11 years) doing interfaces and conversions and recently in QA Testing (5 years).

Hands-on experience as a Senior QA Analyst involved in all phases of Software Development Life Cycle (SDLC) with emphasis on Software Testing Processes.

Extensive experience in preparing test plans, test cases, test scripts and test data based on business requirements and functional requirements, Identify, communicate and track issues.

Successfully handled distinct responsibilities of developer and testing analyst.

Experience working on HP and Relational Tools.

Excellent experience with backend testing by writing SQL statements.

Excellent experience in doing data migrations, analyzing data and data validations.

Excellent knowledge of Waterfall Methodology and Agile methodology.

Good experience in Integration, Functional, System, Regression Testing and UAT testing.

Worked for Oracle Corporation and Bearing Point Inc and JP Morgan Chase.

Consulted to various high profile clients such as Fannie Mae, JP Morgan Chase, Dept. of Home Land Security, Dept. Of Health & Human Services, Citigroup, Boeing Corporation, ESPN Inc., Eckerd Corp., Tracfone Wireless Inc., Lightning Source Inc., CMS Energy, Fieldcrest Cannon Inc., Celotex Corporation, Advantor Corp, Mastec Inc. etc. in the area of financial applications.

SKILLS

Languages/Tools: HP Quality Center/ALM, Clear Quest, Beyond Compare tool, SQL* Loader, SQL, PL/SQL, Structured Query Report writer (SQR), Oracle Reports, TOAD and SQL Developer.

Database: Oracle, MS SQL Server.

Other Products: MS-Excel, MS-Word, MS-PowerPoint, Visio, PVCS version control system, Kintana Migration tool.

Operating Systems: UNIX, Windows

ORCL Apps: Oracle Applications, Accounts Receivables, Accounts Payables, Order

Management, General Ledger.

EDUCATION

B.E, Electronics & Communications Engineering, GNDEC, Gulbarga University, India, 1993

Advanced Diploma in S/W Applications, India, 1995

SUMMARY OF EXPERIENCE

SR.ANALYST AND TESTING CONSULTANT, FANNIE MAE SEP, 2014 – JULY 2015

Tools: Clear Quest and HP Quality Center ALM, TOAD

Worked in Financial Data Warehouse re-write project to support corporate initiatives including Security Master, INTEX and ODS.

Working as analyst to capture data quality rules and Perform Integrated user testing.

Analyzed and provided support on a wide variety of data issues related to securities.

All the Defects were thoroughly investigated and documented using Clear Quest.

Performed data validation, data integrity, and data reconciliation.

Working on SAM Position reconciliation reports. Validating and comparing CUSIP level UPB balances between SAM and FDW.

Working on INTEX recon and GEO reconciliation reports.

Developed and implemented test cases for data verification, business logic and derivation testing (Used HP Quality Center ALM)

Performed UAT, Integration and Regression testing. Extensively used Oracle SQL.

SR.TESTING CONSULTANT, JP MORGAN CHASE OCT, 2010 – OCT,2013

Tools: Oracle SQL Developer, MS SQL SERVER, HP Quality Center and Beyond Compare

Worked as a Sr.QA Tester to manage 10 offshore testers (India) and 5 on-site testers.

As a Sr. Tester my responsibilities were to estimate the time required for developing test cases and maintain Resource scheduling and hiring and assigning test cases and defects to resources. Involved in planning the Production release and go-live testing.

Conduct daily check point meeting and Defect call.

Developed Test Plans, Test Cases, Test Scripts and test sets in Test Lab.

Conducted Integration, System, Regression and User-Interface testing. Worked extensively in writing Test scripts with Oracle SQL and Transact SQL (MS SQL SERVER) to test the data.

Analyzed Business Requirements and Prepared Test Cases.

Prepared test cases based on Requirements and Data Mapping document to make sure every scenario in requirement document is covered in test cases.

Performed System Testing, Regression Testing and Dress Rehearsal testing..

All the Defects were thoroughly investigated and documented.

Worked closely with business users and developers to resolve issues.

Used HP Quality Center for Defect Reporting and Defect tracking.

SQL Developer and SQL Server are used for data validation testing.

Extensively involved in writing, SQL queries and performed backend testing to help develop and test Conversions and Migrations from Legacy and Payment net 3 systems to Oracle Payment net 4 Database.

SR.TECHNICAL CONSULTANT, BEARING POINT/DELOITTE AUG, 2005 – AUG, 2008

Tools: Oracle Applications 11.5.9, TOAD/SQL Navigator, Kintana, UNIX, PL/SQL

Project at Dept. Of Homeland Security: Worked as a Oracle Applications Technical consultant to help develop and test Conversions and Interfaces to migrate data from legacy to Oracle Apps.

Responsible for developing and testing oracle reports for Oracle Federal applications such as AR and AP.

UFMS Project at Dept. Of Health and Human Services: Worked as a Oracle Applications Technical consultant in the Unified Financial Management System to help develop and test Conversions and Interfaces from legacy to Oracle Apps.

Developed and tested programs for conversions of CAN-BACs.

Developed and tested interface to run etravel system.

Used SQL and PL/SQL to migrate and convert the data.

SR.TECHNICAL APPS DEVELOPER, ECKERD MAR, 2005 – AUG, 2005

Tools: Oracle Applications 11.5.9, SQL Navigator, Test Director, UNIX, PL/SQL

Responsible as a team member for Developing, Testing and migrating applications from Eckerd systems to Jean Coutu systems.

Responsible for integration between Eckerd systems and Brooks systems. Developed and tested inbound program using PL/SQL packages to load data (AP paid invoices) from external AP system into Oracle GL via the standard open interface.

Developed outbound program using stored procedures from Oracle GL to load the journals that are posted into an external accounting system.

Developed stored procedures to be used in the interfaces.

Modified the existing database triggers to add additional functionality.

Analyzed Business and System Requirements.

Prepared Test Plan.

Prepared Test Cases from Requirements and Use Cases.

Performed System Testing, Regression Testing, Failover Testing and Integration Testing.

Maintained and executed test cases using Test Director.

All the defects were thoroughly investigated and documented in Test Director.

Mapped Test Cases with Requirements and Use Cases, prepared Requirements Traceability Matrix document to make sure every scenario in requirement document is covered in test case.

SQL Navigator is used for data validation testing.

Involved in User Acceptance Testing (UAT) with users.

APPS LEAD, NEXSPHERE NOV, 2004 – FEB, 2005 Tools: Oracle Applications 11.5.9, TOAD, Oracle 9i, UNIX, PL/SQL

Worked as a Oracle Applications Team Lead and having three developers reporting to me.

The project is a total customization of oracle apps. It is a retail store application which also has inventory module and AR module to it.

As a team lead coordinating the development work and supporting the project (Production Support) for the client in US. The client is Robbins Brothers who is the world’s largest Engagement ring/Jewelry store.

ORACLE APPS TECHNICAL CONSULTANT, CITIGROUP MAY, 2003 – OCT, 2004 Tools: Oracle Apps 11.5.4/11.5.9, Kintana, PVCS, TOAD, Oracle 8i/9i, UNIX, PL/SQL

Worked as a Oracle Accounts Payables Developer.

Developed various reports and interfaces (outbound and inbound) for global implementation.

Created packages to be used for the interfaces using PL/SQL.

Created database triggers.

Customized standard oracle reports.

Developed Collection Document report for Brazil AP globalization. Modified existing Spanish globalization reports to add corp code.

Developed interface to create flat file for the German Central Bank called ‘AWV report’.

Developed Quotation Savings Report in PO.

Customized the AP Invoice Register Report for Taiwan globalization. Developed ‘Contract Payments Report’. Developed an interface to report all Puerto Rico taxes to government. Customized Payment Exceptions Report.

ORACLE APPS TECH ANALYST, MASTEC INC. JULY, 2001 – FEB.2003

TOOLS: PL/SQL, SQL NAVIGATOR

Provided technical production support and worked as an oracle developer for Mastec Inc. which is a major Telecommunication Services company based in Miami, FL.

Worked on Interfaces and Conversions using PL/SQL, stored procedures, functions and database triggers for Oracle financial Modules (AR, AP, CM) and Oracle HR.

Developed PL/SQL packages for Converting Employees, their Addresses, Assignments, Salaries, Costing and their Dependents Conversion, Federal and State Tax Conversions, Element Entries Conversion for Oracle HRMS.

Developed program for Cash Management Bank Reconciliation interface.

Helped in developing programs for Open Invoices and Customers in AR module and Vendor Conversion in AP. Developed Positive Pay Interface for AP.

Documentation done using AIM Methodology.

PRINCIPAL CONSULTANT, ORACLE CORPORATION JULY, 1998 - JUNE, 2001

Boeing Corp., Seattle, Oracle Applications 11i Upgrade Project. Boeing a major Aerospace company is upgrading its existing Oracle Applications from Rel 11 to Rel 11i and from Oracle 7.3 to Oracle 8i. I was technically supporting the functional team in the upgrade project. Documentation done using AIM Methodology.

Tracfone Wireless Inc., Miami, Oracle Applications v11 Project. Responsible for designing and developing Custom Sales Order Cancellation Process in Order Entry Module and also helped the client on resolving the PO Receipts interface errors in Oracle Purchasing. Worked on various EDI Transaction Processes like 810, 856 and 850 in 4010 standard. Developed Auto Invoice interface programs for Accounts Receivables. Also developed new and modified existing reports using Oracle reports. Documentation done using AIM Methodology.

Lightning Source Inc., Nashville, Oracle Applications 11i Project. Responsible for implementing the Sales Order Import Interface in Order Management Module, AutoLockbox interface, Open Invoice interface and Conversion and Customers Interface in Oracle Receivables Module, Inventory Items Import interface, Oracle Inventory. Customized existing reports in AR to meet client's requirement. Also worked on System Administration Module. Documentation done using AIM Methodology.

Marex.com, Miami, Oracle Applications Rel11 Project. Responsible for implementing the Customer and AutoInvoice Interfaces to Oracle Financial Applications, AR Module. Provided technical team lead support to the client on the Interfaces task.

Advantor Corporation, Orlando Oracle Applications Rel11 Project.

Responsible for developing and implementing the conversion of legacy system data to Oracle Financial Applications, AR Module. Developed and implemented Customers and Open Invoices conversion programs using PL/SQL and SQL*Loader. Documentation done using AIM Methodology.

Celotex Corp., Tampa, Oracle SalesAnalyser Implementation Project. Responsible for developing customized PL/SQL procedures to load the Customer Data from AR tables into the Staging tables of Oracle Sales Analyzer.

SLI Lighting Solutions, Raleigh, Oracle Applications v10.7SC Project. Responsible for modifying a couple of customized AR reports to meet customer’s business needs.

Carfel, Miami, Oracle Financials V10.7SC Project. Worked on integrating third party shipping module with Oracle Order Entry. Developed interfaces to do the integration.

eMD.com, Atlanta, DotCom Project. The client is an end-to-end Internet healthcare provider company connecting physicians and consumers to the entire healthcare industry. eMD.com is using the Internet to facilitate a new system for the delivery of healthcare, resulting in a single, secure environment for all communications and transactions that will enable a more efficient and cost effective healthcare system. Responsible for developing the web site eMD.com using HTML and JavaScript along with other team members.

American Bankers Insurance Group, Miami, Oracle WEBDB. The client is engaged in a broad range of insurance and insurance-related activities and financial services in the United States and abroad. ABIG's primary activities include both general and life insurance operations. Responsible for development and modification of the web site for ABIG using WEBDB2.0.

Oracle Internal Project, Atlanta. Involved in development of the iSolutions web site for Oracle using WEBDB2.0.

LHS Comm. Inc., Miami, SQL Tuning Project. The client is a developer and service provider for wireless billing system software. They had issues in performance of about 20 SQL statements. Responsible for Tuning the SQL statements to increase the performance and accomplished the task.

CMS Energy, Detroit, Oracle Applications v10.7 implementation. The client CMS Energy is implementing Oracle Applications. Responsible for developing custom programs for Interfaces of GL Foreign Currency rates interface, GL Journal Import and AP Vendor Conversion from SOLOMON legacy system to Oracle using PL/SQL. Documentation done using AIM Methodology.

Bellsouth, Birmingham, Oracle Applications v10.7 Project. The client Bellsouth is implementing its “Bellsouth Construction Management” project for which Oracle is helping with the implementation of Oracle Project Accounting module. Responsible for development of some custom reports using Reports 2.5. Also worked on GL Journal Import. Responsible for developing the GL interface program for Journal import.

Oracle HQ, MRC Project. Worked on the development of Oracle Applications Release 11.5 ‘Multiple Reporting Currency’. Created Stored procedures(API’s). Modified existing API’s and database triggers. Created GL_MC_INFO package.

Eckerd Corp., Tampa, Oracle Applications v10.7SC Project. The client ECKERD CORP which was outsourced by IBM has implemented the Oracle General Ledger. Responsible for developing programs for conversions and interfaces and was also involved in the cleanup process of the Code Combination Id’s. Responsible for execution of the project plan and developed programs for legacy data conversions to meet the specific needs of client. The legacy system is Mainframe (DB2/AS400). Developed custom Conversion and interface programs using PL/SQL. Provided support in setting up Descriptive Flex fields, Value sets, Concurrent manager scripts, report groups, user responsibilities etc. Documentation done using AIM Methodology.

Applications Consultant, Quality Information Systems, USA APRIL, 1997 - JULY, 1998

Apps Consultant, FieldCrest Cannon Inc./Pillowtex Corp, Kannapollis, NC, Oracle Applications v10.7SC. Worked on Accounts Receivables and Accounts Payables. Involved in conversion of data from legacy system into Oracle and implementation of Lockbox. Responsible for developing Interface scripts and conversion programs in AR to load all the customers and open invoices from existing database to Financials database using control files(SQL*LOADER), PL/SQL and Customer Interface and Auto Invoice programs. Responsible for developing conversion scripts in AP to load all the invoices from existing database to Financials database using SQL*LOADER, PL/SQL and Invoice Import program. Responsible for the implementation of Lockbox.

Apps Consultant, ESPN Inc., Bristol, CT, Oracle Applications v10.6. The goal of the implementation project is to implement the Financials (AR, AP, GL, PO). Worked on Accounts Receivables. Involved in customization of reports and conversion of data from legacy system into Oracle Financials Database. Responsible for developing Interface scripts to load all the customers and invoices from existing database to Financials database using control files(SQL*LOADER), PL/SQL, SQR and Customer Interface and Auto Invoice programs. Responsible for developing conversion scripts to load all the open invoices from non-oracle feeder systems into Oracle Financials database using SQL*LOADER and PL/SQL. Developed Invoice Print Programs using Structured Query Reportwriter(SQR). Documentation done using AIM Methodology.

Contact this candidate