SUMMARY

• Seven years of experience in the design, development and implementation of business/ application software.
• Strong analytical and conceptual skills in database design and development on client/server applications using Oracle 11g/10g/9i/8.x/7.x, SQL, PL/SQL, Forms & Reports.
• Expert in the development of stored Procedures, Functions, Packages and Triggers.
• Strong PL/SQL programming skills and expertise with SQL tuning, performance tuning and Bulk binding techniques.
• Proficient in designing, developing, and implementing ETL solutions and providing quality data services.
• Proficient with Oracle data warehousing features such as materialized views, bitmap indexes, IOTs, external tables, etc.
• Worked on various platforms like UNIX/AIX/HP - UX/Sun Solaris 8.0, and Windows 07/Vista/XP/2003 Server/2000/NT/98.
• Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Proficiency with utilities such as Export, Import, SQL * Loader, OCI and Direct Path API’s and External Tables.
• Expertise in developing and customizing Forms and Reports using Oracle Forms9i/6i/4.5, Reports9i/6i/2.5 and developing concurrent programs using SQL, PL/SQL and Unix Shell Scripting.
• Hands on implementation experience in industries like banking, Finance, communications, health insurance, pension and retirement systems.
• Capable of rapidly learning new technologies and Excellent team player with strong analytical, organization and communication skills.

TECHNICAL SKILLS

Operating Systems: AIX, HP-UX, Sun Solaris 8.0,UNIX and Windows 07/Vista/XP/2003 Server/2000/NT/98.

Languages: SQL, PL/SQL, SQL/XML, C, C++, JAVA, VC++, .NET, C#, UNIX Shell Scripting (KORN, BOURN).

RDBMS: Oracle 11g/10g/9i/8.x/7.x, Sybase, SQL, PL/SQL, Forms & Reports, ApEx.

Applications: Oracle Application (Financials) 10.7/11i

Version control Tools: ClearCase,PVCS, MS Visual Source Safe.

GUI Development: Developer 6i/2000, Designer 2000, Visual Basic 6.0 /5.0, Crystal Enterprise 10 / Crystal Reports 8.0, Multimedia Tool Book

ETL Tools: Erwin 4.x, Informatica

Application Servers: Oracle 9iAS, Oracle Application Server, IIS, JBOSS, TOMCAT

Network: SQL*Net 2.1/2.3, Net 8 and Net Manager (oracle)

Tools: Quest Central 4.01, Fog light 4.0, TOAD, Designer 9i/2000, Discoverer 9iAS, Oracle JInitiator 1.3.1.x, Veritas. BackupExec8/7.1, VeritasNetBackup 4.5Work Experience:

PROFESSIONAL EXPERIENCE

Confidential, Augusta, ME

Sr. Oracle Developer

Responsibilities:

• Worked on complete System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Participated in meetings to gather functional and non-functional requirements with experts and end-users.
• Participated in system analysis, data modeling and database designing which included creating tables, bulk collect, views, dynamic SQL, indexes, synonyms, triggers, collections, procedures and packages.
• Installed the complete working environment of the Oracle Forms 11g and ApEx.
• Re-writing the PL/SQL code for forms, reports and various other applications due to the FACETS transition.
• Worked on new and modifying the existing Oracle Forms & Reports to incur changes as requested.
• Upgraded Forms from 6i to Forms 11g.
• Fine tuned the queries using EXPLAIN PLAN.
• Used TOAD to run sql queries.
• Generated various reports using Developer 11g Reports.
• Worked on Incidents daily in solving the issues arising in the PL/SQL Code, Reports and Forms 10g as support team.
• Execute scripts to handle batch processing.
• Hands on experience on Oracle database and SQL server database.
• Extensively worked on PL/SQL code in creating various versions for different databases and created new code for the new clients as per the requirement.
• Involved in Unit testing of the Reports, Forms and PL/SQL Stored procedures.

