SUMMARY

• 8+years of solid experience in the design, development and implementation of business applications and also haveexposureto Mongo DB which is Scalable, high Performance and open source.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance
• Strong analytical and conceptual skills in database design and development in client/server applications
• Expertise in working with Oracle Advanced PL/SQL, Oracle 11g/10g/9i, TOAD, SQL Navigator, SQL *Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications
• Expert in the development of stored Procedures, Functions, Packages, Triggers and Indexesto implement business logic
• Strong PL/SQL programming skills and expertise with performance tuning and bulk binding techniques
• Experience in using Composite Data Types in Oracle
• Knowledge in schema structure design and involved in estimation and optimization of data storage
• Experience in migration and conversion from Flat Files/MS Access/SQL - Server to Oracle using Oracle SQL*Loader
• Proficient in designing, developing and implementing solutions using various schemas like star schema, snowflake schema
• Involved in review and Gap Analysis of Functional Requirement Documents. Creation of Technical Documents and related Test Case Document
• Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan
• Experienced in providing production support and investigating and resolving system defects and fixing bugs
• Team player with excellent interpersonal skills and ability to work individually as well as part of a team
• Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications
• Great learning skills to adapt the rapid changing technologies and implementing the same at work
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure

PROFESSIONAL EXPERIENCE

Confidential, SFO, CA

Oracle PL/SQL Developer

Responsibilities:

• Generated weekly, monthly, yearly reports for insurance plans based on the customer’s choice
• Created custom tables required for report generation using Oracle reports 6i
• Expertise in designing and creation of database objects like tables, views, PLSQL stored procedures, Functions, Packages
• Responsible for the modification/enhancements/maintenance in the existing PLSQL packages, procedures and functions to establish standardsand the deployment on production Support environment
• Developed and delivered IT Services Management (ITSM) solutions based on ITIL process with best practices that focused on the people, process, and technology perspectives of providing business solutions.
• Extensively used Sub-queries and Joins in stored procedures
• 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.
• Used SQL *Loader to migrate flat filesdata to Oracle Tables
• Worked with Putty and HP quality center for version control
• Developed modules of the application in ASP.NET, Silverlight and involved in writing C# classes.
• Creating custom site pages, lists, views and master pages and adding ASP, Silverlight controls.
• Accessing SQL Server 2008 from a Silverlight application using WCF.
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation. The code behind is implemented in C#.NET
• PL/SQL extensively utilized to implement the business functionalities
• Involved in enhancing pre-existing code by implementing & closing tickets raised by cross functional team requirements
• Worked with business group to create the functional requirements
• The database design responsibility included the conceptual data model design using ER diagrams, logical database design and physical implementation of the database using star schema
• Made necessary changes to existing Database Objects and added new whenever required
• Created complex database triggers using PLSQL
• Done unit testing and module testing
• Prepared the necessary documentation and design specifications of project

Environment: Windows XP, ASP.NET, Oracle 10g/11g, PL/SQL Procedures, Packages, Triggers, Oracle Forms and Reports 10g, Oracle Application server 10g,Oracle Enterprise Manager, Oracle Advanced PL/SQL Developer, SQL*Plus, Putty, ERWIN, Toad, HP Quality center version control

Confidential, EI Segundo, CA

Oracle PL/SQL Developer

Responsibilities:

• Created complex functions, stored procedures and packages by using PL/SQL
• Extensive testing done after migration to ensure the accuracy & timely processing of data
• Generated script for validating the data before it is inserted into the tables
• Extensively created sub-queries and joins in stored procedures and functions
• Used SQL*Loader to convert the data from CSV to Oracle tables
• Created Reports using XML Publisher
• Used tool AOTS (ticketing system) for the version control
• Created new users in APPS using system administration, created stored procedures and registered them
• Worked on trouble tickets to fix the issues reported by the end users
• Worked with users and business group to create the functional requirements
• Created Interface using forms to get the financial details into the application
• Used forall and bulk collect functionalities to improve the performance
• Worked on table partitioning and index creation to improve the performance
• Developed scripts for QA and Business Team to ensure the Quality of the applications
• Involved in extensive coding in Oracle Forms/Reports 6i/10g
• Involved in developing the Receiving Notification form which notifies the users on their orders
• Rectification of errors reported during System Test and User Acceptance Test
• Documentation of the work assigned
• Worked with Oracle development team to fulfill their design requirements

Environment: Windows NT, Oracle 10g/9i, Oracle Advanced PL/SQL (Stored Procedures, Packages, Triggers, REF Cursors), Oracle Forms and Reports 10g, Oracle Applications 11i,Oracle Enterprise Manager, PL/SQL Developer, AOTS (ticketing system), SQL*Plus, Toad

