Involved in developing complex customization and modification of backend programs using TOAD / SQL Developer based on project requirement.
Developed appropriate queries that can help to retrieve data from the database, look into the security issues of the data and develop structures, procedures and triggers.
Maintain and modify the code for software applications, constructs technical specifications from a business functional model, and test and write technical documentation.
Developed Technical & Functional specification documents based on Business Requirement Documents.
Database and SQL optimization, build-materialized views to present the data in different forms and implement database partitioning.
Collect data, analyze the collected information, designs algorithms, and draws flowcharts and then implements code for the logic developed through algorithms and flowcharts.
Analyzing and Simplifying the Application Architecture.
Implementation Internal and External view of sales data in Yearly, Quarterly, Monthly and Weekly direct and Indirect Shipment.
Coordinate with the system/business analyst teams for requirement specific concerns and follow ups.
Expertise in relational databases and Oracle.
Created complex reports using Crystal reports and integrated them in the existing applications.
Administration of the Crystal Report Server and monitoring and scheduling the reports and report outputs.
Writing complex queries, stored procedures, triggers