Ganesh Chittalwar

        Application Enhancements and requirement analysis for new development tasks and coordinating with onsite team on the same.

        Analyzed the issue and resolving it using SQL code postgre SQL (sometimes) and updating the same to clients. 

        Worked on rotational shift basis and weekend support including on call handling.

        Created Database Objects like Tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

        Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.

        Wrote SQL Queries and modifying them according to the client requirement.

        Involved in client meetings whenever required (24/7 support).

        Worked in Support Environment as well as test environments for maintenance requests, bug fixes, enhancements, data changes, etc.

        Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement.

        Identifying the areas of improvement and enhance existing systems by analyzing existing business objectives.

Share knowledge through knowledge-sharing presentations 

 

Description: 

This system is to provide the best solutions to the organizations to manage all their data about customers, Dealers, Customization facility, Using this system Admin can manage their Dealer list, Customer List, Various packages, Advertisement, Banner and Slider, Area and category, contact us enquiry messages, Improve rank Management, Make Dynamic website and all.. It provides the fully customized Ecom system. 

Responsibilities: 

      Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances. 

      Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle. 

      Designed and developed Oracle forms & reports generating up to 60 reports. 

      Performed modifications on existing form as per change request and maintained it. 

      Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information. 

      Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module. 

      Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures. 

      Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIXShellscripts to automate repetitive database processes. 

      In this  good exposure in T- SQL in this project some way handle and using T-SQL functions  

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting. 

  This system is to provide the best solutions to the organizations to manage all their data about Distributors, Retailers and the Customers. In this system by using Distributor and order module the admin can manage their all tasks. Such as Add distributor, View Distributor List, New Order, View all Order, View Contacts us enquiry. 
 

Responsibilities:
      Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
      Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
      Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
      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.
Working knowledge  with T-SQL
      Involved in the continuous enhancements and fixing of production problems.       Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.       Developed PL/SQL triggers and master tables for automatic creation of primary keys.       Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.       Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.   

      Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
      Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. 
      Working know 

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP