SUMMARY

• Over 5+ years of experience in IT industry, involved in analysis, design, development, testing and implementation of applications & maintenance of databases in Client/Server and Internet/Intranet environments.
• Extensive working experience in translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures, and Views.
• Extensive PL/SQL coding abilities with enhanced debugging, error handling and using advanced programming techniques like dynamic SQL, Analytical Functions, hierarchical queries, Bulk,
• Expert in RDBMS including Conceptual/logical & physical Database Design and Modeling using MS Visio, Oracle11g/10g/9i, PostgreSQL, PL/SQL, SQL
• Good experience with SQL Loader, Import/Export of data files, Materialized views in various types of ETL projects.
• Used SSIS to create Dynamic ETL Packagesto validate, extract, transform and load data from online transaction Processing (OLTP)databases to data warehouse databases and involved in Data cleansing in the data transfer.
• Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Expertise in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Experienced working with clients on - site, analyzing software requirements and developing solutions and procedures.
• Experience in Pro* c/C++ precompiler where the SQL statement that embeded in C/C++ code convert into standard C/C++ code .
• Conversant with the complete Software Development Life Cycle (SDLC) of applications and meticulously confirm to quality procedures and standards.
• Possess a good knowledge of gathering/ analyzing business requirements.
• Excellent Client interaction skills and proven experience in working independently as well as in a team.
• Securing the server by giving database access permissions to users and client Applications, things that concern the actual server software.
• Involved in the issue resolution and Root Cause Analysis.
• Provided instant solutions to issues which were reported in the production instance.
• Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS SQL.
• Experience in supporting the production system, handling day-to-day issues and end user training.
• Excellent team player and self-motivated.
• Possess excellent oral & written communication and interpersonal skills.
• Quick learner with the discerning ability to grasp new Technologies.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i, PostgreSQL, Microsoft SQL Server 2005/2008

Operating Systems: UNIX (MAC OS X, AIX), Windows 98/NT/2000/XP

Data Base Tools: TOAD, SQL Developer, and SQL*Loader, SQL*Plus, PgAdmin III, Micro Soft Visio, Slony, Jasper Reports, SQL server management studio, SSIS, SSRS, ERWIN

Languages: SQL, PL/SQL, Autosys, HTML, Pro* C.

Microsoft Tools: MS Office (Word, Excel, Power Point) and Adobe Acrobat

PROFESSIONAL EXPERIENCE

Confidential - Denver, Colorado

Oracle PL-SQL Developer/Analyst

Responsibilities:

• Involved in Requirement gathering sessions for the new database and application design and development.
• Authored various documents including BRD(Business Requirements), Technical Specification and Conversion/Interface Mapping Documents and Test Script Scenarios.
• Involved in system integration testing (SIT), ORT and BRT of the commercial IMS migration project
• Supported Commercial IMS migration fallout errors in different batch types of DRY RUN, STAGING and EXECUTION.
• Responsible for the all the interfaces issues like connectivity, integration, applications health check, proxy, firewall, encryption, archiving, migration and environmental issues.
• Involved in software program design, development, logical data modeling and physical data modeling using ERWIN and Visio.
• Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, Triggers, object types, collections, Dynamic PL/SQL and packages.
• Involved in performance tuning of SQL queries to decrease the execution time, for that Modified cursors to use hints.
• Created joiner expression transformations, Router transformations, lookup transformations, union transformations, Sorter transformations, Aggregator transformations and Rank transformations using Power center Designer.
• Using packages, functions,Pro*Cdeveloped a massive custom batch program for transactional data..
• Involved in data mapping and populating database tables using SQL * Loader
• Developed SOAP based, RESTFUL Web services and JDBC programs using JAVA.
• Worked on the autonomous transactions in PL/SQL to log messages from subprograms to log tables.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Created custom templates in Oracle Reports Builder, for displaying the reports in
• Extensive expertise at developing and scheduling ad-hoc and canned Analytics Reports using OBIEE/BI Answers, Dashboards.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Created newSSISpackage to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio(BIDS)and Visual studio 2008.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Responsible for writing the technical documents and maintaining the documentation.
• Involved in database Performance Tuning and monitoring.
• Handled Production issues with high pace and efficiency.
• Optimized existing queries for better performance and less impact on database and used Materialized views in places where the data does not change very frequently.
• Wrote Queries to retrieve data in XML format from the tables using DBMS XML.
• Worked on the Analytical functions.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, SQL *Developer, Reports Builder 10g, OBIEE 10g, UNIX, Windows 7, Microsoft SSIS, MS SQL Server, Teradata, HP PPM, HP Quality Center, CVS ETL, ERWIN, MS Office.

Confidential, Atlanta, GA

Oracle PL/SQL developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
• Created different schemas and maintained schema objects.
• Creation of new packages and modification of existing codes to resolve application bugs.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Used Pro*c in some cases to embed the SQL statement within C programming code to execute the statements.
• Used advanced queuing concept to deque the exceptions raised during the cron job execution which will be notified by mail using UTL MAIL package and enque it into main table for error reprocessing.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, Autotraceand DBMS APPLICATION INFO.
• Had technical knowledge to maintain ETL Unix Pro*C/C++ system applications and Oracle PL/SQL and SQL querying
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

Environment: Oracle 11g/10g, SQL*Loader, SQL, PL/SQL, SQL*developer, UNIX, Windows XP, SQL Plus.

Confidential, Miami, FL

Oracle PL/SQL developer

Responsibilities:

• Involved in the analysis of gathered information from end users and there by taking appropriate decisions to fulfill their business needs.
• Developed a Customer Interface program to load the new customers and to update the existing customer information from Siebel-on-demand, a Bolt-on application used to create quotes.
• Actively involved in ongoing day to day Production Support activities / issues and providing problem resolving solutions to Tickets
• Experience in all aspects of the SDLC: Requirements gathering, Designing, Development, Testing and Deployment.
• Developed new report to display Item Attribute Values for given five Organizations in Inventory
• Extensively performed DML, DDL, DCL, and Transactional Control Statements.
• Customized Depot repair estimate report to XML
• Developed and Customized reports & forms in Manufacturing Modules
• Responsible for testing fixes and there by moving them from one instance to another
• Worked with the UNIX scripting.
• Responsible for enhancements/developments in oracle quoting.
• Responsible for creating new Responsibilities and modify existing form functions as per user requirements.
• Wrote PL/SQL subprograms, packages, procedures and functions, and DB triggers for data retrieval, deletion, and creation.
• Responsible for Creating Service Requests with Oracle for technical issues and there by working with Oracle team to get them resolved.
• Responsible for attending helpdesk calls and raising tickets on behalf of users and routing them to appropriate Function Consultants.
• Developing Shell scripts to invoke Interfaces to convert the date.
• Extensively worked on XML Publisher.

Environment: Oracle 10g/8i, TOAD, SQL*PLUS, PL/SQL Developer.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed Outbound interfaces with UTL package
• Performed Bulk operations like Bulk Collect, Bulk Insert, FOR ALL and Collections.
• Involved in the creation of dynamic SQL statements using EXECUTE IMMEDIATE
• Performed the data migration using SQL* loader.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Dealt with the Creation of Web services
• Used Autonomous transaction to avoid mutating errors.
• Coordinating with QA team for bug fixes.
• Efficiently dealt with the Exception handlers.
• Organized training session to the end users on the functionality and operability of the application.
• Identifying and improvement of system’s performance by analyzing /tuning of all the programs and other related issues.

Environment: Oracle 10g, TOAD, SQL*PLUS, SQL Developer, PL/SQL Developer, UNIX.