Karthik Polla

NPR: New Edge Product Referential

A referential database that gathers data from exchanges and sends it to Gold application.

Roles and responsibilities:

• Investigated system issues and implemented resolutions to reduce downtime by 12%.
• Became a Single Point of Contact(SPOC) for entire ORACLE Team Handling, Monitoring & Reviewing Activities within team.
• Supported Production Movement Activities and Involved in Performance Tuning.
• Used GIT, Jira, and ServiceNow for versioning, tracking, and production rollouts.

Galaxy : Galaxy is a Sales force automation system to maintain B2B activities.

Roles & Responsibilities:

• Increased response time of queries up to 70% by reviewing and improving indexing, partitioning tables and fixing code issues.
• Created documentation addressing common technical issues reducing number of technical support enquires by 18%.
• Interacting with users & testing team for addressing issues
  Involved & supported EOD related Activities and analyzed queries that consumed Huge response time & tuned queries as well.
• Demonstrated leadership by overseeing code reviews, ensuring compliance with specifications, and taking full ownership of application responsibilities.

Starware : Application is web interface to instantiate, consult requests with a reference database BDR, to stock validated data with Analytical Structure workflow of FPV and GOV.

Roles & Responsibilities:

• Provided 50+ complex queries to support data analysis to senior management.
• Promoted as Lead for rewriting yearly , 7 days Reorg activity to automated job.
• Independently managed multiple enhancements and module rewrites to achieve optimal performance levels.
• Utilized Oracle SQL Developer testing suite Framework, to store testing suites based on modules, which decrease regression testing time by 25%.

TRIPS : Trips is an internal airlines ticketing system, which can be implemented of the other airlines with a minor changes and setups.

Roles & Responsibilities:

• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Trained and mentored junior developers teaching skills in Bulk Collect, Collection and Partitioning and working to improve overall team performance by 15%.
• Performed ad-hoc and Regression testing of system which resulted in uncovering 3 major issues.

PCS : PCS is an application which will sync all the departments information, so that business analysis can be done at a better level in lesser time, effort. Synchronization of data will be happens from multiple locations.

Roles & Responsibilities:

• Implemented de-fragmentation of tables, partitioning that had effective impact on space management and improved efficiency by 22%.
• Created records, tables and collections(nested tables and arrays) that reduced context switching and improved overall performance by 16%.
• Utilized Exception Handling extensively to handle errors that eased debugging and displaying error messages in application reducing debugging time by 15%.