About Me

9+ Years of experience in the Information Technology field with extensive experience in Database development, Shell & Perl Scripting, Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support. Experienced as...ering and analysis, Unit Testing and monitoring, documentation and technical support. Experienced as Oracle developer in large production environments with database implementation on UNIX and Windows. Experienced as MySQL developer in large production Environment Development work experience in the software industry with MySQL(4.x,5,x) and SQL Server 2000/2005. Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration. Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory. Extensive knowledge of Oracle11g/10g/9i/8i/, SQL, PL/SQL (procedures, packages, functions, database triggers) Experience in working with Oracle Forms and Oracle Reports. Experienced in Developing PL/SQL – Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic. Experience in loading data, troubleshooting, Debugging mappings, performance tuning of procedures and SQL queries. Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes. Experienced in writing SQL queries creating different kinds of reports from large scale database. Extensively involved in troubleshooting, debugging and fixing the codes/scripts. Experienced in migration of database from SQL Server 2000 to Oracle 10g. Worked with various SQL Editors such as TOAD, SQL Plus, and PL/SQL Developer. Exposure to RDBMS tools like PowerBuilder Extensive Knowledge and Experience in ETL tools like SQL Loader to transfer the data between different databases. Extensive Knowledge and Experience in Data Analysis and managing data warehouse and data marts Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts. Skills in developing code to interact with databases with knowledge of Front End design in both windows and web application Experienced in providing technical production support. Extensive knowledge on Autosys (Job Scheduling) and JAWS (Reporting tool for Autosys) Extensive knowledge on DB Maestro Database automation tool. Exposure to JAVA, C, C++, Pro*C , J2EE / XML, Web Services and WebLogic tool Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents. Knowledge of the entire development process including specification, documentation, quality assurance and implementation (SDLC) Extensive knowledge and experience in AGILE methodology of Software development Strong analytical, problem solving and communication skills with strong focus towards goals and work ethics