SUMMARY

• Eight Years’ experience in Oracle 11g/10g/9i/8i/7.x Database Development and Administration on different operating systems (AIX, HP - UNIX, Sun Solaris, Linux and Windows Server) in 24x7 Production and Development Environments.
• Strong analytical and conceptual skills in database design and development on client/server applications using 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.
• 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.
• Extensively used MS Word, Excel, Share point, Power point, and Visio to produce and represent documentation.
• Hands-on experience in full system development life cycle (SDLC): Assessing user’s needs analysis, planning, scheduling, systems design, programming, quality assurance, documentation, project implementation, and customer support.
• Good Understanding of Java, ASP, JSP, HTML, JDeveloper.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g/9i database and strong knowledge of Oracle ADF Faces, Oracle Database Concepts, Detailed Depth knowledge in Oracle architecture, Data Dictionary and DBMS packages.
• Experience in the area of analysis, design, development, testing, implementation and Production Support of complex Servers with applications using Oracle Applications (Financials, Distributions, Planning and Manufacturing).
• 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 Forms 10g/9i/6i/4.5, Reports10g/9i/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, Oil and gas, Pension and Retirement systems.
• Having good experience in interacting and working collaboratively with cross functional teams
• Capable of rapidly learning new technologies and excellent team player with strong Analytical, Organization and Communication skills.

TECHNICAL SKILLS

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

Languages: SQL, PL/SQL, SQL/XML, T-SQL, C, C++, JAVA, Visual Basic, .NET, C#, HTML, UNIX Shell Scripting (KORN, BOURN).

RDBMS: Oracle 11g/10g/9i/8i/7.x, SQL Server, Sybase, MS Access. Applications Oracle Application (Financials) 10.7/11i, Apex 4.1/4.2.

Version control Tools: Clear Case, 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, Netezza.

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

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

Tools: PL/SQL Developer, SQL Loader, SQL Developer, MS Office, Enterprise DB Migration Studio, PGAdmin3, Squirrel, JIRA, Apex 4.1/4.2, TOAD, Management Studio 2008, Eclipse Java EE, Oracle Forms and Reports Builder.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Tech Lead (Oracle-Pl/Sql)

Responsibilities:

• Developed an application BOB (Business optimization browser) in Home Mortgage to track the productivity of over 30,000 employees of the organization.
• Was involved in defect fixing, change request and release maintenance of the application.
• Strong development experience in creating Stored Procedures, PL/SQL Packages, Triggers, Views, Materialized Views and Functions. Strong Knowledge in Oracle cursor management and exception handling.
• Tuned SQL queries for optimum performance, was also responsible for performance Tuning Database.
• Extensive worked on Oracle Apex, created different Pages, Regions, Processes, Items, and validations.
• Worked on List of values (LOV), breadcrumbs, Tabs and Lists.
• Understanding and Worked in the agile environment where actively participated in team meeting, retrospectives, and structuring of the database.
• Was involved in scrum and day-to-day status meetings.
• Created upload routine to upload data from excel to our database.
• Used JIRA tool for bug tracking and issue tracking.
• Handling Jira tickets raised by the users/managers.
• Planned and performed daily, weekly and monthly backups; tested and implemented restore procedures.
• Worked on Quality Center to create and update the test cases.
• Created users, roles and granted privileges according to the business requirements.
• Performed capacity planning required creating and maintaining database environments.
• Participated in project planning, documentation, testing, and validation procedures.
• Was involved in code review and involved in distribution of the task, understood deadlines, worked on day-to-day progress of the project.

Environment: Oracle 11g/10g, Explain Plan, JIRA, SQL Developer, Apex, HTML, Agile, Scrum & Scrum, TOAD, XML.

Confidential, Atlanta, GA.

Sr. Oracle Developer

Responsibilities:

• Wrote scripts for Migrating Tables, Packages, Procedures, Functions, and Triggers from Oracle to Postgres, which included Application Migration.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Used bitmap Indexes, materialized views and partition tables to optimize the queries.
• Worked closely with Production support team 24 by 7 format to analyze and fix the production issues including bug fixing, data fixing, etc.
• Data Migration from PL/SQL to Postgres for migrating Tables, Triggers, Packages, Functions and Procedures, which also include application migration.
• Developing reports as per business user requests.
• Developed, modified, and optimized complex queries to data retrieval and modification.
• Defining, supporting and conducting data cleansing activities.
• Performing SQL tuning, analyzing and optimization.
• Creating and running the shell scripts to run the Processes at time schedule according to business rules and also created roles, users and database objects.
• Resolving the Jira issues.
• Performed Oracle database upgrade from 10 g to 11g.
• Troubleshoot, Fixed, Implemented bug fixes and enhancements with tight deadlines.
• Data Migration from PL\SQL to Postgres, used Perl script for transforming.
• Working on Netezza, DB Migration Studio, Eclipse, PL/SQL Developer, and PG Admin3.

Environment: Oracle database 11g, 10g, PL\SQL Developer, Pgadmin3, Netezza, Squirrel SQL Client 3.2.1, Enterprise DB Migration studio 8.4, Eclipse Java EE IDE, MS Office, Unix.

