Working on EIS Federal Government project. This project is designing database, screens and web pages for EIS for web portal management for the federal government. This web portal helps the users to maintain their BSS(Business Support Subsystem) of Telecom Domain. I am into designing database objects for Central Financial Management module.• Created Tables, Views, Constraints, Index and developed Complex database objects like PL/SQL stored procedures, functions, triggers and packages to achieve the business requirements.• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Developed shell scripts to load data from flat files to database tables using SQL loader and SQL control files.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. • Develop and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.

• Worked in an Agile Environment and participated in requirement gathering, analysis and design.• Worked on the bulk uploading of huge amounts of statistical data to the database.• Wrote loader scripts using SQL Loader/External tables to load large tables.• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL to effectively incorporate Business rules.• Optimized/Tuned SQL/PLSQL by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes to improve database response time and performance for several applications.

• Involved in gathering requirements from business users, analysis and system design.• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.• Involved in the continuous enhancements and fixing of production problems.• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to main tables.• Worked with DBA for getting trace files.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Created Job flow diagrams,Data flow diagrams, ER diagrams and also Developed and debugged SQL, PL/SQL scripts including Packages, Procedures and Functions & Triggers in ORACLE 11g environment to perform various tasks.• Writing complex SQL queries for validating the data against different kinds of reports, as well as creating joins and sub queries for queries involving multiple tables.• Creates and maintains SQL scripts for troubleshooting and testing.• Works with external vendors to determine requirements and delivery dates for outsourced development.• Assisted in designing, creation of documentation and conducted internal training sessions for users to operate the attendance management system application.