Umesh Parit

Requirement review with the customer and business analyst and providing effort estimation. Ensure bug free deliveries. Write complex SQL queries, analytical functions, table partitioning and inline views Performance tune and optimize SQLs using explain tables, by setting database parameters, by using optimizer hints to compute statistics on tables. Collaborate with SAP team members to generate innovative ideas to do smooth migration activity.

• Requirement review with the customer and business analyst and providing effort estimation. • Ensure bug free deliveries. • Organize brain storming session with other team members to generate ideas and download collective thoughts. • Proposed technical feasibility solutions for new functional design and suggested options for performance improvement of technical objects. • Designed Interface specification document and their integration with the other applications.

• Involved in maintaining application in production environment. This maintenance includes handling over 19 million o2 Customer data and their transactions. • Design, develop, and maintain PL/SQL standalone procedures, standalone functions, packages, triggers, standard views, materialized views, unique indexes, non-unique indexes, reference cursors, tables, and other PL/SQL creations. Use Collections like variable arrays, nested tables. • Review design and code of other members of the team.

• Created and maintained PL/SQL scripts and stored procedures and helped to improve the performance, scalability and stability of database systems. • Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with industry best practices. • Translated business requirements into technical requirements and delivered application code that is fully tested and meets the business requirements. • Understand and learned the technologies used in the project.

Computer Science

Mathematics