Confidential, Houston, TX.

Sr. Oracle Developer

Responsibilities:

• Worked on Packages that enable the grouping of related PL/SQL objects, such as Procedures, Variables, Cursors, Functions, Constants, and Type Declarations.
• Involved in creation and updates of several SQL packages and Procedures.
• Worked on Triggers to provide a way of executing PL/SQL code on the occurrence of specific database events.
• Maintained an audit log by setting triggers to fire.
• Involved in designing Data flow diagrams, ERD’s, Use case diagrams, Process flow diagrams.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Configured Physical standby for high availability and for disaster recovery.
• Created forms using Oracle forms 10g and 11g.
• Developed the forms, Reports to Oracle forms and Reports 11g from the legacy system Oracle Forms and Reports 6i.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Participation in weekly design reviews and walkthroughs with project manager and development teams.
• Worked on Form triggers and Built-in packages.

Environment: Stored procedures, Functions, Triggers, Packages, Toad, SQL loader, SQL Developer, SQL*PLUS Forms Builder 10g,11g, Reports Builder 10g,11g, Oracle database 6i,9i,10g,11g, SQL Navigator, MS Office 2010.

Confidential, Prairie, MN

Sr. Oracle Developer

Responsibilities:

• Migration of oracle forms from 6i to forms 10g.
• Identified, designed and developed Oracle PL/SQL stored packages, Procedures, functions, database triggers and arrays.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Used dynamic SQL to perform DDL Operations.
• Documentation on the Oracle forms reports migration from 6i to 10 g.
• Documented business rules, functional and technical design, test cases and user guides.
• Migrated Oracle database from 8i to 10g and applied database.
• Created Forms, Pop-up Menus and maintaining Master Detail relation-ship.
• Involved in troubleshooting problems in the migration process.
• Involved in Database Administration activities like creating users, granting privileges, assigning roles to users.
• Significant experience in defect management & database tools like ClearQuest, & TOAD.
• Tested all forms, PL/SQL code for logic correction.

Environment: Oracle database 11g, 10g, PL\SQL Developer, TOAD, Oracle Developer suite 10g, Forms builder, and Reports builder.

Confidential, Los Angeles, CA.

Sr. Oracle Developer

Responsibilities:

• Developed Stored Procedures, Triggers. Developed various applications, using Oracle built-in packages such as DBMS SQL, UTL FILE.
• Written PL/SQL Packages, Load Report and Data fix screens using Oracle Designer, Oracle Forms, PL/SQL and Oracle Reports.
• Integrating, implementing, Architecting and developing interfaces for SCM solutions fordifferentclients.
• Developing various business intelligence solutions using Hyperion Performance Suite.
• Troubleshooting problems in the system for various clients as part of production support.
• Customized the Packages as well as stored procedures to enhance the system.
• Developed inbound and outbound transactional interfaces to G.O.L.D. system as per client requirement to communicate legacy as part of different projects like POS download, retail pricing.
• Used BI Publisher to deliver reports and also for documentation.
• Worked extensively on BI Publishers Formatting Engine for combining data SQL Query, XML.
• Worked on Interface mapping to convert the master data into G.O.L.D. system like customer master, Item master, vendors.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader.
• Developed stored procedures in Sql server 05 using T sql and modified the SSIS packages as per the functional requirement to get the data from G.O.L.D. central database in to Sql server to handle different interfaces for client.
• Coded packages for Updating, Insertion and for Audit and Trial.
• Reconciliation of reports to match the numbers for different clients at different regions.
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables.
• Application tuning for slow running queries using Explain plan (Auto trace).
• Worked on Forms and Reports Using Forms 9i/6i and Reports 9i/6i
• Creating new screens by using ADF Faces.
• Extensive experience in design, development using Weblogic application server, good experience in database programming using Oracle 8i/10g, server.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. Used the tools with EXPLAIN PLAN.
• Did oracle data loading into oracle database from flat files using SQL Loader.
• Involved in Data stage phase of data warehousing in accordance with later we will plan to migrate data warehouse for more analytics.
• Set the Cron tab jobs to achieve automation task on UNIX.
• Wrote shell scripts to invoke pro *c and other interfaces to populate the data in GOLD central database from interface tables on UNIX -AIX.
• Designed a warehouse to generate different kind of reports for different clients.
• Worked closely with Java guys to validate the XML schema and Xml-Java Api.

Environment: Oracle database 11g, 10g, 9i, PL/SQL, Stored procedures, Oracle BI Publisher functions, triggers and Packages. UTL FILE, Unix Aix, PL/SQL Developer, ASP.NET, ADF Faces, Java, Sql server 2005, OLAP, Data stage, UNIX, Oracle (Forms 9i/6i, Reports 6i/9i).

Confidential, Dallas, TX

Sr. Oracle Developer

Responsibilities:

