Maheedhar Dhulipalla

• Coordinated with CEF (CENSUS Edited File) team to provide them with necessary stored procedures and packages and necessary insight into 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 changing needs of project and client requirements.
• Wrote Unix Shell Scripts to process files on daily basis like renaming files, extracting date from files, unzipping file and removing junk characters from file before loading them into base tables.
• Involved in continuous enhancements and fixing of production problems. Generate server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Loaded Oracle dump files using DBMS_DATAPUMP package.
• Created scripts to create new tables, views, queries for new enhancement in application using TOAD. Created indexes on tables for faster retrieval of data to enhance database performance.
• 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.
• Extensively involved in using hints to direct optimizer to choose 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. Created PL/SQL scripts to extract data from operational database into simple flat text files using UTL_FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned fact tables and materialized views to enhance performance. Extensively used bulk collection in PL/SQL objects for improving performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used PRAGMA Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for ease of debugging and displaying error messages in application.
• Collaborated with product management to design, build and test systems.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Developed code fixes and enhancements for inclusion in future code releases and patches.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTPP Package, and WEB.SHOW_DOCUMENT.
• Participated in change and code reviews to understand testing needs of change components. Worked on troubleshooting defects in timely manner.
• Involved in creating UNIX shell Scripting. De-fragmentation of tables, partitioning, compressing, and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle. Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing.
• Extracted data from XML file and loaded it into database. Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• 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 performance. Involved in ETL code using PL/SQL to meet requirements for extracting, transformation, cleansing, and loading of data from source to target data structures.
• Involved in 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 UNIX Shell scripts to automate repetitive database processes. Built databases and table structures following n-tier architecture methodology for web applications.
• Analyzed and designed relational databases using ER Studio and Erwin Data Model tool.
  

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL, and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions, and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, and SQL*Plus programs required to retrieve data using cursors and exception handling. Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications, and analyzed Dependencies.
• Creating indexes on tables to improve performance by eliminating full table scans and views for hiding actual tables and eliminating complexities of large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Created some Custom reports and Forms for end users to check details and errors.
• Worked closely with clients to establish problem specifications and system designs.
• Worked closely with clients to establish problem specifications and system designs.

• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical & Physical Database Layout Design.Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Used SQL*Loader as an ETL tool to load data into the staging tables.Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 10g.
• Provided user training and production support.Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
  

• Responsible for designing schema using Erwin data modeler and generate the DB scripts using the tool.
• Worked with Sql*Loader to import and export data from the flat files in and out of the legacy database.
• Participated in the development of new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests.
• Created various DML and DDL statements using Oracle Pl/SQL and SQL.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs. Assist Java development team for writing SQL Queries for the application.
  
• Designed and developed transactional and analytical data structures.

• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Developed conversion and system implementation plans.
• Tested functional compliance of company products.
• Inspected equipment, assessed functionality and optimized controls.
• Translated technical concepts and information into terms parties could easily comprehend.
• Conducted data modeling, performance and integration testing.

• Gather requirements and produce requirements clarification spreadsheet with all questions and assumptions.
• Write scripts for creating tables, synonyms, sequences, constraints, views, Materialized Views, indexes, triggers, stored procedures, functions and packages.
• Perform analysis and data mining for production impacting issues.
• Write PL/SQL scripts migration of spatial data based on county and state
• Create Control files to migrate data from flat files to Oracle database using SQL Loader.
• Write shell scripts for automated data loads and reports creation.
• Participate in Oracle database 11g migration.
• Work for SSO (Single sign on) Implementation for GEOCAT application.
• Use ForAll, Bulkcollect, ref cursors, and temporary tables to improve performance for bulk loading when required.
• Create Data model & Data Dictionary documents.
• Used EXPORT/IMPORT to do table level and schema level data migration
• Develop 'User Admin Module' for GEOCAT using oracle forms & reports.
• Prepare data model diagrams for GPP and GEOCAT applications using MS Visio.
• Perform Unit and Integration testing and deliver Unit/Integration test report. Provide necessary support to QA and UAT cycles.
• Migrated oracle forms & reports from 10g to 11g.
• Plan and coordinate migration of data to a newer version of a database management system.
• Perform Code Review and prepare code review documentation.
• assist Implementations staff, when needed, reviewing system release notes Maintain existing APEX applications and develop new as needed.
• perform Database Administration tasks on Oracle Express in-house database(s).
• Environment: Oracle 11g, Java, JSP, Oracle 11g Forms & Reports, PL/SQL, TOAD, UNIX,
• Oracle Apex, Windows XP and MS Visio.

• Participated in requirements analysis and detail design of application.
• Designs, test, implement and maintain ETL scripts for movement of data to data warehouse
• Loaded BW flat files data into staging Tables using Sql loader.
• Wrote PL/SQL procedures for Data populating in main tables in Hierarchical way.
• Load BW balancing data into staging Tables.
• Wrote Pl/Sql functions for balancing.
• Extracted data into flat files using UTL_FILE for Data warehouse/data mart.
• Wrote shell scripts for loading, balancing and extraction.
• Performance tuned Implementation using Explain plan.
• Performed Code Review and prepare code review documentation.
• Created Shell scripts for each process, creating of log files and sending status mails admin person.

· Environment: Oracle 10g, PL/SQL, TOAD, SQL, UNIX

• Wrote PL/SQL stored procedures and packages to retrieve specific information as per Business requirements.
• Designed and estimated solutions for new features and/or complex issues.
• Involved in creating tables, views, sequences, synonyms, indexes, index hints, and table partitions.
• Worked extensively in tuning SQL queries and database modules for optimum performance.
• Used SQL * Loader to load data from CSV to Oracle tables.
• Created UNIX shell scripts to automate job processes.
• Created triggers to carry out database maintenance tasks.
• Created DB objects for ETL processes like Tables, views, constraints, etc.