Confidential, NJ

Oracle Developer

Responsibilities:

• Design and develop PL/SQL Packages, Procedures and Functions, Cursors, Partition etc
• Analyze customer requirements and design technical requirements as needed and/or requested
• Responsible for the modification/enhancements/maintenance in the existing PLSQL packages, procedures and functions to establish standardsand the deployment on production environment
• Worked extensively in database development for new releases and implement changes to the Data Model
• Steep knowledge of Advanced level of business
• Ability to outline resolution of problems and manage within a team
• Ability to present complex issues and conduct technical interchange meetings.
• Excellent Business Objects reporting skills and superior communication, analytical and people skills
• Created procedure for data clean up
• Interacting with business users and participating in meetings to gather functional and non-functional requirements with business experts
• Responsible for designing and creating scripts for DB objects such as tables, indexes, views, sequences, object types etc
• Worked on Oracle forms and reports 10g to develop the application. Reports include the number of orders received, dispatches, etc
• Heavily optimized the code for high performance using bind variables, & bulk collects
• SQL tuning and optimization of queries using explain plan
• Developed PL/SQL code for various levels of front-end validations
• Developed modules of the application in ASP.NET, Silverlight and involved in writing C# classes.
• Creating custom site pages, lists, views and master pages and adding ASP, Silverlight controls.
• Accessing SQL Server 2008 from a Silverlight application using WCF.
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation. The code behind is implemented in C#.NET
• Responsible for Production support and release management process
• Documented business rules, functional and technical designs, test cases, and user guides
• Involved in Analysis and Design of Logical and Physical Database and related objects
• Developed a report using Reports 10g for listing the customers who visited the center
• Sub-queries and joins were extensively used in stored procedures
• Used PL/SQL and SQL *Loader to import /export data from various sources
• Worked with the support team to fix the issues from users

Environment: ASP.NET, Oracle Advanced PL/SQL 10g/11g, Packages, Procedures, Functions, Oracle Forms and Report 10g, SQL Tools, Toad, Shell Scripting, Windows XP Professional, ERWIN, Putty, SQL *Loader, Oracle Enterprise Manager

Confidential, Pittsburgh, PA

Oracle Developer

Responsibilities:

• Developing control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data
• Responsible for developing Oracle Advanced PL/SQL Functions, Procedures, Packages, Cursors and Triggers
• Worked on tickets to fix the issues reported by the end users
• Optimized the performance using PL/SQL table types and record types
• Involved in designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements
• Developed SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle
• Generating software upgrade scripts for cross functional teams
• Heavily involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every logical branch of the stored Procedure.
• Wrote SQL queries to developed test data for use during test execution
• Worked on complete SDLC(Software 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
• Generated various reports using Reports 6i like loan reports, savings report, fixed deposits etc
• Analyzed the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 9i/10g, SQL, WINDOWS XP, SQL,PL/SQL, SQL *Loader, Toad, Oracle Advanced PL/SQL Developer, Oracle d2k forms and reports

Confidential

Oracle Developer

Responsibilities:

• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL *Loader, SQL* Plus and PL/SQL.
• Created various Database triggers using PL/SQL.
• 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
• 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, Partitionsand Triggers.
• Designed and developed user interfaces for customers using Developer 6i Forms

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

Confidential

Oracle Developer

Responsibilities:

• Worked with the team to design, develop, test & implement system.
• Creation of database objects like tables, procedures using Oracle tools like PL/SQL, Toad and wrote Stored Procedures
• Designed data model by new objects using existing objects as per requirements given by the functional team
• 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
• Extracted data from flat files to Oracle tables
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance
• Converting all the Custom Reports to work on Oracle Applications
• Developed several new PL/ SQL packages for Database packages, Database procedures and triggers
• Creating list of values and defined the descriptive flex fields and key flex fields
• Developed Term-Wise Aging report and Monthly Roll-forward report
• Modified seeded reports as per new functionalities and business needs
• Developed field-level and form-level validation code and generated various reports using Developer 6i Reports and involved in preparing test cases & unit testing

Environment: Oracle 9i, SQL, PL/SQL, Developer/2000 (Forms 6i, Reports 6i, Graphics 6i), Designer, Discoverer, SQL*Plus Reports, SQL *Loader, Windows XP, Toad

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzing the requirement specifications
• Developed several Oracle Stored Procedures
• Generated reports for management to review for system functionality as against the old legacy reports
• Created forms for data input
• Wrote Form Triggers, and Program Units
• Involved in generation of monthly status of order reports

Environment: Windows XP, Oracle 8i, Developer 2000, and PL/SQL, SQL developer