Environment: Oracle 10g, SQL, PL/SQL, SQL* Plus, SQL * Loader, TOAD, Oracle Forms & reports 11g, Informatica/ETL.

Confidential, Atlanta, GA

Sr. Oracle Developer.

Responsibilities:

• Worked on complete SDLC(system development life cycle) including system analysis, high level design, detailed design, coding and testing
• Developed several new PL/SQL packages for Database packages, Database procedures and triggers.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Deeply involved in tuning of queries using tools like Explain Plan, Trace and TK- Prof and concepts like Parallelism, partitioning, hints etc,.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Wrote UNIX Shell scripts to automate the daily and monthly extracts.
• Generated various reports using Developer 6i Reports.
• Involved in preparing test cases & unit testing.
• Extensively used UTL FILE to read and write files that are located on the server .
• Optimized the performance using PL/SQL table types and record types.
• Analyzed the performance of the SQL queries and created the scripts for indexes .
• Wrote SQL queries to developed test data for use during test execution.
• Involved in developing Shell scripts.

Environment: Oracle 10g, SQL, PL/SQL, SQL* Plus, SQL * Loader, TOAD, TKPROF, EXPLAIN PLAN, UNIX, Shell, HTML, Informatica/ETL.

Confidential, Pittsburgh, PA

Oracle Developer

Responsibilities:

• Worked with the team to design, develop, test and implement system.
• Creation of database objects like tables, procedures and packages using Oracle tools like PL/SQL, Toad.
• Written Stored Procedures using PL/SQL.
• As a team member of the ICDM (Integrated Consumer Data Mart), designed, integrated and built many datamarts like Branch Incentives, P & L, PCG (Private Client Group),CARRP (Corporate Advisors Reporting),WBDW (Warehouse Banking Data Mart), TMDM (Treasury Management Data Mart) ..etc from different online mainframe & other application sources like GENESIS, CORE, AML, ACH and DAP using Informatica and Oracle PL/SQL for all business analytical purposes.
• Involved in designing the datamodel (logical/physical) by creating new objects and by using existing objects of the datamart as per the business requirements using the ER-win.
• Involved in identifying the proper sources, extracting methods, existing relations between the sources and integrating them within the new design.
• Designed Type1, Type2 and Type3 Slowly Changing Dimension strategies for some dimensions of the Data Marts.
• Wrote the Functional Specification Document according to the Business requirements with the proposed logic.
• Prepared the Gathering tools with all the field level and table level transformation logics for metadata repository.
• Using Informatica Designer designed and developed Source Entities for Oracle, COBOL files and Target warehouse Entity for Oracle.
• Developed Informatica mappings to transform the data using different transformations like Source Qualifier, Normalizer, Sorter, Aggregator, Stored Procedure, Sequence Generator, Joiner, Filter, Expression, Lookup and Update Strategy.
• Extracted the data from different sources like COBOL Files, Flat files (delimited & fixed width) and Oracle.
• Used the SQL Loader for extracting the data from Flat Files into Oracle.
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance.

Environment: Oracle 9i/8i, PL/SQL, Toad, Sql*Loader, Informatica 7.1.3, Windows XP, UNIX KORN.

Confidential, Louisville, KY

Oracle Developer

Responsibilities:

