SUMMARY

• Over 7 years’ experience in IT industry.
• Extensive experience working with Oracle 11g/10g/9i, Toad, SQL*plus, SQL * developer, SQL*loader, MS SQL Server and Business Intelligence products.
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.
• Experienced in writing SQL statements, PL/SQL code for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.
• Experience in SQL*loader, UTL FILE and UNIX Shell scripting.
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experienced in writing SQL queries and SQL tuning, understanding requirements, writing functional specs, writing test specs and plans.
• Strong development and support knowledge on Oracle, SQL, PL/SQL,T - SQL queries programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views.
• Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.
• Expert in Developing SSIS (SQL Server Integration Services) Packages Extracting, Transforming and Loading (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS (SQL Server Reporting Services) 2005/2008/2008 R2.
• Comprehensive Experience in various types of oracle technology based projects in multi-tier environment for sectors like Banking, Insurance and Manufacturing.
• Excellent writing, presentation, documentation and communication skills for the management, development.
• Team player with proven ability to introduce change and move an organization towards and innovative Technology.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, MS SQL Server

Languages: SQL, PL/SQL, T-SQL, Java, HTML,C#,.NET

Operating Systems: Windows, Linux, Unix, Shell

DB Dev. Tools: TOAD, SQL Developer, SQL*Plus, SQL Loader, Warehouse Builder

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle PL/SQL Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Responsible for analysis, design, development, and testing of the application.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Loading of data from Moody’s using SQL* Loader.
• Creating and working with GTT (Global Temporary Table).
• Created database objects liketables, views, synonyms, indexesandsequences.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Created and modified several views on tables which will be populating the Warehouse system. Also involved in creation on aggregate materialized views on Data Warehousing.
• Participated in Functional Testing and Unit Testing.
• Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.
• Extensively worked on PL/SQL Error/Exception handling.
• Performed Oracle Performance tuning using SQL Trace and Explain Plan.

Environment: UNIX, Oracle 11g, Windows NT, PL/SQL, SQL*PLUS, SQL, SQL*Loader, Toad, Java J2EE.

Confidential, NJ

Oracle Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Involved in maintaining and updating the procedure for ETL process.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, and synonyms to meet the business requirements.
• Executed upload and load procedures to check the data feed is correctly getting loaded in to the tables.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Modification of the existing forms and reports and registering those in Application.
• Direct interaction with users and helped in the development of functional specifications.
• Written technical specifications for all the procedures developed in the module. Maintained log files during analysis and subsequently report any performance defects.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 11g, UNIX, Erwin, SQL* Plus, and Oracle Forms.

Confidential, Plano, TX

Senior OraclePL/SQL Developer

Responsibilities:

• Developed various PL/SQL objects likeprocedures, functions, packages, Cursors, pipeline functionsandtriggersin accordance with the business needs.
• Created database objects liketables, views, synonyms, indexes,views, materialized views andsequences.
• Involved in interacting with theend-user (client)to gather business requirements and modeling thebusiness requirements.
• Define and represent entities, functions and flows between the entities.
• Participated in analyzing the requirements for thelogical and physicaldesign of the database.
• Knowledge ofNormalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Loading data into test warehouse for the business analyst to perform QA testing using SQL Loader utility andData pumputility.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Performed exception handling for data that did not conform to the required format.
• Implemented purging techniques on the data which is not required by the clients.
• Responsible for making the merged data in turn available to other clients.
• ImplementedPL/SQL scriptsin accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Scheduled html reports usingUTL SMTP,UTL MAILand DBMS SCHEDULER.
• Optimized SQL statements and PL/SQL blocks byusingOracle Hints, Explain plans, profiling,collecting statisticsandTrace sessionsfor Cost based Optimization.

Environment:, Oracle 11gR2, PL/SQL,Oracle FMW, Autosys, .Net, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, HP Quality Center, SQL *Loader, Import Export.

Confidential, Herndon, VA

PL/SQL Developer

Responsibilities:

• Enhance programs to obtain multiple borrowers personal info and multiple properties info, liability info, employment info, debt info.
• Develop complex Oraclestored proceduresandpackagesto calculate borrower's debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Createdinterface documentsas part of the project.
• Managedchange request(CR) process using the rational clear quest tool.
• Provide loan status tracking report for users to keep track of loan process stage.
• DevelopSQL Queriesto fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Developed complex customized views for the clients based on their requirements.
• Responsible for making decisions on coding standards and documentation.
• Involved in developing ETL Process to Load the Data from different sources.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in Unit Testing Stored Procedures and Functions.
• Involved in developingUNIX shell scriptsfor Loading Database Tables.
• Loading data from flat files into database tables usingSQL* Loaderandexternal tables.
• Managed projectSharePoint.
• Preparing documentation for design, install andUnit testing.
• Experience in developing various kinds oftriggersand used sequences to generate values forsurrogate keysin data warehouse tables.
• Extensively used CVS for Implementing the code Changes.
• CreatedMaterialized Viewsand implemented partitioning for performance reasons.
• ResolvingProduction severity Issuesin time and meeting the SLA.
• Fine-tuned the queries and procedures using Oracle Hints, Explain plans, profiling and Trace sessions.
• Optimized critical queries to eliminate Full Table scans to reduce Disk I/O and Sorts.
• SupportedGLclose process.

Environment: Oracle 11g/10g, PL/SQL, Java, MS Access, Visio, UNIX Shell scripts, Crystal Reports, Java, Clear case, Clear Quest, SVN, Toad, Quality Center, SQL *Loader, Import Export. SharePoint

Confidential, Ann Arbor, MI

Oracle Pl/SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Interact with Business to understand business requirements and define project scope.
• Prepare project plan, estimate efforts
• Onsite/Offshore coordination.
• Involved in the analysis of Physical Data model for ETL mapping and process flow diagrams to develop Data mart design.
• Developed programs using Oracle PL/SQL procedures, packages and SQL queries.
• Involved in code walkthrough, system testing and regression testing.
• Tuning of SQL queries.
• Weekly status reporting to different levels of management on project status.
• Conducting audits and reviews to ensure compliance with specific quality guidelines.
• Integrate all components, test and deploy in production.
• Provide post production support.
• Solved various T-SQL issues using Query Analyzer.
• Develop and validate SAS analysis data sets.
• Write, customize, QA, and run SPSS, SAS and STATA programs according to specifications.

Environment: Oracle 10g/9i, Oracle PL/SQL, Toad, T-SQL, DTS, STATA, SSPS, SAS.