Application developer

Director

• Nov 2019 - Present

Database administrator

• Jun 2009 - Feb 2019

Planned, coordinated and upgraded database from Oracle 11.1.0.7 to 11.2.0.3.•Worked on migration of database from Solaris to Linux platform with an Oracle upgrade from 11.2.0.3 to 11.2.0.4 using XTTS.•Worked on Data Pump Export/Import Utility for data migration.•Created/refreshed database clones using RMAN duplicate .•Worked on data migration using Transportable Tablespace.•Built standby database for production environment.•Planned, coordinated and worked on disaster recovery activity.•Monitoring and supporting application on their release activities.•Worked closely with application team in the designing of tables for new application. •Worked on Flashback recovery features like flashback database, flashback table, flashback transaction, flashback drop.•Analyzing ADDM/AWR reports.•Created and maintained materialized view with complex logic.•Worked extensively in SQL tuning on SQL Plan Management, SQL Profiles.•Worked on developing, modifying complex SQL queries for data retrieval for business decisions.•Developed PL/SQL scripts for data correction as an interim solution for the application bug fix and data migration.•Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.•On call support for production databases on rotation.•Worked closely with storage team for new/additional storage requirement.•Experience in working with Oracle Enterprise Manager for troubleshooting.•Mentor new DBA to the team on the standards, data move, SQL tuning etc. •Worked with Oracle Support on datatabase issues.•Involved in the designing of the tables for application utility. Show less

Application Developer

• Jan 2008 - May 2009

Next Gen is a .Net application that provides Allstate claims organization an operating model in improving consistency, speed, efficiency, and effectiveness of claim handling and processing for both customers and claim employees.Role:•Coordinated with Database Administrators in improving performance of application SQL.•Analyzed the requirements of frequently raised DSR (Data Service request) and designed a new utility to automate the applicaiton data changes.•Was involved in facilitating the interim solution process.•Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.•Worked in Production support team in debugging the production issues.•Involved in setting up new PT environment for testers.•Involved in unit testing the application code and database change for data integrity and application functionality.•Used TFS for version control of applicationsEnvironment: Oracle 10g, Oracle 11g, ASP.Net, VB.Net, TFS Show less

Software Engineer

• Oct 2006 - Dec 2007

Role: •Involved in writing documents such as Requirements specification, Deployment Document, Unit Integrations Test document. •Created UML diagram (Class Diagrams, Sequence Diagrams) to describe the relationship that exists among systems in compliance with Java/J2EE standard. •Developed and Implemented Recruitment module and HR module. •Used JavaMail to send automatic emails to employee when there were changes to the details of the employee. •Responsible for coding various Action classes to manage the flow of data between the Model and View layer. •Designed and developed UI using HTML, JSP and front end validation using JavaScript. •Developed Utility classes and Helper class as per need. •Wrote SQL, PL/SQL Queries and Stored Procedures. •Involved in building the ear file and deploying them to Staging and Production Servers •Used Win CVS as version control system for Source code. Environment: Java, J2EE1.4, Struts, JavaBeans, JavaMail, JavaScript, Tomcat, Oracle 9i,WindowsXP, Eclipse, CVS Show less

IT Faculty

• Apr 2001 - Feb 2002

EIIL provides training and education services in information technology. Role: •Worked as an IT Faculty teaching HTML, JavaScript, FrontPage, Flash, C, C++, Java. •Involved in planning syllabus, marketing, teaching workshops for school and college students. •Was the External examiner for NTTF (Nettur Technical Training Foundation EIIL provides training and education services in information technology. Role: •Worked as an IT Faculty teaching HTML, JavaScript, FrontPage, Flash, C, C++, Java. •Involved in planning syllabus, marketing, teaching workshops for school and college students. •Was the External examiner for NTTF (Nettur Technical Training Foundation

Sr.Technical Support

• Mar 2000 - Mar 2001

Caltiger.com was India’s first free Internet Service Provider (ISP). Role: •Debugged the problems encountered by the ISP customers. •Represented the Technical team major meetings. •Coordinated corporate customers of ISP like Indya.com Caltiger.com was India’s first free Internet Service Provider (ISP). Role: •Debugged the problems encountered by the ISP customers. •Represented the Technical team major meetings. •Coordinated corporate customers of ISP like Indya.com

IT Instructor

• Jun 1999 - Feb 2000

Role: •Taught BASIC for Grade 9, 10 and C++ for Grade 11, 12 as a part of their school syllabus. •Was the internal evaluator (Computer) for the ICSE (Indian Certificate of Secondary Education) and ISC (Indian School Certificate) board exams. Role: •Taught BASIC for Grade 9, 10 and C++ for Grade 11, 12 as a part of their school syllabus. •Was the internal evaluator (Computer) for the ICSE (Indian Certificate of Secondary Education) and ISC (Indian School Certificate) board exams.