GURRAM VINAYCHANDRA Ph. no: +919731642493, 8904493218 Email: gurramvinaychandra@gmail.com OBJECTIVE: Contribute to my team and organization by working in a highly effective

manner and having a commitment to meet or exceed expectations by Comprehending, Listening and Converting Business problems into Technology Solutions, using the Knowledge, Experience and Skill sets in software field.

SUMMARY: Having 2+ years of, Oracle PL/SQL and Forms. Mainly in software analysis, design, implementation and Development of forms, Triggers, Stored Procedures and Packages.

Having knowledge in Procure to Pay Cycle. Programming skills in PL/SQL and SQL and Completed OCA Certification. Good Technical knowledge in developing new Forms, Interfaces and Form

Personalization’s.

EDUCATION: B.Tech in Information Technology, Jawaharlal Nehru Technological University, AP.

SKILLS:Database : Oracle 9i, 10g, 11g,D2K and DBA Oracle Tools : SQL * Plus, SQL * Loader, Toad, PL/SQL Developer and Oracle 9i AS.Front End Tools : Forms 9i Developer.WEB : XTML and XML. Operating Systems : Windows 9x/NT/XP/2k, UNIX-AIXLanguages : C, Oracle SQL, PL/SQL, Oracle Developer.

WORK EXPERIENCE:

Working as a Software Engineer in Neovera Solutions, Bangalore.

PROJECT EXPERIENCE :

           Project Title : MEDCOPlatform : Oracle 9i SQL, PL/SQLRole : As a PL/SQL developer

Description : Medco is a health insurance client. I worked as PL/SQL Developer to help the different Domains which are there in MEDCO. • Tuned many procedures and packages of different modules. • Helped in debugging the codes. • Wrote many queries to help different modules in MEDCO using Joins and Sub queries. Solution Environment PL/SQL, ORACLE 9i.

Project Title : Wisdom (Agile methodology)Platform : Oracle 10g, PL/SQL, Toad, Windows and UNIXMy role : Developer

Description : WISDOM is a Validated Project executed on Pharmacy domain. The application having objective to serve the requests of the customers with right kind of responses based on pharmacy products. The response can be of different type. This enables to get product related feedback and intern giving the right responses for the queries of their customers/Health Care Professionals.

Responsibilities: Involved in design of the database, which includes, table design and their

relations.

Creating PL/SQL Packages, Procedures, Functions and Triggers for data

population and updating as per project requirements.

Understand the Business requirement as well as given specification.

Develop SQL Queries for checking data transaction and database integrity.

Responsible for creating triggers to enforce complex business logics.

Writing cursors according to specifications.

Creating Database Triggers To Maintain Data Integrity.

Involved in training the support team to take over the production support activities

after every release.

Project Title : IPID-UK rPACSPlatform : Oracle 10g, PLSQL Developer, ETL, Windows XP My role : Developer Description : IPID is Physical Inventory Database it is used to store all network elements and

PACS is a Planning Assignment Configuration System. It is an Oracle based System used to maintain the Quality of data instead of IPID. Migrate the Black Box, Fully Model and Broadband data from IPID to UK_rPACS. It follows the levels of Hierarchy like Equipment’s, Slots/Cards, Ports and Connections. 

Responsibilities : Design the UDMF process for Extracting, Transform and Load data into rPACS. Writing of Procedures, Functions and Packages to meet business logics. Involved in load Flat File data using SQL * Loader. Developed various Procedures for applying Transformation rules. Involved in Fallout Management Process. Developed Packages for Data Reconciliation and Rectification. Writing the test cases for unit testing.

Affiliations: • Oracle Certified Associate in Introduction to Oracle 9i: SQL