• Involved in System study, Analysis, Design, Data Model, Development, Implementation and maintenance of ECS & EBP Tools used in that product development are Oracle Designer, Forms, Reports and PL/SQL.
• Participated in design and analysis of the database design and architecture using UML.
• Analyzed, designed, developed and maintained Insurance Card Printing Subsystem using Oracle Designer, Forms, Report, and PL/SQL, later merged this card printing system into ECS
• Written Database Triggers, Stored Procedures using PL/SQL.
• Involved in developing Extraction-Transformation-Loading process, using SQL*Loader, PL/SQL package UTL FILE.
• Developed Forms and Reports Using Forms 6i and Reports 6i
• Creating Data Structures. I.e. Tables & views and applying the referential integrity.
• Worked with Partioned tables and materialized views.
• Designing Data conversion/Interface with the use of SQL*Loader, and Open Interface, and convert data.
• Worked on Oracle Forms and Oracle ADF Faces for the end users for user interface and incorporating existing Oracle forms form.
• Mainly used Oracle ADF Faces to simplify java development and minimizing to write code that implement the well know design patterns.
• Created oracle Forms and deployed on the web using Oracle Forms server.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Developed the training documents on how to use the ECS system.
• Written UNIX shell scripts to automate the data load process
• Worked with java application client through web server.
• Involved in Java based portal enhancement using JDK.

Environment: Oracle9i/ 8i, Designer / 2000, Developer/2000 (Forms 9i/6i, Reports 6i/9i), PL/SQL, SQL*Plus Reports, Citrix, XML, TOAD, Oracle ADF, JDK, SQL*Loader, UNIX, Windows NT/2000/ 4.0,XP/2000/ 98/95 TRACE, EXPLAIN PLAN, JDK.

Confidential

Oracle Developer

Responsibilities:

• Developed application and database Triggers, Functions, Procedures, and Packages in PL/SQL, Orecle8i as back-end.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created various Database triggers using PL/SQL.
• Creation of system objects such as queues, queue managers, channels, events etc. using MQ Administration.
• MQ Programming using Embedded SQL for the transformation of messages and routing into destination.
• Generated a number of reports for management to review for system functionality as against the old legacy system.
• Worked with various functional experts to implement their functional knowledge into working Procedures
• Worked on optimizing existing Procedures and Functions using PL/SQL.
• Created various Database Triggers using PL/SQL.
• Involved in the preparation of user Requirements and functional specification of the systems
• Used the graphical features (image items, icon, charts etc.) by using the built in packages
• Involved generation of reconciliation reports. Reconciliation was done between a front office and a back office system(s). All the files were then put in a special directory, which was linked to a front-end application, so that the reports (files) could be accessed using the front-end tool, which was basically a GUI in Forms 4.5.
• Developed Stored Procedures, Functions, Triggers and Packages using PL/SQL for incorporating the validations in Oracle database.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Designed and developed user interfaces for customers using Developer 6i Forms
• Developed Unix Shell Scripts and PLSQL procedures to extract and load data
• Generated first-cut of the forms/reports from Designer 2000 and then refined them using Oracle Forms 4.5 and Oracle Reports 3.0.

Environment: Oracle8.0/8i, Developer 2000 (Forms 4.5, Reports 3.0), Designer 2000, Visual Basic 6.0, SQL * Loader, UNIX, Shell Scripting, Oracle Reports, ETL.

Confidential

Oracle Developer

Responsibilities:

• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives.
• Used conceptual models and extended conceptual models with business rules to develop logical data models.
• Designed Oracle Logical Objects including Triggers, Stored Procedures, and Sequences that helped in automating various operations in the database.
• Developed complex reports like Matrix Reports, Tabular Reports for the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters.
• Developed Front-end forms depending upon the logic such as Master-detail form and complex forms for the application.
• Developed SQL*Loader scripts to load flat files into source staging database and plan the loads to run concurrently without any manual intervention.
• Fine Tuned SQL for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Performed manual testing on the application and Involved in defects fixing team.
• Created new and modified database procedures, functions, triggers and other database objects by using TOAD tool.

Environment: Oracle 8i, Developer 2000, TOAD, SQL, PL/SQL, SQL Plus, Windows 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Wrote stored procedure and triggers.
• Developed Stored Procedures for various validations while inserting data into the tables and developed PL/SQL Packages for incorporating the business rules.
• Developed many PL/SQL Triggers to monitor the database activities and to implement some database constraints.
• Reviewing user application requirements.
• Developed GUI forms (screens) in Visual Basic according to the user requirements.
• Involved in Database Testing (Oracle), loaded the test data into Oracle database by writing SQL queries and PL/SQL procedures.
• Set up scenarios and related datasets for weekly batch tests and reported/fixed issues encountered.
• Involved in the code walk through, and created Process workflow using Visio. Analyzed the business requirements and wrote Test Plans.
• Used Toad to rerun queries for database validation of updates.
• Wrote automated test scripts for GUI, Functional, Data Driven, User acceptance and Regression tests using Win Runner.
• Developed Test Scenarios, Test Process Flows and DTC’s (Detail Test Conditions).
• Involved in System Interface Testing, Regression Testing, Exception Testing, and Product Testing on corporate releases.

Environment: Oracle 8i, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, Win Runner, Quick Test Professional, SQL*Plus, Reports, SQL *Loader, Win NT, Visual Basic 6.0, WINDOWS and LINUX.