• Conducted detailed and comprehensive business analysis by working with the client IT staff and end-users in order to identify system and operational requirements and improvements.
• AGILE SCRUM process is followed during developing and maintenance phase.
• Participated in daily scrum meetings to update progress.
• Acted as developer involved in designing and creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Extensively worked on database objects like Materialized Views.
• Created materialized aggregate views,single-table materialized aggregate views, andmaterialized join views.
• Created Ref-cursors, Packages to provide input for front end Java applications.
• Worked as on call support for these applications.
• Fine tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan.
• Actively involved in the design of ETL and mapping documents for the datamart.
• Created work flow diagrams using Microsoft Visio.
• Assisted in architecture and design of the datamodel in ERWIN by working with the architect.
• Worked extensively with Java Stored procs to handle business logic.
• Worked from FSD (Functional Specification Documents) to make changes to the mapping document based on a CR (change Request) or Defects for QA.
• Created Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams to author FSD (Functional Requirement Document).
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications.
• Coordinated with DBA in creating and managing tables, indexes, db links and privileges.
• Fine tuned the PL/SQL queries by creating complex views, using explain plan and use TKPROF if necessary.
• Created the integrity constraints and database triggers for complex data validations.
• Expert in handling various version control softwares like IBM Rational Clear Case and Microsoft Source Safe to track the progress of the project depending upon the source.
• Developed forms in account receivables using Oracle Forms Developer 6i.
• Worked with the team in SQR programming to embed SQL code.
• Performed code walkthrough ensuring the coding standards and code commenting.
• Performed Branching and Forking on existing codes as per the Users requirement.(ETL specified).
• Documentation of all modules for user level and system level maintenance.
• Developed UNIX Shell scripts to automate repetitive database processes by using Crontab.
• In the process worked extensively on VI Editor.
• Assist in creating Metadata for all the user tables for the application.
• Developed mapping, workflows using Informatica Power Center 7.1 and also in Power Center 6.2.
• Executed Informatica Workflows, to load data from Legacy systems ex. AS/400, Oracle, Flat Files and Access databases, onto the ETL target Flat Files.
• Involved in Test Director (to trace defects), fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Worked extensively on the POC for Netezza.
• Hands on experience on the working of the hardware.
• Primary point of contact for migration of data from Oracle to Netezza.
• Actively involved in modelling the Datamart of Netezza.
• Extensive experience in converting scripts from other Databases to Oracle.
• Involved in the upgrade of Netezza to NPS 4.6.
• Integration of Netezza with OBIEE for the use of business strategy.
• Hands on experience on using NZLOAD to load data into Netezza.

Environment: Oracle 9i/10g, SQL, SQL*PLUS, SQL*Loader, TOAD, SQL Developer, PL/SQL, Oracle Reports6i, UNIX, BI Publisher.

Confidential, Atlanta, GA

Oracle Developer

Responsibilities:

• Installation and administration of Oracle (8i/805/7.x) database and Tools on UNIX (Solaris/HP/AIX/SCO) and Windows NT Server.
• Maintaining all products script in ERD form using Erwin Tool.
• Re-engineering of existing product for enhancement from Database point of view.
• Write Pseudo code, database trigger, stored procedure and packages to implement business logic and command procedure for product.
• Maintain database for Devolvement and Quality Department with the Versions and Releases integrity.
• Diagnosing and troubleshooting of Database related problems.
• Reveal the new features of oracle to development and management team.
• Replicate Customer DB environment and solve performance related Problems.
• Assign task, provide training and explain the business requirements to colleagues.
• Implement backup strategy for different projects as per requirements.
• Write Shell Script to create DB object for Products, Automate backup and testing scripts.
• Implement small projects for in-house requirement like personal and Bug management system.
• Generate Data for Unit test, Load testing Using script, Dynamic SQL and TestByte Tool
• Prepare auditing policy & Implement Security domain for Database Users.
• Perform Backup checking using recovery options on separate Setup of Databases.
• Plan & generate requirement for RDBMS Servers, space requirements, and Backup storage.
• Study and Recommend Database related Software for better project execution.

Environment: Oracle 8i, Designer/2000, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, SQL*Plus Reports, SQL*Loader, Unix, Windows NT 4.0/95

Confidential

Software Engineer

Responsibilities:

• Developed PL/SQL code for various levels of front-end validations. Involved in analyzing and developing application level security system for it. Responsible for design and development of the Menu Module using Developer 2000 and integration of the application system.
• Responsible for generating various levels of reports using Oracle Reports 3.0. Involved in unit test, integration test and test plan.

Environment: Oracle 8.0/8i, Developer 2000 (Forms 4.5 & Reports 3.0), Oracle Designer 2000, Visual Basic 6.0, UNIX, Windows NT.