- Involved in analysis, database design, coding, and implementing database applications
- Understand business requirements, design and document technical design for the business requirements
- Involved in writing stored procedures, Creation/Dropping of tables, partitioning tables, indexes, sequences, synonyms for the business application development in TOAD.
- Involved in Designing packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations (For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc.) using SQL Server Integration Services (SSIS).
- Deploying SSIS packages from various sources like bids, Management Studio, file systems etc.
- Scheduling jobs using Tidal Scheduler in Development, QA and PROD servers
- Participating in all the phases of the project from Requirement analysis phase, development, QA support and production support.
- Involved in Unit testing and Integration System testing.
- Monitored performance and optimized scripts for maximum efficiency.
- Involved in analysis, database design, coding, and implementing
- Understand business requirements, design and document technical design for the business requirements
- Loaded data into multiple tables using SQL Loader
- Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers
- Tuned SQL queries to improve performance
- Used Microsoft Visio for Dataflow and Entity relationship diagram
- Developed procedures, functions for different forms
- Used different joins, sub-query and nested query in SQL query, for reports
- Extensively used PL/SQL in reports to perform calculation and to get desired output
- Developed single HTML page to serve as a centralized menu for the web application, and then broadcast URL
- Developed automated notification of Emails ,using Unix shell script ,to the users in case of failure in the process from time to time
- Implemented the technical and functional aspects of DEPOT project
- Interacted with end user for problems faced and providing necessary technical support by fixing the bugs
- Testing, Integration System test, Implementation (test with users) and documented the entire project
Environment: Oracle 9i, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, HTML, Java, Unix Shell scripts, Windows NT