SUMMARY

• 8+ years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Banking, Telecommunication applications and Vehicle Systems.
• Solid experience working on Oracle 11g /10g/9i/8i/8.0/7.x, Developer 2000/6i (Oracle Forms 6i and Reports 6i), PL/SQL, UNIX and Discoverer.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM Web Sphere Data Stage 8.x/7.x.
• Experience in ANSI SQL with composite.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.
• Experience in using SQL TRACE and TKPROF tools for SQL tuning.
• Designed and extensively worked on Project Documentation. Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Having experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration Management (SSIS).
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Designed, structured and optimized using ANSI SQL, transact SQL queries, stored procedures using DDL and DML.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Experienced with SQL performance tuning and optimization using execution plans.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g/11g, SQL*Plus, SQL*Loader, Oracle Forms and Reports 10g/9i/6i, Oracle Framework, Oracle EBS, MS Office 2007, Open Office 3.3

Internet Technology: HTML 5.0, JavaScript, XML, PHP 5.0, CSS 3, DHTML, .NET

Scripting: Unix Shell Scripting, Java Script, Perl

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

ETL Tools: Informatica, DataStage 8, BOBJ Data Integrator 4.0

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Involved in Gen10 automation and reporting processes. Involved highly in the production support and development of Gen10 applications such as Remote Link.
• Preparing PL/SQL Packages, Procedures, Functions, Triggers and Views
• Performing Oracle SQL Performance Tuning on the Developed Code.
• Prepared and executed unit test cases
• Performing the code fixes for the developed code to meet the requirement
• Implemented multiple Change Requests in GC and prepared reports as and when required
• Worked in Performance and monitoring of Gen10 units.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Developed UNIX Korn shell scripts to process file feeds.
• Used IBM Cognos Report studio to build complex reports using SQL Queries and scheduled them on a daily basis.
• Used Tableau for reporting and preparing dashboards for business visualization.
• Actively Involved in Integration and Deployment in Production Environment.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using ERWin and identified key features for scalability of the application.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• UsedIBMWebsphereData Stage as an ETL tool to extract data from sources and flat files and loaded to target tables.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Used UNIX Crontab for Job scheduling and automation of SQL queries and reports.

Environment: Oracle Database 11g/10g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, Erwin Data Modeler r7/r8, Tableau Desktop 8.1, Tableau Server, IBM Cognos 10.1 Report Studio, Unix Shell Scripting, PL/SQL, Oracle EBS, IBM information Server Web Sphere Datastage 8.0.

Confidential, Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

• Developed Forms based on Master-Detail and Master-Detail-Detail format. Used multiple canvases to display the data effectively and used buttons for navigation.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose. Dealt with Data warehouse architectures and various concepts in data warehouses.
• Worked on Data Migrations, Extractions, Interfaces and customization ofOracleApplicationsEBS10.7, 11i and R12
• Developed Job sequencer with proper job dependencies, job control stages, triggers.
• Involved in writing backend Packages extensively in PL/SQL.
• Used descriptors for getting the input and output values in ANSI SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Used Oracle forms 9i to create applications to enter, access, change and delete data from Oracle databases
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Created stored procedures with ANSI SQL, DDL, and DML to remotely connect with database resources.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g/10g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, UNIX. Data Stage 8 Enterprise Edition, SQL Server -2005/2008, Erwin Data Modeler r7/r8, PL/SQL, Oracle EBS, IBM information Server Web Sphere Datastage 8.0, Windows NT/XP.

Confidential, Richmond, VA

Oracle PL/SQL Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the target systems after applying the required transformations using ETL tool Informatica Power Center.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Involved in Integration test, System test and Implementation.
• Proficiently developed test cases in Quality Center.
• Designed Query Only and Data Entry forms based on the user requirements and involved in meetings with End Users for the effective forms design.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Used debugger to test the mapping and fixed the bugs.
• Worked with pmcmd to interact with Informatica Server from command mode
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows 2003, UNIX, PUTTY, PVCS, WinSCP, Unix Shell Scripting, Quality Center

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL*Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Developed UNIX shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Also written UNIX shell scripts to automate the nightly data load from third party servers.

Environment: Oracle Database 10g, SQL, PL/SQL, Oracle Reports, Oracle Forms, PL/SQL Developer, SQL* Plus, Windows 2000, Java, Shell / PERL Scripting, UNIX, XML, FTP, SQL*Loader, Discoverer 4i.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database.
• Compiling and debugging packages with in-house code, and assisting the developers
• Wrote Scripts to perform HOT/COLD backups.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users using ERWin Data Modeler.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created Users and maintained security with Roles and Privileges.
• Setup connectivity to databases using NET 8 for clients and server side.
• Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance.
• Various stored procedures were written to achieve the back end functionality.
• Analyzed performance bottlenecks and provides appropriate solutions.
• Wrote various scripts in PERL and SHELL for database health and space checks.

Environment: C/C++, Oracle 8i, 9i, Reports2.5, Oracle Designer, Solaris 5, Windows 2000/NT